Vijay Ganesan

1. Establish COE for Business Data Analytics in GCC in South Asia by getting knowledge transition from stakeholders in Japan and USA. 2. Lead hands-on effort using Python’s DA libraries to analyze order shipment, stock, inbound & returns inventory of 3PL prospects to draw insights on current warehousing operations and to facilitate sales proposals & customer success inquiries. 3. Lead the analytics consulting & delivery effort to develop & maintain product operation monitoring dashboards, tools for bin packing, sizing PA-AMR & ASRS installation, increasing hit ratio, modelling optimized warehouse layout & evolving analytics needs for product operations & delivery excellence. 4. Design simulation sub-scenarios to identify influential & non-influential factors on order picking productivity in an ASRS. 5. Spearhead innovation & continuous improvement initiatives for tools & processes used for supporting sales & customer success functions & product operations. 6. Innovate using multimodal GenAI with right prompt engineering techniques. Accomplishments 1. Successfully set up a analytics COE in GCC resulting in significant savings for the parent company. 2. Improved the maturity of sizing tool for ASRS by taking up continuous improvements to save 25% of sizing effort. 3. Developed a tool to calculate count of a SKU type that can be packed in a bin based on dimensional packing. 4. Proposed a framework to reduce trial-and-error simulations required for increasing order pick productivity. 5. Proposed to automate conversion of warehouse maps across file formats & enhancement of simulator to consume any map to decrease TAT. 6. Improved operational efficiency by 10% by proposing process changes to track sizing requests by integrating wrike with slack. 7. Proposed an operating procedure to slash OPEX in usage of Cloud servers for running robot simulations. 8. Proposed to execute scaled down simulations by default to improve response TAT and minimize cloud OPEX.

As a Data & Analytics consultant for clients in multiple industries, I contributed in the following ways to their Digitalization, Analytics and Information Management goals: 1. Led the effort to analyze & visualize customer transactions of a retailer to decipher customer behavior & identify takeaways. 2. Led the effort to ideate, propose & automate comparison approaches to validate accuracy of data migrated from On-Prem Sources to GCP. 3. Led the effort to understand client’s non-negotiable Data Quality requirements & evaluate leading products against a feature list to recommend the most fit-for-purpose product suited to the client’s use cases. 4. Led the effort for analysis of data incidents, prioritization using pareto analysis & identification of the root cause for recurring incidents & collaborating with data owners & data stewards for getting corrective & preventive fixes deployed in production. Led the effort for identification of CDE, framing of data quality checks, data profiling, data cleansing, data standardization, data quality monitoring & data quality remediation. 5. Led the effort for data governance and data quality to enable compliance with BCBS239 regulation. 6. Led the Agile Program Management effort for BI platform re-engineering for the merged entity of two US commercial banks. Led the delivery of report rationalization, MIS reports, dashboards, data visualizations. Accomplishments 1. Was instrumental in improving delivery velocity by 25% through increased collaboration between workstreams aided by re-sequencing of development lifecycle activities and promoting progress transparency using a collaboration dashboard. Proposed productivity hacks such as bulk upload of product backlog items into RALLY saving 2 hours every week. 2. Automation to compare quality of data migration to GCP resulted in savings of 125 hours of effort for comparing 250 tables. 3. Data Analytics findings using customer transactions improved retailer’s sales by 25%.

As a Techno-Functional Project Manager for clients in multiple industries, I contributed in the following ways to their Digitalization, Analytics and Information Management goals: 1. Led the Agile Program Management effort for integration of data feeds received from reporting entities of a bank into a Data Vault, Stress Testing and BI for monitoring Expected Credit Loss (ECL) and determination of provisions to be set aside for meeting liquidity obligations. 2. Led the Agile Program Management effort for integration of data from disparate traditional data sources into SAP ECC, development of a scalable integration platform to automate data flow between clinical sources and clinical targets, development of big data applications for medical devices to enable identification of RCA of failure and develop a KPI system to measure reliability of Supply Planning. 3. Led the Agile Program Management effort at onsite for delivery of Data Integration of Traditional data and Big Data and BI meant for deriving insights from data on Prospects, Premises and Interactions. 4. Led the Program Management effort for maintenance of an ODS and Self-Service BI. Planned and executed migration of ODS from On-Prem MSBI stack to AZURE cloud platform. 5. Led the Project Management effort for re-engineering of Data Integration and BI platform from legacy NOMAD technology to Informatica and Microstrategy respectively. Led Change Management. Accomplishments 1. Operated projects/programs with an EBITDA of 25+%. Consistently scored high on Employee Satisfaction (ESAT) score. 2. Ideated Continuous Improvement (CI) & Automations to reduce Production Support effort by 20% & resulting FTE count. 3. Ideated & provided techno-functional support to develop a Parser to save 4.1 MUSD for a client in a Re-Engineering project. 4. Created a reporting template to standardize status collection from multiple tracks resulting in savings of ~5 hours every week

