Smartsheet
Analytics

• Integrate Smartsheet with Python and Github Actions to perform effective allocations of various teams involved in projects .
• Using Smartsheet I can create tailored project tracking dashboards that provide valuable insights by visualizing KPIs, optimizing processes, and enabling data-driven decision-making with real-time updates .


• I design custom automated workflows to streamline project management, integrate seamlessly with existing systems, and automate recurring tasks, saving time and reducing errors.


• I create meaningful metrics for dashboards, including milestone tracking, resource utilization, and risk analysis, to ensure projects stay on schedule and address potential challenges effectively.

Data
Analytics

• Data Collection & Integration: Experienced in web scraping to extract structured and unstructured data from websites, transferring it to databases like MongoDB or MySQL for analysis, and automating data pipelines using Python with tools like Selenium, BeautifulSoup, and Scrapy.


• Data Cleaning & Transformation: Proficient in cleaning raw data using Python libraries like Pandas and NumPy, transforming and preprocessing datasets for analysis or visualization, and ensuring data integrity and accuracy for actionable insights.


• Visualization & Reporting: Experienced in designing interactive dashboards with Tableau, Power BI, and Matplotlib/Seaborn in Python, effectively communicating insights through data storytelling and tailored visualizations, and generating reports in formats like PDF, Excel, or live dashboards.
• Automation & Optimization: Proficient in automating routine data analytics tasks with Python scripting and Prefect workflows, creating reusable pipelines for data collection, analysis, and visualization, and optimizing database queries and scripts for enhanced processing speed.

Power BI
Services

• Data Integration: Expertise in connecting Power BI to various data sources, including MySQL, MongoDB, and CSV files, to ensure seamless data import and integration.


• Data Analysis & Modeling: Skilled in transforming raw data into meaningful insights by performing advanced analysis and creating robust data models within Power BI.


• Visualization & Reporting: Proficient in designing interactive dashboards and reports tailored to stakeholder needs, enabling effective decision-making through clear and actionable visualizations.

Automating Email Allocation Using
Python ETL Pipeline

In the realm of project management, timely communication is crucial, especially when it comes to milestone tracking. This blog discusses an ETL pipeline created using Python and GitHub Actions, designed to generate email allocations for six different milestones based on the dates when each milestone is punched. Various criteria are considered to ensure accurate email generation.



Read More >>

Live Weather Data Extraction
Using Prefect as ETL

Live Weather and data are used by people in many ways to generate insights, predict upcoming weather, to fleet management and various other applications. There are various parameters which are considered such as pressure, dew point, humidity, rain days, snow days, temperature, time, date when it was recorded, uv index, uv status, air quality, and the feedback such as driving conditions, outdoors, type of clothing etc., In this article, I’m going to show how you can quickly and easily load weather forecast data for any location within India and to load the data into SQL database using ETL tools and at the same display it on the dashboard for further analysis.



Read More >>