MS Excel Pivot Tables

Read More

MS Access or SQL Database Development

MS Access Custom Form

MS Access or SQL Database Development

Quality database using MS Access or SQL Server

• Administering SQL server databases.
• Backups, Recovery, jobs, linked servers,
• Triggers
• SQL Profiler

Replication

• Implement and troubleshoot replication in SQL server environment
• Writing TSQL ad-hoc queries and reports
• SSRS reports
• Custom Report and Business Intelligence Reporting
• Stored procedures;
• SQL Server Functions 
• Creating database objects, ,
• SSIS packages
• · Designing and Implementing SQL server databases
• Expert Data Translation
• Moving data between SQL Server, ACCESS and ORACLE
• Creating, testing and troubleshooting patterns/problems using .NET, C#  and VB
• Collaborating with team members to establish data requirements
  · Automating complex tasks through scripting
• Installation, Support and Maintenance

Read More

MSACC: Dir Paths and ShortCuts

Subject: finding the paths of an MS Access Project
Posted Under: Files, Directories and Path

Borrowed in part but extended from this posting:

http://support.microsoft.com/kb/210395

Option Compare Database
Function g_GetFullName()
   'Returns full path including file to currently opened MDB or ADP
   g_GetFullPath = CurrentProject.FullName
End Function
Function g_GetPath()
   'Returns the path to currently opened MDB or ADP
   g_GetPath = CurrentProject.Path
End Function
Function g_GetFullConnection()
   'Returns the filename of the currently opened MDB or ADP
   g_GetFullConnection = CurrentProject.Connection
End Function
Function g_GetName()
   'Returns the name of of the currently opened MDB or ADP : returns "my app name.accdb"
   g_GetName = CurrentProject.name
  
End Function
' save time run all in one call
Function GetAll()
Debug.Print "con: "; g_GetFullConnection; vbCrLf
Debug.Print "PATH:  "; g_GetPath; vbCrLf
Debug.Print "name:   "; g_GetName; vbCrLf
Debug.Print "Full Path:   "; g_GetFullPath; vbCrLf

End Function

Read More

Microsoft Technology

Microsoft Technology -

Highly Skilled in most phases of Windows Server

Application - Service - Technology
Windows Server 2000 to current versions - we strive on being 100% current
SQL Server 2000 to 2008
ASP.NET
.NET Framework (all versions)
Windows Development
Application Framework
Microsoft IIS Web Servers and Solutions
Web Site Development
Server Monitoring
HTML
CSS – Tables, Forms, Controls
ASP Controls
VB or C# Experience in either language is related to
AJAX Controls
DevExpress
Telerik – RadGrid, RadUpload, RadMultiView, RadMenu
Telerik - Silverlight Controls (limited experience)
SQL, XML, XMPP, Web Services, SOAP, REST
Visual Studio 2005, 2008, 2010
Custom Repeaters, Custom Data Paging, DataBinding, Datasets
Custom LINQ Paging, SQL Paging
Adobe: PhotoShop, Bridge, Premier (Limited), PDF
Microsoft Azure Cloud Computing – testing only
Microsoft Partner since 1996
www.DotNetStoreFront.com customization and installation
www.splendidcrm.com
Minor customization and installation
CSS – Extensive use of tableless forms, ordered lists, divs, precision stylesheets that seamlessly integrate with master pages,
Microsoft Office Suite from 1997 to 2010, Excel, Word, Access, PowerPoint, Info Path, VBA, Publisher

Read More

BRIEF HISTORY OF PAST PROJECTS

A Brief History of Past Projects

---

The projects are shielded to protect clients from marketers, spams and unsavory salespersons who have in the past have used my resume to build their client list. 

Important Information about past clients. 

I strive to remain current in technology as much as humanly possible but the focus is squarely set Microsoft technology and ASP.NET

Software Development – 1990 to Present
Develop custom database applications; provide software services and business consulting to various companies primarily in the Bay Area. Developing applications using the majority of current social networking tools and API.

---

Managing Resources
Managed application developers, Graphic Designers, multi-media professionals and Creatives for the purposes of managing projects.

Projects utilized numerous technologies but our focus was constantly stay current with leading technology to be fully prepared when major revisions would roll out.

Mortgage Industry – Present 
Strong knowledge of back end mortgage processing, debt consolidation, HELOC, default rates, developing real estate marketing systems for mortgage brokers, contractors, and real estate agents.

Mortgage Loan Agent – Present 
Independent loan representative originating home mortgages, commercial loans, and home refinancing. Originate customers, loans, sourced clients through various marketing programs and efforts. Strong ability to interpret loan rate sheets and loan programs.

Terra Vista Software Walnut Creek CA 2004/05Developed software testing application for SonyStyle.com project, evaluated application architecture, made recommendations and implemented strategy to replace underlying software model.

Built For My Son 2003
 

Cabinetmaking Shop – Fairfield CA 2003-2004
Owner of custom cabinet shop, built and designed cabinets, fixtures and restaurants under temporary operations for 9 months, sold business operations back to owner.

Contra Costa County Summer 2001
Developed with MS Access database to that extracted and analyzes telephone billing calls and patterns.

