SUMMARY

• IT Professional over 9 years of experience in Information Technology as Sr ETL QA Data Lead with expertise in ETL testing on web based, Client/Server and data warehousing applications
• Worked in ETL Data modeling\analysis for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) application
• Skillful in ETL Data Analysis using SQL on Oracle, MS SQL Server and DB2. Developed Data Migration and Cleansing rule for ETL application
• Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing
• Worked in Informatica 9.6 products, Informatica Data Quality, Unix, Oracle SQL
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, ER diagram, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin and ER - Studio in both OLAP and OLTP applications
• Experienced in retest the existing test cases with the different kind of source systems for different periods of data
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects
• Strong knowledge of Software Development Life Cycle (SDLC - Feasibility Requirements Analysis, Design, Testing, Implementation, Support)
• Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements
• Experience in preparing test reports from Quality Center and Test Director for daily test status reports to communicate the test status with the team
• Implemented procedures for testing, debugging and documentation of applications with Informatica
• Executed processes for system test planning and relevant testing functions
• Analyse and created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W
• Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.
• Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents
• Implemented and tested slowly changing dimensions (SCD) for ETL Tables as per user requirement
• Experience assessing testing processes, creating and implementing testing strategies in SIT/UAT phase
• Tested all ETL components including BO reports validations for business view
• Clear understanding of business procedures and ability to work as an individual and as a part of a agile team.
• Suggested opportunities and processes for improvement of testing stages relating to overall systems
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing
• Assisted in preparation of work estimates, constraints and timelines
• Identified data streams and reviewed data models for testing strategies
• Supported technical team members writing, execution and debugging of SQL queries during testing
• Participated in all scrum events (daily stand-ups, sprint planning, sprint reviews, and team retrospectives)
• Extensive testing ETL experience using Informatica 9.6 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Consulted with stakeholders, business users, and support personnel with strong engagement and analytical skills
• Expertise in performing GAP analysis and Impact analysis internal and external requirements.
• Wrote complex queries in Teradata SQL assistant to check the data from ETL Source and Target.
• Knowledge of Analysis Design Use Case, Sequence and Activity diagrams using Unified Modeling Language.
• Proficient in troubleshooting database issues and experienced in using performance monitor/profiler to solve dead locks/ long running queries.
• Supported and tested the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
• Developed UNIX scripts to validate the flat files and to automate the manual test cases.
• Developing Test Matrix to give a better view of testing effort
• Worked on Source to Target Specifications with ETL transformation
• Experience in RDBMS, Microsoft SQL Server (T-SQL), Oracle (PL/SQL), MS Access and associated SQL Programming Knowledge.
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong Understanding of BI application design and development principles
• Participation in large-scale “highly-visible” SIT/UAT testing cycles managing technology and business stakeholders
• Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
• Performed data validation testing writing SQL queries.
• Monitor and resolve blocks and deadlocks and monitors backup and restore test jobs
• Strong knowledge in Agile (Scrum), Waterfall model, Kanban and DevOps Implementation
• Strong knowledge in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support
• Performed various operations like Data Cleansing, Data Scrubbing, Data Profiling and maintained data governance for ETL projects
• Good understanding of views, Synonyms, Indexes, Joins and Partitioning
• Gathered and documented Functional and Technical Design documents
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions
• Tested Micro strategy and Tableau reports and generate business trend
• Experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer
• Interacted with BI team in fine Tuning SQL and creating reports. Wrote database scripts & PL/SQL stored procedures, functions and triggers

TECHNICAL SKILLS

Database: MS-Access, Oracle 10g/11g, DB2.SQL Server Studio,Toad,SQL Developer

ETL Tools: Informatica 9.1 /9.6

Data Modeling Tools: Erwin 9.5, Oracle 12.0,ER Studio 8.5.3 and IBM Data Architect 9.1.3

Modeling: Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables

Reporting Tools: Micro-strategy, Power BI

Test Management Tools: HP Quality Centre and ALM

Operating System: Windows, Linux

Defect Tracking Tools: Rational Clear Quest

Languages: SQL, C, UNIX, Shell scripts

Automation Tools: Platinum data compare and Cucumber (Cognizant in house tool) for ETL framework.

Data tool: OLAP, OLTP, ERD, UML and Use case

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sr ETL QA Data Analyst

Responsibilities:

• Maintaining SQL script and perform further data analysis and data aggregation.
• Developing complex SQL queries, and perform execution validation for remediation and Analysis.
• Working closely with developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
• Participating in Web testing, UI front end using SQL comparison .
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Working with the Development team for process improvement and release planning
• Analyzing application data using the SQL to identify the ETL processes
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Performing backend testing of the DB by writing SQL queries to test the integrity of the application and Oracle databases.
• Formulating the QA plan testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
• Wrote complex queries to compare the counts and data from source to target.
• Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results
• Used Agile testing methodology for achieving deadlines in UAT testing.
• Involving in communication between UAT team members, business leaders, and IT.
• Acted as a liaison between the development team and the management team to resolve any data conflicts in terms of requirements.
• Comprehensively used data analysis techniques to validate business rules and identify low quality missing data.
• Interacted with all levels of the project team, from end users to Software Architects, data governance team, Database Administrators, and testers.
• Collaborated with project managers, legal counsel, and other team members to gather data for projects.
• Create daily reports in designed Excel spreadsheet with pivot tables.
• Identified data issues and provided recommendations for resolution to ensure optimal performance.

