Solution Architecture Resume
2.00/5 (Submit Your Rating)
SUMMARY
- Confidential is a US Citizen with over 18 years of pre - sale, delivery and support of Oracle ERP. Extensive collaboration with business/IT leaders to develop multi-year vision, strategy and roadmap dat leverage technologies to transform end-to-end business processes.
- Deep functional, technical and finance experience using Enterprise Resource Planning packages with focus on Oracle ERP. Over teh last 4 years, Confidential TEMPhas focused on implementing Oracle ERP Cloud Financials and Projects (PPM) solutions for customers across multiple sectors including Consulting, Life-Sciences, Financial Service and Education.
- He TEMPhas extensive hands-on experience with full life-cycle implementation projects and upgrades, including project scoping, requirements definition, solution design, conference room pilots, applications configuration, system integration, regression testing, training, deployment, and support.
- With experience in international and multi-organizational projects, Confidential is skilled in teh implementation of both country-specific requirements and custom solutions.
- Complementing his functional expertise is his in-depth technical knowledge, including table structure and developing SQL*Plus queries.
- Confidential is a member of teh Association of Chartered Certified Accountants (ACCA) from teh United Kingdom and Oracle ERP Cloud GL certified.
TECHNICAL SKILLS
- Oracle ERP Cloud - Finance (GL, FA, AR, CE, AP), Project Costing, Project Billing and Time and Labor
- Oracle EBS Financials, Projects
- System Analysis
- EBS R12 Implementation and Upgrade
PROFESSIONAL EXPERIENCE
Confidential
Solution Architecture
Responsibilities:
- Responsible for creating teh Solution Architecture for Oracle ERP Cloud Financials for teh new Transportation Business Unit with key consideration Chart of Accounts redesign, Ledgers and sub-ledgers.
- Architected teh flow of data from third-party application, frequency and method of data flow and impact to Oracle Sub-Ledgers and General Ledgers.
- Implemented Oracle RMCS (Revenue Management Cloud Service) to recognize revenue for teh Agriculture produce brokerage and transportation lines of businesses in compliance with ASC606.
- Facilitated design workshops for GL, FA, CE, AR, and Collections. Facilitated CRP, Testing and Training including building FR reports using FRC.
Confidential
Solution Architecture
Responsibilities:
- Responsible for creating teh Solution Architecture for Oracle ERP Cloud Financials with key consideration for E-Business Suite to Cloud consideration, Chart of Accounts redesign, Ledgers (Primary and Secondary) Business Units, accounting representation using reporting currency or translation.
- Delivered teh First Oracle Cloud Calendar conversion from Fiscal Year to Calendar Year.
- Implemented Oracle RMCS (Revenue Management Cloud Service) to recognize revenue for teh E-Commerce business to recognize revenue at teh time of shipment in compliance with ASC606.
- Architected teh flow of data from third-party application, frequency and method of data flow and impact to Oracle Sub-Ledgers and General Ledgers.
- Conducted requirements gathering sessions and facilitated design workshops, CRP, Testing and Training including building FR reports using FRC.
Confidential Group
Solutions Architect / Project Manager
Responsibilities:
- Demonstrated Oracle Financials Cloud and Oracle Project Portfolio Management (PPM) Cloud to prospective customers. Provided functional expertise during scoping and assessment.
- Responsible for creating teh Solution Architecture for Oracle ERP Cloud Financials and Oracle Project PPM customers with key consideration for Ledgers (Primary and Secondary) Business Units, accounting representation using reporting currency or translation.
- Architected teh flow of data from third-party application, frequency and method of data flow and impact to Oracle Sub-Ledgers and General Ledgers.
- Conducted requirements gathering sessions and facilitated design workshops for key GL (Reversing Journal, Allocations, Revaluations, Translations) and Sub-ledger processes using Oracle ERP Cloud in a Multi-org environments with considerations for inbound and outbound interfaces (Payroll, Employee Expenses, Investments and Banks).
- Created complex Workflow Approval Rules (Journals and Procurement) in BPM with pertinent setup in Oracle HCM Cloud.
- Used Oracle Rapid Implementation spreadsheet for key initial setup including COA, Suppliers and Customer.
- Configured Oracle AP for integration with Wells Fargo and Citibank (Wire, ACH, Positive Pay and Checks) with coordination with Oracle Support and Financial Institution.
- Authored teh Statement of Work (SOW) for each consulting engagement and liaised with teh internal Legal department before sending to clients for contract exchange and execution.
- Created multi-phase detailed project schedules to support project plans and execution. Constantly updating Project management templates (Financials, Risks and Issues Log) for updating and reporting project status to senior management.
- Managed functional and offshore technical teams to ensure adherence to project scope per SOW and to ensure timely project delivery.
- Facilitated techno-functional requirements gathering sessions and design workshops ERP Cloud implementation in a multi-org environment.
Confidential
Solution Architect
Responsibilities:
- Designed and developed teh solution design of unifying all of Axis Insurance and Reinsurance business onto a Single platform of Oracle. Performed data mapping of Policy Administration systems to Oracle tables via Universal Content Manager (UCM) for Premiums (GL) Claims and Premiums (AP).
- Integrated Wells Fargo bank integration for ACH, Positive Pay disbursement and check printing working with Oracle.
Confidential
Solution Architect
Responsibilities:
- Re-engineered business processes for Financials (GL,AR,CE,FA,AP) to meet Oracle and Industry best practice processes, cross-functional and cross-geographical.
- Led and mentored project team from both functional and technical perspective including requirement identification, solution architecture, integration development and project management.
- Analyzed current state technology environment, developed future state architecture and presented solution to Stake Holders.
- Performed detailed analysis of customer current business process, architect future process, solution design.
- Performed detailed analysis specific to Solar Energy including custom process for Asset Accretion and Waterfall Intercompany to account for Intercompany transactions between unrelated entities within teh same group.
Confidential
Functional Lead
Responsibilities:
- Conducted requirements gathering and facilitated design workshops for teh Oracle implementation in a multi-org environment.
- Designed a robust Chart of Accounts structure dat supported multiple divisions across multiple legal entities within teh same ledger.
- Built intelligence into teh structure to aid ease of data entry and reporting and built security and cross validation rules to safeguard access to teh General Ledger.
Confidential
Functional Lead
Responsibilities:
- Responsible for teh General Ledger, Project Accounting, Grants Accounting, Accounts Receivable, and Cash Management modules.
- Served as lead for all business process engineering, design, configuration, data conversion, testing, and support on all activities.
- Facilitated design workshops and conference room pilots.
- Configured teh Grants module to support teh management of sponsored and non-sponsored projects interfacing project budget to Hyperion Planning, configuring teh Sub-Ledger Accounting (SLA) to generate accounting.
- Documented business process (BR030 and BP080), MD050, functional specifications, and configuration documents (BR100).
- Created teh test scripts and training manuals for all teh core accounting modules.
- Responsible for liaising with management and other consultants to establish teh planning and coordinating of teh project.
Confidential
Senior Consultant
Responsibilities:
- Led teh core accounting team to formulate and redesign teh company’s global organization structure to meet fiscal, regulatory, and analytical reporting requirement, including agreeing on legal entities, ledgers for multiple accounting representation, and operating units around teh world.
- Facilitated Conference Room Pilots, led design sessions, and presented to teh senior management.
- Redesigned and mapped 11.5.10 Chart of Accounts to R12. Replaced sets of books with ledgers, multiple reporting currencies with primary and secondary currencies, and intra-company and inter-company with Advanced Global Intercompany System.
- Completed accounting setups using Accounting Setup Manager for key R12 features, including legal entities.
- Completed other GL setups, including cross validation rules and assigned security rules.
- Managed and conducted weekly meetings liaising with implementation teams in teh US, India, and Asia Pacific.
- Responsible for providing weekly reporting to senior management of teh ERP upgrade project.
- Provided project analysis for teh Steering Committee meetings.
Confidential
Senior Consultant
Responsibilities:
- Functional lead on teh Oracle 11.5.10 upgrade, covering all Oracle Financial modules and teh Human Resource Management System.
- Led requirement gathering team and documented teh “as-is” and “to-be” business processes.
- Facilitated teh CRP, systems, integration, and UAT sessions.
- For teh Oracle Financial modules, consulted with senior management to address key processes which required enhancements in teh upgrade, including adding segments to teh Chart of Accounts.
- Responsible for training users on enhanced functionalities, working with Oracle to resolve service requests and reporting back to teh Project Management team.
- Worked with internal and external auditors to ensure dat teh updated system controls were adequately tested and documented.
- Created test scripts for Oracle HRMS core, Advanced Benefits, and Self-Service Human Resources and Financials.
- For General Ledger, conducted teh manual systems Integration and UAT for General Ledger, Fixed Assets, Accounts Payable, Purchasing, iProcurement, iExpenses, HRMS core, Advanced Benefits, and Self-Service Human Resources using Quality Center.
Confidential
Senior Consultant
Responsibilities:
- Responsible for design, configuration, testing, and providing post go-live support and training.
- Responsible for teh redesign of teh COA and introducing concepts dat streamlined teh record to report processes.
- For Cash Management, established over 100 bank accounts and configured teh system to enable automatic reconciliation.
- Documented business process (BR030, and BP080), MD050, functional specifications, and configuration documents (BR100).
- Assisted teh TEMPPrincipal Consultant to create project budgets and to execute teh project based on teh budgets.
- Responsible for contributing to teh project and implementation plans and worked with teh client and PMO to ensure dat teh project was delivered on budget and on schedule and met stated business objectives.
Confidential
Functional Consultant
Responsibilities:
- Worked on requirements definition, facilitated design review sessions with end users, documented “as-is” and “to-be” fit processes and process maps for Oracle General Ledger and Oracle Projects.
- Responsible for documenting high-level General Ledger functional specifications, including setting 7 sets of books and 25 operating units coordinating with business users and implementation team members - developers, testers, and configuration management.
- Assisted with teh Project Costing configuration, which included setting up project templates, task structures, transactional controls, resource lists, expenditure types, key members, and teh Approval Management Engine (AME) for project and budget approvals.
Confidential
Consultant
Responsibilities:
- Responsible for data mapping into teh test and production databases.
- Ran conversion programs, spreadsheets, and scripts to clean, validate, load, convert, and audit legacy data.
- Performed data reconciliation, including trial balance of Oracle Financials to ensure it was accurately converted.
- Identified process/system issues and assisted in resolutions as part of continuous process improvement.
- Conducted post-migration balance sheet management as part of continuous process improvement.
- Conducted post migration balance sheet management, including AR/GL, VAT, Multi-Currency Bank Reconciliation, Debtors, Provision for bad and doubtful debts, and other ad-hoc reports for month-end reporting.
- Liaised with other Shared Service Centers to ensure teh accuracy of intercompany account balances and ensured its consistency with UK and US GAAP and group policy.