- Confirms project requirements by interviewing users to define requirements; conferring with others on project team.
- Maintains data dictionary by revising and entering definitions.
- Maintains client confidence and protects operations by keeping information confidential.
- Maintains technical knowledge by continued exposure to new requirements, consultation with members of teams with similar experience, and technical reviews with “users” of existing applications.
- Ensures operation of tools by maintaining contact with the user(s); troubleshooting and modifying “bugs”; developing new features to enhance operation.
- Contributes to team effort by accomplishing related results as needed.
- Determines changes in physical database by studying project requirements; identifying database characteristics, such as location, amount of space, number and security levels of users and access method, and changes in user requirements.
- Changes database system by coding database functionality.
- Protects database by developing access system; specifying user level of access.
- Maintains user reference by contributing to database descriptions and user documentation.
- Database Performance Tuning, Database Management, Requirements Analysis, Software Development, Problem Solving, Documentation Skills, Verbal Communication, Data Maintenance, Database Security, Promoting Process Improvement, System Administration. Convert business requirements into normalized database table structures.
- Maintain “user friendly” interface in design consideration.
- Transform current manual processes, usually being accomplished using Microsoft Excel, Word, Power Point, SharePoint, and Essbase, into functional solutions with Microsoft Access as the main platform. Candidates for conversion are generally very involved data manipulation applications where the process is centered on a few resources who are the SME’s regarding the complete conversion from source to output. Usually there is a great deal of time spent by the SME in manual transformation of the source data, allowing for introduction of human error, an inability to confirm or independently audit results, and often a single point of failure.
- By converting the manual process into a systematic sequence of process steps that can be executed by a user who does NOT need to be an SME, the possibility of introduction of human error is reduced, the process becomes more independent of the user, and the time involved is reduced from a matter of days to a matter of minutes.
- The process can be repeated at will, with an expectation of the same result, regardless of the user.
- The application owners gain confidence in their product, and can involve fewer resources to produce more deliverables in less time. By using Microsoft Office products (Access and Excel), development time, compared to that experienced using SQL or other similar tool sets, is significantly reduced. An additional advantage to using Access as the database is its user interface.
- If variables need to be introduced into the process by the user, forms are available with prompts as a means of data collection.
- With most reporting using Excel as the primary application for presentation, Access has the capability to build Excel files dynamically. If Power Point Presentations are required, usually they’re staged in Excel first, which facilitates quicker end - to-end processing using Access as the “processor” of the data.
- Work closely with application users/owners to ensure project requirements are understood and implemented.
- Continued interaction with owners of the process to be developed
- Maintain close contact with the resources who will implement the process
- Gain an understanding of the current process, and identify where improvements can be made
- Recommend potential solutions/improvements to the users of the tools to be developed.
- Review aspects of operation with end users throughout all phases of the development.
- Provided reporting for various levels of management, on a daily, weekly and monthly basis.
- Tracked project management progress; provided feedback to project management with overviews of progress with particular attention placed on deficiencies and next steps.
- Collected, processed and distributed information for various Scorecards and Dashboards, which previously had not been available.
- Expanded my sphere by association with other organizations within the bank, by way of personal contacts, to automate their data processing applications.
- Improved efficiency by automating the processes in place, which allowed resources to become involved in projects with greater scope.
- Through review of existing processes, found examples of inaccurate data in reports, and with the permission of the owners of the reporting processes, corrected the processing to ensure the accuracy of the data.
- Worked with others in various areas of the bank to review their processes, and remove as much manual processing as possible; replacing the manual process with an application that would perform the tasks more quickly, with checks and balances built in to prevent the types of errors found in the original processes.
- Was called upon to work with other groups to develop new applications for tasks thought to not be possible to complete (using the tools at hand that everyone was comfortable using).
- Became responsible for all the data collection and processing, and report generation that previously had been the responsibility of 5 associates.
- Worked closely with each to understand what their particular report(s) were intended to illuminate.
- As time progressed, I worked with the recipients of the reports to determine what could be presented more clearly, what could be retired, and what needed to be added.
- The contents of the reports included tracking progress of established workflows; comparing expenditures to budgets; determination of manager to employee ratios; providing visibility into monthly costs per cost center by various types of expenditure.
Data Center Migration - Project Management
- Met with client personnel to determine feasibility of using Microsoft Access to develop an automated solution to their problem.
- Met with managers and end users to understand their business processes and establish functional expectations for design of databases to mirror their business processes.
- Transitioned data from previous releases of Microsoft Access and Excel, as well as from text files and other spreadsheets and databases.
- Designed and developed databases at client locations using MS Access, extensive VBA code and interfaced with SQL Server and ORACLE Databases.
- Met regularly with managers and end users to report and gauge progress, and to determine suitability of product.
- Modified design specifications as a result of regular progress meetings.
- Trained on-site personnel on Microsoft Access, to enable the client to maintain or modify applications.
- Provide phone support to trained client personnel.
- Designed and developed supporting spreadsheets in Microsoft Excel and Lotus 123.
Confidential, Columbus, Ohio
- Built Access databases to provide additional functionality for and interface with existing SQL Server Database at Sun Microsystems for Confidential Real Estate Management accounting department.
- Hired to complete Confidential project of converting RBASE databases to Microsoft Access 7.0 at Confidential.
- Databases were for tracking many aspects of business (i.e. parts quality, H/R, payroll, IRS reporting, safety, tool repair, purchasing, etc.)
- Delivered formal classes on DOS, Windows, Word, Excel, Access and Lotus 123.
Independent Contractor Financial Planner
Confidential, Dublin, Ohio
- Developed spreadsheets to facilitate the creation of the “Plan” using Quattro, Quattro Pro and Excel.
- Automated the semi-monthly payroll using Paradox and Quattro.