Sai Prem T. Email & Phone Number

Bengaluru, Ka, In

Bengaluru, Karnataka, India

Bangalore Urban, Karnataka, India

• Responsible for establishing and visualizing topline metrics for various features in App to monitor on Daily and monthly level• Identified and analyzed errors in transactions, KYC, Sign-up funnels• Measured performance of Ads, New/Existing/Experimental features, Events, Activities validating its impact on users growth ,retention, engagement• Segmentation based on their activity and transactional behavior to improve user retention.• Study hurdles in user activation, retention… Show more • Responsible for establishing and visualizing topline metrics for various features in App to monitor on Daily and monthly level• Identified and analyzed errors in transactions, KYC, Sign-up funnels• Measured performance of Ads, New/Existing/Experimental features, Events, Activities validating its impact on users growth ,retention, engagement• Segmentation based on their activity and transactional behavior to improve user retention.• Study hurdles in user activation, retention, inactivity etc. in all possible aspects• Executed partner migration work and ad-hoc analytics requests to support the team's goals• Created new queries and optimized existing ones to make life easier for customer support• Trained the team on execution and introduced new sustainable permission structures to improve data accessibility• Brainstormed improvement areas and concluded metrics for FamPlay and Missions features, and produced requirements and follow-ups for the team Show less

Bengaluru, Karnataka, India

### Retainer Project for A Major Jewelry Brand of Indiaℹ️ Analyzed and prepared data using Agility Workbench for Netezza as a Database interaction tool• Providing decision support to the Jewelry team as a Retainer• Analyzing 1.8Cr Data of encircle customers for various projects such as new and exchange stories, premium members, buyer demographics, buying trends, purchasing power, and geography• Creating Adhoc and recurring reports, performing hypothesis testing… Show more ### Retainer Project for A Major Jewelry Brand of Indiaℹ️ Analyzed and prepared data using Agility Workbench for Netezza as a Database interaction tool• Providing decision support to the Jewelry team as a Retainer• Analyzing 1.8Cr Data of encircle customers for various projects such as new and exchange stories, premium members, buyer demographics, buying trends, purchasing power, and geography• Creating Adhoc and recurring reports, performing hypothesis testing, assessing market shocks, supporting product launches, and conducting RFM analysis.### Dashboarding For A Major Jewelry Brand of Indiaℹ️ Designed and developed workbooks, dashboards, global filter page, and complex parameter calculations using Tableau as the front-end BI tool and Agility Workbench for Netezza as the back-end.• Led development of BI solution for Supply-Chain, Manufacturing, Quality, and Logistics KPIs with a team of developers• Collaborated closely with various teams including Consumer Orders, Database Management, Quality, Corporate, and Supply-Chain• Utilized Tableau to analyze KPIs such as Due Date Performance and Lead-Time with year over year, quarter over quarter, YTD, and MTD comparisons• Optimized SQL Queries and created Views/Intermediary Tables, as needed, to efficiently supply data to dashboards• Produced Dashboards with Quick filters, Parameters, and sets to enhance view management### CRM For Automobile Auction Companyℹ️ Created Campaign Target Lists and post-campaign performance reports using Excel, Tableau, SAP BO as front-end, and SAS as back-end.• Utilized Excel, Tableau, SAP BO, and SAS to create Campaign Target Lists and post-campaign reports• Collaborated with stakeholders and team members across various locations• Developed and maintained SQL scripts and queries for data analysis and extraction• Proficient in requirement gathering, design, development, testing, and production rollout of reporting and analysis Show less

India

Bachelor Of Technology - Btech, Computer Science

90%

Ssc, 93%