We provide IT Staff Augmentation Services!

Sr. Business Sys Analyst Resume

Linthicum Heights, MD

EXPERIENCE SUMMARY

As a Project Manager/lead and Senior Business analyst has specialized in analysis, design, development and implementation of application. With over 10 years of extensive experience as a business analyst includes 8 years of oracle functional business analyst consultant coveringGeneral Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Cash Management, Purchasing/iProcurement and Order Management. Expertise and experience in migration, implementation of oracle application's financial (AP, AR, GL, FA, CM) and manufacturing (OM, PO, INV) modules. Conversant with all phases of software development life cycles (SDLC). Possess excellent analytical, problem solving, documentation, communication and interpersonal skills.

WORK EXPERIENCE

  • Feb 12 - Present - Managing consultant (Oracle Financial System).IBM - Global Business Services
  • Aug 06 - Feb 12 - Project Lead/Lead Business Analyst (Oracle Financial System),Corelogic
  • Dec 02 - Aug 06 - Sr. Business Analyst (Oracle Financial System),Princess Cruises
  • July 02 - Dec 02 - Sr. consultant, I Process, LLC (GE Capital International service)
  • Feb 02 - Mar 02 - Sr. Consultant,CENTECH Group
  • Aug 00 - Jan 02 - Sr. Consultant, Oracle Corporation
  • July 98 - July 00 - Oracle Financial Analyst (Functional), La Puente Valley Medical Group, Inc. - Los Angeles
  • April 93 - July 98 - Programmer/Analyst, La Puente Valley Medical Group, Inc., Los Angeles
  • Sept 79 - Dec 88 - Accountant, Gujarat Steel Tubes Limited. Ahmedabad, Gujarat, India
SKILLS/Tools

Operating Systems:Windows XP
Front-end Tools:Oracle Developer 2000 (Forms 4.5, Reports 2.5), Oracle Forms 2.3 and Oracle reports 2.0,.
RDBMS:9i, 10g, 11g
Languages:SQL, PL / SQL
ERP Software:Oracle Financials 10.7 nca, 11.0, 11I (GL, AP, AR, FA, CM, OM, PO, INV, iProcuement, iExpense)
Report Tools:Business Object, Oracle Discoverer, Oracle Report

CERTIFICATION / TRAINING

  • Oracle BPM Modeling Aug 2011
  • Oracle BPM 11g Implementation Aug 2011
  • Oracle Configurator (11i) Dec 2001
  • Oracle General Ledger (Rel 11i) Jan 2001
  • Oracle Payables (Rel 11i) Jan 2001
  • Master Certificate - Oracle Financial ERP (Rel 11.0) Jan 2000- Mar 2000
  • Certificate For Power Builder Programming1997-1997

EDUCATION

  • Bachelor of Science, - Computer Information System1991-1993
    Confidential - California - USA
  • Bachelor Of Commerce - Advance Accounting and Auditing 1975-1979
    Confidential - Ahmedabad - India
PROJECT EXPERIENCE

Managing Consultant/Package Solution Consultant
Confidential - Linthicum Heights, MD
Feb 2012 - Present

DESCRIPTION

Confidential (Global Business Services) has conducted one of the biggest Oracle implementation at CMS (Centers for Medicare & Medicaid Services). Project called as Healthcare Integrated General Ledger Accounting System (HIGLAS). Confidential has various teams that maintains and enhance the implemented system at CMS. I am working with Fin Reconciliation and enhancement team.

Project - HIGLAS

  • Perform daily and weekly reconciliation and guide the user for correction. This includes the entire Financial module of Oracle ERP, AP, AR, GRANT, GL, FA, and Purchasing.
  • Support Month end for the all financial module.
  • Conduct daily and weekly call with CMS contractor for any issue and resolution
  • Prepare HCA (HIGLAS Corrective Action) document for CMS contractor and developer.
  • Prepare and reconcile TROR (TREASURY REPORT ON RECEIVABLES
  • AND DEBT COLLECTION ACTIVITIES) report

Project Lead /Business System Consultant Lead
Confidential - Santa Ana, California
Aug 2006 - Feb 2012

Confidential Previously known and as part of First American corp, implemented Oracle in 1999 10.7NCA and again in 2003 11.5. I have work as a Business Analyst (Production Support team) and Project lead to integrate and implement the Oracle Apps various module.

Production support and services

  • Supported and resolved Production issue for 10.7 and 11i
  • Supported and resolve the Month end close issues
  • Lead the off shore team of BA for production support

