PROFESSIONAL SUMMARY:

• 17 years of professional work experience in Oracle Applications E - Business (ERP) as Solution Architect, Tech Lead, Techno Functional & Technical Consultant
• Involve in full life cycle implementations, upgrades, developments of Oracle Applications R12 and 11i
• Worked on various modules of Oracle Applications (R12, 11i) including OM, INV, PO, AP, AR, GL, SLA, Project, Fixed Assets, iProcurement, Service Contract, HRMS, SCM
• Delivered numerous consultancy solutions and has designed & developed various critical business processes (Forms, Reports, Interfaces, Workflows, Business Events & Web Services) for different clients across the globe in a very efficient manner without compromising with the Quality.
• Excellent Technical Development skills in developing RICE (Reports, Interfaces, Conversions and Extensions) Components in the domain of Oracle Applications E-Business Suite.
• Good exposure to Oracle Application Implementation Methodology (AIM 3.0) in preparing BR100, MD50, MD70, CV60 etc.
• Have a very good knowledge on SYSADMIN, AOL, Database objects, etc.
• Leading team, guidance, reporting to senior level people, status reports, time lines and delivery management.
• Excellent Communication, Inter-personal skills, work ethic and drive, makes me a very valuable addition to any Project. Strong multi country onsite client’s exposure (USA, UK, UAE).

TECHNICAL SKILLS:

Oracle Applications: R11i, R12 - GL, AP, AR, SLA, PO, OM, INV, PA, FA, iProcurement, Service Contract, HRMS

Operating Systems: Windows/98/NT/00, Linux/UNIX

GUI: Forms Personalization, XML Publisher, Oracle Forms, Reports 10g, 11gWorkflows, Discoverer, OAF

Database: Oracle 10g, 11g, 12c, Greenplum

Languages: C, Java, PL/SQL

Tools: SQL* Loader, Toad, Jdeveloper, pgAdmin III

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Lead MARS GL Oracle ERP upgrade from 11i to 12.2.4. MARS is critical GE application, over 300 custom DB objects and 15 integrating systems
• EBS R12 Support - IT lead of critical MARS application which used over 900 business users with high volume TB feed. MARS is the consolidation Ledger application system for all the GE business. Businesses submits their trial balances to MARS though DXL, its validated and post into GL.
• Finance close digital automation - Solution Architect for the implementation of Finance Close digital project. This project process to automate the financial closing process entire GE applications with single platform
• R12 enhancements - Technical, Functional review and support

Confidential

Responsibilities:

• Worked as tech lead in R12 CCL project.
• Extensively worked on Finance and SCM implementation project for multi country rollout
• Involved in Business interaction, Requirement gathering, analysis at client location
• Lead CCL Oracle ERP upgrade from 12.1.3 to 12.2.4. CCL is complex ERP system, over 500 custom DB objects and 25 integrating systems

Confidential

Responsibilities:

• Worked as techno functional consultant in R12 development and support
• Extensively worked in multiple task of Oracle SCM, AP, GL, AR, Inventory and HRMS modules
• Involved in Business interaction, Requirement gathering, analysis at client location
• Supporting the technical and functional daily basis issues in challenging environment
• Involved in find out solutions for business on complex issues
• Worked as techno functional consultant in R12 upgrade
• Extensively worked in multiple task of Oracle AP, GL, SLA, PA, FA and HRMS modules
• Extensively worked in conversions (chart of accounts) of P2P modules
• Involved in Business interaction, Requirement gathering, analysis at client location
• Prepared the MD70, CV60 docs for Oracle R12 business suite solutions
• Worked on Retro fitment of AP, GL, SLA, PA, FA and HRMS custom scripts part of COA conversions

Confidential

Responsibilities:

• Played the technical SME in R12 upgrade
• Extensively worked as techno functional in Oracle GL, AP, AR, PO, OM and iProcurement modules
• Extensively worked in RICE components of P2P & O2C modules
• Involved in Business interaction, Requirement gathering, analysis at client location
• Prepared the functional and technical solution doc for Oracle business suite solutions
• Coordinated the end to end delivery of customer change requests
• Managed SLA for the development and testing of customer change requests
• Coordinated with multi-vendors at client location
• Developed the new Custom Forms, Reports, Conversions, Workflow, OAF
• Developed the new XML, Discoverer Reports
• Performed the tuning of PL/SQL queries
• Worked in Custom PLL and form personalization
• Developed the Oracle and discoverer reports for both existing and new functionality
• Prepared the MD50, MD70, BR100 docs

Confidential

Responsibilities:

• Played the techno-functional role in end to end R12 implementation project from 11i.
• Played the technical SME in Oracle application upgrade from 11.5.9 to 11.5.10
• Provided functional and technical subject matter expertise onO2C & P2P cycle modules
• Lead the technical team to complete the enhancements
• Managed the end to end project life cycle to deliver projects on time
• Involved in client interaction, requirements gathering and analysis at client side.
• Provided the L2, L3 support to business users in AP, AR and GL
• Developed the new Custom Forms, Packages, RDF, XML, Discoverer Reports, PLL, FP & WF
• Developed the new Design and developed the new custom User Setup automation process, a huge client requirement which saved 12 men work on daily basis
• Done the performance tuning of PL/SQL queries
• Developed the Interfaces, Oracle and discoverer reports for both existing and new functionality
• Prepared the MD50, MD70, CV60 docs
• Extensively involved in the Oracle Upgrade from 11.5.9 to 11.5.10

Confidential

Responsibilities:

• Developed the new RICE components in O2C & P2P cycle
• Done the customization in Oracle Workflow
• Done the enhancements in Oracle JSP pages
• Done the tuning in Forms, Reports and PL/SQL queries
• Developed the new discoverer reports
• Worked in custom PLL file
• Created the interfaces and reports for both existing and new functionality.
• Done the vendor management (Lead the Wipro team of 5 member)

Confidential

Responsibilities:

• Played the technical developer role in 11i implementation project.
• Developed the new custom forms & reports in p2p cycle and service contract module.
• Done the analysis of client requirements
• Developed custom report for contract module
• Written the Procedures/Functions, packages and Database triggers
• Done the tuning of Forms, Reports and PL/SQL queries
• Worked in custom PLL file
• Created the descriptive flexi fields on custom forms
• Created the interfaces and reports for both existing and new functionality
• Involved in registration/migration of concurrent programs, executables, Creation of Responsibilities, request groups, sets, menus, values sets, document sets, request sets, forms, Functions and printer types, printer styles in System Administration & AOL.

Confidential

Responsibilities:

• Developed the new forms & reports for Order Management, AP modules
• Done the analysis of client requirements
• Developed the custom report for Order Management, AP modules
• Written the Procedures/Functions, packages and Database triggers
• Done the tuning of Forms, Reports and PL/SQL queries
• Created the descriptive flexi fields on custom forms
• Have created the interfaces and reports for both existing and new functionality
• Involved in registration/migration of concurrent programs, executables, Creation of Responsibilities, request groups, sets, menus, values sets, document sets, request sets, forms, Functions and printer types, printer styles in System Administration & AOL.

Confidential

Responsibilities:

• Developed and maintained the different types of forms such as tool order request, tool order, time sheet, inspection, tool order status, etc.Developed the reports such as tool order process wise costing, machine center wise completed load analysis, pending tool order, standard load status, department wise tool order costing etc.
• Analyzed the requirement and problem of user, after analyzing developed the various Forms, Reports related to the requirements of this module.

Confidential

Responsibilities:

• Developed many Oracle forms such as Annual capacity enhancement, Extra shifts/Time assembly, Monthly capacity/Plan generation (assembly), Monthly capacity/Plan generation (in-house), Day wise production plan, Line loading plan, Product line mapping, Time study generation for Planning module.
• Developed many reports such as Day wise short list, Monthly short list, ICN short list, Production vs Actual plan (week wise), Raw material short list, Process wise short list, Component short list, Monthly plan value wise, Indent vs Plan vs Sale for Planning module.
• Developed many types of PL-SQL, procedure, function and data base triggers such as transfer of indent from marketing to PPC (Plan table).