Aarchie Jain
Dublin,Ireland
Summary
Detail-oriented data and operations professional with 3+ years of experience in SQL querying, data validation, reporting, and dashboard development. Skilled in cleaning and validating datasets, preparing operational reports, and supporting business teams with data-driven insights. Experienced in Tableau, Excel, Agile methodologies, and stakeholder collaboration.
Overview
6
6
years of professional experience
5
5
years of post-secondary education
1
1
Certification
Work history
Revenue Protection Analyst
PrepayPower
Dublin, Ireland
2025.03 - Current
- Used SQL queries to extract and analyze operational data to identify fraud patterns, discrepancies, and reporting issues.
- Performed data quality validations, data cleaning, and reconciliation checks, improving reporting accuracy by 20%.
- Created and maintained 4+ Tableau dashboards to monitor KPIs and operational performance metrics.
- Utilized SQL for data extraction and preparation to support dashboard reporting and weekly business reviews.
- Conducted detailed account and consumption analysis, including tariff and top-up validation, to identify discrepancies and support resolution activities.
- Validated charging data between internal systems and ESB/GNI meter records to ensure billing accuracy and compliance.
- Investigated root causes of data discrepancies and collaborated with internal teams, technicians, and third-party providers to resolve issues.
- Prepared weekly and monthly operational reports using SQL, Tableau, and Excel for internal business teams and management reviews.
- Monitored account performance and supported reporting activities related to repayment plans and escalated customer accounts.
- Coordinated with cross-functional teams to ensure customer queries and operational issues were resolved within SLA timelines.
Business Analyst
GNG IT Services Pvt Ltd
Delhi, India
2020.03 - 2022.07
- Collaborated with stakeholders to gather and document business requirements across projects.
- Used SQL and Excel for data analysis, reporting, and validation activities.
- Assisted development teams in improving reporting processes and system workflows, reducing manual effort by 15%.
- Conducted User Acceptance Testing (UAT) across multiple sprint cycles to validate business and reporting requirements.
- Managed project documentation and tracked 10+ project activities using Jira and Confluence.
Education
Master of Science in Business Analytics -
University of Galway, Ireland
2022.09 - 2023.06
Master of Business Administration -
Prestige Institute of Management
2017.08 - 2019.06
Bachelor of Business Administration -
ITM University
2014.08 - 2017.06
Skills
- SQL
- Tableau
- Microsoft Excel
- Data Validation & Data Cleaning
- Dashboard Reporting
- KPI Reporting
- Agile/Scrum
- Jira & Confluence
- UAT Testing
- Process Documentation
Certification
Scrum Fundamental Certified • Python certified from Udemy • Jira and Confluence Certified
Timeline
Revenue Protection Analyst
PrepayPower
2025.03 - Current
Master of Science in Business Analytics -
University of Galway, Ireland
2022.09 - 2023.06
Business Analyst
GNG IT Services Pvt Ltd
2020.03 - 2022.07
Master of Business Administration -
Prestige Institute of Management
2017.08 - 2019.06
Bachelor of Business Administration -
ITM University
2014.08 - 2017.06