Major Project work

  • CFO Initiative: Financial System enablement November 2010 to Present

Confidential is in the process of consolidating the financial system into one Oracle Financial system that includes Billing, Revenue, corporate shared payable and procurement.

  • Manage Implementation and integration ofOracle Payablesfor 13 FADV companies
  • Manage Implementation and Integration ofOracle Receivablesfor five major companies -Saferent, Mutifamily, NBD, MCIA, US Teletrack, and Basepoint, This implementation includes the interfaces between product systems. Provide the billing and payment data to source system for front end application.
  • Major leading efforts of implementing and coordinating theOracle Purchasing/iProcurementfor 13 FADV companies in just two and half months in record time. Major high light of this implementation was to successfully introduce the Punchout functionality first time to the business.
  • Oracle Instance Consolidation Project - Phase I Sept 08 to July 2010

Corelogic two business units were on a separate Oracle financial system (instances)

  • Manage integration as a project lead forOracle Payables
  • Implemented Oracle Purchaing/iProcurement
  • Integration of OM with Main system (Real Estate information System) for billing and user provision
  • Enhance Internet Expense with AIM approval process
  • NJV company Oracle Receivable and Oracle Payable Implementation
  • Chase Corporate Credit Card implementation and integration with Internet expense
  • Other Projects
  • NAS AP Invoice Interface - Design, define functional specification payable invoice interface
  • FARG AR Implementation - Added new Company and ORG, completed set up of Oracle Receivable
  • TANGOE Telecom AP Invoice Interface - Design, define functional specification, interface telecom invoice into oracle and created specification to export payment file for TANGOE system
  • FAISG AR Implementation - Added new Company and ORG, completed set up of Oracle Receivable
  • UKV GL and AP implementation - Set new SOB with functional currency GBP, implemented payables modules with new SOB, LE,OU.
  • UKV iProcurement implementation - Implemented iProcurement, Purchasing, and Inventory
  • Reconciliation Usage Report 10.7 -Design, define functional requirements and help to develop custom report
  • Define functional requirement, solution and provided functional and technical specification to modify/customize iprocurement requisition workflow
  • Provided day to day support and provided satisfactory solution for Oracle financial application 11i and 10.7 that includes not only GL,AP,AR, Purchasing, modules but also iProcurement, and iExpense portal.

Sr. Business Sys Analyst/Project Lead
Confidential - Santa Clarita, California
Dec 2002 - Aug 2006

DESCRIPTION

Princess Cruises has implemented Oracle Financial (AP, GL, PO, and FA) on the 11.03 version and upgraded to 11.5.8 (GFMS). Majority of third party applications are integrates with Oracle Application through customized interfaces.

Project - Carnival Global Financial System (CGFS) - Aug '04 to present

Carnival Corporation has a started to implement company wide Oracle 11i E-business suites (AP, AR, PO, FA and Project Costing) and bring all separate oracle instances into single instance. Princess Cruises is one of the Carnival corporation company running oracle application 11.5.8.

  • Prepared project plan for individual company (Princess Cruises, Carnival Corp., Holland America, Carnival - UK)
  • Assisted and prepared combine global project plan
  • Design and completed set up of Descriptive flexfield for all Operating company
  • Design and documentedGL Daily Rates and Period End/ Period Average ratesimport process
  • Design and documentedInter Company Set of BooksTransfer (INTERSOB- Intercompay Transaction)
  • Prepared and consolidated current customization information (Reports, forms for oracle application).
  • Prepared and consolidated current customize interfaces information with oracle application.
  • Determine functional specification for use of Oracle Project - costing for proof of concepts
  • Prepare document of current processes and procedures for the project including visual process flow diagram
  • Perform setup and testing on development instance for Oracle Project.
  • Perform setup and testing on development instance for Oracle Receivables.
  • Develop technical specification for Oracle Receivables interfaces with POLAR (Mainframe Reservation system).
  • Prepared technical documentation for Princess Cruises current customization and interface.
  • Attended scheduled meetings with project team members and users

Project - Oracle BI (Oracle Data warehouse)
Design Report using Business Object/Discoverer/Oracle Reports -
Jun 05 - Aug 2006

  • As a lead BA, I worked with various business groups and gathered the reporting requirements, prepared requirement documents and completed the fit gap analysis.
  • Created functional and technical design documentation for development team.
  • Configure the finance application for reporting.
  • Design and develop schema for Crunchtime purchasing report from oracle database
  • Conduct the user needs and analysis to create classes and objects
  • Design and develop report for Crunchtime purchasing
  • Design and develop schema for AMOS maintenance system from oracle database
  • Design and develop report for AMOS maintenance system
  • Provided post production support

