Kunwar Siddharth Tiwary
Pittsburgh
Summary
Dynamic Lead Analyst with Highmark Health, adept at driving strategic initiatives through advanced SQL programming and data visualization. Spearheaded the development of interactive dashboards, enhancing reporting accuracy and operational efficiency. Proven stakeholder management skills complemented by a strong focus on data integrity, resulting in significant process improvements and project delivery under budget. Goal-oriented professional successfully assists companies by developing and implementing updates to operational standards, team organization and employee engagement strategies. Proactive and personable leader with top-notch skills in streamlining information, prioritizing tasks and approaching issues with analytical mindset. Bringing years of experience and demonstrated track record of success. Qualified Business Intelligence Analyst versed in data mapping and user acceptance testing to solve complex problems in high-pressure environments. Activates strong analytical skills to investigate trends in large amounts of data, and formulate conclusions based on findings. Excels at cultivating, managing and leveraging client relationships to foster extended engagements and business opportunities.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Lead Analyst / Project Manager
Helion
Pittsburgh
03.2023 - Current
- Orchestrate financial audits and engineered complex SQL queries to detect inconsistencies to ensure uncompromised data integrity across insurance platforms
- Pioneer the deployment of a relational database management system (RDBMS) to enhance claims reporting precision and expedite data retrieval from the Enterprise Data Warehouse (EDW)
- Refine and automate ETL processes with Alteryx, enabling a seamless CMS tool upgrade and fortifying healthcare reporting capabilities
- Collaborate cross-functionally with stakeholders to synchronize technical initiatives with business imperatives, driving strategic alignment and process optimization
- Manage project budgets ranging from $1.2M to $2.8M while ensuring adherence to Statement of Work (SOW) deliverables using ServiceNow and TeamGantt for stakeholder alignment
- Revamped Medicaid data processing workflows via SAS Enterprise and SAS Programming, elevating reporting accuracy and streamlining operational efficiency
- Designed and launched interactive dashboards using Tableau and DataIQ, accelerating claims processing efficiency by 10% through data-driven insights
- Facilitated bi-weekly stakeholder reviews using Miro and Confluence to maintain transparency and alignment with SOW milestones
- Developed a digital health platform integrating personalized patient education and medication adherence tracking, enhancing preventive care engagement for Medicaid beneficiaries with chronic conditions
- Led cross-functional teams to implement data-driven interventions, improving adherence rates, reducing preventable hospital visits, and ensuring seamless integration with healthcare systems
- Managed a $1.8M project budget and delivered 12% under budget through effective resource allocation and stakeholder expectation management via Smartsheet and MS Project
Senior Analyst / Project Delivery Lead
Highmark Health
Pittsburgh
08.2021 - 03.2023
- Designed and developed interactive Tableau dashboards with HTML and CSS, improving data visualization and user engagement
- Engineered and maintained SQL and SAS scripts to extract and refine Oracle database data for optimum accuracy and efficiency in reporting
- Partnered with business stakeholders and agile teams to translate complex requirements into scalable, data-driven solutions
- Steered process improvement initiatives by identifying inefficiencies, implementing strategies to enhance data quality, and optimizing reporting accuracy
- Coordinated with IT and development teams to integrate front-end technologies with backend analytics, streamlining reporting workflows
- Managed project portfolios valued at $1.5M to $3M, leveraging Monday.com and Wrike for SOW tracking and stakeholder communication
- Modernized Delaware Medicaid claims analytics by executing advanced data processing and visualization tools, resulting in enhancing reporting accuracy and decision-making efficiency
- Drove claims workflows by reducing processing time and improving data integrity via integration of cutting-edge analytics solutions
- Deployed custom web-based reporting tools aimed at enabling real-time monitoring and performance analysis of Medicaid systems
- Utilized Lucidchart and Confluence for SOW documentation and stakeholder engagement, ensuring 100% alignment with project deliverables
Decision Support Analyst
Highmark Health
Pittsburgh
04.2020 - 08.2021
- Architected Medicaid reports for Delaware, ensuring seamless processing of claims, encounters, enrollment, and risk revenue data
- Modernized cross-functional collaboration with business analysts and technical teams to refine client requirements data integrity protocols
- Spearheaded process improvement initiatives by documenting enhancements, streamlining reporting workflows, and aligning stakeholder communications
- Evaluated existing systems, diagnosed inefficiencies, and prescribed innovative solutions to elevate data accuracy and reporting performance
- Managed SOW negotiations and execution for projects with budgets of $1M to $2.4M using Asana and Trello for milestone tracking
- Executed interactive Tableau dashboards and Oracle-based reports, amplifying operational insights and strategic decision-making
- Fortified data accuracy and accelerated reporting efficiency by engineering and optimizing SAS and SQL scripts to process high-volume datasets
- Conducted bi-weekly SOW review sessions with key stakeholders using Microsoft Teams and Miro boards to maintain project momentum
- Developed a predictive analytics solution using SAS and SQL, integrating 5M+ Medicaid records to identify high-risk members and forecast care gaps, improving early intervention strategies
- Built statistical models in SAS Enterprise Guide, achieving 87% accuracy in predicting hospitalization risk and optimizing population health management
- Automated ETL workflows, reducing processing time from 40+ hours to under 8 hours, while optimizing data structures to improve query response time by 65%, enhancing real-time decision-making
- Delivered the $2.2M project on schedule and within budget constraints through effective stakeholder management using TeamGantt and Confluence
Program Manager
Highmark Health
Pittsburgh
08.2019 - 03.2020
- Company Overview: (Contractor)
- Advanced SAS-based reporting tools to upscale system performance and reliability while overseeing agile project activities, including timelines, documentation, and report testing
- Authored standard operating procedures and technical guides, facilitating seamless system integrations, data transitions, and process optimizations
- Bridged communication between business analysts, developers, and stakeholders, translating complex requirements into scalable technical solutions
- Monitored performance metrics and maintained audit-ready documentation, driving continuous improvement initiatives in Medicaid analytics
- Managed project budgets of $1.3M to $2.7M and ensured SOW compliance utilizing Jira and Monday.com for stakeholder engagement and milestone tracking
- Implemented an enhanced patient appointment scheduling system at Regional Medical Center, reducing no-show rates, decreasing patient wait times, and optimizing provider availability for improved operational efficiency
- Championed the development of Medicaid analytics solutions for Delaware state initiatives for data accuracy, regulatory compliance, and streamlined reporting, resulting in improving decision-making efficiency
- Reduced processing errors and improved Medicaid reporting system efficiency by steering code enhancements and troubleshooting initiatives
- Integrated machine learning techniques to uncover data trends, enhancing transparency and accuracy in healthcare cost reporting
- Utilized Miro and Lucidchart for SOW visualization and stakeholder management, increasing project transparency by 40%
- (Contractor)
Onshore Coordinator | Program Manager
Citi Group
Texas
08.2017 - 06.2019
- Company Overview: (Contractor)
- Guided cross-functional teams in KYC and AML program initiatives to rationalize analytical methodologies and operational efficiency
- Streamlined workflow through agile methodologies to boost team productivity and project timelines
- Directed data mapping and testing using Ab Initio for maximum accuracy and compliance in financial data processing
- Spearheaded initiatives to enhance data analysis techniques, driving significant improvements in decision-making and efficiency
- Fostered collaboration across teams, aligning technical solutions with business objectives to optimize performance and regulatory compliance
- Managed project portfolios valued at $1.7M to $3M with detailed SOW tracking via ServiceNow and MS Project
- Revamped the expense categorization feature in the Citi Mobile app, leveraging data-driven algorithms to enhance transaction accuracy, streamline spending insights, and improve user engagement
- Increased targeting precision and campaign effectiveness through the development of predictive models aimed at refining marketing strategies
- Facilitated weekly stakeholder alignment sessions using Confluence and Miro to ensure adherence to SOW milestones and deliverables
- (Contractor)
SAS Developer
Lobel Financial
Fresno
10.2016 - 05.2017
- Company Overview: (Contractor)
- Engineered and optimized SAS reports for pricing strategies, sales forecasting, promotions, and targeted marketing, driving data-driven decision-making
- Spearheaded predictive modeling initiatives, leveraging SAS analytics to enhance marketing strategies, optimize customer targeting, and improve business insights
- Managed deliverables for projects with budgets of $1M to $1.5M, utilizing Trello and Asana for SOW tracking and stakeholder management
- Developed advanced SAS macros, improving workflow efficiency and reducing processing time by 20%, while ensuring 99.9% accuracy in reporting
- Conducted bi-weekly SOW review sessions with stakeholders using Microsoft Teams and Smartsheet to maintain project momentum
- (Contractor)
Program Manager | SAS Developer
Nationwide Insurance
Brea
09.2015 - 09.2016
- Company Overview: (Contractor)
- Designed and implemented GIS spatial overlays, enhancing data accuracy and integrity by eliminating topological errors, while optimizing CRM strategies to improve client engagement and decision-making
- Led application development projects, overseeing the design, testing, and certification of software functionalities, and streamlining data processing workflows to enhance operational efficiency
- Managed project budgets of $1.2M to $2.5M with SOW compliance tracking via Jira and Wrike for transparent stakeholder communication
- Developed predictive models to assess customer purchasing power, leveraging regression analysis and Maximum Likelihood Estimation (MLE) to optimize credit risk assessment and market segmentation
- Utilized Lucidchart and Confluence for SOW documentation and visualization, ensuring stakeholder alignment throughout project lifecycle
- (Contractor)
Statistical Programmer
HDFC Bank PVT. LTD
India
08.2013 - 06.2015
- Company Overview: (Contractor)
- Engineered high-performance SAS programs for data analysis, QA, and reporting, enhancing data accuracy and decision-making
- Innovated predictive analytics solutions that enhanced customer engagement and improved financial forecasting
- Strategized technology adoption by aligning software solutions with emerging market trends, driving competitive advantage
- Managed deliverables for projects with budgets of $1M to $2.2M, utilizing Asana and MS Project for SOW milestone tracking
- Optimized project workflows using Lean Six Sigma methodologies, reducing project delivery time by 30%
- Accelerated report generation efficiency by 40% through the development of a proprietary data analytics tool
- Spearheaded Agile-driven process improvements, increasing team productivity and ensuring seamless project execution
- Mentored and upskilled 10+ junior programmers, fostering expertise in SAS programming and statistical modeling
- Conducted monthly SOW reviews with stakeholders using Smartsheet and Miro boards to maintain alignment with project deliverables
- (Contractor)
Education
Ph.D. - Information Technology
University of The Cumberlands
Williamsburg, KY05-2026
Master of Science - Management Information Systems
University of The Cumberlands
Williamsburg, KY05-2023
Master of Science - Industrial Engineering
California State University Fresno
05-2017
Skills
- Data analysis
- Machine learning
- Project management
- SQL programming
- Data visualization
- Data integrity
- Stakeholder management
- Competitive analysis
- Stakeholder engagement
- Critical thinking
- Trend analysis
- Key performance indicators
- Dashboard creation
- Business intelligence
- ETL development
- SAS programming
- Tableau expertise
- Test planning and documentation
- Financial planning
- Teamwork and collaboration
- Complex Problem-solving
- Business tracking
- Analytical skills
Certification
- Six Sigma Master Black Belt
- Six Sigma Black Belt
- IIBA Certified Agile Product Owner
- PMI certified Project Manager
Timeline
Lead Analyst / Project Manager
Helion
03.2023 - Current
Senior Analyst / Project Delivery Lead
Highmark Health
08.2021 - 03.2023
Decision Support Analyst
Highmark Health
04.2020 - 08.2021
Program Manager
Highmark Health
08.2019 - 03.2020
Onshore Coordinator | Program Manager
Citi Group
08.2017 - 06.2019
SAS Developer
Lobel Financial
10.2016 - 05.2017
Program Manager | SAS Developer
Nationwide Insurance
09.2015 - 09.2016
Statistical Programmer
HDFC Bank PVT. LTD
08.2013 - 06.2015
Ph.D. - Information Technology
University of The Cumberlands
Master of Science - Management Information Systems
University of The Cumberlands
Master of Science - Industrial Engineering
California State University Fresno
Similar Profiles
Jonathan LongstreetJonathan Longstreet
Fusion Technician at HelionFusion Technician at Helion
Arlene TORRESArlene TORRES
Fusion Technician at Helion EnergyFusion Technician at Helion Energy
Matthew PetersonMatthew Peterson
Client Technology Manager at Helion Automotive TechnologiesClient Technology Manager at Helion Automotive Technologies