Oracle Federal Financials Support Project
Resume:
Gurjeet K. Sawhney
**** ******* *** **., ***********, MD-21029
Cell: 410-***-****
Email: ***************@*****.***
Highlights
Competent, reliable and committed professional, with a proven track record of project leadership and Oracle Applications Implementation
Comprehensive techno-functional knowledge in the following Oracle Applications Modules – Federal, Public Sector & Commercial: FV, GL, PO, AP, AR, LNS and FA
Experience with full SDLC management, requirements capture, gap analysis, business process re-engineering, Application functional analysis and design, solution development, Applications configuration, quality assurance testing, training, technical writing, and business-technical liaison
Strengths in functional & technical leadership, effective communication, team building, sharp analytical problem solving and interpersonal skills.
Over 25 years of experience in IT field in the Oracle Applications environment – Implementations, Upgrades, extensions and Production support (Functional and Technical)
ERP
Oracle Applications Rel. 12.2.4, 11i, 11 & 10.7 NCA, and Character based Federal, Public Sector & Commercial in Multi-Operating Units, Multiple Sets of Books and Multi-Currency Environment
Modules: FV, GL, Projects, AP, PO, AR, LNS, CE, FA, AOL & System Administrator
Oracle Tools
DB Tools: SQL*Plus, Dicoverer, Oracle Enterprise Manager, PL/SQL, SQL*Loader, Reports 2.5/6i
Apps Tools: Oracle Apps. Desktop Integrator (ADI) & Financial Statement Generator (FSG)
Other Tools
TOAD, SQL Developer, Workflow Builder and Test Director
Operating Systems
Sequent Dynix/PTX, Sun-Solaris, SCO Unix, AIX, VAX/VMS, MS-Windows & NT
Documentation Tools
Oracle Tutor, AIM, SharePoint, ClearCase, ClearQuest, VISIO, Microsoft Projects, & Microsoft Office
Professional Experience:
Dec-12 to Current: Independent Consultant – SeKon Enterprises, Inc.
Centers for Medicare and Medicaid Services
Production support - Rel. 12.2.4 Oracle Federal Financial Applications (FV, GL, AP, AR and Loans) – Multi-Operating Units
Provide AR and Loans functional support for Production system
Work on Production Issues/resolutions and new enhancements
Work with technical team to develop solution
Work on new enhancements requirements, workarounds and design/implement solutions
Develop test scenarios and perform unit testing
Conduct meetings with users to review the requirements, workarounds and solutions
Work on AR related extensions for each quarterly release
Create/Review BR100 changes for AR and Loans
Create/update/Review Functional Specification Design Document
Work with policy to ensure that AR processes in compliance with policy
Worked on various activities with functional and technical team - 12.2.2 to 12.2.4 upgrade project as AR and Loans SME
Worked on various activities with functional and technical team - 11.5.10 to 12.2.2 upgrade project as AR and Loans SME:
Analyzed new features and impact on existing extensions for R12.2.2
Worked with technical team for impacted interfaces, extensions and reports
Conducted workshops with CMS business owners to review the new functionality and impact to existing business processes
Reviewed/updated existing testing suite scripts
Worked with training team to update the training material and participated in user training as AR and Loans SME
Updated AR and Loans Business processes documents and Function design specification documents for extensions and reports
Jun-12 to Jan-13: Independent Consultant–Consulting Solutions International, Inc.
John Hopkins - Applied Physics Laboratory
New Implementation of Project Billing in Rel. 12i (12.1.3) Oracle Financial Applications (GL, Project Costing, PO, AP, INV, AR, & FA) environment
Testing Coordinator and Financial Reconciliation Lead – PB, AR and GL
Assisted with Master Test strategy approach document
Reviewed requirements, functional & technical specifications and setup documents
Developed test scenarios and obtained approval from team - Project Billing, AR and GL
Developed detail test scripts (step by step) for the test scenarios and performed unit testing
Reviewed current accounting and new SLA configurations to ensure accounting entries will be created correctly
Performed financial reconciliation PB to GL, PB to AR, and AR to GL
Developed detail test scripts and demos for GL group for Financial reconciliation team
Provided support for various testing cycles – CRP3, UAT1 etc.
Assisted with issues/resolution
Developed user procedures for Billing manager – from Releasing Project Billing invoice to creating journal in GL
Aug-08 to May-12: Independent Consultant – Logistics Management Institute
Centers for Medicare and Medicaid Services
Production support - Rel. 11i (11.5.10) Oracle Federal Financial Applications (FV, GL, AP, AR and Loans) – Multi-Orgs
Reviewed/approved Production support issues/solutions
Worked with IBM team - issues and propose solutions
Worked with IBM and Medicare contractors on Quarterly releases/enhancements
Performed Setups in Production and Gold instances – GL, AR and FV as needed
Reviewed and provided feedback Functional, Technical design documents
Reviewed Test plans and Test results
Reviewed other IBM deliverables and provided feedback
Developed/executed SQL queries as needed
Mar-08 to Sep-08: Independent Consultant – i360 Technologies Inc.
Business Transformation Agency
New Implementation - Rel. 11i (11.5.10) Oracle Federal Financial Applications (FV, GL, PO, AP, AR, FA, CA and HR/Payroll)
Part of team to implement Fed Admin, Budget Execution, General Ledger and reports
Worked on FV and GL BR100
Configured multiple instances including Gold instance for CRP2 readiness
Conducted FV and GL workshops to demonstrate COTS functionality
Worked closely with P2P, CA O2F teams for funds control functionality
Developed FV and GL scripts using RWD tool
Provided support for CRP2 testing
Feb-07 to Apr-08: Independent Consultant – Oracle Solution and Services LLC
Transportation and Security Administration
Production support - Rel. 11i (11.5.10) Oracle Federal Financial Applications (FV, GL, PO, AP, AR and FA)
Part of team - Undelivered Orders (UDO) reconciliation between sub-ledgers (PO and AP) to General Ledger (GL)
Working with auditors to provide detail support on audit items
Working on Verifications and Validations (V&V) on Obligations, expenditures and open balance with TSA users and providing details
Developed and modified SQL*Plus and Discoverer queries
Dec-04 to Feb-07: Independent Consultant – The Squires Group Inc.
Centers for Medicare and Medicaid Services
Production support for current and new sites - Rel. 11i (11.5.9) Oracle Federal Financial Applications (FV, GL, AP, and AR)
Analyzed and resolved production and transition issues
Provided AR functional and technical support to team
Performed AR setups for new sites - Test and Production instances
Worked on AR related extensions for each quarter release
Reviewed BR100 and AR to be process document - new extensions
Developed AR Year end scripts
Worked on 11.5.10 testing functional processes including setups, reports and extensions – GL, AP, AR and Sys Admin (menus, functions, responsibilities, request groups, folders etc.)
Old Mutual Financial Inc.
Production support - Rel. 11i (11.5.8) Oracle Financial Applications (GL and AP)
Provided functional and technical support for GL and AP modules
Developed FSG reports as needed
Created complex Mass Allocation (MA) formulas
Setup Global Consolidation System(GCS) and Inter-company eliminations
Provided demos & trained users – GCS, Inter-company eliminations and MA
Designed and developed Discoverer report
Analyzed and resolved production issues
May-04 to Feb-05: Independent Consultant – i360 Technologies Inc.
Office of Federal Housing Enterprise Oversight
Implemented- Rel. 11i (11.5.9) Oracle Federal Financial Applications (FV, GL, PO, AP, AR, and FA)
Responsible to implement Fed Admin, Budget Execution, GL, AP and FA
Assisted client to finalize chart of accounts for Oracle Federal Apps environment
Held meetings to discuss requirements and proposed solutions in working sessions
Setup/configured Fed Admin, Budget Execution, GL, AP and FA
Setup Transaction codes for all modules
Setup Funds control environment to control funds at Sub Allowance level and funds control at Allotment level to handle Continuing Resolution
Setup Accounting Flexfields (Chart of Accounts), Location Flexfields, Asset Flexfields, and Category Flexfields
Setup Sys admin – users, responsibilities, menus/functions, reports, request group, printers, folders etc.
Setup Asset Category, Corporate Book and other required setups
Provided CRP and Parallel support
Setup and created Year end process
Setup and ran 224, FACTS I & II, Funds availability, Consolidated Financial Statements
Created bulk files for FACTS I
Trained users to flag invoices if needed to transfer in Fixed Assets, prepare and post mass additions and run depreciation and transfer journal entry
Trained users to enter journal entries, create recurring journal, maintain setups, and close periods
Trained users to maintain-treasury symbol, FACTS attributes, USSGL, budget users, budget distribution, maintain flexfields values, adding FA categories, reclass/transfer assets, capitalize CIP assets etc.
Trained users to close AP, PO, AR, FA and GL month end close and reconciliations
Documented and performed month end closing for all applications – AP, PO, FA, AR and GL
Worked with technical team and loaded 5 years of GL history
Worked with technical team to develop custom reports
Worked with technical team to develop payroll interface
Developed FSG reports
Jun-03 to May-04: Independent Consultant – JPH Group
Veterans Affairs
Part of team for large Implementation - Rel. 11i (11.5.8) Oracle Federal Financial Applications (GL, PO, AP, AR, FA, INV, and PA) using AIM
Provided functional and technical support to team
Setup and maintained Budget Module – Treasury Account Code, Treasury Symbol, Budget Users, Distribution, custom forms etc.
Setup Oracle Federal Financials including Federal Administrator
Provided user support for CRPs and User acceptance testing
Validated and updated Production instance for go-live
Analyzed and resolved issues
Worked with technical team to resolve budget extensions issues
Worked with Report team to resolve budget custom report issues
Loaded Budget data in FV module using API
Setup Summary Templates and Transaction codes
Resolved issues with conversion data
Developed SQL scripts as needed
Developed test scripts and loaded in Test Director
Developed FSG reports
Provided Post Production support for all applications
Aug-02 to Jun-03: Independent Consultant – Sage Consulting Group
Social Security Administration (Full Time Project)
Implemented Rel. 11i (11.5.9) Oracle Federal Financial Applications (GL, PO, AP and AR) using AIM
Reviewed business processes, gathered requirements, performed fit and Gaps including improving BPR
Provided functional and technical solutions to the Gaps
Analyzed and designed Interfaces and Reports
Setup Oracle Federal Financials including Federal Administrator
Setup and used Budget Execution module
Setup Summary Templates and Transaction code
Transferred Funding entries from Federal Administrator to GL
Setup and used funding in PO, AP and GL
Setup and trained user – ADI, Recurring Journals and Mass Allocations
Developed and executed configuration test scripts for GL and Budget Execution module
Worked with technical team to design and test extensions:
Budget Override in the absolute environment (GL, AP and PO)
Segment balancing
Fed/Non-Fed Validation for GL
Funds and Account Inquiry forms design
TC based Journal entry form
Provided support to development team to build extensions
Developed and executed Unit Test Scripts using TestDirector
Developed many SQL scripts to resolve issues
Understand Federal reports including OMB
Tested IPAC functionality
Developed FSG reports
Developed Training materials using Oracle Tutor
Tested OMB financial statements, FACTS I and FACTS II, and other federal reports
Jun-98 - Current: Independent Consultant -World Duty Free Americas, Inc.
Production Support (Part Time Project)
Functional & Technical Team Leader for the following modules: GL, AP, AR, FA & HR in multiple sets of books environment
Provided functional and technical production support for all applications
Used Discoverer to produce ad-hoc reports
Trained users for currency translation and revaluation
Setup Mass allocations and Mass Budget formulas
Defined and ran consolidation
Developed FSG reports
Resolved functional and technical issues
Maintained Flexfields for all modules including HR
Loaded Actual & budget data using ADI
Installed and trained end users – ADI (Application Desktop Integrator)
Assisted in designing and developing AP interface with West Corp. for checks printing
Performed System Admin. functions
Developed SQL queries and modified PL/SQL
Modified Unix shell scripts
Assisted modifying existing reports
Conversion Project (Lawson to Oracle ) – UK, HK and Singapore companies
Project Leader for data conversion from Lawson to Oracle Apps.
Created project plan
Held users and team meetings
Managed Oracle, Lawson and DeLoitte & Touche consultants
Modules converted : GL, AP, PO and AR
Gathered detailed business processes for GL, AP, PO and AR
Mapped, designed and developed business processes
Designed and developed “As Is” and “To Be” processes including Business process re-design
Conversion Strategy, Mapping, Design and Execution
Performed new setups for all applications
Helped designing interfaces for GL, AP, PO and AR
Developed SQL queries and modified PL/SQL
Loaded COA values, Combos, historical and current data for : GL, AP & AR
Performed system admin. functions
Setup Translation and consolidation
Setup New GL sets of books
Worked with DeLoitte & Touche staff to reconcile data
Three-Way Match Project w/o Oracle PO
Project Advisor
Helped in mapping requirements
Designed interface
Tested and trained users
Financial Calendar Update Project
Project Manager for changing the financial calendar across all organizations
Managed 5 Oracle Corporation consultants
Developed and executed project plan
Build project team & held project meetings
Setup new GL
Pointed AP and AR data to new GL
Updated FA calendar
Conference room pilot support
Upgrade from 10.5 to 10.7
Functional and Technical Leader for Upgrade of Rel 10.5 to Rel. 10.7
Modules upgraded: GL, PO, AP, AR, and FA
Implemented new features from 10.7 for all applications
Performed Pre and Post upgrade steps
Developed Test scripts for all applications
Conference Room Pilot Support
Assisted in updating custom interfaces and custom reports
Provided production support after go live
Sep-00 – Feb-02: Independent Consultant – The MCS Groups Inc.
Verisign/Network Solutions Inc.
Functional & Technical Team Leader and Project advisor – Rel. 11 implementation -GL, AP, PO, INV, OE, AR, CE, FA & HR – Multi-Org, Multiple Sets of Books and Multi Currency environment
Reviewed business processes and provided solutions to gaps
Provided Conference Room Pilot support
Assisted and designed interface data conversion (SAP to Oracle)
Reviewed, modified and made recommendations setups – all applications
Assisted and trained users for month end processes – GL, AP, PO, INV, AR and FA
Provided on-going production support for all modules – troubleshoot functional and technical issues
Trained PO and HR users for PO Approval Hierarchies to prevent Requisitions and Purchase Orders stuck in the Workflows
Setup and Trained users: mass allocations, recurring journals, global consolidation, currency translation budget and budget organizations
Designed interface to load Blanket Purchase Agreements via interface tables
Developed FSG reports & provided user training
Loaded Assets for newly acquired companies using ADI
Loaded Actual & budget data using ADI
Implemented Cash Management – full Bank Recon.
Gathered requirements and designed code to modify FA workflow
Reviewed, mapped & designed custom reports
Performed System Admin. Functions/setup: users, responsibilities, menus, printers, profiles, value sets, executables, concurrent programs, request groups etc.
Performed GL setup: new set of books (multi currency including EMU) sequences, segment values, calendar, currency etc
Performed PO setup: Items(2, 3 and 4 way matching) including sourcing rules for Blanket Pos, approval hierarchies(in HR environment), Pay on receipts(autoinvoice), categories, vendors etc.
Performed FA setup: mass additions(AP to FA), Tax books, Asset flexfields, depreciation methods & rates, etc.
Developed many ad-hoc SQL scripts and attached in front-end
Modified PL/SQL procedures as needed
Dec-97 to Oct-98 Independent Consultant - The Renaissance Inc.
John Hopkins - Applied Physics Laboratory
Consultant for Govt. Oracle General Ledger 10.7 NCA implementation Project
Documented Business Requirements
Did Gap and Fit analysis within FASB standards
Analyzed, designed and provided solutions to complex mass allocations process
Conversion Strategy, Mapping, Design and Execution
Setup chart of accounts & Performed other GL setup steps
Trained superusers
Dec’95 to Nov’97 The Owens Group Inc. - Consultant
Washington Suburban Sanitary Commission (Sub-contract with Oracle)
Implemented Govt. Oracle General Ledger and GLDI using AIM
Functional and Technical Leader (Oracle Corp. consultants)
Gathered & developed detailed business processes
Mapped requirements
Designed and developed “As Is” and “To Be” processes including process impovements
Performed Gap and Fit analysis within US GAAP rules
Setup and configured Oracle General Ledger
Setup & Trained users GLDI
Conference Room Pilot support
Setup New segment values and parent values(maintained chart of accounts)
Setup Summary accounts template and rollup groups
Setup budget, budget organizations and mass budget formulas
Assisted and trained users month end process
Used Discoverer with Noetix views to produce ad-hoc reports
Setup DFF(Reporting Attributes) for chart of accounts
Designed and developed specs for custom and FSG reports using DFF
Mapped business scenarios to Oracle Govt. Applications
Performed system admin tasks
Trained superusers
Provided functional and technical support on-going issues
The Rockefeller Foundation (Sub-contract with Oracle Contract Services)
Consultant for upgrade from Rel. 9.4 to Rel. 10.5
Modules upgraded : Govt. GL, PO and AP
Performed pre and post upgrade steps
Resolved functional and technical issues
Assisted and trained users for month end & year end processes
Trained users for new features
Made recommendations to better utilize applications
Washington Navy Yard
Proof of concept for Government Oracle GL, PO, AP & AR - 10SC
Worked with Coopers & Lybrands(C&L) to define business scenarios
Mapped business scenarios to Oracle Govt. Applications
Worked with C&L team to provide solutions to gap
Mapped and setup Charts of Accounts
Configured and setup GL, PO, AP and AR
Designed and setup Budgetary controls model (using Account Model)
Created data for all applications to test business scenarios with users
Developed FSGs
Developed GL interface and loaded data
Installed Oracle Applications on Client work stations
Upgraded from Prod 8 to Prod 11
Applied patches as needed
Startup and shutdown databases, concurrent manager and listner
Jul’93-Nov’95 Duty Free Inc. - Financial Systems Analyst
Performed System administrator tasks
Provided functional and technical support to end users - GL, AP, AR & FA
Setup and maintained chart of accounts including Parent segments
Setup Mass allocations and recurring journals
Setup AP & AR Bank accounts
Performed other setups ongoing – all modules
Developed many SQL scripts to handle day to day business requirements
Implemented Pillar the budget tool & provided end user training
Converted newly acquired company onto Oracle Apps.
Mapped and loaded Chart of Accounts
Developed FSG reports
Modified Standard reports
Trained end users
Oracle Training & Education
Oracle Functional Training:
Oracle Federal Financials Overview 11i
Oracle General Ledger
Oracle Purchasing
Oracle Receivables
Oracle Project Accounting - Costing and Billing
Oracle Financial Analyzer for users and Administer
Oracle Technical Training:
Administer the Oracle7 Database
Introduction to Oracle
Develop Complex Data Models and Design Databases
Develop Reports with SQL ReportWriter (V1.1)
Develop Complex Queries: Advanced SQL and SQL*Plus
Develop Applications Using PL/SQL
Datawarehouse Fundamentals
Education: BS in Information Systems Management, December 1992-UMBC, Maryland.
Contact this candidate