PROFESSIONAL SUMMARY:

• 7+ years of streamlined IT proficiency, emphasizing on Quality Assurance and Data Warehouse testing.
• Manual and Automationtesting expertise of Client/Server,Web and Windows based applications.
• Versatile functional testingmethodologies includingSmoke, Sanity,Integration, Interface, System, Regression,Usability and UATusing HP Quality Center, ALM and Quick Test Pro.
• Solid Black Box Testing skills including Boundary Value Analysis, Equivalence Partitioning, Comparison testing and Error Guessing.
• Hands on experience of Performance testingof API &Web applications using HP Load Runner.
• Web Services testingexperience (request and response message) using SoapUI.
• Experienced inanalyzing requirement and design documents to define and facilitateQATest Strategy and Test Plan.
• Experienced in creating Requirement Traceability Matrix (RTM) ensuring complete code coverage.
• Expert in preparing mock data on positive and negative test scenario / test case basis.
• Experienced in generating dynamicVB scriptautomation frameworks from scratch withDescriptive Programming, Libraries, Functions and Parameterization.
• DWH testing expertise including Source to Target Count/Data validation, Data Transformation, Incremental ETL, Retesting, Regression, Navigation and System integration testing using Informatica Power Center.
• Good at analyzingmapping sheetsand DB source target schema documents to facilitate ETL testing.
• Efficient database coding (T - SQL and PL/SQL) ensuringdataintegrity over SQL Server, Oracle and MS Access.
• Well versed with SSIS Control flow (Tasks and Loop/Sequence containers), Data flow (Connection managers, Tasks and transformations) Error handlers, Exceptional Handlers and Event handlers.
• SSRS and Tableau report authoring including Canned, Ad hoc, Cached, Linked, Snapshot, Tablix, Charts, Graphs,Maps and Gauge reports with Data blend, Context/Global filter, Drill down, Drill through, Parameterized, Sub reports, Radio button, Calendar, Drop Down,Conditional formatting and inline analytical features.
• Complete defect life cycle managementfrom reporting to closureusing HP QC/ALM, JIRA, Bugzilla and Team Foundation Server.
• Diverse domain exposure including Health/Automobile insurance,Personal Banking and Manufacturing.
• Strong HIPAA EDI transaction analysis & compliance experience from, payers, providers and exchanges perspective.
• AGILE - Scrum, V-model andWaterfall mode of Software Testing (STLC) and Development (SDLC) Life Cycle exposure.
• Technical negotiation and active cluster engagement including BAs, SMEs, PO, Dev team, Test team and other Stake Holders.

TECHNICAL SKILLS:

Testing tools: HP Application Life cycle Management 11.0, HP Quality Center 10.0/9.2, Mercury Quality Center 9.0, HP Quick Test Professional11.0/10.0, HP LoadRunner 12.5/11.5/11.0, Informatica Data Validation Option (DVO), SSIS Tester.

Defect tracking: Atlassian Jira 6.3, Bugzilla, MS Team Foundation Server 2013/2008.

DB Source Control: Team Foundation Version Control, GIT.

Document management: SharePoint Server 2013/2010.

RDBMS: MS SQL Server 2012/2008 R2/2008/2005, Oracle 11g/10g/9i, MS-Access 2007.

ETL tools: Informatica Power Centre 9.0/8.1, SQL Server Data Transformation Services (DTS). SQL Server Integration Services (SSIS) 2012/2008 R2/2008.

BI reporting tools: SQL Server Reporting Services (SSRS) 2012/08 R2/08, Report Builder 3.0. Tableau Desktop 9.x/8.x, Tableau Online, Tableau Reader.

