SUMMARY

• Quality focused IT professional over 7 years of experience in SQL Server database system in OLTP environment and OLAP Data Warehousing systems.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Involved in XML Development and XML File Parsing in SSIS and SSRS.
• Developed EMR data transformations to process Provider Data transactions for data accuracy.
• Created stored procedures, triggers, Views, CTE's, T - SQL scripts, schemas, permissions and performance issues with client/ server database design.
• Involved in performance tuning and optimization on Business objects Universes by creating Aggregate tables.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with Incremental load.
• Used SSIS 2014 to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Database.
• Developed the SQL programs and Involved in optimizing stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Demonstrated architecture, design and delivery experience in the full lifecycle of data.
• Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard in SSIS.
• Hands-on experience in creation cubes, perspectives and deploying using SQL Server Analytical Services (SSAS).
• Created automated stored procedures for day end operations using SQL Server agent.
• Involved in Object Oriented Design (UML, activity diagrams, Use cases and Object Modeling).
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Experienced in developing Custom Report and different types of Chat Reports, Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using 2016/2012/2008 R2/2008 Reporting Services (SSRS), PowerBI.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2014.
• Excellent communication and interpersonal skills and have ability to handle multiple tasks; can take initiative to handle responsibilities independently as well as a proactive member of a team.

TECHNICAL SKILLS

Oprating systems: Windows Server 2014/2012/2008 R2

RDBMS: SQL Server 2014/2012/2008 R2/2008, MS Access

Database Tools: SQL Server Management Studio (SSMS),SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio, SQL Profiler, Database Engine Tuning Advisor, Profiler, DTS.

Reporting Tools: SQL Server Reporting Services (SSRS),Microsoft power BI

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

Web Technologies: XML, HTML

Languages: T-SQL, DB2, PL/SQL, VB.NET

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

MSBI Developer /SQL/SSIS Developer

Responsibilities:

• Reviewed and developed data models and database designs with development teams.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing various kinds of transformations using SSIS/DTS packages.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS)
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Created various Tabular and Matrix Reports using SSRS.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Developed several types of reports like Drill down, Drill through, sub reports and parameterized reports using SQL Server Reporting Services 2008 R2.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Development of reports and dashboards using tableau and BI tools based on organizational requirements.
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.
• Used Bulk Copy program (BCP) to import and export substantial amounts of data in and out of SQL Server databases.
• Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Scheduled and monitored all maintenance activities of SQL Server 2016 including database consistency checks and index defragmentation.
• Set up database backup and recovery strategies.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.
• Maintained all records of project status and followed changes as per control procedures.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server 2008R2 & 2012 Enterprise Edition, MDX, T-SQL, MS Access, MS Excel, & Windows 2008 server, Microsoft Visual Studio, SQL Server Management Studio OLAP, OLTP, .NET, ETL, SSIS, SSRS, C#, TFS,power BI,Jira

Confidential, Vienna, VA

MS SQL Developer / BI Developer

Responsibilities:

• Worked on multidimensional data modeling.
• Participated in Databases Architecture and data modeling design.
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Make sure that standards and best practices in database development were followed and maintained.
• Defined and designed the data sourcing and data flows, data quality analysis.
• Identified the data source and defined them to build the data source views.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used SQL Server Agent to automate the SSIS 2010 package execution.
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS2012/2014 and then created reports using this data using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2015.
• Tested and managed the SSIS 2015 packages and was responsible for its security.
• Inspected the reports and fixed bugs in stored procedures and tuned Reporting Services to the T-SQL.
• Experience in developing BI applications using Power BI as reporting tool.
• Experience in Power BI Report and Dashboard development.
• Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.
• Database Administration, Production and Development Support.
• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.
• Worked on Agile Methodology and Microsoft Team Foundation Server (TFS)

Environment: MS SQL Server 2008R2 & 2012 Enterprise Edition, MDX, T-SQL, MS Access, MS Excel, & Windows 2008 server, Microsoft Visual Studio, SQL Server Management Studio OLAP, OLTP, .NET, ETL, SSIS, SSRS, SSAS, C#, ERWIN, TFS,power BI,Jira

Confidential

MS SQL Server Developer

Responsibilities:

• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Migrated few DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Migrated data from Heterogeneous Data Sources and legacy system (Cognos, DB2, Access, Excel) to SQLServer databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
• Developed query for generating drill down, drill through and parameterized reports in SSRS 2010.
• Supported in generating periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational drill-through and drill-down reports using SSRS.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Optimized SSIS packages to fine tune data loads and reduce data load time. Came up with best strategies in the data load process.
• Involved in dimensional modeling by identifying fact and dimension tables based on user and reporting requirements.
• Implemented partitioning, back up strategy and security policies.

Environment: MS SQL Server 2005/2008 R2/ SQL Server 2012, SQL server Reporting Services 2008, SQL Integration Services 2008, SQL server Analysis Services 2008,Tableau Desktop (Desktop, Server), Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, ERWIN.