Role listed
Self-Employed
AeroLeads people directory · profile
Andrew R. Email & Phone Number
Independent Healthcare Analytics Consultant
at
Self-employed
1 work email found
@nordicwi.com
3 phones found area 608
LinkedIn matched
✓ Verified May 2026
4 data sources
Profile completeness 100%
Current company
Self-employed
Role
Independent Healthcare Analytics Consultant
Location
Champaign, Illinois, United States
Who is Andrew R.? Overview
A concise factual answer block for searchers comparing this professional profile.
Quick answer
Andrew R. is listed as Independent Healthcare Analytics Consultant at Self-employed, based in Champaign, Illinois, United States. AeroLeads shows a work email signal at nordicwi.com, phone signal with area code 608, and a matched LinkedIn profile for Andrew R..
Andrew R. previously worked as Data & Analytics Consultant at Self-Employed and Senior Data & Analytics Consultant at Nordic Consulting Partners, Inc.. Andrew R. holds Doctor Of Philosophy (Phd/Abd), Marketing Research/Management Science from University Of Illinois Urbana-Champaign.
Company email context
Email format at Self-employed
This section adds company-level context without repeating Andrew R.'s masked contact details.
*@nordicwi.com
68% confidence
AeroLeads found 1 current-domain work email signal for Andrew R.. Compare company email patterns before reaching out.
Profile bio
About Andrew R.
Andrew Roy is a highly skilled and Epic certified "data scientist" with experience in data warehousing, business intelligence, high-end advanced predictive analytics, ETL & database administration, data mining, OLAP and ad-hoc query tools, SQL, web-enabled decision support, and knowledge discovery.His analytic skills were developed through research and practice in the areas of multivariate statistics, econometric and structural equations modeling, and categorical data analysis. With this foundation, Mr. Roy has built a 35+ year career in information technology and analytics, acquiring comprehensive knowledge of a wide array of software and hardware, adapting emerging technologies to an organization's needs, and using critical thinking skills to solve complex problems. He is expert in several complex analytics software suites such as SAS, SPSS, Systat, S-Plus, Stata, EQS, LISREL, LIMDEP and TSP.With over 10 years in healthcare IT including 6+ years as a consultant, Mr. Roy brings significant Epic implementation and application integration & optimization experience. He specializes in Epic CDW {cogito(r) data warehouse} / Caboodle / Star / Clarity [ETL & SQL Server database] administration including installation, upgrades, optimization, and Meaningful Use reporting covering 'objectives and quality/core measures' for both Eligible Hospitals and Eligible Providers. He has performed significant cogito/Clarity reporting using SAP Crystal Reports, SAP BusinessObjects Enterprise and Epic/Crystal Integration for both clinical and financial applications. Of late, he has been dabbling in utilizing Tableau and QlikView in an Epic enterprise setting.Drawing on his knowledge base, experience and keen interest in the field, Mr. Roy is expert in using the powerful analytical tools that enable an organization to "mine" large datasets for information that is extremely valuable in strategic and operational planning and decision-making.
Listed skills include Data Analysis, Business Intelligence, Consulting, Data Warehousing, and 41 others.
Current workplace
Andrew R.'s current company
Company context helps verify the profile and gives searchers a useful next step.
Self-Employed
15 roles
Andrew R. work experience
A career timeline built from the work history available for this profile.
Data & Analytics Consultant
Current
Self-Employed
Nov 2018 - Present
Jan 2018 - Aug 2018
Aug 2016 - Jun 2017
Jun 2015 - May 2016
Senior Advisor
- Senior Advisor -- Epic Cogito / Clarity
- Performed in-depth analysis of all legacy revenue cycle reporting needs including those fulfilled by the highly proprietary and confidential "Huron Management reporting package"
- Prepared detailed transition plan away from Huron in post Epic 2015 deployment (2016/2017 go live) by rapidly adopting Epic's foundation system reports including but not limited to "financial pulse", dashboards & Radar.
- Led reporting content design sessions for HB, PB, and HB/PB claims
- Mentored FTE personnel on client's reporting team
- Assisted with Clarity ETL deployment & implementation and Cogito infrastructure planning under SQL Server Enterprise 2012 and Crystal Reports 2013
Jul 2014 - Apr 2015
Senior Consultant
- Senior Clarity Consultant
- Clarity reporting project (using SQL Server and SAP Crystal Reports) -- completely reengineered from scratch an automated extract of primarily Epic Resolute Hospital Billing data into a pseudo data warehouse under.
- Original code was delivered to client from Epic Systems Corporation under the rubric of Reporting Workbench “extract framework”
- Developed complex custom level SQL code to replicate all patient level accounting information covering distinct data sources: encounter level, detailed charges, detailed payments, ICD9/10 diagnoses, ICD9/10 procedures.
- Data elements encompass several other Epic modules including but not limited to ADT/Prelude, Inpatient, Willow, Optime, Professional Billing, and HIM
- Created SQL Server 2008R2 SSIS packages to automate daily, weekly and monthly extracts
Dec 2012 - Jan 2014
Senior Consultant
- Professional Services - Epic PracticeSenior Epic Clarity Consultant
- Authored and customized Crystal Reports templates covering Epic Resolute Professional Billing, Cadence and ADT / Prelude
- Reports generated included: charges, payments & adjustments; procedure counts; accounts receivable, debits & credits; A/R aging data; RVUs report for monitoring performance, staff productivity; refunds & claims.
- Assisted in resolving issues with Clarity extract, transform and load (ETL) processes and any urgent Clarity needs covering Meaningful Use analytics
- Assisted in the Epic/Crystal integration implementation to allow for automation of Clarity report publication beside Reporting Workbench (RW) reports via Epic Hyperspace “reporting home” and eventually Radar dashboards
- Supported Epic Cadence go-lives at eight orthopedic clinics followed by a stint at the client’s neurosurgery unit
Nov 2011 - Oct 2012
Sr Bus Analyst / Dba / Reporting Lead
- Epic Clarity Reporting LeadClarity ETL Administrator / SQL DBA / Epic MU Clarity Lead
- Managed and performed all technical functions associated with ETL (extract, transform and load) administration, database management and analytical / business intelligence (BI) reporting within an enterprise-wide data.
- Set up and maintained Clarity RDBMS and related database objects (functions/stored procedures/views/indices/data-marts) under SQL Server 2008R2 Enterprise x64 running on Windows Server 2008R2 Enterprise x64 on.
- Performed multiple clarity data model compass / database schema and clarity console upgrades going from Epic 2007 to 2008 to 2009 to 2010
- Created, tweaked, scheduled, maintained, and monitored all recurring ETL processes from Chronicles OLTP Cache' environment under IBM AIX and/or Sun Solaris to Clarity OLAP platform; added tables & columns using KB-SQL.
- Installed and maintained SAP BusinessObjects Enterprise (BOE) rel. 3.1 sp4 infrastructure under Windows Server 2008R2 Standard x64
Apr 2007 - Sep 2011
Manager Of Systems Services
- Division of Management Information
- Installed and maintained Windows NT/2000/2003 server network with XP/2k clients; maintained six servers running SQL Server 2005 and IIS web-server
- Managed ever-growing portfolio of mission-critical SQL Server databases serving information needs of UofI administrative & academic communities
- Administered and monitored network/database security of highly sensitive and confidential administrative data
- Automated and managed ETL process from EDW on UNIX (Oracle, Sybase, SCT/Banner) to Windows (Microsoft SQL Server, Access) utilizing SQL Server utilities written in DTS/SSIS and miscellaneous SAS(r) procedures
- Designed and maintained web-based database-driven applications written using SAS &/or ASP with SQL Server back-end and involving heterogeneous data sources
May 2003 - Mar 2007
Manager, Statistical & Networking Software
- Senior Research ProgrammerComputing & Communications Services Office
- Researched technology trends; conceptualized, specified requirements and devised strategies for integrating emerging technologies to help maintain leading-edge computing environment
- Identified, evaluated and selected business intelligence & network connectivity software to realize gains in computing capability & productivity
- Negotiated site license contracts: enterprise-wide agreements with SAS, SPSS, Hummingbird and NAG were precedent-setting in scope & pricing
- Installed, performed troubleshooting and maintained all statistical/econometric modeling software on high-end mainframe campus-wide UNIX and Windows servers
- Project Manager for software including SAS, SPSS, Systat, S-Plus and Hummingbird connectivity suite -- administered site licenses; set end-user pricing strategy for internal cost recovery; managed software.
Aug 1994 - May 2003
Statistical Consultant
- Research ProgrammerComputing Services Office
- Managed campus-wide statistical software; played key role in migration from mainframe CDC Cyber NOS to IBM VM/CMS environment
- Served as statistical consultant on complex data analysis problems for faculty & graduate students
- Developed and taught numerous short courses on diverse topics such as 'Intermediate UNIX', 'Intermediate CMS', and 'Regression Analysis Using SAS, SPSS & BMDP'
- Investigated emergence of LAN-based email, POP3/IMAP mail clients, TCP/IP remotelogin, file transfer, NFS, and Kerberos security protocols; made recommendations to Director regarding resultant impact on campus computing
- Negotiated enterprise-wide multi-campus licenses with FTP Software and cc:Mail to facilitate cost-effective adoption of technology
Dec 1985 - Aug 1994
Research Associate
- Department of Psychology
- Coordinated data collection & processing and performed all analytical tasks as leading staff member of large research team
- Carried out complex time-series, multivariate & categorical data analyses using SAS, SPSS, LISREL, EQS, BMDP, TSP, LIMDEP, RATS & SHAZAM
- Coauthored textbook with lead researcher summarizing predictive analytical methods & major findings
Aug 1982 - Aug 1986
Research Data Analyst Ii
- Assistant to DirectorSurvey Research Laboratory (SRL)
- Database administrator for comprehensive longitudinal research panel of consumer household decision-making
- Performed sophisticated multivariate & econometric modeling analyses, and co-wrote research monographs
- Advised faculty & graduate students on research design, survey sampling, statistical methodology & interpretation of results
Sep 1977 - Aug 1982
Instructor, Marketing Research
- College of Business
- Developed and taught advanced Marketing Research class to graduating seniors at the UIUC Department of Business Administration
Jan 1981 - May 1981
3 education records
Andrew R. education
Doctor Of Philosophy (Phd/Abd), Marketing Research/Management Science
University Of Illinois Urbana-Champaign
Bachelor Of Technology (Honors), Mechanical Engineering
Indian Institute Of Technology, Kharagpur
Higher Secondary, Physical & Math Sciences
St. Lawrence High School, Kolkata, India
FAQ
Frequently asked questions about Andrew R.
Quick answers generated from the profile data available on this page.
What company does Andrew R. work for?
Andrew R. works for Self-employed.
What is Andrew R.'s role at Self-employed?
Andrew R. is listed as Independent Healthcare Analytics Consultant at Self-employed.
What is Andrew R.'s email address?
AeroLeads has found 1 work email signal at @nordicwi.com for Andrew R. at Self-employed.
What is Andrew R.'s phone number?
AeroLeads has found 3 phone signal(s) with area code 608 for Andrew R. at Self-employed.
Where is Andrew R. based?
Andrew R. is based in Champaign, Illinois, United States while working with Self-employed.
What companies has Andrew R. worked for?
Andrew R. has worked for Self-Employed, Nordic Consulting Partners, Inc., Optimum Healthcare It, Impact Advisors, and Leidos.
How can I contact Andrew R.?
You can use AeroLeads to view verified contact signals for Andrew R. at Self-employed, including work email, phone, and LinkedIn data when available.
What schools did Andrew R. attend?
Andrew R. holds Doctor Of Philosophy (Phd/Abd), Marketing Research/Management Science from University Of Illinois Urbana-Champaign.
What skills is Andrew R. known for?
Andrew R. is listed with skills including Data Analysis, Business Intelligence, Consulting, Data Warehousing, Healthcare Information Technology, Data Mining, Analytics, and Analysis.
Find 750M verified contacts
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trial