Lead Business Analyst Resume
SUMMARY:
- 7 years of experience in IT software development and implementation Lifecycle; this includes 4 years of Oracle Transportation Management (OTM) implementation.
- Worked for clients across industries, which includes Retail, CPG, manufacturing, Automobile and 3PL.
- In depth understanding of OTM technical concepts around EDI, Idocs and Legacy systems/applications, Agents configuration.
- Involved in majority of OTM modules configuration and testing; Order Management, Shipment Planning & Execution and Financials with multi-domain structure.
- Actively participated to draw up the MRS (Mapping Requirement Specifications) and XML Mapping Documents for various EDI 940, 943, 204, 210, 211, 214, 990 and well as other Integration interface touch points (ASN, Ship Confirm and Receipt Confirm) by working with the technical team headed by a Integration Systems Manager and personnel from SAP and other systems.
- Ability to configure and ran transportation planning, optimization & execution, carrier contract & rate management, freight billing & auditing with functional and technical orientation.
- Designed and Developed solutions & configured OTM to support large volumes of inbound and outbound in OTM.
- Involved in the design and development of Integration Interfaces inbound/outbound to OTM (GC3) including EDI 210 and EDI 214 from EDI and non EDI target systems
- Extensive knowledge of Transportation business financial processes (Carrier Invoice, Accessorial Charges setup and GL code setup and Match Rules etc)
- Strong Communication, Analytical and Client Service skills with a High Learning Acumen to adopt new Tools and Technologies with ease and seamlessly Integrate skills set into the Project Implementation Lifecycle
- Excellent inter-personal skills with strong analytical ability and problem-solving capabilities.
- Strong Application Support and Trouble Shooting Skills.
OTM Configuration & Technical Skills:
Functional Modules
Business Modeling: Geography, Cargo, equipment, service provider’s rates and routes
Order Management: Order bases, Integration with Middleware and SAP
Transport Planning: Order releases, Shipments and Status.
Shipment Execution: Tendering process, Tracking visibility and Settlement.
Technical Aspects
Integration: TMS-EDI messages and mapping with OTM messages, SAP Idocs mapping, inbound & outbound messages, carrier, Order Management and Financial system integration
Agents Configuration: Configuring Agents for various objects (Order Base, Release and
Shipment)
Menu & Screen Set configuration: User access Management, customize Tender notification configurations.
PROFESSIONAL EXPERIENCE:
Confidential,GA Feb’11 – Till date
Role: Lead Business Analyst/OTM consultant
Application: OTM 5.5 CU6
UPS is the world\\\\\\\'s largest package delivery company and a leading global provider of specialized transportation and logistics services. Every day, they manage the flow of goods, funds, and information in more than 200 countries and territories worldwide, The client has many ETMS applications to manage their Logistics business, OTM is one of the strategic tool to maintain and extend their foot hold in 3PL business, for many of their 3PL customers OTM provides a customer specific portal to manage their operations also well integrated with client Order & WM systems and UPS track & trace and financial systems. Around 45 3PL customers are managed using OTM with complex single instance & multi domain model, and continuously new customers added to the existing environment.
Responsibilities:
- Spear headed Business Analysis effort to bring Verizon , Cabelas and EMEA 3PL business model in to existing ETMS production environment by Functional Specifications. Also
- Participated in business requirement review sessions, interacted with Business Analyst and SME team to understand requirements and convert them to detailed functional requirements
- Performed Business analysis responsibilities using HP (ALM) methodologies
- Analyzed Functional design documents and written E2E functional design documents, prepared requirement matrix by mapping BR, FRs and business uses cases
- Indentified, document Business critical activities in the process
- EDI to OTM invoice Mapping. Integrate 110,210,310 from Carriers to OTM provided assistance to understand IG and map with OTM message objects for single and consolidated invoices.
- EDIFACT to OTM invoice mapping .IFTSTA, IFTMAN between carriers and ETMS
- Helped in setting up the carriers, contacts, notifications for different protocols (HTTP, email and Rebserve).
- Configured Bulk plan Saved quires using different grouping & filtering logic. Assisted in testing the bulk planning; familiar with Planning Parameter setup.
- Modeled the carrier, distribution center and consignee information in Transportation Management Systems.
- Modeled the carrier tariffs and cost structure. Setup the system for Automatic freight matching and payment. Developed tools to automatically upload vouchers.
- Involved in A2A and B2B system testing between OTM and other OM application and carriers using GIC as middleware, created sample xml and EDI files to test integration.
- Created master data templates to load customer specific master data to load in to OTM as part of UAT and Production migration.
- Involved in modifying the style sheet for the tender email.
- Hands on experience in developing OBIEE metadata objects (Subject Areas, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports).
- Closely worked with Business Users to complete UAT testing, involved in UAT data setup, execution of test scripts and evaluate test results
Confidential,TX Nov’ 09 – Jan’11
Position: OTM Functional Consultant- OTM 5.5 CU6, SAP 5.x.
- Spearheaded business sessions to identify the as-is business process.
- Identified optimal business rules and processes for the inbound & outbound Transportation management implementation documented and Proto typed to-be model.
- Involved in Creation of Blue print configuration document and in design & configure OTM application for PO and Sales order management, Planning & Execution and Freight Pay.
- Familiarly with Ocean EDI messages and mapping with OTM Sailing Schedules for Inbound flow.
- Designed the Integration Interfaces between Order Entry & Financial System SAP to / from OTM through EAI products Tibco. In addition to providing the XML mappings for the interfaces, designed & developed the Integration Saved Queries, Automation Agents and Milestone Monitors for automating the business processes.
- Designed and Developed solutions & configured OTM to support large volumes of inbound and outbound in OTM.
- Loaded CSV rate load for TL, LTL and fuel surcharge.
- Actively participated in UAT & system testing along with business users, and provided error resolution.
- Involved in creating bills and invoices using BI publisher.
- Developed user manuals and trained the trainers to help with smooth Go-live.
Confidential,IN May’ 08 – Nov’ 09
OTM Functional Consultant/Support - OTM 5.5 CUx, SAP 5.x.
- Wrote functional specifications for integration with SAP execution and financial module objects for Shipment, Tender, Invoice and Voucher.
- Provided functional design/specifications to create automation Agents.
- Helped in functional testing of the standard flows between SAP and OTM.
- EDI to OTM invoice Mapping. Integrate 110,210,310 from Carriers to OTM provided assistance to understand IG and map with OTM message objects for single and consolidated invoices.
- Helped in setting up the carriers, contacts, notifications for different protocols (HTTP, email and Rebserve).
- Configured Bulk plan Saved queries using different grouping & filtering logic assisted in testing the bulk planning; familiar with Planner Parameter setup.
- Modeled the carrier, distribution center and consignee information in Transportation Management Systems.
- Modeled the carrier tariffs and cost structure. Setup the system for Automatic freight matching and payment. Developed tools to automatically upload vouchers.
- Tested optimization strategies for truck load planning. Integrated TMS with legacy applications (OMS, WMS) and also developed customized workflows.
- Provided training to customers and helped in a smooth transition to Support the application.
Confidential,TX Aug’ 07 – March’ 08
Integration Consultant
This is a web based Enterprise Application for integrating Supply Chain Scenarios with an existing Order Management systems. It is a B2B web-hosted portal and supports across the board services for customers that book with any of the participating carriers for their shipments. It standardizes the network system for orders from Warehouse management systems and initiates the logistics transactions. It also standardizes the access to the all the carriers who are participating via EDI and providing the tools to enable third party supply chain system to connect to all participating carrier transactions. It also offers a number of useful tools for Tracking, Viewing Events on containers under a booking, and to have online booking requests and confirmations to and from the participating carriers.
- Gathered Business requirements and prepared solution design for developing Sales Order processing and Invoicing Application.
- Involved in collecting OMS related EDI requirements & documenting the mapping inbound and outbound requests.
- Worked with development team to develop appropriate components as per functional design. Performed testing based on test scenarios prepared.
- Supported System Integration testing, User Acceptance testing and cutover activities to migrate the code to Production instance.
Confidential,FL March’05 – June’07
SAP FI-SD Integration Consultant
- Preparations of storyboard and blue prints. Creation of company code, and other basic settings. Implementation of GL, AR and AP.
- Written various EDI IGs for 214 and 940 and 860 messages, help ABAP Team
- Provided configuration support in SD, MM for account determination, Pricing Conditions, Info Records, Source List.
- Involved in testing, training client, validating data and using training client
- Providing necessary assistance of SAP end users. Documentation of Business Process Procedures.
- Provided offshore support in the areas of Finance and Controlling.
SKILLS SUMMARY:
Oracle Platform and ArchitectureOracle 10g, 9i and 8i, OTM 5.5 , 6.x
Web TechnologiesXML, HTML, Java, J2EE, JSP
Tools UsedMS Office Suite, MS Project, MS Visio, Share Point, Use Cases, Process Maps, Mercury QTP & Load Runner, , Rational ReqPro, Primavera, Kintana, Workbench, Clarity, BI Tools.
Supply Chain ApplicationsOracle Transportation Management, Oracle Applications Order to Cash applications involving Order Management, Inventory, Account Receivables, Oracle 10g 11i and SAP.
Hardware & Operating SystemsWindows NT, Windows XP, Sun Solaris, Unix, Linux
Engagement ExperienceApplications Configuration, Business Requirements Gathering, Solution Design, Project Management, Test lead, XML,CSV, SQL, EDI, Testing Script Creation, Testing Administration, End User Training, End User Documentation, Process Improvement and Configuration
Education: Bachelor’s Degree in Electronics Communication and Engineering
Certification: SAP TERP-10 CERTIFICATION, OTM Training from Oracle University.
