We provide IT Staff Augmentation Services!

Business Systems Analyst Resume

Round Rock, TX

SUMMARY:

  • Over 9 years of experience in Oracle Applications (E - Business Suite) with a strong Functional, Accounting and Financial background.
  • Participated or led implementations, Analysis, roll-out, Testing, and Customization for Oracle Financials, Procurement, Ebiz Tax, Manufacturing, Order Management etc. Strong experience in Oracle EBS releases 10.6, 10.7, 11.5.10, and R12, as well as working knowledge of development, customizations and integrations with various ERP systems.
  • Extensive experience in Oracle Applications versions R12, 11ix (including 11.5.10) and 11.0.3, 10.7 Financials, manufacturing, Planning, Distribution, in Multi-Org, TCA Architecture.
  • Extensive familiarity with Oracle Unification Method (OUM) for different phases i.e. gathering Requirements, Operation Analysis, Solution Design, Build, Test, Transition, & Production.
  • Rich experience in Oracle Applications R12 and 11i modules
  • Defined various templates including Billing term template, Payment term template and Milestone template.
  • Integration and end to end flow with oracle applications like Oracle payables, Oracle Receivables, Oracle Projects, Oracle GL, Fixed Assets, Order Management, Purchasing, Letters and Loans modules of 11i/R12.
  • Excellent knowledge in Oracle Business Flows (Procure to Pay, Record to Receipt, Order To Cash and Asset to Depreciate etc,),
  • Full understanding of the NEW Oracle 12 ledger/subledger data modelFull understanding of the Oracle Financials Accounting Hub (FAH) and Oracle Financial Services Accounting Hub (FSAH).
  • Extensive Upgrade Experience in Finance Modules, Procure to Pay and Order to Cash.
  • Centralized Process in R12 (Includes Legal Entity, Payment System, E-Business Tax Engine, AGIS, FAH, FSAH and Sub Ledger Accounting Engine).
  • Using R12 new functionality defined foreign currency recurring journals.
  • Implementations with larges user groups
  • Using R12 new functionality defined foreign currency recurring journals.
  • Implementations of Global roll outs in a multi-org/multi-national structure
  • GL Module configuration and FSG reports
  • Punch out configuration, iProcurement/PO approval routing through AME Rules and workflow.
  • Implemented Kofax Markview (v4.7, v5.5, v6.1.4, v7.0.1, v7.1, v8.0) along with Kofax Capture (KC) v10.0.2, Kofax Transformation Modules (KTM) v5.5, Kofax Capture Import Connector (KCIC), Kofax Self Service Invoice (SSI), Kofax AP Advisor, Kofax Supplier Express, Kofax Capture (KC) Plug-in.
  • Integration of Oracle Advanced Collections and Credit Management with Oracle Receivables and other EBS Modules.
  • Good functional expertise on developing Open Interfaces (inbound and outbound interfaces) in Oracle Financials.
  • Experienced in designing new DFF’s, forms personalization and new UI forms using Oracle Application Framework (OAF)
  • Extensive knowledge on the Workflow extensions and APIs, Process, Events, Event subscriptions, and Notifications.
  • Excellent command in developing the Functional design with business rules, process flows and scenarios based on the business requirements/enhancements.
  • Experienced in designing new reports and customizing existing reports based on dynamic business needs.
  • Primarily Functional expertise in Oracle Manufacturing and Distribution modules like Oracle Inventory (INV), Bill of Materials (BOM), Work in process (WIP), Engineering (ENG), Material requirement planning (MRP), Purchasing (PO), iProcurement, Advanced Pricing, Order Management (OM), Pricing, Costing modules.
  • Worked in a team environment with other Consultants as well as customer team leads
  • Environment included multiple Organizations and lines of business for worldwide operations
  • Actively involved in resolving pre or post-implementation problems and work around
  • Strong hands-on functional experience, sound conceptual knowledge of business processes and Oracle products, good problem solving skills and an excellent team player
  • Working knowledge DISCOVERER reporting tool
  • Expertise in using tools like TOAD, Erwin and SQL*Loader
  • Integration Tools/Products - 170 systems, Markview, OCR, Imagenow, Vertex, Paybase, STR, Data loader and Recon SMS.
  • Oracle Financial Consulting - Worked on Full life cycle implementations, Production Support, Quarterly Releases with custom solution designing and documentation.
  • Extensive experience participating in Requirement gathering, Scope definitions, Steering Committee presentations and Cutover Management meetings.
  • Strong command in delivering presentations and knowledge transfer sessions on the functionality of Oracle Financial modules and on the overall business process of an organization.
  • Proactive involvement in Process improvements of an organization.
  • Excellent organizational, leadership, team building, and project management qualifications.

