Eit & End-to-end Testing / Etl Lead Resume
Chicago, IL
SUMMARY:
- Confidential has over 18 years of experience in Quality Assurance besides being backed with strong development background coupled with strong ETL experience (Data Management & Maintenance) and having worked in varied industry segments.
- He is very thorough in complete SDLC - STLC processes, IV&V process & procedures & Data modeling and management.
- He has perfect combination of management skills coupled with very strong technical background.
- He has proven expertise in manual and automated testing on heterogeneous platforms.
- He has done evaluations of test management processes for improvement opportunities on a continual basis.
- As a Leader, he always strives to pro actively seek out and implement efforts that continuously improve system quality cost effectively in a timely and efficient manner.
- He has driven and managed bug triage processes, represented Quality Engineering in project meetings to ensure efficient testing and bug fixing process and effectively advocate for QA group. His experience also includes reporting on status of product quality to Senior Leadership, Stake Holders, Project management, Business and Product teams via rigorous execution of detailed test plans/cases and accurate reporting of test executions, system health, Areas / Scope / Opportunities of Improvement, etc.
- He has excellent grasp on QA testing methodologies including regression, Black box, gray box, functional, validation, etc
TECHNICAL SKILLS:
Testing Tools: Rational ClearQuest, Rational Rose, Test Director, PVCS Tracker, HP QTP, HP Winrunner, HP Quality Center, Compuware QARun, QALoadQADirector, Test Partner, SQA Robot, Rocket Shuttle, TOAD, Testing Techniques & Types Mainframe, Client server and Web application Testing using both black box and white box testing techniques, Unit Testing, System Testing, Regression Testing, Parallel Testing, End-to-End testing, Integration Testing, User Acceptance, EIT and stress testing.
Languages: Java, .Net, VB 6.0, VISUAL INTERDEV MS/MF/ANSI/RM/COBOL, FORTRAN IV, EDI, COBOL WORKBENCH, PASCAL, C, POWER BUILDER 6.0, COBOL II, COBOL-85, Unisys COBOL. Databases ORACLE 10.0i, MS ACCESS, DB2 7.2 Fix Pack 11, CICS, INFORMIX Operating Systems HP/SCO UNIX/AIX, MVS, OS 390, WINDOWS NT/2000/3.x, LAN (Novell 3.x/4.x), z/OS, OS/2 Hardware ICIM 2901, SN23, SPERRY UNIVAC VT 700, IBM RS-6000, IBM/370, IBM/3270, DG I, DG II, IBM PCs
Tools: /Utilities VISIO, ANSWERLINK, SUPPORT MAGIC, CARENET, I-NET, VSAM, ISAM, SPUFI, Power play, TOAD, MS OFFICE 97/00, Impromptu 4.0, MS Project 6.0, COBOL Animator, Monarch, File-Aid 12.0, SCO-UNIX, AS/400, Expeditor, SQL, PL/SQL Developer, Lotus Notes 6.5.4, Java, .NET, PVCS Tracker, HP-UNIX, AIX, TSO, FOXPRO, Compuware's QADirector, QARUN 4.0, QALOAD, QTP Professional 8.2, Test Track PRO, WebMethods, Websphere 5.0, Rational's ClearQuest 2003.06, HP Quality Center, Rocket Shuttle, Tortoise Subversion, Application Explorer, Adobe Reader, Zenworks, Microsoft SQL Server 2003 & 2005, eCLIPSE, Citrix (SaaS, PaaS, IaaS), CONTROL-M, HP-ALM, HP Sprinter, Monarch, SubVerion, ServiceNow, SupportMagic, AnswerLink, Monarch, Tivoli, SharePoint, Rally, Jira, CheckSum, etc
EXPERIENCE:
Confidential, Chicago, IL
EIT & End-To-End Testing / ETL Lead
Responsibilities:
- Worked on both the above projects as an ETL Expert, maintaining extracting, transforming / editing & loading data into DB2 & Oracle tables in different schema’s, scheduling / running ETL Jobs using CONTROL-M, Tag Deployments, comparing, verifying, validating / authenticating data (consistency / accuracy) & source to target mapping (Meta Data Lineage), ensuring No Lineage / Graph breakages, building / running SQL Queries, building Data Records, Deploying Builds in various Environments.
- Extensive Black Box/White Box/Gray Box, UI, API, UAT, Functional & System, Web Services & IV & V Testing.
- COBOL Code Review / walk-through with developers to fix defects - Legacy System
- Setting up test bed (data staging for ICD-10, CRD (Common Data), Data Warehouse, Extracting Data from Nemesis Server (MF-Dev), Young Server (Production Server), Comparison of data for accuracy & consistency using Automated comparison scripts / tools
Environment: IBM-3270, Rational ClearQuest, Cognos Reporting, Citrix (SaaS, PaaS, IaaS), CONTROL-M, Ab Initio, MDH Portal/Tool, TOAD for DB2, TOAD for DB2 / Oracle, COBOL, Unix, SQL, RequisitePro, WINDOWS XP, MVS z/OS, J2EE Technology, .NET, Visio, VB, ServiceNow, MDH Tool, SQL, Rally, Jira, Tivoli, RDH (ATTACAMA) HP Quality Center, HP ALM 11.00, Quick TestPro, Beyond Compare, TextPad, File-Aid, CheckSum Mentor, assist & coordinate UAT testing efforts
Confidential, Chicago, IL
Technical Specialist / Testing Lead
Responsibilities:
- Worked on Cost Sharing Scope of Shared Accum (Med/ Rx / Non Med) of the ACA Mandate Project and acting as an SME for Accums, staging / verifying test data, building test data, mentoring team on Shared Accums & HUB Transactions (2-Way & 3-Way), contributing / actively involved in Scope, Design and Requirements reviews for multiple phases, responsible for test artifacts-deliverables, coordinating with various teams & catering to Backend, Claims Processing, Subrogation, Financial Services & Third-Party System Data needs. Ensured 508 Compliance while working on ACA project.
- Lead / Point of Contact from QA on upgrade effort of International Classification of Diseases project, a government compliance mandate participating in requirements & logical design reviews, planning testing efforts and activities, mentoring team members, assigning & allocating tasks to members, monitoring team progress, responsible for test artifacts and deliverables, preparing Foundation Data with Enterprise team and also catering to Backend, Third-Party & Downstream Systems Data needs. Actively involved in Load / Performance testing effort.
- Setting up test bed (data staging for ICD-10 and ACA Mandate - Cost Sharing including Initiation of automation efforts (QTP)
- Worked on testing of Behavioral Health Project for the Shared Accumulators - 2-Way and 3-Way Tier 1 and HCA Sharing Reconciliation Applications for July 2011 release.
- Worked on setup of framework of standards for QA, educating / improving QA processes and procedures, educating and on use of quality center, actively setting up processes and procedures & participating in internal audit of test cases development, execution and reporting in QC
- Performed Black box, White Box, Integration, Regression, Functional & System, Backend, UI, API, Web Services, IV & V, Manual & Automated testing
- COBOL Code Review / walk-through with developers to fix defects - Legacy System
Environment: IBM-3270, Rational ClearQuest, BlueChip, BlueSTAR, BlueTransfer, Premier Pricing, Contract & Member ODS, Accums UI, Ledger, VDR Reports, CICS, DB2, COBOL, Unix, SQL, RequisitePro, WINDOWS XP, MVS z/OS, Clarity, J2EE Technology, AS/400, .NET, Visio, HP Quality Center, Quick TestPro, Magic, Document Direct, Code Explorer, Citrix (SaaS, PaaS, IaaS), etc
Confidential, Cedar Rapids, IA
QA Lead
Responsibilities:
- Promo Allocations to Inbound Router
- Inbound Router to ASR & RDW
- ASR System to Outbound Router & RDW
- Outbound Router to Mainline & Seasonal Promo Billing, RDW, AWR for PO’s
- Mainline Billing to RDW, Promo Allocations & RDW
- COBOL Code Review / walk-through with developers to fix defects - Legacy System
- Performed Black box, White Box, Integration, Regression, Functional & System, Backend, UI, API, Manual & Automated testing