Ajay Swargam
Data Analyst
About
Data Analyst with 5+ years of experience in Power BI, Advanced Excel, reporting automation, and business analytics. Skilled in data transformation, KPI dashboard development, Power Query, and interactive reporting solutions. Experienced in converting raw business data into actionable insights through automated reporting frameworks, AI-assisted analytics workflows, and performance dashboards. Strong expertise in stakeholder reporting, operational analysis, and data-driven decision-making.
Skills & Expertise (24)
Work Experience
Data Specialist
Eb1A Experts
Feb 2025 - Present
Developed standardized and interactive reporting dashboards to improve reporting consistency, KPI visibility, and business performance tracking. Built automated Excel and Google Sheets tracking systems for daily, weekly, and monthly operational performance monitoring and reporting. Generated dashboard summaries, analytical reports, and performance insights for stakeholders to support data-driven decision-making. Leveraged ChatGPT and Claude AI workflows to automate evaluation processes, streamline reporting activities, and reduce manual review effort. Designed centralized performance tracking and risk monitoring dashboards to track project progress, operational metrics, and workflow efficiency. Integrated AI-assisted reporting techniques with Power BI, Excel automation, and business analytics workflows to enhance reporting accuracy and operational productivity. Collaborated with cross-functional stakeholders to gather reporting requirements and deliver analytical solutions.
MIS Executive & Analyst
PYRO Holdings Pvt Ltd
Feb 2023 - Jan 2025
Designed and developed interactive Power BI dashboards to monitor KPIs and business trends. Automated data extraction and transformation using Power Query, reducing manual effort. Built advanced Excel reporting templates and dynamic dashboards. Managed inventory reporting, reconciliation, and operational analytics. Supported business teams with data-driven insights and performance reports.
Associate
KFin Technologies Pvt Ltd
Aug 2021 - Jan 2023
Prepared DCR (Daily Control Reports) for analyzing pending transactions and operational activities. Collected data from Fund AMCs to prepare MIS reports and dashboards for regular business communication. Managed liquid and non-liquid transaction endorsements by verifying and processing investor KYC and FATCA details.
Education
MBA (Finance) - Osmania University
- · Afghanistan
Bachelor of Science (Computers) - Vikas Degree College, Satavahana University
- · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (24)
Click a skill to find developers with the same skill
