Project Data Warehouse
Resume:
Title:Senior Consultant
**********@******.***
Document
Source below
NAME: Reema gupta
ADDRESS:
CITY:
STATE/PROVINCE: TX
ZIP/POSTAL CODE:
COUNTRY: USA
EMAIL: **********@******.***
PHONE:
CANDIDATE ID: 97903
CITIZENSHIP: US
Citizen
EDUCATION:
EXPERIENCE: 0
WILL RELOCATE: Open
RELOCATION INFO:
JOB WANTED: Any
RATE NEEDED:
HOMEPAGE:
HOTSKILLS:
ESUME
Reema Gupta
**********@******.***
Contacts: 313-***-****
Fax: 877-***-****
I am a Data Warehousing/Oracle/Front-end business analyst consultant having
around four years of experience in various phases of software development
including System
Analysis & Design, Development, Integration Testing, Implementation and User
Training. My
experience includes full life cycle project development, implementation and
providing ongoing
support. I have BS in Electronics and Communication from a premier Engineering
college and
has worked with CMC India (Ministry of IT, Govt. of India).
Major strengths:
1 Knowledge of Data Warehousing Concepts and Data Modeling Techniques
2 Extensive experience in Business Objects 5.1/5.i, Web Intelligence 2.6,
BRIO 6.2
3 Used extensively on ETL tools in particular Power mart (Informatica)
and coded packages in
Oracle PL/SQL for data extraction, transformation and loading
4 Knowledge of data modeling tools like ER Win
5 Strong Skills in RDBM like Oracle 9i/8i/8.0/7.x, worked on other
databases like SQL Server 7.0,
MS Access, IBM DB2, Informix
6 Worked on Application development tools like Developer 2000 (forms
4.5/5.0 and Reports
2.5/3.0), Forms 6i, Reports 6i, Power Builder 6.0, People Soft 7.5
7 Worked on tools for Internet technology like FrontPage 98, Active
Server Pages 2.0, VB Script,
Java Script, HTML 4.0
8 Worked on various Operating systems like Windows 95/97/2000, Windows NT
4.0, UNIX
9 Experience of working in various industries like Automobile, Banking,
Networking,
Telecommunication, Textile etc.
Summary of Experience:
1 Oracle RDBMS for 4yrs
2 Oracle Forms/Reports for 3 yrs
3 Business Objects for 2 years
4 ETL tools for 2 years
5 Internet technologies for 2 years
SELECTED EXPERIENCE: (most recent first)
Human Resource Global Tracking Project for Data Warehouse of Ford
Motor Company, Detroit, USA
Duration : Feb 2001
Present
The Project: This was a Human Resource, data warehouse project for tracking
employee information
like Payroll, Job, Personal details, International assignment details etc.
globally.
Role/Responsibility:
1 Responsible for writing Oracle PL/SQL packages for extraction,
transformation and loading of
data from People Soft 7.5 transactional system to Oracle 8.i data warehouse.
2 Involved in designing reports using Business Objects 5.1 and configured
web Intelligence 2.6
for display of information on web.
3 Modified existing PL/SQL packages for performance enhancement after
data migration.
Data Warehouse Project for
Avaya Inc
., Florida, USA
Duration: Jan 2001
Feb 2001
The Project: This Project involved design of a data warehouse for an existing
transactional system for
Avaya Inc., which carried network, related of various network components like
UPS, Routers etc. This
information was stored in Informix database and based on it a data warehouse
was built on Oracle
8.i and reporting was done using Business Objects 5.i to analyze the network
performance of the
above said devices.
Role/Responsibility
1 Involved in designing data warehouse in Oracle 8.0 based on Informix
database as per the
requirements
2 Involved in installing supervisor module to create repository in Oracle
8i
3 Designed Universe based on functionality of the business using features
like aggregate navigation
4 Involved in developing reports in Business Objects 5.i, for Fault
Management System, and
Network Summary
5 Facilitated user for ad hoc reporting.
Data Warehouse Project for National City
Bank, Ohio
Duration: Nov 2000
Dec 2000
The Project: The Project involves design of a reporting system using Business
Objects 5.i on an
existing data warehouse in IBM DB2 V6 for analysis of the bank's business,
accounts activity and the
market comparison. The universes were designed to provide extensive reporting
based on
information like Account to Customer relation, Profitability, analysis of
products under deposits and
lending, information from household level to products owned by each customer.
Responsibility
1 Involved in installing Supervisor module to create repository and
manage resources
2 Designed Universe in Star Schema using Business Objects Designer module
based on
functionality of the business using features like aggregate navigation,
resolved loops using aliases
and contexts
3 Involved in developing the reports (list, grouped list, cross-tabs
etc.) using BO features like Drill
down, Slice and Dice
4 Used Document Agent Server for monitoring and controlling the batch and
scheduled processing
of documents
Sales & Customer Services Reporting System on CRMS for
BRI, NJ
Duration: July 2000
Oct 2000
The Project: This is a data warehousing project built over Customer report
management system
(CRMS) CLARIFY for Baton Rouge International (BRI) Inc. BRI provides IT
solution to its clients.
Functionality included study, design and upload of the data warehouse. Oracle
stored procedures
with Informatica Power mart was used extensively for data extraction process
from Clarify and for
loading the data in the data warehouse. As a part of project, the Business
Object's Universe, queries
and reports are created for Customer Service and Sales functions.
Responsibility
1 Involved in requirement study of the system.
2 Created the data dictionary for report data-element mapping.
3 Installed Informatica Power mart server and Power mart client.
4 Created the warehouse tables using Informatica Power mart Warehouse
designer.
5 Involved in source data transformation to load the target tables using
Transformation developer
and mapping designer of Power mart Designer.
Data Warehouse for Indian Railways, Govt. of India
Duration:
Mar 2000
Jun 2000
The Project: Indian Railways are the second largest railway networks in the
world. Presently, many
trains are overloaded whereas some trains are running under-utilized. During
different times of the
year the trains have different passenger load. The project was to create a Data
Warehouse in Oracle
8.0 and perform OLAP using Business Objects 5.0 for the optimum utilization of
various railway
routes for varying passenger load in India.
Responsibility
1 Involved in data warehouse designing using star schema. Also involved
in creation of
aggregate tables in warehouse for the faster processing.
2 Writing procedures for data loading and refreshing from present OLTP.
3 Defining hierarchies of various dimensions and making aggregate aware
universe
4 Universe and Reports creation
Web Site & Office Automation for Ministry of Information and
Technology, India.
Duration:
Sept 1999
-Feb 2000
The Project: The project provided complete searching on the basis of companies
location,
categorization, products manufactured and exported by the company for the
Electronic Industry of
India on the using Active Server pages, HTML, DHTML, Java Scripting, VB. Also
another web site
was created for Intranet of Software Technology Parks of India to provide
information regarding
various annual and half-yearly meetings held in STPI. The other project
involved study of system
requirements of the client, Preparation of Software Requirement Specifications,
Design and
Development of the system, testing and its implementation
Responsibility:
1 Involved in transfer of data of the Electronics Industry from MS Access
to SQL Server
2 Designed ASP pages for various query screens for the web site.
3 Database designing in for storing information available in flat file
for the STPI meetings
4 Designed various data entry screens using Visual Basic 6.0
5 Study of system requirements and preparation of SRS and Database design.
Office Automation Of Ministry of Information and Technology, Govt. of India
Duration: Feb 1998
-Aug 1999
The Project: The Project involves monthly Payroll Processing, Arrears
Processing and Income Tax
Calculations for the employees of MIT using PL/SQL stored packages. The project
also involved
computerization for various departments' Financial Accounting information and
Personnel
Information System. Using Developer 2000 as front-end and Oracle 8.0 as back-
end.
File tracking system was designed to track various files, documents, letters,
complaints that move
from one section or one division of organization to the other.
Responsibility:
1 Involved in designing various data entry forms, Query Screens, Output
2 Database designing for Personnel Information System using Transactional
approach
3 Coded various stored procedures for payroll processing
4 Testing and Implementation of the module
5 Implementation of security features
Automation of National Textile Corporation, New Delhi, Govt. of India.
Duration: Sept 1997
Jan 1998
The Project: The Project involves organizing of information regarding various
subsidiaries and mills
of NTC and the employees and workers working in it.
Responsibility:
1 Designed input screens and output reports using Power Builder 5.0 for
Finance module,
Modernization module & Personnel module.
Reema Gupta
Oracle/Data Warehousing/Front-end Analyst Consultant
July 31, 2001
Contact this candidate