Power Bi Data Analysis

SWETHA BANDAPALLI

******.**********@*****.*** 1-401-***-**** WWW: www.linkedin.com/in/swetha-bandapalli-57304619b Profile Summary

• Performance driven professional experience in Data Analysis, Agile Methodologies, Business Analysis and Testing in across various domains Aerospace, Banking, Insurance and DMV sectors.

• Proficient in designing and creating various Data Visualization Dashboards, worksheets, and analytical reports to help users to identify critical KPIs and facilitate strategic planning in the organization utilizing BI tools like Power BI, Tableau, MS-Excel according to the end user requirement.

• Optimize report distribution, execution and the scalability of all reporting solutions so they are autonomous and dynamic

• Work with the Data Management team to provide input on logical and physical database design, data modeling and/or mapping

• Generate large and complex data extracts and queries for the Analytical Leads for data analysis by utilizing various database schema such as Microsoft SQL Server.

• Good experience in SQL, stored procedures and Hands on experience on Databricks.

• Strong familiarity and experience with the end-to-end pipeline of data analysis viz. data extraction, pre-processing, Data cleaning, mining, and visualization for deriving required results.

• Successful in interfacing with various Stakeholders such as SMEs, BAs, Developers, DBAs for decision making, identifying the critical problem areas, and delivering on customer commitments.

• Expert in identifying high-impact issues to help de-risk projects and improve the Application quality.

• Analytics findings and dashboard presentations to stakeholders to support data-driven decision making.

• Proficient in using Agile Scrum methodologies, performing role of Scrum Master, and conducting scrum ceremonies.

• Experience in developing and scheduling ETL workflows.

• Familiar with Python, R, Big data, Hadoop, ETL processes, Snowflake and Databricks

• Experience testing Web based/Client Server applications and Web Services, API testing with Manual testing in various domains

• Demonstrated expertise in creating and publishing dashboards within Power BI Service.

• Very strong in DAX, enabling advanced data manipulation and analysis.

• Implemented Security Features of Power BI like row level, object level and report level to make the data secure.

• Ability to lead teams working in cross-functional setting to drive execution of initiatives

• Driven teams, with focus on tracking and reporting product performance throughout its life cycle including product strategy, product planning and issue prioritization, defining product milestones.

• Collaborate with business partners to gather requirements on new Power BI projects and visualize the outcomes through reports.

• Assist in planning and managing changes to dashboards because of new or improved business processes.

• Passion to understand the unknown. A willingness and desire to embrace unfamiliar processes with an open-minded approach and a team player.

Experience

Peraton Cranston, USA

Data Analyst

01/2019 - Current

• Designed new tracking metrics for DMV appointment reservation system has lead to a 25% increase in effectively creating the appointment slots for the customers.

• Contributed to overall BI Strategy and quality of 30+ dashboards and BI insights.

• Developed and Designed the Plate Reissuance Dashboard to project DMV sales.

• Implemented row-level security on data along with an understanding of application security layer models in PowerBI.

• Working with Import and direct queries created custom table in PowerBI.

• Actively engaged in ongoing report development to meet evolving business requirements.

• Participated in monthly Business Intelligence meetings to discuss and implement best practices for service improvement.

• Utilized Agile methodology, responsible for daily scrum calls, sprint exit and entry meetings for efficient project management.

• Utilized JIRA for incident tracking and created Kanban boards to monitor Power BI work across all projects.

• Standardized report formats and optimized queries for 50 existing Power BI reports, utilizing both Import and DirectQuery modes.

• Create analyze and distribute ongoing reports as needed by key stakeholder by turning multiple data sets into valuable and interactive insights.

• Design and create innovation and valuable visualizations to identify patterns, rends and exceptions which enable the business executives and senior leaders to make data driven decisions.

• Incorporated DAX, SQL server and agile methodologies, optimizing data models and contributing to a 20% improvement in reporting quality.

• Collaborated with design engineering and other stakeholders to prioritize features, plan sprints, and deliver high-quality products on time and within budget.

• Directed cross-functional teams in defining and executing the product vision, strategy, and road map, ensuring alignment with company goals and market demand.

