SUMMARY:

• Senior Professional with 10 years of experience in ETL Testing and Manual Testing across Insurance, Healthcare, Payment, Invoice, and Billing and Estimation domains. Worked on development, Maintenance and prototype projects.
• Over 7 years of ETL Tester, Datawarehouse tester, ETL DATA Analyst and Business analyst of Insurance and Healthcare domain (BA).
• Extensive experience in ETL, ELT, Reports and OLAP.
• Good Experinece in Informatica, ETL and QTP.
• Knowledge of Microsoft Office and CRM software such as Salesforce.
• Possesses strong understanding of business processes. Capable of overseeing project from conceptual phase to successful implementation.
• Extensive experience in Agile and Waterfall methodologies
• 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 ProfilingData Scrubbingand 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 teh DataQuality rules dat will cleanse, de-duplicate, validate, enhance and standardize teh project data.
• Trained on Informatica ETL Tool & Automation Tools like QTP 8.2.
• Expertise in Functional Testing, System Testing, Regression testing and Database testing.
• Experience with scheduling tool.
• Having noledge 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 noledge of Test Driven Development, Agile and Waterfall Methodology.
• Has been involved in testing Distrubuted 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 halped teh developer and tester easily estimate teh 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 teh 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). Has been involved in testing Distrubuted 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,Test Director, JIRA, HP UFT, Version One for AGILE Methodology.

ETL Tools: Informatica Powercenter 8.x/9.x, Informatica Data Explorer 9.x, 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

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

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

PROFESSIONAL EXPERIENCE

Confidential, Irving TX

ETL Data Analyst

Responsibilities:

• Involved in Requirements gathering
• Playing role of Business analyst of Insurance domain (BA) and ETL Tester.
• Playing role of DATA ANALYST.
• Based on requirement editing queries written in parameter file and testing reports in target path.
• Performed Software Quality Assurance tasks on multiple FDA data warehouse projects Facility and Supply Chain Master Data Repository (FMDR) and Integrity Product Dictionary (IPD) according to teh FDA approved Guidelines
• Worked with Data Modelrs to create a Physical Data Model from teh Logical Data Model using Erwin tool.
• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Extensively tested several ETL Mappings using Informatica.
• Worked on writing SQL queries to verify teh 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 teh Source to Target documents
• Worked on developing Requirements Traceability Matrix (RTM) to track requirements during teh testing Phase using HP ALM.
• Validated teh MDM tables by executing teh SQL scripts based on teh transformation/clinching rules and designed Test data for Informatica MDM to be entered through IDD.
• Developed ETL mappings in Informatica PowerCenter Designer using various transformations
• Performed analytical activities to resolve or explore root cause on teh issues identified in cognos reports by downstream application user
• Tested teh ETL Informatica mappings and other ETL Processes (DW testing)
• Worked on validating ETL target tables in table level and column level looking at teh complexity of Source to Target document.
• Tested data migration to ensure dat integrity of data was not compromised
• Verified teh error tables and audit post process emails occurred during teh ETL execution.
• Co-ordinated with teh business team and development team for opening a defects, demonstrating teh scenarios and results.
• Perform defect tracking and reporting with strong emphasis on root cause analysis to determine where and why defects are being introduced in teh development process using SQL to narrow down teh root cause of teh problem
• Created data set for process ability to validate different workflows for ETL mapping rules to test teh functionality according to requirements of teh 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 teh 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 FDA and communicated with BA team and developers to provide teh issues
• Co-ordinated with development and business teams to halp UAT process run smoothly
• Participated in presentations for teh client FDA business team to demonstrate teh data flow and functionalities of application as required by teh 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, analyzing log file, Data Sampling, Functional and System Testing.
• Performed Regression Testing.

Environment: Informatica Power Center, Db2, Mainframe, Java, JSP, Servlets, Struts, Spring, Hibernate, JDBC, XML, JavaScript,Jasper, Quality Center, Version one, TOAD, Text Pad, Compare IT, Sharepoint.

Confidential, IRVING, TX

ETL Data Analys

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.
• Developed ETL mappings in Informatica PowerCenter Designer using various transformations.
• Worked on ICD 10 project in Agile Methodology, responsible for analyzing logical and physical data model of teh existing data warehouse and finding teh changes dat needs to be addressed to be able to process teh ICD 10 codes and ICD claims, writing teh SQL queries to validate teh changes in teh tables developed by Ab Initio and performing regression and integration testing.
• Extensively involved in testing teh 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 teh 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 teh need of teh data requirement and business requirement
• Worked with business and development team to identity issues in data mapping for reports in data mapping
• Tested teh PL/SQL procedures, functions, packages according to teh requirements.
• Identified various defects in teh development code and Source to Target documents and raised teh defects in JIRA.
• Used Clear Quest for tracking and follow up with teh development team to verify defect fixes and update defect status
• Worked on Quality Center for documenting teh requirements, preparing test cases and executing teh 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 teh weekly QA meetings, weekly project follow-up meetings to update teh LOE and report on teh current progress, blocking issues and challenges ahead
• Worked with one on one co-ordination with teh development team at teh 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 teh enhancements and Involved in finding teh gaps in test scripts with enhancements, updating teh scripts and conducting Regression Testing.
• Involved in mocking up teh test data, as required by teh transformation rules and conducted both positive and negative testing to ensure teh quality of data.
• Worked on promoting teh tags, and installing and executing teh Ab initio jobs.
• Planned ahead of time to test teh 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 teh source flat files, XML files and ETL target extract files.
• Involved in testing teh 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 teh 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 Power Center, Informatica Data Explorer, Db2, Mainframe,Java, JSP, Servlets, Struts, Spring, Hibernate, JDBC, XML, JavaScript,Jasper, Quality Center, Version one, TOAD, Text Pad, Compare IT, Sharepoint.

Confidential, IRVING, TX

ETL Test Lead

Roles &Responsibilities:

• Analyzed teh business requirements and Functional Specs for developing Test Plan and teh 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 teh 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 teh 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 teh defects.
• Involved in testing Data Stage ETL jobs for teh data quality and number of teh 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 incorporate 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: Informatica Power Center, Informatica Data Explorer, Db2, Mainframe,Java, JSP, Servlets, Struts, Spring, Hibernate, JDBC, XML, JavaScript,Jasper, Quality Center, Version one, TOAD, Text Pad, Compare IT, Sharepoint.