SUMMARY

• Over 7+ years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) wif good working noledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Expert in writing SQL queries and has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Extensive testing ETL experience using Informatica 8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager), AutoSys, Control M and Maestro.
• Worked in various Healthcare areas like Enrollment, Benefits, Claims, Medicare, and EDI X12.
• Extensively Worked on HIPAA EDI X12 transaction sets 270/271, 835, 834, 837 I/P, 997 etc.
• Hands on experience in configuration of claims adjudication systems, i.e., Facets, NASCO, QNXT.
• Experienced working for Data Migration, Data Extraction, Data Cleansing, Data Profiling, Data Consolidation, Data Standardization and Data Quality for various business data feeds.
• Assisted in production OLAP cubes, wrote queries to produce reports usind SQL server 2005/2008 analysis Services (SSAS) and reporting service (SSRS)
• Highly experienced in various features of Micro Strategy like managing multiple projects, project migration and defining standards, procedures for development, production environment.
• Proficient in using testing tools such as Quality Center, Win Runner, Load Runner and Quick Test Professional for web - based and client server applications.
• Hands on experience on ETL Micro Strategy tools in ETL process development, testing and in maintaining ETL codes.
• Well versed wif Software testing concepts, SDLC, Agile and Waterfall methodologies
• Possess excellent skills in manual testing in HP ALM(Mercury Quality Center).
• Strong experience testing in Mainframe.
• Used Mainframes for the daily data from the production to SIT environments.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Ab Initio &Informatica
• Solid Back End Testing experience by writing and executing SQL Queries.
• Extensively worked in all phases of testing includes Integration, System, Regression, Load, Stress and User Acceptance Testing (UAT).
• Experience in TestingBI applicationsusing OBIEE, Server Reporting Services (SSRS), Crystal reports.
• Experience in UNIX shell scripting and configuring cron-jobs for ETL Loads
• Extensive experience wif Reporting Tools like OBIEE, Cognos, Business Objects
• Experienced in running SQL, T-SQL, MDX using Toad and MS SQL Server 2000/2005/2008
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Data Stage
• Strong noledge in HP ALM QC, working on the HP Peregrine Service Center, Control-M V.6 and V.8, HP ALM Quality Center10.1, WinScp, Wily (Java Application), Putty, Keynote, H2H, SAP Business Objects: Central Management Console and Server, Info view Reports, XPOLOG, ITSM, WRM.
• Involved in coordinating the White box and Black box testing for the data warehouse by checking ETL procedures/mappings.
• Used SOAP UI, Web Logic ANT task to test Web Services running on Web Logic Server.
• QA Black Box, White Box Testing, Understanding of JAVA test tool, JTEST and test framework JUNIT and JAVA noledge and concepts, Full System and QA Lifecycle, all phases and deliverables
• Worked as a consultant in delivering quality data centric solutions for various business domains
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Experience in testing XML files and validating the data loaded to staging tables.
• Experience in testing and writing SQL and PL/SQL statements.
• Excellent Communication, Analytical and Interpersonal skills.
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed wif UNIX shell wrappers, KSH and Oracle PL/SQL programming.
• Experienced working wif Excel Pivot and VBA macros for various business scenarios.
• Team player wif excellent Organization and Interpersonal skills and ability to work independently and deliver on time.

TECHNICAL SKILLS

ETL Tools: SSIS 9.0,Informatica 8.6.1/8.1/7.1/6.2/5.1, Data stage 8.1, Ab Initio

Data Modeling: Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 10g/9i/8i, MS SQL Server 2005/2000, DB2, Teradata V2R6

OLAP Tools: Cognos 8.0/7.0/6.0, Business Objects XIR3/XIR2/6.x/5.x, SSRS 9.0 Micro Strategy OLAP Suite (8 & 7i)Languages: SQL, PL/SQL,MDX, Visual Basic, XML, C, C++

Tools: Toad, SQL* Loader, SQL AssistantReporting Tools: Business Objects, Cognos 8.0, OBIEE,MS Access Reports, SSRS, DSS reports, Pivot Tables, Crystal Reports.

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Testing Tools: QTP 10/9.2, Quality Center 10, Test Director

Rational Tools: RUP, Rational Clear Case, Clear Quest, Test Manager, PVCS, Rational Requisite Pro, IBM Rational Manual Tester

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

Job Schedulers: Control M, AutoSys, Maestro

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

Sr.ETL QA Analyst

Responsibilities:

• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Teradata Conversion & Abinitio Upgrade of the Apps
• Used HP Quality Center 9.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Co-ordinate testing efforts between onsite and offshore teams.
• Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL minus queries.
• Worked as a consultant in delivering quality data centric solutions for various business domains.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Experience in ETL Data Warehousing, database testing using Data Stage for Workflow process.
• Designed policies, standards and procedures for testing life cycle for the data warehouse and datamarts.
• Prepared test cases by understanding the business requirements Data Mapping documents and technical specifications.
• Implemented SDLC, QA agile methodologies and concepts in the Project.
• Build a customer data centric data warehouse to analyze transactions across finance, marketing, risk collections and consumer relations for the credit card division. Clean customer data warehouse successfully implemented on Oracle target, the data warehouse is growing in its analytical richness.
• Involved in identifying the defects and raising them in HP ALM and assigning to the respective team.
• Tested the ETL process for both before data validation and after data validation process. Tested.
• Converting the Oracle table components to Teradata Table Components in Abinitio Graphs
• Responsible for different Data mapping activities from Source systems to Teradata
• Extensively used Informatica power center for extraction, transformation and loading process.
• Wrote and implemented manual automated test scripts for Risk Warehouse decision support system using HP Quality Center.
• Involved in daily meetings, Defect triage meetings, and walkthroughs in an AGILE environment.
• Executed test cases in HP ALM and documented the test results.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target
• Coordinated wif development team in system integration test and services level unit testing.
• Supporting presales activity for Data centric warehouse testing projects.
• As a part of dis project I had to perform data profiling using the Abintio Data profiler
• Responsible for identifying and defining the Key Performance Indicators in SSAS 2008.
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center wif Pass/Fail/Blocked status.

Environment: Data Stage 8.5/ 8.0.1/8.0/7.5/7.1, HP ALM Quality center 10.0, OBIEE10.1.3,AB Initio, Oracle 10g, Teradata, Agile, SSIS (2008), SQL server SSRS (2008), SSAS, PL/SQL, Toad, XML, PERL 5.12.1, Flat Files, Excel, Autosys, netezza, UNIX, Shell Scripting.

Confidential, Washington, DC

Sr. ETL/ QA Tester

Responsibilities:

• Wrote SQL Statements to extract Data from Tables and to verify the output Data of the reports
• Performed back-end testing on the Oracle database by writing SQL queries.
• Collected, analyzed and reported testing metrics, executed SQL queries
• Built and maintained TEMPeffective QA test lab environments
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Used Query Studio to test ad hoc reports
• Developed SQL queries in Toad and DB Artisan to achieve the data transformations
• Participated in various meetings and discussed Enhancement Request issues
• Conducted Regression testing after the bugs has been fixed by the development team
• Generated reports from Test Director.
• Responsible for source control, versioning, and configuration management of test scripts, test results, defects
• Developed Test Strategy, Test plan, Test cases, and Test scripts
• Created test plan and executed test cases using Rational Test Manger
• Conducted Functionality, Security, and End to End testing
• Reported bugs using Test Director and generated the defect reports for review
• Defect reporting and tracking was also done using Test Director.
• Maintained the test traceability matrix
• Performed Regression Testing on weekly builds.
• Monitored the workflow transformations in Informatica work flow monitor

Environment: Windows 2000 Server, SQL Server, Oracle 9i, Documentum 5i, Rational Test Manager, Rational Requisite Pro, Rational Clear Case, Rational Robot, ETL Informatica 7.1, Cognos 7.3 Series, Test Director, Toad, Java, J2EE, JSP

Confidential, Bloomfield, CT

ETL/BI Quality Engineer

Responsibilities:

• Defined the test criteria, project schedules and base lined the Test Plan wif the halp of project meetings and walkthroughs.
• Involved in testing HIPAA EDI Transactions.
• Completed 5010 Gap Analysis and Impact Assessments on Business process, Application and EDI Transaction process for upgrade from 4010A1 to new 5010 HIPAA EDI X12 electronic formats.
• Analyzing 4010 and 5010 gaps and impacts across all transactions, system interfaces, applications and business processes.
• Projects were in different methodologies like Waterfall and AGILE, well versed wif both methodologies of SDLC.
• Tested the Pricing, Enrollment, maintenance and benefits configuration in Facets 5.0
• Tested the claims flow, Claims Status, Financial Claims, Payer System, Billing and Inquiry in Facets 5.0.
• Providing technology(Ab initio ) support to various other Applications
• Tested the COB and EOB in Facets.
• Worked wif claims batch process, external claims and Pended claims in Facets.
• Tested the ICD 9 / 10 Codes.
• Developed Test Cases and Test Scripts for ICD9 and ICD10 applications.
• Tested Medical claims that are sent by doctor’s offices wif ICD9 and ICD10 codes, along wif procedure codes non as CPT codes, and the amount billed for the services rendered.
• Tested the class, plan, products, group and sub-groups in Facets
• Tested the eligibility inquiry and enrollment in Facets
• Tested the Healthcare Payer, Provider, Subscriber and Member enrollment in Facets and association wif class, plan and product.
• Tested the COB carrier functionality and eligibility functionality in Facets.
• Developed an implementation guide for Partners for EDI X12 transactions such as 834, 835,837,270 and 271
• Work on Logical Data Requirements and Physical Data Mapping for the Forward Data Cache a new Data Model designed for EDI transactions (270/271,276/277, 834 and 837) to cater to the new 5010 federal govt. mandated regulations.
• Tested the Web portals for Members/Providers.
• Worked wif XML/SOAP/WSDL Web Services.
• Adhered data transition of the enrollment process, COB, ICD9/10, Claim Status and Eligibility as per the EDI standard 834, 835, 837, 277 and 271.
• Worked wif EDI transactions 837 - Claims and 835 Remittances and validated the claims.
• Tested and processed Institutional, Professional and Dental claims using EDI 837 I/P/D Transactions.
• Extensively worked on EDI 837I, 837P, 837D X12 file creations.
• Involved in EDI 834 (Enrollment) Testing.
• Validated the data coming from EDI/X12 4010/5010 (837, 835) interfaces.
• Worked on EDI 270/271 for Eligibility Inquire and Response and 276/277 for Claims status.
• Worked wif X12 /EDI transactions and validated the specifications/mapping for 837 transactions for Institutional and professional claims and 835 responses.
• All the test scenarios which has been satisfied wif the functionality are moved to automation testing using QTP.
• Tested the Cognos/BI reports.
• Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Tracked and Managed Defects using Quality Center.
• Backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases using TOAD.
• Used Visio for business analysis.
• Responsible for collecting and analyzing the test metrics and tan submitting the reports keeping track of the status and progress of the testing effort.

