Post Job Free

Resume

Sign in

Power Bi Data Analytics

Location:
Dallas, TX
Posted:
January 23, 2024

Contact this candidate

Resume:

Anala Peddireddy

Email: ad21sp@r.postjobfree.com /ad21sp@r.postjobfree.com Phone: +1-469-***-**** United States

An accomplished data analytics professional with 5+ years of experience, adept at transforming complex data into actionable insights that drive strategic decisions. My expertise in advanced analytics, data visualization, and process optimization enables me to empower organizations with data-driven solutions that lead to enhanced efficiency and growth!

EDUCATION

Master of Science – Business Analytics, The University of Texas at Dallas Aug 2022- May 2024 Bachelor of Technology – Electronics and Instrumentation, Jawaharlal Nehru Technological University Jun 2012- May 2016

SKILLS

Python,R, SAS studio Microsoft SQL Server, MySQL, MongoDB,Tableau, Power BI (DAX, Power Query), Quicksight, Looker, Alteryx, Pivot Tables, Macros, Advanced Functions,VBA,Snowflake, AWS, Azure,DAX Studio,Power Apps, Power Automate

,JIRA, SDLC, Scrum, Power BI Desktop, Power BI Service, Data Modeling, DAX (Data Analysis Expressions), Power Query, Data Integration, Row-Level Security, Power BI Apps, Power BI REST APIs, Advanced Analytics, Power BI Embedding, Power BI Paginated Reports, Power BI Report Server, Power Automate Integration, Cross-Report Drillthrough, Azure Integration, Composite Models, Power BI XMLA Endpoints, Custom Visuals, Version Control, Data Lineage Analysis, Power BI Theming, Power BI Branding, Streaming Datasets, Natural Language Queries, Incremental Data Refresh, Power BI Apps for Teams, Data Visualization, Data Transformation, ETL (Extract, Transform, Load), KPI (Key Performance Indicator), BI (Business Intelligence), SQL (Structured Query Language), RDBMS (Relational Database Management System), Data Warehouse, Dimensional Modeling, Cloud Technologies, Data Mining, Data Quality, Data Governance, UI/UX Design Principles, Performance Tuning, Report Subscription, Data Profiling, Microsoft Azure, Business Requirements, Stakeholder Collaboration, Dashboard Development, User Acceptance Testing, Report Optimization

CERTIFICATION

Google Data Analytics,Alteryx Designer Core, SQL

WORK EXPERIENCE

Data Analyst, SHC Technologies, United States May 2019 – Aug 2022 Roles and Responsibilities as a Power BI Developer

• Developed a patient churn model that improved patient churn by 50%, optimizing services and identifying gaps

• Conducted competitor analysis, resulting in a 20% increase in medical tests and a 50% rise in website application traffic

• Built CMS compliance Power BI reports to prevent patient churn and aid hospitals in migration towards compliance

• Developed Tableau dashboards monitoring medical test prices and patient ratings for affordable medical care selection based on geography

• Created hospital readmission dashboards leading to a significant 20% reduction in readmission rates, empowering healthcare teams

• Designed, developed, and implemented interactive Power BI reports and dashboards to visualize and analyze complex data sets, meeting diverse business requirements.

• Integrated data from various sources into Power BI, ensuring comprehensive reporting capabilities and implementing advanced features like DAX calculations and custom visuals.

• Conducted thorough analysis of business requirements, translated them into actionable insights, and developed Power BI solutions to facilitate data-driven decision-making across multiple industries.

• Utilized Power BI Service for publishing, sharing, and collaborating on reports and dashboards, ensuring effective communication and user engagement.

• Implemented row-level security in Power BI to control data access based on user roles, maintaining data confidentiality and integrity.

• Conducted training sessions to educate end-users on Power BI functionalities, promoting effective and widespread utilization of the platform.

• Automated report generation and distribution using Power BI subscriptions and workflows, enhancing efficiency in report delivery.

• Collaborated with data architects to design data warehouse solutions aligned with Power BI reporting needs, ensuring seamless integration and promoting 20% efficiency.

• Utilized Power BI Apps to package and distribute solutions, promoting consistency across different environments, resulting in a 15% improvement in deployment efficiency.

• Conducted performance tuning on Power BI reports, optimizing queries and data refresh schedules for improved responsiveness, achieving a 25% improvement in report performance.

• Implemented Power BI report theming and branding to align with organizational visual standards, enhancing the overall user experience by 20%.Conducted data lineage analysis in Power BI, tracing the source and transformations of data for documentation and compliance, contributing to a 15% improvement in data documentation.

• Integrated Power BI with external authentication providers for enhanced security and user management, ensuring a 20% improvement in user authentication processes.

• Utilized Power BI DirectQuery mode for connecting to large-scale datasets without importing, ensuring real-time data access and achieving a 30% improvement in data retrieval speed.

• Conducted root cause analysis for data discrepancies in Power BI reports, ensuring data accuracy and reliability, resulting in a 25% improvement in data accuracy.

• Implemented composite models in Power BI for combining DirectQuery and Import data sources, providing flexibility in data analysis and achieving 20% efficiency in data source integration.

