Career Summary

Having **+ years of experience as a Techno Functional Analyst on Oracle EBS in Supply Chain Management and Finance Applications.

Commendable experience in Complete Project Life Cycle Implementation involving Pre-Implementation Analysis & planning, solution design & development, Systems configuration & data migration, User Training programs and Documentation.

Experience in working on cross functional modules in the environment of Procure-to-Pay (P2P) and Order-to-Cash (O2C) Cycles.

Functional Expertise in Purchasing and Order Management Modules.

Analyze the impacts on third party systems integrated with oracle apps and provided the better mapping solutions based on business requirements (TIPQA, Auto time, Proficy and Centerpiece) and trained the business SME’s to clear the interface errors.

Running Integration testing with other modules and verifying test results with other modules.

Performed requirement study, FIT-gap analysis, development, tuning, and user testing and production support of RICE (Report, Interface, Conversion and Extension) elements with AIM documentation.

Managed, designed and developed all aspects of migrating plenty of data conversion components from legacy system (Item Master, Item costs, Item Categories, Item Cross references, Suppliers, Customers, AP Invoices, AR Invoices, Stock Locators, Item Attachments, Routings, Routings Attachments, Purchase Orders, Sales orders and Work orders etc.,)

Extensive experience in design and development of Data Conversion Programs, Interfaces, validation programs, customizing forms, reports, Alerts and workflows using PL/SQL, Oracle Internet Development Suite (Forms & Reports 10G/9i/6i), Discoverer, Oracle Work Flow Builder, Shell Scripts, Pl/SQL Advanced Techniques, SQL, TOAD, XML Publisher and other software tools.

Experience in building applications, extending and personalizing pages using Oracle Applications Framework (OAF).

Involved extensively in preparing test scripts, migration scripts and change management scripts as per the requirements.

Expertise in Performance Tuning of Queries, Reports and high volume transaction processing.

Good understanding of Application Object Library (AOL) and SYSADMIN activities.

Played an active part in developing Business Gap-Fit & Requirement Documents (BR30, RD50) & Configuration Design Documents (BR100), Functional Specification (MD50/CV40), Technical Design (MD70/CV60).

Working experience in Agile Framework

Attended weekly status review meetings and monthly operations review meetings with the leads and customers to prioritize tasks and review progress in terms of value additions and process improvements

Created service requests(SRs) and follow up, conducted Oracle Web Conference (OWC) with Oracle for speedy resolution for all high prioritized issues.

Used version control and migration tools like CVS, PVCS, and HP PPM. Also, used Project Portfolio Management tools like HP Quality Center(QC) and training & learning tools like Oracle User Productivity Kit (UPK).

Worked extensively in onsite-offshore models for all projects following strict timelines

Education and Training

Bachelor of Technology in Computer Science and Engineering. J.N.T.U, India

Development and testing activities on Financials, SCM, Sysadmin/AOL, TCA and CRM modules of Oracle Applications EBS 11i/R12.

Technical Skills

Oracle ERP: Oracle Applications/Oracle E-Business Suite 11i (11.5.10.2)/ R12(12.1.1, 12.1.3)

Modules: Purchasing (PO), iProcuremnt, iSupplier, iExpense, Inventory (INV), Order Management (OM), Work in Process (WIP), Bill of Materials (BOM), Account Payables (AP), Account Receivables (AR), General Leder (GL) and others.

Programming Languages: SQL, PL/SQL, J2SE,J2EE, HTML and Java Scripts

Database: oracle 9i/10g/11g

Operating System: Windows NT/2000/XP, UNIX, LINUX

Tools & Utilities: Report builder(6i/9i/10g), Discoverer 11g(11.1.13.0), SQL*Loader, Work Flow Builder, XML Publisher, ADI, SQL* PLUS, MS office

Configuration and FTP Tools: WINCVS, PVCS, Integra, WINSCP, FileZilla and Core ftp

Recent Project Experience

GE Aviation(Unison)- Jacksonville, FL May’2016 - Present

