JDSCraft

Director, IT – Data & Common Services

Accountable for implementing a shared services strategy across all of HA IT for our integration, data, and analytics platforms. Ensure the diverse needs of our entire IT portfolio toward common capabilities, processes, and tools. This includes an equally strong balance of business services, data services, and technical services and requires negotiation and coordination across many involved parties and adherence to best practices and principles in IT.

Continually reducing the overall cost of delivering IT services to Hawaiian Airlines by building a leverageable common core that ensures consistency, reuse across the HA enterprise, and a data-first strategy.

I have developed good relationships with IT leaders at HA and continually strive to improve our development processes, quality, IT security, reduce development time/costs, and increase service reliability. Working as a technical leader and the Software Development Engineer (SDE) job family sponsor at HA has enabled me to do this by collaborating with other IT departments to effect change, build and lead a highly productive team through highly effective hiring and coaching processes, and leverage modern technology and design practices.

Flight Data Mart (FDM) Retirement: Retire legacy FDM enterprise data warehouse (EDW) to reduce operational costs and non-labor IT budget. Technology to retire: Microsoft SQL Server, SQL Server Integration Services (SSIS), Crystal Reports, Microsoft Orchestrator.

• Operational Processes: I led the various workstreams to integrate the operational processes with the modern API, ingestion pipeline, enterprise service bus (ESB), and operation data store (ODS) data stack. Technology: MuleSoft apps, S3, AWS SNS, AWS SQS, ActiveMQ, Anypoint MQ, MongoDB.
• Analytics Data: Re-engineer the flight data ingestion pipelines to feeds the data analytics stack. Technology: Snowflake, Airflow, python, DBT.
• Consumption: Provide operation dashboards of near real-time data, data visualization, and tools for analysis of historical data. Technology: Angular, MuleSoft Apps, MongoDB, Snowflake, DBT, Tableau.

Senior IT Manager

Managing the IT Data & Common Services integration team building secure, highly available services for the Kiosk, Web, and Mobile channels supporting capabilities such as Ticket Enterprise Data Store (TEDS), Enterprise File Gateway (EFG), Self-Service Checkin (SSC), Shopping and Flight Status. Leading a team of software developers and technical analysts to build quality systems, improve development processes, develop effective hiring processes and onboarding programs for SDE job family, retain employees, and guide other IT teams on best practices in development and design.

Projects:

• SSCI: Led the team designing and developing the services that deliver the Self-Service Checkin capabilities delivering a platform of common capabilities, processes, and tools by documenting the development process, best practices, and integration patterns used.
• TEDS: Led the team designing and building the enterprise data store for tickets ensuring the ingesting of data from various ticket data sources, providing APIs, and data exchanges to apps.
• EFG: Led the team in creating the platform for all external files coming onto HA and the patterns for integrating with them for dissemination to all systems that use them.
• PSS Migration: Led the team that built the automated processes for creating the connectors to the Amadeus Passenger Service System (PSS) for use by any application running on our integration platform, migrated the SSCI common services, and helped other teams successfully migrate to the new PSS.

IT Manager

Upon starting I worked with other managers and developers to start a grassroots effort to use agile development practices (XP, Lean, iterative Unified Process, Scrum), CI/CD, and automated tests. I worked with senior developers and IT managers to document these coding and quality standards to bring benefits to the rest of the organization.

• HawaiianAirlines.com E-commerce Payments Team: Within the first couple of months od starting at Hawaiian Airlines I had turned the Payment team around from fixing bugs 90% of the time to just working on new features by refactoring all the code to achieve 100+% unit test coverage to detect regression issues with any changes made before releasing them.
• PCI Project: When the organization needed to comply with PCI regulations, I was chosen to lead the AWS Cardholder Data Environment (CDE) project that was completed within a tight deadline and has proven to be a highly reliable, secure, robust payment processing system.
• Mobile App Beachhead Project: Joint lead for the team developing the foundation for the HA Hub to meet the organization's IT strategic goals, prove out the enterprise architecture, and lay the foundation for Data & Common Services to transform HA's aging IT infrastructure and outdated software development practices using modern technology and design principles. MVP features included SSCI, shopping, flight status, enterprise service bus (ESB) messaging platform, and push notifications.

Technical Director / Developer / Solution Architect

Running my own software development company working as a contractor and IT consultant for various clients, including:

Projects:

