Snehith Acharya
Austin,TX
Summary
Results-driven Data Analyst with 4.5 years of experience specializing in data transformation, visualization, and predictive modeling within the healthcare, education, and banking sectors. Proficient in creating user-friendly dashboards and utilizing machine learning methods to enhance data-driven decision-making and operational effectiveness. Adept at working collaboratively with diverse teams to optimize workflows, provide valuable insights to key stakeholders, and maintain data integrity.
Overview
6
6
years of professional experience
Work History
Data Analyst
Cigna Health Care
02.2024 - Current
- Company Overview: Industry: Healthcare
- Responsible for providing data analysis that focused on improving user experience and optimizing user retention.
- Wrote complex ad-hoc MySQL queries involving correlated sub-queries, window functions and common table expressions to track user activity metrics such as retention rate and daily active user.
- Optimized existing queries to run faster on large dataset.
- Designed and maintained MySQL databases and created pipelines using user-defined functions and stored procedures for daily reporting tasks.
- Developed dashboards in Tableau and present data to track KPIs and product performance using data from various sources such as MS Excel, AWS S3, AWS RDS, AWS Redshift, JSON and XML.
- Spotted and analyze trends in user activity data, identify under-performed user segmentation report insight to stakeholders.
- Designed metrics for A/B testing, creating dashboards in Tableau to monitor test processes, analyzing test results, interpret and give recommendations to stakeholders.
- Performed statistical analysis such as hypothesis testing causal inference and Bayesian analysis.
- Communicated between the business, product manager and data engineers to ensure the data quality.
- Built ETL pipelines to retrieve data from No SQL databases and load aggregated data into the analytical platform.
- Managed data storing and processing using big data tools such as Hadoop, HDFS, Hive and Spark.
- Developed Python scripts to automate data validation and data cleaning processes such as deduplicating and checking data consistency using Pandas and Apache Airflow.
- Analyzed large scale user log data and generated features for classification models using SparkSQL in Spark.
- Implemented scalable machine learning models Random Forest using Spark ML and Python to predict customer churn.
- Applied advanced classification models such as XGboost, SVM, Neural Network to train data using Python packages such as Scikit-learn.
- Defined metrics to estimate impact of new features and give recommendations for business decisions based on data analysis.
- Industry: Healthcare
Data Analyst
Confluent
02.2021 - 08.2022
- Created detailed reports on student enrollment trends, identifying the most popular subjects and courses to support curriculum planning and resource allocation using Power BI dashboards for effective data visualization.
- Participated in daily scrum meeting with team to discuss on the challenges and development of the project.
- Involved in requirement gathering from business users and IT teams to understand and express business process and business logic.
- Extracted data for reporting from multiple data sources like SQL Server, SQL Server Analysis, Service, Azure SQL Database, Azure SQL Data Warehouse, Salesforce, etc.
- Extracted data from data warehouse server by developing complex SQL statements using stored-procedures and common table expressions (CTEs) to support report building.
- Implemented Tableau for visualizations and views including scatter plots, box plots, heatmaps, tree maps, donut charts, highlight tables, word clouds, reference lines, etc.
- Generated complex reports in Tableau using multiple functionalities including context filters, hierarchies, parameters, LOD Expressions, time intelligence, etc.
- Built interacting and storytelling dashboards in Tableau workbooks using dashboard actions.
- Published Tableau workbook on Tableau Server and set report refresh.
- Used Data Analysis Expressions (DAX) to create measures and calculated fields to analyze data and to create time intelligence.
- Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
- Used Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
- Created PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.
- Assisted in creating SQL database maintenance logs and presenting any issues to the database architects.
- Worked on Power BI reports using multiple types of visualizations including line charts, doughnut charts, tables, matrix, KPI, scatter plots, box plots, etc.
- Made Power BI reports more interact and activate by using storytelling features such as bookmarks, selection panes, drill through filters, etc.
- Created and administrated workspaces for each project on Power BI service and published the reports from Power BI Desktop to Power BI Services workspace.
- Utilized Power BI to create various analytical dashboards that helps business users to get quick insight of the data.
- Installed Data Gateway and configured schedule plans for Data Refresh of Power BI reports.
- Created SSIS packages for ETL processes by using control flow and data flow components.
- Maintained and tuned performance for slowly running SSIS packages.
- Responsible for accurately reporting on the financial aspect of the company's operations by rendering reports on daily / weekly / monthly base.
- Evaluated returns and risks for various types of investments including stocks, fixed-income assets, hedge fund, real estate and commodities and evaluated risk tolerance for customers.
- Created ad-hoc reports such as YTD, YOY, MTD, MOM analysis for income statement, cash flow by requests from business units.
- Implemented report integration among Power BI, Tableau, SSRS and Python reports.
Data Analyst
HSBC Corporation Limited
05.2019 - 01.2021
- Company Overview: Industry: Banking
- Interpreted data and analyzed results using statistical techniques and provided ongoing reports.
- Acquired data from primary or secondary data sources and maintained database systems.
- Built SQL complex queries for accessing and extracting data from MySQL.
- Constructed dashboard and ad-hoc reports Excel and Tableau.
- Analyzed issues for updating database and expedited 35% of data processing time.
- Industry: Banking
- Environment: MS Excel, My SQL, SQL Server, MS PowerPoint, Tableau
Education
Master of Science - Information Technology
Webster University
San Antonio, TX05.2024
Skills
- Python
- Pandas
- NumPy
- Scikit-learn
- Seaborn
- SQL
- SQL Server
- DAX
- SQL Server Management Studio
- BIDS
- SQL Server Profiler
- Power BI
- Tableau
- Matplotlib
- Power Query
- API Integrations
- AWS
- EC2
- S3
- Lambda
- QuickSight
- Git
- MS Excel
- Google Docs
- MS PowerPoint
- MS Word
- Jira
- Scrum
- Confluence
Timeline
Data Analyst
Cigna Health Care
02.2024 - Current
Data Analyst
Confluent
02.2021 - 08.2022
Data Analyst
HSBC Corporation Limited
05.2019 - 01.2021
Master of Science - Information Technology
Webster University
Similar Profiles
Wendy LanierWendy Lanier
Customer Support Specialist at Cigna Health CareCustomer Support Specialist at Cigna Health Care
Neeraja KothapallyNeeraja Kothapally
Integrated Solution Manager at Cigna Health CareIntegrated Solution Manager at Cigna Health Care
Ashley AllenAshley Allen
Customer Service Representative at CIGNA HEALTH CARECustomer Service Representative at CIGNA HEALTH CARE
Tatiana T. TorresTatiana T. Torres
Senior Enlisted Advisor at U. S. Navy, Recruit Training CommandSenior Enlisted Advisor at U. S. Navy, Recruit Training Command
JOSE MACEDOJOSE MACEDO
Trust and Safety at Accenture/WhatsappTrust and Safety at Accenture/Whatsapp