Operating Environments:
• Windows, Linux
Languages:
• 10+ years programming using C# and VB.Net
• 10+ years programming using C/C++
• 10+ years programming using ANSI SQL, PL/SQL, T-SQL
• 10+ years programming using Visual Basic
• 10+ years programming using Unix shell scripting
• 2+ years programming using Python
Code Environments:
• Microsoft Visual Studo
• Team Foundation Server
• Agile
Technologies:
• 10+ years programming under UNIX
• 10+ years programming in Windows environments
• 10+ years programming using C#
• 10+ years programming using SQLServer development tools (T-SQL, SSIS, DTS, packages)
• 10+ years programming using Oracle development tools (PRO*C, PL/SQL)
• 10+ years developing distributed systems (Web services, server/client architectures, real time data acquisition and control systems
Database Environments:
• Oracle
• SQLServer
• Teradata
• Ingres
Software Engineer @ Building Web Apps, Cloud Services, Web APIs, SQL Databases in Azure. From January 2015 to Present (1 year) Software Engineer @ Building enhanced security enabled applications for Android using Java, C, SQLite, Eclipse in Linux. From July 2014 to January 2015 (7 months) Consultant @ • Building configuration and monitoring tools for Fluid Cache disk caching system using linux libraries, gcc (portable C), gdb.
• Built a Text UI for initializing vCenter VSAs and Fluid Cache appliances using Python.
• Porting Linux user code in C to Windows for Fluid Cache.
• Built a web service using gSoap and Mongoose in C++ that invokes external Powershell scripts returning results to clients. From October 2012 to March 2014 (1 year 6 months) Portland, Oregon AreaSoftware Engineer @ o WCF Services developer building streaming services for data virtualization projects in C#.
o Developed custom JSON/XML stream serializers in order to multi-thread proprietary formats in WCF functions.
o SQL Server / Teradata modeler and developer creating sprocs, triggers and views..
o ASP.Net Dynamic Data developer creating web applications using C#, jscript, jquery and custom UI components.
o SSIS developer building ETL services that synchronize CRM data stores. From October 2011 to October 2012 (1 year 1 month) Application Engineer @ o C# Developer supporting enhancements and bug fixes for Alstom`s OpenPDC real time data concentrator and associated SCADA interfaces. Completed SQLServer scripts that facilitate C37 modeling.
o Completed Alstom`s ISD Adapter for openPDC that allows C37 Syncrophasor streams to enter existing SCADA data streams.
o Created C37 Streamer, a C# socket listener/sender that can be used as a C37 stream repeater or data source. From February 2011 to August 2011 (7 months) Application Analyst @ o C# Developer creating tools and applications in support of the Western Electric Coordinating Council’s Wide Area Situational Awareness Syncrophasor initiative. C# applications concentrate hundreds of streaming UDP sockets into time sequenced output frames for further distribution.
o SQLServer modeler creating schema and clients for reporting warehouses based on large real time datasets.
o Developer creating OSISoft Pi extensions in C# for real time operators. From August 2010 to February 2011 (7 months) Senior Computer Specialist @ o SQLServer 2010 developer creating scripts, stored procedures and Integration Services in support of Patient Financial System warehouses.
o Maintenance programmer supporting Reg/ADT applications at Harborview and UW Medical centers. Application consists of a redundant database store and several client expressions running in Linux. Maintenance environment includes SQL embedded in C, ksh and Perl scripting.
o On call application / interface support. Troubleshooting HL7 interfaces given in C socket servers and various scheduled data transfers and loads in a 7/24 production setting. From August 2008 to August 2010 (2 years 1 month) Application Analyst @ * Consultant providing software solutions in support of real time system operations in C# and VB6.
* Oracle developer supporting Electric Power Distribution Management Systems
* Pi developer creating Gas Control Center infrastructure using VB6 and custom ActiveX controls and DLL's From August 2008 to August 2010 (2 years 1 month) Senior Software Engineer @ o Developer enacting releases and issue resolutions for FusionWorks Billing Mediation product family.
o Optimized standard PL/SQL reporting packages increasing runtime performance from nearly 24 hours to completion to under an hour.
o Java developer creating Management Beans intended to provide run time control for real time data acquisition modules. From March 2008 to May 2008 (3 months) Database Modeler/Programmer @ o Database Modeling and Programming Services to design, build and implement T-Mobile`s Retail Activity and Labor Hours Forecasting, Allocation and Security Model. Implementation Involved SQLServer infrastructure to efficiently grow and abstract a past Retail Channel Activity Archive, forecast future retail activities and predicted labor hours budget allocations and dynamically build a series of pre-aggregated reporting views for a Crystal Reports Web Server.
o Solution Provider Created Retail Finance Labor Model Security methods and implementations.
o Designed and built Retail Finance Analyst Tools and associated DTS framework.
o Designed and built Retail Finance Labor Model Mailer used to embed URLs in a source image within Email messages. The mailer provides custom STMP handshaking settings specified at runtime that adjusts message connection densities and retries according to real time network and STMP server environments. Build using VB6 and SMTP protocol commands thru Winsock.
o Designed and built a PowerPoint tool that mines Presentations for specific Slides and then adds them to a new Presentation made from a template. This allowed quick changes to a set of PowerPoint Presentations Slide hierarchies using a mapping mechanism. Delivered fully tested and accepted solution under tight timelines in order to maximize cost savings. From February 2007 to January 2008 (1 year) Programmer Analyst @ o Database Development Services to create XML SPEC2000 messaging infrastructure for an Aircraft Identification and Statistics database and associated client interactions and reports. Data store provides reliability information on all known commercial aircraft. Development environment is VB6 and ODBC into a Teradata warehouse.
o Maintenance Programming enacting releases for production RMCS application. Build a Teradata macro that presents groups of data and their corresponding pivot columns in static sized rows. Used to dynamically create client pivot tables with hundreds of columns from the database using fixed sized rows and static, stored SQL. From June 2005 to February 2007 (1 year 9 months) Software Design Engineer @ o SDE building infrastructure for RTC Operations using .NET, C#, IIS, SOAP and SQL Server technologies. From May 2005 to June 2005 (2 months) Database Analyst @ o Data Analyst identifying relationships and reporting requirements across several data warehouses. Data describes cell site equipment and configurations throughout customer base in the Americas. Analysis involves characterizing datasets and their relationships and validating process flows that affect them. Data is contained in Oracle 8i/9i. Analysis tools include PL/SQL, VB, Access, Excel, SQL Server, DTS From December 2004 to May 2005 (6 months) Product Developer @ o Created Remote Batch Copy. A remote file Gather/Scatter utility that automates batch copies from multiple sources and destinations on thousands of networks thru out the world.
o Created Active IP Sensor that captures IP port connections in real time as they are formed, progress and retire on remote desktops and displays them in a dynamic tree view that shows their state hierarchy.
o Created Log Dispatcher A Real Time Event Driven Network Node. From August 2004 to December 2004 (5 months) Senior Developer @ o Maintenance Programmer supporting e-terraarchive suite. Product provides a distributed general-purpose tool for scheduling data transfers from real time SCADA systems to Oracle or SQL Server. Development environment included PL/SQL, WIN32/Unix ODBC, C++, ASP From May 2004 to November 2004 (7 months) Database Programmer @ o Database Modeler building schema to support views of critical business operating metrics for senior management.
o Designed and implemented a series of PL/SQL packages and procedures that acquire data from operational sources and populate Business Object universes used to monitor financial performance. Views for business metrics are materialized from staged snapshots, external tables and historical datasets merged via scheduled PL/SQL server code.
o Created a database deployment package that builds schema and stores database code from a list of dependant installation sources. Implemented using Perl and KSH scripting, PL/SQL, SQL*Loader
o Assigned Priority 1 and 2 system acceptance discrepancies related to an Enterprise Information System data warehouse. EIS is comprised of an Access front end that assembles ODBC pass-thru queries destined for an Oracle9i aggregated from SAP 4.6c. Maintenance activities involve correcting embedded SQL in Access VBA modules, editing ETL processes on the various servers and implementing new functions appropriate for Oracle 9i and Philips' EIS system. From September 2003 to May 2004 (9 months) Senior Technical Systems and Applications Analyst @ o Resolved a long-standing bug in real time SCADA user library that caused spontaneous server exits. Anomaly precluded SCADA writes after system fail over. Developed in MSVC++ and AREVA HabConnect API.
o Built and implemented PSE Systems, Releases and Items Source Control Tracking System based upon VSS.
o Developed a document locking and monitoring facility that merges passages from several documents into a Power Dispatchers Daily Log. Facility forms a legal chronology of power system control activities. Built using VB, MS-Access and MS-Word libraries. Instrumented using WINSOCK for remote management functions.
o Developed an interface that repeats data across selected points from OSISoft's Pi archive into a Caminus ACES Oracle schema. Interface conveys energy schedules and SCADA values from throughout the Western US. Written in C# using ADO, PL/SQL and Pi API.
o Created a Windows Service that buffers Oracle 8i DBMS_ALERTS against an outbound FTP control using VB and Winsock API. Service provides a data feed into corporate HQ from the operations center and supports online status reporting and real time error recovery.
o Visual Basic Programmer clearing discrepancy lists during system testing. Projects enable user developed COM objects and ADO expressed in VB in order to implement an Energy Distribution Management System.
o 7x24 on-call troubleshooter supporting real time power system operations From September 2002 to September 2003 (1 year 1 month) System Engineer @ o Real Time Programming Services to develop real time data collection and transfer systems involving a wide range of hardware platforms and operating environments. Wrote a device driver that provides support for a custom VME bus interface installed on a Concurrent Computer multi-processor system.
o Designed an API that permits engineers to merge IRIG time and raw data packets in real time applications. API included specialized device interfaces and diagnostic utilities. Written in C under SYS V UNIX, code was used to form modules for virtual laboratory instruments in data acquisition environments.
o Developed Interrupt/DMA service routines necessary to transfer asynchronous buffers from Q and UNIBUS hosted adapters. Written in PDP-11 assembler and Fortran.
o Data Acquisition Systems Engineering to develop and implement hardware and software components necessary to convert Navy Universal Digital Data System and MK-48 vehicle data acquisition systems from custom hardware systems to commercial PC based, resulting in more cost effective maintenance, procurement and portability. The system delivered a user interface that enabled operators to configure and monitor the transfer, perform hardware self checks and finally post the captured data to analysis workstations on the LAN. Written in C/8086 assembler From May 1987 to May 1996 (9 years 1 month)
Jeff Martin is skilled in: C#, C, SQL, Web Applications, Web Services, Databases, Microsoft SQL Server, .NET, Windows Azure, Linux, Unix, Cloud Security, Data Warehousing, Python, XML