Responsible for building and pivoting the credit card(CC) cross sell strategies to increase activation rate, spends, profit and mitigating the risk, while leading small team of 2 members.Key Project(s)-• Profitability based Pre-Qualified base programs: Revamped a vintage framework used by the bank to identify Pre-Qualified base to cross sell CC. The developed strategy focused on identifying low risk, potential profitable segments leveraging credit bureau data.• CC Acquisition… Show more Responsible for building and pivoting the credit card(CC) cross sell strategies to increase activation rate, spends, profit and mitigating the risk, while leading small team of 2 members.Key Project(s)-• Profitability based Pre-Qualified base programs: Revamped a vintage framework used by the bank to identify Pre-Qualified base to cross sell CC. The developed strategy focused on identifying low risk, potential profitable segments leveraging credit bureau data.• CC Acquisition guiding framework- Built an automated dashboard application showing -Default rates, sourcing and growth opportunity (Share of wallet and default rates on credit bureau) by micro segments. Show less

Business Analyst | Manager at Axis bank BIUResponsible for building strategies to identify low risk customer segments analytically, to cross-sell Credit card to ETB (Existing To Bank) customers, DC-EMI to Debit card holders and CLI offers low risk CC customers. The development and testing of strategy involves analyzing large datasets, pitching the strategies to stakeholders including Business & Risk teams and tracking the risk and acquisition metrics were part of day to day.Key… Show more Business Analyst | Manager at Axis bank BIUResponsible for building strategies to identify low risk customer segments analytically, to cross-sell Credit card to ETB (Existing To Bank) customers, DC-EMI to Debit card holders and CLI offers low risk CC customers. The development and testing of strategy involves analyzing large datasets, pitching the strategies to stakeholders including Business & Risk teams and tracking the risk and acquisition metrics were part of day to day.Key Project(s)-• Developed a strategy to cross sell, low risk, already carded customer segments to cross sell Rupay variant to bring their UPI spends on Rupay Credit card. The released strategy has helped bank to acquire monthly ~15K extra cards to the portfolio increasing the share of wallet of the target segment as expected.• CLI (Credit limit Increase) Strategy revamp-Developed risk sloped CLI multiplier strategy by which, increased the CLI offer base size by ~75% and that in turn increased the CLI take-up rate by ~25% while having the risk rates under the threshold.• Base creation process migration to BDL from on-prem- Lead the migration project end to right from requirement gathering and building the processes from DE till Quality assurance till• Automation of Daily sales and monthly Risk dashboards- Have set up a automated tracker, which sends an e-mail notification with acquisition, conversion and risk metrics at end of every day. It reduced hours of manual data pull and modification efforts.• DC-EMI base preparation strategy revamp- Re-designed and automated the DC-EMI offer base creation, release and risk tracking processes, which has cut down the manual base creation efforts from a week to 3-4hrs. This reduced the operational cost. Show less

• Was helping TJX companies Inc in their data and analytics.• Pull store wise sales and returns trend reports and analyze performance of stores - by week, by month and year to year.• Understanding business requests and writing complex SQL to pull ad-hoc csv reports, If the requests are often, automate the incremental pull using Talend/Datastage and control-M.• Building ETL/ELT pipelines using Datastage and Talend to consume and transform 3rd party data. Scheduling the same ELT jobs… Show more • Was helping TJX companies Inc in their data and analytics.• Pull store wise sales and returns trend reports and analyze performance of stores - by week, by month and year to year.• Understanding business requests and writing complex SQL to pull ad-hoc csv reports, If the requests are often, automate the incremental pull using Talend/Datastage and control-M.• Building ETL/ELT pipelines using Datastage and Talend to consume and transform 3rd party data. Scheduling the same ELT jobs using Control-M to automate the process.• Conducted Migration testing of 1500 BI jobs to ensure smooth migration them from ESP to Control-M.• POC on Web scraping using R: Built and tested and framework to scrape thousands of rows ethically from multiple websites to collect and ingest data into Databases for pricing analysis. Show less

• Helping Arcadia Group Ltd in ETL development.• Data migration and data reconciliation process: Built ETL jobs using Datastage and productionalised them to migrate the data in batches. The jobs also had reconciliation functionality which generated and mailed reports with check sum and migration variance if any.

• Got trained on D.W. & ETL concepts and at the end of the training did an end to end BI capstone project using the concepts practically.