http://www.johndi.com mrstyxjdm@gmail.com 360.737.1796
John J. DiMartino
Senior Programmer/ Developer/ Reporting Analyst
Seasoned consultant with experience in Information Technology. Provided logical and physical data models for Oracle (8i, 9i, 10) and SQL Server 2000 databases. Provided DTS packages to import/ load data from external sources.
Optimized existing source code by analyzing and correcting existing issues. Using SQL queries and other analysis tools, I have successfully researched and corrected data anomalies. Provided Technical Support documentation specifications based on System Development Life Cycle documents for new functionality/ revisions.
PROFESSIONAL EXPERIENCE - Information Technology
Intel; Hillsboro, OR Jul, 2009 - Sep, 2009
MS Access Programmer/ Analyst/ Developer
* Performed analysis of existing Microsoft Access 2007 application for the purpose of improving on the design of data retrieval functions/ processes.
* Implemented source code modifications and enhancements to optimize performance of data retrieval, and to improve performance of report generation.
Pacificorp – Transmission Finance; Portland, OR Sep, 2008 – Jul, 2009
Transmission Finance Analyst & Programmer Analyst
* Generate Transmission Finance reports in Excel to show Megawatt Hours and related costs.
* Create COGNOS reports using Impromptu.
* Utilize Toad to analyze Oracle data proprietary to Transmission Schedules by creating queries, or to validate existing queries, and their result sets.
* Utilize several applications such as COGNOS-Impromptu, Visual Studio-Visual Basic.Net, and Pacificorp’s Intranet Site’s Reporting tools to create Excel and HTML output files. Data is extracted from Oracle Databases.
* Create Pivot table reports, detail drill down reports, and summary reports
* Perform trouble shooting-analysis to determine transmission variations in hourly electricity production, path of energy delivery, and if loss of scheduled transmission of energy may vary from what was to be provided in the original schedule.
* Using 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). Also 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.
* Create and implement comprehensive Invoices containing summary reports, and data available from several sources to show transmission information for all pertinent customer accounts and cost sheet data.
Regence-Blue Cross; Portland, OR Oct, 2007 – Aug, 2008
Programmer/ Reporting Analyst – PSO Reporting Team
* From Access front end, generated Excel Pivot Table type reports comprised of Microsoft Project Data and Clarity (Oracle) Data showing Project Schedule Performance Index and Cost Performance Index analysis. As part of the reporting process, I designed and executed queries to access Oracle 9i database to obtain Clarity resource Time Reporting of Actual hours spent on a project’s tasks.
* Performed Import processing, which executes from Microsoft Access 2003 front end application to import Microsoft Project data using a methodology to accurately capture hourly time reporting on a daily basis.
* Created Excel 2003 templates that are updated from Access front end. The resulting output is then reformatted and customized for applicable reports. All of the processing was handled within the Access front end via VBA code, and manipulation of Excel objects.
* My responsibilities included automating various Excel 2003/VBA template routines to eliminate hours of manual formatting effort.
* I also designed and developed a new relational database tracking system Access 2003 that interfaces with Lotus Notes via a special tool called Visual Workbench, which is used to export Lotus Notes database data that is persisted to the Access database. The Access interfaces were comprised of Data Entry screens and extensive/ complex reports. The reports were built using numerous queries that contain several formula based calculations to create the required output. The reports are output to Excel 2003 spread sheets.
* In addition, improved on existing source code executing in several legacy routines/ functions within the main Access 2003 reporting tool.
* Assisted with data migration and source code migration of the aforementioned applications/ databases to Oracle 9i, and Business Objects. Tasks include logical and physical data modeling, writing stored procedures, designing Universe classes and subordinate classes; business objects, and writing technical support documentation.
* Environment: Excel 2003, VBA, MS Project, Clarity, Visual Workbench, Lotus Notes, SQL, Access 2003, Oracle 9i, Win XP Pro 2003
Schnitzer Steel - Global Exchange Division; Portland, OR Jan 10, 2007 – Jul 20, 2007
Sr. Programmer/ Analyst
* Gather and manage requirements based on System Development Life Cycle process.
* Design, develop, and implement new Accounting system to track Sales and Purchases of Recycled Metals. The new system provides both the New York office and Portland office with a system that captures and stores the sales and purchase data in a relational database model. The new system provides data entry screens that will capture four types of Purchase information:
1. Purchase contract; 2. Wire Memo's; 3. Addenda; 4. Inventory analysis. The new system also provides various types of Sales contract information: 1. Sales contract; 2. Invoices; 3. Remittance; 4. Inventory
Nike WHQ-Subsidiary-IT Support; Beaverton, OR Oct 18, 2005 – Jan 10, 2007
Senior Analyst, Developer and Programmer
For the Nike In-House Manufacturing Department
Tasks include:
* Provide modifications and enhancements to Crystal reports using stored procedures to access SQL Server 2000 databases.
* Trouble shoot source code in existing Visual Basic front end accessing SAP database tables/ views.
* Implement new reporting requirements for existing Access applications utilized by fabrication supervisors.
For the Nike subsidiary, Exeter Brand
Tasks include:
* Gather and manage requirements, conduct System Development Life Cycle process.
* Design, develop, and implement new Sales Order system for Exeter Brand, a Nike subsidiary. The Sales Order System automates the process of constructing sales orders from Wal-Mart purchase orders provided to Exeter in Microsoft Word, RTF file format.
* Proposed system would parse and extract order information contained in batches of Wal-Mart purchase-orders (Word- RTF file) that are required to construct Exeter sales orders:
* Automate uploading of purchase order documents using a file sniffer routine to locate files and capture all data.
* Execute parsing procedures to extract proprietary data from the purchase order, and persist the data to a SQL Server database.
* The stored data will be maintained in a normalized relational database model.
* Excel files are maintained and will be updated with pertinent purchase order product information, which is persisted to the SQL Server database, and accessed for the purpose of updating sales orders when product pricing may change prior to sales orders being output as CSV files for TradeCard.
* Data retrieval or manipulation is implemented using stored procedures and ADO technology invoked from an Access 2003 front-end interface.
* End user can modify data, if necessary.
* Completed Sales Orders are output in CSV format to create a text file that is used for additional processing used by TradeCard system.
* The Sales Order System is fully automated Sales Order constructor-application comprising a parsing engine, interfaces to utilize VBA, ADO, ODBC , SQL Server back-end-database.
* Environment: Converse supported server, SQL Server 2000, Access 2003, ODBC, ADO, Excel 2003
For the Nike Golf Operations Department
Tasks include:
* Designed and developed a relational database management system to track sales, and purchases of Logo Golf Balls.
* System design, development included implementation of Logo Ball Purchase Order module.
* Provide inventory tracking, Vendor Work Order interface to capture product orders, and output the Vendor Work Order in XML format viewable.
* Provide automated customer pricing and Vendor pricing process to ensure accuracy.
* Provide a Net Inventory screen to view current product inventory based on all orders to date, and orders shipped.
* Environment: Windows XP; Microsoft Access 2003
EDUCATION
United States Naval School Of Music; McKendree University, Lebanon, Illinois, PCC Community College; Portland, OR ; Bachelor's Degree - Computer Science