Ratan Sharma

Data Scientist | Data Analyst | Electronics Engineer
Chandigarh, IN.

About

Highly analytical and results-driven professional with a B.Tech in Electronics and Communication Engineering, specializing in data science, machine learning, and business intelligence. Proven ability to leverage Python, SQL, and Power BI for complex data analysis, predictive modeling, and developing automated solutions. Eager to apply strong technical skills and a passion for data-driven insights to solve challenging problems in a dynamic industry.

Work

IFFCO Tokio General Insurance Co. Ltd.
|

Data Analyst

Chandigarh, Punjab, India

Summary

Leveraged Python, SQL, and Power BI to analyze CRM/ERP datasets, develop automated pipelines, and deliver actionable insights for insurance operations.

Highlights

Optimized data integrity by extracting and meticulously cleaning complex CRM/ERP datasets using Python and SQL.

Developed and deployed interactive dashboards in Power BI and Excel, visualizing key performance indicators to provide actionable insights for stakeholders.

Engineered and deployed robust automated data pipelines on Azure cloud platform, enhancing data processing efficiency and scalability.

Conducted in-depth Exploratory Data Analysis (EDA) to identify critical business trends and patterns, ensuring compliance with COBIT frameworks.

Presented data-driven insights and recommendations to stakeholders, adhering strictly to ISO 27001 data security standards.

AlignEye Pvt. Ltd.
|

Electronics Product Developer

Chandigarh, Punjab, India

Summary

Contributed to product development by programming multi-phase vibration therapy modes, designing hardware, and optimizing device usage patterns as an Electronics Core Team Leader.

Highlights

Engineered and programmed multi-phase vibration therapy modes, significantly enhancing user benefit and product functionality.

Developed and implemented a double-tap align walk feature, improving device usability and user experience.

Designed and optimized two-layer PCB layouts, achieving efficient hardware performance and manufacturability.

Facilitated cross-functional collaboration to translate complex conceptual ideas into viable technical solutions and product features.

Conducted in-depth analysis of device usage data to identify patterns and optimize vibration therapy algorithms for improved efficacy.

Volunteer

Suvidha Foundation International NGO
|

Social Media Marketing Contributor

Chandigarh, Punjab, India

Summary

Contributed to enhancing the visibility and impact of Suvidha Foundation through strategic social media engagement.

Highlights

Leveraged social media platforms to enhance organizational visibility, engage with a broader audience, and amplify community impact.

IEEE Club
|

Head Member

Chandigarh, Punjab, India

Summary

Managed events and fostered member engagement for the IEEE Club.

Highlights

Successfully managed club events and initiatives, significantly enhancing member engagement and participation.

Education

UIET, Panjab University
Chandigarh, Punjab, India

B.Tech

Electronics and Communication Engineering

B.S.B.A Inter College
Siwan, Bihar, India

Intermediate

Higher Secondary Education

Grade: 79.8%

Vigyanand Kendriya Vidyalaya
Siwan, Bihar, India

High School Diploma

High School Examination

Grade: 73%

Certificates

Python for Data Science and Machine Learning Bootcamp

Issued By

Udemy

Technical and Analytical Skills Certification (SQL, Power BI, Advanced Excel, PowerPoint, Business Analysis)

Issued By

Various (Inferred from content)

Geoprocessing with Python Course

Issued By

ISRO

AI Appreciation Badge

Issued By

CBSE & Intel

Skills

Programming Languages

C, C++, Python, MySQL, SQL.

Data Science & Machine Learning

Pandas, NumPy, XGBoost, Scikit-learn, Matplotlib, Seaborn, Log Analysis, Pattern Recognition, Predictive Modeling, Feature Engineering, Model Evaluation, Preprocessing, Statistical Analysis, NLP, Computer Vision.

Cloud & Databases

Azure, Relational Databases, MySQL Server.

Business Intelligence & Tools

Power BI, MS Excel, PowerPoint, Business Analysis, Salesforce, Zoho CRM, SAP, Oracle NetSuite, Jupyter Notebook, Visual Studio Code.

Version Control & Compliance

Git, GitHub, COBIT, ISO 27001, Risk Management, Control, Compliance.

Electronics & Hardware

PCB Design, Hardware Performance, Product Development, Vibration Therapy Modes.

Geospatial Analysis

Remote Sensing, GIS, Earth Observation.

Interests

Sports

Cricket, Badminton.

Strategy Games

Chess (1000+ rating).

Projects

Amazon Sales Analysis (Power BI Dashboard)

Summary

Created interactive Power BI dashboards for comprehensive analysis of Amazon product and Prime sales data.

Pizza Sales Analysis (SQL & Excel Dashboard)

Summary

Analyzed pizza sales data using SQL and Excel, extracting key KPIs and visualizing sales trends to inform marketing strategies.

Black Friday Sales Prediction (Retail Analytics Project)

Summary

Developed a retail analytics solution to predict Black Friday sales using machine learning models and extensive data analysis.

Finance Data Analysis (Bank Stock Performance Study)

Summary

Analyzed stock performance of six major banks, identifying trends, volatility, and key performance indicators using Python.

Ratan Sharma