Project - Shore Excursion Self Invoicing Process - Jan '03 - Jun '04

  • Design and developed shore excursion self invoicing process, including database design, new table structure, integration with Oracle Payables and Lotus Notes application system.
  • Prepared various functional and technical documentation for Shore excursion self invoicing process, ERD diagram for new data structure, visual diagram for functional and technical design process.
  • As a project lead conducted various meetings with Shore Excursion, Finance, Lotus Notes developer and Oracle developer
  • Perform vigorous integrated testing of newly design system.

Project - Implementation Of Oracle Receivable - Apr '03 - Nov '03

  • Implemented and continue ongoing support to Oracle Receivable.
  • Attended and conducted various meeting, gather receivable requirements.
  • Performed fit gap analysis and conducted workshop with other business unit.
  • Prepared AR production setup document and maintain change request log document.
  • Perform functional analysis to develop custom reports for AR user.
  • Perform functional analysis, data mapping and assisted to develop interface from Reservation System (main frame) to Oracle Receivable for customer and transaction (invoice).
  • Prepare test script for user testing for Oracle Receivable.
  • Train user for use of day to day receivable functionality and assisted for month end close activity.

Project - Other Project - Dec '03 to Present

  • Extracted and reformatted furnishing data from APPROACH purchasing system for various ships and prepared for upload into the AMOS purchasing and maintenance system.
  • Performed fit gap analysis for hotel services for AMOS maintenance application.
  • Attended various meeting with user and developer.
  • Prepared technical documentation for various interfaces includes Reservation system to Oracle General Ledger for earned and unearned revenue, ARC system to Oracle General Ledger for air expense and air accrual, Interface between Travelex, Oracle General Ledger, and Oracle Payables, Stockwatch system to Oracle GL and Oracle Purchasing.
  • Prepared and presented demo for Oracle iSupplier internet portal.
  • Continue ongoing support to Oracle Receivables, including month end, customization of invoice report, financial reports, reconciliation of AR, issues and resolution, logging tar with oracle.

Sr. Business Consultant Lead
GE Shared Sourcing Service - Albany, New York
Nov 2002 - Dec 2002

DESCRIPTION

GE SSS (Shared Sourcing Service) is in the process of implementing Oracle iSupplier internet portal 11i (11.5.7)

  • As a team member, participated in implementing and testing the Oracle iSuuplier module.
  • Research and resolve post implementation system critical issues working with Oracle support.
  • Performed rigorous testing in iSupplier with integration of Oracle Payable.
  • Performed extensive testing as a supplier user.
  • Prepared and presented interactive iSupplier demo to the prospective vendor.
  • Prepared iSupplier user manual for vendor.

Sr. Business Consultant Lead
Confidential - Atlanta, Georgia
July 2002 - Oct 2002

DESCRIPTION

GEEIP (GE Parts) is in the process of stabilizing and bullet proofing the implemented Oracle ERP system 11i (11.5.4)

  • Involved to resolved production issues as a financial lead for COE team.
  • Performed detail investigation and find the root cause of production issues forAP, AR,andGL.
  • Involved to rectify issues and suggested and implemented the solution.
  • Resolved interface issue -Vertex, Tax on freight issue.
  • Involved to resolve cross functionality issues for OM, PO, INV.
  • Design, modified, and implemented newprogress billing (20/60/20)process inOracle ARand updated document forprogress billing.
  • Developed, updated, modified UAT test scenarios and prepared testing documentation forAP, AR, GL..
  • Performed rigorous testing for AP, AR, GL, and all other interfaces after resolution of issues.
  • Conducted performance and integrated testing forAP, AR, And GL.

Sr. Business Consultant Lead
Confidential - Irvine, California
February 2002 - March 2002

DESCRIPTION

