Dimple Wadhwa
acwfcb@r.postjobfree.com
Career objective
To become a part of an organization where I can learn technically and create value for the organization. As
well as achieve growth as a professional, in an amicable environment.
Experience Summary
4.3 years of professional experience.
•
Organization Designation Duration
Infosys Ltd Senior Systems Eng 3.4 years
Cognizant Technology Solutions Pvt Associate Projects 9 months
Ltd
Technology Experience
Technology Data Warehousing, Informatica Developer, ETL Testing
Tools Putty(UNIX), HP Quality Center, Informatica, MS Office, SQL Server
2008, WinSCP
Database MS SQL, Teradata
Aware of SDLS, STLC and Defect Life cycle.
•
Involved in the detailed analysis, design, documentation, development of the transformation process
•
Development of Mappings and Workflows to perform Extraction, Transformation and Loading Data (ETL)
•
Used Workflow Manager/Monitor for creating and monitoring workflows.
•
Extensively used mapping parameters, mapping variables and parameter files.
•
Aware of design of database applications and with all stages of SDLC from requirement study to
•
support and developing in line with SDLC, Database Designing, Coding Standards, Documentation
Extensively involved in Manual Testing (Black Box Testing), Data warehouse Testing (ETL Testing),
•
Regression Testing, SIT testing, end to end testing and Data warehouse Migration.
Successfully performed multiple roles like writing SQL queries, preparing the Test Plan,
•
Test Strategy, Test cases writing, Test Executing, Defect Management and Test Closure Report.
Participated in status meetings jointly with the team as required, active in onsite offshore interactions
•
and submitting daily status reports to the lead.
Aware of design of database applications and with all stages of SDLC from requirement study to
•
support and developing in line with SDLC, Database Designing, Coding Standards, Documentation.
Experience Profile
Project: Payless,Avis Budget Group
Project Description: Payless Project is a car rental company owned by Avis Budget Group. It had number of
systems in scope.This was a migration project in which information from the legacy system (Mainframes) to
Oracle Database 11g database according to the business logic. The ETL tool used in migration to articulate
the transformation is Informatica. Flat files are used as a source and Oracle Database 11g acts as a staging
area and target. It involved acquiring files from the respective system then the acquired files were loaded into
the target tables.
Tools/Technologies Used: QC, Putty, Unix, Oracle Database 11g, Informatica, WinSCP
Responsibilities:
Involved in the detailed analysis, design, documentation, development of the transformation process
Development of Mappings and Workflows to perform Extraction, Transformation and Loading Data
(ETL)
Used transformations like Sorter, Connected & unconnected lookups, Filters, Expression, Router,
Joiner, Union, Source Qualifier etc.
Used Workflow Manager/Monitor for creating and monitoring workflows.
Extensively used mapping parameters, mapping variables and parameter files.
Responsible for all phases of project such as development, unit testing, system testing.
Involved in handling of defects
Preparation of project documents
Test data and Test Scripts preparation for Unit Testing and System Testing.
Logging and Tracking the defects using quality center.
Preparing status reports for tracking progress during the execution period.
Attending status and defect calls.
Project: Trade Management System, Barclays
Project Description:This was a migration project in which customer information from the legacy system (Mainframes)
to TI Plus according to the business logic. The ETL tool used in migration to articulate the transformation is Informatica.
Teradata and flat files are used as a source and Teradata acts as a staging area and target. The informatica
transformations comprises of basic data validation checks.
Tools/Technologies Used: QC, Putty, Unix, Teradata, Informatica, WinSCP
Responsibilities:
Involved in the detailed analysis, design, documentation, development of the transformation process
Development of Mappings and Workflows to perform Extraction, Transformation and Loading Data (ETL)
Used transformations like Sorter, Connected & unconnected lookups, Filters, Expression, Router, Joiner,
Union, Source Qualifier etc.
Used Workflow Manager/Monitor for creating and monitoring workflows.
Extensively used mapping parameters, mapping variables and parameter files.
Involved in handling of defects
Preparation of project documents
Test data and Test Scripts preparation for Unit Testing and System Testing.
Review Activities.
Tracking of issues in a well organized way.
End to End business process validations.
Logging and Tracking the defects using quality center.
Preparing status reports for tracking progress during the execution period.
Attending status and defect calls.
Project: Spring, Barclays
Project Description: The Spring project had number of systems in scope. The systems had similar requirements,
although they process various kinds of accounts including personal credit, commercial accounts and loans accounts. It
involved acquiring files from the respective system then the acquired files were loaded into the Teradata target tables
which were being further used for generating Cognos report.
Tools/Technologies Used: QC, Putty, Unix, Teradata, Informatica, WinSCP
Responsibilities:
Involved in writing Test Cases.
Executing the Test Cases.
Logging and Tracking the defects using quality center.
Preparing status reports for tracking progress during the execution period.
Study the Functional Requirement and identifying the Test Scope.
Prepare the Test Plan & Test Scenarios.
Involved in writing SQL to validate data
Responsible for Defect Management (Tracking and Reporting) and Keep track of defect status.
Following up with the Dev team till closure.
Preparing Test Status Reports (Daily Status Report DSR) during Test Execution.
Project: Global Commercial Payments, Barclays
Project Description: The Global Commercial Payments alias IVR is to deliver small and medium business customers
some ability to serve through an IVR. This delivered an IVR solution which enhanced Barclaycards ability to identify
incoming call type, route calls based on the number of defined conditions, attempt the verification of cardholders and
introduce self service by callers which require an update of their current balance into Barclaycard Commercial business
models.
Tools Used: Unix, Informatica 9.1.0, Teradata and Quality Center.
Responsibilities:
Was involved in Testing the application manually.
Writing SQL queries, executing them and comparing the data entered through application with the data
generated by the queries.
Reporting the defects and getting them fixed.
Preparing Test Status Reports (Daily Status Report DSR) during Test Execution.
Project: Basel, Barclays
Project Description: The Basel project had been tasked with acquiring files from call credit and making available to
the users. These files are predominantly used for Basel models. The acquired files were loaded into the staging area
and loaded into the Teradata target tables
Tools Used: Unix, Informatica 9.1.0, Teradata and Quality Center.
Responsibilities:
Study the Functional Requirement and identifying the Test Scope.
Prepare the Test Plan & Test Scenarios.
Involved in writing SQL to validate data
Responsible for Defect Management (Tracking and Reporting) and Keep track of defect status.
Preparing Test Status Reports (Daily Status Report DSR) during Test Execution.
Project: Mystic, AMEX
Project Description: : The Mystic project was to migrate the existing Data warehouse on DB2 to Netezza. It involved
conversion of ETL related components on Datastage and scripts to read from and load into Netezza tables. This
included modification of existing jobs, testing them after the changes and validation with the data of the existing system
Tools Used: Datastage 8.0.1, Unix, DB2 and Netezza
Responsibilities:
Analysis of existing scripts and DB2 Functionality and data analysis that are up for modification.
Setting up the files and the data required for the scripts.
Modification of Datastage jobs, testing them after the changes and validation with the data of the existing
system.
Responsible for developing, testing, implementing, troubleshooting and resolving issues.
Performed Unit and System testing.
Writing SQL queries, executing them and comparing the data generated by the application with the data
generated by the queries.
Reporting the defects and getting them fixed.
Education Summary
Examination University/Board School/College Year Division
B.Tech(ECE) Maharishi Maharishi Markandeshwar 2007 2011 First
Markandeshwar Engineering College, Haryana
University
CBSE Board GMSSS 21, Chandigarh 2007 First
AISSCE
CBSE Board GMSSS 19, Chandigarh 2005 First
AISSE
Personal Information
Permanent Address: 1010 Wilshire Blvd, Los Angeles,
CA 90017
DOB: 24th Sept 1989
Passport Details: Passport No: G7661830
Valid Till: 4th Mar 2018
DECLARATION:
I hereby declare that the details furnished above are true to the best of my knowledge and I own the
responsibility for its correctness.
Date: 08/31/2016
Place: LOS ANGELES
DIMPLE WADHWA