Business Intelligence Data Analyst
Resume:
****.**********@*****.***
I am writing to convey my genuine interest in the Business Intelligence Manager. With two years of experience in data analytics utilizing Advanced MS Excel, Power BI, SQL, SQLite, and MySQL, I am confident in my capacity to contribute to your expanding organization. In my role as a Sr. Data Analyst, I have engaged with a diverse range of data sets, both large and small. I have a robust capability to derive significant insights from data and am skilled in effectively communicating my analyses to Managers, Assistant Directors, Directors, and Onshore personnel. What distinguishes me is my proficiency in conducting thorough research and my effective communication skills. My solid business acumen enables me to grasp the implications behind the data, allowing me to convey technical findings in an accessible manner.
I am dedicated to delivering high-quality data and have established numerous processes to ensure the accuracy of my results. In the field of analytics, the quality of outcomes is directly linked to the integrity of the underlying data, which is why I prioritize addressing inconsistencies at their source.
As a member of your team, I would utilize my extensive analytical experience to efficiently generate both regular and ad hoc reports for your operations team.
I have included my resume with this application for your review and am available for an interview at your earliest convenience. Thank you for considering my application. I look forward to your response. Sincerely,
Arun Sagar
Arun Sagar
Arun Sagar
Trivandrum, Kerala
****.**********@*****.***
Summary
Accomplished and results-focused professional with over 3 Years of experience in Analytics, consistently surpassing performance benchmarks. Possessing strong expertise in Data Analytics, Data Modeling, Business Intelligence, and Project Management, complemented by 7 Years in Medical Billing. I bring a unique blend of technical and business acumen, fueled by a passion for fostering success through innovation and teamwork. With outstanding communication and interpersonal abilities, I excel at cultivating relationships and influencing stakeholders across all levels. I am proactive, adaptable, and driven by goals, dedicated to ongoing learning and professional growth. I am now seeking a challenging position that utilizes my strengths and expertise to propel organizational success.
Skills
Business Intelligence, Team Management, Team Handling, ETL, Power BI, Data Visualization and Presentations, Data Modeling, Advanced Excel, KPI Tracking, Query Tools, SQL, SQLite, MySQL, Data Validation, Problem-solving aptitude, Microsoft PowerPoint, Medical Billing Application - Greenway, Zirmed
(Waystar), Raintree, AdvancedMD, Kareo, Practice Partner. Certificates
MS Office - LinkedIn Certificates, Power Query - LinkedIn Certificates, Power BI – LinkedIn Certificates, My SQL - LinkedIn and Udemy Certificates, SQLite - LinkedIn Certificates. Experience
GUIDEHOUSE
Senior Data Analyst, Business Intelligence • Trivandrum, Kerala 08/2019 - Present
Operational Team Manager Guidehouse: Managing a 650-member operational team in one of Guidehouse's largest departments.
Team and Performance Management: Managing headcount, KPIs, daily performance, attrition trends, invoicing, PMS-OPS, quality metrics, and allowance trackers for OPS, Quality, and Training teams.
Operational Metrics: Maintaining finance team lists, volume capacity trackers (FTE metrics), FTE projections, trends, weekly position control, staffing calculations, and the Early Warning System (EWS).
Reporting and Analysis: Developing SOPs, OPS project summaries, model output reports, downtime trackers, and transitioning reporting tasks from onshore to offshore operations.
Stakeholder Engagement: Managing resource allocation, providing updates, and ensuring timely solutions to meet business needs.
Data Insights: Analyzing data to uncover trends, improve decision-making, and create dashboards and reports for stakeholders.
Data Quality: Delivering accurate data, identifying quality issues, and implementing resolutions. Achievements -
Volume Capacity Tracker:
Objective - To oversee and manage workload capacity effectively. Procedure - Aggregate client-specific volume data over the past three months, normalize by operational working days to derive average daily workload, and compute FTE requirements by dividing daily volume by performance benchmarks. Advantages - Facilitates efficient resource allocation and ensures sufficient staffing to meet client needs. Benefits – Optimal Resource Allocation, Informed Decision-Making, Cost Efficiency, Improved Service Delivery, by 25%. Automated FTE Available vs. Required:
Objective - To assess the actual available FTE against the required FTE, Deficit/Excess FTE, Attrition Shrinkage, Equivalent FTE, this comprehensive approach ensures balanced staffing for both production and support teams, optimizing workforce management.
Data Sources – Client, Onshore, Stakeholder’s requirement for production staffs and live Headcount Tracker, Daily, Weekly, Monthly volume inflows.
Advantages - The advantage of the above approach is optimized workforce management. By accurately assessing the available and required FTE, factoring in deficit/excess, attrition shrinkage, and equivalent FTE. Benefits - Balanced Staffing, Proactive Resource Planning, Enhanced Cost Efficiency, Improved Workforce Utilization, by 45%
Headcount Dashboard:
Objective - Real-Time Monitoring, Headcount vs. Target Analysis, Attrition Tracking, Resource Allocation, Stakeholder Visibility.
Data Sources - HR Information System, Payroll System, Recruitment & Onboarding Systems, Attrition & Retention Reports.
Advantages - Headcount Dashboard enables real-time, data-driven decision-making, optimizing staffing levels, resource allocation, ad cost efficiency while improving forecasting and proactive workforce management. Benefits - Real-Time Visibility, Improved Resource Planning, Enhanced Decision-Making, Cost Optimization, Proactive Workforce Management, Increased Accountability, by 65%. ELI
Sr. Executive- Operations • Noida, Uttar Pradesh
Ensured that the Eligibility and Benefits were verified to avoid unnecessary claim denials. 05/2018 - 06/2019
Regular Review of Denial bucket was conducted, during which the details were amended or supplemented, and the claim was subsequently resubmitted.
Coding Correction, Client Updates, Tasks, and Immediate Corrections. Freelance
Appeal Specialist • Ghaziabad, Uttar Pradesh
05/2017 - 05/2018
Workers' Compensation (WC) - Verified that all documentation, medical records, and treatment plans pertaining to work-related injuries are thoroughly completed and precise. Comply with the established deadlines for the submission of claims and appeals. Closely worked with the adjuster to get regular updates and decisions. Personal Injury (PI) - Providing comprehensive medical evidence to support the claim, including physician statement and diagnostic reports.
Employee Pooling Resources
Team Leader • Uttam Nagar, New Delhi
04/2015 - 05/2016
Service Provided for PA-C and RNFA - guaranteed that they receive the essential support required to carry out clinical responsibilities, including billing, coding, and patient communications. Onshore Reporting - Ensured 100% service delivery and accountability to the reporting manager. RCM Services manages the RCM process, overseeing the entire billing process from the patient's registration forms, insurance verification, to submitting claims in a timely manner. Con-Calls - Regularly met with Onshore manager to share inputs and new updates, to maintain transparency and build trust.
MCK Info Link Pvt. Ltd.
Sr. A/R Specialist • Karkardooma, New Delhi
Ensured that the Eligibility and Benefits were verified to avoid unnecessary claim denials. 01/2014 - 04/2015
Regular review of rejections bucket, resubmitting claims after corrections. Evaluation of the Un-Billed/Not-Billed Claims to ensure that all outstanding claims receive prompt attention. Reevaluation and Resubmission of Claims (Paper Claims) & appeals in timely manner. Procare
A/R Specialist • Noida, Uttar Pradesh 04/2013 - 12/2013
Compliance to Californian working hours.
Demo Entry, Charge Entry, and Payment Posting, along with Claims Follow-up, Denials and Appeals of WC and PI claims.
Education
ICFAI
MBA • Trivandrum, Kerala
Operation Management
10/2021
NIIT
GNIIT • Ghaziabad, Uttar Pradesh
07/2015
Software Engineering (UG)
CBSE
Senior Secondary • Laxmi Nagar, New Delhi
05/2006
Uttar Pradesh Board
High School • Ghaziabad, Uttar Pradesh
05/2003
Contact this candidate