Looking for a career-building opportunity in Big Data Analytics, Data Science & Machine Learning to thoroughly utilize my interpersonal skills along with my technical proficiencies considering any challenges appointed to me and to exhibit adaptiveness.
• Worked from Scratch to setup ETL and Amazon Redshift Datawarehouse.
• Working on advance SQL for Tableau Reporting, ETL & Analysis for Blockchain and Web3 data.
• Have also been creating Tableau reports to analyze blockchain data and provide important data nuggets for decision making for management. For eg: Northstar Metrics, Granual data determining performance of each department.
• Creating custom ETLs using Python to fetch data from Jira API, Github API & SonarCloud.
Tools & Tech : Python, Tableau, SQL, ETL, HevoData, Jira, Notion, Miro, Web, Github & APIs.
• Worked on SQLs (Basic to Advance) according to the requirement of Clients using Oracle, Azure Synapse, Amazon Redshift, and SQL Server.
• Working on Python to automate the regular and tedious tasks to reduce Human Efforts using Pandas, Regex, Selenium, Web Scrapping, File Scrapping, and Excel.
• Backend logic creation of custom software which used to convert different form of SQLs.
• Worked on SQL (Basic to Advance) to adhere to the business requirements for reporting.
• Extracting data from various platforms using Web Scrapping or Using APIs and preparing it to report ready.
• Have also worked on providing the import data nuggets for the decision-making to the management
• Have also had direct Tableau Desktop and Tableau Server to analyze the data and to maintain the integrity of the data
• Have also worked on creating and maintaining ETL jobs and Tableau Data Sources refresh using AWS Matillion and Pentaho
• Automated day–to–day business processes to reduce manual intervention using multiple tools like Advance Python, Selenium, Web – Scrapping, Katalon, Excel, and VBA Macro.
• Worked on the project named "Predictive analysis for US stock market".
• Developed an efficient and robust algorithm for identifying stock trend and prediction for over 8000+ tickers within the timeframe of 5 years, 1 year,6 month,3 month and 1 month.
• Improved the efficiency of the trend identification and prediction algorithm from initial 44% to 92%.
• Integrated the algorithm on the company's site https://ticksignals.com/ to be used with various other modules.
I did internship with Inexture Solutions LLP under curriculum of B.Tech , worked with Python - Flask and made FlaskBlog Website and also worked with Python Automation Scripts.
Experience LetterI did Societal Internship in a team at Karma Foundation (A non-profit NGO). During my volunteering at Karma Foundation, I alongside with my team took upon a task of surveying the health conditions and Maintenance of government/privately run Public Toilets and created a detailed report and analysis about the current situation of public toilets in the City of Ahmedabad. The collected data was used by government officials to take decisions and improve the Public Toilets.
Experience LetterCGPA : 8.67
Percentage: 73%
CGPA: 8.8
Patient Management System API is created using Python FastAPI, Flask and MySQL which provides the benefits of streamlined operations, enhanced administration, control, superior patient care and cost control increasing the profitability. Management of, day by day increasing demand of healthcare data has become a challenge, where manual paper-based technique becomes hectic and time consuming. Patients’ data needs to be available online where it could be accessed securely by the Doctors, Patients, Hospital Staff, Government, or any 3rd Party Application developer who can provide features and facility. The solution to this problem was solved by creating an API which can securely provide the requested data, which can reduce the hassle and work could be done efficiently.
Project LinkWorked on the project named "Predictive analysis for US stock market".
• Developed an efficient and robust algorithm for identifying stock trend for over 8000+ tickers within the timeframe of 5 years,1 year, 6-month,3 month and 1 month.
• Improved the efficiency of the trend identification algorithm from initial 44% to 92%.
• Integrated the algorithm on the company's site https://ticksignals.com/ to be used with various other modules
Project Based on Fetching Streaming Data from Twitter Using Spark and Python. Based on the data all Different Hashtags would be filtered and according to it the Dashboard would Display the Information
Project LinkFlaskBlog is an intuitive blogging platform that has been built using Python Flask framework from scratch. It allows creators to get started into the world of blogging and let the world know of what they have been keen upon. The blog has been curated like a social media platform, allowing the readers to Like, Share and Comment as they please.
Project LinkA simple Android Application that helps managing Personal tasks and track your Expenses. Its Key features were Simple and Easy to use, Cloud Data Storage, Graphical Analytics for Expense Tracker (Beta), Compatible with almost every Android device, Material UI
Project LinkNet based project which was made to help the Institutes Placement Cell to manage the data of Students as well as data of the companies. It had functionality of Notifying the Students when a new company arrives for Placements.
Project Link
Tableau
Redshift
Snowflake
Hevo Data
Matillion
Pentaho
Katalon
Hadoop
Data Science
Spark
MongoDB
IBM Watson
Python
HTML
CSS
R Programming
Github
AWS
Excel
IBM Cloud