SUMMARY:

• Over 7+ Years of Experience on data warehousing in implementing and developing OLTP and warehouse applications using SQL Server 2008 R 2/ 2012/2014/2016.
• Expert in Microsoft suite of products like SQL server Integration services (SSIS), SQL server Analysis services (SSAS) and SQL server reporting services (SSRS).
• Experience in working with T - SQL Database objects like indexes, Triggers, User Defined Functions and writing complex Stored Procedures using Dynamic SQL.
• Proficient using various SSIS Control Flow Tasks like Execute SQL, Execute Package Tasks and Data Flow Items like Derived Column, Script Component, Lookup and experience working with various data sources like Flat files, Excel, SQL Server.
• Expertise in performance tuning and optimization of queries using SQL Server Profiler and Analyzing the execution plans of the queries.
• Expertise in Development of Drill Down, Parameterized, Tabular, Matrix Reports using SQL Server Reporting Services (SSRS).
• Strong Ability of utilizing SSIS, Bulk Copy Process (BCP) and Data Transformation Services (DTS) with MS SQL 2008/2005 for development, implementation, administration and support of ETL processes for Data Warehouses.
• Proficient in Data warehousing concepts like Normalization of data, OLTP and OLAP systems, Physical and Logical data model and wide experience with star and Snowflake schemas.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills.

TECHNICAL SKILLS:

Operating Systems: Windows 10/8/7 Windows server 2016/2012/2008 R2/2008, Linux

SQL server Tools: SQL server management studio, Data base engine, Import and export wizard

Relational DBMS, Client: server architecture, OLTP, OLAP, Azure Cloud Services

ETL Tools: DTS, SQL Server Integration Services (SSIS),T-SQL, ETL

C, T: SQL, .net, MDX, XML,C#, BIML, Power Shell IS

Reporting Tools: SSAS, SSRS, Tableau, Qlik view

Database Modeling: Erwin, TOAD, SQL Server Management Studio.

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

Sr. SSIS/SSRS Developer

Responsibilities:

• Worked with Stakeholders of the organization to gather requirements and develop user case stories and designed all technical documentation as well as data dictionaries for users.
• Developed T-SQL Stored Procedures and User defined functions using Dynamic SQL for report datasets and ETL.
• Worked on creating Tables, Views, Stored Procedures, User defined functions that are used by the pricing application to modify data in the transactional database based on user needs.
• Involved in designing, developing, and testing of the ETL (Extract, Transformation, and Load) strategy to populate the data from various source systems feeds using SQL Server Integration Services (SSIS).
• Involved in Data Migration from different data sources to SQL Server 2017 As per Project Need.
• Created SSIS Packages using Derived Column, Condition Split, Lookup, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports.
• Worked on Identifying Slow running Stored Procedures and tuning them using Performance tuning techniques and optimizing the queries by Identifying bottlenecks.
• Worked on large and complex T-SQL Stored Procedures using concepts like Common table expressions (CTE’s) and Temp tables and complex joins across multiple tables.
• Developed Tabular, Matrix, drill down and parameterized reports with SSRS for Pricing and Forecasting Daily, monthly and quarterly reporting needs.
• Worked on development of materialized view for pre-processing the aggregated data and used partition swapping techniques to load data to avoid the down time for large fact tables.
• Developed Tabular, Matrix, and drill down and parameterized reports with SSRS for Claims, Financer, and Data Management for Daily, monthly and quarterly reporting needs.
• Worked on creating indexes on existing and new tables to improve the query performance and triggers to maintain data integrity across the databases.
• Worked on various database administration activities like scheduling backups, granting permissions, working with SQL Server Agent Jobs.

Environment: s: Git. MS SQL Server, SSIS, SSRS, T-SQL, XML, Git, SQL Server Agent, MS excel, MS Visio, C# and VB.net,.

Confidential, Atlanta, GA

Sr. SQL/BI/Power BI Developer

Responsibilities:

• Worked with Product Owners to identify requirements for the dashboards and reports and develop design Specifications, Data Dictionaries and Source to Target Mapping documents.
• Developed a Data Model and E-R diagrams for the Analytics Data mart using Microsoft Visio and knowledge in implementation of Star, Snowflake and Hybrid Schemas.
• Developed a Tabular Model Cube from the Data warehouse using SQL Server Analysis Services (SSAS).
• Developed Complex ETL Packages using SQL Server Integration Services (SSIS) using Various Control Flow Tasks like Execute SQL Task, Execute Package Task, Data Profiling Task and Data flow Tasks like Script Component, Derived Column etc.
• Created Complex Stored Procedures in T-SQL and re-usable stored procedures using Dynamic SQL for Various Data pulls and Reporting needs.
• Developed the Data mart using partition Swapping, Temporal tables and other advanced T-SQL Concepts to add new functionalities to the Data mart and improve the query performance from the consumption layer.
• Developed Tabular, Matrix, drill down and parameterized reports with SSRS for Pricing and Forecasting Daily, monthly and quarterly reporting needs.
• Worked on Identifying Slow running Stored Procedures and tuning them using Performance tuning techniques and optimizing the queries by Identifying bottlenecks.
• Worked with Business Intelligence Manipulation Language (BIML) to rapidly and securely develop SSIS packages.
• Configured DACPAC Database solutions and Build/Deployment pipelines for SSIS, SSRS, and Database solutions.

Environment: s: MS SQL Server 2008 R2/2017, SSIS, SSAS, SSRS, T-SQL, C#.Net, SSMS,TFS, GIT, Source Tree.

Confidential, Roswell, GA

Sr. SQL/ SSIS/ Power BI Developer

Responsibilities:

