Deeban D.

Deeban D.

Senior Consultant-Product Implementation

Chennai , India

Experience: 8 Years

Deeban

Chennai , India

Senior Consultant-Product Implementation

USD / Year

  • Start Date / Notice Period end date:

8 Years

Now you can Instantly Chat with Deeban!

About Me

Having Total Experience of about 9 Years with 5+ years in PL/SQL Application Development and Product Implementation for diverse projects. Proficient experience in Oracle DB. Expertise in writing SQLs and PL/SQL for development of Stored Procedures, F...

Show More

Portfolio Projects

Description

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.

Show More Show Less

Description

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.

Show More Show Less

Description

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

Show More Show Less

Description

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

Show More Show Less