Lead Oracle Analyst Resume
San, JosE
Experience Summary:
- Cost Accountant (~CPA) with over 15 years of extensive knowledge of commercial and government accounting, consulting, training and project management experience and has a proven track record of applying these principals across multiple industries.
- Strong expertise in designing and implementing a global chart of accounts (COA), global Ledgers, Secondary Ledgers including STAT and GAAP, Legal Entities, Reporting Currency (RC) for Consolidation, Inter and intra - company setups and configurations and accounting / custom SLA within the Oracle General Ledger Release 12.
- Experience in Full lifecycle software development and project management utilizing various methodologies including Agile/Scrum, Waterfall or hybrid. Conducting fit gap analysis of system capabilities, designing custom solutions, collaborating with IT teams for custom solution development and system extensions, providing production support. As a project Manager I handled Multi Million dollar projects with team size of 50+ including mix of IT Analysts, Developer and Testing team .Prepared Project and cutover plan, Stakeholder management, weekly / monthly reporting. As Business Analyst Highly-performing with proven ability to collect unstructured requirements through customer workshops and develop strategy to build the products. Worked with analysts, customers, Domain experts, sales and professional services to define the product solution. As an Oracle Apps Functional Consultant proven on resolving complex client challenges by developing innovative and practical solutions with implementations, Upgrade, Development and Production support of Oracle Fusion Financial, Oracle Apps-R12 & 11i. Financials; Distributions modules like Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL), EB-Tax. Successfully completed Vertex integrations with E-Biz.
- Oracle General Ledger, MOAC, SLA, AGIS, FSG Reporting, Implemented SLA using both standard and custom SLA sources
- Procure to Pay processes for both expense and inventory items, including Purchase Accounting, Receiving and Accrual Accounting
- Implemented Oracle Account Payables (AP), I Expense, Approval Management Engine (AME) with business specific rules
- Implemented Global Payment formats using Oracle Payables for Logitech Inc
- Worked extensively on support projects, handling day to day issues meeting agreed SLA’s, supported during international time zone handled Level1, Level2 tickets, provided short term and long term solutions and prioritizing enhancements in highly customized, multi system integrated environments . Hands on experience on supply chain modules including Oracle channel revenue management module, POS systems and multi-tier customers (Tier1, Tier2 and Tier3)
- Worked on IPM (Imaging & Process Management) integration with Oracle for Imaging solution on payable invoicing
- Cost Management using Oracle (FIFO and Standard costing), Costing for Reverse Logistics, Intercompany, AGIS, Profit in Inventory, COGS recognition
- Using Multi-Org for Supply Chain and Financial solutions
- Implemented & Supported Oracle Financial Modules AR, AP, GL, EB-Tax, I-Expenses, Fixed Assets and PO modules
- Hands on experience for support, implementation on Oracle Learning Management, Oracle Time and Labor, Financial integrations with Project Accounting, Advanced collections, EDI Invoicing.
- Implemented Oracle Workday, Oracle integrations for C workers
- Worked on Oracle Side for integration with Zuora Revenue Recognition tool.
- Snowflake Reporting
- Implemented the India GST solution for Cisco India .
- Implemented the Oracle and Vertex Integration for Logitech to be Tax Complaint.
- Successfully supported lot of Compliance Audits, SOX compliances
PROFESSIONAL EXPERIENCE
Confidential, San Jose
Lead Oracle Analyst
Environment:Oracle Account Receivables, Intercompany, SLA, Reporting, Interfaces, System Integration with IRS (Indian Revenue Services), Integrations with Multiple ERP’s and BoltOn system, EbTax,.
Responsibilities:
- Translating requirements to feature descriptions for the business group. Completed Fit GAP Analysis
- Prepared Business Requirement Document and communicating business requirements to effectively to the technical team.
- Prepare prototype and detailed documents; update status to the senior management to enable effective decision making.
- Analyzing and Designed India specific accounting / reporting requirements satisfying Local GAPS using SLA and Secondary Ledger
- Designed platform for multi system integration and attribute exchange
- Customer Conversion and Address changes, incorporating GSTIN related changes at customer / Site levels
- Analyzed and Designed solution for Location Based Accounting
- Defined India specific E Invoice template, Attribute Mapping, Error Handling and interface to IRS through Bolt On System
- End state preparedness with cutover planning.
Confidential
Oracle Functional Analyst
Environment:Oracle Account Receivables, Intercompany, SLA, Reporting, Interfaces, General Ledger, Snowflake
Responsibilities:
- Successfully went live on Sep-21 . Involved right from inception to sign off of the project, My role include-
- Planning the Data Migration and data cut off
- Engaging Cross teams for data validations and getting sign off
- Prepared Roadmap and Phase wise implementation, working with multiple teams including Snowflake, Oracle DM, DBA’s, SOX Controller office, Internal auditors in addition to MFG, Service Contracts, Finance and Planning teams stakeholders.
- Migrated 300+ tables from Oracle 11i to Snowflake
- Prepared Data Archival strategy and finalized reporting requirements after coordinating with finance data stakeholders
- Identified data and Audit requirements and gathered sign offs from multiple stakeholders
Confidential
Product Owner
Environment: Finance, Tax, Reporting, Interfaces and Compliances
Responsibilities:
- Translating requirements to feature descriptions for the business group. Collaborate with executives in product management in defining vision and product roadmap. Communicate stakeholders to come one common ground for product design.
- Lead and Participate in All Agile Ceremonies Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective
- Create Story and Requirement Traceable matrix and conduct gap analysis based on business as well as operational requirements. Define & implement project control parameters aimed at seamless implementation of assigned projects.
- Assess information consolidated from multiple sources, reconciling conflicts, decomposing high-level information into details and abstracting low-level information to general understanding
- Maintain clarity of business objectives to be communicated to the technical product team.
- Draft / review scope/ statement with business stakeholders to align project deliverables to business requirements of clients.
- Indirect tax related changes as integration with Virtual Traders, Sabrix, Tax Finance invoices etc.
- E invoicing and multi-currency reporting for import and export invoice for south Korea.
- Worked on determining configuration requirements and SLA changes
- Design and offering solution for Intercompany costing and accounting needs taken care with Sub Ledger Accounting
- Reporting requirements
Confidential
Senior Consultant Oracle Applications
Responsibilities:
- Responsible for providing client support, offering expertise in problem tracking, replication, troubleshooting, diagnosis and resolution of complicated and critical cases
- Lead team of offshore resources
- Manage Oracle quarterly patch testing efforts
- Hands-On Oracle Cloud Financials configuration and issue resolution
- HANDS-ON resolution of support tickets as well as management of offshore team of resources
- Responsible for the education of clients on Oracle’s quarterly release deltas/new enhancements
- Provide best practice recommendations as well as status to upper-level management on new projects as well as current production environment health
- Define testing scenarios and develop test scripts.
- Utilization of BPM for workflow updates/modifications
Confidential
Senior Consultant Oracle Applications
Responsibilities:
- Enterprise Structure Setup using Manual configurations
- Created Report using OTBI
- Configured Test and Dev environments by utilizing Rapid Implementation Templates.
- Implemented Oracle Fusion Financial modules include General Ledger, Accounts Receivables, Fixed Assets, Accounts Payable, Procurement and Cash Management. Analyzed and Setup Custom SLA as per client specific requirements
- Designed and implemented Subledger Accounting (SLA) rules across AP & AR.
- Uploaded and migrated client’s specific data, configuration by utilizing seeded templates and
- Rapid Implementation templates
- Developed and tested solutions in collaboration with end-users, execute production migration and post-install after care
- Planned and recommended Production to Test (P2T) strategies to reduce implementation time.
- Led the Conference Room Pilot (CRP) workshops and User Acceptance Testing (UAT)
- Worked with Oracle Development to resolve Service Requests and backported future functionality to current Release R12.
- Involved with business users to understand accounting changes related with Intercompany requirements.
- Intensively Worked on Requirement Gathering and Addressing customizations.
- Configured Account Payables, SLA, GL, OM and Inventory modules.
- Design and offering solution for Intercompany costing and accounting needs taken care with Sub Ledger Accounting.
- Presenting recurring changes to Business stakeholders and taking approvals on functional changes.
- Reconciled transactional data between R11 and R12 instance.
- Using secondary ledgers approach for consolidations in General Ledger.
- Reconciled Accounting changes between 11i & R12 and reporting to Business.
Confidential
Senior Consultant Implementation
Environment: JDE, AP, AR, GL, FSG Reporting, FA, MOACCisco implemented ASC 606 for Revenue recognition for US, CAN and Brazil countries
Responsibilities:
- Prepared detailed impact assessment of ASC 606 guidance on Revenue business systems processes
- Prepared RFP document giving SWOT analysis for each impacted business system area
- Conducted multiple sessions with Business Users to understand how Revenue for non-standard deals is captured and reported, Identified changes (i.e customizations/ extensions/new reports) to be added for reporting revenue under ASC 606 guidance
- Implemented Oracle AR, GL & Account Payables
- Enabled FSG Reporting with half yearly reporting capability for Opex and cogs reporting (Customer specific reporting requirement)
- Providing post production support, configuration and testing setups related to all Oracle Finance functional modules.
- Troubleshooting and handling issues with Account Receivables Auto invoice, issues related to Sub Ledger Accounting and handling period end exceptions, Supported on issues with Sub ledger to GL reconciliations.
- Customizations related to Customer Onboarding design and develop solution end to end drive through front end GUI approvals using workflow. Involved in design and testing the solution.
- Worked extensively on providing functional support for issues related to Month End Processes, GL reconciliation, Accrual Process, Period End Closing.
- Designing and coordinating with Development team on Objects. Taking them through Change Review Board, testing changes.
- Preparing project documentation as Functional Solution Document, Std Operating Procedures, Training and Setup Documents.
Confidential
Functional Consultant
Environment:Oracle Payable (AP), Oracle Receivable (AR), AGIS, SLA, Order to Cash and Procure to Pay, iExpenses
Responsibilities:
- Configuring and testing setups in AGIS, SLA, General Ledgers and Fixed Assets.
- Preparing project documentation such as MD-50 after analyzing BR-100 Standard Operating Procedures, Training Materials and Setup Documents.
- Worked on Mapping and migrating Asset categories and setups as per changes required due to accounting segments.
- Helping User base on SIT and UAT. Organizing setup documents for Financial Module. Preparing design document and getting it approved from Business Analysts at Logitech.
- Single handedly delivered End to End implementation of iExpenses module for Logitech within time and budget
- Designed and tested Mexico Factura inbound - outbound invoicing Custom process with Oracle.
- Worked on implementing Global banking payment format in Logitech, testing it and helping with sign offs.
- Setting up and implementing Credit cards integrations and testing end to end functionality. Preparing user training documents.
- Worked on Setting up EDI invoice outbound process between multiple systems
- Analyzed ASC606 standards and compliance from Logitech perspective.
- Workday integration for Employee HRMS for C workers.
Confidential
Functional Consultant
Environment:Oracle I Expenses, Fixed Assets, General Ledger, Account Payables, Accounts Receivables, Oracle E-Biz 11.5.10.2
Responsibilities:
- Configuring and testing setups in Accounts Payable, Accounts Receivable, General Ledgers, and Cash Management
- Prepared Functional Solution Document, Standard Operating Procedures, Training Materials and Setup Documents
- Handling Integration issues for EDI Inbound and Outbound. Maintaining and managing the Tax codes with Sabrix.
- Worked on IPM integration with Oracle for Imaging solution on payable invoices, Supporting Internal Auditors with SOX Audit requirements and process adherence
- Worked extensively on providing functional support for issues related to Month End Processes, GL reconciliation, Accrual Process, Period End Closing, MRC, Revaluation, Translation and Financial Statement Generator (FSG) process
- Defined formulas for Mass Allocation and Recurring Journals. Completed setup of options required to perform Mass AllocationsAP, AR GL Reconciliation month end and quarter end support, providing RCA’s and proactively handling issues
- Worked on setting up of FSG, MRC, Revaluation, Translation and Consolidation process. Involved in setting up Expense Report Templates and creating expense reports.
Confidential, Burlington MA
Team Lead
Environment:Oracle I Expenses, Fixed Assets, General Ledger, Payables, Project Accounting/Costing, Oracle E-Biz Suite 11.5.10.2
Responsibilities:
- Gather and analyze user requirements for new enhancements in the application,Prepared design document for new enhancements. Analyze issue with respect to functionality, setups, process and data.
- Helping end users to understand the business process and daily activities of Invoicing, Customer Management, Accounting the transactions and transfer to ledger and month end book closing.Test the components with respect to the functionalities requested by the users. Preparing TE-40.
- Worked on customizations for iExpense workflow on certain expense items dual approvals required, worked with business on analysing requirement and implementing it using customizations.
- Understanding requirement and preparing Functional Design documents MD-50 and taking business approvals.
- Developed custom objects, required views.
- Testing and closely worked with Business for UAT and taking signoffs.
- Setting up and mapping custom lookups and testing it with dependent objects on destination instances.
- Developing and testing the reports, coordinating business on UAT and taking business sign offs.
- Developed on 50 + reports customization / Development and delivered on time
- Developed Lot / Serial number interface