PROFESSIONAL SUMMARY:

• Senior Techno - Functional/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.
• Completed Three R12 and 5 EBS upgrades.
• Implemented Oracle Fusion R13 - P2P, Services 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.

SKILLS HIGHLIGHT:

• Releases 10.7, 10.7 SC to 11 i, 11.5.10.2, R 12.1.2 to 12.2.4, 12.2.6,12.2.8
• V13 R19c
• Finance, P2P, Services Procurement, iProcurement, SCM
• Project Awards, Contracts and Billings, OTL
• Adept at all stages of Project Management for SDLC and project lifecycle, creating business requirements, Functional setup and requirement gathering, technical solutions, development and testing. Experienced in creating BR-100, MD50, MD70, DS-140, AN-100, IM-90 documentation.
• PeopleSoft HR, Sales Force, SAP, Lawson, Hyperion, OBIEE, BI Publisher, SmartView, OBIEE, Dalmia and Workday, Powerplant, Avantis
• SVN, Clearcase, PVCS, Mercury Kintana/BMC remedy request System/Meriant Version Manager, Vista Plus, MS-Visual SourceSafe 6
• Test Plan Strategies, QA analysis, Unit Testing & Module Testing, Integration Testing, HP Quality Center, Agile/Scrum methodology
• 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
• HP Quality Center - bug tracking
• Experience implementing Security for EBS modules using Oracle Governance Risk and Compliance Modules (GRC) -
• AACG, TCG, PCG, CCG. Upgrading GRC (12.1.3 to 12.2.6) and analysis for GRC Fusion
• R13 Oracle Services Procurement, Contracts and Security, migrated data (Lift and shift) from Oracle EBS

PROFESIONAL / PROJECT EXPERIENCE:

Confidential, Los Angeles CA

Environment: Oracle Cloud R13 Finance Implementation

Responsibilities:

• Setup and configuration of GL/AP/AR/CM/Expenses modules
• Setup and support for FA and AGIS
• Support ARCS issues after post implementation
• Configure GL Allocations and Validations Rules
• Generate queries for FAH
• OIC setup

Confidential, San Jose, CA

iProcurement Support Lead and ERP Compliance and GRC Focal

Environment: Oracle Application R12.2.6, Workstream/Audit Board for SOX Compliance

Responsibilities:

• Post implementation support and minor changes to functionality. Leading and close interacting with development team (India). 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.
• Change Management and CEMLI support.
• Data analysis for OBIEE and Smartviews.
• Access, Security, Roles and responsibilities review and evidence gathering ( Confidential follows the control framework - COSO and COBIT standards)
• Heavy SQL writing and data validation.
• HRMS APIs (ADP-Workday-HRMS) support.
• AGIS setup, GL Balances and month end Reconciliation Issues.
• 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.
• Implemented customization for User Access Review for each BPO to review and approve.
• Implementation of SOD and UAR application - Software selection, analysis and comparison between various vendors (Fastpath, QSOftware, Onapsis etc).

Confidential, Las Vegas

Oracle Services Procurement, Procurement Contracts SME (Lead)

Environment:Oracle Application R12.1.3

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, Santa Monica, CA

Oracle Purchasing, SCM, Projects and Awards to Workday Data Conversion Lead and SOX Focal

Environment: Oracle Application R12.1.3

Responsibilities:

• Migration/conversion of Awards, Project and Tasks with Billing data and data masking to workday including payroll.
• AP/AR/GL/PO data migration/conversion
• Documentation and user signoffs (Test, approvals, CR/PR etc)
• Daily data extracts for BI (OBIEE and BIP)
• Ledger conversion and Customer/Supplier data to Workday
• Employee data conversion to Workday.
• SOX Focal for internal audit and Security and Roles for employees
• Production support for Procurement and Project modules.

Confidential, Sacramento, CA

Oracle EBS BA and GRC, Identity and Roles Admin

Environment: Oracle Application R12.1.3, upgrading to 12.2.6 to 12.2.8

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.
• 50+ 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.
• OPM - Purchasing Management support.
• 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.
• Negotiation planning with sourcing calendar, recent activities and recommended actions: this will help to see who all are responded. Graphical view of negotiation and RFQs in the process.

Confidential, Renton (Seattle), WA

Oracle EBS Lead

Environment: Oracle Application 11.5.9 to 11.5.10 upgrade, 11.5.10 to R12.1.3 upgrade, XML/BIP reports, Interfaces via MQ-series to BAAN, SAP, SONIC, Bridge-net, Unix script maintenance, PL/SQL, TOAD, AME, Noetix, Version control/releases, Workflow

ERP Modules:Finance, P2P, Costing, OPM and SCM (Support to ASCP, WMS/MSCA, BOM, WIP)

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.
• 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.
• 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 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)
• 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.
• 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.
• New implementation, assisting Oracle implementors to upload R12 Contract Purchase Orders to Oracle cloud procurements, user and data security and Oracle cloud security implementation.
• 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, Seattle WA

Oracle EBS Consultant

Environment: Oracle Applications Rel. 12.1.3 Re-implementation.

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.
• Oracle Treasury
• QA and Testing.

Confidential, Las Vegas NV

Sr. Application Developer

Environment: TOAD/Mercury Kintana/BMC remedy request System/Meriant Version manager/ Developer 10g, BI Publisher, Discoverer 4i, Vista Plus, Java, OA Framework.

ERP Modules: AP/AR/INV/PO/OM/ALR/AME/Sys Admin/iSupplier/iExpenses/iProcurement /HRMS/OTL/PA support and upgrade version. 11.5.10.2 upgrade to R12 12.1.3

SOX: Security control, Verifications of SOD conflicts, Production controls

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.
• SOX queries - Running user access, responsibilities, 90 days password restrictions etc.
• Supported and configured GL extract from Powerplant.

Confidential, Boulder CO

Principle Consultant

Environment: TOAD/Visual Source Safe/ Developer 2000/6i, XML Publisher, Oracle 10g, Portal and single sign on, SOA/BEPL/DBI/Punchouts and Discoverer 4i.

ERP Modules: AP/AR/FA/HR/PO/OM/WIP/HRMS/Procurement/Costing/Treasury

Responsibilities:

• Worked as a Tech lead for 11.0.3 upgrade to 11.5.10.2 (40+ custom Reports, 30 Interfaces and customizations, iProcurement/ Punchouts and online Catalogs setup). Procure to pay, AP,PO, Vertex/EB-TAX, AR and HR reports conversion to XML/BI Publisher and XMLP Workshops
• Labor Distribution Override interface, HR/Payroll Interface.
• Converting existing reports to XML Publisher reports.
• XML file gateway/Interface for Office Depot.
• BPEL and XML Publisher workshops, BEPL setup and adaptors for 3rd party interface integration.