Pankaj Dev

Extracting and cleaning diverse datasets from Salesforce, Quickbase, and Aptora. Leveraging Python and MS Excel, I contribute to data accuracy, laying the groundwork for effective analysis and data-driven decision-making.

• Managed and maintained category spend dashboard on Tableau using Alteryx to collect data, providing leadership with vendor spend insights. • Generated monthly reports for leadership by aggregating data from multiple sources using Hive SQL and Alteryx. • Worked on a project to identify patterns in sales and used tax transactions, improving accuracy of refund tagging and resulting in the reclamation of previously overlooked funds using python and alteryx workflow.

• Migrated over ~4 TB of data from Amazon - Aurora MySQL to Redshift using Data Migration Services, S3 bucket & Lambda function. • Optimized the process by creating automated scripts reducing the load time from 7 hours to 20 minutes, resulting in an increase in efficiency by 95%.

• Developed insights-driven solutions for increasing customer engagement & improving user experience, contributing to an increase of 40% in the average revenue per account (ARPA). • Monitored performance of multiple reports and product lines to identify trends, yielding insights for further optimization & growth. • Conducted thorough funnel analysis of payment transaction for Merchant product, identified key opportunities to optimize revenue growth.

• Ad-hoc Reporting: Extracting and manipulating data from BQ and producing the desired stats and dashboards in the agreed format. • Dashboards: Created visually impactful dashboards in Data Studio for data reporting. • Analyzed GKE usage and consumption for cost optimization. • Collaborate and meet with data, marketing, and product teams to discuss the requirement of data/reports. • Carried out experimentation using A/B testing on the UI and analysing the result to check the engagement rate

• Cleanse the data to remove anomalies and translate it into a format that can be easily imported into RiskLink application software. • Responsible for the Quality Check for of the deliverable of the project. • Developing queries for daily data processing and automation using SQL. • Supported cross-functional teams in production in different Line of Business