Supriya Tated
Data Analyst II · Excel Impact, LLC
Work Experience
Data Analyst II
Excel Impact, LLC2019 – Present
• Created ETLs in AWS Glue using Python Lambda scripts for storing data and maintaining data warehouse in Amazon Redshift. • Setup KPIs to analyze the quality of leads sold to buyers & track website conversions leading to valuable business recommendations. • Collaborated with C-suite stakeholders by identifying and resolving data gaps, thus improving profitability by 2% per month. • Implemented a data pipeline using Kinesis Firehose to support data streaming from our website data to load into S3 bucket & Redshift. • Performed K-means clustering to cluster states based on revenue and lead volume which helped in organizing the campaigns efficiently. • Built Dashboards in Qliksense showing trends in campaign performance, sales and profit over the years to track goals & productivity. • Managed data collection from required sources, data quality and timely delivery of data to information users through our BI reports.
Data Analyst Intern
Stearns Lending, LLC2017 – 2018
• Accountable for detailed analysis of business practices and providing business insights on ways to improve sales. • Identified 3000+ new clients with opportunity for business in MySQL Server after carrying out data cleaning and data validation. • Achieved data migration from SQL Database into CRM Tool- Salesforce increasing user adoption by 50%. • Analyzed market share of company in different MSA's and produced Heat Maps in Tableau showing potential areas of business. • Performed data analysis and mapping to update market share data in Salesforce for 6000+ accounts on weekly basis. • Conducted reporting analytics and presented results in Excel-based Reports using Pivot Tables, VLookup, Line and Pie Charts. • Generated ad-hoc reports to track geographic area transaction volume and mortgage loan originators' activity to target clients. • Automated tools and scripts to increase departmental efficiency and automate repeatable tasks. • Increased leads and opportunities in Salesforce, resulted in sales increase by 34%.
Database Management Intern
Zensar Technologies2015 – 2015
• Gathered real time data for database and provided analytical solutions using SQL for web portal updates, resulting in automation of manual tasks and improvement of man-hours by 30%. • Planned and implemented SQL Server software installations and upgrades to improve database setup and performance. • Modeled data into RDBMS structure that helped in reporting and maintaining over 200 client data using SQL Server.
Microsoft Technology Associate, India
EduKinect2015 – 2015
• Worked on how BigData in an organization is collected, processed and stored as information to carry out the functions of management. • Achieved problem solving and analysis using Hadoop tools like Hive, Pig, HBase and produced detailed analyzed reports for the team.
Education
B.E
Rajiv Gandhi Proudyogiki Vishwavidyalaya2016
B.E
M.S
The University of Texas at Dallas2018
M.S