SBC/Pacific Bell- San Ramon CA Summer/Fall 2001
Develop customized application for DSL order department using ASP Classic , VB and Internet.
Wells Fargo Bank 2000/2001 – Internal IT tracking database
MS Access database for managing internal projects and initiatives.




Jobwire.net – Authentic Technologies 1998-2004
Developed an internet job posting board for Dot Com Web Play. Successful revenue generating operation - ASP Classic and SQL.

Plan-it Interactive –1999-00 
Developed customer and account management database. Installed WAN/LAN for five locations. Automated business processes, scheduled events, employees and trucks. Used MS Access and ASP classic.

MustangSoccer.com – Authentic Technologies 2000 
Development of a youth sports site complete with fields, schedules, players, and on-line registration system. Site was taken over by larger vendor and original site was donation from our firm.

Authentic Technologies –1997-2002 President
Founder of a software development operation consisting focusing on projects for the Dot Com boom, raised capital for multiple web plays, created joint venture agreements, cross marketing programs and customized business solutions.

Outlook Companion – Email management 1998-99
Developed add-in for client and then created a version for downloading. Used Outlook 97/98 to assist MS Office users with automation of tasks inside of MS Outlook.

www.FreeSportsPlay.com – Joint Venture Project
Lead architect for developing online gaming application that allowed users to play for points and prizes. Project consisted of integrating five developers focused on web development. This site is down as the venture folded.

Bank of America  –Loan Systems 
Developed internal mortgage tracking system to capture transactions related to Mortgage Transaction Processing.

PG&E  San Bruno Fire 
Developed internal tracking system specifically related to the San Bruno Fire in Sept 2010.  Project began in 2011 and finished later that summer.

Comerica Bank Developed custom reporting application using MS Access to track loan defaults and delinquent loan accounts. Integrated reporting data into MS Access and Excel for analysis via pivot tables.

AMI Flight Charter Operations - San Francisco 1997-98
Developed reporting application using MS Access to supplement flight operations scheduling program. Importing and exporting of schedules, airport arrivals/departures and expense data. Reports provided with detailed expenses for each plane.

Project Management Database- Authentic Technologies 1998-2000
Internal company database created in MS Access 2000. Tracks projects, customers, Utilizes MS Outlook libraries to manage Email, appointments and calendars. Integrates to MS project. Tracks employee time on projects, manages hosted clients DNS records, and generates billing statements. Created ASP web interface for client access. Tools: NT Server, ASP, SQL, MS Access, Java Script, VB script, COM, VB, CDONTS, Win32 API and MS Exchange.

McCready Insurance Summer 1998
Converted billing system using VB and MS Access. Migrated user to NT servers from Novell 3.x to Windows 4.0.

Levi Strauss 1997 
Developed Access/VB application to manage subsidiary cash flows. Provided currency translations, FTP upload from 88 subsidiaries located world wide. Project provided corporate treasurer with accurate information regarding cash on hand held by subsidiaries.

Irwin Home Equity – 1996-97
Developed a variety of applications for a fast growing mortgage loan company. Developed multiple applications in Access 2.0 and 95, DOS, Qbasic, VB 4.0 and 5.0, supported Eastern Loan Origination System, FiServe, Novell 3x, NT server 3.5, Created database to manage loan portfolio for 10 Q reports, portfolio cash flows available cash reserves.

Computer Land Stores– 1995-96
Developed in-house reporting system for tracking returns and shipments from distribution system. Primary tools were MS Access using ODBC against Sybase database. Rolled up data for integration with Excel using VB, VBA and Office 2.0 Automation. Reports provided clients with relevant reports on product pipeline, sales and production plus developed MBS Analytics.

Clone Zone 1990-93 
Retail computer store owner: Focused on selling new and used computer. Installation, repairs, service, networks, new systems, training and consulting. Authorized reseller for most major brands. Staff consisted of 4 employees, managed sales, marketing, advertising, purchasing and payables. Prepared all aspects of accounting and tax preparation requirements.

MainFrame Designs 1980-89 
Operated 10,000 SF mid-sized cabinet and millwork shop with ten full time employees. Design build operation focused on commercial fixtures, stores, schools, hospitality and restaurant trades. Projects included Moscone Convention Center, San Jose Airport, Tony Roma’s, Wendy’s International, McDonalds, Emporium Capwells, Macy’s, Flakey Jakes Restaurants, Fresh Choice. Contra Costa County Colleges District, UC Berkeley, Wells Fargo Bank, Chevron, Pacific Bell and many major chains in Northern California and Nevada.

Read More

MS Access Developer - 1994 to Present

Over 20 years I've developed at least 300 databases.  Many very small that often served shortterm client needs.  In the late 1990's MS Access was very popular with the workgroups but was hated by IT Managers back when Novell Networks always had trouble with file handles. 

Past customers have been Fortune  500 entities to the small business.  Scope of work usually is get it done fast and it's too complicated for us or we don't have the time. 

The natural transistion was porting my skills to ASP, then to ASP.NET / .NET technologies.  The early days of .NET were bumpy with libraries that said they could do something but often failed but now Visual Studio (2012) is rock solid with zillions (big word) of features.

MS Acess is a solid application that serves many companies very well but MS Access has shortcomings that may or may not be a problem.  The .NET platform takes longer but outperforms in many ways but we can support either technology.

Read More