SUMMARY

• Having 8.6 years of IT experience in testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications
• Excellent testing experience in all stages of Software Development Life Cycle which includes Requirement Gathering and Analysis, Test strategy, Test Plan preparation, Test Estimations, Testcase writing and execution and Defect management and retrospection.
• Experience in HIX, Plan Eligibility and Enrollment, Medicaid, Patient management, Mutual funds, Retrials, CRM marketing and sales, Retail, Mortgage banking, cards and loans, Health & Property Insurance
• Proficient in writing complex SQL to perform data driven tests and involved in front - end and back-end testing. Strong knowledge of RDBMS concepts. Developed SQL queries in Oracle databases and as well as in DB2 databases to conduct DB testing. Worked on Data files & label parameter of data file.
• Involved in End to End ETL projects which involved source extraction, transformation and target loading using Informatica, Datastage and SSIS as ETL tools.
• Experience in Data Warehouse testing which involves data migration from Target DB to Ware house using and validating the data displayed in SSRS, OBIEE and Cognos reports
• Experience in Web services testing which involved XML exchange using SOAP and MSMQ
• Strong knowledge of test methodologies: Object Oriented test methodology, Service Oriented Architecture, Top to bottom and Bottom to top test methodology, QA Validations & QA Compliances to ensure the Quality Assurance Control.
• Experience in Mobile device testing, User Acceptance Testing, Performance Testing, GUI Testing, System & Functional Testing, Integration Testing, Regression Testing, Data Driven & Keyword driven Testing
• Experienced in using Test management tools like HP ALM, QC,JAMA and Test Director for Test case creation and Execution
• Experienced in using Defect management tools like JIRA, Clear quest
• Experience in file management with Unix operating system
• Managed a team of 20 and Have executed projects on Onsite/Offshore models and thoroughly understood the process & functions performed at Onsite/Offshore.
• Expertise in Testing complex Business rules with the help of mapping documents and transformations
• Proven knowledge in Automation testing using Selenium Web driver
• Expertise in test methodologies like Agile, V model and Waterfall model
• Ability to work on multiple projects simultaneously & able to adjust priorities with changing needs of the projects
• Knowledge on Excel Pivoting and VBA macros for implementing various business scenarios.
• Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.

TECHNICAL SKILLS:

ETL Tools: Informatica 8.6 (Power Center) (Designer, Workflow Manager, Workflow Monitor), and SSIS 10.0 and Abintio

Databases: MS SQL Server 2008, DB2 9.0 and Oracle 11G

OLAP Tools: Cognos 8.0, OBIEE 11.1.17, and SSRS 10

CRM tools: Siebel Open UI, Salesforce

Languages: SQL, Visual Basic, XML, C, C++

Operating Systems: Windows, Unix and Linux

Testing Tools: Selenium Web driver, QC ALM, JAMA, JIRA and Test Director

Workflow Tools: MS-Project, MS-Excel, MS-PowerPoint, MS-Word.

Healthcare Tools: HIPAA, HL7

PROFESSIONAL EXPERIENCE

Confidential, CT

ETL/BI Lead

Responsibilities:

• Tested the data displayed in the SSRS reports to validate the accuracy of the data
• Tested the data in data ware house to ensure the migrated data
• Tested the data in Source and Target to ensure Transformation of the data
• Validated the ETL mapping documents
• Testing of Confidential application functionality by enrolling the eligible members under different plans
• Wrote the SQL queries to compare the UI data with the data available in the backend
• Execution of the test cases in JAMA
• Defect management using JIRA
• Going through the BSD to test the reports functionality

Environment: SSRS 9.0, SQL Server 2008, IBM DB2 9.0, Toad 9.0, JAMA, JIRA and Unix

Confidential - Malvern -PA

ETL/BI Lead

Responsibilities:

