EXPERIENCE

• About 9 years of experience in design, analysis, development, testing PL/SQL, ETL flow and ETL product support.
• Expertise in ETL Database stream mainly into Oracle world with a diversified knowledge on the SQL/PLSQL, Informatica PC development, OWB development, OWB/ODI product support, Admin support, Database modelling, SQL performance tuning.
• Trained in Informatica Power Centre version 8.6.1.
• Having good development knowledge in Informatica PC 8.6.1 ETL tool.
• Specialist in Oracle Warehouse Builder OWB development involving 10g, 11g version and having expert's level development knowledge in OWB.
• Specialist in different version on Oracle Data Integrator ODI and Oracle Warehouse Builder OWB in the product support by providing solutions to tool level issues
• Well versed in working with Oracle 9i, 10g, 11g and performing Database design and experienced in writing SQL queries, Stored Procedures, Triggers, using PL/SQL,OWB and ORACLE APPS O2C .
• Having strong Analytical, logical skills and problem solving capabilities.
• Created Unit Test Cases for PL/SQL, OWB modules.
• Team Player, quick learner and self-starter with effective communication, motivation and organizational skills combined with attention to details and business process improvements.
• Proven ability to analyze problems, root causes and develop innovative solutions to business challenges and streamlining operations.

TECHNICAL EXPERTISE

CORPORATE EXPERIENCE

Senior Software Engineer

Cognizant Technology Solutions India Associate

Covansys a CSC company India Singapore Senior software engineer

Confidential

Senior database developer PLSQL OWB

PLSQL Responsibilities

• Creating PL/SQL stored procedures, functions.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Partitioned the tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Created SQL scripts for the front end application.
• Working on SQL Loader to load data from flat files obtained from various systems to oracle.

OWB Responsibilities

• Created OWB pluggable mapping, mappings for loading data from different systems to oracle.
• Created Process flows.

Confidential

Team lead / Support Co-ordinator

Responsibilities

• Providing technical solution/guidance on the issue faced during Production, Integration Development phase.
• Supporting POC's on OWB and ODI tools by providing the better information about the features and best practices for development, integration deployment.
• Providing better way of Architecture setup for better performance and maintenance.
• Technical solution/guidance and admin level of support for the below actions
• o Installation of ODI/OWB servers both standalone and clustered
• o During the setup/configuration of Agents, High availability, DB connectivity for ODI OWB and Agent Setup
• Supporting the Production issues for the objects related to ODI OWB
• Helping clients on installing the patches for solving the issues.
• Owning the confirmed bugs/issues on OWB and ODI products to provide the necessary solution for the client

PROJECTS Cognizant Technology

Confidential

Team lead

Responsibilities

• Collecting requirement from client
• Writing DB procedures, packages, functions for Actimize system for loading data from different systems Albridge,Morning star and Mainframes systems .
• Written queries for the front end applications for configuring reporting tools needs
• Tuning the performance for procedures, packages functions
• For better performance in the system created partition, index based on the table usage.
• Created batch processing jobs using msdos for processing the data for loading into database using sqlloader and also for calling the procedures,packages or any DB action
• Involved in the design for job processing on development and production environment using the third party tool.
• Maintenance of the production and fixing the issues.

PROJECTS Covansys a CSC company projects

Confidential

Team lead

Responsibilities

• Created OWB pluggable mapping with different systems.
• Created mapping with different systems.
• Created Process flows.
• Worked as OWB UI administrator.
• Admin on OWB for creating OWB and DB users, import/export activities.
• Administrated the DB related activities.
• Co-ordinate with Client for requirement, deployment and testing.
• Developed DB Procedures and functions.
• Involved in writing Procedures, Packages and Functions.

Confidential

Onsite Coordinator

Responsibilities

• Co-ordinated offshore team on the project development, tacking and fixing the issues.
• Designed the full database model for the application.
• Prepared Technical Specification Document for ePT
• Co-ordinate with onsite testing team, Users and functional team to track and resolve the issues
• Involved as the administrator for the DB related activities.
• Developed SQL Queries, Procedures and Triggers for all the modules.
• Involved in the development of PRO C code for batch for the data population to the tables.
• SIT and UAT Support.
• Prepared Unit Test Plan Document for ePT.

Confidential

Team Member

Responsibilities

• Key Developer for Interfaces for O2C Objects into APPS Database.
• Extensive functional knowledge on O2C objects
• Interacted with the client and marketing team to design and development
• Have done data migration from SQL Server 2000 to Oracle 9i through PL/SQL scripts and SQL Server stored procedures for various countries France, Italy and Germany releases
• Involved in Data Migration from legacy to Oracle 9i through PL/SQL scripts and Oracle stored procedures for various countries UK DTP, Canada and Belgium releases.
• Developed screens using Oracle forms for the OWB architect.
• Developed the OWB architect for the conversion objects
• Created package Load programs for loading, validation and mapping the data with Oracle.
• Proficient in registration of concurrent programs, executables, defining responsibilities, Request groups and data groups.
• Loading the extracted files into the oracle core database using oracle apps vOracle 11i
• Involved as a Developer to implement the tools at client side to track and resolve the issues.
• Identified and resolved issues faced during conversion.
• Co-ordinate and implement the new tools for reconciliation process for O2C objects.
• Co-ordinate with onsite team and functional team to track and resolve the issues
• Prepared technical specification documents and Unit test plans for conversion
• Involved in the Iterative process of the conversion data and provided the support after the go live.
• Performed peer reviews
• Collaborate with multiple vendor teams for various conversion releases
• Prepared / updated migration document for conversion
• Attend scheduled conference with the client
• Train new resources on data conversion