Pawan P.

Pawan P.

Senior Analyst

Mumbai , India

Experience: 8 Years

Pawan

Mumbai , India

Senior Analyst

280258 USD / Year

  • Immediate: Available

8 Years

Now you can Instantly Chat with Pawan!

About Me

Having 8+ years of experience in Data Analysis and programming on various projects in Finance and Banking, Healthcare Clients, Consumer Sector and Media Sector, Tele-communication. Seeking opportunity as Senior Analyst in an organization where my kno...

Show More

Portfolio Projects

Description

• Performing data assessment by reviewing and monitoring Anti-Money laundering (AML) transactions consistent with global standards and procedures.
• Identifying close to 100k fallouts in the Data Quality report and executing Hive and Impala SQL queries to understand the root cause of the defect and underlying data.
• Assessing the 32 Critical Data Elements in the AML transactions responsible for NextGen and Feature Impact.
• Analyzing the behavior of millions of Asset Transfer Party, Journal and Trade Execution transactions from L1 layer to L4 layer in the Enterprise Analytics Platform to understand the attributes that impact feature calculation.

Show More Show Less

Description

Responsible for research and roll out of a comprehensive customer segmentation strategy. Provided key insights on defined consumer profiles to the B2C sales and marketing teams. Generated segmentation models using K-means Clustering in order to discover new segments of user. Developed a customer segmentation algorithm using python to boost sales leads & market share by 12%.

Show More Show Less

Description

YouGov Sport asks Australians every day about their views, attitudes and behaviors around sport, on specific teams and leagues and this past year, sports fans views of COVID-19 since the outbreak. This special project uncovers insights on Covid-19 and the impact of Australian sport, beliefs and expectations among sports fans, and looking ahead to a strong recovery of Australian sport in 2021 Built a random forest model in Python that combined the disparate sources into one projection that outperformed the mean absolute error of the next best projection by 18%

Show More Show Less

Description

  • Collaborate cross-functionally (Marketing, Finance, Stores, IM) to set growth targets and inform priorities for CRM analytics team
  • Lead team responsible for developing catalog circulation-analytics & customer-level planning, including file scoring for house and prospect circulation to meet financial goals
  • Lead CRM campaign analytics and reporting including LTV, CTA and ROI with focus on identifying opportunities to improve program performance
  • Develop and present reports focused on customer and campaign performance. This includes reporting on specific KPI trends and performance by campaign
  • Increase customer LTV through development of customer contact strategies informed by rigorous testing and customer analytics in areas of retention, frequency and spend
  • Drive increased ROI of direct response marketing program through development of lower cost pieces and more efficient mix of direct response vehicles in digital and physical channels
  • Proficiency with SAS or SPSS and advanced Excel

Show More Show Less