Summary

• Around 9 years of rich IT experience in developing cost effective solutions as Techno-Functional Consultant using Oracle PL/SQL, Oracle Applications and related technologies Including Implementations, Upgrades, Data Conversions, Interfaces, and Customizations.
• Extensive experience in using SQL, PL/SQL, Developer 2000/6i/9i, SQL Loader, Workflow2.6, Oracle 10g, UNIX and Shell Scripts and Oracle Applications Financials, Manufacturing and Sales Distribution modules .
• Sound techno functional knowledge in the business processes such as Financial, Order to Cash O2C , Procure to Pay P2P of Oracle EBS 11i and R12 in the modules GL, AP, IEX, AGIS, CM, FA, IBY Payments, AR, TCA, INV, PO, OM, AOL and SysAdmin.
• Extensively worked on life cycle implementations using oracle applications R12 and 11.5.10.
• Hands on experience in development and extension RICE components using SQL and PL/SQL, Customization of forms using CUSTOM.pll, reports using Report builder 6i, XML Publisher and exposure to WF and OAF.
• Extensive knowledge in working with the tools like TOAD and SQL Loader.
• Expertise in technical components Conversions, Reports, Interfaces, Extensions, Forms personalization.
• Strong experience in Data Conversions and Design/Development of Interfaces using Oracle open interfaces and Oracle Public API's.
• Designed and developed various payment formats like PAM and SEPA as per client need.
• Expertise in Design and Development of interfaces and conversion programs with respect to financial modules to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL Loader etc.
• Proficient in creating functional and technical specifications as well as test plans and test scenarios using AIM methodology and documents such as BR 100, MD 50, MD 70, TE20, TE 40 and MD 120.
• Excellent Data Migration experience from Legacy systems using PL/SQL, Oracle API and Oracle Open Interfaces
• Expertise in client engagements and technical support.
• Lead a team of 15 successfully as Team Lead/Senior Developer in major full cycle implementations and end-to-end business support projects within the assigned time, cost and quality parameters
• Providing standardized and global solutions to specific, segregated and customized business processes, performing feasibility analysis, impact analysis, RCAs, proof of concepts for complex business problems and issues
• Strong analytical and trouble-shooting skills, excellent communication and interpersonal skills, self-motivated, quick learner, and team player.
• Attended in house training on BIG DATA technologies.

Technical Summary:

Professional Experience

Senior Oracle EBS Techno

Confidential

• Worked on Project Maintenance form customizations and personalization changes
• Worked on Receivables, Payables related SLA Custom Sources for Fund type, apportionment category, based on Revenue distribution lines, Expenditure item and customer agreements.
• Participated in the design discussions of the project, contributing to deliverables like to-be process flows.
• Techno-functional consultant for reporting and interfaces of Oracle EBS in AR, AP and SLA modules.
• Worked on Re-class functionality to reconcile the payments across NIH systems.
• Worked on 11i Payment formats enhancements as per new PAM Payment formats implementing from Oct 1st 2014.
• The key facets and achievements in this project as a Senior Oracle EBS Techno Functional Consultant are as follows:
• Re-implement the Oracle Financials Modules on to R12.2.3 instance.
• Support of Oracle Applications 11.5.10
• Involved in the development of the several customization which includes analysis, design, development, testing and implementation of Oracle ERP solution.
• Interacting with client, analysing CEMLI requirements, impact analysis, and implementation of the same. Preparing MD70 from MD50 provided by Business creating TE20 and testing the changes and implementing the same in Test environment production.
• Also responsible for Migrations of the technical objects from Development instance to other testing instances and production using the migration tools such as putty, HP PPM and SVN.

Environment:

Windows and UNIX, Oracle Applications 11i and R12.2.3, Oracle Database 11g SQL and PL/SQL , Oracle Forms/ Reports Developer 10g, Putty, Toad, SQL Developer, SVN, JDeveloper, SQL Loader and XML Publisher tools.

Senior Oracle EBS Developer

Confidential

Confidential is a Finnish oil refining and marketing company producing mainly transportation fuels and other refined petroleum products. Neste Oil has three business areas: oil products, oil retail and renewable fuels. It produces, refines and markets oil products and shipping and engineering services, as well as licensing production technologies.Infosys was assigned to re-implement the Oracle Applications several financial modules AP, AR, FA, GL, IEX, CM, Ebtax and AGIS . Client was using Oracle E-Business Suite financial modules on 11.5.10 and moved to R12.1.3 globally for all entities.

The key goals of this project are:

• Re-implement the Oracle Financials Modules on to R12.1.3 instance for all entities of Neste Oil
• Designed and developed alerts, interface reconciliation reports forwarding the Interface errors.
• Designed and developed new interfaces for AGS and IEX modules to automate the process.
• Designed format validation and custom validation program before loading data into interface tables.
• Forms extensions in Oracle Financials AR, AP, GL, IEX, AGIS, CM, FA and Ebtax .
• Designed and Developed Custom Pl/SQL programs, Host scripts, SQL Loader scripts, Reports,
• The key facets and achievements in this project as a Senior Oracle EBS Developer Consultant are as follows:
• Pilot solution to be implemented for selective entities and same solution to be rollout across all geographies.
• Standardize the financial business process across the geographies and legal entities
• Design and development of RICE Components
• Extensive design and developments of custom PL/SQL programs for Interfaces and Conversions for Oracle financial modules.
• Developed Customer Collection Process Dunning Letters customization.
• Code enhancements and lookup definition to cater the needs of new product line.
• Designed and Developed shell script and SQL loader program to load the data into staging tables.
• Enhanced interface setups for transferring the files to respective trading partners.
• Anchor proof of concept development to validate proposed solution and reduce technical risk.
• Converted various custom RDF reports to XML reports.
• Involved in Forms Extensions and Personalization as per the business requirements.
• Using Oracle reports and XML publisher.
• Developed various Custom reports on the basis of business requirements used for month end closing
• Followed AIMS template MD050, MD070, BR100 etc to manage Project Documentations.
• Advanced PL/SQL development in financial system specific to the client.
• Developed outbound interfaces as part of collection process as per business requirements.
• Prepare estimates, release plan and road map for future releases and participate in cut over activities
• during every roll out.
• Supporting multiple R12 EBS application, monitor, analyze, resolve support tickets, provide weekly
• Status report and manage customer expectation.

Environment :

Oracle EBS R12.1.3, Developer 2000 Forms 6i/10G, Reports 6i , TOAD, SQL Loader

Achievements:

• Recognition by Neste Oil CEO for Successful Pilot entities Go-live and solution/Technical design for Global Roll-outs.
• Recognized and won Most Valuable Player MVP award and Bravo award for an exceptional work done in Pilot entities implementation and during the Global Roll-outs.
• Best Team recognition in the Oracle Practice.

Senior Oracle EBS Techno-Functional Consultant

Confidential

• The key facets and achievements in this project as Techno-Functional Consultant were as follows:
• Developed BI Publisher Reports and Check Printing reports.
• Designed and developed custom PL/SQL programs, SQL Loader scripts, XML Reports in AR, AP and GL.
• Implemented Bills of Materials BOM interface using open interface tables by doing necessary validations.
• Developed customized reports like Invoice print and various other reports in Inventory module as per client needs.
• Converted various oracle reports to xml publisher reports in BOM and WIP modules.
• Developed Oracle Alerts, Workflows.
• Handled components of Oracle Application Frame work OA Frame Work personalization like VO, CO, AM, EO extensions, Page extensions.
• Migrating the OAF extended objects from one instance to other instance.
• Followed AIMS template MD050, MD070, BR100 etc to manage Project Documentations.
• Performance Tuning of custom programs.
• Involved in Forms Extensions and Personalization as per the business requirements.
• Converted various custom RDF reports to XML reports.
• Worked on various enhancements using form personalization.
• Developed test plan, test scenarios and executed user-acceptance test cases and ensured proper cutover plan successful Go-Live.

Environment :

• Oracle EBS R12, Developer 2000 Forms 6i, Reports 6i , TOAD, XML Publisher Oracle OAF And Oracle Workflows.

Oracle EBS Techno-Functional Project Lead

Confidential

Confidential is a rapidly growing global Financial Services organization, Confidential is running the global FAST program to address the needs for standardizing and improving its process and technology frameworks that will help them with process improvements and accomplish complete finance transformation. The project is to implement a multi-country rollout to provide a Finance transformation framework for Newedge with Financial Accounting Hub, Thin GL, and Supporting Reference with appropriate application Architecture to help process high volumes and with a Financial Industry focused reporting solution using the full suite of products.

Responsibilities:

• Developed BI Publisher Reports and Check Printing reports.
• Designed customizations, interface/conversion mapping document.
• Developed Currency Rate Interface.
• Designed and developed staging tables, conversion routines, custom PL/SQL on AP, AR Lockbox .
• Worked on FSG report generations for financial reports.
• Worked on migration of FSG using data links.
• Extensive involvement in design, development, Unit Testing, UAT and Regression Testing.
• Creation of LDT files to load Executables, Concurrent Programs and Request sets.
• Preparation of MD65, MD70 Documents.
• forms in Oracle Application R12, Discoverer Reporting, UNIX shell scripts
• Involved in the maintenance, enhancements and new development of Registration of Reports and
• Designed XML publisher reports. These are configured to generate output in PDF formats
• Customized various RDF reports as per the business requirements.
• Using FNDLOAD utility for transferring Concurrent Programs, Request Sets, Value Sets and Request Groups from one Instance to another Instance.
• Performance Tuning of custom programs.
• Mentoring the team on BI Publisher reports.
• Got trained in OBIEE.

Environment :

Oracle EBS R12, Developer 2000 Forms 6i, Reports 6i , TOAD, XML Publisher