NISHANT V MADATHIL

909-***-****

acekq3@r.postjobfree.com

PROFILE

A Business Intelligence, Datawarehousing and Data Integration professional

with extensive experience in architecting and implementing enterprise level

datawarehouse and data integration projects for over 17 years. Experienced

in all phases of the project life cycle - from business analysis, data

modelling and ETL architecture to design, development and implementation of

the solution. Exposure to Big Data implementation.

SUMMARY OF SKILLS

> 17 years of IT experience in leading teams and implementing Business

Intelligence, Data Warehousing and Data Integration solutions in

industries as varied as Entertainment, Healthcare, Pharmaceuticals,

Insurance, Retail and Shipping.

> Expertise in designing, architecting and implementing Business

Intelligence and Data Integration solutions end to end.

> Accomplished in all phases of the project life cycle - requirement study,

system analysis, technical architecture, data modeling, design,

development, testing and implementation of decision support systems and

data integration applications.

> Proficient in variety of Data Modelling, ETL and Business Intelligence

tools, besides programming and scripting languages.

> Experience in Hadoop/Big Data platform

> Excellent communication skills.

TECHNICAL SKILLS

Datawarehousing Ralph Kimball's, Bill Inmon's

Methodologies

Data Modeling Entity Relationship & Star Schema

Concepts

Databases/Platforms Oracle, SQL Server, DB2, Teradata, Hadoop

Business INFORMATICA: Informatica PowerCenter v9.1

Intelligence/ MCROSTRATEGY: Microstrategy v9

Data Integration BUSINESS OBJECTS: Business Objects (5.0.3),

Tools Designer, Business Objects, Supervisor, Broadcast

Agent, Web Intelligence 2.6 Web Administrator

COGNOS: Cognos Impromptu, Cognos PowerPlay, Cognos

Scenario, IWR, PPES

SAS: SAS v6.12 suite of products including Base

SAS, SAS Warehouse Administrator, SAS EIS,

SAS/Insight, SAS/STAT, SAS/AF,

DATA MODELING: Erwin, PowerDesigner

Programming SQL, PL/SQL, Hive, Shell Scripts, Batch Scripts

Languages

Platforms UNIX, LINUX, Windows.

EDUCATION

> B.Tech, Computer Science & Engineering, REC (NIT) Calicut, India

PROFESSIONAL EXPERIENCE

ELECTRONIC ARTS INC, Los Angeles, CA Jun 2011

- Present

Position: Datawarehouse Engineer

Environment: Windows, Linux, Oracle 11g, Teradata 13, Hadoop, Informatica

Powercenter v9.1, Microstrategy 9

Electronic Arts is amongst the biggest interactive software/gaming company

in the world.

As part of the Electronic Arts Digital Platform team, redesigned and

implemented EA's Pogo datawarehouse, besides contributing to design and

development of various phases of EA's Mobile business datawarehouse.

The datawarehouses provided end-to-end view of the user behavior enabling

business users to identify high value customers, enabling targeted

campaigns and narrowing down on profitable marketing channels. It also

provided game statistics and usages for the benefit of game development

teams to enhance game features for future releases.

Key Responsibilities:

> Complete redesign and data modelling of Pogo datawarehouse, design inputs

to Mobile datawarehouse

> Business Requirements gathering from end users, analysis of various

source systems, data profiling of source data

> ETL architecture including strategies to access source data from variety

of source systems, eliminating pitfalls and points of failure in the

previous architecture to ensure stability of the ETL on an ongoing basis.

> Design, Development, Testing and Implementation of ETL programs using

Informatica and batch/shell scripts.

> Creating and scheduling reports using Microstrategy

> Implementing Big Data environment on Hadoop for Mobile data.

> Migrating and consolidating Informatica environments to reduce licensing

costs

> Ongoing support and enhancements on newer business requests as needed.

ANTHEM BLUECROSS, Thousand Oaks, CA Feb 2007 - May 2011

Position: ETL Architect/Technical Lead/ Informatica Consultant

Environment: Unix, DB2, Informatica Powercenter v8.1, Oracle 9i.

