Project Assistant

AVISHEK MUKHERJEE

http://www.linkedin.com/pub/avishek-mukherjee/20/bb3/346

Email: ******@*****.***, ***.*******@*****.***

Skype id: avi_muk

Cell: +1-408-***-****

PROFESSIONAL SUMMARY

IT professional with 7+ years of diversified experience in Data warehousing and Business

Intelligence technologies.

Technical skill: Teradata (Primary, 5+ years), Oracle (2 years), Informatica (2+ years),

Unix Shell scripting (5+ years)

Domain skill: Extensive knowledge in CRM, Marketing Campaign Operations and

management.

Working as a Solution Architect/Technology Lead for last 3+ years involving:

Database/Application design & review

Physical data modeling

Performance engineering

Database management & system monitoring

Database Upgrade (Co-ordination & Technical help)

User (Business Analyst) training

POC (Proof of concepts)

Preferred job positions: Solution Architect/Technology Lead, BI Development lead, BI

Analyst, Teradata Engineer, Senior Business Analyst, DBA

Current Employer Infosys Technologies Ltd.

Currently working on TD 13.10 Database with capacity of 850+ Terabytes running on 2

production servers consisting of 114 and 46 nodes respectively of “6650” family and 3

Appliances.

More than 5 years of experience in EDW Teradata (TD13/TD12/V2R6). 2 years of

experience in Oracle 8i.

Overall 4 years of experience in customer interfacing and project management (Onsite)

experience on projects involving development, implementation & maintenance of Business

Intelligence Data Warehouse applications in EDW Teradata.

Presently responsible for Enterprise Data Warehouse Performance Engineering and

Management Solutions which includes design/architecture review for new applications,

system monitoring & performance support, SQL performance tuning, Proof of Concept and

user training.

Experience in migrating several Oracle legacy applications to EDW Teradata .

Responsibilities included, Proof of concepts (POC), design, development, functional and

integration testing, assisting users during user acceptance testing, successful implementation

and primary support for the applications.

Involved in many hardware and software upgrade activities in EDW Teradata [Like

V2R6 to TD12, TD12 to TD13, addition of nodes etc.]. Responsibilities included analyzing

impact in terms of performance and functionality, Pre/Post Performance benchmarking,

finding alternatives for unexpected behavior in the new system and following up with

Teradata to come up with the fix etc.

Expertise in SQL/PLSQL programming, developing and executing Stored Procedures,

Functions, Macros, Table Partitioning, Table Compression, Join indexes.

Extensive experience in Teradata TD13/TD12 ETL Utilities like Bteq, MLoad, FLoad, TPT,

Tpump and Fast export.

Experience in session routing tool, Teradata Query Director (TQD).

Experience in data replication tool Teradata Data Mover. (TDM).

Experience in using various tools of TASM /Teradata Active System Management. Like

Teradata Workload Analyzer, Dynamic Workload Manager, Teradata Manager etc.

Experience in using Teradata Viewpoint portal. Extensively used portlets like Metrics

Analysis, Metrics Graph, Query Monitor, Query Spotlight, Node resources, System health

etc.

Experience in data replication framework set up using Unity.

Extensive experience in using Teradata client Tools like Teradata SQL Assistant and SQL

Workbench.

Experience in designing the architecture of the Extract, Transform and Load process and

development of transformation standards and processes using Informatica best practices.

Have in depth knowledge and experience in implementing the best practices for design and

development of data warehouses using Star schema & Snowflake schema design concepts.

Involved in projects for domains like Manufacturing (95%) and Healthcare (5%).

Extensively involved in project coordination activities by keeping track of various project

milestones and organizing weekly project reviews throughout the entire SDLC.

Extensive experience in UNIX shell scripting (Ksh), Job scheduling using Autosys.

Experience in using version control tool like CVS and SVN.

Experience in Project and people management of leading large development teams (10-15

people), client interaction, requirement gathering and analysis, architecture definition, design,

development, testing, implementation and maintenance.

TECHNICAL SKILLSET

RDBMS : Teradata 13.10, TD12, V2R6, Oracle 8i/9i/10g/11g

Database utilities : Teradata Parallel Transporter (TPT),Mload, Fload, Tpump, Bteq

Client tools : Teradata SQL Assistant, SQL Workbench

Database Monitoring/Resource management: View Point, TASM

Database object copy: Data Mover

Data replication: Unity

Session routing/Load balancing: TQD

ETL Tools : Informatica PowerCenter/PowerMart 9.1

Reporting Tools : Business Objects 6.5/XI R2

Scheduling Tool : Autosys

Languages : SQL, PL/SQL, C/C++, Pro*C, PERL

Web Technologies : Java Script, HTML, DHTML, XML,

Operating Systems : UNIX (AIX 5.2), Windows 95/NT/2000/XP/7, MacOSX

Versioning Tools : Win CVS, SVN

Hardware : MacOSX, Sun/Solaris, RS6000/AIX server

EDUCATIONAL QUALIFICATIONS

Bachelor of Engineering (B.E) in Computer Science & Engineering

PROJECT SUMMARY

Employer: Infosys Technologies Ltd.

Client: Apple Computer Inc.

Performance Engineering and Management

Feb 2009 – till date

Technology Lead (San Francisco Bay Area)

This project provides performance engineering and management solutions to efficiently manage Apple’s

