Post Job Free
Sign in

Project Manager Data Warehouse

Location:
Naperville, IL
Posted:
December 06, 2012

Contact this candidate

Resume:

Title:Business Intelligence/CRM Advisor

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

Document

Source below

NAME: Rafeeq Ahmed

ADDRESS: **** ***** ***** *****

CITY: Naperville

STATE/PROVINCE: IL

ZIP/POSTAL CODE: 60565

COUNTRY: USA

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

PHONE: 630-***-****

CANDIDATE ID: 111760

CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 17

WILL RELOCATE: Open

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED:

HOMEPAGE:

COMMENTS:

HOTSKILLS: Data warehouse Solution Architect/Project Manager

ESUME

RAFEEQ AHMED

2592 River Woods Drive

Naperville, IL 60565

630-***-****

E-MAIL: (***********@*****.***

)

Dear Sir / Madam,

As an experienced IT Architect/Database Manager/Data Warehousing Solution

Architect/Project Manager with proven ability, I seek a challenging position in your firm.

I am especially interested in this field for several reasons. First, I have over 16 years

of experience as an Information Technology professional with 7 years of direct experience

in data warehousing/Business Intelligence. Secondly, I have extensive working knowledge of

various IT system implementations including Data warehouse/CRM, from cradle to grave. Also

provided day-to-day management, planned and organized assignments to ensure objectives are

met, developed and maintained project estimates /budgets and deadlines. I have full

awareness of current and future technologies that have an impact on strategic and critical

decision-making and provide end-to-end solution. I have the ability to work under pressure

and meet deadlines. I also have enjoyable experience in working closely with many firms.

Finally, my education, background, hands-on experience and many excellent references

will prove valuable to your organization.

I would appreciate an opportunity to meet with you and discuss how my experience and

education will best serve your needs.

I am U.S. Citizen.

I look forward to hearing from you.

Sincerely,

Rafeeq Ahmed

Encl.: Resume

RAFEEQ AHMED

2592 River Woods Drive

Naperville, IL 60565

630-***-****

E-MAIL: (***********@*****.***

)

Professional Profile

With over sixteen years of experience as a Solution Data Warehouse Architect in

information systems I specialize in Data Warehousing, project management, application

development, packaged solution implementation and large system conversions. My expertise

include maintaining state-of-the-art industry architecture, disciplines and cost

consciousness, with a reputation for quality and integrity. I have successfully performed

engagements for clients in a broad range of industries, including communication,

insurance, finance and distribution. I have managed also pre-sales support activities by

identifying opportunities, and providing work estimates and technical support for proposal

development.

My experience focuses on infrastructure architecture, data architecture and solution

architecture for the entire enterprise data warehouse (EDW). My Business Intelligence

specialties include VLDB (very Large Databases) architecture, multidimensional data mart

design, and meta data design and management. I have a clear understanding of new

