Data Quality Assurance

Balarao Akkina Email: *******.**@*****.***

Page * of 4

Summary

Sr. level IT industry professional with emphasis on Data Analysis and Software Data Quality in Data warehouse, Business intelligence, Main Frame, back-end, front-end, Middle-Tier software applications. Strong verbal and written communication skills, conflict management skills, passion for quality, initiative, results-oriented, and attention to detail. Experience Synopsis

• 20+ years of Data Quality Assurance Analyst/Production Support experience (WellsFargo, LPL Financial, Allianz Life, Cargill)

• 15+ years of Financial Experience (Wellsfargo).

• 5+ years of experience working in Agile environments.

• 12 years of experience writing SQL queries – creating and executing Complex SQL queries to validate ETL and data conversion.

Professional Experience

VCI, MN July 2024 – Current

QA Manager/PM

Project: Visual CRM

• Supervised and mentored QA teams to ensure adherence to quality standards and best practices.

• Developed and implemented training programs to enhance team performance and knowledge

• Designed and refined QA methodologies, test plans, and quality standards for projects

• Implemented and monitored defect tracking systems and ensure timely resolution of issues

• Acted as a key communicator between technical teams and business stakeholders regarding quality goals

• Created detailed reports on QA activities, results, and areas of improvement for senior management.

LPL Financial, CA Sep 2023 –June 2024

Sr. Data Quality Analyst

Project: Integration Services – ETL Application

• Worked on many projects, Service requests, Incident tickets over a course of my time at LPL Financial

• These projects dealt with constant communication with Business, Technical team and Developer and leading the QA team to work towards the project.

• Involved in Daily SCRUM meetings and AGILE/Scrum Methodology for the overall Project.

• Participated in Bi-Weekly Sprint Planning, Sprint Review Meetings, Sprint Demos.

• Involved in writing the Test Plans, Detailed Test cases, Test Summary Reports based on Business Requirement Documents and Design Specifications and Data model diagrams.

• Detailed understanding of design specifications documents, Load Documents, S to T mappings, Transformation rules documents and Data Models.

• Extensively involved E2E data validation from Source Systems to Landing tables and to Target tables and Files

• Schedule meeting on a weekly basis which includes IT, LPL Business and Vendor on going through the issues and resolution process.

• Extensively used simple and complex custom SQL queries to test the data and the transformation rules and table load rules from Source to Target tables.

• Involved in validating of Source tables, Landing/Staging tables and final Target tables. Balarao Akkina Email: *******.**@*****.***

Page 2 of 4

• Extensive testing was performed on End to End Integration of Change Data Capture(CDC).

• Involved in various kinds of testing like System Testing, Integration Testing, Regression Testing, Smoke Testing, and UAT Testing.

• Used LPL Financial homegrown tool DIS Monitor to monitor and debug the ETL jobs and workflows.

• Used Informatica to debug all various ETL job workflows.

• Performed backend Data Centric testing to test data integrity Wells Fargo, Minneapolis, MN Mar 2020 – Aug 2023

ETL Production Support

Project: Cornerstone – Wholesale Due Diligence ETL Application

• Used Informatica tool extensively to monitor and debug the ETL jobs and workflows.

• Participated in daily handover calls with WFIS teams.

• Setup the alerts in ITRS monitoring system for ETL job failures, Database and infrastructure issues.

• Used different alert monitory systems i.e Symphony, Autosys & ITRS

• Participated in automation of ETL job schedules in Autosys.

• Used ServiceNow and PAC2000 tools to track the Production tickets & CRs.

• Used Splunk, AppDynamics, Grafana & Unix to debug the production issues.

• Supported production installations during nights and weekends.

• Performed data analysis/file validation by running simple and complex SQL queries on source data and reported anomalies to business.

• Attended various production issue calls to swiftly triage complex technical problems and provided concise, timely updates to senior executive management.

• Created and executed complex SQL queries to validate ETL and data conversion based on design documents, S2T mapping documents, and data models.

• Researched many ETL Autosys job failures in production by using Unix scripts.

