Chirag

Certified Data Analyst from E&ICT IIT Kanpur proficient in R, Python, SQL, and Power BI with hands-on project experience in data analysis and strategic decision-making. Skilled in gathering business requirements, developing actionable insights, and collaborating with stakeholders to implement effective solutions. Committed to continuous learning and eager to apply analytical skills and business acumen to real-world challenges

Project on R Retail Store Opening Prediction Model :

• Developed predictive model for store openings based on sales, population, area, etc. Utilized decision trees and random forests for interpretability and complexity handling.
• Implemented in R using libraries like Recipe, dplyr, proc, and car.
• Provided insights to optimize store placement, enhancing operational efficiency and profitability in retail sector.

Project on R : Predictive Modeling for targeted marketing campaign- Portuguese Bank

• Developed a model in R ,using historical data to predict customer subscription to term deposits, optimizing campaign targeting.
• Achieved high predictive accuracy validated by a KS score, reducing irrelevant customer contacts and improving campaign efficiency.
• Enhanced decision-making by automating customer selection processes, addressing complaints of irrelevant marketing calls.

Project on Python: Predictive Modeling of Property Prices:

• Engineered a predictive model for property prices using R with the housing_train dataset.
• The model facilitated consistent pricing strategies and informed property development decisions, enhancing market competitiveness and buyer engagement for real estate firms.

SQL Project Database Setup & Management:

• Created 'Tenant' database with tables including Tenancy_histories, Profiles, Houses, Addresses, Referrals, and Employment_details.
• Ensured data integrity and relationships with foreign keys. Designed database diagram and managed data insertion and retrieval processes.

Power Bi Dashboard : Sales and Inventory Analysis for Multi-National Retail Company:

• Analyzed sales trends and inventory data using Power BI to inform strategic decisions for Roger Ferro, Country Head of a multi-national retail company.
• Provided insights on pricing, stock levels, and vendor performance to optimize sales strategies and ensure adequate inventory.
• Supported formulation of schemes to improve sales during low-profit periods and meet customer demands effectively.

Data Analytics certification E&ICT IIT Kanpur 2024

• Honda Cars India Ltd, Tapukara, 06/2015, Undergone training in Manufacturing Department for forty days. The Welding Processes used in the plant were studied.
• Escorts Agri Machinery, Faridabad, 05/2016, Undergone industrial training in the Component Plant for forty days. Studied workflow in the plant.

• SSC CGL Mains qualified 2022
• Haryana Civil Services Pre 2020 qualified

• Core team member of my college during Cultural and Technical Festival "MOMENTUM "
• Participated In 17th youth festival at Manglore Karnatka.
• Participated in the American Society For Quality HR (ASQ HR) Conclave on 'Creating talent' organised by ASQ-NCU Student Chapter.