• Managed data governance activities to ensure consistent data presentation across all business units of the organization, contributing to a 15% improvement in data governance standards.

• Developed tabular, multidimensional models compatible with warehouse standards and developed self-service models using Power BI service, achieving a 20% improvement in data modeling efficiency.

• Developed, published, and scheduled reports and dashboards to meet business requirements, ensuring timely and accurate insights.

• Assisted business users with functional and data requirements to enhance data models and improve reporting solutions.

• Built Data Analytics enterprise models using Microsoft’s Power BI, demonstrating proficiency in creating efficient reporting solutions.

• Knowledge in Microsoft enterprise cloud technologies such as Dynamics 365 CRM, Office 365, and Microsoft Azure.

• Strong experience in SQL and RDBMS technologies, with a background in manufacturing data warehouse design.

• Conducted full-stack MS Power BI modeling, including M code, DAX, data storytelling, report publishing, and security implementation.Experienced in extracting business requirements and data in data warehouse design and data mining.

• Significant hands-on experience in creating and deploying KPI, analytic, and dashboard solutions. Data Analyst, Bank-Al-Etihad, Jordan Jun 2017– April 2019 Roles and Responsibilities as a Power BI Developer

• Spearheaded comprehensive loan metric analysis, informing senior management decisions by evaluating distribution, overdue amounts, and size. Demonstrated technical leadership skills, organizational skills, and attention to detail.

• Produced trend analyses and SLA reports, optimizing efficiency and elevating service quality, boosting customer satisfaction

• Led cohort analyses, identifying avenues for process enhancement, resource allocation, and cost-saving across departments

• Employed data analytics to segment customers by behavior, yielding a 25% customer engagement surge through a tailored dashboard. Excellent analytical thinking for translating data into informative visuals and reports.

• Developed loan portfolio tracking dashboard, proactively reducing high-risk loans by 10%, enhancing portfolio performance

• Utilized Power BI REST APIs for programmatic access to Power BI functionality, enabling automation and integration with other systems.

• Created visually appealing and insightful reports and dashboards using Power BI, presenting data in a clear and understandable manner.

• Developed, tested, and deployed interactive reports and dashboards to meet user needs, focusing on user-friendly design and functionality.

• Conducted deep dive analyses of billing, denial, volume, revenue, etc. trends and identified root causes using Power BI.

• Documented data models, report specifications, and other relevant information for reference and future development, ensuring knowledge retention.

• Provided support for end-users to ensure effective use of Power BI solutions, addressing queries and resolving issues promptly.

• Integrated Power BI with Microsoft Teams for improved collaboration and communication, enhancing teamwork and information sharing.

• Implemented cross-report drillthrough in Power BI for seamless navigation between related reports, improving user experience.

• Conducted load testing for Power BI reports to ensure optimal performance under varying user loads, addressing scalability concerns.

• Developed custom visuals in Power BI using R and Python scripts, expanding visualization options and meeting specific business requirements.

• Conducted version control for Power BI reports and datasets using Azure DevOps, ensuring consistency and traceability in development.

• Implemented natural language queries in Power BI for enhanced user interaction, making data exploration more intuitive.

• Designed and implemented real-time dashboards using Power BI Streaming Datasets, providing up-to-the-minute insights, contributing to dynamic reporting by improving 15% efficiency.

• Conducted data profiling and analysis using Power BI to identify data quality issues, contributing to data cleansing and improvement efforts, resulting in a 20% enhancement in data accuracy.

• Integrated Power BI with Azure Synapse Analytics for advanced analytics capabilities, leveraging cloud services for enhanced functionality, achieving a 25% improvement in analytical capabilities.

• Implemented Power BI anomaly detection features to identify irregular patterns in data, enhancing the ability to detect outliers, resulting in a 30% improvement in anomaly detection accuracy.

• Developed Power BI data gateways to enable secure data refresh from on-premises data sources, ensuring data security and accessibility, contributing to a 15% improvement in data refresh efficiency.

• Created and managed report and dashboard subscriptions within Power BI, automating report delivery to relevant stakeholders.

• Utilized Power BI XMLA endpoints for programmatic access to Power BI datasets, enabling more advanced data manipulation.

• Conducted comprehensive documentation of data models, algorithms, metrics, measures, and refresh schedules for clarity and shareability.

• Collaborated with business stakeholders to understand their reporting requirements and translated them into effective Power BI solutions.

• Continuously optimized and improved existing Power BI reports and dashboards for better performance and user experience.

• Conducted detailed analysis on tested and deployed Power BI scripts, providing thorough data documentation for algorithms, parameters, and models.

• Performed essential technical and strategic changes to improvise present business intelligence systems and developed custom charts accordingly.

• Developed, tested, and deployed interactive reports and dashboards to meet user needs, ensuring alignment with business objectives and achieving a 20% improvement in user satisfaction.

• Proficiently utilized Power BI, SQL, and data modeling to create efficient and effective reporting solutions, resulting in a 15% improvement in reporting efficiency.

• Applied statistical methods and data visualization tools to interpret complex datasets, enabling informed decision-making for strategic business initiatives, contributing to a 25% improvement in data-driven decision-making.

