Project Manager Data Warehouse
Resume:
Title:Business Intelligence/CRM Advisor
abpwnj@r.postjobfree.com
Document
Source below
NAME: Rafeeq Ahmed
ADDRESS: **** ***** ***** *****
CITY: Naperville
STATE/PROVINCE: IL
ZIP/POSTAL CODE: 60565
COUNTRY: USA
EMAIL: abpwnj@r.postjobfree.com
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
E-MAIL: (abpwnj@r.postjobfree.com
)
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
E-MAIL: (abpwnj@r.postjobfree.com
)
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