SUMMARY:

• Over Twenty years of experience in end - to-end life cycle implementations, upgrades and support of the Oracle e-Business Suite of applications (9.x to 12.2.6) in several different technical and functional roles.
• Implementation, Upgrade, Support and technical expertise in Oracle Applications 11x/R12.2.6, across Modules such as Purchasing(PO), Accounts Payable(AP), Accounts Receivables(AR), General Ledger(GL), Oracle Projects(PA) (Costing & Billing), Fixed Asset (FA), Order to Cash (O2C), Procure to Pay cycle(P2P), Order Management (OM), Inventory (INV), Human Resources (HR), Oracle Payroll, iProcurement, iStore, iExpenses, Oracle Alerts and XML Publisher.
• Experienced in Oracle Application System Administration, AOL System Admin Activities such as Creating KFFs, DFFs, Profile Options, Value Sets, Users, Responsibilities, Managing Concurrent Programs and Requests.
• Extensive experience in creating Stored Procedures, Functions, Packages and other database objects using SQL and PL/SQL. Experienced in UNIX/LINUX shell scripting.
• Experienced in developing custom Oracle Forms using Oracle Forms 10g/6i. Used CUSTOM.pll to customize the standard Oracle Forms and Forms personalization to personalize the forms.
• Experienced in Developing and Customizing Oracle Reports using Reports 10g/6i as per business user requirements.
• Experienced in requirement gathering, design and development of custom applications in Oracle Applications Framework (OAF) environment.
• Experienced in implementation and upgrade from Oracle 11i to R12.1.3 and 12.2.6
• Experience with Oracle SLA (Sub Ledger Accounting), MOAC and TCA.
• Experienced in implementing in Oracle XML Publisher Bursting functionality.
• Experienced in OBIEE (Oracle Business Intelligence Enterprise Edition)\OBIA (Oracle Business Intelligence Administration) reporting tool including creating Repository (RPD), Analysis and Dashboard.
• Enthusiastic and highly skilled individual with 2+ years of experience in the field of data warehousing, specialized in OBIEE, BI publisher, BI Concepts and Reporting tool.
• Experience in setting up Confidential Multi-User Development Environment (MUDE) to run queries to test and validate the repository.
• Working knowledge with Oracle Data Integrator (ODI) 12c.
• Experience in CAMLI (Configuration, Extension, Modification, Localization and Integration) components.
• Experienced in Patch analysis process and Performance tuning for Oracle custom processes.
• Experience includes exposure to all the phases of Software Development Life Cycle including Analysis, Design, Development, Testing, Implementation, Production Support and Maintenance.
• Great exposure to Client Interaction, Requirement Gathering, Designing, Development, Testing, Team Leading, Release Management and Follow ups.
• Experienced working in onsite-offshore support model.
• Experienced working with Federal clients such as DHS, DOD, FAA, Treasury and Army, and Air Force.

TECHNICAL SKILLS:

Database and Tools: Oracle RDBMS V7 to 11g, PL/SQL, SQL*Reports, SQL*Plus, Forms 10g, Developer/2000 & Reports 10g, Designer 2000, Oracle Application Framework, Form Personalization, Discover 9i, SQL*Loader, Import/Export Utilities, JDeveloper 3.0, Workflow, smartDB, DB2, BPEL, XML Publisher, Java, SOA (Service Oriented Architecture), OBIEE, OBIA with 12C client ODI 12C, UNIX and Shell scripting.

PROFESSIONAL EXPERIENCE:

Oracle EBS HRMS and Payroll implementation

Confidential ( San Antonio, Texas)

Responsibilities:

• Configured and created OBIEE Repository, involved in modifications of the physical, the BMM, and the presentation layers of metadata repository using OBIEE Administration Tool.
• Analyze, Design and Developed OBIEE Metadata repository (.rpd) that consists of physical layer, multiple business model / layers with aggregates, dimensions & time series objects, presentation layers with catalogs & folders, external table security using session variables, test and validate the model using Siebel Analytics Server Admin tool.
• Developed OBIEE/OBIA Analysis and Dashboard Prompts for new reports and bug fixes for production reports.
• Designed schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables.
• Created reports with PDF, RTF and Excel templates using the BI Publisher.
• Worked closely with end users to designing reports and dashboards, suggesting better ways of reporting in OBIEE so that the required information is visualized by end users.
• Developed MD070 and MD065 documentation for reports.
• Used Serena for code migration, KSN (Knowledge Service Network) and Remedy for production issue tracking.
• Also worked with R12 upgrade team for patch reviews from Oracle and code remediation for upgrade to R12.2.6.

Environment: Oracle Financials R12.2.6, Agile SAFe Methodologies

Oracle EBS 11i to R12.2.4 Production Support

Confidential (Scotts, Illinois)

Responsibilities:

• Code Remediation 11i custom components to R12 including interfaces, custom Forms and custom Reports for pre and post MOCK upgrade.
• Creating and reviewing the technical design documents and test case documents for all the components.
• Prepared CDRLs (Contract Data Requirements List) and configure sub-ledger accounting.

Confidential (Oklahoma City, OK)

Responsibilities:

• Primarily worked as Confidential Techno-Functional consultant with core expertise in Oracle EBS in the Procure to Pay cycle, Order to Cash and provide production support.
• Performed application support in single and multi-Org environment for Oracle Financials (Purchasing (PO), Accounts Payables (AP), General Ledger (GL), Account Receivable (AR) and Fixed Assets (FA) modules)
• Involved in Requirement Analysis, Design and Develop custom applications in OAF. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec)
• Business requirements gathering, mapping, gap identification and workarounds
• Participated in 11i to R12 upgrade. Retrofitted 11i custom RICE objects to R12
• Upgraded forms and reports from 11i to R12
• Performed Patch analysis process and Performance tuning.
• Developed Interface process to import Invoices into AP.
• Developed Interface process to import Journals into GL.
• Working with Oracle support through Service Requests in resolving issues with standard processes.
• Co-ordinate across teams during integration testing, troubleshooting issues and tracking support tickets. Resolve Production Support tickets with Confidential quick turnover time.
• Code Remediation - Make changes to custom objects (Forms, Reports and Interfaces) to make them compatible to 11g database.
• Testing Support - Assist users and team members during various phases of testing including Unit Testing, SIT and UAT.
• Worked with DBAs for analyzing and testing patches, also code migration.
• Configured Security and Cross validation rules to restrict the usage of departments and companies belonging to one Company by the other in sub ledger transactions.
• Responsible for end to end support for Finance Modules (AR, AP, GL, Projects and SLA) including CEMLI (Configuration, Extension, Modification, Localization, and Integration) including reviewed proposed by Integration team.
• Organized daily calls with users to report the status of current issues and understand the issues.

Confidential (Sacramento, CA)

Responsibilities:

• Primarily worked as Confidential Techno-Functional consultant with core expertise in Oracle EBS in the Procure to Pay cycle and provide production support.
• Co-ordinate across teams during integration testing, troubleshooting issues and tracking support tickets. Resolve Production Support tickets with Confidential quick turnover time.
• Worked on modifications to the existing custom objects including custom interfaces, reports and forms.
• Developed multiple interfaces in different modules including PA, AP, and PO.
• Worked on BI Publisher and Oracle reports and developed outbound HR interface HCM to ADP Enterprise.

Confidential (West Chester, OH)

Responsibilities:

• Manage full life cycle of design, development and testing phases and develop solution design and lead client throughout implementation and support phases.
• Worked as code migrator, migrate code in production environment, performance testing and tuning and upgrade and patch installation. Developed code and fixed issues using PL/SQL packages, Shell scripts, Oracle Application Framework (OAF), Oracle Forms, Oracle Forms Personalization.

Confidential (Dayton, Ohio)

Responsibilities:

• Involved in the implementation of Financial Modules (GL, AP, PO, AR & FA). Responsible gathering to understand current business process and to implement new functionality or Business future process model.
• Preparation of MD 50, BR 100, TE 40 documents and user Manuals. Involved CRP and UAT for test and development environments.
• Setting up the Ledger i.e. Chart of Accounts, Calendar, Currency & Accounting Conventions. Conducted to end users on solutions for business processes.
• Coordinated with Oracle support to resolve application issues.

Confidential (Detroit, MI)

Responsibilities:

• Worked as Confidential development lead (technical/functional) on the project. Responsible for converting data from legacy to Oracle Financials Applications.
• Project involves replacement of legacy MRP systems with Confidential single global business application as the foundation for collaborative enterprise design, planning, and execution to improve General Dynamic’s capabilities in integration, manufacturing, and lifecycle support.
• It includes the implementation of Procure to Pay, Concept to Release, Planning (INV, WIP, BOM, ASCP, G/L and Order Management), Demand to Build, Contract Authorization & Customer Relationship Management (CRM) and convert legacy data to Oracle Application 11.5.10 by using SmartDB Workbench and EDI (extract application data, format, and writ to data files) tool.
• Design inbound/outbound interfaces from to legacy system and oracle. Customized workflow and worked with OA framework.

Confidential ( Dayton, Ohio)

Responsibilities:

• Designed, and developed Interface Programs for Oracle Manufacturing packages implementation to meet special business need.
• The Interface Programs bridge the third party system SRS (Legacy System) and Oracle Manufacturing modules together functioning as Confidential single system to meet business operation requirements.
• Also developed Oracle forms (6I) to maintain data and Oracle Reports (9I) for data output.

Confidential ( Washington DC)

Responsibilities:

• Financial Consultant for the implementation of Accounts Receivable, Accounts Payable and Purchase Order (11i) in Confidential client-server environment.
• Customized iProcurement build and workflow processes as per the client’s requirements.
• Designed and Developed Oracle Reports (9i) for PO and Confidential /P modules.

Confidential (Washington DC)

Responsibilities:

• Oracle HRMS Technical consultant on the Oracle HRMS project modules include HR, Payroll and Advanced Benefits. Responsible for developing, design, testing and customizing Oracle HRMS modules (11i).
• Also involved in problem resolution and enhancements in the area of fast formulas and custom interfaces.

Confidential (Columbus, OH)