As a Techno-Functional Project Lead for clients in multiple industries, I contributed in the following ways to their Digitalization, Analytics and Information Management goals: 1. Functioned as a techno-functional Business Analyst cum Project Lead in maintenance and support of a Business Process Management (BPM) product meant for Customer Service for Finacle’s clients. Reduced production support effort by 25% by advocating Problem Management driven by Root Cause Analysis (RCA) and Pareto analysis of service requests and by promotion of self-help manual. Contributed as a product consultant for the modernization initiative. Contributed on development work undertaken for Data Integration, Business Intelligence and for tuning SQL Queries & underlying data model to improve response time of backend queries both by manual study, examining execution plan & by using tools like Profiler, DTA (Database Engine Tuning Advisor). 2. Managed the initiative to migrate SQL Server DTS packages to SQL Server SSIS packages and .Net 1.1 framework-based applications to .Net 3.5 framework. 3. Led the design and development effort from offshore effort to get from GLOSS real time summarized information on clearing and settlement status and perform intraday reconciliation by parsing SWIFT extracts (XML files), loading the parsed data into Oracle database, development of Actuate reports for business data analysis and decision support from the same and generating test data for Volume/Performance testing.

As a Techno-Functional Consultant in the Sourcing & Procurement & Pricing divisions of a Mining & Manufacturing Client, I contributed in the following ways to the client's Digitalization, Analytics and Information Management goals: 1. Maintained and supported a PowerBuilder Foundation Classes (PFC) and Sybase ASE based Client Server application meant for digitalization of Procurement and Contracting functions. In due course, I was instrumental in migrating the data from the client server application to a Commercial Off-the-Shelf (COTS) procurement contract management product and co-ordinating the global rollout of the Global Contract Management System (GCMS) to the client’s offices worldwide. 2. Developed DTS packages for Extracting the Spend details received from the client's plants distributed worldwide, Profiled and Cleansed the extracted data using Data Quality rules, Standardized Transformed and Loaded the spend data into a Global Enterprise Data Warehouse (GEDW) for enabling descriptive Spend Analytics. 3. Provided production support to Java/J2EE based web applications meant to be used by Plant Engineering Stockrooms for generating and associating 11-digit numbers akin to Stock Keeping Unit (SKU) to stockroom items. Monitored scheduled batch jobs, interpreted the error reports generated by them and took corrective action to resolve the errors. 4. Developed SQL queries and DTS packages for Extracting, Transforming and Loading Customer data into the Global Enterprise Datawarehouse (GEDW) and performed other DBA activities as needed. Processing and loading cleansed and transformed customer data into GEDW enabled the client to accurately calculate Sales Compensation for the Sales Managers. 5. Maintained and supported a Java Swing based application meant to digitalize storage and retrieval of prices of traffic safety system products. Innovated to develop a price loader utility that could bulk upload prices of products and thus avoid manual entry effort.

As a Techno-Functional Consultant for a Media and Entertainment client, I contributed in the following ways to the client's Digitalization goals: 1. Designed and developed a configurable and metadata driven Compare Utility to facilitate comparison and reporting differences between data stored in legacy systems and an integrated data hub created for serving the business needs of downstream systems. The Compare Utility was developed using Java and JDBC and the data comparison approach was programmed in SAP IQ (erstwhile Sybase IQ). This utility enabled the client to validate the quality of Data Migration. 2. Maintained and supported a PowerBuilder and Sybase ASE based Client Server application to enable media agencies buy advertisement spots on televised programs and to plan, package and manage their advertisement campaigns. 3. Tested a Java/J2EE application meant for campaign management for a Media Research client.

Series of 5 advanced courses in Supply Chain Management spanning across 18 months, run and accredited by MIT Center for Transportation and Logistics. SC0x: Supply Chain Analytics SC1x: Supply Chain Fundamentals SC2x: Supply Chain Design SC3x: Supply Chain Dynamics SC4x: Supply Chain Technologies and Systems https://micromasters.mit.edu/

Post Graduate Diploma in Business Administration