SUMMARY

• EBS Upgrade and Implementation: Completed Three R12 and 5 EBS upgrades.
• Implemented Oracle Fusion R13 - Three implementations (Finance, Procurement)
• Oracle EBS data conversion/migration to Workday/SAP: Migrated EBS Projects, HRMS, P2P, Contracts and Awards data to Workday and SAP.
• 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, RBAC (duty / data, templates roles, and data security policies, RBAC, SOD Matrix for approvals, Production Control, Function and Data Security Controls, etc.
• 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.
• Worked for Govt (Dept. of Energy), Defense (RAND Corp) and Federal ( Confidential ), Aerospace ( Confidential and PTI), City and County (King County Seattle, City of Las Vegas, City of North Las Vegas and Yuma County). Worked for Insurance, utilities, power and energy companies (LVVWD, SWGAS, LADWP, LAMETRO, Nevada Power, Tri-State Denver), Transportation - RTD Denver, Oil and Natural Gas rigs and platforms (ONGC), Ranbaxy and UHC (Pharma/Medical), Qualcomm and Xerox.
• Worked for Big 5 consulting companies like Oracle, PWC, Confidential and Solbourne.
• Completed Oracle Financial Consolidation & Close Cloud Service (FCCS) Training.
• Completed Oracle Account Reconciliation Cloud Services (ARCS) Training.

TECHNICAL SKILLS

ERP Versions: Releases 10.7, 10.7 SC to 11i, 11.5.10.2, R12.1.2 to 12.2.4, 12.2.6,12.2.8

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

Configuration Management Tools: SVN, Clearcase, PVCS, Mercury Kintana/BMC remedy request System/Meriant Version Manager, Vista Plus, MS-Visual SourceSafe 6

Methodologies: Test Plan Strategies, QA analysis, Unit Testing & Module Testing, Integration Testing, HP Quality Center, Agile/Scrum methodology

Production Control and Change Management: SOX Focal, Adopt SOX guidelines for Change Management. Completed 8+ SOX audit as SOX focal. Production Control, Change Management and User Management, SOD, M016, PO32 documentations and Appscan

PROFESSIONAL EXPERIENCE

Confidential

Oracle Cloud R13 Finance Implementation

Responsibilities:

• Setup and configuration of GL/AP/AR/CM/Expenses modules.
• Ledger and COA setup (Source Quickbooks)
• Setup and support for FA
• Complex AP/AR Setup for Insurance Brokerage firm where Agent, Brokerage and wholesalers involved and settlement was done after AP/AR Netting (Agent commissions, Brokerage fees, Insurance claims) settlement.
• Interacting with Business users to gather the requirements, come up with feasibility analysis and proposed solutions.
• Data upload, conversion and migration.
• Support ARCS issues after post implementation
• Configure GL Allocations and Validations Rules
• FRS - Generate Cash flow, Balance Sheet and TB
• FCCS - Setup Dimensions, source systems, drill through, definition for import format etc.
• CM and FA setups, Invoice OCR.
• Leading and Collaborating with off-shore team
• Independently handling Unit Testing, System Testing, CRP and SIT and working with tech team to fix CRP issues.

Confidential iProcurement Support Lead and ERP Compliance and GRC Focal

Responsibilities:

• Oracle Fusion GL implementation. AS and Lift of COA to fusion from EBS.
• Testing and test scripts
• Interaction with Business users. Gathering requirements and proposing solutions.
• Involved in Analysis of COA, BU, LE, Cash Flow, TB ad BS setup
• Leading and close interacting with development team (India) for R12. Client is using heavily customized EBS R12 version. Also working on redesign to R13 Cloud P2P upgrade roadmap.
• Business user support, testing, approvals and training.
• SOX/SOD/Compliance/OUM documentations.
• Ensure all the security controls are in place and all the yearly Audit reports are up todate.
• SOX Controls - S1 to S6 controls (Security, Production, Unix, Job failures etc)
• Quarterly Audit data preparations for SOX controls.
• Access, Security, Roles and responsibilities review and evidence gathering ( Confidential follows the control framework - COSO and COBIT standards)
• Involved in analysis of using FCCS services to consolidation of Accounts from various systems.
• Oracle GRC discovery and Analysis for business rules and SOD.
• Analysis for use of ARCS feature and implementation of ARCS for 2 Business units.
• Implementation of SOD and UAR application - Software selection, analysis and comparison between various vendors (Fastpath, QSOftware, Onapsis etc).

Confidential

Oracle Services Procurement, Procurement Contracts SME (Lead)

Responsibilities:

• Involved in Functional and Technical tasks, configurations, CRP, UAT, resolving issues, user training, preparing user manuals, unit testing, production migration, post-production support, enhancements, analysis and design. Helping technical consultants, DBA, PM as needed and Oracle Support.
• Converted 200 POs to Contingent Workers assignment (GBPA to Std PO and assigned to CW in OTL) after go-live.
• 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. Also, setup securities, AOL/FND data upload (FNDLOAD) and custom responsibilities.
• Services contract implementation and converting setup and customized line types.

Confidential

Oracle EBS BA and GRC, Identity and Roles Admin

Responsibilities:

• Involved in R12.2.6 upgrade planning and leading development team and assessment for 12.2.8.
• Worked on CEMLI assessment, Creating MD-50/70 for BI Publisher Reports and CM/Release management task.
• EBS upgrade 12.2.6 to 12.2.8 Assessment for iProcrument and Purchasing.
• BI Publisher reports and data interface with OBIEE and Hyperion.
• AGIS setup, transactions and invoicing.
• 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.
• APIs, Interfaces and conversions migration help and support (DS140, BR100, AN100 documentation).
• Configuration and Supported iSupplier, Finance and P2P for R12.2.6 upgrade, Cash Management and Accounts Reconciliation.
• Data conversion and migration.
• Technical support for Oracle Projects Contracts & Billing modules (mainly BIP reports).
• Technical support for HTML and OTL, Oracle 12.2.6 upgrade and conversions.
• Oracle WMS/MSCA (inbound) and Oracle Inventory Management Issue. Scanning device setup.
• Encumbrances and Budgetary control.
• P2P/SCM daily/monthly issues and support, implemented Service contracts and Procurements.
• QA/Testing and implementation.
• 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 evidences (gathering and collection).
• Responsible for Production Control, Change Management and User Access.
• Oracle Cloud Implementation, iProcurement and catalogs.
• IExpenses Travel and Expenses for travelling and employee payments.
• Implemented Purchasing (with services procurement, converted GBPA to Std POs for CW)
• Worked with Oracle consultant to implement Cloud Procurement for one of the OU.
• Helped with Data migration and EBS R1.2.3 to R12.2.6 to Oracle Cloud (lift and shift) for one of the OU.

Confidential

Oracle EBS Lead

Responsibilities:

• Being a SME, actively participated in 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) 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 EBS 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 Cloud implementation with Oracle corp. New implementation, assisting Oracle implementors to upload R12 Contract Purchase Orders to Oracle cloud procurements, user and data security and Oracle cloud security implementation, GL and AP module setups
• Implemented Oracle Cloud security
• Oracle Data Integrator (ODI, 11G or 12C, ODI client) Extract, load and transform (ELT) tool by Oracle that offers a graphical environment to build, manage and maintain data integration processes in business intelligence systems. CRP setup for P2P and OTC features.

Confidential

Oracle EBS Consultant

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 EBS 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.

Confidential, Las Vegas NV

Sr. Application Developer

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.
• Involved in CEMLI objects and Conversion of custom PLLs to OAF and forms personalization for Self Service forms. Converted majority of reports to BI Publisher reports, Purchase Order, Payables document with Barcode (Fonts setup MICR etc), Bank issues for ACH and P-Card expenses.
• 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.
• Modified monthly period closing, Tax method, use of SLA features, Account Generator setup, Converted/modified majority of reports to work in mulit-org requirement in R12, added additional parameters and value sets.
• Unix scripting, custom scripts to migrate code from approved R12 test instance to R12 UAT and prepare timeline for production move. Custom code to drop absolute objects, create new objects like Value Sets, Concurrent Programs, Request and Request Sets, Menus and responsibility (some menus and responsibilities are absolute/changed in R12), custom forms, BI templates and reports, Script to move DB objects and Unix scripts to move custom file system.
• Supported and configured GL extract from Powerplant.