Oracle Data

Manoj Kumar Verma

Phone: +1-408-***-****, Email: *********@*****.***

Oracle ERP Techno-functional Lead Consultant

EXPERIENCE SUMMARY:

Overall 16+ years of experience in Oracle Applications (R12/11i)/CLOUD working as a techno- functional consultant on Oracle Financials,, SCM, HRMS,iRec,iExpense,EAM (Enterprise Asset Management),Alerts, AOL modules in Technical areas of Solution Design, implementation, Development, Enhancement, Up gradation(from 11i to R12), Roll outs, Support and enhancement projects.

Oracle Certified Professional (OCP) and Oracle Payables Cloud certified professional.

Good onsite exposures depute on different global locations for assignments (Currently in US, worked in India, Canada, Philippines, Qatar, Bahrain, Kenya, and Middle East regions) and worked with global customers.

Worked in Data conversion from ERP Oracle apps to Cloud by using the FBDI. Transform the ERP data as per the business requirement and FBDI template and Load in Oracle Fusion.

Worked in BI and OTBI reporting in CLOUD after getting the business requirement.

Involved with Integration development team to provide the specification documents.

Involved in different stages of the project development life cycle such as requirement gathering, gap analysis, System Configuration and setup, Design, and Development, Unit Testing, Integration Testing, System Testing and User Acceptance Testing.

I also possess Project Management/Lead experience and have managed team across Technical and Non-Technical associates with aim of achieving business objectives from enterprise applications programs.

I've excellent knowledge of Oracle ERP Architecture & Concepts. I have demonstrated strategic leadership in various roles such as Project Manager, Techno Functional Lead, Business Analyst, and Technical Architect, Technical Consultant

Excellent knowledge in application development, production support activities including investigation, analysis, solution optimization, Query optimizations, performance tuning, and bug fix etc.

Good trouble-shooting and technical skills, persistence in problem solving. Proficient in understanding business processes / requirements and translating them into technical requirements.

I have worked on various domains like Insurance, Telecom, Airways, Manufacturing, Finance, Healthcare Mining, Oil and gas, solar energy.

Possess sound knowledge on various phases of software Development Life Cycle-Design, Analysis, Development, Implementation and Support.

Possess excellent problem solving, organizational, inter-personal, communication skills and proven self-starter capable of working on multiple Assignments.

Good technical experience in SQL, PL/SQL, XML/Oracle Reports, Forms, Interface designing, Oracle Discoverer Reports, APIs, SQL*Loader, Form personalization, Workflow, Custom.pll and worked in the functional flow of FIN/MFG/HRMS/EAM modules.

Worked in Concur, Vertex and some other applications.

Worked on complex integration between Oracle ERP to others.

Preparation of MD050 Design document, MD070 Technical document, MD0120 Deployment Document, TE020 Test plans, BP070 Business process, BR100 setup document etc. to ensure application functionality meets the user’s requirements.

Employment History:

Organization

Designation

Duration

Wipro Technologies

Oracle apps Techno functional Consultant

DEC-2009 to FEB-2021

Satyam Computer Services Ltd.

Sr. Oracle Apps Consultant

Mar 2008 – DEC-2009

Tata Consultancy Services

Asst System Engineer

Nov 2006 – Mar 2008

Sanmina-SCI,Chennai

Programmer Analyst

Nov 2005 - Sep 2006

AWC, Delhi

Technical Consultant

Jan 2004- Oct 2005

EDUCATION:

Master of Computer Applications from Kurukshetra University, Kurukshetra (CAMPUS).

B.Sc. from M.D. University, Rohtak.

TECHNICAL CERTIFICATIONS:

OCA (Oracle Certified Associates)

OCP (Oracle Certified Professional)

Oracle payables cloud certified professional

Done various oracles and oracle apps technical and functional internal training in my working companies.

TECHNICAL SKILLS:

ERP

Oracle Cloud BI/OTBI Reports, Cloud Data conversion by using FBDI, Oracle Apps R12 and 11i(Modules: GL,AP,AR,FA,CM,PO,OM,INV,OM,EAM(Enterprise Asset Management),HRMS,AOL,Alerts,iRec,iExpense),O2C,P2P Cycle,AGIS,FSG Reports

