Kiran Sethi

• GetSetUp is an online platform and community that helps older adults enjoy more fulfilling, independent, and socially connected lives through learning
• Achievements/Tasks -Worked on data segmentation, Global Data Requirements for the company which included working on primarily AWS Athena, Postgresql, Mysql and Ms-Excel(also Google Spreadsheets)
• Made Dashboards for tracking the all over growth metrics of the company as well as developed the Global Support Dashboard and Social Media user tracking dashboards in Metabase.
• Tracked website traffic using Google Analytics and Amplitude Analytics -Created Complex Data Query Reports for the Global team for analysing and visualising data.
• Contact: Stanley Lobo: +918451842484

Redcarpetup.com is a 2016 founded Fintech Startup which mainly focus on lending where normal banks don't lend. It serves the under-deserved segments

• Achievements/Tasks
• Successfully managed to move 17k customers out of 25k from our early product Zeta Credit Card - which was a credit card built for student segment to Ruby Card - which is our premium credit card by planning strategies based on model validation for which we mainly used XGBoost model and managed to do complete their OKYC process.I generated a total revenue for 8 cr within a time period of 4 months.
• Worked on Reset Card which is a credit building card. Built strategies to increase sales and revenue by studying historical data and built NPV models to include various offers for the customers and thereby increased sales and generated revenue of 3 cr starting from April till the month of August.
• Built Dashboards for OPS team in order to track daily sales data.
• Decreased refund rate of the Reset Card from 30% to 0.01% by analysing data and running offers and favourable campaigns as well as changing the UI-UX of the app and gave customers a great experience.
• Increased customer retention rate from 20% to 70% by changing some of the fundamental working process of the product
• Conducted A/B Testing on Reset Card by experimenting on product variations by SMS Campaign, E-Mail Campaign, Social Media Campaigns.
• Conducted Statistical Analysis with all the changes in the reset card after sucessfully conducting the A/B testing. Performed a Z-test and was able to achieve confidence interval of 95% with a significance level(p-value) of 0.05.
• Improved the existing Model from KS-0.172 to KS-0.341 which had a 26% increase in profits and 6% decrease in bad acquisitions.
• Worked with around 2 million credit card customers data by writing PostgreSQL queries and making a score of visualization dashboards showing MoM, DoD, MTD and other card tape metrics in Apache Superset for making business decisions.
• Contact: Pappu Kumar +918210843042

• Tasks
• Worked mainly in deploying web applications in client server.

• Autovity is a fast-growing software company with excellence in services and process. Autovity is a company that is delivering enhanced value in IT to it's clients through service and process solution
• Achievements/Tasks
• Investigating, design and implement scalable applications for data identification, analysis, retrieval and indexing
• Software design and development while remaining concentrated on client needs
• Cooperate diligently with other IT team members to plan, design and develop smart solutions
• Estimate interface between hardware and software
• Working in a Software MMS using HTML, CSS,
• JavaScript, Java and MySQL for database.

• Identified, analyzed and interpreted trends or patterns in complex data sets by finding correlations and visualizing with charts.
• Utilized various professional statistical techniques and maintained large databases to collect and analyze data from partners and customers.
• Assisted end-users with creating custom reports using software and database tools.
• Presented reports to clients and teammates regarding project progress and results.
• Performed routine tasks under direct supervision and within established procedures and guidelines.
• Aggregated data from various sources to construct streamlined data pipelines.
• Analyzed user concerns, requirements and requests for system features and uses.
• Created Dashboards on Tableau for Client presentation.