SUMMARY

• QA Analyst and Tester with over 6 years of IT experience in Data Warehousing testing and Data Analysis using SQL, PL/SQL, UNIX, Shell Scripting, Java Scripting and HP Quality Center in Telecommunications, Retail, and insurance industries. Experience testing a Wireless Billing Graphical Tool, product tracking and reporting as well as collecting data to profile customer needs.
• Extensive experience in Data Management, Data Analysis, Data Discovery, Data Masking and Data quality.
• Worked on different Schemas including Star and Snowflake.
• Hands on expertise in Data Warehousing concepts and tools. Involved in the ETL processes using, Informatica, and Ab Initio and Autosys tools
• Involved in performing various kinds of testing including Sanity, Functional, regression and Integration testing
• Extensively involved in performing automated testing using HP ALM and QTP
• Good experience in data sources, data profiling, data validation, developing low - level design patterns based on the business and functional requirements.
• Worked extensively on SCDI, II and III dimensions
• Experienced working with SQL Server 2008, Netezza, Oracle 10g/11g, Teradata, Sybase & DB2.
• Experienced in testing different source feeds of data for ETL and prepared mock data for ETL.
• Experience in testing Business Report developed in Business Objects XIR2 & Cognos 8 series, OBIEE, Hyperion reports.
• Extensive experience in Oracle Packages, Stored Procedures, Functions and Database Triggers using PL/SQL. Efficiently used Oracle utilities like SQL Loader,
• Extensive experience in data modeling to ensure the referential integrity
• Experienced in Writing UNIX Korn Shell Scripting for job scheduling and sequencing.
• Automated and scheduled the Data stage jobs using UNIX Shell Scripting and CRON TAB.
• Extensive experience in UNIX Shell Scripting, AWK and file manipulation techniques.
• Experience with QA Methodology and QA Validations to ensure the Quality.
• Solid Back-end testing experience in writing and executing SQL Queries.
• Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures, and free hand SQL.
• Ability to interact with all levels of personnel from technical to high level executive management within the information technology and business communities.

TECHNICAL SKILLS

Quality Assurance/ Test Management: Rational Requisite Pro, HP ALM 11/Quality Center 10, IBM ClearQuest 9.0, IBM Clear Case 9, Test Director 7.5, BugZilla, JIRA

SDLC/STLC: Agile, SCRUM, Water Fall, RAPID, Spiral, V- Model

RDBMS Technologies & Data Sources: Oracle 11g/10g/9i, Teradata 13.0/12.0, SQL Server 2012/2008R2, IBM DB2, SYBASE, MS Access, MS EXCEL, FLAT Files, XML, Oracle ATG

RDBMS Query Tools/GUI Tools: TOAD 10.6, SQL* Loader, Oracle SQL Developer, Teradata SQL Assistant 13.0, WinSQL

ETL/Data warehouse: Informatica 9x/8x/, SSIS, Ab Initio 2.15, IBM Informatica 8.1

JOB SCHEDULING TOOLS: CRON TAB, Autosys, Control-M

Languages: Shell scripting, C, C++, C#, Visual Basic, VB Script, XML, HTML, JavaScript

BI/Reporting Tools: Business Objects XIR4, Cognos 8.4, OBIEE 10, Hyperion 11.1.2

Operating System: MS - Windows 9x/NT/2000/XP, Red Hat Linux, UNIX (Sun Solaris 5.8)

Enrichment tools: Trillium Discovery(13.5), TS Discovery 14.0

PROFESSIONAL EXPERIENCE

Confidential, CA

ETL QA Analyst

Responsibilities:

• Tested all the Informatica jobs and ETL flow for data validation.
• Reconciled data for all the Informatica jobs for testing needs.
• Wrote test cases based on ETL mapping document for testing the entire ETL workflow.
• Involved in understanding of business processes to learn business requirements.
• Extracted data from different systems into Source. Mainly involved in ETL developing.
• Defined and implemented approaches to load and extract data from database using Informatica.
• Worked closely with data warehouse architect and business intelligence analyst in developing solutions.
• Performed integration testing, Unit testing, regression testing and load testing on various modules using WinRunner and LoadRunner
• Used Erwin for data modeling (i.e. modifying the staging and SQL scripts on Oracle and MS Access Environments).
• Conducted System testing for each phase of the application.
• Involved in preparing Test Scripts and Test cases based on the functional specifications.
• Executed backend testing of the application by writing SQL queries.
• Used Defect Tracking System Test Director to report bugs found in different testing stages.
• Uploaded test cases into HP ALM 11.0 and performed manual/automation testing
• Executed Test Procedures and documented Test Results
• Involved in design, source to target mappings between sources to operational staging targets, using Informatica Designer.
• Performed ETL coding using Hash file, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested. Extensively used stages available to redesign Data Stage jobs for performing the required integration.
• Executed jobs through CRON TAB for better performance and easy maintenance.
• Involved in unit, performance and integration testing of Data Stage jobs.
• Used Data Stage Director to run and monitor the jobs for performance statistics.
• Involved in performance tuning of the jobs.
• Used T-SQL for validating the data generated Confidential OLAP server.

