PROFESSIONAL SUMMARY:

• 9+ years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, MarkLogic, Client/Server applications
• Experience using query tools for Teradata, Oracle, IBM DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Strong experience in Banking, Financial and HealthCare domains.
• Represent QA in all phases of product development including requirement, Analysis, design, construction, testing, implementation, code reviews and support.
• Experience in analyzing Business Requirement Document (BRD), Functional Requirement Specification (FRS) and assisting in developing TEST PLAN.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Expertise in developing Software Test Plans, Test Case Design and Test Scripts based on User Requirements Specification (URS) and System Requirements documents.
• Proficient in writing SQL queries to perform data driven tests and involved in front - end and back-end testing. Strong knowledge of RDBMS concepts. Developed SQL queries in Oracle database to conduct DB testing.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using ETL tools like Informatica and Data Stage
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos 8.0 Series and Business Objects XI R2
• Strong in writing UNIX shells scripting. Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Experience in working as a liaison between the team members and the manager.
• Expertise in writing SQL queries, PL/SQL Stored Procedures and Triggers
• Experience in testing/validating the Source, Stage and Target (End-to-End).
• Expert in analyzing the error caused to failure of the ETL load with reference to the log file and report them to the corresponding team to get it rectified.
• Strong knowledge of working with Data Marts (Star Schema and Snowflake Schema).
• Worked with PERL for file manipulations
• Converted SQL queries results into PERL variable
• Experience with Mentoring and Coordinating a team of QA resources, Identifying and Managing Risks, Estimating Work, Resource sharing between the projects, tracking project
• Progress, Delivering projects as per the deadlines.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.1/8.1 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor),Parallel Extender, Data Mining, EME, Data Profiler, SSIS, Ab Initio, Data Stage

Test Mgmt Tools: Test Director, HP Quality Center, Rational Quality Manager

Mercury Interactive: QuickTest Pro 11/10/9.5, WinRunner 9.2/9.0/8.0/7.5 , LoadRunner 9.2/9.0/8.0, Test Director 8.0, Quality Center 10/9/8.2, HP ALM 11

Bug Reporting: Rational Clear Quest, Test Director, MS Access, Bugzilla.

Programming Languages: SQL, PL/SQL, T-SQL, XML, XSLT, PERL, Shell Scripting.

Operating Systems: Windows Vista/ XP/NT/2000, AIX UN IX, LINUX

Databases: Oracle 10g/9i/8i/7.3, MS SQL Server 6.5/7.0/7.5/2005 , IBM DB2, Teradata V2R6

Web Development: MarkLogic, HTML, XML, VBScript, JavaScript, XSLT

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, CT

SQL/ETL/ Data Warehouse QA Analyst

Responsibilities:

• Validate different sources that is coming from CDNI using SQL Server.
• Run Squid reports against the transformed files for Data Quality.
• Validate Mapping document and the Mapping rules.
• Validating the data passed to downstream systems.
• Experienced in writing test plan and creating defect metrics.
• Involved in code migration from test to production (QA sign off process).
• Responsible to provide the management with status reports and updates.
• Responsible for providing the QA effort estimate and capacity planning of new initiatives in pipeline.
• Work with business users, system analysts, designers and programmers to create and analyze various required project documents.
• Participate in production implementation verification and being accountable for validating system quality.
• Responsible for leading the offshore team of 5 QA resources.
• Responsible for error reporting, maintaining and tracking of defects with SDS tracker.

Confidential

SQL/ETL/ Data Warehouse Tester

Responsibilities:

• Involved in testing XML using XQuery.
• Development and testing of API’s.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.
• Monitor all processes to ensure there are not any gaps.
• API testing using SOAP UI.
• Help ensure team members are following processes and meeting expectations.
• Track and report out of compliance behavior.
• Conduct analysis and trending on the findings and provide feedback to the field by Data Quality (DQ).
• Assess any newly discovered defects/concerns.
• Provide coaching and training to lower level analysts.
• Analyze and dissect system requirements and technical specifications to create and execute test cases for large business initiatives
• Ability to write test cases and execute testing within a web service environment.
• Product test and driving defect resolution.
• Assist business users in defining User Acceptance Testing, test cases and plans.
• Establish and maintain test cases and test data.
• Create and maintain test cases in Quality Center and / or Test Directory.
• Actively participate in walk-through, inspection, review and user group meetings for quality assurance.
• Plan, document, evaluate and track testing results to ensure system applications are free from defects.
• Experienced in using Talend and Bed Rock ETL tools for running and monitoring jobs in Test environment.
• Communicate and interact with appropriate areas on problems, changes and enhancements that may impact data, workflow and / or functionality within Information Technology software.
• Comply with standards of the software development life cycle and follow strategies, plans and procedures within information Technology software.

Environment: Oxygen 17, Bedrock, Query Console, SQL Server 2005, HP QC/ALM, SQL/PLSQL, Rally, XSLT, XML, XSD, UNIX, Windows 7, SDS Tracker, Microsoft SQL Server

Confidential, Dallas TX

