SUMMARY

• This candidate is always seeking progressive companies to utilize 27+ years of solid IT experience.
• Data Warehousing
• Reporting Solutions (SSRS / Crystal Reports)
• ETL (SSIS)
• Database Development / Maintenance (SQL Server / Oracle) gained valuable experience working with SQL Server and Oracle creating and maintaining normalized databases including: tables, queries, triggers, functions, stored procedures and performance tuning as well as creating and deploying Business Intelligence (BI) packages and reports within SSIS, SSRS and SSAS. Was the main architect and implementer of a data warehouse project gathering data from five different ERP systems.

TECHNICAL SKILLS:

• National Agency Check (NAC) Security Clearance
• DATABASE
• PROGRAMMING
• ERP SYSTEMS
• SQL Server 2016/2014/2012/2008/2005/2000
• COM/DCOM
• SAP
• SQL Server Management Studio (SSMS)
• Turbo Pascal
• Great Plains
• Informix xBase
• Pivotal
• MySQL
• Microsoft Office (OLE) Automation
• Sedona
• Toad 10.6
• SOFTWARE
• Expandable
• Oracle
• Crystal Reports 11/9/8.5/7
• Exact Max
• PROGRAMMING
• Microsoft Access
• JobBOSS
• .NET (C#, VB, ASP, ADO)
• Microsoft Excel
• BI TOOLS
• XML
• Microsoft Word
• SQL Server Reporting Services (SSRS)
• Visual FoxPro 9/8/7/6/5/2.6
• SBT Accounting
• SQL Server Integration Services (SSIS/DTS)
• Java
• QuickBooks Pro
• SQL Server Analysis Services (SSAS)
• HTML
• FACS Collection Software
• SOURCE CONTROL
• Clipper
• Seagate Info 7
• Team Foundation Server (TFS)
• COBOL
• Cisco Unified CCX Historical Reports Client
• Subversion (SVN) dBase III/IV
• SQL Server Management Studio
• Visual SourceSafe (VSS)

PROFESSIONAL EXPERIENCE:

Database & BI Developer/Analyst

Confidential

Responsibilities:

• Setup the company’s SSRS Reporting Server including managing folders and user permissions.
• Developed a number of reports using both SSRS and Power BI, then deploying them to their proper folder locations.
• Developed many SSIS Packages to perform a number of different data migration and consolidation tasks to solve different data issues.
• Automated many manual data gathering and reporting processes utilizing SSIS and SSRS.

Environment: SQL Server (2016, 2014), Power BI, SSIS, SSRS, AWS, RedShift

SQL DBA/Developer

Confidential, Edina, Minnesota

Responsibilities:

• Helped support the data side related to Confidential national website creating and modifying scripts using SQL Server 2012, and 2008 - R2.
• Setup data feeds to streamline data from the customer’s online electronic transmissions, into the standardized website database used for all customers and MLSs. While doing this, Extracted, Transformed, and Loaded the data (ETL) using SQL Server.
• Worked within a fast-paced Agile Scrum environment, producing software releases/deployments on a regular basis.
• Worked extensively with Team Foundation Server (TFS) and Visual Studio 2013 to track individual projects from assignment, all the way through development, testing, and finally deployment.

Environment: SQL Server (2012, 2008 R2), TFS, Visual Studio 2013, ETL Industry: Real Estate

SQL Server Data Warehouse Consultant

Confidential, Eden Prairie, Minnesota

Responsibilities:

• The primary architect and developer for a new SQL Server data warehouse utilizing the Kimball Dimensional Modeling Technique.
• This warehouse uses an SSIS ETL process to pull together five completely separate ERP systems including: Expandable, ExactMax, JobBOSS, and QuickBooks.
• Designed and developed a number of reports using SSRS geared at extracting sales information using both self-service reporting, as well as reports automatically delivered using Data Driven Subscriptions.
• Setting up QODBC driver connection into QuickBooks for data retrieval.
• Responsible for installing and setting up the reporting server, as well as managing the users' security with regard to permissions and restrictions of the different reports and folders.

Environment: SQL Server (2012), SSRS 2012, SSIS 2012, SQL Server (2008-R2)

SQL Server Data Migration Consultant

Confidential, Chanhassen, Minnesota

• Developed and maintained SQL Server scripts & stored procedures required to extract, transform, clean, and move data for loading into the target system SAP from Dynamics Great Plains and Sedona ERP systems.
• Created and loaded many migration staging tables and views.
• Utilized SQL Servers’ Linked Server technology to consolidate data from a number of different server sources.

Environment: SQL Server (2008 R2, 2012, 2014), SAP, Dynamics Great Plains, Sedona

SSRS / Oracle BI Developer

Confidential,Paul, Minnesota

Responsibilities:

• Migrated all of the many reports being generated on individual user’s PCs into an SSRS 2012 server reporting solution.
• Responsible for the entire project from design, to installation, programming, testing, training and documentation.
• Connected the reporting server to an Oracle 11g database server.
• Created many Oracle and SQL Server functions, stored procedures, and lookup tables in order to satisfy reporting requirements.
• Responsible for training the local and offshore resources to take over the reporting administration once contract concludes.
• Setup the procedures and implemented all of the many Data Driven Report Subscriptions to customize the report delivery process.
• Setup and customized the Reporting Server security including creating new specific Roles and Tasks for the many users across the world.

Environment: SQL Server (2012), SSRS 2012, SSIS 2012, SQL Server (2008-R2), TFS, Oracle 11g, Toad 11.5

SQL Server / BI Developer

Confidential, Minnetonka, Minnesota

Responsibilities:

• Created a number of custom reports for the Confidential system called.
• Successfully completed the rigorous US Department of Defense Security Clearance, valid until August 29, 2023.
• Utilized SQL Server, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS), version 2008-R2.