Environment: Trizetto Facets 4.71/5.0, Agile, EDIFECS Transaction Manager, EDIFECS SPEC BUILDER, EDI 5010/4010, ETL, Informatica,Netezza, Quick Test Pro 11.0, HP Quality Center 11.0, ALM, UNIX, XML, SQL, PL/SQL, Oracle.

Confidential, MA

Sr DWH Tester/SQL Tester/BI Tester

Responsibilities:

• Prepared data mapping document for various data feeds for ETL to write and develop the data extraction routines.
• 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
• Coordinated between offshore and onsite team and managed multiple OLAP and ETL projects for various testing needs.
• Extensively used Informatica for extraction, transformation and loading process
• 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 and validated the Report Net reports by running similar SQL queries against the source system(s).
• Created and implemented Micro Strategy reports by creating projects, schema objects and public objects, Attributes, hierarchies, metrics, filters, and templates.
• Did extensive work wif ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Performed MS SQL Server T-SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in dis project to write Shell Scripts and SQL queries.
• Tested Micro Strategy 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.
• Tested all the reports by running queries against the warehouse-using TOAD. Also compared those queries wif the Micro Strategy SQL engine generated queries.
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Conditional testing of constraints based on the business rules
• Analyzed the Requirement Traceability Matrix, Daily Test Status reports, Weekly defects report, and Risk analysis by communicating wif the Business Team.
• Defects were tracked and prioritized using Quality Center and analyzed the variation between expected result and actual result.
• Designing and creating new reports, Freeform sql reports in Micro Strategy
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Extracted certain column of data from a number to files using PERL.

Environment: Informatica 8.6.1, XML, XSLT, PERL, Micro Strategy, SQL Server 2008, QTP, Quality Center 10.0, DTS, T-SQL, SQL, Teradata V2R6, TOAD, Teradata SQL Assistant 6.0, Oracle 10g, PL/SQL, IBM DB2, MS Access/Excel/Visio, UNIX Shell Scripting

Confidential, Madison, WI

DWH / ETL Tester

Responsibilities

• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Experience in data analysis, data integration, conceptual data modeling or metadata creation.
• Performed Business Analysis, Data Analysis and Dimensional Data Modeling
• Created the test environment for Staging area, loading the Staging area wif data from multiple sources.
• Conducted source-system data analysis to understand current state, quality and availability of existing data.
• Worked wif Data Stage for Data Extraction, Transformation and Loading (ETL).
• Tested all the Data Stage Parallel jobs when extract, transformation and loading of the data using Data Stage in the parallel processing mode
• Extraction of test data from tables and loading of data into SQL tables.
• Verify the source to target data movement and verify the target data by writing SQL queries
• Written several complex SQL queries for validating Cognos Reports.
• Worked wif business team to test the reports developed in Cognos
• Tested whether the reports developed in Cognos are as per company standards.
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Tested several stored procedures.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Involved in testing data mapping and conversion in a server based data warehouse.
• 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 wifin the application wif metadata.

Environment: Oracle 10g, x Ascential Data Stage 7.5, SQL Server 2005, DTS Packages, Quality Center 9.0, PERL, Cognos Series 8.0, Unix IBM AIX 5.5, T- SQL, XML Files, XSLT, XML Spy 2010, SQL, PL/SQL, Stored Procedures, Shell Scripting, OLAP, IBM DB2, COBOL II, VSAM, JCL, Teradata V2R5

Confidential

QA Test Engineer

Responsibilities:

• Reviewed the Business Requirement Documents and the Technical Specification.
• Designed Test scripts and test cases in Test Director and MS-word.
• Generated automated test cases on first build of the module using QTP, Rational Tools.
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using QTP.
• Analyzed Software Requirement Specification
• Inserted Database Checkpoints to verify consistency of the database workflow using Win Runner
• Implemented Database Checkpoints for Back-end Testing
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Performed Functional Testing and Back-end Testing using the database comparable results Manually
• Interacted wif the users to ensure meaningful development of the scripts and simulated real time business scenarios
• Designed and Executed Test Plans, Test Cases and Test Procedures.

Environment: Windows NT/2000, Quality Center, UNIX, Oracle10g