Post Job Free
Sign in

Project Manager

Location:
King of Prussia, PA
Posted:
August 07, 2013

Contact this candidate

Resume:

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



Contact this candidate