Environment: SQL Server (2008-R2), SSRS (2008-R2), SSIS (2008-R2), SVN Subversion

Crystal Reports Developer

Confidential, Golden Valley, Minnesota

Responsibilities:

• Created customized customer service phone call reports using Crystal Reports, XML, Informix, and the Cisco Unified CCX Historical Reporting tool.

Environment: Crystal Reports, XML, Informix, Cisco Unified CCX Historical Reports Client

System Engineer / SQL Server / SSRS-SSIS Developer

Confidential, Minneapolis, Minnesota

Responsibilities:

• Working for their Wholesale International Services division, created a number of reports within SSRS related to Standby Letters of Credit.
• Within Oracle (PL/SQL), created a number of very complex stored procedures for retrieving data that drive the reports.
• Using the SSRS Reporting Services Intranet Web interface, managed a great number of report Parameters, Data Sources, and Security Roles.
• Utilized the Toad (10.6) application to help create, test, and manage a number of queries and stored procedures for the reports.
• Managed requirements and QA Defects using the HP Quality Center (10.0) application.
• Utilizing SQL Server and SSRS/SSIS, created complex home loan financial reports taking advantage of the tool’s drill-down features to view detail loan information, as well as bar, line and pie charts.
• Created complex SQL Stored Procedures

Environment: SQL Server 2008/2005, SSRS 2008/2005, SSIS 2008/2005, Subversion (SVN), Oracle 11g, Toad 10.6, HP Quality Center 10.0 Industry: Banking, Finance, Mortgage

SQL Server / Oracle / SSIS Developer

Confidential, Paul, Minnesota

Responsibilities:

• Installed and configured an SSIS data migration solution to move and scrub data from their transactional Oracle database, into a data warehouse located on SQL Server 2008 that is used for a custom written in-house reporting solution.

Environment: SQL Server 2008, Oracle 11g, SSIS 2008, SQL Developer Industry: Medical

SQL Server / Visual FoxPro Developer

Confidential,Paul, Minnesota

Responsibilities:

• Using SSRS and joining a number of tables, created many complex reports that are used by management and general users of the system.
• Created and deployed a number of SSIS ETL packages to migrate Visual FoxPro databases into SQL Server 2008. The packages included many data scrubbing/cleansing routines in order to format the data properly.
• Worked on many modifications and new development to their OTIS and RTS systems. These systems track juveniles entered into one of the two detention centers within Ramsey County, Minnesota. Both of these systems are written in Visual FoxPro 9.0 and the backend databases are SQL Server 2008/2005.
• Implemented, administered, and trained employees the proper procedures to migrate the programming code into the source control product Visual SourceSafe (VSS).
• Developed a process within the OTIS application to track and sort offenses committed by the juveniles by severity when being viewed by the officer on the screen or within the many complex reports.

Environment: SQL Server 2008/2005, SSIS, SSRS, Visual FoxPro 9.0, Visual SourceSafe (VSS)

Software Developer