OS

Windows 98/2000/XP, UNIX

GUI

Developer 2K (Forms, Reports), Discoverer Publisher, Workflow

OTHER TOOLS

TOAD, PL/SQLDeveloper, SQL*LOADER, UTLfile, Putty,psftp,PVCS,Kintana,

Sarena, ITG, Remedy,WebADI

RDBMS

Oracle 8/ 8i/9i/10g/11i, MS-Access,

Languages

PL/SQL, C, C++, Pascal, Java.

WEB Tools

HTML

Projects accomplished In WIPRO:

Duration: Sep-2016 – till date

Client: Williams Energy, Tulsa, OK USA

Oracle ERP R12 Support and Enhancement & Cloud Project Implementation

My Role:

Working as an Oracle Apps Techno functional consultant and responsible for delivery of the enhancements on time and make sure to resolve the support tasks as per the SLA.

Fit gap analysis in Oracle enterprise resource planning (ERP) & Design and implement high level solutions of customization using Oracle ERP, Forms, Reports, PL/SQL, Workflow, XML Publisher, Unix Scripting and Oracle Applications Framework.

Design and implementation of ERP applications including an understanding of user-specific requirements, design solutions and implementation of customizations and brand-new applications using Oracle ERP tech stack.

Work with users and provide reporting and integration solutions of Oracle ERP applications

Lead the Oracle ERP CRP, UAT, SIT sessions and provide solutions for the issues found in CRP/UAT and SIT sessions

Design and implementation of data conversions and Reports, Interfaces, Conversions, Workflow and Enhancements (RICE components) in Oracle ERP applications

Responsible for analyzing & troubleshooting complex issues and implementing solutions. Work with peers, and business analysts to create project specification and determine implementation details

Maintain current applications which include bug fixes, feature enhancements and performance tuning

Worked on the development of interfaces and Customizing Oracle Reports touching various modules such as AR, AP, GL, PO, INV etc.

Involve in all customer meetings and responsible to find the new opportunity or project.

Organizing and presenting Daily and Weekly Status call with clients, Monthly operational review meetings, Business meetings with clients.

Assisting junior team members to resolve the support incident/tasks and providing solution design for the enhancements.

Ensuring that all the inbound/outbound interfaces with third party system running on time.

Worked on the development activities as part of issue resolution. Perform Unit Testing, Migrate to next environments, assist user testing and closing the tickets.

Prepare Technical Design Document (MD070), Functional Design Document (MD050), Conversion Document (CV060), Technical Test Document (MD0120) and Set up document (BR100).

Developed various reports, interfaces, conversion, workflow, form personalization, custom.pll, as the part of enhancement project by using oracle RDF, XML Publisher, PL/SQL.

Working in BI and OTBI reporting in different modules, developed few complex reports in Innovation management module.

Working in Data conversion for cloud by using the FBDI.Transform the ERP data as per the business requirement and FBDI template.

Working in Cloud Data conversions

Duration: Aug-2014 to Sep-2016

Client: Sun power Corporation, Austin, Texas USA

Oracle ERP R12 Support and Enhancement

My Role:

Working as a techno functional Consultant supporting day to day activities and assisting client in month/quarter end closing on time.

Designed to automate intercompany process between AR and AP by integrating with AGIS functionality to create the automatic intercompany invoices, Designed the custom logic to calculate the markup amount and create the separate line in the AP/AR.

Developed various reports and custom programs as the part of enhancement project by using oracle RDF, XML Publisher, PL/SQL.

Responsible for the assignment of work to the developers, testing the code and timely delivery of the same.

Code review, Peer review, Team building and Motivation.

Technical guidelines and training, Quality process check.

Responsible for getting resolution of technical and functional queries raised by the team

Incorporated new functionality Agents and Dealers using Form personalization and Customization for Order Entry form, Delivery form, Po Requisition and AR Invoice and Customer forms.

Trouble shooting root cause analyze, Rework and defect analyze

Extensively worked on form personalization on various modules.

Experienced in production support activities like ticketing, creating/maintaining SVN Repository for source control, Defect tracking tools Quality Center, share point etc.

Good trouble-shooting and technical skills, persistence in problem solving. Proficient in understanding business processes / requirements and translating them into technical requirements.

