SUMMARY

• 6+ years of experience in Database Maintenance, Design, Analysis and Development of data driven solutions using SQL server, Oracle, My SQL and DB2.
• Expert in Designing logical and physical data model, Data mapping, Data profiling on SQL server 2014/2012/2008/2005.
• Experience working on Normalized Databases and Designed Database/Tables and teh requisite relationships, designed partition tables and partition views.
• Experienced in modeling teh databases using Erwin.
• Expert in Designing, creating and maintaining database objects such as Stored Procedures, Functions, Views, Triggers, Joins and Indexes using T - SQL.
• Excellent in Query optimization using different tools SQL profiler, Database Engine Tuning Advisor, DMV and Red Gate Profiler.
• Expert in developing Report solutions using SSRS and Tableau by creating drilldown, drill-through, sub-reports, matrix, cascading parameterized reports, ad-hoc and pivot reports using OLAP and OLTP databases.
• Strong experience in designing on-line transactional processing (OLTP) and on-line analytic processing (OLAP) database solutions.
• Expert in creating ETL transformation and SSIS control flow using BIDS designer and provided proper logging configuration, package level error handling and data level errors.
• Experience in migrating heterogeneous database sources like DB2, Oracle, My SQL, Excel, CSV files, and Flat files into SQL Server destination.
• Expert in creating and maintaining packages using different data flow, containers and control flow tasks such as for loop, for each loop, sequence container, conditional split, derived column, look up, merge, and sort transformations using SSIS.
• Involved in implementing a well-planned backup and restore strategy for databases against data loss due to damage caused by a variety of failures.
• Experience in designing data warehouse (star and snow flake schema), fact table, cubes, dimensions.
• Involved in optimizing T-SQL queries and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Knowledge in creating databases and using temporal tables and In-Memory OLTP in SQL Server 2016.

TECHNICAL SKILLS

Languages: T-SQL, Pl-SQL, SQL, C#, Python

Databases: SQL Server 2016/2014/2012/2008/2005, Oracle 10g/9i, My SQL & DB2

Database Tools: SSMS, Business Intelligence Development Studio, Visual Studio 2015, Profiler, Tuning Advisor, SQL Agent

Data Modelling: Erwin, My SQL Workbench, Oracle Data Modeler & MS Visio

ETL Tools: MS SQL Integration Services (SSIS), Informatica, MDS & DQS

Version Controls: GIT, Team Foundation Server & SVN

Reporting & Bug Tracking Tools: SQL Server Reporting Services, Crystal Reports, JIRA, Tableau

PROFESSIONAL EXPERIENCE

Confidential - New York, NY

BI Developer

Responsibilities:

• Designed conceptual and logical models for databases and data warehouse.
• Updated data models to meet new and changing business requirements.
• Mapped source system data to data warehouse models.
• Developed, tested, and maintained ETL process for all sources and destinations in SQL Server SSIS.
• Defined and captured metadata and rules associated with ETL processes.
• Maintained recommended specifications for client access, application servers, database servers and networks.
• Worked collaboratively with Systems Analysts and Subject Matter Experts to identify and understand source data systems.
• Analyzed and designed data preservation strategy of ETL packages.
• Created different steps in Jobs to run SSIS package daily for loading teh data to SQL server from source database and validate teh data status.
• Worked with SQL Server Agent to create teh job to automate different processes.
• Created, updated and maintained ETL Technical Document for future reference by another team member.
• Maintained Change Control and Release Management process for all teh scripts (DML & DDL).
• Involved in designing tables in ODS for preventing data loss from sources.
• Performed data cleansing using various transformations such as fuzzy lookup components and cleared duplicate data using DQS data flow components in SSIS.
• Used Check point, Break point and Logging in SSIS to debug and optimize package while developing them.
• Monitored and kept track of error logs from logging providers in SSIS.
• Used Event Handlers and Script task to send mail in teh background upon failure of SSIS package.
• Evaluated database performance and maintenance duties such as Backup, Restoration performed by scheduling jobs using SQL Server Job Agent.
• Worked with OLTP, OLAP, ODS, Data Warehouse application, star schema and snowflakes schema dimensions.
• Generated business report solutions using SSRS by creating drilldown, drill-through, sub-reports, matrix, cascading parameterized reports, ad-hoc and pivot reports using OLAP, ODS, and OLTP databases
• Designed and developed complex T-SQL queries, User Defined Functions, Stored Procedures and Triggers followed testing of those database objects before deployment to teh production server.
• Used C# code to generate DDL to store teh Excel data in teh database with a standardized format.

