Kapsch TrafficCom is a provider of intelligent transportation systems in the fields of tolling, traffic management, smart urban mobility, traffic safety and security, and connected vehicles. As a one-stop solutions provider, Kapsch TrafficCom offers end-to-end solutions covering the entire range of transportation control systems for its clients, from components and design to the implementation and operation of systems. The mobility solutions supplied by Kapsch TrafficCom help make road traffic safer and more reliable, efficient, and comfortable in urban areas, on highways, and everything in between.My position at Kapsch is within the DevOps function as a Database Lead, currently supporting primarily Tolling System design, development, and support of large and complex client systems such as the Maryland Transportation Authority's tolling and back office interfaces.I work primarily with Oracle Databases and UNIX system development and support and scripting applications in support of Transportation and Tolling Systems, primarily on the database, system interface (roadside data collection, toll calculation, and data delivery to external billing systems), and other backend systems. This includes system failsafe components, trip definition, error detection. and other system component support in high-transaction, high-availability, constant-operation systems.The DevOps functionality means that if it breaks, we need to jump on the issue, at whatever time or day, to get the problem fixed and the system back into operation without any revenue loss.My other roles in my career have prepped me to get to this point, but I still learn something every day. DevOps requires the ability to calmly execute in pressure situations while using creativity and experience to get the fix in quickly and reliably. Sometimes this creates high stress levels, but it also creates continuous reward and gratification.

Database design analyst contracted to assist with the multi-year project of database and process modernization of inventory management, order management, customer/supplier managememt, invoicing, storage, delivery, and related support systems for one of the nation's oldest and largest logistics and supply chain services companies. This company-wide system will replace the existing legacy system which supports the storage and distribution of grocery, food, alcohol and tobacco product to convenience stores, mass merchants, drug stores, restaurants, and military locations throughout the United States. • Designed, coded, and implemented an Oracle-based application to extract and present Order Guide data from the company database on order to present a customer-facing product via online and FTP/XML from which orders could be made on a daily/weekly basis via manual or electronic means. • Designed, coded, and implemented an Oracle-based application to prepare and present a Price Book of products for organizational customers. • Created a stand-alone module using Oracle-based applications and PL-SQL libraries to update product and order pricing at all stages of the order/delivery process. This application was used to update component/item prices at all stages of the order/picking/delivery process based on all available pricing components used for specific customers as well as corporate-wide deals, allowances, and discount pricing components as defined by other marketing (internal and external) pricing components. • Designed, coded, and created a Supply Chain application to convert customer orders into “cubed” delivery units, allowing easy calculation and organization of individual order component items into delivery/loading “cubes” (or units) which allowed easy and efficient loading of delivery cubes and vehicles, saving the company thousands of dollars annually due to more efficient loading of trucks and delivery containers.

Started a broad-based consulting company with the goal of assisting small- and medium-sized companies with the development, purchase, installation and maintenance of business computer, server and network systems and databases (both SQL Server and Oracle) to support business operations, inventory control, purchasing and customer-maintenance applications. • Managed and mentored a team of 3 developers • Designed, sized, and assisted with the purchase, installation, and support/maintenance of a computer system and network comprised of 23 workstations, 4 servers, and supporting devices such as printers, scanners, and fax machines to support the modernization of inventory and sales/customer management in an appliance and household goods retailer with two separate retail/office locations. This work involved customizing business reports as well as a simple database system used to track inventory and manage customer relationships as well as numerous custom scripts necessary to support the day-to-day operations of the business. • Provided varied professional consulting services to various small businesses related to design and implementation of computer systems (hardware and software) as well as installation, maintenance, and enhancement to existing and new business systems (enterprise-wide). • Performed Business/System Analysis and Business Intelligence research and design as required to successfully understand, integrate, and implement business solutions involving various stand-alone and third-party applications/system components required to provide business solutions to client companies. • Designed/Implemented/Maintained various SQL databases in support of business operations. Performed heavy SQL and PL/SQL development including stored procedures, triggers, production support and monitoring tasks. • Created automated (scripted) and manual data ETL tasks for pulling sales/inventory data from flat files into usable system files and database tables.

