Data Analyst Power Bi

Sai Sreeja Bandaru

****************@*****.*** +1-636-***-****

Professional Summary

Experienced Data Analyst skilled in automating and optimizing reporting solutions to drive efficiency and data-driven decision-making across sectors like healthcare, telecommunications and research.

Reporting Automation: Transformed 200+ local Excel reports into MicroStrategy Dossiers, increasing user adoption by 30% in Field Operations.

Executive & Compliance Reporting: Led C-suite reporting and financial crime monitoring report migrations, automating data flows for budget vs. actual comparisons and compliance assessments.

HIPAA Compliance: Ensured all reports complied with HIPAA regulations, maintaining data privacy and security.

EDI Data Reporting: Integrated complex EDI transaction data (837, 835, 270/271, 276/277) into comprehensive reports for healthcare payors, enhancing trend analysis and performance tracking.

Data-Driven Insights: Spearheaded the development of a new reporting suite for field supervisors, resulting in a 15% increase in productivity.

Cross-Domain Expertise: Collaborated with stakeholders across Research and Development, telecommunications, and healthcare sectors to create custom reporting solutions that aligned with unique industry requirements.

Power BI & Data Modeling: Delivered Power BI solutions by designing custom templates, optimizing queries, and building star and snowflake schema models for improved data retrieval and performance.

Project Leadership: Managed end-to-end projects from initiation to completion, delivering solutions on-time with a 98% customer satisfaction rate.

Skills

Hard Skills: Product Roadmaps, User Stories, Storyboarding, Agile, Competitive Intelligence, Market Research

Soft Skills: Communication, Negotiation, Empathy, Leadership, Collaboration, Accountability

OLAP/BI Tools: GIT, Power BI (Advanced), MicroStrategy, Tableau, Data Modeling and Analysis, Power Query

Databases: SQL Server, Oracle, Redshift, Snowflake, Teradata, DB2

Languages: Phyton, R, Java, SQL

Other Tools: MS Office Suite, JIRA, GIT

Operating Tools: UNIX/Linux, Microsoft Windows

Charter Communications: Field Operations May 2022 – Present]

Job Role – BI Analyst II – Telecommunications Domain

Responsibilities:

Automated 200+ local Excel reports into MicroStrategy Dossiers, leading to a 30% increase in user adoption rate within Field Operations.

Orchestrated executive reporting for the C-suite, automating budgeting data from Essbase to MSTR for seamless budget-versus-actuals comparisons.

Collaborated with regional managers/business partners to research technician data, driving the development of a new reporting suit for field supervisors, resulting in a 15% increase in field productivity.

Led development efforts for ongoing enhancements, gathering user feedback, reducing user-reported issues by 25%, and increasing user adoption rate.

Created mock-ups/roadmaps and facilitated working sessions with developers, ensuring efficient development and alignment with business requirements.

Managed project details from initiation to completion, ensuring on-time delivery and a 98% customer satisfaction rate.

Spearheaded research to identify and ingest data for critical initiatives, expanding data sources by 10%.

Conducted user acceptance testing, achieving a 98% success rate in ensuring data accuracy and resolving data integrity issues within 48 hours.

Implemented a customer trouble call prediction model, leading to a 2% decrease in trouble call and truck roll rates.

Become a subject matter expert, emerging as the go-to analyst for addressing a wide range of data-related inquiries.

Dataflix: SRI (Stanford Research Institute) October 2019 – May 2022]

Job Role – Technical Analyst – Research and Development Domain

Responsibilities:

Collaborated closely with business stakeholders to gather reporting requirements, creating dashboards designs that aligned with SRI International's diverse research needs across multiple sectors, including biomedical R&D, quantum technologies, and national defense.

Designed Business requirements document for research initiatives in areas such as security, education, and ocean and space research.

Document end-to-end business processes by working directly with cross-functional teams, pinpointing bottlenecks, and actively identifying automation opportunities to streamline operations, saving both time and resources.

Created custom templates and reusable components to standardize the reporting processes across departments, increasing efficiency and consistency in data reporting.

Built and optimized data pipelines with Power Query to streamline ETL processes, integrating data from diverse sources such as SQL databases, Excel, and cloud applications, to ensure accurate and real-time data for various research projects.

Performed thorough unit testing to verify the functionality, data accuracy, and integration of reports within the Power BI environment, ensuring high-quality outputs that supported SRI International’s research and development efforts.

