Objective: 
To obtain a challenging and rewarding position as an Oracle Implementation Analyst that would allow me to utilize my strong domain experience, financial background and business knowledge

Summary of Qualification:

• Over 6 years of experience as Functional/Business Analyst in Implementation and Support of Oracle ERP and in core Finance areas
• Proficient in Multi Org, GIS, MRC setups, Flexfield concepts and System Administration
• Expertise in Reconciliation of Sub-ledger modules with GL
• Provided solutions on the complex integration between Oracle Financials and various other external applications
• Provided Post Production Support in Oracle Financials (GL, AP, AR, OM, INV, CM & FA)
• Experience in working with Oracle Product Support and TAR Handling with Oracle Support
• Good Understanding of the business processes across various domains
• Functional Experience in Financial Accounting and Reporting with good leadership and interpersonal skills
• Experience in areas of Audit, Implementation & Evaluation of Accounting and Internal controls
• Working knowledge of SDLC/AIM process
• Experience with preparing Specification Documentation, gathering Business Requirement, Designing process workflow, Identifying and resolving Gaps
• Overall competency in precise translation of requirements into deliverable

Professional Experience:

Client: Confidential, Dallas, TXPeriod: Aug 06 – Till Date
Role: Oracle Functional Consultant

Confidential is the leading manufacturer and wholesale distributor of optical lenses in the United States. Throughout North America, Confidential has more than 8,500 dedicated employees located in 116 prescription laboratories, four manufacturing facilities, two distribution centers and one research and development center.

Project: Standardize Customer Invoices, Statements and Automate Cash Application Process

Responsibilities:

• Completed Impact analysis of the existing Print Document Solutions
• Interacted with end users, super users to gather requirements
• Preparation of To-Be flow taking all business units into account
• Clearly defined timelines for meeting the Projects goals and objectives
• Automated Essilor’s Cash Application process which was previously created manually and applied to transactions
• Creating test cases & executing the test cases
• Provided guidance to the offshore technical team in building customizations.
• End Deployment planning and Post go-live support.

Project: Moving Shipping of Inventory Organization from the Shore Distribution to the Columbus Distribution Center

Responsibilities:

• Was involved in the project from its inception. Prepared the Proposal, Prepared client presentation, and Interacted with the client for business requirements
• Performed as-is and to-be analysis, identified gaps
• Performed OM,AR,INVset ups and Prepared business process documents
• Created Functional Design Documents and developed test cases for testing CBP’s
• Prepared detailed deployment steps and post deployment activities.
• Trained users on navigation inline with the new business processes

Project: Upgrade Assessment for NA Operations from Oracle Release 11.5.9 to Release 11.5.10.2

Responsibilities:

• To take advantage of the new functionality in release 11.5.10, especially the new features in Accounts payable, Accounts receivable modules, the client upgraded from 11.5.9 to 11.5.10
• Facilitated the reengineering of business processes to match or take advantage of the new 115.10 functionality
• Involved in setup change, change management, end-to-end testing, documentation and rollout
• Analysis and troubleshooting custom reports in both instances to identify differences with the upgrade instance
• Worked with Oracle Support on bug resolution
• Performed the upgrade and setup steps on five different complete upgrade dry runs

Project: Enhancements/Support for Oracle AR Module 11.5.9

Responsibilities:

• Primary responsibilities included identifying new functionalities that could eliminate existing customizations, working with business team to identify inefficient processes that could be changed to ease manual and server workloads, designing test plans and application setup
• Gathering, business process redesign, configuration and testing of the Oracle applications modules to meet client’s requirements
• Designed and documented the functional documents for the customizations
• Resolves issues on AR interface.
• Provide support related to production issue and month end closing

Project: ELVIS LAB Migration for Oracle AR Module 11.5.9

Responsibilities:

• Performed as-is and to-be analysis
• Actively involved in GAP Analysis and Business Process Mapping and documenting various workarounds that can be used for migrating from legacy system to oracle
• Performed set ups and Prepared business process documents
• Prepared cut off plans
• Interacted with end users, super users to gather requirements for development of new reports and changes to any existing reports and prepare MD-50 documents
• Involved in end user training
• Provided post Production support

