Data Project

Title:Test Technician

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

Document

Source below

NAME: PANDEY, p

ADDRESS: 12

ADDRESS2: North

CITY: New York

STATE: NY

ZIP: 10010

CANDIDATE ID: 2323424

US CITIZENSHIP: US

Citizen

EDUCATION: Master Degree

EXPERIENCE: 8

WILL RELOCATE: Yes -

JOB WANTED: Any

RATE NEEDED:

TELEPHONE: 732-***-****

EMAIL: ************@*****.***

HOMEPAGE:

HOTTEST SKILLS: Senior Consultant,Solution Designer,Data Conversion Manager

REVISION: 28-SEP-01

YOE: 8

Objective:

To utilize my diverse IT experience and business knowledge in an Information

Management position.

Experience Summary:

Developed business and data conversion strategies and coordinated all aspects of

Data Management. Led the Data Warehousing and Knowledge Management efforts to

effectively capture and disseminate knowledge within an organization. Planned

the data integration and conversion processes for Data Warehouse projects

ensuring the smooth transition between diverse database systems. Utilized data

warehousing and data mining technologies to improve data quality and data

accessibility.

Technical Profile:

Data Modeling Tools: Erwin 3.5.2, Designer 2000,

Data Warehouse Tools: Data warehouse tool Kit, Star Tracker, I2 Active

Data Warehouse, Informatica,

Business Warehouse, Cognos

Data Mining Tools: Knowledge Seeker, Data Mind, NueralNetware

Predict

CASE Tools: Rational Rose, System Architect, Visio,

CASEwise

Languages: SQL, PL/SQL, C, C++, HTML, Visual Basic

4.0, Unix

Project Management: Project Workbench (Certificate Suite 3.0),

Rational RequisitePro, MS Project

Databases: Oracle 7.0, MS Server 7.0, Informix,

DB2, Microsoft Access 7.0, Power Builder 5

Supply Chain Management: I2 Rhythm Control Planner, I2 Demand Planner, I2

Supply Chain Planner

ERP: SAP/R3 3.1 Logistics Module,

Material Management (Certified in SAP Basis)

Groupware Products: Lotus Notes 5

Platforms: UNIX (HP-UX, Alpha and SUN), Win 95,

Win NT, Novell Netware

Others: MS Office, Clarify, Customer

Relationship Management Index, Portal

Relevant Experience:

Cap Gemini Ernst & Young

New York, NY

Senior Consultant

(10/00-Present

)

Solutions Architect

(Major Health Insurance Company)

London, UK

Defined the scope and approach for reengineering business processes for Policy

Administration for the Global UK and the US teams and provided a common set of

processes for both the UK and the US.

Facilitated workshops to identify and to reconcile the processing differences

between the US and the UK business.

Created project plan, task definition, WBS, resource definition and status

reports using Microsoft Project.

Developed the data and business requirements and analyzed the data sources and

data models to assess the data integration for the existing business processes

using Oracle 8.0, Erwin 3.5.2 and Informatica.

Designed data architecture, data flow and process flow diagrams using CASEwise

process modeling tool.

Data Conversion Manager

(Major Health Insurance Company) Dublin,

Ireland

Managed and led the data analysis activity and the specification of the data

conversion rules for the financial data impacted by the Euro conversion.

Developed the data conversion strategy for the financial data warehouse

impacted by the Euro conversion.

Specified the scope of the data being converted and created project plans and

project definition for data conversion and data transformation for financial

data warehouse within the organization.

Utilized dimensional modeling techniques, Designer 2000 tool, star and

snowflake schemas to design a financial data warehouse.

Used Informatica PowerMart 4.7 ETL tool, to create complex transformation data

mappings.

Data Warehouse Architect/Project Lead

(Major Financial Company) New York, NY

Evaluated the ETL and the OLAP vendors, identified the selection criteria and

recommended the best tools based on the scorecards (RFI) received from the

vendors.

Designed snowflake and star schemas for a financial Data Warehouse using Erwin

and Model Mart.

Designed fact tables and dimensions using star schemas and dimensional

modeling techniques.

Used the Informatica tool for specifying the data transformation rules and the

data mappings for integrating the data from diverse sources into a data

warehouse.

Created Statement of Work, Letter of Understanding, RFPs, RFI and approach

deliverables for in order to formalize scope of contribution by CGEY.

KPMG LLP

New York, NY

Senior Data Architect (Senior Supervisory Specialist)

(06/00-10/00)

Managed and Led the assessment of existing IT systems in the effort to combine

data from Tax Data Repository and various internal systems for corporate tax

preparation and tax reporting purposes.

