Amor Alfieri (Di Cio)
Senior Data and Visualization Engineer at CVS Health Payor Solutions- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
-
Tagalog Native or bilingual proficiency
-
Cebuano Native or bilingual proficiency
-
Waray -
Topline Score
Bio
Credentials
-
Tableau Desktop Certified Professional Certification
Tableau Software 2Dec, 2022- Oct, 2024 -
APPLIED BUSINESS ANALYTICS
MIT Sloan School of ManagementJul, 2020- Oct, 2024 -
IT Information Library Foundations Certification (ITIL)
Pro TechMar, 2020- Oct, 2024 -
FHIR
HL7 PortugalDec, 2019- Oct, 2024
Experience
-
CVS Health Payor Solutions
-
Hospitals and Health Care
-
1 - 100 Employee
-
Senior Data and Visualization Engineer
-
May 2022 - Present
Tableau Desktop Specialist Certified Architecture Wireframe Visualization Tableau Desktop Specialist Certified Architecture Wireframe Visualization
-
-
-
Highmark Health
-
United States
-
Hospitals and Health Care
-
700 & Above Employee
-
Senior Business Intelligence Engineer Analytic Consultant
-
Dec 2017 - May 2022
Develop BI Dashboards using Power BI or Tableau for various internal and external stakeholders. Extract, Transform and Load data. Works effectively within a collaborative and fast paced team environment and completes tasks with accuracy and with strong attention to detail.Plans, designs, tests and implements Business Intelligence solutions through use of BI tools, technologies and databases. Analyzes complex processes and develop technical and/or process solutions to meet business needs. Works collaboratively with customers and technical staff for requirements gathering and development.Collaborate closely with Data Engineers and help them with data cleansing, data modeling, data profiling, translates the data, validating and corrects data anomalies.SAS for deep dive analysis; Hadoop Hive; Microsoft Power BI; Tableau.Provides end user support for BI solutions and applications, including investigation and resolution of issues regarding tool functionality and performance. Participates in quality or process improvement activities, including regular reviews of systems and technology.Provides input on strategies and tactics regarding platforms, tools and technical staffing to meet customer needs.Documents the design and technical testing, as well as managing and negotiating project scope, timelines and developing/defining project deliverables with business customers.Design, develop, implement and maintain of Business Intelligence (BI) solutions to support business needs, following BI development best practices and innovative use of appropriate technologies and systems.Provides input to business cases, contracts, project plans, scope of work, status and project summary reports.Work effectively with customers in all phases of application development projects, potentially including requirements gathering, design, testing and change management.Consults. Train employees, assign, monitor and review progress and accuracy of work. Show less
-
-
Senior Decision Support Analyst(Gateway)
-
May 2016 - Dec 2017
• Develops and refines HCC ESRD Risk Adjustment Models from scratch. Spearheaded BI from SAS to Tableau to create Reporting Executive Financial Portfolio.• Develops, analyzes and summarizes business performance reports (e.g. for claims data, provider data, utilization data) using SAS, Excel, SQL, or other analytical tools.• Creates Financial Report Forecast from the final output of my analysis.• Creates SAS logic of claims data and member attribution needed to run through CMS Risk Score Models (HCC/ESRD), as well as, RAPS/EDPS submissions . Uses Excel, PowerPoint, SQL or other analytical tools.• Deals with big projects that require deep analytics and communications due to the more complicated nature of assignments. • Re-engineers HCC and diagnoses conversion to get a more accurate risk scores, as a result it closed score gaps that contributed to the revenue’s $Ms increase.• Creates logic to deep dive in analytics for Targeting; Prospective and Retrospective campaigns.• Manages, updates, and maintains SAS project as CMS implements updates to HCC/ESRD models.• Provides expertise and accurate projections or actual financial reports to the upper management.• Develops multiple SAS programs and SQL queries to projects for various internal and external requestors. • Identifies, analyzes, and interprets trends or patterns in complex data sets.• Defines and documents business, user, functional and technical requirements. • Serves as an expert in data analysis, reporting and formulating recommendations and providing guidance to other data analysts. Provides guidance and assistance to other analysts as required.• Analyzes, reviews, and forecasts the trend complex data and provides analytical consultation to other teams.• Translates requirements into technical specifications and coordinate other team to implement new development.• Develops & produces ad - hoc reports, solves complex problems and / or conducts moderately complex analyses. Show less
-
-
-
PNC
-
United States
-
Financial Services
-
700 & Above Employee
-
Business Analyst III - Direct Marketing Campaign Application Analyst
-
Mar 2014 - Apr 2016
SAS Programming | Teradata | PRIMO | HYPERION | WIN7 | SHARED POINTS | PUTTY | FileZilla | MAS | SQL • SAS programming. Analytics. MAS. Business data analysis. • Executed SAS logic for marketing campaign of PNC products and services. • Formulated and defined the system scope and objectives, based on user needs and business processes. • Worked closely with clients and marketing design teams to prioritize data and information requirements. • Recommended better process in achieving goals more efficiently, better approach to analytical assessment. • Extracted raw data, executed the created logic using SAS code and applying SQL query within the code; tapping into data stored in Teradata flat form. Loaded datasets from UNIX. Imported excel and text files into the program using SAS code. Transformed all those puzzles into a nice and clean file after QA, analyzed logs and checked for errors to ensure accuracy of the code execution in order to generate an error free campaign file before sending it off to the vendor. • Provided sample file for quality check done by the requestor, myself and other person. Then it gets approved after validating that the final file matches with the listed requirements and the criteria of the request. Worked and collaborated closely with data management staff to define, develop, and implement policies and operational/security frameworks that ensure precise and secure delivery of knowledge and information. • Developed internal and external relationships across the corporation and vendors. Provided analytic and consultative support to an internal external business partners. • Performed in a high capacity and timeframe focus environment where multitasking is inevitable. • Developed and maintains required programming languages (such as SAS, SQL,) and other database technology (Teradata, Oracle, and Putty); other software such as Aprimo/MAS; TCH and other in-house system (mainframe/genesis, UNIX). Show less
-
-
-
WM
-
United States
-
Environmental Services
-
700 & Above Employee
-
National & Broker Accounts Liaison
-
Nov 2007 - Feb 2014
Prioritized assigned projects and developed project plans, requirements, deadlines, and reports progress and status on timely basis. Served as the main resource on internal and external projects defined by management. Mentored team members on standardized National and Broker processes including project tracking, time management, reporting, issue escalation, and change management. Executed rapid issue resolution and provide proactive customer service, price quoting and emergency problem solving for customers over 100 key accounts 100% on Waste Management scorecard—track record/log for bids completion in timely fashion of our Market Area, Eastern-Western PA. Participated in the development of new pricing systems, processes and reports. Tested new/improved solutions, and contribute to and/or lead cross-functional training for successful implementation. Analyzed list price, discounts, actual price, concessions, contractual obligations, target-based programs, etc. to win new business on large bids. Researched pricing discrepancies and propose solutions to factually resolved pricing disputes Show less
-
-
-
Spartech Corporation
-
United States
-
Plastics Manufacturing
-
200 - 300 Employee
-
Account Manager
-
Mar 2007 - Nov 2007
Performed inside sales and coordinated sales transactions, order request modification and with account managers to support account retention. Updated pricing matrix Monitored product development to its completion and shipment destination. Performed inside sales and coordinated sales transactions, order request modification and with account managers to support account retention. Updated pricing matrix Monitored product development to its completion and shipment destination.
-
-
-
U.S. Bank
-
United States
-
Banking
-
700 & Above Employee
-
Financial Analyst/Project Leader
-
May 1999 - Mar 2007
Developed and executed Monarch models for Reconcilement system, which is a custom designed template that generated a customized accounting report for daily use and provided for the organization's financial management. Learned, troubleshot and supported custom template designed using Monarch, an application for employees and managers, to ensure smooth transition of application. Provided support services including problem resolution Reconciled the general ledger of numerous accounts to ensure they meet audit requirement. Managed multiple accounts, analyzed daily transactions, and reconciled discrepancies Resolved financial pending issues. Prepared balance sheets, profit and loss statements, and other financial reports. Met reporting deadlines and downloaded reports. Create updates and reports daily, monthly and year-end Show less
-
-
-
Ketchum
-
United States
-
Public Relations and Communications Services
-
700 & Above Employee
-
Computer Operator
-
Jun 1996 - Jul 1997
Backup end of day data. Monitor its processes. Trouble shoot. Backup end of day data. Monitor its processes. Trouble shoot.
-
-
Education
-
MIT Sloan School of Management
Certificate (Executive Education), Applied Business Analytics -
Columbia Engineering (Data Science Certificate)
Certificate (Executive Education) Enrolled, Applied Data Science -
FHIR
Certificate, HL7 -
Carnegie Mellon University
Certification, Enrolled, Computer Software Engineering -
Robert Morris University
Master's Degree, Information System Management -
Robert Morris University
Bachelor's degree, Computer Science -
Community College of Allegheny County
Associate’s Degree, Computer Science and General Studies -
Community College of Allegheny County
Associate’s Degree, Registered Nursing/Registered Nurse