OBJECTIVE:

• To contribute to robust business solutions and test environments using .NET/MS Access (version 2.0 - 2013)/VBA/SQL Server/SSIS/SSRS/Oracle/VB6

SUMMARY:

• Rich experience working with clients/end-users to design, create, test, document and implement custom MS Reporting Services, VBA, VB6, SAP Business One SDK, MS Access, Excel, databases, user manuals and web sites
• Experience with design requirements, systems analysis, MS Office automation, UAT scripts and implementation, VBScript, VBA, SQL Server, Access ADP/MSDE, database conversion (Access 2.0-Access 2013). .NET, SSIS
• Experience with compensation, commissions and incentive data, workflow and reports, data reconciliation
• Extensive experience with data merge, scrub and cleanse from disparate data sources
• Rich experience creating complex work flow applications referencing disparate data sources
• OOAD
• Extensive experience with complex logic, business rules and Windows forms

PROFESSIONAL EXPERIENCE:

Confidential

MS Access/MS Excel Developer

Responsibilities:

• Create complex MS Access database to store and update MBOM and EBOM data for the design and manufacturing of sub-orbital space ships
• Support and modify multiple MS Access databases for storing and updating FAA-required documentation for sub-orbital spaceship and mothership

Confidential

MS Excel/MS PowerPoint Developer

Responsibilities:

• Created complex formatting process to integrate existing MS Excel workbook into PowerPoint
• Extensive VBA coding for PowerPoint and Excel DOM
• Project was completed early and under budget

Confidential

MS Access Developer

Responsibilities:

• Create manual ETL processes (MS Access and MS Excel) for translating 40,000 Covidien product licensing data for Confidential SAP upload for 34 countries
• Extensive data scrub, cleanse and merge
• Create ad hoc reports for senior management

Confidential

MS Access Developer

Responsibilities:

• Created complex MS Access databases to track campaign activities for non-profit fund raising projects
• Complex business rules, mail merge and reporting

Confidential

MS Access/MS Outlook Developer

Responsibilities:

• Created MS Access/MS Outlook application to customize, send and track emails for 1700 FedEx outlets nationwide

Confidential

SQL/.NET developer

Responsibilities:

• Rewrite complex MS Access database into .NET/SQL solution for TV programming distribution company, including stored procedures, triggers and views
• Troubleshoot and repair existing complex MS Access database including generating ad-hoc reports as needed
• Debug complex stored procedures

Confidential

VB6/MS Access/VBA/Excel developer

Responsibilities:

• Converted complex Excel spreadsheet to MS Access for project estimations
• Implemented complex business rules (including logarithmic functions) to estimate FTEs, hours and cost for projects ranging from 2-18 months
• Created front-end/back-end architecture to allow n-users to utilize database using single back-end
• Assisted in legacy VB6 support

Confidential

MS Access/VBA/Excel developer

Responsibilities:

• Create and maintain multiple, complex MS Access databases (versions 2003, 2007 and 2010) for Wealth Management Fees/Wachovia integration/Sales and Treasury Mgmt/Risk Compliance.
• Create and maintain multiple processes for Cash Vault and AML data reconciliation
• Implement complex business rules across multiple work-flow projects, complex reports, batch processing
• Extensive MS Word automation including dynamic margins, bookmarks, embedded bookmarks, spacing, paragraph insertion and spacing, blank page removal, headers, footers
• Create UAT scripts and manage UAT across multiple states
• Create and support Tableau work books
• Create and maintain SQL Server tables, functions and stored procedures for ODBC-connected MS Access databases
• Created MS Access and Excel reports using AS/400
• Create and maintain Info path forms
• Create SSIS packages and .NET scripts consuming large data sets (>100M records)
• Support multiple, multi-user MS Access databases for >150 users throughout the US

Confidential

MS Access/VBA/Excel developer

Responsibilities:

• Create and maintain multiple MS Access databases for sales commissions and fleet services for GE nationwide

Confidential

MS Access/VBA/Excel developer

Responsibilities:

• Created and maintained 100+ commissions, compensation and incentives reports for sales representatives (approx. 1500) for Confidential nationwide, created table-driven process to automate report updates and design changes allowing for 1 programmer to support entire reporting process for the sales dept., extensive use of crosstab queries, manual ETL for disparate data sources (SQL Server, Oracle, Excel, text-delimited files), worked with commissions, payment, compensation and sales managers creating ad-hoc reports and applications for sales, compensation, commissions and payment detail, extensive data reconciliation for sales comp. and bonuses, extensive use of automating Excel and MS Access for workflow processes and reporting, created multiple automated (overnight) batch processes for ETL data for multiple departments

Confidential

MS Access/VBA/Excel developer

Responsibilities:

• Created MS Access 2003 database allow buyers and sellers of foreclosed properties to communicate, database will be business model for nationwide rollout of Confidential applications and websites, database includes complex business rules and logic

Confidential

MS Access developer

Responsibilities:

• Created complex estimating and pricing tool using Access 2003 and SQL Server 2005 back-end (stored procedures and triggers)
• Created small VB6 interface with SQL backend to track production errors
• Complex UI with large number of integrated business rules

Confidential

MS Access/VBA/Excel developer

Responsibilities:

• Supported trading desk for mortgage-based transaction
• Supported extensive batch files, VBScript, Windows Scripting processes
• Assisted in rewrite, support and creations of daily reporting process for robustness and accuracy
• Extensive MS Excel and MS Access support and development
• Implemented SQL Server 2000 Microsoft Reporting Services, MS Outlook automation and custom forms
• Data scrub, cleanse and merge from multiple systems and platforms including Bloomberg, Excel, Access, VB6, Word, SQL Server, Oracle and DB2

