Dipak Selmokar

Contact : 502-***-****

Email : adbttq@r.postjobfree.com

Professional Summary:

Experience: 14+ years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.

Self-Motivated, Flexible to adapt to changing priorities and deadlines. Systematic and organized approach.

Believe in Commitment to Excellence and Team Spirit. Multi-tasking projects Handling, Team handling, People management Capabilities.

Excellent Presentation, Communication, Writing & Interpersonal skills.

IT Profile:

Extensive IT experience in various capacities including Analysis, design, development, Testing & implementation in client server environment using various S/W tools including Reporting Applications.

Extensive experience in Actuate erd Pro, software quality assurance, Manual Testing, ETL Testing, Data Analysis, Data Migration Testing, SOA Testing, Web Method /API Testing using POSTMAN and Ready API, BI Report testing,Big Data Hadoop Hive, HQL.

Worked with large Databases in Testing and Production environments, Data warehousing and ETL process using Informatica.

Developed and designed Mappings using Informatica ETL tool for testing the data flow from Data Warehouse to data marts to compare data migration, data transformation & the totals at summary level.

Good experience in working with onsite-offshore team model projects

Proficient in analyzing and translating business requirements to technical requirements and architecture.

Strong database skills, Object Oriented Programming and development knowledge. Good Exposure to database like Oracle, DB2, Teradata and MS SQL Server

Good understanding of Reporting BI Tools like Actuate, Crystal report and ETL Tools like Informatica

Well versed in Hadoop ecosystem - Hive, HQL

Good Exposure of extensive HQL Queries to analyze the HDFS data

Involved in testing the Text Files, CSV Files, XML files, JSON Files and checked whether data is parsed and loaded to staging tables in Hadoop Hive using HQL

Excellent Understanding and working experience in Agile Methodology, Waterfall Methodology

Excellent experience in Quality Assurance, QA processed, Manual Testing, ETL Testing & Informatica DVO, POSTMAN, SOAP UI, Ready API, HP ALM Quality Center

Experience in leading and managing teams. Handled multiple roles - Project Lead, Team Lead, Technical lead, Application developer, Application tester

Executed software projects for Financial, Banking, Education, Insurance, Healthcare, credit Card and Telecom Domain

Expertise in RDBMS backend testing for data validation and data integrity using SQL.

Good experience on Team Management, People Management, Estimation, Stakeholders communication for different projects.

Education:

Bachelors in Computer Science and Engineering (B.E. CSE) From DR. BABASAHEB AMBEDKAR MARATHWADA UNIVERSITY - 2004

Technical Skills:

Languages

C++, VB

Databases

DB2, SQL Server 2008, 2010, 2012, My SQL, Oracle 8, 9i

Reporting Tools

Actuate erd pro, Actuate e spreadsheet, Crystal Report 11.0

OS

Windows NT, Win 2000, Win 7/XP/VISTA/10, UNIX

Testing Tools

HP ALM Quality Center, Informatica DVO, POSTMAN, SOAP UI, Ready API, AcceLQ Automation

ETL

Informatica 8.5/9.1/9.6/10, Informatica Cloud, Hadoop-Hive

Quality Assurance

Manual testing, Web Testing,ETL testing,

Backend testing, Data Testing, testing

Processes, Informatica DVO, SOA Testing,

Web Method/ API Testing,BI Report Testing

Informatica Cloud/ SharePoint Cloud testing

Project Experience:

Client:- Tennessee Department of Environment and Conservation Oct 2019 – Till date

Project: Tennessee Department of Environment & Conservation Certification Application

Role :- Sr. Software System Engineer Quality

TTC – Department of Tennessee will provide various training and certification programs. The project includes the following programs Fleming Training Center, Waste Water/ Drinking Water Operator, Smoke School, Cross Connection control, Ten Lead and Asbestos Training.

Responsibilities:

●Participated in Scrum Meeting, Sprint Planning Meeting and Agile Manager Updates

●Worked with Product Owner for creation of user requirement document for several components by extensive interactions with the user teams, development teams and management teams.

●Developed a detailed Test Plan, Test Cases for the testing effort of the Data Migration.

●Worked on Requirement Analysis, Data Analysis, Testing of various source systems sitting and coming from multi systems. Responsible for BI Data Quality.

●Developed and maintained Stored procedures, User Defined Functions, Indexes, Views, Tables,