• Worked with the Product Owners of multiple markets of the Organization to analyze the requirements and also develop design specifications and technical specification documents.
• Developed T-SQL Stored Procedures and User defined functions using Dynamic SQL using advanced concepts of SQL Server.
• Worked on Advance performance tuning, optimizing SQL queries and building indexes
• Developed Complex SSIS Packages using Control Flow and Data Flow Tasks to load data from Various transactional sources.
• Worked on Identifying T-SQL bottlenecks using execution plans, I/O, Disk Space and other issues. Developed complex SSIS packages using various Control flow tasks like Execute SQL Task, Execute Package Task, Script Task, Data Profiling Task and with Dataflow Tasks like Derived column, conditional split and custom transformations using script component.
• Developed ETL Control Architecture and building custom logging tables and implementing additional abilities like restarting the packages from the last point.
• Worked on Dimensional modeling and relational modeling to model the data marts and knowledge of implementing star, snowflake and Hybrid schemas.
• Implemented Advance Concepts like Materialized Views and Tables and pre -processing data based on the identity fields to improve the performance.
• Designed Complex SSRS Reports to support the needs of Regulatory Reporting for Monthly, quarterly and Annual Report submissions.
• Built various dashboards to monitor the data for regulatory, Enrollment and Corporate goals in Power BI using Charts, Tables, matrix, slicers and custom visualizations and developed the reports and dashboards from various data sources using data blending techniques.
• Wrote Advanced Calculations using DAX and Power query to meet the requirements of the dashboards in Power BI.
• Worked on Automated deployments using tools like Team city, Octopus and writing automated scheduling scripts for Tidal using JSON.

Environment: s: MS SQL Server 2012/2016, SSIS, SSAS, SSRS, Power BI, MDX, T-SQL, XML, BIML, DAX, Power Shell ISE,SSMS 2012/2016, Team City, Octopus Deploy, Git, Sub version.

Confidential, Atlanta, GA

Sr. SQL BI Developer

Responsibilities:

• Designed SSIS (SQL Server 2008/2012 Environment) package to load data to into SQL Server and Oracle.
• Coded detail Data scrubbing and cleaning process lookup, pivot / un-pivot transformation, Sort, Script transformation.
• Used SSIS Logging feature to log the status and error in logging database.
• Created SSIS Configuration to make the package deploy on diff server environment (DEV / UAT / Production)
• Automated SSIS Package through SQL Jobs
• Generated dynamic SQL Query with the help of SSIS Expressions and use it in data flow transformations.
• Optimized SSIS Packages to load large volume of data - (from 5million to 100 million.).
• Generate dynamic SQL queries and execute them on different server as per inputs
• Performed health check of server and managed space by truncating unwanted logs - mostly of staging databases, partitioned large tables.
• Created views, stored procedures, functions and Index in SQL.
• Worked on supporting Enterprise Databases CDR (Clinical Data Repository).
• Worked on Health Data Exchange Project with application team.
• Proactively evaluate system processes and recommend solution to enhance / optimize them.
• Develop and test scripts and associated test data requirements to test specific scenarios as identified in the requirements.
• Dedicated to completing assigned tasks and delivering high quality software under deadline.

Environment: s: SQL Server 2012/2008R2, SSIS, SSRS, SSAS, TFS, Visual Studio 2010/2008, SQL Server Agent, Erwin.

Confidential

SQL Developer

Responsibilities:

• Involved in creating Stored Procedures, views, tables, constrains based on the requirements.
• Designed and Created SQL Databases and schema objects including tables, indexes (Clustered Index, Non-Clustered Index), applied constraints, views and cursors based on client necessities.
• Created stored procedures for Data consistency.
• Worked on sub queries, SQL joins (Inner Join, Outer Join, and Cross Join) and followed and executed tuning for better running of queries.
• Created User Defined Functions, CTE and Stored Procedures.
• Created views to encourage simple UI usage, and triggers on them to encourage predictable data entry into the database.
• Experience in generating SSIS packages with implementation of package configurations, event handlers, and checkpoints.
• Worked on T-SQL statements, and implemented different codes and functions.
• Import/Export data within all versions of Microsoft SQL Server.
• Created the SSRS reports by involving different features like Drilldowns, Drill through, Actions, Dynamic grouping, Charts, Sub Reports, Linked Reports based on client requirement and rendered them to HTML, XML, PDF and Excel formats using SSRS.
• Responsible for creating new reports and multiple parameterized stored procedures which were utilized by the reports to get the information.
• Worked with various features of report manager like providing security for reports, implementing caching, Snapshots etc.
• Monitored and modified SQL Server jobs to enhance performance.
• Created and executed AD HOC reporting with the report builder for the end users.
• Created, deployed and managed complex SSRS Reports in a SQL environment per product owner specifications.
• Used ETL (SSIS) to develop jobs for transforming and loading data into data warehouse and extracting, and cleaning.
• Created ETL packages (.Dtsx) with SQL Server, Flat files, Excel source files and stacked the data into target tables by performing various types of transformations utilizing SSIS.
• Created SSIS packages using transformations like Lookup, aggregate, sort, Conditional Split, Derived Column etc.
• Created SSIS packages using Execute SQL Task, Data Flow Task, transfer database task etc. and Transformed data from one server to other servers using SQL Server Integration Services (SSIS).
• Developed, deployed, and monitored SSIS Packages.

Environment: s: Microsoft SQL 2012 Server, Microsoft SQL Management Studio, Microsoft SQL Server Integration Services, Microsoft SQL Server Reporting Services, T-SQL, SQL Server Agent, MS excel, MS Visio,C# and VB.net, Data Transformation Services (DTS).