SUMMARY

• Almost 10 years of strong experience as a MS SQL Server Developer / BI Developer include experience in design, development, implementation and administration of database systems using MS SQL Server 2017/2016/2014/2012/2008/2005/2000 for both OLTP & Data Warehousing Systems applications (SSRS, SSIS, SSAS).
• Develop T - SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues.
• Design ETL architecture for overall data transfer with the help of SSIS from the OLTP to OLAP.
• Migrate data from Oracle, Flat file, Excel to Microsoft SQL Server by using SSIS and DTS Utility
• Expert in SSIS script transformations using scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling, and reporting tools.
• Extensive knowledge in design of logical and physical data modeling using Erwin tool and consistency check.
• Strong knowledge in OLAP, Data warehousing, Operations Data Store concepts and ETL technologies.
• Use SSRS and Microsoft Access for the custom and ad-hoc reporting purpose. Knowledge and basic practical experience in Tableau and MicroStrategy.
• Excellent knowledge in tuning SQL queries, T-SQL and PL/SQL queries & improving the performance of the Database
• Deploy SSIS package on Azure Cloud and running those with Autosys. Knowledgeable for other Azure Cloud services like Azure Data Factory and Pipeline and have knowledge in AWS glue services for ETL development.
• Expert in developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Python script for analysis the data and validation for business users.
• UNIX commands and PowerShell.
• Strong team player with excellent problem-solving skills and ability to take new roles, self-starter with excellent communication skills.
• Analyze performance of the system and ensure the performance goal and availability of the requirements.

TECHNICAL SKILLS

• MS SQL Server 2000/2005/2008/2012/2014 /2016/2017 , SSRS 2000/2005/2008/2012/2014 , MS SQL SSAS 2014/2012
• SSIS 2000/2005/2008/2012/2014 /2016, MS Access, Erwin, Oracle, T-SQL, PL/SQL, HTML, Visual SourceSafe
• Team Foundation Server, Embarcadero, Microsoft Office, Windows NT/ 2000 Server/ XP,HP Quality Center
• Visual Studio 2010/2013/2015/2017 , Tableau 10.5, PowerShell

PROFESSIONAL EXPERIENCE

Database Developer/ETL Developer

Confidential

Responsibilities:

• ETL Production support for failing ETL and SQL Server agent Jobs.
• Work with ‘MyInfo’ HR application team for backend code where user requesting fix issue or add some enhancement
• Work on using SSIS (SQL Server Integration Services) for data extraction, transformation and loading (ETL) across different databases like Oracle, Teradata and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Create Stored Procedure and Table schema based on requirement of application.
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Work on incident tickets, Jira tickets, BUS tickets to fix issue from user side and directly work with user to resolve issue daily basis.
• Manage and monitor the system utilization by using the query optimizer and checking the execution plan.
• Database design, development, database creation and maintenance, performance monitoring and tuning, and troubleshooting where it’s needed it to improve.

Skills Used: MS SQL Integration Services 2008/2012, MS SQL Server 2012/2016/2017 , Window XP, MS Excel 2013, Visual Studio 2010/2015, SharePoint, Teradata Client 15, Oracle 11g, Ultra Edit, Jira tool

Database Developer/ETL Developer

Confidential, North Brunswick, NJ

Responsibilities:

• Developed and changed complex T-SQL, stored procedure code for the application.
• Involved in deploying Packages in Azure cloud and responsible for daily Production support failing ETL and Autosys Job.
• Create Technical and Functional Documents including detailed description and screenshots showing functioning of the package.
• Use SQL Server Tools like Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.
• Use SSIS (SQL Server Integration Services) for data ETL across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Involved and performed data migration for Sybase DB to SQL DB server and oracle for multiple application using ETL.
• Perform indexes performance improvement using Index tuning wizard for tuning of indexes.
• Validated source data before moving into target system and perform some data cleaning and data profiling using ETL.
• Involved for one-time data migration from Sybase to SQL Server using SSMA and performed data validation after migrated data into target system.
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports
• Manage and monitor the system utilization by using the query optimizer and checking the execution plan.
• Performed and develop Python script for data analysis and data validation for business users.

Skills Used: MS SQL Integration Services 2012/2014/2016 , MS SQL Server 2012/2014/2016 /2017, C#, Window XP, Linux, MS Excel 2010/2013, Visual Studio 2010/2015, Team Foundation Server (TFS), Sybase Central 6, SharePoint, Python 3.6, PowerShell.

Data Analyst

Confidential

Responsibilities:

• Involved in performance tuning of the database and T-SQL queries using Database Engine Tuning Advisor. Provided technical support to internal developers and external clients.
• Created Technical and Functional documents including detailed description and screenshots showing functioning of the package.
• Experience in using SSIS for data ETL across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Developed stored procedure, views, and database triggers in SQL Server 2008 R2/2012/2014

Skills Used: SSIS 2008/2012, MS SQL Server 2008/2012, C#, VB.Net, Window XP, Word 2010, Visual Studio 2010, Excel 2010, Da Vinci Tool, R-programming.