• Tested the data warehouse with the help of data mapping document for various data feeds.
• 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
• Participated in Sprint planning sessions in a Agile Environment to give QA input & estimations for user stories in each sprint
• 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 several Informatica mappings to validate the business conditions and tested the source and target databases for conformance to specifications.
• Tested and validated the Report Net reports by running similar SQL queries against the source system(s).
• Did extensive work with ETL testing including strategies like Data Completeness, Data Transformation & Data Quality for various data feeds coming from different source systems.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Tested BI reports and written test cases using HP Quality Center.
• Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Conditional testing of constraints based on the business rules.
• Planned, coordinate and execute OBIEE deployment for End-users and documented the entire project.
• 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.
• Designed and prepared scripts to monitor uptime/downtime of different system components

Environment: Siebel OpenUI, Informatica 8.6, XML, OBIEE 11.1.1.7, DB29.0, Quality Center 11.0, SQL, MS Access/Excel and UNIX

Confidential, Schaumburg, IL

ETL/BI Lead

Responsibilities:

• Analyzed the Functional requirements using Scenarios & DDD(Detailed Design Document)
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Generated the detailed reports of the Bugs, go no go reports and comparison charts.
• Involved in writing the test cases and Test plans based on SSIS Mappings Transformation Matrix or (Traceability Matrix) for supporting Black box and White Box testing.
• Conducted Black Box - Functional, Regression and Data Driven.
• Tested whether the SSRS reports developed in OLAP are as per company standards.
• Defects tracking, review, analyze and compare results using Quality Center.
• Used SQL for Querying the SQL server database for data validation and data conditioning
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
• Extracted data from flat files and SQL Server tables and upload into targets EIM and Base tables. Used Informatica as the ETL tool to extract the data from sources and loading it into targets.
• Involved in testing timeline scheduling with the lead.
• Did testing of SOA end to end, Service by service and Interface by Interface
• Helped in identifying effort estimations related to testing efforts to Project Management Team
• Tested SOA application interface and communication paths.
• Tested data feeds from XML to Database.
• Development of test plan, test case and test scripts in Quality Center after for functional, system integration, Usability, security testing.
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Mapping.
• Tested reports for various portfolios using universe as the main data provider.
• Tested reports using SSRS like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Check the naming standards, data integrity and referential integrity.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: SOAP,, Web Services, SSIS 10.0, SSRS 10.0, SQL server 2008, Quality Center 9.2, ASP.net, TOAD, Unix, VB Script, XML, XSLT, XML Spy, SQL, MS Excel, Shell Scripting, OLAP

Confidential, AU

ETL/BI Tester

Responsibilities:

• Developed business data feeds document for data mapping needs for ETL and BI purpose to migrate the data
• Written complex SQL queries for querying data against different data bases for data verification process.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Extensively used SQL programming in backend and front-end functions, procedures, and packages.
• Tested different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Effectively communicate testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using HP QC.
• Extensively used Informatics power center for extraction, transformation and loading process.
• Extracted data from various sources like Oracle, flat files and DB2.
• Worked on issues with migration from development to testing.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.

Environment: Informatica 7.1, HP Quality Center, XML, Cognos 7.0, DB2 8.1, TOAD 7, Oracle 8i

Confidential

Senior Test Analyst

• Preparation of test scenarios, test cases and test data
• Configuring the necessary routings for HL7 messages
• Validating the HL7 messages with respect to the specs
• Executing the test cases in QC and preparing the daily test reports
• Logging the defects in QC and attending the triage calls
• Preparing the Daily Status reports and involved in Client calls.
• Participating in daily calls to discussing about the defects raised
• Conducting the web-ex session to client to demonstrate the functionality
• Responsibilities: Analyzing the application profile prepared by the development team.
• Performed Positive and Negative testing to verify Functionality.
• Testing the application on all the stages of its life cycle.
• Created test cases for web Testing
• Created new test cases based on Functional Requirement
• Performed functional and Regression testing.
• Bug tracking and reporting

Environment: Asp.net, VB.net, SQL server 2005