SUMMARY:

• Extensive experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL.
• Experience with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS).
• Expert in requirement gathering, data validations, analysis, and full software development process (SDLC).
• Involved in defining the source to target data mappings, business rules and data definitions.
• Proficient in creating dynamic SSIS packages by implementing Slowly Changing Dimension (SCD) type 2 in building warehouse solutions.
• Demonstrated experience with SQL Server Integration Service to accomplish regular, non-disruptive data refreshes implementing data validation, business rules, and aggregations; design error handling and deployment plans.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Experience in using CTE, temp tables, table variables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.
• Experience in end-user reporting definition, development and platform support using SQL Server Reporting Services (SSRS) and Performance Point.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Experience in Designing Report Using SQL Server Reporting Service (SSRS), Crystal Report, and Tableau including Linked Report, Parameterized reports, Drill down, Drill through, and visual graph reports
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS Packages.
• Excellent analytical, problem solving and communication skills with ability to interact with individuals at all levels.
• Self-motivated team-player who performs effectively under pressure and thrives on challenge.

TECHNICAL SKILLS:

Operating Systems: Microsoft Windows Vista/Windows 7, Linux, UNIX

Databases: MS SQL server, MS Access, Oracle 11g/10g

Languages: T-SQL, PL/SQL, ASP.NET, C#, .NET Framework, VBScript, XML, HTML

Tools: SSMS, SQL Server 2012 Data Tools (SSIS&SSAS&SSRS),Red Gate, SAP business objects BI Platform, JAZZ Rational Team Concert, Tableau, Crystal Report, Visio, Erwin, MS Project, ER studio, TFS, XML Notepad, live Office .

Performance Tuning Tools: Profiler, Query Execution Plan, Index and Database Tuning Advisor, Windows Event

PROFESSIONAL EXPERIENCE:

Confidential, DC

MS SQL BI/SSIS /ETL Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (Flat files, Excel, Oracle, and SQL Server).
• Teamed with Business Analysts and Users to translate business requirements into functional and technical specifications, create, implement and test appropriate solutions.
• Analyze and perform data mapping which involves identifying source data field, target entities and their lookup table ID’s, and translation rules. writing and debugging complex SQL Queries, dynamic Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also creating clustered and non clustered indexes.
• Create SSIS packages to pull source data into staging environment to further Clean, validate and standardize it.
• Developed SSIS packages to Implement SCD type 2 to maintain historical data in data warehouse.
• Developed packages to transfer data between OLTP and OLAP databases.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Perform and/or automate varying levels of data quality and data stewardship tasks.
• Implementing Event Handlers and Error Handling in SSIS packages.
• Prepare deployment note and XML Config Files to promote development work to test and production environment.
• Conduct Index and Performance Analysis to ensure products provide optimal performance.
• Created trace in SQL Profiler and used Database engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Create and schedule SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Provide documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, etc.) for all projects
• Analyze and resolve report errors.
• Involved in writing functional specification document that has all the details of the work done to migrate the data.

Environment: SQL Server 2012/2014 Enterprise Edition, Rational Team concert, MS SQL Profiler, SQL Server Database Engine Tuning Wizard, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio, MS Excel,.Net framework.

MS SQL ETL/SSIS/SSRS Developer

Responsibilities:

• Involve in complete SDLC requirement like analysis, design, development and testing the user stories.
• Involved in business analysis and technical design sessions and transferred operational requirements to functional requirements.
• Created tables and database from active participation in and gathering requirements from workgroup meetings and making changes to existing logic as per business requirements.
• Created objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and QA environment for SQL Server.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Wrote the ETL scripts to load the data into database from various source files.
• Developed SSIS packages not only for Initial Data Loads but also for incremental/delta load.
• Created SSIS packages to clean the incoming data including address and to find out if the address is valid or not.
• Design and develop ETL packages with different data sources (SQL Server, Flat Files, Excel source files, oracle DB etc) and load the data into target tables by performing different kinds SSIS transformations such as such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task.
• Implement Event Handlers and Error Handling in SSIS packages.
• Created a Log tables to capture the SSIS events and used it to Perform Debugging of packages.
• Created new dimension tables to satisfy new requirements. analyzed and executed the internal test cases for various testing phase
• With strong analytical ability, identified the potential risks during project developing cycle and raised the issues to the project team for further discussion and solutions.
• Involved in the continuous enhancements and fixing of production problems.
• Performance tuning of SQL queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
• Worked with agile project methodology to provide estimations for each Sprint, and present status and highlight if any road blocks in Scrum meetings.
• Developed AdHoc SSRS reports for the users for analysis purpose.
• Provide documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, etc.) for all projects

Environment: SQL Server 2014/2012 Enterprise Edition, SQL Server Data Tools, Server Business Intelligence Development Studio (SSIS, SSRS),TSQL,C#, .Net framework, XML, MS Visual Source Safe and Windows Server, MS Excel.