Mark Hare Email & Phone Number

Boston, Ma, Us

Complete redesign/re-platform of compliance document management application. Replaced existing on-premise ETL ingestion process taking 12 hours with AWS Lambda/Python/Postgres parallel processing taking less than 1 hour thereby reducing AWS cost and downtime. Responsibilities:• Perform baseline performance testing on AWS clustered db instances to determine partitioning and parallel processing capabilities working closely with DBA• Migrations from Postgres 9.6, 10.6, to 11.6 to leverage Postgres true partitioning• Restructure Data model to increase performance and reduced table size and row width by 25%• Convert MySQL to Postgres 11.6 using SQL functions to generate converted db on AWS cluster• Work with UX/UI to improve workflow, performance and reduce db calls and rows returned• Redesign db functions for UI APIs to increase performanceInvestigated data inaccuracies and determined root cause on supply chain analytics application spanning multiple ERPs. Recommended, implemented technical solutions and mentored local and offshore team on best practices. Responsibilities:• Developed PostgreSQL code changes for ETL ingestion scripts pulling data from multiple data lakes storing Oracle and SAP ERP currency data. Corrected discrepancies in currency exchange rate queries and provided performance tuning enhancements to those queries.• Redesigned/refactored error prone CRUD operations for updating ERP data with actions and comments.• Postgres database table redesign for performance tuning.• Developed one-time conversion functions for new table design.• Modified back end Node scripts to add new models/routes and changed Sequelize and javascript logic accordingly. • Provided technical leadership to offshore pod for cross-module integration in preparation for ERP writeback functionality. • Developed extensive test scenarios for validating data and code behavior for all the above.

Reston, Virginia, Us

Responsibilities:• Developed Java code changes for Monroney label changes for 2018 new vehicle launches.• Developed Java code and Oracle changes for EPA compliance related to VW clean diesel lawsuit.• Created new mini EPA labels for TDI vehicles using Java and XML for EPA compliance.• Developed and monitored new processes for recreating over 20,000 labels with negotiated EPA data. • Developed US Customs Invoice utility for vehicles produced at new Audi plant in Mexico shipping vehicles to the US. Application developed in Java Springboot and H2 in-memory database to automate commercial invoices sent to US Customs.• Knowledge transfer to production support team of all of the above.• Leveraged Java skills to analyze, code, test and deploy changes to other Java applications.Environment: Java, Eclipse, Clearcase, SVN, Oracle12c, TOAD, WINSCP, Putty, UNIX Shell Scripting, Perl, TWS, Cypress Content Management, Jira.

Responsibilities:• Developed performance enhancements to MS SQL Server stored procedures and SSIS packages. • Analyzed current processing and determined where parallel processing could be leveraged.• Coded new SSIS packages to implement the parallel ETL processing.• Implemented new MS SQL Server and database to improve performance.• Code/test/deployed new SSIS packages and stored procedures to maintain database integrity between new server and existing server.• Code/test/deployed new and modified Netezza stored procedures to load MS SQL server campaign data into DW.• Launched new MS SQL Server processes in production along with Tidal scheduling changes and improved big data performance metrics by 50%.Environment: SQL Server Mgmt Studio, Visual Studio SSIS, MS SQL Server 2008 -2014, T-SQL, Netezza, Cisco Tidal Enterprise Scheduler, Jira.

Detroit, Mi, Us

Responsibilities:• Gathered business requirements and created structured systems design documents using appropriate design methodologies in close cooperation with business customers.• Created business process maps, swimlanes, business rules, use cases and user stories in BluePrint.• Worked with scrum team in Agile environment using VersionOne with 3 week sprints.• Data mining and creation of test data executing SQL queries against Information Warehouse and loading into OTS application.• Configuring OTS application to support business processing.• Determining impact of proposed changes to various downstream systems.Environment: MS SQL Server 2012, T-SQL, Blueprint, VersionOne.

Dearborn, Michigan, Us

Client: Ford Motor Company Oracle/Teradata/J2EE ConsultantProviding development and business analysis services in Finished Vehicle Accounting project in the areas of:• Translating business requirements into structured systems design using appropriate design methodologies in close cooperation with Business Analysts and business customers.• Subject matter expert and Lead developer for 3 applications consisting of:o 143 Oracle packageso 27 AutoSys boxeso 107 UNIX scriptso 80 J2EE screenso 6 Excel Templates using Visual Basic• Web Development. IBM RSA 9.0 and IBM WSAD 8.0 tools for J2EE development.• Participate in Oracle logical and physical data modeling.• Spec/design/code/test/implement Oracle APIs in Oracle 8i – 11g.• Design/code/test Unix shell and korn shell scripts to execute jobs in Autosys environment.• Design/code Teradata stored procedures invoked from J2EE screens.• Design/code Excel Templates using VB script/Oracle async process/MQSeries for mass updates and mass downloads providing cost savings in lieu of new J2EE screens.• Production support of all above.• Responsible for logical design deliverables using the Zachman Framework methodology. Deliverables included: o Oracle Designer Function Hierarchy diagrams, o corresponding CRUD matrices and business rules; o logical screen design documents and process flows.• Design/code/test/implement intranet application using ASP/JavaScript/VBScript/MS IIS.• Design/code/test/implement business rules in Microsoft COM/Visual Basic.• Led object integration/reuse of COM objects communicating with Oracle and Web/ASP.• Developed business scenarios, test strategies and test plans using Mercury TestDirector.

Southfield, Mi, Us

Provided consulting services in the areas of:• Y2K remediation• Enhancement of Web application using JavaScript, FrontPage, and Powerbuilder 6.5.• Implemented EDI interfaces to Powerbuilder online application for purchase order processing and automated invoicing, increased productivity of processing purchase orders from 80/day/salesperon to 60/hour/salesperson. Architectural review of current state – responsible for increasing productivity of team by reducing testing time.

• Technical Lead of Powerbuilder 5.0/Oracle project for Volkswagen Credit Inc.• Provided mentoring in Powerbuilder 5.0, code reuse and standards to staff of four developers.• Main customer contact for system requests, managed project workload and customer expectations.• Technical Lead of Powerbuilder 4.0/Oracle project for Volkswagen Customer Relations department. Responsible for prototyping and design of Powerbuilder and Oracle data modeling.• Participated in recruiting process for hiring of Powerbuilder programmers.• Designed, coded, implemented and maintained first Powerbuilder MDI application at Volkswagen of America for Customer Prospecting. Powerbuilder 3.0a/Oracle, prototyping and data modeling.• Coded, tested, implemented Cost Estimating system for Excello Corporation. Powerbuilder 3.0a/Oracle ported from Watcom.• Designed, coded, implemented and maintained Parts Ordering System for Volkswagen of America in IMS/DB2/COBOL2.• Revamped forecasting system to more closely forecast demand.• Initiated and implemented first LAN based GUI application at VW, FoxPro/COBOL2.

Dearborn, Mi, Us

• COBOL2, IMS/DB2

West Hartford, Us

• Completed SED program; COBOL, IMS/DB2