Project Management

PIJUSH CHATTERJEE

Phone# 773-***-****

Email#abnigz@r.postjobfree.com

ITIL v3 Foundation certified and pursuing Project Management certification from PMI

CAREER OBJECTIVE

Senior level responsibility with an organization, where demonstrational skills in client service, leadership,

organization and technical ability can be translated into improved customer satisfaction, growth and

profitability.

SUMMARY

Seasoned professional offering 12 years of experience in Information Technology with in-depth knowledge in

Enterprise Data Warehousing, Business Intelligence, ETL Architecture, Data Architecture & Modeling,

Metadata, Service Delivery and Support, Process management like ITIL, COBIT, Team building, Outsourcing,

Vendor management, IT Governance and Risk management. Also, extensive experience in managing enterprise

IT project life cycle through all phases.

• Worked with IT and Business Leadership to formulate Data Warehouse and Business Intelligence

Architecture Strategy, Tool Selection, Hardware recommendations, Implementation Life Cycle and

Production Support Guidelines

• Experienced in all phases of SDLC in 24 *7 environment of Very Large Data Warehouse projects

including implementation of IT Service Management practice based on ITIL

• Expert knowledge in Performance Tuning of Business Intelligence query and access path

optimization(Business Object, Cognos), Database Performance(Teradata,Oracle,DB2), ETL processes (Ab

initio, DataStage), Data Modeling(Erwin) and Unix System Performance

• Experienced in ITIL implementation of Service design, Service delivery, Service support, Capacity

management, Incident management, Problem management and Availability management

• Extensive experience in managing enterprise IT project life cycle through all phases.

• Information Systems Audit and Control Association(ISACA) member

TECHNICAL SKILLS

OS: HP-UX, AIX, Sun Solaris, MVS, Windows NT

RDBMS: Teradata 12.0, Oracle 9i/10g, DB2 UDB 9, Sql Server

ETL Ab initio2.13/2.15,DataStage 7.5/IBM Information Server 8.0.1, Informatica 8

Data Modeling Erwin 7

Business Intelligence Business Object XI/6.5, Cognos 8.3

Languages: SQL, PL/SQL, Pro*C, C, Unix Shell scripting, Perl

Web Technologies: JDBC, Java Servlets, Java Web Server, Apache

Batch Scheduler Autosys, Tivoli, Control-M

Software: Microsoft Office, MS Project, Ms Visio, Toad, Benthic, Clear Case, Clear

Quest, Harvest, Peregrine, Clarity, Ab initio EME, Quality Stage, Rational

Rose

EXPERIENCE

USA:

Saven Technologies, USA March 2003 – Till Date

•

Managing Consultant

Omniscient Systems, USA October 2000 – February 2003

•

Sr.Consultant

INDIA:

Usha Martin Telecom(Hutch), India September 2000 – November 2000

•

Sr. System Manager

Price Water House Coopers/ Nicco Corp. India June 2000 – September2000

•

Sr. Database Manager

McNally Bharat Engineering Comp. India September 1999 – June 2000

•

Assistant Manager MIS

RPK Software Pvt. Ltd, India April 1998 – August 1999

•

Oracle Consultant

P ROJECT SUMMARY:

McDonald Corporation

Technical Project Lead, Nov, 08 – Till Date

Project requirements gathering, project planning and estimation, Capacity planning

•

Logical and Physical Teradata Data modeling for Application, Data standards and Taxonomy

•

Leading onsite and offshore development team, issue and risk management

•

Enterprise Architecture recommendation and Data Integration best practices and standards

•

Capacity planning and Data Warehouse Service operation guidelines based on ITIL framework

•

Teradata data model recommendations, teradata load utilities recommended use

•

Teradata ELT design recommendation for Aggregated load of weekly, monthly data

•

Blue Cross Blue Shield Association

Technical Performance Specialist May, 08 – Oct, 08

• Defined Performance Metrics, Service Support and Delivery Best Practices, Enterprise Business

Intelligence Roadmap

• Performance tuning of DB2 UDB Database Partitioning, Data Modeling

• Refine Physical data model, Recommendation of creating aggregated and summary tables

• Performance Engineering Scope for the end to end Data Warehouse initiative, Testing Policy and

Guidelines, Code migration and Version Control, Architecture Framework for Database, ETL and BI

• Recommended Data architecture and drafted mixed workload data load policy

• ITIL Framework implementation from Service delivery, Service Support and Capacity Management

Kraft Foods

Enterprise Consultant, remote, Sep, 08 – Oct, 08 for (Sntial technologies)

• Drafted Project Management lifecycle and phases for Data Warehouse projects including templates of all

deliverables

• Service Delivery Best Practices, Administration and Scheduling guidelines for Batch applications

• Enterprise Data Warehouse Roadmap, Data Integration Architecture framework and best practices,

