SUMMARY:

• Entrepreneurial technology professional with over 15 years of experience designing, developing, and supporting complex distributed business applications for Confidential 500 companies.
• Extensive experience as developer and technical lead with the full software development life cycle (Agile and waterfall) from conception to post - implementation, including functional and technical analysis and design; client/server development; unit, system, and user acceptance tests; and application support.
• Projects involved software development; data mapping, modeling, and migration (SQL ETL); systems integration; data research and analysis; process automation; technical documentation; database administration tasks; and production defect identification and resolution.
• Mentored employees, managed offshore teams, and provided knowledge transfer to both client associates and contractors.
• Excellent communication skills, team oriented, organized, reliable, highly motivated, quick learner.

TECHNICAL SKILLS:

Languages/Formats: PL/SQL, T-SQL, Java, ProC, shell scripting, VB, EDI, XSL/XML, JSON, ETL, Python

Platforms: J2EE, Windows 7/10, Windows Server, Linux, AIX, Ace/ISS45 retail POS systems

Databases: Oracle, SQL Server, MongoDB, MS Access

Methodologies: Agile, Kanban, Waterfall

Applications: Power BI, SSMS, SSIS, Visual Studio, Sterling MCFS, Eclipse, JUnit, PMD, SVN, Version 1, Jira, Quickbooks, JDA PMM, SessionM, ABO, Ace POS Sales Explorer, Category Analyzer

PROFESSIONAL EXPERIENCE

Confidential, Niwot, CO

Principal Software Engineer

Responsibilities:

• Designed, reviewed, and managed offshore development of SQL ETL process for data migration and automation of store, product, customer, and Ace/ISS45 POS history data loads into SessionM to implement a new customer loyalty and rewards program.
• Developed SQL ETL process to extract and format store, vendor, and product data for import into JDA PMM to enable perpetual inventory functionality. Identified data related problems for correction by merchant teams and coordinated testing and validation with JDA personnel.
• Designed, reviewed, and managed offshore development for custom web-based applications in AWS (Aurora) and created the associated automated SQL data extract processes. The first was a mobile application that provided hourly sales data to executive management. The second was a vendor portal allowing external vendors to submit online applications to become approved vendors, which provided a defined, quick, and streamlined procedure for approval by the merchant, legal, and finance teams.
• Developed and automated SQL based daily and weekly summarized POS reports and ETL processes for the operations, finance, and accounting teams for analysis and import into third party applications, including SmartConnect/Great Plains and Kronos.
• Analyzed, enhanced, and supported existing Visual Basic, C++, and DOS-based batch applications providing business critical functionality. Performed SQL Server DBA tasks related to data modeling, SQL performance improvements and optimization, database restoration, and data imports/exports.

Confidential, Broomfield, CO

Senior Software Engineer

Responsibilities:

• Migrated coupon functionality from IBM WCS to a custom coupon qualification service.
• Tasks included data mapping for request and response messages, test case identification, data setup in both SQL and NoSQL DBs, and QA support.
• Developed backup and restore scripts for MongoDB product and pricing collection data to prevent data errors during regression test execution.
• Designed and developed code and configurations for IBM Sterling Multi-Channel Fulfillment Solution (SMCFS) to provide buy online, pick up in store functionality to customers for orders placed online which reduced order abandonment from 10-12% to 5-7%, saving ~$2.5-3MM per year and to allow new carriers to ship vendor and fulfillment center orders to customers saving ~$1MM per month.
• Analyzed, designed, and developed code and configurations for an SMCFS solution to enable a new wholesaler to increase product selection via wrap and label and drop ship purchase orders and in-stock availability. Reviewed interface data mapping requirements for send and return messages in all affected systems, including wholesaler, gateway, enterprise service bus (ESB), and shared order management.
• Provided support covering data creation, order processing, and troubleshooting of environment issues for a custom application allowing third-party vendors to sell products through Confidential ’ e-commerce channels.
• Played primary role in implementing key functional components of Confidential ’ continuous delivery vision. P iloted, developed, and supported an automated unit test and code coverage process to improve efficiency and accuracy across the Shared Order Management System development organization. Debugged and enhanced stub modules and database tables/data to mimic live service functionality. Aided in optimization of test automation scripts reducing regression test execution from ten to four days.

Confidential, Lafayette, CO

Owner / President / Software Developer

Responsibilities:

• Designed and developed processes (Pro*C / SQL) between two Confidential 500 companies post-merger to integrate vendor, accounts payable, order registration, and accounts receivable functionality for legacy systems and associated data. Coordinated with legacy order management system (OMS) and QM/QA resources to ensure successful product delivery.
• Subject matter expert for all legacy system OMS domains, performing all maintenance and development support for integration and eventual retirement, including creation of SQL based data correction and clean-up processes.
• Served as analyst and developer for two Confidential 500 companies on all assigned projects. Projects included functional and technical enhancements (Pro*C / SQL) for order entry, customer maintenance, supply chain management, and financial systems as well as fixing production issues.
• Managed all aspects of a multi-state business including contract negotiation, accounting, payroll, employee recruitment and management, insurance and tax obligations, invoicing, and collections.