We provide IT Staff Augmentation Services!

Sr Business Analyst Resume

0/5 (Submit Your Rating)

CA

SUMMARY

  • 8+ years of experience in ERP Supply Chain Management Systems providing solutions to business/system problems, and implementing the same through customer acceptance and final delivery of the solution.
  • Implementing and participate in corporate strategies and triggers to enforce SCM policies.
  • Responsible for resource allocation, prioritization, documentation, builds management and standard releases.
  • Work with internal business partners in related groups like Development team, Quality Assurance, Infrastructure Operations
  • Setting up the SCM standards/processes and CM system for development groups, designing branching and labeling
  • Proficient in SCM practices using Team Foundation Server, ClickOnce, MSBuild, MKS, ANT, CVS, Clearcase, MKS, Apache and Automation Perl/Shell scripts.
  • Strong experience in Oracle Applications (OM, Shipping, Configurator, Purchasing, Pricing, I - proc, Bill of Material, Inventory, AR),
  • Experience in PL/SQL, SQL, Core Java, Shell script, Oracle Forms 6i, Reports and Oracle Workflow, TOAD, PL/SQL Developer.
  • Experience on Oracle Supply Chain Applications consulting including Quote to Cash and Procure to Pay.
  • Extensive experience in the Functional aspects of Oracle Applications 11i, Release 12.0.3 and 12.1.3 Worked across different modules of the Supply Chain Management suite including Oracle Purchasing, Oracle Inventory, BOM, Oracle Order Management, and Oracle Shipping.
  • Good experience in mentoring and providing technical assistance for juniors and offshore programmers.
  • Excellent communication, interpersonal, leadership skills and also analytical skills with logical reasoning capabilities.
  • Experience. in Software Configuration Management ( Release management/ Configuration management / Build Engineering ) on both Linux/Unix and Windows environments.
  • Experience in Advanced Supply chain planning - ASCP and Manufacturing processes, which include excellent working experience in software development in oracle applications in R12, 11i Version.
  • Conversant with various SCM tools like ClearCase, CVS, VSS, TFS, MKS, Nant, Ant, Cruise Control, TFS, Shell Scripts, Perl, Ajax, JavaScript’s, PHP, Apache
  • Received hands on access to pre-release version of Fusion Manufacturing participant with direct support from Fusion Development teams. Interacted with supply chain planning and requirements to support Oracle Fusion applications.
  • Experience in implementation of R12 OPM Suite and Inventory modules utilizing the Oracle Application Implementation Methodology (AIM).
  • Experience in implementation of Oracle e-Business in financial and Manufacturing Modules.
  • Experience in Oracle’s EDI Gateway and Release Management application solutions Oracle Configurator
  • Proven track record in implementation, upgrading and helping the technical teams in conversion and customization of SCM application.
  • Experienced in oracle Approvals Management Engine (AME) (11i and R12) implementation.
  • Detailed functional understanding of Oracle EBS and associated middle-ware such as SOA Suite, Web Sphere, and MQ.
  • Experience in Project accounting module and Finance module like AR, AP, FA, CM and GL. Experience on production support and Implementation experience
  • Strong Oracle SCM (BOM,OM,INV,PO) Manufacturing modules and also in Oracle Apps, OTC, R12, OPM/PTM
  • Experience working with JDA/i2 Supply Chain modules, DM, SCP, ABPP, and S&OM; Version 6.3 and TOAD, SQL, PL/SQL.
  • Hands-on experience with Oracle and database tools, including TOAD, SQL, PL/SQL programming (Packages, Stored Procedures & Triggers), JDBC.
  • Implementation of Oracle application 11.5.10 Oracle Manufacturing & Distribution modules.
  • Expertise in requirement gathering, analysis and design of software solutions to support the business needs of the Global Corporations.
  • Good experience in mentoring and providing technical assistance for juniors and offshore programmers.
  • Excellent communication, interpersonal, leadership skills and also analytical skills with logical reasoning capabilities.

TECHNICAL SKILLS:

Application Development Tools: Oracle Forms, Oracle Reports, SQL Loader, Oracle Workflow Builder, ODI and Oracle BI Publisher.

