Lokendra Parihar
Principal Business Analyst
Summary
Results-driven, Detail-oriented and well-qualified Engineer with more than Seven years of experience in SQL, Programming in Python/R, Tableau /Power BI.Large and Complex data manipulation, Analysis, Supply analysis, reporting and visualization
Overview
8
8
years of professional experience
Work History
Principal Business Analyst
Times Black ICICI Bank Credit Card
03.2024 - Current
- Creating Daily Cards Sourcing plans with different channles using comms to targeting specific audience reducing cost and reducing CAC
- Audience upload on meta and google and find optimum lookalike for targeting
- Monitor end to end funnel on website,app, meta , google and idenotfy the cohort performing and improve non performing
- Creating all Daily reports like sourcing numbers ,traffic .funnel performance and app performance etc
- Developed key performance indicators, allowing for ongoing monitoring of business operations and progress towards goals.
- Attribution funnel for b ank and TIL carding reconcillation like invociing and SCN level repots
Senior Business Analyst
Times Internet Limited
08.2022 - Current
- Daily reports setup for supply performance in the form of emails for stakeholders using SQL, Python and R.
- Build automated dashboard using google sheets and Looker/Power BI
- Created Prediction Models Using Statistics Linear and Logistic Regression for improving channel level supply.
- Product analysis of users journey for dropped off users and retargeting them for improving funnel conversion.
- Analyzing Channel Level Performance like offline online (meta/google/Instagram etc.) and providing insights.
- Created Customer Data Platform(CDP)for Multiple business and aggregating data at one place for user journeys.
- Offer performance basis different geographies and age group and channels to take decisions for stakeholders
- Finding the target customer for app engagement and marketing/Growth team for better conversion of leads.
- Written Event for feature development and providing visibility and impact of that feature on business
- Providing automated data solutions for different team like Ops, Product, Growth and CRM which help in optimizing different processes.
Supply and Revenue Analyst
OYO Hotels and Homes Pvt. Ltd.
01.2019 - 08.2022
- Worked in Supply Team and monitored DOD performance related to revenue and growth.
- Analyzing different states district level supply and finding potential of that geography.
- Analyzing impact of various coupons and price algorithm on current business and its feasibility in future.
- Worked on finding insights from unstructured market size and analyzing to find potential of that market.
- Partner with local team and providing them data reports and insights which help them in taking decision over supply and pricing.
Resource Analyst
Grey Orange India Private Limited
02.2018 - 12.2018
- Improved overall efficiency and productivity of NOC by 17% by developing SOP's & troubleshooting processes for NOC Engineers.
- Worked extensively on CRM tools to develop the ticketing system – leading to improvements in the products
- Monitored system performance and uptime and responded quickly to incidents
- Developed SLAs and escalation matrices to create consistency and improve response time
Education
Mechanical Engineering
Sharda University
Greater Noida, India 04.2001 -
Skills
- Python, SQL, R,Big Query,Google Cloud Platform,Looker Studio/ Power BI/ Tableau
- Statistic Data Modeling, Predictive Modeling (Linear and Logistic Regression)
- Large Data Manipulation using R/Python and Excel
- Clevertap,Google Analytics,
- BRD and PRD Documentation for feature development in product and A/B Testing
- User Journey creation app/web events and profile integration and writing event schema
- User Retention and Growth and CRM analysis and optimization of user daily communications
Timeline
Principal Business Analyst
Times Black ICICI Bank Credit Card
03.2024 - Current
Senior Business Analyst
Times Internet Limited
08.2022 - Current
Supply and Revenue Analyst
OYO Hotels and Homes Pvt. Ltd.
01.2019 - 08.2022
Resource Analyst
Grey Orange India Private Limited
02.2018 - 12.2018
Mechanical Engineering
Sharda University
04.2001 -
Similar Profiles
Crystal JoubertCrystal Joubert
Data Scientist II at First National Bank (Credit Card)Data Scientist II at First National Bank (Credit Card)
Ling JiangLing Jiang
Data mining at CITIC Bank Credit Card CenterData mining at CITIC Bank Credit Card Center
Sonia RawatSonia Rawat
Sales Executive at HDFC Bank (HDB Finance Credit Card Department)Sales Executive at HDFC Bank (HDB Finance Credit Card Department)
Shivani MohapatraShivani Mohapatra
Principal Business Analyst at Manhattan AssociatesPrincipal Business Analyst at Manhattan Associates
Ryan PerkinsRyan Perkins
Principal Business Analyst at National Grid USAPrincipal Business Analyst at National Grid USA