Data warehouse Resume

SUMMARY

5 years and 2 months of IT industry experience encompassing a wide range of skill sets and roles.
Good experience with analysis, design, development, customizations and implementation of software applications including Data Warehousing and Banking applications.
Strong Abinitio skills with 5 years of experience involving Abinitio design and development of Code with features like PDL, Metaprogramming, Multiple Layout data processing from various source systems like OLTP databases, Unix flat files, etc.
Good knowledge of database and Data Warehousing concepts.
Strong functional abilities, flexible and goal oriented, good communication and interpersonal skills with self - motivation and quick learning at the work.

PROFESSIONAL EXPERIENCE

Data warehouse

Confidential

Responsibilities:

Processing flat files from the source team and loading it into database for long term reference.
Using same set of processed flat files and applying business transformational rules on source data to calculate client’s transactional details.
Storing client details into table created for scoped country in WEDW
Creation of views for persisted data in the database, fetching relevant data through SQL queries in WEDW downstream process like KPI calculation and variable calculation.
Developing the graphs according to the Technical design document
Performing unit testing for the graphs developed and preparing the Unit testing result.
Providing the warranty support in production environment.
Leading the team from the Cognizant side, total team size is 9 and 4 members are from Cognizant.

Confidential

Data warehouse

Responsibilities:

Processing flat files from the source team and loading it into database for long term reference.
Using same set of processed flat files and applying business transformational rules on source data to calculate client’s transactional details.
Storing client details into table created for scoped country in WEDW
Creation of views for persisted data in the database, fetching relevant data through SQL queries in WEDW downstream process like KPI calculation and variable calculation.
Reviewing the Technical design documents.
Determining the complexity of requirement and thus assisting team in performing the estimation
Developing the graphs according to the Technical design document
Performing unit testing for the graphs developed and preparing the Unit testing result.
Providing the warranty support in production environment.
Leading the team from the Cognizant side, total team size is 9 and 4 members are from Cognizant.

Confidential

Project period

Responsibilities:

Different source are used and they are combined together to create the required sources for coding
The sources are used and then dimension loading is done, also the business logic is implemented
With the use of dimension table key map table are created each keymap table contains multiple surrogate keys.
With the help of keymap tables fact table is loaded.
Reviewing the Technical design documents.
Determining the complexity of requirement and thus assisting team in performing the estimation
Developing the graphs according to the Technical design document
Performing unit testing for the graphs developed and preparing the Unit testing result.

Confidential

Project period

Responsibilities:

Source for this project is database which has only transactional data, We extract the data into our environment and maintain history.
This data is than transformed according to business logic and loaded to other set of tables.
Using transformed data as source data is populated into Summary table.
Understanding the business requirement
Reviewing the Technical design documents.
Preparing low level design document.
Determining the complexity of requirement and providing estimation.
Onsite - Offshore coordination.
Reviewing all the objects.