Skip to content
View obitorin07's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report obitorin07

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 supported. This note will be visible to only you.
Report abuse

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

Report abuse
obitorin07/README.md

Hi there! πŸ‘‹ I'm Kiran

Typing Animation

"Automate everything!" I love transforming data into insights while building tools to save time ⚑


πŸ”₯ Core Skills

Data Analytics πŸ“Š Automation πŸ€– Development πŸ’»
SQL β€’ Snowflake Python Automation PHP β€’ Laravel
Python β€’ Pandas Excel VBA, Xlwings Python Backend
Power BI Web Scraping, Web Automation App Development

πŸ› οΈ Technical Stack

Python

  • Data Analysis: Pandas, NumPy, SciPy
  • Automation: Selenium, Playwright, BeautifulSoup, PyAutoGUI, xlwings, OpenPyXL
  • Web Development: Flask
  • App Development: PyQt5, Tkinter

SQL & Databases

  • Expertise: 300+ problems solved
  • Databases: MySQL, PostgreSQL, Snowflake
  • Advanced: Query optimization, ETL pipelines

Advanced Excel

  • Advanced Formulas: XLOOKUP, VLOOKUP, INDEX-MATCH
  • Automation: VBA scripting, xlwings, OpenPyXL
  • Transformations: Power Query
  • Visualization: Dynamic dashboards, Pivot Tables

Power BI

  • Formulas: DAX
  • Reports: Interactive reports
  • Modeling: Data modeling
  • Transformation: Power Query

Web Development

  • Backend: PHP (Laravel), Python (Flask)
  • Frontend: HTML5, CSS3, JavaScript

βš™οΈ Dedicated Automation Expertise

Automation process GIF
My drive to streamline operations is at the core of my work. I specialize in building robust automation solutions to enhance efficiency and productivity.
  • Excel Workflow Automation: Leveraging VBA scripting, xlwings, and OpenPyXL for powerful spreadsheet automation.
  • Web Scraping Bots: Developing intelligent bots with Selenium and Playwright to extract and process web data.
  • Scheduled Tasks: Implementing automated routines for repetitive tasks, ensuring seamless and timely execution.

πŸ’‘ Version Control

Git & GitHub

  • Version Control: Proficient in using Git for collaborative development and tracking changes.
  • Repository Management: Experienced with GitHub for hosting, managing, and contributing to projects.

⚑ Coding Activity

LeetCode Stats


πŸ“ˆ GitHub Stats

---

🌐 Connect With Me

Visit My Website LeetCode Profile

Pinned Loading

  1. Excel-For-Data-Analysis Excel-For-Data-Analysis Public

    Practice exercises and projects to learn data analysis with Excel. Let's explore together! πŸ”πŸ’»

    9 3

  2. SQL-For-Data-Analytics SQL-For-Data-Analytics Public

    Advanced SQL for Data Analytics. A collection of problem-solving solutions covering complex Joins, Window Functions, CTEs, and Query Optimization. Includes real-world interview questions, schema de…

  3. Amazon-Sales-Analysis-Using-Python Amazon-Sales-Analysis-Using-Python Public

    Jupyter Notebook 1

  4. Bollywood-Movie-Performance-Analysis Bollywood-Movie-Performance-Analysis Public

  5. Python-For-Beginners Python-For-Beginners Public

    Welcome to the "Python for Beginners" directory! πŸš€ This directory is designed for individuals who are new to Python programming and are eager to learn from scratch. Whether you are a complete begin…

    Jupyter Notebook 2

  6. Comprehensive-Superstore-Sales-Dashboard-in-Excel Comprehensive-Superstore-Sales-Dashboard-in-Excel Public