| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateBalarao Akkina Email: EMAIL AVAILABLEPage 1 of 4SummarySr. 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 ExperienceLPL Financial, CA Sep 2023 July 2024Sr. Data Quality AnalystProject: 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. 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. Wellsfargo, Minneapolis, MN Feb 2021 Aug 2023ETL Production SupportProject: Cornerstone Wholesale Due Diligence ETL Application Used Informatica tool extensively to monitor and debug the ETL jobs and workflows. Balarao Akkina Email: EMAIL AVAILABLEPage 2 of 4 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 & 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. Made sure that the client ETL files are placed properly from source systems to target folders. 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.Allianz Life, Minneapolis, MN May 2020 Jan 2021Sr. ETL TesterProject: Depository Trust & Clearing Corporation Enhancements for Allianz This project dealt with constant communication with Business, Technical team and Developer and leading the QA team to work towards the project. Participated in walkthroughs of business requirements and design specifications for projects. Created test plans, test cases, test data and executed all the test cases against the application. Ensured all test environments are established with proper parameters during smoke testing. Executed different ETL jobs to feed the data to a GUI application and ultimately to flat files. Researched many ETL job failures in CA Workload and acted upon them promptly. Validated Informatica Workflows for various ETL job failures. Used ELF Viewer to monitor the application logs and analyzed the results. Used Polarian test tool for test case creation, execution and monitoring the defects. Executed different Informatica jobs and made sure that the generated files comply to the DTCC formatted file layouts. Validated different XML API messages that are generated by Informatica jobs. Attended daily scrum meetings. Profiled and inspected the source data and validated against the Design and Transformation Rules. Several issues identified during this process. Wellsfargo, Minneapolis, MN May 2000 April 2020Sr. 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 ComplianceProject: Enterprise Customer Profiling & Referrals (ECPR) Worked on multiple platforms (APIs, User Interface, Mainframe, ETL applications) and played multiple roles throughout the time worked at WellsFargo. Balarao Akkina Email: EMAIL AVAILABLEPage 3 of 4 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. 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.EducationBachelor of Science in ComputersMasters in Computer ApplicationsCERTIFICATIONS Certified Software Test Professional (CSTP) International Software Testing Qualifications Board (ISTQB) Certified Scrum Master (CSM) AWS Solution Architect AssociateBalarao Akkina Email: EMAIL AVAILABLEPage 4 of 4Technical SkillsLanguages: 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 2000Testing Tools: Win Runner 75 (Web Add-In), Test Director 7.6, HP ALM, ClearQuest, QTP(Quick Test Pro), Selenium, Query Surge, JiraTools: 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 MonitorETL Tools: Informatica 7.1, Data Stage, Crystal Reports, SSIS, SSRS, COGNOS, Ab Initio/GDE, Hadoop, Big DataDBMS: 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 |
