SUMMARY

• 7+ years of experience in requirement gathering and analysis, ETL testing, BI testing, Backend Testing, change management and system testing application various sectors like Financial, Brokerage, Banking, Trading and insurance.
• Extensive knowledge of the Software Development Life Cycle (SDLC) models/frameworks including the Rational Unified Process (RUP), Rapid Application Development (RAD), Agile Process.
• Adept at working with the quality analysis team to create test plans, test cases, test scripts, facilitating User Acceptance Testing (UAT) and ensuring timely resolution of defects
• Experienced with both ETL and BI testing.
• Highly skilled at creating page mock - ups and wire frames to illustrate the functionalities of the product.
• Experience in testing Business Report developed in Business Objects XIR2
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica and Ab Initio using Oracle, DB2, Teradata and UNIX.
• Extensive experience in SQL Performance Tuning.
• Experienced in writing complex SQL queries for data validation for both ETL and BI testing.
• Expert in DTS, SSIS, SSRS, SSAS testing for various business scenarios.
• Hands on experience on ETL MicroStrategy tools in ETL process development, testing and in maintaining ETL codes.
• Good Knowledge on Business intelligence, OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process
• Experience in loading from various data sources likeOracle,DB2, SQL Server, Fixed Width and Delimited Flat Files, MS Access, COBOL files &XMLFiles.
• Tested Transformed data from various sources like excel and text files in to reporting database to design most analytical reporting system.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica 9.6.1(Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) as ETL tool on Oracle, DB2 and SQL Server Databases.
• Experience in writing Test cases based on Business Requirements and Technical Specifications.
• Experience in Business Intelligence testing in various reports using Cognos, Business Objects.
• Widespread experience in the financial services industry including fixed income, equities, mutual funds, investment banking, brokerage, foreign exchange, retail banking, risk, and wealth management on large and small scale projects
• Worked extensively in UNIX (AIX) and Linux environment, used Shell Scripts for automating batch transfers, table space management, automated backup, user group maintenance, security and custom report generation.
• Expertise with scripting languages: SQL, Teradata stored procedures, Oracle PL/SQL, VB script.
• Extensive experience in preparing test requirements, test plans, test cases, test defect reports, and performing Black Box, Regression, Integration and User Acceptance testing.
• Adept in reviewing Test Procedures, creating Test plans, Test Scenario, defining System & Integration Test Cases, executing Test Cases, Test Data reviewing and maintaining and executing detailed Test scripts for User Acceptance Testing (UAT), analyzing bugs, interacting with team members in fixing errors and UAT and also assisted in Post - Production support. Worked on Black box and White box Testing.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, T-SQL, C, C++, Java

Web Programming: HTML, XML,JSP, Java Script

Testing Tools: Quick TestPro9.5/9.2/8.0, LoadRunner9.2/9.0/8.0, Rational Clear Quest, TestDirector9.0/8.0/7.5, Quality Center 9.2/8.2

Databases: MS SQL Server 2000/2005/2008/2008 R2, MS Access, MS Excel, My SQL, Oracle 8i/9i/10g, Toad 8.0/9.0, Oracle SQL developer 1.1.3, DB 2 8.0/7.0/6.0, Teradata V2R6, IBM DB2.

Software Applications: Microsoft Suite (Word, Excel, Power Point Access), Adobe Photoshop.

Operating Systems: MS Windows 2003/2000/XP /Vista, Windows 95/98, UNIX

Reporting Tools: SSRS, Business Objects XIR2, Micro strategy, Cognos Series 8.0, Crystal Reports, OBIEE

ETL Tools: SSIS 2005/2008, Informatica 8.6/8.2, Data stage 7.2, 8.0,Abinitio GDE( Graphical Development Environmental ) 1.13, 1.14Co-operative System 2.13, 2.14, 2.15.

PROFESSIONAL EXPERIENCE

Confidential, WINDSOR MILL, MD

SR ETL/BI TESTER

RESPONSIBILITIES:

• Extensively used SQL programming in offshore team of 6 people and Liaised between Technology, Business & QA
• Informatica PowerCenter - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Maintained the test logs, test reports, test issues, defect tracking using Quality Center.
• Tuned database and SQL statements and schemas for optimal performance.
• Expertise in SQL queries for the cross verification of data.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Testing of Business Objects and Reports which Includes, Database Connectivity, Tested objects in the Universe to ensure the correct mapping of the objects, tested the Universe s Structure to ensure that tables are properly uploaded; Tested the aggregate Universe to ensure the query is pulling correct level of Aggregation.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Performed SQL queries in the TOAD and ensured Correct Data Retrieval
• Test scripts developed in QTP 10 and maintained in HP Quality Center 9.2
• Created change request for the change in functionality and gave it to offshore team to get the impact on the project and effort required to implement the change.
• Created SQL statements to validate the data tables. Developed test scripts in SQL to check the data integrity from the databases.
• Tested reports for various portfolios using universe as the main data provider.
• Tested graphical representation of reports such as Bar charts, Pie charts as per End user requirements.
• Extended the functionalities of existing ETL process of Medicaid for Medicare.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Designed, Developed and unit tested the ETL process for loading the Medicaid/Medicare records across STAGE, LOAD and ACCESS schemas
• Tested Desktop Intelligence and Web Intelligence reports.
• Involved in TRR (transaction recurring process) will create a new member record or update an existing member record to identify members who receive a TRC 11 without an additional TRC 307 on the same TRR as Voluntary and members who receive both TRC 11 and TRC 307 on same TRR as Passive Enrollments.
• Extensively Worked in Processing Structured and Unstructured data
• Involved in developing the test strategy and assisted in developing test plans, test case objectives and test cases. Developed Test scenarios, to be used in testing based on business requirements, technical specification and/ or product knowledge. Tested application and reported bugs to the development team using mercury quality center. Streamlined and coordinated the bug and defect tracking and rectification effort.
• Extensively worked and involved in Voluntary enrollments Maximus P35 Daily and P34 Monthly file will update records created by the TRR much like the Maximus Daily 834 for MMAI (Medicare and Medicaid) except will use P35 and P34 file formats.
• Performed Black Box Testing. Performed GUI testing and user acceptance testing (UAT).
• Entered and implemented stored procedure changes to the production DB.
• Worked with HIPPA 5010 for reduces risk and provides flexibility and complete bi-directional transaction crosswalk transactions.
• Involved in working 837/835 EDI /XML files to generate a wide variety of valid claims
• Tested application and implemented into production.
• Tested external procedure.
• Analyzed and tested scheduling strategies to fine tune our Informatica batches.

ENVIRONMENT: QNXT 4.71/5.01, Redgate, MS SQL Server 2008, Informatica 8.6.1, Oracle 10g, MS Visio, MS Office, SQL, T-SQL, UML, Mercury Quality Center 10, Business Objects XIR3 (Web Intelligence), XML, XSD, XML Spy 2008, PL/SQL, Shell Scripting, PERL, Teradata SQL Assistant, Agile, HIPPA5010, VSAM Files, MVS, JCL, COBOL II, HP ALM 11.5.

Confidential, RESTON, VA

SR. BI/ ETL QA TESTER, DATA QUALITY ANALYST

RESPONSIBILITIES:

• Performed analysis of ETL logic residing in Decision Stream to uncover data relationships, derived values, calculations, etc. in lieu of proper documentation
• Working in close conjunction with testers in different environments to solve existing reports and design problems
• Tested several Informatica Mappings to validate the business conditions
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0.
• Designing and creating new reports, Freeform SQL reports in MicroStrategy
• Created and implemented MicroStrategy reports by creating projects, schema objects and public objects, Attributes, hierarchies, metrics, filters, and templates.
• Involved in analysis of defects and found the root cause of the defect.
• Tested PL/SQL statements to verify the output and compared against ETL Output.
• Performed SQL queries in the TOAD and ensured Correct Data Retrieval
• Extracted certain column of data from a number to files using PERL.
• Used PERL for automating all the types of modules at a time.
• Worked with PERL control structures & Regular Expressions for substitutions based on matches.
• Worked with Teradata SQL Assistant for data retrieval.
• Worked on issues with migration from development to testing
• Worked with PERL for file manipulations
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Used SQL plus as a query analyzer to run queries against the warehouse to get a better understanding of the SQL produced by MicroStrategy, which greatly enabled in better data quality.
• TestedAb Initiographs for several business scenarios based on ETL data mapping document
• Used Quality Center to track and report system defects.
• Designed and developed Test Plans and Test Cases and executed them.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Written several complex UNIX Shell Scripts for cleanup, logging, file manipulation and transferring the files.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Designed and developed Test Plans and Test Cases and executed them.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Conducted Database testing using SQL Queries.
• Tested reports in Web Intelligence XIR2
• Tested Cross-Tab reports
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Used Quality Center for requirement analysis, scheduling and generating test cases
• Involved in Data Extraction from Teradata and Flat Files using SQL assistant.
• Tested complex objects to the universe to enhance the report functionality.
• Performed data validation by writing SQL queries and creating ad hoc reports using desktop intelligence and web intelligence
• Heavily interacted with database operation by writing SQL queries.
• Heavily interacted with ETL team for testing data Quality and data Validation.

ENVIRONMENT: Informatica, MicroStrategy, Ab Inito GDE, .Net 4.5.1, Oracle 9i, Quality Center, Teradata V2R6, SQL, PL/SQL,UNIX, Shell Scripting, PERL Scripting, MS Visio, Macros, Rational Unified Process, MS Office, IMS, Agency Interface, Active Docs, Lotus Notes 7

Confidential, DALLAS, TX

SR. ETL / DWH / BI TESTER / DATA ANALYST

RESPONSIBILITIES:

