SUMMARY:

• Complete understanding of Software Development Lifecycle and core area of experience in validating end - to-end business scenarios of B2B (Business to Business) applications, Enterprise Applications developed expertise in SSIS/SSRS/SSAS.
• Good exposure to entire Software Life cycle Phases (Feasibility, System studies, Design, Coding, Testing, Implementation and Maintenance).
• Solid skills in designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.
• Experience in creating Index, Views, complex Stored Procedures, appropriate user defined functions (UDF) and effective Triggers to facilitate efficient data manipulation and data consistency on Microsoft SQL Server database platform.
• Having over 6 years of strong ETL and data integration experience in developing ETL mappings and scripts using Microsoft SSIS.
• Extensive experience in MS SQL Server 2008/2008R2/2012/2014 and solid hands on experience in installing, configuring, managing, monitoring and troubleshooting SQL Server in Dev, Testing and Production environments.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2012/2014.
• Proficient with SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)/SSDT, SQL Profiler, Performance Monitor.
• Experienced with the creation of SSIS packages in Data Extraction, Transforming, and Loading (ETL) from various sources using SQL Server Integration Services, Bulk Insert, and Bulk Copy Program (BCP).
• Extensive experience with writing T-SQL scripts, stored procedures, triggers and functions, creating SQL Server Jobs/alerts, and scheduled tasks to automate tasks.
• Strong experience with server/database/scripts Performance tuning and optimization.
• Strong experience with SQL Server performance monitor and performance tuning, maintenance and SQL Server version upgrade.

TECHNICAL SKILLS:

Database Tools: Windows server 2008/2008 R2/2012 Enterprise edition, MS SQL Server 2008/2008 R 2/2012/2014/2016 Enterprise edition, SSIS, Data Warehouse (OLAP, ROLAP, MOLAP), ETL, SQL Profiler, SQL Query Analyzer, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, Visual Studio C#, Report builder.

Database modeling: Oracle Data modeler, VISIO 2003.

Project Management: Trello, Agile, GITHUB. Jira

Business Intelligence and Reporting: Power BI, SSRS, Excel, SQL Server Data Tools

Microsoft Office tools: MSWord, Excel, Power Point, SPSS

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

MS SQL Server/ETL/BI Developer

Responsibilities:

• Designed and Developed SSIS packages for performing ETL process using SQL Server Integration Services.
• Design, build, unit test & deploy ETL routines on SSIS
• Worked using integration services for transferring and reviewing data from heterogeneous sources like (Flat file, Excel, CSV, Oracle, MS Access).
• Worked on Data Mapping extensively.
• Performance analysis and optimization on SSIS jobs
• Responsible for Data Profiling to determine data integrity for transformation of Data from Source to Target.
• Strong working experience in Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Expertise in Data Analysis, Understanding in Dimensional Data Modeling, Data Extraction, Transformation & Loading (ETL)
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data and finally load it into the Multi-dimensional data warehouse.
• Developed complex stored procedures for daily, weekly, monthly and yearly finical summary reports
• Monitored time taking queries with Performance Tuning to reduce the execution time and created packages in SSIS with error handling and also tested the packages for Incremental Data Load & duplications.
• Experience in scheduling SSIS batch jobs using SQL Server Agent
• Developed Reports and Dashboard using Power BI Desktop

Environment: MS SQL Server 2014/2012, Visual Studio C#, Windows Server 2008R2 and 2012T-SQL, Redgate SQL compare and Multi Script, Visual Studio 2012,Power BI,SSDT, GitHub, Jira

Confidential , PA

SQL/SSIS/SSRS Developer

Responsibilities:

• Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
• Export and import data from Flat file, CSV file, Excel to/from SQL Server database using SSIS.
• Developed Complex SSIS Packages to load data into Staging, ODS, and Data Warehouse systems.
• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints, Stored Procedures and Queries to be used in the project.
• Optimized the performance of queries with modification in T-SQL queries, creating sub queries, establishing joins and creating indexes wherever necessary.
• Developed, monitored and deployed SSIS packages for ETL flow to validate, extract, transform and load data into database.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Design and Developed multiple Enterprise reports using SSRS from both OLTP and OLAP databases
• Documented and delivered Functional Specification Document to the project team by using SQL Server.
• Tested the reports and fixed bugs in the stored procedures. Involved in scheduling the reports and setting security for reports.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track report history using SSRS.

Environment: MS SQL Server 2012/2008R2/2005, Visual Studio C#, Windows Server 2003, 2008R2 and 2012, T-SQL, Visual Studio 2008/2010/2012

Confidential

SQL Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup, etc for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Created SQL server configurations for SSIS packages.
• Responsible for creating reports based on the requirements using SSRS 2012.
• Defined the report layout and identified Datasets for report generation.
• Created different type of reports including Cross-tab, Drill through, Drill-down, Sub reports, and parameterized reports.
• Created numbers of complex formula in sub report.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects. Tuning long-running SQL Queries, Procedures and Functions using SQL Profiler, SQL analyzer, Index tuning wizard.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Created Packages to group logically related column types and to transfer data.
• Documented and delivered Functional Specification Document to the project team by using SQL Server.

Environment: SQL Server 2008/2008 R2,SSRS, Windows 2003 R2/2008 Server, Visual Studio C#, T-SQL, Excel, Visio, VPNs