RAJAT JAIN
@rajat.jain
Data Analyst at McKinsey & Company
Gurugram, India
Rajat Jain is a Data Analyst with over 6 years of experience, specializing in transforming large datasets into actionable business insights. He possesses deep knowledge of cloud technologies, including Azure Databricks, Power BI, and Tableau, alongside excellent skills in SQL and Python. His experience includes solid contributions in data analysis, reporting, and visualization, complemented by proven leadership and people management capabilities.
Experience
Data Analyst
McKinsey & Company
Implemented end-to-end data pipelines on Azure Analytics platform using Azure Databricks, Pyspark, Python, Pandas, and NumPy. Developed reports and visualizations using Power BI for client performance and future simulations. Managed data storage in Azure Data Lake and performed data cleansing and quality checks to maintain data integrity.
IT Analyst
Tata Consultancy Services
Performed data extraction using SQL queries and stored procedures. Used Python libraries (Pandas, NumPy, etc.) for text mining and data analysis, improving performance by reducing memory consumption by 30%. Built Visual Analytics using Tableau and conducted market analysis, contributing to increased sales and decreased costs.
System Engineer
Tata Consultancy Services
Worked in Bayer Business Services GmbH as a Lead Test engineer.
Assistant System Engineer
Tata Consultancy Services
Worked as a support Engineer actively involved in developing, enhancing, and maintaining applications for CUNY-FAP and CAS.
Education
Hindustan College of Science & Technology
B.Tech
Electronics & Communication
John Milton School
Intermediate
C.B.S.E
St. Mary’s Convent School
High School
I.C.S.E