Summary
Overview
Work History
Education
Skills
Certification
Course Projects
Timeline
Generic

Jahnavi Allam

Fremont

Summary

Data Analyst and Data Engineer with 4+ years of experience in leveraging SQL, Python, and BI tools to derive actionable insights and optimize business performance. Proven expertise in fraud detection, transaction analysis, and financial risk analytics in fintech and healthcare domains. Adept at building dashboards, streamlining ETL processes, and collaborating cross-functionally to drive data-driven decisions. Passionate about solving complex problems using advanced analytics and machine learning.

Overview

7
7
years of professional experience
1
1
Certification

Work History

SENIOR DATA ANALYST

Cogni, Inc.
Milpitas
07.2021 - Current
  • Developed multiple dashboards in Tableau/Looker, reducing manual reporting time by 30% and improving executive decision-making to give an overall business picture on different financial parameters to provide daily insights to product managers to reflect on the current trend customer growth
  • Built Python-based ETL scripts to extract, transform, and load data from AWS Redshift, centralizing customer data and enabling faster fraud detection for the CFR team to access comprehensive customer-related data from a single source
  • Developed PostgreSQL queries on daily need basis to assist Marketing, Development, Test, CFR, and CS team
  • Performed Power PIVOT, Pivot tables and written formulae in advanced Excel and Google sheets
  • Developed automated reports for compliance and regulatory reporting, streamlining workflows by 30%
  • Developed accessible and data-driven dashboard trends based on a real-time monitoring for Fraud dashboard, Onboarding users, Transactions, etc., to help the business need
  • Developed predictive analysis on customer data on weekly, monthly, and quarterly basis using Looker Studio/Tableau with increasing monthly active users
  • Designed fraud detection models that improved fraud identification rates by 20%, leading to proactive risk mitigation
  • Reviewed and Tested Cogni Mobile Banking App on release basis
  • Constantly interacting with Dev, marketing, and product management teams and provided visualizations to understand the business need
  • Conducted predictive analysis on churn rate, crypto adoption, and customer behavior, new onboarding users influencing business strategies to help CEO’s make decisions about future state of improvement in banking services
  • Worked on ingesting data from multiple disparate heterogeneous upstream sources and transforming and curating the data into high-quality, easy-to-use data models
  • Partnered with Product Managers and Marketing teams to refine transaction monitoring strategies, reducing false positives by 15%
  • Empower all our stakeholders to make data driven business decisions by providing Daily Reports, WBRs, Analyses/Narratives and Datasets
  • Innovate on behalf of our end-users to produce relevant Metrics, Automations and Tools to make Data and Insights actionable
  • Responsible for keeping track of tasks, Issue logs and status of the deliverables using JIRA

GRADUATE ASSISTANT

University of North Texas
Denton
10.2019 - 11.2020
  • Designed database tables and structures, created views, functions, and wrote optimized SQL queries for integration
  • Created visualizations for the data by using Tableau, Designed Dashboards, Twisting SQL queries for improving performance
  • Produced ad-hoc reports with V-lookups, Pivot tables, Pivot charts and Macros in Excel and recommended solutions to drive decision making, for business problems and provided business modelling solutions

HEALTHCARE DATA ANALYST

Signet Soft Pvt Ltd.
Bangalore
01.2018 - 07.2019
  • Developed and managed end-to-end ETL pipelines, processing and transforming large-scale healthcare data to ensure seamless data integration
  • Designed and optimized database architectures, reducing query execution time by 40% and improving overall system performance
  • Implemented real-time data streaming solutions using Apache Kafka, enhancing data availability for analytics teams
  • Developed predictive analytics models for healthcare claims processing, improving fraud detection and cost efficiency
  • Automated data quality checks and validation processes, ensuring 99.9% data accuracy and reducing manual efforts by 50%
  • Led collaboration with cross-functional teams to enhance data governance, security, and compliance with HIPAA regulations

Education

Master of Science - Data Science

University of North Texas
Denton, TX
05.2021

Skills

  • Data analytic algorithms
  • Linear regression
  • Logistic regression
  • KNN
  • K-Mean
  • Decision trees
  • Cluster analysis
  • Neural Networks
  • SQL
  • AWS
  • Python
  • R
  • Tableau
  • Power PIVOT
  • Extract Transform Load (ETL)
  • Hadoop
  • Advanced data analytics
  • Power BI
  • Looker Studio
  • Google Data Studio
  • Excel
  • AWS Redshift
  • Spark
  • Airflow
  • Apache NiFi
  • SSIS
  • Machine Learning
  • Analytics
  • Clustering
  • Data visualization

Certification

  • Google Data Analytics Professional Certificate
  • AWS Certified Data Analytics – Specialty

Course Projects

  • Netflix Video Recommender, Python, ML-SVD, Tableau, EDA Spring '21
  • Hospital Management system, Data Modelling-ERD, My SQL Workbench, Draw.io Fall '20
  • FIFA Data Analysis, Data Visualization, Tableau Spring '20
  • Data Analysis of the Foodservice Zomato, Data Mining, SAS enterprise miner. Fall '19

Timeline

SENIOR DATA ANALYST

Cogni, Inc.
07.2021 - Current

GRADUATE ASSISTANT

University of North Texas
10.2019 - 11.2020

HEALTHCARE DATA ANALYST

Signet Soft Pvt Ltd.
01.2018 - 07.2019

Master of Science - Data Science

University of North Texas

Similar Profiles

CREATE PROFILE
Jahnavi Allam