Rohit
7696373928 [email protected] www.linkedin.com/in/rohitkk18
Summary
Result-oriented Data Analyst with 3 years of experience in analyzing, interpreting, and visualizing complex data to drive strategic
business decisions. Proficient in SQL and Python to perform data analysis and deliver data-driven insights. Skilled in translating
business needs into technical solutions, performing advanced statistical analysis and applying techniques to solve real-world
problems.
Technical Skills
Languages and Databases: Python, Pandas, NumPy, SQL, MySQL
Visualization Tools: Power BI
Other Skills: Advanced Excel, Data Mapping, ETL, Business Analysis, Machine Learning, Big Data, Data Integration, Reporting
Automation
Experience
Infosys Ltd January 2022 – October 2024
System Engineer Chandigarh, India
• Performed data collection, cleansing, and organization of large datasets using Python, SQL, and Excel, ensuring accurate
and consistent data across multiple departments.
• Executed multiple data analysis projects leveraging Python (Pandas) and SQL to solve real-world business problems and
deliver data-driven insights.
• Created dynamic, interactive dashboards using Power BI to visualize KPIs, providing stakeholders with actionable insights
into business performance.
• Integrated data from multiple sources (SQL Server, Excel, etc.) into Power BI, facilitating comprehensive visualization and
trend analysis.
• Collaborated with cross-functional teams to develop and implement data-driven solutions, optimizing business
workflows and driving continuous process improvements within the organization.
• Contributed to data mapping for internal reporting systems and supported ETL/reporting tasks to streamline data
pipelines.
Personal Projects
Sale Insights - Brick & mortar business | Power BI | SQL
• Designed a Power BI dashboard to understand AtliQ hardware good sales trend.
• The final dashboard was effective at displaying the sales trend of AtliQ hardware, allowing users to understand the
data and make informed decisions.
• The dashboard could help in increasing the revenue at least 7% in the next quarter.
HR Analytics Dashboard | Power BI
• Developed an interactive Power BI dashboard to analyze and visualize employee attrition trends within the company.
• The dashboard provides actionable insights into attrition rates and identifies key factors contributing to employee
departures, enabling HR teams to make informed, data-driven decisions to reduce attrition.
Education
Guru Nanak Dev University Aug 2017 – May 2021
Bachelor of Technology in electronics and communication engineering Amritsar, Punjab