Etl Test Engineer/ Hadoop Qa Tester Resume
PROFESSIONAL SUMMARY:
- Lead EDI QA Tester/EDI Analyst/ETL Test Engineer/ Hadoop QA Tester with total 10+ years of experience quality assurance , Business Analysis implemented Service Oriented Architecture projects using industry accepted methodologies and procedures.
- Worked on 834 State and Federal Exchange Insurance projects.
- Worked on WELLMARK, ATENA, UHC, BCBS FL, HCSC, BSC and CIGNA’s Fedreal Exchange and STATE Exchange Enrollments processing.
- Experienced in EDI Transactions 834,820,270, 271, 837P, 835, 837D, 837I,835,276,277,278, 997, 999, TA1’s and BCBSA Plans and FEP Plans.
- Experienced in Pharmaceutical, Insurance, Insurance Federal and State Exchanges, Financial, Supply Chain Management, and Manufacturing domains
- Experienced in Bigdata testing tools Hadoop, HBase, Hive, MapReduce Impala, Spark, Zookeeper Kalka and QuerySurge.
- Extensive experience in Products like BizTalk server, Visual studio frame work( C#,WCF,WPF, and MOSS 2008/2010, WTX and WMB.
- Experienced in implementing Software Development Life Cycle (SDLC), Spira l Model, Rapid Application Development (RAD) Model and Object Oriented Analysis.
- Experienced Testing internet/intranet of web financial application for security, reliability, internet browser compatibility, performance, regression, integration, unit, negative, conformance, user error messages, Ad - Hoc
- Experienced Agile Scrum project architecture review meetings, Poker for sprint reviews and project stores and tasks meetings, daily stand up meetings, Project demos, backlog grooming meetings and the existing systems requirements meeting, Production and Release management meetings, production issues and UAT Testing activities.
- Experienced in preparing Test Plan, Test strategy, Test scenarios, Test cases, Defect Report and Requirements traceability matrix and Business/System/Application environment setting-up documents.
- Experienced in requirements gathering and GAP analysis ICD 9 to ICD 10 Procedure code sets.
- Experienced in Analysis, design, developing logical and physical data models/mapping/data mart using entity-relationship modeling tools like Erwin and Microsoft Visio 2000.
- Experienced in UNIX, Shell scripting, AutoSys, share point, SQL Queries, Xpath Queries, DDL, DML, Data Sets, Views, and Store Procedures.
- Extensive experience with UI Testing, Web service testing, Application programming Interface testing, integration testing.
- Experienced in preparing technical specifications including use cases, process flow charts and diagram .
- Experienced in Testing Technologies Tools like Mercury Tools (Quality Center 9.0, Test Director 8.0, Win Runner 7.5, and QTP 8.2), HP Quality Center, Rational Robot, Clear Quest, VSTS 2010 and TFS 2010.
- Experienced in Testing WSDL, XDR, XSD Schemas, XML, XSLT,HTML/DHTML, CSS, jQuery’s, and application testing in different environments like Windows, Unix, Sun Solaris etc.
- Experienced testing online applications/Intranet portal in multiple browsers (IE, Safari, Chrome, Firefox, etc.).
- Experienced in preparing GAP Analysis document, Business Analysis documents and Requirements traceability documents.
- Extensive experience in Data Warehouse testing worked on with Data Migration, Data Conversion and Extraction/Transformation/Loading using Informatica Power Center/Power Mart with Flat Files, XML, oracle, SQL Server, DB2, Tera data database.
- Expertise in GUI Testing, Functional Testing, Unit testing, Block Box testing, Performance Testing, Load Testing, Integration Testing and Back-end testing.
- Experienced in Provider portal (Navinet) web portal UAT Testing and Providers and Payers applications worked on external applications on providers and payers.
- Experienced in preparing Application user manual documents, Applications configurations documents etc.,
SKILLS/TOOL USED:
Testing Tools: Mercury Tools (Quality Center 9.0, Test Director 8.0, WinRunner 7.5, QTP 8.2), Rational Robot, Clear Quest and HP Quality center.
Microsoft testing Tools: VSTS 2008/2010, TFS, WCF Client and Bug Tracking
Microsoft tools: Visual studio 2010( C#.net, VB.net, WCF,WPF
Operating Systems: Window 2003 Server/XP Pro/2000 Pro/NT 4.0/98, UNIX (AIX 5.3/4.3, Solaris 2.8/2.
Languages: JAVA, C#, C++ And Mainframe
Scripting Languages: HTML/DHTML, CSS, PHP, JSP, ASP, Perl and Unix Shell scripting
Bug Tracking Systems: Hp Quality center, PVCS Tracker, Test Director and Bugzilla.
Modeling & Project Mgt. Tools: , MS Project, MS Visio, Rational Suite and
EDI / HIPAA Standards: EDIFACT,ANSI X12, NSF, HL7, HIPAA 4010 and 5010, ICD 9 and ICD 10 and Blue Exchange LRM 4.
Databases: SQL Server 2005 & 2008, Oracle 9i / 8i and DB2
ETL Tools: Informatica 8.x, SSIS, Congnos report net
Miscellaneous: Microsoft Office Tools.
Integration Tools: BizTalk Server 2009, 2006 R 2/2006/2004/2002 , WTX AND WMD
Data Formats: XML, XSLT, FLAT FILES, EDI, UB92,UB-04,NSF and Flat files
Hadoop/Bigdata Tools: Hadoop, HBase, Hive, MapReduce Impala, Spark, Zookeeper Kalka and QuerySurge.
PROFESSIONAL EXPERIENCE:
Confidential
ETL Test Engineer/ Hadoop QA TesterResponsibilities:
- Experienced in Pharmaceutical, Insurance, Insurance Federal and State Exchanges, Financial, Supply Chain Management, and Manufacturing domains
- Experienced in Bigdata testing tools Hadoop, HBase, Hive, MapReduce Impala, Spark, Zookeeper Kalka and QuerySurge.
- Extensive experience in Products like BizTalk server, Visual studio frame work( C#,WCF,WPF, and MOSS 2008/2010, WTX and WMB.
- Experienced in implementing Software Development Life Cycle (SDLC), Spira l Model, Rapid Application Development (RAD) Model and Object Oriented Analysis.
- Experienced Testing internet/intranet of web financial application for security, reliability, internet browser compatibility, performance, regression, integration, unit, negative, conformance, user error messages, Ad - Hoc
- Experienced Agile Scrum project architecture review meetings, Poker for sprint reviews and project stores and tasks meetings, daily stand up meetings, Project demos, backlog grooming meetings and the existing systems requirements meeting, Production and Release management meetings, production issues and UAT Testing activities.
- Experienced in preparing Test Plan, Test strategy, Test scenarios, Test cases, Defect Report and Requirements traceability matrix and Business/System/Application environment setting-up documents.
- Experienced in requirements gathering and GAP analysis ICD 9 to ICD 10 Procedure code sets.
- Experienced in Analysis, design, developing logical and physical data models/mapping/data mart using entity-relationship modeling tools like Erwin and Microsoft Visio 2000.
- Experienced in UNIX, Shell scripting, AutoSys, share point, SQL Queries, Xpath Queries, DDL, DML, Data Sets, Views, and Store Procedures.
- Extensive experience with UI Testing, Web service testing, Application programming Interface testing, integration testing.
- Experienced in preparing technical specifications including use cases, process flow charts and diagram .
- Experienced in Testing Technologies Tools like Mercury Tools (Quality Center 9.0, Test Director 8.0, Win Runner 7.5, and QTP 8.2), HP Quality Center, Rational Robot, Clear Quest, VSTS 2010 and TFS 2010.
- Experienced in Testing WSDL, XDR, XSD Schemas, XML, XSLT,HTML/DHTML, CSS, jQuery’s, and application testing in different environments like Windows, Unix, Sun Solaris etc.
- Experienced testing online applications/Intranet portal in multiple browsers (IE, Safari, Chrome, Firefox, etc.).
- Experienced in preparing GAP Analysis document, Business Analysis documents and Requirements traceability documents.
- Extensive experience in Data Warehouse testing worked on with Data Migration, Data Conversion and Extraction/Transformation/Loading using Informatica Power Center/Power Mart with Flat Files, XML, oracle, SQL Server, DB2, Tera data database.