Daniel Mcewan Email & Phone Number

Austin, Texas, United States

-Developer Lead• Responsibilitieso Mentor application teams on proven development standards and practiceso Support backlog grooming for upcoming sprintso Provide code reviews for backend development o Collaborate across teams to improve enterprise data quality o Update database architecture and diagrams o Develop Oracle pl/SQL for back-end batch processing as well as data integrationo Develop Linux scripts to support ETL processeso Develop DataStage jobs to support ETL processeso Write complex SQL on Oracle, Postgres, and Sparko Improving performance by updating SQL or database objects• Projectso Supported process changes to development life cycle to improve on-time delivery and quality. o Converted Oracle PL/SQL to PL/pgSQL which included migrating objects from Oracle to Postgreso Developed major source system changes that improved performance and maintainability o Migrated over 100 window scripts to Linuxo Setup and Migrated utility server from OEL to Ubuntuo Developed and maintained a multimillion-dollar billing process for our suppliers • Tools o Visio, Toad for Oracle, DBeaver, Autosys, Tidal, DataStage, TFS, ADO, Hive, Hue, S3 Storage, PuTTY, SourceTree

• Responsibilitieso Led design for our dynamic pricing engine within the Tolling producto Collaborate across business functions to setup roadway configurations per customero Align pricing engine design with other functions of the tolling roadway producto Read contracts to procure customer requirementso Meet with customers to provide demos for their specific custom producto Develop complex SQL for end user reportso Developed Oracle pl/SQL to support our backend data processingo Create technical design documents to support updates to database or data flow processes• Projectso Made major improvements to our dataflow process from getting data off the road, to generating a price and finally sending that price to a sign on the roadway. The improvements required a major change in our data model and data flow. The enhancements included improved reporting ability, decoupling data for different customer features, and improved maintainability. This provided a major reduction to the cost to current and future projects purchasing this product.o Restructured reports to reduce complexity. Reports had too many fields that sometimes wouldn’t make sense together. The restructure allowed the customer to make better sense of the report with improved performance. • Toolso Oracle Apex, PL/SQL Developer, PuTTY, GitLab, Visio, Draw.io, SourceTree

Gm Arizona It Innovation Center

-Database DeveloperDevelop using best Oracle techniques to deliver a robust, reliable and high performance database. Code back end batch processing as well as data integration. Support business and operations by researching issues and providing feedback. Support requirements gathering as well as QA testing efforts. Create technical and operational support documents.• Codeo Code PL/SQL using Packages, Functions, Procedures and Complex SQL. o Code JILL files for The AutoSys batch scheduling tool. o Code Linux scripts used in our data integration process.• Tools o Oracle Database 12c,Toad for Oracle, SQL PLUS, SQL*Loader, Autosys, Datastage, Visio, TortoiseSVN, Team Foundation Server, PuTTY

Salt Lke City, Utah

Operation Specialist IIIManage treasury billing for 170,000 business accounts across five banks. Monitor 7-10 thousandincoming paying checks for possible fraud. Balance and monitor six Zions official check accounts worthmore than a half a billion dollars. Reconcile 21 business accounts and send monthly reports to endbusiness customers.o System Analysis: provided requirements for the retail teller system to give more accurateinformation for our treasury billing system; resulting in cost savings to our clients.o Created a solution for the small business exchange process that saved annual revenue of$30K.-Innovation Committee MemberAssisted in creating an innovation program for over 1500 employees in Treasury and Bank Operationsfor the technology division, and led the launching of this innovation program in the Treasury Servicesgroup.-Retail SupervisorResponsible for approving high risk transactions, which protected our customers and bank from losses.Trained new employees on banking procedures and tasks. Provided a high level of customer servicewhile processing transactions, and informing clients of our products and services.

Business Information Systems

Associate Of General Studies, General Studies