ROBERT M.
PEDROZA
2482
Charleston Dr. #4
Schaumburg, Illinois 60193
http://www.geocities.com/pedrozab
(847) 895-0144
PedrozaB@USA.net
CAREER OBJECTIVE: Expand my technical and industry
business knowledge using leading edge development and database products.
WORK EXPERIENCE:
Keane Consulting Inc. / City of
Chicago (Dept. of Revenue), Chicago, Illinois.
Analyst/Developer, Mobile Internet / Web Investigations, April 2001 -
Present
- Business
analysis, design, and development for a mobile internet / web
investigations system using Java 2 v1.3, Oracle 8.04, IBM VisualAge for
Java v3.5, and Xerces 1.30.
- Module
components included a payload management process to build mobile database
information in XML format, a web site that can be connected to remotely
for downloading assignments and uploading investigation results, and a
mobile application that an investigator can perform all their daily
duties in an occasionally connected mode.
Keane Consulting Inc. / Comdisco
Inc. (Technology Leasing), Rosemont, Illinois.
Analyst/Developer, Internet Procurement/Billing, February 1999 – April 2001
- Database
and process analysis, design, and development for an internet / web
procurement and Executive Decision Support (EDS) system, using ASP, Java,
and SQL Server 7.0. Duties included logical data modeling of the billing
database, process analysis and development of the billing calculation and
support information.
- Analysis,
design, and development for order and accounting subsystems for an international
technology equipment leasing system, using PowerBuilder and Sybase.
Keane Consulting Inc. / Meijer (Chain Grocery/GM Retail), Grand
Rapids, Michigan.
Lead Analyst/Developer, Warehouse Distribution System,
December 1998 - February 1999
·
Analysis and design for resource manager subsystem for
a warehouse distribution system, using PowerBuilder 6.5/6.0/5.0 and Sybase SQL
Server System 11/10.
Keane Consulting Inc. / USN Communications, Chicago,
Illinois.
Oracle PL/SQL Development, Database Conversion, May 1998 -
December 1998
- Analysis,
design, coding, and testing of Oracle PL/SQL stored procedures.
- Database
schema management of testing environments. Creation of tables, indexes,
database links, synonyms, and sequence objects.
Keane Consulting Inc. / Kraft Foods,
Northfield/Glenview, Illinois.
Database Administrator, Various Systems, March 1997 – May
1998
- Logical
and physical database datamodeling using SilverRun RDM and Microsoft SQL
Server 6.5 for advertising, finance, retiree, and sales projects.
- Database
support of development and production servers for Kraft Chicago and New
York divisions using SQL Server Enterprise. Implement and support database
maintenance, backup, and transaction log dump scheduled tasks and alerts.
- Performed
database transfers, object creation, emergency database restoration and
database/device manipulation.
Keane Consulting Inc. / Ameritech Communications (ACI),
Rosemont, Illinois.
Business/Database Analyst, Telecomm. Packaged Services, July
1996 - March 1997
- Database
modeling, analysis, and requirement gathering for customer products and
billing systems.
Keane Consulting Inc. / Meijer (Chain Grocery/GM
Retail), Grand Rapids, Michigan.
Lead Analyst/Developer, Warehouse Distribution System,
February 1995 - July 1996
·
Lead business analyst for receiving and appointment
scheduling subsystems developing a large, client/server, automated warehouse
distribution system, using PowerBuilder 4.0 and Sybase SQL Server.
- Performed
functions on all phases of software development life cycle including:
analysis, design, system and data flow diagramming, specification writing,
data analysis, development, creation of test cases, testing, and
implementation.
- Gathered
requirements and modeled processes from JAD sessions.
- Developed
prototype windows and systems using PowerBuilder and Watcom 4.0. Assisted
defining requirements of the development infrastructure.
- Presented
GUI prototypes demonstrating business functionality and system navigation.
Keane Consulting Inc. / McDonald's Corporation, Oak
Brook, Illinois.
Programmer/Analyst, Marketing EIS Reporting System, March
1994 - February 1995
- Performed
analysis and development using a GUI client/server, Executive Information
System tool, Clear Access, and Oracle Sqlnet.
Keane Consulting Inc. / Premier Healthcare,
Westchester, Illinois.
Database Administrator, Contract Maintenance System, August
1993 - March 1994.
- Database
administrator/application developer on a medical supplier contract
maintenance system using Sybase SQL server and PowerBuilder 2.0/3.0.
- Designed,
developed, and tested system stored procedures and triggers using Transact
SQL to perform complex tasks and maintain referential integrity.
- Designed
and created an accounting month end processing subsystem to create general
ledger entries and a data conversion subsystem to format, edit, and load
product information. Created additional on-line windows and reports.
Keane Consulting Inc. / McDonald's Corporation, Oak
Brook, Illinois.
Programmer/Database Analyst, August 1991 - August 1993
- Created
complex SQL queries to performance test prototype database for marketing
reporting system. Extensive SQL performance tuning using plan table
explains and system tables. Created ad-hoc programs and database load
utilities.
- Developed,
tested, and maintained programs for a marketing data collection system.
McDonald's Corporation, Oak Brook, Illinois.
Internship, May 1991 - August 1991.
- Installed,
executed, and maintained various PC packages/programs to collect and
format store sales data. Duties included: PC programming, daily data
communication, upload data to mainframe, and invoke edit jobs.
OE Management / Ameritech Services, Hoffman
Estates/Arlington Hts., IL.
Systems/Design Analyst Assistant, February 1990 - August
1990, December 1990.
- Used
ProKit*Workbench (CASE tool) for a large, new systems development project
during analysis and design phases. Duties included: creation of system and
data flow diagrams, and database synchronization.
University of Illinois at Champaign-Urbana.
Computer Lab Supervisor/Peer Tutor, September 1987 - May
1988.
- Taught
students Macintosh software and maintained hardware and peripherals.
TECHNICAL SKILLS:
Software: PowerBuilder, ERwin, EIS*Toolkit
Databases: Oracle, MS SQL Server, Sybase
SQL Server, Watcom, DB2
Languages: PBscript, Transact SQL, P/L SQL,
Hyperscript, Pascal, MacScheme
Environment: Windows 95 / NT / WFW, DOS,
Macintosh
EDUCATION:
Northern Illinois University, DeKalb,
Illinois.
Bachelor of Science Degree in
Computer Science, December 1991.
William Rainey Harper College,
Palatine, Illinois.
Associate of Science Degree in
Computer Science, May 1990.
University of Illinois at Champaign-Urbana
Math and Computer Science major,
August 1987 - May 1989.
HOME