SUMMARY:

• Oracle Certified Senior Lead consultant with 16 years of experience in analysis, design, development, and implementation of large - scale systems with focus on Finance, Procurement, GRC and SCM.
• Oracle Cloud Implementations - Total 5 (Finance and SCM/Procurement).
• Confidential R12 Upgrade, Support, and Implementation SME: Completed 3 new R12, 5 Confidential upgrades.
• Oracle R12 Confidential data conversion/migration to Workday/SAP: Migrated Confidential Projects, HRMS, P2P, Finance, Contracts and Awards data to Workday and SAP.
• JD Edwards to Oracle Cloud migration.
• Oracle Confidential SOX Focal and Admin for Compliance and Security: Oracle GRC - AACG, TCG, PCG, CCG, APPSCAN, ACP P032(Access Control Policy), AEC (Services and Recovery), DRP, Focal for Change Management, SOD Matrix for approvals, Production Control, Function, Data Security etc.
• Worked for Utilities companies ( Confidential, Las Vegas Valley Water District, Tristate Denver, Nevada Power, Kairo Energy), Government (Dept. of Energy), Defense ( Confidential ) and Federal (Aerojet), Aerospace ( Confidential and PTI), City and Counties (King County Seattle, Clark County, City of Las Vegas, City of North Las Vegas and Yuma County), Health (UHC), Insurance and Banking, Transportation, Utilities, Waste Management, power and energy, Oil and Natural Gas, Pharma, Medical and Technology companies.
• Consulting for Big 5 consulting companies like Oracle, PWC, Deloitte and Solbourne.

TECHNICAL SKILLS:

Project Management: for SDLC, creating business requirements, Functional setup and requirement gathering, technical solutions, development, and testing. Experienced in creating AIM/OUM documentations (BR-100, MD50, MD70, DS-140, AN-100, IM-90 ).

External System: COUPA, Ariba, NetSuite, QuickBooks, PeopleSoft HR, Sales Force, SAP, Lawson, Hyperion, OBIEE, BI Publisher, SmartView, OBIEE, Dalmia and Workday, Powerplant, Avantis, Vertex

Configuration Management Tools: SVN, Clearcase, PVCS, Mercury Kintana/BMC remedy request System/Meriant Version Manager, Vista Plus, MS-VSS6, Agile, Waterfall.

Methodologies: Test Plan Strategies, QA analysis, Unit Testing & Module Testing, Integration Testing, HP Quality Center, Agile/Scrum methodology. Experienced with Oracle AIM/SDLC methodology, business process and Fit Gap analysis, Lift and Shift, "as is" and "to be " process flows, sales support and writing SOWs and BRs, Negotiation meetings and providing best approach with estimation and solutions.

Production Control and Change Management: SOX Focal, Adopt SOX guidelines for Change Management. Completed 8+ SOX audit as SOX focal. Production Control, Release/Change Management and User Management, SOD, M016, PO32 documentations and Appscan Oracle GRC - AACG, TCG, PCG, CCG

HP Quality Center: bug tracking

EPM: Supported ARCS, FCCS, PBCS, FAH/AHCS

PROFESSIONAL EXPERIENCE:

Oracle Cloud

Confidential

Responsibilities:

• Setup and Config - GL and AR Module with 44 countries and localizations.
• Fit/Gap analysis - Translate Confidential Setup and configuration to Cloud for GL/AR/OM modules.
• Conversion - Converting R12 BR100/CEMLI through Change Management/Release management and version Control into Cloud BR100. BR100 for FRS reporting (R12 BI reports to FRS)
• GL - CVR, allocations, SLA, Intercompany, support to OM and Revenue Recognitions.
• Feasibility analysis for adding new segment in COA. Mapping R12 5 segs COA vs Cloud 6 segs.
• Procurement Setup and Configuration, Integration, TAB accounting, Suppliers etc.
• Cloud Retrofit Workshops for Customizations (integrations, DFF, interfaces, localizations)
• Liaison between implementation team and internal team.
• Cloud Security - R12 Confidential Responsibilities, function security and SOD matrix to Oracle Cloud security and SOD Matrix.
• TAX Configuration - EB Tax for Canada and Vertex for US localizations.
• AR Configuration with support to R12 Custom tables, DFFs, Autoinvoice, country specific custom Invoice formats (Language, currency, address, format). Heavily customized Bill ahead/Bill later transaction types for invoicing.
• 44 countries Data consolidation and DRM (Financial MDM), Import/export of data to Confidential R12 Parent instance that has FAH configured.

Confidential, Los Angeles C

Oracle Cloud Implementation

