Vivek Gadiraju

• Automated Mexico Tax Reports using AWS EMR and Spark SQL, saving approximately 100 hours annually for MX Tax team.
• Consolidated six Account Receivables reports into one, reducing monthly processing time by 50%.
• Collaborated with business stakeholders to identify data sources for ETL pipeline development in MX Tax Reporting.
• Provided ad-hoc support for customers on MX Tax Reports during new launches or expansions.

• Achieved 100% efficiency in housing forecast applications through Python and SAS script development.
• Migrated applications to AWS Cloud with AWS team, increasing speed by 50% and enhancing data load capacity.
• Ensured 100% accuracy across ETL pipeline processes by developing complex SQL queries.

• Created business metric reports using Tableau to monitor and prevent fraud in AWS team.
• Developed enforcement jobs utilizing SQL and Python to prevent bad actors from leveraging AWS resources, reducing fraud from approximately $200,000 to $9,000 monthly.
• Developed complex SQL queries to conduct ad-hoc analysis based on stakeholder requirements.

• Developed Lambda functions in Python for AWS Console, enhancing data application efficiency by approximately 50%.
• Executed complex SQL queries to support multiple Big Data jobs.
• Designed Jenkins pipelines for streamlined code deployment in AWS Cloud Infrastructure.
• Built various Tableau dashboards for product consumers and data analysis.

Prepared weekly transaction reports in Excel, analyzed player data using MySQL, R, and SAS, and developed Tableau dashboards to support data-driven management decisions.