At Anthem BlueCross, Enterprise Provider Database Solution (EPDS) was a

data integration project that aimed at consolidating all Provider

information from various source systems and disparate affiliated Healthcare

network systems into a single environment. The new environment was also

designed to have enhanced functionalities and features for the business

users.

As the technical lead and ETL architect, led an ETL team that comprised

both on-site and off shore resources, was part of the data architecture

team that modeled the enterprise ODS, did source system analysis of the

various data sources, designed and implemented the ETL system end-to-end

and managed the post-production support team.

Responsibilities:

> Source system analysis and data profiling.

> EPDS database design inputs

> ETL architecture

> Preparing functional and technical specifications for the ETL for the

various source systems.

> Leading the ETL Design, Development, Testing and Implementation effort.

> Post-production support.

AMGEN, Thousand Oaks, CA Oct

2005 - Dec 2006

Position: Informatica Consultant

Environment: Unix, Sybase, SQL Server, Oracle 9i, Informatica Powercenter

v7.1, Erwin 3.5.2

As part of the Business Information Systems group at Amgen, was involved in

3 separate projects -

(i) Was involved in developing and maintaining various interfaces which

provide data to and from various 3rd party vendors and internal clients

that provide different services to Amgen. Was also involved in developing

many new interfaces that would replace some of the existing interfaces once

the ERP implementation of the HR database went live at a later stage.

(ii) Was also involved in the Clinical Trials Accrual Project at various

times in an ETL role. This project was about the financial accruals from

various clinical trials that Amgen conducts. The role involved developing

and maintaining Informatica Powercenter mappings and Oracle stored

procedures.

(iii) Took up the Contract Management Datamart project during the later

part of the stay at Amgen. The role involved designing the dimensional data

model and designing and developing Informatica mappings.

Responsibilities:

> Interact with business users, identify and document requirements for

various interfaces.

> Design the data model for the Contract Management data model

> Design, Construct, Test and implement the solutions using various

technologies/tools like Informatica PowerCenter v7.1, Unix shell scripts

and PL/SQL stored procedures.

TRINUS CORPORATION, Glendale, CA Sep 2000 - May 2011

Position: Software Engineer, Technical Lead

Platforms & Technologies: Unix, Windows, Oracle, SQL Server, DB2, Business

Objects, Cognos

Trinus Infotech Corporation is a leading datwarehousing and business

intelligence solutions company.

As a Technical Lead and BI consultant, have lead and implemented BI and

data integration solutions at many of Trinus' clients, including big names

like Anthem BlueCross, Amgen, Mattel, BestBuy, American President Lines,

Intuit and California State Department of Health. Responsibilities

typically included system analysis, architecting and modelling the

database, design and implementation of ETL systems, leading teams including

on site-off shore models and post production support. The different

technologies and platforms at the various clients also mean a rich and

diverse experience, both from a technical as well as domain knowledge

perspective.

Responsibilities:

> Leading technical teams, designing and implementing Business

Iintelligence and Data Integration projects at Trinus' Clients

> Pre-sales write ups/presentations and assistance to sales and marketing

teams in pursuit of new clients

> Training Trinus' and clients' team members on various technologies and

platforms.

TATA INFOTECH, Bangalore, India Jul 1997 -

Mar 2000

Position: Systems Engineer, DSS Center of Excellence

Platforms & Technologies: Unix, Windows, Visual Basic, SAS, Business

Objects, Oracle, SQL Server

Tata Infotech (since merged with TCS) is a bellwether IT services company

in India.

As a Software Engineer, helped set up a Center of Excellence for DSS at

Tata Infotech. During this time, was involved in training new recruits on

DSS concepts, building in-house expertise on various technologies (e.g.

SAS, BusinessObjects), besides leading teams on datawarehousing projects

for various clients of Tata Infotech.

Responsibilities:

> Involved in setting up a center of Excellence for Decision Support

Systems at Tata Infotech

> Training new team members and building up technical expertise

> Leading technical teams in design, devlopment and implementation of DSS

systems at Tata Infotech's client sites.

Contact this candidate