Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Languages
Timeline
Generic

AISHWARYA WUPPUKONDURU

Austin,TX

Summary

Senior Business/Data Analyst with over 9 years of experience delivering enterprise-level business intelligence solutions using Tableau, Power BI, SQL, and Excel. Proven track record in translating business requirements into actionable insights and data visualizations, enabling strategic decision-making. Adept at stakeholder collaboration, data modeling, process improvement, and leading end-to-end analytics projects. Certified Tableau Server Admin with hands-on experience in data governance, SDLC, and cross-functional team leadership across banking, telecom, and public sector domains. I am a driven professional with a passion for harnessing the power of data to transform complex challenges into streamlined solutions.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Senior Business Data Analyst

Bank of America
06.2022 - Current
  • Developed and implemented a new data analysis tool that increased efficiency by 25% and reduced errors by 15%.
  • Collaborated with cross-functional teams to identify and implement process improvements, resulting in a 10% reduction in project delivery time.
  • Evaluate existing systems and workflows, identifying redundancies, manual inefficiencies, and areas for automation or optimization.
  • Automated data flow and reporting processes using APIs provided by SaaS platforms, reducing manual intervention by 40%.
  • Designed high-fidelity mockups and wireframes following UX best practices, enhancing user experience and interface design.
  • Conducted usability testing to gather feedback and iteratively improve designs.
  • Created Process flow use case and actively diagramming client allocations space for external connectivity for new legal entity.
  • Working with business analysts, interpreted business requirements that users looked to dashboards to answer, and created server-based Tableau dashboards with automatic updates.
  • Working with Share point Creating a series of events and workflows to assign tasks to user who can track and update the task.
  • Published Dashboards on Tableau Server and from there customers/stakeholders can access and choose the view.
  • Apply Configurational changes to the Tableau Server application as needed and Perform upgrades
  • Designed and developed complex Oracle SQL scripts to optimize performance and efficiency.
  • Conducted comprehensive data analysis and validation using SQL.
  • Acted as a system analyst for data analytics, performance management systems, and data warehousing projects.
  • Led business process re-engineering (BPR) initiatives for banking and public sector clients using Visio.
  • Utilized modeling and mapping tools like Visio and Erwin for technical diagramming.
  • Developed and delivered internal and external reports to stakeholders.
  • Tested Dashboards for data accuracy and functionality. Working with multi data connections.
  • Worked with SharePoint and O365 to support business operations.

Senior Business Data Analyst

Department of Motor Vehicles (DMV)
03.2019 - 05.2022
  • Performed complex data analysis using SQL on large datasets to identify trends and support business decisions in the financial domain.
  • Contributed to state-level IT project planning for the DMV by aligning analytics initiatives with government compliance and reporting mandates.
  • Designed and presented executive-level reports and data visualizations using Microsoft Excel and PowerPoint.
  • Collaborated with cross-functional teams to define KPIs and develop data models and dashboards.
  • Participated in strategic planning sessions and document deliverables for state agency priorities and preformance measures.
  • Documented business and technical requirements and facilitated meetings with stakeholders and technical teams.
  • Participated in UAT, defect triage, and backlog grooming sessions in Agile/Scrum frameworks.
  • Created Power BI Reports using the tabular SSAS models as sources data in Power Bi desktop and publish reports to Service.
  • Experience in combining data from different sources by using power query.
  • By using Power BI desktop connected to various data sources working with different visualizations.
  • Good understanding of business environment, excellent coll skills and ability to work proactively in a fast-paced environment.
  • Utilized DAX to create custom measures and calculated columns for complex data analysis
  • Recorded and documented all defects found using JIRA.
  • Used SQL Server Management Studio, SQL Integration Services and SQL Reporting Services in various phases of the project
  • Led data analysis initiatives to support strategic decision-making, utilizing advanced SQL queries to extract, transform, and analyze data.
  • Created and maintained detailed business process models and workflow diagrams using Microsoft Visio.
  • Developed performance dashboards and reports in Excel and Power BI, streamlining monthly reporting processes.
  • Collaborated with stakeholders to gather requirements and translate them into functional specifications.
  • Presented project updates and analytical findings to senior leadership using visually engaging PowerPoint presentations.
  • Managed change requests and supported testing efforts through all phases of the SDLC in Agile environments.

Business Analyst

Wells Fargo
07.2018 - 02.2019
  • Developed Business Objects according to client needs and requirements.
  • Understanding the business requirements through interacting with end users.
  • Good understanding of business environment, excellent communication skill and ability work in proactively in a fast-paced environment.
  • Additionally, conducted impact assessments to evaluate how proposed changes might affect existing systems and processes, ensuring alignment with organizational goals.
  • Implemented tools for process automation to reduce manual effort and improve accuracy in data management tasks.
  • I collaborated with enterprise architects and solution designers to align data architecture with overall business strategy and IT standards.
  • Kept close track of project tasks, breakthroughs, risks, actions, issues and dependencies in projects plans.
  • Evaluated, implemented, and customized SaaS (Software as a Service) platforms to align with business needs and improve operational efficiency.
  • Developing and maintaining power Bi dashboards: Created Compelling and interactive dashboards for various departments, improving data visibility and decision-making processes.
  • Defined business requirements and produced corresponding functional specifications for technical teams.
  • Performed data analysis to support validation of business requirements and prototyping of functional solutions.
  • By using Power BI desktop connected to various data sources working with different visualizations.
  • Perform work on time, within scope and with high customer satisfaction.

