Project Oracle
Resume:
Satya Bala Kapila
Phone: +1-832-***-****
Email: ************@*****.***
WMS Business Systems Analyst
Functional Business Analyst, ERP with around 12+ Years of experience. Expert in global Implementations, Agile/Waterfall Project Methodologies, Product Testing, Functional Gap Analysis, Migration/upgrade Systems. Comprehensive understanding of the functionality, Setups, dependencies in SCM with specialty in Warehouse Management Systems, Order Management, Purchasing and Inventory Modules. Strong interpersonal skills, exceptional communicator, good team player, proactive in problem resolution, aptitude to simplify business processes and adaptability to changing client requirements
Areas Of Expertise
Warehouse Management Systems
Oracle Extensions for WMS Endeca
Mobile Supply Chain Applications
Inventory Management Systems
Oracle Yard Management Systems
Distributed Warehouse Management Systems
Fusion Data Migration
Oracle Inventory and Discrete Manufacturing
Order to Cash (Order Management)
Procure to Pay(Oracle Purchasing)
Project Management & Methodology
Oracle Shipping
User Acceptance Testing and Document SDLC artifacts
As-Is and To-Be Documentation
Business Cases/Evaluation
Training & Team Building
Issue Resolution
Strong written and communication skills
Strong Technical knowledge
Requirements
Requirements /Gap analysis
EXPERIENCE SUMMARY
Mar, 2018 -Till date Driscoll’s Berries & Associates, Watsonville, CA as WMS Implementation Consultant
May, 2017 to Feb,2018 Powell Industries Ltd, Houston, TX as EBS Functional Consultant
Feb 2017-May 2017 Niagara Bottling LLC, Ontario, CA as WMS Business Systems Analyst
July 2015 to Jan,2017 I Consulting INC Redmond WA as a SCM Functional Analyst
Feb,2011 to Dec,2014 Oracle India Pvt. Ltd, Hyderabad as a Sr. SCM Functional Analyst.
Dec,2005 to Nov,2010 Infosys Technologies Limited as a Programmer Analyst
ACHIEVEMENTS
Hosted Seminars in Oracle Customer Meets subjected to SCM and WMS & Endeca products.
Received the ‘Appreciation Momentum’ from Oracle University for contributing the trainings on Oracle WMS Modules
Achieved ‘Best Performer of the Quarter’ from Infosys Technologies Limited for delivering complex Oracle XML Publisher Reports
Have secured ‘Infosys Prestigious SPOT Award’ for the design and development carried for
complex Sales Online Quote Approval Workflow and for my contribution towards the project.
Received Multiple Client appreciations for most of the components developed and quick issue handling capabilities during these Implementation Projects during Infosys Period.
TECHNICAL SKILLS
Operating Systems : Windows XP, UNIX.
Databases : Oracle, Sql, Pl-Sql
ERP : Oracle Apps(Release 11.5.10,R12.1.3,R12.2.4),MS Dynamics
Oracle Apps Tools : Endeca, ODI, XML Publisher, Workflow Builder
Project Management Tools : Microsoft VSS, TFS, JIRA, Oracle Beehive,Oracle Bug DB,Zendesk
Certifications
Certified Oracle Partner Network candidature –Oracle Supply chain Managements
Certified Oracle Partner Network candidature –Oracle Application Developer
Certified Oracle Partner Network candidature –Oracle XML Publisher
Professional Experience
1.
Project Name: JDA WMS Implementation
Role
WMS Implementation Consulting & QA
Organization
Driscoll’s Associates, Watsonville, CA
Duration
Mar 18 – Till date
Software
MS Dynamics ERP, Mobile WMS, JDA WMS(Red Prairie), Integration Boundary Systems, QTest, JIRA, Zendesk, MS Teams and SharePoint
Project Description:
Microsoft dynamics is the Enterprise Resource Planning Application for Driscoll’s. Driscoll’s use MS Dynamics for Manufacturing, Finance, Purchasing, Order Management and Project Management. Changing business needs require that the ERP System is enhanced and upgraded to meet the new requirements. Driscoll’s uses Legacy WMS “Mobile” applications tools for logistics and warehouse operations. This project is transformation of legacy WMS Systems to JDA Redpraire for all their warehouses across Us, Mexico, Europe countries. This Project involves new implementations / roll outs and support existing WMS systems before the go-live. The range of activities involved in this project includes requirements gathering, designing, building, testing and deploying the new implementation/roll out.
Responsibilities
Analysis of Business Requirements & enhancements for the existing objects across all ERP Modules like EBS WMS, SCM, and back office Financial applications.
Provide production support and quick Issue resolution to the business users
Build Test Strategies and Requirement Traceability Matrixes for the new Implementation.
Complete End to End business model Test Scenario preparations and Test Executions.
Support Enhancements and troubleshooting of existing WMS Systems
Interact with BA and BRM’s for planning and execution POC’s of WMS Processes.
Defect fixing and Bug Resolution and Trouble Shooting of Production Issues
2.
Project Name: EBS Technical and Functional Support
Role
EBS Functional Consultant
Organization
Powell Industries Ltd, Houston, TX
Duration
May 17 – Feb 18
Software
Oracle Applications E-Business Suite R12 WMS, SCM, FIN and ERP Tools, TFS and Microsoft VSS, ECR
Project Description:
Oracle Apps is the Enterprise Resource Planning Application for Powell. Powell use Oracle Apps for Manufacturing, Finance, Purchasing, Order Management and Project Management. Changing business needs require that the ERP System is enhanced and upgraded to meet the new requirements. Powell is also in the process of deploying Oracle Apps across more manufacturing locations. This Project involves Oracle Applications related development, enhancements, upgrades, support and new implementations / roll outs. The range of activities involved in this project includes requirements gathering, designing, building, testing and deploying the enhancements, fixing of broken customizations during upgrade and any new implementation/roll out.
Responsibilities
Analysis of Business Requirements & enhancements for the existing objects across all ERP Modules like EBS WMS, SCM, and back office Financial applications.
Provide production support and quick Issue resolution to the business users
Enabling shipping process using WMS processes – Paper based pick, Direct ship
Developed complex WMS picking Rules for the Outbound shipping and allocation methodologies and Intra-company business operations.
Worked on Mobile Personalization designs to meet the customer complex business structures
Developed prototype and POC enhanced solutions for supply chain Demand and replenishment models for the WIP and BOM modules of the manufacturing operations.
Defect fixing and Bug Resolution and Trouble Shooting of Production Issues
Developed multiple complex reports and interfaces for modules like, SCM Purchasing Documents and WIP Discrete Job reports etc.
3.
Project Name: SCM WMS Functional Implementation & Support
Role
WMS Business Systems Analyst
Organization
Niagara water Bottling LLC Ontario, CA
Duration
Feb 15 – May,17
Software
Oracle Applications E-Business Suite R12 SCM, PL/SQL, Manhattan WMS and E80 WMS, Telnet, GUI
Project Description:
This project is a full suite WMS Implementation for the global reach. Solution was designed from scratch based on the future requirements. Project Scope involves implementation of Oracle EBS, Manhattan WMS and E80 solutions for each of the manufacturing and Distribution plants of Niagara across the world. As a WMS Analyst, I have been involved in the Production Support and Upgrade/Implementation Team.
Responsibilities
Analysis of Business Requirements & Identified GAPS for WMS Solutions for all three types of Installations during implementations(Oracle WMS, Manhattan WMS, E80 WMS)
Provide production support and quick Issue resolution to the business users for P1,P2,P3 models
Applied Agile Project methodologies using Project Management tools like JIRA etc.
Design custom pages for Mobile Supply Chain Applications
Defect fixing and Bug Resolution and Trouble Shooting of Production Issues
Functional Specification Documentation and Fit Gap Analysis
Design and Develop Custom Private Labelling for the partners.
Developed POC and prototype solutions for the clients complex LPN Transfers modules to be compatible with the integration challenges of versatile WMS Layers.
Conducting cross functional team meetings with business stake holders
Prepared MD50 for the new enhancements
4.
Project Name: E- Business Suite R12 Implementation
Client
L.S.Starrett Tools Company, Athol, MA
Role
WMS Business systems Analyst
Organization
I Consulting INC, Redmond, WA
Duration
July 15 – Jan 2017
Software
Oracle Applications E-Business Suite R12, PL/SQL, Oracle XML Publisher, Workflows
Environment
(With version)
Oracle Applications R12
SCM, MFG,WMS,OM, INV,WSH,PO
Project Description:
This project is a full suite Oracle Implementation for the global reach. Solution was designed from scratch based on the future requirements. Project Scope involves implementation of Oracle EBS and developing extensions within Oracle Applications framework to deliver configuration solutions to meet client’s complex product configurations requirement. As a Techno functional analyst, I have been involved in the Post Production Support Team.
Responsibilities
Analysis of Business Requirements & Identified GAPS for SCM Modules like WMS, INV,OM, Mfg, and PO Modules
Documented high-level & detailed specifications for the Gaps and customizations identified
Responsible for configuring end to end WMS setups for the new facilities of the organization
Provided Post production functional support for SCM Logistics and Manufacturing Modules
Provided Maintenance and production support for technical RICE components like XML Publisher reports, Workflows, Extensions etc.
Lead CRP and UAT Training sessions and reviewed AIM documents for Oracle SCM modules.
Performed end-to-end P2P & OTC Integration testing for Oracle Purchasing,, Oracle AME and Order management.
Analysis of Business Requirements & Identified GAPS for SCM Modules like INV,OM, PO, Mfg. Modules and transformed the enhancements into MD50’s with the proposed solutions using Oracle RICEW tools.
5.
Project Name: Oracle EBS – SCM- WMS
Role
Senior Functional Analyst
Organization
Oracle India Private Ltd – Hyderabad
Duration
Feb,2011 – May, 2015
Releases
R12.1.3+, R12.2. R12.2.3, 12.2.4,12.2.5
Modules
Oracle Applications
SCM-Logistics : Warehouse Management Systems, Inventory Management systems, DWMS, Oracle YMS and Warehouse Shipping, OM, PO,OPM
Project Description:
Oracle Warehouse Management (Oracle WMS) is a fully integrated component of Oracle's integrated E-Business suite. It supports warehouse configuration, task dispatching, flexible pick methodologies, advanced material handling and control (including license plating), advanced lot and serial control.
Oracle WMS Supports: Mobile Devices, Inbound Logistics, Outbound Logistics, Advanced Inventory, Storage and Facility Management, Wave Planning and Warehouse Shipping transactions
Responsibilities
Understand the WMS Functionality thoroughly.
Responsible for doing all the WMS related setups in any New Environment
Responsible for Certifying the WMS Product for the R12.1.3+, R12.2, R12.2.4 releases.
Responsible for End to end DWMS Setups and certify the Logistics Functionalities
Responsible for YMS Setups and certify the Features
Worked for Major OPM Customer specific enhancements for Advance Catch weight implementations with Pharma and Manufacturing industries
Expert in certifying the Customer one off and ER’s
Expert in upgrade and migration testing.
6.
Project Name: Oracle Extensions for WMS Endeca
Role
Senior Functional Analyst
Organization
Oracle India Private Limited
Duration
Mar 11- Dec 14
Environment
(With version)
Oracle Applications R12.2.5
SCM-Logistics (WMS& INV)
Project Description:
Oracle Endeca Information Discovery is a data discovery platform that guides people to better decisions on diverse and changing data. It is based on a patented hybrid search-analytical database, and gives IT a centralized platform to rapidly deploy interactive analytic applications, and keep pace with changing business requirements while maintaining information governance.
Endeca for WBS logistics applications plans on providing action driven analytics for Outbound, Inbound, Inventory and Productivity related operations in the warehouse.
Responsibilities
Upload ETL Data Sources from the Endeca Studio server
Run Full Load & Incremental Loads from Endeca Clover servers
Preparing various test scenarios involving creation of variety of data in EBS and checking the data compatibility in WMS Logistics Endeca layers(Plan& Track Fulfillments, Space and Labor Utilization)
Performing System Testing and validate Endeca Pages for the SCM Logistics
Perform WMS Transactions through Endeca UI Interfaces
7.
Project Name: Fusion Data Migration Implementation
Role
Senior Functional Analyst & Central POC for Project Execution
Organization
Oracle India Private Limited
Duration
Mar 11 - Dec 14
Environment
(With version)
Oracle Applications(R12.1.1)
EBS, SCM, Oracle Beehive
Project Description:
This project is a full suite Oracle Migration and upgrade activity. All the ERP EBS versions are upgraded to Fusion Version.1 using the tools like ODI and validation analysis carried out using ADF (Application Diagnostics Framework). As a QA, I have been involved in the validation and analysis of migration objects in the target systems (Fusion V1) w.r.t Source Systems EBS and As a central POC it also involves activities like executing the ODI interfaces for migrating the EBS Data to Fusion V1 Database.
Responsibilities
Execute ODI Interfaces at runtime migration & Debug the interfaces for all migration Jobs
Have designed automation validation framework which publishes the migration script results w.r.t the volume migrated and database objects
Preparing various test scenarios involving creation of variety if data in EBS and checking the data compatibility in Fusion instance.
Performing Unit Testing, Integration Testing and System Testing.
Analysis of Business Requirements with the Fusion Counterparts
Defect Fixing
8.
Project Name: E- Business Suite Implementation
Client
STARBUCKS Coffee (NA Rollout), USA
Role
Senior Technical Consultant
Organization
Infosys Technologies Ltd – Hyderabad
Duration
Jan 09 – Nov 10
Hardware
Sun Solaris
Software
Oracle Applications E-Business Suite R12 PL/SQL, Oracle D2K, Oracle DBMS, Oracle XML Publisher, Workflows
Environment
(With version)
Oracle Applications R12
SCM, WIP, INV,ASCP
Project Description:
This project is a full suite Oracle Implementation for the global reach. Solution was designed from scratch based on the future requirements. Project Scope involves implementation of Oracle EBS and developing extensions within Oracle Applications framework to deliver configuration solutions to meet client’s complex product configurations requirement. As Software Designer and Developer, I have been involved in the Extensions Team.
Responsibilities
Involved in Development and Customization of all types of RICE Components.
Preparation of Detailed Technical design documents for the RICE Elements.
Analysis of Business Requirements & Prepared detailed designs for Inventory and WIP modules.
Unit & Integration Testing
Defect Fixing
Code & Design Review
9.
Project Name: E- Business Suite Implementation
Client
Hanover Compressors Limited, USA & Exterran Compressors Ltd, USA
Role
Software Designer & Developer
Organization
Infosys Technologies Ltd – Hyderabad
Duration
March, 2007 –July 2009
Software
Oracle Applications E-Business Suite 11.5.10 and R12 PL/SQL, Oracle D2K, Oracle DBMS, Oracle XML Publisher, Workflows
Environment
(with version)
Oracle Applications
WIP, INV, PO, OM and Shipping
Project Description:
Oracle Apps is the Enterprise Resource Planning Application for Hanover. Hanover use Oracle Apps for Finance, Manufacturing, Human Resource Management, Purchasing, Order Management and Project Management. Changing business needs require that the ERP System is enhanced and upgraded to meet the new requirements. Hanover is also in the process of deploying Oracle Apps across more manufacturing locations. This Project involves Oracle Applications related development, enhancements, upgrades, support and new implementations / roll outs. The range of activities involved in this project includes requirements gathering, designing, building, testing and deploying the enhancements, fixing of broken customizations during upgrade and any new implementation/roll out.
Responsibilities
Analysis of Business Requirements
Development and Customizations of RICE Components
Preparation of Detailed Technical Design documents and Unit Test Plans
Unit & Integration Testing
Code & Design Review
Optimizing SQL Queries for better performance
10.
Project Name: E- Business Suite Implementation
Client
TOSHIBA Electronics Ltd
Role
Software Designer & Developer
Organization
Infosys Technologies Ltd – Hyderabad
Duration
Nov, 2006 to Mar, 2007
Software
Oracle Applications E-Business Suite 11.5.10 and PL/SQL, Oracle D2K, Oracle DBMS, Oracle XML Publisher
Project Description:
The project involves development of Single Global application (SGA) for Toshiba worldwide. Focus of this project is to replace current legacy systems and to development a single global applications for all the sites across the world It involved the extension of the standard Oracle Apps 11.5.10 modules like Outbound, Inbound, Inventory, and Distribution. These extensions were developed using the PL/SQL, Oracle Forms and Reports and OAF.
Responsibilities
Analysis of Business Requirements
Development and Customizations of RICE Components
Preparation of Detailed Technical Design documents and Unit Test Plans
Unit & Integration Testing
Defect Fixing
Documentation
Code & Design Review
Optimizing SQL Queries for better performance
11.
Project Name: Immigration Project
Client
Microsoft Technologies Ltd
Role
Software Engineer
Organization
Infosys Technologies Ltd – Bangalore
Duration
Aug, 2006 - Sep, 2006
Hardware
Windows
Software
C#, ASP .Net, MS SQL Server, Web Services, HTML and XML Languages
Project Description:
The Project involves development of Immigration related documents and forms for Microsoft employees and also the Web Applications related to the Immigration and Visa Processing exclusively for Microsoft employees. This Project involves Dot Net related web applications and many forms which are using C# as their programming languages.
Responsibilities:
Analysis of Business Requirements
Unit & Integration Testing
Code & Design Review
Optimizing SQL Queries for better performance
12.
Infosys Entry Level Training
Role
Software Trainee Developer
Organization
Infosys Technologies Ltd – Mysore
Duration
Dec 2005 - May 2006
Trained on
Microsoft Technologies
Microsoft .Net Technologies like C#, ASP .Net, ADO .Net, RDBMS, MS SQL Server, Web Services, HTML and XML Languages
Training Description: I have attended Infosys entry-level training as a fresher on .Net Technologies. The Project involves learning of different technologies that are currently required for the Business Processes of the Company.
Educational Qualifications
Bachelor of Technology in Electrical & Electronics Engineering April 2005 from Jawaharlal Nehru Technological University, Hyderabad, Andhra Pradesh secured First class .
Contact this candidate