• IT Consultant for Reid Industries and Rain or Shine Solutions: designing overall architecture and implementing IT infrastructure using Znode/ASPNET e-commerce platform, ASP.NET, .NET 3.5, and Web services to integrate with QuickBooks and suppliers. Creating multiple themes for each store running off the same platform, each with a unique URL, look & feel, page content, and product catalog for one site needing multiple brands as well as their Pik Stik site.
• Solution Architect and Developer for Rental Reservation System (RRS): Designing overall architecture for RRS in UML using the latest technologies to build the app in: .NET Framework 4, MS SQL Server 2008, AJAX and Entity Framework. Multiple front-end property marketing sites designed for HTML5 and CSS3 integrated with RRS and partners through Web services, REST and XML feeds with identity management. The previous version of RRS I built using PHP, MySQL, XML feeds and JQuery used by property management companies to compete with VRBO in 2009.
• Developer for American Technology Services (ATS): Developer and software architect for .NET software development projects, ensuring applications meet design specifications and standards during code reviews. Experience using Microsoft Project to generate project Gantt charts, various issue/task tracking systems or SharePoint for reporting and consolidating project documentation, and reporting to stakeholders and managers on project progress. Software architecture designed in UML which is also used to trace fulfillment of system requirements (using Enterprise Architect CASE tool) & track progress on the implementation of components and other development tasks.
• Technical Director for LeafDev: Managing technical department and training/mentoring the recently hired General Manager to take over the day-to-day running of the company that specializes in building custom websites using various content management systems (CMS) like Joomla, Drupal and WordPress, providing search engine optimization (SEO) services, and e-commerce solutions.

C# .NET Programmer / ETL Developer

Part of a small team responsible for providing technical support, system maintenance and enhancement services using an agile development approach, writing user stories and striving to improve efficiency in the organization by developing an appropriate software architecture and consolidating the various databases, including developing a project plan and ETL scripts for a unified system.

Director of Engineering

I supported Videomaker by providing a reliable technical infrastructure and overseeing development efforts for their website, mobile apps, third-party integrations, and internal tools. It was a leadership role that required innovative thinking that coupled business strategy with technical opportunity. It was also a highly enjoyable hands-on agile team lead role using PHP, and Drupal 7 to improve the videographer's training portal which interacted with OpenX, Recurly, Vimeo and Quickfill, web services for iPad app that I published updates to Apple’s iStore, GIT and used Selenium IDE for testing.

When I started the website was frequently going down and we were losing a lot of online revenue due to visitors not being able to access the site, watch training videos or become members/subscribers at these times of outage, not to mention lost ad revenue. I identified the root causes of the problem which was the hosting platform currently in use and a tightly coupled set of systems.

After performing a thorough hosting vendor product comparison and benefits analysis I secured the budget to move the website to Acquia’s cloud-based hosting service, setup and configured Memcached for publicly accessible web pages and started monitoring the site’s performance with New Relic to identify bottlenecks and memory leaks. With the help of the small development team, we decoupled the ad server from the site and moved it onto a separate and more cost-effective hosting environment. I chose Bluehost’s VPS hosting package for the OpenX ad server we were self-hosting, although I would have preferred using their hosted ad server instead but could not secure the budget for that at the time.

The site had a 100% uptime after the transition to the new hosting platform and decoupling the systems, the page load speeds improved significantly by using page caching which increased customer satisfaction. This helped the marketing team achieve higher rankings on the search engines as well as having the confidence to drive even more traffic to the site because it could now handle it with ease by automatically adjusting the hardware allocated to it, increasing the ROI on the site for the organization.

Systems Analyst / Architect / Technical Lead / C# .NET Programmer / ETL Developer

Led the analysis and design for U.S. Environment Protection Agency (USEPA), U.S. Navy, Department of Energy (DOE) and State Water Board projects. Technical lead and developer for all .NET and SharePoint projects, ensuring timely delivery of development tasks.

My main responsibility was to gather requirements from clients and identify how the system being developed fits into the overall business processes in onsite Joint Application Design (JAD) sessions. I’d then analyze and document the requirements in a formal System Requirements Specification (SRS) meeting company quality standards and present it, along with creating the HTML mockups of the UI, to the client for sign-off with the project manager. I would then work with the developers and DBAs to estimate the development effort by breaking down the functionality into small tasks/estimating elements for the project managers to update their project plans and schedules with more accurate estimates to ensure the projects were on track and within budget.

