Description
PROFESSIONAL SUMMARY: * Around 11 years of Professional experience in IT industry as a SQL Server /BI developer /Data Modeler /Report Analyst * Microsoft certified technology specialist (MCTS) and certified information technology professional (MCITP) in SQL server 2005 * Microsoft certified technology specialist MCTS for business intelligence * Information gathering, analyzing the information gathered, documenting the functional or business requirements * Good SQL Server 2000/2005/2008/2012/2014 Administration skills including user authorizations, Database creation, backup, restore, replication, scheduling and clustering * Worked on Front End Application Like Salesforce, MS Dynamics and custom-built apps with .net, Delphi * Exposed to Cloudera technologies to AWS with open Source Hadoop frame version (hartonworks) * Experienced in pulling data from Upstream Sources into staging and eventually destinations using SSIS * Converted reports from crystal and MS Access to SSRS * Used C# for script task within SSIS, both to call Rest API and retrieve data through Flat Files, Outlook * Expertise in Manual Testing, Mainframe Testing, Automation Testing and Database Testing * Excellent understanding of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Test Methodologies from project definition to post deployment * Good experience with writing and utilizing SQL queries for data verification in Oracle and other RDBMS * Upgrading data to recent versions from earlier versions using MS Access, SQL server * Experienced in using Data Modeling tools like Visual Studio, ERWIN, MS-Visio * Extensively used crystal reports, SSRS to generate reports based on the client needs * Experienced in building up dashboards using MOSS 2007 and knowledge on performance point * Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS/SSIS Packages. * Experienced in converting crystal reports to SSRS reports * Understand the Map-Reduce algorithms and make use of horizontal Computing in Cloud Storage * Experience in Data Conversion and Data Migration from earlier versions to current SQL server using SSIS and DTS services across different databases like Oracle, MS access and flat files. * Extensive exposure in SSIS, SSRS and SSAS and charting tools like graphical charting * Good knowledge of share point 2007 in managing documents creating workspaces. Exposure towards moss 2007 and performance point. * Knowledge on MES, TFS, MDX, Replication understanding C#, .net (validated applications using asp.net) concepts * Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
Accomplishments
Highlights:
Keywords