Responsibilities:

• Performed development, design, and testing of enhancements to Oracle Federal Financial Applications Release 11. Areas of work include modify Oracle COTS (Commercial-Off-the-Shelf) API for Payment out and Customized Prompt Payment Interest for client requirements.
• Develop Third Party Payment, Multiple Payment Terms, Treasury Limitations, which is an extension to Oracle AP, PO and G/L.
• Created PL/SQL packages to interface with AP tables for invoice status reporting, performed modifications to reports using Reports 2.5, and created query forms for custom tables.
• Developed Entity Relationship Diagrams (ERD), business functions by defining modules, generating logical and physical design, generated Forms and reports by using Designer/2000.

Confidential (Columbus, OH)

Responsibilities:

• Development Lead for Conversion/Interfaces for the iStore (11i)/CRM implementation at Papa Johns.
• Performed business requirements analysis for Consumer Conversion, Item Conversion and Pricing Interface for Apps 11i.
• Developed an interface to load the Pricing information from Legacy system to Oracle application.
• System administrator for Applications and have done set ups for iStore.
• Environment: Oracle 8.1.6.2, Oracle Applications 11i (CRM 11i, iStore 11i, CallCenter, Workflow)

Confidential (Cincinnati, OH)

Responsibilities:

• Manufacturing Consultant for the implementation of MPS in Confidential client-server environment.
• Performed business requirements, designed technical document, build, tested coding and Interface with i2 Technologies and CAS.

Confidential (Washington DC)

Responsibilities:

• Financial Consultant for the implementation of Human Resources, Accounts Receivable, Accounts Payable and General Ledger in Confidential client-server environment.
• Performed business requirements analysis and mapped to system functionality and Interfaces with other financial systems.
• Worked on application extensions and customized reports.

Confidential (Pittsburgh PA)

Responsibilities:

• Worked at Developer Programs for Oracle Finance Modules.
• Developed and Designed end to data conversion and Interface programs.
• Also involved testing and bug fixing.
• Updated documentation like MD70 and MD50.

Confidential (Pittsburgh, PA)

Responsibilities:

• Designed, and developed Extension Programs for Oracle Manufacturing Applications implementation to meet special business need of Confidential PPG Automotive Glass.
• Lead Confidential group of six people in developing the set-up Reports for various Oracle Application modules as per Oracle Application standards, using Reports 2.5. (Set-up reports are used by SA‘s to check the set-up data in different instances), did Q/ Confidential of set-up Reports as per standards and Registered them as concurrent programs in AOL.

Confidential (Covington, KY)

Responsibilities:

• Designed, and developed Interface Programs for Oracle Financial and Manufacturing packages implementation to meet special business need.
• The Interface Programs bridge the third party system RTS (Inventory Management System) and Oracle Financial and Manufacturing modules together functioning as Confidential single system to meet business operation requirements.
• Designed and developed complex values sets, flexfields, and concurrent programs for extensions in INV., OE, WIP, ENG, and BOM to meet complex business rules.

Confidential (Allentown, PA)

Responsibilities:

• ICD/OAS (Integrated Circuit Division/Oracle Application Suite) of Confidential .
• The project involves the Conversion/Interface of data from Legacy Systems like IMS, DBII, INFORMIX and SYBASE to Oracle Apps v 10.7 and the extension and customization of Forms and Reports.
• The project is jointly managing by IBMGS and ORACLE Corp.
• Worked as Apps lead for the setting the standard for the conversion/interface teams and design documentation for Customers, Open Orders, Item Categories, WIP Interfaces Inbound/Outbound, URB(BOM) Inbound Interface.
• Converted data from different sources including mainframe systems and loaded them to ORACLE.
• Wrote SQL, PL/SQL, and shell, scripts for extracting, loading and massaging data with special emphasis on data integrity enforced with constraints and database triggers.
• Speeded up the data conversion using parallel processing and tuning SQL scripts and data transfer processes.

Environment: SUN 5000, Solaris 2.5, Exceed, Oracle 7.3.2.3.0, Oracle Apps 10.7, Forms 4.5, Reports 2.0/2.5, sql*Loader, EDI, Visio

Confidential (Sidney, OH)

Responsibilities:

• Converted Open Orders, Invoices and Customers from legacy using P/L sql packages.
• Developed the set-up Reports for various Oracle Application modules using Reports 2.0/2.5 in Motif environment.

Environment: SUN 5000, Exceed, Oracle 7.3.2.3.0, Oracle Apps 10.6, Forms 4.5, Reports 2.0/2.5, Sql*Loader, Visio, SQL, PL/SQL

Confidential (Knoxville, TN)

Responsibilities:

• Analyzed, designed and developed an issues and change managementmethodology for Confidential complex ERP reengineering project at Confidential major aluminum metal and product manufacturer.
• Developed decision and information flows, determined issue process resolution, formalized procedures, and presented senior management.
• Primarily used Developer 2000 to develop the system.
• The system and associated process will aid in issue management in Confidential project that includes over 100 people full time for 2+ years.

Environment: Oracle 7.2, Oracle Apps 10.6, Forms 4.5 and Reports 2.5.