LALIT SALUNKHE
Data Analyst/Specialist
Pune
Summary
Experienced Data Analyst with over six years of experience in Insurance/Reinsurance, and Supply Chain. Excellent reputation for resolving business problems by converting them into the language that databases understand and improving customer satisfaction by providing accurate and timely reports.
Overview
6
6
years of professional experience
4
4
years of post-secondary education
7
7
Certifications
Work History
Business Data Analyst (Content Delivery Specialist
Rockwell Automation India PVT LTD
Pune
03.2021 - Current
- Translating business problems into data that can be used for visualization.
- Developed end-to-end Power BI Report for Past Due vs Backlog Comparison.
- Worked on Excel application to handle Inventory Projections and Overviews for accurate forecasting.
- Developed three Microsoft Access end-to-end applications to fetch and consolidate plant, warehouse performance information as well as Open PO Information.
- Developed Warehouse, Plant, Inventory metrics derived (nearly setup 40 KPI's) from raw company data to track improvements in organizational efficiency.
- Produced report to track information about shipments in EMEA region for plant managers.
- Tracking Lead Time, Shift on Time, Days on Hand, Production and Shipment related matrices on daily, weekly, and monthly basis. Developed and automated PPV Tracker report that shows Price Part Variance for POs.
- Wrote query to automate and move data from Oracle SQL to Data lake. It was helpful for other users to use results directly into Power BI rather than establish ODBC connection.
- Developed SAP T-codes (through SQVI) to pull data for Weekly Reports created.
- Hands on exposure of using Data lake, SAP, Oracle SQL, SSMS, SharePoint to pull and modify data.
- Maintained energy and enthusiasm in fast-paced environment.
- Created spreadsheets using Microsoft Excel for daily, weekly and monthly reporting.
- Monitored company inventory to keep stock levels and databases updated.
- Worked with customers to understand needs and provide excellent service.
Supply Chain Analyst
OTS Consulting Services LLP
Pune
07.2020 - 03.2021
- Analyzing data on daily basis using statistical methods, text mining, that helps stake holders to make sure product delivery is on time as well as material is in inventory for lesser time.
- Creating visually appealing as well as interactive dashboards into Power BI for our offshore stake holders.
- Writing and running SQL queries to slice and dice, modify, and extract data on daily basis through multiple databases from server. Working experience on Microsoft SQL Server Management Studio (SSMS).
- Spreadsheet modelling and Data Analyzing through dynamic templates and dashboards in Excel/Power BI, and VBA.
- Tracking Lead Time, Shift on Time, Production, and Shipment related matrices on daily, weekly, and monthly basis.
- Working on SAP to collect raw data for few of reports.
- Studied movement of goods to identify gaps in efficiency and other areas needing improvement.
- Supported senior company leaders by delivering reports outlining performance to drive process improvements.
Executive Analyst
Darwish Cybertech India PVT LTD
Pune
12.2017 - 07.2020
- Working as Executive in Planning and Inventory Control department for order and demand forecasting as well as reporting for Darwish Cybertech India PVT LTD.
- Developing statistical models and validating same based on sales history, sales pattern, current market needs, customer approach etc. available with help of tools such as Bayesian Statistical Forecasting, python, Oracle Demantra. Managed to create strategy based on which non-moving stock approximately of AED 1.23 Million is sold out.
- Writing and running SQL queries to slice and dice, modify and extract data as of needed.
- Develops and run forecast accuracy report that helps maintaining forecasting error lesser than 5%. Analyze customer behavior and market intelligence and insights to build more compact and fruitful strategies.
- Spreadsheet modelling and Data Analyzing through dynamic templates and dashboards in Excel/Power BI
- Helping to monitor fleet management solutions in effective way through deep analytics and with help of various tracking systems to optimize fleet cost. Managed to implement strategies based on which monitoring reports developed has reduced fuel wastage by 3%, driver idling by 4.8% and productivity during lunch hours by 2.3% in past two years. Tools used are Excel, and Microsoft Access.
- Performing ad-hoc analytical tasks that lead to better decision-making policies using statistical techniques such as Segmentation, Text Analytics, Hypothesis Testing etc. as well as preparing reports as per requirement which are more focused towards deep Business Analytics/Intelligence.
- Helped leaders understand how to effectively manage Sales, Inventory, and Forecasts.
- Optimized execution of supply chain by forecasting, scheduling orders and balancing inventory levels for over seven Business Units.
- Produced detailed and relevant reports for use in making business decisions.
- Collected, organized and modeled data using Microsoft Access, Excel, Power Query, Power BI, and R Programming.
- Evaluated current processes to develop improvement plans.
- Reviewed internal systems and organized training plans to address areas in need of improvement.
Analyst
WNS Global Services
Pune
05.2017 - 12.2017
- Worked with Canopius (largest privately-owned business at Lloyd's of London) and supported underwriters in their pricing functions.
- CAT Data Processing - Supported underwriters to model risks for various CoB's (Class of Business) like Property & Casualty, US Property, Marine, UK Property, Crisis management, Engineering by performing data engineering of provided data. Thus, helping underwriters to set premiums for insurance policies.
- Performed data review, data cleansing and preparing property and casualty insurance data for catastrophe risk analysis using MySQL, MS-Excel etc. As well as build statistical likelihood models for future references.
- Supported preparation of business reports and monthly as well as quarterly modelling on portfolio roll-ups/claims for each division and CoB as requested.
Process Specialist (Data Analyst)
Infosys BPM
Pune
08.2016 - 05.2017
- Undertook processing of various pre and post binding risk modeling portfolio roll-up tasks while using catastrophe tool (RMS as well as AIR) like RiskLink, CATRADER, TOUCHSTONE, SQL + Building further statistical likelihood models for future references with adherence to set accuracy, efficiency and professional goals.
- Helped Underwriters in deciding premiums for various reinsurance policies as well as comparing losses using risk analysis with help of core statistical analytical techniques such as Bayesian likelihood, Hypothesis Testing as well as with the help of Charts & Graphs, Advanced Excel Formulae etc.
- Assisted onshore catastrophe management in carrying out sensitivity analysis which was very helpful in figuring out different loss structure using different model analyzing tools as well as versions.
- Provided Year on Year (YoY) comparison for same exposure data over different time to have better understanding of how exposure is changing over time for same policyholder.
- Modeled one or more different treaty policies per account, and multiple options per account as requested by underwriters.
Assistant Teacher (Mathematics and Statistics)
P.B.A. ENGLISH MEDIUM SCHOOL
Amalner
06.2015 - 01.2016
- Taught Mathematics for higher secondary standards
- Worked as Class-teacher for standard 8th and class was awarded as best emerging class of school for educational year 2015 – 2016.
Education
Master of Science - Statistics
North Maharashtra University
Jalgaon 08.2013 - 05.2015
Bachelor of Science - Statistics
KES’S PRATAP COLLEGE
Amalner, MH 08.2010 - 04.2013
Skills
Microsoft Excel
Certification
Programming with Python : HandsOn Introduction for Beginners (Online through Udemy)
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
Torture the data, and it will confess to anything
Ronald Coase
Timeline
Enrolled for the MSc in Financial Engineering from World Quant University
04-2022
Business Data Analyst (Content Delivery Specialist
Rockwell Automation India PVT LTD
03.2021 - Current
Supply Chain Analyst
OTS Consulting Services LLP
07.2020 - 03.2021
Executive Analyst
Darwish Cybertech India PVT LTD
12.2017 - 07.2020
Analyst
WNS Global Services
05.2017 - 12.2017
Process Specialist (Data Analyst)
Infosys BPM
08.2016 - 05.2017
Assistant Teacher (Mathematics and Statistics)
P.B.A. ENGLISH MEDIUM SCHOOL
06.2015 - 01.2016
Master of Science - Statistics
North Maharashtra University
08.2013 - 05.2015
Bachelor of Science - Statistics
KES’S PRATAP COLLEGE
08.2010 - 04.2013
Programming with Python : HandsOn Introduction for Beginners (Online through Udemy)
SQL For Beginners (Online through Udemy)
SQL for Newcomers – A Crash Course (Online through Udemy).
LinkedIn Badge for Microsoft Excel Skill Assessment
LinkedIn Badge for R Programming Skill Assessment
LinkedIn Badge for Python Skill Assessment
Similar Profiles
Prasanth LingisettiPrasanth Lingisetti
Power Bi Developer /Business Intelligence Analyst at Rockwell Automation India Pvt LtdPower Bi Developer /Business Intelligence Analyst at Rockwell Automation India Pvt Ltd
Shally VermaShally Verma
Business Development Leader – Cyber Professional Services, India at Rockwell Automation India Pvt. Ltd.Business Development Leader – Cyber Professional Services, India at Rockwell Automation India Pvt. Ltd.
Manish KumarManish Kumar
Project Administrator at Rockwell Automation India Pvt LtdProject Administrator at Rockwell Automation India Pvt Ltd