Data Analyst Quality Assurance

SOWJANYA UNGARALA

Fremont, CA ***** 408-***-**** ********@*****.*** www.linkedin.com/in/sowjanyaungarala

Professional Summary

Enthusiastic Data analyst with 5 years of total IT experience, seeking a professional role in Data Analytics. Experience in analyzing complex datasets and creating insightful reports to drive business decision-making. Proficient in MS Excel skills – VLOOKUP, pivot tables and data visualization tools like Tableau.

Skilled in troubleshooting, performance analysis, optimization, quality assurance, and conducting unit and system testing of reports and data sources.

Proven track record in improving data accuracy and integrity by up to 20%, reducing data errors and inconsistencies by up to 30% resulted in enhancing data accessibility and usability.

Skilled in developing and executing ETL processes to extract, transform, and load data from diverse sources into SQL Server databases and Tableau.

Extensively experienced with various RDBMS platforms, including Oracle Databases, SQL Server, and MS Access databases.

Proficient in conducting regression testing to guarantee the reliability and stability of both new and existing reports.

Well-versed in all stages of the Software Development Life Cycle (SDLC), encompassing Requirement Gathering, Development, Testing, Deployment, Documentation, Migration, and Production support.

Proficient in MS-PowerPoint, MS-Excel, MS-Word and other office Suites like Google sheets for Project Management and Ad hoc data Analysis.

Experience in JIRA and Agile processes.

Professional experience:

Tableau Reporting Data Analyst – Citibank, TX. 11/2021 -12/2023

Defined and created key metrics and KPIs related to credit exposures and analyzing loan portfolios such as total credit exposure, exposure by borrower type, industry sector exposure, concentration risk measures, and exposure at default (EAD) metrics.

Experienced in setting threshold values for key credit exposure metrics and set up alerts in Tableau to notify risk managers when exposures exceed predefined limits. This allows for proactive monitoring of credit risk and timely intervention to mitigate potential losses.

Extensive expertise in architecting source table mappings to ensure seamless alignment between data extraction, transformation, and loading processes with reporting requirements using Tableau.

Efficiently streamlined source data to detect and rectify data quality issues, implementing effective strategies that led to a notable 20% reduction in data errors and inconsistencies.

Crafted intricate SQL queries to extract, manipulate, and analyze data from databases.

Demonstrated proficiency in constructing custom data sources using custom SQL, effectively reducing dataset sizes and enhancing report loading times.

Led System Integration Testing (SIT) of diverse Tableau components, including data sources, calculations, filters, performance metrics, report specifications, and user guides. Ensured alignment with Business Requirements Documents (BRDs) to guarantee cohesive functionality across all elements.

Enhanced and upheld documentation standards for test plans, test cases, and testing outcomes, providing comprehensive evidence of data validation.

Played a pivotal role in the weekly migration of data sources and workbooks, overseeing testing procedures and scheduling subscriptions, while also managing extract refreshes in production.

Delivered proficient Production support by diagnosing and resolving issues associated with data loading, functionality, and report performance.

Executed large-scale migration of reports and data sources, transferring extracts from one server to another, updating connection details, replacing data sources, and rectifying reported issues by substituting field references. Ensured seamless functionality of reports throughout the process.

Generated Change Requests (CR) using ServiceNow to facilitate the deployment of dashboards, preparation flows, and data sources.

Collaborated closely with business analysts and senior managers to comprehend report requirements and functionalities.

Maintained documentation and tracked version release control, facilitating bug assignment to relevant developers and updating status throughout the lifecycle.

Data Analyst - Uplift Family Service, CA. 08/2018 - 08/2019

Proficient in designing, developing, testing, and managing the production rollover of Reporting and Analysis projects using Excel.

Experienced in delivering timely reporting requirements to optimize contracts and secure adequate funding for Behavioral Health programs across California.

Managed the development and production of weekly and monthly productivity reports, census reports, and Client Flex Fund expenditure reports. These reports were utilized by higher management for data analysis to facilitate critical business decisions.

Analyzed monthly reimbursement reports and contract terms to offer guidance for programs and funding source-based payment applications, resulting in a 20% improvement in error resolution. Facilitated information exchange and coordinated process flow between the billing department and clinical staff.

Proficient in leveraging analysis tools like Google Sheets, Pivot Tables, and SQL to manipulate data effectively, draw precise conclusions, and provide insightful reports to upper management.

Skilled in filtering and cleansing data through the review of reports and performance indicators, identifying and rectifying data quality and computation issues.

Scheduled extract refreshes using Tableau to automate weekly and monthly reports.

Conducted dashboard testing to ensure data alignment with business requirements by querying databases using SQL.

Designed and developed diverse analytical reports from multiple data sources, integrating data onto a single worksheet within Tableau Desktop.

Collaborated closely with business power users to craft reports and dashboards using Tableau Desktop.

Project Coordinator - Kaiser Permanente, CA 04/2017 – 08/2018

Generated reports and performed data validation in SMART objectives.

Translated end-user reporting requirements into secure, useful, timely, and accurate manner using Excel

Created Gantt charts, scorecards, power Points and various process flow diagrams for successful completion of projects.

Performed SWOT analysis and Risk Analysis to identify critical and high-risk areas of the mobile application..

Held brainstorming sessions with corporate department, Compliance, Information Service department to determine the best form for Requirement gathering.

Conducted user interviews, gathered, analyzed and documented Business requirements based on the analysis of workflow model.

Managed 40% of task in building Job Safety Analysis Tools - gathered business information required for building online safety tool that can be used to define and control hazards associated with a certain process, jobs or procedure. Performed systematic examination and documentation of every task within each job to identify health and safety hazards and the steps to control each task.

Analyst I - Family Health Plan (TPA) Ltd., India 06/2011 – 03/2013

Perform various analysis and interpretation of data to link business needs.

Managed business process workflow Diagrams like swim lane to improve task assignment.

Coordinated requirement gathering meetings, created FRD and BRD.

Maintained and tracked all claims to analyze business requirement and organized high and low level requirement.

Reviewed policy and claim information to analyze the potential gaps in the report that are being presented to the client.

Created Use Case diagrams using MS Visio Coordinated JAD sessions at various stages of project and analyze the system preference.

Played as a key member of the team in planning, testing and implementing system enhancement request.

Used UML diagrams for data capture activities which required working with SME’s to maintain accuracy of data.

Thorough understanding of health benefit products, assisted in consolidating the summary of Benefits.

Prepared analyses summarizing analysis, conclusions, issues and recommendations.

Business Operations Coordinator - Helios Insurance & Broking Services, India 03/2009 – 05/2011

Managed quality assurance of health insurance for retail and corporate businesses.

Maintained and tracked cash deposit statements and updated client with updated members list and CD statement at month-end.

Prepared MIS - collection reports at month-end.

Coordinated with marketing team to provide required materials to direct sales team.

Handled customer queries and claim issues, and ensured a high-quality customer experience.

Screened and compared insurance quotes from different insurance companies and submitted “best quote” to the client based on client’s needs and closed the deal.

Coordinated with sales team to collect data while making quotes

Assisted client for proper completion of claim documents and formalities.

Achieved 90% retention of existing clients.

EDUCATION

MS – HCA, California State University, East Bay, Hayward, CA 2018

CERTIFICATIONS

Google Data Analytics Certification 2021

Course covered: Data Analytics Foundation, Make Data Driven decision, Prepare Data for exploration, Data Cleaning, Analyze Data to answer questions, Share Data through Art of Visualization-Tableau, Data Analysis with R Programming

Contact this candidate