SUMMARY:

• Rich experience of Consulting, Project Management, Client Management and Resource Management gained by 5+ full project lifecycles.
• Worked in delivery of multiple IT Projects and got associated with discrete aspects of the life - cycle of the project from inception to completion. Apt in Organizing, planning, directing, and coordinating the overall program effort.
• Domain expertise of Oracle Cloud ERP (Oracle Fusion) / Oracle Applications (E-Business Suite) with specialization in Financial Accounting Hub, Oracle Financials (General Ledger, Fixed Assets, Payables, Receivables etc.), Master Data Management (Product Data Hub, Customer Data Hub) and EBS Supply Chain Management modules like Order Management, Shipping, Inventory and Procurement etc.
• 11+ years of work experience in application development, customization, integration and configuration of various modules of Oracle Applications. Worked as a technical developer, technical lead and also worked as a part of functional team.
• Worked both at offshore and onshore for various clients of different industry sector to implement/support the ERP application or business process optimization.
• An effective communicator with excellent relationship building & interpersonal skills. Strong analytical, problem solving & organizational abilities.
• Expertise in managing different project implementation methodology viz AIM, Agile, Momentum and Hybrid.
• Hands-on experience in Oracle Cloud SaaS technologies like SOAP and REST Webservices, OTBI, FRS Reports, Smart View, BI Publisher. Also PaaS solutions like OIC, ODICS, DBCS as well as OACS, integration of PBCS, PCMCS to Oracle Cloud ERP.
• Hands-on experience in Oracle EBS Technologies like SQL, PL/SQL, SQL Developer, Toad, SQL*plus, SQL Loader, Oracle Reports, Oracle Forms, XML Gateway, XML/BI Publisher, Discoverer, Workflow Builder, ADF, Web ADI, FNDLOAD, TkProf, Flexdeploy and Shell scripting etc.

TECHNICAL PROFICIENCY:

Domains: Oracle ERP Applications Oracle ERP Cloud, Oracle E-Business Suite

ERP Modules Financials: Financial Accounting Hub, General Ledger, Receivables, Payables, Cash Management and Fixed Assets

Supply Chain Management: Order Management, Shipping Execution, Inventory, Purchasing, BOM, WIP and Advanced Pricing including India Localization

Project Accounting: Project Costing and Project Billing

Oracle Cloud Technologies: SOAP and REST Webservices, OTBI, FRS Reports, Smart View, BI Publisher. PaaS solutions using OIC, ODICS, DBCS as well as OACS, integrating PBCS, PCMCS to Oracle Cloud ERP.

Oracle EBS Technologies: Oracle Reports 9i, XML/BI Publisher, SQL Developer 1.5, Toad, SQL loader, Utl file, TkProf, Forms 10g etc.

Database: Oracle 9i, 10g. 11g

WORK EXPERIENCE:

Confidential, Dallas, Texas

Environment: Oracle Cloud Financials R13 (19B/19C), Informatica Data Management and other systems

Onsite Technical Lead

Responsibilities:

• Manage the team of highly skilled consultants of different tracks, assign work packets, to help resolve all issues and conflicts within team.
• Conduct/participate business requirement discussions with client’s business and IT team, define scope, document and perform feasibility study, time and effort estimation of new development requirements.
• Perform daily reporting to all stakeholders, closely monitor development progress and project timelines to ensure business requirements are delivered on time and with good quality.
• Work closely with all the functional track owners, work on proof of concepts (POCs) to finalize the approach and speed up the development.
• Helping client’s internal IT and ETL team and IT vendors to complete the development for the overall program.
• Prepare various technology related playbooks like Integration Strategy, Conversion Strategy, Instance Management etc.
• Review code and documents as per the client’s development standards.
• Also worked on documentation design and development of reports (BIP, OTBI, FRS and SmartView) and interfaces (using BIP, SOAP WebServices) whenever needed.

Confidential

Environment: Oracle Applications R12 (12.2.5), Oracle DB 11g and other systems

Offshore Technical Lead

Responsibilities:

• Leading a track of data integrations and oracle reports track to design and develop the custom business reports.
• Design and development of various complex integrations with third party systems and B2B integrations with suppliers.
• Design and development of enhancement objects for Oracle Procurement, Enterprise Asset Management and Oracle Inventory modules.
• Review code and documents as per the client s development standards.
• Have worked on various proof of concepts (POCs) on proposed business solutions which helped to finalize the approach.

Confidential

Environment: Oracle Applications R12 (12.2.5), Oracle DB 11g

Offshore Technical Lead

Responsibilities:

• Worked on design and development of data conversions for Oracle Inventory and Bills of Material and Oracle Trade Management modules.
• Performed conversion execution on various test cycles.
• Have worked on various proof of concepts (POCs) on proposed business solutions which helped to finalize the approach.
• Learned new module ‘Oracle Trade Management/Channel Revenue Management’.
• I was part of document review group to review technical and functional documents?
• Managed Performance tuning of Queries of programs. Worked on various critical service requests with Oracle Development team.

Confidential

Environment: Oracle Applications R12 (12.2), Oracle DB 11g

Offshore Technical Lead

Responsibilities:

• Worked on design and development of data conversions for Oracle Inventory and WMS modules.
• Designed end to end solution for various extensions.
• Learned Demantra and worked on integration from EBS to Demantra.
• Have done various proof of concepts (POCs) on proposed business solutions which helped to finalize the approach.
• Developed a custom framework for error handling and reporting which is used across tracks.
• Was part of document review group to review technical and functional documents?
• Guided and monitored junior members in the project.

