SUMMARY:

• Over 7 years of extensive experience in Software Quality Assurance and Testing with strong knowledge 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 Scrum
• 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 the different teams members and the manager
• Validated insurance claims, customers’ records, and policy renewals data moving from operational data store to Enterprise data warehouse.
• Validated the market surveys functionality, both the front end and back end for gathering information about customers’ choice and preferences of insurance products and ongoing market trends in the insurance industry.
• Validated customized insurance programs functionality to suit the customer needs.
• Experience in testing/validating the Source, Stage and Target (End - to-End) data systems
• Experience 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
• 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 the requirements.
• Expertise in Defect Tracking, Defect management and Bug Reporting using tools like Clear Quest, Test Director, 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 the 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: Informatica Power 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

ROFESSIONAL EXPERIENCE

Confidential, Salt Lake City, Utah

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 the test scripts.
• Involved in gathering Functional Requirements, Business Requirements and Design Documents.
• Developed detailed Test Cases based on the Functional Requirements and Design Documents.
• Identified the test data to execute the test cases.
• Performed Functionality, Negative, Security, GUI, Integration, System and Database testing.
• Validated OBIEE Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs.
• Tested Ab Initio Batch and Continuous graphs and worked with transform, aggregate components, and partition/departition components, serial and multi file system, static lookup and dynamic lookup, read xml component, join, sort components.
• Tested Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Validated different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Extensively worked on RPD and Dashboards.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
• Designed Star schema for fact & dimensional tables and created alias for the dimensional tables when necessary.
• Validated Query Prompts as, Cascading Prompts, Calculations, Conditions & Filters
• Experienced using database query and integration tools such as TOAD, SQL plus etc.
• 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 the 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 the data loaded into Target
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Preparing and supporting the QA test environments

Environment: Informatica Power Center 9.1, Oracle 11g, HP ALM 11, SQL Server 2012, Oracle SQL Developer, Teradata, OBIEE 11g, XML, PL/SQL, SQL, WinSCP, Putty, TFS, UNIX, Toad, SharePoint, Windows Office

Confidential, Columbus, OH

Sr. ETL Tester | Reports Tester | Data Migration Tester

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 the tables and columns from which data is extracted
• Extensively involved in testing the ETL process of data sources, SAP, PeopleSoft, Oracle, flat files into the target SQL server, Oracle database as per the 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 the best test scripts.
• Responsible in testing Initial and daily loads of ETL jobs.
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Tested & developed the 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 the data loaded into Target.
• Done data validation, accuracy of calculated fields, Accuracy of the data shown, Selection criteria shown, Accuracy of subtotals for the SSRS reports.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Used SQL for Querying the database for data validation, data verification and data conditioning.
• Writing the test scripts, test cases & test plan for multiple ETL Feeds.
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Involving in Functional testing, Backend Testing, End to End testing and Regression Testing
• Involved in Preparing and supporting the 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: Quality Assurance, Agile, SQL Server 2008, Oracle 11g, XML, XSLT, XSLD, Flat Files, MS Excel, SQL, T-SQL, PL/SQL, SSIS, SSRS, SSAS, Toad, Clear Quest, Windows, UNIX, Clear Case, HP Quality Center 10

Confidential, MD

ETL Tester / Reports Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC).
• Validating the data passed to downstream systems.
• Used data stage director to run the jobs and check the log files.
• 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 the QA Lead and QA Manager
• Performed Integration Testing of different modules.
• Exclusively used Analysis Studio and Report Studio to test the 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 the 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: IBM Data Stage 8.1v, 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

Responsibilities:

• Validated SQL and stored procedures for the 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
• 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 the requirements.
• Involved in maintaining and first level troubleshooting of the database.
• Validated micro strategy reports according to the functional requirements.
• Analyzed and wrote logics, tests for software solutions involving database extraction
• Designed and implemented a new information database for supporting interfaces
• 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 2000, Micro Strategy, SQL, PL/SQL, Windows XP, JAVA Script, Win XP, MS Office Suite