UTTAM PATRA
Pittsburgh,PA
Summary
Meticulous Data Scientist accomplished in compiling, transforming and analyzing complex information through different data tools and programming languages. Expert in healthcare domain, large dataset management and statistical analysis. Demonstrated success in identifying relationships and building solutions to business problems.
Overview
12
12
years of professional experience
17
17
years of post-secondary education
3
3
Certifications
Work History
Data Science Consultant (Decision Support)
Highmark Inc. (Highmark Health)
Pittsburgh, PA
10.2021 - Current
- Managed multiple programs under MA & ACA health products and liaised with Vendors for program outreach campaigns
- Conducted Vendor provider network capacity analysis in program and product performance tracking dashboards bolstering member outreach by 15%, resulting in additional budget of ~$600K for expansion
- Presented Vendor coded no-HCC analysis impact to program resulting in retrieval of $750K in return to department
- Architected data integration flows in Alteryx and streamlined disparate unstructured data for department dashboards
- Automated electronic access to medical provider systems for records retrieval and roll-up, reducing vendor involvement and building cost-efficient process
- Reconciled disparate raw vendor inbound data distributions in dashboard and reduced leakage by 40% in targeted data stores
- Audited samples for internal ICD-9/ICD-10 HCC coding and listed out claims billed for each patient visit
- Devised automated solutions in Python for SFTP transmission of medical charts and validated medical supplemental data and claims from Vendors for final CMS submissions
- Acted as consultative support to teammates and colleagues on ad-hoc business strategies and proposed technical solutions
- Partnered with Vendor Relation Managers and other matrix partners to support data for varied health plan outreach campaigns.
Senior Decision Support Analyst
Highmark Inc. (Highmark Health)
Pittsburgh, PA
01.2019 - 10.2021
- Influenced management discussions on Vendor payment, invoicing, and incentive process producing insights in real-time billing Tableau dashboard segregating different types of vendor fees, and rate per assessment for accruals
- Improved record retrieval processes and parsed HL7 & JSON medical files creating Python based bot programs reducing medical coders’ manual efforts by 20 hours per week
- Derived top patient diagnoses based KPIs by Risk factor, claims, customer base coverage, and revenue generated
- Automated medical chart PDFs transmission, merging & unzipping, image to pdf conversion, extracting & validating customer responses by using PyTesseract OCR and sending email notification to end users using Python
- Refined dashboards in Tableau Server notifying data-driven alerts based on KPI threshold values enabling Program Managers & Business Analysts liaising with Blue Shield and Blue Cross plans on weekly basis
- Identified potential projects and managed solely on various assignments by collaborating with non-technical matrix teams.
Analytics & Reports Developer
Collabera Inc.
Columbus, OH
09.2018 - 01.2019
- Developed multiple interactive dashboards for operational and management reporting at IT operations department
- Involved in building CIO decks specifying departments affected due to IT infrastructure incidents, changes, and problems
- Involved in testing dashboards developed by peers and advised changes and enhancements relevant to projects
- Built a proprietary GUI tool using Python REST API integration with Tableau server for pulling dashboard views and exported snapshots for PowerPoint using tabcmd, parameterized filtered Tableau URLs, Python OS and pptx packages
- Regulated site management activities handling extract refreshes, published workbooks, and data sources to Tableau Server
- Monitored and parsed logs of IT Infrastructure operations getting impacted on Splunk and tracked issues in ServiceNow
- Maintained datamarts from operational data stores and examined query performance bottlenecks in Toad for SQL.
BI Analyst and Project Lead
Tata Consultancy Services
Bhubaneswar, India
01.2015 - 05.2017
- Contributed BI strategies, reduced overhead costs of NXP semiconductors production, and optimized monthly costs by 25%
- Headed multiple waterfall & V-model projects, coordinated team & stakeholder meetings, and solved business challenges
- Assisted in database and data warehouse design to be in vogue with system workflow design with proper data flows
- Developed Dashboards using maps and geocoding based on client requirement to identify territorial business across country
- Involved in reviewing Business Requirements and analyzing data sources and databases for design, reports, and analysis
- Created dashboards, reports, and visualization for marketing to track key performance indicators and calculated return on investment for presentations to marketing teams and executive leadership
- Mentored newcomers and conducted weekly training sessions on technical, business and consulting aspects to make them delivery ready for any assignment.
Data Analyst
Tata Consultancy Services
Bhubaneswar, India
06.2012 - 12.2014
- Designed schema, ETL workflows, and scheduled jobs for data creation and loading according to business and mapping rules
- Gathered data from Hive data warehouse schema directories and loaded data to Tableau Server
- Optimized aggregate SQL queries on partitioned and bucketed tables improving query response by 188 seconds
- Validated Source to Target mappings in Hive by checking process IDs and data entries improved coverage by 18%
- Identified customer experience values by Tableau reporting and spearheaded campaigning user stories for paperless bill adoption.
Education
Master of Information Systems Management - Information Systems Management
Carnegie Mellon University, Heinz College of Information Systems
Pittsburgh, Pennsylvania, USA 05.2001 - 05.2018
Bachelor of Technology - Information Technology
SOA University, Institute of Technical Education & Research
Bhubaneshwar, India05.2012
Skills
Python
undefinedSkills Summary
- Languages: SQL, Python, HiveQL, SAS Base & Macros, PROC SQL,
- Tools: PowerBI Desktop, Tableau 2022.5, Teradata SQL Assistant & Studio, SAS Enterprise Guide 8.2, Spyder, Jupyter Notebook, HUE, Toad for SQL Server & Oracle, RStudio, SAS Enterprise Miner 14.2, ServiceNow,
- Databases: Teradata, Oracle 11g, Hive, MS SQL Server, GCP BigQuery
- Functional/Domain Skills: Business Analysis, Healthcare & Insurance, Risk Accuracy, Program Management, Performance Tracking and Process Improvement, Product Analytics, IT Operations, Agile, Waterfall, Vendor Management, Banking & Financial Services, High-Tech
Websites
Projects
Capstone Project (Final Project), CMU, Project Manager, Parkway West Career and Technology Center, Managed the team, coordinated meetings with the customer and advisor ensuring 100% delivery and informed decisions., Analyzed the market data in Tableau from external sources such as the Bureau of Labor Statistics, Department of Education and Pittsburgh State Education Department to observe the demand for educational fields., Proposed an average billing system to reduce their year-end losses by 35% resulting from previous budget planning., Performed competitive analysis of vocational training courses offered by other Career and Technology centers., Recommended potential vocational programs valuable to their center by revenue and visualized the heatmap in Tableau of frequently taken courses by students in other vocation centers. Business Intelligence & Data Mining of a European bank using SAS, CMU, Designed K-means clustering model for customer and market segments, and identified valuable customers for target marketing., Imputed customer data, and trained data for logistic regression and predicted customer decision to take term deposit in future.
Certification
Tableau Desktop Specialist
Timeline
Data Science Consultant (Decision Support)
Highmark Inc. (Highmark Health)
10.2021 - Current
11 Tableau Badges
06-2020
Tableau Desktop Specialist
06-2019
Senior Decision Support Analyst
Highmark Inc. (Highmark Health)
01.2019 - 10.2021
Analytics & Reports Developer
Collabera Inc.
09.2018 - 01.2019
Professional Scrum Master I Certified
12-2017
BI Analyst and Project Lead
Tata Consultancy Services
01.2015 - 05.2017
Data Analyst
Tata Consultancy Services
06.2012 - 12.2014
Master of Information Systems Management - Information Systems Management
Carnegie Mellon University, Heinz College of Information Systems
05.2001 - 05.2018
Bachelor of Technology - Information Technology
SOA University, Institute of Technical Education & Research
Similar Profiles
Martins WilliamsMartins Williams
Inventory Specialist at Highmark HealthInventory Specialist at Highmark Health
Fawn Zakor, CPPFawn Zakor, CPP
Police Officer at Highmark HealthPolice Officer at Highmark Health
Rachel PhillipsRachel Phillips
Sr. Project Manager, Business Ops & Strategy at Highmark HealthSr. Project Manager, Business Ops & Strategy at Highmark Health