●Identify discrepancies/inconsistencies and perform root-cause analysis as needed.

●Manage encountered defects through resolution. Collaborate with development team and business analysts in the resolution of encountered defects.

●Apply proven analytical and problem-solving skills to work on complex issues. Exercise strong judgment in selecting methods, techniques and evaluation criteria for obtaining results.

●Assist in the planning and facilitation of User Acceptance Testing as needed.

●Execute data validation process using SQL and ETL tools, and perform root cause analysis.

●Write SQL against relational databases to validate ETL processes and BI reports.

Environment: ASP.NET 4.5, .Net Framework 4.5, C#, Web Forms, Visual Studio 2015, HTML5, CSS3, JavaScript, JQuery, Bootstrap, Entity Frame Work 5.0, WCF, IIS 7.0, Oracle 12c, SQL Server, TFS, SSIS, Tortoise GIT.

Client: Evolent Health Oct 2018 – Oct 2019

Project: Identifi

Role :- Sr. Software System Analyst Quality

Evolent Health is a "big data" analytics company that helps hospital systems analyze their costs and identify opportunities for improvement so they can take on risk when contracting with payers.

Responsibilities:

●Lead the Agile test from planning and organization to execution and delivery.

●Work with Product Owner, Scrum Master and Agile Developer team to design Test strategy, Desing Test Approach & Test Cases and Validation & Execution of test cases for Identifi Product

●Design the test approach, Test cases and Validate Web Services for EVH Portal, Microsites, Community portal using POSTMAN, SOAP UI Automation

●Perform comprehensive test planning activities, including developing effective test strategies.

●Create QA artifacts, including test strategy, test plan, detailed test cases, defect reports and final test summary report.

●Perform various types of testing, including but not limited to the following: integration, backend data validation, usability, end to end system testing, performance/stress, and regression testing.

●Participate in Various Agile ceremonies like Release planning, Sprint planning, Mid Sprint review, Sprint closure, Sprint retrospective & Demo.

●Design HQL,SQL DB artifacts used for Data & ETL Validation as well as BI Report validation

●Involved in testing the XML files, JSON Files and checked whether data is parsed and loaded to staging tables

●Create Web and Automation suite for testing API as well as Web Applications

Environment: Test planning, ETL Data testing,, SQL Server 2016, AcceLQ Automation, POSTMAN,JIRA,MS VSTS, GitHub, Hive, HQL

Client:-Houston Independent School District (HISD),TX Feb 2018 – Aug 2018

Project: SIS EDW

Role :- Sr. DW/BI Quality Assurance Analyst

The Houston Independent School District is the largest public-school system in Texas, and the seventh-largest in the United States. This Project involve migrating & Validation of HISD data from Old Data Warehouse to New data Warehouse, creating new DW BI objects, creating and validation of Cognos Reports.so that It can be used for Infinite Campus Implementation.

Responsibilities:

●Lead the test effort from planning and organization to execution and delivery.

●Work with business analysts and the development team to develop a testing culture. Drive adoption of unit testing, metrics to monitor code coverage, bug prevention strategies, and other quality measures.

●Analyze requirements to assess completeness and testability. Provide timely feedback and constructive recommendations to the Business Analyst.

●Perform comprehensive test planning activities, including developing effective test strategies.

●Create QA artifacts, including test strategy, test plan, detailed test cases, defect reports and final test summary report.

●Perform various types of testing, including but not limited to the following: integration, backend data validation, usability, end to end system testing, performance/stress, and regression testing.

●Identify discrepancies/inconsistencies and perform root-cause analysis as needed.

●Manage encountered defects through resolution. Collaborate with development team and business analysts in the resolution of encountered defects.

●Apply proven analytical and problem-solving skills to work on complex issues. Exercise strong judgment in selecting methods, techniques and evaluation criteria for obtaining results.

●Assist in the planning and facilitation of User Acceptance Testing as needed.

●Perform other job-related duties as assigned.

●Execute data validation process using SQL and ETL tools, and perform root cause analysis.

●Write SQL against relational databases to validate ETL processes and BI reports.

Environment: Test planning, ETL testing, Informatica 10, SQL Server 2016, Cognos 10, HP ALM, Informatica Cloud, SharePoint Cloud and SQL

Client - Discount Tire, Scottsdale, AZ Jan 2016 – Dec 2017

Project: EPIC

Role:- Sr. ETL API Tester

