Rupesh Kumar Email & Phone Number

Palamaner, Ap, In

Thane, Maharashtra, India

Bengaluru, Karnataka, India

* Built MIS from scratch and created dashboards, reports and SOPs to make data-driven decisions, which helped the collection team improve efficiency* Innovated a flat file system to store more than 1 million data cells, which helped the team get multiple customer numbers on Google Sheets. This significantly improved agent productivity and efficiency by 20%* Helped stakeholders create incentives for collection agents and reduced costs by 33%* Created multiple automation programs using JavaScript(AppScript) to send automated mail and auto-allocation. This helped stakeholders reduce their time from 4-6 Hrs of manual work to 20 minutes and create ad-hoc reports.* Create and manage JIRA tickets, collaborating with Data Engineers, Data Science & Engineering for work automation and dashboard improvements. * Create Complex SQL Queries to pull requested data for stakeholders and teams for different reports and data views.* Create SOP & Documentation using Confluence for business & data-related documents. * Manage internal and external & NBFC Stakeholders for data-related inquiries. * Fully automated systems which publish various reports to different stakeholders & NBFCs on time. * Creating KPIs and Quality Metrics for the Collection Team (In-House & Agency)* Manage a team, helping them work in a positive environment and helping them grow technically and professionally.

Bengaluru, Karnataka, India

* Hands-On Experience in building MIS from Scratch. Developing and documenting MIS for the Organization. * Preparing MIS reports on a daily, weekly, and monthly basis* Creating KPIs and Quality Metrics Data for Collection (B0,B1,B2,NPA) Team* Working Experience On Amazon Athena to query data. * Creating Ad-Hoc Reports to stakeholders to help them analyze data* Creating a Dashboard for all Buckets (B0, B1, B2, NPA) in Collections to track their performance in real-time* Experienced with Google Sheets, Google Macros, and Google Studio.* Hands-on experience with Advance Excel, Macros, PowerQuery & PowerPivot * Working experience With BI Tools such as Power BI* Experienced with Data Mining, Data Warehousing, Data Interpretation, Data Modeling, Data Visualization, Data Analytics and Data Analysis

Bengaluru, Karnataka, India

* Preparing MIS reports on a daily, weekly, and monthly basis* Creating KPIs and Quality Metrics Data for CS Team* Creating Ad-Hoc Reports to stakeholders to help them analyze data* Creating a Dashboard for all LOBs in CS to track their performance in real-time* Experienced with Google Sheets, Google Macros, and Google Studio.* Hands-on experience with Advance Excel, Macros, PowerQuery & PowerPivot * Working experience With BI Tools such as Power BI, Metabase, and Tableau * Hands-on Experience with SQL, JIRA and DBMS, and other Database tools.* Experienced with Data Mining, Data Warehousing, Data Interpretation, Data Modeling, Data Visualization, Data Analytics and Data Analysis* Working Experience with CRM tools like Freshworks CRM, Retool, JIRA, Ozonetel, and Genesys to download reports.* Experience in automation tools like Power Automate, Creating Triggers, and Scheduled reports to deliver reports in a timely manner.

Bangalore Urban, Karnataka, India

* Preparing MIS reports on a daily, weekly, and monthly basis* Creating KPIs and Quality Metrics Data for the sales team * Working Experience of Advance Excel and advanced functions like Xlookup, Unique, Filter, Sort, Vlookup, Index Match, Offset, Indirect, and aggregations like SUMIFS, Countifs, and Averageifs. * Have hands-on experience in creating dynamic charts using pivot tables* Good Knowledge of data analysis and working knowledge of tools like Phable Admin Portal, Ameyo, and HealthPe Portal to download reports for data interpretation and data analysis.* Working Experience in Creating charts for Data Visualization and for reporting purposes. * Experienced in PowerQuery for Data Cleaning and Data Warehousing.* Working Experience with Google Sheets to track Live Information for Data analysis using advanced functions like Importrange, Query, etc.

Master Of Business Administration - Mba, Marketing & Systems

Bsc Physics, Computer Science