SUMMARY

• Lead developer, IT Manager. Hard - working self-starter. Team player. Project management and lead developer experience on enterprise ETL and architecture projects.
• Experienced with applying industry-standard software development best practices to solve real-world business problems, increase profitability, and reduce overhead.

PROFESSIONAL EXPERIENCE

Confidential - Melvindale, MI

Applications Architect

Responsibilities:

• Developed the application from requirements
• Utilized feedback from the organization to make improvements and changes, as well as add features that were not present in the original version
• Deployed application to our local infrastructure
• Created video training materials and created training courses on Litmos, our internal learning management system
• Designed, developed, and implemented an interactive arcade-style game for a trade show that showcased some of our company s business processes in an entertaining way
• Reverse engineered and documented old Dell Boomi EDI orchestrations as part of an initiative to port all EDI orchestrations to the RAMP Systems Interchange platform
• Developed Talend ETL orchestrations to perform data quality, analysis, and import transformations on customer data
• Assisted in user support and helpdesk activities
• Set up a new onsite development server
• Built shipping packing slip reports with Jaspersoft iReport
• Implemented a full - stack framework for documentation, project management, and time / cost tracking
• Introduced the company to Atlassian s suite of products, including JIRA Software, JIRA Service Desk, Crucible, Bitbucket, and Confluence
• Demonstrated value-add and utility of products
• Installed and maintained all product instances
• Migrated all Service Desk-related work and assets from Zendesk to JIRA Service Desk with no interruption of service to users
• Project management, software development, communications management, and leadership on multiple fulfillment projects
• Member of EPIC, an exclusive internal organization for future leadership development. First new member added in over four years.
• Managed relationship between Confidential and Secure-24, our datacenter and IaaS provider
• Strategy, planning, and coordination for projects
• Follow-up and accountability on SLA misses
• Currently leading and organizing development on data warehousing initiative
• Selected tools and defined processes for research, documentation, and development
• Primary contact with contractors from Developrise
• Overseeing the project in its current research, analysis, and documentation phase
• Designed, developed, implemented, and documented a new version of the company s proprietary goal-tracking and progress management tool, Goaltender

Confidential

ETL Architect / Lead Developer

Responsibilities:

• Assisted in the design, development, and implementation of a Data Vault model data warehouse for nightly ETLs from a PartyRole model data warehouse to optimize the data for daily and historical reporting.
• Built a fully dynamic nightly archival process for the Data Vault environment that archives expired records without needing to be changed to accommodate Data Vault table changes.
• Designed multiple re-useable Talend joblets for common tasks to ensure code reuse and codebase health.
• Built a dashboard to monitor nightly ETL loads from the Party Role data warehouse to the Data Vault data warehouse.
• Worked with DBA team to ensure ETL performance.
• Designed and implemented a scalable system for safely running client provided and required cross-process ETL executables.
• Performed weekend on-call duties as needed.
• Conceptualized, designed, and implemented a multi-tiered reporting output archival and reporting system that feeds a series of Tableau dashboards to provide business visibility into reporting extract accuracy and delivery timeliness - including an intranet webapp, several nightly ETL processes, and modifications to 100+ reporting extract generation jobs.
• The intranet webapp supports user authentication and custom roles assignment, and was part of a wider department-level initiative to centralize common reporting intelligence and configuration tasks, as well as provide a visual front-end for common business tasks.
• Developed a web-based interface for client-facing reporting associates to resend corrected contract reporting extracts.
• Developed dozens of inbound and outbound contract reporting data feeds that consumed and / or produced data in a variety of formats, including CSV, Microsoft Excel, and EDI
• Provided ongoing mentoring and training for all development and QA team members.

Confidential

ETL Developer / IT Management

Responsibilities:

• Promoted to an IT management role to lead a team of up to 25 on-site contractor resources.
• Internally promoted by client to a lead developer / architecture role.
• Wrote WPF application used by the entire Contract Reporting team to package, manage, and document release assets.
• Developed web application to generate SQL for use in report configuration in the future-state ETL effort, as well as provide insight into the status of each report across multiple environments (Dev, QA, Production, etc) to reduce time spent in development, QA, and troubleshooting.
• Designed common handling for future-state ETL effort.
• Subject matter expert in ETL best practices.

