Bill Grogg Email & Phone Number

o Manage all aspects of retail and wholesale operations in all countries outside Australia for the US-based subsidiary of an Australia-headquartered niche health products company.o Collaborate with corporate parent's senior leadership team to strategize international sales, marketing, business development, and logistics.

Salem, Oregon, Us

Public Utility CommissionInformation SystemsKey Achievements:o Designed and developed a cutting-edge, secure application framework in Microsoft Visual Studio.NET and C#.o Introduced spatial data into the agency's SQL Server environment along with geographic reporting and automated address geocoding through a State web API backed by Esri's ArcGIS services.o Designed structured organizational reporting security and implemented an enterprise-wide reporting solution based on Microsoft SQL Server Reporting Services (SSRS).o Created an ETL process to import and convert federal government data from Excel spreadsheets into Microsoft SQL Server and then provided access to the data from SSRS to streamline data analysis for the Utility Safety, Reliability and Security Division.o Designed, developed, and implemented a new system to track investigations of possible violations of excavation laws for the Utility Safety, Reliability and Security Division and the Oregon Utility Notification Center. The entire project from concept to deployment was just a few short months in duration.o Designed, developed, and implemented an immutable audit log solution to meet the required controls of the United States Social Security Administration (SSA) for handling of SSA-provided data.o Designed, developed, and implemented automation to bring in data from DMZ-based servers to internal servers for processing.o Quickly rewrote an entire SharePoint-based intranet site as an ASP.NET MVC web application.Responsibilities:o Provide complete solutions and software development services for use throughout the agency.o Lead efforts to formalize standards and processes around the Software Development Lifecycle (SDLC).

Keizer, Or, Us

Key Achievement:o Built the ARCheck™ product for AmeriNet, Inc. from concept to installation CD by assembling a team of technical specialists and tightly managing the project schedule for an on-time and under-budget delivery.Responsibilities:o Research and evaluate technology for quality, durability and fit.o Lead business development efforts.o Nurture client relationships.o Architect software and full-stack solutions.o Manage client and internal projects.o Design and develop custom software solutions.

Salem, Oregon, Us

• Review, analyze, and evaluate existing SQL structure and user needs• Identify issues and recommend changes to boost performance and security of databases• Document database monitoring, alerting and maintenance procedures.• Develop, maintain and test database back-up and recovery plans• Communicate with IT staff regarding database integrity, access controls and compliance• Optimize performance of database environments

Salem, Oregon, Us

Department of Consumer and Business ServicesCentral Services DivisionInformation Technology & ResearchKey Achievements:o Specified new bar code scanners to replace obsolete units used in the annual fixed asset inventory. Developed and tested a custom application for the new devices in just a few hours.o Identified and fixed an interest calculation error deep in an existing process while providing process documentation for an internal audit.o Recognized an opportunity to replace a weekly manual reporting process with an automated report that saves between 100-150 OSHA employee hours annually.Responsibilities:o Provided primary system support, business analysis, programming/development, systems analysis and design, project management, and related services for 33 applications that are used across all DCBS divisions.o Provided technical and business consultation and guidance to divisions across the agency.

Beaverton, Oregon, Us

Key Achievements:o Evaluated, selected, and implemented a completely new Managed File Transfer (MFT) product to handle over 300 daily data transfers with clients and partners (financial institutions), significantly increasing process performance and stability.o Designed and developed automated ACH auditing used to validate daily bank transaction activity and ensure financial controls.o Automated production software deployments across server farms. This resulted in reducing deployment times from 3-4 hours to less than 15 minutes for the bi-weekly product sprint releases.o Designed and implemented the first two phases of a process control system consisting of central logging and alerting with varied language wrappers around a SQL-based API.Responsibilities:o Administered file processing and production processes for data sources, systems, and partners.o Provided key troubleshooting on the production platform including batch processing, web service transactions, and SQL-related issues. Identified the source(s) of issues and fixed or coordinated resources to fix. Completed Root Cause Analysis and recommended solutions.o Collaborated with the software development team and internal business teams to deploy builds to the production and test environments.o Provided review and sign-off related to proposed product changes (change management).o Managed change control and release cycles, assisting with data changes, hot fixes, and security incidents.o Provided high-quality support and collaborated with systems administrators, DBAs, developers, and business stakeholders.o Continuously audited and analyzed data to ensure high data quality.o Made recommendations on continuous process improvement. Evaluated and recommended new file transfer technologies.o Led the production engineering team.o Participated in on-call rotation. Provided 24/7 support for critical situations.o Provided support, information, and policy review for SOC 1 and PCI-DSS audits.

Portland, Or, Us

Portland, Or, Us

Key Achievements:o Managed all phases of a multi-year Customer Relationship Management (CRM) implementation project including Commercial Off-the-Shelf (COTS) software evaluation and selection, customization, integration with third-party systems, process automation, data migration, deployment, end user training, support, and reporting.o Designed and developed an engine for credit card tiered batch pricing (contract data-driven) that handled more than $2.5 billion in payments to non-profit clients by 2012 and was a key component of the technology desired by Global Payments Inc. in the Auctionpay acquisition. o Automated a formerly manual credit card merchant account boarding process across companies and technologies.o Provided project management, technical assistance, and data migration for a major accounting system and related integrations upgrade.o Managed conversion of all credit card processing systems and merchant IDs from one merchant processor to another.Responsibilities:o Provided full SDLC to architect, design, build and maintain enterprise-wide business applications.o Collaborated with internal business stakeholders, partner companies, and others to envision, architect, and implement integrated processes and solutions.o Researched emerging technologies to determine their potential for use in the organization.o Designed, developed, managed, and supported all systems related to running a credit card aggregator, including managing between 20,000 and 50,000 credit card merchant accounts (Elavon, Global Payments, and American Express) used in processing payments for over 6,000 non-profit clients.o Designed, developed, and optimized databases and reports.

Portland, Or, Us

Key Achievements:o Worked with a financial industry consortium (NACHA) to develop a system for processing digitally-signed ATM payments over the Internet.o Assumed the role of IT Manager and managed all technical operations when the permanent IT Manager was on a 3-4 month leave-of-absence.o Designed and developed a credit card integration software product for CTR to use in Epicor distribution and manufacturing implementations complete with extensive documentation.o Designed and developed eCommerce sites and web-based applications under extreme time constraints.o Was a key contributor in over half of the projects highlighted in CTR’s project case studies.Responsibilities:o Evaluated and reviewed technology options for client recommendation.o Nurtured client relationships.o Led requirements gathering efforts.o Designed and architected full-stack technology solutions (infrastructure, database, application, UI, technology).o Provided project management for complex projects (both in project size and the number of simultaneous projects).o Provided full lifecycle software development services including design, programming, and quality assurance.o Mentored and trained the development team.o Kept track of the evolving technology landscape through industry journals, trade shows, vendor events and briefings, and independent research.

Key Achievements:o Invented a technique to recover data from hard drives with damaged partition tables.o Designed a highly-efficient solution to support dozens of active users in a remote office using a central corporate client/server database application over a very small data pipe (56 Kbps).o Implemented the first client/server system at CPS.o Worked with Sequent, Oracle, Microsoft, Lotus, and other vendors to test and specify products for company-wide use.