About Me
As a experte data analyst and dashboard developer, I have experties on SAS, Tableau,Qlikview,Excel and VBA. In my professional carrer i have worekd in verious domain like BFSI, Pharmaceutical. I have setup MIS reporting platform for my verious cli...
I am a SAS certified programmer. I rate myself 8 out of 10 in SAS programming skill. I have used SAS for data processing and analytics.
I have expert experice in Tableau and Qlikview, I have developed more than 200 reports and dashboards. One of my US based fortune 100 pharma client had sent myTableau dashbored to be verified by Tableau. Peter Gilks from Tableau had rated that report as A+.
Currently I am working as Analytics manager in renouned MNC. I am manageing team for data managemnt and MIA reporting for banking Client.
I am also SAS and BI tool trainer. I am associated with verious training centers for carporate and individual training.
Regards
Subodh Kumar
Show More
Skills
Programming Language
Data & Analytics
Database
Others
Web Development
Portfolio Projects
Company
Automated MIS platform for USA base Pharma Giant
Role
Data Scientist
Description
Project manager for data analytics and MIS reporting, Client interaction for requirement gathering and presentation of the solution. POC and RFP development. Mentoring team on domain and technical skills like SAS, Tableau. My team has developed an end to end solution platform which has capacity of data processing, automatic dashboard refresh in Tableau and ppt generation.
- Sales management and ad-hoc reporting: The responsibilities included the analysis of sales of pharmaceutical products at geographical/alignment, time, medical representative, channel and market level. The same included delivery of over 50 reports to client in a month. Acted as the business analyst and guide for the team for conceptualization, development and delivery of most of the reports.
- Business Intelligence based Reporting Platform: Leading the Technical implementation, development and deployment of multiple dashboards in Tableau to create a central platform for all user segments to view all required reports. Regularly interacting with client to understand the requirements and wants, then providing appropriate advice over the technical feasibility and guiding the client for a better development. Leading the business and project managerial aspect of the same involving development of business deck for client presentations and management of revenue and resources for the entire length of the project.
Tools
Tableau Excel Macro SAS SQLCompany
Campaign analytics, CRM Analytics for Indian Insurance company
Description
- Product White Space Analysis: Analyzed data to track performance of insurance product in targeted segment and to identify new opportunity area.
- Campaign Analytics: Campaign design and execution for Insurance industry. Per and post analysis of sales data to track the impact of the campaign.
- Banka Analysis: Analyzed insurance premium payment data to identify banks to collaborate with them so sell our insurance product.
- Agent attrition model (Predictive modeling): This is logistics model developed to tracks the probability of Insurance agent to quit their jobs.
Company
Collection Analytics for US based bank
Description
Provided analytics support to collections team, by analyzing “customer behaviors”, and tracking” collection efficiency of collection agencies.
Segmentation of credit card customer to implement different collection strategies.
Analytics support for “Agency Inventory Management” by“ Collection Efficiency Tracking” of Collection Agencies for different due stages.
Domain- Credit Card
- Merchant level analysis for credit card industry to track performance of credit card in different business area: Data analytics and MIS reporting to track the credit card business for different merchant and different vertical. Prepare various market insight report and business insight report to track the merchant’s performance and sales force analysis of client’s sales team.
- Credit Card Collection analytics: “Agency Inventory Management” by “Collection Efficiency Tracking” of Collection Agencies for different due stages.
- Collection call scheduling: Identified the issue of less contact ability to the customer because of unscheduled call. Segmented the customer according to their profession and decided a time frame to schedule the call as per the profession of customer.
Tools
SAS BASE SAS MACRO Excel MacroCompany
SEO and Web Analytics (Digital Analytics)
Description
SEO and SMM for various website. Tracking of website search of the website from different sources using Google Analytics
Show More Show LessSkills
Google Analytics API MS Office