Hi, I'm Akash
Data Analyst
Welcome to my portfolio website! A passionate individual who always thrives to work on end to end products to provide meaningful insights & understand customer behavior to maximize the impact & maintain strong client relationships.
Contact meAbout Me
My introduction
I have worked as Data Analyst, During these experiences I have collaborated with the Clients & teams to transform business needs into actionable insights & used SQL queries to extract, clean, manipulate, transform data through ETL tool & create dynamic dashboards to find meaningful insights, KPI, metrices to stakeholders and maintain strong client relationships.
IT experience
Intenship experience
in data analytics
Skills
My technical levelProgramming Languages
SQL ( DBMS )
90%PYTHON / R
70%JAVA
70%Analytics Skills
Data Anaysis & Cleaning
75%Data Visualization, Data Interpretation, Reporting,
75%Data Modelling, Data Validation, ETL
50%Data Science, Python(Numpy, Pandas), R, Machine Learning, statistics
50%Analytics Tools & Framework
SQL - Microsoft SQL SERVER(SSMS,SSIS, SSAS, SSRS), MySQL, PostGreSQL, Teradata, Oracle, Hadoop, BigData-Hive-spark
85%Visualisation - PowerBI, Tableau, Quicksight, Looker, QlikView, Google Studio
80%ETL, Abinitio, Alteryx, Unix/Linux Scripting, Powershell/Putty
50%Advanced Microsoft Excel for Analysis - Vlookup, Pivot, Formula, Macros/VBA, Data Cleaning
80%JIRA, Confluence, GITHUB, Microsoft PowerPoint, Microsoft Outlook, SAP, SAS, visio, SharePoint, SDLC
80%HTML/CSS, Javascript, Salesforce, light componnet, AWS
80%SOFT SKILLS
Work Focused, Adaptive, Good Communication, Storytelling, Presentation, Data-driven, Analytical, Results-oriented
90%Qualification / Education
My Education journeyClass 10th
ARMY PUBLIC SCHOOL, BOLARUMSenior Secondary School
Class 11th & 12th
FIITEJEE JUNIOR COLLEGEHiger Secondary School
College
Vellore Institute Of TechnologyCompter Science(I.T.)
EXPERINECES
My Most recent Experience & worked on different projects where creativity meets innovation
RADARRADAR (TradesParent) | TECHNICAL BUSINESS CONSULTANT
• As Technical Consultant, responsible for building and maintaining our client relations & work closely with other technical and business consultants to identify key opportunities and build data-driven strategies to boost our clients' business • Worked closely with technical & business consultants & Clients on real-world commodity markets to analyze data & transform business needs into actionable SQL queries & conduct data normalization & validation to improve data accuracy, quality, efficiency to boost performance and maintain strong client relationships • Provided Technical Support to teams & clients with SQL best practices and troubleshoot & resolve database-related issues & SQL queries. Implemented dashboards to provide real-time insights for trading & risk to stakeholders for decision-making processes & created documentation for business requirements
BARCLAYS BANK | DATA ANALYS
• Worked in Data warehousing technologies and methodologies with knowledge in programming language SQL & reporting tool Tableau with understanding in Unix shell scripting along with hands-on Abinitio • Worked & Collaborated with Data Analysts team to understand requirements, clean, extract, transform, manipulate data from various sources & provide strategies to improved business & kept a track of key metrics. And understand end-to-end data flows, requirements, identified data dependencies, performed Analysis on Barclays Credit Card transactions datasets to gain insights on transactions made by customers over a period of past years. These insights help future marketing and business strategies for Barclays. • Built, Created, Developed, published interactive & dynamic Tableau dashboards & reports to identified trends & patterns and understand & visualize distribution of transaction amounts core KPIs to made impact on business & provided meaningful insights from data to understand customer behavior.
VODAFONE SHARED SERVICES (VOIS) | SALESFORCE ADMIN
• Part of SCM deployment team,responsible for managing & performing pre-prod. & production end-to-end ”CL” deployement lifecycle, picking & moving up all ”changes/CL” from one to another sandbox, test them & deploy till prod. as per bussiness req. • Worked on salesforce cloud with tasks including, create custom objects fields, relationships, Workflow Rules, Sharing, Validation Rules
MEDULANCE HEALTHCARE PVT LTD | DATA ANALYST INTERNSHIP
• Worked with developments teams to ensure accurate integration of ML models into firm, Compared increased efficiency & performance of each models with others & evaluated their best accuracy score which led to successful completion of internship • Improved & optimized the Model by Hyper Parametric Tuning different parameters in the model which led to increased in accuracy from 87%to 90% • It has been my privilege to have a team of project guide who have assisted me on ongoing project from the commencement of this project • Learned how to clean & analyze the data, which comes under exploratory data analysis & finally visualize using libraries & various others tools & got to enhance my practical as well as theoretical skills
TAKEN MIND | DATA ANALYST INTERNSHIP
• Worked as Intern Trainee and learned how to clean & analyze the data features, which comes under exploratory data analysis & finally visualize using libraries & various others tools. • By using some python libraries such as NumPy for multidimensional array & NumPy for feature Engineering & Feature Selection used for data cleaning & analysis and seaborn, matplotlib for visualization. • Got some insights of data wrangling & analysis and how to follow any life-cycle of any data science project
ETHNUS | AMAZON AWS TECHNICAL ESSENTIALS & ARCHITECTURE INTERNSHIP
Tasks that I completed during the course of this internship: • Work directly on AWS Cloud environment • Hands-on AWS cloud Qwik labs & where I have performed : • Hands-on 2 mini-projects AWS Techincal Essentials Topics include : • Understand the different AWS compute, storage, network, database services i.e., EC2 (virtual server, connect cloud to O.S.), S3, EBS, EFS, Glacier, VPC, CloudFront, RDS, DynamoDB • Examine IAM service i.e., users, groups, and roles, policies Architecting on AWS Topics include : • Identify the design and architectural patterns • Compared structured query language (SQL) with NoSQL databases • Select compute, storage, database, and networking resources to improve performance • Best practices to eliminate suboptimal resources
JP MORGAN | SOFTWARE ENGINEERING VIRTUAL INTERNSHIP
• I learned how to use perspective to generate a live graph that displays the data feed in a clear and visually appealing way for traders to monitor this trading strategy. • And also completed practical task modules in Establishing Financial Data Feed, Frontend Web Development, and Data Visualization and learned how the real-time data streams, an alternative way to visualizes and share price data for its traders.
Projects
Discover my projects, where creativity meets innovation
END TO END Super Store Sales Dashboard & 15 Days ForeCast Dashboard
• To contribute to the success of a business by utilizing data analysis techniques, specifically focusing on time series analysis, to provide valuable insights and accurate sales forecasting. • Incorporated data analysis techniques, specializing in time series analysis, to deliver valuable insights, and interactive dashboard creation, driving business success. • Dashboard Creation: Created, Built, Monitored visually appealing interactive dynamic dashboards & reports added filters to allow user to explore dara at various levels of granularity • Dashboard KPI's : understand, identify, track KPIs, metrices, key-influencers, Identified key factors to reduce attrition • Actionable Insights and Recommendations: Proived valuable & meaningful insights & Analysis for better decision making & insights in clear & concise manner to track and analyze their online sales
GitHub Repository See Live
END TO END HR Analytics & Employee Attrition, Retention, Churn Dashboard
• Identified key factors to reduce attrition • Gained employee trust & Improved the hiring process & employee experience • Made workforce more productive • Dashboard Creation: Created, Built, Monitored visually appealing interactive dynamic dashboards & reports added filters to allow user to explore dara at various levels of granularity • Dashboard KPI's : understand, identify, track KPIs, metrices, key-influencers, Identified key factors to reduce attrition • Actionable Insights and Recommendations: Proived valuable & meaningful insights & Analysis for better decision making & insights in clear & concise manner to retain employees & reduce employee attriton rate & Gain employee trust & make workforce more productive & satisfaction & business success
GitHub Repository See Live
END TO END Akash e-commerce Sales Dashboard
• • To contribute to the success of a business by utilizing data analysis techniques, specifically focusing on time series analysis, to provide valuable insights and accurate sales forecasting. • Incorporated data analysis techniques, specializing in time series analysis, to deliver valuable insights, accurate sales forecasting, and interactive dashboard creation, driving business success. • Dashboard Creation: Created, Built, Monitored visually appealing interactive dynamic dashboards & reports added filters to allow user to explore dara at various levels of granularity • Dashboard KPI's : understand, identify, track KPIs, metrices, key-influencers, trends & patterns • Actionable Insights and Recommendations: Proived valuable & meaningful insights & Analysis for better decision making & insights in clear & concise manner to drive & suport supermarket's goals for growth, efficiency, satisfaction & business success
GitHub Repository See Live
END TO END Flight Price Prediction FLASK WEBAPP
• Built end-to-end full fleged ML-WebApp which shiw real time price ticket booking for both 1 and 2 way journey & used Random Forest trained model of 87% accuracy & deployed using Flask framework & on Heroku cloud • Show, display price comparison & predictions of Flight ticket b/w various flights price patterns and display price accurate predictions • Analyzed & explored the dataset features and develop models to predict the fare well in advance & Evaluated all 4 high performances unsupervised Regression ML models Xgboost, Random Forest, KNN, Gradientboost, analyzed their best MAE,MSE,RMSE score, improved & optimized the model by HPT RandomizedSearchCV • Recommended Random Forest, fitted/split the train \& test data, (X\_train, y\_train)score = 94\%, (X\_test, y\_test)score 78\%, Metrices R2 score (y\_test, y\_pred) = 78\%, accuracy = 90.04\% on test data, model tuning using RandomizedSearchCV
GitHub Repository See Live
DIABETES PREDICTION USING CLASSIFICATION ALGORITHM FLASK WEBAPP
• Predicts whether a patient is having diabetes or not & Machine learning algorithms help automate the process of monitoring blood sugar levels and recommend adjustments in care. • Recommended Random Forest Classifier with 90% accuracy & calculated their best f1,recall, precision, ROC, support score to predict the diabetes • Demonstrated EDA, Handling categorical data, Feature selection, Evaluatedrandom forest confusion performance Metrics, optimized using GRidSearchCV & scaling, dimensionality reduction \& feature transformation using PCA Bias-Variance tradeoff, Performance Metrics, Splitting data into train and test set, performed GRidSearchCV to optimize model,cross validated k-fold, trained model using Random Forest Regressor • Perfomrmed EDA and create a model to predict if a particular observation is at a risk of developing diabetes, given the independent factors & performances of all the three algorithms are evaluated on various measures like Precision, Accuracy, F-Measure, and Recall. Accuracy is measured over correctly and incorrectly classified instances. • Evaluated 4 unsupervised classifier models Xgboost, Random Forest, KNN, Gradientboost \& improved & optimized the Model by HPT Cross validation, GridSearchCVRecommended Random Forest Classifier, with presicion = 83\% , recall = 83\% , f1score = 83\% , support = 154,ROC score = 0.81\% accuracy = 90.04\% on test data, model HP Tuning using Cross validation, mean = 0.7167451503781488 , SD = 0.05709939039060164, GRidSearchCV with best accuracy score = 0.755700325732899
GitHub Repository See Live
COVID-19: Face Mask Detector
• Developed a detection Model with 92% accuracy in training & testing. It automatically detect whether a person is wearing a mask or not in real-time video streams. Process have 3 phases : loading dataset, training model & detecting features. OpenCV, Keras/TensorFlow, MobilNetV2 classifier, deep learning techniques & algorithm technologies used. • Used the highly efficient MobileNetV2 architecture & fine-tuned MobileNetV2 on our mask/no mask dataset and obtained a classifierthat is 97% accurate. • Extracted the face ROI & facial landmarks. And applied to the face by using the facial to compute & Determined the class label encoding based on probabilities associated with color annotation
GitHub Repository See Live
Facial Expression Detection And Recognition
• Identify mood/expression of a person & Detect & recognize facial changes, patterns, counters, expression, motions and mood of a person. • Used CNN, Back-propagation, Pooling layer(Max-pooling) using libraries OpenCV & NumPy on Python 3v. • Got 90% success rate, which led to the successful completion of our project with satisfactory output. It Detect & recognize facial changes, patterns, counters, expression, motions and mood of a person. • And the results we got 90% success rate ,10% incorrect , which are satisfactory, which led to the successful completion of our project with satisfactory output
GitHub Repository See Live
Car Brand Prediction (Data Science)
• Developed a detection Model with 92% accuracy in training & testing by reducing error with help of HPT. Show which car brand or company car belongs. • Involves data science life-cycle for prediction, which includes how to collect, clean, analyze data & exploratory data analysis. • Performing all machine learning models for training & testing and comparing the performance of the models
GitHub Repository See Live
ICHAT - REALTIME Realtime CHAT APP
• iChat is Realtime Node.js Socket.io Chatting Application. Exhibit some great features i.e., user joined, user left, message notification ringtone and live messaging. • Created scalable web application, allow users to send text messages to anyone instantly overinternet, show notifications, last seen message when user entered & leftroom & can handle multiple joined users at same time
GitHub Repository See Live
Movie Rating & Review WebApp (Django)
• Displays the latest movies, TV series info, and provides search and personal collectionfunctionality, recommendations & allow option for writing reviews and rating for movie • Follow MVC (Model-View-Template) core architecture to provide mechanisms to manage (add,modify, delete) and query records in the database & dynamically create an HTML page using an HTMLtemplate, populating it with data from a mode
GitHub Repository See Live
YouTube Live Subscriber Count
• Fetch YouTube analytics API from GDC, display real time live subscriber count with channel names/id, total subscribers & accepts usernames/YouTube URLs • Fetch YouTube Analytics API from GDC & display real time live YouTube subscribe count. • Shows subscription Count of a YouTube channel (updated every second) & exhibit additionalinformation such as, YouTube Channel names, total subscribers & etc…. • Accepts usernames/YouTube URLs, Channel names, Channel IDs, or any keywords in general
GitHub Repository See Live
Jarvis AI Assistant Realtime AI
• Assistant which can talk with you & follow your instructions to do any specific task. It uses Computer & python pyaudio library to speak. • A simple personal virtual computer based voice activated desktop assistant in python whichworks on the command line perform various task & activities with the same effectiveness or evenmore effectively than humans. • Play music/video, open YouTube, search something on Wikipedia etc.
GitHub Repository See Live
Election Voting - Ethereum Blockchain dApp on the Ethereum Blockchain Network With MetaMask
• Developed a client-side web application that allows accounts to cast votes & Show election between two candidates. • Ensure that votes are counted only once and the candidate with the most votes will actually win the election. • Build it on the Ethereum Blockchain network where anyone connected to the network can participate in the election and secured by cryptographic hashing, and validated by a consensus algorithm. • Smart contracts are in charge of reading and writing data. • Allow anyone & anywhere to vote online from a digital device • Ensure secure and transparent digital voting that votes are counted only once &cryptographically secured by SHA-256 hashing. • End-to-end verifiable voting technology eradicates fraud and corruption & eliminate thecurrent difficulties of offline-physical voting system by creating more efficient, less expensive
GitHub Repository See Live
IMAGE CRYPTOGRAPHY USING RSA ALGORITHM
• The concept is, that this process involves converting a Secret image into a text document, then encrypting the generated text into a ciphertext using a key (Password) based encryption algorithm, and finally embedding the ciphertext on to a cover image. • There are many Traditional approaches for encrypting & decrypting such as, DES, AES, Feistel Function, Least Significant Bit Substitution (LSB), Jsteg. But, we used RSA Algorithm, Steganography techniques to hide message into the image so that the message is hidden from the privacy eyes and protects the user message and Cryptography to encrypt and to decrypt the files, images, videos, etc. • We got our required result obtained, which will be in ciphertext, which means it is encrypted and cannot decrypt by third person/party. So, this led to successfully completion of our project with satisfactory output
GitHub Repository See Live
DATABASE OF MOVIES (SQL)
• As we know, movies are the 21st century’s prime form of entertainment. Every day more and more movies are made, and the ever-growing collection of movies grows even more. • The concept is, we need a database to store all the data pertaining to the movie, the actors, all the personnel working on the movie. This is why we created this database containing all the movies of MCU • We have collected data for all genres, actor names, age, dob, director, production, box-office. • Used SQL language for storing a database of movies and performed SQL operations (insert, join, delete, update ,etc.) • Results obtained have a 100% success rate, which led to successfully completion of our project with satisfactory output.
GitHub Repository See Live
SECURE DATA STORAGE AND IN CLOUD (AWS)
• Nowadays, Data is moving to cloud, data centers manage these servers to keep the data safe as this is the best way to store sensitive data and provide any time secure access to any file as these files are stored remotely on the server. But still, some breaches occur, due to this we have to store our confidential documents on cloud, for that we need some type of encryption to be safe from security breaches. • So, in this project are providing the secure data storage of your confidential files on the cloud storage system. • As data security is important, we in this project are providing the secure data storage of your confidential files on the cloud storage system.
GitHub Repository See Live
SPOTIFY MUSIC PLAYER CLONE(PHP)
• The concept is, that the user side contains an admin side and user side and the user has to perform all the main functions from the admin side and admin has full access to the system. • And users can view all the new releases albums, top songs with rankings, news, featured songs and vote their favorite song and also play and listen to music to songs. • He/she can manage all the music albums, add & remove songs from albums • Technology used are, HTML5, CSS3, JavaScript & jQuery for markup, design and interaction behaviorand Bootstrap / Angular JS will be used for making the site responsive and as a framework and PHP as server side language, MySQL, SQL Server as database software. • We have successfully completed our music player project, which led to successful completion of our project with satisfactory output
GitHub Repository See Live
Selenium Testing (Automated Testing) on " Sales & Inventory Management System" on our Zoho Website
• Worked on Real-time Project i.e., Selenium Testing (Automated Testing) on topic " Sales & Inventory Management System" on Zoho our Website • As we know, Warehouse inventory management functions cover internal warehouse movements and storage. Support for inventory management helps you record and track materials on the basis of both quantity and value. • The concept is to, reduce costs for warehousing, transportation, order fulfillment, and material handling – while improving customer service using the Selenium software testing tool. • This Selenium tool, help to test any website or web application in modern web browsers. It provides a playback tool for authoring functional tests without the need to learn a test scripting language (Selenium IDE). Runs on Windows, Linux, and macOS with JAVA running code • Results obtained have a 100% success rate, which led to successfully completion of our project with satisfactory output.
GitHub Repository See Live
BOOK COLLECTION WEB APPLICATION
• The concept is, which similar to the library book system, where there is a collection of books details of books, issue at any time, etc. Similar to this, we made a database to store books online, where we can do operation collection, create, edit, details of the book. • We have languages/technology such as,For frontend, HTML5, CSS3, JavaScript, JSON/jQuery for design and interaction behaviorFor Backend, Mongo DB, node.js for making the site responsive and as a framework. • We complete our project for database for book collection, which this led to successfully completion of our project with satisfactory output.
GitHub Repository See Live
STUDENT REGISTRATION VALIDATION FORM USING HTML , CSS , JAVASCRIPT
• Real-time application webpage for Login and Registration. All the data entered by the user in the registration form must be validated using the regular expression. • This allows us to validate the user entered data with our suitable requirement .ie., when user input details which do not match our requirement, then immediately it will show error for correction.
GitHub Repository See Live