Jaswinder Singh Paul
King of Prussia, PA
Cell:630-***-****
Home: 610-***-****
*********@*****.***
Skill / I am B-Tech and having 10 years of IT experience
Experience in ETL/ Informatica Power Center 8x /9x
Summary Development and Oracle 9i/10g and Netezza as RDBMS
including Unix Shell Scripting. I have also
acquired good Knowledge of Complete Development
Life Cycle of Data Warehouse and PL/SQL Projects.
Also, I have experience working for various
clients in US, UK and India.
. 10+ Years of IT with complete SDLC experience from understanding the
requirements to code Deployment in Production.
. Experience in development of ETL and OLTP solutions using Informatica
Power Center 9.1 and Talend Studio
. Created complex mappings like slowly changing dimension (type1, type2,
and type3), slowly growing targets, and Simple pass through mapping
using Lookup, Joiner, Aggregator, Filter, Router, Update Strategy and
Expression transformations with Informatica Power Center.
. Design, develop, debug, and optimize ETL Workflows using Workflow
Manager and Workflow Monitor for Data Extraction and Data Loading for
Reporting.
. Experience of working with Oracle using Toad and SQL Developer and
Netezza RDBMS (SQL) using Aginity Workbench.
. Experience working with Unix Shell Scripting.
. Optimized performance and Debugging of ETL Code and well Versed in
Query tuning and optimization.
. Involved in Unit testing and smoke testing of ETL Code.
. Create or update functional and technical and design documents.
. Interacted directly with the client to know the business requirement
and executed the same in the projects.
. Knowledge of different Schemas (Star and Snow Flake) and Data Modeling
to fit reporting, query and business analysis requirements
. Worked with XML transofromations and Schemas to provide the XML files.
. Exposure to other tools: Toad, PL/SQL Developer, Autosys, Defect
logging tools - HPQC, Jira.
. Knowledge of Data Modeling, Dimensional Modeling and Business
Intelligence concepts
. Knowledge of other tools such as Informatica MDM, Power Exchange,
OBIEE, Business Objects, Erwin, SSIS, SSRS and SSAS.
. Knowledge of Complete Development Life Cycle of Data Warehouse
Project.
. Have good experience working with XML Files, Flat Files and RDBMS -
Oracle 9i/10g
EDUCATION: Bachelor of Engineering in Electrical Engineering
Technology Experience Oracle, Netezza, SQL, PL/SQL Extract -
Transform - Load (ETL), Oracle 9i/10g, Unix -
Shell Scripting
OS Windows NT/XP/1998, Unix (Shell Scripting)
Hardware Intel Pentium, HP
Tools Informatica Power Center 8x and 9x, Talend
Studio, Talend Admin Console, Autosys, HPQC,
Toad, PL/SQL Developer
Domain Experience Telecom, Banking and Finance
RDBMS Oracle 9i/10g, Netezza
Experience Profile - Key Projects
Project: EBAY ETL Development Duration: Apr 2013 - Till date
Customer name: Ebay Enterprise (US)
Location : King of Prussia, PA
Project Description:
Ebay Enterprise formerly known as GSI commerce is a second largest
e-commerce company in the world having various types of products
available for buying and selling online. Ebay enterprise has several
clients for which they design and create Data Warehouse for
respective web stores.
This Data Transformation Program (DTP) requires transformation of
various webstores such as Spanx, Sony, ToysrUS, Steinmart and other
store's data from its various Source Systems like Oracle and
FlatFiles according to defined business rules, and loading them into
Netezza as the target system (DW). This data is then used for their
reporting purpose This ETL process is carried out with the help of
Informatica Power Center and Talend Studio.
Tools: Informatica 8.6/ 9.1, Talend Studio
Software: SQL, PL/SQL
RDBMS : Oracle 10g, Netezza
Responsibility: ETL Developer
Role Description:
Requirements Analysis - Identify sources of data and document
business rules.
Developing Informatica mapping to implement techniques like slowly
changing dimension (type1, type2), slowly growing targets, and Simple
pass through.
Created various Transformations like Lookup, Joiner, Aggregate,
Expression, Filter, Router, and Update Strategy to implement the
business logic.
Creating tasks/Workflows to perform the ETL execution.
Working in Oracle as Source system to extract data and Netezza as a
Target System to load data into it.
Performing unit/integrated testing of ETL process.
Convert existing processing of data in to Informatica mappings and
move all tables into Landing/Staging area.
Perform data Extraction to move all data to Enterprise data ware
house (EDW)
Perform data validation and eliminate issues as a source.
Build Informatica ETL processes to load data through the Staging
layer in to EDW
Support down-stream users and migrate the down-stream users from
Oracle to Netezza
Creating HLD(High level design), TDD(Technical Design docs)and
Mapping document as per business requirement.
Developing Informatica mapping to implement techniques like slowly
changing dimension (type1, type2), slowly growing targets, and Simple
pass through.
Created various Transformations like Lookup, Joiner, Aggregate,
Expression, Filter, Router, and Update Strategy to implement the
business logic.
Creating tasks/Workflows to perform the ETL execution.
Performing unit/integrated testing of ETL process.
Daily communication with Scrum Calls, Weekly Status Calls and
SME/Business Analysts via email, chat, teleconferences.
Internal Quality Auditing of the deliverables before delivery.
Project: RBS DTP Data Warehouse Duration: Mar 2011 - Jan 2013
Development
Customer name: Royal Bank of Scotland (US)
Location : Chicago, IL, US
Project Description:
The Royal Bank of Scotland is one of the leading banks that provides
branch banking facilities throughout the British Isles and US. RBS
has around 700 branches, mainly in Scotland though there are branches
in many larger towns and cities throughout England and Wales. The
Bank of Scotland was effective in raising funds and as a result, The
Royal Bank of Scotland was established to provide a bank with strong
ties.
This Data Transformation Program (DTP) requires transformation of RBS
data from its various Source Systems according to defined business
rules, and loading them in target system (DW). This data is then used
by various applications of DTP for reporting purpose This ETL process
is carried out with the help of Informatica Power Center.
Tools: Informatica 8.6/ 9.1
Software: SQL
RDBMS : Oracle 10g, Netezza
Responsibility: ETL Developer
Role Description:
Gathering requirements with business and implementing as per business
requirement.
Attending daily scheduled Conference calls.
Experience of working with Oracle SQL and PL/SQL Procedures,
Packages, Functions and Triggers.
Experience working with Unix Shell Scripting.
Optimized performance and Debugging of ETL and PL/SQL Code.
Creating HLD(High level design), TDD(Technical Design docs) and
Mapping document as per business requirement.
Experience with Netezza as the Source System to load data into Flat
Files.
Implemented techniques like slowly changing dimension (type1, type2,
and type3), slowly growing targets, and Simple pass through mapping
with ETL tool Informatica.
Created various Transformations like Lookup, Joiner, Aggregate,
Expression, Filter, Router, and Update Strategy.
Participated in system design and data modeling( Logical and
Physical)
Assigning the work from functional & technical perspectives.
Mentoring the Team to resolve routine issues and problems and also
with the new CRs and Developments
Managing, coordinating, planning and executing project.
Handling team size of 6 members
Co-ordination with the Client/ Onsite Team in order to understand the
business needs.
Project: Data Warehouse Duration: Nov 2008 to Feb 2011
Development for BT Customers
Customer name: BT
Location: India, UK
Project Description:
BT is a British multinational telecommunications services company
headquartered in London, United Kingdom. It is one of the largest
telecommunications services companies in the world and has operations
in over 170 countries. Through its BT Global Services division it is
a major supplier of telecoms services to corporate and government
customers worldwide. Its BT Retail division is a leading supplier of
telephony, broadband and subscription television services in the UK,
with over 18 million customers.
This Assignment requires transformation of BT 21CN Customer data from
its various Source Systems according to various business rules, and
loading them in target system (DW). This data is then used by various
businesses for reporting purpose This ETL process is carried out with
the help of Informatica Power Center.
Tools: Informatica 8.6
Software: SQL
RDBMS: Oracle 10g, Teradata TD 12
Responsibility: ETL and PL/SQL Developer
Role Description:
Reviewing requirements with business and both onsite/offshore
management team.
Creating ETL design docs and Mapping document as per business
requirement.
Experience of working with Oracle SQL and PL/SQL Procedures,
Packages, Functions and Triggers.
Experience working with Unix Shell Scripting.
Optimized performance and Debugging of ETL and PL/SQL Code.
Created various Transformations like Lookup, Joiner, Aggregate,
Expression, Filter, Router, and Update Strategy.
Assigning the work from functional & technical perspectives.
Implemented techniques like slowly changing dimension (type1, type2,
and type3) and Simple pass through mapping with ETL tool Informatica.
Creation of various tasks, sessions, worklet and workflows and their
scheduling using Workflow Manager.
Interacting with the offshore and Onsite management.
Troubleshooting and Rescheduling in case of issues and problems with
the Workflows
Managing, coordinating, planning and executing project.
Ensuring proper utilization of resources.
Handling team size of 4 Developers.
Project: Customer Data Warehouse Duration: Apr 2007 to Oct 2008
Development
Customer name: Qualcomm (US)
Location: Santa Clara, CA, US
Project Description:
Qualcomm is world-leading provider of wireless technology and
services. Qualcomm is a global company, a firm with many facets, with
each business division changing the way and work through its own
unique contributions. But no matter what each Qualcomm business does,
all are united by a single, driving passion to continue to deliver
the world's most innovative wireless solutions
This Assignment requires transformation of Qualcomm Customer data
from its various Source Systems according to various business rules,
and loading them in target system (DW). This data is then used by
various businesses for reporting purpose This ETL process is carried
out with the help of Informatica Power Center.
Tools: Informatica Power Center 8.1
Software: SQL
RDBMS: Oracle 9i
Responsibility: Informatica Developer
Role Description:
Reviewing requirements with business and both onsite/offshore
management team.
Creating ETL design docs and Mapping document as per business
requirement.
Experience of working with Oracle SQL and PL/SQL Procedures,
Packages, Functions and Triggers.
Experience working with Unix Shell Scripting.
Optimized performance and Debugging of ETL and PL/SQL Code.
Created various Transformations like Lookup, Joiner, Aggregate,
Expression, Filter, Router, and Update Strategy.
Assigning the work from functional & technical perspectives.
Implemented techniques like slowly changing dimension (type1, type2,
and type3) and Simple pass through mapping with ETL tool Informatica.
Creation of various tasks, sessions, worklet and workflows and their
scheduling using Workflow Manager.
Interacting with the offshore and Onsite management.
Troubleshooting and Rescheduling in case of issues and problems with
the Workflows
Managing, coordinating, planning and executing project.
Ensuring proper utilization of resources.
Project: Operations and Duration: Jun 2003 to Mar 2007
Maintenance of BSS Customers
Customer name: BSNL
Location: India
Project Description:
Bharat Sanchar Nigam Limited (abbreviated BSNL) is an Indian
state-owned telecommunications company headquartered in New Delhi,
India. It is the largest provider of fixed telephony and fourth
largest mobile telephony provider in India, and is also a provider of
broadband services.
It is India's oldest and largest communication service provider
(CSP). It had a customer base of 95 million as of June 2011.
The purpose of the project was to operate and maintain their GSM and
CDMA Network BSS (Business Support System) customer Database. This
comprises of operations and maintenance of BT BSS customers 24 x 7
including their Billing, Mediation, Payment and Revenue systems.
Tools: IRB 3.0 ( Billing Application)
Software: SQL, PL/SQL
RDBMS: Oracle 9i
Responsibility: PL/SQL Developer
Role Description:
Operations and Database Maintenance for BSS data using PL/SQL scripts
to Oracle 9i Databases.
Experience of working with SQL and PL/SQL Procedures, Packages,
Functions and Triggers.
Designed and created database tables, views and stored procedures and
Built and maintained SQL scripts, indexes, reports and queries for
data analysis and extraction.
Created different Cursors and Reference Cursors in various Procedures
and Packages.
Extensive experience in creating and executing SQL queries and Query
tuning and optimization
Created test scripts for application module and performed Unit
Testing of application.
Interacted with the end users to define and document business
requirements as the foundation for database design and analysis.
Mentoring the Team in troubleshooting routine issues and problems and
also with the new CRs and Developments.
Co-ordination with the Client in order to understand the business
needs.
Training / Continuing Education Summary
Program or Course Coverage Year
Oracle Certified Oracle 9i - SQL and PL/SQL
Associate - Developer
2010
Oracle Certified Oracle 9i - Fundamentals of 2010
Associate - DBA Database Administration concepts
Informatica Power Informatica setup, mappings, case 2007
Center studies, Designer, Workflow manager
and Monitor
Netezza Introduction to Netezza 2012
Architecture
International Standard All Testing Methodologies and 2009
Training Quality Board concepts
(ISTQB)
Business Objects Introduction to reporting processes 2011
and concepts 6.0
OBIEE Introduction to OLAP concepts and
reporting using OBIEE 10.1.3
HP- Quality Center HPQC overview and concepts 2008
Unix/ Shell Scripting Unix commands and Shell script 2006
writing using sed and awk commands