Confidential

Software Developer

Responsibilities:

• Assigned to a client in the pharmaceutical industry in a staff augmentation role on their reporting team.
• Built custom wiki solution with ASP.NET MVC and used it to document client-specific coding standards and practices.
• Wrote several web-based and command-line-based tools to automate portions of client-related standards compliance.
• Lead developer on a large project to integrate a third-party HR solution with a third-party online training solution to automatically enroll employees into training courses.
• Created T-SQL + SSIS / SSRS reports for status, dispense, and adherence for pharmaceuticals.
• Lead developer on a large project to commonize all filesystem and SFTP tasks for all SSIS-based reports.

Confidential

IT Analyst

Responsibilities:

• Part of a team responsible for the development and maintenance of an in-house Windows Forms-based business application.
• Worked extensively on a hybrid report generation engine in T-SQL.
• Developed T-SQL stored procedures and scripts.
• Was part of a project that involved integrating new Ingenico signature capture devices with our business application.
• Worked closely with upper management on various reporting dashboard projects.

Confidential

Systems Administrator

Responsibilities:

• Completely restructured networking and file-sharing, and set up local and remote backup. Set up UPS.
• Wrote Ruby and Bash scripts to parse, sort, and organize over 60gb of pictures and automated the process of uploading them to Amazon s S3 service.
• Completely restructured network, replaced the consumer-grade hardware with business-grade hardware.
• Instituted a number of changes in company s day-to-day procedures to streamline business processes and maintain data integrity.
• Single-handedly moved entire IT infrastructure to a new location and migrated from an OSX Server setup to a new Windows Server 2008 R2 instance over a weekend.
• Day-to-day activities included user support, hardware maintenance and website development, database maintenance, and FileMaker development.
• Responsible for 100% of company s IT infrastructure.
• Junior developer on a two - person team that ported company s e-commerce site from Ruby on Rails to ASP.NET MVC3, using Visual Studio 2010, C#, nUnit, SQL Server 2008, Entity Framework, JavaScript, jQuery, and the Razor view engine, hosted on Amazon EC2.
• Responsible for developing a system to automatically export data from the company s internal FileMaker CRM application to be uploaded to the web server and imported to the site s SQL Server database.
• Upgraded office from Windows XP to Windows 7 and replaced all user computers with custom-built machines.

Confidential

Consulting Owner

• Freelance technical consultant.
• Services provided have included building custom PCs; Windows and OSX troubleshooting and support; home and small-business networking; and spyware / virus removal and recovery.

TECHNICAL EXPERIENCE

• Software / Tools: / PlatformsProgramming Languages / FrameworksAmazon Web Services ASP.NET MVC3, MVC4, MVC5, MVC6
• Atlassian JIRA, Service Desk, Confluence, Crucible, Bitbucket Bash
• Debian Linux Batch
• Dell Boomi Bootstrap
• FileMaker Pro & FileMaker Server C#
• Git, SVN Dapper ORM
• Google Docs for Business / GSuite Entity Framework ORM
• Mac OSX 10.6 - macOS High Sierra haml
• Microsoft IIS 7, 8 HTML
• Microsoft SQL Server Management Studio 2008 R2, 2012 Java
• Microsoft Office 2000, 2003, 2007, 2010 JavaScript & jQuery
• Microsoft Windows 98, 2000, XP, Vista, 7, 8, 8.1, 10 Markdown
• Microsoft Windows Server 2003, 2008 & R2, 2012, 2016 MySQL
• Microsoft Visual Studio 2008 - 2017 Razor
• Network Automation AutoMate 7, 9 Ruby nUnit Rails
• RAMP Systems Interchange & Enterprise SQLite
• SME Server (Linux) T-SQL
• SSIS 2008, SSDT-BI 2012 Windows Forms
• SSRS Windows Presentation Foundation
• Sonatype Nexus
• Talend Data Integration Studio 5.6.1, 6.0.1, 6.3.1
• Ubuntu Linux & Ubuntu Server vim
• VMWare HorizonView / DaaS 5