Data Analyst Business

Swetha Emmadi

QA/Business Data Analyst

Professional Summary

Experienced Business Data Analyst/QA with a strong background in Mortgage Corporation, Telecommunications, Banking, and Consulting Industries. Proficient in Acquisitions, Finance, Human Resources, Quality Assurance, SDLC, Data Warehousing, and Agile methodologies. Extensive expertise in Business Requirements Gathering, Data Cataloging, Collibra, Issue Escalation, Problem Resolution, and Process Modeling. Adept at leading, motivating, and mentoring staff to deliver high-quality results. Highly skilled in providing status updates and reporting at all levels to stakeholders.

BOOZ ALLEN HAMILTON January 2018 – Current

BUSINESS DATA ANALYST

Experienced Business Data Analyst and QA Tester with a strong background in data warehousing, business analysis, and Sarbanes-Oxley (SOX) compliance. Proven ability to lead and coordinate cross-functional teams, ensuring that business requirements are accurately captured and translated into technical solutions. Adept at performing data validation, managing project schedules, and providing quality control and testing across the SDLC.

Key Responsibilities & Achievements

Data Warehousing & Business Analysis Expertise

Led the creation and redesign of a centralized data warehouse for managing Acquisition-related data, improving data processing and reporting capabilities.

Directed a team of Business Analysts to gather, document, and test requirements across 145+ data warehouse tables, ensuring data consistency and alignment with business goals.

Coordinated with downstream users to define business requirements, communicate timelines, and manage testing schedules for timely project delivery.

Managed project schedules and provided weekly updates to senior management, addressing challenges and mitigating risks.

Project Management & Leadership

Led enterprise data warehousing projects from requirements gathering through implementation, acting as the liaison between business clients and technical teams.

Conducted Level of Effort (LOE) analysis to evaluate project scope, resource needs, and timelines for better planning and resource allocation.

Collaborated with internal and external teams to resolve issues related to data integrity, coding, and business logic.

Mentored junior staff, ensuring team success and achievement of project goals.

Sarbanes-Oxley (SOX) Compliance & Documentation

Managed applications to ensure SOX compliance, focusing on access controls and regulatory standards across the data warehouse.

Led data extraction and validation efforts to ensure data integrity, security, and accuracy in adherence to SOX guidelines.

Maintained process documentation, ensuring compliance with regulatory standards.

Collaboration & Data Reporting

Collaborated with Data Warehouse, Essbase, and Reporting teams to design data structures, improving reporting capabilities and data extraction efficiency.

Acted as a Subject Matter Expert (SME), providing regular project updates to stakeholders and proactively addressing issues to meet business needs.

FreddieMac Mclean VA July2013 - July2017

Business Data Analyst/QA

Governance & Data Management

Supported Governance initiatives for Shared Information Assets, focusing on AMCP and SDLC enhancements.

Articulated business requirements and documented processes for User Acceptance Testing (UAT) and postproduction validation.

Performed data analysis using Excel, including pivot tables, VLOOKUP formulas, and Macros to analyze and present data.

Created and modified pivot tables and charts to manage and visualize data from internal and external sources.

Incident & Defect Management

Utilized Clear Quest and Remedy tools to track and report on incidents, defects, and enhancements, ensuring accurate reporting and resolution.

Opened and managed Clear Quest Data Initiatives tickets, coordinating with technical analysts for necessary details.

Reviewed enhancement lifecycle updates and coordinated with technical teams to ensure the proper inclusion of Critical Data Elements (CDEs) in project deliverables.

Data Quality & Risk Management

Analyzed Data Quality (DQ) reports to assess sufficiency and prepare Risk and Controls Matrix (RCM) for impacted CDEs.

Conducted Release Assessment Form (RAF) reviews and submitted documentation to Operational Risk Management (ORM) for approval.

Monitored and reviewed Systems Integration Testing (SIT) results, providing UAT test strategy documentation and performing additional UAT as needed.

Documentation & Reporting

Designed and developed Test Strategy Documents, Test Completion Reports, Go/No Decision reports, and weekly status reports.

Expertise in creating Requirement Traceability Matrix (RTM) to ensure alignment between business needs and technical solutions.

Managed TDQ report reviews and updates, ensuring accurate tracking through auto trackers and communication with stakeholders.

Business Analysis & Collaboration

Gained knowledge of business processes and applications such as CDW, EIH, ODS, RDS, and DTS, improving data insights and analysis.

Reviewed and approved business fact types (attributes) in the Business Decision Management System (BDMS), ensuring alignment with business objectives.

Served as both Admin and Analyst in the BDMS Glossary team, reviewing, approving, and rejecting fact types as needed.

Managed the BDMS SharePoint site, ensuring accurate documentation and smooth approval workflows.