Business Intelligence area. This includes better capacity planning, correction and prevention of unwanted

high resource usage, identifying slots for scheduling ETLs and Business Object reports, Input to cost/benefit

analysis for each business group, Reducing the Physical utilization of the system by reducing the CPU, Spool

and IO. This has also achieved to establish a round a clock performance monitoring process in place that

would provide Key performance indicators, dashboard data, resource usage, load parameters and key system

parameters in an almost real time basis.

Responsibilities:

Design/Architecture review for new applications

System Monitoring & Performance Support

SQL Performance Tuning

Proof of Concept

User Training

Coordinating with all the application teams and helping them streamlining/optimizing the application

performance.

Technology:

Teradata (13,12,V2R6), TASM, TPT, Mload, Fload, Tpump, Bteq, TQD, Data Mover, Teradata SQL

Assistant, SQL Workbench

Employer: Infosys Technologies Ltd.

Client: Apple Computer Inc.

Apple Production Support

October 2008 till Jan 2009

Technology Assistant (San Francisco Bay Area)

Numerous important and business critical applications across a wide class of business spaces such as Sales,

Operations, Marketing, Research & Development, Human Resources, Customer Relationship Management

and Planning, Finance, Reporting, Directory Services etc. are supported in this project. The project has its

crucial contributions in keeping up with the day-to-day operations of Apple Inc., normal and smoothly

running. All different aspects of business applications and their issues, including technical as well business

workflows and rules are catered in this project. Business continuity and maintaining smoothness is one of the

key driving factors of the project.

Responsibilities:

Business & System Support

Change management and Control.

Application Maintenance

Capacity planning

User Training

Client Interfacing

New Application Transitions

Environment:

Teradata (6.2), Oracle (9i), Mload, Fload, Tpump, Bteq, Teradata SQL Assistant, SQL Workbench,,UNICA

Affinium

Employer: Infosys Technologies Ltd.

Client: Apple Computer Inc.

Migration of marketing data mart from Oracle legacy to EDW Teradata

February 2008 till September 2008

Technology Assistant (San Francisco Bay Area)

Purpose of this project was to migrate the whole legacy data mart related to marketing area from Oracle to

Teradata. This data mart is one of the major contributors of Apple’s success story in reaching out to customers

through right channel at right time for a right product. As this data mart helps in customer analytics, sales

reporting, campaigning etc., it deals with very complex business logic and enormous data volume from

numerous operational systems and needless to say one of the most important database applications in Apple.

Responsibilities:

Several Proof of concepts (POC) to ensure consistency of system behavior in new technology and

accommodate new features.

Design and development

Functional and integration testing

Assisting business users during user acceptance testing

Successful implementation and primary support for the applications.

Leading a 10-15-member team.

Technology:

Teradata (12,6.2), TASM, Mload, Fload, Tpump, Bteq, Teradata SQL Assistant, SQL Workbench, Informatica

8.6.1, Oracle 8i, Unix Shell Script, UNICA Affinium.

Employer: Infosys Technologies Ltd.

Client: Apple Computer Inc.

Campaign Management System (CMS)

April 2006 till January 2008

Technology Assistant (India)

The application provides the apple marketing team with the real time data for customer behavior. It also

provides a set of tools to create and execute promotional campaigns and measure the responses to create more

effective campaigns. The application enables the, marketing analysts to do the activities like automation of

campaign generation and list processing, improve demand generation program growth and efficiency, closed

loop response tracking capabilities.

Responsibilities:

Client Interfacing

Requirement Gathering & Analysis

High Level Design

Detailed Design

Software Development

Test Planning

Integration testing

Product implementation

Mentoring Offshore Team

Environment:

Teradata (6.2), Oracle (9i), Mload, Fload, Tpump, Bteq, Teradata SQL Assistant, SQL Workbench, UNICA

Affinium

Employer: Infosys Technologies Ltd.

Client: Apple Computer Inc.

Apple Customer database (ACD)

July 2005 till March 2006

Software Engineer (India)

The Apple Customer database, ACD, is a central repository wherein Apple maintains all registration

information pertaining to its customers. The data maintained herein plays a pivotal role and becomes a crucial

input for strategic business planning and decision-making. The project entails maintaining this database and

makes endeavors to constantly enrich the customer information leading to accurate analysis and better-

targeted campaigns. ACD also assures that Apple customer is recognized across all systems and is not

duplicated in any system. This establishes a central repository of customer information in Directory Services

that can provide all divisions of Apple globally with a common, 360-degree view of the customer.

Responsibilities:

Preparation of Detailed design

Formulating test strategy.

Software development.

Unit testing

Integration testing

Deployment

Environment:

Oracle 9i,Unix (AIX 5.2), SQL, PL/SQL, Webobjects, Shell scripting

CERTIFICATIONS

Teradata 12 Certified Technical Specialist

Oracle Certified Associate (OCA)

Infosys Technical - OS Technology 203

Infosys Technical - PR Bridge OS Programming

Infosys Technical - PR 301 OS Advanced Programming

Infosys Technical - PR 101 OS Foundation

Infosys Technical - PR 201 OS Basic Programming

Infosys Domain - PM Elite Lite

Infosys Domain - IQ Foundation

Infosys Domain - Foundation course Hi Tech Discrete Manufacturing

Infosys Domain - MFG FND Course

Contact this candidate