Sign in

Project Oracle

Florissant, MO
market rate
September 26, 2018

Contact this candidate



Phone: 636-***-****


Over 20 years of experience as a Lead Consultant with exceptional record of delivering cost effective, high performance technology solutions to meet challenging business demands. Worked with Fortune 500 companies. Implemented various solutions using ERP, Custom and Web applications especially related to Financials and billing Business processes. In depth knowledge in Business warehouse, Data modeling and data analytics. Delivered many finance, sales, billing, CRM BI-reports for critical decision making. Involved in Oracle Cloud implementation team as part of business functional testing, user functional acceptance testing for integrating with other internal and external systems.

Delivered different solution using SAP R/3-FI/CO/P2P and SAP Business Analytics and delivered many Global BI Reports.

In depth experience with IT Environment along with extensive experience with IT Project management

Act as a liaison between IT and business stakeholders by communicating changes and test plans, identifying problems, providing status updates

Consistently delivered and exceeding customer expectation on their change requests and production supports

Work closely with business users and stakeholders to improve their business processes by automate and schedule processes in timely fashion

Deliver many custom applications, web applications using Oracle Finance data along with custom databases

Involve with data modeling with process, events, business process layer delivery, MIT, MAT, UAT testing

Implemented Oracle Ebusiness Suites for different clients and SAP R/3 migration and BW implementation

Extensive experience in Inventory (INV), Account Payable (AP), Purchasing (PO), Account Receivables (AR), SLA, Project Systems, Oracle HCMS, OAB and Payroll

Involve in deeper data analysis and data mapping for different business needs

Involved in full lifecycle implementation with various roles –

Functional solution architecture, functional detail design, technical architecture, technical design, development, coding, testing, end-user training, post-implementation support and customization

Excellent interpersonal and communication skills.

Ability to handle full life cycle implementation going through Development, Conference Room Pilot (CRP), User Acceptance Test (UAT), User training and Go-live and Post Production support in Multi-Org Environment

Well experienced in preparing User Scripts, User Manuals, test scripts as well as provide User training for a wide range of user groups

Experience in creating and maintaining Oracle AIM (Application Implementation Methodology) documents such as RD-020, BR-100, TE-040, MD-050, CV-040 and BP-080

Experience organizing multiple meetings with business team and follow-up on pending items including follow-up with offshore team to reach the time lines with the deliverables, have done follow-up with Oracle Technical support for all open service requests to get resolved

Excelled in preparation of Data Migration and Data Conversion strategy and executed migration

Excelled in data analysis for detailed resolution for each operating unit and get into granular level of details

Expert in data mapping for many external systems, many interfaces between external and internal application, inbound and outbound data exchange

Involved in data cleansing for vendor and material master data repository

Develops and executes quality assurance test plans for unit, system, and regression testing

Expertise in Optimization techniques and performance enhancement

Thorough understanding of Software Development Life Cycle & Software development methodologies

Subject Matter Expert in Oracle P2P,O2R,General Ledger, HCMS, Benefits and Payroll

Lead in SAP-BusinessWarehouse(Business Analytics) migration on FI, CO and Customer Service, COPA, P2P for different operating companies

Details of Technical Environment

ERP : Oracle ERP E-Business Suites(R12.2.5,12.1.2/11.5.10/10.7)

Modules: P2P(PO,AP), O2R (OE, AR), GL, FA, Alerts, PO, Work

Flow, OPM (Oracle Process Manufacturing), Oracle

Project Accounting (PA) module

Oracle HCMS-HRMS/OAB/Payroll (12.1.3/11i)

ADI, WEBADI & Sys Admin, iexpenses, iPROC,

SAP R/3 FI/CO/AR/MM/PS/CRM(3.0/7.0)

Data Warehouse : SAP BW 7.4 and SAS ABM



(Business Intelligence) : OBIEE, NOETIX, Oracle, Business Objects,

BIPublisher(XML Publisher), Polaris and

Discoverer, COGNOS and BEX

Analyzer, Analysis for Office, BICS

Business Objects (3.0,4.0) and CrystalReports

Database : Oracle 12c, SQL*Server, Sybase and Access

Programming : Java, Shell Programming, PL/SQL, API calls, SQL PLUS

Tools : Toad, SQL Navigator, SOLMAN, and SQL Developer



