SUMMARY

• Oracle Apps Techno - functional expert with 9+ Years of hands on experience as a solutions architect, solution provider with a track record of delivering customer focused, enterprise ERP solutions for various system in Oracle Applications - EBS (11i/R12) and Cloud Applications
• Documented the current process flows, business requirements and fit/gap analysis for R12 General Ledger, Accounts Payable, Accounts Receivable, Cash Management and Fixed assets.
• Implemented and supported various stages of Procurement, Order-to-Fulfill / Order-to-Cash and Procure-to-Pay life cycles.
• Guided and supported business teams through the redesign of various legacy processes and translated the new processes into technical designs during multiple projects.
• Proficient in corporate finance/resource planning, financial systems evaluation, design and implementation
• Contributed and provided solutions at different phases of implementation, including requirement gathering, gap analysis, configuration of the modules, developing test case scenarios, test scripts and leading the UAT.
• Prepared financial reports, developed processes, and performed variance analysis in accordance with business plan using Excel, Oracle BI, XML Publisher and Oracle Financial Reporting.
• Co-ordinated various teams (Design, Development & Testing and Configuration teams) in various Oracle Application Implementation projects.
• Hands on experience with oracle application upgrade from 11i to R12
• Extensive experience as Techno-Functional consultant in implementation of Oracle Applications 11i/R12/cloud in purchasing, Inventory, Order Management, BOM, WIP, i-procurement and Financials modules like Receivables, Payables, General ledger
• Good knowledge of the functional flow of Order to cash & Procure to Pay life cycles.
• Tremendous Experience in design & development of Reports, Interface, Conversion, Extension, Workflow (RICE-W) components.
• Expert in writing stored procedures, Packages and functions using SQL & PL/SQL, Forms & Reports 6i/10g, BI Publisher and UNIX scripting.
• Experience building XML Publisher Reports using Data Template and implementing bursting send documents using deferent delivery methods like Mail and /Fax
• Excellent understanding of the SDLC starting from the requirement analysis, functional specifications, design and development, UAT to Go Live.
• Good Experience in project leadership, coordinating multiple vendors and infrastructure team.
• Expertise in development of BI reports using TIBCO Spotfire and OBIEE reporting tools
• Comprehensive understanding of change control system, business-initiated issues and follow-up procedures and processing of emergency and non- emergency tickets.
• Designed and developed various components using PostgreSQL and R libraries
• Hands work experience on Greenplum Database
• Good Knowledge on Oracle cloud implementation cycle.
• Worked on Oracle Fusion Cloud R13 Financials.
• Strong experience and Functional knowledge of Oracle Fusion Cloud Applications
• Good exposure on extracting data from Legacy system and importing into CLOUD through FBDI
• Identifying business requirements and mapping them to the Oracle Cloud functionality
• Configuring the Oracle Cloud Applications to meet client requirements and document application set-ups
• Configuring the Oracle Fusion Cloud modules
• Good understanding & working Experience of Multi org & TCA architectures.
• Extensive experience on PL/SQL Collections, Bulk Collectors and Pipelines functions.
• Experience in customization of form personalization, OA Framework, AOL concepts and ALERTS.
• Experienced Implementation Documentation such as BRD (Business Requirements Document), SRD (Systems Requirement Document), SDD (Solution Design Document), TDD (Technical Design Document) BR100 and BR120s.
• Experience in both the Waterfall and Agile project methodologies
• Excellent communication, leadership, interpersonal skills. Dedicated and Motivated in accepting various challenges imposed on me and showing enthusiasm in group work assigned to the team
• Involved in Conference Room Pilots and provided Proof of Concepts for various solutions

TECHNICAL SKILLS

ERP: Oracle Applications EBS 11i and R12/fusion/Cloud

Module s : Purchasing (PO),Inventory (INV), Order Management (OM), General Ledger(GL), Accounts Payables(AP), Receivable (AR), Manufacturing Modules (BOM & WIP) and i-Procurement and ASCP

Framework: Oracle Application Framework

Operating Systems: Windows NT/2000/2003 Server

Database: Oracle 8i / 9i / 10g, Greenplum and Big data (Data Lake)

Tools: and Utilities: Oracle Discoverer 6i/9i, XML Publisher, SQL * Loader, Toad, SQL *plus, Reports 6i/9i/10g, HP Migration tool(Kintana-PPM), Clear case, SVN, PLSQL Developer and Spotfire

Languages: C, UNIX, SQL, PL/SQL, PLpgSQL, LINUX and Java

Web Languages: HTML, XML

Packages: Ms-Office Suite, MS Visio

Oracle Fusion Middleware: SOA

PROFESSIONAL EXPERIENCE

Confidential, Overland Park, KS

Oracle ERP Analyst

