SUMMARY

• Over 11+ years of analysis, design, and development experience in the IT industry on Oracle.
• Over 10+ years of experience as Technical Consultant in Oracle E - Business Suite Applications (UK/US).
• Experience in all phases of the system development /implementation life cycle.
• In-depth knowledge in analysis, design, coding, testing and troubleshooting.
• Extensively worked on GL, AP, AR, purchasing, CE, Alerts and System Administration modules.
• Experience of Development, Interfaces & Data Conversion, Implementation, Customizations of Oracle General Ledger, Accounts Payables, Accounts Receivable modules.
• Prepared technical design documents for customizations and conversions using Confidential delivery methods.
• Experience in Oracle Analytics, demonstrating expertize in utilizing the ETL tools in data modeling using dimensional data modeling, star schema modeling, Fact and Dimension tables.
• Proficient with BI Publisher reports and using various templates to publish the reports as per user requirements.
• Comprehensive knowledge in debugging, optimizing and performance tuning of ETL objects using Informatica and ODI 12c.
• Expert level experience in Oracle 7.x, 8.x, 9.x, Oracle forms & Reports 9i.
• Proficient in writing stored procedures, packages and functions using SQL & PL/SQL.
• Acquired sufficient level of good functional knowledge on financial accounting and business processes.
• Experienced in Offshore-Onsite Delivery Model.
• Experience in Production Support.
• Good communication and presentation skills.
• Strong perseverance and diligence towards attaining challenging goals and effective time management.
• Self-motivated, excellent team player with proven leadership skills.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

ERP: Oracle Applications R12/11i (GL, AP, AR, Purchasing, Core HRMS, CE, System Administration and Alerts)

ETL Tools: Oracle Data Integrator 12c, Informatica

Reporting Tool: OBIEE 11g, BI Publisher tool

RDBMS: Oracle 11g to 7x, SQL Server 2000

Tools: JDeveloper, Developer 2000/6i (Forms 6i, Reports 6i), TOAD, SQL*Loader, SQL*Plus, Data load, CuteFTP, Clearcase and PVCS (Version Control System)

Languages: SQL, PL/SQL, HTML, XML

Environment: UNIX, Windows 98/NT/2000/XP

PROFESSIONAL EXPERIENCE

Confidential - Norwalk, CA

Team Lead

Responsibilities:

• Working as the Oracle analytic lead involved in design and development of all the custom star schema mappings.
• Handling the delivery of BI reports for Account Receivables and customer activity modules
• Interacted with the business users for requirement gathering and defined requirement specification documents
• Identify and implement the reusable PLSQL stored procedures that can used across the project
• Involved in design and data modeling using star schema.
• Created SCD and incremental update mappings using ODI 12c
• Identified and created the reusable mappings for various functional areas
• Created ODI packages, scenarios using various logical components like aggregate, data set, distinct, pivot, sub-query filter, expression, etc
• Designed and Implemented the complex accumulated snapshot model
• Providing everyday/Weekly status update to the onshore team on all the development activities.
• Involved in creating some Custom reports (Pivot, Charts, Line, Graphs, etc) for the end users to check the details and errors as per business requirements
• Designed and developed various BI Publisher reports ( eg.TANF audit report, SSIAP approval and denials, etc )
• Developed various PLSQL stored procedures to aid the complex data model requirements ( e.g. periodic snapshot )
• Responsible for the technical and user documentation of the customizations.

Environment: ODI 12c, OBIEE 11g, Oracle BI Publisher, Oracle 11g, TOAD, Putty, winscp.

Confidential - Pittsburgh, PA

Team Lead

Responsibilities:

• Worked as the Tech lead involved in developing all the custom components
• Worked as Confidential SME for AR and Trade Management modules
• Supporting the OBIEE team as Confidential OTC SME in developing complex reports
• Supporting process team on the product test
• Involved in post go-live at client place supporting the complex components
• Involved in various level of testing & fixing the defects identified by the process team
• Created new custom Java pages and personalized the existing OAF pages.
• Converted User Requirements into formal Functional specifications and Interfacing with client.
• Participated in developing the approach and plan for developing & testing the application.
• Providing everyday/Weekly status update to the onshore team on all the development activities.
• Extracted data from Oracle base tables and sending Confidential flat file (checks cut in Confidential period) using UTL FILE package at periodic intervals.
• Registered various PL/SQL packages, Request Sets, Forms, Menus and defining value sets.
• Involved in creating some Custom reports and forms for the end users to check the details and errors as per business requirements
• Delivered Solution Design Document encompassing both Functional and Technical Design
• Responsible for the technical and user documentation of the customizations.

Environment: Oracle Applications 12.1.2 (OM, TCA, PO,FA & GL), OAF, Forms 10g, Reports 10g, Oracle 10g(SQL, PLSQL), JDeveloper, TOAD, SQL Loader and Putty.

Confidential

Sr. Tech Designer/Tech Lead

Responsibilities:

• Worked as the Tech Lead in developing all the custom components
• Converted User Requirements into formal Functional specifications and Interfacing with client.
• Participated in developing the approach and plan for developing & testing the application.
• Providing everyday/Weekly status update to the onshore team on all the development activities.
• Extracted data from Oracle base tables and sending Confidential flat file (checks cut in Confidential period) using UTL FILE package at periodic intervals.
• Registered various PL/SQL packages, Request Sets, Forms, Menus and defining value sets.
• Involved in creating some Custom reports and forms for the end users to check the details and errors as per business requirements
• Delivered Solution Design Document encompassing both Functional and Technical Design
• Responsible for the technical and user documentation of the customizations.

Environment: Oracle Applications 12.0.4 (GL, AP, AR, PO & CE), Forms 10g, Reports 10g, Oracle 10g(SQL, PLSQL), TOAD, SQL Loader and Putty.

Confidential

Sr. Oracle Applications Developer

Responsibilities:

• Working as the incident manager to manage and deal with the support issues.
• Logging calls with Oracle and managing the service requests.
• Worked on Payables Open Interface Import to create invoices from external systems into AP Invoice tables.
• Customized the AR Invoice print report and AP to GL Transfer programs.
• Created Alerts to notify users on various business events
• Extracted data from Oracle base tables and sending Confidential flat file (checks cut in Confidential period) using UTL FILE package at periodic intervals.
• Registered various PL/SQL packages, Request Sets, Forms, Menus and defining value sets.
• Involved in creating some Custom reports and forms for the end users to check the details and errors as per business requirements
• Executed the Payables Transfer to General Ledger program and resolved the issues during the process.
• Delivered Solution Design Document encompassing both Functional and Technical Design
• Involved in scheduling some batch jobs using Appworx scheduling tool.
• Responsible for the technical and user documentation of the customizations.

Environment: Oracle Applications 11.5.8 (GL, AP, AR, PO & Alerts), Forms 6i, Reports 6i, Oracle 9i(SQL, PLSQL), TOAD, SQL Loader and Putty.

Confidential

Oracle Applications Developer

Responsibilities:

• Converted User Requirements into formal Functional specifications and Interfacing with client.
• Review the code and develop revisions.
• Create documentation for code/application
• Participated in developing the approach and plan for testing the application.
• Involved in the UTP for various components & efficiently resolving the deficiencies.
• Developing packages, reports & alerts and registering the components as concurrent programs.
• Customizing oracle standard reports like remittance advice, AR customer statements as per the business requirements to print or email the outputs in PDF format.

Environment: Oracle Applications 11.5.10 (GL, AP, AR, PO, Core HRMS, Payroll Alerts), Forms 6i, Reports 6i, Oracle 9i(SQL, PLSQL), TOAD, SQL Loader and Putty.

Confidential

Oracle Applications Developer

Responsibilities:

• Journal Import: Developed Confidential package for GL Interface that validates and imports journals to General Ledger.
• Participated in the technical design process by helping analyze and define the technical application requirements
• Review the code and develop revisions
• Create documentation for code/application
• Participated in developing the approach and plan for testing the application
• Efficiently resolve code deficiencies detected in the applications.

Environment: Oracle Applications 11.5.10 (GL, AP, AR, PO), Forms 6i, Reports 6iOracle 9i(SQL, PLSQL), TOAD, SQL Loader and Putty.

Confidential

Oracle Consultant

Responsibilities:

• Participated in the technical design process by helping analyze and define the technical application requirements
• Participated in designing the database
• Review the code and develop revisions
• Create documentation for code/application
• Participated in developing the approach and plan for testing the application
• Prepare and execute unit and module testing, verify the correctness of the module against its detailed design.
• Efficiently resolve code deficiencies detected in the application.
• Help to identify and document the impact and associated effort of change requests.
• Support users.

Environment: Oracle 9i (SQL, PLSQL), TOAD, Ms Visual Basic-COM, ASP3.0, XML

Confidential

Oracle Consultant

Responsibilities:

• As it is Confidential re-engineering project, have involved in code-mining of EARL & COBOL reports to prepare PSP (Program Specifications).
• Designed technical documents to develop the reports with various lexical parameters with two or more layouts.
• Creating stored procedures with the program specifications.
• Developing check-list for the report standards and unit-test cases.

Environment: Oracle 9i (SQL, PLSQL), TOAD and Oracle Reports 9i.

Confidential

Oracle Developer

Responsibilities:

• Extensively developed PL/SQL Procedures, Functions, Form Triggers and Packages.
• Responsible for creating the Database tables, indexes, constraints in Oracle8i.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Development, trouble-shooting, debugging, Independent unit-testing & Impact analysis.
• Created stored procedure using SQL Server 2000 & Oracle 8i for various components.
• Error-Mapping are done using the framework for various stored procedures with/without place holders.
• Designed the business logic to eliminate problems and to ensure efficient system functioning.
• Tested the entire application in testing environment and exported to Production.

Environment: Oracle 9i (SQL, PLSQL), SQL Server 2000, XML, ASP3.0