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
- 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.
- 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
- Designed and developed ACCESS Financial Reports
- Developed requirements, designed data base, tables and reports
- Tested and implemented system
- Financial information concerned cost accounting
- 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.
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