1.      Balanced Score Card(BSC), Dashboard, Enterprise Performance Management(EPM)/BI software Implementation 

2.      Performing QA/QC on dashboard parameter by verifying Expressions, Formula’s and Business Logic's shared by client.

3.      Responsible for developing technical specifications from business requirements.

4.      Monitoring the Database performance and take necessary action to optimize the database performance

5.      Developed SQL and PL/SQL scripts for Data loading from different source system’s (Oracle, MS SQL Server, Excel files) to Target EPM system.

6.      Worked in Data Migration using Informatica Power Center 9.x, Oracle PL/SQL Stored Procedures to Extract and Transform data from various data sources and Load to the Target/Dimensional Databases. 

7.      Handled Incident and problem management related to SQL production support.

1.      Coded and maintained PL/SQL Packages, Stored Procedures and Database Triggers. 

2.      Loaded the data into database tables using SQL*loader from text and excel files.

3.      Designed/developed tables, views, various SQL queries, stored procedures, function and various Database Change Request’s as part of enhancements.

4.      Extensively used FOR ALL and BULK COLLECT to fetch large volumes of data from table.

5.       Prepared estimates for Change requests raised by the client

6.       Involved in Production Support to resolve production issues in a timely and efficient manner which was assigned to support using BMC Remedy tool. 

1.      Requirements Analysis and providing estimates for the Changes Request/Requirements 

2.      Creating  unit test plans and Unit test cases and generating  regular status reports 

3.      Designed/developed tables, views, various SQL queries, stored procedures, function and various CR’s as part of enhancements. 

4.      Involved in Production Support to resolve production issues in a timely and efficient manner which was assigned to our group through HP service desk. 

5.      Involved in the deployment of code into QA and Production environment. 

6.      Involved in Code review before dropping into QA/UAT environments. 

7.      Analyzing of work request/client requirement, planning and estimating efforts for work request.

8.      Providing deliverable's with zero defects and guided in the Implementation phase of the project.

9.      Involved in Software Quality Assurance activities

1.      Interacting with the representatives of the Design Department for mapping their requirements and specification. 

2.      Worked in User Interface and Database schema Design. 

3.      Prepared Data Dictionary with the list of tables, fields, and data types, Keys, Index and Constraints.

4.      Created Procedures, Functions and Trigger’s for executing Business logic with Transactions

5.      Documented business rules, functional and technical designs, test cases, and user guides. 

6.      Troubleshooting performance issues and bugs within SQL scripts. 

7.      Analyzing of work request/client requirement, planning and estimating efforts for work request