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 noledge 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.
• Gatheird 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 teh Staging and destination databases.
• Creating SSIS package with error handling.
• Creating configuration files to deploy SSIS package across multiple environments.
• Maintaining teh SSIS package by creating jobs, Alerts and scheduling teh 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 teh 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 teh constraints, rules and defaults to maintain teh data and referential integrity.
• Created ER diagrams using Visio.
• Involved in teh 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 teh 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 teh source data and creating sample reports to help with teh requirements and design.
• Deploying teh SSRS reports to Report Server in Development, Test and Production environments.
• Developing an automated report subscription process to deliver teh reports to email on a schedule.
• Creating Parameterized, Drill-down, Drill-through and Cascaded reports according to teh 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
• Gatheird information about teh conditions required for teh purge process respective to each application.
• Key role played by writing teh windows service.
• Involved in teh development of teh service.(C#)
• Created Stored Procedures.
• Gatheird requirement specifications about teh folders and database tables.
• Key role played by writing teh windows service.
• Involved in teh development of teh service.(C#)
• Involved in teh service to write structured data from XML into Database.
• Created Stored Procedures to manipulate teh database and to apply teh business logic according to teh user’s specifications.
• Established connections to teh web services.
• Created instances of teh web services as an object, and tan accessed teh methods from windows service.
• Involved in supporting and fixing teh bugs in QA and Production in a timely manner.