In the next phase, I would work with the developers and DBAs to design the software, apply appropriate design patterns and consider the various architectural viewpoints of the system that I then documented using UML diagrams and entity-relationship diagrams (ERDs) for DBAs, where appropriate. At the same time, I’d work on the test plan, starting with the test cases identified from the use case scenarios and documenting unit, integration, vulnerability and performance tests planned by the development team, or mandated by the client in the requirements or constraints.

I was responsible for tracking, and communicating project progress to the client, the project manager and other key project stakeholders, mentoring junior analysts, leading the development on .NET projects and training the users how to use the new system once installed onsite. I ensured the software complied with and met all client requirements and quality metrics by demonstrating full traceability through to implemented code, services, APIs, scripts, screens, documents, and other project artifacts.

I was also responsible for recommending tools to purchase for the development team, improvements to the development process for raising the company’s CMMI maturity level above "Managed" (level 2) and increasing quality of software products produced, writing technical approaches in client proposals as part of the bidding process, interviewing analysts and developers, managing user acceptance test (UAT) sessions, creating the documents detailing each release of the software to various parties for enhancements and hot fixes, and as well as creating software maintenance documentation for developers and DBAs.

Projects:

• Water Quality Monitoring (WQM) Data Flow System for Texas Commission on Environmental Quality (TCEQ): led the analysis effort gathering requirements and designed data flow system using UML diagrams to communicate behavior, architecture, and realization of components implemented in Java. Used a model and test-driven approach in line with unified process (UP) and agile practices to manage development effort and comprehensive test strategy. The Surface Water Quality Monitoring System (SWQMIS) is used to enter Water Quality Management (WQM) data in an Oracle database that is submitted to USEPA’s Central Data Exchange (CDX) system via Web services in XML format conforming to a specific set of CDX compliant XML schemas and data validation rules. Also, part of the team responsible for updating design documentation and testing SWQMIS, utilizing Sparx Enterprise Architect tool to reverse engineer the Java code into UML class diagrams and other tools to create entity-relationship diagrams (ERDs) from the Oracle database schema.
• Coral Triangle Initiative (CTI) for USAID: technical lead and developer planning, designing and building SharePoint application used in the Philippines to collaborate on various initiatives to protect coral reefs. Includes custom Web part using Google Maps and a backend Geographic Information System (GIS) using ArcGIS Server for spatially-enabled project information, a custom Web part to replace SharePoint’s document library for more ease of use and publishing documents to other sites and Microsoft SQL Server. Created SQL Server Reporting Services (SSRS) reports using Web services to pull data from SharePoint lists.
• ALA-WADR for Alabama State: C# .NET developer adding functionality to existing multi-tier ASP.NET application for collecting and analyzing fish and macroinvertebrate samples.
• Dynamic Document System (DDS) for Naval Facilities Engineering Command (NAVFAC): Systems Analyst, Business Workflow Developer, and C# .NET Developer on project customizing enterprise DMS using Laserfiche with custom business process applied for developing the US Navy Marine Resource Assessments (MRA) document and extensible content types for other documents.
• Forest Information Management (FIMS) for Camp Leijune and Marine Corp: Systems Analyst, Technical Lead and C# Developer on the system developed using ASP.NET, .NET Framework 3.5 with ASP.NET MVC and LINQ to SQL to provide object-relational mapping (O/RM) of the SQL Server 2005 database. Reports developed using SSIS. The FIMS app accepts entry of forest inventory data collected from the base's forests and calculates forest product metrics available as reports.
• SharePoint Intranet for Tetra Tech’s Information Technology and Modeling Services Group (ITMSG): technical lead implementing the office’s Intranet site built using Microsoft Office SharePoint Server 2007 (MOSS 2007) which includes documents libraries, Wikis for knowledge bases, custom views of lists using Web services, custom XML and XSLT data views, and custom workflows for projects. Techncial Lead and developer planning, designing, building, and administrating SharePoint site and subsites.
• eNOI eReporting for United States Environment Protection Agency (USEPA) Office of Waste Management (OWM): lead analyst and designer for the eReporting module which is part of the eNOI system - online electronic permit application system. eNOI allows construction site operators to apply for coverage under EPA’s NPDES stormwater Construction General Permit (CGP) and for industrial facilities covered by EPA’s Multi-Sector General Permit (MSGP). The requirements were gathered in JAD sessions with key stakeholders and users, and analyzed using various agile and Unified Process (UP) compatible techniques to design business process workflow, use cases and scenarios, logical data models and documentation of non-functional requirements. The design was documented in the form of diagrams compliant with latest UML. Ensured electronic signatures and permit encryption complied with Cross-Media Electronic Reporting Rule (CROMERR) check list standards.
• Check-Up Program for Small Systems (CUPSS) for USEPA Office of Ground Water and Drinking Water (OGWDW): selected appropriate technology and system architecture through proof-of-concept studies for multi-platform, free asset management tool. Lead tester and configuration manager for the build phase of CUPSS desktop application that’s an electronic mechanism for tracking and planning basic facility operations, maintenance activities and long-term asset management. CUPSS provides asset inventory, planning and preventive maintenance and financial planning components for small drinking water utilities. The test plan includes the testing strategies, test cases, and expected results used to test system and extensive code reviews meeting federal agency standards.
• Comment-Response System (CRS) for the Department of Energy (DOE): functional lead and configuration manager for system that manages the comment-response process and generates scoping reports and environmental impact statements (EIS). The SDLC followed an approved set of processes that ensure quality in the development of the system and the Sparx Enterprise Architect tool was used to document design that met strict quality assurance (QA) procedures during the DOE audit.
• alifornia Water Quality Assessment (CalWQA) System for State Water Resources Control Board (SWRCB): lead analyst and designer for system that collects lines of evidence (LOE) on water body impairments in the state of California. Allows regional boards to make decisions on LOE for SWRCB and USEPA to approve and create 303(d) and 305(b) listings for public and USEPA Integrated Report.
• California Integrated Water Quality System (CIWQS) for USEPA: responsible for gathering business requirements from EPA and various water boards in California. Then translated requirements into designs for developers and database administrators (DBAs) to create Web-based reports from WQM data held in CIWQS using Java, PL/SQL and Oracle.

