Data Project

A KH I LENDRA GOSWAM I

*************@*****.***

210-***-****(C)

I am an accomplished and versatile system professional with considerable experience in

E TL, Data architecture and enterprise data management. I have more than 14 years of

experience in designing, developing and End to End Implementation of IT solutions.

Well versed in ETL tools like I nformatica Power Center versions (latest 9.5), Data

S tage etc.

Establishment of E TL I nformatica coding and implementation standards.

Excellent knowledge of P L/SQL and Unix Scripting

Versed with K imball and I nmon data warehousing philosophies

Advanced knowledge and hands on production experience in m ulti-tiered data

w arehousing architecture (ODS/Marts and ODW/warehouse)

Excellent D ata Analysis and Data mining skills.

Well versed in ETL architecture and Designs and End to End implementation of

various BIDW and Data Migration projects

Extensive experience in d imensional d ata modeling using Erwin and ER Studio

Established consistent d ata element definit ions, define meta data standards and

environment to support meta data collection

Developed process for capturing and maintaining meta data f rom all data

warehousing components

Created and Maintained d atabase dictionaries a long with identifying data

sharing opportunities

Identify and Implemented E TL Components for an integrated reporting system

Excellent knowledge of relational database design including normalization,

r eferential integrity, database t r iggers, user defined functions, user defined data

t ype, views, data aggregation/manipulation

Conducted required source system analysis and d ata analysis review session with

t he SME.

Ensured alignment of system requirements with actual business processes using

s tandard analysis techniques such as use case scenarios and business process

modeling

Strong project and people managerial skill to execute the project end to end,

managing the overall project delivery, adherence to schedule and in acceptable

quality.

Well versed with both Waterfall and Agile(Scrum) SDLC Model

An outstanding ability to define business functions as generalized metadata,

enabling systems to provide long-term stability and reliability.

Work Experience

Project 1: C reating Reference Data Hub (12/2013-Till Date)

Client: C itigroup (New Jersey, USA)

R oles: Data Architect/Data Modeler

• Design and develop reference data management framework and create single source

of t ruth for the data referenced by multiple applications

• Data Standardization and Data Profiling

• Design Data Approval Framework (Workflow)

• Design and Develop Data Subscription Model for downstream application from the

reference data hub

Project 2: Customer Billing Data Migration (05/2013-11/2013)

Client: Rackspace (San Antonio, TX)

R ole : Informatica ETL Lead

• ETL Design and Development using Informatica, Oracle and Postgre SQL

• Defining cutover strategy for data migration, prepare cutover plan and deployment

p lan

• Data Analysis and Gap Analysis for coming up with t ransformation logic

• Data Analysis and profiling for Phased migration

• Design and development of reconciliation reports and dashboards for data validation

a fter migration

• Defining exit criteria for different phases of testing

• Creation of progression report and future releases plan

• Manage and define scope of each of the release and get it approved from the client

• Defining and collecting metrics on the project progress for reporting to the client.

• Existing system analysis to prepare technical specs

Project 3: Regulation Report M igration from Actuate to Assentis (9/2012 – 4/2013)

Client: U BS (Swiss Based)

Role : Informatica ETL Lead

• System Design: Multi-Layer framework, Designing ETL Layout, Data Design

• Designing of audit control unit to monitor and t r iggering the ETL and Reporting

jobs.

Technology Used : Informatica Power Center, Oracle, BO, UN IX and DB2

Project 4: I nsurance Policy Data M igration (9/2011 – 8/2012)

Client: A merican Family Insurance (Madison, WI)

Role : Informatica Lead

Worked as Data M igration Architect and Technical Lead to design and develop Data Mart

and ETL for life policy data mart migration from DB2 to Oracle with couple of new source

system.

• System Design, Designing ETL Framework, Data Modeling, Data Analysis, Gap

A nalysis and develop ETL Code

• Review Code for standards, performance

• Migration of BO reports from DB2 to Oracle

• Cutover planning, design for migration, data reconciliation report design for data

validation

• Lead a team of 12 developers and 2 Tech Leads

• Worked on performance tuning of both ETL and Data ret rieval for the reports.

•

Technology Used : Informatica Power Center, Oracle, BO, UN IX and DB2

Project 5: O EM Revenue Sharing Data Mar t (6/2010 – 8/2011)

Client: Symantec Corporation (Sunnyvale, CA)

Role : Sr. ETL Lead

Worked as ETL Lead and Architect to design and develop ETL for Symantec Norton OEM

revenue share Data Mar t and EDW.

• ETL Design, Develop ETL Code using Informatica,

• Designing ETL Framework, Data Modeling (Staging and ODS) and Data Analysis

• perform sizing and effort estimations for the ETL

• Data Gap Analysis and build and implement data rules in ETL and Database design

• Managed of team of 5 developers and project planning

Tools and Technology : I nformatica Power Center, Oracle, BO and UN IX

P roject 6: L ife Monitor DW ( 03/2009-05/2010)

Client: Morgan Stanley Smith Barney (NY, NY)

Role: Senior Tech Lead

• Design and Develop ETL Jobs for data extraction from the sources to Stage, ODS

and Data Mar ts

• Work with data governance team to get the approval on the data to be staged for Life

Monitor Data Marts

• Worked as Data Stewart

• Develop project plan and work with client to set-up t imelines for each of the releases.

• Coordination with offshore manager on budgeting, team composition and resource

a llocation and de-allocation.

• Status reporting, r isk assessment and periodic evaluation of the project progress.