EPIC Project is a Discount Tire Company initiative to enhance the customer experience for any customer that visits the Store and the Website. The overall goal of the project is to give one seamless experience for all customers that use Discount Tire Site or Stores to buy Tires and wheels. This project will deliver a new Website for all our Discount Tire, America’s Tire, and Discount Tire Customers. The website will have new UI’s and checkout process for a better customer friendly experience.

Responsibilities:

●Participated in Scrum Meeting, Sprint Planning Meeting and Agile Manager Updates

●Worked with Product Owner for creation of user requirement document for several components by extensive interactions with the user teams, development teams and management teams.

●Developed a detailed Test Plan, Test Cases for the testing effort of the Data Migration.

●Worked on Requirement Analysis, Data Analysis, Testing of various source systems sitting and coming from multi systems. Responsible for BI Data Quality. .

●Tested ETL jobs as per business rules using ETL design document (Mapping Sheet)

●Created and Executed Test cases in Data Validator Option ( Informatica DVO)

●Created projects in Ready API, Tested Web Methods/ API using Postman and ReadyAPI

●Used HP QC to track Defects, analyze results and generate performance reports.

●Participated in updating the Requirements Traceability Matrix (RTM)

●Executed SQL Queries to verify the dataflow from the backend.

●Performed user acceptance testing (UAT), and integration testing.

●Worked on creating Test strategy, test plan and test scenario for E2E testing

●Executed E2E testing successfully

●handled responsibilities of co-ordination with offshore team, estimation, status reporting

Environment: Informatica 9.1/9.6, SQL Server, Skybot, GoAnyWhere, Informatica DVO, My SQL, Hybris, PostMan, Ready API, Groovy Scripting

Client:-Metlife Insurance Somerset NJ Mar 2014 – Dec 2015

Global Party Management (GPM)

Role: Sr. DWBI ETL Tester

MetLife Insurance is one of the world's largest insurance institutions, serving individual consumers, small- and middle-market businesses and large corporations with a full range of insurance products and services. This application is dealing with the data validation and the data migration from old tactical data warehouse to new Strategic warehouse.

Responsibilities:

Participated to created user requirement document for several components by extensive interactions with the user teams, development teams and management teams.

Participated in created of User Stories with Business users, and Developers.

Developed a detailed Test Plan for the testing effort of the User Interface.

Developed Test Cases based on the requirement documents.

Worked on Requirement Analysis, Data Analysis, Testing of various source systems sitting and coming from multi systems. Responsible for BI Data Quality.

Performed Business Process mapping for new requirements.

Tested ETL jobs as per business rules using ETL design document

Used HP QC to track Defects, analyze results and generate performance reports.

Participated in updating the Requirements Traceability Matrix (RTM)

Executed SQL Queries to verify the dataflow from the backend.

Performed user acceptance testing (UAT), and integration testing.

Worked on creating Test strategy, test plan and test scenario for E2E testing

Executed E2E testing successfully

Worked as representative of IBM and handled responsibilities of co-ordination with offshore team, estimation, status reporting

Environment: Informatica, DB2, Control M, Unix, HP ALM QC, SQL Server, SQL

Client:-JPMorgan Chase, Columbus, OH Mar 2013 – Mar 2014

Role: Sr. DWBI ETL Tester

Project: Wave 4

JPMorgan Chase Bank NA is one of the world's largest financial institutions. This Project included data validation and data migration and data quality assurance for the data migrated from old data warehouse to new EDM data warehouse.

Responsibilities:

Analysis of Requirement, Mapping document and create MTD, RTM and Test strategy document

Developed a detailed Test Plan for the testing effort of the User Interface.

Developed Test Cases based on the requirement documents.

Tested ETL jobs as per business rules using ETL design document

Executed the Test Scripts in TOAD

Used HP QC to track Defects, analyze results and generate performance reports.

Participated in updating the Requirements Traceability Matrix (RTM)

Executed SQL Queries to verify the dataflow from the backend.

Performed user acceptance testing (UAT), and integration testing.

Worked on creating Test strategy, test plan and test scenario for E2E testing

Worked as a member of UAT team

Environment: Informatica, DB2, Control M, Unix, HP ALM QC, SQL Sever

Client:- American Express, Phoenix, AZ Dec 2008 – Mar 2013

Project: SMART

Role: Actuate Developer and BI Report Tester

