Pankaj Dev

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

1. Managed and maintained category spend dashboard on Tableau using Alteryx to collect data, providing leadership with vendor spend insights. 2. Generated monthly reports for leadership by aggregating data from multiple sources using Hive SQL and Alteryx. 3. Implemented the Apriori Algorithm to analyze sales patterns and tax transactions. Leveraged Python and Alteryx workflow to enhance refund tagging accuracy, reclaiming previously missed funds. 4. Stakeholder management

1. Conducted comprehensive analysis on marketing campaign data for client, identifying patterns that led to a 15% increase in campaign success rates by focusing on younger customers and utilizing cellular contact methods. 2. Developed predictive models achieving 82% accuracy, precision, and recall to optimize marketing strategies and improve ROI for future campaigns. 3. Migrated over ~4 TB of data from Amazon - Aurora MySQL to Redshift using Data Migration Services, S3 bucket & Lambda function.

1. Analyzed customer feedback data from over 5K customers and conducted a series of A/B tests, yielding insights with up to 15% improvement in product features. 2. Developed insights-driven solutions for increasing customer engagement & improving user experience, contributing to an increase of 40% in the average revenue per account (ARPA). 3. Monitored performance of reports and product lines to identify trends, yielding insights for further optimization & growth. 5. Funnel analysis of payment transaction.

1. Ad-hoc Reporting: Extracting and manipulating data from BQ and producing the desired stats and dashboards in the agreed format. 2. Dashboards: Created visually impactful dashboards in Data Studio for data reporting. 3. Analyzed CDN Logs Stored in S3 buckets using Athena. 4. Analyzed GKE usage and consumption for cost optimization. 5. Experimentation using A/B testing on the UI 6. Chat transcript analysis in discord channels.

1. Cleanse the data to remove anomalies and translate it into a format that can be easily imported into RiskLink application software. 2. Responsible for the Quality Check for of the deliverable of the project. 3. Proficiency in writing SQL queries to extract data from vendor Catastrophe model databases. 4. Supported cross-functional teams in production in different Line of Business. 5. Client Communication