Vivek Gupta

- Vivek Gupta - Bangalore, India. linkedin.com/in/-vivekgupta SUMMARY Data Analyst, with a demonstrated ability to facilitate data-driven business solutions. Proficient in Business Intelligence, data visualization, and inside generation looking to leveraging my skills efficiently for organizational and professional growth. Campaigns Effectiveness • • WORK HISTORY Data Analyst • Rupeek Fintech, Bangalore. Oct 2018 – Present • CAREER HIGHLIGHTS Customer Sentiment analysis • • • Utilized Python for data cleaning and anomaly detection on unstructured CIBIL data, which reduced total process time by 20%. Created customer segments using Gold Loan borrowing pattern vs other substitutable loans and did Churn Analysis of each segment. Forecasted loan pattern across different customer segments and presented results to the business head and wrote requested executive summary detailing value proposition and strategy to acquire new customers based on CIBIL Data. Data Management • • • Played a pivotal role in defining new dashboards to track the customer journey, streamlined existing dashboards which lead to a reduction in delivery time of business. Formulated analytical data mart by transforming data, which Optimized existing SQL queries execution time by 1520%. Developed a sales planning tool that Forecasted sales targets for different channels of distribution with an overall accuracy of 75%. Wrangled 2TB of call data stored in Big Query and Identified different pockets of customers suitable for a specific type of campaign based on customer’s credit history. Developed accessible and engaging data visualization on Tableau to facilitate access to insights and data needs of different business units. Negotiated vendor contracts and managed relationships. Cost-cutting and improved lead quality by Call and SMS Campaign which increased revenue by 5% since 2020. EDUCATION Bachelor of Technology in Electronics and Communication Engineering Lovely Professional University, Phagwara 2014 – 2018 TECHNICAL SKILLS • • • • Programming Languages: Python, R, SQL (PgSql, MySQL) Data Visualization: Tableau, PowerBi, Qlik View. Big Data & Machine Learning: MongoDB, Python (e.g.- NumPy, pandas, matplotlib) Data Science & Miscellaneous Technologies: ETL, Data science pipeline (cleansing, wrangling, visualization, modeling, interpretation), Time series, CRM analytics, Excel, Git. CERTIFICATIONS • R Programming for Data by Udemy. • Python for Data Science by Coursera. • Machine Learning by Udemy.