Others : SDLC, AIM Methodology, Vendor Life Cycle,

Material Life Cycle

Operating system : UNIX, WINDOWS IBM PC/Compatibles, and UNIX System


Office Tools : MS Project 2000, Visio, Power Point, Word and Excel


Maritz Inc, MO Mar’18-Sep’18

Working as an Analyst in Oracle EBusiness Suites-R12, OCI, AR, AP, PO, GL, Custom Modules like Cash Check, Adaptive and Oracle Credit Management

Lead support and enhance each business unit solution for different ETL processes and Interfaces for different applications like billing, order entry, inventory, travel events

Deliver credit card payment processing interface using webservices from NAS service which is .net application

Work with Accounts Receivable and P2P business stakeholders to address their support needs, also new configuration and functional needs

Work with Credit analyst using DBNI data for customer credit review and credit application process for each business unit needs

Create a protype using Oracle Credit Management to show proof of concept on Oracle credit application and review functionality

Work closely with Application DBA to adopt dbobjects, dblinks, synonyms, triggers, packages and procedure for Cloud migration

Deliver many audit reporting needs for Payable, Purchasing, customer, Oracle Projects and General Ledger

Work with Supplier form customizations to add functionality for different regions

Enhance many reporting changes for AR, AP and PO using Oracle reports and BiPublisher

Support migrate PO and Inv using xml gateway for different supplier

Deliver many configuration changes on P2P and O2C to adhere R12 functionality

Give detailed Oracle patch analysis to stakeholder and application DBAs

Address process improvement on AR and AP processes

Fix 1099 reports and form fixes to eliminate errors

Migrate Cloud WEB ADI-GL/PA for different opcos in different way using Macros

Work with BICS reporting with various AR, AP reporting needs


Oracle R12 (E-Business Suites 12.2.5) AP, Purchasing, AR, GL on Linux RAC, PL/SQL, OAF, Toad, BI(XML)Publisher, Oracle forms and Reports, BICS, Oracle 12c, Visio

BiStateDevelopmentAgency,MO Mar’16-Mar’18

Worked as ERP Business Analyst in Oracle E-Business Suites (12.1.2), HCMS, Oracle Advanced Benefits and Payroll

My day to day work involves

Requirement gathering for HRMS, OAB and Financials process implementation of many reports using XMl(BI)Publisher and many interfaces

Worked with Benefit stakeholders to address their issues and resolve in timely manner

Configure ACA process and implemented to send a file to IRS

Functional Setup on Benefits, Plans, Rates and HRMS related changes

Integrate Payroll process with AR and costing

Many setups related to Risk Management connect to HRMS

Support ongoing HR Self-service changes

Worked on Total Compensation Statement-Project E2E from requirement gathering until implementation

Benefit files to the different insurance carriers and third-party vendors for insurance

Created Business Requirements and Technical requirement for HRMS with other 3rd party systems

Lead Open Enrollment process and co-ordinate with stakeholders to prepare and drafted project implementation documents like BR-100 development of functional and technical design documents (MD.050 and MD.070), development of testing documents (TE.020, TE.040, TE.120, etc.)

Expert skills in creation of flex fields, Value sets and Concurrent Programs

Validated the Integration with Accounts Receivable: Project related Purchase Order and Integration with Payables: Import and Review Project Expense

Working on Bank Setups for the new bank setup and bank statement reconciliation process

Leading the report conversion from Discoverer into Polaris and BI Publisher

Designed and configured setup of Flex fields related to HRMS, Benefits and other AOL objects

Lead year end Payroll and OAB RUP patches analysis

Payroll support related to Benefit and HR

Worked with Fast Formulas on OAB and Payroll

Worked with Oracle Analytics for HR

Involved with RUP, ACA patching and implemented all the way to PROD environment


Oracle E-Business Suites(12.1.2,12.1.3)-OAB, HRMS, Payroll, AP, Purchasing, GL, AR on Linux RedHAT RAC, PL/SQL, OAF, OBIEE, NOETIX, Toad, SQL*Navigator, PL/SQL developer, MS-Access, BI(XML)Publisher, DISCOVERER and POLARIS

Nestle Purina Pet Care, ST.LOUIS, MO, USA Dec’05-Mar’16

