Etl Tester Data Analyst
Resume:
Rajeswari Chaparala
*******************@*****.***
SUMMARY:
8+ years of experience across multiple organizations in the banking & finance, mortgage industries and HealthCare. Extensive experience in testing validation rules, custom objects, custom fields, role-based page layouts, workflow alerts & actions, pick lists, approval processes, record types, dashboards, custom tabs, custom reports, report folders, report extractions to various formats, and Email generation according to application requirements.
Quality Analyst Skills:
Functional, Regression and UAT testing Coordination.
Creation of test scripts and execution.
SDLC methodology such as Agile, Waterfall and RUP.
SQL queries for testing/report validation in data warehouse.
ETL: SAP data services, Business objects, Tableau reports.
Automation Testing with Selenium,Testng.
TECHNICAL SKILLS:
Business Processes
Agile, Waterfall, RUP, JAD, UML.
Platform
UNIX, Linux, Windows vista/XP
ETL
SAP data services, Business objects, Tableau reports, dashboards,ETL
Databases
Oracle 11g, Teradata, MS Excel, MS Access, MS SQL server, Oracle,
Web
HTML, CSS, JSP, SOAP, WSDL, JSF, Ajax, XML
Programming Languages
SQL, PL/SQL, T-SQL, Java, Python, Tableau, Cognos, Java, Shell scripting, Selenium
Office Tools
Microsoft Excel, Microsoft PowerPoint, Microsoft Access, Microsoft Visio, Microsoft SharePoint
Ticketing Tools:
Jira, Service Now,
Testing Tools:
ALM/Quality Centre 11.0
WORK EXPERIENCE:
CLIENT: State Of Indiana (Family and Social Security Administration) April 2020 – TILL DATE
ROLE: Senior ETL tester/Automation
Responsibilities:
Developed high level test matrix based on business requirements, functional and development standards for assigned projects/applications.
Develop test cases based on test matrix including test data preparation for Data completeness, data transformations, Data quality,performance scalability.
Developed SQL queries/scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
Performed data quality analysis using advanced SQL skills.
Performed count validation, Dimensional analysis, Statistical analysis and Data Quality validation in data migration.
Extensive SQL querying on staging, data warehouse and datamarts.
Involved in troubleshooting,resolving and escalating data related issues and validating data to improve data quality.
Ensure error logs and audit tables are generated and populated properly.
Used Jira for requirement gathering session
Designed Quarterly test Reports and processes for the stakeholders.
Extensively worked on Formula fields.
Perform UAT / Sanity testing through different sandboxes.
Experience in giving Demos and training to the end user.
Performed functional testing on the User stories and then documenting the process.
CLIENT: Eli-Lilly, Indiana SEP 2018 – Mar 2020
ROLE: ETL Tester/Data analyst
Responsibilities:
Developed complex SQL queries for data validation for verifying the ETL Mapping Rules.
Performed Metadata Analysis by Data Profiling and acted as a data steward in maintaining the quality metrics on a continuous basis.
Conducted Data Migration and Data Cleansing.
Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatics Workflow Manager.
Used Master Data Management (MDM) technology, tools to create and maintain consistent and accurate lists of Master.
Responsible for Import and Export databases between Microsoft Access, Microsoft Excel, Text, or SQL.
Extensively tested the reports for data accuracy and universe related errors.
Used SQL tools to run SQL queries and validate the data loaded in to the target tables.
Validated the data of reports by developing SQL queries in SQL Developer against Data Mart tables and ODS.
Involved in user training sessions and assisting in UAT (User Acceptance Testing).
Involved in extensive DATA validation using SQL queries and back-end testing
Wrote data conversion and data migration scripts for ETL process
Created ETL execution scripts for automating jobs.
Worked on creating various reporting using crystal reports according to end user requirements.
Used workflow manager for session management, database connection management and scheduling of jobs.
CLIENT: Gain Well Technologies, Indiana SEP 2016 – Mar 2018
ROLE: Quality assurance specialist
Responsibilities:
Worked closely with Business user in understanding designing and documenting the Functional testing plan and then writing executing documenting the results .
Logging ETL test specifications including test source data preparation, writing test cases to test data completeness,data transformations and Data quality.
Performance and scalability data aggregations- match aggregated data against staging tables and or/DSS and granularity of data is as per specifications .
Testing to check for attributes from source system are migrated to target system based on the defined business/transformation rules.
Created use cases, activity diagrams and sequence diagrams.
Created test cases document to test each phase to ensure complete coverage. test cases were incorporated to test each positive and negative case.
Develop Sql queries and similar artifacts to validate the completeness,integrity and accuracy of data within an ETL process test cycle.
Execute test cases with respect to source and target tables.
Perform UAT testing for the used cases and prepare the sign off documentation with the test scenarios.
Customer Migration -Extensively on Reports – Joined / Tabular Created new user accounts and configured Salesforce.com to fit security needs at the user and organization levels.
Tested profiles, Roles, Permission sets, workflows, Reports and Dashboards.
CLIENT: Health First Health plans, Florida Fl APR 2013 – AUG 2016
ROLE: ETL Tester-Level 3
Responsibilities:
Worked closely with application development teams to ensure adherence to design specifications, proposed procedures, practices and standards.
Participated in Joint Application Design/Development (JAD) sessions. e
Extensively involved in requirement analysis
Created the conceptual diagrams and data flow diagrams based on the analysis of requirements
Designed the relational data model ie ERD to acquire the transactional data and database snapshots.
Identified the process which were to be associated with FACT tables.
Tested ETL process to push the transactional data from the normalized data structure into the data marts.
Defined the data cleansing strategy based on the exploratory data analysis reports which to be applied on the staging data base and then pushed to the Operational datastore.
Developed SQL scripts for verification of data at extraction phase to ensure,transformation phase and loading phase of the data to ensure correctness of the data and also verifying the ETL mapping rules
Assisted the UAT sessions with the users which were not just limited to flow of transactional data, through the system, performance test and updating the defect tracking list for with UAT feed backs.
Contact this candidate