SUMMARY:

• Information Technology professional with over 15 years of combined experience in object - oriented software development, business process integration, and IT-focused business analysis and product management
• Full knowledge of and experience with the entire project management and software development lifecycle using various methods across different industries
• Ability to prioritize disconnected tasks, think unconventionally, and be detail-oriented while designing and implementing cost and time effective solutions to complex problems
• Ability to quickly learn different technologies, methods, and processes, and be able to immediately implement new skills in to work products
• Significant experience with Microsoft technologies and within Microsoft-centric enterprise environments
• Demonstrates strong communication skills and an ability to mollify stressful and difficult situations

PROFESSIONAL EXPERIENCE:

Confidential - Hilliard, OH

Owner, Senior IT Consultant / Product Owner

Responsibilities:

• Consult for small-to-medium business (SMB) clients:
• Business process analysis (BPA) services
• Learn and map current state of business process and software application flows
• Identify areas on flow chart to eliminate or gain efficiencies
• Compute impact and potential return on investment (ROI)
• Upon approval by client, execute tasks
• Marketing strategy analysis services
• Produce and review market research data
• Break data into market segments and determine optimal market segment(s) for specific client
• Compute the cost and potential ROI of various marketing tactics
• Methods included print, events, branded products/swag, digital (online video), website/SEO, visual (signs, billboards, TV), and vocal (radio)
• Upon approval by client, execute tasks
• Review available analytic data to determine and visualize the result of each campaign
• Technology services
• Design & develop new, extend existing, and administer public-facing web sites
• Design & develop new, extend existing, and support internal business software solutions
• Ad-hoc general break-fix and troubleshooting for computers and peripherals
• Past Projects:
• Producing and mailing a 15,000+ postcard campaign for a health insurance broker utilizing a mailing list built using publicly available data to target specific market segments, creating over $25,000 in new business within six months
• Business process flow modifications and software automation for a health insurance broker, reducing time spent on specific daily and weekly processes by over 60%
• Business software automation for an ultrasound imaging provider, reducing administrative time spent on every client by over 75%
• Business software creation and automation for a medical doctor, reducing administrative time spent weekly on Accounts Payables & Receivables by over 40%
• Consult for legal document management (DMS) and case management (CMS) software implementations
• Product owner for Agile SCRUM development team responsible for five (5) custom software utilities designed to facilitate the document migration process
• Within Salesforce Classic and Lightning, create and modify reports, administer data objects, and perform ETL functions utilizing SSIS and the Data Loader
• Perform ETL functions for system data, files (documents & emails), and file metadata from and into legal DMS (iManage and NetDocuments) using a combination of out-of-the-box utilities (SQL SSIS; Excel; iManage CLLOAD and ASCII Importer; NetDocs Folder Import and Mass Import), custom ETL apps, SQL & Powershell scripts, and third-party migration tools (Litera Cloud Migrator)

Confidential - Marysville, OH

Technical Product Owner, Project Manager

Responsibilities:

• Managed a group tasked with centralizing and coordinating all project, accounting, resource, and scheduling information across all company business projects and utilizing various digital applications
• Environment consisted of a combination of the following digital applications and categories:
• Third-party software - Microsoft Excel, Access, Project, SharePoint
• ERP - Oracle e-Business Suite, SAP ECC
• SaaS - Smartsheet, Salesforce Lightning
• Custom web apps - ASP.NET MVC, Azure services, on-premises Angular
• Custom desktop software - .NET (Forms, WPF, Console, DLLs, and Services apps), Powershell scripts
• Custom mobile apps - Android
• Microservices - .NET framework middleware, Azure REST APIs
• Data analytics - Tableau, Excel, Smartsheet, SSRS, Power BI, Snowflake
• Workflow Automation - SSIS, Smartsheet, Power Automate, UiPath RPA
• Databases - Oracle, SAP, SQL Server, Azure SQL, Access, Project
• Development code revision control systems - TortoiseSVN, Azure Repos
• Organized, prioritized, and maintained detailed product backlog and roadmap in Jira across all custom software, third-party software, and reporting tools utilized by suite
• Continually gathered feedback from various disparate stakeholder groups via surveys and direct interviews in order to understand and catalogue the voice of the customer,
• Facilitated joint application design (JAD) sessions for new features and applications, created wireframes and user interface (UI) prototypes for stakeholder feedback of user experience (UX), and composed business requirement documents (BRDs) and actionable user stories after the sessions were complete
• Implemented Agile SCRUM framework to accelerate early and often delivery of bug-free features, and conducted bi-weekly sprint planning, reviews, and retrospectives, as well as daily stand-ups
• Organized and conducted design sessions for new products and features, striving for the creation of minimum viable products (MVP) and features (MVF) while keeping in mind the future ability to scale after rotating through the Plan, Do, Check, Act (PDCA) cycle
• Directly developed and maintained business reports and Key Performance Indicator (KPI) dashboards in Tableau, Smartsheet, Microsoft Excel, Microsoft SSRS, and PowerBI
• Coordinated user acceptance testing (UAT), pilot testing groups, and wide releases for new products, and crafted internal stakeholder communications for each release
• Created an overall activity accounting forecast for each fiscal year, and developed a cost-benefit analysis for larger software development activities, with build-vs-buy comparisons for each activity
• Architected, documented (via Swagger), and tested (via complex test suites in Postman) microservices and RESTful Application Programming Interfaces (APIs) in JSON format to facilitate the transfer of data between previously disconnected applications with separate and specific functions
• Designed and conducted A/B tests within software and harnessed resulting data for future development
• Coordinated the creation and maintenance of manuals for the custom apps in the software suite
• Maintained product release logs by appending user stories upon the release of each new product version
• Evangelized the custom software suite’s features, efficiencies gained, and future potential to interested company individual employees and groups
• Provided as-needed technical and customer support for software and reporting troubleshooting
• Past Projects:
• ASP.NET web app for vendors on Time & Material contracts to input and handle time, material, and travel information for each of their employees working on union-style rates on any shift at any of 10 sites within US and Canada
• App was initially hosted internally on local server, but was later migrated to a private Azure server
• Android app was created to allow for direct and timely entry by on-site foremen
• Added validated digital signatures to completed PDF timesheets via iText add-in
• Microservices using .NET Core to allow for data transmission between software systems via REST API calls in JSON format
• Windows console apps to shuttle data between software systems
• Project WBS and schedule data to/from sheets across 50+ workspaces within Smartsheet
• Project WBS and schedule data to/from Microsoft Excel & Project files used by resource managers
• Project, WBS, financial, and procurement data to/from Oracle eBS and SAP ECC & Ariba
• Project templates (sheets, reports, and dashboards tracking activity schedules for projects) creation within Smartsheet to be utilized by Control Center
• Windows service to track internal creation, modification, and validation of engineering drawings and automate release process of drawings once fully approved to hand off to plants and vendors
• A separate ASP.NET web app displayed the status of all tasks across all projects, with filtering capabilities and direct data entry to update estimate completion dates
• Angular web app written in TypeScript to allow for resource managers to assign resource estimates to activities for project tasks
• Windows WPF app to catalogue project information, creation and modification of project WBS, and creation and modification of project quotes
• Windows WPF app for management of overall plant equipment list, which is then utilized as the initial WBS for each new project
• ASP.NET web app for creation, management, and approval of project change orders
• Windows WPF app to catalogue and automate workflows for vendor procurement legal agreements
• Salesforce environment to track vendor and plant assignment and communication across projects
• Windows WPF app for management of equipment cost for project quotes (updated yearly), and ability to assign different templates to project quotes depending on external variables (Yen exchange rate, vendor quotes, project delays, etc.)
• C# WinForms app migration to an ASP.NET app hosted on Azure private cloud and controlled via DevOps using Boards, Pipelines orchestrating CI/CD & using Powershell scripts, Repos for code repository, Artifacts for code packages, and Test Plans for manual, automated, and UAT test scripts
• Analyzed and modeled current business, systems, and project-flow processes inside and across business units within business division
• Created and maintained an accurate picture of workflows and technical requirements fulfilled by existing software solutions, utilizing Microsoft Visio and PowerPoint for documentation
• Subject Matter Expert for enterprise-wide implementation projects, including:
• Migration from Oracle eBusiness Suite to SAP
• Implementation of Kronos timekeeping and workforce management system
• Responsible for record retention activities and management within division

Confidential - Marysville, OH

Project Manager, Business Analyst

Responsibilities:

• Managed Confidential ’s Oracle eBusiness Suite (ERP system) major-version upgrade implementation (11i to R12.1)
• Upgrade encompassed Finance (AR, AP, GL, CM, FA), Procurement / Supply Chain (Purchasing / Inventory), Projects, HR, Quality, and Reporting modules, as well as custom ApEx extensions
• Led Projects, Reporting, & HR modules, in addition to PM responsibilities
• Elicited project requirements from all levels of company management and all separate functional groups
• Created & maintained a RACI chart to coordinate all communications with all project stakeholders
• Created & maintained the project schedule, built upon the requirements obtained and upgrades required
• Compiled, received approval for, and managed a project budget of over $2 million, which included cost of internal stakeholder and external Subject Matter Expert labor, Oracle and COTS user licenses, and computer hardware
• Sought for, interviewed, and selected suppliers to obtain software & technical / functional resources that would facilitate the migration
• Elicited a “pain point wish list” after interviewing each functional group to highlight features to implement or issues to resolve in the project, then built, prioritized, and maintained a backlog with those items
• Coordinated resources across all functional groups at Confidential for three rounds of validation testing encompassing all business pillars in the project, and created plans & led sessions for each round of testing
• Prepared and delivered project evaluation presentations to company executives, following the established Honda “J-Flow” project structure (internal Waterfall-style project management method for IT projects)
• Coordinated the creation of new and update of existing documentation
• Crafted company-wide communications regarding system upgrade, and continually produced budgetary and schedule status reports targeting company executive and senior management
• Project was executed completing all project requirements, on time and under budget, and with zero internal business disruption and zero disruptions to suppliers

