Data Analyst Quality

Anagha Deo

email:anagha *@*****.*** mobile:425-***-****

Professional Summary

Seasoned Business/Data Analyst with 10+ years of experience delivering data-driven insights and solutions across banking, financial services, and technology domains. Skilled in SQL de- velopment, ETL, Power BI, Hadoop/Hive, and data governance. Adept at gathering and translating business requirements into actionable technical solutions, designing and automating data validations, and driving data quality improvements. Proficient in Microsoft Office (Excel Pivot Tables, Word, Visio, PowerPoint), with working knowledge of Python and PowerShell. Demonstrates strong communication and leadership skills, having led cross-functional teams and mentored junior staff. Passionate about aligning data analysis with strategic goals to optimize decision-making and business outcomes.

Core Skills & Tools

• Data Analysis & Reporting: Power BI, SQL(T-SQL), Excel(Pivot Tables), SSRS, SAS

• Big Data & ETL: Hadoop/Hive, Informatica, SSIS, SAP ECC & SAP HANA data sources

• Database & Scripting: SQL Server, Oracle, DB2, Unix Shell Scripting, Python, PowerShell

• Data Quality & Governance: Data Validation & Profiling, Data Lake Migrations

• Methodologies: SDLC, Agile/Scrum, JIRA, Confluence

• Business Analysis: BRD/FRD creation, gap analysis, stakeholder management, UAT Plans

• Other Tools/Platforms: SharePoint, SAS, Toad, Visio, AIX, Windows (10/8/7) Professional Experience

Sr. Data/Business Analyst Wells Fargo (Innova), Hybrid Jan 2023 – Dec 2024

• Develop and lead advanced data quality, governance, and metadata initiatives to ensure strict com- pliance with corporate standards, BSA/AMK, and Y-14 regulatory requirements.

• Design and conduct complex analyses to identify and remediate high-severity data quality/integrity issues and control gaps—meeting rigorous audit expectations and documenting root causes, remedi- ation steps, and evidence.

1

• Define data quality metrics, execute comprehensive audits, and create remediation plans—maintaining highly secure documentation of defect impacts and corrective actions for internal governance, regu- latory, and audit reviews.

• Collaborate with cross-functional, U.S.-based teams and dedicated sub-domain Working Groups (10 in total) to address emerging defects in real time, ensuring synchronous communication and rapid escalation for critical business data.

• Serve as a central point of contact for project planning, coordination, and onshore defect remediation efforts, leveraging domain expertise to meet stringent timelines and mitigate risk associated with sensitive/confidential data.

• Provide domain expertise on data governance, security protocols, and best practices for storing and sharing customer data during defect management—upholding compliance and ensuring readiness for regulatory inspections.

• Ensure best practices in governance documentation, advanced data validation, and effective stake- holder engagement at executive levels, ensuring consistent, high-quality deliverables across the enter- prise.

Key Achievements:

- Identified and resolved critical data quality issues, successfully closing 45% of the overall defects in CSBBL in home-lending sub-domain while adhering to enterprise-wide defect documentation standards.

- Streamlined and accelerated remediation processes for business-critical defects, facilitating timely approvals and signoffs from senior leadership and regulatory stakeholders. Data/Business Analyst Oracle Cloud Infrastructure (Collabera), Remote Mar 2022 – Dec 2022

• Elicited and documented business requirements, performed gap analyses, and developed user stories and test cases.

• Analyzed large data sets using SQL; created dashboards and reports for key stakeholders.

• Built wireframes and flowcharts to illustrate system design and present findings to cross-functional teams.

• Influenced decisions in executive settings by translating complex data points into clear business rec- ommendations.

Key Achievements:

- Consolidated fragmented reporting processes, reducing turnaround time by 30%.

- Introduced new visualization techniques in Power BI to enhance decision-making for senior leadership.

Technical Business Analyst Bank of America (Collabera), Addison, TX Aug 2020 – Mar 2022

2

• Interfaced with stakeholders to clarify and document requirements for merchant credit approval and fraud data.

• Created mapping documents and requirements specifications; handed them off to development teams.

• Conducted workflow analyses to optimize approvals and payment processes; proposed solutions to improve efficiency.

• Provided frequent project updates to supervisors; took ownership of assigned deliverables. Key Achievements:

- Successfully integrated chargeback and payment data, reducing fraud detection time by 20%.

- Pioneered streamlined data pipelines for the Integrated Credit Decision Platform. BI Data Analyst Microsoft, Irving, TX Oct 2018 – Jul 2020

• Supported Microsoft BI product suite by diagnosing and resolving complex system issues for global customers.

• Developed SSRS reports and Power BI dashboards for real-time troubleshooting and performance tracking.

• Escalated unresolved technical issues to internal engineering teams, ensuring swift resolution. Key Achievements:

- Decreased issue resolution time by 25% through creation of proactive BI dashboards.

