Skills SUMMARY      

Programmer of Client Server Applications, and Business Systems/ Reporting Analyst who specializes in requirements gathering, data modeling, and Relational Database Management System design and development.
Working with end users to develop solutions, and improve production, and process flow. John has a passion for data integrity, process efficiency, and solution development.

TECHNICAL SUMMARY        

Applications: MS Office Suite, Visio 2003, MS Project, Crystal Reports 7.0, TOAD, ERwin, Lotus Notes, Visual Workbench.

Tools: Cognos Reports/Impromptu, Excel Pivot Tables v 5 – 2007.

Languages: Visual Basic 6.0, VBA, VB.NET, SQL, DTS, ODBC, ADO.

Databases: MS Access v 2.0, 97, 2002, 2003, 2007, SQL Server v 2000, Oracle 9i

Operating Systems: Win XP Pro 2003, Windows 7.

EXPERIENCE      

Nike WHQ, Sr. Data Analyst/ Consultant  (5/01/2011 – 5/31/2011)

·        Provide Advanced Excel, analytical skills, process mapping skills.

·        Identifying current data sources for metrics that will be measured in the Index and documenting process for each of the metrics identified.

·        Create an Excel or "Beta" version to track each of the metrics and calculate an overall score.

·        Create MS Access Relational Database application for Index maintenance and reporting.

·        Upload data into current Excel/Pilot version of the Indexes and make updates/ modifications as necessary.

·        Environment: Excel 2007, MS Access 2007


Providence Health Care (5/10–5/10)
Sr. Programmer Analyst/ Consultant        

·     Special project to build new reports, and create new functionality to facilitate import and export of Excel data using an existing MS Access 2007 application.

·        Environment: Access 2007

Intel (7/09–8/09)
Analyst/Consultant 

·        Short term contract to conduct analysis of business model, and maintenance analysis of existing Microsoft Access 2007 application for the purpose of improving on the design of data retrieval functions/ processes. Implemented source code modifications to optimize and improve performance of data retrieval and overall report generation.

Environment: Access 2007

 

PacifiCorp (9/08–7/09)
Transmission, Business Analyst/Report Developer/Consultant  

·        Requirements gathering and creation of Transmission Finance reports to show Megawatt Hours and related costs using Excel.

·        Created Cognos Reports using Impromptu. Utilized Toad to analyze Oracle data proprietary to Transmission Schedules by creating SQL queries.

·        Utilized Cognos-Impromptu, Visual Studio, VB.NET, and Visual Basic 6 for PacifiCorp’s Intranet Site’s Reporting tools to create Excel and HTML output files. Data was extracted from Oracle Databases. Created Excel Pivot table reports, detail drill down reports, and summary reports.

·        Performed trouble shooting-analysis to determine transmission variations in hourly electricity production and path of energy delivery.

·        Used Visual Basic 6, Excel-VBA: implemented code fixes, and provided new development to improve on legacy code. Changes reduced process time for comprehensive Calculations by as much as twelve minutes (formulas execute on very large amounts of data). Automated tasks otherwise performed manually.

·        Provided enhancements to existing Microsoft Access 2003 application to implement complex search engine ability for tracking transmission-meters and their customer-owners. This included data modeling, and adding new tables to the database while maintaining third normal form.

·        Created and implemented comprehensive Invoices containing summary reports, and data available from several sources to show transmission information for all pertinent customer accounts and cost sheet data.

Environment: Cognos Reports Impromptu, Excel Pivot tables, VBA, HTML, Visual Studio, VB.NET, Visual Basic 6, Access 2003, Oracle, SQL.

 

Regence-Blue Cross (10/07–8/28)
Senior BSA/Report Analyst/Consultant 

·        Gathered requirements and learned business rules in support of EPMO Project Management reporting, and Governance department.

·        Generated Microsoft Project Data and Clarity Data results comprising estimated project hours compared to actual hours. Performed queries in the Oracle 9i database to obtain Clarity Time Reporting of Actuals data.

·        Created Excel 2003 templates then updated and formatted the data output from Access 2003. Reporting was implemented from Access 2003 modules executing several functions/sub routines to create output to Excel 2003 template files.

·        Designed and developed a new database application that interfaces with Lotus Notes via a special tool called Visual Workbench, which was used to export Lotus Notes data imported into the Access application. The Access 2003 interfaces were comprised of Data Entry screens and extensive/ complex reporting.

Environment: Visual Basic 6, Excel 2003, VBA, MS Project, Clarity, Visual Workbench, Lotus Notes, SQL, Access 2003, Oracle 9i, Win XP Pro 2003

 

Schnitzer Steel (1/07–7/07)
Business Systems Analyst/Report Developer/Consultant             

·        Gathered and managed requirements, created and generated reports based on System Development Life Cycle process.

·        Designed, developed, and implemented new Accounting system to track Sales and Purchases of Recycled Metals. System provided both the New York office and Portland office the ability to capture and store the sales and purchase data in a relational database model.