Unison Industries LLC is a global business supporting the aerospace industry with electrical and mechanical systems for engines and airframe applications with seven sites across the US (Unison-Jax, Unison-Dayton, Unison-Norwich, Sterling-DC, Terrehaute-IN, TDI-Dayton) and Mexico(Unison-Saltillo). Unison is manufacturing of electrical components, sensors and systems for aircraft, industrial, marine and space Uses with one propeller repair shop in Sterling-DC. It is one of the subsidiary company with in GE’s Aviation Business Unit. This project involved in Implementation (Demantra) and supporting of Oracle Applications R12(SCM, Manufacturing and Finance) with business for all sites in Agile Model.

Responsibilities

Conduct numerous business meetings to identify and assess the impact of production issues and provide solutions along with functional impact analysis

Proposed new solution for the existing interfaces

Provided knowledge transfer to end users in resolving user errors

Attending Golf Eco metrics weekly meetings with GE higher management to present inflow and outflow of tickets and SLA breach information

Working in Agile model – Daily Scrum, creating user stories and updating weekly status as part of retrospective meeting

Assisting the accounting team in smooth month-end closing

Worked on RICE Objects in SCM and Financials of Oracle Applications

Provide bug fix for issues in across the modules (PO, INV, OM, BOM, WIP, AP, AR and GL)

Created Service Requests (SR’s) and prioritized as SEV2 and SEV3 and conducted Web Conference to resolve the high priority issues

Worked on Customer Ship to Address OAF page to make accounting flex field as required

Worked on Supplier OAF page to add DFF

Personalized Customer OAF page to make demand class field as required

Customized Colour of the items using CSS class in Oracle Applications Framework (OAF)

Personalized Customer OAF page to add custom tips

Developed Several PL/SQL and SQL Scripts to perform back end jobs. Developed Interface Programs

Developed RTF/XML Templates for various BI Publisher Reports in across the modules

Tuned the SQL Scripts to improve performance which are taking longer time

Developed interfaces from ERP side to help Demantra implementation team

Communicating with offshore team and ensuring Delivery with quality with in required time

Environment: Oracle Application R12.1.3, BOM, WIP, OM, INV, PO, AP, AR, DTR, PLM, ASCP and GL, Oracle 11g, Discoverer 10g, Report Builder 10g, PL/SQL, SQL *PLUS, SQL*Loader, SQL Developer, Windows 2007, XML Publisher, Linux x86.

GE Aviation - Jacksonville, FL Oct’2013- May’2016

Sites: Unison Elano, Dayton, OH (Nov’2015 – May’2016)

TDI, Dayton, OH (Feb’2015 – Nov’2015)

Terra Haute, IN (June’2014 – Jan’2015)

R12 Upgrade &

Dowty Propellers, Sterling, VA (Oct’2013 – June’2014)

All sites are affiliates to GE Aviation. This project involved in R12 OLTP Upgrade (11i to R12) and Implementation of Oracle Applications R12.1.3 with Manufacturing, SCM and Financials modules for all sites.

Responsibilities

Implementation:

Involved in Full-Cycle Implementation and conducted several meetings with business teams for business overview.

Interaction with the Customer on the requirements, fit gap analysis and preparation of project plan

Responsible for the functional configuration of Purchasing and OM modules with the co-ordination of the project team and end-users and Implemented Procure to Pay (P2P) and Order to Cash (O2C) business flow successfully

Conducted CRP (Conference Room Pilot), integration testing and performed extensive UAT

Create and maintain BR100, MD50, TE40, and CV40 documents including Change Management Process documents with providing detailed functional impact analysis

Prepared and presented Conversion strategy with business partners

Preparation of mapping documentation, functional and technical Specs for the data migration

Conducted daily meetings with stakeholders to track the conversion activity

Developed Master and Transactional data conversion entities using PL/SQL and SQL*LOADER utilities

Developed Custom components (Interfaces and reports) as per the business requirements

Involved in preparation of cutover plan with business partners and users

Executed successfully all conversions as part of cutover and get the sign off from users after reconciliation.

Provided support in raising Service request(SR), applying patches and problem-solving

Performed debugging of the applications and helped team members in troubleshooting and debugging.

Provided post go-live and post implementation support.

Upgrade:

Identified objects (interfaces, form personalization’s and custom objects) to modify as per the R12 requirement

Extended OAF pages as per the requirements to map the gap from 11i to R12

Involved in Pre-upgrade and Post-upgrade activities as per the cutover plan.

Environment: Oracle Application R12.1.3, BOM, WIP, OM, INV, PO, AP, AR, PLM, ASCP and GL, Oracle 11g, Discoverer 10g, Report Builder 10g, PL/SQL, SQL *PLUS, SQL*Loader, SQL Developer, Windows 2007, XML Publisher, Linux x86.

Texas Industries (TXI), Dallas, TX, USA Mar’2013 to Oct’2013

TXI, formerly Texas Industries was headquartered in Dallas, Texas. The company is focused on heavy construction materials in the southwestern United States market (e.g. Texas and California). There are mainly three products: cement (Portland, masonry and oil well cements), aggregates, and concrete related products. It owned 82 manufacturing facilities in six states. This Project involved to develop custom Oracle EBS Image solution in place of existing TXI sales portal. The TXI Oracle EBS Image Solution should give end users the ability to view and send images from the Oracle E-Business Suite (EBS).

Responsibilities

Involved in Requirement analysis, Design and Develop custom application in OAF. This include analyzing MD50 (Functional Design Document) and then writing MD70 (Technical Design Document)

Development of custom self-service pages using the Oracle Application Framework(OAF)

Making the self-service pages to access anywhere within Oracle EBS

Consolidating multiple images into a single PDF

Sending email/fax the PDF as single attachment

Developed OAF Extensions on iExpense and Customer pages.

Prepared documentation and end user training documents for future reference

Environment: Oracle Application R12.1.3, OM, INV, PO, iSupplier, iExpense, iProcurement, AP, AR and GL, Oracle 11g, PL/SQL, SQL *PLUS, SQL*Loader, SQL Developer, Windows 2007, XML Publisher, Linux x86.

CSX Transportation, Jacksonville, FL, USA Dec’2011 to Mar’2013

CSX Corporation based in Jacksonville, FL. It is one of the leading transportation suppliers. The companies rail and intermodal businesses provide rail-based transportation services including traditional rail service and the transport of intermodal containers and trailers. This project involved maintenance and support for the FinApps system for Purchasing and Materials. CSX keeps on adding enhancements to its system to have minimal manual work required for their day-to-day processing.

Responsibilities

Analyzed user requirements, functionalities and mappings within the PO and OM Modules

Involved in gathering/documentation of business requirements

Prepared test scripts and conducted unit and integration testing

Prepared training documents for the users for future reference

Attended weekly and monthly review meetings with business partners on ticket inflow and new projects

Preparation of estimations for project execution/deliverables

Delivery of solutions with high quality as per the project schedules

Developed PO Review for Quality Report

Developed PO Utility Report

Customized Oracle Reports to get output in excel format

Developed PO Utility custom form

Personalized PO Requisition form

Personalized OAF page in isupplier

Customized View Object and Controller OAF page using jDeveloper in iProcurement

Customized Supplier Registration Workflow

Development/modification of SQL scripts and PLSQL programs for project requirements as part of project implementation.

Day to day status track of issue logs.

Taking care of all functional issues and setups.

Problem determination in standard programs using fnd logs.

Raised Service Requests (SR) and worked with oracle to resolve the issues.

Regularly attended meetings on behalf of Purchasing Team and co-ordinate with Business partners for task accomplishment.

Providing Maintenance and 24/7 on call support for the applications and maintained the system stability.

Environment: Oracle Application R12.1.3, OM, INV, PO, iProcurement, iSupplier, iExpense, AP, AR and GL, Oracle 11g, PL/SQL, SQL *PLUS, SQL*Loader, SQL Developer, Windows 2007, XML Publisher, Linux x86.

CSX Transportation, Jacksonville, FL, USA Sep’2010 to Dec’2011