Confidential

Environment: Oracle Product Data Hub R12 (12.2.4), Oracle DB 12g, Informatica Data Quality

Team Lead / Consultant

Responsibilities:

• Worked as Track Lead for Product Data Hub (MDM) and lead a team of 2 - 3 consultants.
• Worked on design and development of all the critical data conversions for PDH like Items, Items UDA, Item Cross, Related Items, Item Category Assignment, Item Attachments and Bills of Material.
• Designed end to end solution for various Inbound and Outbound interfaces between PDH (MDM) and third-party systems.
• Worked with multiple integrations team of different technologies - ETL, ESB etc.
• Developed few accelerators to speed up PDH configurations like PIM Attribute Group setup, Category master data etc.
• Have discussed and proposed business solutions to the onshore team and helped functional team on PDH standard configurations.
• Developed a custom framework for error handling and reporting which is used across tracks.
• Drive various critical meetings and calls.
• Was part of document review group to review technical and functional documents?
• Guided and monitored junior members in the project.
• Have done performance tuning of Queries of programs.
• Prepared various functional and technical documents as per AIM methodology.

Confidential

Environment: Oracle Applications R12 (12.1.3), Oracle DB 11g, OBIEE, Hyperion

Team Lead / Consultant

Responsibilities:

• Worked as Track Lead for Master Data Management (MDM) and lead a team of 4 consultants.
• Worked on many critical extensions of master data structure of business - like Area, Territory, Store, Property etc.
• Worked on various critical data conversions like HR Locations, AP Invoices, COA mapping, Customers, Suppliers, Chart of Accounts etc.
• Worked on retrofitting the existing client s extension to be used for Japan.
• Developed a custom framework for error handling and reporting which is used across tracks.
• Worked closely with client during onshore tenure. Have discussed business required and offered feasible end to end solutions to it.
• Arranged client meetings and calls with leadership.
• Was part of document review group to review technical and functional documents?
• Guided and monitored some junior members in the project.
• Managed Performance tuning of Queries of programs.
• Prepared various functional and technical documents following AIM methodology.

Confidential, San Jose, California

Environment: Oracle Applications R12 (12.1.3), Oracle DB 11g, Discoverer 11g

Team Lead / SCM Techno-Functional Consultant

Responsibilities:

• Review codes and documents of my technical team and assigning the tasks.
• Support for the production issues related to SCM (O2C, P2P, INV),
• Working as a prime technical consultant for Project Costing and Billing technical objects.
• Work on various change requests and new developments as per the daily business need.
• Develop many Discoverer Reports.
• Develop and enhance various Oracle Reports and XML Reports.
• Enhance existing customized forms and develop new custom forms.
• Interface design both inbound and outbound from other systems.
• Performance tuning of Queries of various reports.
• Prepare High and Detail level functional cum technical documents.

Confidential

Environment: Oracle Applications R12 (12.0.4 & 12.1.3), Oracle DB 10g/11g

SCM Techno-Functional Consultant / Technical Consultant

Responsibilities:

• Support for all the production issues related to O2C, INV, AR, AP, GL and Advanced Pricing including India Localization.
• Work on various change requests and new developments as per the daily business need.
• Worked on many data conversion from the legacy systems.
• Develop many custom AR Credit/Debit Note programs based on the business requirements.
• Develop and enhance various Oracle Reports and XML Reports.
• Enhance existing customized forms and develop new custom forms.
• Various Interface design both inbound and outbound from other systems.
• Performance tuning of Queries of various programs, forms and reports.
• Prepare High and Detail level functional cum technical documents.
• Review codes and documents written by teammates.
• Performing Sysadmin and Application Developer activities.

Confidential, Waltham, MA

Environment: Oracle Applications R12 (12.0.4), Oracle DB 10g

Technical Consultant

Responsibilities:

• Support for the production issues related Project Accounting (Project Costing and Billing), Receivables, Cash Management etc.
• Worked on few inbound interfaces of Project Costing and Billing modules.
• Performance tuning and modifications in interfaces on Oracle Projects module and other financial modules like CM, GL etc.
• Modify and customize Custom Reports using XML Publisher and Reports 9i.
• Prepare Custom UNIX Patches for each object to test in Test instances and finally in Production.
• Reviewed codes and documents written by teammates.

Confidential, Waltham, MA

Environment: Oracle Applications R12 (12.0.4), Oracle DB 10g, Data Migration from Legacy Systems

Technical Consultant

Responsibilities:

• Worked on various interfaces and conversions of Oracle Project Accounting (Project Costing and Billing) which includes Projects, Tasks, Project Customers, Classifications, Budgets, Agreements, Funding, Expenditures etc.
• Data conversions and interfaces through PL/SQL code on Oracle Projects module and other financial modules like CM and GL etc.
• Design and develop Custom Reports using XML Publisher and Reports 9i.
• Prepare Custom UNIX Patches for each object.
• Created AOL Objects like Programs, Value Sets, DFFs and Request Groups etc. and moved them into new instance by Unix patches.
• Done performance tuning of PL/SQL scripts.
• Prepared Technical Analysis and Design Documents like CV200 and MD 70.
• Migrate setups between instances using data loader.