Currently lead a team of developers in three countries around the world. Build and support custom enterprise reporting solutions. Gather requirements from uses. Architect solutions with multiple departments. Oversee and assist in the development of solutions. Perform HR related activities, performance reviews, merit increases, promotions, etc...Designed data structure in Hadoop, using Impala and Hive, to replace SQL Server data mart. Replicated over 100 database objects using Unix shell scripts with Impala and Hive queries to structure the data.Created MicroStrategy infrastructure, attributes, metrics, filters and reports, to enable dash-boarding and reporting. Created more than 20 attributes, over 50 metrics, about 12 dashboards and about 30 reports.

Led a team of developers in three countries around the world. Built and supported custom applications and reporting tools using SQL Server, Reporting Services and .NET. Oversaw the acquisition of infrastructure, SQL and reporting servers, physical and virtual. Recommended technologies like JAMs job scheduling and .NET for InControl application. Handled HR related activities.Migrated several applications from .NET web forms to MVC, leveraging jQuery and bootstrap.Designed data structures and load process for InControl application. InControl won Gartner's top high-tech manufacturing supply chain innovation award in 2016. (https://www.gartner.com/newsroom/id/3319617)

Managed a team of developers based in the US. Developed custom supply chain solutions using SQL, .NET, Access and Excel.Designed an internal web platform using .NET and Reporting Services. Provided access to more than 50 reports and 20 tools to thousands of users around the world.Stabilized SQL Serve data mart used for analysis using tools like SQL Server Integration Services and JAMS Scheduler for job scheduling. Reduced load errors and support to an hour or less per week from a couple hours per day.

Supported and developed custom tools using visual basic for applications, Excel and Access. Built a tool to track freight rates and historical expense for Logistics using SQL Server, MS Access and Reporting Services. Created a reporting dashboard uing SQL Server Reporting Services with one master dashboard and about 12 supporting reports allowing users to drill to detailed data.

Positions Held: Systems Analyst, Manager - Supply chain, Sr. Manager - Supply ChainDeveloped custom solutions to improve efficiency and reporting accuracy. Provided training and guidance to the team. Handled general HR activities.Designed an Access application to manage third party logistics, 3PL, inventory tracking and billing.Orchestrated the design and development of a web based product research and issue tracking application used to report product availability issues to purchasing analysts.Optimized countless stored procedures written by analysts and programmers alike. Reduced many from hours to minutes.Built an Access application for purchasing to provide an unprecedented view into inventory positions and potential issues.

- Managed a team of developers responsible for data analysis, reporting and solution development.- Built .NET solutions for resaerching product issues, adhoc reporting, and maintaining data in SQL Server databases.- Designed applications in Access and Excel ranging from Payroll tracking to Inventory Tracking- Maintained over 3TB of data in three SQL Servers.

Led the development of a production planning application for PBG, including requirements gathering, communication with internal and external developers, testing and issue tracking.

- Developed tool for recording journal entries, eliminating data entry- Designed a system for balancing AR to GL and recording entries, reducing required hours from 48 per week to 8 per week.- Created tools to assist accounting in LIFO, inventory reconciliations, bank reconciliations, etc...