Timothy Jeffryes Email & Phone Number

Salt Lake City, Ut, Us

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 stability. Meet current and ongoing requirements as governmental regulations change.

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 stability. Meet current and ongoing requirements as governmental regulations change.

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 with. Another Excel file would then gather up their inputs and generate a text file for uploading back to the accounting software. The process of downloading and generating the Excel files took over 25 minutes to complete. The individual Project manager workbooks would take 2 minutes to open and 17 seconds to switch projects. The process of collecting the data took 15 minutes.I replaced this entire architecture with an Access database solution using SQL server as a back-end. Refreshing the data now take 8 seconds and generating front-end Access databases for the project managers takes 10 seconds. Pushing their inputs back to the accounting software takes 8 seconds.Additionally, since I began my work with this company, they have added a 2nd location and there are now nearly 100 project managers, yet most of this process now takes seconds to complete.I have saved this company hundreds of hours annually in employee time. Prime is very happy with this solution.

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 ongoing requirements as governmental regulations change.

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 California, using custom key search strings to find appropriate jobs.3. Maintained an Excel "bidding" application that creates a "bid for review" folder for a potential construction job and updates an initial OneNote file with the project information. The job can then be created, in which case the OneNote file is updated and calendars items are added to Outlook for specific bid dates.

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. • Obfuscated code • Robust error handling

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 forecast data, and XML storage. Navigation throughout the model is accomplished through on-worksheet buttons. Custom pop-up menus provide users access to various custom functionality. ActiveX controls, UserForms, XML, VBA. TreeView Controls.

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 in its infancy and requirements changed quite rapidly and suddenly. Many solutions had to be create quickly, including allowing end users to work on the database remotely via LogMeIn. Much use was made of a "treeview" control (much like the way that Windows Explorer works) so that users could see the hierarchy of where trees were located (when they were planted, in what field, in what lot, etc).

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 completed completely via telephone and the internet, with no in-person meetings whatsoever.Tracker Database: MS Access database, this time created by someone else. A great deal of re-design was necessary to optimize performance. This was also implanted entirely through conference call and the internet.Reportables Database: Architected and built MS Access database to track specific “work items” at NARAL for reporting to board and funders.

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 statements.Work included designing ASP pages to pull School board information for website visitors.Involves working via email and telephone. Specific uses of front-end and back-end databases and custom routines that allow developer to implement upgrades to backend without interrupting work with production data. Custom error handling sends error messages directly to developer over the internet for rapid response time to bugs.

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 and data tables that could then be amortized by another Excel application. Created an Access database that allowed end-users to easily switch linked tables between various data environments. This application used automation to create reports in Excel by extracting data from Oracle. A third application was a “code template” that contained various VBA routines and toolbars that could be shared by various applications, specifically for the purposes of switching data environments and pulling data from Oracle. All code required to pull data and switch environments was reduced to a simple command bar and 2-3 lines of code.

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 provided. tools included automation using the Internet Explorer activeX control as well as the winHttp activex control. Other technologies included MS Visual Basic 6.0, MS SQL Server 2000, OnContact CMS, VBA for MS Excel, VBA for MS Access.Architected, engineered and built a MS Access database for use with HRF, Human Rights Watch, NYU and the American Civil Liberties union. Database is used to track various incidents of torture and abuse of detainees in US detention centers worldwide.Additionally, provided ongoing support for staff in products such as MS Word, MS Excel, MS Powerpoint, MS Project and MS Access.

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 of files residing on a network drive for inclusion in a standardized MS Outlook email. The MS Word files are then converted to PDF format and an email is generated. This application used the object models from MS Outlook, MS Excel and MS Word. Additionally, it utilized a third-party OCX grid control, enabling the end-user to easily select pertinent files from a grid, rather than having to navigate to the network drive on which the files resided.Merlyn Maintenance — 60,000 line template used worldwide: Provided maintenance, trouble-shooting and upgrades to template that is used worldwide by all offices of Merrill Lynch. The template is used by analysts to create financial reports on companies and industries that are published to the major financial newswires (Bloomberg, Multex, etc). Template interacts with several dlls, and three external executables, one of which controls the template independently and runs macros within the template. iQXL: Created an Excel Add-In that referenced both an external C++ dll and a VB dll to consolidate all custom worksheet functions and make a single call to a remote database, thereby reducing the network/internet traffic and cutting calculation time by 85%. This technology is similar to Microsoft’s new RTD technology introduced with Office XP – however we were able to accomplish this two years in advance.

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 sheets and display the data in the required format. Data pulled from Oracle via SQL and ODBC. SQL statements edited and data reviewed using TOAD software.

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 the task, enabling me to approach similar conversions for other firms with a ready-made toolset. Special attention was required in porting iManage code and there was significant interaction with iManage to facilitate this.

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 developed in WordBasic for Word 95 and upgraded to Word 97 VBA.

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 Training staff.In the process of this work I "invented" a number of special error handling techniques that could be used throughout the template base and also invented ways to replicate the functionality of classes, even though WordBasic did not support classes.

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, retrieving data from the workbooks to a central file for reporting purposes, and dozens of macro-generated reports based on the combined sales data. Special considerations in this project included: many of the anchors of data were variable, such as sales reps, number of issue dates for the magazine, number of advertisers, number of issues per month, and user-defined advertiser names; several of the sales reps were off-site, either being connected to the main servers through a WAN, or not connected at all; and many of the files involved were being used while procedures were run—allowances had to be made for such conditions.

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 scheduling, schools, hotels, directions to schools, and shows performed. Formula IV is a very low-level application with no templates for given situations. Therefore, all relationships, calculations, screen & printer output, and user-interfaces had to be designed from scratch.

Bfa, Acting

High School Diploma

High School Diploma