SUMMARY:

• Successful IT professional with 15+ years of established track record of driving strategy in testing and validation of state - of-the-art solutions enabling clients to thrive in diverse domestic and worldwide marketplaces.
• Led, managed and strengthen global resources by providing customer centric engagement models
• Motivated to strive for excellence and quick learner, with a drive to exceed expected results
• Innovative thinker capable of modeling and implementing outside the box solutions
• Contained costs and waste by proactively implementing automated reporting and management tools
• Minimize risk to critical businesses by implementing a plan-do-check-act process within scope, time and cost

EXPERTISE AREA:

• Testing Strategies & Plans Test Scenarios & Test Cases
• Project & Program Management Process Management & Improvement
• High Availability & Disaster Recovery Automation & Performance Strategy
• Defect Management & Prioritization Change & Release Management
• Data Generation, Conversion & Migration Issue, Risk & Impact Management
• Mentoring & User Training Metric Collection & Status Reporting
• Vendor & Offshore Test Management Matrix Team Building & Leadership
• Healthcare Insurance Logistics Retail Energy/Utilities
• SDLC Waterfall Agile SCRUM

TECHNICAL SKILLS:

PM Tools: MS Office (Word, Excel, PowerPoint, Project, Visio), SharePoint

Packages & Tools: HP ALM (Quality Center), HP UFT (QTP), HP Performance Center (LoadRunner), Selenium, SoapUI, Visual Source Safe, Rational (ClearCase, ClearQuest, ReqPro), ElemenTool, JIRA, TFS, Postman, OKTA

Content Management: Sitefinity, IBM ECM (Enterprise Content Management)

Interfaces: EDI, XML, JSON, SFTP, Batch, Web Services (SOAP, REST), ETL

Framework: SOA, J2EE, Dot Net, Client-Server, Cocoa Framework, Cloud (AWS, Azure)

Operating Systems: Windows 9X/2000/XP/ME/NT/7/10, UNIX, Linux, IBM MVS, Apple Mac OS, Android, iOS

Databases: MS SQL Server, Oracle, IBM DB2, MS Access

ETL Tools: IBM DataStage, Informatica PowerCenter

BI Reports: Hyperion, MS SSRS (SQL Server Reporting Services), IBM Eclipse BIRT (Business Intelligence and Reporting Tools)

Languages: C, Oracle 9i PL/SQL, SQL, Shell script, HTML, CSS, COBOL, JCL, CICS, Java, JavaScript

COTS/SaaS: Calligo (Document Automation & Mgmt.) • Fiserv LifeSuite (Underwriting) IBM TRIRIGA (Lease Mgmt.) Kubra iDoxs & DocWeb iFactor notifi & Storm Center

PROFESSIONAL EXPERIENCE:

Confidential, Providence, RI

IT QA Manager

Responsibilities:

• Lead all phases of testing (Systems, SIT, Security & Performance) by engaging vendors or contractors.
• Provide support for business acceptance testing (UAT) and coordinate automation engagement.
• Create checklists, audit review templates and standardized defect form for Testing Center of Excellence (TCoE)

IT QA Advisor

CVS, Woonsocket, RI

Responsibilities:

• Led the testing efforts thru unique challenges of understanding packaged software and related enhancements, configurations & customizations by continuous collaboration with vendor partner and project stakeholders.
• Introduced lean processes that improved testing efficiency by 150% by removing redundancy and waste.
• Successfully tested ETL integration in conjunction with data migration from legacy (SLIM) to TRIRIGA.
• Successfully tested specialized IBM TRIRIGA Eclipse BI Reports (BIRT) that gathers intelligence on leasing properties, accounting, rent receivables/payments, tax payments.
• Coordinated automation testing team to create various types of property/rental lease agreements to keep the inventory ready for end-to-end system integration and business acceptance (UAT) testing purposes.

Enterprise IT QA & Testing Manager

Confidential, Bloomfield, CT

Responsibilities:

