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 Accenture 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

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

Team Lead Responsibilities:

• Worked as the Tech lead involved in developing all the custom components
• Worked as a SME for AR and Trade Management modules
• Supporting the OBIEE team as a 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 a flat file checks cut in a 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 a flat file checks cut in a 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 a flat file checks cut in a 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