Environment: - Erwin r9.5, Oracle 9i/10g, TOAD,Informatica Data Quality tool,IBM DA tool

Confidential, Irvine, CA

ETL Data Test Lead/Modeler Architect

Responsibilities:

• Analysis of SDLC Scope and High-Level Business Requirements document
• Discussed requirement for each asset types from business analyst
• Support agile teams of software engineers, business analysts, database administrators, network engineers, and support teams in developing, maintaining, executing and analyzing results of automated performance testing procedures and related software
• Involved in requirement gathering, analysis, design, development, change management
• Developed source to target specifications/mapping
• Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing
• Work as part of a system team monitoring software quality and associated business/technical risks across the software development lifecycle
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets
• Design, develop and execute automated software test plans, test scripts, test scenarios, and analyze performance tests
• Performed sophisticated ad-hoc or ongoing custom analyses against medical claims to support business stakeholders
• Designed and populated specific tables, databases for collection, tracking and reporting of test data
• Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies, Microsoft SQL Server database management
• Wrote Test Plans, which detailed the testing scope, testing requirements, success criteria, milestones, and necessary resources.
• Manually performed Ad-Hoc testing, end-to-end testing, and system testing.
• Performed testing by entering positive values, negative values, and boundary values to the application.
• Performed data validation testing writing SQL queries. Tested ETL batch processes using UNIX shell scripting.
• Involved in writing SQL statements to create test data for test cases and data validation tests to extract data from the tables.
• Compared SQL results with application results by writing SQL queries.
• Used SQL queries to test the migrated database for Back End Testing.
• Wrote and modified required UNIX scripts and other SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases using TOAD.
• Involved in writing Shell Scripts to load and extract information from files and tested the back-end for data integrity in UNIX.
• Involved in exporting the test cases form Microsoft Excel to Test Director and running the cases remotely in different hosts.
• For tracking the Defects used the tool Test Director. Performed Integration, and Regression Testing. Investigated and reported bugs to the developers.
• Reviewed the Logical Model with Application Developers, ETL Team, DBAs and Testing Team to provide information about the Data Model and business requirements
• Normalized the tables/relationships to arrive at effective Relational Schemas without any redundancies
• Developed logical data models and physical data models using ER-Studio
• Generated Reports and Documented and Communicated test results on daily bases
• Involving in writing complex SQL queries to verify data from Source to Target
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow

Environment: Informatica 9.1/9.6, Windows 7, UNIX, CA ERWIN r7, Platinum, Cucumber, PowerBI, HP QC/ALM, Oracle, MS SQL, Web Testing

Confidential, Milwaukee WI

Sr ETL Test QA /Data Modeller

Responsibilities:

• Studied in-house requirements for the Data warehouse to be developed.
• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
• Analyzed requirements and creating and executing test cases involved in ETL process testing using Informatica ETL tool.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Gathered and Analyzed Functional and Performance requirements.
• Involved in project planning, coordination and implemented QA methodology.
• Reviewed Test cases for automation and provided inputs about the scope of Automation.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Sever using SQL, PL/SQL for data integrity.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems for ETL testing.
• Peer reviewed the Test Cases andmade recommendations.
• Test Environment Setup and Performed the Functional and Regression Testing
• Involved in Testing Change Requests (CR) that is testing base enhancements to the existing code before implementing in the Production.
• Coordinated with Developers for Defect analysis and performed Regression Testing.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Performed data validation testing writing SQL queries. Tested ETL batch processes using UNIX.
• Involved in the meeting with business analysts and Marketing team for requirement gathering in Definition Stage.
• Involved in project planning, coordination and implemented QA methodology.
• Peer Review of the scripts and made recommendations for updates if any.
• Setup the Performance test environment with the support of technical team.
• Response time, throughput, hits per second, etc were studied by graphs and reported.
• Created detailed periodic Status Reports for senior management to keep them posted on the progress of implementation
• Wrote SQL queries to test the data in database using TOAD and validated the data
• Verified data completeness and transformation rules.Identified defects and errors in data prior to data processing.
• Solid understanding of source to target data mapping.Highly analytical with strong critical-thinking and problem-solving abilities
• Understands data models and excels at transformations
• Has strong time-management and organizational skills

Environment: Informatica 9.1/9.6, Windows 7, CA ERWIN r7, UNIX, Autosys, Platinum, Cucumber, PowerBI, HP QC/ALM, Oracle, DB2, Netezza