Programming: Dot Net (VB/C# script), XML, HTML 5, CSS, PHP, T-SQL, PL/SQL, C, C++.

Operating System: Windows Server 2012 R2/2008/2003, Windows 2007/XP/Vista, Unix, Linux.

Other tools: MS Visual Studio 2013/2012/2010/2008, SQL Server Management Studio (SSMS),Query Analyzer, SQL Profiler, Performance Monitor, Putty,MS office suite 2013/2010/2007 (Word, Excel, Outlook, PowerPoint, Notepad++).

WORK EXPERIENCE:

Sr. QA / DWH TESTER

Confidential, NY

Responsibilities:

• Involved in complete software testing life cycle.
• Analyzed BRD and SRS documentsand conducted Requirements Ambiguity Tests.
• Reviewed the proposedTest Strategy and associated Test Plans.
• Conducting peer reviews on the test scenarios andtest cases createdfor generating effective and efficient RequirementTraceability Matrix (RTM) ensuring full code coverage.
• Manual testing,defect tracking and generating test summary reportsusing HP ALM.
• Implemented Integration. System and Regression testing using HP Quick Test Professional using dynamic VB script framework.
• Responsible for Data driven automated VB script testing with Descriptive Programming, Libraries, Functions, Parameterization and Shared Object Repositories.
• Utilized Load Runner for performance under load testing and analyzed the response times duringheavybusiness transactions.
• Performed browser compatibility testson I.E, Mozilla Firefox and Chrome.
• Worked with middleware systems for validating web services using SOAP UI Pro with XML.
• Implemented smoke tests for each new build.
• Analyzed ETL mapping sheetsand DB Source Target Schema documents.
• Created ETL Test Cases based on Data Cleanness, Correctness andCompleteness scenarios.
• Worked with FACETS Team for HIPAA Claims and payment processing data Validation and Verification Process.
• Created and maintained complex SQL Scripts including Stored Procedures, Triggers, Views and UDF’s over MS SQL Server.
• Tested the ETL process facilitated for high volume batch processed data migration from staging server to Warehouse environment (EDW) using Informatica Data Valid Option (DVO).
• Performed Source to Target Testing, Metadata Testing,Data Transformation Testing andData Quality Testingof data as per HIPAA 4010 and 5010 standards for 837 EDI X12 transactions, related to providers, payers and subscribers.
• Incremental ETL testing themaster-child packages of Change Data Capture and Slowly Changing Dimension configurations for incremental data loadings to data warehouse.
• SSRS report testingby validating data against database as per the requirement documents.
• Complete defect life cycle involvement from logging to closure with root cause analysis and defect follow-upsin defect triage meetings.
• Change request impact analyzationwith lead, PO, Test team and Dev team.
• Creation and managementof release notes over SharePoint server.
• Mentoring newly hired QA folks and conducting demos to off-shore team on the functionality enhancements.
• Sprint reviews and process improvements in retrospective meetings.
• Applied strong organizational skills as a team to deliver the product despite intense pressure.

ENVIRONMENT: HP ALM 11.0, HP Quick Test Professional 11.0, SOAP UI, HP Load Runner 12.5, SQL Server 2012, Oracle 10g, Informatica Power Center 9.0, Informatica Data Validation Option(DVO), Microsoft Visual Studio, SQL Server Reporting Services 2012, SharePoint 2013, JavaScript, Junit, XML, HTML,VB Script, T-SQL, Windows Server 2012 R2.

Sr. QA/DWH TESTER

Confidential, WASHINGTON, DC

Responsibilities:

• Collaborated with team manager and lead in reviewing Business and System Requirement specifications for definingTest Strategy and Test plan.
• Involved in feasibility analysis and conductedpeer reviews on the test scenarios and casesensuring full code coverage.
• Prepared the mock data for test cases with to RequirementTraceability Matrix (RTM).
• Transferred test cases from Excel to HP ALM and conducted manual testing on both positive and negative scenarios.
• Implemented Integration, System and Regression testing using HP Quick Test Professional withVB script framework.
• Responsible for Data driven and key word drivenregression testingmaking the system robust.
• Developed baseline scripts with Parameterization, Descriptive Programming, Libraries, and Functions, shared object repositoriesfor testing the future releases over QTP.
• Performed the Web Services testing and checked all the WSDLs using SOAP UI.
• Utilized HP Load Runner for performance, stress and load testing of web application.
• Performed Cross-Browser testing on browsers like IE, Mozilla, Safari and Google.
• Responsible for creating and executing test cases for Usability and User Acceptance Testing.
• Created and maintained complex SQL Scripts including Stored Procedures, Triggers, Views and UDF’s over MS SQL Server.
• UsedInformatica Data Validation Optionfor validating and verifying the data loadingsinto SQL Server data warehouse and data marts as per ETL mapping sheets.
• Performed Source to Target Testing, Data Transformation Testing, Data Quality Testing of all ETL processfrom flat files, ODS to DWH using Informatica Workflow Manager.
• Incremental ETL testing on Change Data Capture and Slowly Changing Dimension packages.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Tested complex SQL stored procedures and functions for ensuring data integrity during OLAP cube data population.
• Performing root cause analysis, tracking defects and generating test summaryreports using ALM.
• Tableaureport testingby validating the compliance data in the form of charts, maps and graphs against the database.
• Complete defect life cycle involvement with root cause analysis and defect follow-upsin defect triage meetings.
• Change request impact analyzation with lead, PO, Test team and Dev team.
• Responsible for providing test execution status in daily stand up meetings.
• Creation and managementof release notes over SharePoint server.
• Participated in Sprint Retrospective and Product Backlog Grooming Meetings.

ENVIRONMENT: HP ALM 11.0, HP Quick Test Professional 11.0, SOAP UI, HP Load Runner 11.5, SQL Server 2012/2008, Oracle 10g, Informatica Power Center 9.0, Informatica Data Validation Option(DVO), Windows 2007 enterprise,Tableau Desktop 9.0, SharePoint 2013, ASP.Net, XML, PHP,VB Script, T-SQL.

QA ENGINEER

Confidential, TAMPA, FL

Responsibilities:

• Analyzing Business (BRD), Functional (FRS) and System (SRS) Requirement Specification documents.
• Involved in feasibility analysis of master and modular test plans.
• Prioritized the test cases w.r.t RequirementTraceability Matrix (RTM)ensuring complete code coverage.
• Written precise set of positive and negative test cases ensuring flawless functionality.
• Conducted Integration andSystem of Checkout flow, Shopping Cart, Track Orderusing HP QC.
• Responsible for Data driven automated testing using dynamic VB scripts on HP Quick Test Professionalensuring the changes has no adverse effect.
• Generated dynamicVB scripts for to increase extensive regression testing coverage.
• Responsible for creating and executing test cases for Usability and User Acceptance Testing.
• Created and executed complex SQL queries to validate data againstfront end application.
• Utilized Load Runner for performance under load testing and analyzed the response times during heavy business transactions.
• Performed compatibility tests on different browsers I.E, Mozilla Firefox and Chrome.
• Implemented smoke tests for each new build.
• SSRS report testingby validating data against database as per the requirement documents.
• Conducteddefectroot cause analysis, logged and then trackedto closure using HP Quality Center.
• Test case documentation and preparation of Defect Metricsto PO and lead.
• Assist entry-leveltester(s) on reviewing requirement, preparing and executing test cases and report software defects.

ENVIRONMENT: HP Quality Center, HP Quick Test Professional, HP Load Runner 11.0, SOAP UI, SQL Server 2012/2008, Oracle 10g, JavaScript, Junit, XML, HTML 5, Windows Server 2012, Informatica Data Validation Option(DVO), MS Visual Studio, Tableau Desktop 8.0, VB Script, T-SQL.

SQL BI DEVELOPER

Confidential

Responsibilities:

• Working with BA and SMEs onfunctional analysis of student loan application work flow.
• Created dynamic Stored Procedures, UDFs and Triggers for facilitating the ETL process during quarterly assessment adjustments(Market-plan index rates).
• Involved inBRD and FRD analyzation for KPIs and establisheddatawarehouse of fully normalized snowflake schema.
• Developed SSIS packages to integrate coverage data from ODS and Oracle 11g to EDW(2014) with mail alerts within cluster.
• Developed, Deployed and Scheduled Incremental data loading packagesofChange Data Capture (CDC) and Slowly Changing Dimension (SCD) configurations.
• Generating daily roaster excel files from Operational Data Store (ODS) to vendor teams.
• Data validation checks over staging serverwith Lookup onacademic criteria.
• Upgraded(detach-attach) SQL Server 2005 databases to 2014 ensuringcompressed backup.
• Migrating DTS packages to SSIS 2014 packages.
• Responsible for developing and monitoring dynamic SSIS packages for numerous file movement between SQL Server 2008 and FTP server.
• Defect tracking from QA with ticket prioritization and resolution using Team Foundation Server.
• On call level-2 production enhancement issue support.
• Proposed and implemented change requests to enhance the batch processed data integration using Team Foundation Version Control (TFVC).
• Maintaining Technical Design Documentation (TDD) with management over SharePoint Server.
• Developed trend analysis dashboards of the firm's monetary obligation with customers using Tableau Deskop.
• Created and maintained SSRS suite of33 standard reportswith Drill down, Drill through, Sub reporting, Conditional format expressions and running aggregations.
• Developed interactiveSSRS Dashboardsincluding Pareto charts, Pie Charts and line/Bar Graphs for revenue profit trend analysis and cumulative cross charge revenue analysis.
• Generating ESRI Map visualizations with ISO and NAIC codes for regional business assessment, claims and operations.
• Mentored stake holders oncanned and Ad hoc report development using Report Builder 3.0.
• Responsible for report server maintenance with content managementand scheduled data driven subscriptions.
• Troubleshooting, monitoringand tuning reports performance by analyzing the query execution plansof OLAP cube data sources.

ENVIRONMENT: MS SQL Server 2008 R2/2008/2005, Oracle 9i, MS Access 2007, Excel 2010, SSIS 2010, SSRS 2010, Visual studio 2010, .Net Framework 4.0, Business Objects X1 R2, UNIX, Windows server 2008 Enterprise, Team Foundation Server 2008, GIT Source control

SQL SERVER DEVELOPER

Confidential

Responsibilities:

• Analyzing User stories and understanding the N-tier web architecture functional workflow.
• Supporting front end and back end applications with complex and dynamic Queries, Stored Procs, UDFs, Triggers, Views, Joins and Co-relations as per business logic.
• Developed SSIS packages for lease datamigration from vendor sources like DB2 and Legacy files to SQL Server 2008.
• Incremental Data loadings from OLTP to enterprise warehouse withSlowly Changing Dimensions (SCD) ofMaster - Child Package configuration.
• Query tuning for better execution plans usingSQL Profiler and Index Tuning Wizard.
• Performance tuningmillion record vehicle auctionsdata integrationofChecksum T/F (3rd party).
• Resolved ticket issues from QA environments with task updates to ticket owner channeling through Mercury Quality Center.
• Document management over SharePoint Server.
• Database migration within SQL Server instances ensuring back up and integrity check.
• Developed data validation packages with lookup on multiple cached entities.
• Migrating DTS 2005 packages to SSIS 2008 packages.
• Monitoring Cube data population SSIS packages for level 2 production support.
• Preparing Detailed Technical Design Documents with updates as per new releases.
• Month end reconciliations on Account Receivables and Balance Sheets withdata driven subscriptions over Tableau server.
• Publishing consolidated Tableau stories with report selectors illustrating the potential gross revenue variance across markets and time-series to Tableau Server.
• Developed conditional formatted SSRS reports with pane down and pane across aggregations on blended data from SSAS Cubes.
• Publishing live dual axis dashboards for Budget vs Actuals and Estimated vs Weighted Revenue withinline analytical functionalities like compound growth rates, year over year etc.,
• Built image dependent drill through reports and presented lease status using checkbox indicators.
• Integrated Scorecards including Pareto charts and geographic maps from SSRS to SharePoint.
• Developed interactive action reports for vendors that navigated to FTP server.
• Conducted manual testingand generated test summary reports using MercuryQC.
• Generated dynamic automated VB test scripts for system and regression testing ofweb server applicationusingHP QTP.
• Identified bugswith recreation steps and assigned to mid-tier development team.
• Burn down status interactions with stake holders (Team/Scrum master /product owner).

ENVIRONMENT: MS SQL Server 2008/2005, Windows 2000 Advanced Server, MS Access 2007, MS office suite 2007, DTS, Query Analyzer, Index Tuning Wizard.