Business Analyst Resume
Boston, MA
Professional Summary
- 10 years of IT experience in all phases of the ERP cycle
- 8 plus years of business knowledge in Financials : Accounts Payables, Supplier Hub, Supplier Lifecycle Management (SLM), Sourcing, Iexpenses, iProcurement, iSupplier, Fixed Assets, Asset Tracking/EIB, Inventory costing, GL, Grants, Cash Management
- 3 plus years experience in R12 with 2 full lifecycle implementations
- 3 years in world’s single largest Oracle Applications Implementation, at Center for Medicaid & Medicare, US Department of Health & Human Services for entire USA
- Functional lead for FIRST IMPLEMENTATION of Oracle Supplier Hub/Supplier Life Cycle Management/Sourcing in the world
Languages SQL, PL/SQL
BI Tools Discoverer, XML Publisher, APEX, Cognos
ERP Oracle Applications 11i, R12, Softeon, WASP, MfgPro
Miscellaneous Remedy, Kintana, Clear-Quest, E-room, Data Loader, Oracle UPK
M.S Accounting Information Systems, University of Nebraska-Lincoln, USA, 2005
B.S Computer Science & Engineering, Cochin University, India, 2001
Confidential– CONTRACTOR May 2012 – Present
State of Maryland, Department of Education Upper Marlboro
Oracle Functional Consultant – Business Analyst
Focus Area(R12.1.3):iProcurement/Purchasing w/ Inventory, iSupplier, Sourcing
R12 upgrade from R11.5.10, with new Sourcing Module Implementation
- Translating functional requirements into design specifications for Sourcing and iSupplier integrated with Purchasing/iProcurement
- Gap Analysis, Design, set-up, and Testing of Sourcing
- Design, set-up, and Testing of Sourcing and compliance policies
- R12 upgrade, migration, delta-setups and testing for Purchasing
- R12 upgrade, migration, delta-setups and testing for iProcurement
- Design, set-up of Supplier Profile Updates – Custom Process
- Customization with iSupplier invoicing and PO Change Orders
- Customization with Advance Shipment Notification (ASN) in iSupplier
- Conducted CRPs and User Acceptance Testing
- Checking data integrity, migration of legacy suppliers, and data clean-up
- Knowledge transfer to system-users and document management
- User Training and handled all related SRs
Confidential – CONTRACTOR June 2012 – May 2012
Oracle Functional Consultant – Business Analyst Boston, MA
Focus Area(R12.1.3):Supplier Hub and Lifecycle Management, iSupplier, Sourcing,
iProcurement/Purchasing
Full Life-cycle Implementation – FIRST IMPLEMENTATION IN WORLD: SLM/SHUB
- Translating functional requirements into design specifications for Supplier Lifecycle Management (SLM), Supplier Hub, iSupplier combined with Sourcing & iProcurement
- Gap Analysis, Design, set-up, and Testing of supplier on-boarding
- Gap Analysis, Design, set-up, and Testing of supplier performance evaluation
- Gap Analysis, Design, set-up, and Testing of Master Vendor Data Management
- Gap Analysis, Design, set-up, and Testing of Sourcing and compliance policies
- Integration of D&B (DUNS No.), RISK , OFAC , GCL with Oracle
- Regression testing of re-implemented procurement process for State Street globally
- Conducted CRPs and User Acceptance Testing
- Checking data integrity, migration of legacy suppliers, and data clean-up
- Designed UPK training documents and quick-step training guides
- Knowledge transfer to system-users and document management
- Researched and resolved system integrity and financial reconciliation issues
- User Training and handled all related SRs
Confidential – CONTRACTOR Dec 2010 – June 2011
Oracle Financials Functional Consultant Sunnyvale, CA
Focus Area (R11.5.10): AP, FA, Asset Tracking, Inv Costing
- Translating functional requirements into design specifications for Asset Management
- Testing, setups, and Gap Analysis of Asset Tracking, AP, iproc, FA
- Design, Testing, and Gap Analysis of Inventory Average Costing
- Design, analysis, and testing of Asset tracking with international deployments
- Functional Analysis and testing of re-implemented P2P process for International data center management for Yahoo global (worldwide)
- Invoice price variance (IPV) custom extension including tax and freight (AP)
- Checking data integrity, migration of old assets, and data clean-up
- User Training and handled all related SRs.
Confidential - CONTRACTOR March 2010 – Dec 2010
Oracle Financials Functional Consultant Boston, MA
Focus Area (R12): Iproc, iSupplier, PO, AP, Iexpense, FA, Property Manger
American Tower Corp is into real estate with products in communication systems
Full Life-cycle Implementation
- Translating functional requirements into design specifications for R12
- R12 testing, setups, and Gap Analysis of AP, Iexpense, PO, isupplier, FA
- Solution design for EFAT involving Iproc and PO
- Functional Analysis, design, and testing of AP Payments involving Brazilian EFT, Checks, Bank Returns, Bordero, PIS/COFINS, Alternate Payee, Landlord/Beneficiary
- Setup of Taxes for Integrated Receiving and performed Regression Testing with US, Mexico and Ghana Instances.
- Functional Design of Cognos Reports for AP, FA, PO and Property Manager.
- Design, analysis, and testing of Accelerated Depreciation in FA and Property Manager
- User Training and handled all related SRs.
Confidential - CONTRACTOR
Oracle Financials Functional Consultant Feb 2007 – Feb 2010
Acting Production Support Manager Baltimore, MD
Focus Areas: R11.5.10 AP, PO (Procure-to-pay P2P), Grants, GL, Cash Management
HIGLAS – Healthcare Integrated General Ledger Accounting System is the world’s single largest volume claim processing & reporting system for Center for Medicaid & Medicare, US Department of Health & Human Services.
- Translating functional requirements into functional design specifications
- Functional design, analysis, and testing of complete HIGLAS P2P process
- Federal Procurement customization for PO and Grants
- Functional Analysis, design, and testing of Payment Batch extensions involving checks (NACHA), EFT, Stale Dated Checks, Check HOLDS, and CPT Interest
- Maintained T-codes and CANS for Budgetary Accrual Accounts
- Functional design of ETL extract and load for Healthcare Transaction Board (HTB)
- Provided Subject Matter Expertise (SME) in business process related issues to the application users and cross-functional developers in Purchasing and Payables area
- Resolved Error 10 (GL) financial integrity issues and implemented MFAR
- Researched and resolved system integrity and financial reconciliation issues
- R11.5.10 to R12 Prototyping – Gap analysis, set-up, and testing
- Month End/Annual Support to the system owners
- Analyzed, Tested and Prepared various data fix scripts and co-coordinated deployment of the fixes in production including patches via Oracle SRs (TARs)
- Managed Help Desk and coordinated with various support groups to resolve issues
- Assisting in Gap Analysis, Unit and Integration testing, and User Acceptance Testing
Confidential – CONTRACTOR Nov 2006 - Feb 2007
Oracle Financials Functional Consultant Holland, MI Confidential is a global leader in automotive interiors. I was involved in the setting up of the EFT NACHA Application for accounts payable including- Payment Batch Extension to submit payment batches (Checks & EFTs) automatically
- Prepared functional specifications for Payment Batch Extension
- Performed testing of configured system for expected results and functionality
- Knowledge transfer to system-users and document management (MD 50s,70s)
Oracle Financials Functional Consultant Washington D.C
The Federal Reserve System serves as USA’s central bank for all monetary policies. I was involved in a fill-in functional support role for Oracle financials issues.
- Customized Electronic File transfer (EFT) process
- Conducted Data Gathering, Analysis, Validation, and Documentation of new process
- Tested AP Print Check (Evergreen)with XML Publisher, Protocol, and Gateway
- Upgraded a variety of financial audit reports with XML formats
- Handled and supported production issues
Oracle Financials Functional Consultant Baltimore, MD
Confidential is a leading supplier of networking equipment. This project involved a re-implementation of Oracle Applications 11.5.6 to 11.5.10, by ORACLE Consulting Services.
- Conversion mappings/procedures of legacy data (Agile and Siebel) to Oracle 11.5.10
- Developed understanding of system for business process flows and mapping them
- Design, analysis, testing and support for GL, AP, AR, Cash Management
- Design, analysis and testing of different monthly close business processes with SOX Extensively used ADI for uploading Journal entries, Budgets and running reports
- Verified financial accounting with Purchasing, Receiving, and Inventory transactions
- Extensive functional documentation with AIM Methodology
- Support for User Acceptance Testing (UAT) and Regression Testing
- Conducted Training & Education for upper Management and End users
- Post-production Support
Information Systems (ERP) Assistant Lincoln, NE
I worked full-time (50%) and part-time (50%) in the Information Systems division for the College of Arts and Sciences, consisting of 12 Colleges, in Nebraska’s largest Public University System.
- Back-ups for HR data of SAP running on Oracle databases
- Imported financial data into Excel and Quicken for analysis
- Fine tuning SQL queries, stored procedures, and Triggers
- Technical Support
Confidential Jan 2001 – Dec 2002
Software Engineer, Offshore development
New Delhi, India; Milipitas CA (USA); Valencia (Spain); Amsterdam (Netherlands)
Amsoft is a multinational software consulting company with a presence in over 20 countries
- Modeling with Rational Rose and UML
- Technical Gap Analysis and Feasibility studies
- Development of various RICE components
- Handled and supported production–support issues
- Conversion programs and stored procedures to load data from legacy systems
- Extensively involved in system testing and transition to CRPs
- Maintained issue and enhancement logs