SUMMARY:
An accomplished Information System professional with extensive experience in hi-end technology of Business Process environment. Distinguished ability to conduct accurate analysis solves problem, assess technical capabilities and integrate complex systems with high-talent team. Implemented a highly integrated Apparel and Footwear ERP applications with WMS/EDI environment. A “One Stop” Solution Provider for short and long term project strategies.
PROFESSIONAL EXPERIENCE:
As a Sr. Analyst – Supply Chain, Providing Total Techno-functional Solutions from Project conception through Implementation and maintenance of Global operations. Identify required Business Process to Automate schedule jobs, Configure Master Data, Cost Templates (PO, IT), Define MRP BOM, paths and to Final Finished Products. Organize the Labels by Divisions, Analyze Demand-source planning and creating controls for ROI. Implemented Oracle RETEK-Retail, Jesta-Essentus, WMS-Pkms Applications with its Inbound / Outbound /Custom Interfaces using latest tools.
6+ years of Business / System Analysis experience in Supply Chain Management
Independently worked with SW vendor on PRODUCT modules and added functionality of Size Range/ scale Grids for Solid and Prepack sizes, similar to SAP AFS Master Setup
Modules are similar to SAP AFS Size GRID, ARUN Allocation functionalities and using for 10000+ customers DC/Retail stores distribution
Translated matrixes ITEMS to warehouse system and maintain the inventory level at various WMS instances and Sync with OM system
Create each project milestone, its dependencies by JAD/JAR approaches and communicate with SMEs on implementation
Conduct strategic Acquisitions Data Conversion planning, Identify Fit/Gap Mapping, Create Process flow with Staging with required API interfaces
Create routine processes to maintain 24x7 / CRON jobs. Integrate external services to Multiple B-Units/ Divisions for Warehouses/3PLs, Web-OM - Yahoo, Amazon, ATG systems
Experienced in all phases of SW project life cycle, utilizing the Oracle technologies, VBScript, PL/SQL, ETL and DB tools
Provide System Specifications to BPO vendors and testing includes unit, integration, upgrades, functional and DB load testing, Secure configuration setup with Traceability Matrix
Maintain SOX Compliance at every level and using SDLC methodology for Implementation
Work with department managers to optimize the system and processes to reduce manual efforts in a high volume environment, Mass Changes
Earned appreciations for dedication, high performance and lead Programmers / Consultants
Saved $1M on Data Conversion and Project / Acquisitions Integration
A member of PMP institute and Team Leader for CMM Level 5 Certification
EDUCATION:
• Bachelors in Science and Technology from Madras University, India
• Diploma in System Analysis and Computer Applications, India
• Member of PMI (Project Mgmt Institute), SIG group
TECHNICAL SKILLS:
ERP Applications ORACLE Retail Supply Chain – RMS, SIM, RETL, SeeBeyond / RIBs (Linux)
& Modules Essentus – OM, Pricing, MRP, EDI / WMS / Financial Interfaces
( Oracle’s Best Award for “Data Integrity” )
Pkms – Receiving/ Shipping, Routing, WIP, INV (Unix)
Mercator – EAI, Inbound / Outbound Interfaces (24x7)
Business Object (Xi) – OLTP Reporting, Universe Designer
OS & Middleware Windows XP, Vista, UNIX, Linux, Citrix & Application servers
RDBMS Oracle 10.g, 9i, SQL Server, MS Access
Languages SQL, PL/SQL, TSL, Shell scripts, Test Script, Java, COBOL
Utility Tools TOAD, ETL, Golden, Oracle developer, Gentran, MS Office /Visio, Editors
PROJECT EXPERIENCES:
Perry Ellis International (PEI-Pery), Miami – FL May ’08 – To date
a) Project Lead: Return Authorization (RA) Confirmation, RMS/SIM to Pkms WH Inve.
RA API Interface was designed in order to process the Return Merchandize into the Inventory and QC for rework. An API Interface program is designed and developed for unmatched SKUs from the original Shipped Items with price validations and will ADD Skus to Distribution system. Another API interface to transfer inventory from RMS/SIM to Pkms Physical warehouse and send the confirmation to RMS.
Responsibilities: Project design, Data Models, BP requirements
• Created API design document with required BP changes and Configure WH Master
• An Interface StoreProc, to transfer between RMS and different Pkms WH instances
• GUI with Data validation against Received units for Approval by Credit Dept.
• Preparation of Project Docs, DB privileges, Email Notification, UAT
Environment: Retek, Essentus, Pkms, PL/SQL, Mercator, Oracle 9i/10g, Golden / TOAD, Visio, SQL
Perry Ellis International (PEI-Pery), Miami – FL Jun ’07 – Apr 08
b) Technical Lead - BP / Interfaces: Integration of PEI Retail Stores in Oracle’s Retek – WMS
PEI has cutting-edge technology in both Wholesale distribution and Retail store systems. A unique company which integrated both environments using many interfaces and connects to Corporate Business. PEI Warehouses acts as a Supplier for Retail stores and ship merchandizes as per Allocation or Transfers. The PO, Intransit, Receipts and Inventory were maintained in RMS and SIM for stores and controlled by Essentus with Custom Interfaces among RMS / SIM, Pkms-WMS and OM-Essentus Applications. The job responsibilities included gathering requirements from Consultants, spec. to developers to create APIs, DB privileges and links with proper System Audit procedures.
Responsibilities: Business Process definition and Project Activities are,
• Interfacing Approved Transfers and Allocations from RMS to Pkms-WMS
• Sending Shipment / ASN info from Pkms-WMS to RMS and SIM
• Receiving RMS PO in the Warehouses and receive cases thro’ an Intransits
• Identified required stored procedures, triggers and other DB objects
• Documented the System Processes, Table Layouts, Constraints, Test and Seed data
c) Technical Lead – Data Conversion: (Jan-May 08) New Acquisition of Liz Laundry, C&C California
PEI has acquired recently Liz Laundry and C & C California divisions from Liz Claiborne, Inc. Convert and Integrate with Jesta-Essentus, a complete Order Management system by interfacing with Warehouses, EDI and Oracle Financials. Drafted the current Business Processes and identified the Data Requirement layouts by Modules. Wrote complete Conversion project plans, design proposals both internally and interacted with clients on “Data sources”. Functional / Technical specifications for all Customer, Item Masters and MRP BOM processes. Converted and Configured Open Transactions to New Divisions, a volume of 0.5m records into Corporate environment.
Responsibilities: Complete Integration includes,
• Identified the environments and organized Development DB for conversion purpose
• Assessment of interfaces and mapping with Fit / Gap Analysis and X-Refs
• Configured Size / Dimension Grids and appended respective sizes for ITEMS
• Gathered BLOCK-IDs for catalog and attached to Primary/Secondary UPCs
• Created all BOM and its path then attached to a ITEM with different cost templates
• Tested on a separate system by creating all Control Sheets for System Audits
Environment: Unix, Windows, Oracle 10g, Access, Mercator, Golden / TOAD, Visio, SQL, PL/SQL, EDI
Perry Ellis International (PEI-Pery), Miami – FL Oct ’06 – Aug ‘07
d) Systems Analyst - ITEM Interfaces: Interfacing ITEM MASTER into Retek – RMS / SIM
An ITEM with multiple color/sizes are created at Design stage in WebPDM and interfaced into Wholesale system. Babsed on Licensed Labels criteria, the ITEMs are uploaded into Retek RMS ITEM MASTER and then to SIM, RPAS and RDW thro’ RIB Interfaces. Pre-defined and User-Defined Attributes are seeded. Provided required Data Models to Consultants and established an Item Interface which runs 3 times / day on a scheduler. Stored Procedures on Shell script is used to interface Style’s updates / deletion into RMS with system Audit Trail records/logs.
Responsibilities: Detail Design and System Testing,
• Identified functional entities for ITEM on Retek RMS – Division, Label, Attributes, UPCs
• Definition of Item level, Class/Sub-class, Packing sizes and Data Mapping from Essentus
• Created a custom model to calculate MAC Cost for Parent/ Child ITEMs from the source
• Integrating 3rd Party ITEMS (Perfumes, Watches, Belts, etc. ) into RMS thro’ interface & Testing
• A Shell script runs on a scheduler by transferring ITEM MASTERs into RMS DB
Environment: Unix, Oracle 9i/10g, SQL, PL/SQL APIs, Retek RMS, SIM, RIB Interfaces, Pkms, Visio
Perry Ellis International (PEI-Pery), Miami – FL Jan ’07 – Jul ‘07
e) Technical Lead - Shipment / EDI ASNs Using BPO-India, replaces MERCATOR/ ASN process
During Quarter / Year end shipping, ASNs gets delayed due to high volume transactions. To avoid a Chargeback from EDI Customers for every late ASN transmission, we replaced the existing Mercator Shipment process into an EDI ASN process with 75% higher performance. PEI provided a complete Interface Program Specifications to re-write the ASN Process to a BPO service provider in India. This shipment process was implemented on 3 Pkms instances for warehouses across US / Canada to handle approx. 75-80K cartons on same day with multiple Transportation types.
Responsibilities: Detailed Design Specifications and Volume Testing,
• Created Detailed Design Documentation and Price negotiations
• Established VPN access, Private DBlinks across Databases
• Specifications to do pre-process and multi-thread processes on a scheduler
• A shell script decides program execution, based on Transaction Volume Controller
• Functional and Volume testing for 2 Pkms instances and half-yearly ending shipments
Environment: VPN, Unix CRON scheduler, Oracle 9i/10g, SQL, Shell scripts, Visio
e) Other Major Projects: Client: Perry Ellis Intl. and Other clients Period: 2000 to 2006
Project Name Clients / Period Project Detail
Division Label to Customer Attribute PEI- Janzten 6 labels – 2007 Reduced Maintenance in Order Mgmt process, by adding Label as an Attribute to each Division Customer and minimized process time
Upgrades Pkms & Essentus PEI (ERP) WMS & OM – 2005/06 Created Gap Analysis, ETL- SQL Loader, Functional / Volume Testing
Integration of 3PL Services PEI – OM/EDI/ WMS – 2005/04/07 Regal Logistics, FMI and APL – Warehouse Integrations
Shipping of Web Orders PEI, Amazon,ATG, Yahoo – 2005/06 Backend Integration of Shipping with Transport Services
Legacy FACTS BBx system to Integrated Essentus. Overall 7 Acquisition project and 95% success rate PEI– Salant/Jantzen /TSI/JAG 2002 / 2003 / 2005 / 2006
ERP Application Integration –Source & Demand Project Study, Design, Mapping, coding & Implementation – BBx programs to Oracle 9i (0.5m records) – Independently implemented. Architect the Size Range/Size Scale concept and defined Prepack sizes in a Size Grid modules. Based on this approach, converted all open ITEMS and inventory units in the respective size ranges.
Sales / Inventory Modules Derco Jewels–SFO,CA- 2000-01 Refined Inventory process, GUI Inquiry and Reports
Container Operations, Saudi Globe Marine Services–1999-2000 Project Lead- INFOPAC-ERP and Integrate Custom Module
Online Financial Services NetFinex.com – 2000 Team Lead – Rational Rose Tools, 8-10 Programmers
Appl. Design & Development SPB PC Ltd, 1996-99 Systems Analyst- Paper Mills Applications & Process design (PDS)
NGO–ActionAid UK Project CODE – India 1992-1996 Systems Manager- Community Development WHO projects
Production Tasks:
• Support Supply Chain Multiple Regions and Production operations – Approx. 600-700 users
• Based on current issues, providing long term process solutions (3PL, SIM Inventory, EDI)
• Sync UPC#, Customer orders, WHSE / Stores inventory between Applications
• Keep ERROR FREE Interfaces and satisfy customers and large user groups
• Co-ordinate with SW Vendors, DBAs, Consultants and techies in a cutting edge technologies
Work Permit – Valid EAD and transferable (No Visa Sponsorship is required).
Work status – Work for any US Employer EAD# A- 089-124-052.
Activities: Sports and Photography
RAVI SRINIVASAN