Developed data transition strategies for automating the tax preparation

process within a corporation.

Developed business and data requirements specifications for the consolidation

of the financial statements at the various summary levels.

Designed the data architecture and the data flow diagrams using the Visio,

process modeling tool.

Designed a Tax Data Warehouse using dimensional modeling techniques and Erwin

modeling tool.

PANASONIC

Secaucus, NJ

Senior Data Architect

(06/99-06/00)

Developed and enforced standards for Database change requests in order to

ensure data quality and data integrity, referential integrity and normalization

for 9 enterprise-wide database and data warehouse applications through the use

of SQL and data modeling tool.

Created project plans and Gantt Charts using Project Workbench and designed

the data integration process between legacy systems and I2 Active Data

Warehouse for the Supply Chain Management initiative.

Directed DBAs and data analysts in data decisions and in implementing changes

to the database.

Contributed to Knowledge Management initiative of optimizing Business Rules,

by analyzing PL/SQL code and conducting interviews with Project Managers in the

effort to capture intangible knowledge.

Managed the data migration process from the Order Management System to the I2

Active Data Warehouse and SAP logistics module.

Utilized Erwin 3.5.2 CASE tool to perform dimensional modeling,

reverse-engineering, and to design entity relationship models, star schemas,

data dictionary components and to generate DDL statements.

Utilized Cognos to design cubes to generate multidimensional sales and

inventory reports for customers.

AT&T

Piscataway, NJ Data Modeler

(03/99

-06/99) Contract

Utilized the vendor tool Portal and Erwin 3.5 to analyze and customize the

physical and logical database model in order to meet the functional

requirements of the OneComm Billing project.

Performed data mapping for all the fields for the taxation by extracting and

manipulating data through SQL queries in Oracle 7 environment.

Developed Entity Relationship Diagram, logical data model and collaborated

with the database team to translate logical data model into physical data model

and databases.

XEROX

Rochester, NY

Database Analyst Contract

(12/99-03/99)

Created data dictionary by researching and defining data elements based on key

characteristics, data type, business definition, logical and physical names and

domains.

Researched and defined data elements based on key characteristics, data type,

business definition, logical and physical names and domains.

Created data dictionary by running SQL queries and interviewing users for

customer Information database.

Performed data mapping from Customer Master to the vendor product, Clarifys

Customer Information module.

ECONOMIC FORECASTING CENTER

Atlanta, GA

Database Analyst

(1/98 to 12/98)

Modeled and developed a database in Oracle v7.3 for the "HR ATLANTA" magazine

using System Architect CASE Tool, ER modeling techniques and data flow

diagrams.

Used KnowledgeSeeker Data Mining tool to determine effective ways of targeting

the customers.

Specified cardinality and association between entities and generated schemas.

Implemented and maintained RDBMS database using SQL in Oracle v 7.3 on a

Solaris 2.5.1 platform.

G.T.E MOBILNET COMMUNICATIONS

Symrna, GA

Software Engineer

(6/97 to 12/97) Contract

Developed an application using object-oriented modeling CASE Tool, Rational

Rose and C++. This system was developed using Use-Cases in UML and Booch

methodologies.

Business Process Reengineered Project Management process for web application

development by using trigger models, process flow diagrams and solution

effectiveness grids.

HUGHES NETWORK SYSTEMS

Symrna, GA Programmer/Analyst (1/97 to 6/97)

Contract

Modeled and developed an application for monitoring gateway performance,

traffic, problem determination and problem-notification for DirecPc satellite

using Visual Basic 5.0 on Windows NT.

NC Advancement

New York, NY

Database Programmer/Analyst

(6/94 to 11/96)

Monitored and controlled the processing of records of approximately 1500

profiles in the database.

Established and administered a computer training program permitting users a

greatly simplified process of accessing records in the database.

Education:

Master of Science

in COMPUTER INFORMATION SYSTEMS

J. Mack Robinson College of Business, Georgia State University,

Atlanta, GA

BARUCH COLLEGE, City University of NEW YORK,

New York, NY

Bachelor of Business Administration,

Management

Training:

Certificate: Project Management Workbench, Suite 3.0

Certificate: SAP Basis Technology

Certificate: Informatica

Certificate: Rational RequisitePro

Rational Unified Process (RUP Methodology)

Member of the Database and Management Association of New Jersey (DAMA)

CRM Customer Relationship Management Index for Financial and Telecommunication

Industry

Facilitated Session Leader Training

Structured Thinking and Communications

Data Warehousing Seminar by Peter Miemno

Requirements Management with Use Cases

Engagement Economics

Consulting Services Entry Training

Contact this candidate