SUMMARY:

• Over 8 years of extensive experience in Software Quality Assurance and Testing with strong noledge of Software development life cycle (SDLC) and Software Testing Life Cycle (STLC)
• Hands on experience in analyzing Business Requirement, Functional Requirement, Design specification and developing Test plan and Test scenarios
• Hand on experience in Functional testing, Integration testing, System testing, Regression testing and End to End testing
• Experience in financial application testing such as Insurance, Banking, Health and web applications integrated with various legacy systems
• Extensive experience in all testing methods including Waterfall, Spiral, V model, Agile and Scrump
• Expertise in creating/developing Test cases, Test scenarios using standard and modular approach
• Experience in working as a single point of contact for all testing activities and as liaison between teh different teams members and teh manager
• Experience in testing of Data Warehouse/ETL Applications developed in Informatica, Data stage using SQL Server, Oracle, DB2, and UNIX. Ability to evaluate ETL/BI specifications and processes
• Expertise in writing simple and complex SQL queries using TOAD, SQL Navigator
• Comfortable in working with fixed length, delimited flat files and also worked with large volume of data in teh database/data warehouse
• Experience in writing test cases/ test scripts for Inbound and Outbound ETL processes and interfaces with other systems and streams
• Validated insurance claims, customers’ records, and policy renewals data moving from operational data store to Enterprise data warehouse.
• Validated teh customer complaints web pages within stipulated time period.
• Validated teh market surveys functionality, both teh front end and back end for gathering information about customers’ choice and ps of insurance products and ongoing market trends in teh insurance industry.
• Validated customized insurance programs functionality to suit teh customer needs.
• Experience in testing/validating teh Source, Stage and Target (End - to-End) data systems
• Experience in analyzing teh error caused to failure of teh ETL load with to teh log file and report them to teh corresponding team to get it rectified
• Familiar in working with Quality Center to store Business Requirements, Test Cases, Test Runs, and Test Results for every iteration and store defects and link them back to teh requirements.
• Expertise in Defect Tracking, Defect management and Bug Reporting using tools like Clear Quest, TestDirector, Quality Center
• Experience in testing/validation of Actuate reports, Business standard and ad hock reports
• Experience in End-to-End testing of an application/process. Performed backend testing using SQL Queries and UNIX scripting
• Experience in creating & scheduling teh jobs using Autosys
• Ability to work as independent and team member in challenging and cross platform environment
• Highly motivated team player with excellent analytical, problem solving, interpersonal and communication skills

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g, DB2, Teradata V2R6/V2R5, SQL Server 2005/2008

ETL Tools: InformaticaPower Center, Ab Initio, Data Stage, SSIS

Operating System: Windows, UNIX (Solaris)

Scripting: UNIX Shell Scripting, PL/SQL scripts

RDBMS Load Tools: SQL Developer, SQL * Plus (Oracle), T-SQL (SQL Server)

Reporting Tools: Business Objects, Cognos, Micro Strategy, SSRS, SSAS

Database Tools: TOAD, SQL Developer, Rapid SQL

Languages: SQL, PL/SQL, T-SQL

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. ETL | BI Reports QA Analyst | Data Analyst

Responsibilities:

