Data Analyst with AI-Driven Analytics Expertise

Niharika Yarala

Data Analyst

IL, USA M.no: +1-551-***-**** Email: ***************@*****.*** LinkedIn SUMMARY

• Data Analyst with 4 years of experience in healthcare and financial domains, specializing in data extraction, transformation, and advanced analytics using Python, SQL, R, and Scala.

• Proven track record of developing AI-driven predictive models, NLP solutions, and credit risk frameworks, improving healthcare outcomes and lending precision by 15–26%.

• Skilled in designing interactive dashboards (Power BI, Tableau, Advanced Excel) to provide actionable business insights for clinical teams, risk officers, and leadership.

• Hands-on expertise in cloud platforms (AWS, Azure, Snowflake) to build scalable ETL pipelines and enable regulatory-compliant analytics workflows (HIPAA, Basel III, CCAR).

• Strong background in machine learning, A/B testing, predictive modeling, and statistical analysis, leveraging libraries like Pandas, NumPy, Scikit-learn, and TensorFlow.

SKILLS

Programming Language:

Methodologies:

Python, SQL, Scala, R

SDLC, Waterfall, Agile-Scrum, Rational Unified Process (RUP) Packages: NumPy, Pandas, Matplotlib, SciPy, Scikit-learn, TensorFlow, Seaborn, GGplot Visualization Tools: Tableau, Power BI, Advanced Excel (Pivot Tables, VLOOKUP), CRM Analytics Cloud Technologies: AWS (EC2, S3, Redshift, Athena, Glue, DynamoDB), Azure, Snowflake Database:

Business Skills:

Soft Skills:

MySQL, PostgreSQL, MongoDB, Oracle

Change Management, Impact Analysis, Risk Analysis, ROI Analysis, SWOT analysis, Root Cause Analysis, BRD, FRD, Process Modelling

KPI Tracking, Time management, Leadership, Management, Problem-solving, Negotiation, Decision-Making, Documentation and Presentation, Verbal communication, Stakeholder Management, Risk Management, Flexibility, Networking, Optimization, Self-starter Operating Systems:

Other Technical Skills:

WORK EXPERIENCE

Windows, Linux, Mac OS

Machine Learning Algorithms, ETL Tools, Exploratory Analysis, Probability distributions, Predictive Modelling, Hypothesis Testing, Regression Analysis, Linear Algebra, Advance Analytics, SSIS, SSRS, Confidence Intervals, ANOVA, Data Storytelling, Association rules, Data Mining, Data warehousing, Data transformation, Big Data, Clustering, Classification, Regression, A/B Testing, Forecasting & Modeling, statistics, Data Profiling, Data Cleaning, Data Wrangling, Jira, Confluence, Snowflake, Informatica, GitHub, SVN, Bitbucket Blue Cross Blue Shield of Illinois Data Analyst

Jul 2024 - Present

• Designed and executed SQL queries to extract, join, and filter high-volume EHR, patient feedback, and claims datasets from Epic and Cerner systems, enabling accurate clinical decision-making and reducing patient readmission rates by 12%.

• Performed data cleaning, wrangling, and exploratory data analysis (EDA) using Python (Pandas, NumPy, Seaborn) and Excel

(pivot tables, advanced formulas, VBA), improving data quality scores by 18% and ensuring readiness for advanced analytics.

• Developed and deployed AI-driven predictive models in R (regression, classification) to forecast readmission risk and treatment effectiveness, supporting personalized care planning and improving quality-of-care metrics by 15%

• Built interactive dashboards in Power BI to track patient journeys, diagnosis history, treatment outcomes, and population health trends, used by clinical teams, nurse leaders, and hospital administrators for data-driven interventions.

• Conducted A/B testing and statistical modelling in R to evaluate the impact of new clinical protocols, leading to adoption of evidence-based practices and a measurable 10% improvement in treatment success rates.

• Applied Natural Language Processing (NLP) on patient feedback data to uncover sentiment and common care concerns, improving patient engagement strategies.

• Collaborated cross-functionally with data engineers, clinical informaticists, physicians, and compliance officers to align data architecture, governance, and analytics workflows with HIPAA regulations and healthcare audit standards.

• Implemented HIPAA-compliant data masking, PHI protection, and secure data pipelines to safeguard sensitive patient information while ensuring analytical accessibility for authorized personnel. Capgemini, India Data Analyst

Jan 2021 – Jul 2023

• Built profitability scoring models and AI-powered credit risk segmentation frameworks using SQL (Teradata, Oracle), Python (Pandas, NumPy), and R (clustering, logistic regression), improving lending decision precision by 23%.

• Designed behavioral segmentation strategies based on customer lifetime value (CLV), delinquency trends, and payment behavior, driving 15% improvement in loan portfolio performance.

• Developed regulatory-compliant stress testing models for Basel III and CCAR, automating SAS-based reporting and reducing audit turnaround time by 40%.

• Delivered executive-ready KPI dashboards using Tableau, enabling credit, compliance, and risk teams to monitor risk exposure and profitability in real time.

• Conducted in-depth analysis of transactional and payment data to identify default risk patterns, which led to a 26% increase in credit risk model precision.

• Integrated machine learning models into reporting workflows, providing predictive insights on delinquency risk and repayment patterns.

• Built cloud-based analytics workflows in Snowflake, ensuring scalable integration of behavioral and credit data with automated data quality validations and fraud trend detection.

• Collaborated cross-functionally with risk analysts, credit policy officers, data engineers, and finance leads using Git and Jira for Agile development and transparent version control.

• Created self-service analytics dashboards and automated reporting pipelines, cutting manual reporting efforts by 35% and improving insights delivery to compliance and executive leadership. EDUCATION

Sacred Heart University, Fairfield, CT: Master of Science in Business Analytics Osmania University, Hyderabad, India: Bachelor of Arts in Economics CERTIFICATION

Google Cloud Certified - Professional Data Engineer AWS Certified Data Engineer – Associate

Microsoft Office Specialist - Excel Associate

Microsoft Office Specialist - Microsoft Excel Expert

Contact this candidate