Groups
Keywords
Username: tjeffryes
Minimum Hourly Rate: $50/hr
Location: United States, NY, New York
Summary
Bringing Your Project to Fruition
We deliver.
Having worked extensively both as architects/designers and as end users, we know the needs, frustrations and expectations of users. We keep our interfaces as intuitive and user-friendly as possible. Simple is key.
We have worked in a wide range of industries for such clients as Merrill Lynch, Fannie Mae, Goldman Sachs, New Yorker Magazine, Memorial Sloan Kettering Cancer Center, Planned Parenthood, and Human Rights First.
In developing software for clients, we have three major goals: re-usability of code (modularization), readability of code (because we know someone else may eventually be maintaining it), and ease of use by the end-user. Additionally, we focus on timliness, efficiency and making sure the code is robust enough to handle all known situations.
Using our acquired knowledge over 14 years of software development, we will work with you to establish your exact needs so that you get what you expect.
We deliver.
Having worked extensively both as architects/designers and as end users, we know the needs, frustrations and expectations of users. We keep our interfaces as intuitive and user-friendly as possible. Simple is key.
We have worked in a wide range of industries for such clients as Merrill Lynch, Fannie Mae, Goldman Sachs, New Yorker Magazine, Memorial Sloan Kettering Cancer Center, Planned Parenthood, and Human Rights First.
In developing software for clients, we have three major goals: re-usability of code (modularization), readability of code (because we know someone else may eventually be maintaining it), and ease of use by the end-user. Additionally, we focus on timliness, efficiency and making sure the code is robust enough to handle all known situations.
Using our acquired knowledge over 14 years of software development, we will work with you to establish your exact needs so that you get what you expect.
Experience
Skills
|
Self-rated
Tested More Info
|
||
|
Elance Admission Test
|
Passed
|
More Info |
|
Microsoft Office Access 2003
|
|
Avg.
|
|
|
Microsoft Office Excel 2003
|
|
Avg.
|
|
|
Microsoft Office Word 2003
|
|
Avg.
|
|
|
Microsoft Office Access 2007
|
|
Avg.
|
|
|
Visual Basic 6
|
|
Avg.
|
|
|
Adobe Premiere
|
|
|
|
English Basic Skills (U.S. Version)
|
|
Avg.
|
|
|
FrontPage 2000
|
|
|
|
HTML 4.01
|
|
|
|
Microsoft Office Excel 2007
|
|
|
Employment
Technology Sales Leads LTD
2009-2009 - MS Access 2000 , Excel 2000 Development Architect
Created Excel front-end to connect to 2 backend MS Access databases. All technology was in Office 2000 and all communication was via the internet. Interface allowed for end-user to choose databases from anywhere on the LAN and choose multiple points of data on which to report.
2009-2009 - MS Access 2000 , Excel 2000 Development Architect
Created Excel front-end to connect to 2 backend MS Access databases. All technology was in Office 2000 and all communication was via the internet. Interface allowed for end-user to choose databases from anywhere on the LAN and choose multiple points of data on which to report.
BAS Services & Graphics, LLC.
2009-2009 - MS Access 2007 Database design, architecture SQL Server
Worked with client to create rich MS Access front-end with a TreeView control for end-users to generate crosstab queries on data generated from remote sensing devices and input to SQL Server.
2009-2009 - MS Access 2007 Database design, architecture SQL Server
Worked with client to create rich MS Access front-end with a TreeView control for end-users to generate crosstab queries on data generated from remote sensing devices and input to SQL Server.
Altamont Country Kennels
2009-2009 - Access 2003 Developer
Revised queries and interface for client on guru.com. Communicated all needs and specifications via email and over internet connections.
2009-2009 - Access 2003 Developer
Revised queries and interface for client on guru.com. Communicated all needs and specifications via email and over internet connections.
Rapa Nui Youth Involvement Program
2008-2009 - Applications Developer
MS Access Database design, architecture MS Excel template design and automation
HTML, Javascript & Google Maps API implementation
http://www.terevaka.net/dc: Worked with client to create a method for mapping archeological data from Rapa Nui (Easter Island) in such a way that it could be easily accessible to the public via the website. Used Google Maps API to display 710 markers on a Google map, each representing moai (or statutes) from the island. Each marker can be clicked on to display a popup "tabbed info window" containing 4 tabs of data including photos and archeological details.
Created an Access database to house the data.
Created an Excel template that can be used to store any data that can be mapped in such a manner, making it easy for anyone with MS Excel to get their data onto the web with little effort.
2008-2009 - Applications Developer
MS Access Database design, architecture MS Excel template design and automation
HTML, Javascript & Google Maps API implementation
http://www.terevaka.net/dc: Worked with client to create a method for mapping archeological data from Rapa Nui (Easter Island) in such a way that it could be easily accessible to the public via the website. Used Google Maps API to display 710 markers on a Google map, each representing moai (or statutes) from the island. Each marker can be clicked on to display a popup "tabbed info window" containing 4 tabs of data including photos and archeological details.
Created an Access database to house the data.
Created an Excel template that can be used to store any data that can be mapped in such a manner, making it easy for anyone with MS Excel to get their data onto the web with little effort.
Access Safety LLC
2008-2009 - Excel 2007 Developer
Dependent Page Filters: Client was seeking a way to get Page Fields in MS Excel Pivot tables to display data based on information displayed in other page fields. For example, if both State and City were page fields and the end-user chose “Alabama” and “New York” for states, the City Page Field should only show cities for those states. The native behavior of Excel does not allow for that. The solution created for Access Safety did this seamlessly and without any additional effort on the part of the end-user.
2008-2009 - Excel 2007 Developer
Dependent Page Filters: Client was seeking a way to get Page Fields in MS Excel Pivot tables to display data based on information displayed in other page fields. For example, if both State and City were page fields and the end-user chose “Alabama” and “New York” for states, the City Page Field should only show cities for those states. The native behavior of Excel does not allow for that. The solution created for Access Safety did this seamlessly and without any additional effort on the part of the end-user.
Tinga USA
2008-2008 - Excel 2003 Develope
Usage Report: Created an Excel add-in for a Mexican food restaurant chain. Add in loads and removes custom menu items. Application opens text files that are generated by the Tinga Point of Sale system and parses non-linear data to retrieve food totals and subtotals to determine total quantities sold and how inventory needs to be refreshed.
2008-2008 - Excel 2003 Develope
Usage Report: Created an Excel add-in for a Mexican food restaurant chain. Add in loads and removes custom menu items. Application opens text files that are generated by the Tinga Point of Sale system and parses non-linear data to retrieve food totals and subtotals to determine total quantities sold and how inventory needs to be refreshed.
Solomon Enterprises
2008-2008 - MS Access VBA Developer
Batch Processing: Wrote VBA code for client that allowed for them to add hyperlinked files to their access database while simultaneously insuring data integrity and the existence of all hyperlinked files while in offline mode.
2008-2008 - MS Access VBA Developer
Batch Processing: Wrote VBA code for client that allowed for them to add hyperlinked files to their access database while simultaneously insuring data integrity and the existence of all hyperlinked files while in offline mode.
Planned Parenthood of Orange and San Bernardino
2005-2008 - Applications Developer - MS Access/HTML/ASP
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.
2005-2008 - Applications Developer - MS Access/HTML/ASP
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.
Fannie Mae
2006-2007 - Independent Consultant
Amortization Calculation, Automation and Reporting for Financial Restatement: Designed numerous applications in MS Excel and MS Access to enhance and automate the amortization processing for Fannie Mae's 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.
Another application was an Access database that allowed end-users to easily switch linked tables between various data environments (production, UAT, Development, etc). Additionally, this application used automation to create reports in Excel by extracting data from Oracle using either linked tables or SQL Pass-through queries.
A third application was a "code template" that remained on the shared drive and 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. Thus, all the code required to pull data and switch environments was essentially reduced to a simple command bar and 2-3 lines of code.
2006-2007 - Independent Consultant
Amortization Calculation, Automation and Reporting for Financial Restatement: Designed numerous applications in MS Excel and MS Access to enhance and automate the amortization processing for Fannie Mae's 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.
Another application was an Access database that allowed end-users to easily switch linked tables between various data environments (production, UAT, Development, etc). Additionally, this application used automation to create reports in Excel by extracting data from Oracle using either linked tables or SQL Pass-through queries.
A third application was a "code template" that remained on the shared drive and 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. Thus, all the code required to pull data and switch environments was essentially reduced to a simple command bar and 2-3 lines of code.
Human Rights First
Date Verified: March 07, 2009
2004-2005 - Data Migration Applications Developer
GetActive: Served as lead programmer in migrating data from CMS OnContact software to an online member management program called GetActive. Utilized MS SQL Server, MS Access and MS Access VBA to develop an automated process to synchronize the two databases. Challenges included the fact that GetActive is a flat file format and all interaction with it must be via an HTTP interface, multiple select data fields in both databases needed to be synchronized as well as the actual data, and both databases were live at development time.
Data Migration: From a CSV file generated by FileMaker Pro, massaged, cleaned up and migrated over 8,000 records into Raiser's Edge fundraising contact software. The project involved transforming a flat file structure into a relational database with a proprietary backend using SQL statements. Rigorous communications with staff were required to ensure the proper business rules. VBA for Access code was used in MS Access to create fuzzy logic routines to check for duplicate names, addresses and email addresses. VBA for Raiser's Edge was implemented to import data that their user interface would not allow.
Date Verified: March 07, 2009
2004-2005 - Data Migration Applications Developer
GetActive: Served as lead programmer in migrating data from CMS OnContact software to an online member management program called GetActive. Utilized MS SQL Server, MS Access and MS Access VBA to develop an automated process to synchronize the two databases. Challenges included the fact that GetActive is a flat file format and all interaction with it must be via an HTTP interface, multiple select data fields in both databases needed to be synchronized as well as the actual data, and both databases were live at development time.
Data Migration: From a CSV file generated by FileMaker Pro, massaged, cleaned up and migrated over 8,000 records into Raiser's Edge fundraising contact software. The project involved transforming a flat file structure into a relational database with a proprietary backend using SQL statements. Rigorous communications with staff were required to ensure the proper business rules. VBA for Access code was used in MS Access to create fuzzy logic routines to check for duplicate names, addresses and email addresses. VBA for Raiser's Edge was implemented to import data that their user interface would not allow.
About Me
Profile Type: Individual
Year Founded: 1993
Number of Employees: 1
In developing software for clients, we have three major goals: re-usability of code (modularization), readability of code and ease of use by the end-user. Additionally, we focus on timeliness, efficiency and making sure the code is robust to handle all known situations.
With more than 15 years of experience with MS Office, SQL Server and web programming, we have developed an extensive library of features that immediately become a part of your solution from the moment we begin work. Once such feature is our global error handling routine that is particularly useful during Beta testing -- this feature will send us an email in the unlikely event that an error is generated. The email contains the exact line number where the error occurred, the progression of events that led up to the error, the username and machine name where the program was running and optionally a message from the end-user describing in more detail what happened. This feature alone allows us to address issues within minutes instead of days.
A few examples of work we did some years ago:
Sloan Kettering Memorial Cancer Center: To over-ride the inherent clumsiness of MS Word's "protection" feature and "forms" feature, we completely remapped the keyboard so that users working in a specific template could not type in various areas of the document. This made it possible to be like a form, but with all the built in functionality of Word still available.
New Yorker Magazine: Created a complete Sales application for Sales reps to enter estimated sales along-side of actual sales, submit the data, create reports for management, and at the end of the week have all sales that converted to "actual" posted back to the spreadsheets.
With more than 15 years of experience with MS Office, SQL Server and web programming, we have developed an extensive library of features that immediately become a part of your solution from the moment we begin work. Once such feature is our global error handling routine that is particularly useful during Beta testing -- this feature will send us an email in the unlikely event that an error is generated. The email contains the exact line number where the error occurred, the progression of events that led up to the error, the username and machine name where the program was running and optionally a message from the end-user describing in more detail what happened. This feature alone allows us to address issues within minutes instead of days.
A few examples of work we did some years ago:
Sloan Kettering Memorial Cancer Center: To over-ride the inherent clumsiness of MS Word's "protection" feature and "forms" feature, we completely remapped the keyboard so that users working in a specific template could not type in various areas of the document. This made it possible to be like a form, but with all the built in functionality of Word still available.
New Yorker Magazine: Created a complete Sales application for Sales reps to enter estimated sales along-side of actual sales, submit the data, create reports for management, and at the end of the week have all sales that converted to "actual" posted back to the spreadsheets.
Payment Terms
We are a consuliting firm and generally bill twice per month as work is performed. We are flexible in our billing and are willing to work with you to create a mutually acceptable arrangement.
Detailed Service Description
We will arrive at a Specifications document through phone calls, in-person meetings and emails.
From the specifications document, a proposal will be created which will include a timeline, tasks to be completed, fees and obligations of both parties.
We can work on site or over the internet, depending on the project. English is our first language and all staff are college educated. Communication by email is often preferred as it facilitates both clarity and a paper trail in the event of a dispute.
From the specifications document, a proposal will be created which will include a timeline, tasks to be completed, fees and obligations of both parties.
We can work on site or over the internet, depending on the project. English is our first language and all staff are college educated. Communication by email is often preferred as it facilitates both clarity and a paper trail in the event of a dispute.
Credentials
References
Julissa Jose - Personal Reference - 2005
Planned Parenthood of Orange and San Bernardino, Vice President of Public Affairs
Microsoft Access database architecture, design and programming. Also involved in migrating data to a website. r
Planned Parenthood of Orange and San Bernardino, Vice President of Public Affairs
Microsoft Access database architecture, design and programming. Also involved in migrating data to a website. r
Danielle West - Personal Reference - 2004
Kinsella/Novak Communications, LLC, Project Manager
Worked on 3 separate MS Access databases at NARAL in Washington DC. Worked as technical liason between end-users and our development team.
Kinsella/Novak Communications, LLC, Project Manager
Worked on 3 separate MS Access databases at NARAL in Washington DC. Worked as technical liason between end-users and our development team.
Michael Xifaras - Personal Reference - 2006
Fannie Mae, Manager
Worked together on amortization schedules and Excel automation for the Fannie Mae 2004 Restatement Project.
Fannie Mae, Manager
Worked together on amortization schedules and Excel automation for the Fannie Mae 2004 Restatement Project.
Education
New York University School of the Arts, Bachellor of Fine Arts in Acting
1980 - 1982
1980 - 1982
