Subodh Agrawal

• Working with DEX( Delivery experience) Team at Amazon as client.
• Developed test and control campaign performance Framework to quantify audience performance and assess campaign effectiveness using a range of KPIs, Metrics and lifts, assisting stakeholders in making crucial marketing decisions.
• Built Python framework which brings data from User's Excel and loads into Redshifts tables. It helped stakeholders to make end product(Dashboard) scalable.
• Developed multiple insights dashboards for multiple teams inside DEX which helps them to take decisions for next steps.
• Reduced 400hrs work to 15mins work via SQL automation in AWS.
• Helped Team to build analytical infra and move things from Excel or manual work to Automated fashion call it as ETLV.
• Used AWS platform to schedule tedious reporting workstream code.
• Dashboard migration from Power BI to AWS Quicksight.
• Helped overall DEX team to reduce 20% of delivery time of Customers products.
• Proved successful working within tight deadlines and fast-paced atmosphere.

• Working on multiple types of Action dashboards in Power BI, Adobe XD and automating data flow using Spark SQL or Python based on client need and Data size.
• Identified and documented detailed business rules and use cases based on requirements analysis.
• Implementing end to end data visualization work in Power BI.
• Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
• Developed, implemented, supported and maintained data analytics protocols and standards.
• Prepared functional and technical documentation for clients dashboards.
• Created Automated dashboard using VBA and Macro, VBA PPT, VBA Email, VBA SQL are used as libraries.
• Helped junior team members to optimize their SQL and Power BI Dashboards.

Project: Candidate Persona

• Created semi-fictional representation of ideal candidate for hire.
• Defined characteristics, skills and traits that makes perfect hire.
• Produced monthly reports using python and Excel.

Project: Live Interview and Customer Health Dashboard

• Helped develop reports and data analysis.
• Pinpointing Trends and Patterns.
• Automated reports in SQL on MetaBase platform.
• Monthly reports using python pipeline and Power BI.

Project: Asynchronous Video interview text analysis.

• Data Collection, Cleaning and Transformation.
• Predicted Candidates joining possibility.

• Conduct data mining and data modeling in co-ordination with marketing team.
• Introduced new products which was selling with different riders.
• Created clusters of Producers by states, commissions, products, sales etc.
• Coordinated statistical data analysis, design, and information flow.
• Designed and developed and analytical data structures.