Timothy Jeffryes Email and Phone Number
Salt Lake City, UT, US
Timothy Jeffryes's Location
Salt Lake City, Utah, United States, United States
Timothy Jeffryes's Contact Details
Timothy Jeffryes work email
- Valid
- Valid
- Valid
- Valid
- Valid
Timothy Jeffryes personal email
n/a
Timothy Jeffryes phone numbers
About Timothy Jeffryes
SAVING TIME, MONEY AND REDUCING ERRORS: That is what I've been doing for 25 years, primarily with Microsoft Office, including Excel, Access, Word, Outlook, PowerPoint, OneNote and Visio. The primary focus of all of these projects has been to automate repetitive workplace tasks.I am well suited for assessing the needs of a given challenge and for communicating those needs to the appropriate departments. Similarly, I have substantial experience working with smaller firms remotely and am able to assess and quantify their needs quickly.I very much enjoy a challenge and have no problem in researching Help files, the MSDN website, newsgroups and picking the brains of my colleagues. As a matter of pride, I work hard to avoid reinventing the wheel. In most cases, I consider it my responsibility to deliver solutions that balance time, cost and quality and effectively as possible. In many cases, finding an existing product that fits the requirements 90% may be the best thing I can do for my client.Primary Languages:Visual Basic for Applications (Excel, Word, PowerPoint, OneNote, Outlook, Access, Project, Visio)VB.NETWordBasicHTMLSQLOracle SQLASPJavascriptPrimary Skills:Programming and MS Office Solution DesignerSQL Server Data Migration for MS AccessUser Interface DesignProject ManagementProject Architecture and Design
Timothy Jeffryes's Current Company Details
Sharp Decisions
View
MS Access VBA customization with SQL Server, HTML, JavaScript, and ASP
Salt Lake City, UT, US
- Website:
- sharpdecisions.com
- Employees:
- 183
Timothy Jeffryes Work Experience Details
-
Sharp DecisionsSalt Lake City, Ut, Us
-
Microsoft Access Vba Sql SpecialistSharp Decisions Jan 2019 - PresentNew York, Ny, UsManaging 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.
-
Microsoft Access Sql SpecialistSharp Decisions Jan 2019 - PresentNew York, Ny, UsManaging 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.
-
Ms Access/Excel Vba DeveloperPrime Electric Jan 2019 - PresentBellevue, Washington, UsPrime 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. -
Ms Access/Sql Server DeveloperUtah Department Of Agriculture And Food Jan 2019 - PresentTaylorsville, Utah, UsManaging 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. -
PresidentTj'S Tools Llc Jan 1997 - PresentProvide 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. -
Excel Vba EngineerVpapps, Llc Mar 2018 - Apr 2022Bellevue, Wa, Us1. 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. -
Microsoft Access DeveloperKeola Lai Condominium Mar 2018 - Jan 2019Working 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.
-
Software EngineerSunrise Helicopter Llc Jun 2016 - Jun 2018Working 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. -
Ms Word And Excel Vba DeveloperExpert Ojt System Nov 2011 - Apr 2017Job 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 -
Excel Model DeveloperIpsos Dec 2009 - Feb 2014Paris, FrOncology 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. -
Database DeveloperHawaiian Legacy Hardwoods Jan 2009 - Dec 2013Worked 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). -
Computer ConsultantNaral Pro-Choice America 2004 - 2013Washington, Dc, UsWho 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. -
Ms Access Database Design And DevelopmentPlanned Parenthood Of Orange And San Bernardino Counties Sep 2005 - Aug 2008Anaheim, Ca, UsLegislation 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. -
Computer ConsultantFm Talent Source Aug 2006 - May 2007Silver Spring, Md, UsAmortization 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. -
Excel/Access/Oracle Applications DeveloperFannie Mae 2006 - 2007Washington, District Of Columbia, UsWorked 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. -
Software Architecture And Data MigrationHuman Rights First Jan 2004 - Sep 2005New York, Ny, UsPrimary 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. -
Vba ConsultantMerrill Lynch Research Technology 1999 - 2002New York, Ny, UsiQ 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. -
Applications DeveloperMerrill Lynch Research Technology 1999 - 2001New York, Ny, UsWorked 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.
-
Applications DeveloperWachtell, Lipton, Rosen & Katz 1999 - 2000New York, Ny, UsWord 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. -
Software Applications DeveloperMemorial Sloan-Kettering Cancer Center 1998 - 2000New York, Ny, UsMedical 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. -
Applications And Support SpecialistWhite & Case Jun 1998 - Jun 1999New York, New York, UsMaintained 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. -
Microsoft Excel DeveloperConde Nast Publications 1995 - 1998Developed 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.
-
Executive DirectorTheatre-In-The-Schools, Inc. 1984 - 1991Wang 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.
Timothy Jeffryes Skills
Databases
Access
Visual Basic
Sql
Software Documentation
Vba
Project Management
Microsoft Sql Server
Programming
Microsoft Excel
Oracle
Javascript
Testing
T Sql
Html
Microsoft Office
Database Design
Microsoft Access
Visual Basic For Applications
Excel
Xml
Asp
Powerpoint
Documentation
Visio
Ms Project
C#
Visual Studio
Word
Sql Server
Timothy Jeffryes Education Details
-
New York University Tisch School Of The ArtsActing -
Kalani High SchoolHigh School Diploma
-
Kalani High School; Honolulu, HawaiiHigh School Diploma
Frequently Asked Questions about Timothy Jeffryes
What company does Timothy Jeffryes work for?
Timothy Jeffryes works for Sharp Decisions
What is Timothy Jeffryes's role at the current company?
Timothy Jeffryes's current role is MS Access VBA customization with SQL Server, HTML, JavaScript, and ASP.
What is Timothy Jeffryes's email address?
Timothy Jeffryes's email address is ti****@****pps.com
What is Timothy Jeffryes's direct phone number?
Timothy Jeffryes's direct phone number is +180835*****
What schools did Timothy Jeffryes attend?
Timothy Jeffryes attended New York University Tisch School Of The Arts, Kalani High School, Kalani High School; Honolulu, Hawaii.
What are some of Timothy Jeffryes's interests?
Timothy Jeffryes has interest in Programming, Children, Environmental Justice, Environment, Education, Poker, Theatre, Bicycling The World, Poverty Alleviation, Science And Technology.
What skills is Timothy Jeffryes known for?
Timothy Jeffryes has skills like Databases, Access, Visual Basic, Sql, Software Documentation, Vba, Project Management, Microsoft Sql Server, Programming, Microsoft Excel, Oracle, Javascript.
Who are Timothy Jeffryes's colleagues?
Timothy Jeffryes's colleagues are Olushola Oyinloye, Rakesh Sharma, Palden Kyab, Miranda Small, Sierra Coleman, Emma Brown, Jyoti Roy.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial