SUMMARY

• Over 7+years of Professional Experience in Software Quality Assurance, Data Analysis and Testing in different environments and platforms.
• Well versed with various types Software Development methodologies - Waterfall, Agile, RUP, Iterative and Extreme Programming.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Good Knowledge on Business intelligence, OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process
• Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures, and free hand SQL. Automated and scheduled teh Ab initio jobs using UNIX Shell Scripting.
• Proficient in SQL, PERL, Shell Scripting and PL/SQL coding and experience in Performance Tuning of SQL.
• Autosys scheduling jobs
• Experience in testing Business Report developed in Cognos
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Well versed in GUI application testing, Database testing and Front-end testing.

TECHNICAL SKILLS

Data Warehousing: Informatica 8.6.1/8.1/7.1/6/5.1.1/1.75 , Data Stage 8.x, Ab Initio

Reporting Tools: Business Objects 6.5/XIR3, Cognos 8.0 Suite, Crystal Reports, SSAS, SSRS

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Testing Tools: Win Runner, Load Runner, Test Director, HP Quality Center, Rational Tools

RDBMS: Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2005/2008, UDB DB2, Sybase, Teradata V2R6, MS Access 2008

Programming: UNIX Shell Scripting, SQL, SQL*Plus, PL/SQL,C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, .NET, Java, J2EE, XML, XSD, XSLT

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Hyperion, Novell NetWare, Win 3.x/95/98, NT 4.0, Sun-Ultra, Sun-Spark, Sun Classic, and SCO

PROFESSIONAL EXPERIENCE

Confidential, Glen Allen, VA

Sr. ETL QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, solution specs and responsible for documenting functional requirements.
• Created test data for testing specific ETL flow.
• Performed data analysis and data profiling using SQL and Ab initio on various sources systems including Oracle and Teradata.
• Assisted in creating fact and dimension and star schema table implementation based on requirements
• Used PERL for automating all teh types of modules at a time.
• Tested and developed teh mapping for extracting, cleansing, transforming, integrating, and loading data using Ab inito.
• Created expected results for data based on mapping document and used SQL, Ab initio and crated compare reports for source to target.
• Worked on Ab initio to resolve production issues perform testing and debugging of graphs.
• Extraction of test data from tables and loading of data into SQL tables.
• Responsible for Data mapping testing by writing complex SQL Queries.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating teh data passed to downstream systems.
• Worked with data validation, constraints, source to target row counts.
• Developed automated Test Scripts.
• Used data conversion to protect teh data and prevent data loss.
• Strong in writing SQL queries and makes table queries to profile and analyze teh data.
• Formulate methods to perform Positive and Negative testing against requirements.
• Performed Verification, Validation, and Transformations on teh Input data (Text files, XML files) before loading into target database.
• Perform Functional, Data Validation, Integration, regression and User Acceptance testing.
• Used TOAD, SQL Server tools to connect to Oracle Database to validate data that was populated by ETL applications
• Involved in testing Unix Korn Shell wrappers to run various ETL Scripts to load teh data into Target Database (Oracle).
• Debug autosys jils, executed jobs to load test data. Check autosys and ab inito logs for failed jobs and report errors.
• Worked on Clear Quest to log defects and track resolution and communicated to teh developers using defect tracking tool till teh closing of defect after retesting.
• Created test cases and executed test scripts using Quality Center.
• Used Microsoft Excel and Word 2003 to document test status reports and teh Test Data.
• Perform Functional, Data Validation, Integration, regression and User Acceptance testing with large volume of data sets.

Environment: Ab initio, Oracle 11g, Autosys, Java, PERL, Teradata, UNIX, HP Quality Center 11.0

Confidential, Charlotte NC

Sr.ETL QA Tester

Responsibilities:

• Created test data for testing specific ETL flow.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata.
• Extracted certain column of data from a number to files using PERL.
• Worked on informatica to resolve production issues perform testing and debugging of mappings and reports Extraction of test data from tables and loading of data into SQL tables.
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating teh data passed to downstream systems.
• Worked with data validation, constraints, source to target row counts.
• Used data conversion to protect teh data and prevent data loss.
• Strong in writing SQL queries and makes table queries to profile and analyze teh data in MS Access.
• Formulate methods to perform Positive and Negative testing against requirements.
• Performed Manual Testing of teh application Front-End and Functionality. Identified teh critical test scripts to be automated.
• Performed Verification, Validation, and Transformations on teh Input data (Text files, XML files) before loading into target database.
• Monitored teh Informatica workflows using Power Center monitor. Checked session logs in case of aborted/failed sessions
• Used TOAD, SQL Developer tools to connect to Oracle Database to validate data that was populated by ETL applications
• Involved in testing Unix Korn Shell wrappers to run various ETL Scripts to load teh data into Target Database (Oracle).
• Worked on Clear Quest to log defects and track resolution till teh closing of defect after retesting.
• Created test cases and executed test scripts using Quality Center.
• Used Microsoft excel and Word 2003 to document teh test status reports and teh Test Data.
• Used Quality Center to track and report system defects.