Confidential, Burnsville, Minnesota

Responsibilities:

• Within the internally written FoxPro 9.0 BoRAS application, created a number of Key Performance Indicator (KPI) reports to track customer service’s performance.
• Developed many programs and functions used for calculating holidays and non-working days within the reports for work locations throughout the world.
• Worked closely with other programmers and managers in The Netherlands.
• Trained other programmers a number of techniques to write queries to increase system performance within the database in turn increasing productivity.

Environment: Visual FoxPro 9.0, Crystal Reports 11

SQL Server / Visual FoxPro Developer

Confidential, Baton Rouge, Louisiana

Responsibilities:

• Utilizing SQL Server 2005 and Visual FoxPro 8.0, designed, programmed, unit tested and documented the entire.
• Import/Export application. This application consisted of uploading and downloading sensitive patient data to a third party vendor using the secured WINHTTP Windows object for posting. Patient data and any instruction orders would then be sent to/from a cell phone where nurses or home health aides could use to administer any treatments required at the patient’s home, and report vitals and other pertinent information back to the company.
• Initially Visual SourceSafe (VSS) was used as the source control product, but was changed over to Team Foundation Server (TFS).
• Fixed a number of defects within their custom application and SQL Server stored procedures, functions, and queries.
• Created a number of SQL Server stored procedures and functions in different schemas utilizing T-SQL syntax and joining a number of large (terabyte) tables making sure queries were structured properly for greatest system performance.
• Made a number of changes and additions to the in-house home health care application reporting imperative OASIS-C and OASIS-C corrections information to the federal government.

Environment: SQL Server 2005, Visual FoxPro 8.0, Team Foundation Server (TFS), Visual SourceSafe (VSS), Crystal Reports 11 Industry: Health Care

SQL Server / Visual FoxPro Developer

Confidential, Louis Park, Minnesota

Responsibilities:

• Performed maintenance programming within the dispatchOffice™ custom software application. This logistics application is mainly purchased and used by delivery companies across North America to track deliveries for nationally known third party customers. The application is written in Visual FoxPro 9.0, with a SQL Server 2005 backend.
• Created a number of SQL Server SSIS packages for importing and exporting data, as well others that setup and backed up SQL Server databases.
• Parsed many XML, SDF and CSV files utilizing Microsoft’s XML Parser (XML DOM).
• Performed many migrations of data from the test SQL Server database into production using SSIS. Created a number of stored procedures utilizing Linked Servers to complete this assignment.
• Utilized the product SourceOffSite to connect remotely to the Microsoft SourceSafe source control database.

Environment: SQL Server 2005, Visual FoxPro 9.0, SourceOffSite

Visual FoxPro Developer

Confidential, Wayzata, Minnesota

Responsibilities:

• Worked within the Remedy tracking system to identify and fix the defects logged for the Meal Loadout application written in Visual FoxPro 6.0. This application tracks the trucks and railroad cars’ payload of grain and soybeans into the unloading stations located across North America. This system also bills the trucking and railroad companies. The defects would be identified, debugged, and fixed. A new version of the application would be recompiled and then placed onto the WAN.
• Created a number of tools within Visual FoxPro to track data performance across the network.
• Completed all required tasks in one-half the time estimated by management.
• Worked with a team of six other programmers developing their VOX ordering, logistics, & tracking application. This application, written in Visual FoxPro 8.0, tracks orders and inventory, for truckloads of grain to feed their cattle, ordered by farmers across the USA. This application utilized RFID readers at each loading facility to read the tags of the specific trucks ready for loading. This application also transmitted data back and forth from the application to the semi-truck driver. This is utilized by using a PDA with cellular and satellite communications.

Environment: Visual FoxPro 6.0 Industry: Logistics, Agriculture

SQL Server / Visual FoxPro Developer

Confidential, Minneapolis, Minnesota

Responsibilities:

• Worked on converting many programs, forms, reports and databases from Visual FoxPro 9 into SQL Server. Utilized SSIS, stored procedures, and SQL pass-through technology to accomplish this. Wrote a number of SQL Server stored procedures.
• Finished assignment ahead of schedule and under budget.

Environment: SQL Server 2005, Visual FoxPro 9.0 Industry: Internet Publishing, Legal, Publishing

Visual FoxPro Developer

Confidential, Eagan, Minnesota

Responsibilities:

• Developed a large portion of their Long Term Care application that created annual renewal letters for the subscribers. This object oriented application was developed using Visual FoxPro 8.0 and utilized Office Automation to create the letters via Microsoft Word as well as Adobe Distiller & Acrobat in order to save the letters to a PDF file.
• Visual SourceSafe Build Master. Was responsible for making weekly production builds and the more frequent test builds for all of the FoxPro projects. Was in charge of keeping the production and test code organized.
• Was responsible for new development and maintenance programming of the company’s SelectAccount application. This application tracks the client’s records for their Health Savings Account (HSA) and Flexible Savings Account (FSA). The system was written in Visual FoxPro 8.0 and FoxPro 2.6 for Windows.
• Helped out management with the other programmers as the team lead and mentor, assigning them work and performing source code review.
• Developed a number of programs that connected to and queried Oracle databases in order to update Visual FoxPro tables.

Environment: SQL Server 2005, Oracle, Visual FoxPro 8.0, Microsoft Word, Adobe Distiller & Acrobat, Visual SourceSafe, FoxPro 2.6 Industry: Health Care

Visual FoxPro Developer

Confidential, Portland, Oregon

Responsibilities:

• Valuable member of a 12-person team whose primary goal was to convert an existing legacy FoxPro 2.6 (XBase) application into an object oriented Visual FoxPro 8.0 application.
• This application is used at every PETCO nationwide to track customer’s visits with their pets into the pet hospital. The application consisted of more than 800 programs, 400 forms and 200 reports that were converted. The source code was maintained utilizing Visual SourceSafe.

Environment: Visual FoxPro 8.0, FoxPro 2.6, Visual SourceSafe, Crystal Reports 9 Industry: Health Care

Senior Programmer Analyst

Confidential, Golden Valley, Minnesota

Responsibilities:

• Developed many multi-user applications for the collections law firm using Visual FoxPro 6.0/7.0, SQL Server 2000, and Crystal Reports 9.
• Completely responsible for converting the existing data from Commercial Legal Software (CLS) into the FACS collections software created by Ontario Systems.
• Setup many file & record formats using the Enable product within FACS. Also was proficient in creating Event Tactics and Logic Blocks.

Environment: SQL Server 2000, Visual FoxPro 6.0/7.0, Crystal Reports 8.5/9, FACS, Ontario Systems

Senior Programmer Analyst

Confidential, Minnesota

Responsibilities:

• Day to day maintenance programming using Visual FoxPro 6.0.
• Create complex reports using Crystal Reports 8.5.

Environment: Visual FoxPro 6.0, Crystal Reports 8.5 Industry: Confidential

Visual FoxPro Developer

Confidential, Burnsville, Minnesota

Responsibilities:

• Responsible for both new development and maintenance of a financial factoring application written in Visual FoxPro 7.0.

Environment: Visual FoxPro 7.0

Visual FoxPro Developer

Confidential, Paul, Minnesota

Responsibilities:

• Responsible for the conversion of a taxpayer viewing system from FoxPro for DOS (XBase) into Visual FoxPro 6.0. This was a VERY high profile project in that the application is used by over 350 users throughout the country at one time via a WAN.
• The application would allow the user to search for a Confidentia by name or confidential, and then display a list of all years and tax forms filed for that taxpayer within the previous seven years.
• Once the user chose a tax form to view, the actual tax form, saved as an image (JPG), would be displayed on the screen. The data that the taxpayer filled in on their original return would then be placed on the image in the proper area.

Environment: Visual FoxPro 6.0, FoxPro for DOS, Data Encryption Industry: Accounting, Government, Taxes

Visual FoxPro Developer

Confidential, Birmingham, Alabama

Responsibilities:

• Responsible for new development, maintenance and reporting of a utilities tracking and billing application written in Visual FoxPro 5.0.

Environment: Visual FoxPro 5.0, Crystal Reports 7.0

Crystal Reports/Seagate Info Developer

Confidential, Bloomington, Minnesota

Responsibilities:

• Developed numerous complex reports using Crystal Reports 7.0. In addition to creating reports, was also the administrator to the entire Seagate Info 7.0 application used to view these reports over the Web.
• Duties included creating groups & users, determining and issuing the appropriate rights for them, and developing events to ensure the current data is appended into the database for accurate reporting.

Environment: Crystal Reports 7.0, Access, Seagate Info 7.0 Industry: Transportation, Logistics, Software

C rystal Reports Developer

