SUMMARY

• Around 8 years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Expert in writing SQL queries and has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Extensive testing ETL experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager), AutoSys, Control M and Maestro.
• Worked in various Healthcare areas like Enrollment, Benefits, Claims, Medicare, and EDI X12.
• Hands on experience in configuration of claims adjudication systems, i.e., Facets, NASCO, QNXT.
• Experienced working for Data Migration, Data Extraction, Data Cleansing, Data Profiling, Data Consolidation, Data Standardization and Data Quality for various business data feeds.
• Proficient in using testing tools such as Quality Center, Win Runner, Load Runner and Quick Test Professional for web - based and client server applications.
• Hands on experience on ETL Micro Strategy tools in ETL process development, testing and in maintaining ETL codes.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Ab Initio & Informatica
• Solid Back End Testing experience by writing and executing SQL Queries.
• Extensively worked in all phases of testing includes Integration, System, Regression, Load, Stress and User Acceptance Testing (UAT).
• Experience in UNIX shell scripting and configuring cron-jobs for ETL Loads. Extensive experience with Reporting Tools like OBIEE, Cognos, Business Objects
• Experienced in running SQL, T-SQL, MDX using Toad and MS SQL Server
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Data Stage
• Worked as a consultant in delivering quality data centric solutions for various business domains
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Experience in testing XML files and validating the data loaded to staging tables. Experience in testing and writing SQL and PL/SQL statements.
• Excellent Communication, Analytical and Interpersonal skills.
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming.
• Experienced working with Excel Pivot and VBA macros for various business scenarios.
• Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time

TECHNICAL SKILLS

Requirement Gathering Tools: IBM Rational Requisite Pro, Quality Center/ALM, MS Excel

Modeling & Designing Tools: MS Visio 2010

Operating Systems: MS Windows7/XP

SDLC Methodologies: Agile/Scrum, Waterfall, Rational Unified Process (RUP)

Bug Tracking Tools: Quality Center, ALM 11.0

Data Bases: MS Access, Oracle, DB2

Software Packages: MS Project, MS-Office, MS SharePoint, MS Visio

ETL Tools: Informatica Power center, Ab Initio

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

Sr. ETL Tester

Responsibilities:

• Prepared Test Plan from the Business Requirements and Functional Specification. Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
• Tested to verify dat all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Tested both conditional formatting and threshold level testing for several reports developed in Micro strategy.
• Tested several business reports including Score Cards, KPI's, Summarized, Master-Detailed and Drill Down reports Reviewed developed by Micro strategy.
• Involved in extensive DATA validation using SQL queries and back-end testing. Involved in Front to Back testing for all European and Asia pacific regions
• As QA Tester, performing responsibilities with both the functionality and back end testing.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Created high level use case diagrams, process composition diagrams and data modeling
• Reviewed Informatica mappings and test cases before delivering to Client.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Written several UNIX scripts for invoking data reconciliation.
• Experienced in writing complex SQL queries for extracting data from multiple tables. Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution. Performed Functional, Regression, Data Integrity, System, Compatibility testing
• Extensively executed T-SQL queries in order to view successful transactions of data and for validating data in SQL Server Database.
• Build a customer data centric data warehouse to analyze transactions across finance, marketing, risk collections and consumer relations for the credit card division. Clean customer data warehouse successfully implemented on Oracle target, the data warehouse is growing in its analytical richness.
• Extensively used Informatica power center for extraction, transformation and loading process.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in dis project to write Shell Scripts and SQL queries. Used MDX to create calculated members in the cube
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center/ALM
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log. Used T-SQL for Querying the SQL Server database for data validation.
• Writing the test scripts for manual testing. Supporting presales activity for Data centric warehouse testing projects.
• Involved with ETL test data creation for all the ETL mapping rules. Preparing and supporting the QA and UAT test environments. Tested different detail, summary reports and on demand reports.