Expert in backend database development including designing, writing stored procedures, triggers for Oracle databases.

Worked on the custom payment programs to generate the payment file for the bank which goes to the bank server.

Rich experience in Data Conversions using Open interfaces and API’s and third party integrations.

Duration: Jan-2013 to Jul-2014

Client: Marsh & McLennan Companies, Toronto, Canada

Oracle Apps Upgrade from 11i to R12

My Role:

Techno functional project Lead at Onsite handling offshore technical team and Working with key business functional users.Currently handling 2 projects in the same account.

Providing technical support to offshore team and ensuring the delivery on time to client.

Understanding business processes and gathers requirements at client site. Involved in Issue discussion with client and provide the Technical Solution design to Team.

Responsible for Process Analysis, Mapping & Re-engineering the business requirements in providing technical solution to the team

Involved in Project Review / Status Report Meetings with client Managers.

Acting as a system subject matter expert for supporting business processes

Managing a fully integrated team to provide user support & further enhancements to business processes; Also ensures on-time delivery of all projects

Involved in the business analyst tasks like gathering requirements, designing solutions, designing customizations/extensions, testing solutions, generating test scripts, writing documentation, etc.

Involved in Project Planning activities with PM for Checkpoints (Milestones) & Time Estimates Involved in Negotiation with client for Change Request and Prepare risk and estimate

As the part of the project worked on all technical components like Forms, Reports, Interface, and Workflow etc.

Duration: OCT 2012 to DEC 2012

Client: GENPACT, Gurgaon India

Genpact HRMS Consolidation Project-Roll out

My Role:--

My role in this project as a Technical Lead

All the custom components involve interface changes, report changes, Oracle framework page personalization, Web ADI customization/development, AME for the approval while process of vacancy approval. Making the MD70 documents as per the country specific and following the oracle coding standard. Working for the HRMS different modules like Irec for US, Philippines and China Pole.

Duration: MAR 2012 to OCT 2012

Client: MAADEN, Saudi Arabia

Upgrade from 11i to R12

My Role:--

My role in this project as a Techno Functional Consultant

Involving in the up gradation activity from 11i to R12.Testing the reports in 11i and R12 then compare the data and fixed the issue if the data is not coming in R12, Changes the table in reports from 11i tables to R12 table.

Involving the interface testing if it is working fine in R12 environment and fixed the issue if it’s failing anywhere. Checking the forms and alerts in R12 environment.

Doing the enhancement in the reports and interfaces as per the user requirement.

Making the MD70 and following the oracle coding standard.

Duration: Dec 2011 to Feb 2012

Client: MAC Maaden Aluminum Company, Saudi Arabia

EAM and INV module rollout

My Role:--

Worked as Oracle Apps Technical Lead

Interacting with client and taking the requirement about the data loading and suggesting the templates for the interface the data from their system to oracle EAM.Prepared the interface to load the data like Asset group, Asset Activity, Assets, Meteres,Asset Attributes, Category Etc.

Provide the template to the user for the item loading, miscellaneous receipt and issue loading and make the Interface according to that.

Preparing the reports in EAM and Inventory which is in the scope of this project and doing the personalization to fill the limitation of oracle apps.

Making the MD70/MD120 and following the oracle coding standard.

Convert FSG reports to custom reports because data calculation was not achieved in FSG for Maaden Corporate Company.

Duration: Oct 2011 to Dec 2011

Client: Saleco, Saudi Arabia

Upgrade from 11i to R12

My Role:--

Worked as a Technical Lead

Involving in the up gradation activity from 11i to R12.Testing the reports in 11i and R12 then compare the data and fixed the issue if the data is not coming in R12, Changes the table in reports from 11i tables to R12 table.

Involving the interface testing if it is working fine in R12 environment and fixed the issue if its failing anywhere. Checking the forms and alerts in R12 environment.

Doing the enhancement in the reports and interfaces as per the user requirement.

Making the MD70 and following the oracle coding standard.

Duration: Apr 2010 to Sep 2011

Client: NASS Corporation, Bahrain

Oracle Apps R12 Implementation

My Role:--

Worked as a Technical Project Lead

