RITAMBHARA GOEL's WORK EXPERIENCE

COMPANY / Title - Period

Job Description

CHICAGO MERCANTILE EXCHANGE Clearing House Division,
30 S. Wacker Drive Chicago, IL 60606

SENIOR PROGRAMMER ANALYST
December, 1997 - Present

  • Working with a team of 6 programmers, to design and implement software application using Microsoft ACCESS, which links data to DB2 mainframe database mirrored in ORACLE 8.0, using ODBC under Window NT 4.0 environment.
  •  Design Window NT based applications to do financial analysis for Risk Management.
  • Design and implement Microsoft Excel template for storing calculating and producing reports on financial data of Clearing House.
  • Design HTML and XML Reports for Clearing House Intranet. Using XML and ADO biding data in Microsoft Access Database with in XML documents

UQ SYSTEM SOLUTIONS, INC.
2211 S. York Road, Suite 310
Oak Brook, IL 60521

CONSULTANT
Client Server Solutions

R.R. Donnelley & Sons
Marketing Technologies Group
February, 1997- December 1997

·         Working with a team of 5 to design a Generic Relational Database in ORACLE 7.3 to meet client needs.

·         Designing a Visual Basic/ORACLE Client/Server a Three-Tier System that involved VB class design and implementation. Use RDO, ODBC. Middle layer developed as Out of Process OLE Server. Classes were made and OOP techniques were utilized. For Window NT environment running over Ethernet.

·         Managing telemarketing information of certain pharmaceutical companies through maintenance of existing ACCESS 2.0 databases, while converting databases into ACCESS 95. Improved current system through Access VBA programming.

·         Design and offer many useful suggestions on how to optimize the routines in the operations department.

·         Perform Data Analysis and Report Design using Pass-thorough SQL Queries. Used OLE Server to transfer data to EXCEL.

TECHNOLOGY ADVISORS, INC.
Park Ridge, IL

CONSULTANT
Client Server Solutions
March 1994-December 1995

Baxter International Inc.
Productivity System Division

 

·         Developed a VISUAL BASIC/ORACLE Client/Server application using ODBC. This Help Desk/Problem Tracking system was utilized for logging, tracking, and reporting customer product problems. System tracked call volume, maintained follow up status, build KNOWLEDGE BASE to provided problem solutions, give historical reference and kept track of customer and sales information and product installation information.

  • Designed Data Model for this project used SQL PLUS, Visual Source Safe, Created dial-up procedures for Remote Access to the clients to log-on to the server. Started the Table Structures design in SQL SEVER then switch to ORACLE. Created Online Help file using SDK 3.1.

TECHNOLOGY ADVISORS, INC.
Park Ridge, IL

CONSULTANT
Client Server Solutions


Baxter International Inc.
Corporate Environmental Affairs

·         Developed a Relational Database application using ACCESS for the purposes of tracking Financial and Time Schedule of Environmental Audit of sites.

  • Project involved designing Tables, GUI and programming in VBA, used complex Sorting and Scheduling Algorithms. Created Online Help file using SDK 3.1.

TECHNOLOGY ADVISORS, INC.
Park Ridge, IL

CONSULTANT
Client Server Solutions
April 1995- September 1995

Baxter International Inc.
Corporate Environmental Affairs Legal Division

·         Developed a Runtime ACCESS Database application using ADT for the purposes of tracking Superfund legal cases, maintaining legal history of the case along with financial history and Forecasting.

·         Project involved designing Tables structures, GUI and programming in ACCESS VB. Implemented Security on Pier-to-Pier Window 3.11 environment. Used Crystal Reports for the Data Analysis.

 

TECHNOLOGY ADVISORS, INC.
Park Ridge, IL

CONSULTANT
Client Server Solutions
June 1994- September 1994

Loyola Medical College
Orthopedic Department

·         Developed a Runtime ACCESS database application using ADT for recording the work done by residents and patient case histories. The database recorded the information on patient visits and procedures performed by residents to generate reports for Illinois Health Department.

·         Developed Data Model and Graphic User Interface used Visual Basic for programming. Wrote installation and Windows setup using API Programming.

TECHNOLOGY ADVISORS, INC.
Park Ridge, IL

CONSULTANT
Client Server Solutions
September 1994 - December 1994

ALL TANK INC.

·         Developed reports and forms using DBASE CLIPPER for the Tank Volume Gauging software.

·         Design Windows Solution for DOS DBASE CLIPPER Database for the Tank Volume Gauging software.

Daniel F. and Ada L. Rice Campus
Illinois Institute of Technology
201 East Loop Road
Wheaton, IL 60187-8489

NETWORK ADMINSTRATION ASSISTANT
September 1993- April 1994

·         Maintained a SUN NETWORK.

·         Maintained 25 PC's at the lab, installed software, up-graded hardware.

·         Assisted students in running various software program and connected to networks.

·         Wrote applications using C using OOP to record the financial information for lab copier and laser printer charges, and kept network log-on ID and password assigned to SUN system users.

COMPU-APP CONSULTANTS
New Delhi - India

PROGRAMMER
December 1987 - December 1988

THE HINDUSTAN TIMES    

·         Developed forms and programmed in DBASE III+ for matchmaking software based on matrimonial advertisements published in the Hindustan Times (a leading India Newspaper).

COMPU-APP CONSULTANTS
New Delhi - India

PROGRAMMER
December 1987 - December 1988

KUMAR ASSOCIATES
  • Developed payroll generation and employee record maintenance software using Procedural language PASCAL