Confidential, Minnesota

Responsibilities:

• Developed and modified a number of sales reports using Crystal Reports 7.0 within the Pivotal CRM application. The database used was SQL Server 7.0.

Environment: Crystal Reports 7.0, SQL Server 7.0, Pivotal

FoxPro Developer

Confidential, Eden Prairie, Minnesota

Responsibilities:

• Was responsible for rewriting 75% of an existing order/inventory system, using FoxPro 2.6. This system allowed the user to track an order from entering it into the system, all the way down to the shipment of the order. The system also tracked backorders, and created exception reports for inventory levels below the minimum quantity on hand.
• Many other reports were developed to track sales and inventory information using both FoxPro’s report writer, and Crystal Reports 6.0/7.0.

Environment: Crystal Reports 6.0/7.0, FoxPro 2.6

Senior Programmer Analyst

Confidential, Minnesota

Responsibilities:

• Created many applications that allow their out-of-state users to enter, edit and view data via the Internet using both FoxPro 2.6 for DOS, and Visual FoxPro 5.0. Created a few applications written in FoxPro 2.6 for Windows that tracked trade shows visitor information. These applications allowed the users to enter name, address and demographic information for nametags and future mailings.
• Day to day maintenance programming. Created complex reports using Crystal Reports 8.5.

Environment: Visual FoxPro 6.0, Crystal Reports 8.5

Visual FoxPro Developer

Confidential, Minnesota

Responsibilities:

• Helped with the conversion of a logistical Freight Analysis System from FoxPro for DOS (XBase) into an object oriented Visual FoxPro 5.0 application.

Environment: Crystal Reports 6.0/7.0, FoxPro 2.6

SQL Server / Visual FoxPro Developer

Confidential, Burnsville, Minnesota

Responsibilities:

• Designed, programmed, tested and implemented an entire reporting system for the accounting department of a large manufacturing plant using FoxPro for Windows.
• Retrieved the data from their SBT Accounting software databases using FoxPro's SQL language.
• Created customer order forms using Visual FoxPro 5.0.

Environment: FoxPro 2.6, SBT Accounting

FoxPro Developer

Confidential, Minnesota

Responsibilities:

• Designed, programmed, tested and implemented a Produce Logistics System. The system is designed to allow the user to order produce from farmers, and track the orders all the way into the company’s distribution center.
• This system also generated billings, and adjusted the inventory files. This system was placed into 12 distribution centers located across the country, connected by a wide area network. This system is written in FoxPro 2.6 for Windows.

Environment: FoxPro 2.6

FoxPro Developer

Confidential, Eden Prairie, Minnesota

Responsibilities:

• Designed, programmed and tested programs for a hearing aid system designed for audiologist offices. All of these programs are written in FoxPro 2.6 for Windows. Environment: FoxPro 2.6

Senior PC Programmer/Analyst

Confidential, Bloomington, Minnesota

Responsibilities:

• Developed, tested, implemented, and maintained customer service telephone usage tracking system in FoxPro for DOS, Windows, Novell network environment.
• Designed, programmed, installed, maintained, and documented employee insurance indemnity coverage tracking system in FoxPro for DOS, Windows, Novell network environment.
• Designed, programmed, tested, installed, and maintained corporate insurance claims tracking system with fax interface in FoxPro for DOS, Windows, and Novell network environment.
• Maintained and supported FoxPro and dBase IV databases and word-processing, spreadsheet, and graphics software in DOS, Windows, and Novell network environment.

Environment: FoxPro, dBase IV

Clipper/dBase IV Programmer

Confidential, Bloomington, Minnesota

Responsibilities:

• Conversion of an XBase Clipper application into dBase IV.

Environment: Clipper, dBase IV

PC Programmer/Analyst

Confidential, Edina, Minnesota

Responsibilities:

• Developed, tested, and maintained interface allowing users to access and print customer reports stored on laser discs in dBASE IV, DOS, and Novell network environment.
• Designed, programmed, installed, maintained, and documented customer report tracking system with upload/download interface in dBASE IV, DOS, Novell network environment.
• Maintained ad hoc traveler reporting system in dBASE IV, Novell network environment.
• Maintained and supported FoxPro, dBASE IV, and Paradox databases and word processing, spreadsheet, and graphics software in Windows, DOS, and Novell network environment.

Environment: FoxPro, dBASE IV, Reporting Industry: Business Travel