Application Package: Oracle Applications EBS R12/11i - SCM, ASCM (Oracle Supply Chain Management, Advanced Supply Chain Management), (Oracle Manufacturing, Order Management, Purchasing and Inventory) and Oracle Financials (Account Receivables and Account Payables), Oracle EDI Gateway, Demantra and Oracle Integrator.

Desktop Tools: MS Office suite 2003 and 2007

Programming Languages: C, C++, SQL, PL/SQL, UNIX, and XML.

Methodologies / Techniques: Enterprise Resource Planning, Object Oriented Programming and Quality Assurance Techniques

Databases / DB Tools: Oracle, TOAD, SQL*Plus, SQL Developer

Supply Chain Module: ASCP, MRP/MPS, Demantra.

Operating Systems: Windows NT, Windows 98/2000/XP/Vista/7

PROFESSIONAL EXPERIENCE:

Confidential, CA

Sr Business Analyst

Responsibilities:

  • Extensively involved in R12 implementation of Business processes - Design to build, Build to Stock, Forecast to Plan, Core Finance, Order to Ship and procure to receive covering Oracle modules
  • Experience in WIP/OM/PO/INV/WMS/iSupplier/ENG/QA/AR/GL/Vertex
  • Experience in Costing/RLM/Supplier Scheduling/E-Commerce
  • Experienced in ASCP and also involved in OracleOrder to Cash Applications System developer with the following EBS applications modules: General Ledger, Accounts Payable, Accounts Receivable, Order Management, Advanced Pricing, OTM, WMS, Inventory.
  • Created Documentation (ie. Payables and Receivables Invoices) for AGIS transactions
  • Involved in Web ADI Integration to facilitate uploading transactions from Excel
  • Implemented One Sender to many receivers in the same transaction batch (the receivers can be in different ledgers, with different chart of accounts, currencies, periods etc)
  • Performed integration with Oracle Approvals Manager for fully flexible approval rules with no coding
  • Introduced of Intercompany Periods, which can be opened and closed by AGIS transaction type
  • Made Optimum utilization of warehouse through WMS Rules for incoming material based on volume, velocity of the material etc. and for picking most optimum product for sales orders.
  • Customizations - Designed and developed multiple customizations to the seeded Oracle functionality to satisfy functional gaps in the application. This included the design and development of technical documents, database triggers, PLSQL bolt-on programs and modifications to custom libraries. Requirement gathering, design and development of all business reports using Discoverer and Oracle Reports to assist functional users and executives.
  • CustomizedASCPcustom hook and cleansing package during the Data Pull and ODS Data Load programs.
  • Planned and executed multiple test/mock upgrades to arrive at the right sequence of cutover tasks, address interdependencies, and improve predictability of the cutover timeframe that resulted in success of the project with zero business downtime.
  • Involved in tracking of inventory movements between warehouse and assembly lines as every task is guided by system as opposed to manual decision by user.
  • Involved in testing the entire system landscape holistically, which included approach for testing other 3rd party systems (internal and external) that were upgraded in accordance with the same timelines as the oracle R12 upgrade.
  • Analyzed the business functions for implementing a standard workflow across the organization.
  • Developed the requirement and design specification for the entire workflow Developed custom workflows for tracking sales orders on Hold, and notifying users about the status of these sales Orders (Workflow Builder).
  • Worked on WF for checking the Order status and activity, creation of workflows for additional processes, activities and notifications.

Confidential, San Diego, CA

Oracle Apps SCM Functional/Technical consultant

