Project Developer

Title:Cellular Operator

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

Document

Source below

NAME: Mohamad Hasan

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

CITY: Huntley

STATE/PROVINCE: IL

ZIP/POSTAL CODE: 60142

COUNTRY: USA

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

PHONE: 847-***-****

CANDIDATE ID: 112592

CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 4

WILL RELOCATE: Yes

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED: Open

HOMEPAGE:

HOTSKILLS: informatica =3+ yrs, Cogono's Impromptu =3+ yrs, Cogono's Powerplay =3+ yrs, Cognos's Transformer =3+ yrs, SQL Server =2+ yrs, PL/SQL =2+ yrs, Oracle =2+ yrs,

Cobol =4+ yrs

ESUME

Hi-Tech Solutions May 2000 Present

Power Path Project/BATS, Commonwealth Edison, Chicago IL

Senior Consultant / Data Mart designer/developer

Created Informatica mappings based on a Oracle database and a Mainframe environment to

load fact and dimension tables

Analyze and design mainframe jobs to unload data from a DB2 table, audit data, and move

data from the mainframe environment to a Unix box for input to informatica mappings

Analyze and design interface that loaded data into an Oracle Data Mart from a mainframe

environment

Design and developed analytical reports to be written in Excel using as source the Data

Mart to be executed via the intranet using ASP scripts

Designed and developed Power Cubes that allowed the user to drill through selected

dimensions and measurements

Tool Set: Informatica, Oracle, MS Access, MS Excel, PL/SQL, Visio, MS Word, Cognos Power

Play, Cognos Impromptu, and Mainframe environment.

Xpedior Incorporated, Chicago, IL. January 1998May 2000Consultant

for Grainger Project

February 2000- May 2000Designer/developer

Analyze and create extracts from new BroadVision website using Korn shell scripts to be

ftp to the Marketing Department for analysis

Analyze and create imports from old website to be loaded into new BroadVision web site

using Korn shell scripts, Java scripts and BroadVision load components

Tool Set: BroadVision, Unix, Oracle, PL/SQL, Korn Shell Scripts, Java Scripts, Visio, MS

Word

Xpedior Incorporated, Chicago IL.

.

TransUnion Incorporated

- Chicago October 1999-February 2000Data Mart designer/developer

Analyze billing system to design and implement loading process which extracts and

transforms data to be implemented using Informatica

Created Informatica mappings based on a DB2 database and a Mainframe environment for fact

and dimension tables

Install and configure development environment, and in the installation and set up of Brio

Maintained database during cycle of project

Full life cycle development

Tool Set: UDB-DB2, SQL, Data Movement Transformation tool - Informatica Powermart 4.5,

Visio, MS Word

Xpedior Incorporated, Chicago IL.

.

Medirisk Incorporated

- Chicago March 1999September 1999Database Administrator role

Maintained production and test databases during the cycle of the project

Loaded and compiled SQL scripts, SQL procedures

Setup daily, and weekly backups of the database

Loaded tables in the database using SQL scripts

Tool Set: SQL Server 6.5, SQL procedures

Xpedior Incorporated, Chicago, IL.

MCI World Communications Chicago

January 1999March 1999Consultant

Developer /Analyst role

Used an Olap tool from Cognos PowerPlay to create reports and Cognos Impromptu to

create powercubes to analyze and forecast sales and product orders against database

Tool Set: Oracle, PL/SQL, Cognos PowerPlay, Cognos Impromptu

Xpedior Incorporated, Chicago, IL.

GTE Airfone Oak Brook Illinois

October 1998January 1999Consultant

Data Warehouse Developer

Gross Receipts Tax Project

Created and analyzed the functional design as well as the detail design for the project

Developed a module of the pricing system which determines which taxes and fees are

applicable to the customer

Full Life cycle development experience

Tool Set: Oracle, Embedded SQL, Pro Cobol, System Architect

Xpedior Incorporated, Chicago, IL.

Quill Corporation

May 1998September 1998Consultant

Order Entry Legacy Accounts

Analyzed and converted order entry systems from a mainframe environment to a client

server environment

Tool Set: MS Access Database, MS Excel, Unisys system, Cobol, ECL, Visio

Xpedior Incorporated, Chicago, IL.

Quill Corporation

January 1998May 1998Consultant

Legacy Inventory Project

Determined the placement of legacy programs into either systems or subsystems

Identified all input/output files and database for each system

Identified relationships between systems

Arranged spin off projects for legacy systems to be converted to a client server

environment

Tool Set: MS Access Database, MS Excel, Unisys system, Cobol, ECL, Visio

American Stores Co, March 1986 - December 1997

Programmer, Salt Lake City, UT June 1995 - December 1997

Maintained and enhanced Legacy System for the ADSI Warehousing and Logistics environments

Responsible for back up support during non-business hours

Tool Set: Ramis, Clist, Cobol, Cobol II, Ultims, JCL, VSAM, TSO/ISPF, IMS, 4300 series

mainframe

Assistant Manager, Osco Drug Store, Chicago IL June 1991 - June 1995

Pharmacy Technician, Osco Drug Store, Chicago IL March 1986 - June 1991

Supervisor, Osco Drug Stores, Chicago IL March 1986 - June 1991

Education: Northeastern Illinois University,

Jan. 1987 - Dec 1991, BS Computer Science

Contact this candidate