Delivered regular training sessions for end-users to navigate Power BI reports and dashboards effectively, empowering teams across security, education, and biomedical research to leverage data insights for decision-making.

Enhanced self-service BI capabilities across the organization, allowing various teams to independently analyze and visualize data without heavy reliance on IT resources.

InfoCepts: Vertex Pharma March 2018 – July 2019]

Job Role – Technical Analyst – Health Care Domain

Responsibilities:

Ensured compliance with HIPAA regulations, protecting sensitive data and ensuring that all reporting adhered to privacy standards.

I have developed comprehensive Excel reports that integrate complex EDI transaction data, including 837 (claims), 835 (payment remittances), 270/271 (eligibility), and 276/277 (claim status). These reports empower healthcare payers to effectively analyze trends, monitor performance, and gain actionable insights, enabling data-driven decision-making and improved operational efficiency.

Collaborated with stakeholders to verify data integrity for healthcare transactions and maintained seamless flows across claims, billing, and enrollment systems.

Take ownership of designing and delivering technical solutions that are not only innovative but also scalable and adaptable, ensuring they address complex business needs and align with both short-term and long-term goals.

Enhanced report performance by optimizing queries and refining data models, improving data retrieval speeds and overall user experience.

Troubleshot ETL job failures, and optimized query performance, ensuring reliable data processing and report delivery.

Monitored cluster health, performance metrics, and resource utilization, identifying bottlenecks and optimizing system performance.

Conducted root cause analysis for customer-reported data issues and suggested solutions to ensure continued data accuracy and report reliability.

Trained end-users on utilizing Power BI reports and dashboards efficiently, enabling non-technical healthcare staff to analyze claims and financial data independently, reducing their reliance on IT teams and speeding up decision-making processes.

Infosys: Bank of America February 2017 – February 2018]

Job Role – Business Analyst – Banking Domain

Responsibilities:

Led the migration of financial crime monitoring reports from Tableau to Power BI, ensuring a seamless transition and minimal disruption to compliance teams.

Developed a data migration and integration strategy to ensure data consistency and integrity between multiple financial crime compliance reporting systems.

Troubleshot report issues, ETL job failures, and optimized query performance to maintain data accuracy for financial crime risk assessments.

Designed and implemented star and snowflake schema data models to facilitate efficient data retrieval for AML, sanctions screening, and compliance risk reporting.

Utilized the Best Practice Analyzer to implement performance tuning strategies, improving data refresh rates and dashboard responsiveness for compliance monitoring.

Assist in prioritizing initiatives by analyzing key performance metrics and using data-driven insights to evaluate potential ROI, while working closely with stakeholders to align priorities based on team capacity and business goals.

Created KOM (Key Operating Metrics) document to generate insights on financial transactions, suspicious activity patterns, and fraud detection metrics.

Developed reports designs and trend analysis designs to highlight potential money laundering risks and compliance gaps.

Syntel: Hospital Corporation of America February 2015 – February 2017]

Job Role – Business Analyst – Healthcare Domain

Responsibilities:

Collaborated with healthcare payor teams, such as claim managers and compliance officers, to gather reporting requirements and create actionable dashboards Designs that help streamline claims processing, eligibility verification, and provider payments

Provided estimations for reports and dashboards and developed business requirement documents (BRDs) and functional requirement documents (FRDs) to align technical teams with business needs.

Assisted in defining key performance indicators (KPIs) such as claim approval rates, claim rejection reasons, payment timeliness, and outstanding claims, empowering healthcare payors to monitor the performance of their claims process effectively

Led discussions on data mapping and transformation to support healthcare claims, eligibility verification, and payment processing.

Conducted data validation and UAT testing for reports and dashboards to ensure that all reports created in Power BI comply with HIPAA regulations, specifically in terms of data encryption, and data privacy.

Used JIRA to track, analyze, and resolve defects raised by QA, ensuring efficient issue resolution and maintenance of system reliability.

I have experience implementing star and snowflake schema data models to structure healthcare payor data effectively. These models allow for quick retrieval of large datasets such as claim data, provider information, and payment histories

Assisted in resolving production issues, ensuring minimal downtime for critical reporting functions in claims, enrollment, and billing.

Support the development team by providing clear and actionable feedback throughout the delivery process, ensuring that requirements are continuously refined and adjusted to reflect the evolving needs of the business.

Contact this candidate