SUMMARY

• Over eight (8+) years of experience in Information Technology with extensive experience in software testing, Applications involved with SOA Architecture, ETL, e - Commerce, N-Tier Architecture.
• Displays Test Lead skills and was involved in gathering System and Business requirements, studying and coordinated with the Development and Business teams to prepare Test Plans and Execution Plans.
• Expertise in Data Analysis/Business Analysis/Data Modeling and BI reporting.
• Exposure to Data warehousing, CRM, SFDC, SOA with SOAPUI and web services.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing in a corporate-wide-ETL solution using ETL tools like Informatica and Ab Initio
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Extensive experience in Black box/White box, manual and Automation (QTP) testing.
• Extensively used SOAPUI Tool for SOA Testing Using WSDL and WADL environments.
• Strong working knowledge of Software Development Life Cycle (SDLC), QA Methodologies like waterfall model, agile processing methods.
• Expertise in GUI testing, functional testing, performance testing, UAT, unit testing, integration testing with the extensive knowledge of smoke testing, volume testing and stress/ load testing
• Experienced in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
• Exposure to Data warehousing, CRM, SOA with SOAPUI and web services.
• Good communication skills, Team player and positive approach.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Extensive work with various Rational tools like RequisitePro- Requirement gathering/maintenance, Use Case document maintenance, ClearCase- version control and ClearQuest/TestDirector for bug tracking, Rational Rose for Use case diagrams, Sequence diagrams and activity diagrams.
• Efficient in MS Project/MS Excel for planning/status reporting/writing test scenarios.
• Experienced as a test lead managing a team of 8

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i, Teradata V2R6, 12.0, DB2 9.0, SQL Server 2008, Sybase12.5

Testing Tools: Quality Center 10, IBM Rational Clear Quest/Clear Case, HP QTP, Soap UI

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), Doors Erwin Data Modeler 4x, eCommerce applications

BI Tools: Business Object (Crystal Reports), OBIEE, Micorstrategy

ETL/DW Tools: SSIS, Informatica 8.5.1, Ab Initio, Control M, TOAD, SQL Developer, WinSQL, Autosys

Business Skills: Business Definition Requirements (BRD), Business Process Analysis, Gap Analysis, Use Case Modelling & Analysis, Business Environment and Market Research Analysis.

Packages: MS Office Suite, Visio, Dream Weaver, Adobe Photoshop

Operating System: Windows 95/98, NT, 2000, XP, Vista, UNIX, DOS, Windows 7

PROFESSIONAL EXPERIENCE

Confidential, IL

Data Warehouse QA Lead

Responsibilities:

• Managing/Coordinating the testing activites among three shift leads for 8 peoples.
• Attending Defect review meeting with business everyday to identify the critical defects.
• Priortizing the tasks as per the business requirement.
• Coordinating with the delivery manager for the overall status of the testing.
• Escalating concerns/questions of testers and shift leads to the appropriate teams.
• Identifying the gaps to utilize the time.
• Balancing the task for all the resources in different shifts.
• Reporting overall testing status to the Director of the Product Verification.
• Solve the challenges faced by shift leads or testers during testing.
• Coordinate with System Analyst and the development team with the new changes applied.
• Participating in deployment guide review to understand the overall impact of the changes in the build.
• Reviewing the Business Requirement Documents and the Functional Specification in timely manner.
• Experienced in writing complex SQL queries for extracting data from multiple tables and validating with target tables, using AQT v9.
• Involved in Manual and Automated testing using QTP and Quality Center
• Help prepare Test Cases based on functional requirements.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Used Quality Center for defect tracking.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Involved in testing the Cognos reports by writing complex SQL queries
• Experience testing tables like SCD Type 1, Type 2 & Type 3 verified history load and incremental load data.
• Experience testing the span logic for 820 enrollment files, Health condition tagging, Service category tagging, Sensitive information tagging for Medical claim files.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Able to pick up new concepts quickly
• Worked with Production environment to resolve several data issues.

Environment: Informatica Power Center, Abitnio, QTP,SSIS,IBM DB2, Oracle 10g, Cognos 8.0 Series, Agile, SQL Server 2012,Quality center, Rational Clear Quest, JIRA Flat files, Excel Files, UNIX, Advanced query tool, Beyond Compare 3.0, WinMerge, Toad.

