SUMMARY:

• Senior Professional with 12+ years of experience in ETL Testing or ETL QA, Data warehouse Testing, Mainframe Testing and Manual Testing across Insurance, Healthcare, Payment, Invoice, Billing and Real Estate Estimation domains. Worked on development, Maintenance and prototype projects.
• Having H1B Visa. I have been in USA for requirements gathering, as an ETL QA and Hadoop Tester.
• Over 9+ years of ETL Tester ETL QA, Data warehouse tester and Business analyst of Insurance and Healthcare domain (BA).
• Over 2 Years of Mainframe Testing.
• Extensive experience in ETL, ELT, Reports and OLAP.
• Having Knowledge on output/input or Inbound/Outbound transactions, i.e., HIPAA 270/271, 837/835, 999,277 864, D.0, and proprietary flat file layouts.
• Good Experience in Informatica Power Center ETL tool, Informatica B2B Dx tool and Hadoop.
• Possesses strong understanding of business processes. Capable of overseeing project from conceptual phase to successful implementation.
• Extensive experience in Agile, V & V Methodologies and Waterfall methodologies. In Present project we are following Agile Kanban Methodology. Using VersionOne tool for Agile Methodology.
• Data Extraction from various data sources, Mapping, Transformation and Loading between Source and Target Databases in a complex, high - volume environment.
• Expert in Data warehouse and Data mart designs, estimations, resource planning, architect, development and deployment.
• Data Extraction from various data sources, Mapping, Transformation and Loading between Source and Target Databases in a complex, high-volume environment.
• Extensive experience to handle large amounts of data for Data Cleansing, Data Profiling Data Scrubbing and Data Quality.
• Worked as an Onsite-offshore coordinator. Experience in working with remotely distributed teams (Product, infrastructure, Creative, Testing and support teams).
• Using Version tool for implementing AGILE methodology and also Version One tool is used for life cycle of task.
• Analyzed unstructured BIG DATA (Analyzing Millions of Record file). Playing role of DATA ANALYST.
• Worked with data Modellers in preparing logical and physical data models.
• Analyze and profile source data to determine all source data and metadata characteristics .
• Defined the Data Quality rules that will cleanse, de-duplicate, validate, enhance and standardize the project data.
• Trained on Informatica ETL Tool & Testing Automation Tools like Java Selenium and QTP 8.2.
• Expertise in Functional Testing, System Testing, Regression testing and Database testing.
• Experience with scheduling tool.
• Having knowledge about implementation of Dimensional Model(s)
• Undergone training on Insurance and Healthcare domain and passed L0 - Insurance test (Trained by LOMA certified individual).
• Undergone L0 training on Banking and Financial Services (BFS) domain.
• Comprehensive knowledge of Test Driven Development, Agile and Waterfall Methodology.
• Have been involved in testing Distributed system(Distributed system includes some functionalities were implemented in Mainframe, some functionalities were implemented in Informatica and some functionalities in Java application)
• Involved in Testing of Web, Windows application and application developed on Oracle Forms.
• Strong in SDLC, STLC and Defect Life Cycle.
• Prepared Test Estimates, Test Strategy and Test Plan. Prepared Estimation guide line document which helped the developer and tester easily estimate the tasks.
• Written Test Cases using test case design techniques.
• Actively involved in project management activities like Creating Tasks, preparing Resource Usage report, Status report, Assigning bugs, Maintaining CR Tracker.
• Prepared Defect Prevention plan and involved in internal Defect Prevention Meeting and also Defect Prevention from external.
• Designed Developer Release note template.
• Involved in configuration management audit and provided suggestions to streamline our team process and part of organizational group for CMMI Level 5 and PCMMI Audit.
• Prepared Defect Report and effectively communicated bugs using the tools like Bug Tracker and DevTrack.
• Involved in reviewing functional Document.
• Involved in mentoring juniors in a project.
• Designed curriculum for SIP (Span Internship Program) Training.
• Excellent problem solving skills. Possess excellent communication and presentation skills.

