PROFESSIONAL SUMMARY

• Oracle EBS professional with 13 years’ experience in performing all or part of the Software Development Life Cycle (SDLC) ranging from analysis and design to construction, implementation and maintenance. Worked as Technical Manager/Project Lead, Technology Specialist, Technical Consultant, Senior Systems Analyst and Software Programmer/Analyst mainly related to Oracle E - Business Suite and data conversion using ETL tool.
• Worked on 11i to R12 upgrade project.
• Ability to deliver high quality results with attention to details. Excellent Analytical skills and ability to work efficiently in a multi-tasked environment.
• Design and propose Oracle E- Business Suite (EBS) solution based on the business requirement and develop technical design document.
• Interacted with Business users and the client for providing testing and Production Support to meet SLA.
• Good experience on building customized business solutions. Extensive experience in Oracle PL/SQ, Reports BI Publisher reports, Discoverer reports.
• Extensively worked on Data Conversion, hands on Oracle ODI (ETL).
• Good experience as team lead, client communication and onshore offshore model.
• Expert in preparing Technical specs, user manuals, test procedures, training and document preparation.
• Experienced in all aspects of Project Management (Resource, Cost, Team management)
• Experienced on Project go-live and post-implementation support.

TECHNICAL SKILLS

ERP: Oracle E-Business Suite R12, 11i, 11.5.3

ETL: Oracle Data Integrator (ODI) 11.1.11, Informatica Power center 10

ERP Modules: GL (General Ledger), AP (Account Payables), AR (Account Receivables), PO (Purchasing), OM (Order Management), AOL (Application Object Library), P2P, O2C, R2R, Advanced Collections and System Administration.

RDBMS: Oracle 7.x/8.x/8i/9i/10g/11g/12g

Development Tools: XML/BI Publisher, Reports & Forms 6i/10g, Discoverer 4i/10g/11g, Workflow Builder,

Tools: SQL*PLUS, SQL*Loader, TOAD, SQL*Navigator, SQL Developer. PVCS, Kintana, Quality Center, Remedy

Languages: SQL, PL/SQL, Unix Shell Scripting.

Reporting Tools: Reports 6i/10g, Discoverer 11g, XML/BI Publisher.

PROFESSIONAL EXPERIENCE

Conversion Team Lead 

Responsibilities:

• Design and document mapping of conversion project.
• GAP analysis for data conversion.
• Source to target data mapping.
• Communication between client and development team.
• Schedule conversion timeline per application development team.
• Coordination between development and DBA team.

Conversion Team Lead (design and Development)

Responsibilities:

• Managing team of 13 persons, assigning and tracking weekly progress of individual task.
• Keep the project manager informed of task accomplishment, issues and status. Generating weekly progress report and presenting to the management.
• Develop a strategy the team will use to reach its goal.
• Coordinating between different teams like Application development, testing for design change
• Documenting source to target data mapping and updating new changes.
• Working with individuals on (ODI) ETL and SQL, PL/SQL or technical issues.
• Individual code review for development work.
• Preparing cutover task and assign resources to each task, for all group release.
• Generating data mismatch / fallout report and communicate to team for all group release.
• Support all post release activities including production issues (Production support).
• Triage production tickets and assigning them to appropriate person.
• Individual code review for production fix.
• Setting timeline for all production issues with team.

Application Lead

Responsibilities:

• As part of Linksys-Belkin ERP integration we worked on major part for data conversions. Customer conversion, Price List Conversion, AR Open Invoice conversion, AP Vendor conversion, PO conversion
• Managing the Technical Development Team and ensure the on time delivery and Support ticket resolution.
• Leading offshore team for all deliverables.
• Understanding the functional design and preparing the technical design for User Interfaces, Conversions, Workflows and Interfaces in PO, AP, and OM Modules.
• Define your reports with reusable report objects, making it easy to create new reports from the components of reports.
• Design custom financial reports to meet specific business needs.
• Produce ad hoc reports whenever client need them.
• Printing reports to tab-delimited files for easy import into client-based spreadsheet programs with Financial Statement Generator.
• Executing functional testing for RICE. Interact with Client Functional teams to resolve any issues during the development and enhancement phases.
• Interacted with end users to gather requirements and Draft specifications during development Phase.
• Involved in requirements gathering and testing (Unit, Mock, Pre Production).
• Created Concurrent Programs, Executables and Request sets.
• Coding, testing of the technical components to meet the functional requirements
• Production support and meet SLA

Team Lead 

Responsibilities:

• Managing the Technical Development Team and ensure the on-time delivery
• Worked on Revenue Recognition custom module
• 11i to R12 upgrade all retrofitting.
• Understanding the functional design and preparing the technical design for User Interfaces, Conversions, Workflows and Interfaces in GL, AP and AR Modules.
• Worked on various enhancement projects like Revenue recognition, Standard margin.
• Development of interfaces in GL, Sourcing, AP, PO, OM and AR modules.
• Development of custom Conversions and Interfaces.
• Development of AP Invoices interface.
• Executing functional testing for RICE. Interact with Client Functional teams to resolve any issues during the development and enhancement phases.
• Involved in Oracle Application Production support
• Developed PL/SQL Packages, Procedures and Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated the base tables.
• Involved in writing Package to extract data from Legacy System, validated and imported into Journal Import Interface tables and submitted a concurrent request to populate base tables.
• Created End User Layer and Business Areas using Discoverer Administrator.
• Created workbooks in Oracle Discoverer for trend analysis and reporting purposes.
• Coordinated Knowledge transfer to technical team and guided them on prevailing technical issues and general Oracle Applications issues.

Oracle Apps Technical Consultant 

Responsibilities:

• Oracle Apps customization of Financial Modules - AP, AR, GL.
• Requirement Analysis, Design and Development.
• Developed Forms and Reports- XML/BI Publisher, Discoverer
• Created Concurrent Programs, Executables, Parameters and Value Sets through backend process (API) development
• Interface development in Financials Modules.
• Accountable for the entire project lifecycle spanning scope, design, build, test, rollout and warranty support using Oracle’s AIM Methodology.
• Develop and maintain productive business relationship with customers.
• Understanding of process flow of integration points between PO-AP-GL-OM
• Worked on errors faced in GL cross validation rules used in requisition account generator validation process
• Converted existing Oracle Reports to XML/BI Publisher Report through Oracle’s desktop XML Publisher tool
• Used XML Publisher to create XSL-FO (Formatting Object) and XSL-T (Transformations)
• Experience in creating Concurrent Programs, Request sets, Flex fields, lookups, Profiles, Value sets, Triggers, Packages, Procedures, Functions, Cursors and Exception Handlers, Record Groups, LOV’s.
• In-depth understanding of the steps in Oracle Reports 6i creation, deployment and registration process through AOL and system administration.
• Planned and developed the data conversion methodology for Purchasing Order data interfaced to PO module.
• Created around 22 XML/BI publisher reports in Financial and SCM module.

Oracle Apps Technical Developer (Offshore)

Responsibilities:

• Worked on New Report Development
• Involved in Report Customization
• Worked on Reports 6i, BI Publisher Reports
• Production Support

Oracle Developer

Responsibilities:

• Worked on SQL reports
• PL/SQL procedures, function creation
• Righting complex SQL for reports.
• Providing technical solutions to the team for development as well as support issues