Timothy Jeffryes Email & Phone Number

Salt Lake City, UT, US

New York, NY, US

Managing 15+ Microsoft Access applications for a government agency. Assisting in reducing "inconsistent state" errors, modifying usage methodologies, cleaning up legacy code, modernizing VBA coding, migrating tables to SQL server, making table relationships more robust and normalized. Working with end-users to mitigate errors, improve performance and.

New York, NY, US

Managing 15+ Microsoft Access applications for a government agency. Assisting in reducing "inconsistent state" errors, modifying usage methodologies, cleaning up legacy code, modernizing VBA coding, migrating tables to SQL server, making table relationships more robust and normalized. Working with end-users to mitigate errors, improve performance and.

Bellevue, Washington, US

Prime works with an industry leading accounting database software for construction projects. Each month project managers must estimate projections for the projects they work on. Initially a master Excel workbook was used to connect with the database, pull in the monthly information and then generate up to 30 Excel workbooks for the Project Managers to work.

Taylorsville, Utah, US

Managing 15+ Microsoft Access applications. Assisting in reducing "inconsistent state" errors, modifying usage methodologies, cleaning up legacy code, modernizing VBA coding, migrating tables to SQL server, making table relationships more robust and normalized. Working with end-users to mitigate errors, improve performance and stability. Meet current and.

Provide consulting services to Fannie Mae, NARAL, Planned Parenthood, Mazur Carp & Rubin, Human Rights First, Consumers Union, Beaconfire Consulting, The New Yorker Magazine, Memorial Sloan Kettering Cancer Center, Ipsos Pharamceuticals, Prime Electric and the Utah Department of Agriculture and Food.

Bellevue, WA, US

1. Building and maintaining Excel estimating tools for various clients in the construction industry. The tools involved extensive use of VBA, advanced formulas such as OFFSET, VLOOKUP, data validation, conditional formatting. 2. Created a Microsoft Access database that scrapes the web for potential construction jobs in Washington, Idaho, Oregon and.

Working with Keola La'i Condominium in Honolulu to re-purpose a and existing Microsoft Access database. Tracks owners, tenants, incidents, staff, units, bicycles, cars, surfboards.

Working with Sunrise Helicopters to migrate data from existing DOS based Q&A inventory software to Microsoft Access. Because the company is not year ready to fully migrate, create a series of batch processes which allow client to migrate data each week, while fully maintaining existing operations.

• Job Aid Writer (Word)
• Cleanup up Word 2003 Word template and added a custom ribbon
• Added End User License Agreement (EULA)
• Added "trial-only" functionality
• Robust error handlingMAPS (Excel)
• Inherited existing Excel model, cleaned up existing code, making more robust and scalable, added enhanced user forms, right-click menus and database-like functionality.

Paris, FR

Oncology Drug Sales Forecasting Application: Client provides MS Excel forecasting tools to large pharmaceutical companies such as Millenium/Takeda. These tools are complex applications that accept thousands of various inputs and predicts potential sales scenarios for the next 15 years. Includes functionality for charting, importing and exporting of.

Worked with HLH to gather requirements and create a Microsoft Access database to manage hundreds of thousands of Koa trees planted on the Big Island of Hawaii. Trees are identified by Radio Frequency Identifier (RFID) tags and the "mother tree" from which the seeds were gathered was also recorded. Special challenges included the fact that the company was.

Washington, DC, US

Who Decides Project: Implemented a user-interface to a database designed by another Beaconfire consultant. Bypassed the standard Access wizards for creating interfaces and instead created a more quicker and more robust interface using a custom HTML editor, quick-pick lists and custom reports using both Internet Explorer and MS Word. This project was.

Anaheim, CA, US

Legislation Database: Designed database for tracking all elected positions from school board to state governor, including complete contact information, staff, meetings, choice advocacy positions, votes on specific legislation, various stages in a proposed legislation life and election result data. Primary coding method for accessing data is via SQL.

Silver Spring, MD, US

Amortization Calculation, Automation and Reporting for Fannie Mae Financial Restatement: Designed several applications in MS Excel and MS Access to automate the amortization processing for Restatement of 2002-2007 financials. The CSL_Generator allowed end-users to select specific deals and securities within Excel and execute a routine to pull parameters.

Washington, District Of Columbia, US

Worked with Michael Xifaras and numerous other consultants to automate and test the amortization engine used for the 2005 Fannie Mae restatement. Work involved customization of complex tools in Microsoft Excel, Microsoft Access and using both to connect to multiple data environments in Oracle.

New York, NY, US

Primary focus was a data synchronization project between an online contact/mailing database (GetActive) and an offline database (SQL Server/OnContact CMS). Challenges included accessing the online database without being given connection capabilities to the backend Oracle servers. Thus, all data had to be retrieved using the existing GetActive Web interface.

New York, NY, US

iQ Desktop: Maintained and streamlined 6 VB dlls for iQ Desktop, an in-house application. The application allowed Research Analysts to submit crucial analytic data from MS Excel to a large worldwide Oracle database. The entire application required usage of VBA, VB, Java, and TCP/IP.ReMail: Created a stand-alone executable that allows users to select a list.

New York, NY, US

Worked extensively with Vice Presidents and CFOs of Merrill Lynch to create an Excel workbook that represented income and expenses for Investment Banking worldwide. A requirement was made to pull data from Oracle and then have most of the rest of the automation done entirely through custom Excel formulas. Lookups were created to pull data from hidden.

New York, NY, US

Word 95 to Word 97 Conversion Project: Converted this 500 end-user WordBasic/Visual Basic macro/executable set to VBA for Microsoft Word. Special conversion routines were created to transport Visual Basic forms to VBA forms, as there is currently no such conversion tool provided by Microsoft. Additionally, many conversion routines were created to automate.

New York, NY, US

Medical Protocol Template: Developed a template for the creation of protocols. The unique aspect of this project was that certain boilerplate text had to be kept protected, but we wanted to avoid using form protection. Instead, the entire keyboard was remapped with macros so that when the user typed in given areas, the keys would not function. Project.

New York, New York, US

Maintained a massive base of MS Word templates used worldwide by White & Case. Most templates used WordBasic macros and many integrated with PC Docs. I reponded to user issues with the templates and provided 2nd level support to the Help Desk. Also created a number of new templates based on requirements submitted by the end-user community and the Word.

Developed an inter-linked set of macros and workbooks which enabled sales managers to capture a “snapshot” of current sales data on the network. This “snapshot” included over 12,000 records of sales data from their Admarc Vax system, as well as data culled from the workbooks of 40+ sales reps. Routines included updating the 40 workbooks from the Vax data.

Wang Formula IV Programming: Founder and Executive Director of this non-profit corporation in New York State which toured live theatre programs to Elementary & Junior High Schools throughout New England. Customized the Formula IV database application for the Wang PC. This customization included designing databases for bookkeeping, accounting, tour.

Bfa, Acting

High School Diploma

High School Diploma