Data Engineer & Analyts

ANUSMRITI SIKDAR

Ó +1-661-***-**** Sunnyvale, CA R *********.********@*****.*** anusmriti08 anusmriti26 SUMMARY

Recent Data Analytics graduate and Data Engineer with over 5 years of industry experience in data engineering and analytics. Skilled in SQL, Python, and Tableau with a strong background in data modeling. Extensive experience with healthcare and claims data, including knowledge of industry standards for medical records retrieval (HIPAA). SKILLS

Programming: Python (Numpy, Pandas), SQL, R, Java

Database & Big Data: MySQL, PostgreSQL, NoSQL(MongoDB), Hadoop, Spark, Hive Data Analytics: Data Cleaning, Data Wrangling, Data Mining, Data Visualization, Predictive Analysis, A/B Testing Data Engineering: Data Modeling, ETL pipelines, CI/CD process, Apache Airflow, GCP, AWS Data Visualization: Matplotlib, Seaborn, Tableau, PowerBI, Excel(v-look up, Pivot tables), MS Office Suite WORK EXPERIENCES

Data Engineer and Analyst - MetLife (via Cognizant), India Mar 2018 - Nov 2021

• Managed policy expansion projects by enhancing existing systems with new features and coverage options. The tasks included gathering requirements, designing data pipelines, coding, testing, documentation, deployment, and post-deployment support.

• Led a team on the annual fund expansion project, enhancing the system to handle larger financial transactions. Optimized ETL processes, cutting down processing time by 40% and improving reporting accuracy.

• Automated the weekly batch processing cycle for policy additions, saving 10 man-hours per week.

• Utilized Agile practices and SQL for root cause analysis, resolving data defects, maintaining data integrity, and enhancing the quality of claims data reporting.

Junior Data Engineer, Analytics - Chubb Insurance (via IBM), India Mar 2016 - Mar 2018

• Optimized client data warehouse and ensured data quality through advanced SQL queries and schema design. Presented key performance indicators (KPIs) through Tableau dashboards, helping clients in decision-making across the organization.

• Analyzed healthcare, claims and financial data reports to identify discrepancies and automate repetitive data fixes and reporting, reducing quarterly release costs by 35%.

• Authored key Technical Design Documents and Traceability Matrices, and defined 70+ user stories in Jira. EDUCATION

Master of Science in Data Analytics Jan 2023 - Dec 2024 San Jose State University, San Jose, CA GPA: 3.5/4.0 Relevant Coursework: Python(Data Structures & Algorithms), Database Systems, Mathematics & Statistics, Machine Learning, Deep Learning & Computer Vision, Data Mining, Data Visualization, Big Data Analytics Bachelor of Technology in Electronics and Communication Engineering Aug 2011 - Jul 2015 West Bengal University of Technology, West Bengal, India GPA: 8.0/10.0 ACADEMIC PROJECTS

Large-Scale Personalized AI Financial Analyst

• Fine-tuned LLAMA 3.1 using custom datasets and RAG (Retrieval Augmented Generation) to develop an AI-powered financial analyst for real-time stock recommendations for Dow Jones 30 companies via a Streamlit interface. Technologies & APIs used: Python, PyTorch, Yahoo Finance API, Finnhub API, Streamlit. Instacart Data Analysis

• Analyzed Instacart order and user data to predict next purchases, segment users, and identify reorders and churn. Applied Market Basket Analysis and Customer Segmentation to enhance marketing strategy and customer retention. Technologies used: Python, SQL, Scikit-Learn, Tableau. Analysis of US Weather Data

• Extracted, transformed, and loaded data from AWS S3 into Snowflake using Apache Airflow, establishing a 15 minute interval data pipeline. Achieved 89% accuracy in weather predictions displayed on a Tableau dashboard. Technologies used: Python, SQL, Apache Airflow, Snowflake, Tableau. RECENT CERTIFICATIONS

• IBM - Databases and SQL for Data Science with Python - October 2024

Contact this candidate