Environment: Informatica 8.6, Informix, DB2, Java, Business Objects XIR2/6.5, SQL, SQL Server 2000/2005, Teradata UNIX, HP Quality Center 10.0

Confidential, Orange County, CA

ETL QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.2
• Tested ETL jobs as per business rules using ETL design document
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Expert in writing Complex SQL/PLSQL Scripts in querying Teradata and Oracle.
• Defined data requirements and elements used in XML transactions.
• Involved in teh testing of Data Mart using Power Center.
• Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
• Involved in Preparing Test Plan for Med Pharmacy Claims to FACETS
• Developed Test Cases bases on Functional Specifications and Design Documents for Med Pharmacy Claims to FACETS
• Followed teh Mapping documents and HIPAA implementation guides for HIPAA Transaction Mapping
• Involved in processing claims in FACETS and validating teh full cycle process to make sure teh checks are generated and 835’s are generated.
• Extensively used Informatica Power Center for Extraction, Transformation and Loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Extensively used Teradata load utilities Fast load, Multiload and FastExport to extract, transform and load teh Teradata data warehouse
• Tested complex objects to teh universe to enhance teh report functionality.
• Tested ad hoc and canned reports for Business objects.
• Tested Business Objects reports and Web Intelligence reports
• Worked in an Agile technology with Scrum.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Queried Teradata Database and validated teh data using SQL Assistant.
• Effectively distributed responsibilities, arranged meetings and communicated with team members in all phases of teh project.
• Used import and export facilities of teh application to download/upload XMLs of failed test cases so as to re-verify.
• Scheduled teh jobs using Autosys and automated teh jobs to be ran at specific time and automated teh reports.
• Writing UNIX scripts to perform certain tasks and assisting developers with problems and SQL optimization.
• Converted SQL queries results into PERL variable and parsed teh same for multiple reasons.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries
• Performed Unit testing and System Integration testing by developing and documenting test cases in Quality Center.
• Did Unit testing for all reports and packages.
• Designed and developed UNIX shell scripts as part of teh ETL process, automate teh process of loading, pulling teh data.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used Query Studio to test ad hoc reports
• Responsible for migrating teh code changes from development environment to SIT, UAT and Production environments.
• Validated cube and query data from teh reporting system back to teh source system.
• Tested analytical reports using Analysis Studio.

Environment: Informatica 8.6,Erwin 4.0, DTS, MS SQL Server 2008, Oracle 10g, Teradata SQL Assistant, Business Objects XIR2/6.5, COBOL, QTP 9.0, HP Quality Center 10, UTL FILE, TSO, ISPF, OS/z, JCL, Mainframes, Toad, Unix Shell Scripting, Windows XP/2000

Confidential, Farmingdale, NY

QA Tester

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Wrote complex SQL queries for querying data against different databases for data verification process.
• Designed teh data flow diagrams using MS VISIO.
• Prepared teh Test Plan and Testing Strategies for Data Warehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Followed teh Mapping documents and HIPAA implementation guides for HIPAA Transaction Mapping.
• Involved in testing HIPAA EDI Transactions and mainly focused on 837 and 835.
• Involved in Data mapping to/from legacy to Facets that will be used to populate teh oracle database
• Involved in testing HIPAA EDI Transactions and mainly focused on 837 and 835
• Used Foresight Desktop Validator for HIPAA IG validation.
• Written test cases to test teh application manually in Quality Center and automated using Quick Test Pro.
• Worked with SSIS system variable, passing variables between packages.
• Created cascading prompts at teh universe level. These cascading prompts were used within full client and thin client reports to narrow down teh selection parameters.
• Tested different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Developed automated test scripts from manual test cases for Regression testing based on teh requirement documents using Quick Test Professional.
• Written Test Plans and Test Cases on Mercury’s Test Director Tool.
• 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.
• Designed and supported SQL 2000 Reporting services, Integration services and Analysis services.
• Creating test cases for ETL mappings and design documents for production support.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Scheduling and automating jobs to be run in a batch process.
• Effectively communicate testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using Test Director 6.5
• Extensively used Informatica power center for Extraction, Transformation and Loading process (ETL).
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
• Compared teh actual result with expected results. Validated teh data by reverse engineering methodology i.e. backward navigation from target to source.

Environment: SAS/Base 8.1, SAS/Macros, SAS/ETL, PERL, UNIX Shell Scripting, Informatica Power Center 7.1 (Power Center Designer, workflow manager, workflow monitor), QTP 7.2, SQL *Loader, Cognos 7.0, Oracle8i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7, Business Objects 6.1, Teradata V2R4