technologies (E-commerce, Customer Relationship Management (CRM) and supply chain.

Professional Experience

Business Intelligence/CRM Advisor, Technical Brokerage Corp. and Data Wiz Software

Management consultants, inc

. from August 1996 to Present.

As a Senior Advisor/strategist with technical Brokerage, contributing to the rapid growth

of market share of integrated knowledge management/Business Intelligence/B2B/E-Commerce

solutions. Responsible in Enterprise Planning and Architecture (EPA) to derive from the

business strategy to the plan for exploiting information technology -- the technologies

and infrastructure, the dovetailing of man and machine to help revolutionize in knowledge

management.

DW Technical Manager, Oracle Corporation, Ft. Belvoir, Va from June 2000 to May 2001.

Serve as a data warehouse specialist for DESCs Oracle Energy Downstream Management

Information data warehouse (MI). Is responsible for defining and implementing the

companys strategies and technical direction. Analyzing and anticipating client

requirements and recommending focused solutions that meet the clients needs. Establishing

and managing project plans including the project scope, delivery schedule, resource

requirements, cost and ensuring successful delivery of client projects in line with client

expectations. Motivating and directing consultants by setting objectives, reviewing

progress, and providing feedback. The platform involves for MI is Oracle 8i/Sun

System/Discoverer 3.0/Oracle Reports and Web DB.

DW Solution/Infrastructure Architect, IBM, Cincinnati, Ohio from May 99 to May 2000.

Provided technical leadership for the full system life cycle of an 8-terabyte data

warehouse for one of the largest Grocery chains in the United States. Led activities such

as business discovery and development of DSS Architecture model, including infrastructure

that comprised application, data, communication, capacity planning, source analysis, data

extract design, meta data strategy, logical model, database sizing, aggregation analysis

and design.

Responsible for developing solution with Siebel (CRM Software) to analyze customer data,

identify and exploit opportunities to develop models which are used to analyze

performance, and predict future customer behavior.

Data warehouse Solution Architect, IBM, Southbend, Indiana from Sept. 98 to April 99

Also led development of an overall architecture for the centralized data warehouse of a

nationwide steel firm. Was responsible for application, integrating data and technical

architectures. My design experience includes mainframe, clients/servers and DB2/ Oracle

environments. Planned and developed infrastructure, interfaces, data conversions and

enhancements needed to support the implementation of Siebel (CRM software).

Senior SAP BW Information Architect, IBM, Cleveland, Ohio from Feb. 98 to August 98

Designed data warehouse involving large data volumes and extensive user populations.

Translated business requirements into logical and then physical designs, as well as data

acquisition component, from where the data was sourced within the SAP R/3 core. Provided

solution with solid multi-dimensional data design and configuration of BW InfoCubes. Also,

responsible for Overall project management of BW effort including project planning.

Senior Architect, DMR Consulting, Chicago, IL from September 97 to Feb. 98

Analyzed, designed and constructed The Commercial Auto System for one of the largest

insurance companies. Worked with IBM/IAA (Insurance Application Architecture) data model

and customized physical database as per companys needs and requirements. Also set up

worked examples and assisted developers in successfully completing this complex project

ahead of schedule. The system used was a 3-tier system using PowerBuilder, C/C++, DB2 and

Cobol.

Senior Architect, Lucent Technologies, Naperville, IL from August 96 to August 97.

Managed, designed and developed a sophisticated and complex communication system using

Informix. My role was to lead all areas of systems development life cycle including

project proposals, business re-engineering, implementation, training and systems support.

Responsibilities also included overlooking software architecture, technical interface,

overload control strategies, billing and service measurements. I was also actively

involved in interviewing and selecting candidates.

Data Warehouse Specialist/Senior Architect, Nobel Star Consulting, Stamford, CT from

April 96

to August 96

Designed DSS/EIS for one of the clients using DSS Agent/DSS Architect and ORACLE.

Transformed client's needs into technical solutions using an innovative warehousing based

architecture. Also constructed a solid data model including star schema and configured DSS

Server in 3-tier system architecture.

Data Warehouse Specialist/Senior Architect, Family Restaurants, Inc., Irvine, Ca. from

August 93

to March 96

Budget Modeling (DSS Agent Data warehouse):

Designed, developed and implemented a 3 tier system architecture for DSS/EIS using DSS

Architecture and DSS Agent.

Project Leader/Manager/Data Warehouse Specialist, Family Restaurants, Inc., Irvine, Ca.

Sales Analysis System (Data Warehousing Architecture):

In this role I developed an enterprise-wide decision support system. Created and

optimized data warehouse using Informix (2 tier), MS Access (1 tier) and built metadata

with DSS Architect. Also constructed a logical data model for multidimensional analysis

using DSS agent and EIS.

Project Manager/Senior Architect, Family Restaurants, Inc., Irvine, Ca

Cash Sales System:

As a team leader of the architecture committee, I designed system to manage FRIs complex

cash sales system. This system utilized Windows and was using PowerBuilder 4.0 and

Erwin/Erx for modeling. As a key member of the Client/Server team, assisted in the

development and deployment of sales system application standards and procedures, which

ensured optimum use of current and future architecture. Acted as the principal bridge

builder between operations and technical worlds to make human/technical system truly work

for the end-user. I have experience with extremely large distributed databases in both

relational and hierarchical databases. Was also responsible for the architecture of all

core databases. Actively led the development and administration of annual operating budget

approx. $6 million in expense and capital. Was responsible for strategic planning of

annual operating plans and long-term goals. I adopted a department wide process to

determine product standards and managed the life cycle of those technologies used within

FRI resulting in limiting the variety of products with similar capabilities, thus reducing

overall costs.

General Ledger System: Developed a GUI based applicant using Micro focus COBOL workbench,

CICS and dialog system. Also maintained Payroll, Fixed Assets and Accounts Payable

applications in Dunn & Bradstreet system.

Sr. Programmer Analyst, 7 up Bottling Co.,Vernon, Ca from November 90 to August 93

.

As a

SR programmer analyst, I worked in dual environment (AS 400/36 and IBM 3090/VSE/VM)

with sales, distribution, GL, AP, AR, cost accounting, marketing, inventory control and

product catalog. Migrated many application systems from CSP/GENER/OL to Cobol/Vsam/CICS.

Also implemented JD Edward's payroll and fixed assets system in AS400 environment.

Sr. Consultant, Owl Rock Products, Inc. Southern California October 1989 to November 90

As a consultant, completed PROGRESSION project from B1985 system to A6 Unisys system in

financial, business and distribution applications. My role was to perform as a liaison

with system users. Monitored workflow by scheduling and coordinating special

tests/production runs with operation division and user departments. Also trained and

provided work direction for personnel.

Sr. Programmer Analyst consultant, Ca from July 84 to October 90.

Educational Background

I earned a BS

in Electrical Engineering from the UNR, Reno - Nevada. I also

holds a BS

in Mathematics from the Osmania University - India.

I have taken following IBM courses:

- Business Intelligence Methodology - Business Intelligence TOP gun

- SI Method for professionals - Executive Professional Consultant

Also, Completed numerous corporate in-house and external educational programs including

technical, quality assurance, methodology, management, team-building and diversity

awareness.

Languages & Tools: SAP BW 2.0B, BW ADMINISTRATORS WORKBENCH, BW OBJECTS(Info cubes,

Queries, R/3 extracts for Cubes etc.), ORACLE 8I, ORACLE EXPRESS, ORACLE DESIGNER, ORACLE

WAREHOUSE BUILDER, ORACLE PURE EXTRACT, ORACLE PURE INTEGRATE, DISCOVERER 3I, WEB DB, DB2,

DB2 UDB, INFORMIX, SYBASE, MS QL SERVER, TERA DATA, COGNOS, VALITY, DSS

AGENT(Microstrategy), MY EUREKA(Information Advantage), BRIO, BUSINESS OBJECTS, DECISION

BASE (platinum metadata management), PRISM, PLATINUM, DPROP, SAS, CARLETON, VISUAL

WAREHOUSE, ETI, INFORMATICA, IBM DATA GUIDE, DSS ARCHITECT, IBM INTELLIGENT MINER, DARWIN,

JAVA, SIEBEL, ONYX, CLARIFY, SALESLOGIX, Microsoft technologies, C ++, COM/CORBA, HTML,

XML, BROADVISION, WEB-RELATED PROGRAMMING (VISUAL BASIC AND VISUAL C S-DESIGNER,

COBOL, RPG 400, EDI, CICS, CSP, GENER/OL, FAVER/XP, PANVALET/PANAPT, ER/WIN, VISIO, DB2

CONNECT, ODBC, SQL/NET AND MQ SERIES ETC.

Hardware: WINDOWS NT, SUN SEQUENT, S/390, ES 9000, AS/400, IBM 3090, IBM 4381, UNISYS A-

SERIES, IBM SYS 3X, HP9000 and SP2.

Methodologies: SI METHODS, BI METHODS, MICROSCOPE, OBJECT ORIENTED ANALYSIS, DESIGN AND

PROGRAMMING (BOOCH) STRUCTURED ANALYSIS, DESIGN AND PROGRAMMING (YOURDAN).



Contact this candidate