Involved in interaction with client about the formats of the reports and developed Print Programs, Custom Reports, customize the oracle standard reports in FIN/MFG modules according to the business need.

Provide the master data templates to the user and suggested them to give data in proper manner. According to that developed interface for the Master Data Migration like Suppliers, Customers, Intercompany party (supplier as well as Customer), Items and Load all the data of 13 companies from legacy system to the ERP

Developed interface for open data migration like AP invoices, AR Transactions, FA Assets, On-Account Receipts, Miscellaneous issue, Miscellanies receipt, Purchase Orders and Load all the data of 13 companies from legacy system to the ERP and did reconciliation to run the standard report.

Worked on the complex form personalization, customization to fill the gap which is not provided by the Oracle apps standard Process.

Customizations were done according to the Oracle coding standards.

Prepared MD70 technical documentation with the help of functional specification.

Used DATALOAD and FNDLOAD.

Involved in the functional training given by functional to the client so have functional knowledge of FIN/SCM modules.

Fix the issues raised in Support phase.

Duration: Dec 2009 to Aug 2010

Client: Power Finance Corporation, Delhi, India

Oracle Apps R12 Implementation

My Role:--

My role in this project as a MODULE LEAD.

Involved in interaction with client about the formats of the reports and developed Print Programs, Custom Reports, customize the oracle standard reports in FIN/MFG modules according to the business need.

Worked on Inbound and outbound interface:

Vendor loading interface to load the vendor along with site, contact, bank into ERP from 7 different third party systems.

Employee interface to load the employee along with job and position from third party system.

Bank Outbound interface for ICICI and HDFC Bank to give the file from ERP system to Bank.

Vendor Outbound interface to give the file of vendor along with all information to the third party system.

Payment Outbound interface.

Worked on Oracle forms

Worked on Alerts and Trigger.

Customizations were done according to the Oracle coding standards.

Prepared MD70 technical documentation with the help of functional specification.

Nominate for the best Team Lead in Wipro annual function.

Projects accomplished In Mahindra Satyam Services:

Duration: Sep 2009 to Nov 2009

Client: Kenya-Airways, Nairobi, Kenya

Oracle Apps R12 Support and Enhancement

My Role:--

My role in this project as a Techno-functional consultant.

The issue fixing in different interface, RDF reports, discoverer reports which were developed while implementation.

Enhancement/customization/Development done in reports, interfaces and pl/sql procedures as suggested by the business users.

Understand the business needs and made changes in the interface and the reports.

Customizations were done according to the Oracle coding standards.

Duration: Mar 2009 to Sep 2009

Client: Qatar Telecom, Doha, Qatar

Oracle Apps 11i Implementation

My Role:--

My role in this project as a Technical Lead.

Preparing the technical documentation with the help of functional specification.

Enhancement and customization done in reports, interfaces, forms and pl/sql procedures.

Managed, this includes understanding the functional/technical documents and assigning task.

Designing and developing request set and Alerts.

Testing the code.

Registered concurrent programs and concurrent program sets using Application Developer

Designed custom table’s to enhance the functionality of the application.

Customizations were done according to the Oracle coding standards

Worked on Enhancements and resolve Issues/Bug fixes.

Worked on the oracle apps standard reports standard purchase order, blanket purchase Agreement, Blanket release. In these reports, made the changes in xsl file as per client requirement.

Worked on periodic and event alerts.

Customized D2K Bank software reports and form according to the client requirement.

Knowledge of DATALOAD and FNDLOAD.

Duration: May 2008 to Mar 2009

Client: Colt Telecom, Gurgaon, India

Oracle Apps 11i Support and Enhancements

My Role:--

My role in this project as a techno functional

Worked in different finance (GL, AP.AR), PO, projects modules. Developed various discoverer reports and customization of the discoverer report as per business requirement. Customization of the RDF reports and bug fixing in the reports. Support production and handled escalations during the month end closing. Resolved the technical and functional issues as per business requirement and did enhancement work in interfaces, Discoverer reports, RDF reports.

AIM: Made MD50 and MD70 for discoverer reports and RDF reports and did some changes in the MD documents in case of any report change.

Worked in SQL and PL/SQL to support business and provide the data which is critical for the month end closing.