Perform full life cycle development of high-availability financial market data delivery, quality verification applications for this financial news company (newspaper, internet, and training seminars) and provider of national and international financial and stock market data. Trained and supervised a team of 12 developers primarily focused on the support of high-performance investment portfolio research and management as well as a financial stock market newspaper and internet production processes. • Designed, developed, and maintained a proprietary MS SQL Server-based system to monitor and gauge performance of various existing and potential stock portfolios which is used in newspaper production, customer education, and institutional portfolio research and management. • Designed and implemented a complete set of high-availability monitoring system components, applications, dashboards, and email/paging components that were put in place to monitor system production processes and report any problems or database issues rapidly enough that they did not interrupt time-sensitive production processes. • Served as corporate IT Database Manager (DBA) for SQL Server groups. • Designed and supported various Data ETL schemes used to both import data into production and test databases/data warehouses and to extract the data for export to various internal and external data delivery product customers, creating a new and highly-prosperous income stream for the company. • Acted as liaison between corporate IT and internal/external customers to troubleshoot and resolve functional issues as well as to define, develop, document, and implement interdepartmental/ intercompany data delivery solutions resulting in a steady stream of new customers and the related revenue streams. • Managed, maintained and supported a data warehouse containing stock trading information and history for all listed USA companies from the inception of the various stock markets up to the present day.

Perform full life cycle development of monitoring and infrastructure data transfer/process interactions for component processes of this software development team supporting the nissanusa.com and infiniti.com websites. Brought in to design and develop a system monitoring dashboard so that process and data quality of the various website support systems could be more closely monitored and ultimately improved. • Wrote new and modified existing Perl scripts whose purpose was to monitor system component data hand-offs and to capture process and inter-process metrics related to primarily the server-side of the nissanusa.com and infiniti.com websites for use by the System Dashboard and other team analysts within the development group. • Designed and implemented an Excel- and VB/VBA-based System Dashboard application that auto-loaded data from the various capture processes and scripts into small SQL databases, performed various metric and statistical analysis of the captured data, presented it to internal users in both dashboard- and report-formats for the purpose of data/process verification and analysis, forwarded system alert emails to appropriate support and management personnel, and archived the data for ongoing trend analysis.

Perform full life cycle development of Financial Market Data delivery and quality verification applications for this provider of national and international financial market data. • Took direct responsibility for the maintenance and enhancement of a Java-based (over Sybase SQL RDBMS) application which was initiated in response to a corporate-wide effort to monitor and increase the general accuracy and quality of the financial market SQL databases used for gathering Business Intelligence and Data Analysis information and report generation for varied internal and external customer business system decision-making activities. • Converted a core legacy processing system from a build format using make/multimake that required specific setup and invocation from specific network machines to one that can be built from any network node/workstation in the organization. This project allowed what was previously a legacy knowledge “black box” core application to be easily updatable by virtually any software developer in the organization. • Created Java classes and jar files related to daily market data exception processing for use in ITG Data Delivery Group’s data quality API libraries. • Utilized Sybase SQL coding and Stored Procedures to create script and Java applications for database table cross-checking and data verification in a high-transactional financial analysis and tracking software suite.

Selected to perform the full life cycle development of system applications to demonstrate and support high availability, multi-threaded, fault-tolerant client/server telephony and networking products for this manufacturer of custom equipment racks and hardware for the telecom industry. Worked individually and with another developer under the paired XP programming model to design, develop, implement, test and document GUIs, system control components and continuant software using Dynamic Shared Memory for use in cross-platform CPU/Blade environments. • Led a project to identify and present points of weakness and other shortcomings in the API and system functionality components, enabling management to prioritize and improve specified areas in order to transition a demonstration system into a successful product offering with maximum benefit and appeal to customers. • Defined and streamlined documentation procedures for the CTO (Development) group as Documentation Release Coordinator to ensure timely and accurate preparation, review and delivery to customers in accordance with company format and content standards. • Developed a (POSIX-compliant) multi-threaded, high-availability GTK/Gnome GUI to demonstrate the full functionality of the Continuant Software Suite product by displaying system status and recovery processes and allowing the user to shut down nodes at random to observe the system’s ability to recover at sub-second intervals. • Expanded the marketability of the company’s Continuant product by creating a multi-threaded SNMP server/agent interface in C++ with Java status GUI allowing customers with existing third party software, such as HP OpenView, to access, monitor and control the system. • Designed and developed a command-line interface using Tkl/Tk and Expect that provided users with the functionality to auto-configure, add or remove nodes and perform general “hot-swap” software/hardware functions on the blade cluster.

