Quality Analyst - Onshore Lead Resume Hartford, CT - Hire IT People

SUMMARY:

Data analyst with 6+ years of experience in Business - Intelligence Insurance Domain Data warehouse applications that consists 3 years as Ab-Initio ETL developer & 3 years as ETL/Warehousing Quality & System Analyst
Counseled Business team as System Analyst for 6 months in data remediation analysis and impact quantification for +80 business critical defects
Spearheaded implementation of +40 Production critical hot fixes as member of SWAT-Rapid action team
Involved in validating terabytes of data from multiple legacy and XML sources into a warehouse of +160 tables and a subsequent Snow -Flake Semantic layer of +20 tables
Eliminated 70% of manual effort by implementing a reusable Smoke testing and automatic Regression-test SQL generator tools using Ab-initio GDE
Implemented a generic process to Delete and Reload +50 million transaction in parallel production environment in 3 weeks for downstream critical issues
Standardized Agile methodology using Rally- Kanban tool in two Data Remediation Team for timely implementation of critical modules
Specialized in leveraging Ab-Intio in data warehouse testing by creating sample ETL mappings and generic test Environment validation tools to ensure test bed robustness
Awarded Individual Achiever for 2016(Q4) by client
Awarded Performer of Month 2013(Nov) and Sep’2014

TECHNICAL SKILLS:

ETL: Ab-initio-GDE, BRE

SQL: Teradata 14, Oracle, DB2

Defect Tracking: QC ALM

Agile: Rally Kanban

Scripting: UNIX

Novice: Cognos, Mainframe

Job Scheduling: Autosys

WORK EXPERIENCE:

Confidential, Hartford, CT

Quality Analyst - Onshore Lead

Responsibilities:

Lead a geographically dispersed team of 9 resources for 3 multi-vendor modules.
Design Test artifacts like Test plan, Test approach, Test Cases and Test scenarios from business and functional requirements.
Implement Agile-Kanban methodology (Rally) in fast track Data remediation modules
Prepare monthly scorecard and dashboard reports for multiple projects
Leverage Ab-initio GDE for mocking, sampling and filtering source Mainframe files and create generic code to automate manual processes
Work on Proof of Concept(POC) for client on upcoming modules and tactical fixes
Ensure Crisp and timely communication with upstream/ downstream projects for Integrated execution
Provide High and low level work estimates for version release
Conduct technical interviews for project level recruitment drive

Confidential

System Analyst

Responsibilities:

Build and implements hot fixes on live prod data as a member of SWAT-Rapid action team
Provide Root Cause Analysis ( Confidential ), impact analysis & quantification of existing defects with business team

Confidential

ETL Developer

Responsibilities:

Created mappings for batch/daily and Real Time Main-Frame Queue extracts in Ab-initio and BRE.
Involved in creating detail data flows with Complex batch/daily and Real Time Main-Frame Queue source and target mappings
Migrated scripts from DEV to SIT and UAT environment to test & validate data
Developed Generic graphs and utilities for data cleansing, data validation and data transformation
Design end-to-end ETL generic framework for loading data into Claims data warehouse. Worked on Ab-initio standard environment Conduct> IT, BRE. Performed optimization by transferring files to mainframe and then loading to DB2 database.