SUMMARY:

• Expertise in providing MS ACCESS (relational) database development with expertise for full - life cycle application development including data access and management, dynamic querying, reporting and maintenance functions and provide SQL Server skills to manage and analyze data and creating datasets, i.e., SDF text, CSV, Spreadsheet, extracts, and linked MS ACCESS tables.
• Read and write complex queries - MS Access expert level
• Create database objects (tables, views, stored procedures, user-defined functions)
• Strong Skills with using VBA Objects: text box, list and combo boxes, Active X components, radio buttons and check box for User Front End’s, taking selections and converting choices to create dynamic queries that adjust based on user selection to create data subsets for exporting to Spreadsheets or for Reporting
• Several decades of spreadsheet experience - MS Excel, Lotus 1-2-3, VisiCalc
• VBA Coding including Variable declaration, arrays, use memvars in SQL Code for dynamic use of user parameters in queries.
• Use of Append and Make Table Queries from SQL Code.
• Modify existing reporting content
• Understand complex business processes
• General and technical specification development
• SAP Crystal Reports 2013 Developer (Oracle-based Database)
• MS Access Reporting Object
• Some Tableau Experience: Graphs, Reports, Dashboards.
• Work efficiently and verify the results
• Strong writing and communication skills
• Experienced seminar leader & trainer of application users
• Oracle Database Development: Extensive use of the TOAD environment for Oracle Database management:

TECHNICAL SKILLS:

MS-ACCESS development; SAP Crystal Reports 2013 / SSRS; Oracle SQL / Microsoft SQL; SSIS / TOAD for Oracle; MS - 2012 Management Studio; VBA (Visual Basic/Visual Studio), ODBC (connection), MS Excel (CSV, pivot tables, filtering and analysis), Excel (Think-Cell Add-On), MS-Word, PowerPoint, Tableau

PROFESSIONAL EXPERIENCE:

Confidential,Deerfield,IL

SQL Developer

Responsibilities:

• Convert new data to existing Government Compliance Reporting Application with extensive VBA/SQL Query development and modification.
• Analyze existing Government Compliance Reporting application (extensive VBA Queries) to migrate the application to align with modified data sources.
• Provide methods ways to improve processing speed.
• Contract Extended: After the above success, I was charged to CREATE and Oracle Database converting all MS-ACCESS to Oracle, using the TOAD for Oracle development environment which is similar to Microsoft SSIS). I converted 200+ queries to Oracle SQL (backend), and redesign the MS Access Interface (frontend)
• I also created Procedure for Rapid LARGE data log and use Import and Export Data pumps for migration of Development to Production.
• (The above action is similar to capabilities of Microsoft SSIS.)
• Created New Oracle tables to hold yearly data and a system of working tables to process data for annual governmental reporting.
• A secondary task was to automate Analytical queries that reviewed that data creating review logs and history/action loads for the analysts to deal with data issues.
• Extensive Excel Spreadsheet conversion to xls, xlsx, cvs for data import to Access and Oracle
• Use of Spreadsheet/Database Filtering, Recorded Macros/Development Tools (command buttons), Pivot Tables, and Graphics.
• Solved “System Resource Errors” in by implementing code fixes which allow MS Access to operate more efficiently in a server environment.
• Developed an application to provide a detailed field-by-field comparison data check between previous and new data sources to identify data conversion issues and code issues.
• Worked with Multiple Tables, creating complex queries, joining DataSets (90,000 records) joined to large DCH tables of 4.5 million records to produce updated a work table with information for compliance processing. This process reduced processing time from 8 hours to 8 seconds by executing the query in Oracle. (Server Side execution initiated from MS Access
• As a result of this success, I created Oracle “back-end” tables for all 68 tables in the system and developed and edited “Pass-Through” queries (which execute on the server) to vastly improve processing speed of elaborate queries.
• Modified data load queries to capture new structured data download.
• Integrated new tables
• Programmatically modified field names to work with SQL Queries
• Redesigned application for all data to reside on “Oracle” Back-end with MS Access control of table updates and data transfers.
• Converted macros to VBA code. Created Form Menus (with command buttons) for convenient user-processing and professional look of the application.

Confidential,Chicago,IL

Microsoft Access 2010 Developer

• Responsibilities - gather specifications from top management for the development of internal MS Access projects interfacing with PeopleSoft HCM (Query Manager) to extract downloads to be used in MS-Access for additional query and reporting including Screen Preview, PDF and Excel spreadsheet formats. Applications developed to-date include: Skills Review, Talent Acquisition, Case Consolidation, Hierarch Reporting
• Skills Review Application also used Data Download from Success Factors which provided information that was used in calculated rating of individual (employee) skills.
• Efficiency gains include: Conversion of manual spreadsheet cut/paste methods from 1 hour or more per report to mere seconds. 720% increase in efficiency. Reduced time (two weeks) of generation 75 monthly reports to 10 minutes.
• Development includes general and technical specification development, use of Access Objects (List, combo, text boxes, radio, check boxes, command buttons, hyperlinks, event programming, Internal help screens, external document access, automatic user application update, operational manual development, user training, and system support.
• Proficient MS-Access Visual Basic, SQL, File Open/Launch, multi-user data accessibility.

Confidential,Chicago,IL

Microsoft Access 2010 Developer

• Responsibilities - to update an existing database: Adding new fields; creating a more user-friendly environment for data entry using drop-down boxes and screen formatting; providing record navigation, add, and delete buttons; creating a search/find browse screen with zoom-in/Edit functionality; providing an automated email function for distributing reports; and developing standardized and dynamics reports with variable user input of report parameters.
• The improvement of the database was clearly evident and delighted the customer by providing ease-of-use, much needed functionality, and savings of time.

Confidential,Waukegan,IL

SAP Crystal Reports 2013 Developer

• Database Tool, (Connections, Commands, DB Set Locations)
• SQL Commands (extensive ad-hoc SQL Queries to optimize table linking)
• Sorting (Field and formula-based)
• Filtering (Field and formula-based)
• Grouping (Field and formula-based)
• Sub-Reporting (Linking, passing of memory variable and user-entered parameters)
• Section Expert (Formula-based suppression, conditional color formatting)
• Shared and Local Memory Variables (used extensively in sub-reporting)
• Formulas (Extensive use of formulas and functions)
• Running Totals (Sum, Count, Average, formula-based record selection and resets)
• User-entered parameters (Static, dynamic, programmed conditional flagging)

Confidential, WI

MS-Access Database Development

• Converted Single-User System to Multi-User System with centralized data collection.
• Migrated current and legacy data to the new application:
• Re-numbered all foreign keys in a new customer lookup table to previous data records.
• Integrated 300 current data records and 25000 legacy data records in the new system
• Improved and automated Data field lookups.
• Added Filters to improved recording searching for editing and updates.
• Developed 7 new statistical reports.

Confidential,Chicago, IL

Database Developer

• SSRS Report Development w/SQLServerDB (Data Warehouse) data source.
• Student Profile Demographic Report
• Student Full-Time/Part Report
• Student Class Statistical Report
• Data Dictionary Report
• Capturing of data definitions of measures and dimensions from the Open Book SQL database using ODBC connection.
• Collaboration with Executive Director and Sr. Research Analyst(s) - Capturing of data, CRUD operations, & producing statistical reports using Microsoft Access & Excel
• Experience as a user and developed some “wiki” page specs for project communication.
• Responsibilities included Relational Database Design in MS-ACCESS version 2000, 2003, 2007, 2010, 2013; utilizing Visual Basic for Access (VBA) and SQL Query Developing for the capture of PeopleSoft Data, creating client/server environment with Centralized Data Tables for Multi-User Access and provide standardize reports and data subsets for institutional reporting and Government Statistical reporting requirements.
• In all projects, there was a high degree of team collaboration in design specifications and validation.
• Created 27 separate MS-Applications of a period of years to provide Student Profiles of Enrollment, Remedial, Skill Based, and Adult Education courses, Classroom Utilization, Class Size, and Student Program Reporting by College, Ethnicity, and Gender and Full/Part Time Status by Term and Fiscal year to aid research Analysts and Administrative Leaders to meet State and Federal Reporting Institutional Guidelines and requirements achieving and maintaining Academic Accreditation

Confidential,Evanston, IL

Database Developer & Programmer

• 12 separate MS-Access applications resulted in major saving in report processing time (From 20 minutes per report to 5 seconds) data capture with 300% efficiency improvement user input of parameters and selections - 100% efficiency improvement

Confidential,Chicago,Illinois

Database Developer & Programmer

• increases in efficiency by 200% or more through Spreadsheet Macro programming in sales AWARD tracking.
• 300% efficiency increase Abbott Diagnostic Division, Lease Contract Form Generation
• Government EPA Hazardous Waste Disposal increased efficiency in reporting with forms automation incorporating complex chemical calculations of waste weights and quantities.
• Receive Abbott Delta Award for major contribution to office efficiency in Sales Force Car Lease Program
• Increased the efficiency of Truck Fleet Management (shipping) with the conversion of a manual(paper) tracking system to a fully automated application
• Provided Spreadsheet Macro programming (Accounting Dept.) for aggregated relational (cube) data capture for Fiscal Year reporting.
• Corporate training for users

Confidential

Educational Software Development

• Developed 27 educational programs in 3 languages: Spanish, French, and German
• Word Games, Verb Tense Drills, Vocabulary Builder, Text Adventure Game, Culture, Geography
• Programming Language: Applesoft Basic, Apple DOS, and 8088 Assembly Language.
• Ran this small business: Target marketing to secondary & middle schools, world-wide sales, and order processing/shipping.

Confidential, Skokie, IL

Database

• Accomplishments include: Macro programming & spreadsheets
• Many applications to increase the efficiency of data collection and reporting in the areas of
• Manufacturing Process Data Management/Job
• Costing/Reporting
• Fabrication Data Collection and reporting

Confidential,Evanston, IL

Database

• Accomplishments include the creation of many applications to increase the efficiency of data collection and reporting in the areas of
• OSHA Reporting
• Organizational Charting
• Data consolidation of spreadsheets to database for analysis and reporting