Responsibilities:

• Setup and configuration - GL/AP/Purchasing/AR/CM/Expenses/FA
• COA and Structure Design - Responsible for designing COA segments and accounting structure with Mergers and Acquisitions, Master data reporting, EPM and Budgeting.
• Security and Audit - SOX/SOD/Audit and security controls, data access security for users etc.
• BR100 - Functional design, Modules config, Integration with 9 other external systems. Reports design using OTBI/BIP/SmartView/FRS (BS/TB/CF) and BI (Purchasing, Expenses template.
• Complex AP/AR Setup for Insurance Brokerage firm where Agent, Brokerage and wholesalers are involved and settlement was done after AP/AR Netting (Agent commissions, Brokerage fees, Insurance claims) settlement. AP, AR upload using API/Load, Collections and Billings.
• GL Rapid Implementation, COA, Intercompany rules, CVR, Allocations for multiple offices, Allocation Manager (Periods, Ledger set, Dimension, Allocated Scenario, etc) Allocation setup using FBDI template, Journal Load, AP/AR Invoices, Bank files. Inv Imaging etc.
• AP Multiperiod Accounting and Prepayment. AR Refund to AP payment and AP refund process.
• Invoice and expense report imaging for AP Invoices and Expenses (with Bar Code)
• Setup and Support for ARCS (Periods, Formats, profiles, buckets, data load, worklist, matching, reconciliations, activities, views filters etc)
• Setup FCCS and involved in monthly consolidation activities. Troubleshooting and following up with Oracle for related SRs.
• FAH - Rules and mapping for FAH for 3 external systems.
• CRP, SAT, UAT, training videos, Cut-over, production move, go-live planning.
• Production and 3 months postproduction support. Created and managed 100 plus Oracle SRs during implementation and postproduction.
• UC Office of the President (UCOP) is currently underway with a Financial System Replacement (FSR) Program. Two key projects under the FSR Program include the Financial Information System (FIS) project and the Planning and Budgeting System (PBS) project. UC San Diego (UCSD) and UC Merced (UCM) are also underway with finance transformation efforts.
• Quick Assessment, Requirement gathering, business process mapping and proposed solutions.
• Sourcing/Supplier Portal and qualification setup, workshops, CRP1
• Self-Service Procurement and Supplier Qualification setup and Requisition Compliance review.
• Procurement/AP setup, TAB Accounting, Descriptive Fellfields (Req2PO) setup for custom data.
• PO/INV workshops, setup and requirement gathering, FBDI and AFBDI data mapping.
• AIM Documentations, CRP1/CPR2 Demo preparations.
• Oracle support for Integration with COUPA procurement (existing system)
• Procurement SOW Preparations with Oracle Consulting.
• External system considerations - COUPA, NetSuite and QuickBooks.
• Understand the current system and Assessment for migration to Oracle Cloud.
• Procurement/Inventory Setups with Supplier Portal
• GL Configuration and Implementation - COA design, CV rules, Allocation formulas, validation, and SLA.
• Procurement/Purchasing/INV/AP Fit and Gap, Data Integration with existing systems.
• Assessment for Open POs migration strategy and lift and shift analysis.
• Contingent workers and Services procurement.

Internal Project with 9Edge: Worked on developing JDE to Oracle Cloud conversion utility/Tool (packEdge: A Pre-configured Accelerated Configuration Kit for Food Processing, Industrial Mfg. & Life Sciences industries). Also worked with couple of 9Edge team working on JDE to Oracle Cloud migration.

Confidential, San Jose CA

Oracle Cloud GL/Procurement

Responsibilities:

• Oracle Fusion Procurement and GL implementation. AS and Lift of COA to fusion from Confidential .
• Interaction with Business users. Gathering requirements and proposing solutions.
• Involved in Analysis of COA, BU, LE, Cash Flow, TB ad BS setup
• PO/SCM support, Data load and Mapping.
• COUPA integration for Invoice and Expenses.
• Leading and close interacting with development team (India) for R12. Client is using heavily customized Confidential R12 version. Also working on redesign to R13 Cloud P2P upgrade roadmap.
• SOX/SOD/Compliance/OUM documentations.
• Ensure all the security controls are in place and all the yearly Audit reports are up todate.
• Oracle HR to Workday and Procurement Coupa to Confidential .
• SOX Controls - S1 to S6 controls (Security, Production, Unix, Job failures etc)
• Implementation of SOD and UAR application - Software selection, analysis, and comparison between various vendors (Fastpath, QSOftware, Onapsis etc).
• Oracle AP outbound (Oracle program for liability and pay group mapping using AP Interface for Ariba Invoice groups.

Confidential

End to End Implementation

Responsibilities:

• Services Procurement, Expenses and HR (default) setup and configurations.
• Involved in Functional and Technical Assessment tasks, AIM documentations, CRP, UAT, user training, preparing user manuals, unit testing, production migration, post-production support and enhancements. Working with technical, DBA, Oracle Support and PM for Support.
• Converted POs to Contingent Workers assignment (GBPA to Std PO and assigned to CW in OTL).
• AP Expense lines and GL Transfer customizations. Prepayment and Travel customization.
• AME, Setup security groups and security feature in Purchasing.
• Line type customizations (Labor and Hour), Requisition POR custom pack requisition, new validation for requisition checkouts.
• Helped with AME configuration, Requisition Compliance Review (RCR). New AME rule for PO Approvals.
• Enabled HRMS and setup HRMS and OTL modules to record timesheet for CW. Oracle Projects to track projects.

Techno-Functional Lead Consultant

Confidential, Santa Monica CA

Responsibilities:

• Worked with Oracle Consulting for Assessment tasks.
• IExpenses Travel and Expenses for travelling and employee payments.
• GL/AP/AR Setup, Rapid Implementation.
• Oracle Cloud Data migration (lift and shift) for one of the OU to BU.Involved in R12.2.6 upgrade planning and leading development team and assessment for 12.2.8.
• Leading technical development team (Documentation, testing, CRP, review with Client etc)
• Worked on CEMLI assessment, Creating MD-50/70 for BI Publisher Reports and CM/Release management task, Assessment for Procurement and Purchasing.
• System Administrators task and upgrade including AOL/FND and removal and reconfiguration of System security, responsibilities and function security.
• Working on CPR1/CPR2 signoff. Preparing current and proposed AP/PO setups, Projects and Contracts tracking, Lookup change.
• Configuration and Supported SCM, Planning, Finance and P2P for R12.2.6 upgrade, Cash Management and Accounts Reconciliation.
• Technical support for Oracle Projects Contracts & Billing modules (mainly BIP reports).
• P2P/SCM daily/monthly issues and support, implemented Service contracts and Procurements.
• Implemented automated controls using PCG, AACG, CCG and TCG for Oracle ERP Modules.
• Implemented SOD Controls/Rules for Oracle P2P, P2M and O2C modules.
• Involved in implementation of TCG, AACG 8.6.5.9000
• Support to Internal Auditors/Audit and Sox Teams
• Implemented 26 GRC rules for Inv, BOM, GL, Items, requisitions etc.
• Monthly Audit and security control report (user, access, responsibilities and last login).
• SOX Queries and validating SOD and time stamp of evidence (gathering and collection).
• Oracle Confidential /HR to Workday Migration - Finances, Award and PO data migration to Workday.
• Migrated/conversion of Awards, Project and Tasks with Billing data and data masking to workday including payroll.
• HR Employees, daily files and payroll data to Workday.
• Support and Leading - AP/AR/GL/PO data migration/conversion technical team.
• Ledger conversion and Customer/Supplier data to Workday
• Employee data conversion to Workday.
• Data Normalizations, SQL query writing using TOAD, Excel data output, data standardizations (working with the status/WF - Closed, open, paid, cancelled, terminated, partially paid, accounted, posted, close/open periods, booked, awarded, granted etc.)
• Excel conversations - Massaging of data in staging tables (converting IDs to real segment values and attributes values, CCIDs to workday attributes, parents-child to one-on-one parent child, drop-down (valueset values) to attributes, Workday attributes decoding, fetching oracle Ids etc.
• PTI Aerospace protects lives and livelihoods with its differentiated technology and know-how, operating with a deep insight into customer needs and agility.
• Functional and Techno-Functional (design, Setups, BR.100, MD and CV design docs, Solution Provider, Development and Support (trouble shoot issues, run and maintenance) Modules: Oracle Finance modules
• Involved in support and fixes.
• Implementation of Oracle Cloud GL/AP/AR
• Data gathering and setup. Leading 4-member team to implement COA/BU/GL/AP/AR.

Oracle Confidential Lead

Confidential, Seattle WA

Responsibilities:

• Oracle Cloud Implementation for one of the Org with Oracle consulting. Analysis and design for Gl/AP/AR modules.
• Leading Off-shore TCS team for development work, daily calls, reviews and allocation of work.
• Worked with external consulting company to implement Oracle Cloud upgrade. Involved in initial discussion, upgrade process, mapping, as-is, lift and sift analysis.
• Being a SME, actively participated in Assessment, Requirements gathering, functional gap analysis, application design, configuration, modules setup. Responsible for code review, BR-100, MD-50 and MD-70, allocation of work to off-shore team of 20 consultants. Experienced in leading in-house and off-shore teams for technical, production support (data fixes, patches and new requirements) and post-implementation support. Involved in configurations, CEMLI objects, analyzing functional and technical specifications for conversions/interfaces/reports and customizations, record defects using HP QC defect system. Worked on SAP data conversation and data export to SAP.
• Production Support: Involved in production and functional support by providing solutions for Ledger transfers, AP/AR/OM/SCM/ Kits/Collections/TOP Kits, WMS, MSCA, ACH, P-Card, Cycle counts, PO approvals, AME issues, Sales Order, Workflow, Mobile application scanning and setup, SO ACK, BOM and ECOs, Various interfaces, Imports and APIs, month-end jobs, month end closing, Account generator issues, Worked with COGS account generator for interfacing between Order management and Inventory, Use of API and daily Interfaces. Also supporting payroll and HR issues. Supported issues with costing (standard vs average, LIFO and FIFO). AP and AR Support, DM and CM settlements, Refunds processing, Revenue Recognition Accounting Rules, Bills in Arrears etc. period open-close issues, supported user calls, daily transaction, Interface issues and testing, Item move, move orders, sales order, shipping and order processing O2C cycle support, Work Bench Planner, WMS, APS, Memory based planner, Supply chain planning, Planning data collection, etc. ACH deposits, Bar code reports and Pick Slip, Cycle count and bin/locator reports, Tax calculations and SLA/monthly transfer support, log file generation resolving issues with import/export/interfaces, closing, monthly AUC jobs, running and scheduling jobs etc.
• R12 - Implementation/Upgrade: Being BA, responsible for instance upgrade, gap and fit analysis, configuration, Completed 2 upgrades, 1 R12 implementation (re-implementation from 11.5.8) and 1 new R12 implementation in 4 years with this client. Involved in Setups (Suppliers, banks, Orgs, migrations, import and interfaces, conversations and setups, RCR, Procurement Contracts and Service). Involved in CRPs, mapping sessions, mock-runs, dry-runs, Oracle to SAP conversions, OSCE to Oracle 11i conversion (in millions). Contact person for BAAN/SAP/SONIC interfacing teams.
• SOX Control/GRC: SOX focal for 2 of the Confidential projects. Responsible for creating, maintaining and validating UNIX Controls, USER Controls and Change Management reports for SOX Audits. Attended 4 yearly audits. Implemented RBAC (Role based access control)
• Build Release and code deployment: Maintaining IBM Rational Clear Quest for creating PRs/CRs and moving code across the instances. CR/PR approvals, SOD, test instance setup, acceptance testing, move sheet, coordination with DBA and CM team to move/release the code.
• Document Control: Responsible for completing APPSCAN, Risk-Sorter, DRP and various controls, M016 and PO32 documents.
• BI Publisher Bursting, Workflow Approvals and AME (Setup: chain of authority based on relative job level, Chains of authority based on number of supervisor levels.

Oracle Confidential Consultant

Confidential, Seattle WA

Responsibilities:

• Due to major business/structure changes, King County decided to go for re-implementation of Oracle Application to R12 from 11i. I was involved in Setup and re-configuration for GL, Cash Management and Purchasing Modules and cross functional projects in R12.
• Involved in BR-100, requirement gathering and discussion with various departments, MD-50 and MD-70 documentation, development methodologies.
• As a BI publisher Enterprise Administrator, created 50+ BI Publisher reports using BI Administrator for Confidential R12. Also enable bursting features to distribute reports for departments as per department and Job roles.
• After go-live support for month-end processing, period close/open, interfaces and transfers.
• Created Comptroller reports for county.

Sr. Application Developer - FTE

Confidential

Responsibilities:

• As a BA and Support Tech Lead, I was Involved in co-ordination with production support team, Oracle Support for patches/SRs, business group and working closely with Project manager for day-to-day activities.
• Involved in helping contractors for technical work i.e. custom forms, reports, PO process, RFQ/Quotation process, conversions and interfacing with mainframe, powerplant and other systems.
• Implemented iProcurement and iSupplier (Functional)
• Involved in upgrading Oracle Applications 11.5.10.2 to R12.1.2
• Gap Analysis (upgrade vs re-install), Test install and upgrade R12 and compare functionality.
• Worked with functional and end users to identify issues with upgrade, Opening and escalating SRs with Oracle support. Identified 400+ issues during/after upgrade and solved majority of them.
• Supported and configured GL extract to Power-plant.