Rupika Gupta Email & Phone Number

Gurugram, Hr, In

Gurugram, Haryana, India

Bangalore Urban, Karnataka, India

• Building roadmaps for the accounts analytics team, ensuring meeting of deadlines by the team andstakeholder management.• Usage of epics/user stories in JIRA tool so as to ensure quality deliverables to the users.• Managed a team of data analysts. Responsible for code reviews, mentoring and guiding them.• Retailer Payout Report: Updation and maintenance of the retailer payout report responsible for all thepayouts to all the retailers associated with PharmEasy.• Backdated Updates: Application of backdated updates on 40+ reports so that backdated updates could beprevented and the integrity of the data could be maintained.• DQ Checks: Application of a framework to check and data sanity and data sync between live databaseand derived database, to maintain the Data Quality of the reports.• Automating and maintaining financial reports for all the retailers tagged with Pharmeasy using Python,SQL and Airflow.

Noida, Uttar Pradesh, India

LENDING (CREDIT CARD BUSINESS):-- Planning and executing acquisition campaigns based on 30mn audience and study which includes spend pattern and analysis.-- Created Google Data Studio Dashboards for CC spends and applications.-- Created and used Python scripts for various tasks in my work.-- Created GDS dashboard for MIS to track card applications, issued card spends, approval rate and MCC distribution, using BigQuery.-- Analysing and creating optimised segments to target in the campaigns to give maximized CTRs basis user’s spends patterns and interests.-- Carried out the whitelisting process for CC business.-- Being a point of contact for the stakeholders, carried out requirement analysis and project management work.PAYTM WALLETS:-- Planning and executing activation (for dormant wallets) and spends campaigns based on wallet load data of the audience (100 Mn & above) and study which includes spend pattern and analysis.-- Analysing and creating optimised segments to target audience based on the different pay modes (UPI, Net Banking, Debit Card, Credit Card etc. load, and merchant wise split (3P, Onus, Offline, P2P, P2B)-- To check and analyse the money load trend on the basis of geographical locations, and on customer segments like load decile, transaction decile, payment mode and category wise spends.

Bengaluru Area, India

-- Research on the trends of KPIs of the projects, Spend Analysis of the company using visualising tools like PowerBI.

Noida Area, India

-- Developed SQL scripts for the various apple products being added to the company’s inventory.

Noida Area, India

-- Backtracking and analysing the database errors by writing SQL scripts and correcting them. Worked on projects in Agile and Waterfall methodology.