Sr. Oracle Finance Solution Architect Resume
Addison, IL
SUMMARY:
- 12 plus years of Oracle ERP implementation, customization, development, integration, support and management experience in highly complex and customized environments (Multi - org, Multi-currency, and Multi-site, Localizations, NLS)
- Over 15 years of total professional experience - providing functional leadership, motivating personnel, and coordinating activities to ensure quality performance within designated project timeline Managed team sizes from 5 to 15 consultants including offshore.
TECHNICAL SKILLS
Oracle Applications: Version 10.7SC / 11.0.3 / 11.5.9 / 11.5.10 / 12.1.1 / 12.1.3 GL, SLA, AR, AP, Payments, TCA, E-Business Tax, FA, CM, PO, Project Accounting, OM, INV, WIP, BOM, IPM, SA, AOL, iSupplier, iExpenses, iProcurement, iReceivables, Alerts, Oracle Workflow, SOA, OBIEE, FSG, OFA, BIS, ADI and Flexfields, XML Publisher, Forms Personalization, Country specific Localizations and NLS/MLS
ERP Engagement Expertise: Oracle ERP Implementation, Solution Design, Upgrade, Project Management, Project Delivery Planning, Project Scoping, Application Controls, System Integration, Application Development, Business Process Re-engineering, Release Management, Production Support, User Training and Testing, Complete System Implementation & Development Life Cycle: Requirements Analysis, Business Process Study, Fit & Gap Analysis, Enterprise Mapping, System Interfaces, RICEW, System Controls, SR/TAR Management, Transition & Conversion Mgmt.
Other ERP/Related Skills: GAAP Accounting, Month End Close Process, Integration between core Financial Modules - GL, AP, AR, FA & CM, Financial-Supply Chain/Manufacturing Integration, Financial-Project Accounting Integration, COA Design, Multi-Org Design, AR Billing System Design/Integration, Credit Card/ ACH Prepayment, Revenue Recognition, Global Consolidation, Global Intercompany, MRC, Banking integration, Scanning solution integration, Tax integration, FA Tax Books, Approval Management, Oracle internal Processes and integration points, Table level Architecture, Working with Oracle Support and Oracle On-Demand etc.
Implementation Methodology: Oracle AIM, Oracle: Fast Forward, Oracle OUM
Development Methodology: SDLC, OOAD/UML-SDP, E-R Modeling.
Development Tools: Oracle Toad, SQL Developer, Oracle Developer, Oracle Workflow Builder, SQL*Loader, Data Loader, JDK, HORA, TOAD, KawaPro, Editplus
Testing Tools: Mercury Test Director, Mercury Load Runner, Integra migration, UPK
Languages: SQL, SQL*Plus 8.0, PL/SQL, HTML, JavaScript
Databases: Oracle 7.3, Oracle 8.0.5 Enterprise Edition, Oracle 8i, Oracle 10g, MS Access.
MS Products: MS Projects, Visio, Excel, Word, Power Point
PROFESSIONAL EXPERIENCE
Confidential, Addison, IL
Sr. Oracle Finance Solution Architect
Responsibilities:
- understand the existing core financial setups and business processes in R11 along with the enhancement/improvements requirements and suggest the best fit solution into Oracle Financials R12. Full lifecycle - Requirements, fit/gap, CEMLI, Conversion Strategy, Testing Strategy, CRPs, UAT, Go-live.
- This included all the integration points with other modules like - TPC Website, OM, Payments, Purchasing, WMS, MDM, OBIEE and SOA. Lead a team of 4 functional consultants.
Confidential, Lombard, IL
Oracle Finance Solution Architect
Responsibilities:
- my mandate was to understand the requirements - i.e. understand the differences that exist between the 2 LE’s.
- Come up with the scope of work and strategy - configurations, reporting, operational/process changes, legacy Data conversion strategy for GL, AP, AR & FA and integration points between Oracle Projects and AR, AP & GL.
- Execute the strategy, Perform CRP’s and UAT’s & Go live.
Confidential, Chicago, IL
Finance lead
Responsibilities:
- responsible for the successful configuration of the upgraded system - SLA architecture, TCA, E-Business Tax, Payments to enable behavior of existing functionality, upgrade testing and issue resolution.
- Complete life cycle implementation - Test scripts, CRP, UAT, cutover and go-live support.
Confidential, Rosemont, IL
led the Solution Design
Responsibilities:
- implementation of Financials for US, Canada, Mexico and France.
- Provided leadership and Solution through all phases of the implementation, including as-is and to-be process design, gap analysis, overall solution design, Multiple GAAP representations, localizations, NLS and RICE specifications etc. Provided support for all global implemented locations including U.S. and Canada for issue resolution and new functionality deployment.
- Led the planning effort for the next implementation phase for Romania and Financial/Accounting integration for the Manufacturing Project
Confidential, Chicago, IL
Client Project Manager
Responsibilities:
- responsible for coordinating client resources with implementation partner project manager - to identify and manage phase scope, deliverables, budgets, controls, project plans, issue and risk logs, change requests.
- Participate in TO-BE Process modeling workshops for designing future business processes.
- Working with User community to establish Use cases, Test Scripts, Testing Plans, CRP, SIT, SOP’s etc.
- Enabling Technologies and bolt-on application Vendor Relation and integration planning - Vertex, Covus, Fujitsu, Birchstreet, Fintech.
- Managing Legacy system vendor - CSC for conversions and interfaces.
- Complete life cycle implementation - requirements, design, deployment to full system integration testing to production support.
Confidential, WI
Oracle COE Project Lead
Responsibilities:
- responsible for the successful delivery and implementation of various Oracle ERP Programs.
- Working closely with the PMO and Client Service Manager (CSM) to identify Scope, deliverables, budgets, controls, phases and project plans.
- Working with User community to establish Use cases, Test Scripts, Testing Plans, CRP and SIT using Mercury Test Director, SOP’s etc.
- Complete life cycle implementation form requirements, design, deployment to full system integration testing to production support requiring deliverables like Requirements, Use Cases, MD60’s, MD63’s, MD70, Test scripts, Traceability Matrix, Capacity Plans etc.
Confidential, Atlanta, GA
Project Lead
Responsibilities:
- PPO team for implementing new enhancements and new module release at Confidential Parts business which contributes $ 2 billion to the overall GE business.
- Having responsibility for the successful implementation of both the enhancement and new projects.
- Planning and execution of the quarterly enhancement release cycles - BRD, Functional Specs, development, testing, training and release management.
- Scoping and Integration of new projects/modules into the existing Instance.
Confidential, ODC
Project Lead
Responsibilities:
- Business Intelligence (BI) reporting requirement of Agilent around the world.
- The Scope was development of BI reports in Oracle ERP - using Oracle Discoverer, Brio and Oracle D2K and to suggest work-around where applicable.
- Utilization of complete development life cycle - user requirement, design, build, testing, acceptance, and production environment release.
- Conducted SOW finalization, Progress monitoring, Metrics collection, Progress meetings, Quality management, Expectation management and Team Development.
- Assisting client users in the development of functional specifications by understanding their requirements and then relating these to the backend architecture for best performance.
Confidential
Project Lead and Solution Architect
Responsibilities:
- for a complete life cycle implementation - lead the complete solution and design of the entire suite of Oracle Financials.
- This included SOA finalization, Business Process study; As-Is and Requirement analysis, Gap and fit Analysis; Workarounds; Solution Design and To-Be Modeling, Extensive User Training; CRP, System and integration testing; Legacy data extraction; Legacy data conversion; COA Design, Reports customization; Legacy billing system integration with Oracle AR; Revenue Recognition, Standard Operating Procedure (SOP) documentation; FSG Reports.
Confidential, Santa Clara, CA,
Project lead and SME
Responsibilities:
- for a full life cycle rapid vanilla implementation of Oracle GL, AP, AR, FA, PO and Cash Management, for a startup Internet Auction Company.
- Responsible for Business Process study, COA Design, Gap Analysis, Business Process Reengineering, Setting up the application, CRP, Unit & System Testing, User training and Data conversion for ‘go live’ production.
Solution Architect
Responsibilities:
- responsible for conceptualization, design, development and operations of multiple billing systems for Confidential .com reverse auction web site.
- Lead a team of 12 resources for development of a Java and Oracle Financial integrated, scalable and distributed billing application using an iterative and incremental life cycle development approach.
- Solution involved inbound and outbound interface development between the web site and Oracle AR.
- Major Integration with Oracle AR - Customers, Auto-Invoice, Lockbox interface etc.
- Complex Revenue Recognition, Customization of Consolidated bills, Dunning letters, Lockbox. Also implemented a Closed Billing System where buyer’s pay in advance for specific categories and sellers were paid later at a given time.
- This involved major integration with Oracle AR and AP - developed custom supplier interface, automatic creation of AP invoices with correct contra entries to offset AR accounting entries, sales tax implementation, and adjustment interface. Other modules developed - Subscription billing, Dispute resolution module, Promo code system etc.
Functional Lead
Responsibilities:- responsible for Oracle GL-AP-PO pilot project involving pilot implementation support, training, testing (unit and Integration) and troubleshooting.
- Setup feature highlights are Budgetary Controls, Encumbrance Accounting, and Reporting Attributes.
GL Functional lead
Responsibilities:
- for Fastforward plus Oracle GL-HR-Payroll-OTM implementation.
- Responsible for GL Business Process Study, Mapping (via setting up of Chart of Accounts, Calendar and Currencies), user demonstration, training, testing
AR Functional lead
Responsibilities:
- for Fastforward plus Oracle GL and AR implementation.
- Handled Business Process Study, Mapping (via the setups), Reporting requirements and implementation, Reconciliation of Accounts, Customer and AutoInvoice interfacing, Lockbox interface, user demo and training.