Environment: SQL, PL/SQL, UNIX, MDX, IBM AIX 5.5, DB2, TERADATA V2R6, SYBASE 12.5, Teradata SQL Assistant 6.0, putty, Shell Scripting, Micro Srategy 8.0.2, XML Files, VSAM COBOL Files, IBM, INFORMATICA 9.6, AUTOSYS, XML SPY 2010, ORACLE, TOAD 10, CA Erwin.

Confidential - Boston, MA

Sr. QA Tester/ETL

Responsibilities:

• Created Requirement traceability matrix. Generated Test Plan and Test Strategy based on the business requirement.
• Created test cases based on the test plan and uploaded to the test management tool. Worked with Quality Center for testing activities. Created test cases and test sets.
• Reported bugs and worked with developers to resolve defects. Involved in Smoke, SIT, Retesting, Performance testing and Regression test.
• Developed test cases to accomplish ETL data migration. Wrote data conversion and data migration scripts for ETL process
• Worked with DataStage Director to do job inventory and view job status. Used DataStage Director to verify jobs are running in GRID environment.
• Experience with DataStage Designer to view jobs sources, transformations and target database and the scripts.
• Experience working with the Parallel, Sequence and Server jobs in DataStage.
• Worked with the OSH scripts in DataStage Director to view the SQL scripts used by jobs.
• Performed functional testing for jobs dat were converted from Server jobs to Parallel jobs.
• Understood Data Models, Data Schema, ETL and created extensive store procedures, SQL queries to perform backend data warehousing testing
• Extensively used SQL tools like SQL Developer and SQL Plus to run SQL queries and validate data in source, staging and data mart.
• Analyzed the session logs and the audit tables to find the job elapsed time for staging and loading jobs.
• Ensured data integrity and verified all data modifications and calculations during database migration using ETL tools
• Extensively used UNIX commands to validate the Unix Script files and the parameter files.
• Extensively used the diff command in UNIX to find difference between files. Extensively used FC windows command to find the differences between tables.
• Participated in daily stand up meetings, weekly status meetings with offsite teams and offshore teams.
• Validated the Tidal jobs. Involved in Defect Triage Meetings and determine the priority and severity of bugs.
• Coordinated with the offsite and offshore teams and monitored junior test Analysts.

Environment: DataStage 8.7, DataStage Director, DataStage Designer, Oracle 10g, HP ALM, SQL Developer 3.2, UNIX, SQL Plus, Beyond Compare 3, Tidal, Windows.

Confidential, East Providence, RI

Automation QA Engineer

Responsibilities:

• Involved to create Business Risk Levels to determine Test Priorities.
• Analyzed Test Plans and Test Cases based on Requirements and General Design Documents, Involved in both Manual and Automation Testing.
• Performed Regression testing using Test Director. Extensively used SQL Queries to verify and validate the Database Updates.
• Used Test Director a workflow automation tool for defect tracking and product automation.
• Created User Defined Functions and procedures in Test Director Library to re-use them in Different tests.
• Performed data analysis and data profiling using SQL and Informatica on various sources systems Including Oracle and Teradata.
• Responsible for full testing life cycle, system testing and validating the Informatica mappings against the pre-defined ETL design standards.
• Designed and supported SQL Reporting services, Integration services and Analysis services. Created variety of reports from SSAS cubes
• Defining and performing the Test strategies and associated scripts for the verification and Validation of the application and ensuring dat it meets all defined business requirements and associated functionality.
• Designed the Load Runner scenarios with various user-mix incrementing in constant ratios, till the peak load is achieved.
• Working as Technical for QA on three different projects. One of the most important project was evaluating Automation Test Tool for QA. Evaluated Win Runner
• Tested SSRS reports based on SSAS Cubes and OLTP with drill through and drill down. Tested OLAP cubes and SSRS reports for various business needs.
• Worked with SSIS system variable, passing variables between packages. Tested the created SSIS packages to transfer data from various sources like Oracle, Excel,
• Created high level test cases and test procedures for Unit Testing on reinsurance and documented them.
• Created VUser scripts using Load Runner by recording, incorporating Transactions, and think time.
• Used Test Director to create test plans, gathering requirements, analyzing the results and reporting.
• Responsible for Reviews and documentation for reporting the status to the project manager.
• Played a significant role of QA testing at various stages of the project including Data Quality Testing, Data load Testing, Data Integrity testing, Business Objects Reports Testing etc.
• Tested Complex metrics, Nested Filters, Nested Prompts, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports.