Senior Business System Analyst working in Oracle Financials, SAP FICO and SAS

My day to day work involves

Worked with the Project team to implement Oracle ERP modules and

Integrate various applications to better manage projects and operations.

Worked as a functional consultant for the implementation of Oracle Project Accounting (Costing & Billing).

Conducted requirements gathering, gap analysis, testing, documentation.

Drafted project implementation documents like BR-100, BR035 (Gap Analysis) and development of functional and technical design documents (MD.050 and MD.070), development of testing documents (TE.020, TE.040, TE.120, etc.), and other Oracle AIM related documents

Prepared and laid out the Auto Accounting rules based on the segments configured and Project number was also considered as one of the segment values.

Performed the standard configuration and setups for project accounting.

Implemented silent features of Project Accounting such as rate schedule, transaction control and Auto-accounting rules, Implementation of labor cost rate schedules.

Creating user and responsibilities and attaching menus using sys-admin

Expert skills in creation of flex fields, Value sets and Concurrent Programs.

Validated the Integration with Accounts Receivable: Project related Purchase Order and Integration with Payables: Import and Review Project Expense.

Loaded data using SQL loader, Used Toad, SQL Navigator to write the code and written UNIX shell scripts

Designed and configured Setup of Flex fields.

Drafted the testing document (TE-050) for the project accounting (PA) module and participated in SIT and UAT testing.

Involve in various P2P functions for the business and end user community. Working with Payable – Bank reconciliation and related bank information.

Managed Payables closing, including reconciling AP to the GL, reconciling GL accounts included in the balance sheets, Prepared Journal entries for assigned accounts including Allocations, Accruals, prepared recurring journal entries, recurring monthly payments, prepayments and monthly reports. Created Ad hoc reports for analysis & tracking financial expenditure trends

Expert in RICE objects and PL-SQL, UNIX

Working with Tax group to resolve their Tax issue with purchasing and invoicing issues. Also involve in Inventory Purchase periods and close Purchasing and AP month end activities.

Involved in data conversion and designed interface files and staging table to load the data and validation and translation of records

Created lot of out bounds and in bounds transfer data and load data

Created lot of custom reports and designed the custom forms.

Used SQL Loader to load the data. Used extensively PL/SQL.

Created the value sets, descriptive flex fields, segments, setting transaction types, Auto accounting rules, cross validation rules, Transaction sources, ccid, and accounts code for the new company.

Created Interface files using Shell scripts, PLSQL for inbound interface to GL, AR and AP SQL loader to load the data to staging tables and validate and process to Oracle Interface tables.

Provide SME advice to the requirements, design and development team

Analyze and Prepare requirements, design documents and other meetings to obtain requirements

Extensive knowledge of the Oracle Table Schema and regularly extracted data in TOAD and SQL*Plus. Dimension to check in and checkout code

Provide functional and technical support for Oracle ERP modules and other system that interface with it. Audit and administer user accounts, responsibilities, policies and procedures using Account Request Tool to maintain Audit (SOX) compliance.

Develop complex ad hoc queries to monitor various initiatives, analyze data, developed reports for tracking to maintain Audit compliance. Conduct user acceptance test using UCASE.

Identify, document, and expedite resolution of Oracle functionality issues. Track and expedite Oracle SR (Service Requests) and assist with the planning and testing of updates and patches. Work closely with developer team to implement the change requests.

Involve in Globe activity to identify gaps, early adoption, and assist with Vendor/Item data conversion/cleansing. Write functional requirements and specification for the same.

Working with CRM3.0 business users with their daily needs and Project System co-ordination on WBS (Work Breakdown Structure).

Working with Business Warehouse on PFME report and other reporting needs using OBIEE and NOETIX vies.

Migration of BEX3.5 into BusinessObjects on FICO,Costing,P2P,CS reports

Environment: Oracle applications 11i Project Accounting, AP, Purchasing, GL, HP UNIX, PL/SQL, FORMS, Report, OBIEE, NOETIX, Toad, SQL*Navigator, PL/SQL developer, MS-Access, SAS ABM, SAS ASK, SAP BW, Business Analytics

SAVVIS Communication Inc., ST.LOUIS, MO, USA Oct’04 - Dec’05

Worked as a Senior Business Analyst Lead

