Patrick Mcfarland Email & Phone Number

Eugene, Or, Us

This is a volunteer position in which I mentor undergraduate and graduate students in Data Analysis, Software Development and Database practices.

Eugene, Or, Us

• CareLogic is a Qualifacts Behavioral Health data platform in Oracle • Reports were created to comply with Oregon State regulatory requirements • I worked with Behavioral Health therapists to create meaningful presentations • Created financial, billing, process improvement, demographic and compliance reports • Helped increase staff efficiency through accuracy and timely delivery of reports

• During the Pandemic I worked on an innovative new education project • I wrote product reviews to help suggest app improvements • Improvements were achieved through building Cloud data channels • Made the site accessible to the visually impaired • SQL Server monitored all app changes and recommendations • Built a custom reporting platform to provide status updates to client • Using this platform I compiled a campaign to promote literacy

Springfield, Oregon, Us

• Designed data interfaces with big data health systems such as PeaceHealth and McKenzie-Willamette • Presented complex data in meaningful ways • Hospital to hospital data exchange • Designed complex pathology reports • SQL Server programming and reporting environment • Daily backup of all company databases

Franklin, Tn, Us

• Contract Position. Developed ETL processes for data from CMS programs, Bundles Model 2• This was post acute care data for Medicare recipients• Imported data according to CMS business rules• Worked in an Agile environment using two-week sprints for development cycles• The CMS data was complex and we fed it to an application back end for analysis and reporting• We proved the CMS data can be interepreted and turned into a profitable business

• Contract Position. Worked remotely with team members located throughout the world. We took existing web applications in the healthcare industry and improved upon them for better functionality and industry relevance• Managed and monitored tasks assigned in the SDLC process to resolve defects• Gathered technical requirements to improve software, set and conducted meetings, kept minutes and action items• Tested and reviewed coding changes• Technology for social progress• We made national headlines with one of our projects in which we developed a search engine for consumers to find medical Providers: http://opensource.com/health/14/2/open-source-health-provider-website

Menlo Park, Ca, Us

• Contract Position. Provided database development, ETL programming, data integrity and business intelligence services in an enterprise-wide information system that fed a back-end application and a reporting platform.• Imported Pharmacy data to help consumers reduce Rx conflicts by programming SSIS packages and optimizing databases to receive data efficiently• Many millions of rows of data imported and transformed, cleaned and normalized• Core processes fed a call center application

Nashville, Tn, Us

• Oversaw all ETL processes of the company and was the technical lead for the data department.• Analyzed clients’ business requirements, documented these requirements and their corresponding database platforms, and used SQL Server to maximize operational efficiency.• Used SharePoint to develop interfaces to monitor daily progress, project management goals, and to document business requirements as well as departmental procedures. • My major project was the lead architect and SQL developer for a database that generated billing statements based on daily account information changes received from a major Midwest hospital group. This project raised the client’s receivables by 30%, close to $60 million annually, helping to add at least an additional 15 employees to our staff. • As manager, helped the company surpass an historical $100 million in annual collections. Developed advanced reporting platforms using SSRS and ETL. Also developed NACHA files for billing purposes. Helped to automate FTP processes for daily file transfers between the company and its clients. Worked with the IT infrastructure staff to maximize data flow and security. My position was phased out after a 3 year. This was a very productive period of time and much progress was made.

Franklin, Tn, Us

• Contract Position. Conducted a corporate wide ISO 27001 analysis of internal IT processes • Used ETL processes through SSIS to bring in sensitive employee data for analysis• Principal Consultant providing technical and solutions advice, assistance, and direction to corporate project managers to improve operations• Scheduled meetings with and interviewed executive management to explain the scope of the internal audit resulting in excellent relations and enhanced compliance• Advanced reporting in Excel and Access using SQL Server data provided to executives• Thorough analysis of PeopleSoft and Active Directory data

Various Business Analyst and Data Analyst assignments.

• Advanced defect management reporting directly to executive management• Implemented project reporting to show the progress of the overall project on two major government accounts• Technical team lead and technical support on a team of 30 business analysts who tested TennCare applications; interfaced 30 business analysts with 20 developers as defect analyst• Developed SharePoint site to house audit information shared by State employees• Developed gap analysis for the State of Tennessee (TennCare) and Washington, D.C• Project-level liaison between executive management, business analysts and developers to maintain project goals, timelines and deadlines and to optimize resources allocated to these projects resulting in streamlined resource coordination

Nashville, Tennessee, Us

• Contract Position. Implemented a new contract with TennCare after winning the RFP• Database manager for the Medical Appeals Division of TennCare: developed a data platform for the Medical Appeals division that was shared throughout the organization• Developed system documentation • Developed and monitored ETL processes in SQL Server• Implemented daily reporting to TennCare managers via email subscriptions resulting in real-time data delivery for informed management decision-making• Frontline technical support for over 200 TennCare employees

• Contract position• Converted Microsoft Access databases to SQL Server; data mapping• Contracted with the Department of Social Services as a DBA to help the mentally disabled• Provided database maintenance, backup and security• Performance tuning and query optimization in SQL Server• Responsible for providing training for county employees

Alpharetta, Ga, Us

• Contract Position. Analyzed marketing data for medical equipment sales possibilities• Worked with developers to design and implement a call center system in an SDLC environment resulting in increased sales opportunities• Responsible for importing data from customer files using custom ETL processes • Designed reports using SSRS and advanced Microsoft Excel functions• Data cleansing and integrity checks using functions and stored procedures• Technical help desk assisting others resolve issues resulting in less down-time

Frankfurt Am Main, Hessen, De

• Contract Position. Provided database services to financial business executives throughout the world• Designed and implanted unique MS Access databases integrated with MS Excel• Delivered data using XML standards for enterprise-wide data sharing solutions• Successfully designed and tested customized reports• Revenue reporting and audit trail of financial markets; data mapping

Us

• Best of class technician in the Franklin area for Dell with a successful service area • Certified to work on all Dell computers and printers• Helped provide innovative technical solutions to customers• Configured routers, printers, IP addresses, networks, and everything to do with hardware• Communicated technical details in plain language to customers

Cincinnati, Ohio, Us

• Taught A+, Net+, and MCP certification courses• Created curriculum• Assisted students in creative learning opportunities

Us

• Technical trainer for the visually impaired; taught blind people how to use the Internet• Set up home businesses for the blind and gave tech support• Evaluated adaptive software and hardware for the State of Tennessee• Converted database systems from Excel to Access• Implemented inventory systems, including the fulfillment and delivery of goods to Williamson County government, resulting in a better level of service to the community• Intranet and web design for local businesses• Database integration with Microsoft Office• Moderated DisabilityAccess, a forum for web designers about accessible web design

Louisville, Ky, Us

• Executive Assistant to the Presbyterian Peacemaking Program• Managed a database of 20,000 active members nationwide

Milwaukee, Wisconsin, Us

Technical Trainer to corporate clients on Microsoft Access, Microsoft Excel and Microsoft Word

Harleysville, Pa, Us

Underwriter for Commercial Lines of insurance

Us

Underwriter for Small Business Lines of insurance

Bachelor Of Science, Liberal Arts

College Prep