Andrew Walker Email & Phone Number

Portland, Or, Us

Portland, Oregon Metropolitan Area

• Deployed Virtual Machines to host proprietary product for clients.• Collaborated with internal and client teams to perform large upgrades and patches during maintenance windows.• Configured SSMS and SSRS to provide functionality to proprietary product.• Maintained system users and groups to keep servers secure.• Worked directly with DevOps to create firewall rules to prevent security breaches.• Modified IPs of servers to ensure URLs were routing to the correct location.• Decommissioned old servers saving the company thousands of dollars a week.• Participated in monthly on call rotation to ensure server uptime.• Ramped up in a remote working environment.

Portland, Oregon Metropolitan Area

• Developed a suite of SSRS reports to analyze data coming from a new data source.• Created a SQL purge process to remove old records causing a 30% decrease in size amongst databases.• Modified graphs, parameters, and expressions in Tibco Spotfire reports to meet client needs.• Configured extracts to provide data that could be loaded and used in Spotfire reports.• Configured admin accounts in Secret Server to automatically change passwords regularly to maintain network security.• Created a Powershell script to automatically change the file type of documents to easily load them into databases.• Monitored indexes on table to find ones underutilized by the query optimizer. Removed them and replaced with better ones based on professional experience and missing indexes system table.• Guided new hires with a variety of backgrounds to learn our products and tools. Sought advice from others to make sure I was providing the best experience and knowledge possible.

• Created SQL Insert scripts to load data from disparate sources into a SQL Server database.• Collaborated with Consultants, Project Managers, and Client Stakeholders to configure proprietary software product.• Designed database tables to store client's HIPAA Audit Log data.• Juggled competing tasks to meet all deadlines on time.

Lake Oswego, Or

• Developed an extract/load/transform process to import, clean, and map raw data from several sources to an SSMS relational database. • Created and updated SQL functions and stored procedures, triggers, views, and tables.• Designed and modified data visualizations for healthcare clients using SSRS and Visual Studio.• Conducted over 20 product implementations for small community hospitals with 25 beds to the Department of Veterans Affairs with over 25,000 beds utilizing various HISs - Epic, Cerner, Soarian, Meditech, Invision, and Healthquest. • Analyzed data extracts from potential clients and created reports with Spotfire to display revenue benefit opportunities. • Innovated new product capabilities to tailor customizations for client needs. • Identified and repaired bugs in product modules to recover lost revenue for clients. • Served as gatekeeper to review and approve high-level baseline design changes to products.• Located product inconsistencies and developed standards to improve supportability and deployment times.• Documented project customizations on SharePoint to ensure smooth transition from implementation team to support team.• Organized and managed expenses for over 30 large and small internal and external office teambuilding events.• Mentored and educated new hires on company methodologies and technical tools.

Lake Oswego, Oregon, United States

• Designed highly-complex process and data flows remotely and on-site with industry experts to improve client workflow.• Configured product modules and enhanced client ability to secure insurance for patients and pursue billing.• Led SSRS trainings on RDL modification, data source creation, and dataset alterations with Visual Studio.• Utilized SQL Server Agent jobs to automate daily ingestion of complex data from disparate systems.• Collaborated with DevOps to troubleshoot built-in product features and ensure product success.• Modified PowerShell and XML scripts to function with diverse client configurations.• Provided top-level T3 technical on-call support to maintain system stability.• Effectively managed time while staffed on multiple projects concurrently with competing priorities.

Corvallis, Oregon Area

Transferred funds between different accounts and indexes. Communicated with clients to obtain invoices.Worked frequently with Microsoft Access and Excel

Went to a clients store with a team of auditors and accurately counted up their inventory.