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.

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.

• 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.
• 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.

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.

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.