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 the requisite relationships, designed partition tables and partition views.
• Experienced in modeling the 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 the data to SQL server from source database and validate the data status.
• Worked with SQL Server Agent to create the job to automate different processes.
• Created, updated and maintained ETL Technical Document for future by another team member.
• Maintained Change Control and Release Management process for all the 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 the 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 the production server.
• Used C# code to generate DDL to store the Excel data in the 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 the execution of control flow.
• Created Jobs to run SSIS package periodically for loading the data to SQL server from Flat File.
• Created the SSIS packages for loading the 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 the database and to halp with complex stored procedures.
• Used SSRS Reporting services to query database to generate Drilldown report for Business Intelligence.
• Gathered requirements and designed normalized and de-normalized tables, lookup tables and relationships.
• Created and maintained the Data dictionary for current databases.
• Maintained Change Control and Release Management process for all the 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 the data migration strategy for merging the data during batch processing and halped developed the rule of processing the data.
• Created, updated and maintained ETL Technical Documentation for future by other team members.
• Worked with SQL Server Agent to create the 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 the DML and DDL scripts in TFS for release management.
• Reviewed the queries written by Developers.
• Restored the data from production backs on local environments.
• Involved in Tier 3 production support.
• Involved in designing the ODS for hosting the 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 the 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 the package to send mail massages if task in the package workflow succeed or fail, or send massages in response to an event dat the 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