• Successfully tested Hyperion BI reports & ETL processes to push/pull end-to-end employer, member, claims and incentives data to/from Data Warehouse to understand the market impact of incentive program, popularity of various incentives program, incentives driven health choices, incentives impacting insurance claims.
• Led the CAQH CORE Phase 2 Certification testing efforts by collaborating with Edifecs enabling Confidential to become X12 EDI HIPAA 5010 compliant for the 270/271 Eligibility, Claims status and Connectivity.
• Successfully led all phases of testing $150M+ Advantage program’s mission critical business capabilities with 12 releases in 4 years for a new CDHP Service Oriented Architecture (SOA) based platform spanning across 40+ applications that resulted in sun setting legacy CDHP administration systems, data conversion / migration of 400+ middle and national accounts to new platform, by removing claim life cycle impediments that resulted in increased revenue cycle with improvement of over 60% in claim processing timeliness and auto-adjudication, that helped Confidential to grow consumer plans by 35% - that is more than double the industry average.
• Rigorously tested 100+ Blaze Advisor rules and 30+ IBM WebSphere services based workflow thereby significantly improving the defect removal efficiency before starting end-to-end SIT and UAT testing.
• Led Debit card & Forfeiture testing efforts on Advantage program to complete within cost and schedule by providing requirements / architectural / design solutions. Tested ETL processes that pull the data from the claim engines and debit card data mart to populate Microsoft SSRS BI reports to understand popularity of debit card offering on health plan, motivation to move to debit card based copay, debit card transactional accuracy.
• Successfully coordinated Business Acceptance (UAT) testing with Business SMEs & Leads from Service Operations & Products that resulted in implementing 100+ change controls over the period of 4 years.
• Participated in solutioning the build-out of Group Claim Management (GCM) in areas of case management, document management and customer engagement capabilities and Financial Integrator that transforms data from 30+ year old SRO system and combines it with GCM data using ETL/Data ware housing solutions.
• Implemented automated solutions to minimize upfront efforts to enroll members & submit claims using HP QTP thereby shortening the end-to-end enrollment / claims testing cycle by 2 days.
• Introduced test script audit using MS Excel tool for all projects within Testing Center of Excellence (TCoE).
• Saved $100K per year by automating testing status reports & defect metrics using advanced HP QTP queries and state-of-the-art excel tool that reduced 16 to 24 hours of manual work each week to 30 to 45 mins.

Confidential, Fremont, CA

IT QA Lead

Responsibilities:

• Created and maintained automation testing suite using HP QTP (data drive framework) thereby reducing regression testing timeframe to 10% of manual testing efforts.
• Improved project quality by 75% by introducing a rigorous integration testing between Quoting and Case Install domains and by using automated XML parser / extractor tool.
• Led testing of $1M proprietary business rules engine for real time rating application.
• Saved Aetna $500K by providing 48 hrs. of production checkout support, articulating production hot fix solution, providing critical feedback to Business & IT Senior Leadership that helped “Final GO” decision.
• Led successful testing of $4.5M ePublishing Suite by thorough testing of business rules, product combinations by utilization of UNIX shell scripting, advanced SQL queries.
• Managed the testing activities within 1.5% of the overall approved program QA budget.

IT System Analyst

Confidential, Seattle, WA

Responsibilities:

• Migrated, redesigned and deployed database artifacts from Oracle 8i to Oracle 9i PL/SQL standards as a part of Apple Cost Scrubbing application (in-house BI reporting to compare pricing to select competitively priced parts or components from worldwide manufacturers).
• Optimized Oracle database and tables by removing redundancy, normalizing, indexing that resulted in achieving 60% increase in data retrieval.
• Redesigned a program to refresh internal database from Apple Data Warehouse by optimizing & restructuring SQL queries that reduced refresh cycle time by 75%.
• Scripted UNIX shell scripts to create auto listeners for incoming costing files from Apple’s Data warehouse and deployed ETL solution to update localized database/tables.
• Designed and developed Apple Cost Projection application (a proprietary BI reporting solution to provide pricing projection capabilities with the strategic direction set for future price positioning with direct bottom line impact) using roll up algorithm that improved efficiency more than 80%.