Avtar Singh

• Work with leadership teams across the enterprise, including Product, Finance, Marketing and leading the BI team to provide essential strategic solutions to drive business growth and competitive pricing

• Lead Analytics team that is responsible for providing key insights and recommended actions to drive the business growth- Developing KRA Frameworks, Performance Tracking, Supply Drives Analytics, Competitor Benchmarking.

• Streamlined workflows by identifying bottlenecks in existing systems and proactively addressing these challenges through appropriate solutions implementation.

• Conducted competitive analysis to identify market trends and capitalize on emerging opportunities for growth.

• Driving end to end cost optimization projects and migration projects to improve the data warehousing performance.

• Identified the process gaps in system due to which organization was losing 1 Cr. Revenue on monthly and performing sensitivity analysis on fortnightly basis to prevent the organization from losses within existing set of process and services.

• Closely monitoring all business KPIs and share daily analysis with the leadership team for further business decisions.

• Successfully managed budgets and allocated resources to maximize productivity and profitability.

• Responsible for organization level budgeting and P&L which includes to identify what all services are not working in our favor.

• Reduced operational costs through comprehensive process improvement initiatives and resource management.

• Drive organization level rate loading project which helped us to streamline the pricing structure.

• Responsible for providing strategic insights for new client onboarding which included define customer profiling and seeking for the business opportunities to integrate our business Model.

• Working with leading Banks, OTAs and Enterprises to drive the business growth and share competitive pricing

• Value-based pricing: Determined customer perceived value and set price accordingly. Package curation.

• Built high-performing teams through effective recruitment, onboarding, and talent development initiatives.

• Established robust risk mitigation strategies to safeguard against potential operational challenges or disruptions.

• Python, Snowflake, Quick-Sight, SQL Server, AWS Athena, MS-Excel, tableau-RDP server and Power-BI.

• Work with leadership teams across the enterprise, including Product, Finance, Marketing and CX teams to provide essential strategic solutions to drive business growth.
• Responsible for setting up the framework required for implementing and adopting tableau among various LOBs.
• Successfully implemented the KYC and Digi-locker feature on rummy app which helped us to reduce the fraud by 9-10%.
• Driving end to end cost optimization projects and migration projects to improve the data warehousing performance.
• Closely monitoring all business KPIs and share daily analysis with the leadership team to take critical business decisions.
• Product Analytics – The new feature or any variation in the product must go through the product analysis.
• Performed analysis focusing business aspects, KPIs such as revenue, revenue per user, expense per user, ROI and retention metrics are analyzed before making any strategic decision.
• AB Testing – Marketing campaigns/ promotions and product changes were implemented using control/ test approach.
• If the business KPIs are in favor of the test group, then it had to be executed to all the user cohorts.
• Marketing Campaigns/ Promotion- One of crucial part of my work is to create simulations around marketing campaigns with the objective to increase overall business revenue and user retention in the system.
• Revenue Analysis – Responsible for performing revenue analysis, any dips and ups in revenue must be backed up by reasons for the change in the revenue metric.
• Usually, the process involves deep dive across geography, product, user behavior and bonus consumption pattern etc.
• Acquisition Strategy – Based on cumulative player value and customer acquisition cost, we identified states and channel where the revenue per user were highest and then based on the analysis, we do decisions on our acquisition spends.
• Working closely with Performance Marketing & Retention teams to drive acquisitions and campaign effectiveness.
• Successfully created a model around the payback period analysis which helped the marketing team to optimize their spending based on the inputs received from the analysis.
• Player Balance Anomalies- Recognize errors in the transaction system which cause us loss.
• The loss amount was approx 25M rupees.This activity prevents any future losses.
• Hands on experience on consumer engagement and retention KPIs and maintain the live dashboards.
• Built a Model to detect fraud users and unethical activities via the demographic details of the users. This is also helped us to save the unwanted money leakage happening in the system.
• Automate dashboards and other ad-hoc requests using tableau, snowflake, Fornax, AWS-Athena and Python.
• Python, Snowflake, Branch, click-streams, SQL Server, Dremio, Sagemaker Iceberg, AWS Athena, Google Analytics, MS- Access, MS-Excel, tableau-RDP server and Power-BI.
• Managed and optimized Cloud SQL databases for data analysis applications.
• Leveraged additional GCP data analytics tools like Dataflow and Cloud Spanner.
• Performed advanced troubleshooting and optimization of Big Query queries.
• Increased client data accessibility and analysis speed by 20% through Looker optimization.

• Work with leadership teams across the enterprise, including Supply, Revenue, Marketing and Product, to provide essential reporting solutions to drive International and domestic Hotel Business Teams.
• Lead Domestic Hotels Analytics team that is responsible for providing insights and recommended actions to drive hotel supply team effectiveness – Developing KRA Frameworks, Performance Reporting, Supply Drives Analytics, Competitor Benchmarking.
• 80% of Reports were Automated in the Year 2021-22 using Python and S.A.S Technology which resulted in saving of approx 100 Man- hours per week
• Responsible for setting up the framework required for implementing and adopting S.A.S Viya among various business-teams.
• Designed campaigns performance tracking mechanism for hotels supply.
• Built Hotel Quality Score to define quality of a hotel basis multiple quality related KPIs & build a reward plan around the same to ensure increased adoption of the product and identified right set of hotels for Cat-Rev Teams to increase dispersion (+2%).
• Migrated critical business dashboards (Productivity and NPS) on Qlik-View for tracking MoM and YoY Performance.
• Python, Hive, Data Bricks, Omniture, SQL Server, Redash, My SQL, Omniture, Qlik-View, Google Analytics, MS- Access, MS-Excel.

• Worked with internal stakeholders to provide end-to-end reporting solution for ongoing Insurance Policies
• Interact and Coordinate with the US counterparts to resolve the team Queries
• Designed KPI dashboard for the team to track monthly performance.

• Worked for JP Morgan chanse-US credit card services, I was responsible to track the day-to-day activities of the existing customers
• Supported team manager and other superiors with monthly review dashboards and presentations
• Had to block the credit card temporarily In case we came across any of the suspicious activity in the transaction’s patterns.

• I used to work for JP Morgan US Bank in credit card fraud detection team
• In which we had check the customer’s transactions behavior and take necessary steps in case we found any suspicious transaction/Activity in the transaction’s patterns
• I used to share the detailed analysis to the client for teams’ performance and the action we took against the Cards which are detected under the fraud buckets.

• Provide key insights to the management to track the Home loans & mortgage business numbers
• Supported team manager and other superiors with monthly review dashboards and presentations
• Designed Process Analysis Review on monthly basis and presented to our LOB