• Demonstrated expertise in extracting meaningful information from extensive data sets, contributing to data-driven decision-making processes, achieving a 20% improvement in information extraction efficiency.

• Conducted in-depth analysis of business requirements to understand data needs and developed interactive and visually appealing Power BI reports, resulting in a 20% improvement in report quality.

• Integrated data from various sources into Power BI for comprehensive reporting and implemented advanced features such as DAX calculations and custom visuals, achieving a 15% improvement in report sophistication.

• Designed, mapped, and built multi-dimensional data models to transform raw data, utilizing Power BI to create interactive and visually appealing dashboards and reports, contributing to a 25% improvement in data modeling efficiency.

• Monitored and optimized the performance of Power BI reports and dashboards, turning data into meaningful insights and developing key performance indicators.

• Analyzed and transformed previous and present data for better decision-making according to business requirements.

• Conducted detailed analysis on tested and deployed Power BI scripts, creating strong data documentation about algorithms, parameters, and models.

• Conducted root cause analysis for data discrepancies in Power BI reports, ensuring data accuracy and reliability.

• Collaborated with SQL and Data Management teams to source new data, develop new tables and views, and augment existing Power BI data models.

• Documented data models, algorithms, metrics, measures, formulas, refresh schedules, etc., comprehensively for clear and shareable reference.

• Routinely tested data for accuracy, ensuring reporting integrity, and researched and corrected data irregularities and issues as necessary.

Data Analyst, Tech.Mahindra, United States May 2016 – Jun 2017 Roles and Responsibilities as a Power BI Developer

• Conducted market research and brand surveys, resulting in a 25% improvement in brand consideration among potential customers

• Strengthened brand credibility through consistent messaging and marketing efforts, leading to a 50% increase in brand perception

• Reduced average queue time of incoming phone calls by 40%, minimizing customer wait time and enhancing service level agreements (SLAs)

• Implemented cost-saving measures, leading to a 15% decrease in the cost per minute of handle time, optimizing call center operations

• Stayed current and knowledgeable on all Power BI updates and release notes to take advantage of new features and capabilities.

• Created and managed report and dashboard subscriptions within Power BI, automating the distribution of relevant reports.

• Worked within the team to perform deep-dive ad hoc analyses of billing, denial, volume, revenue, etc., trends, and issue root causes on an ad hoc basis.

• Managed data governance activities to ensure consistent data presentation across all business units of the organization.

• Developed tabular, multidimensional models compatible with warehouse standards, enabling effective data analysis.

• Developed self-service models and data analytics using Power BI service, empowering users to derive insights independently.

• Assisted business users with functional and data requirements to enhance data models and improve reporting solutions.

• Crafted and executed ad-hoc database queries and conducted analyses upon request for business insights.

• Collaborated with teams to integrate systems and actively engaged in business stakeholder requirements gathering sessions.

• Established metrics to measure business performance and recommended strategies to address performance gaps.

• Completed full stack MS Power BI modeling, including M code, DAX, data storytelling, report publishing, and security implementation.

• Conducted user acceptance testing for Power BI reports to ensure alignment with business requirements.

• Managed data governance activities to ensure consistent data presentation across all business units of the organization.

• Developed tabular, multidimensional models compatible with warehouse standards and developed self-service models using Power BI service.

• Experienced with Microsoft Azure platform and services (Power BI, Flow, Cortana, etc.) and strong understanding of data analytics application security.

• Experienced in requirement analysis, design, and prototyping along with data gateway, data integration, and self-service data preparation.

• Strong knowledge of SQL, ETL, SSIS, SSRS, and SSAS reporting, with hands-on experience in extracting business requirements.

• Performed SLC procedures to gather requirements, design, develop, test, document, and maintain business intelligence solutions.

• Presented information through reports and visualization with good communication skills for training purposes.

• Collaborated with SQL and Data Management teams to source new data and develop new tables and views.

• Augmented, refined, and created Power BI data models for actionable analytics and insights.

• Refined and standardized existing architecture, data models, and measures to mimic Power BI community best practices.

• Comprehensively documented data models, algorithms, metrics, measures, formulas, refresh schedules, etc., for clear reference.

• Routinely tested data for accuracy, researched and corrected data irregularities and issues as necessary.

• Stayed updated on all Power BI latest features and release notes to take advantage of new capabilities.

• Developed and managed report and dashboard subscriptions within Power BI, ensuring timely and automated distribution.

• Worked within the team to perform deep-dive analyses of billing, denial, volume, revenue, etc., trends and issue root causes.

• Managed data governance activities to ensure consistent data presentation across all business units of the organization.

• Developed cutting-edge business intelligence solutions and analyzed data sets to generate insights.

• Experienced in data analytics, data visualization, and data mining.

• Possessed exceptional communication and problem-solving skills, collaborating with a wide range of stakeholders.

• Developed and maintained Power BI dashboards, reports, and metrics for data-driven decision-making.

• Designed, developed, and deployed reports and dashboards to meet stakeholder needs, ensuring accuracy and effectiveness.

Eligibility: Eligible to work as early as possible



Contact this candidate