Environment: Oracle 8.0, Informatica 9.x, SQL*Plus, SQL, Quality Center, Rational Clear Quest, Clear Case, SQL Server 2000, PL/SQL, Visual Basic 7.0, Windows 7, Test Director, XML, XSD, XSLT, Java and UNIX, Korn Shell scripting, CRON TAB, PERL, win runner, Load runner

Confidential, OAK BROOK, IL

ETL QA/Data analysis

Responsibilities:

• Worked with team to analyze the requirements and review the BRD and TDD documents then design test plan.
• Analyzed data mapping specifications and developed Test Plans, Test Cases, Expected Results and Prioritized tests for the applications for various modules using HP QC 10.
• Involved in Unit testing and integration testing of Informatica Jobs
• Tested several packages developed using SSIS.
• Wrote several test cases for Informatica and for data flow.
• Tested Complex ETL Informatica jobs and Sessions based on business user requirements and business rules to load data from different source
• Performed Verification, Validation, and Transformations on the Source data before loading into target database.
• Wrote complicated SQL queries for data validation and data verification based on data mapping document.
• Wrote SQL queries in Toad and SQL server Management studio 2008 to validate the source and target systems
• Extensively executed T-SQL queries in order to view successful transactions of data between sources
• Tested the reports generated by (SSRS) SQL Server reporting services and checked as they are as per the Organization standards
• Clearly communicated and documented test results and defect resolution during all phases of testing.
• Used HP Quality center 10.0 as our defect tracking tool to upload test cases, track execution and defects.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity
• Tested complex objects to the universe to enhance the report functionality.
• Optimized the usage of user objects, conditions and universe level filters
• Involved in documenting the changes to the universe and reports functionality.
• Performed data validation by writing SQL queries and creating ad hoc reports using desktop intelligence and web intelligence
• Executed Informatica jobs from UNIX using CRON Tab.
• Involved in fixing the defects and data validation of reports for Partially Converted and Fully Converted Reports.
• Tested and maintained the Business Objects universe and reports
• Written several shell scripts using UNIX Korn shell for file transfers, archiving the existing files, catalog creation, error log creations and log file cleanup process.
• Evaluation of critical problems/issues during testing and reporting them in Quality Center.

Environment: Oracle 10g, TOAD, SQL Server 2008R2, SSIS, Informatica 7.x/SSRS, SQL Server Management studio 2008, Business Objects Enterprise XI R3.1, CRON TAB, Java Scripting, Business Objects Designer, HP Quality Center

Confidential, CA

Data Analyst

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• Used Quality Center 9.2 for writing Test Plan, Test Cases, test script, Test case execution and Defect Tracking
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Performed Data integration testing on extracted data from various sources like Oracle, flat files and SQL Server.
• Extensively worked on ATG web services
• Wrote complex SQL queries for querying data against different data bases for data verification process.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Scheduled the UNIX script from the CRONTAB
• Unit tested the mappings using SQL scripts.
• Tested mappings to load data into II slowly changing dimension tables.
• Suggested to create Oracle Indexes on some of the source tables
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Tested the reports generated in Hyperion interactive reporting by comparing the data against the source system
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Set up, monitored and used Job Control System in Development/QA/Prod.
• Worked with ETL group for understating mappings for dimensions and facts.
• Worked on issues with migration from development to testing.

Environment: Informatica Power Center 8.1 (Power Center Designer, workflow manager, workflow monitor), ODI, Hyperion Interactive Reporting 9, Mercury Quality Center 9.0, SQL *Loader, Oracle 9i, ATG WebService, Java scripting, SQL Server 2005, Erwin 3.5, Windows 2000, TOAD 7.

Confidential, CA

ETL / Backend Tester

Responsibilities:

• Created test cases and test plans for testing the ETL process and reports.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Data warehouse using complex SQL queries.
• Tested the entire reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Provided support to offshore QA team by giving them knowledge transfer and helping them in closing the defects by coordinating with the development team.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Conducted and coordinated with integration testing and regression testing.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Worked with the team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
• Prepared test data to cover all the test scenarios.
• Prepared UNIX scripts to run the Informatica ETL jobs from command line.
• Tested several business reports developed using Business Objects including dashboard, drill-down, summarized, master-detail & Pivot reports.
• Maintained all the test cases in Quality Center and logged all the defects into the defects module.

Environment: Oracle 8.0, Data Stage 6.x, SQL*Plus, SQL, Quality Center, Rational Clear Quest, Clear Case, SQL Server 2000, PL/SQL, Visual Basic 6.0, Windows 95, Test Director, XML, XSD, XSLT, Java and UNIX, Korn Shell scripting, PERL