Balram Prajapati
@balramprajapati
I build SQL, Power BI, and ETL reporting solutions that turn operational data into actionable business insights.
What I'm looking for
I've delivered SQL-based reporting, ETL processes, and executive dashboards across BFSI, Telecom, Healthcare, and BPO for more than 13 years.
At Teleperformance, I developed and maintained SQL Server ETL and reporting solutions for Finance and Operations, supporting Paid Production Hours, productivity, SLA/TAT performance, operational KPIs, and financial metrics. I also supported cloud-based workflows using Azure Data Factory, Azure Databricks, PySpark, and Azure Data Lake Storage.
At Genpact, I designed 10–15 interactive Power BI and Excel dashboards for workforce analytics, quality monitoring, forecasting, and executive reporting. I managed the full dashboard lifecycle, from requirements and star-schema data modeling through DAX, deployment, refresh scheduling, and user support.
I've also automated reporting with Advanced Excel, VBA, Power Query, Microsoft Access, and SQL, helping teams improve reporting accuracy, visibility, and efficiency. I'm continuing to strengthen my cloud analytics, Microsoft Fabric, and enterprise data platform capabilities.
Experience
Work history, roles, and key accomplishments
Developed and maintained SQL Server ETL processes and reporting solutions for Finance and Operations teams. Collaborated with stakeholders to deliver reliable reporting and supported cloud-based ETL workflows.
• Designed and developed 10–15 interactive Power BI and Excel dashboards supporting
workforce analytics, operational performance, quality monitoring, SLA/TAT tracking,
forecasting, and executive reporting.
• Designed Star Schema data models, developed reusable DAX measures, and leveraged
Power Query for data extraction, transformation, cleansing, and integration.
Senior Analyst
SmartAnalyst Pvt Ltd
Feb 2021 - Feb 2022 (1 year)
• Developed Power BI dashboards and automated reporting solutions for clinical research
analytics, leveraging Advanced Excel, VBA, and Power Query to improve reporting
efficiency.
• Designed VBA automation tools, UserForms, and Microsoft Access solutions to streamline
data entry, reporting, and business processes.
• Supported SQL-based reporting and data analysis.
• Led MIS reporting and analytics for enterprise clients using Advanced Excel, SQL, and
reporting tools to support operational and business decision-making.
• Developed dashboards and analytical reports for SLA monitoring, performance tracking,
workforce productivity, and operational KPIs.
• Collaborated with business stakeholders to improve reporting processes.
Managed daily, weekly, monthly, and yearly MIS reporting, ensuring timely and accurate
business reporting for operations and management.
Performed volume forecasting, FTE planning, and business analysis to support resource
planning and operational decision-making.
Developed Advanced Excel reports and automation solutions, delivering analytical insights.
Education
Degrees, certifications, and relevant coursework
Indira Gandhi National Open University
Master of Commerce, Commerce
Pursued a Master of Commerce degree from Indira Gandhi National Open University, New Delhi, completing in 2017.
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Salary expectations
Social media
Skills
Interested in hiring Balram?
You can contact Balram and 90k+ other talented remote workers on Himalayas.
Message BalramGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