Responsibilities:

• Interact with client, businesses, functional module experts, third party system leads through regular workouts and open items discussion for capturing the business and functional requirements.
• Communicating with the Client for capturing the business requirements, consolidating and documenting the same and preparing business requirements document. Communicating the requirements to the team and get the deliverable ready without any scheduled deviations and ensuring quality.
• Analyzing client requirement and designing solution using PLSQL, SQL, API and Reporting tools. Integrate application with new/existing applications and databases
• Designing and developing the interfaces, packages, functions, procedures, triggers and cursors to achieve the business functionality and analyzing the data and their sources
• Perform UAT and Unit testing from business users. Update Onsite Team /Client about the status of adhoc reports or projects. Data Analysis/Modification as per Users request. Incorporate Business Rules. Resolves application related issues experienced by end-users
• Generating Test Specifications. Gathering detailed requirements from Functional and Business specifications. Analyze the requirements and develop detailed test plans. Documentation and review. Developing testing strategies for efficient and error free testing (like preparing Unit Test plans and doing Unit Test reviews).
• Coordinating with Business users regarding the problem they face in the system for analysis and Co-coordinating with business on testing the solutions. Ensure smooth completion of SIT and UAT phase and gathering the pre-requisites data which will be required during the testing phase.
• Work on change management process using the Click IT and ITSM tools
• Used Putty for deploying DB Objects/scripts into data mart and Version control tool SVN for code migration.
• Monitoring the deliverables and ensuring that the deliverables are met as per milestones.

Environment: Oracle Sprint Vision cloud Application, OM, BOM, WIP, Inventory & Procurement modules, DataMart, SQL*Loader, PL/SQL, SQL*Plus, SVN and UNIX

Confidential, Cincinnati, OH

Oracle ERP cloud Analyst

Responsibilities:

• Work directly with business stakeholders to capture business requirements and provide Fit Gap Analysis and workarounds
• Financials track for Cloud Financials Implementation
• Responsible for requirements gathering, design, configuration, conducting various test events, issue resolutions and offshore - onsite coordination.
• Worked on Cloud Conversions on GL, FA Modules, extracted data from Oracle EBS and imported into CLOUD through FBDI.
• Worked on customizations in Cloud Financials GL with the integration of ODI & ICS
• Post production support on Oracle Fusion Financials
• Created a new custom job sets and scheduled Jobs/Job sets in Fusion CLOUD
• Worked on GL, FA setups in fusion CLOUD as per configuration document
• Developed new OTBI Reports in CLOUD as per business requirements.
• Conduct Gap fit analysis and conference room pilots
• FBDI templates to upload data to Oracle Fusion Financials cloud.
• Design of Volume Accounting Solution for Revaluation process via development of custom BIP extract.
• Configuration of Allocations rules via Allocation Manager
• Co-coordinated and guided offshore team in development of FR Studio Reports, Smart view Analysis for Financial Reporting
• Design data migration strategy for GL balance, AP Open invoices and Fixed Assets conversion.
• ADFDI to upload value sets, invoices and other data
• OTBI for real time reporting, BI Publisher reports (PO Printing, Check Printing etc.)
• Used BI Publisher to produce EFT and positive pay files.
• Work directly with business stakeholders to capture business requirements and provide Fit Gap Analysis and workarounds
• Providing support for day to day business issues
• Working with Oracle Support to handle product related issues
• Setup Fixed asset / cash management modules
• Setup AP/AR/ GL modules
• Load trail balances and asset balances through WEB ADI
• Identifying and developing the automated process to reduce the labor work
• Actively involved in frequent status calls with the customers.
• Expertise in development of BI reports using TIBCO Spotfire and OBIEE reporting tools
• Prepare business process document, support document, user manuals, test cases for the enhancements and extensions.

Environment: Oracle Applications R12/cloud - Oracle Financials, Purchasing (PO), Oracle Inventory (INV), Oracle Order Management (OM), Bills of Material (BOM), Work in Process (WIP), SQL, Spotfire Reports, Starfish (ETL)

Confidential, Webster, NY

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Analyzing the requirements from customer and preparing the requirements understanding document.
• Involved with Business for getting requirements and clarifications
• Interacting with the Functional Analyst for the clarification of requirements regarding the Functional Design Document.
• Played a major role in UAT during upgrade and migration projects
• Debugged custom interfaces to identify potential issues during upgrade.
• Conducted CRPs, UAT, Parallel Runs.
• Developed several xml/ BI Publisher reports
• Worked on Procurement modules
• Implemented new functionalities into Iproc module
• Developed Solution mapping, SRD, BR100, CV60 and Training Strategy documents.
• Worked on OAF form personalization changes
• Involved in preparing end user document of the business process flow for future knowledge transition.
• Worked on functional set ups related to the standard functionality as per the business requirement.
• Provided solution to the long running jobs at the time of upgrade.
• Involved in integration testing.
• Developed interfaces involved with different systems.
• Extensively worked on creation of various Critical to Quality packages by incorporating business validation logic in modules like PO, OM, INV, AP, AR and Planning modules.
• Interacting with end users, business Analysts and Value chain partners
• Preparing MD50, MD70 and TE20 documents
• Migration designing and strategy development of legacy data into Oracle Apps
• Customizations & Change Request
• Testing the functionality for new enhancements
• All necessary support related to QA (Quality Assurance) for new enhancements
• Resolving Functional validation Issues
• Post production Support when the new releases go live.

