AMRUTA TAWDE

DALLAS, TX 469-***-**** adjkq3@r.postjobfree.com

https://www.linkedin.com/in/amrutatawde/ https://public.tableau.com/profile/amruta.tawde#!/ EDUCATION

The University of Texas at Dallas December 2020

M.S. Information Technology and Management (STEM) GPA 3.6/4 University of Mumbai, India May 2018

B.E. Electronics and Telecommunication (Distinction Top 10%) GPA 3.8/4 WORK EXPERIENCE

Virtu Financial, Texas-United States September 2020-December 2020 Technical Compliance Analyst Intern (Tableau, SQL)

● Learning and improving the process for compliance validation, tracking and reporting to meet an aggressive compliance timeline

● Developing and modified procedures based on user inputs

● Developing dashboards on Tableau documenting efficiency of operating compliance processes, legislative and regulatory updates, and assist in trade surveillance and compliance reviews Vertafore, Denver-United States June 2020-August 2020 Business Analyst Intern (Salesforce, Excel)

● Performed customer data cleaning and validating the accuracy of the reports by reviewing on an opportunity level

● Developed Einstein dashboards on Customer data to discover trends & identify reasons behind customer churn and provide analytical reporting on Salesforce

● Collaborated with multiple other organizations (finance, operations, sales, customer success) to understand and perform root cause analysis behind the customer churn

Innovious Technologies, Pune-India

Data Analyst Intern (Excel, Tableau) December 2017-Febraury 2018

● Developed reports in Excel using advanced Excel functions like Pivot tables and motorized the reports by making data connections to excel using SQL

● Catalogued and assembled client’s website modified as per the proposed requirements & specifications

● Integrated business data from Innovious Technologies applications into dashboards to monitor usage statistics and application performance

TECHNICAL SKILLS

Tools: Microsoft Excel, Teams, SharePoint, RStudio, Salesforce Languages: C, Python, SQL (MySQL, Oracle), R, HTML BI and Visualization: Advanced Excel (Pivot Tables, VLOOKUP), Tableau, Power BI, Qlikview Soft skills: Highly organized, Punctual, Strong Analytics skills, Team Coordinator RELEVANT COURSEWORK

Statistics and Data Analytics, Business Analytics with R, Business Data Warehousing(ETL), Data Visualization, Data Management, Big Data, Object Oriented Programming, Algorithms and Data Structures, Operations Management, Agile Project Management ACADEMIC PROJECTS

Credit Card Analysis of Czech Bank Data, Using RStudio, MS SQL April 2019-May 2019

● Mined and analyzed bank data to classify the type of customer who makes a good candidate for a credit card using the decision tree algorithm to achieve a model accuracy of 57%

● Performed data wrangling techniques, combining multiple flat files using SQL joins, imputing missing values, feature scaling, converting categorical variables into dummy variables along with performing statistical analysis

● Created powerful visualizations of our data which helped to extract key insights Airline Flights Data Analysis (Kaggle data), Using Tableau January 2019-March 2019

● Created Interactive dashboards in Tableau on American Airlines & Southwest Airlines data to explore type of conditions that cause delays which affect airline timing at different airports Night Vision Robot, Using Python, HTML September 2017-March 2018

• Built a night vision wireless robot for the surveillance of human activities in war field or border regions to reduce infiltrations from the enemy side

• Developed an application on the Android Studio to control the robot, consisting of metal detection and firing mechanism in order to reduce risk of human causalities

LEADERSHIP & ORGANIZATIONS

• The Young Women In Science and Engineering, Mentor January 2019-April 2019

• CS Outreach Instructor, UT Dallas May 2019

Contact this candidate