Confidential, WI

Data Warehouse QA Lead

Responsibilities:

• Lead the team of 5-6 people and co-ordinate offshore team of 6 people in INDIA.
• As Test lead worked on test management throughout the Testing process.
• Work directly with project requestors and end users in support of User Acceptance Testing.
• Worked closely with users and program developers to ensure application development meets user expectations.
• Created and executed QTP scripts by using descriptive programming.
• Experienced in creating the SSIS packages, DTS packages.
• Coordinated the testing activity for positive & negative testing, data validation, and GUI testing.
• Used Agile Scrum and Water Fall Model for building the application.
• Used the Agile methodology to build the different phases of Software development life cycle.(SDLC)
• Metadata graphs from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base
• Created source table definitions in the DataStage Repository by studying the data sources.
• Analyzed the existing claims process and specific business rule logic will be applied in the requirement model.
• Provided data modeling support for numerous strategic application development projects.
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2005 environment
• Performed Functional, Front End (GUI), Integration, Regression, end to end testing.
• E-Commerce, Claims management, Claims Management Systems.
• Validated Web Services, Soap responses and Soap Faults to compare expected results and actual results.
• Performed functional and load testing using SOAPUI.
• Verification of Claims data in OMS, WOMS and SODA.
• Performed Data Driven, Data sink testing using JDBC, Excel and Files as Data Source in SoapUI.
• Worked on data modelling and produced data mapping and data definition documentation
• Developed BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional using RequisitePro and Rational Rose to create/maintain: Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Helped with Data Mapping between the data mart and the Source Systems.
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2008 environment.
• Experience in loading from various data sources like Teradata, Oracle, Fixed Width and Delimited Flat Files.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Used Microsoft Visio for Business Process Modelling and Data flow diagrams.
• Coordinated with onsite and offshore teams for better understanding of client needs and provided quality deliverables.
• Created and executed QTP scripts by using descriptive.
• Manually generated reconciliation reports using MS Excel and Access.
• Design and streamlined process to facilitate annual reconciliation of plan sponsors.
• Developed, reviewed, understood and validated Testing scenarios/scripts.
• Defect Tracking with Clear Quest, Configuration Management with Clear Case.

Environment: Ab Initio CO>OP 2.15, SSIS,GDE 1.15,Oracle 11g, Oracle SQL Developer, SQL Server 2008, SQL Management studio 2008,T-SQL,, TIBCO, HP MetaVance, SFDC, Business Objects XI3, HP Quality Center ALM, QTP, IBM Rational Clear Quest, Teradata 13, Unix, Liaison EDI Notepad, Epswitch WS FTP Professional, Ultra Edit

Confidential, Baltimore, MD

Data Warehouse QA Tester

Responsibilities:

• Gathering, blueprinting and analyzing requirements using Requisite Pro and Requisite Web.
• Extensively used Agile Methodology in the process of the project management based on SDLC.
• volved in Managing Data modeling project from Logical design and implementation of Sybase Database.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
• Mapped high-level to-be designs using Business Process Modeling Notation (BPMN) on MS Visio.
• Gathered and documented Business Requirements, created Functional specifications and translated them into Software Requirement Specifications.
• Used QTP framework functionality in various phases and executed test cases using QTP Automation tool.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Consulted with healthcare insurance company to develop conversion specifications for other insurance Coordination of Benefits (including Medicare).
• Used gap analysis framework to identify AS-IS processes of claims transactions of HIPAA X 12 4010/4010 A standard and TO-BE processes (ICD-10-CM and ICD-10-PCS compliance requirements) of 5010 standard
• Involved in creating sample mappings for the conversion of EDI X12 transactions code sets version and translation of ICD 9 codes into ICD 10 codes.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Created ICD-9-CM/ICD-10-PCS comparison document and dealt with DRGs.
• Assist coders to be competent in using ICD-10-CMS/PCS.
• Developed data conversion programs for membership, claims, and benefit accumulator data - converted thirteen corporate acquisitions. Developed data field mappings. Provided programming and support for claims processing functions and auto-adjudication.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Designed conceptual and logical data models of Data Warehouse and tables.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data.
• Analyze business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and OOD using Borland Together according to UML methodology thus defining the Data Process Models.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Documented Requirements for Management Reporting out of Clear Quest using Crystal Reports.
• Facilitated Change Control Board and Governance Board meetings and acted as a liaison between parties impacted by the change requests.
• Provided training on new features within CQ and prepared training materials like Quick Reference Guides and Job aids.