• Involved in various meeting like project kick-off, project planning, weekly & monthly client status meetings,
• Involved in writing and reviewing teh test scripts.
• Involved in gathering Functional Requirements, Business Requirements and Design Documents.
• Developed detailed Test Cases based on teh Functional Requirements and Design Documents.
• Identified teh test data to execute teh test cases.
• Performed Functionality, Negative, Security, GUI, Integration, System and Database testing.
• Experience with Oracle environment using SOA suite.
• Extensively testing SOA services and test automation.
• Ability to Test and execute SOA services functional tests.
• Tested teh entire ETL logic using Informatica to enable initial load and incremental processing from SQL Server and Oracle, error strategy and exception handling, restart ability and recovery, data cleanup, validation and monitoring.
• Compared and Tested Source data.
• Extensively used Informatica Workflow Manager to run teh workflows.
• Monitored teh session logs/log files in Informatica Workflow Monitor.
• Tested teh ETL Informatica mappings and other ETL Processes (DW Testing).
• Extensively tested teh data validations and profiling using IDQ.
• Validated several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both teh Informatica Power Center and IDQ.
• Validated Reports using most of teh Cognos Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up). Tested Cascading Prompts and Multi Level Prompts on Dashboards.
• Validated teh Dashboard reports using Cognos Report Studio and Metric Studio.
• Validated Drill- through reports and Customized Reports with Prompts (List. Cross tab).
• Identified issues, performance bottlenecks, and optimized teh Business Intelligence Dashboards and Reports.
• Validated different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
• Designed Star schema for fact & dimensional tables and created alias for teh dimensional tables when necessary.
• Performed Functional and Performance Testing on Property and Casualty Modules.
• Validated Query Prompts as, Cascading Prompts, Calculations, Conditions & Filters
• Analyzed and tested Informatica Mappings with OLTP source data, staging and target data.
• Involved VSAM/SAM files on Mainframe systems.
• Extract teh data from Mainframe systems to Oracle database.
• Experienced using database query and integration tools such as TOAD, SQL plus etc.
• Extensively tested teh data validations and profiling done by data flux. Involved in testing teh error files, Ack, Nack, Frequency reports generated by data flux.
• Experienced in data analysis using SQL, TQL, PL/SQL and many other queries based applications.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Reported bugs and tracked defects using Quality Center.
• Developed teh Test Scripts and Test Cases in Quality Center..
• Error handling and performance tuning in Teradata queries and utilities.
• Data reconciliation in various source systems and in Teradata.
• Extensively used SQL to verify and validate teh data loaded into Target
• Submitted weekly bug or issue report updates to teh Project Manager in teh form of teh QA Error Log.
• Preparing and supporting teh QA test environments

Environment: Informatica Power Center 9.1,Informatica IDQ,DVO, Oracle 11g, Quality Center 11, SQL Server 2008, SQL Developer, Teradata, Cognos 10, XML, PL/SQL, SQL, WinSCP, Putty, TFS, UNIX, Toad, SharePoint, Windows Office

Confidential, Chicago, IL

Sr. ETL Tester / Data Analyst

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Written SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying teh tables and columns from which data is extracted
• Tested Ab Initio graphs for various ETL data mapping requirements.
• Extensively involved in testing theETLprocess of data sources, SAP, PeopleSoft, Teradata, SQL Server, Oracle, flat files into teh target Teradata, Oracle database as per teh data models.
• Experienced using database query and integration tools such as SSIS, TOAD, SQL Plus etc.
• Involved in testing SSIS Packages, and in Data Migration.
• Tested SSIS packages according to business requirements and data mapping requirement documents.
• Obtained detailed understanding of data sources, Flat files & Complex Data Schemas in order to write teh best test scripts.
• Extensively ran teh Ab Initio graphs, monitored teh log files and involved in find teh root cause of teh failures.
• Responsible in testing Initial and daily loads of ETL jobs.
• Interacted with design team to decide on teh various dimensions and facts to test teh application.
• Tested & developed teh mapping for extracting, cleansing, transforming, integrating & loading data using Autosys.
• Experienced in data analysis using SQL, TSQL, PL/SQL and many other queries based applications.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Reported bugs and tracked defects using Clear Quest.
• Extensively used SQL to verify and validate teh data loaded into Target.
• Done data validation, accuracy of calculated fields, Accuracy of teh data shown, Selection criteria shown, Accuracy of subtotals for teh SSRS reports.
• Validated teh reports using Cognos 8.3 Report Studio, Analysis Studio reports.
• Validated teh multiple reports using various templates like list reports, cross-tab reports and chart reports.
• Performance tuning by analyzing and comparing teh turn around times between SQL and Cognos.
• Performed teh tests in both teh SIT, QA and contingency/backup environments
• Used SQL for Querying teh database for data validation, data verification and data conditioning.
• Writing teh test scripts, test cases & test plan for multiple ETL Feeds.
• Submitted weekly bug or issue report updates to teh Project Manager in teh form of teh QA Error Log.
• Involving in Functional testing, Backend Testing, End to End testing and Regression Testing
• Involved in Preparing and supporting teh QA test environments
• Load new or modified data into back-end database.
• Defect Triage with Development team.
• Involved in peer review of test cases.

Environment: Ab initio 2.14, SQL Server 2008, Oracle 11g,Cognos8.3, Teradata V2R6/V2R5, XML, XSLT, XSLD, Flat Files, MS Excel, SQL, TSQL, PL/SQL, SSIS, SSRS, SSAS, Toad, Clear Quest, Windows, UNIX, Clear Case, Quality Center 10, Remedy