Confidential - Marysville, OH

Business Analyst

Responsibilities:

• Responsible for local implementation of Honda North America projects, including:
• Internet Explorer 11 upgrade
• Windows OS major version upgrades (XP to 7, and 7 to 10)
• Microsoft System Center Configuration Manager 2013 upgrade
• All pillars (Outlook, Skype/Teams, Office apps, Yammer) of the Microsoft Office 365 implementation
• Migration from SmartCard to RSA SecurID token for off-site VPN access
• North American HondaWeb (built upon Microsoft Sharepoint) intranet implementation
• ServiceNow ITSM implementation for IT incident and service requests
• Created, extended, and maintained business reports and stored procedures for the following environments:
• Oracle e-Business Suite (financials, HR, projects, and procurement / supply chain) written in PL/SQL
• Microsoft SCCM 2013 for application and security patch delivery
• Asset management software for software licenses and computer hardware
• Financial reports in Microsoft Excel, using pivot tables, lookups, data connections, VBA, and Power Query
• Product owner of Confidential ’s custom web apps, including all HondaWeb SharePoint sites
• Designed and implemented software system to track the lifecycle for IT assets across the entire company
• System was a combination of extending an existing third-party IT asset tracking web app and integrating data pulled from external sources (IT leasing vendor, UPS, FedEx, & Dell) via RESTful API calls in JSON format and written in C#, with all stored in a local SQL Server database

Confidential - Marysville, OH

Business Analyst, Programmer

Responsibilities:

• Inherited development of, and assisted in implementation for, a company-wide suite of custom .NET C# desktop and web software applications that were designed to track all project, accounting, and schedule information for and phases of company projects
• Assumed role as Application Packaging Engineer to create new and modify existing installation packages for software used in the company, completing, on average, over two new software installation packages per week
• Provided technical support and business analysis for the migration from Microsoft Systems Management Server 2003 to Microsoft System Center Configuration Manager (SCCM) 2007
• Developed software utilities for use in the company’s migration from Microsoft Windows XP to Windows 7
• Extended reporting features and utilization of asset management software used by company (Lansweeper)
• Assisted in the design and handled the development and implementation of Confidential ’s remodeled SharePoint site
• Provided as-needed technical and customer support for software and reporting troubleshooting

Confidential - Columbus, OH

Software Developer, IT Support

Responsibilities:

• Worked extensively with VBA development in MS Access 2003, 2007, and 2010 to correct issues with and add requested enhancements into 10+ previously existing applications designed to increase efficiency in the business operations of construction firms
• Aided in the user interface design and functionality implementation of a not-yet-released ASP.net/C# web application using Visual Studio TFS to track construction bonds
• Provided Windows OS, MS Office, and general IT support for clients remotely via screen-sharing sessions

Confidential - Plantation, FL

Junior Software Developer

Responsibilities:

• Responsible for designing, developing, testing/debugging, deploying, and supporting over 20 custom apps:
• 15+ third-party .NET Framework applications that integrated with Autonomy’s iManage document management system to enhance the client’s user experience and cut down on redundant operations
• 5+ standalone applications in C# and VB.net utilizing the MS Office development API, communicating with data stored in SQL databases, and accessing features in Windows to satisfy urgent client needs
• Provided extensive technical support for clients with immediate issues regarding Autonomy iManage, Windows OS, and Microsoft Office
• Was considered the company’s “SWAT Team”. Routinely handed problems with unknown causes, swiftly and calmly discerning the root cause of an issue, and correcting issues for clients.
• Worked within Microsoft SQL Management Studio (SSMS) to set up and maintain servers, create relational databases for new and existing applications, and access and manipulate data in existing databases via queries, stored procedures, functions, and triggers
• Worked within Microsoft Access to import data from Excel spreadsheets and created forms to display and edit the data, then transitioned those Access forms into a stand-alone .NET application that communicated with the data in a database on a SQL server
• Helped resolve the most cost-efficient solution to the company’s hardware needs and oversaw maintenance of servers and development computers

Confidential - Paramus, NJ

Systems Coordinator/Analyst

Responsibilities:

• Implemented and supported a Linux internet portal for parents to observe their children during the day
• Designed, developed, implemented, and supported an employee time tracking application.
• Helped design and maintain the company’s website using HTML in Adobe Dreamweaver
• Supported existing computer network and daycare business operations application