Client: Confidential, Columbus, IN Period: Jul 05 - Jul 06
Role: Financial Functional Consultant 

Confidential., a global power leader, is a corporation of complementary business units that design, manufacture, distribute and service engines and related technologies, including fuel systems, controls, air handling, filtration, emission solutions and electrical power generation systems. Cummins is headquartered in Columbus, IN and is also having an engine plant located there.

Project: Implementation of Oracle Financial GL and AR module

Responsibilities:

• Interacted extensively with the end-users to understand the business process and defined a precise accounting flex field structure in Oracle General Ledger
• Configured and Setup the application per customer requirements
• Established proper hierarchy of the business units for financial reporting
• Prepared To-be Flow documents taking into account the COA for the Group and business process
• Defined the recurring journal allocation formulas for allocation of various expenses across various business units
• Defined customer profile classes, customers, Statement cycles, Dunning letter sets, Receipt classes, Receipt Sources and Payment Methods
• Defined FSG Reports to consolidate the financial statements of its 4 distinct business units
• Defined Customers, customer profile classes, payment terms, distribution sets, and Auto Cash Rule Sets
• Prepared Unit, Interface and Environment Certification Test Scripts
• Impart training to the Business Super Users about the additional functionality, new reports and the inherent process changes in the application
• Provided Post Go-Live support to the client

Project: New Invoice flow for Oracle AR Module and OM Module

Responsibilities:

• Understanding the existing business process workflow, identification of Gaps and providing the solution in terms of workarounds and customizations
• Allowing Business to be able to print invoices in OM instead of AR with AR as final depository for Invoices so that invoices could be sent along with the shipment
• Reconciliation program to reconcile the invoices printed in OM to invoices created in AR and reconciliation report giving a comparison between OM and AR Invoices that error out
• Providing the inputs to the technical team for building custom reports by preparing functional documents and conducting Unit testing for custom module developments and reports
• Documenting the test scripts covering various business scenarios for UAT
• Post Production support after Go-Live

Client: Confidential, Sunnyvale, CAPeriod: Jul 04 – Jun 05
Role: Financial Functional Consultant

Confidential is a leading provider of digital solutions in the growing digital entertainment and digital imaging markets. Today, Confidential is focused on delivering technologies that allow consumers to connect and share their video and audio files with their families and friends and that improve their digital entertainment experiences in their homes, offices or while traveling

Project: Implementation and support of Oracle 11i Fixed Asset Application

Responsibilities:

• Understanding the client\'s requirements, documenting the same and providing functional inputs to the technical team
• Captured business process information , requirements, and developed models for the business processes
• Mapped the future process requirement into Oracle Fixed Asset and identified the gaps
• Carried out mapping of the legacy system to Oracle 11i
• Defined required setups for converting data in FA
• Designed and documented MD60\'s to develop custom reports in Fixed Assets to cater to business requirements
• Setup fixed assets module with 91 asset books for 9 countries to meet the local statutory reporting of the countries, Local tax requirements, US GAAP requirements and US tax requirements
• Defined asset key categories and location key flexfields
• Defined quick codes, financial options and system control
• Defined depreciation bonus, depreciation ceilings and investment tax credits
• Defined prorate conventions and prorate calendar
• Guided users through creation of setup document and carried out setups including depreciation rules for different asset categories
• Mapped the legacy fields into the mass additions table and used application desktop integrator to upload into the mass addition interface table
• Reconciled with GL after data conversion
• Developed Oracle training manuals and trained super users

Confidential, Ypsilanti, MIPeriod: Mar 04 - Jun 04
Role: Financial Analyst 

Responsibilities:

• Completed budgeting and forecasting with assigned project and functional areas
• Completed monthly and annual accounting close, performed financial analysis for assigned projects as well as assisted with annual financial audits
• Performed cost analysis to measure ongoing effectiveness
• Worked directly with clients and vendors to resolve project issues and financial concerns

EDUCATION AND TRAINING

• Masters in Business Administration –Finance, Confidential University
• Bachelors in Computer Science and Information Technology
• Internship in Oracle Implementation at Confidential Company
• Internship in CCB Treasury Finance Department at Confidential