SUMMARY:

• 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. I Worked with Fortune 500 companies. Strong Knowledge in R12 Oracle Financial Upgrade process.
• Excelled as a Lead in Oracle ERP implementations
• Extensive experience in Inventory(INV),Account Payable (AP), Purchasing (PO),Account Receivables (AR), SLA,Project Management, Project Contact, Project Manufacturing, Oracle Time and Labor
• Involved in full lifecycle implementation of 11i release of Oracle Projects - - 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 Migration and Data Conversion strategy and executed migration
• I have Four Implementation experiences in Oracle Financials.
• Develops Strategies for Implementation, Data conversion, Interfaces, etc.
• 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 Project accounting, Oracle Payables, Purchasing and Account Receivable.

TECHNICAL SKILLS:

ERP: Oracle ERP Applications (11.5.10)

Modules: AP, GL, FA, AR, Alerts, PO, Work flow, Order Entry, OPM (Oracle Process Manufacturing), Oracle Project Accounting (PA) module HRMS/Payroll (11i) Time & Labor ADI & Sys Admin, i-expenses, i-PROC SAP FICO

Reports: OBIEE, NOETIX, Oracle, Business Objects

Database: Oracle, SQL*Server, Sybase

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

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

Version control: CHANGEMAN, PVCS -DIMENSION, KANTANA, APPLIMATION

Others: SDLC, AIM Methodology, Vendor Life Cycle,Material Life Cycle

Operating system: UNIX, WINDOWS IBM PC/Compatibles, and UNIX System,SCO UNIX, HP-9000, SUN SOLARIS, NOVELL NetWare, Windows Office Tools: MS Project 2000, Visio, Power Point, Word and Excel

PROFESSIONAL EXPERIENCE:

Confidential - ST.LOUIS, MO

Senior System Analyst

Responsibilities:

• 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 other 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 APSQL 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.

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

Confidential - ST.LOUIS, MO

Senior Business Analyst Lead

Responsibilities:

• 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.

Confidential - St. Louis, MO

Lead Consultant

Responsibilities:

• 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

Confidential - St. Louis, MO

Senior Consultant

Responsibilities:

• 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 value sets 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

Confidential - St. Louis, MO

Senior IT Techno-functional consultant

Responsibilities:

• 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 value sets 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

Confidential - St. Louis, MO

Techno-functional consultant

Responsibilities:

• 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.

Confidential - St. Louis, MO

Lead Consultant

Responsibilities:

• 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.

Confidential - St. Louis, MO

IT Consultant

Responsibilities:

• 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