Cinque Terre

Apoorva Paygude, MS

About me

Proficient and hands-on experience in Python, R, Tableau, SQL, Excel(Advanced), Power BI, QlikView, Alteryx, and Azure Data Factory. Implemented projects in the area of Deep Learning and Machine Learning. A quick learner who can absorb new ideas and can communicate clearly and effectively. Currently working as a Business Intelligence Developer at Performics where my responsibilities include dashboard development using Tableau, PowerBI and automation of processes using Python and SQL, Alteryx.

Experience

Jan 2022 - Present
BUSINESS INTELLIGENCE DEVELOPER

• Design efficient data architecture solutions to answer client’s reporting needs and create a clean overview with embedded business rules and logic • Build scalable and efficient solutions for clients using Alteryx, Python, SQL, Tableau and Google Analytics • Responsible for requirements gathering, design, development, testing, deployment, and support of complex reporting solutions • Developed Billing Automation process to save 150 hours a year for multiple clients • Create data mapping, dashboard wireframes and automate data pipelines based on requirements • Won award of Best Data and Technology Integration for Anomaly detection process • Drive operational efficiency & scalability of solutions through standardization of data metrics, KPIs and processes

July 2019 - Jan 2022
PROJECT ENGINEER
(BUSINESS INTELLIGENCE ANALYST)

• Interact and collaborate with global business and product teams to collect engineering/business/ quality/ productivity data for analysis • Design, develop, and maintain performant and scalable applications/dashboards, machine learning models using either Python, MSSQL, Oracle, Tableau, PowerBI, and Snowflake • Develop automated ETL data cleaning processes in Python to create Tableau, Power BI Dashboards • Identify, propose and implement internal process improvements: automate manual processes, optimize data delivery, re-design infrastructure to meet team scalability requirements • Analyze large volumes of field data to help the team understand outstanding issues or to help with the development of new functionality • Developed some first-time dashboards which helped management save many manual hours and take some real-time decisions

Dec 2018 - May 2019
Graduate Assistant

Assist Research Scientist in working and taking care of Animals.

Dec 2015 - June 2017
Systems Engineer

• Successfully completed Industrial training on Python, OOP, RDBMS and Linux Server Administration • Accelerated support for more than 3000+ users using ServiceNow Worked on user accounts on windows platform with Active Directory • Working knowledge of ITIL processes specifically Incident Management, Change Management • Managed and monitored all installed systems for the highest level of availability • Provided outstanding helpdesk service and support to customers • Reviewed and analyzed security logs to determine and alleviate network threats

Education

Aug 2017 - May 2019
Master’s in Information Technology

System Analysis and Development, Project Management, Data Analysis, Advance Database Management, SDLC, agile, Research Methodology, Software testing, Enterprise Resource Planning, Database Querying, TDD, ETL

Jul 2011 - July 2015
Bachelor's of Engineering in Information Technology

Programming, Computation, Mathematics, Data Structures, Computer graphics, Problem solving, Communication skills

My Skills

Programming Languages
Python
80%
R
70%
SQL
90%
Java
60%
Workflow Tools
Microsoft Office
80%
Software's
Power BI
90%
Tableau
90%
Jupyter Notebook
85%
MSSQL Server
90%
SQL Developer
85%
Alteryx
70%

My Projects

  • Employing Raspberry Pi for image processing and recognition using Python for Artificial Intelligence Deployment
  • Programmed in Python using libraries such as Tensorflow, Keras, OpenCV with an accuracy of 95%
  • Deployed on Raspberry Pi 3 using Linux Commands
  • Presented at Illinois State University Symposium and BIAC Conference as a Live Project
  • Performed data cleaning and data analysis using Excel and Tableau for Kickstarter site
  • Coded in Python (NumPy, Pandas, ScikitLearn) to predict the success/failure of projects
  • Built a Logistic Regression, Decision Tree model and achieved an overall accuracy of 99%
  • Categorized tweets as Positive, Negative or Neutral using Python and Twitter API
  • Optimized to categorize tweets using Natural Language Processing(NLP)
  • Built a model with the usage of tweepy, textblob libraries on Jupyter Notebook
  • Created a word cloud using Python libraries such as Matplotlib, os along with subprocess module
  • Used word cloud package in python on a very popular dataset of Marvel superheros
  • Analyzed Cricket ODI World Cup data from 1975 to 2015 using Gantt view, Pie Charts and Heat Maps
  • Developed an interactive dashboard using Tableau to analyze Winners Percentage and relation between Winners and Host Countries