Peter J Smith

TECHNICAL OVERVIEW:

I have ** years of programming experience with a wide range of systems and responsibilities. My current position I am building a web site using open source tools, data management, business reporting , setting up Debian servers , maintain window servers and work with the AS400/Iseries. I am involved in rebuilding the infrastructure as well as maintaining the old systems. This has been bit out of the normal for me but a very good learning experience.. Before this I spent 5 years in a Microsoft .Net environment. My duties as a Business Intelligence Consultant include Reporting Services and SSIS in SQL Server 2005/2008 environments. In my role as a consultant I am an integral part of the Business Intelligence team that is responsible for assisting the customer in gaining access to data from different sources into one centralized reporting database. I used SSIS to integrate C# with TSQL and ETL proccess to create lights out data movement and well as checks and balances. Along with that data models supported the adhoc reports the client wanted. In some cases we loaded cubes that were attached to Excel reports. I have created technical documentation for the BI software package-BI Express and also tested and made recommendations for the BI team. One of my main responsibilities is technical demonstrations of the software product (BI Express) to potential customers. I support and code stored procedures in DB2 on an ISeries along with writing programs in CL and RPG. Past projects have included MAPICS, COGNOS and Pervasive SQL systems. My responsibilities included an e_commerce web site. We used VB. Net, C#, ADO. Net, ASP. Net, HTML and JAVA script. It was designed as an N-Tier application and code was Object Oriented. The use of classes and interfaces allowed for faster changes and easier coding. The use of classes especially helped when we moved the code from Oracle database to SQL2005. We used the Microsoft Enterprise libraries for logging and error handling. I also maintained 3rd party software and web components. For managing data bases we used Toad for SQL. This included maintaining licenses, budgeting and reviewing new technology. I was responsible for customer support, after hour help desk, sales reporting and maintaining Microsoft servers.

TECHNICAL SKILLS:

• Frameworks: .Net , Django , Satchmo

• Software : Microsoft Studio 2005, Component Art, Data Gate, SCORE ,Sequel, Toad

• Languages : VB. Net, ASP. Net, ADO. Net, COBOL ,CL RPG , C# , Python

• Databases: SQL Server 2005 Oracle DB400 SQL Server 2008 ,Postgres

• Hardware HP Blade Server, ISeries, Windows Server 2003 , XP ,Debian ,Ubuntu

• Applications: E_commerce web site, order cart, sales reporting, pricing system, purchase order system, transportation, EDI, PGAdminIII , SEO tools ,Sterling EDI, Trans Gen

PROFESSIONAL EXPERIENCE:

July 2009-Present MidAmerica Motorworks, Inc.

Effingham, IL

Web Manager/Data Manager

• Build a new web site using Open Source tools Django and Postgres

• Create RPGLE and CL extract programs to cleanse bad data from the AS400.

• Train employees on how to use the new systems

• Create jobs to maintain data on the DB2 and Postgres databases from the web site using automated scripts.

• Maintain server hardware; this includes making old servers work with the new virtual servers.

• Maintain virtual machines on Vmware and build a back up strategy

• Sit down with users and find areas in the current system to automate to improve efficiency in processes

• Maintain DNS entries on old and new servers to handle the switch from an old 192 system to a new 10. system.

• Created Stored Procedures on an Iseries to help in the transfer of data to and from the new web site

• Create and deploy SQL Server2008 SSIS code to help handled flow of information on systems that utilize SQL Server

March 2009-July 2009 Self-Employed

Ashland, IL

TECHNICAL CONSULTANT

• Created Transportation Reports

• Fixed RPG code Errors

• Day to day programming in COBOL and CL.

April 2008-March 2009 Advanced System Designs, Inc.

Morton, IL

BUSINESS INTELLIGENCE CONSULTANT

• Created SQL 2005 Reports using Reporting Services by creating data models and using reporting services to build ad hoc reports. Also used C# to monitor the etl processes. This also included working with cubes and KPI,s by loading the cube and maintaining existing dashboards.

• Create CL programs with embedded SQL code that was used in the administration of etl process that check the row count from DB2 to SQL

• Created Stored Procedures on an Iseries that communicated with the SQL database.

• Create and deploy SQL Server2005 SSIS code to production servers and other test servers .

• Completed Training for SQL Server 2005 Business Intelligence

• Developed Report Models for scheduled reports

• Studied Cubes and Data Mining

• Implemented bug fixes on both ISeries and SQL Server

• Used Subversion for Source control

• Used VMware to create virtual systems for running testing on software that we created. We could use virtual servers to rerun different test scripts or data over and over.

February 2008-April 2008 Self-Employed

Ashland, IL

TECHNICAL CONSULTANT

• Created Transportation Reports

• Fixed RPG code Errors

• Day to day programming in COBOL and CL.

July 1999-January 2008 DOT Foods, Inc.

Mt. Sterling, IL

PROGRAMMER/ANALYST (1999-2004)

E-COMMERCE DEVELOPER (2004-2008)

• Developed and maintain VB.Net code including order cart, sales reporting and search engine. We needed to emulate the systems running on an AS400

• Used Component Art to create Ajax controls

• Integrated with SQL Server 2005 including nightly updates from ISeries to maintain data integrity between the two systems

• Maintain ADO.Net and Create T-SQL functions to help manage the multi tier system on the .Net web site

• Used Toad to examine sql procedures and testing.

• Developed and maintain HTML to conform with company color standards

• Create reports in XML and CSV formats and route through Email from the AS400 using Esend from HelpSystems

• Integrate EDI with the current web site to allow both to do similar functions

• Primary technical support for Purchasing Department including creating a backorder system that utilized the order system as well as the logistic system

• Secondary technical support for Pricing, Marketing, and Sales

• Day to day programming in COBOL and CL.

• Occasional programming in RPGIV and SQL

• Responsible for maintaining NONSTOP Solutions Demand Network Suite ®

• Worked with TMW transportation software interfaces

• Help with ISeries and window upgrades

March 1998-July 1999 UW Madison DOIT Center

Madison WI

PROGRAMMER

• Primary Y2K conversion in COBOL and SAS

• Created interfaces between MVS 390 and Unix servers

• Programmed in PL SQL, COBOL, JCL, and SAS

• Worked with PeopleSoft Student modules

• Worked on the University’s helpdesk for 6 months

September 1992-March 1998 City of Madison Health Department

Madison WI

LAB AIDE

• Data entry in Paradox and Quattro Pro databases

• Collected laboratory specimens

• Supported household hazardous waste

EDUCATION:

Madison Area Technical College

Program: Midrange Programmer/Analyst

Dec 1996- May 1999

University of Wisconsin Madison

Program: Dairy Science

Aug 1983- May 1987

Reference Available upon Request

Contact this candidate