Confidential

Database and application developer

Responsibilities:

• Application Developer (contract)
• Assessed, converted and migrated 80,000 MS Access databases for Confidential nationwide
• Implemented Converter Technology’s Office Converter
• Supported 4000+ end-users
• Project was completed on time and within budget

Confidential

MS Access/VBA/Excel developer

Responsibilities:

• Retooled and enhanced MS Access database used for tracking heart valve machining and manufacturing data
• Implemented regression testing, weighted averages, complex formulae within multiple processes
• Implemented extensive MS Access and MS Excel automation
• Created complex forms and reports for manufacturing, and purposes
• Worked with multiple depts./sales managers to create hotline application utilizing MS Access/Oracle back-end for Confidential sales and of 400 products
• Implemented Oracle back-end, pass-through queries, extensive GUI manipulation, complex business rules for multiple applications
• Created automating reporting system for CareLink services and products with reports sent to 93 district sales managers nationwide
• Creating SMS-supported hardware/software-tracking database (for Confidential worldwide - 40,000 network-connected devices) with integrated VBA, SMS, SQL, Created .NET interface for data viewing SMS-gathered data
• SQL Server 2000, Oracle, 3-party and homegrown software applications
• Created complex staging, data scrub, cleanse, and merge processes for heart-valve manufacturing

Confidential

MS Access/VBA/Excel developer

Responsibilities:

• Created multiple and varied MS Access and MS Excel processes to cleanse, scrub and merge data for Fortune 100 clients
• Managed large, complex data streams (DB2, Oracle, SQL Server) for data staging
• Extensive data merge and analysis for GL, commissions and data reconciliation
• Created, enhanced, converted, maintained and documented multiple MS Access 97/2000, MS Excel and VB6 applications and interfaces for various departments
• Experience with payroll and 401K/investments
• Consume AS/400 data for reporting and data analysis
• Developed complex, LAN-based VB/Access 2000/Oracle 7.3 workflow applications with multiple back ends using: Word, Outlook, Excel, ADO, ODBC, DAO, timed synchronization, combinations and permutations for matching processes
• Complex algorithms for data manipulation
• Created custom MS Outlook forms and complex reports
• Assisted with department-wide conversion from Access 97 to Access 2000

Confidential

MS Access developer

Responsibilities:

• Worked with sales managers to enhance existing Access 97 database for ease of use, data display, and price-tracking, modified and optimized existing table and forms
• Estimated time savings: 1440 hours per year

Confidential, Eagan, MN

Software engineer

Responsibilities:

• Team member that assisted in the design and creating of a large 3-tier automated CD test/QA application that utilized Crystal Reports, VB 6, QARun, Access 97, SQL Server 7, VBScript, HTML, ASP 3.0, project saved $1M over 24 month period
• Created multiple custom utility programs using VB6 for related CD QA tests
• Created intranet website for online documentation
• Lead Y2K departmental programmer, tested or modified 750 existing PL/1 programs for Y2K compliance
• Created curriculum and manuals for Y2K project for multiple departments Y2K project brought in early and under budget
• Supported large proprietary Powerbuilder/Sybase application and provided related and documentation for 75 end users in 4 states
• Created proprietary text conversion programs using PL/1 in an IBM MVS environment using JCL, TSO and Expediter
• Maintained and debugged PL/1 programs while concurrently testing for Y2K-related problems

Confidential

MS Access/VB6 developer

Responsibilities:

• Created multiple VB6/MS Access applications including: 2-tier applications using VB6/MS Access 2002 and VB6/SQL Server 2000
• Created stand-alone Access 2002 databases to interface with MAS90 for shipping, sales forecasting and machine efficiency
• Implemented statistical formulae for Excel reports and graphs
• Created complex reporting tool to predict inventory needs for 1200 products (supply chain)

Confidential

SAP Business One SDK developer

Responsibilities:

• Utilized VB6 (with some .NET) to create multiple custom forms for quote, contact functionality
• Extensive use of UI, DI, DTW, experience with UI and DI object models

Confidential, Minneapolis, MN

MS Access developer

Responsibilities:

• Enhanced existing and complex Access 2000 database and Excel spreadsheets for low-income housing non-profit organization
• Experience with Section 8, tenant-landlord, rent and eviction issues as they relate to data and reports

Confidential, Minneapolis, MN

MS Access developer

Responsibilities:

• Converted Access 2.0 to Access 2000 database for use in phone tracking/hotline data, normalized tables, extensive data scrub, conversion and merge

Confidential, Mpls., MN

Associate instructor

Responsibilities:

• Created curriculum and documentation for, and instructed college students in, web design and dynamic web pages using ASP 3.0, VBScript, HTML, ADO, Access 2000

Confidential, St. Paul, MN

Program analyst

Responsibilities:

• Created automated utility subprograms/interfaces to enhance large VB 6, DB2 and Access 97 application
• Assisted other team members with system programming (PERL/C) duties and web duties (ASP, HTML)

Confidential, Mpls., MN

Application developer

Responsibilities:

• Trained corporations for beginning and intermediate MSOffice products
• Developed websites using VB6, ASP 3.0, VBScript, HTML, JavaScript, ADO, Access 97/2000, and SQL Server
• Created SMB applications and websites for various clients
• Created MS Access ADE/ADP/MDE databases
• Experience with upsizing Access to SQL Server 2000