- Earned recognition for advanced troubleshooting and strong client support. Sr. Business/Data Analyst Microsoft (Mindtree), Redmond, WA Mar 2017 – Oct 2018

• Performed deep-dive analyses using Power BI and Excel for credit card approval rates, token autho- rization, and daily alerts.

• Created pivot charts, dashboards, and MBR decks for monthly business reviews.

• Developed SCOPE scripts and COSMOS queries for data ingestion; managed daily/weekly data loads.

• Modified Python and PowerShell scripts to improve automation in ERP data analysis. Key Achievements:

- Boosted token authorization rates by identifying root causes and presenting data-driven im- provements to payment teams.

- Implemented monthly reporting structure, cutting manual reporting time by over 40%. Sr. Business/Data Quality Analyst T-Mobile (RFExcel), Bellevue, WA Aug 2016 – Feb 2017

3

• Gathered and analyzed business requirements; linked them to data sources for functional/non-functional specs.

• Employed SQL Management Studio, Toad, and Business Objects for data analysis and transformation logic.

• Assisted in issue resolution during development and production; documented runbooks and project artifacts.

• Created charts and reports for the marketing team to enhance campaign insights. Key Achievements:

- Improved data accuracy by implementing robust validation rules, reducing QA backlog by 25%.

- Introduced updated JIRA/Confluence workflows, enhancing cross-team collaboration. Sr. Business Process/Hadoop Data Analyst T-Mobile (SmartWorks), Bellevue, WA May 2015 – Jul 2016

• Led SQL Server-to-Hadoop migration efforts, coordinating with business to gather requirements and finalize specs.

• Worked with SAP ECC/SAP HANA and supply chain data for ingestion into a Hadoop Data Lake.

• Created pivot charts, sprint documentation, and deployment processes for smooth data transitions.

• Used Hive commands to validate and analyze data post-deployment. Key Achievements:

- Accelerated data lake deployment, enabling faster analytics turnarounds for supply chain metrics.

- Standardized sprint documentation across teams, improving consistency and efficiency. Sr. Data/Business Analyst Expedia (SmartTek21), Bellevue, WA Apr 2013 – Apr 2015

• Managed migration of marketing analysis dashboards and reports; created BRDs for daily, monthly, and weekly updates.

• Collaborated with developers to build processes for email marketing campaigns and B2C/B2B test analysis.

• Used SSRS for dynamic visuals and monitoring email counts, flight/hotel/car trip data.

• Developed test data management strategies and automated validation processes to ensure accuracy. Key Achievements:

- Enhanced campaign ROI visibility by 30% through automated SSRS dashboards and data refreshes.

- Launched new QA framework, reducing manual testing time by 40%. Sr. Data/Business Analyst Microsoft, Redmond, WA Jun 2010 – Jan 2013 4

• Led Field Dashboard and BRE audit projects; developed KPIs/Metrics for Rhythm of Business (ROB).

• Utilized SSAS (MDX), SSIS, Informatica, Oracle, and SQL for data automation and reporting solu- tions.

• Created Visio workflows and ad-hoc audit queries; generated dashboards for STB and SLT.

• Authored BRDs and data validation plans, executed them to ensure data accuracy and process effi- ciency.

Key Achievements:

- Established a data-driven culture for leadership reviews, resulting in faster, more informed decisions.

- Streamlined data pull scripts from SQL into Excel, cutting reporting prep time by 50%. Data Analyst Microsoft, Bellevue, WA Nov 2008 – May 2010

• Created and maintained daily reports for various business groups, improving visibility and decision- making.

• Built an Operational Reporting Tool (SSRS/SSIS) to integrate data from xCAT, HR (Oracle), and other sales systems.

• Oversaw HR fiscal year rollover processes, ensuring data accuracy and compliance. Data Analyst RealNetworks, Seattle, WA Jan 2008 – Aug 2008

• Worked on media application programs, handling music and games data.

• Created automated Crystal Reports for in-depth data validation and analytics.

• Collaborated with project stakeholders to define requirements and manage deliverables. Data Analyst Washington Mutual (WaMu), Seattle, WA 2006 – 2007

• Supported the CMRG data team on new model analysis; performed data pulls for monthly reten- tion/reporting.

• Utilized Oracle 10G, Toad, and ETL processes for daily payoffs/demands. Data Analyst/ETL Cingular Wireless, Bothell, WA 2005 – 2006

• Used Informatica ETL with Oracle and SQL Server for the LNP project. Data Manager/Analyst Dendrite (Analytika), RTP, NC 2001 – 2005

• (Details available upon request.)

5

Education & Certifications

• M.S. in Computer Science, Pune, India

• B.S. in Computer Science, University of Poona

• Oracle 9i OCA Certification

• C/C++ Course (Technical College); Java and OOA/OOD Course (NCSU) 6

Contact this candidate