SQL/MySQL
MATIUR AHMED
Data Analyst/Data Analytics
Kamrup Metropolitan,India
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans.
Skilled in Data Analysis and Visualization, with tools like SQL/MySQL & Advance Excel and also pursuing new technologies like Python & Tableau Software.
Overview
6
6
years of professional experience
5
5
years of post-secondary education
4
4
Languages
Work History
Supply Chain Analyst
Star Cement Ltd
Guwahati, India
11.2017 - 02.2021
- Used analytical models and mathematical analysis to create and maintain key performance metrics.
- Created processes and methods to gather supply chain data
- Conducted detailed cost benefit analysis to improve profitability
- Forecasting warehouse inventory and replenishment planning (cycle and safety inventory planning)
- Planning dispatches through FOB/FOR and EXW arrangements based on sales requirements and optimize on-time final deliveries to ensure customer satisfaction with 85-95% accuracy band.
- Track KPIs and report on supply chain’s performance, improving efficiency of employees.
- Drove cost reduction efforts for supply chain AOP to meet annual operations targets.
- Analyzed weekly and monthly patterns to forecast business needs, reducing inventory costs 20%.
Data Analyst
Bharti Airtel Ltd
Guwahati, India
01.2016 - 10.2017
- Used statistical methods to analyze data and generate useful business reports.
- Documented effective and replicable methods for extracting data and organizing data sources.
- Participated in requirements meetings to understand business needs.
- Developed tables, views and materialized views using SQL.
- Extracted and interpreted data patterns to translate findings into actionable outcomes.
- M0-M3 visualization reports on Customer Retention, Revenue Growth, New Acquisition and Site
- Segmented Data Offers planning and implementing for NE Customers (1 million Base) based on Revenue, Recharge Product & Geo-Tag
- Competitor analysis on Product price points and Plans.
Data Analyst
Vodafone Spacetel Pvt Ltd
Guwahati, India
04.2015 - 12.2015
- Setup and share standardized analytics reports with SO and HO, highlighting focused areas
- Increased sales by 10% on Profitable Pack performance across regions with special focus on newly launched product segment
- Gathering Zone wise daily sales data and forecasting th sales geographically for Sales & Marketing Operations
- Preparing visualization reports and PPT's for Marketing review
Education
MBA - Information Technology
Bharati Vidyapeeth University
Pune 08.2012 - 06.2014
Bachelor of Science - Information Technology
Kumvempu University
Karnataka 03.2009 - 05.2012
Skills
Analytical and Critical Thinking
Software
Excel
Matrix ERP - Sales & Logistics Process
Tableau
Python
GST Laws & E-way Bill Implementation
Accomplishments
- Cost optimization on several Railway Rake Supply by completing on given time through proper coordination of delivery to customer site avoiding penalty of Rs 3150 per hour in Star Cement Ltd
- Analyzing & Implementing Segmented 121 Offer to a base of 1.2 million in NE Circle successfully with 98% error free uploads in Airtel Ltd.
Interests
Travel & Photography – Exploring the hidden offbeat place in NE and India, exploring and showcasing to like-minded people
Home Interiors & structure design
Gardening
Timeline
Supply Chain Analyst
Star Cement Ltd
11.2017 - 02.2021
Data Analyst
Bharti Airtel Ltd
01.2016 - 10.2017
Data Analyst
Vodafone Spacetel Pvt Ltd
04.2015 - 12.2015
MBA - Information Technology
Bharati Vidyapeeth University
08.2012 - 06.2014
Bachelor of Science - Information Technology
Kumvempu University
03.2009 - 05.2012
Similar Profiles
HIROK JYOTI BHUYANHIROK JYOTI BHUYAN
Officer Logistics at Star cement LtdOfficer Logistics at Star cement Ltd
Vabul KumarVabul Kumar
Senior Administration Officer at Star Cement Meghalaya Ltd.Senior Administration Officer at Star Cement Meghalaya Ltd.
Satyendra PrasadSatyendra Prasad
Manager - Branding at Star Cement Ltd.Manager - Branding at Star Cement Ltd.