SUMMARY:

• Microsoft Certified MS Access Developer with extensive experience developing custom applications using .Net, MS Access, Excel, Visual Basic, and SQL Server. Eleven years leading and developing web based solutions.
• Primary liaison with customers at all levels in their organizations - management, stakeholders, and users. Interpret customer requirements and determine overall hardware and software needs.
• Technical lead responsible for managing full life cycle of projects -- requirements definition, design, development, testing, deployment, modifications, and problem resolution.
• Led and managed the development of several applications using MS Access and SQL Server.

TECHNICAL SKILLS:

Programming: VBA (Access, Word, Excel, Project & Outlook 97-2003), all previous versions VB

Internet tools: CSS, HTML, JavaScript, ASP.NET, VBScript, PHP, SQL Server, MySQL, IIS 6/7

Networking: TCP/IP and Hardware configuration, Windows Server/Domain management

PROFESSIONAL EXPERIENCE:

Confidential

Lead Developer

Responsibilities:

• Primary liaison with customers at all levels in their organizations - management, stakeholders, and users. Interpret customer requirements and determine overall hardware and software needs.
• Technical lead and responsible for managing full life cycle of projects -- requirements definition, design, development, testing, deployment, modifications, and problem resolution.
• Responsible for high level application and database design. For web based solutions, responsible for devising a structure that cleanly separates code for presentation, content, and functionality. Design high level html layout, CSS code, and .NET master/child pages.
• Staff and lead a team of programmers and specialists to assist in development as needed. Direct and manage work assignments of employees, outside vendors, and off-shore support to meet customer schedule and budget expectations.
• Strong server and networking skills used in the configuration, administration, and maintenance of application, website and database servers for development, test, and production.
• Developed an Access application (Case Manager) for the tracking of HUD sponsored mortgage claims.
• Designed the database and user interface for tracking a claim through its processing lifecycle: Receipt, Review, QA, Voucher/Denial, Disbursement, and Payment Notification.
• In addition to tracking work flow, the File System object is harnessed to transfer relevant case documentation from the scanner drop folder to cognizant personnel (analysts and QAs) working folders.
• Database is optimized to handle the large volume of claims processed (approx.1,000/month). The application was designed with the core processing related features as table driven to ensure flexibility and expandibiltiy to meet the needs of the ever changing HUD regulatory environment.
• The application interface is developed entirely in VBA using Object Oriented Programming (OOP) principles via MS Access classes.
• All data retrieval functions use parameter based queries to facilitate upsizing to SQL Server in the future.
• Weekly reports are generated using Access and Excel providing real-time status of cases, inventory workload, and billing reports for invoices submitted to HUD.
• Version 2 will assist financial analysts in the review of claims through an interface designed to ensure mortgage applications meet all relevant criteria and all required documentation has been submitted.
• Also developed financial reporting application to summarize Dept. of Labor data by various financial criteria, e.g., GL, fund, agency, etc. Menu driven application allows users to load criteria for a specific report and generate details and summaries output to screen, pdf-ready reports, and MS Excel.

Confidential

Technical lead

Responsibilities:

• Worked directly with company’s CIO and EVP of Marketing to determine the overall company vision at the outset and at each major milestone to determine expectations and establish budgetary and schedule constraints.
• At the working level, routinely interfaced with managers in marketing, compliance, software, and data groups to generate detailed requirements, establish testing and production facilities, and schedule deliveries.
• Assembled and led a team in-house and external graphic artists and web programmers to implement company’s marketing vision across four websites - English & Spanish Consumer, Corporate, and separate care center. Maintained compliance with ADA and CMS (medicare) driven web practices.
• Developed underlying .NET architecture of the site to allow the smooth integration with web hosted apps and utilities, while maintaining separation of design, programming, and content related code and developer efforts.
• Developed custom MS Access application to manage native and linked content.

Confidential

Responsibilities:

• Led and managed the development of several applications using MS Access and SQL Server.
• ADA’s planning and Budgeting Tool (PBT) used to coordinate the development of a national organization budget pyramidically built up from individual local and regional offices.
• Managed upgrades and general software maintenance as it was improved each year until the organization’s migration to Oracle Financials. Developed formal administrator and user training modules and provided nationally at regional offices.
• ADA’s Production and Books Management application (PBM) used to track resources and materials inventories to ensure needs of field offices are met by the production division. All items produced and stocked by ADA are managed using PBM, e.g., recipe books, campaign marketing materials, branded supplies, flyers, etc.
• Distribution and associated inventory depletion (whether by sale or internal distribution) was also monitored to trigger production managers of critical restocking points.

Confidential

Responsibilities:

• Planned and directed the development of an Access application for the management of conference planning, attendance, and financial information.
• Application evolved through multiple iterations and versions of Access through version 2000 and ultimately was used by company for management of all operations related to their conference planning and management business.
• Also developed an online e-commerce registration component that automatically synchronizes with their local Access data.

Confidential

Responsibilities:

• Developed a scheduling and team management application for a local Little League using MS Access for the user interface with MySQL as the database back-end and PHP and .NET web pages for the display of public information.

Confidential

Responsibilities:

• Developed an MS Access application for the management and tracking of all Engineering Change Proposals (ECPs) related to the F/A-18 aircraft production.
• The application was used to generate and manage the history of all related official correspondence.
• Directed the design and development of the FDIC National Insurance System (NIS), v 2.0 -- a Client/Server system for the management of data pertaining to the myriad of insurance coverage maintained by the FDIC on real estate owned by the FDIC. NIS tracked coverage durations, limitations, all related expenses, and status of damage/injury claims. NIS 2.0 was a full redesign of its predecessor, which was programmed in Clipper. NIS 2.0 was designed to be Web based with an ultra thin client.
• Instrumental in assisting the FDIC Data Analyst on the reengineering of the database architecture from Clipper to SQL Server 6.5.
• Temporary Programmer/Analyst positions (full and part time) for various companies and government organizations either directly or through a placement agency.
• Primarily developed applications in Visual Basic and VBA (MS Access, Excel, and Word). Designed and maintained SQL Server and Access databases.

Confidential

Responsibilities:

• Visual Basic programmer and team leader.
• Developed Confidential enterprise application for business managers to automatically generate contract proposals. App calculated pricing and availability for voice/data services required by a specific customer and printed results in proposal format.
• Also assisted department manager in parsing daily DB2 data runs for billing department. Trained other employees in the use of MS Access, Visual Basic and other Windows based applications.

Confidential

Visual Basic programmer

Responsibilities:

• Lead programmer responsible for application delivered to US Navy PEO that allowed acquisition managers to plan and budget major contracting initiatives for engineering changes to aircraft weapon platforms.
• Personally responsible for application interface designed entirely based on MS Object models. Designed Access 7.0 table structures for prototype & later migrated the data side to SQL 6.5.

Confidential

Responsibilities:

• Developed Access 2.0 / Visual Basic 3.0 application to track the location, connectivity & usage of Defense Messaging equipment around the world.
• Designed and developed record change monitoring system to achieve data replication & synchronization across multiple locations.

Confidential

Responsibilities:

• Developed Intranet web site using IIS 3.0, FrontPage, ASP, VBScript, and MS Access 7.0. Site provides flexible querying and reporting on project data in Access database, password-protected data updates of the same.

Confidential

Responsibilities:

• Directed the development of assorted in-house applications using Oracle & SQL/S back-end data with Excel front end interfaces using VBA.
• Supervised a project which was converted from Excel VBA application to a IE 4.0 front end interfaced with Active X components.
• Led the development of a custom application for a local homebuilder allowing progress tracking and reporting of multiple-lot building projects.
• The application was developed with VB 6 interface using MS Access back end through MS Project VBA objects.
• Designed & developed the MS Access database & VB front end for a vertical app that calculated FCC frequency assignments.
• The application was designed to access stored information or process new applications.
• Developed Access 2.0 application to track U.S. based student populations, scholastic performance & financial activity for a foreign embassy.
• Added a financial module that strictly adhered to foreign government's accounting & reporting requirements.
• Application source code was ultimately purchased outright to permit use in home country and embassies based in other countries.