• Translated business problems and user needs into a set of detailed requirements for the solution that align to best practice methodology, with the appropriate use of epics, features, user stories and defined acceptance criteria. Peraton Cranston, RI

Sr.Systems Analyst/Project Scrum Master

09/2015 - 12/2018

• Facilitated communication among cross-functional teams such as development, QA, operations.

• Created reports to communicate progress of projects to stakeholders at all levels of the organization.

• Coached team members in Scrum methodologies to improve productivity.

• Participated in design reviews for new features or products prior to implementation.

• Collaborated with product owners to define product backlogs and prioritize stories for upcoming sprints.

• Established metrics to measure progress of development teams against objectives.

• Facilitated daily scrum meetings, sprint planning sessions, sprint retrospectives and release planning sessions.

• Tracked progress against timelines using agile tools such as JIRA, Octane

• Removed impediments and protected team members from interruptions and distractions to maximize productivity.

• Coached and mentored team members, stakeholders, and leadership on benefits of Agile and Scrum.

• Involved in writing user stories and acceptance criteria

• Performed UAT, Created End to End test plans, defect tracking process for successful project delivery.

GENRE Stamford, CT

Test Manager

07/2014 - 09/2015

• Actively collaborate with the larger testing community to share knowledge and drive efficiencies.

• Monitoring and managing test project plans across functions providing resource estimates and establishing tasks and schedules; prioritizing and delegating responsibilities to the team.

• Managed multiple concurrent projects while ensuring timely delivery of high-quality results.

• Organized training sessions for new team members on different types of software testing techniques.

• Developed test plans, strategies, and schedules for software testing projects.

• Maintained up-to-date knowledge of industry trends related to software testing processes.

• Worked with Agile and Scrum methodologies to accomplish project milestones and meet demanding timelines.

• Developed comprehensive reports on application performance metrics for senior management review.

Citizens Financial Group Cranston, USA

Sr. Systems Analyst

09/2011 - 07/2014

• Preparing various QA metrics and ownership for writing and testing user stories

• Pioneered analyzing & defining business requirements and Production releases for Home Equity Applications

• Co-ordinated, tracked, and reported on progress of E2E testing throughout project lifecycle, and proactively took corrective action as required.

• Provided guidance and mentorship to junior team members on technical matters.

• Created user manuals, training materials, reference documents and other technical documentation related to system operations.

• Executed business requirements analysis and user workflow analysis.

• Lead and coordinate Sprint Planning, Daily Scrums, Sprint Reviews, and Sprint Retrospectives, Sprint Backlog, Track Burn chart, Velocity, Retrospective charts etc.

• Involved in testing the REST APIs and handling integrations with clients. HCL Technologies USA

Lead Engineer

02/2005 - 01/2011

• Coordinated with the offshore team and track the Test Execution Status and Defects Status

• Conducted data driven Test with the Test Data sets and verified the contents using Quick Test Pro 9.2

• Configuration Manager for Microsoft Visual Source Safe. Skills

• MS SQL

• Octane/ALM/JIRA

• HTML

• PowerBI/Tableau

• Cloud Fundamentals

• SQL Server 2000

• R/Python Basics

• Service Now

• Cherwell Incident

• Agile

• Octane

• GitHub

• Databricks

• Swagger

• Business Analysis

• SDLC

• Communication

• Teamwork

• Adaptability

• Problem Solving

• Work Ethic

• Time Management

• Continuous Improvement

• Project Management

• Visualization Techniques

• Big Data Technologies

• Troubleshooting

• Snowflake

Education and Training

Boston University

Master of Science in Applied Data Analytics

JNTU, India

Bachelor of Technology in Computer Science and Information Technology Certifications

• Certified Scrum Master (Scrum Alliance)

• Generative AI (PMI)

• Databricks Lakehouse Fundamentals

Awards

• Defect Detector Extraordinaire Award from DMV for Leading and identifying critical issues.

• Paper Plate Awards from Perspecta for Outstanding Sprint work

• SKY DIVER Award from HCLA for Team Lead Role

Contact this candidate