ESSENTIAL COMPETENCIES:

  • Conference Room Pilot
  • Business Process Modeling
  • Requirements Analysis
  • System Integration Testing
  • Project Planning and Management
  • User Acceptance Testing
  • GAP Analysis
  • Super User and End User
  • Solution Design
  • Production Deployment and Cutover
  • Application Setup / Configuration
  • Post Production Support
  • Agile Project Methodology

SKILLS:

Oracle Apps Versions: Oracle Applications Versions R12, 11i (11. .5.9, 11.5.8)

Imp. Methods: Oracle AIM, OUM

Oracle EBS Modules & Knowledge Financials: General Ledger, Accounts Receivables, Accounts Payables, Cash Management, Fixed Assets and Project Accounting.

Procure to Pay: Purchasing, Supplier Scheduling, iprocurement, Catalog administration, isupplier portal, iExpense, Self Service Purchasing, Sourcing, eCommerce Gateway, Accounts Payables

Order to Cash: Order Management (Order Entry, Advanced Pricing, Shipping), Inventory, Service and Core Contracts Receivables Advanced Collections and iPayments

SOPO Process - Intercompany Transactions: Order Management (Order Entry, Advanced Pricing, Shipping), Inventory, Receivables and iPayments..

Others: Alerts, Workflow, Oracle Financial and Sales Analyzer (OFSA), Vertex Quantum, System administration, Application Object Library (AOL).

Software: Oracle 7.3/8.x/8i/9i/10g, Forms 4.5/6i/9i/10g, Reports 2.5/6i/9i/10g, PL/SQL, SQL*Loader, Oracle Developer Suit 9iDS/10g, Discoverer 4i/9i, Designer 9i, VSS, Load Runner, TOAD

Programming Languages: SQL, PL/SQL, Basic UNIX Shell Scripts

Operating System: Linux Itanium 2.4.9, AIX 4.2, Sun Solaris ver5.9, SCO UNIX 5.0, HP-UX

Project Mgmt. Tools: MS Project and Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Round Rock, TX

Business Systems Analyst

Responsibilities:

  • Performed Revenue recognition and COGS accounting testing on a 3rd party revenue recognition tool-RevStream®.
  • Conducted requirement gathering session with various business teams and documented.
  • Part of Confidential Print ® Phase I e2e UAT test team, roles included- Assisted team in thorough testing of the design, including designing scenarios and scripts
  • Track and research orders thru downstream systems such as GCM (Governance and Compliance Mgmt tool), OMEGA(Oracle EBS) and etc
  • Open/Tracking defects in TFS for issues identified during UAT-Working with various teams in resolving, testing and closing defects
  • Supported user community with daily reports that include, order status, accounting reports for UAT results validation in OMEGA (Oracle EBS R12)
  • Hands on experience with Agile project methodology.
  • Strong exposure to Order Management, COGS and Revenue Recognition modules
  • Design functional specifications and documentation for business sign off
  • Coordination with various teams such as IT, System owners and business/end user teams in resolving issues.
  • Supporting the requirements, design, creation and testing phases of project while continuously coordinating and conducting transition of knowledge to functional IT team members
  • Participating in the analysis of user operational processes to develop functional system requirements, documenting business processes using standard business process and data flow diagrams
  • Identifying innovative solutions to business requirements in technical development as a part of performing and documenting Fit/Gap analysis with new system and Oracle Projects
  • Work with the technical team in regards to establishing new development of interfaces between internal and external sources as well as other extensions in the Oracle modules
  • Delivering functional specification documentation for RICE-W items, as well as configuration documentation for system setup
  • Participating in the delivery of user support and .

Environment: Oracle EBS 11.5.10, R12 (AP, Concur ®, Rev Stream, COGS, OM, FA, GL,AR and OUM, MS Visio, MS Project Management)