C# .NET Programmer

Performed business analysis and software design using CASE tool for creating UML diagrams to communicate with business managers and other developers in line with the eXtreme Programming (XP) process. Implemented in C#, ASP.NET, SQL Server, SQL Reporting Services, and Indigo/WCF.

• Public record search platform: Redesigned overall architecture, enhanced search functionality, and added visitor tracking for multiple Web sites providing public records search capabilities using C#, ASP.NET, and Web Services. Sites targeted different audiences, such as public searching for friends and companies needing background checks on employees, hence need for common application framework and multiple front-ends. System met current design standards and used latest technology by utilizing design patterns like Model-View-Controller (MVC) and Indigo messaging framework (now known as the MS Windows Communications Foundation- WCF). Innovative use of WCF combined with AJAX for providing search-as-you-type results.
• E-marketing Web tool: designed and implemented system in ASP.NET and MS SQL Server with advanced sales tracking integrated with front-end public records search sites. Enabled staff to create email marketing campaigns that automatically send custom-branded emails, newsletters, offers and discounts to prospects and existing customers by intelligently selecting relevant promotions based on visitor tracking data and past purchases. Significantly increased revenue for Confi-Chek, Inc. within 3 months of launching first email marketing campaign by tapping into previous customers with targeted emails and product offers.

Technical Director / Developer

Running my own software development company doing my ownh bookkeeping and accounting. Worked as a contractor for various government and commercial contracts, including:

• Waste Recycling Web site for European (EU) Environment Agency (EA): lead analyst, designer and .NET developer responsible for producing detailed design documentation (including UML diagrams) and development plans for system allowing businesses to search for waste recycling facilities in their area. The system was created for Agricultural Waste Stakeholders’ Forum that included the Department for the Environment, Food and Rural Affairs (DEFRA), UK EA, National Farmers Union, and other organizations from which requirements were gathered. I implemented the multi-tier website with ASP.NET, VB.NET, and SQL Server.
• Remas for EU EA: Web developer for system used to analyze environmental data using graphs. Wrote detailed user guides and implemented in Microsoft Active Server Pages (ASP), Crystal Reports 10 and Microsoft Access XP. This project required careful negotiation in meetings and pacifying a disgruntled client that I achieved within a few weeks of taking over project by being honest with timelines and understanding to problems the client had encountered with first version. Then followed through by producing a quality system that met and exceeded the client’s needs and expectations.
• Landcare UK for UK EA: Web developer for land management best practices site that met accessibility guidelines, adhering to not only the UK Web Content Accessibility Guidelines (WCAG) Level AAA, which is the highest level of web accessibility conformance, but also compliance with United States section 508 of the Rehabilitation Act of 1973 and the Americans with Disabilities Act (ADA). Developed using HTML, CSS2, ASP and Microsoft Access.
• Greenerfutures for the Peterborough Environment City Trust: webiste that provided analysis of key stage 1 & 2 data on their education portal using JavaServer Pages (JSP) and MySQL.
• Stock exchange utility for Regisdata: updated stock quotations on daily basis and exported specified fields to be uploaded to website and sent to clients. Automating file creation from Microsoft Access database was achieved using Visual Basic for Applications (VBA), also detected spikes in data by comparing two files.
• Listencloser music portal: my own custom built online portal that provided free web pages, audio streaming and online promotion for bands, DJ’s and solo artist of all music genres and trained staff in website development and to administer it, validate HTML code, and meeting accessibility guidelines. Trained bands and DJs to use Cakewalk digital audio workstation (DAW) software package to practice recording and mixing themselves for a single to be recorded in a studio then promoted and sold as a music CD and downloaded with digital rights management software used to lock download after 3 free plays unless purchased. Provided VJ (Visual Jockey) services at concerts mixing in live and prerecorded visualizations at shows using projectors, AI to synchronize visuals with music and visualization software. Provided accounting services for bands. Trained staff to record and VJ. Designed album covers and performed bookkeeping services for bands.