CSX Corporation based in Jacksonville, FL. CSX currently have their Revenue Management System (RMS) in mainframe which has interfaces with the Automated Waybill (AWS), Rating and Cash Application systems along with an Accounts Receivables interface system which enables the CSX customers to view their invoice related information online. The project will be dealt in providing solution on the application configuration, building interfaces between mainframe and Oracle systems and setup the auto invoice programs to create invoices for the original & corrected invoices in Oracle, Cash Receipts, XML and BPA reports. It involves developing the custom form within the application referring the requirements and the standard functionality that Oracle has within the application. It will also include being part of the User acceptance testing & Go-Live and support the UAT & Go-Live issues reported by CSX.

.

Responsibilities:

I have involved in developing the interface between Oracle AR Cash Receipts and Mainframe RMS for CSX Transportation.

Developed Lockbox preprocessor interface and conversion program.

Developed Auto Receipts Outbound and inbound program.

Developed an extract with Receipt Details.

Developed Report Builder/XML Reports.

Developed the Aging file extracts and send it to a UNIX path as mentioned by the user requirements.

Provided technical bug fixes during User Acceptance testing on the interfaces developed.

Provided functional support in Account Receivables for the customizations developed during User testing.

Development/modification of SQL scripts and PLSQL programs for project requirements as part of project implementation.

Raised Service Requests (SR) and worked with oracle to resolve the issues.

Involved in of Pre-PROD/PROD migration cutover plans.

Provided post production Go-Live support for the issues reported by users.

Achievements

Developed a custom program to apply unidentified receipts in AR which is appreciated by Oracle and they released a new API as part of quarterly patch release based on our program.

Environment: Oracle Application R12.1.3, OM, INV, PO, AP, AR and GL, Oracle 11g, PL/SQL, SQL *PLUS, SQL*Loader, SQL Developer, Windows 2007, XML Publisher, Linux x86.

Dun and Bradstreet, Argentina June’2010 to Sep’2010

The DUN & BRADSTREET, INC is US based company. It is the world's leading source of global business information, knowledge and insight, has been enabling companies to Decide with Confidence for over 168 years. D&B's global commercial database contains more than 160 million business records. The project mission is to implement Oracle Financials and Order Management R12

Responsibilities:

Prepared Technical Documents for conversions as per the Functional document requirements.

Designed and developed and tests conversion programs as per the business requirement

Prepared Installation Documents for migration.

Prepared Code Pack Documents as per Oracle Standards.

Involved in development of new reports.

Development of PLSQL programs required for business data process and interfacing to Oracle AR of EBS.

Responsible for Development of Procedures and Packages.

Developed Inbound and Outbound interfaces.

Development/modification of SQL scripts and PLSQL programs.

Registration/Defining of Executable, Concurrent Programs, Value Set using SYSADMIN.

Provided post production Go-Live support for the issues reported by users.

Environment: Oracle Applications R12.1.1, Account Receivables (AR), Order Management (OM), AOL, Reports 10g, Forms 10g, UNIX, XML Publisher, Work Flow, Oracle10g, SQL, PLSQL, TOAD.

ABRL, Hyderabad, INDIA Jan’2007 to May’2010

Aditya Birla Retail Ltd. is an Indian based industrial Retail company which has business presence across many States in the India. ABRL has planned to implement Oracle Applications version 11.5.10.2 to move from its legacy WMS to Oracle Applications. The ERP suite has all the financial, distribution and Manufacturing modules like AP, AR, GL, PO, OM, BOM, and INV. In the first phase of requirement analysis, data conversions are sought to be the major development areas where WMS business data needs to be mapped to Oracle applications database to bring data consistency per old WMS and keep historical transactions enliven.

Responsibilities:

Responsible for analysis of existing components functionality.

Design, code, Test and Code Review.

Development of packages and procedures.

Developed Control Files.

Developed PL/SQL Scripts for Validations.

Developed Reports using XML Publisher.

Customized Reports as per Client Requirements.

Define the AOL Objects.

Development/modification of SQL scripts and PLSQL programs as per the project needs and as directed.

Developed scripts to fix the bugs in production system.

Environment: Oracle Applications 11.5.10.2, AP, AR, GL, PO, OM, BOM, INV, AOL, Reports 6i, Forms 6i, UNIX, XML Publisher, Oracle9i, SQL, PLSQL, SQL Developer.

Contact this candidate