Meet Jashanpreet K
Summary
Meticulous data analyst with 5 years of experience interpreting and analyzing data to drive business insights and implement action-oriented solutions across functions. Proficient knowledge of statistics, data mining, creating visualization and reports.
Education
- M.S. Business Analytics, Carl H. Lindner College of Business, University of Cincinnati, Cincinnati, USA
- GPA: 4.0/4.0
- Coursework: Optimization, Data Mining, Statistical Methods, Data Visualization, Data Wrangling, Simulation Methods
- Bachelor of Technology, Computer Science, Guru Nanak Dev University, Amritsar, India
- GPA: 8.90/10.00
- Coursework: Data Structures, Design and Analysis of Algorithms, Database Management Systems, Software Engineering, Operating Systems
Professional Background
I have 5 years of work experience working in the data domain as a DBA and Analyst. Following are the high-level list of my projects across my professional tenure:
IT Data Analyst, John Deere India Pvt Ltd, Pune, India
• Built real-time dashboards (budget trackers, operational metrics, CRM Campaign Metrics) for cross-functional multiple business functions using Tableau and SQL; dashboards were used for cross-functional periodic business reviews • Increased retention by 20% by revamping John Deere’s Customer Loyalty Program to incentivize harvest season sales by analyzing customer purchase data using Excel and Python • Saved 5K+ man-hours by developing an auto mailer system using SQL that reported unauthorized data access, leading to the first-ever zero audit compliance flag • Increased cross-selling rate by 9.6% against control group by building product recommender using Market Basket Analysis on merchandise data
Database Administrator, John Deere India Pvt Ltd, Pune, India
• Saved $250K annually as licensing cost by mitigating dependency over third party DM tools by developing an in-house tool using SAS, REXX, and JCLs with zero production defects • Led migration of gateway and federation servers from AIX to LINUX platform with zero user downtime • Saved 300 man-hours annually by identifying error-prone DB processes & implementing automation scripts using Python • Performed EDA: Data Integration, Outlier Analysis, Missing value treatment, correlation analysis as part of data preparation using R, Python, and Excel for cross-functional departments
Experience in R
I came across R in a university statistics course and loved what the language had to offer. I have done one project on Topic Modelling in R as part of a coursework assignment.
Experience with other Analytics software/s
I have worked on the following analytics/data science conducive software from the past 5 years -
- Programming : Python, JAVA, C , C++, REXX
- Data extraction : MS SQL, IBM DB2, Oracle
- Data analysis : MS Excel, SAS
- Data Visualization : Tableau, Power Bi
- Operating System : Windows, Linux, AIX
Leadership Experience
International Ambassador’20, Society of Women Engineers (SWE)
• Represented John Deere at the International Level – one among 89 global ambassadors from 19 countries • Conceptualized and Implemented Prajna – webinar series hosting global leaders from business and technology domains benefitting 1000+ mid-career women in STEM and was awarded Appreciation Badge by SWE CEO for the success of the series • Program managed local chapter of Wow, That’s Engineering – a global program to conduct STEM activities for underprivileged girls, and led factory operations workshop as part of the program
Global Domain Lead, Employee Engagement Initiatives
• Employee Experience Survey – Led Action Planning at Domain and Department level on dimensions such as Diversity, Inclusion, and Supervision. • Achieved Top Quartile Engagement Score in last Employee Survey with John Deere featuring among top 50 companies in Great Place to Work Survey.
• Rejuvenated Best Practice Repository (Gung- Ho Central) for smoother Knowledge Sharing and Introduced New Employee Onboarding module focusing on college to corporate transition