Arihant Jain
Noida
Summary
Results-oriented Data Specialist and BI Consultant with extensive expertise in Power BI, specializing in the creation of dynamic dashboards that monitor marketing KPIs, customer analytics, and overall business performance. Proficient in data modeling, SQL, and advanced visualization tools, driving the development of data-driven strategies that yield actionable insights. Proven track record of enhancing KPI tracking within the HCM sector, leading to improved decision-making and operational efficiency. Recognized for strong collaboration across departments, fostering productivity and adaptability to achieve successful project outcomes.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Integration Consultant II
UKG
04.2022 - Current
- Designed and optimized stored procedures to automate data export processes for various vendors. Ensured high data integrity and compliance with industry standards by implementing rigorous validation checks and data transformation rules.
- Designed and delivered multiple Power BI dashboards across performance, and business KPIs, streamlining reporting, reducing manual Excel work, and enabling leadership to make data-driven decisions with improved visibility into TTR, TTB, and overall team efficiency.
- Managed the import of large and complex datasets into the UKG system. Utilized advanced SQL techniques, such as bulk inserts, indexing, and data partitioning, to ensure smooth and consistent data integration. Implemented thorough data validation and error-handling processes to maintain data integrity, significantly reducing discrepancies.
- Collaborated with the automation team to create SQL standard templates, achieving a 95% reduction in build effort and significantly accelerating project timelines.
- Managed and executed multiple HCM integrations, including Demographic, Contribution, HSA/FSA, and COBRA, ensuring seamless data integration and compliance across systems.
Data Engineer
Kvantum By Yum (Yum! Brands)
11.2020 - 03.2022
- Directed the design and development of a robust reporting data module for the PH-UK marketing team, optimizing data visualization and reporting processes.
- Engineered advanced DAX measures to track and analyze critical business KPIs, enhancing data-driven decision-making.
- Crafted and executed complex SQL queries, including stored procedures and common table expressions (CTEs), and integrated Python scripts to augment Power BI reporting capabilities.
- Applied unsupervised machine learning algorithms to develop customer segmentation models, and utilized Python notebooks and SQL to construct and refine marketing mix models for precise targeting.
- Conducted sophisticated market basket analysis using PySpark and SQL, deriving actionable insights into customer purchasing patterns and improving cross-selling strategies.
- Developed and fine-tuned propensity-to-buy models with PySpark and SQL, enhancing predictive accuracy and supporting data-driven marketing and sales strategies.
- Achievements/Tasks
Data Analyst
Voylla Fashion Pvt Ltd
08.2018 - 10.2020
- Designed and developed comprehensive marketing dashboards using MS Power BI and PostgreSQL to track campaign performance, integrating key KPIs for real-time decision-making.
- Conducted customer segmentation using RFM (Recency, Frequency, Monetary) analysis, achieving a notable ROI of 3.5.
- Built an online business dashboard with MS Power BI and PostgreSQL to monitor online business performance against critical KPIs.
- Analyzed order flow and dropout rates throughout the order pipeline using Google Analytics, leading to a 5% reduction in address dropout rates and a 1% decrease in Return to Origin (RTO) through website verifications.
- Developed an algorithm for bid optimization, incorporating factors such as ROAS (Return on Ad Spend), Delta ROAS, and spend, which improved Facebook ad campaign efficiency and reduced manual effort.
- Conducted monthly target planning for various marketing channels, providing detailed daily, weekly, and monthly performance reports to guide strategy and improvements.
- Achievements/Tasks
Education
Bachelor of Science - Electronics and Communications Engineering
SKIT
Jaipur, India05.2018
Skills
- SQL data analysis
- Skilled in creating reports using MS Power BI
- Advanced Excel proficiency
- Domo data visualization
- Proficient in PostgreSQL
- DAX reporting skills
- Data Modeling
- Data Visualization
- Snowflake
- Pyspark
- Python
- Unsupervised Learning
- AWS
- Data modelling
- Data Analysis
- Customer Analytics
- KPI Tracking
- ETL
- Skill
Certification
Certifications
- Microsoft Certified: Data Analyst Associate (12/2021 – Present)
- HackerRank: SQL (Intermediate) (12/2021 – Present)
- Intermediate Python (University of Michigan, Coursera) (10/2018 – Present)
Awards
- Gold Award (01/2024): Developed a leadership dashboard to track CSAT and KPIs, improving performance monitoring and strategic decision-making.
- Silver Award (06/2023): Recognized for SQL optimization and managing complex integrations end-to-end.
- Silver & Bronze Awards (2024–2025): Built a unified Power BI dataset consolidating cross-team data (Analytics, Integration, DSC) to monitor resource-level targets and critical KPIs.
LANGUAGES
Hindi Full Professional Proficiency
English Full Professional Proficiency
Timeline
Integration Consultant II
UKG
04.2022 - Current
Data Engineer
Kvantum By Yum (Yum! Brands)
11.2020 - 03.2022
Data Analyst
Voylla Fashion Pvt Ltd
08.2018 - 10.2020
Bachelor of Science - Electronics and Communications Engineering
SKIT