SUMMARY

• Confidential has 10+ Years of experience in IT industry as a software developer, team member and client coordinator with analysis, design and development of n - tier applications on SQL technologies towards Healthcare and Retail Industry. He has hands on experience and thorough understanding of Software Development Life Cycle (SDLC). He has involved in various phases like Requirements analysis, Design, Development, Code Review, Functional Testing, Deployment, Production support and documentation. He is a team player with strong communication, analytical, logical and problem- solving skills.
• 10+ years of experience as MS SQL Developer in development of Database Design and Development using MS SQL Server 2019/2016/2014/2012/ 2008 R2 system in OLTP and OLAP environment. Excellent experience in SSMS, SSIS and SSRS of MS SQL Server.
• Highly expert in translating Business System Design document into technical design document.
• Proficient in all phases of the Software Development Life Cycle (SDLC) including Requirements gathering, Analysis, Design, Development, Testing and Documentation using MS SQL Server suite of products (SSRS, SSIS, SSMS) and Oracle SQL Developer
• Experience in analyzing information, system needs, evaluating end-user requirements and custom designing solutions, Data validation, Support, and troubleshooting.
• In-depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins and CTEs.
• Experience in scheduling SSIS packages using SQL Server Agent. Strong knowledge of using variables and expressions in packages. Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Excellent skills in implementing ETL Packages using DTS and SSIS 2014/ 2012/ 2008 R2/ 2008
• Proficient in implementing all transformations available on the SSIS toolbox. Expert in resolving the performance issue of SSIS packages.
• Experience in Data Extraction, Transforming and Loading (ETL) between using SQL tools (SSIS, DTS, Bulk Insert, and XML).
• Well versed in Importing/Exporting Data from various data sources like Excel, Oracle and Flat file using BCP, Bulk Insert & DTS utility.
• Strong experiences to Design, deploy, and maintain various SSRS Reports in SQL Server 2016/20142012 and experience in creating enterprise reports using SSRS 2005/2008 using Report Manager, Report Builder, and BIDS.
• Created many Drill through, Drill Down, Parameterized reports using SSRS 2008/2012.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012/2014.
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts, and column report.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Significant experience with data intensive visualization/analytics tool like SSRS
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages
• Team player with strong analytical, logical and problem-solving skills

TECHNICAL SKILLS

Operating System: Windows 98/2000/2003/ XP/VISTA, Windows Server 2000/2003/2008/2008 R2/2012

Database Tools /Reporting/Analysis Tools/Skills: SQL Server Management Studio (SSMS) - SQL Server 2005/2008/2012/2016 , SQL Server Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL, Oracle-SQL Developer, Agile Methodology, Bit Bucket, Source Tree, ETL, Data WarehouseJira, Bamboo, MS Office

Other Utilities: Retail Domain, Healthcare

Scheduler/Version Control System: UC4, Mercurial, Team Foundation Server, Tortoise SVN Sub Version, Toad, Visual Source Code, Tidal

PROFESSIONAL EXPERIENCE

Confidential, Norfolk, Virginia

MSBI/SSIS/SSRS/Oracle SQL Developer

Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures and views.
• Involved in Designing, Developing and Testing of the ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS) and Development of SSIS Packages to leverage data as per report needs
• Designed SSRS reports for in depth business analyses.
• Adept at developing and supporting analysis solutions, data transformations, and reports.
• In-depth understanding of all stages of software development life cycle (SDLC).
• Perform quality assurance and testing of SQL server environment.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Supported all production operation activities, with focus on integration and development of new and existing products and services.
• Worked with internal and external clients for import and normalization of third-party data.
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, merge join, execute SQL flow task, data flow task to extract data from different databases and flat files.
• Created complex SQL queries by joining multiple tables, dynamic SQL and sub queries in TSQL.
• Worked on migrating data from non-relational database to relation database.
• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Improved the performance of long running views and stored procedures. Improved performance by adding indexes, removing reductant columns in the inner views and adding conditions to get only required data.
• Integration testing for ETL, Reports and Preparation of design documents and Unit Test cases.
• Production Enhancements and Bug Fixing.
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop.
• Documented User Stories and facilitated Story Point discussions to analyze the level of effort in project specifications

