We provide IT Staff Augmentation Services!

Independent Consultant Resume Profile

New York, NY

SUMMARY OF QUALIFICATIONS

  • Microsoft ACCESS system developer with experience in all phases of development..
  • VBA coding for ACCESS and EXCEL
  • Report development in COGNOS, ACCESS and EXCEL
  • EXCEL development of financial data
  • Programming in C with Sybase and in TOAD/SQL with ORACLE
  • Business Analyst developing application requirements for Insurance, Healthcare and Banking industries.
  • Developed several ETL processes extracting data from EXCEL, ACCESS. ORACEL AND DB2 to transfer to other systems
  • Data Mapping and Modeling for table design in relational data bases
  • Documentation of System Development including Users' Guide, Table Definition, Function and Flow Charts
  • Project leader for several software package installations at IBM
  • Test scripts creation for Access systems and other projects
  • Mainframe development at IBM with COBOL, DB2, IMS, VSAM, JCL, TSO, PL/1, Assembler and Endevor

Professional Summary

INDEPENDENT CONSULTANT

Confidential

  • Developed new fast division algorithm for factoring large numbers.
  • Programmed it first in then reporgrammed in C to improve performance
  • Wrote paper describing algorithm and program design.
  • Developed in EXCEL several examples of mathematical patterns for algorithm research.

Confidential

  • Developed ACCESS system for American Musical History project
  • Designed system for creating historical archive of songs and recordings
  • Created tables, forms and queries for entering and retrieving data
  • Researched Data for system

Confidential

ACCESS Developer

  • Designed and developed ACCESS Financial Reports
  • Developed requirements, designed data base, tables and reports
  • Tested and implemented system
  • Financial information concerned cost accounting

Confidential

ACCESS Developer

  • Prepared grants for the museum
  • Created ACCESS systems for exhibit and bibliographic functions
  • Wrote VBA code for complex ACCESS forms processing and other functions
  • Developed SQL ad-hoc queries using ACCESS table data
  • Did Data integrity and validity checking of EXCEL input to systems
  • Created EXCEL spreadsheet to track information about exhibits and used Macros for summarizing data.

Confidential

ACCESS SYSTEMS ANALYSIS

  • - Did data analysis of the COGNOS report system for development of ACCESS data dictionary system
  • Developed ACCESS system using Visual Basic, forms, SQL queries and macros. .
  • Developed requirements, front end forms, tables and function for system
  • Did Data mapping and modeling for table definitions
  • Using SQL queries, extracted, edited and cleansed data from ORACLE into EXCEL for input to ACCESS
  • Wrote VBA code in ACCESS for forms and reports
  • Created system documentation and User Guide

COGNOS Report Writer

  • Analyzed report requirements and the data model
  • Wrote reports using Report Writer and Query Writer
  • Wrote SQL queries for complex reports
  • Maintained schedule for development
  • Converted SQL Reports to COGNOS reports
  • Developed tracking spreadsheet and monitored report removal .
  • Project leader for phasing out library of SQL reports
  • Wrote Ad-Hoc SQL report queries using TOAD to access ORACLE databases
  • Analyzed SQL Queries, wrote COGNOS requirements and developed reports in COGNOS
  • - Did Data Mapping of SQL report fields in ORACLE to COGNOS report fields

Hire Now