Data Analyst Power Bi

V NITILESHKUMAR

DATA ANALYST

Phone: 968-***-**** Email: ***********@*****.***

Linkedin: https://www.linkedin.com/in/v-nitilesh-kumar-540672193 PROFILE SUMMARY

Data Analyst with 2.5 years of experience in data analytics. Proficient in SQL, Power BI, and Excell with strong grasp of data science. I turn complex data into clear insights that drive decisions, streamline operations, and deliver impact. Known for solving problems fast and communicating results effectively. Always learning, always optimizing.

SKILLS

Analytics Tools: Power BI, MS Excel, SQL

Functional skill- SAP, MAKDOMS, ERP, Google Sheets,

Cloud Platforms: AWS CLOUD

Requirement Management Tools: MAKDOMS, ITRACE, KPI Tracking

Programming Languages: Python, SQL, LINUX, Pandas, Numpy, Matplotlib, Seaborn

Exploratory Data Analysis, Data Processing techniques, Regression, Classification, Statistical techniques, Data visualization, Communication, Analytical Thinking. Data storytelling WORK EXPERIENCE

COMPANY- MANE KANCOR PVT LTD. May 2023 -Present

POSITION: Data Analyst

Project: Production Performance and Efficiency Analytics in Spice Extraction Plant. 1.Data Collection & Integration (from SAP and Plant Logs) Collected daily production and consumption data from SAP and manual log sheets, including raw material charged, crude produced, solvent, steam, water, diesel, and wood consumption, plant downtime, and yield data. Extracted and organized data in Excel or Power BI for analysis. This represents the data gathering and preprocessing stage. 2.Input-Output and Efficiency Calculation Prepared Efficiency Reports comparing raw material input vs crude output, solvent recovery efficiency, and utility consumption. Calculated KPIs like extraction yield, solvent loss, crude output per kg RM. This involves data cleaning, transformation, and metric calculation. 3. Performance Monitoring & Trend Analysis Used Excel dashboards or Power BI for visual reports on yield trends, comparison across spice varieties, and utility consumption patterns. This is data visualization and business intelligence for decision-making.

4.Process Improvement Insights Based on data trends, provided insights to reduce solvent loss and improve yield. Helped identify causes for downtime or low yield using historical data — root cause analysis. 5. GMP and Compliance Reporting Maintained Good Manufacturing Practice (GMP) reports by validating daily data entries and ensuring data accuracy. Created standardized templates for clean data entry — data governance and reporting automation.

Project: Rosemary, alfa-alfa, spices sales & Business Performance Dashboard in manufacturing.

• Collected, cleaned, and analyzed production and sales data for Rosemary and Alfa-alfa product lines

(Ethiopian and European grades) to enhance data-driven decision-making.

• Designed and developed comprehensive Power BI dashboards displaying daily, monthly, and yearly production efficiency trends, sales revenue, and product performance metrics.

• Extracted and merged data from SAP and Excel sources using SQL for unified analysis across raw material usage, production cost, and total revenue metrics.

• Created sales and profitability reports showing total revenue by each product, total cost of production, and overall profit margins to support management insights.

• Analyzed total order volumes, identified highest and lowest selling products, and visualized sales trends for better inventory and demand planning.

• Prepared detailed input-output efficiency reports to calculate yield ratios, solvent losses, and production efficiency improvement areas.

• Implemented SQL-based data cleaning and transformation processes, ensuring high data accuracy and consistency across multiple systems.

• Automated daily and monthly reporting tasks using Power BI and Excel, improving reporting efficiency and accuracy by 35%.

• Utilized SAP for real-time monitoring of raw material consumption, yield, and utility usage (steam, water, diesel, wood) for operational optimization.

• Collaborated with cross-functional teams (finance, production, and quality) to provide insights on cost reduction, performance improvement, and strategic decision-making. • Conducted regular stock verification

(monthly, quarterly, yearly), reconciled discrepancies, and ensured compliance with GMP and audit standards. CERTIFICATIONS

• Data Analyst course excel, Power BI, SQL – Udemy

• AWS Solution Architect Course– Microdegree

• Data Modelling Course – Udemy

ACHIEVEMENTS/PROJECTS

Completed Projects on finding out revenue total orders, total sales, daily and monthly trends, and top Best selling pizza using MS-Excell, SQL, Power-BI

Designed and deployed an interactive Power BI dashboard to analyze vendor performance, inventory turnover, and profit margins using retail datasets; implemented Power Query (M) and DAX to build dynamic KPIs and visuals, uncovering $2.71M in unsold inventory and reducing insight delivery time by 40%.

Worked on project creating PowerBI Dashboards of total Employee, total salary, highest salary, employee ID, Active employee, Inactive Employee, Average salary.

Project Name : Supply chain optimization Analysis Tools Used : Excel, SQL, Power BI

Roles and Responsibilities: Built a reorder model based on historical demand. Suggested inventory policy changes that improved order fulfillment by 20%. Built dashboards for supply chain KPIs. EDUCATION

Masters In computer application from Kalsalingum Research and education in 2025 8.02 CGPA BE- Chemical engineering from MVJ COLLEGE OF ENGINEERING in 2020 7.99 CGPA

Contact this candidate