• Built models by Logistic Regression, Random Forest, Decision Tree to predict customer retention for a telecom client.
• Used Linear Regression model to predict the sales of various connection packages.
• Made clustering techniques to find the group / segment of customers for unstructured datasets.
• Data analysis through data visualization, dashboard & reporting using Qlikview, Qliksense, Excel, Tableau, SQL from various sources like RDBMS, Excel, Flat file, SAP, etc.
• KPI creation, Reports of POs / Vendors / Products/ Asset Data based on various measurements by Tableau, SQL, Qlikview and Qliksense.
• Transform business feature into solutions with advanced visualization techniques to help with data-driven decision-making and management reporting.
• Modernized data streamlining processes, resulting redundancy reduction.
• Complete understanding of ETL (Extract, Transform and Load) and Data modelling, NF using Tableau Prep, SSIS.
• Writing SQL queries to various stages of data and to integrate with BI tools.
• Data Representation / Forecast in various forms from different sources and their automation and Complete data analysis with KPI, dashboard and send report to stakeholders for self-serve reporting by building robust domain and logical models which resulted 96% accuracy in forecasting.
• Worked in Product & IT Service analytics.
• Following & practicing scrum principle strictly on every delivery.
• Frequent meeting with client and operation team for continuous requirement, business criticality and further improvements.
• Lead RCA Analyst and send report to stakeholders
• Automation of manual efforts through VBA.
• Ability to handle multiple tasks and adapt to a constantly changing environment
• Work in an extremely Agile environment with continuous user interaction
Skills/Libraries Used: Python, Machine Learning Models - Random Forest, Decision Tree, Logistic Regression, Linear Regression, Scikit learn, Matplotlib, Seaborn, Tableau, Qlik, SQL, SSIS, Tableau Prep