Confidential, Cleveland, OH

Oracle Functional Analyst

Responsibilities:

  • Working as functional lead for GL,AP,CM and all financial modules for Jamaican Implementation.
  • Requirements gathering for the business community, document the functional and technical documentation in BRD.
  • Confirm functional level modular configurations and setups and documenting in BR100
  • Configured GL, AP,AR,FA,CM, EBTax for fresh implementations in various instances.
  • Coordinate with DBA and developers for accomplishing technical requirements.
  • Strong experience in working with external AP, GL systems and designing the interface with core Oracle GL, AP etc.
  • Strong experience in defining forms personalization, custom reports and any custom objects.
  • Strong working experience in designing ACH, WIRE, SWIFT payment files, inbound bank statements for example ISO XML formats and so forth with various banks JPMorgan Chase, BofA, CITI etc.
  • Supporting current on going production issues/tickets for Financial and PO related modules.
  • Driving business requirements gathering sessions, CRP, demonstrations at various phases of projects.
  • Strong experience in writing module specific test scripts TE.030 during SIT and UAT phases.
  • Project status communication with the steering committee and stake holders.
  • Gauging capacity of work involved to determine timeline for accomplishing project dates.
  • Driving user sessions which includes demos, manuals.
  • Strong experience in handling multiple projects, tickets and prioritizing tasks.
