Shikhar Aditya
Email: satyamshikhar@gmail.com Mobile: +91 9082355413
Education &bull;
Central University of Ra jasthan
Ajmer, India
Master of Science - Computer Science(Data Science and Analytics); GPA: 8.06 2021 - 2023
Courses: Probability Distribution, Linear Algebra, Statistical Methods,Computing for Data Science, Machine Learning, Cloud
Computing, Databases,Data Mining,Operations Management,Hadoop for Big Data
&bull; University of Mumbai
Mumbai, India
Bachelor of Science - Computer Science; GPA: 9.93 2018 - 2021
Courses: Operating Systems,Databases,Networking,Programming with C,Linux,Data Structures and Algorithms
Skills Summary &bull;
Languages : Python, R, Java, SQL, HTML/JS/CSS
&bull; Frameworks : Scikit-learn, Flask, Django, Apache Airflow, Android Studio, React
&bull; Tools : GIT, Prompt Engineering, Power BI, Excel, Pyspark, Databricks, Selenium
Work Experience ◦
Data Analyst - Advisai Consulting, Lucknow : [Nov 2023 - Present]
&lowast; Designed and deployed an AI-driven news app on AWS, boosting daily news published by 400%. Integrated AI news
summarization for smoother publishing workflows
&lowast; Analyzed client data to pinpoint inefficiencies in marketing strategies, revealing underperformance in user acquisition
by current agency. Proposed strategic recommendations resulting in substantial cost reductions and improved ROI
metrics.
&lowast; Produced and delivered weekly and bi-weekly analytics reports using Power BI, enabling clients to track and
visualize their performance metrics effectively.
◦ Backend Engineer and Analyst - LocalWell Healthtech Pvt. Ltd, Bangalore : [Jan 2023 - Oct 2023]
&lowast; Accomplished creation of Data Pipeline integrating multiple APIs,reducing manual data ingestion and verification
&lowast; Revamped multiple third party APIs into the system, made their interaction efficient and scalable.
&lowast; Analysed features and components of application, enhancing user experience
Projects &bull;
AI News Aggregator App :
Problem Statement - Client experienced a substantial deficit in the number of news articles published, hindering their
competitive edge in the market.
Recognizing the need for a solution, developed an AI-powered news collector app to address this issue. The app&rsquo;s purpose was
to aggregate news content efficiently from various sources, enabling Client to significantly increase their daily publication
output and maintain relevance in their industry.
Tech Stack - Python/Flask, React, ChatGPT API, CSS/JS
&bull; Web Scraping Data Verification and Decision Support Pipeline :
Problem Statement - To validate the medications existing in LocalWell&rsquo;s database and incorporate new drugs and products
sourced from external websites through web scraping.
Designed and implemented data pipelines that automated the process of scraping data from various websites, cleaning and
transforming the acquired data, and ingesting it into our databases.Resulting in verification of about 300,000 products.
Tech Stack - Python, Flask, Jupyter Notebooks, PostgreSQL, Beautifulsoup, Requests
&bull; Unified CSV File Integration and Performance Enhancement :
Problem Statement - Enhance CSV purchase bill handling and optimisation of backend API.
Created an efficient API that could identify and categorize both organized and unorganized CSV files, intelligently mapping
data to specific software formats for seamless extraction.fine-tuned the code to automatically map CSV files to various
formats.Cutting processing time from 15 seconds to just 7 seconds.
Tech stack - Python, Requests, Flask, Postman, PostgreSQL
Certifications &bull;
*Google Data Analytics Professional Certificate : Coursera - Certification in Foundation of data, Data Processing, Data
Analysis, Visualization, Analysis using R Language
&bull; Machine Learning Specialisation : Coursera - University of Washington - Specialisation in machine learning paradigms -
Classification, Regression, Clustering ; Tech used - TuriCreate, Python, Jupyter Notebook
Extracurriculars &bull;
Yoga and fitness
2023
Secured second runner up position in yoga competition for breathing exercises and advance poses.
&bull; Marathons and runs
2023
Finished runner up in 8 km run in societies running community. * - ongoing