Patrick Lonchar Email and Phone Number
Patrick Lonchar's Location
Phoenix, Arizona, United States, United States
Patrick Lonchar's Contact Details
Patrick Lonchar work email
- Valid
- Valid
- Valid
Patrick Lonchar personal email
n/a
Patrick Lonchar phone numbers
About Patrick Lonchar
Business Intelligence Analyst professional with extensive experience working with business leaders and customers to understand their needs by gathering business requirements and utilizing a strong technological background to deliver high quality results. Success through personal attributes of honesty, loyalty, and superior work ethic. Excellent oral and written communications skills with strong problem solving and analytical abilities on Microsoft, SAP and Oracle platforms. Key Competencies:• Data Acquisition/Cleansing • Data Integration • Data Analysis/Validation • Reporting/Metrics • Business/IT Liaison • System EnhancementsTechnical Skills:• Microsoft: SQL Server 2012, SQL, SSRS, Visual Studio, TFS, Excel, Word, Access, Outlook• SAP: ECC 5.0, SAP R/3, SD, FI, MM, ABAP, Data Conversions, Interfaces, IMG, Basis• Oracle: Oracle 11i/10g, PL/SQL, SQL, Stored Procedures, Packages, Alerts, Triggers, Reports, Discoverer, Materialized Views, Fast Formulas, APIs, Toad, Linux
Patrick Lonchar's Current Company Details
Patrick Lonchar Work Experience Details
-
Business Intelligence AnalystTriwest Healthcare Alliance 2020 - PresentPhoenix, Az, Us
-
Senior Data AnalystTriwest Healthcare Alliance 2015 - 2020Phoenix, Az, UsService the Finance and Claims Departments by supporting business initiatives and data requests while providing analysis and insights to tell the story of the data.• Responsible for all aspects of business requirements gathering, data mining, analysis, and reporting of financial and claims metrics to the executive leadership team.• Manage administrative invoicing and support of healthcare service authorizations and claims billing processes, including quality assurance validations.• Subject matter expert and liaison for finance and claims departments regarding claims healthcare billing & payments (to/from providers and to/from the Veterans Administration).• Provide data healthcare cost incurred but not received and prepare reporting for estimating and forecasting banking reserves for future claims payments.• Support upper management of the finance and claims departments for initiatives, projects, and ad-hoc reporting.
-
Client Service AnalystIms Health Jun 2011 - May 2015Danbury, Ct, UsManaged the implementation and administration of proprietary software solutions to calculate Incentive Compensation (IC) pay for pharmaceutical clients including bonus pay, contests, and other performance metrics.• Analyzed client IC plans to configure software for processing files and creating client deliverable reports and web portals to provide clients with critical information to compensate and reward their sales forces. Consistently met and exceeded the 98% service level agreement by providing on-time delivery of error-free results.• Reduced weekly file processing from 5 days down to 1 ½ days in less than 6 months greatly improving customer service for our largest client.• Identified a process improvement need for a weekly employee eligibility feed. Took the lead on this effort and reduced manual file formatting efforts by 67% from 3 days down to 1.• Developed MS SQL queries referencing stored procedures to prepare control totals for QC and other ad-hoc reports as needed to meet the contracted service level agreements on or ahead of schedule.• Worked with development to implement IC plan changes in the software to configure: client reports, scorecards, and dashboards on web portal tabs to meet and/or exceed the client’s expectations.• Documented all phases of the IC process: file access method, file importing, data validation, IC plan execution, quality assurance, reporting, portal preparation, and results distribution significantly improving the quality of results delivered to the client.• Communicated with off-shore resources to coordinate the handoff and receipt of deliverable tasks to keep priorities moving round-the-clock providing excellent customer service. -
Programmer/Analyst (Oracle)Blood Systems 2007 - 2011Scottsdale, Az, UsPerformed systems analysis, requirements gathering, and interviews of subject matter experts. Developed and tested software, prepared documentation, and provided technical leadership for Human Resources, Payroll, Finance, and Purchasing applications.• Designed and developed PL/SQL programs/stored procedures including interfaces, data extracts, and reports for a wide variety of business applications substantially enhancing the functionality of the Oracle system to make users more effective in their jobs.• Served as lead developer on turnover and retention reporting system for over 3,000 employees utilizing Oracle Discoverer to assist the CEO in considerably reducing employee turnover and extending employee retention. Created MS Access wizards/queries for validation.• Implemented Nakisa talent management and succession planning software as technical liaison working with various internal teams and software consultants providing management with a dynamic software tool to groom upcoming business area leaders and help insure future company success.• Functioned as technical lead for an Oracle enhancement of an employee applicant tracking and vacancy control module. This upgrade enhanced reporting and reduced hundreds of hours of data entry annually. -
Software Consultant (Sap)Honeywell Aerospace 2007 - 2007Charlotte, North Carolina, UsWith a team of 12 supported 8,000 global computer users with software problems and change requests. Performed root cause analyses through documentation review to develop viable and sustainable solutions.• Worked primarily with Accounting, Manufacturing/Materials and Sales/Invoicing departments to improve data integrity, process efficiency, and user productivity. -
Software Consultant (Sap)Starwood Hotels & Resorts Worldwide, Inc. 2006 - 2007Stamford, Ct, UsAssisted with the implementation and auditing of financial banking systems by working with established project plan/business requirements, and technical specifications.• Coded automated bank transmissions including electronic bank statements and standard lockbox to facilitate payment processing.• Collaborated with the functional analyst to create detailed steps to make key changes, meet contract requirements, and complete projects within deadline. -
Software Consultant (Sap)Raytheon 2006 - 2006Arlington, Va, UsAnalyzed functional requirements based on SAP knowledge to develop specifications and data mapping for loading legacy data. Completed 4 major data conversions within very demanding development and testing timelines.• Loaded information with full data integrity and a 95% load success in first test cycle based on data mapping accuracy, allowing Raytheon to implement SAP well ahead of schedule. -
Software Consultant (Sap)Thomson West 2005 - 2006Toronto, On, CaAutomated sales order process/web service interface for subsidiary to seamlessly integrate with parent company system, saving thousands in labor and productivity costs. -
Project ManagerAmerican Express 2004 - 2005New York, Ny, UsDirected concurrent software and hardware projects to enhance AmEx business systems related to small business credit/charges. Achieved an infrastructure with faster, more efficient systems to handle greater volume and provide better service. -
Production Support Analyst (Sap)Cardinal Health 2004 - 2004Dublin, Oh, UsManaged and prioritized technical production support for up to 50 Finance Department users in a transition mode after recent merger. -
Software Consultant (Sap)Kimberly-Clark 2002 - 2003Irving, Tx, UsAnalyzed functional and technical requirements to implement SAP system for financial and purchasing applications, improving workflow processes and financial accountability. -
Software Consultant (Sap)Perrigo 2001 - 2002Dublin, County Dublin, IeDeveloped an inventory disposition system in compliance with FDA regulations integrating accurate tracking to facilitate efficient inventory audits. -
Programmer/Analyst (Sap And Mainframe)State Industrial Products 1994 - 2001Collaborated with business leads (sales, marketing, inventory and finance) to identify information reporting requirements, facilitating timely and accurate sales and product tracking, as well as financial reporting.
-
Programmer/Analyst (Mainframe)Fiserv 1991 - 1993Milwaukee, Wisconsin, UsWorked on new company conversion team utilizing assembler language programming to quickly and successfully implement failed mortgage and savings institutions onto Fiserv's banking software after F.D.I.C. takeovers. -
Programmer (Hp 3000)Insurx 1990 - 1991Created and maintained drug claim processing software enabling a 3rd party service for prescription drug purchase coverage between health care providers and their network of pharmacies.
-
Computer Operator (Hp 3000)Chardon Rubber Company 1989 - 1990Performed computer operations in a key organizational role supporting local and subsidiary companies in the areas telecommunications, job executions, reporting, and system backups. Ran payroll/accounts payable checks, made minor program/report changes, provided strong technical support to keep operations up and running smoothly.
Patrick Lonchar Skills
Sql
Analysis
Sharepoint
Access
Visio
Process Improvement
Testing
Oracle
Sdlc
Project Management
Sap
Pl/sql
Data Analysis
Microsoft Excel
Software Development
Data Conversion
Quality Assurance
Web Services
Reporting
Data Validation
Quality Control
Data Integration
Business Process Improvement
Microsoft Access
Sap R/3
Abap
Sap Erp
Excel
Software Development Life Cycle
Oracle Discoverer
Sap Products
Patrick Lonchar Education Details
-
Devry Institute Of Technology, Columbus, OhioComputer Information Systems
Frequently Asked Questions about Patrick Lonchar
What company does Patrick Lonchar work for?
Patrick Lonchar works for Triwest Healthcare Alliance
What is Patrick Lonchar's role at the current company?
Patrick Lonchar's current role is Business Intelligence Analyst at TriWest Healthcare Alliance.
What is Patrick Lonchar's email address?
Patrick Lonchar's email address is pa****@****ess.com
What is Patrick Lonchar's direct phone number?
Patrick Lonchar's direct phone number is (602) 564*****
What schools did Patrick Lonchar attend?
Patrick Lonchar attended Devry Institute Of Technology, Columbus, Ohio.
What are some of Patrick Lonchar's interests?
Patrick Lonchar has interest in Education.
What skills is Patrick Lonchar known for?
Patrick Lonchar has skills like Sql, Analysis, Sharepoint, Access, Visio, Process Improvement, Testing, Oracle, Sdlc, Project Management, Sap, Pl/sql.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial