July 2019 - Dec 2021
Business Technology Analyst
- Performed system setup of the Sales Crediting(SC) process using AWS Redshift, S3, EC2 using Agile methodologies
- Automated sales force operations of a billion $ US pharmaceutical company of about 4500 sales rep which resulted in
a cost reduction of 20% by mentoring a team of 5 members
- Reduced manual intervention by developing an ETL pipeline to ingest data in AWS S3
- Optimized complex SQL queries and performance tuning which improved database performance by 30%
- Cleansed, prepared and analyzed HR data to calculate various employee engagement KPIs using Alteryx through 12
data points
- Designed insightful Tableau dashboards to help the HR leads measure the effectiveness of the program
- Engaged clients to gather business rules and administered the design process for 3 quarters