Handling the day to day tickets which come in Remedy and solving ITSRs.

Extract the data from the oracle apps as per business requirement while month end closing.

Handled functional issue related to AP, AR, GL, PO modules.

Projects accomplished In TCS, Bangalore (client: GE Health Care):

Duration: Nov 2006 to Mar 2008

Client: GE Healthcare, USA

Oracle Apps 11i Support and Enhancements

My Role:

My role in this project is as one of the key Techno Functional Consultants

We receive the daily jobs by monitoring a Tool called Clarify and then work on these Cases.

We also monitor the daily scheduled tools on an application called AppWorx.

AP (Accounts Payables), AR (Accounts Receivables), GL (General Ledger) and PO basics

Customized Oracle Finance Reports, Payments and Settlements through the Customized processes

Customized Billing and Transaction Settlement systems

AP invoice and PO matching (Front end and backend transactions)

Handling the functional issues on AP, GL, AR.

Working on different AIM methodology

I am also working on FMEA (Fault Maintenance and Effect Assessment) processes for different interfaces being used by our Clients.

Working on different interfaces. IBS-AP, IBS-AP, IBS-AP, IBS-AP, IBS-AP, GL Interface, Auto lockbox.

Projects accomplished In Sanmina-SCI:

Duration: Nov 2005 to Sep 2006

Client: Sanmina-SCI, Chennai, India

Oracle Apps 11i Support and Enhancements

My Role:

My role in this project as a Programmer Analyst.

Created the template for finance and manufacturing responsibilities by using the tool KINTANA and migrate the same from a test instance to the production using KINTANA.

Wrote the pl/sql script to rename the Responsibilities, change the responsibility key and Description. Set organization access and profile option values by using the Pl/Sql script.

Creating and maintaining generic accounts based on Company’s approval process and procedures.

Finance/Manufacturing/IT/HR/eCOMPRAS responsibilities creation, org access assignment and profile setup for new orgs in OSP instances and production instances.

Creating Request groups and Menus in OSP instances and production instances as per CCR and WR.

Supply Chain Information Transfer Standard (SCITS) is outbound interface developed to extract data for SANMINA-SCI plants supporting HSCITS. SANMINA_SCI automatically transmits the following information on a daily basis, to HSCITS.

Here my role to check whether these following data is transferring properly or not, if an issue then solve that issue by some coding changes or some updation command using TOAD.

SFDC and Oracle Enterprise are integrated together at the level of work order creation and completed WIP moves. Oracle SFDC interface process has been developed to 11.03 and 11i versions in response to the different business practices of plants and Oracle apps versions.

Here my role is to solve the issues related to this like Receiving Issue, WIP Entry Issue, EDI Issue, Item prefix, setup issue, Interface Issue.

Projects accomplished In AWC:

Duration: Feb 2004 to Oct 2005

Client: AWC, Faridabad, India

Oracle Apps 11i Support and Enhancements

My Role:

Worked as a technical consultant

Migration Activity: Migration Activity includes:

Vendor Master Migration Open Invoice Migrations, On Hand Migrations

Reports Migrations: Migration of Reports from lower Version to Higher versions

Object Migrations: Migration of Custom Tables in corresponding schema, Migration of Custom Procedures

SQL*Loader Activity: Transfer data from CSV files and fixed width files to temp tables, Wrote Control Files.

Custom.pll: Customized forms using Custom.pll,Customization like enabling and disabling field, making field required is done by Custom.pll

Reports Developments: Design and Development of custom components to meet the business requirements and integrate them with Oracle Applications.

GL Interface: Developed Scripts for GL Interface. Transfer Journal data from CSV file to Temporary tables with the help of SQL*Loader.

AP Interface

Documentations: Documentation of Custom Programs using AIM Methodology (MD 70).

Documentation of Custom Programs: Migration Activity includes,

Customization of Forms Wrote Various PL/SQL Procedures and registered in Apps.

Knowledge of Basic flow of financials.

Alerts Design: Developed Periodic and Event Alerts and send notification to the user.

Customization of Reports.

Auto Lockbox Interface

Loaded Invoices in AR with the help of Auto Invoice Interface.

MULTI_ORG Concepts: Familiar of Multi_org Concepts

Contact this candidate