Environment: Microsoft SQL 2014, DQS, MDS, MY SQL, JIRA, AGILE SCRUM, SharePoint, Oracle 11g, DB2, XML, Flat Files, MDS, Red Gate Profiler & VS.NET 2015

Confidential - Dallas, TX

ETL Developer /Production Support DBA

Responsibilities:

• Created ETL packages for integrating data from sources like Excel and Flat File and applied various data transformations like conditional split, derived column, sort, merge join, union all, and row count.
• Used SSIS packages to merge data from existing database, and exported them to Flat File.
• Developed complex and multistage SSIS packages using various tasks such as Execute SQL task, Script Tasks, File System Task, and Data Flow Task.
• Used complex expressions to manage package configurations and Precedence Constraints to manage teh execution of control flow.
• Created Jobs to run SSIS package periodically for loading teh data to SQL server from Flat File.
• Created teh SSIS packages for loading teh data to SQL server periodically from Oracle database.
• Used Check point, Break point and Logging in SSIS to debug and optimize package while developing them.
• Designed and developed complex T-SQL queries, User Defined Functions; used nested Stored Procedures to create Rule Engine which applies complex business rules and will be called by packages, web service, stored procedure and UI.
• Created views for easier maintenance of teh database and to help with complex stored procedures.
• Used SSRS Reporting services to query database to generate Drilldown report for Business Intelligence.
• Gatheird requirements and designed normalized and de-normalized tables, lookup tables and relationships.
• Created and maintained teh Data dictionary for current databases.
• Maintained Change Control and Release Management process for all teh scripts (DML & DDL).
• Maintained Data Consistency and Data Integrity by applying various constraints like Primary Key, Foreign Key, Unique, Check, and Default.
• Identified, tested, and resolved performance issues of poorly running queries and performance of database itself by using Index Tuning Wizard, SQL Profiler, and Query Analyzer.
• Created teh data migration strategy for merging teh data during batch processing and helped developed teh rule of processing teh data.
• Created, updated and maintained ETL Technical Documentation for future reference by other team members.
• Worked with SQL Server Agent to create teh job to automate different process.

Environment: Microsoft SQL 2012, MS Word, SSIS, SSRS, T-SQL, TFS, DB 2, C#, Visual Studio 2013

Confidential

Database Developer

Responsibilities:

• Created T-SQL queries, stored procedures, user defined function and views, for faster retrieval of data by using T-SQL queries and to display specific information.
• Scripted Transact SQL (T-SQL) queries and used SQL Server Constraint (Primary Key Foreign Key, Default, Checks and Unique).
• Maintained teh DML and DDL scripts in TFS for release management.
• Reviewed teh queries written by Developers.
• Restored teh data from production backs on local environments.
• Involved in Tier 3 production support.
• Involved in designing teh ODS for hosting teh data from various application sources.
• Designed ETL packages for integrating data from heterogeneous sources like Excel, CSV, Flat file and Text Format data and applied various data transformations like conditional split, lookup, derived column and sort.
• Performed data cleansing using various transformation such as fuzzy lookup components in SSIS and cleared duplicate data using data flow components.
• Used Check point, Break point and Logging in SSIS to debug and optimize package while developing them.
• Monitored and kept track of error logs from logging providers in SSIS.
• Used Event Handlers and Script task to send mail in teh background upon failure of SSIS package.
• Evaluated database performance and maintenance duties such as Backup, Restoration are performed by scheduling jobs using SQL Server Job Agent.
• Worked with OLTP, OLAP, Data Warehouse application, star schema and snowflakes schema dimensions.

Environment: SQL Server 2008 R2, SSIS, SSRS, T-SQL, TFS, MS Excel, MS Visio, Erwin & Mictosoft.NET

Confidential

Junior SQL Developer

Responsibilities:

• Used SQL profiler to trace slow running queries and server activity by using SQL server 2008.
• Configured teh package to send mail massages if task in teh package workflow succeed or fail, or send massages in response to an event dat teh package raises at run time.
• Designed and developed various reports such as cascading parametrized reports, sub-reports and charts, parameterized reports as per client requirements.
• Deployed report to a report server using reporting services configuration manager and created individual subscription for patient appointment reminder by enabling physical secluded event and report deliver.

Environment: SQL Server 2008 R2, SSIS, SSRS, T-SQL, Erwin & TFS