GE EER is in the process of migrating its DELTEK Accounting system, from legacy systems (DOS Base) to Oracle Applications.

  • Performed global architectural and "As Is" mapping study of current information systems of GE EER - Irvine, California. Attended various meeting with core team Member.
  • Conducted data gathering, analysis, validation, and diagramming of the existing GE EER information systems.
  • Developed a high level "As Is" GE EER existing systems architecture Visio diagram for financial module and business process showing the interrelationships between the existing systems.
  • Mapped GE EER business processes to Oracle Business Process Models (OBMs). Performed application fit/gap analysis of GE EER systems.
  • Used AIM methodology and prepared documents (RD 020) for General Ledger, Accounts Receivable, Accounts Payables, Cash Management, Project Accounting, and Fixed Assets.
  • Freeze AS-Is and To-Be Flows after carrying out business process analysis and To-Be flows with Oracle Application including identification of areas for customization and work around.
  • Carried out Solution Pilot and demonstrated business processes of test database installation of Oracle Applications.
  • Developed prototype production set-up to simulate transaction process environment for AP, FA, CM, PA and GL modules.

Environment: Oracle Applications 11i (General Ledger, Account Receivable and Payables, Fixed Assets, Cash Management, Project Accounting), Oracle 8i, Sun Solaris, Form 6I, Report 6I.

Confidential - Norcross, Atlanta, Hilversum, Netherlands
April 01 - January 02

Business Consultant - AP Lead

DESCRIPTION

OFS Brightway JV and OFS Fitel, JVpreviouslyLucent Technologieswas in the process of implementing Oracle 11I E-business suites includes financial and manufacturing modules. Implementation took place at four locations which includes Somerset - NJ, Norcross- GA, Augsburg- Germany, and Hilversum- Netherlands.

Participated in Global implementation of 11i E-Business suites at EMEA Order Desk Hilversum ,Netherlands for OFS Brightway and OFS Fitel.
  • ImplementedOracle Financials 11.5.3 (11i) (Oracle General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Order Management, Inventory, PO) inMulti Orgenvironment.
  • Developed understanding of existing system with respect to business process flows and mapped them to Oracle Applications.
  • Designed and configuredOracle Applicationsmodules forConference Room Pilot testing. Performedtestingof configured system with respect to expected results and standard functionality.
  • DevelopedAcceptance Test Plan scriptsfor testing of configured system by business users. Conducted Training and education for Top Level Management and End users onfunctionality/enhancementsof Release 11i.
  • Implemented and performed set upforOracle Order Management, Inventory, Oracle Purchase, Cash Management.
  • Provided functional guidance formodifyingtheAccount GeneratorusingOracle Workflowto createCOGSAccount fromOrder Managementmodule at a detailed level.
  • Performed set up in Oracle Order Management, such as Transaction Type, Defaulting rules for shipment, Price List set up, Tax Setup, Drop shipment etc.
  • Set up shipping tolerances for over and under shipments inOracle Order Management
  • Performed setup inPurchase Orderand define Receiving option, Purchasing option, Financial option, Payment terms, set up approval process.
  • Performed setup inInventorysuch as define location, define organization, define Inventory Organization, define business group, Define item, Item template and enable to organization.
  • Successfullyimplemented Oracle PayablesandAP Localization Netherlands (Europe)as Lead Team Member in aMulti Orgenvironment.
  • Performed set up forOracle Payables- Define Payables Option, Financial Option, Payment Document, Payment Format and electronic payment.
  • DefineEURO VAT TaxSetup; Define supplier and matching tolerance inOracle Payables.
  • Successfully created Foreign (multi currency) and Domestic (EUR) EFT payment file for Deutsche Bank in Oracle PayablesusingAP Localization Netherlands.
  • Prepared various reports forOracle Payablessuch as trial balance, Invoice aging report, Intra EU-VAT audit report and PreparedOracle Payablesclosing document and trained users forOracle Payablesperiod closing process.
  • Processed expense report inProject Accounting,imported expense report inOracle Payable.
  • Performed setup forOracle Receivables. Define system options, define invoicing and accounting rules, define transaction type, define AR payment terms, define auto invoice rule, performed tax setup, performed customer setup, define receipt class, define collector, define aging buckets, define dunning letter.
  • Performed common financial setup such as internal bank, supplier bank, and customer bank, payment terms, define document sequence(GL), document category(GL),
  • PerformedGLsetup. Define accountingKey flexfieldstructure, defineCOA, currency, calendar, DefineSet of Books, define value sets, define values, define cross validation rule and security rule. Define currency rate include daily and corporate rate, define recurring journals and mass allocation journal.
  • Configured variousfinancial reportsusingFinancial Statement Generator (FSG)formanagement control.
Prepared various documentation using AIM methodology such as, Application (AP, GL, OM, CM), Set up document (BR.100), Business Requirement (RD30/50), User Acceptance Test script (TE.040), Business Process Flow (BP.080), System Integration Test script (TE.050). Prepared and trained users on various stages of implementation and provided postproduction support at Hilversum, Netherlands. Environment: Oracle Applications 11i (General Ledger, Account Receivable and Payables, Inventory, Cash Management, Order Management, WIP, Purchasing), Oracle 8i, Sun Solaris, Form 6I, Report 6I.

