Pramod Karna P
Chennai
Summary
Detail-oriented and results-driven business analyst with a proven track record of facilitating cross-functional collaboration to enhance process efficiency and documentation. Expertise in innovating business processes across diverse sectors, including automotive, FMCG, and IT, to drive organizational success. Committed to achieving optimal results through strategic analysis and cost-effective solutions. Seeking opportunities to leverage analytical skills and industry knowledge to contribute to transformative business initiatives.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Manager – Business Analyst
Quaking Aspen Private Limited (Pando), India
12.2022 - Current
- Pando – It’s a TMS product(SaaS)-based company.
- Established baseline cost for all the clients and publishing the cost savings due to implementation of Pando.
- Finalized the key metrics to all the modules present in Pando (Optima, Manage, Pay & Track-Trace) for all the clients (as per client’s usage of Pando)
- Designed, developed and automated the reports to all clients as per key metrics.
- Designed & developed the dashboards in Power BI and published in Power BI services.
- Reporting the metrics on monthly basis to all the clients with insights to improve the cost savings, productivity & data correctness.
- Streamlined the baseline methodologies based on type of the client and constraints applied in optima logic.
- Performed business requirement analysis and documented as-is & to-be process.
- Identified the gaps in the process and provided the solution to it before documenting the to-be process.
- Leading logistics digitization project (TMS implementation) for leading FMCG company.
- Acting as a SPOC and liaising with developers and client (FMCG).
- Apple-Inc: Led end-to-end freight costing for a Fortune 10 client (Apple | ~$380B+ annual revenue), covering 50+ SCACs across air, road, and ocean transportation modes.
- Designed and built a scalable, real-time costing pipeline using Amazon Airflow, capable of processing and costing up to 7 million shipments per week across carriers and modes.
- Developed executive and operational dashboards using Power BI and Amazon QuickSight, improving invoice-aligned costing accuracy from ~70% to 90%+.
- Built RCA and exception-monitoring dashboards, increasing speed to identify discrepancies and capture value by ~3×, strengthening accrual accuracy and audit readiness.
- Implemented a weight hierarchy model using multiple inbound weight sources (shipment, carrier, and event data) to ensure consistent rating and prevent over/under-costing.
Functional Consultant || D365 || 3PL
Mercurius IT Private Limited, India
06.2022 - 12.2022
- Wrote effective documentation for each client system to deliver comprehensive sets of requirements and alignment with business objectives.
- Liaised between IT infrastructure team and other personnel to assist with resolution of system issues.
- Determined proper methodologies and procedures to use based upon project specifications.
SCM Analyst
ITC Limited (ESPB), India
09.2019 - 06.2022
- Logistics Analyst: Doing logistics cost calculations of RM & FG stock (Local & interstate movements) and analyze the drivers that influence the overall logistics cost to provide the inputs to national logistics manager.
- Designed, developed & managed the tool for trucks indenting of FG stocks to adhere the transporter share allocation as per plan. Based on the serviceability of the transporters, debit amount is calculated for late placement & non-placement of trucks and make sure that transporters agree for the debit amount with required proofs.
- Project ITCOne: Negotiating & finalizing the transporters of different divisions (Internal ITC) under one roof. In this project, part of transporter finalization team for ESPB division based on their past serviceability & cost and analyzed the cost impact on total savings for finalizing good serviceable transporter with higher rates.
- Budget Planning: Did total logistic cost (warehousing, transportation & assets) plan for 3 financial years 20-21, 21-22 & 22-23 along with National logistics manager.
- Logistics Executive: Monitoring out-right purchase (non-notebooks section) dispatches from planning to delivery and its cost analysis. Indenting trucks for FG stock and coordinating with transporters for ontime vehicle placement. Measure and monitor gaps in service levels with reasoning and make corrective action plans with National logistics manager and monitor improvement.
- Coordinating with logistics team to ensure the SRN (Sales Return) details are captured and presented to concerned stake holders on timely basis.
- Handled export operations (EXIM) of modern trade customers (mostly to US).
Assistant Manager
TVS Supply Chain Solutions (TVSSCS), India
06.2014 - 09.2019
- Warehouse Management: TVS Motor Company
- Managed 5 Lakhs sq.ft spare parts warehouse of TVS motor company (2-Wheelers) and did projects to improve the productivity of pickers, loading time reduction of vehicles, Damage reduction & project Vanning by using Warehouse slotting techniques, Operations management, TPS & Lean-six sigma concepts.
- Consultant: First Step Baby Wear
- Went as a consultant to FSBW which is one of the largest manufacturers of kids garments. Optimized warehouse capacity by proposing racking system based on type of goods, changed the picking method to improve productivity levels and designed semi-automated excel-VBA based tools to reduce the manual errors and increase the productivity which led to acquire the warehousing operations business with 36% of margin.
- Process Automation through VBA tools:
- Designed semi-automated tools for the below mentioned clients through Excel VBA & Macros
- Robert Bosch: Designed 30 tools for SCM & Production planning team to reduce the Cycle time of a process, improve the efficiency of planners & reduce the manual errors by logistics team.
- Daimler: Picklist Generation, Intransit Stock Tracking
- Visteon: Inventory tracking – Gives the track of dispatched stock for past 1 year and also the traces the exact location of existing stock in Warehouse.
- CEAT Tyres: Replica of WMS from binning to dispatch process.
- Turbo Energy private limited: Kanban System – Automatically triggers the production team for picking the stock based on Kanban’s.
- TVS SCS (BID Team): Warehousing commercials comparison
- SCM Solutions: Did scope studies for 5-6 projects i.e. analyzing data and coming up with the solution for manpower required to handle, vehicles requirement and its commercials after implementing the developed solutions. Some of the customers are Tommy Hilfiger, India Cements, Dalmia Cements, ABB and Schneider electric.
- Auditor: Cummins Inc. offered us to conduct an audit on the stock at 183 dealer locations. For this, I designed an application for printing the barcode MRP labels of Cummins and trained a team of 45 members to conduct the audit.
- Warehouse Operations Implementation:
- Gabriel India Limited: Did the study to have optimum manpower required for handling the warehousing operations, set the SOP’s & work instructions. Implemented the best practices and handed over to warehousing operations team after streamlining the processes.
- TVS & Sons Private Limited: Implemented the warehousing operations in 9 existing warehouses. Finalized the warehouse location in Chennai with better serviceability by doing center of gravity analysis and using LOGVRP
- Software Knowledge:
- Microsoft dynamics (CRM): Developed views, forms, reports and executive dashboards for business development team in Microsoft dynamics (CRM). Updated the previous opportunities, accounts detail in CRM by creating some macros (VBA) for cleansing the data. Solved sales executives related issues in CRM and designed executive dashboard prototypes in Power BI.
- TRACE: Supported in implementation of TRACE software in TVS & Sons Pvt. Ltd
- SAP: Have good knowledge to use the SAP GUI version
Education
Executive Diploma - Supply Chain Management
Loyola Institute of Business Administration (LIBA)
Chennai, TN01.2015
Executive Diploma - Supply Chain Management
Loyola Institute of Business Administration (LIBA)
Chennai, TN01.2015
B TECH - MECHANICAL
SASTRA UNIVERSITY
Thanjavur, Tamil Nadu01.2014
Skills
- MS Office - MS Excel, MS Access, VBA in Excel, MS Word, MS Power Point
- Operations Management, Inventory Management, Warehouse Management, LOGVRP
- Power BI
- Microsoft Dynamics – CRM
- SAP
Accomplishments
- Awarded with SBM award for the project FSBW in 2016 and in 2017 for Bosch Automotive Electronic India Pvt Ltd
- Received a best performance award for performing beyond perceived expectations of the customer TVSMC in 2015.
- Received scholarship under Central Sector Scheme, MHRD, Dept of Higher Education, New Delhi.
- Won “Rockstar Rookie” award at Pando for performing exceptionally within 3 months of joining.
Extra-Curricular Activities
Won in a creative Event “Contraptions” in university technical fests DAKSH, SAKSHAMA and SPRINGZ. Third Place in Badminton (Shuttle) in TVS Supply Chain Solutions inauguration function in 2016.
Certification
- Unlock Excel VBA and Excel Macros
- Logistics Optimization with Excel Solver
- Microsoft Power BI - Up & Running with Power BI desktop
- Certified in Import & Export management from iiiEM
Languages
Telugu
Bilingual or Proficient (C2)
English
Bilingual or Proficient (C2)
Hindi
Advanced (C1)
Tamil
Upper intermediate (B2)
Hobbies and Interests
Playing Cricket, Badminton, Chess
Place
Chennai, India
Personal Information
Date of Birth: 12, March 1992
Interests
- Playing Cricket
- Badminton
- Chess
Personal data processing
I declare that the information and facts stated herein above are true and correct to the best of my knowledge and belief.
Timeline
Manager – Business Analyst
Quaking Aspen Private Limited (Pando), India
12.2022 - Current
Functional Consultant || D365 || 3PL
Mercurius IT Private Limited, India
06.2022 - 12.2022
SCM Analyst
ITC Limited (ESPB), India
09.2019 - 06.2022
Assistant Manager
TVS Supply Chain Solutions (TVSSCS), India
06.2014 - 09.2019
Executive Diploma - Supply Chain Management
Loyola Institute of Business Administration (LIBA)
B TECH - MECHANICAL
SASTRA UNIVERSITY
Executive Diploma - Supply Chain Management
Loyola Institute of Business Administration (LIBA)