TECHNICAL SKILLS:

Languages: C, JAVA, SQL

Platform: Tested applications developed on Java, .Net Web and Windows, Cold fusion, Delphi, Oracle Forms and Legacy (Mainframe). Have been involved in testing Distributed system(Distributed system includes some functionalities were implemented in Mainframe, some functionalities were implemented in Informatica and some functionalities in Java application)

Testing Tools: HP Quality Center 11.0/10.0/9.2, TFS, Java Selenium, Test Director, JIRA, HP UFT, Version One for AGILE Methodology.

ETL Tools: Informatica Powercenter 8.x/9.x, Informatica Data Explorer 9.x, Informatica B2B Dx tool, Ab Initio and Data Stage, Informatica MDM, IDD

Other Tools: Hive, Hadoop(Cloudera flavour),HDFS,sqoop, WinScp, FileZilla, Putty, Jenkins, TOAD, SQL Developer, Text Pad, Compare IT, Sharepoint, VL Trader, SQL Server 2014 Management Studio

Databases: MS SQL Server, Oracle 10g/11g, DB2, SQL Server 2014.

Operating Systems: Windows 8, Windows 7, XP, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, IRVING, TX

ETL Test Lead

Responsibilities:

• Involved in Requirements gathering
• Playing role of ETL Tester or ETL QA and Business analyst of Insurance domain (BA).
• Playing role of DATA ANALYST.
• Preparing Test data by editing 270/271, 837/835, 999 D.0, and proprietary flat files.
• Worked on writing SQL queries to verify the count and data difference between source tables to landing tables, landing to staging tables and staging to base tables.
• Wrote several complex queries to validate De-normalized tables and materialized views.
• Created and maintained test cases for ETL mappings and design documents for production support in HP ALM based on the Source to Target documents
• Worked on developing Requirements Traceability Matrix (RTM) to track requirements during the testing Phase using HP ALM.
• Performed analytical activities to resolve or explore root cause on the issues identified in cognos reports by downstream application user
• Tested the ETL Informatica mappings and other ETL Processes (DW testing)
• Tested data migration to ensure that integrity of data was not compromised
• Verified the error tables and audit post process emails occurred during the ETL execution.
• Verified business requirements by running negative scenarios SQL queries
• Co-ordinated with the business team and development team for opening defects, demonstrating the scenarios and results.
• Involved in preparation of Defect reports, Weekly status report and presentation documents with testing data and testing results
• Perform defect tracking and reporting with strong emphasis on root cause analysis to determine where and why defects are being introduced in the development process using SQL to narrow down the root cause of the problem
• Created data set for process ability to validate different workflows for ETL mapping rules to test the functionality according to requirements of the FMDR application
• Involved in communicating with business, support, and development teams to resolve issues during test execution.
• Extracted data from various sources like SQL Server, Oracle, DB2, XML, and flat files
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts
• Involved in testing and monitoring Informatica job run in informatica Workflow Monitor, Verifying logs for workflows and sessions.
• Performed ad-hoc testing on new issues for any software functionality requests coming from Confidential and communicated with BA team and developers to provide the issues
• Co-ordinated with development and business teams to help UAT process run smoothly
• Participated in presentations for the client Confidential business team to demonstrate the data flow and functionalities of application as required by the requirements
• Worked in Agile Software Development environment, Participated in daily stand-ups, Iteration planning meetings and Iteration Retrospective meetings
• Effectively communicate testing activities and findings in oral and written formats
• Developed test cases in Excel and uploaded to Quality Center.
• Used Rational Clear Quest for defect management
• Editing scenarios in source file and running work flows in informatica.
• As a part of ETL testing, Data Sampling, Functional and System Testing.
• Performed Regression Testing.

Confidential, IRVING, TX

ETL Test Lead

Responsibilities:

• Involved in Requirements gathering
• Played role of ETL Tester and Business analyst of Insurance domain (BA).
• Playing role of DATA ANALYST.
• Based on requirement editing queries written in parameter file and testing reports in target path.
• Worked on writing SQL queries to verify the count and data difference between source tables to landing tables, landing to staging tables and staging to base tables.
• Wrote several complex queries to validate De-normalized tables and materialized views.
• Created and maintained test cases for ETL mappings and design documents for production support in HP ALM based on the Source to Target documents
• Worked on developing Requirements Traceability Matrix (RTM) to track requirements during the testing Phase using HP ALM.
• Validated the MDM tables by executing the SQL scripts based on the transformation/clinching rules and designed Test data for Informatica MDM to be entered through IDD.
• Performed analytical activities to resolve or explore root cause on the issues identified in cognos reports by downstream application user
• Tested the ETL Informatica mappings and other ETL Processes (DW testing)
• Worked on validating ETL target tables in table level and column level looking at the complexity of Source to Target document.
• Tested data migration to ensure that integrity of data was not compromised
• Verified the error tables and audit post process emails occurred during the ETL execution.
• Verified business requirements by running negative scenarios SQL queries
• Co-ordinated with the business team and development team for opening defects, demonstrating the scenarios and results.
• Involved in preparation of Defect reports, Weekly status report and presentation documents with testing data and testing results
• Perform defect tracking and reporting with strong emphasis on root cause analysis to determine where and why defects are being introduced in the development process using SQL to narrow down the root cause of the problem
• Created data set for process ability to validate different workflows for ETL mapping rules to test the functionality according to requirements of the FMDR application
• Involved in communicating with business, support, and development teams to resolve issues during test execution.
• Extracted data from various sources like SQL Server, Oracle, DB2, XML, and flat files
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts
• Involved in testing and monitoring Informatica job run in informatica Workflow Monitor, Verifying logs for workflows and sessions.
• Performed ad-hoc testing on new issues for any software functionality requests coming from Confidential and communicated with BA team and developers to provide the issues
• Co-ordinated with development and business teams to help UAT process run smoothly
• Participated in presentations for the client Confidential business team to demonstrate the data flow and functionalities of application as required by the requirements
• Worked in Agile Software Development environment, Participated in daily stand-ups, Iteration planning meetings and Iteration Retrospective meetings
• Effectively communicate testing activities and findings in oral and written formats
• Developed test cases in Excel and uploaded to Quality Center.
• Editing scenarios in source file and running work flows in informatica.
• As a part of ETL testing, analyzing log file, Data Sampling, Functional and System Testing.
• Performed Regression Testing.

Environment: (It’s in distributed system): Informatica, Db2, Mainframe

Confidential, IRVING, TX

ETL Test Lead

Responsibilities:

• Worked on multiple projects, involved in end to end testing, responsible for creating test cases, development and execution of SQL queries and preparation of Test Result documents.
• Written several complex and efficient SQL queries in DB2 for data verification and quality checks.
• Worked on BCBSA’s Enhanced Data Warehouse and Data Migration from Legacy System to Enhanced Data Warehouse.
• Worked on ICD 10 project in Agile Methodology, responsible for analyzing logical and physical data model of the existing data warehouse and finding the changes that needs to be addressed to be able to process the ICD 10 codes and ICD claims, writing the SQL queries to validate the changes in the tables developed by Ab Initio and performing regression and integration testing.
• Extensively involved in testing the ETL process from different data sources (flat files, XML files, DB2)
• Worked on validating ETL target tables in table level and column level looking at the complexity of Source to Target document.
• Worked on functional and user acceptance testing on Cognos applications and reports.
• Worked on report data validation generated by Cognos, including dashboards, summary reports and drill down and score cards.
• Worked on all testing units through Cognos framework according to the need of the data requirement and business requirement
• Worked with business and development team to identity issues in data mapping for reports in data mapping
• Tested the PL/SQL procedures, functions, packages according to the requirements.
• Identified various defects in the development code and Source to Target documents and raised the defects in JIRA.
• Used Clear Quest for tracking and follow up with the development team to verify defect fixes and update defect status
• Worked on Quality Center for documenting the requirements, preparing test cases and executing the test cases and showing testing progress.
• Involved in meetings and worked together Data Analyst team to discuss Project Requirements and Source to target documents.
• Involved in the weekly QA meetings, weekly project follow-up meetings to update the LOE and report on the current progress, blocking issues and challenges ahead
• Worked with one on one co-ordination with the development team at the crucial times of delivering new builds in time.
• Involved in communicating with Data Analysts, support and development teams to resolve issues during test execution
• Used DOORS in managing requirements and system documents.
• Responsible to understand the enhancements and Involved in finding the gaps in test scripts with enhancements, updating the scripts and conducting Regression Testing.
• Involved in mocking up the test data, as required by the transformation rules and conducted both positive and negative testing to ensure the quality of data.
• Worked on promoting the tags, and installing and executing the Ab initio jobs.
• Planned ahead of time to test the graph parameters and variables by Discussion with DA team.
• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Updated and executed psets through UNIX to load the source flat files, XML files and ETL target extract files.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables and Data warehouse tables.
• Performed Backend testing by writing SQL queries and running PL/SQL scripts in TOAD.
• Tested initial and subsequent loads for various Ab Initio graphs.
• Developed test cases in Excel and uploaded to Quality Center.
• Involved in Production support with verifying the production defects.
• Played role of Business analyst of Insurance domain (BA).
• Analyzed unstructured BIG DATA (Analyzing Millions of Record file).
• Played role of DATA ANALYST.
• As a part of ETL testing, performed database testing, Data Sampling, Functional and System Testing.
• Performed Regression Testing.
• Guided team to improve quality process.
• Reported and following up bugs in bug tracking tool.
• Participated in Regular, weekly project status meetings related to testing (Internal and Onsite).
• Executed System testing test cases prepared for this project.

Environment: Informatica, Db2, Mainframe

Confidential, IRVING, TX.

Senior Software engineer

Responsibilities:

• Analyzed the business requirements and Functional Specs for developing Test Plan and the Test Strategy
• Wrote Test Cases for EDW - Data ware house (Source to Target) and Cognos Standard Reports, OLAP and CUBES.
• Wrote complex SQL queries for positive and negative testing in validating data ware house tables.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
• Conducted Test plan reviews, Test case reviews by analyzing the requirement specifications.
• Worked on traceability matrix to map Test cases against Requirements using Quality Center.
• Wrote Test Cases for EDW - Data ware house (Source to Target) and Cognos Standard Reports.
• Involved in working with slowly Changing Dimension type 1, type2 and type 3 based on the requirement.
• Validated ETL DW load statistics and Data mart Loads on an Ongoing Basis
• Validated Source - Target mappings applying various transformation rules and Business Rules.
• Validated Data ware house DB2 tables and verified the defects.
• Involved in testing Data Stage ETL jobs for the data quality and number of the records.
• Validated Adhoc Reports, OLAP Reports for Data Accuracy.
• Created various complex SQL scripts for functional validation of ETL applications.
• Created test sets based on scenarios to validate EDW.
• Participated in Defect Review meetings periodically.
• Worked on Test management using DOORS.
• Validated Cubes, Standard Reports built from Cognos.
• Working Experience with Agile Development Methodology.
• Responsible for reviewing and modifying test scripts after initial iterations of testing phases to in corporate changes in project environment
• Responsible for Functional and System Testing.
• Performed database testing and Regression Testing.
• Reporting and following up bugs in bug tracking tool.
• Participated in Regular, weekly project status meetings related to testing.
• Executed System test cases.

Environment: (It’s in Distributed system): Java, JSP, Servlets, Struts, spring, Hibernate, JDBC, XML, JavaScript, Jasper, DB2, Mainframe

Confidential, IRVING, TX.

Senior Software Test Engineer

Responsibilities:

• Done quality assurance activities.
• Involved in Requirement and data analysis.
• Responsible for Functional and System Testing
• Performed Regression Testing
• Reporting and following up bugs in bug tracking tool
• Participated in Regular, weekly project status meetings related to testing with Teammates.