·        Reporting provided users the ability to have the same data seen in a report output to an Excel 2003 Spreadsheet with automated formatting.

Environment: Windows XP Pro 2003; Access, Excel 2003, Word 2003 and Visio 2003.

 

Nike World Headquarters for Kelly Services (10/05–1/07)
Business Systems Analyst Report Developer, WHQ-Subsidiary IT Support Division

Contractor at Nike:

·        Gathered and managed requirements, created and generated reports, conducted System Development Life Cycle process. Designed, developed, and implemented new Sales Order system for Exeter Brand, a Nike subsidiary (Visual Basic 6, VBA, SQL Server 2000). The Sales Order System automated the process of constructing sales orders from Wal-Mart purchase orders provided to Exeter in Microsoft Word, RTF file format. Proposed system must parse and extract pertinent data contained in Wal-Mart purchase order document (Word RTF file) required to complete construction of an Exeter sales order as follows:

·        Data extraction using stored procedures and ADO technology invoked from an Access 2003 front-end interface. The Sales Order System was a fully automated Sales Order constructor-application comprising a parsing engine built using Visual Basic 6, VBA, ADO, and ODBC with a SQL Server 2000 backend-database.

·        Executed process to automate the uploading of all available purchase order documents using a file sniffer routine to locate available purchase order files. Executed parsing procedures to extract proprietary data from the purchase order, and persisted the data to a SQL Server 2000 database. The stored data was maintained in a normalized relational database model.

Environment: Visual Basic 6, Converse supported server, DTS, SQL Server 2000, Access 2003, ODBC, ADO, VBA, Excel 2003.

 

Senior Analyst/Consultant, Nike Golf Operations Department

Designed, developed, and implemented a relational database management system to track sales, and purchases of Logo Golf Balls. The Vendor Work Order interface will capture product orders, and output in XML format viewable in an IE Web browser.

Environment/ Database application: Windows XP; XML, Microsoft Access 2003.

U.S. Department of Agriculture’s Forestry Service (7/04–11/04)
Senior Developer/Consultant    

·        Gathered and managed requirements (prioritize, and modularized all components of proposed system). Designed, coded and implemented all functions, interfaces and test/ deployment of builds throughout life of project.

·        Performed data modeling to construct physical and logical models. Used SQL to provide applicable data manipulation and data extraction/ migration.

·        Constructed turn-key interface to perform: manipulation of raw data, error logging, and error reporting, executed statistical calculations to create summary data. Conducted QA testing of each new build, conducted user testing, and deployed final build into production.

Environment: Windows XP Professional, Microsoft Access 2002.

 

Lockheed Martin (10/03–2/04)
Report Developer/Consultant   

·        Supported LMCO employees and Nike personnel by providing maintenance of all Service Requests submitted to LMCO.

·        Generated reports distributed to a special Review Committee that evaluates each Service Request to determine work load and categorization.

·        Assigned Service Requests to specific teams responsible for supporting a variety of customers needs. Maintained all documentation proprietary to a Service Request such as a Document of Understanding, which was an overview of the project or work to be done, and status of the work flow, and hourly estimates.

·        Implemented SQL’s as underlying data source for statistical reporting results, which were included in weekly automated E-Mail management notification messages. Implemented search engine technology and functionality as part of automation tool.

Environment: Excel Pivot Tables, VBA, Visual Basic, SQL, Access 2002, Win XP Professional.

 

Bonneville Power Administration (3/02–11/02)
Reporting Analyst/Consultant   

·        Supported PBL-InfoFactory Data Warehouse Team in development and implementation of Source Staging Database project.

·        Supported and participated in developing Source Staging database data model. Supported Business Analysts by doing research and fact-finding of information proprietary to Load Forecast information.

·        Data Analysis: Map East & West Hub revenue forecasting algorithms to Load Forecast-data. Performed Proof of Concept as part of moving data model into staging phase of development and implementation.

·        Designed and developed Revenue Forecast System that generated revenue forecast reports based on forecasted energy and power obligation provided to BPA customers. Tasks included robust test and deployment procedures comprising test plans derived from methodology utilized by Data Warehousing team.

Environment: ERwin, PowerPoint, DTS, SQL Server 2000, Access 2000, Oracle 8i.

 

Northwest Evaluation (12/00–5/01)
IT Lead/Application Developer/Consultant

·        Developed client server applications using Access 2000, Visual Basic 6.0, ADO 2.6 and SQL Server 7.0 technology. Supported a large-scale client server application, Measures of Academic Performance Development System, used to create and package tests implemented by school districts to meet critical education goals determined by the district.

·        As Application Development Lead, oversaw technical documentation requirements such as support documents, project plans and user guides. Tasks included development and execution of test plans. Provided technical mentoring to junior level personnel.

