OBJECTIVE:

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

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

EXPERIENCE:

Confidential

MS Access Developer

Responsibilities:

• Create data transformation processes (MS Access and MS Excel) for translating 40,000 Covidien product licensing data (21 countries) for Confidential SAP upload
• 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

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

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

Confidential

Lead Application 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.
• 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
• 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

Application Developer

Responsibilities:

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

Confidential

MS Access/VBA/Excel developer

Responsibilities:

• Created and maintained 100+ commissions, compensation and incentives reports for sales representatives (approx. 1500) for Confidential, 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

Application Developer

Responsibilities:

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

Confidential, Cold Spring, MN

Database developer

Responsibilities:

• Created complex estimating and pricing tool using Access 2003 and SQL Server 2005 back-end (stored procedures and triggers)
• Complex UI with large number of integrated business rules

Confidential, Bloomington, MN

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, Word, SQL Server, Oracle and DB2

Database and application developer

Confidential

Responsibilities:

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

Confidential, MN

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, education and training purposes
• Worked with multiple depts./sales managers to create hotline application utilizing MS Access/Oracle back-end for Confidential sales and training 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 Confidential
• 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

Confidential, Roseville, MN

MS Access/VBA/Excel developer

Responsibilities:

• 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
• 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, Mpls., MN

Database 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 VB 6 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 training curriculum and training manuals for Y2K project for multiple departments Y2K project brought in early and under budget
• Supported large proprietary Powerbuilder/Sybase application and provided related training 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