Pawan P.

Pawan P.

Senior Data Analyst with 8+ years of Experience

Mumbai , India

Experience: 8 Years

Pawan

Mumbai , India

Senior Data Analyst with 8+ years of Experience

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 organizati...

I bring value to clients business through diverse palette of experience and education. My inclination is towards simple and efficient designs. This leads to love for data, deep diving into the information at hand and discovering insights which will help clients to improve their business. - Worked with Fortune 500 companies in different domains like Retail and Logistics, Health Care, Banking and Finance.

8+ years of extensive hands on experience in the IT industry. - Experienced in Data analytics with a focus on statistical and predictive modeling along with expertise in Data Mining and Optimization techniques providing efficient and flexible reporting solutions. - Expertise in design and development of data mining algorithms to provide optimal technical solutions to clients using tools like R, Python,  Microsoft Excel and Access databases. Knowledge of SQL Query writing for extracting and data from various databases. - Developed performance Reports/ Dashboards, Metrics, attributes, filters, what-if analysis for different functional areas using Tableau, Excel, Qlikview and Power BI. - Understanding business problems, translate them into mathematical representations for predictive analysis. - Experienced in managing stakeholder expectations, excellent communication skills and demonstrated ability to work with and support cross-functional project teams and managing multiple projects simultaneously with attention to detail. - Areas of Interest: Predictive Modeling, Data Mining, Business Intelligence, Big Data Analytics, Business Analytics.

 

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