SUMMARY

• 5 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008/2012 in Development, Test and Production Environments.
• Experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in developing, monitoring, extracting and transforming data using SSIS, Import Export Wizard, and Bulk Insert.
• Defined precedence constraints and implemented various control flow tasks such as data flow task, execute SQL task, Execute Package Task and Send Mail Task.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill Down and subreports.
• Wrote Stored Procedures, Triggers and Indexes for better performance and flexibility.
• Experience in using T - SQL in SQL Server 2008, 2012 and 2014 platforms.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts and schedule SSIS Packages using SQL Server Agent.
• Experience in SQL Server SSIS (Integration Service) package design, constructing, and deployment.
• Good understanding in building Cubes and creating hierarchies with SSAS.
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Worked on multiple transformations provided by SSIS such as Derived Column, Data Conversion and Conditional Split.
• Hands on development experience in ASP.Net, C#, VB, ADO.NET and Tableau Desktop.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player. Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS

Databases: Microsoft SQL Server-2008R2/2012/2014, SSIS, SSAS, SSRS, SSMS.

Languages: T-SQL, C#.Net, VB .Net, SAP ABAP ECC 6

Web Technologies: ASP.NET, HTML5, CSS/3

Tools: /Technologies: Visual Studio 2005/2008/2010/2013 , Ado.Net, Tableau Desktop 10.x.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Interacted with business users for requirement analysis.
• Gathered information about database tables.
• Extract Transform Load (ETL) development Using SQL Server 2014 and SQL Server data tools 2013.
• Created SSIS packages to pull data from different sources, like SQL server, flat files and loaded in to the Staging and destination databases.
• Creating SSIS package with error handling.
• Creating configuration files to deploy SSIS package across multiple environments.
• Maintaining the SSIS package by creating jobs, Alerts and scheduling the jobs with SQL Server Agent.
• Created Inner join and outer join queries for data validation purpose.
• Wrote Stored Procedures for better performance and flexibility.
• Data migration from text files, excel files to SQL server.
• Crated SSIS packages to Move the Data from Dev, Test to Production servers.
• Created indexes on tables based on execution plan analysis.
• Used different transformations lookup, condition split, row count Transformation, Derived Column, Data Conversion.
• Used Email Notification package success or failure.
• Used Execute package task from parent package to calling child package.
• Defined precedence constraints and implemented various control flow tasks such as data flow task, execute SQL task, Execute Package Task and Send Mail Task.
• Coordinate with business users and team in gathering business requirements and translating them to technical specifications.
• Involved in creating the constraints, rules and defaults to maintain the data and referential integrity.
• Created ER diagrams using Visio.
• Involved in the performance tuning and optimization of T-SQL queries.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Extract Transform Load (ETL) development Using SQL server and SQL Server data tools.
• Created Indexes for faster data retrieval from the database.
• Wrote Stored Procedures and Functions for better performance and flexibility.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Involved in analyzing the source data and creating sample reports to help with the requirements and design.
• Deploying the SSRS reports to Report Server in Development, Test and Production environments.
• Developing an automated report subscription process to deliver the reports to email on a schedule.
• Creating Parameterized, Drill-down, Drill-through and Cascaded reports according to the business requirements.
• Involved in daily batch loads into Staging, troubleshooting process, issues and errors using SQL Server Integration Services.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages
• Gathered information about the conditions required for the purge process respective to each application.
• Key role played by writing the windows service.
• Involved in the development of the service.(C#)
• Created Stored Procedures.
• Gathered requirement specifications about the folders and database tables.
• Key role played by writing the windows service.
• Involved in the development of the service.(C#)
• Involved in the service to write structured data from XML into Database.
• Created Stored Procedures to manipulate the database and to apply the business logic according to the user’s specifications.
• Established connections to the web services.
• Created instances of the web services as an object, and then accessed the methods from windows service.
• Involved in supporting and fixing the bugs in QA and Production in a timely manner.