SUMMARY

• I am a multi - talented personable individual with 20+ years' experience in database administration, development, and application support.
• My professional experience includes object-oriented programming using VB.NET, and C#. I have extensive administration and troubleshooting experience with Microsoft applications to include Active Directory, IIS, Windows Office, SharePoint, and Windows Servers. Additional areas of specialty include business functional areas around CRM, PLM, ERP, and Lean Methodologies.
• Build synergy with approachable technology to address repetitive and non-value added processes
• Tear down silos of information and facilitate communication and collaboration
• Treat IT as revenue generating department, a value added investment
• Users are our clients, and should be treated as a customer
• Deliver unto our clients the required training and encouragement so that they may be successful at their job

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst Developer

Responsibilities:

• My current role is responsible for data analytics and development. I produce data driven metrics and KPI’s to help facilitate critical business decisions.
• I leverage several reporting tools to help deliver artifacts, both strategic and tactical. Other responsibilities also include database development, SharePoint development and administration, as well as COGNOS, SSRS, and Tableau which leverages Snowflake on Azure.
• Worked with business to determine SLA requirements for data replication and reporting using a combination of log shipping and ETL tools to load data into Snowflake and local SSAS data warehouse models to accommodate business requirements.
• Worked with Business stake holders to align business requirements with technical solutions.
• Significantly improved project intake and change management processes. Created process controls around IT project intake and change control processes leveraging SharePoint 2010 foundation. Leveraged Content Types, Site columns, and workflows to produce a consistent and reproducible project site.
• Streamlined the organizations Safety and compliance reporting using SharePoint
• Improved Engineering and Production opportunities by transitioning processes from excel, word documents, and file folders into an integrated SharePoint application.
• Created an EDI database that allowed the company to process real-time EDI orders and invoice them.
• Transitioned SQL Servers from 2008 to 2016 with road maps to upgrade to 2019.
• Improve ETL processes by redeveloping SSIS packages which process nightly processing from 2.5 hours to less than 10 minutes.

Confidential

Senior Technical Advisor

Responsibilities:

• I was brought on to start up a new division within an organization that’s primary purpose is consulting services. I created standards and methodologies for the development of SharePoint and Project Server applications.
• Product Development
• Create supporting collateral and artifacts to support product development.
• Standardized development methodologies (Using Agile/Waterfall development methodologies).
• Created a hosted development environment for collaboration with offshore development resources.
• Created Weekly Sprints communication portals to help track work for offshore development.
• Customer Management
• Supported and maintained relationships with the company’s largest customer. Acted as account manager and developer resource for many of the company’s strategic customers.
• Worked directly with stakeholders and end users to ensure adequate requirements are established and that training is well defined for consumers of the applications we develop.
• Internal Support
• Improved internal processes by leveraging existing tools. Built out SharePoint workflows, custom applications, and integration with other systems to reduce overhead and inefficiencies.
• Led a joint effort with Marketing to implement Dynamics CRM in the Cloud. Gathered requirements from each stakeholder and executed what we could of those into the CRM System.

Confidential

Programmer Analyst/Business Analyst/Database Administrator/Developer

Responsibilities:

• Partner with organization to map organizational requirements and processes into SalesForce.com
• Migrate existing data from Sales Logic, Excel Spreadsheets, Outlook Contacts, and ERP into Salesforce.
• Work with executive staff to understand expected outputs for decision making and process alignment.
• Customize Salesforce with new Objects, Triggers, Reports and Dashboards.
• Align permissions and roles with process requirements.
• Introduce SharePoint for document management, process control, and task automation
• Introduced document management and revision control.
• Created and trained personnel for use of SharePoint in project management and workflow automation.
• Integrated with on premise ERP through a SQL gateway into a Progress database.
• Database Development and Management
• Consolidated 6 database servers into 2, while upgrading from SQL 2000 and SQL 2005 to SQL 2012.
• Created security structure based upon AD Groups and central administration of user accounts.
• Integrate a legacy ERP system with update-to-date technologies such as SQL, SSRS, & SharePoint (BDC modelling).
• Real-time data retrieval from the ERP system for inventory accuracy, on-hand quantity, and automated workflow for replenishment requests.
• Automate Supply Chain logistics with automated tools using SharePoint and Monitors positioned around the campus to alert buyers, warehouse personnel, & trade compliance
• Develop processes to manage SOX compliance
• Worked with outside consultant to securely automate SOX automation and reporting output.
• Processed files from UNIX into SQL using SSIS
• Report subscriptions using SSRS of the daily output for auditing.
• Created Calibration Database as a result of a ISO audit
• Worked with Quality and equipment owners to develop an ASP.NET application to manage calibration schedules,

Confidential

Systems Analyst/Database Administrator/SharePoint Analyst/Developer

Responsibilities:

• Analyze requirements and develop solutions for a fast-paced and growing manufacturing company. I have created and deployed simple and powerful solutions to provide necessary data to the business decision makers.
• Additional responsibilities include SharePoint and Project Server development and administration, ASPNET, and Win Forms Development. Define and implement business requirements for effective CRM, ERP, Quality and Project management processes.
• Implemented internal processes to increase collaboration and greater efficiency through the use of the following tools:
• SharePoint 2003 through 2016: initial implementation and version upgrades
• Project Server
• Custom PSI Workflows
• SSRS Integrated Reporting
• Template workflow: Project and Site Templates
• Help Desk Ticketing Application
• Defect Tracking: Custom built to business requirements
• Work Order Completions: Custom built to business requirements
• Real-time reporting for Gemba analysis and production line efficiency
• Developed solutions for automated barcoding
• Automated integration between disparate systems
• Simplified business processes where ever possible to increase efficiency through minimal user interaction. Specific examples include:
• Reduced the reliance on “mini applications” and established robust and collaborative processes.
• Consolidate disparate data by means of T-SQL, SSRS, SSAS, and other database technologies to reduce the amount of effort to collect data.
• Leveraged ASPNET, Win Forms, XML, and XLST technologies to deliver simplified solutions to manufacturing and supply chain challenges.
• Significantly improved access to data for quicker decision making through a variety of tools to assist with the following challenges:
• On Time Delivery
• Inventory turns
• Quality metrics and reporting
• Financial Reporting
• MRP Forecasting and Demand Analysis
• Project Management
• Supply Chain Automation
• Successful Project Manager for a number of critical business and technical initiatives:
• Project Server Implementation, Training, and Customization
• Shop floor execution and automation
• Product Quality and efficiency
• Financial Reporting
• Supply Chain reporting and automation
• Implement and Define processes for tighter integration of processes and effective collaboration.
• Support ERP/PLM/CRM processes through strategic and controlled phases.
• Leveraged better utilization of ERP best practices to reduce inventory.
• Built extensive reporting infrastructure with the collaborative efforts of the executive team.
• Automated Lead Imports for enhanced marketing strategies.
• Created adapter to integrate hosted PLM system with a local ERP system.
• Train and provide documentation for new processes.
• Reinforce new concepts and technology with hands-on training and thorough documentation.