EXPERIENCE SUMMARY:

• Overall 15+ years of experience in Oracle Applications (R12/11i) including 10 years of Onsite experience across globe (Asia, Middle East, Africa, Canada, United States) with multiple customers. My role is mostly on customer facing.
• Currently at Onsite in US working with Wipro as Oracle ERP Techno - functional for one of the customer and responsible for support and enhancements deliverables for Oracle Tower.
• 15+ years worked in different role as per project need as a Technical/Techno functional/Oracle Lead/Manager in Oracle Applications (R12/11i) on Oracle Financials, Distributions, 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 and worked with global customers.
• 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 possess Project Management/Lead/Consultant 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've demonstrated strategic leadership in various roles such as Project Manager, Techno Functional Lead, Business Analyst, and Technical Architect.
• 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 Data conversion for cloud by using the FBDI.Transform the ERP data as per the business requirement and FBDI template.
• 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.

TECHNICAL SKILLS:

ERP: 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,XML Publisher, Workflow

OTHER TOOLS: TOAD,PL/SQLDeveloper,SQL*LOADER,UTLfile,Putty,psftp,PVCS,KintanaSarena,ITG,Remedy,WebADI

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

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

WEB Tools: HTML

PROFESSIONAL EXPERIENCE:

Confidential, Tulsa, OK

Oracle Apps Techno functional

Responsibilities:

• 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.
• As a team lead, assisting 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.
• 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 Data conversion for cloud by using the FBDI.Transform the ERP data as per the business requirement and FBDI template.

Confidential, Austin, Texas

Techno functional Consultant

Responsibilities:

• 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.

Confidential

Techno functional project Lead

Responsibilities:

• 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.

Confidential

Technical Lead

Responsibilities:

• 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.

Confidential

Techno Functional Consultant

Responsibilities:

• 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.

Confidential

Oracle Apps Technical Lead

Responsibilities:

• 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 Confidential Corporate Company.

Confidential

Technical Lead

Responsibilities:

• 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.

Confidential

Technical Project Lead

Responsibilities:

• 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.

Confidential

MODULE LEAD

Responsibilities:

• 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.

Confidential

Techno-functional consultant

Responsibilities:

• 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.

Confidential

Technical Lead

Responsibilities:

• 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.

Confidential

Techno functional

Responsibilities:

• 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.