Dipak Selmokar Mobile: - +1-614-***-****
*********@*****.***
New Jersey
Education:
. Bachelors in Computer Science and Engineering
. Currently working as Team lead,Technical Lead and Test lead
Profile
o 9+ years of IT industry experience encompassing a wide range of skill
set, roles and industry verticals.
o Extensive IT experience in various capacities including Analysis,
design, development,,Testing & implementation in client server
environment using various S/W tools including Reporting Applications.
o Proficient in analyzing and translating business requirements to
technical requirements and architecture.
o Good experience in Quality Assurance and Testing,ETL Testing, HP
Quality Center 10/11
o Strong database skills, Object Oriented Programming and development
knowledge. Good Exposure to database like Oracle (SQL/PLSQL),DB2,Teradata and SQL Server
o Good Experience in Reporting BI Tools like Actuate
o Good Basic knowledge in ETL Tools like Informatica
o Experience in leading and managing teams. Handled multiple roles -
Project Lead, Team Lead, Technical lead, Application developer, QA
Tester, Test Lead, UAT Lead
o Executed software projects for Financial,Banking,Insurance,credit Card
and Telecom Domain
o Good communication skills, interpersonal skills, self-motivated, quick
learner, team player, Experience with global and offshore resource
coordination, Excellent organization skills, Excellent verbal and
written communication skills.
o Excellent knowledge of BSA activities, creation of share point
documents for SDLC 2.0 standards
TECHNICAL SKILL SUMMARY
Languages C++
Database Oracle,DB2
Reporting Tools Actuate erd pro7 / 8/ 9,10/11,Actuate e spreadsheet9/10,
Crystal Report 11.0,
Operating Systems Windows
Testing Manual Testing, ETL Testing, HP QC 10/11
ETL Informatica 8.6(Basic)
PROFESSIONAL SUMMARY
Working as Sr.Application Consultant at IBM from Dec'08 to Till date.
Worked as Software Engineer at Infosys Technologies Pune. from Sep'07 to Nov
'08
Worked as System Engineer at IBM India Pvt. Ltd. from Apr'06 to Aug 07.
Worked as Software Engineer at Survik Software Limited May'05 to Apr'06.
Professional Experience
Quality Assurance Tester / UAT Testing Team /Team and Technical Lead
Dec 08 - Till date, IBM
. Currently working as Test lead/ Team lead and Responsible for leading
a India offshore, Mexico and USA project team in testing and
validating various requirement.
. Develop and coordinate Test strategy, test plans, Master Test
Document
. Manage test environment for integration testing activities
. Effectively working with Business Analysts and Project Managers to
meet deliverable deadlines for various projects
. Functional study of the application, Designing and Execution of Test
Cases & preparing Bug Report.
. Coordinating with the client for on time delivery of the build tested.
. Escalating any serious issues encountered to the higher management.
. Writing and executing test cases.
. Bug vetting & preparing status reports.
. Sending the Daily Status Reports, Functionality coverage reports.
. Conducting Regular meeting with the Team over project related
information sharing and suggestions in improving the team's
productivity
. Projected related communication with the Engineering Team and
Production team.
Reporting End of the Day Report to the Project Managers
. Provide post-implementation support for all deliverables
. Introducing innovative ways to test and validate applications
Work History
Project # Metlife IVR Testing
Duration: Feb 2014 to Till Date
Client Name: MetLife USA
This is IVR testing project. As MetLife have various functionality
available through IVR and new functionality getting introduced, testing and
main objective of this project is validation of all IVR application as per
requirement
Roles & Responsibilities :-
> Analysis of new requirements.
> Creating and coordination Test strategy and Master Test document as
well as review test cases
> Execution of test cases, Escalating if any issue, HP QC Update and
Defect reporting
> Status reporting to Management, UAT Team support, SharePoint
documentation and team management
> Working as Team member as well as team lead and handling client facing
role with team management
Project #- Wave 4
Duration: Apr 2013 to Feb' 2014
Client Name: Chase USA
JPMorgan Chase Bank NA is one of the world's largest financial
institutions, serving individual consumers, small- and middle-market
businesses and large corporations with a full range of banking, investing,
asset management and other financial and risk management products and
services.
The JPMC Retail team is partnering with IBM to leverage their data
management & analytics expertise to accelerate achievement of target state
This project is ETL Testing project and validation of data loaded from
source system to target system as per requirement.
Roles & Responsibilities :-
> Analysis of new requirements.
> Understanding Mapping sheet and transformations
> Creating Test cases, Test plan and test strategy Documents
> Writing SQL Queries to validate Source system and Target System data
> Executing of test cases in quality center
> Worked in UAT team to support UAT activities as well as Managing
Offshore team for all projects deliverables.
> HP QC update for Test plan, Test lab and defect management as well as
status reporting
> Worked as Onshore coordinator / UAT Lead between offshore IBM and
onshore customer UAT team
Environment: HP Quality Center, Informatica, Teradata, Control M, UNIX
Project # - SMART (Self Managed Analytic and Reporting Tool)
Duration Aug'11 to Mar'13
Client Name: AMERICAN EXPRESS
Actuate Developer(System Engineer)
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.
Environment: Actuate erd-pro,Actuate iserver, Actuate Active portal,DB2
Sep 07 - Nov 08, Software Engineer Infosys Technologies
Limited, Pune, India
Project # 1 EDL (Enterprise data Layer)
Duration Sep'07 to jan'08
Client Name: Wellpoint USA
Informatica Developer(Technical Architect)
EDL is a ETL project.In this project we need to extract data from different
databases and different regions and after extraction of data, we need to
apply business rules and then transform data to load into target.
Roles & Responsibilities:-
> Analysis of new requirements.
> Creating Design Documents based on the requirement.
> Devel0ping mapping and workflows in informatica.
> Preparing test cases for workflows.
> Involved in Unit Testing and System Testing.
Environment: Informatica,Oracle
Project # 2 MS2.0 Coke Report Implementation for Coke Inc. USA
Duration jan'08 to Nov'08
Client Name: Coke USA
Business Objects Report Developer
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 in
this project.Also some modification in Data warehouse, Data Model, Universe
and reports also done in this project..
Roles & Responsibilities:-
> Analysis of Data warehouse, data model, universe and BO reports.
> Implementing changes in Universe and reports as per New data model.
> Developing reports in BO.
> Preparing test cases for Reports and new changes.
> Involved in Unit Testing.
Environment: Business Objects 11 XiR2
Apr 06 to Aug 07, System Engineer/Actuate Report Developer IBM
India Pvt.Ltd
Project # 1 SMART (Self Managed Analytic and Reporting Tool)
Duration Apr'06 to Aug 07
Client Name: AMERICAN EXPRESS
Actuate Developer(System Engineer)
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.
Environment: Actuate erd-pro,Actuate iserver, Actuate Active portal,DB2
May 05-Apr 06, Jr.Actuate Developer Survik Software Limited Pune,
India.
Actuate Developer(Software Engineer)
> Analysis of new requirements.
> Studying Functional & Technical Specification
> Creating Design Documents based on the requirement.
> Created Own Actuate Libraries
> Designing and Developing Actuate reports
> Deployting it on Actuate iServer and iServer management
Environment: Actuate erdpro 7 sp2, Oracle 9i,SQl Server
> Creating Reports With Parameter & Hyper linking.
> Studying Database & Maximo Schema
> Created Template in Excel and Generated Output In Excel Sheets
Environment: Actuate erdpro 7 sp2, Sql Server
References: Available upon request[pic]