Summary
Overview
Work History
Education
Skills
Timeline
Generic

Ankit Anand

Morrisville,NC

Summary

  • 5+ years of experience in Information Technology as a Data Analyst and Data Modeler with advanced analytical and problemsolving skills.
  • Excellent knowledge of Software Development Life Cycle (SDLC) and various methodologies such as Agile and Waterfall.
  • Experience in Python, R, and SQL, leveraging advanced analytical techniques to extract, manipulate, and analyze large datasets, providing valuable business insights.
  • Skilled in using Visual Studio Code and PyCharm as IDEs, and employing libraries like NumPy, Pandas, Matplotlib, SciPy, and ggplot2 to perform sophisticated data analysis and visualization.
  • Expert in analyzing business user requirements, analyzing data, and designing software solutions in Tableau Desktop based on the requirements.
  • Familiarity with Cloud Technology, including AWS and Azure, utilizing cloud services for scalable and efficient data storage, processing, and analysis.
  • Experience in working with diverse databases such as MySQL, MongoDB, and PostgreSQL, ensuring seamless data management and integration for analytical projects.
  • Extensive knowledge of all phases of data mining, data collection, data cleaning, developing models, and visualization.

Overview

8
8
years of professional experience

Work History

Data Analyst III

Centene Corporation
St Louis, MO
10.2023 - Current
  • Provide advanced analytical support for business operations in these areas: claims, provider data, member data, clinical data, HEDIS, pharmacy, external reporting.
  • Lead the planning and execution of large-scale projects and new reporting tools, translating business goals into actionable solutions
  • Model data using advanced analytical tool
  • Extract, load, model, and reconcile large amounts of data across multiple system platforms and sources.
  • Review data to determine operational impacts and needed actions; elevate issues, trends, area for improvement and opportunities to management.
  • Develop report and deliverables for management.

Trainee Software Developer

SourceMantra
Westford, MA
02.2023 - 10.2023
  • Collaborate effectively with cross-functional teams and stakeholders to follow the SDLC and Agile methodologies in project execution.
  • Use packages like ggplot2 in R Studio for data visualization, and generate scatter plots and high-low graphs to identify relations between different variables.
  • Create interactive Tableau dashboards that provide real-time insights to stakeholders, resulting in 20% faster decision-making.
  • Perform data validation to ensure data quality, completeness, and correctness by working with business partners using MS Excel.
  • Utilizing StatsModels to develop time series forecasting models, achieving an average accuracy of 95% in predicting sales trends, enables data-driven decision-making for inventory management.
  • Led the seamless migration of on-premises databases to AWS RDS, reducing data retrieval times by 40%, and optimizing data storage costs by 30%.
  • Manage and maintain databases on AWS, SQL Server, and MongoDB, ensuring data accuracy, consistency, and availability.

Student Assistant

UAB-Informatics Institute
Birmingham, AL
03.2022 - 12.2022
  • Worked to Improve Health Record Usability and usefulness with patient-specific clinical knowledgebase using NLP algorithms to automate and streamline medical data.
  • Normalize and map biomedical concepts, procedures, and medications using specific libraries such as SNOMED, RXNORM, and LOINC, for clinical notes written by physicians to reduce around 20 hours of manual effort per week to extract relationships.
  • Performed Named Entity Recognition using Spacy and Flair framework, data manipulation using Pandas, Numpy, and nltk.
  • Utilize NLP-based framework cTAKES based on JAVA, to convert to structured data and apply SQL, DL, and Python for the project.
  • Increased efficiency of the process by more than 75% and gained ~15 million plus in funding on 6 different projects.

System Analyst

Wipro Limited
Noida, Uttar Pradesh
09.2017 - 08.2021
  • Write SQL queries to perform Data Validation and Data Integrity testing to ensure data quality.
  • Working with various Python IDE like PyCharm and Visual Studio Code.
  • Use Pandas, NumPy, SciPy, and Matplotlib in Python for developing various machine learning algorithms.
  • Designed and implemented efficient data models and schemas, resulting reduction in data redundancy and improved query performance.
  • Developed and maintained Tableau Dashboards to take monitoring and reporting time from two weeks/month to two days/month.
  • Analyzed, documented, and reported user survey results to improve customer communication processes by 18%.
  • Utilized technology such as MySQL and Excel PowerPivot to query test data and customize end-user requests.
  • Understand Data Modelling, Data Collection, Data Cleansing, Data Warehouse, and Client/Server applications.

Education

Master of Science - Data Science

University of Alabama At Birmingham
Birmingham, AL
12-2022

Bachelor - Computer Science and Engineering

Jaipur Engineering College & Research Centre
Rajasthan, India
08-2017

Skills

  • Methodologies: SDLC, Agile, Waterfall
  • Language: Python, R, JAVA, SQL
  • IDE's: Visual Studio Code, PyCharm
  • Packages: NumPy, Pandas, Matplotlib, SciPy, Ggplot2, Seaborn, Nltk, Pyspark, Scikit-Learn, Statsmodels
  • Visualization Tools: Tableau, Power BI, Microsoft Excel
  • Cloud Technologies: AWS, Azure
  • Database: MySQL, SQL Server, MongoDB, PostgreSQL, Oracle, AWS RDS, Azure Cosmos DB, Snowflake
  • Other Skill: Data Cleaning, Data Wrangling, Critical Thinking, Communication Skills, Presentation Skills, Problem-Solving
  • OS: Windows, Linux

Timeline

Data Analyst III

Centene Corporation
10.2023 - Current

Trainee Software Developer

SourceMantra
02.2023 - 10.2023

Student Assistant

UAB-Informatics Institute
03.2022 - 12.2022

System Analyst

Wipro Limited
09.2017 - 08.2021

Master of Science - Data Science

University of Alabama At Birmingham

Bachelor - Computer Science and Engineering

Jaipur Engineering College & Research Centre

Similar Profiles

CREATE PROFILE
Ankit Anand