Business Consultant
Confidential - Warren, New Jersey
September 00 - March 01

DESCRIPTION
Lucent Technology is in the process of global architectural study of existing information systems and procedures, with the objective of migration to Oracle applications and developing a standardized global architecture.

RESPONSIBILITIES

  • Conducted data gathering, analysis, validation, and diagramming of the existing Lucent information systems interrelationships.
  • Addressed and resolved Lucent current systems interrelationship issues.
  • Developed a high level "As Is" Lucent existing systems architecture Visio diagram by business unit and business process showing the interrelationships between the existing systems.
  • Mapped Lucent business processes toOracle Business Process Models(OBMs). Performed application fit/gap analysis of Lucent systems.
  • FreezeAS-IsandTo-BeFlows after carrying out business process analysis andTo-Be flowswith Oracle Application including identification of areas for customization and work around.
  • Carried outSolution Pilotand demonstrated business processes of test database installation ofOracle Applications.
  • Developed prototype production set-up to simulate transaction process environment forAP, FA, CM, PA and GL modules.

Environment: Oracle Applications 11i (General Ledger, Account Receivable and Payables, Inventory, Cash Management, Order Management, WIP, Purchasing), Oracle 8i, Sun Solaris, Form 6I, Report 6I.

Oracle Financials Analyst (Functional)
Confidential - Los Angeles
July 98 - July 00

DESCRIPTION

La Puente hospital administration system is in the process of migrating its hospital administration system, from legacy systems (IBM) toOracle Applications.
  • Participated in various meetings with the Management Team and Legacy System Management to gather user requirements and incorporate those requirements into Oracle applications features.
  • Analyzed existing business processes and mapped into Oracle Applications.
  • Restructured user processes so as to leverage Oracle Applications features and functionality. Finalized the setup.
  • As an Implementation Project Team Member worked on different functionality ofOracle Financial modules - General Ledger, Accounts Receivables, and Account Payables. Purchase Order, Fixed Assets.
  • Defined flexfield structure, segment, value sets, and profile options.
  • Involved in designing, developing and modifying reports inGeneral Ledger.
  • Assisted the end user to perform ad hoc queries, generate reports, and publish information usingOracle Discoverer.
  • Involved in designing descriptive flexfields for theAccounts Receivablesmodules.
  • Performed set up inAccount Payables -supplier, define matching tolerance, Payable option, Financial Option, Tax Setup, Bank Setup, Payment Document, Payment Format.
  • Defined Expense report template, Defined Pay Groups, Payment terms inAccount Payables.
  • Inventoryperformed and validated set ups - defined organizations structure and location.
  • Defined and set up UOM. Set up profile option forPO, AP, AR.
  • Defined report security groups and organized programs in to report groups inSystem Administration.
  • Assisted client inMonthly Closing of Booksfor the first time in production.

Environment: Oracle Applications 11.0 (General Ledger, Account Receivable and Payables), Oracle 7.3, Windows NT, Forms 4.5, Reports 2.5

Programmer/Analyst
Confidential, Los Angeles
Apr'93 - Jun'98

DESCRIPTION
La Puente Valley Medical Group, Incis customizing and implementing Medical Management Systems.

RESPONSIBILITIES
  • Implemented medical management system, which includes patient scheduling, insurance billing, reporting, and account receivable.
  • Customization of legal report as per California state requirement.
  • Design and formatted different claim forms, reports and statements as per company's requirement.
  • Provided training and support to user on new system.
  • Provided technical support for software, hardware and computer networking.

Environment: Medisoft Medical Management, Oracle 7.1 and 7.3, Forms 2.3, Reports 2.0 and 2.5,Windows 95, Window NT

Accountant
Confidential. Ahmedabad, Gujarat, India
Sept '79- Dec '88

DESCRIPTION
Confidential was major manufacturer of steel, galvanized and
Precision tubes with over 1300 employee. Company was exporting majority of its production to the Gulf countries. Company had adopted and implemented new information system since 1981.

RESPONSIBILITIES

  • Performed all majors accounting function, which include from invoice preparation through trail balance.
  • Participated with system analyst to convert and implemented manual accounting system to computerized accounting system and also material inventory system.

LEGAL STATUS

US Citizen

Hire Now