Skip to content
View anston-jp's full-sized avatar

Block or report anston-jp

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
anston-jp/README.md

Typing SVG


🧑‍💻 About Me

class AnstonJP:
    def __init__(self):
        self.name = "Anston J P"
        self.location = "Kanyakumari, Tamil Nadu, India"
        self.degree = "B.Tech in Civil Engineering"
        self.background = "Civil Engineering ➡️ Data Analytics"
        self.stack = [
            "SQL (PostgreSQL)", "DAX", "Advanced Excel",
            "Power BI", "Power Query", "Power Pivot"
        ]
        self.currently_learning = ["Diploma in Data Analytics"]
        self.fun_fact = "Started out managing construction sites, now I manage datasets 🏗️➡️📊"

    def motto(self):
        return "Clean the data, trust the insight."

me = AnstonJP()
print(me.motto())

🛠️ Tech Stack

Languages & Query

Tools & Platforms

Databases

Data Process

📂 Featured Projects

Project Stack Highlights
IPL Data Analysis Advanced Excel, Power Query, Pivot Charts Cleaned & harmonized 630+ matches / 150K+ delivery rows; built a full performance dashboard (Top 10 Batsmen, MoM Awards — Gayle led with 18) across 10 seasons and 35+ stadiums
Sales Performance Analytics Excel, PostgreSQL, Power BI Architected a relational PostgreSQL DB from cleaned Excel data; used COALESCE, CASE WHEN, and scalar functions across 15+ columns; visualized monthly sales trends in Power BI
Superstore Retail Analytics PostgreSQL, Power BI Applied window functions (RANK, DENSE_RANK, OVER), CTEs & subqueries for profit/margin analysis; managed full DB lifecycle with schema changes and SQL Views
IT Service Operations & Customer Support Analytics PostgreSQL, Power BI Built SQL pipelines and dimensional models. Designed an interactive Power BI dashboard with advanced DAX. Identified bottlenecks—including 32.2% SLA breaches and 2.8K ticket backlogs—to optimize support agent resource allocation.

🏆 Certifications & Achievements

🏅 Achievement Details
🎓 UI/UX Designer Certificate Completed Dec 2025 — user research, visual design, Gen AI in design, capstone project
📈 Diploma in Data Analytics Currently in progress
🏗️ Civil Engineering → Data Analytics Self-driven transition from construction/site management into data analysis

🎓 Education

Degree Institution Year Score
B.Tech, Civil Engineering Puducherry Technological University Jan 2021 – May 2025 CGPA: 7.0
Higher Secondary (12th) Bethlahem Matric Hr Sec School, Kanyakumari Jun 2019 – Apr 2020 76%
Secondary (10th) Bethlahem Matric Hr Sec School, Kanyakumari Jun 2017 – Apr 2018 84%

🌱 Currently Learning

📊 Data Analytics Diploma → Advanced SQL, Data Visualization, Statistics
🧱 PostgreSQL             → Window Functions, CTEs, Views, Query Optimization
📈 Power BI               → DAX, Data Modeling, Dashboard Design

📫 Connect with Me

profile views

Popular repositories Loading

  1. anston-jp anston-jp Public

  2. Supermarket-Sales-Performance-Operational-Analytics Supermarket-Sales-Performance-Operational-Analytics Public

    Comprehensive sales performance analysis for a supermarket chain. Features include revenue trends, product line profitability, and customer payment behavior insights derived from transactional data.

  3. global-covid-19-pandemic-analytics global-covid-19-pandemic-analytics Public

    Comprehensive Excel-based global COVID-19 pandemic analytics repository tracking worldwide infection trajectories, mortality rates, active case distributions, and continent-level impacts using Worl…

  4. virtual-gaming-startup-revenue-analytics virtual-gaming-startup-revenue-analytics Public

    Excel-based case study analysis for a virtual gaming startup examining April revenue distribution by state, daily active user engagement patterns, and monetization metrics.

  5. ipl-match-and-player-performance-analytics ipl-match-and-player-performance-analytics Public

    Excel-based analytical dashboard examining Indian Premier League (IPL) match outcomes, venue utilization, team dominance, and top player statistics from 2008 to 2017.

  6. Superstore-Monthly-Customer-Sales-Analytics Superstore-Monthly-Customer-Sales-Analytics Public

    Interactive Power BI Dashboard analyzing monthly purchasing behavior, sales trends, and customer metrics (2014–2017).