Responsibilities:

  • Developed On-hand Inventory interface to Manugistics, a planning tool that provides Confidential, Inc. inter-process communication and visibility across the handset and accessories supply chain.
  • Worked with Oracle Apps 11.5.10/R12 Functional, SCM(PO,OM,NV), Planning Manufacturing (Flow and Discrete): INV/BOM/WIP/Costing.
  • Oracle Apps Functional Experience. Order to Cash Experience. Oracle Process Manufacturing Experience. Release 12 Experiences.
  • Developed an Interface to accommodate processing logic for Digital Life and DSL item Bills of Materials to Manugistics.
  • Worked on the various changes to the existing Sales Order Inbound Interface.
  • Worked on Vendor Master Conversion to update Vendor Number, name and site code.
  • Extensive experience in defining, analyzing, designing, implementation and support for Oracle Supply Chain Management, Manufacturing and Financial modules like Purchasing(PO), Order Management(ONT), Inventory(INV), Work In Process(WIP), Bills of Material(BOM), Material Resource Planning(MRP), Costing, Shipping(WSH), Advance Pricing(QP), Accounts Receivables(AR), Accounts Payables(AP), General ledger(GL).
  • Good command over e-business modules I-procurement, purchasing, sourcing, Inventory and costing modules.
  • Involved with I-procurement, purchasing, sourcing, Inventory and costing modules.
  • Good knowledge and understanding of Oracle Order to Cash and Procure to Pay Life Cycles.
  • Developed numerous views for discoverer reports which involved reporting for inventory, OTM, PO, OM, AP, AR, ASCP, QP.

    Worked on Item download interfaces.

  • Worked on Purchase Order Receipts Inbound Interface.
  • Supported the existing production environment.
  • Involved with Cash and Procure to Pay Life Cycles.
  • Involved with unit testing, module testing and integration testing. Handled Customer teleconference pertained to Oracle TAR (Technical Assistance Request) support and Status review meetings.
  • Project involves integration of external Purchasing and Financial application with Oracle EBS Release 11.5.10
  • Worked extensively and modified various Custom & Standard Oracle Workflows related to Purchasing and Order management.
  • Worked on developing various RICE components in Oracle Supply Chain modules.
  • Customized various custom forms.
  • Worked on Forms personalization.

Confidential, NJ

Oracle Apps Techno Functional Consultant

Responsibilities:

  • Performed a role of Subject Matter Expert (SME) for Supply Chain Management modules.
  • Involved in Customer teleconference pertained to Oracle TAR (Technical Assistance Request) support and Status review meetings.
  • Involved in Code peer reviews, Internal and External Quality assurance reviews and conducting quality analysis meetings.
  • Solved Service Requests which involves problem solving, analyzing and understand the business flow and functional aspects of for Supply Chain Management modules OM, PO, INV and iStore.
  • Coordinated and performed code review of deliveries from team members and peers.
  • Developed and enhanced the custom RICE (Reports, Interfaces, Conversion and Extension) components as part of the upgrade.
  • Actively involved in preparing Understanding documents, Design Documents, MD120, and Unit Test Plans.
  • Followed SEI CMM Level 5 software development processes and Quality Assurance techniques.
  • Developed Outbound Interfaces to Banks to send Financial Transactions from Oracle via EDI.
  • Developed interfaces, conversions and other enhancements which included part of customizations in Receivables (AR).
  • Implemented Lockboxes in AR with Chase Bank which reduced a lot of manual effort in applying Cash in AR.
  • Implemented Ipayment for Credit Card Processing of Financial Transactions. This enabled credit card payment of Invoices and Orders by external customers via Imodules.
  • Developed Outbound Interfaces to Banks to send Financial Transactions from Oracle via EDI.
  • Developed interfaces, conversions and other enhancements which included part of customizations in Receivables (AR).

Confidential, VA

Oracle Apps Techno Functional Consultant

Responsibilities:

  • Worked as SME in the purchase to pay cycle flow mapping to Sempra energy business.
  • Provided solution for Procurement Operations for Projects using Procurement Modules Purchasing, iProcurement, iSupplier, AME.
  • Configured AME for Requisition Approvals to match the Region specific Approvals requirement from Sempra energy to have both CAPEX and Inventory Purchases.
  • Worked on Req/PO Account Generator Workflow Customization with Projects.
  • Served as a resident expert in Oracle eBusiness Suite application strategy, development, and maintenance in support of P2P business process.
  • Strong experience in Inventory, PO, Pricing, Costing, PIM modules.
  • Performed Month end closing procedures in PO, AP and GL. provided post production support by troubleshooting and resolving issues by analyzing transactions at the table level. Extensively used SQL to query tables for data.
  • Captured issues in issue log, bug fixing and resolving issues encountered during these test cycles and Created service request (SR) with Oracle support for resolving bugs and issues during the course of the project.

We'd love your feedback!