Self Managed Analytic and Reporting Tool referred as SMART is a Reporting and MIS platform within American Express Company referred as Amex that is responsible for Developing applications and products for the Global Resource Network Business Services & Travelers (GRNBS) of Amex. IBM Global Services India referred as IGSI has been engaged for providing the skilled resources to develop web based applications in the Amex environment. SMART Team comprising of onsite and offshore teams together provides development of web-based applications that are under the GRNBS portfolio. SMART is a Reporting and MIS platform for Card member referred as CM and Merchant information. SMART provides self-servicing of standard reports as well as ad-hoc analytic and cube capability. SMART utilizes the Actuate application and calls the Mystic data warehouse for sourcing of CM and Merchant data.

Responsibilities:

Analysis of new requirements.

Creating Design Documents based on the requirement.

Developing Reports in Actuate erdpro and e spreadsheet with version 8.

Integrating Main reports with Criteria reports.

Preparing test cases for reports.

Involved in Unit Testing and System Testing.

Installation of Reports on Production Environment.

Preparing detailed Test cases for report testing, data validation and look and feel changes

Testing the reports for individual report flow and cross report flow

Cross validation of report data with database values and validation of calculation

Environment: Actuate ERD Pro, Actuate e-Spreadsheets,DB2, HP Quality Center, Actuate iserver, Actuate Active Portal

Client:- Coke Inc. Sep 2007 – Nov 2008

Project : MS2.0 Coke Report Implementation

Role – ETL BI Report Tester

Fairisaac have a product Market Smart2.0(MS 2.0) which is purchased by Coke Inc.MS 2.0 application have some default reports. Coke requested some extra reports for business analysis purpose and these reports are developed and tested in this project. Also some modification in Data warehouse, Data Model, Universe and reports also done in this project

Responsibilities:

Analysis of new requirements.

Creating Design Documents based on the requirement.

Preparing test cases for reports.

Prepare test strategy, MTD and test approach documents

Preparing detailed Test cases for report testing, data validation and look and feel changes

Testing the reports for individual report flow and cross report flow

Cross validation of report data with database values and validation of calculations

Client:-American Express Apr 2006 – Aug 2007

Project: SMART

Role: Actuate Developer and BI Report Tester

Self-Managed Analytic and Reporting Tool referred as SMART is a Reporting and MIS platform within American Express Company referred as Amex that is responsible for Developing applications and products for the Global Resource Network Business Services & Travelers (GRNBS) of Amex. IBM Global Services India referred as IGSI has been engaged for providing the skilled resources to develop web based applications in the Amex environment. SMART Team comprising of onsite and offshore teams together provides development of web-based applications that are under the GRNBS portfolio. SMART is a Reporting and MIS platform for Card member referred as CM and Merchant information. SMART provides self-servicing of standard reports as well as ad-hoc analytic and cube capability. SMART utilizes the Actuate application and calls the Mystic data warehouse for sourcing of CM and Merchant data.

Responsibilities:

Analysis of new requirements.

Creating Design Documents based on the requirement.

Developing Reports in Actuate erdpro and e spreadsheet with version 8.

Integrating Main reports with Criteria reports.

Preparing test cases for reports.

Involved in Unit Testing and System Testing.

Installation of Reports on Production Environment.

Preparing detailed Test cases for report testing, data validation and look and feel changes

Testing the reports for individual report flow and cross report flow

Cross validation of report data with database values and validation of calculations

Environment: Actuate ERD Pro, DB2, HP Quality Center

Survik Software Ltd, Pune, India May 2005 – Apr 2006

Role: Actuate Developer and BI Report Tester

I have joined Survik Software Ltd as trainee engineer. This company is Actuate consulting partner company. I completed training on Actuate and completed some of the projects successfully. I have successfully worked and implemented projects like Library and leave management, DCWASA, City of Lakeland, AARP.

Responsibilities:

Analysis of new requirements.

Creating Design Documents based on the requirement.

Developing Reports in Actuate erdpro and e spreadsheet with version 8.

Unit and integration test case preparation

Preparing QA test cases for reports.

Involved in Unit Testing and System Testing.

Installation of Reports on Production Environment.

Preparing detailed Test cases for report testing, data validation and look and feel changes

Testing the reports for individual report flow and cross report flow

Cross validation of report data with database values and validation of calculations

Environment: VB, SQL Server, Actuate erdPro, Actuate e-spreadsheet

Contact this candidate