Business Analyst

Hewlett Packard
03.2017 - 05.2018
  • Working with a Business team and gathering proper requirements to Building Reports, as per end user requirement.
  • Blending data by using Alteryx.
  • Prepared Requirements Documents (BRD) for project which inculcated updating key details of securities into the universe of securities.
  • Having experience in identifying, analyzing and interpreting trends and patterns in complex data sets.
  • Used HP Jira to log any defects. Used HP Agile Manager to log any new user stories created.
  • Worked with Automation Testing team who used Selenium to automate the testing scripts.
  • Adhoc data cleaning and standardization using Alteryx.
  • Worked closely with QA team to identify test cases and testing plan.
  • Worked on UAT documents and helped supervise the UAT.

Business Analyst

Experian
08.2016 - 02.2017
  • Experience working on a huge project, which involved coordination with around 100 people. Worked very closely with 4 developers and 4 manual testers on a daily basis.
  • Worked with project management staff with closely to develop schedules. Participated in Change Control Board Meeting.
  • Currently working on Production Support and Warranty.
  • Gathered requirements from end users and helped communicate the requirements to the development and testing teams. Wrote high level design documents which were signed off by end-users
  • Developed test cases and executed test scenarios.
  • Worked with remote development/testing teams over phone meetings, conference calls.
  • Gathered minutes of meeting and helped meeting members be accountable for action items taken during the meetings.
  • Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and MS Excel.
  • Creating different reports from different data sources using SSRS.
  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
  • Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Business Analyst

EMC
11.2014 - 06.2016
  • Worked on a project to migrate the Data Domain (a company acquired by EMC) CRM systems into EMC CRM systems.
  • Worked on the reporting module which encompassed the contacts, install base, accounts, service requests/cases, knowledge base and product dimensions.
  • Worked as the primary business analyst in the EMC BRS project reporting team which is responsible for supporting the Business Intelligence activities like report creation and data analysis for the BRS project.
  • After requirement analysis, created a business use case to move data from Salesforce into the EMC global data warehouse to support report creation.
  • Tested the data from Salesforce before it is moved to the Data Warehouse.
  • Supported SaaS-based CRM systems like Salesforce with integration, configuration, and optimization.
  • Understood the reporting limitations of knowledge base articles in Salesforce and developed a business case to overcome this limitation in the data warehouse.
  • Supported the data architect in the development of the dimension models for the reports. Assisted him in understanding the business requirements so that the models can be created accurately.
  • Supported the Informatica resource to develop the mappings between the Salesforce source system and Oracle Data Warehouse. Tested the data in the extract, staging and the final data mart.
  • Worked with the business users to help them understand the data model and develop their reports using Tableau. Assisted in developing 16 workbooks and ~200 reports
  • Worked with the testing center of excellence to help them develop their testcases, end to end scenarios to perform the testing
  • Developed the playbook to identify the tasks necessary for go- live.
  • Used Data Loader, SFDC Developer Console to review the data in SFDC system

Education

Bachelor of Science - Computer Science

Andhra University
INDIA

Master - IT

University of Sydney
Sydney, Australia

Skills

  • SQL, Microsoft Excel, Microsoft PowerPoint, Microsoft Visio, Tableau, Power BI, Python, Oracle(DB), Salesforce, Azure, AWS, Snowflake, Data Warehousing, Data Modeling, Business Process Reengineering, SDLC, Agile, JIRA

Accomplishments

  • Designed and deployed over 100 interactive dashboards in Tableau and Power BI, leading to improved decision-making across departments.
  • Spearheaded a data migration project involving over million records, ensuring 99.9% accuracy and on-time delivery.
  • Applied critical thinking and root cause analysis to address recurring data discrepancies implemented long term solutions that improved data integrity by 20%.
  • Conducted in-depth analysis of customer data for a telecom client, uncovering actionable insights that increased retention by 15%.
  • Experienced in integrating Oracle databases with visualization tools, ensuring seamless data queries and reporting. Working with architects on data warehouse design or cloud migrations.
  • Led a cross-functional team implement an SDLC-aligned analytics solution for a banking client, reducing reporting time by 30%.
  • Developed a robust data governance framework as a Tableau Server Admin, enabling secure and streamlined access for over 500 users

Certification

  • Certified Tableau Server Associate
  • Certified Salesforce Administrator and Certified Salesforce Platform Developer 1

Languages

English
Professional Working

Timeline

Senior Business Data Analyst

Bank of America
06.2022 - Current

Senior Business Data Analyst

Department of Motor Vehicles (DMV)
03.2019 - 05.2022

Business Analyst

Wells Fargo
07.2018 - 02.2019

Business Analyst

Hewlett Packard
03.2017 - 05.2018

Business Analyst

Experian
08.2016 - 02.2017

Business Analyst

EMC
11.2014 - 06.2016

Bachelor of Science - Computer Science

Andhra University

Master - IT

University of Sydney

Similar Profiles

CREATE PROFILE
AISHWARYA WUPPUKONDURU