Job involved managing the project and suggesting areas of improvement, conducting regular developer meeting, preparing project status reports to send to Vice President. I managed a team size of 4.

Involved in implementation of Oracle Financials –Project Accounting AR, GL and HRMS (OAB).

Utilized strong working knowledge in GL, AP, PO, Order Management, Cash Management and PO module.

Involved in the setup of Project Accounting Module. Setting up the Billing, Costing and expenditures in project accounting.

Gathered and analyzed business requirements. Documented functional requirements pertaining to Financial modules and security features in Project Accounting and OTL.

Worked on billing events, Project costing, Budgeting and Project Management.

Worked on Billing Extensions to Create Event Holds.

Worked on customizing the application for revenue recognition.

Added Accounting Rules for Auto accounting and creating Lookup sets.

Maintained proactive interaction with the client to understand business practices to aid in system configuration.

Addressed post-production issues and fix them accordingly and maintain issue log to track issues.

Worked on resolving month end closing issues.

Raised SRs (Service Requests) to Oracle support and aggressively followed up the issues for timely resolution.

Involved in CEREDIAN HR conversion project as a lead by participating in gap analysis.

Environment: Oracle applications 11i modules Project Accounting, AP,PO Oracle 9i on Sun Solaris(RAC system), PL/SQL, Unix Shell Scripts, Toad, OFA, Acuity, SQL Server, Crystal Reports v8, VANTIVE, ADI and Windows NT/XP/2000.

Emerson Corporate, St. Louis, MO, USA Jun’03-Sep’04

Lead consultant and Involved in developing/enhancing/production support of Oracle 11i Application for AP, GL, AR, FA, CE and Purchasing.

My Responsibilities cover end-to-end project management of the IT lifecycle - including

project planning, requirements definition, estimating, Identifying/recommending solutions, coordination, tracking/status reporting

Identify and leverage opportunities based on experience gained from other projects

Responsible for Projects requirements gathering, fit/gap analysis, functional design, Projects application configuration and development of Work Breakdown Structure, system integration and user acceptance testing, user training and production support

Gathered accounting and project structures from QuickBooks software to migrate the data into Oracle Project Suite system

Configuration of key areas in Project Costing, Project Billing and suggesting suitable Business flow setups to the client

Defined Project related setup options, Project Resource calendar and identified the Project organizations, Project types, Project Templates, Task related setup and Project related workflow and profiles

Creation of expenditure types for interface supplier costs and miscellaneous transactions.

Creation of projects and project status. Created various projects, tasks and sublevel tasks with in those projects.

Responds to user issues regarding Accounts Payable, Accounts Receivable, General Ledger, Fixed Assets

Gather user requirements for customization, reports and changes to existing functionality and make recommendation as to the same

Developed and maintained Interface Programs for GL and AP. Involved in enhancing, developing old/new Oracle/Custom reports using Oracle Reports 6i for all the modules.

Involved in loading Budgets/Force Count Information. Involved in supporting user requests for production.

Involved in designing the HRMS/PAYROLL implementation.

Created FSG Reports

Worked in Creating Value sets, DFF's, Lookups, Customer Design using TCA, Dunning Letters setups and Statement of account Setups customizations in Dunning letters and Statement of accounts.

Lead in implementing Oracle Financial 11i which included gathering business requirements, integration fit gap analysis, application configuration and reporting requirements.

Creation of Chart of accounts, Currency and Calendar

Loading Data into GL interface tables

Open and coordinate Service Request with Oracle Support

Meet with business analysts and business owner’s one new functionality requests/production issues

Worked in EDI Transactions

Installed ADI on all desktops and Trained end-users in ADI to create templates and upload journals

Daily use of PVCS- Version Control Software and KINTANA Application to deploy code and monthly running of FSG Reports.

Conducting regular meetings with clients and developers to discuss the issues and to monitor the progress of the project.

Organize and run user acceptance testing and obtain user sign off.

Involved in design and managing production support of Oracle 11i Application for GL, AP, AR, FA, and Purchasing. Involved in supporting user requests for production.

Work include manage the project, coordinating with DBA for applying the patch and raising the TAR and assisted in creating test scripts and Implemented in production.

Also involved in iSUPPORT/iEXPNSES implementation. During Design phase validate standards compliance, work with team to resolve key software issues, and facilitate interaction with Oracle Development.