Environment: Quality Center, SSIS, SSAS, SSRS, Test Director 8.0, Win Runner 5.0, Load Runner, Rational Clear quest, SQL Server, Teradata V5R12, UNIX and XML, Quality Center 9.0, QTP 9.0

Confidential - Madison, WI

QA Tester

Responsibilities:

• Prepared data mapping document for various data feeds for ETL to write and develop the data extraction routines.
• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Coordinated between offshore and onsite team and managed multiple OLAP and ETL projects for various testing needs.
• Extensively used Informatica for extraction, transformation and loading process. Debugging the SQL-Statements and stored procedures for various business scenarios.
• Performed extensive data validations against Data Warehouse. Logging and tracking defects on a release basis using HP Quality Center.
• Tested and validated the Report Net reports by running similar SQL queries against the source system(s).
• Created and implemented Micro Strategy reports by creating projects, schema objects and public objects, Attributes, hierarchies, metrics, filters, and templates.
• Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Performed MS SQL Server T-SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Trained the users before UAT on how to test and document the test results. Also, assisted the users during UAT. Took part in Triage Meetings with the required parties after defect analysis to prioritize defect resolution.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in dis project to write Shell Scripts and SQL queries.
• Tested Micro Strategy reports and written test cases using HP Quality Center.
• Tested and validated the cube data, ensuring dat the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
• Tested all the reports by running queries against the warehouse-using TOAD. Also compared those queries with the Micro Strategy SQL engine generated queries.
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Conditional testing of constraints based on the business rules
• Analyzed the Requirement Traceability Matrix, Daily Test Status reports, Weekly defects report, and Risk analysis by communicating with the Business Team.
• Defects were tracked and prioritized using Quality Center and analyzed the variation between expected result and actual result.
• Designing and creating new reports, freeform SQL reports in Micro Strategy
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Extracted certain column of data from a number to files using PERL.

Environment: Informatica, XML, XSLT, PERL, Micro Strategy, SQL Server, QTP, Quality Center 10.0, DTS, T-SQL, SQL, TOAD, Oracle, PL/SQL, IBM DB2, MS Access/Excel/Visio, UNIX Shell Scripting

Confidential - Chicago, IL

QA Tester

Responsibilities:

• Analyze functional and technical requirements for Data Warehouse Migration from Oracle to Teradata project to ensure precise translation of business requirements into technical solutions.
• Create / Design ETL specifications based on business requirements.
• Provided expert knowledge in the development and maintenance of system checks and balances to ensure data integrity and consistency.
• Designed templates for Source to target mappings, gap analysis and use case acceptance testing for structured execution of project tasks.
• Responsible for creating Test plan, development of test scripts, execution and validate Test results and document test evidence.
• Executed test cases, and test scenarios for User Acceptance (UAT), Functional and Regression test cases.
• Created user acceptance testing documents and reviewed them with the customer. Tested ETL jobs as per data mapping requirements.
• Involved in validating various Business objects reports for data quality and the lay out.
• Involved in communicating with support, business and development teams to resolve issues during test execution.
• Conducted reviews of test plans, test cases, and prepared test results.
• Effectively communicate testing activities and findings in oral and written formats.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to test business rules and security.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Provided status reports on test execution, and defects identified during testing.

Environment: DataStage, SQL, PL/SQL, Oracle, Toad, Teradata, Teradata SQL Assistant, SQL Navigator, Database Management Studio, Business Objects XI, Share point, UC4, UNIX, Putty, HP Quality Center.