Environment: Oracle 11g, Toad for Oracle 11.6,QTP, SSIS,SQL Server 2012, SQL Management studio 2012,T-SQL, Informatica 8.6.1, IBM Rational Clear Quest, OBIEE 11g,Teradata, Unix, GS Data Generator, Flux, SecureCRT

Confidential, CT

Data Warehouse QA Tester

Responsibilities:

• Involved in requirement gathering phase (Provider, Claim components and HIPAA).
• Utilized Rational Unified Process (RUP) to configure and develop process, standards and procedures.
• Met with report users and stakeholders to understand the problem domain, gathered customer requirements through surveys, interviews (group and one-on-one) along with JAD sessions.
• Involved in understanding the current business process, defining scope of the project along with position statement.
• Worked on environment issues, Compatibility checks after post migration of applications to Unix to Linux.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Implemented automated COB processing of Medicare claims into Facets.
• Integrating systems of record into conformed dimensions and fact tables.
• Wrote database interface specifications and documented in Data Manager data dictionary.
• Worked on development of an information access strategy for the client including integrated data and information requirements, Tools & Process recommendations.
• Create and maintain data model/architecture standards, including master data management (MDM).
• Maintain historical records of contracts and accounts, support internal/external audits on a yearly and quarterly basis for Pharma Sales Operations.
• Performed Data Verification in Oracle database by writing SQL Queries using Toad.
• Worked on Data mapping, logical data modeling used SQL queries to filter data within the Oracle database tables.
• Made sure that the systems complied with the rules of HIPAA and CFR Part 11.
• Documented the dimensional models of ETL system.
• Led the testing efforts of the datamarts in development, coordinated moving/setting up of processes in dev/qa/production. Worked with QA team and UAT team to go over the various test scenarios for different types of loads in the datamarts.
• Used SQL to test various reports and ETL load jobs in development, QA and production environment

Environment: Oracle 11g, Teradata SQL Assistant, Teradata V2R6, SQL Server 2005, HP Quality Center 10.0, QTP, IBM Rational Clear Quest, SAS, PL/SQL, Putty, WinSCP, Action Request System for Remedy, DOORS, Autosys (JIL), Clear View v4.0, Unix, Business Objects

Confidential, South Brunswick, New Jersey

ETL/Data Warehouse Tester 

Responsibilities:

• Involved in business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Performed SOX Program Management in support of the Single Family Technology Group, including SOX test evidence gathering, standard compliance and weekly reporting to upper management.
• Developed test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on the ETL Mapping document.
• Prepared technical specifications and source to target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, and packages to implement business rules and security.
• Gained solid testing experience in working with SQL stored procedures, triggers, and views and worked with performance tuning of complex SQL queries.
• Used QuickTestPro; generated various scripts for performing functional testing.
• Wrote test cases to test the application manually in Quality Center and automated using Quick Test Pro.
• Developed automated test scripts from manual test cases for regression testing based on the requirement documents using Quick Test Professional.
• Wrote Test Plans and Test Cases on Mercury’s Test Director Tool.
• Defects identified in the testing environment were communicated to developers using the defect tracking tool, Mercury Test Director.
• Provided overall support to the Reverse Mortgage Systems, Consumer Home Equity Enhancement & Reporting System and the Shared Accounting and Reporting System.
• Extracted data from various sources like Oracle, XML, Excel and COBOL Flat Files.
• Designed and created complex mappings using SCD Type II, involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Optimized/Tuned several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process; automated the process of loading, pulling the data.

Environment: Ab Initio (GDE 1.12, Co>Op 2.12), Data Profiler, QTP 7.2, SQL *Loader, Cognos 7.0, Oracle 9i, SQL Server 2000, Erwin 3.5, Test Director, Windows 2000, TOAD 7