
Senior Analyst with 7+ years in Business Intelligence & Data Modeling
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Data Analyst with 5+ years of experience in collecting, cleaning, and analyzing large datasets to deliver actionable business insights. Skilled in building interactive Power BI dashboards, writing complex SQL queries, and leveraging Advanced Excel for data transformation and reporting. Experienced in designing ETL workflows, tracking KPIs, and presenting data-driven recommendations to senior leadership and cross-functional stakeholders. Strong foundation in statistical analysis, data modeling, and business intelligence.
RBS College, Agra
B.Tech · Mechanical Engineering
August 1, 2012 – June 30, 2016
Telus Digital
Data Analyst
September 1, 2024 – June 1, 2025
India
Iris Software
Senior Executive
April 1, 2023 – July 1, 2024
India
Infogain India
Senior Executive
April 1, 2022 – February 1, 2023
India
Infogain India (Payroll - Pacific IT Consulting)
Senior Consultant
November 1, 2020 – April 1, 2022
India
Altum Staffing and Marketing Solutions
Sr. Technical Recruiter
November 1, 2016 – January 1, 2020
India
Customer Service Department Dashboard
June 30, 2026 – Present
Problem: Customer service team needed centralized KPI tracking across multiple performance dimensions. Approach: Connected data through MySQL Server. Created calculated fields and DAX expressions. Developed dashboards for TAT, CSAT, Agent Login, Complaints, Retention, and Pendency tracking. Impact: Published reports to Power BI Service with role-based access for real-time performance monitoring.
Smart Gate Management Dashboard
June 30, 2026 – Present
Problem: Organization needed automated tracking of employee attendance and floor presence. Approach: Built a dashboard using turnstile data to display In Time, OutTime, Break Time, Production Time, and total employees on the floor. Impact: Replaced manual attendance tracking with real-time automated visual reporting.
Retail Sales Optimization Analysis
June 30, 2026 – Present
Problem: Client lacked a clear understanding of their customer base, hindering targeted marketing and effective sales strategies. Approach: Extracted and cleaned sales data using SQL. Used Excel pivot tables for initial exploration. Loaded data into Power BI, established table relationships, and created DAX measures. Segmented customers using RFM analysis and K-means clustering. Impact: Delivered interactive dashboards with actionable recommendations for targeted marketing campaigns, product placement, and cross-selling opportunities.
Talent Acquisition Dashboard
June 30, 2026 – Present
Problem: Hiring leadership lacked centralized visibility into recruitment pipeline health and recruiter performance across departments. Approach: Built an end-to-end Power BI dashboard integrating data from ATS and Excel trackers via Power Query. Created DAX measures for application-to-hire ratio, time-to-fill, source ROI, and diversity metrics with drill-through pages for hiring manager KPIs. Impact: Replaced weekly manual reporting with real-time automated dashboards, enabling faster decision-making on sourcing budget allocation.
Employee Attrition Analytics
June 30, 2026 – Present
Problem: Organization faced high employee turnover with no data-driven understanding of root causes. Approach: Performed EDA on employee records using Python. Analyzed attrition patterns by department, tenure, salary band, and performance rating. Built Power BI dashboard with dynamic filters. Impact: Identified key attrition drivers, enabling HR to design targeted retention strategies.
Cultural Fit Analysis
The candidate's project diversity, spanning retail sales, talent acquisition, employee attrition, customer service, and smart gate management, indicates adaptability and a broad interest in applying data analytics across various business domains. Their experience in multiple companies (Telus Digital, Iris Software, Infogain India) and roles suggests an ability to integrate into different organizational cultures. The focus on delivering actionable recommendations and improving operational efficiency aligns with a results-oriented culture. However, the primary focus on HR/recruitment analytics in recent roles might require a slight adjustment for a broader 'Senior Analyst' role if it's not HR-centric.
Soft Skills & Operational Fit
The candidate demonstrates strong problem-solving skills, evidenced by their project descriptions where they identify business problems and propose data-driven solutions. Their experience in leading a 5-member team and partnering with cross-functional teams suggests good collaboration and leadership potential. The automation of reports and ETL workflows indicates an operational mindset focused on efficiency and process improvement. The candidate's ability to monitor attrition trends and forecast hiring needs also points to a proactive and analytical approach to operational challenges.