• Coordinate with team to set priorities, schedule weekly/monthly tasks, anticipate

and mitigate conflicts/issues.

• Defining and collecting metrics on the project progress for reporting to the client.

• Work with client for the change requested and its impact on the delivery dates and

u pdate plan accordingly.

• Managing the project resources to best meet project objectives.

• Code Review and providing solutions to the developers.

T echnology: Informatica 8.5.1, SQL Server 2000 and UN IX scripting.

Project 7: Swaps Data Mar t (11/2007-01/2009)

Client: Lehman Brothers (Jersey City, NJ)

Role: Team Lead and ETL Designer

• Develop project plan (timelines, resource allocation, activities for each phase).

• Proactively managing scope to ensure the t imely and complete delivery.

• Managing and directing the assigned project resources to best meet project

objectives.

• Coordinate with team to set priorities, schedule weekly/monthly tasks, anticipate

and mitigate conflicts/issues.

• Coordinate with QA to ensure that the solution developed is of acceptable quality as

per the company standards.

• Created ETL specs for loading data into the data marts generated from the source

Delta 1 system.

• Created detailed analysis, implementation and maintenance documentation.

• Writing functional specs and technical specifications.

• Design and create Informatica Mappings to cater the Business requirements.

• Design and create Informatica workflows to implement business dependencies

(dependency of one system on another) and to run the Informatica code in most

efficient way.

• Review code (mappings & Workflow created) by others in the team.

T echnology: Informatica 8.1, BO XI, Sybase 12.5, Oracle 10g and UN IX scripting.

Project 8: Global Hygiene and Match (07/2007 – 10/2007)

Client : D &B (Center Valley, PA)

Role : ETL Informatica Lead

• Design and re-architect the existing system for new business init iatives.

• Writing Functional requirement, use cases and design document

• Customer data Validations and reporting ambiguity.

• Report to business on each of the data issue and reporting data quality to the Source

system.

• Fixing production defects.

• Offshore-Onshore Co-ordination and passing requirement to offshore team.

T echnologies: I nformatica, PL/SQL and SQL loader, O racle 10g, DB2, Informatica 7.1,

P L/SQL, UN IX

Project 9: CRM DW (11/2006 – 06/2007)

Client : Thomson Healthcare (Evanston, I L)

Role : ETL Lead and Data In tegration Engineer

• Development ETL leads for Customer relationship management warehouse (CRM),

Outpatient warehouse & Mar t.

• Analyze system requirement and provide ETL estimations.

• Create ETL design spec and design ETL/Informatica architecture.

• Work with Data quality team to provide them data quality report that received from

t he clients.

• Setting up test environments for QA and UAT

• Writing UN IX shell script for automation of data files archival and executing

I nformatica workflows.

Technology: O racle 10g, Visio, Informatica 7.1, PL/SQL, UN IX

Project 10: CDW (Commercial Data Warehouse) (5/2004 – 11/2006)

Client : ABN Amro/Bank of America (Chicago, I L)

Role : ETL Tech Lead/Sr. Developer

• ETL Informatica Coding and Testing

• Lead gap analysis of source system feed and the financial warehouse att r ibutes.

• Performed source system analysis based on the functional requirements of data to

be loaded into the data warehouse

• Developed both the logical (conceptual), physical models and successfully validated

t he models against requirements

• Prepared the ETL Design document and ETL mapping document along with the

test cases.

• Developed models for Data Warehouses (Dimensional Modeling) to develop data

loading programs using I nformatica, PL/SQL and SQL loader.

Environment: O racle 8i & 9i, Erwin, Visio, Informatica, PL/SQL, UN IX

Project 11: L ive-L ink Implementation (7/2003 – 4/2004)

Client: Capital One (Richmond, VA)

R ole: Team Lead

• Development Lead for web based document and content management application

developed in Java, PL/SQL, O racle 8i and Live link.

• Developed System appreciation Document.

• Design and developed P L/SQL Procedures and functions for the application.

• Analyzed the technical architecture gaps, and define the technical architecture

requirements for closing those gaps.

• Participated in t ransitioning the requirements and use cases to the designers, and

ensure a clear and complete understanding of the requirements.

• Coding in OScript (Live link language) for customization of Live link implementation

Environment: O racle, UN IX, Live link, H T M L

Project 12: Various Projects on VC++, Oracle (PL/SQL) and Crystal Reports ( 5/2000 –

6/2003)

Client: F irst USA Bank/Chase (Wilmington, DE)

R ole: Developer

• Developed and managed conceptual, logical and physical models and definition of

data resources, leading to the ongoing design of an integrated data architecture

• Prepared detailed specifications, logic flowcharts and t ransformation r ules for the

development and implementation of application and reports

• Developed stored procedures, t riggers, VB & VC++ modules external tools in

i ntegration with external tools Like FileNet.

• Specified and constructed the use case diagrams for the integrated FileNet application

• Wrote a dvanced PL/SQL Scripts to setup test data

• Develop, integrate manage F i rst Look data model

• Developed stored procedures, tables, indexes and jobs to implement various

business functionalities

• Participated in process performance tuning, optimization and provided tuning

assistance to clients for their database

• Responsible for d ata loading and t est planning

• Development of Reports for In ternal Audit purposes using C rystal reports and

P L/SQL

• Created and executed P L/SQL Queries for testing

Environment: Oracle 7.3.4, Oracle 8.1.7, UN IX, Windows NT, Oracle Developer 2000

& 6 i, TOAD, Crystal Report 7.2, Test Director

Contact this candidate