• Monitored different mid-tier applications traffic in both test and production environment and then acted promptly on the issues.

Wellsfargo, Minneapolis, MN April 2004 – Mar 2020

Sr. ETL Tester/Production Support/Systems Analyst/Automation Lead Project: Cache Data Facility and Mid-Tier Applications Project: Client Support for many Mid-Tier and GUI Applications Project: Risk and Compliance

Project: Enterprise Customer Profiling & Referrals (ECPR)

• Worked on multiple platforms (API’s, User Interface, Mainframe, ETL applications) and played multiple roles throughout the time worked at WellsFargo.

• Participated in walkthroughs of business requirements and design specifications for the projects.

• Partake in daily SCRUM meetings and AGILE/Scrum/Kanban Methodology for the overall Project.

• Participated in bi-weekly Sprint Planning, Sprint Review Meetings, and Sprint Demos

• Performed data analysis/file validation by running simple and complex SQL queries on source data and reported anomalies to business.

Balarao Akkina Email: *******.**@*****.***

Page 3 of 4

• Researched many ETL Autosys job failures in production by using Unix scripts.

• Uploaded client ETL files from source systems to landing zone using Ab-Initio.

• Involved in extensive testing of Type I and Type II Dimension and Fact tables in a Dimensional Data warehouse.

• Tested Cognos Reports and validated the data against the tables and validated the format and formulas.

• Created and executed complex SQL queries to validate ETL and data conversion based on design documents, mapping documents, and data models.

• Ensured all test environments are established and running for all the API application clients.

• Executed Web Service testing scenarios using SOAP UI & SoapScope tools.

• Developed automation frameworks by using tools such as Selenium WebDriver, Cucumber, and SoapUI

• Extensively utilized Jira, Selenium & GitLab.

• Developed and executed XML driven message test cases using APIs.

• Extensively involved in REST API Testing using SOAP UI tool.

• Used QuerySurge for Automating Regression Test Suite for each release.

• Assisted both Level2 and Level3 production support teams.

• Validated Splunk error reports

• Setup various test data using API calls (POST/PUT) and SQL queries for the following entities - offers, promotions, dispositions, and HRIS team member data.

• Validated the back-end data by executing complex SQL queries in SQL Server & DB2/MS Access connector.

• Tested different WFXML2.1 messages and validated them against the respective schema documents by using XML Spy & Soap UI tools.

• Maintained the mainframe test dates for different API application IDs every week for all testing environments.

• Automated testing process of RCSA and CICAT web-based applications by using QTP 9.1 & 9.2 versions.

Education

Bachelor of Science in Computers

Masters in Computer Applications

CERTIFICATIONS

• Certified Software Test Professional (CSTP)

• International Software Testing Qualifications Board (ISTQB)

• Certified Scrum Master (CSM)

• AWS Solution Architect Associate

Technical Skills

Languages: Python, C, Object-oriented programming with C++, SQL, P/L SQL Operating Systems: UNIX (Sun Solaris 26, Sun OS 56, BSDI), Windows NT/95/98/2000/XP GUI: VB 60, Developer 2000

Testing Tools: Win Runner 75 (Web Add-In), Test Director 7.6, HP ALM, ClearQuest, QTP

(Quick Test Pro), Selenium, Query Surge, Jira

Balarao Akkina Email: *******.**@*****.***

Page 4 of 4

Tools: SQL *PLUS, P/L SQL, MS-Word, MS Excel, ETL Console, TOAD, SQL Developer, AQT, SQL Server Management Studio, SOAP UI, XML Spy, Splunk, Control -M, Autosys, DIS Monitor

ETL Tools: Informatica 7.1, Data Stage, Crystal Reports, SSIS, SSRS, COGNOS, Ab Initio/GDE, Hadoop, Big Data

DBMS: Oracle7x, Oracle 8i/9i, MS-Access, SQL Server 2000, DB2, Teradata, Sybase Web Technologies: HTML, DHTML, XML, XML Spy, SOAP Scope, SOAP UI Hardware: UNIX based systems, Pentium & IBM PC

Contact this candidate