Environment: Facets, Advanced SQL, MS SQL Server, SDLC, Agile/Scrum, SQL Server Integration services SSIS, SQL Server Reporting services SSRS, Visual Studio Code, BitBucket, Tidal, Tortoise SVN Sub Version, Toad, Oracle SQL Developer.

Confidential, Jessup, Pennsylvania

MSBI/SSIS/SSRS/SSMS SQL Developer

Responsibilities:

• Coordinated with client business analysts to finalize the Requirements and designed database structure for the reports and created technical specification documents
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Involved in Designing, Developing and Testing of the ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS) and development of Packages/reports to leverage data as per reporting needs.
• Developed Tables, Stored Procedures using SQL Server Management Studio and reviewed and modified SQL queries as part of peer review.
• Designed SSRS reports for in depth business analyses and adept at developing and supporting analysis solutions, data transformations, and reports.
• In-depth understanding of all stages of software development life cycle (SDLC).
• Perform quality assurance and testing of SQL server environment.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Supported all production operation activities, with focus on integration and development of new and existing products and services.
• Worked with internal and external clients for import and normalization of third-party data.
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, merge join, execute SQL flow task, data flow task to extract data from different databases and flat files.
• Created complex SQL queries by joining multiple tables, dynamic SQL and sub queries in TSQL.
• Worked on migrating data from non-relational database to relation database.
• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Improved the performance of long running views and stored procedures. Improved performance by adding indexes, removing reductant columns in the inner views and adding conditions to get only required data.
• Integration testing for ETL, Reports and Preparation of design documents and Unit Test cases.
• Production Enhancements and Bug Fixing.

Environment: Facets, Advanced SQL, MS SQL Server, SDLC, SQL Server Integration services SSIS, SQL Server Reporting services SSRS, Tidal, Tortoise SVN Sub Version

Confidential

MSBI/SSIS/SSRS/SSMS SQL Developer

Responsibilities:

• As a key person, managed team and coordinated in all aspects with client to ensure successful delivery of project.
• Coordinated with client business analysts to finalize the Requirements and designed database structure for the ETL/Reports and created technical specification documents
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Involved in Designing, Developing and Testing of the ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS) and development of Packages/reports to leverage data as per reporting needs.
• Developed Tables, Stored Procedures using SQL Server Management Studio and reviewed and modified SQL queries as part of peer review.
• Designed SSRS reports for in depth business analyses and adept at developing and supporting analysis solutions, data transformations, and reports.
• In-depth understanding of all stages of software development life cycle (SDLC).
• Perform quality assurance and testing of SQL server environment.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Supported all production operation activities, with focus on integration and development of new and existing products and services.
• Worked with internal and external clients for import and normalization of third-party data.
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, merge join, execute SQL flow task, data flow task to extract data from different databases and flat files.
• Created complex SQL queries by joining multiple tables, dynamic SQL and sub queries in TSQL.
• Worked on migrating data from non-relational database to relation database.
• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Improved the performance of long running views and stored procedures. Improved performance by adding indexes, removing reductant columns in the inner views and adding conditions to get only required data.
• Integration testing for ETL, Reports and Preparation of design documents and Unit Test cases.
• Production Enhancements and Bug Fixing.

Environment: Retail, Advanced SQL, MS SQL Server, Oracle SQL Developer SDLC, SQL Server Integration services SSIS, SQL Server Reporting services SSRS, UC4, Tortoise SVN Sub Version

Confidential

MSBI/SSIS/SSRS/SSMS SQL Developer

Responsibilities:

• Interaction with Client to gather requirements and KT to team upon received inputs. Preparation of design documents and Unit Test Cases
• Development of SSIS mappings & SSRS Reports. Unit Testing, Integration testing for mappings.
• As Part of this project all the existing jobs were moved from EPICOR backed to RMS adding additional features supported by RMS and development of transactional reports.
• As a key person, managed team and coordinated in all aspects with client to ensure successful delivery of project.
• Coordinated with client business analysts to finalize the Requirements and designed database structure for the ETL/Reports and created technical specification documents
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Involved in Designing, Developing and Testing of the ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS) and development of Packages/reports to leverage data as per reporting needs.
• Developed Tables, Stored Procedures using SQL Server Management Studio and reviewed and modified SQL queries as part of peer review.
• Designed SSRS reports for in depth business analyses and adept at developing and supporting analysis solutions, data transformations, and reports.
• In-depth understanding of all stages of software development life cycle (SDLC).
• Perform quality assurance and testing of SQL server environment.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Supported all production operation activities, with focus on integration and development of new and existing products and services.
• Worked with internal and external clients for import and normalization of third-party data.
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, merge join, execute SQL flow task, data flow task to extract data from different databases and flat files.
• Created complex SQL queries by joining multiple tables, dynamic SQL and sub queries in TSQL.
• Worked on migrating data from non-relational database to relation database.
• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Improved the performance of long running views and stored procedures. Improved performance by adding indexes, removing reductant columns in the inner views and adding conditions to get only required data.
• Integration testing for ETL, Reports and Preparation of design documents and Unit Test cases.
• Production Enhancements and Bug Fixing.

Environment: Retail, Advanced SQL, MS SQL Server, Oracle SQL Developer SDLC, SQL Server Integration services SSIS, SQL Server Reporting services SSRS, UC4, Tortoise SVN Sub Version

Confidential

MSBI/SSIS/SSRS/SSMS SQL Developer

Responsibilities:

• As a key person, managed team and coordinated in all aspects with client to ensure successful delivery of project.
• Coordinated with client business analysts to finalize the Requirements and designed database structure for the ETL/Reports and created technical specification documents
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Involved in Designing, Developing and Testing of the ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS) and development of Packages/reports to leverage data as per reporting needs.
• Developed Tables, Stored Procedures using SQL Server Management Studio and reviewed and modified SQL queries as part of peer review.
• Designed SSRS reports for in depth business analyses and adept at developing and supporting analysis solutions, data transformations, and reports.
• In-depth understanding of all stages of software development life cycle (SDLC).
• Perform quality assurance and testing of SQL server environment.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Supported all production operation activities, with focus on integration and development of new and existing products and services.
• Worked with internal and external clients for import and normalization of third-party data.
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, merge join, execute SQL flow task, data flow task to extract data from different databases and flat files.
• Created complex SQL queries by joining multiple tables, dynamic SQL and sub queries in TSQL.
• Worked on migrating data from non-relational database to relation database.
• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Improved the performance of long running views and stored procedures. Improved performance by adding indexes, removing reductant columns in the inner views and adding conditions to get only required data.
• Integration testing for ETL, Reports and Preparation of design documents and Unit Test cases.
• Production Enhancements and Bug Fixing.

Environment: Retail, Advanced SQL, MS SQL Server, SDLC, SQL Server Integration services SSIS, SQL Server Reporting services SSRS, UC4, Tortoise SVN Sub Version

Confidential

MSBI/SSIS/SSRS/SSMS SQL Developer

Responsibilities:

• Involved in Designing, Developing and Testing of the ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS) and development of Packages/reports to leverage data as per reporting needs.
• Developed Tables, Stored Procedures using SQL Server Management Studio and reviewed and modified SQL queries as part of peer review.
• Designed SSRS reports for in depth business analyses and adept at developing and supporting analysis solutions, data transformations, and reports.
• In-depth understanding of all stages of software development life cycle (SDLC).
• Perform quality assurance and testing of SQL server environment.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Supported all production operation activities, with focus on integration and development of new and existing products and services.
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, merge join, execute SQL flow task, data flow task to extract data from different databases and flat files.
• Created complex SQL queries by joining multiple tables, dynamic SQL and sub queries in TSQL.
• Improved the performance of long running views and stored procedures. Improved performance by adding indexes, removing reductant columns in the inner views and adding conditions to get only required data.
• Integration testing for ETL, Reports and Preparation of design documents and Unit Test cases.
• Production Enhancements and Bug Fixing.

Environment: Retail, Advanced SQL, MS SQL Server, SDLC, SQL Server Integration services SSIS, SQL Server Reporting services SSRS, UC4, Mercurial