Business Intelligence Presentation layer recommendation and best practices

Walgreens Health Service (PBM)

Technical Project Lead, Feb, 07 – Apr, 08

• Assisted Senior Project Manager in estimate and planning major Projects, mentoring technical folks in Best

practices of the industry

• Data Architecture recommendations, Data modeling of Historical fact tables, Aggregated and Summary

tables, Bridge tables

• Logical Data modeling for Claims and Groups subject-area, working with SME and Business to design

Semantic Data Model that will be used by Business Object

• Business Intelligence Presentation layer Modeling, captured Business Objective and priorities, Project

Management of Medicare readjudication Part D implementation

• Establishes staffing/resource plans, determining appropriate mix of sourcing opportunities

• Hands-on project management, leading team of employees/contractors, Participated in creating standards

and best practices

• Worked as Subject Matter Expert in various PBM projects

• Presented Architecture solutions to the Business and Senior management for lead projects

Walgreens Retail (Inventory Management)

Technical Project Lead, Aug, 06 – Jan, 07

• Planned, Architected and developed projects related to Inventory, Forecasting

• Preparation of Detailed Design of the proposed system, including common processes and individual

modules

• Working on the Database Sizing, File space required, Capacity Planning for the System to ensure smooth

operation

• Created Summary Tables for query optimization, Aggregated tables design to hold history data and

proposed solution for atomic data retention and back-up

• Mentored colleagues on technical best practices, standards and architecture of ETL, Databases

JP Morgan Chase

Project Lead, Jan, 06 – July, 06

• Planned and executed 529 Plan Onsite/Off-shore project, managing 12 resources

• Advised and participated in End to End Data warehouse Architecture including Business Intelligence, ETL

and Data architectures.

• Designed Data Model for the 529 Data Mart including aggregated tables, metrics for Reporting tool

• Oracle Database Architecture setup, Backup and Recovery planning, Index and Partitioning management

• Managed change control, issues and risk, performance metrics, user training and implementation

• Maintained project expenditures, resource allocation and management

• IT process automation based on ITIL framework, drafted guidelines and best practices for Service Design,

Service Delivery and Service Support

Allstate Financial Technology

Project Lead, Aug, 04 – Dec, 05

Leading team of 10 resource, Project estimation, Issue Management, Metadata Repository Design

•

Data Architecture, Meta data stewardship, ETL Application Architecture and framework

•

Business Intelligence Architecture, Data Integration framework and Best practices, Data Modeling

•

ETL Architecture, Audit, Balance and Control Layer Architecture, Legacy Data Conversion

•

• Designing and Coding of Balance & Control for all processes, modeling the Oracle schema to support the

Balance & Control architecture

• Provide leadership in drafting best practices and processes for setting up Data Warehouse and Business

intelligence competency centre.

Bank One

Team Lead, Jan, 03 – July, 04

• Production Support management of entire Data Warehouse, Batch Scheduling, Database Maintenance,

Disaster Recovery, Business Intelligence security control, service desk resolution

• Database Performance Tuning of Data Warehouse, lead disaster recovery exercises

• Design version control, code migration, Quality check processes for SOX compliance, Patriot Act

• Responsible of all SLA, day to day maintenance and Performance / Capacity of the systems

• Project planning and estimation, maintaining project expenditures, project tracking and resolution

• Presented Data Warehouse Service support process to C-level executives

• Drafted outsourcing vendor selection criteria, identified outsourcing opportunity in Data warehouse

• Worked with the Data Architects to define taxonomy, standards, data mart models from Data Warehouse

Capital One

Sr. Data Warehouse Consultant, Aug, 01 – Dec, 02

• System Study, Re-Engineering of Design of the Batch Processing System and Data Warehouses, Data

Modeling

• Extensive PL/SQL and Pro*C code debugging and conversion to ETL

• Production Support On-Call for Critical Batch Process, Data Warehouse group. Acted as Liaison between

Business Partners and Analyst/Developer Team

• Drafted Incident and Problem management model, escalation model for smooth operation of service

support

Sprint PCS

Lead Developer, Dec, 00 – July, 01

Data Modeling, System Design, ETL Design, Coding and testing

•

User Acceptance Testing, SQL Optimization, PL/SQL conversion, Batch scheduling

•

System testing, Integration testing and Code review

•

Production Support of existing system, Incident management and problem management

•

WORK STATUS

• Permanent Resident (Green Card Holder)

EDUCATION

• Bachelors in Commerce from Calcutta University, India

• Post Graduate diploma in Computer Application from DOEACC,Govt of India

• Higher Diploma in Computer Science from Aptech Ltd, Calcutta, India

CERTIFICATION

Information Technology Infrastructure Library (ITIL) v3 Foundation Certified

Contact this candidate