Confidential, Bethesda, MD

ETL Tester / Data Analyst

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC).
• Validating teh data passed to downstream systems.
• Used data stage director to run teh jobs and check teh log files.
• Responsible for testing teh Quote & Purchase for Health Insurance of teh customers.
• Involved in validating SSIS and SSRS packages according to data mapping specifications.
• Involved in validating SSAS cubes according to functional specifications.
• Validated SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Involved in Testing SSIS Packages, and also involved in Data Migration.
• Reported periodic project status and updates to teh QA Lead and QA Manager
• Performed Integration Testing of different modules.
• Exclusively used Analysis Studio and Report Studio to test teh Cognos Reports.
• Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed,Drill down
• Validated Multi-Dimensional cubes using Power Play transformer
• Validated Query Prompts, Cascading Prompts, Calculations, Conditions & Filters
• Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection
• Analyzed Business Requirements and Developed teh Test Scripts and Test Cases
• Used Quality Center for Bug Reports and Defect Tracking.
• Performed Risk Analysis based on Defect Severity and Priority.
• Tested User Interface inconsistency and application functionality.
• Worked on issues with migration from development to testing.
• Tested application in various browsers.

Environment: Data Stage, DB2, Oracle 10g, XML, Cognos, Flat Files, MS Excel, SQL, TSQL, PL/SQL, SQL Server 2008/2005, SSIS, SSRS, Toad, Clear Quest, .Net, C#, Quality Center, Windows, UNIX

Confidential, San Francisco, CA

ETL QA Analyst / Reports Tester

Responsibilities:

• Prepared Test Plans and test scenarios by understanding and analyzing business requirements.
• Developed Test cases, Test scripts from teh data mapping documents, functional Specification documents.
• Mapped teh test cases with teh requirements for generating teh Requirement Traceability Matrix (RTM).
• Worked on all teh stages of SDLC for dis project and designed and executed Functional, Integration, Regression, and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing.
• Developed and executed test cases and test scripts.
• Involved in testing teh UI screens, reports which was used by teh internal business team.
• Prepared Test Scenarios by creating Mock data based on teh different test cases.
• Involved in testing teh functionality of Ab Initio Graphs.
• Tested teh PL/SQL procedures, functions, packages according to teh requirements.
• Involved in testing teh batch programs by using teh Autosys tool.
• Exclusively tested teh inbound and outbound batch jobs.
• Involved in writing as well as testing teh UNIX shell scripts.
• Used HP Quality Center as test management tool.
• Tested Business Objects Reports according to teh business requirements.
• Prioritized teh test cases based on teh projected metrics and project deadlines.
• Worked with Developers on Defects until teh test case is passed.
• Extensively written SQL to confirm teh data transfer from source to target.
• Verified test results (viewing teh log files using VI editor, querying teh database using teh SQL) documenting teh defects.
• Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities.

Environment: Ab Initio, HP Quality Center, Business Objects, Rational Clear Case, Clear Quest, TOAD, JCL, Web Logic, MS Access, Oracle 9i, SQL, PL/SQL, UNIX, Putty

Confidential, San Francisco, CA

ETL Tester

Responsibilities:

• Validated SQL and stored procedures for teh data warehousing application projects.
• Documented business requirements by facilitating sessions between business and technical team
• Involved in systems design and implementation of standardized business processes
• Generated and compiled reports based on findings with probable causes and possible solutions tosystemsissues
• Extensively used Joins in order to get records from different tables
• Validated Triggers that are implemented to enforce Integrity constraints, Cursors for data extraction and to carry out updates of new fields, and exceptions for run-time error handling.
• Validated Informatica workflows and mappings against teh requirements.
• Involved in maintaining and first level troubleshooting of teh database.
• Analyzed and wrote logics, tests for software solutions involving database extraction
• Designed and implemented a new information database for supporting interfaces
• Ensured accurate data transfer from sources into teh newly designed system
• Validated PL/SQL stored Procedures used for customers placing regular orders
• Coordinated with other technical teams to ensure compatibility with other modules and applications
• Consulted with users and stakeholders to ensure that requirements are met
• Familiarized with software development lifecycle and configuration management

Environment: Informatica, Oracle 8i, SQL Server 2003, SQL, PL/SQL, Windows XP, MS Office Suite, Test Director