Environment: Oracle EBS R12 (AP, FA, GL,AR and OUM, TOAD

Confidential, Seattle, WA

Oracle Functional Analyst

Responsibilities:

  • Create effective project documentation including project charters, business requirement documents, functional design documents, test plans, project plans, and change control documents.
  • Provide support (tier 1, 2, or 3) of application issues and interacts with FSG IS and Oracle Hosting Support on functional/technical questions not readily understandable from available resources. Coordinate and execute functional testing related to issue resolution
  • Redesigned new Chart of Accounts structure and carry out testing and UAT sessions.
  • Responsible for the standardization of Financial Statement Generator (FSG) reports and their development.
  • Restructured and consolidated the existing FSG objects to produce a comprehensive library for use in current reports and future development.
  • Developed a Standards Guide defining naming standards and tips & techniques for FSG development.
  • Designing a complete re-architecture of inventory items and bill of materials (BOM) to support all product and service sales, billing, and renewal from the Oracle system
  • Provided user on running FSG’s and using the library of objects.
  • Developed a standard template and procedure to upload budgets from Getty’s different business units into Oracle General Ledger using Oracle’s Application Desktop Integrator (ADI).
  • Define functional specifications for UI forms using OA framework (OAF)
  • Designed specifications for custom reports in Oracle General Ledger, Payables, Receivables, Assets and Purchasing, working closely with the users to determine requirements and complete the development with system testing and user signoff.
  • Analyzed and restructured the Oracle Applications (R11i) Responsibilities to apply Segregation of duty rules.
  • Updated the responsibilities and profile option values, using SQL scripts, for General Ledger, Fixed Assets, Receivables, Payables and Purchasing in 43 sets of books. Developed a standardized Invoice Import for Oracle Payables, using SQL*Loader and UNIX scripts to receive the import file via email and archive it before processing it through the Application Program Interface (API).
  • Designed an interface to keep Oracle Assets up-to-date with employee assignment, tag number and physical details maintained in the Remedy Helpdesk system.
  • Developed Fixed Assets Accounting Procedures for the Oracle Assets module, and a Reconciliation Report between Oracle Assets and General Ledger

Environment: Oracle EBS 11.5.10, R12 (AP, Concur ®, FA, GL,AR and OUM, MS Visio, MS Project Management)

Confidential, Seattle, WA

Oracle Functional Analyst

Responsibilities:

  • Configure supplier punch-out sites for e-procurement
  • Design DISCOVERER reports for purchasing and finance reporting
  • Strong working experience on purchasing module and resolve daily production issues,
  • Acted as BA for HRMS integration with ADP system
  • Strong functional knowledge on EDI mechanism setup, configure and post production support.
  • Experience in full lifecycle implementations of Oracle EBS applications and SDLC in general
  • Good documentation skills (gathering business requirements, writing functional and technical design documents)
  • Key Liaison between Business and IT for successful delivery of projects and accountable for operational support
  • Provides input to business leader ship team on prioritization within the IT portfolio
  • Develop, coordinate, and implement test plans for functional changes, bug fixes, enhancements, patches and upgrades
  • Cross functional view of functional initiatives
  • Manage projects with varying degrees of complexity, provide production support to the business users and system processes, and ensure high level of IT service.
  • Document requirements and actively participate in design, configuration and testing of Oracle implementation and its integration with other projects while providing support to the existing Release 11i implementation and in the near future - Upgrade to R12
  • Implement automated solutions through a formal SDLC process including requirement definition, design, development, configuration, project planning and software testing
  • Train users with supportive documentation and decks
  • Coordinating with offshore development team in API development-Unit test
  • Conducted CRP and UAT sessions with business users

Environment: Oracle EBS 11.5.10 (AP, iExpenses, Purchasing, INV, FA, GL and AIM, MS Visio, MS Project Management, HRMS,GRC

Confidential, Federal Way, WA

Oracle EBS Functional Lead

Responsibilities:

  • Worked as functional lead in GL, AP, AR iExpenses, iProcurement, PO and FA.
  • Actively participated in Acquired company implementations in very tight schedule.
  • Prepared Requirement Documents and GAPs for newly acquired companies.
  • Functional flow: Global Intercompany Transactions, Expenses Reports using iExp, Payment batch, Electronic Payments.
  • Configured intercompany (GIS) setups
  • Configured MRC setups and created Journals with foreign currency.
  • Conducted kick off/CRP
  • Configured Finance and Procurement Modules in DEV and UAT instances.
  • Integration testing with internal and external modules/applications.
  • Prepared UAT plan and Test Cases.
  • Acted liaison between IT implementation team and Business Super Users.
  • Tracked UAT issues with solutions.
  • Prepared rollout production readiness and cutover plan.
  • Supported Post Go Live issues.
  • Designed period closing process in Payables and Purchasing along with Reconciling accounts payable transactions for the period.
  • Experienced of order flows and multi org setup in order to cash process.
  • Designed interfaces for Bank Reconciliation and Positive Pay transactions through Oracle Cash Management.
  • Involved as functional consultant in MDM (CDH and PDH) implementation.
  • Assist in defining and reviewing the functional requirements for the RICEW objects for instance and existing interface specifications.
  • Work with other business architect and other planners to assess current capabilities and identify high-level requirements.
  • Participate in quality reviews to ensure traceability of the designs to the requirements
  • Participate in the transitions of the customization functional designs of R12 to the technical designers.
  • Create RICEW components functional designs.
  • Provide functional guidance to the reports/interface/conversion/extension technical designer for the reports/interface/conversion/extension work units
  • Experienced in Integration with 3rd party System Integrators and Banks.
  • Extensive knowledge on SWIFT standards and financial Payment formats as NACHA, NACHA IAT, ISO XML, MT101, MT 900 series, MT 300series, MT 500 series etc.
  • Member of the Solution-Review team which deals with reviewing the problem tickets in production and approving the fix prior to its deployment.
  • Worked on several customizations on Oracle AR such as mass application of receipts in AR, Cascading of AR statuses (customization), enhancing the Oracle AR adjustment approvals, enhancing the interest accrual process.
  • Worked on Advanced Collections Modules Integration setups with Oracle Receivables to identify delinquent customers, adjust transactions, support posting systems and resolve disputes.
  • Good exposure on Period open and closes activities.
  • Setup of R12 payment system using payment process profiles and payment instruction programs for funds disbursement and funds capture process.
  • Experience in using account setups, journal entries, period closing, multi currencies and consolidation.
  • Experienced in AR auto invoice setup and configurations of Collections work bench.
  • Strong hands on and expertise on Order to Cash modules Order Management, Shipping, Receivables, Inventory Management, Advanced Pricing.
  • Extensive experience of order flows and multi org setup in order to cash process.
  • Worked on inventory setups, holds, order purge, exception management and configured setups of shipping execution.
  • Involved in developing the user manual and giving presentations to the users in coordination with the QSSI team on any new enhancements.
  • Configured the setup for multi currency invoices and payments in AP
  • Created FSG reports considering the oracle GL functionality utilizing the Report Wizard of ADI
  • Auto Invoice Process and integration and defining of transaction batch sources of Account Receivables.
  • Experienced in eBusiness Europe localizations
  • Configured the setup for raising Batch invoices and Batch payments of Oracle Payables.
  • Describing of the period closing process in Payables and Purchasing along with Reconciling accounts payable transactions for the period. Along with applying prepayments and advances, matching invoices to purchase orders.

Environment: Oracle Applications R12 and 11.5.10 (AP, iExpenses, PO, INV, FA, GL and AIM, MS Visio, MS Project Management

Confidential, Manassas,VA

Oracle Financials Functional Lead

Responsibilities:

  • Worked as functional consultant in iExpenses, Accounts Payables and Fixed Assets.
  • Prepared Project Plan for iExpenses and AP(p2p Project)
  • Track of issues log and weekly meetings
  • Prepared UAT plan and involved in UATs with large user groups
  • Conducted and prepared sessions and material
  • AS IS Process Documentation for Accounts Payables and Corporate Travel Group.
  • Process Definition, AISIS and GAP analysis Document for Fixed Assets
  • Month End Process for FA
  • Fixed Assets Opening Balances with ADI
  • New features assessed in R12 for GL,AP,PO and iProcurement
  • Implemented R12 finance modules and Procurement modules
  • Prepared Requirement document for FA custom reports
  • Prepared GAP analysis and Functional Design documents for iExpenses and Accounts Payables.
  • Country specific implementations for iExpenses and Accounts payables
  • Conducted Several sessions/demos with different business users like Corporate travel, Services and Finance Group for iExpenses Custom Discoverer Reports Requirements
  • Configured various payment types including Draft, ACH, Wire and Check
  • Oracle Payment has been integrated with Paybase (Check Printing), Hogan and Pep+ systems (ACH Payments)
  • Prepared Electronic invoice process design document and custom solution
  • Conducted POC for Payment process
  • Defined various Customer & Customer Sites, Remit to Address.
  • Setup Customer Profiles, System Options. Defined various Transaction Types, Sources, Accounting Rules, Auto Accounting Rules, Auto Invoice Line Ordering Rules, Grouping Rules.
  • Defined and modified various Banks, Bank Charges, Aging Buckets.
  • Communicated with the banks to setup the lockbox functionalities and transmission formats.
  • Troubleshooting various issues relating to the AR invoices, Lockbox issues etc and performing the Month and year end close for AR.
  • Preparation of Functional Test cases and Test plan
  • Prepared Functional design documents for iExpenses Reports
  • Coordinate with development team, Performance team and QA team
  • Reviewed Technical Design documents and QA test cases scenarios
  • Prepared Deployment cutover list

Environment: Oracle Applications 11.5.10/R12 (AP, AR, iExpenses,170 systems, AME and Bottom line Oracle e-Commerce Gateway Oracle 10g, Sun Solaris (SPARC 32 bit), TOAD, Work flow 2.6, Oracle Discoverer, FTP, AIM Methodology, MS Project Management and MS Visio 2000

Confidential

Oracle Business Analyst

Responsibilities:

  • Responsible for Preparing GAP analyses, Solution design document, Asis operation analysis and mapping for financial modules including AP, iProcurement and PO.
  • Prepared Configuration and Setup documents finance modules
  • Prepared To be process documents for finance modules
  • IProcurement/PO: Reviewing and finalizing the functional and technical documents. Performing unit and integration testing
  • Oracle Cash Management: Bank statement Loader Interface. Loading the BAI2 format into oracle. It is an inbound interface.
  • Understanding BAI2 format functional documents. Functionality mapping and elaborating the business logic to the developers
  • Prepared Period end closure process
  • Performed a different role like Responding to multiple leads and managers to resolve their solutions interfaces concern. Scheduling and driving client meetings and achieving better business solutions.
  • Prepared and executed test cases
  • Prepared End User Materials
  • Performed a different role like Responding to multiple leads and managers to resolve their solutions interfaces concern. Scheduling and driving client meetings and achieving better business solutions.

Environment: Oracle Applications 11.5.9 (GL, AP, AR, CM, PO), Oracle 9i, TOAD, FTP, AIM Methodology

Hire Now