Data Analyst Business Intelligence

Aruna Yadav

Data Analyst

Location: IL Mobile: 872-***-**** Email: *************@*****.*** LinkedIn SUMMARY

Data Analyst with around 5 years of experience utilizing Agile and Waterfall methodologies to deliver data-driven healthcare and business intelligence solutions. Proficient in Python, SQL, Tableau, Power BI, and big data tools like Apache Spark and Databricks, with expertise in machine learning algorithms including Linear Regression and Random Forests. Skilled in Azure, Snowflake, and data wrangling, consistently enhancing operational efficiency by up to 20%. Strong communicator with a proven ability to present actionable insights to stakeholders, driving strategic decisions. SKILLS

Methodologies: SDLC, Agile, Waterfall

Languages: Python, SQL

Packages: NumPy, Pandas, Matplotlib, SciPy, Seaborn Visualization Tools: Tableau, Power BI, Microsoft Excel Cloud Platforms: Azure

ML Algorithm: Linear Regression, Logistic Regression, Decision Trees, Supervised Learning, Unsupervised Learning, Classification, SVM, Random Forests, Naive Bayes, KNN, K Means, CNN Big Data Technologies: Hadoop, MapReduce, Hive, Apache Spark, Pig, Databricks Database: MySQL, SQL Server, MongoDB, Snowflake

Other Skills: Data Cleaning, Data Wrangling, Critical Thinking, Communication Skills, Presentation Skills, Problem-Solving Operating System: Windows, Linux

EDUCATION

Master of Technology (MTech.) in Computer Science Engineering June 2012 Banasthali Vidyapith, Rajasthan, India

Bachelor of Technology (B.Tech.) in Computer Science Engineering June 2008 KIET Group of Institutions, Uttar Pradesh Technical University, UP, India EXPERIENCE

Cigna, IL Nov 2023 - Current Data Analyst

• Leveraged Agile methodology to collaborate with cross-functional teams, delivering iterative data analysis projects that improved healthcare claim processing efficiency by 15%.

• Developed Python scripts using NumPy and Pandas to clean and preprocess large datasets, reducing data inconsistencies by 20% for downstream analytics.

• Utilized Tableau to create interactive dashboards visualizing patient enrollment trends, enabling stakeholders to make data- driven decisions for resource allocation.

• Applied Linear Regression models in Supervised Learning to predict healthcare costs, achieving an R score of 0.85 for cost forecasting accuracy.

• Queried MySQL databases to extract and analyze customer demographic data, supporting targeted marketing campaigns that increased engagement by 10%.

• Employed Azure Data Lake Storage (ADLS) for secure storage and retrieval of sensitive healthcare datasets, ensuring compliance with HIPAA regulations.

• Demonstrated critical thinking by identifying and resolving data quality issues in claims datasets, improving reporting accuracy by 25%.

Infinite Infolab, India Aug 2018 - July 2021 Data Analyst

• Implemented Waterfall methodology to execute structured data analysis projects, ensuring timely delivery of business intelligence reports for clients.

• Used Power BI to develop dynamic reports on operational KPIs, reducing report generation time by 30% through automated data pipelines.

• Applied Random Forests and KNN algorithms in Classification tasks to segment customers, improving marketing campaign targeting by 18%.

• Utilized Apache Spark on Databricks to process and analyze large-scale transactional datasets, accelerating data processing by 40%.

• Queried Snowflake to extract and transform financial data, supporting real-time analytics for budgeting and forecasting.

• Deployed data wrangling techniques to standardize unstructured datasets, improving data usability for machine learning models by 15%.

• Showcased presentation skills by delivering insights to senior leadership and translating complex data findings into actionable business strategies.

CERTIFICATIONS AND TRAINING:

IBM DB2 certified.

PHP & MYSQL certification from IIT Bombay.

Sci-Lab certification from IIT Bombay.

Linux certification from IIT Bombay.

Udemy: The complete agile and scrum project management course, Microsoft Power BI Desktop for Business Intelligence, Python for absolute beginners,

Data analysis SQL, Tableau, Power BI &Excel Real Projects. LinkedIn: Deep Learning and Generative AI: Data Prep, Analysis, and Visualization with Python, SQL for Testers, ETL in Python & SQL,

Power BI Data Modeling with DAX,

Python Data Analysis,

Top 10 skills for Health Care Data Analyst.

Contact this candidate