Environment: Oracle applications 11i, Oracle 9, Toad, PVCS, KINTANA, Hyperion, PL/SQL, Unix Shell Scripts, Discoverer, MS Project, MS Office, Visio

ARCH COAL Inc., St. Louis, MO, USA Sep’02 – Feb’03

Worked as Senior Consultant in upgrade of 11i implementation Oracle HRMS/Payroll converting Basic Benefits into Oracle Standard Benefits (OSB) project and worked in Call connect interface.

Involved in data conversion and designed interface files into OSB. Created lot of custom reports and designed the custom forms for benefits, payroll packages.

Involved in supporting production tasks like fixing some of the Oracle/custom forms and reports. Created Concurrent programs and registered forms, menus and valuesets in APPS. Created lot of out bounds and in bounds transfer data and load data. Written UNIX shell script for inbound/interfaces.

Used SQL Loader to load the data. Used extensively PL/SQL.

Used API to update/insert data into tables. Loaded New Hire, Rehire, and Transfer and Terminate people into Oracle HRMS tables.

Involved in payroll reports and interfaces.

Involved in Bank Reconciliation Report.

State wages process and federal tax EDI filing reports for payroll.

Worked in Call Connect Interface, which is maintained by third party.

The inbound and outbound interface has been coded in PL/SQL and it maintained the employees personal and benefits information, if the employee needs to change any of their information they can call the third parties and change, instead of going through the HR forms

Completed appropriate documentation during the lifecycle of a project unit test plans, software move forms and system test plans.

Environment: Oracle applications 11i, Oracle 8i on Sun Solaris, Forms 6i Reports6i, PL/SQL 8, Toad, Unix and Windows NT/2000

SBC Telecom, St. Louis, MO, USA Nov’01 – Aug’-02

Worked as Senior IT Techno-functional consultant Involved in 11i implementation of Telecom project for SBC,AMERITECH,PAC BELL,NEVADA BELL AND SNET Oracle Financials 11i Application- core modules are AP, GL, FA, AR and PROJECT ACCOUNTING.

Involved in Gap Analysis, identified known product gaps and solutions previously developed.

Worked as a techno functional analyst for the implementation of projects (costing/billing).

Interacted face-to-face with clients to understand the present business process and gathering of business requirements

Implemented budgeting like creation of project budget and draft budget

Creation of PA and GL Period.

Conducted Business Process Review (BPR) and fit-gap analysis to fulfill business requirements.

Involved in setting up project billing module -- auto-accounting, event type, implementation options, and bill rate schedule.

Familiar with tie-back programs and Project Status Inquiry (PSI)

Created alias tables, flex field segments and attributes.

Created Concurrent programs and registered forms, menus and valuesets in Oracle application

Created User, User Responsibility, Request groups and registered forms and menus in Oracle application.

Extensive knowledge of the Oracle Table Schema and regularly extracted data in TOAD and SQL*Plus.

Developed code for Data Mapping and Conversions of the legacy systems.

Designed functional specifications performed testing, user training and implementation for a number of custom procedures, custom forms and triggers. These customizations were used to support specific client requirements per their business needs.

Involved in data conversion and designed interface files and staging table to load the data and validation and translation of records

Created lot of out bounds and in bounds transfer data and load data

Created lot of custom reports and designed the custom forms.

Written Unix shell script for inbounds.

Used SQL Loader to load the data. Used extensively PL/SQL.

Adhered to the database and development standards for the Oracle Financial Application in order to meet the Software quality Assurance requirements.

Compiled with requirements of the Oracle Financials Application's Software Configuration Management (SCM) Team in order to migrate code from development to system test and then to production

Environment: Oracle applications 11i, Oracle 8i on HP, Forms 6i Reports 6i, PL/SQL 8, Toad, Unix and Windows NT/2000, Version control – changeman

SWB Yellow Pages, Inc., St. Louis, MO, USA Mar’00 – Oct‘01

I worked as Techno-functional consultant

I involved in Oracle Application 11i implementation and production support. I involved in design and implementation of Accounts Payable Module and GL Module and some HR module.

Involved in Design and implementation of Accounts Payable Module and FA and HR module.

Developed the HR/AP system in 11i.