Environment: Win NT 4.0 with SP 6A installed, or Windows 2000 with SP1 installed, Visual Basic 6.0, Access 97, DTS, SQL Server 7.0, ADO 2.6, ODBC, Excel 97, Word 97, Crystal Reports 7.0, Paradox 7.

 

Teldata Solutions, Inc. (8/00–11/00)
 Sr. Programmer/ Analyst/Consultant

Designed, developed and implemented FTP application written in Visual Basic 6.0, Win 32 API. Supported and implemented modifications and enhancements to existing application, which included upsizing application from Visual Basic 5.0 to Visual Basic 6.0. Application tracked data representing information provided by customer’s metering devices that monitor the use of power and energy. Maintained and modified an existing web application’s Active Server Pages. Tasks included developing and executing test plans to ensure integrity of deployed deliverables.

Environment: Win NT 4.0, Win 32 API, ADO 2.5, Visual Basic 5.0 and 6.0, Oracle, Toad (analysis tool), ODBC, ASP, VBScript, HTML, Internet Explorer 4.0.

Cotelligent Technology Solutions Group (8/99–8/00)
 Sr. Consultant

·        Provided support to clients deploying applications written in Visual Basic 5.0 and 6.0, Access 97, SQL Server 6.5 and 7.0. Provided technical documentation (estimates, project plans, and support documentation). Supported and provided reverse engineering for existing intranet application for Alcatel. Responsibilities included debugging Active Server Page script and stored procedure calls, redirects, and to add source code commentary to explain purpose of ASP and scripts. Supported Freightliner Corporation’s Marketing Analysis Data System Application. Focus of my responsibilities was to enhance reporting and to trouble shoot existing reports.

·        Created client server RDMS application to track and report on products brokered. Focus was on data analysis and product availability, trends and sales promotions.

·        DTS packages created in SQL Server 7.0 played a role in importing downloaded data supplied by Western Family Foods.

·        Created user guide and support documentation for applications I developed or supported. Tasks included providing Use Case Scenarios as part of a Testing, and Q & A process.

Environment: Win NT 4.0, Visual Basic 5.0 and 6.0, ADO 2.5, ODBC, Win 32 API, Excel 97, Access 97, Word 97, DTS, SQL Server 6.5 and 7.0, Crystal Reports 7.0.

Alaska Communications Systems, Inc. (2/99–8/99­)
Sr. Programmer/Tech Lead/Consultant

Provided support for Platinum SQL Visual Forms Designer and SQL Server 7.0 data propagation. Designed, developed data migration application used to import General Ledger data into SQL Server database.

Environment: SQL Server, DTS, Platinum SQL Software, Visual Basic 6.0, ADO 2.5, ODBC, Excel 97, Access 97, and Win NT 4.0.

Emery Worldwide (Global Airfreight) (12/98–2/99)
Sr. Programmer/Analyst/Consultant      

Supported and provided reports using Data Dynamic’s Active Reports for Shipping application. Implemented reports using ActiveReports required developing separate Class files for each of the reports in addition to a Visual Basic 5.0 interface. ADO was used for data access running SQL commands.

Environment: Windows 95/WinNT; ActiveReports, Visual Basic 5.0, existing Visual C++ objects, Access 97, ADO objects.

PCC Structurals, Inc. (11/97–2/98)
Sr. Programmer/Analyst              

Designed, developed and implemented Employee Performance Rating System. This application utilizes multiple servers to propagate data for 3 manufacturing plants and all supervisors. The focus of the application is to provide the ability to select criteria upon which to base a report comprising data about each employee, the employee’s department as a group and standards by which each is to be compared for performance ratings. Excel-VBA was extensively used for report analysis and graphical analysis.

Environment: Windows 3.1.1, Windows 95, Windows 98, Visual Basic 4.0, Crystal Reports 6.0, Excel 5.0, Access 2.0, ODBC, DAO technology (Access engine), Windows NT 4.0 server software.

Columbia Sportswear Co. (10/96–11/97)
Sr. Programmer/Analyst              

Maintained and supported all SQL required to create or merge product information data from Informix database tables into Access databases.

Environment: Win NT 3.5 and 4.0, Access 2.0, Informix, Visual Basic 4.0, ODBC, Word, Excel, Sheridan ActiveX/ Custom Controls.

Bonneville Power Administration (11/95–10/96)
Programmer/Analyst

·        Created and implemented Sale of Power and Energy System to track hourly sales. This application was written with Visual Basic and VBA for formatting and summarizing data on each spreadsheet reports.

·        Designed, developed and implemented Excel (VBA code) applications to produce reports pertinent to energy analysis. Focus of these reports provided ability to track river flow and levels effecting power plants.

Environment: Windows 3.1.1, Access 2.0, Excel 5.0, Sybase Databases, ODBC, Excel 5.0, Visual Basic, VBA.

EDUCATION       

B.S., Computer Science, McKendree University, Lebanon, Illinois.