SUMMARY

• Around 12 years of total software experience in Information Technology Industry. As part of his assignments, he has been in working as a Sr.
• Technical Consultant in Oracle EBS development, implementation, support, enhancements and upgrade Oracle E - Business Suite.
• Expert in Developing, Customizing, Maintaining and Supporting Oracle Applications EBS versions R12/11i/Cloud using Forms, Reports, PL/SQL, XML Publisher, Workflow and Oracle DB 10g/11g, OTBI.
• Techno Functional expertise in modules like AP, GL, SLA, AR, PO, Payments, TCA HZ, FND, AOL.
• Hands on in End-to-End Oracle E-Business Suite (R12) Implementation and Support experience.
• Extensively experienced in development, testing, and data migration/validation, loading data from legacy system to target system.
• Good understanding of Application Object Library (AOL) to manage concurrent managers, application user setup, defining responsibilities, forms, reports and concurrent programs.
• Proficient in developing RICE (Reports, Interfaces, Conversions & Extensions) components.
• Fair knowledge in designing Relational Data Structures, writing Stored Procedures, Packages and Functions using SQL and PL/SQL.
• Excellent learning skills and ability to adapt quickly to rapidly changing/new technologies.
• Ready to take the challenges with a positive attitude and dedication towards the task in hand.
• Strong analytical, problem solving, communication and presentation skills.
• Experience in handling a team of 4-5 developers.
• ITIL Foundation certified.
• Experience in various industry vertical like Technology, Banking, Travel & Hospitality and Retail.

TECHNICAL SKILLS

Oracle ERP: Oracle Applications E-Business Suite R12 - AP, AR, GL, SLA, Payments, PO, TCA, FND, AOL, CM, FA

Tools: PlSql, Toad, Sql Developer, PL/SQL Developer, Oracle Forms, Oracle Reports, Oracle Workflow, XML/BI Publisher, Web ADI, SVN, Win CVS, Mercury ITG Kintana,, Perforce, Advanced Queue, Autosys

Servers: Oracle Applications Server

Databases: Oracle 10g/11g

OS: Windows, Linux

PROFESSIONAL EXPERIENCE

Confidential

Application Developer

Responsibilities:

• I am responsible understanding the current logic of Dual Post and Recon and propose changes as the feed would be generated from Oracle Cloud rather than from FGI (current EBS 11i system).
• Understanding how the various steps in the entire process work together.
• Understanding the MView refreshes of the FDW data ware house and it would be impacted with the Cloud upgrade.
• POC activities in PlSql on the outbound feeds that were generated from FDW.
• Working on the technical high-level design specs.

Confidential

Senior Associate

Responsibilities:

• I was responsible for supporting the EBS Finance modules.
• Handling and resolving the issues related to the day-to-day transactions in OM & AR.
• Providing support during the Month End activities and ensuring smooth closing of the period.
• Analyzing and providing solutions for complex issues faced by the business users.
• Taking care of functional and technical requirements by interacting closely with business users, analyzing change requests, doing impact analysis and incorporate the new enhancements in the current application.

Confidential

Oracle ERP Techno-Functional Consultant

Responsibilities:

• I was responsible for supporting the EBS Finance modules and the custom integrations with LRM.
• Handling and resolving the issues related to the day-to-day transactions in AP/AR/GL.
• Responsible for doing setups in EBS for integrating 3 divisions from legacy LRM system with EBS.
• Expertise on designing and implementing Oracle Alerts and Lookups and profile options.
• Interfacing AP Invoices and GL Interfaces, and fixing interfaced invoice related bugs.
• Custom reports development, enhancement and fixing existing report issues.
• Resolving various integration interfacing issues.
• Developed new Concurrent Programs, Custom Forms and Flex Field Customizations.
• Providing support during the Month End activities and ensuring smooth closing of the period.
• Analyzing and providing solutions for complex issues faced by the business users.
• Taking care of functional and technical requirements by interacting closely with business users and incorporate the new enhancements in the current application.
• Interacting with Business Users, analyzing change requests, impact analysis, and implementation of the same.

Confidential

Oracle ERP Techno-Functional Consultant

Responsibilities:

• I was responsible for supporting the EBS Finance modules like AP and GL.
• Analyzing and providing solutions for complex issues faced by the business users.
• Taking care of functional and technical requirements by interacting closely with business users and incorporate the new enhancements in the current application.
• Interacting with Business Users, analyzing change requests, impact analysis, and implementation of the same.
• Presented and participated in CCB meetings for getting approval for various changes that needed to be migrated to Production based on the support tickets priority.
• Handling and resolving the issues related to the day-to-day transactions in AP/AR/GL.
• Providing support during the Month End activities and ensuring smooth closing of the period.

Confidential

Oracle ERP Techno-Functional Consultant

Responsibilities:

• Complete ownership of multiple Oracle Financials modules like AP, AR, SLA, GL, CM and FA.
• Interaction with EBS business users and cross functional teams during Requirement gathering phase.
• I was also involved providing an extract of open AP/AR invoices/transactions from Oracle EBS to SAP.
• Performing the impact analysis of enhancements and change requests and implementing the same.
• Imported data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc.
• Providing support during the Month End closing activities and ensuring the smooth closing of the GL period.
• Actively participated in the code migration activity creating packages using HP PPM tool and defining dependency between them.
• Performance testing of the newly developed component.

Confidential

Oracle ERP Techno-Functional Consultant

Responsibilities:

• Interaction with business users and functional teams during requirement gathering and finalizing the business needs.
• Performing the impact analysis of enhancements and change requests and implementing the same.
• Preparation the technical specification for the custom modules like Revstream, Praxis, SPP etc.
• Development of various program components including SQL scripts and PL/SQL programming for Interface Engine and custom financial module.
• Migration of setups/custom objects into the Production Environment.
• Co-ordinate with QA team in testing activity (System Test, Smoke Test, UAT and Regression testing).
• Coordinated with Quality Assurance team with the preparation of test case scenarios by giving them all possible scenarios that can be encountered during the program execution, thereby assuring good quality of the deliverables.

Confidential

Oracle ERP Techno-Functional Consultant

Responsibilities:

• I was responsible for supporting the EBS Finance modules like AP, AR and GL thereby handling critical live production issues for a renowned telecom/network client.
• Designing and implementing new enhancements in the project.
• Analyzing and providing solutions for complex issues faced by the business users.
• Taking care of functional and technical requirements by interacting closely with business users and incorporate the new enhancements in the current application.
• Interacting with Business Users, analyzing change requests, impact analysis, and implementation of the same.
• Presented and participated in CCB meetings for getting approval for various changes that needed to be migrated to Production based on the support tickets priority.
• Technical Design documents preparation.
• Code Review and debugging.
• Unit testing and Test case preparation.
• Handling and resolving the issues related to the day-to-day transactions in Account Receivables and Cisco specific tools.
• Providing support during the Month End and Quarter End closing activities and ensuring the smooth closing of the Cisco Financial activities thereby providing crucial reports to the Cisco Management.
• Examining the Account Receivables module and its interface to various interfaces to find scope of improvements and automations.
• Performance testing of the newly developed component.

Confidential

Software Development - Sr. Analyst

Responsibilities:

• I was part of Dell IT core EBS team and was part of the OMAR project. Worked mostly on AR/SLA/GL modules. Analyzing the new components and performing impact analysis.
• I was involved in doing an interface between Dell's Oracle AR and Perot system which was acquired by Dell so as to import project invoices from Perot to Dell EBS system.
• I was involved in development of custom programs, interfaces, reports as per the requirements.
• Preparing MD.070 (Technical Design Document) for the development of different custom components based on MD.050 (Functional Design).
• Preparing Coding Standards document (MD.110) which is used to follow uniform coding style and reducing the defects.
• Development of custom programs, interfaces, reports as per the requirements.
• Preparing TE.020 (Test Plan) with various test cases and scenarios.

Confidential

Applications Engineer

Responsibilities:

• Requirement Analysis
• Resolving technical and functional issues logged by customers against AP product and modifying core product code as required.
• Understanding the technical/functional flow of the product and help AP Global support team in resolving issues quicker.
• Introducing new futures and implementing them with existing system.
• Worked on third party payments (TPP) which was a new feature in R12.1.
• Creation of TDD once code development is complete.
• Doing unit testing once coding is completed.