• Performed defect management using Rational Clear Quest.
• Performed Data Analysis during the requirements gathering phase by reviewing the source data model and running SQL queries.
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
• Coordinated with QA Testing Team to test various test scenarios involving Test Plans, Test Cases, and Test Scripts.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Worked with Advanced SQL and PL/SQL programming
• Extensively involved in writing Test Plan, Test Cases, based on Business Requirement Documents, Functional Requirement Specifications, and Design Specification document generated and executed Test Scripts.
• Developed ETL Test Plan and Test Strategies for the entire Line of businesses.
• Extensively used SQL queries for Database testing and Validation.
• Involved in extensive backend testing.
• Tested PL/SQL statements to verify the output and compared against ETL Output.
• Conducted requirements gathering sessions that lead to the Design of Data Mart.
• Performed Data Analysis using SQL based on requirements gathering sessions.
• Assisted in Capacity planning based on Data Analysis and requirements gathering sessions.
• Carried out UAT by developing Test Plans, Test Scenarios, Test Cases, and Test Data to be used in testing based on business and user requirements, technical specifications and/or product knowledge.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Involved in executing the UNIX shell scripts for loading the data from the Source to the Datamarts.
• Tested the data and data integrity among various sources and targets.

ENVIRONMENT: Data Stage 7.x, Oracle 9i, Quality Center, UAT, .Net 4.5, Ruby 2.1.5, Agile VSAM Files, XML Files, XSD, XML Spy, SQL, PL-SQL, MS Visio, UML and MS Office, Cognos, TestDirector, MS Office, MS Visio, UML

Confidential

ETL/BUSINESS TEST ANALYST

RESPONSIBILITIES:

• Extensively followed RUP methodology and involved in complete project life cycle.
• Conducted interviews, JAD sessions with users and development team to bridge requirement gaps.
• Prepared Business requirement document for MMCE, involved in gathering requirements for WD and R&W applications.
• Identify the primary key (logical / physical ) and put update or insert logic
• Deleting the target data before processing based on logical or physical primary key
• Design and execute the test cases on the application as per company standards
• Preventing occurrences of multiple runs by flagging processed dates
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags
• Write and execute complex SQL queries to validate actual test results match expected results.
• Involved in loading of data into database through unix.
• Validated the source and target data count.
• Involved in writing of SQL scripts.
• Validated the XML files by using Altova XML spy and against XSDs which are posted in the JMS topic.
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations
• Ensured that the mappings are correct
• Conducted data validation testing
• Debugging the SQL-Statements and stored procedures
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Developed regression test scripts for the application
• Involved in metrics gathering, analysis and reporting to concerned team
• Tested the Oracle PL/SQL testing programs
• Conducted review sessions on test case and regression test scripts in test director
• Worked with QA team to design test plans and test cases for UAT.

ENVIRONMENT: SQL, PL-SQL, UML,Infromatica, Ab Inito GDE XML Files, MVS, VSAM Files, ISPF, UNIX, IBM AIX 5.3, Java 2, J2EE, Rational Rose, Rational SODA, Rational Requisite-pro, Oracle 9i/8i, MS Office, PERL 5.2.

Confidential

ETL BUSINESS/QUALITY ANALYST

RESPONSIBILITIES:

• Prepared and analyzed AS IS and TO BE work flow scenario and performed GAP Analysis. Designed new process flow and documented the business process. Designed various business scenario and activities of business from the conceptual to procedural level.
• Worked extensively with Subject Matter Experts (SME’s) in understanding, extracting the User and Business Requirements pertaining to clients account information: Account(s) summaries, Account(s) details, Monthly Statements, Balance Transfers between accounts, accrued interest, Check Ordering.
• Authored Business Requirement Document (BRD) with project teams. Interacted with users and other stakeholders to check and alter the specifications of the application and elicit and evaluate requests for modification. Refined business requirements from Project team members. Performed analysis and tracking of requirements.
• Maintained and Kept track of Stakeholders’ requests for enhancements and changes using Unified Change Management tools (UCM) such as Rational Clear Quest.
• Involved with the QA team to determine and develop test approaches and methods for unit testing, integration and functional testing, load and usability testing according to application complexity and test requirement. Designed and implemented basic SQL queries for QA Testing and Report/ Data Validation.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files to target tables.
• Performed data analysis by using SQL profiler and prepared data mapping excels.
• Written several complex SQL queries for validating the migrated data.
• Collaborated within the QA team to ensure adequate testing of application both before and after completion, maintained quality procedures, and ensured that appropriate documentation was being made pertaining to the test results.
• Collaborated with the QA team to develop the Test Plan, Test Conditions and Test Cases to be used in testing based on business requirements, technical specifications and/ or product knowledge. Conducted UAT.

ENVIRONMENT: MS Visio, HTML, MS Office, Oracle, Java, Java Servlets, JavaScript, JSP, J2EE, Windows 2000, Rational Suite, TestDirector, LINUX, LoadRunner, UML