Verizon Communication INC January 2013 – April 2013

QA/Business Data Analyst

Test Planning, Execution & Coordination

Collaborated with customer representatives and Solution Architects during the testing design phase to understand testing requirements related to data mapping, standard profiles/templates, and business rules.

Effectively communicated testing issues to relevant VDMS teams (including Configuration/Solution Architects) to ensure issues were resolved, re-tested, and ultimately delivered successfully.

Actively participated in Agile ceremonies including scrum calls, sprint planning, sprint reviews, and retrospectives, contributing to sprint goals and progress.

Test Documentation & Reporting

Verified and prepared test summary reports for sign-off, ensuring that all requirements were met and providing clarity before code was delivered to User Acceptance Testing (UAT).

Participated in peer reviews of test cases, ensuring traceability and coverage of test requirements against business specifications.

Created detailed, clear, and concise testing documentation, capturing test results, evidence, and troubleshooting steps for project transparency.

Test Case Development & Execution

Developed and executed test plans and test cases for UAT and system integration tests, ensuring alignment with customer requirements and business processes.

Leveraged SQL Server for data validation, writing queries and scripts to automate testing, troubleshoot issues, and ensure data integrity.

Prepared test run books for third-party vendors, clearly outlining test tasks and execution steps to ensure smooth testing and validation processes.

Quality Assurance & Issue Management

Developed Quality Assurance test plans, test data files, test summaries, and test metrics to track progress and quality throughout the testing lifecycle.

Led the tracking and management of defects, using tools like Rational ClearQuest to log, link, and monitor defects, ensuring quick resolution and effective defect management.

Published closure summary reports after project migration to production, summarizing lessons learned and key testing findings to improve future projects.

Collaboration & Communication

Communicated business processes and requirements clearly to IT development teams, ensuring a thorough understanding and alignment with business needs.

Coordinated with third-party workflow vendors to automate testing processes, improving testing efficiency and reducing manual errors.

For critical issues, quickly escalated to the appropriate directors and coordinated emergency calls to expedite issue resolution.

Agile Testing & Continuous Improvement

Worked within an Agile environment, adapting to changing requirements and providing regular feedback to improve testing processes and product quality.

Capital One Mclean VA August 2012 – December2012

Business Data Analyst/QA

Test Planning, Documentation & Approval

Created Quality Center (QC) structure for Business Requirements, Test Cases, and Test Sets, seeking stakeholders’ approval during project meetings to ensure alignment and clarity.

Uploaded requirements and test cases to QC and DOORS, ensuring proper tracking and version control for project deliverables.

Developed and maintained Test Strategy Document, outlining testing timelines, test environments, data preparation, testing scope, entry/exit criteria, and team roles/responsibilities for each phase of testing.

Test Case Execution & Reporting

Executed test cases and managed RTM (Requirement Traceability Matrix) to ensure complete test coverage and traceability.

Logged and tracked defects in QC, ensuring proper communication and resolution of issues throughout the testing lifecycle.

Prepared and delivered Test Execution Reports (QS Reports) to track test progress, providing leadership with a clear status of testing activities via Klink.

Risk Management & Business Assurance

Prepared Business Assurance Strategy (BAS) document to assess and communicate high-level business risks for the project, ensuring alignment with project scope and identifying impacted stakeholders.

Participated in Go/No-Go meetings at the end of each testing cycle to evaluate test results, risks, and overall project readiness for deployment.

Integration & System Testing

Performed integration testing to validate the data mapping from various source systems to destination systems, ensuring data accuracy, transformation, and flow.

Coordinated with third-party vendors, product owners, developers, and the Project Management Office (PMO) to ensure high-quality deliverables and efficient issue resolution.

Quality Center Administration & Test Management

Set up new Quality Center projects, managing user access, user-defined fields, and permissions to ensure proper project configuration and access control.

Led the maintenance and upgrades of Quality Center tools, ensuring the tool environment was up to date with patches, enhancements, and new feature integrations.

Test Completion & Sign-off

Created Test Completion Reports (TCR) at project conclusion, summarizing test case execution, test results, and traceability to requirements as part of the final sign-off document for stakeholders.

Coordinated and verified migrations with development and business teams, ensuring smooth transition and deployment.

Team Collaboration & Process Improvement

Collaborated with peers to ensure that customer expectations were met and exceeded, leading efforts to continuously improve testing processes, tools, and techniques.

Contributed to team success by hiring the right talent and implementing training programs to enhance personnel skills and team efficiency.

Metrics & Reporting

Provided status reports detailing defect and enhancement metrics, offering leadership clear insights into testing progress, issues, and project health.

Consistently exceeded financial goals by optimizing resource utilization, improving testing efficiency, and meeting project timelines.

