Engineer Data
Resume:
NISHANT V MADATHIL
*********@*****.***
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