- 🔭 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 katti.vishal@gmail.com
- ⚡ Fun fact: The data in this .md file comes from a Google Sheet and is created with R and 💖
- Beyond 01/31/2024
- Python - List Comprehension
- Pivoting your tables with Tidyr: Part II
- Pivoting your tables with Tidyr: Part I
- Writing Robust R Functions
| 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 |
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 |
| 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 | 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 | - |
| 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 |