Developed the interface to load people into HRMS tables for 11i by using Oracle Delivered API for the New Hire, Transfer, Rehire, and Termination and changed the personal information, office and location changes etc. Created a link to AP for the employee/vendor information, which will create the customer information in AP module by using Oracle APIs.

Developed custom form for custom lookups in 11i

Involved with AR Late Payment Charge process/report in 11i.

Developed and implemented the vendor conversion in 11i.

Involved in FA conversion for 11i.

Created shell scripts to ftp/to load data thru SQL LOADER.

Used extensively PL/SQL.

Attended user meetings and made suggestion to improve performance.

Created concurrent programs, values sets and flex filed values.

Used API packages and customized the packages.

Involved in changing/developing various Oracle Delivered/ Custom Reports for Purchasing, Order Entry, Oracle Receivables, Oracle Payables and HRMS. Developed/modified various reports. Created concurrent programs, values sets and flex filed values

Used shell script to ftp the Data. Used extensively PLSQL.

Attended users meetings and made suggestion to improve performance.

Unit tested and implemented the system.

Created concurrent programs, values sets and flex filed values.

Used API packages and customized the packages.

Environment: Oracle applications 11i, Oracle 8i on HP, Developer/2000-Forms 6i, Reports 6i, PL/SQL 8 and Windows NT.

SLP Inc., St. Louis, MO, USA May ’99 – Feb’ 00

Worked as a Lead Consultant in AR Implementation project, which is converting into Oracle Application (11.0.2) from the legacy system DICE and existing system SLP Funding Manager. This project consists of Accounts Receivable (AR), Workflow, and Oracle Alerts.

Involved with Customer Conversion from legacy system, Customer Interface from the existing system, Commitments, Invoices against those Commitments.

Designed the Balance Forward Report. Written PL/SQL procedures for conversion and Interface.

Involved in Application DBA work, applying patches on the server, installing and setting up the client Pc

Involved in customizing the forms and reports.

Created aging bucket report for Accounts Receivable

Created many PL/SQL and Unix shell scripts.

Created concurrent programs, value sets, segments and attributes.

Used SQL loader to load the files and developed various Reports.

Worked on the interface coding in which collection agent will be calling the customers on their outstanding amount. The call will be connected to the collection representative and the information of the customer is ready for their use, which is the existing system.

Environment: Oracle applications 11.02, Oracle 8.05 on NT, Developer/2000 - Forms 4.5, Reports 2.5, and PL/SQL 8.0.

SBC Inc., St. Louis, MO, USA Jan’97 - Mar’99

IT Consultant involved in the Disbursement Accounting Re-engineering Effort projects using Oracle Applications, at Southwestern Bell Telephone. This project consists of various financial modules like AP, PA, FA, GL and custom modules like Cost Accounting (CA), CS. Supported the whole CA in implementation and production. The highlight of the system is to provide the project managers with estimates of labor hours; engineering hours based on predefined calculation parameters.

Involved in Project Accounting and General Ledger customizations.

Involved in developing and supporting Batch Automation. Involved in PacBell (wireline) project.

Involved in enhancements of some of the existing Reports and Forms in CA, developing new Reports, Forms for CA and CS.

Created Interface and requirement gathering and gap analysis

Customized Oracle Forms.

Environment: Oracle applications 10.7 SC, Oracle 7.3 on HP, Forms 4.5, Reports 2.5, PL/SQL 2.3

Singapore Telecommunications, Singapore Aug’95 - Aug’ 96

IT Consultant involved in development of Telecommunication Customer Administration System (TELICAS) project for Singapore Telecommunications. This project is intended to be a fully integrated customer administration system and billing package. The highlight of the system is the ability to process large volume of data with high performance.

I involved in the development, testing, implementation, and ensuring smooth integration of Billing Receipts, Product, and Promotions modules.

I also involved in on-site (Singapore) development, testing, and implementation for 6 months.

Environment: HP9000-UNIX, Oracle Forms, Oracle Reports


Bachelor Degree in Computer Science, Bharathidasan University, India.

Post Graduate Diploma in System Analysis and Data Processing, Annamalai University, India.

Diploma in UNIX, C, Oracle by Bitech Information Systems India

Diploma in RDBMS – Sybase & Power Builder by SSI India

Contact this candidate