Chief Programming Officer (CPO)

Provided all training, support, website, custom software, Intranet, and Web script development services for the company and to their clients, including:

• Public Web site for the Eden Project: worked with Technical Director to set up Reddot Content Managment System (CMS) for users to manage public Web site and used ASP, Access and JavaScript to implement custom education games to entertain children coming onsite for a school trip or with the family.
• Intranet Web site for the Eden Project: Web developer and back-office system integrator using ASP, Access, and MS Office automation (Word). Compared and recommended best existing CRM and Knowledge Management Solutions (KMS) available but client chose a custom document and event management system, along with a phonebook/contact system with all staff and Eden Project contacts made available over company network. Trained staff and wrote user documentation.
• NeuQuote Web site for Nuera, Inc.: staff configures available online marketing services for resellers and clients to select, enter monthly marketing budgets and generate a custom quotation online or in PDF to print and turn into an invoice. Designed to be database agnostic and works with MySQL, MS Access, SQL Server, dBase, and PostgreSQL. System implemented using PHP, MySQL and designed in UML.
• Web site review desktop application for Bishop Fleming and UK Online: initially developed for Nurea Ltd. as a contrtactor before becoming a full-time employee (see experience below) then updated for accountant’s Bishop Fleming and UK Online to include the latest recommendations in meeting accessibility guidelines and various government directives, i.e. The Electronic Commerce (EC Directive) Regulations 2002.
• Other projects include creation of custom scripts for Star Internet complex form registration process, event management system for Cornwall Arts Center Trust (ACT), custom CMS for CESA foreign language courses website, and search engine optimization (SEO) services.

IT Technician

Various IT-related contracts as part of my Industrial Placement required for the British Computer Society accreditation of the B.S. (Hons), Software Engineering Management degree.

• InterStar Networking Services: developed routines in PERL to automate the setup of server-side services. Then integrated with existing server-side routines and the Internet Servicve Provider’s (ISP’s) accounting system. Helped save server administrator time by allowing services to be set up, and instantiated, from ISP accounting system automatically by sending a request to the Web server. This meant no manual intervention, which eliminated problems due to missing, incomplete, or inaccurate service set up. Automated ISP services included: website storage space, POP and other e-mail accounts, DNS aliases and many more.
• ISP Accounting Aystem: there were known bugs in existing system used for tracking customer accounts, services and automated billing. Fixed all known bugs along with other issues found in logic of SQL and functionality of some screens. Extra functionality and managerial querying added, including set up of invoicing via postal system and email, more intuitive filtering system for intelligent querying and others to make the Office Manager’s job more efficient. Used VB6, Access, Crystal Reports, a custom file template to specify the layout, format, variables and text of email invoices and statements.
• North Valley Bank Website: worked with head Graphic Designer to develop site in FrontPage. This included several meetings with the Managing Director and Branch Executive over lunch to discuss site’s purpose. Being a major customer, it was also desirable to enquire on any improvements that can be made to InterStar’s services, thus getting idea for redesigning monthly statements and set up of invoicing on ISP accounting system.
• E-commerce Site Debug and Graphic Design: used Cold Fusion to debug and correct problems in existing site and add extra functionality.
• Developed some graphics and simple animations for sites being working on. Used Abode’s Photoshop and Corel Draw to create these images.
• Checked accounting company’s computers were year 2000 (Y2K) compliant.

Colorado Technical University Online

Gained a 4.0 GPA on all courses completed (e-Business Strategies and Leadership)