Fannie Mae Mclean VA November 2008 – July 2012

Operational Risk Analyst

Risk Management & Compliance Reporting

Managed and conducted annual reviews and certifications for Corporate Policies and Procedures Repository, ensuring all policies adhered to internal and regulatory standards.

Validated risk metrics and dashboards by cross-referencing reports with raw data extracted from backend databases, ensuring data accuracy and alignment with key risk indicators.

Presented risk and compliance reports to upper management (VPs, SVPs, Directors), effectively communicating insights and providing recommendations for risk mitigation.

Audit & Compliance Testing

Prepared and executed test cases based on SOX compliance requirements and internal IT controls, ensuring all systems met Section 404 compliance standards.

Led testing efforts related to access control, logging and monitoring requirements, and business process verification, ensuring adherence to SOX regulations and internal control frameworks.

Tested Segregation of Duties (SOD) controls, ensuring that access rights and responsibilities were aligned with compliance standards.

Collaborated with internal audit, management, and business owners to test IT controls, identifying weaknesses and communicating findings to process owners for remediation.

Data Management & Reporting

Managed the RMO dashboard, generating weekly and monthly reports on OI, IA, MSI, and SOX issues from RTS and MicroStrategy.

Created risk reports, utilizing pivot tables and charts in Excel to visualize data and provide actionable insights to stakeholders.

Tracked and managed deficiencies using Deficiency Management System (DMS), ensuring proper documentation and follow-up on issues reported by the SOX 404 finance team.

Access Management & Database Support

Executed PL/SQL scripts to load and update the Access Cleanup database, maintaining an accurate list of non-unique IDs within the IT environment for compliance monitoring.

Monitored Technology Selection Process (TLC) site for new documents, ensuring timely TRL (Technology Risk Leads) reviews on new technology documentation.

Risk & Control Management

Managed risk and control programs for various IT projects, including Cyber Trust Remediation Tracking, Non-unique ID Access Compliance, SOX 404/302 Certifications, and TIO Incident Management, leveraging Excel for tracking and reporting.

Defined and implemented structured processes for IT controls decisions, aligning them with control frameworks and enterprise policies to ensure a consistent approach to risk management.

Conducted Risk and Control assessments for platforms like UNIX, Oracle, Sybase, and various process areas including Business Continuity & Disaster Recovery and Software Configuration Management, providing cost-effective recommendations for countermeasures.

Process Improvement & Remediation

Assisted with remediation efforts, including the development of manual dashboards and extensive spreadsheet analysis, improving process visibility and ensuring timely resolution of identified deficiencies.

Verizon Communication INC Mclean VA September 2006 – October2008

QA Analyst

Test Planning & Requirements Analysis

Actively participated in Analysis and Design meetings to ensure that assigned functionality met user requirements, providing valuable insights during the requirements phase.

Collaborated with developers to better understand requirement specifications, ensuring that the quality of the application was improved from the outset.

Conducted requirement walkthroughs with business owners and participated in requirements review sessions, validating requirements against business needs.

Led JAD (Joint Application Development) sessions to gather requirements and identify gaps in business logic and application functionality.

Test Case Development & Execution

Provided input on project scope, goals, risks, and timelines to project management for effective planning and control of testing phases.

Developed, executed, and documented detailed unit tests and user acceptance tests (UAT), ensuring that all features were properly validated before release.

Conducted cross-browser testing, verifying navigation paths and checking for broken links to ensure compatibility across various platforms and devices.

Database & Migration Testing

Used SQL Developer to validate data feeds and check the integrity of data stored in main tables, ensuring proper functionality and accuracy.

Performed migration testing, running SQL queries to verify data migration from legacy systems to new systems, ensuring no discrepancies in data transfer.

Web Service & Security Testing

Tested Web Services (SOAP & REST) using SOAP UI, creating test cases, performing load and security testing, and validating XML responses to ensure service reliability and security.

Conducted security testing to verify role-based access controls (RBAC) and ensure that only authorized users could access protected application features.

Test Execution & Defect Management

Executed test cases using Test Lab in Test Director, logged defects, and worked with development teams to resolve issues in a timely manner.

Performed End-to-End (E2E) testing and IST (Interface System Testing) to ensure that no downstream systems were impacted by new enhancements and that the overall system integration was intact.

Data Integration & Loading

Loaded data feeds into network tables using tools like Putty and Hummingbird, ensuring accurate data transfer and system integration.

Used DataStage Director to run fact jobs, ensuring that full data was successfully populated into the network and that any issues were promptly identified and addressed.

User Training & Demonstrations

Presented product demos to end users and customers, showcasing new functionality and gathering feedback to ensure the application met user expectations.

Contact this candidate