SQL/ETL/ Data Warehouse Tester

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Created test plan and test cases from the business requirements to match the project’s initiatives in HP ALM.
• Analyzed trading partner specifications and created EDI mapping guidelines.
• Wrote MACROS in Teradata to generate less channel traffic and easy execution of frequently us SQL operations and improves the performance.
• Work with source system personnel on source data delivery issues .Interacted with DBA for setting up test environment.
• Performed Data Mapping around EDI transactions
• Assisted in promotion of Informatica code and UNIX Shell scripts from UAT to Production.
• Ran workflow monitor to monitor job and workflow manager to run the job in Informatica .In case of error in ETL job, used to record log failure details and report it to developer in order to debug the defect.
• Used DataStage to move data to the warehouse using the stored Procedure thereby enabling faster moment of data.
• Developed UNIX scripts and AUTOSYS scripts to load extract files in to staging tables using solder.
• Tested PL/SQL Packages to transform/load the staging data into schema using business logic.
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
• Performed database validation according to the business logic by comparing the source to the target in Spreadsheet.
• Created Jobs to Schedule multiple reports in Cognos Connection.
  • Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Worked with Users to develop Test cases for user acceptance testing.
• Maintained the test logs, test reports, test issues, defect tracking using Quality Center.
• Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.

Environment: Informatica 9.1, Oracle, OLTP, OLAP, Teradata V2R6, SQL Server 2005, HP QC/ALM, SQL/PLSQL, Cognos 9.0, XML, XSLT, XML, UNIX, Windows 7

Confidential, Roseland NJ

SQL/ETL/ Data Warehouse Tester

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Validated the data on the application against the source system Teradata using SQL queries.
• Based on the design specification and business requirements determined the scope of the testing.
• Involved in developing Test Plans and developed various test scenarios and test cases with input from assigned Business Analyst and data architect.
• Report accurate testing status and test summary reports.
• Followed waterfall and AGILE development methodology and adhered to strict quality standards in requirement gathering.
• Coordinated component, System testing with appropriate technical groups and release management and documented testing procedures and findings.
• Worked on the web services to verify the data returned by XML.
• Extensive experience in Functional, system, Integration, Regression Testing, User Acceptance Testing.
• Loaded the data into the Teradata database using Load utilities like (Fast Load, and Multi Load).
• Worked with data validations, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Worked on data loading (ETL) from Oracle, Siebel and Flat Files to D.W.H using Work-flow Monitor.
• Interacted with Users to understand the bugs in Business Reports generated from OBIEE.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Developed test reports and participated in testing prioritization and archived test results and user signoff.
• Reported bugs and tracked defects using Mercury Quality Center 10.0.
• Maintained the Traceability Matrix between Project release, Requirements, Design Components, Test Cases and Defects.
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.

Environment: Oracle 10g/11g, TOAD 9.0, AQT, VersionOne, IE 8, Windows 7, SQL, FTP Pro, Putty, Informatica 9.0, MS Excel, MS Word, MS Outlook, MS Lync, Mercury Quality Center

Confidential

ETL/SQL Test Engineer

Responsibilities:

• Created Test Case documents in MS Excel template from the Test Plan, and the Business Requirements documents.
• Experience in ETL Data Warehousing, database testing using DataStage for Workflow process.
• Testing ETL sessions and PL/SQL scripts for multiple feeds and multiple LOBS’.
• Exported Manual Test Cases from MS Excel template directly to Mercury Test Director and executed 100% of the Test Cases in Test Director with Pass/Fail/Blocked status.
• Performed database integrity check using SQL and Unix Shell Scripts
• Updated QA Manager and Lead weekly with the testing status, which included Test Task Plan, Defect Management, and Test Metrics
• Executed SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.
• Verified correctness of data after the transformation rules were applied on source data.
• Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments.
• Worked on DataStage Version Control Tool for Migrating jobs from one environment to another environment.
• Used Data Stage to move data to the warehouse using the stored Procedure thereby enabling faster moment of data.
• Used Mercury Quality Center to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team
• Participated in frequently held Defect Meetings which included Project Management, QA, Development, and Business Line teams and submitted weekly defect and test status updates during the Defect Management meetings
• Performed Functional, Regression, Data Integrity, and User Acceptance Testing including GUI testing
• Executed test cases for data validation, link verification, and content verification.
• Scripts have been written for both Batch mode which will write results to the individual called test and Interactive (non-batch) mode which will write to the main test
• Performed the back end testing by using SQL Queries and verified the data integrity.
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.
• Participate in weekly meeting with the management team and walkthroughs.

Environment: Data Stage 8.0/7.X/6.X,DB2,Oracle,Windows NT/XP/2000, XML, XSLT, XSD, Autosys, SQL Server 2000, Test Director, Clear Quest, MS Office Suite, SQL,PER

Confidential

QA Analyst

Responsibilities:

• Involved in Defining, and Analyzing the Testing Requirements based on the Application Functionality.
• Gathered test data requirements for data conditioning from Business Units to test total application functionality.
• Conducted Test Plan walkthroughs and wrote test scripts for manual testing.
• Created test scenarios for System testing and Regression testing.
• Performed Cross browser testing.
• Prepared Test Plans, Test Cases for both positive and negative scenarios and mapped the same to requirements in Quality Center.
• Preparing and running of Automated Test Scripts Using the Quality Center.
• Executed test scripts and analyzed the test results.
• Used Team Track tool for defect tracking.
• Tested Automobile, Homeowners, and Dwelling Fire and Workers Compensation applications finally checking the accord (pdf) applications.
• Worked on Insurance Modules pertaining to Commercial and Personal lines.
• Involved in testing the Property and Casualty Insurance pertaining to Small Business, Large Business.
• Worked on Electronic Bill Payment applications when select the Electronic Bill Payment as the Payment type in the Pay Plan.

Environment:  Win Runner 7.0, Test Director 7.6, Oracle7, Windows NT 4.5, PL/SQL, Oracle, SQL Server 2000, UNIX.