Oracle Finance Functional Resume
SUMMARY:
- Highly energetic leader known for innovation, integrity, and the ability to create successful solutions to complex business problems.
- Accomplished Manager with superior Organizational skills.
- Demonstrated expertise in information technology with a tenacious commitment for driving continuous process improvement.
- Proven ability to quickly analyze key business drivers and develop strategies to improve the bottom line
TECHNICAL SKILLS:
Application: Oracle Applications R12/11i/11.GL, AR, AP, FA, PO, PA, OTL, Channel Revenue, iExpense, iProcurement, CE and Treasury Federal Financials
Languages: SQL and PL/SQL
Reporting: FSG and Discoverer
Other Tools: Web ADI, Data Loader, HP Service Manager, Clarity, Service Now, Onbase, Interneer, Configshot, UPK, Quick Test pro, HP ALM & Sharepoint, Payment factory, MIS Robot, Jitterbit, Billtrust, Get paid, Vertex & UC4, Workday, Taulia, Aravo, Serengeti, Inspyrus, Confidential & Concur
Office Suite: MS Project, Visio and MS Office
Ad - hoc Reporting: TOAD, SQL Navigator, Discoverer & GL wand
PROFESSIONAL EXPERIENCE:
Confidential
Oracle Finance Functional
Responsibilities:
- Participated in all activities of EBS upgrade (from 12.1.3 to 12.2.8). Attended workshops with Upgrade partners ( Confidential ) and Salesforce Business Users. Collaborated for end to end testing involving multiple integrations with boundary apps. Participated daily standup calls presenting progress on process enhancements prior to the Upgrade, nature of defects raised during the Upgrade testing, triaging methods and defect resolution.
- Analyzed and evaluated business requirements by working with finance functional teams and management. Provided recommendations on the nature, scope and complexity of solutions.
- Supported Oracle Financial applications and integration points. Coordinated with cross-functional IT departments to resolve issues.
- Exercised troubleshooting skills to identify, research and propose solutions to problems and accommodate necessary changes or corrective action, as needed.
- As part of QA testing, executed number of SQL scripts and UNIX shell commands in addition to extensive end to end functionality testing.
- Worked on configurations and testing an end to end solution involving Oracle MRP (Plans, Schedules and Forecasts), Inventory (Item setups and template creation, Category sets, Approver setups), Workflows, Requisition interface with Confidential (3rd party tool for Procurement management).
- Developed test strategies, tests and documents, educated and supported subsequent software solutions.
Confidential
Functional Manager
Responsibilities:
- Played an important role as SI (System Integrator) in DEAMS (Defense Enterprise Accounting Management System) R12 upgrade project.
- Supported instance issues, Regression and QT&E testing issues. Remediated QT&E issues.
- Assisted and Collaborated with DBAs on Instance strategy.
- Contributed ideas for successful instance strategy.
- Tested newly cloned instances for bugs and errors.
- Assisted PM as and when needed in compiling metrics, business proposals, presentations and other project related activities.
- Participated, presented and discussed project deliverables during Leadership meetings with PMO senior management.
- Lead and coordinated KT sessions for all the teams with Confidential .
- Played a major role in the Govt personnel in Oracle R12 functionality.
- Conceptualized the content and prepared the schedule. Put together the required material that prepared the Govt Oracle users to be equipped with the required Oracle R12 processes and the changes from R11i to R12.
- Conducted 3 weeks for Air Force FMO and DFAS employees for delta changes between 11i and R12 versions of Oracle P2P, O2C and B2R processes.
- Collaborated with Confidential project team in testing and configuring the Oracle upgrade changes.
- Remediated functional and technical issues in the as well as QT&E test instances.
- Prepared the UPK material, job aids and Guides for Govt Oracle users. All together we prepared around 400 UPKs for all the Oracle business processes in R12.
- Helped the team in staging data for UPK recording of various processes. Resolved Oracle system related and data related errors during UPK recordings.
- Had frequent interactions with Air Force Base FMO and DFAS Supervisors discussing the R12 changes.
Confidential
IT Manager, Oracle support
Responsibilities:
- Resource planning, budgeting, screening and hiring. Hired full time as well as contract resources.
- Manage more than a dozen onshore and offshore resources.
- Oracle patch review, approval and migrations through test to Production instances.
- Review and approve Request for changes as Change Management Board member.
- Advise on new solutions for enterprise business applications integration and functionality activation. Understand the impact of process changes and be able to guide process definitions accordingly.
- Analyze and solve complex problems, provide documentation, guidance and instruction to users at all levels.
- Proactively work with Accounting, IT and internal business partners to provide assistance and advice with the implementation of new or enhanced Oracle financial applications and systems.
- Managing the Project/Production issue assignments, lead weekly project status meetings, monthly customer update meetings, monthly global IT support meetings, coordinated Global testing for major Oracle Patches, guiding and mentoring Mainframe system analysts while they transition to Oracle.
- Remediating post go-live issues and supporting sustainment.
- Coordinate and/or manage projects and department assignments.
- Consult with end-users to analyze and understand needs, objectives, desired features, and input and output requirements. Provide end-user instruction and support to resolve application issues.
- Develop, coordinate, and implement plans to test business and functional processes and quality assurance testing. Lead functional acceptance testing of patches and upgrades. Train and document processes.
- Develop test scripts, process flows and functional specifications for the process improvement projects.
- Co-ordinate with developers to develop custom solutions, test the custom solutions through multiple iterations of testing and corrections.
- Every project was designed to pass through several stages starting from gathering requirements, analyzing the standard and custom solutions, solution design, process flow documentation, preparing functional specifications, preparing technical specifications, Testing the custom solutions, Bug fixing, User acceptance testing, production migration and post production support.
- Strong cross functional business knowledge in process streams such as Procure to pay, Order to cash and account to close or budget to report.
- With internal resources Implemented bolt on applications like AME solution for Invoice Approval, iExpense project, Cash management, Onbase integration, Vertex integration and Payment factory for secure payment process.
- Worked with COE/Architecture to establish best practices for global processes and systems.
- Managed global teams to deliver key programs on time and within budget.
- Played a significant role in successful completion of upgrade projects from 11i to R12.1.3 and from R12.1.3 to R12.2.4 and Oracle Financials (GL, AP, AR, FA, PA) implementations for multiple North America plants in Atlanta, Lebanon, Alliance, Insinkerator, Emerson Motors and their Canada Division and their Mexico plants.
- Made several international trips to Mexico and Canada to participate in project discussions and collaborate with customers for successful Oracle implementations.
Confidential, Cleveland, Ohio
Project Lead/ Sr. Oracle applications Analyst
Responsibilities:
- Implemented AP, FA Cash and Treasury and Purchasing solution for Domestic US operations and Canada in Oracle 11i version.
- Led the project to design and develop Bloomberg Interface to bring Forex rates and Fed rates in to Oracle Treasury.
- Led SWIFT connectivity project through a Service Provider called BankServ.
- The Payables implementation covered interfacing invoice data from 27 feeder systems with Payables Invoice Open Interface tables, 25 report customizations, Interfacing with 6 Banks, Interfacing with Taxware and Manchester, standard Setups and Configurations.
- The Fixed Assets implementation covered the Asset system setups, customization of reports, interfacing with Virtual Trader and Taxware.
- The Purchasing implementation covered Configuration of Oracle Purchasing module like Item definition, item category, sourcing rules, procurement limits, document approval rules, approval hierarchy, and document revision criterion. Wrote functional specifications and business requirements documents for uploading supplier and Supplier site data into the purchasing.
- Implemented Cash and Treasury solution for their Mexico operations in Oracle 11i version. Addressed issues relating to Spanish Language pack.
- Implemented AP, AR, FA, GL, Cash and Treasury solution for their China Operations in Oracle R12 version. All the documents including the User procedures were translated in to Chinese language and provided to the local Users.
- Implemented GL, AP, AR, FA, Cash and Treasury solution for their Malaysia and Singapore operations in Oracle R12 Version. This implementation also covered pretty much all the required configuration as in China implementation but was done in English.
Confidential
Oracle Sr Functional Consultant
Responsibilities:
- As a Sr. Functional Consultant, made significant contributions for Implementation and Customization of Oracle Applications (GL, Oracle Purchasing, Oracle payables, Fixed Assets and Oracle iProcurement Fixed Assets.
- Gathered business requirements for setting up the Oracle Finance Modules.
- Designed conversion strategies for conversion of legacy data into Oracle system.
- Implemented a custom solutions for various gaps between standard Oracle applications and the business requirements.
- Vendor/Customer Conversions.
- Documented Functional specifications, process flows, process flow definitions, as is and future state processes, testing strategies, UPKs and test scripts.
- Testing and implementation strategies for Oracle upgrades within 11i and from 11i to R12.
- Post go live Production support after Oracle module implementation.