Brought on to design and develop applications in C and various scripting languages to support and enhance this company’s Unix-based wireless communications billing system and initiate the transformation to a web-based product. Researched and analyzed legacy system to define and document report generation processes, develop user-level documentation and build an internal support knowledge base. • Generated a system/portfolio of over 20 customizable business and data analysis reports using UNIFY SQL and Report Writer code and scripts. Began work on a report generator tool which could be used to generate custom on-demand reports by CBill customers. • Preserved the company’s relationship with a key customer by fulfilling a request to account for the methods used to generate UNIFY/RPT reports, which involved reverse-engineering the system to determine the origin of each field on eight standardized reports, saving the client for CBill while enhancing future customer support. • Participated in a two-person task force to lay the groundwork for development of VBA and XML-based GUI/Browser billing presentation.

Served as lead designer and managed a team of 5 developers responsible for the migration of Student Loan Application and processing software from mainframe to PC environment with a web-based user interface and verification enhancements for the company that performs actual student loan guarantees for the Student Aid Commission of California as well as other states. Prepared UML diagrams using Rational Rose, prototyped and tested system components on Sun Solaris and Windows NT platforms and assisted new developers in the set-up and use of the development environment. • Created and implemented a C++ cross-checking and verification application and multi-threaded server to sustain existing batch-mode verification processes while allowing new web and GUI-based development, which enabled simultaneous testing and correction of both systems with no disruption to service. • Employed and expanded knowledge of concepts behind SGML, SMTP and Sendmail, HTML, PHP Script, KIVA Enterprise Server and C/C++ built over a DB2 database for communication and component processes.

Advanced to oversee development of new cable television, telephony & network management systems to ensure adherence to all specifications/requirements for this provider of billing & subscriber management software for multiple industries. Charter member of corporate R&D project sizing committee that reviewed, assessed, and sized all Incoming projects. Monitored all phases of development to ensure ISO-9001 compliance & provide early detection of potential conflicts with requirements/design documentation. • Managed a team of 4 Design Analysts dedicated to the company’s proprietary Cable TV & Telephony billing, customer maintenance, inventory management, & reporting functions for major national & international customers. • Led a design steering committee tasked with design & implementation of a fully customizable report-generation system utilized to pull data from Tandem SQL databases & generate full suite of reports. • Reduced the average development timeline for interface development from 120 days to just 30 by leading R&D effort to design and code a modular, client/server system with three total interface layers to replace the highly inefficient previous method of creating a new driver/interface for each new vendor. • Spearheaded company-wide Y2K compliance plan as R&D representative & committee chair; independently assessed all applications & SQL database structures for potential conflicts and led multiple departments through the process to pass Y2K without a single issue across over 120 applications. • Led the separation of a mainframe-based, monolithic application into Object-Oriented client/server applications capable of operating across multiple platforms. • Ensured consistent and complete notification of all stakeholders in the event of a change in any specification document by creating a library/logging system to control & distribute changes, meeting ISO-9001 certification standards while saving time & avoiding project delays.

Provided direction and guidance to a team of 8 internal and up to 6 contract software programmers in the development and on-time delivery of machine-interface, inventory control, addressability and customer service/subscriber management modules. Communicated with cable company clients and ANI vendors such as AT&T and PacBell to define and review specifications for interface protocol. Met with product managers, Marketing personnel, vendors and customers to discuss and negotiate functionality and cost issues regarding new development and modification projects. Hired and monitored the performance of departmental staff. • Key player in the ongoing conversion of a suite of over 250 programs from Tandem/SQL to be made platform independent and run on both Tandem/SQL and Unix/Oracle platforms; led efforts to incorporate multi-language capabilities for international customers as well as a billing/charging Telephony module. • Served as Project Coordinator charged with preparing project plans and schedules, monitoring progress and adherence to specifications, assessing performance, resolving problems and testing several major software releases to ensure on-time delivery of top quality domestic and international product lines. • Acted as a special consultant on a team tasked with designing a future product line with the goal of providing company customers with a 100-percent customizable reporting tool capable of building reports from any and all fields available in the system’s many SQL database tables. • Headed special task forces responsible for implementing products including Near-Video-On-Demand, Satellite Systems billing and support and the industry’s first system to support cablemodem authorization and billing.