Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings
@obitorin07
obitorin07
Follow

Kiran Data Analyst obitorin07

🎯
Focusing
Passionate about Python & SQL πŸš€ | Optimizing data efficiency through scripting | Eager to learn, grow, and collaborate πŸ’Ό

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
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

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! πŸ”πŸ’»

    12 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

AltStyle γ«γ‚ˆγ£γ¦ε€‰ζ›γ•γ‚ŒγŸγƒšγƒΌγ‚Έ (->γ‚ͺγƒͺγ‚ΈγƒŠγƒ«) /