SUMMARY:

• Over 11 years of experience with analysis, design, development and Implementation of software applications primarily using Microsoft SQL Server, Oracle, Netezza, SQL Server Integration Services, SQL Server Reporting Services and Extensive experience in ETL/ Data warehouse backend testing.
• Proficient in creating Dynamic - queries, Stored Procedures, Triggers, User defined functions, Views Index, CTE and sql JOIN’s.
• Expertise in database activities like Data Modelling, Database Design, Development, Performance Monitoring and Tuning, Troubleshooting and Normalization.
• Developed various operational Drill-through and Drill-down reports and different kind of reports such a Sub Reports, Matrix/Tabular reports, Linked reports and Parameterized reports
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate objects, charts and synchronized queries.
• Deployed reports created report schedules and subscriptions. Managing and securing reports using SSRS based on the business requirements.
• Created and maintained SSIS ETL packages to extract data from different systems, and load variety of large volume data into data warehouse from different sources like databases, flat file, Excel file
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task and Send Mail task etc.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases .
• Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements.
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Actively involved in System Integration Testing (SIT) and Training of the end users. Participated in cross-functional teams to reengineer and improve business processes.

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Oracle 12c, Netezza, Power center - Infomatica

Senior Software Developer/Technical Architect/ETL Tester

Responsibilities:

• Play a key role in the development and system integration testing.
• Created Oracle/Netezza MERGE statements for complex updates, inserts and deletes with high volume data
• Created Test Plan, Test Scenario, Test Cases and Test Scripts to validate source and Target data using JIRA
• Involved in Performance Testing, Data Profiling and Data Analysis.

Confidential

Environment: Oracle 12c, Netezza, SSRS

Senior Software Developer/Technical Architect/ETL Tester

Responsibilities:

• Designed and Developed End to End automated Confidential using Oracle & Netezza stored procedure.
• Created Oracle & Netezza procedures to generate dynamic Recon Scripts (SQL & Autosys JIL) for any given tables based on system tables.
• Generated decision-making recon summary and detail reports.
• Designed and developed various SSRS drilldown and parameterized reports for loan and attribute level changes for the categories Value to Value, Null to Value and Value to Null.
• Created and managed subscriptions for the reports.
• Involved in performance tuning.

Confidential

Environment: Oracle 12c, Netezza, Power center - Infomatica & SSIS

Senior Software Developer/System Analyst

Responsibilities:

• Create Test Plan, Test Scenario, Test Cases and Test Scripts to validate source and Target data
• Play a key role in the development/automation of SQL queries while preparing the test case scripts
• Execute all the test case and report defects, define severity and priority for each defect.
• Carry out regression testing every time when changes are made to the code to fix defects
• Test data creation for volumetric testing and any performance testing.
• Creating, maintaining and executing Re-usable SQL scripts
• Execute test scripts including pre-requisites, detailed instructions and anticipated results
• Execute any data migration related tasks and provide feedback on the automated migration steps and queries

Confidential

Environment: MS-SQL Server, SSIS & SSRS

Senior Software Engineer/System Analyst

Responsibilities:

• Requirements gathering and impact analysis.
• Extracted data from SQL Server & CSV files using informatica to load into a single data warehouse repository
• Design & Development of Infomatica Mappings/Workflows & SSRS Reports
• Created automated Excel reports for data validation between Source & IDS.
• Involved in Unit Testing & Pear review

Confidential

Environment: SQL Server 2012, PowerCenter Informatica

Senior Software Engineer/System Analyst

Responsibilities:

• Extracted data from SQL Server & CSV files using informatica to load into a single data warehouse repository
• Created entity relationship diagrams & data model. Developed logical & physical data models using Erwin
• Designed & Developed bridge tables for Index Security Resolution.
• Designed & Developed bridge tables between PACE & CADIS for distribution migration.
• Created design documents, data mapping and data analysis documents.
• Involved in Data modeling for EDW migration (from EDW 1.0 to EDW 1.5)
• Created automated Excel reports for data validation between Eagle PACE & Cadis.
• Involved in data migration for EDW 1.5 through Informatica & SQL Server
• Involved in Deployments (SIT, UAT & PROD) & created deployment plan documents.

Confidential

Environment: SQL Server 2008R2/2012 & SSRS

Senior Software Engineer

Responsibilities:

• Created a Database and normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
• Responsible for development of Procedures, Functions and database Triggers.
• Created indexes and analyzed its role for optimizations
• Data Modeling using Erwin & Developing different types of reports using SSRS.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.

Confidential

Environment: SQL Server 2005/2008, SSIS & SSRS

MSBI Developer

Responsibilities:

• Created a Database and normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
• Responsible for development of Procedures, Functions and database Triggers.
• Created indexes and analyzed its role for optimizations
• Developing different types of reports using SSRS.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.

Confidential

Environment: SQL Server 2005/2008, SSIS & SSRS

Software Engineer

Responsibilities:

• Responsible for development of Procedures, Functions and database Triggers. Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Wrote queries for drill down reports to get the dataset required to build the report. Identified and included report parameters for parameterized report. Formatted the reports using Global variables and expressions.
• Deployed generated reports onto the Report Server to access it through browser.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Created indexes and analyzed its role for optimizations.
• Developed Dynamic search queries and results with manipulated data.

Confidential

Software Engineer

Environment: SQL Server 2005/2008, SSIS & SSRS

Responsibilities:

• Created a Database and normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
• Responsible for development of Procedures, Functions and database Triggers.
• Created indexes and analyzed its role for optimizations
• Developing different types of reports using SSRS
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.

Confidential

Environment: SQL Server 2005/2008, SSIS & SSRS

Database Programmer

Responsibilities:

• Created a Database and normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
• Responsible for development of Procedures, Functions and database Triggers.
• Created indexes and analyzed its role for optimizations
• Developing different types of reports using SSRS
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.