Environment: Oracle EBS/ Cloud - Oracle Financials, Oracle Purchasing (PO), Oracle Inventory (INV), Oracle Order Management (OM), Oracle procurement, Bill of Materials (BOM), Work IN Progress (WIP), ASCP & VCP, OA Framework & Form Personalization’s, PL/SQL, Oracle Forms, Reports, XML Publisher, UNIX

Confidential

Oracle Apps Technical Consultant and Design expert

Responsibilities:

• Responsible for Production support for issue resolution, user request, data load, performance issue.
• Gathered the requirements for whole VMI set up process and whole Intercompany process from Onsite and analyzed in technical prospective
• Complete US and Canada Functional Setup
• Involved with business for getting requirements and clarifications
• Explained Intercompany business flows to entire team including offshore and onsite
• Developed best fit solution for Intercompany business by coordinating with developers involved in Intercompany development
• Defined the Legal Entity in Legal Entity setup manager
• Configured the Payables, General Ledger and Receivables as per the client requirement
• Define Options and Defaults - Financials options and Payable Options that are specific to Accounts Payables, and defined Banks and various Payment formats
• Defined Payment terms, Distributions sets and working on all invoice types and Payments Manager
• Worked on Multi-Org Access Control Feature for AP and AR
• Configured Payables, Financials Options, System Options and Transaction types, Sources
• Auto Accounting, Memo Lines, Receivable Activities, Receipt Classes, Receipts Sources and Bank Accounts Definitions
• Involved in UT, SIT and CAT
• Creating Oracle SR as per Development, SIT and CAT Issues and doing data-fix accordingly.
• Modified the custom packages, tables, lookup, Value set and DFF
• Tuning all the application components for better performance and throughput
• Resolving Functional Issues and Interface problems
• Set up test data/scenario as required for testing the resolution of the issues
• Preparing MD50, MD70 and TE20 documents
• Testing the functionality for new enhancements
• Post production Support when the new releases go live
• Handled/ monitored all movement of codes (code-migration) to several testing and QA environments.
• Actively involved in frequent status calls with the customers.
• Developed XML publisher reports, Developer Reports and PLSQL Packages in AR, PO, OM and GL modules.
• Grooming New Team Members.

Environment: Oracle Applications R12 - Oracle Financials, Oracle Purchasing (PO), Oracle Inventory (INV), Oracle Order Management (OM), Form Personalization’s, PL/SQL, Oracle Forms, Reports, XML Publisher, UNIX

Confidential

Team Lead and Oracle apps Technical Consultant

Responsibilities:

• Involved with business for getting requirements and clarifications
• Worked on Receivables and Revenue Outbound interface to load the data of all the legal entities of NSN to staging tables from where the P20 system will pick the data.
• Worked in setup of exchange rates and Loading of exchange rates into all the instances of OTC system
• Coordinated with Onsite resources in analyzing the enhancement projects and providing estimations to the client.
• Coordinating with onsite team for the implementation of objects. Defined concurrent programs and developed PL/SQL packages.
• Created Kintana Packages, check-in updated code into Clear Case and migrating objects one instance to another. Logging tickets for DBA and clear case issues and get them resolved by concern teams.
• Preparing/reviewing MD-70 technical design document and MD-120 Component deployment documents.
• Customizations & Change Request
• Testing the functionality for new enhancements
• Taking the responsibility of team and individual automation required for the business to reduce the manual effort.
• Hosting client meeting s and gathering requirements. Prepared functional and technical design documents.
• As per client requirements understanding the existing system and worked for development.
• Prepared Unit test cases and CAT test cases and executed and posted results into Compass.
• Involved in setups and Release Rollout Plan, prepared production check list.
• Handled tickets on issues reported through RMT Tool.
• Having good experience in co coordinating with the offshore and onsite team
• Active participation preparing the status report, Delivery report and monthly metric reports.

Environment: Oracle Applications 11i&R12 - Oracle Financials & SCM, Oracle Projects, PL/SQL, Oracle Forms, Reports, Kintana, Clear case and UNIX