Code Monkey home page Code Monkey logo

Vishal Katti

Hi there 👋

Twitter Badge

  • 🔭 New Quarto website and blog.
  • 🌱 Full-time Business Data Analyst at LTIMindtree Ltd., Bengaluru, India.
  • 👯 Contributed to open-source, specifically to openxlsx and croquet R packages. Looking for opportunities to contribute more.
  • 💬 Ask me about how to automate your manual reports and other process improvement methods.
  • 📫 How to reach me: twitter @vishal_katti or email [email protected]
  • ⚡ Fun fact: The data in this .md file comes from a Google Sheet and is created with R and 💖

📝 Latest Blogs

🔧 Tools

🎯 Certifications

Certificate/Course Name Issuing Authority Acquired on URL
Databricks Certified Data Engineering Associate DataBricks 2022-06-21 link
R Programming A-Z™: R For Data Science With Real Exercises Udemy 2017-12-28 link
The Complete JavaScript Course: Build a Real-World Project Udemy 2017-12-07 link

💼 Work Experience

Total 13 Years 3 Months Experience (as on 2024-01-07)

Employer Location Role From To
LTIMindtree Ltd. (Post merger of Mindtree Ltd. with L&T InfoTech) Bengaluru, Karnataka Associate Principal - Data Sciences Apr 2023 Till Date
Business Data Analyst Nov 2022 Mar 2023
Mindtree Ltd. Bengaluru, Karnataka Business Data Analyst Sep 2021 Oct 2022
ExxonMobil Services & Technology Pvt. Ltd Bengaluru, Karnataka Business Analytics Advisor Oct 2020 Aug 2021
Data Analyst Jun 2018 Sep 2020
Tata Consultancy Services Pvt. Ltd. Bengaluru, Karnataka Data Analyst Jun 2016 May 2018
Mumbai, Maharashtra Functional Consultant Jan 2014 May 2016
Business Analyst Oct 2011 Dec 2013
Associate Systems Engineer Jan 2011 Sep 2011
Trivandrum, Kerala Associate Systems Engineer Sep 2010 Dec 2010

🎉 Career Highlights

Highlights Where When
Became MS Purview SME within 2 months for confidential client LTIMindtree Ltd. Nov 2022
Received 7/7 performance rating for 4 Quarters in a row Mindtree Ltd. Oct 2021-Oct 2022
Extended functionality and fixed Issue #6 in R package {croquet} via Github pull request(pcctc/croquet#7) Open Source Contribution Sep 2022
Extended conditional formatting feature and fixed Issue #179 in R package {openxlsx} via Github pull request (ycphs/openxlsx#311) Open Source Contribution Jan 2022
Received customer appreciation for using Python for data cleaning and consolidation, which would otherwise take 2 weeks to do manually. Mindtree Ltd. Oct 2021
Added new conditional formatting feature to R package {openxlsx} via Github pull request (ycphs/openxlsx#166) Open Source Contribution Mar 2021-Apr 2021
Designed and implemented critical in-house solution that replaces third-party vendor solution thereby saving ~50K USD in annual subcription cost ExxonMobil, Bengaluru Jan 2021
Designed and deployed 3 R packages for ExxonMobil OE-SSHE-DAG internal use. ExxonMobil, Bengaluru Apr 2020-Jul 2020
Awarded ‘Star of the Quarter’ for 2019 Q2 for designing the Report Automation Framework for OE-SSHE-DAG ExxonMobil, Bengaluru Sep 2019
Automated a report for SOC project using Excel VBA for Alert Analysis with Effort reduction from 8 hours to 5 minutes!! TCS, Bengaluru Jul 2016
Designed a critical solution which enabled TCS Talent Acquisition Group to roll out 66% more Offer Letters to TCS Applicants; thereby reducing Cost of Hire by 35%. TCS, Mumbai Aug 2015
Worked on high priority Mobility project for TATA SONS Chairman Office as Functional Consultant/Analyst and Backup Project Manager. TCS, Mumbai Aug 2014-Dec 2014
Worked on high priority Mobility project for TCS CEO Office as Functional Consultant and Backup Project Manager. TCS, Mumbai Jan 2014-May 2014
Received ‘On the Spot’ Award for ensuring TCS Internal IT Department’s entry into TATA INNOVISTA 2013. Chosen in Top 5 entries across the globe. TCS, Mumbai Jan 2014
Initiated and implemented Trainee Management application, which helps manage around 45K candidates annually. TCS, Mumbai Jan 2011-Jul 2011
Self-learnt, developed and deployed RMA Management stand-alone application (in MS Visual Basic) as part of 8 weeks internship during BTech Engineering. DLink India Pvt. Ltd, Verna-Goa May 2009-Aug 2009

⚡ Skills

Skills Tools
Data Cleansing, Feature Engineering, Data Modelling, Visualizations R, Python, Apache Spark with Databricks, MS Excel, PowerBI
Web Apps, Dashboards R Shiny, Python, MS Excel, PowerBI, PowerApps
SQL Queries & Reporting SQL Server, MS Access, Microsoft SQL Server Management Studio (SSMS), Databricks SparkSQL
Data Analytics R, Python, Apache Spark, MS Excel, PowerBI
VBA Macros, Userforms, Excel Add-ins MS Excel, Word, Outlook, PowerPoint
Report Design R, MS Excel, SQL, PowerBI, Word, PowerPoint
Requirement Documentation and Change Request Management MS Word, Rally for Agile, JIRA
Mockups, UI and Usability Design MS PowerPoint, Balsamiq Mockups for Desktop, MS Visio
Process Improvement PDCA, Lean Six Sigma, VBA Automation
Test Planning, Test Cases, User Acceptance Testing, Defect Management MS Excel, Rally for Agile
Project Management -

📚 Education

Level Specialization Institute Location From To
Master of Business Administration (Online Mode - 2023-2025) Business Intelligence and Analytics JAIN (Deemed University) Online Mode Feb 2023 NA
Bachelor of Technology (B.Tech) Instrumentation & Control Engineering National Institute of Technology (NIT) Jalandhar Punjab, India Aug 2005 Apr 2010
Higher Secondary (HSSC) Physics, Chemistry, Mathematics Smt. Parvatibai Chowgule College of Arts & Science Goa, India Jun 2003 Apr 2005
Secondary (SSC) - Mahila & Nutan English Highschool Goa, India Jun 2002 Apr 2003

Vishal Katti's Projects

courses icon courses

Course listings and landing pages for each course.

croquet icon croquet

Miscellaneous operations for PCCTC, a Clinical Research Organization (CRO)

dplyr_joins icon dplyr_joins

A repo of R code to create animated SVG to demonstrate dplyr joins

openxlsx icon openxlsx

openxlsx - a fast way to read and write complex xslx files

quantbook icon quantbook

A quarto book for Quantitative Techniques and Analytics

simplr icon simplr

A miscellaneous set of utility functions to make R usage simpler

turbokat-archive icon turbokat-archive

Source files for my personal website, built using the {distill} R package and deployed with Netlify

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.