TANIYA DHAR

adhs70@r.postjobfree.com 469-***-**** linkedin.com/in/taniyadhar github.com/taniyadhar SUMMARY

Skilled Data Analyst with over 5 years of diverse experience across different industries. Proficient in data analysis, reporting, complex problem solving and project management. Experienced in interpreting and analyzing data to reduce project costs by 20%. Furnished insights to support decision making using analytical tools and programming languages. EXPERIENCE

IT Business Analyst Intern, The Shields Group, Dallas, Texas Aug 2020 - Oct 2020

• Analyzed and transformed financial data in MS Excel using VLOOKUP, Power Pivot, Power Query, DAX and calculated functions

• Built 12 interactive dashboards for management and clients using Power BI that helped in deriving meaningful insights

• Researched for new means of obtaining data and utilized analytical tools for process improvement which saved time by 10% Data Analyst Intern, American College of Emergency Physicians, Dallas, Texas Jan 2020 - May 2020

• Analyzed healthcare data from SharePoint & created Power BI dashboards related to payment deadlines & discounts per visit fee

• Automated existing process using SQL to retrieve data from Clinical Emergency Data Registry which increased efficiency by 12%

• Developed a model to predict high-risk opioid patients using Python for the emergency physician team Analyst, Accenture (Client AT&T, Vodafone), India & United Kingdom Aug 2013 - Nov 2018

• Developed & executed complex SQL queries to mine existing customers data from Oracle DB which saved time by 7%

• Executed & processed bulk requests for large data from Oracle applications like Siebel CRM, BRM, OSM using UNIX shell scripts

• Created approximately 20 dashboards in Tableau related to customer preference of plans, packages and derived influence index

• Troubleshot production issues by analyzing XML log files across various systems which reduced customer issues by 5%

• Gathered requirements, developed functional documentation, and translated business needs into user stories

• Collaborated with stakeholders & cross-functional teams to deliver more than 200 change requests within 40 releases

• Interacted directly with business stakeholders in workshops to deliver user stories, planned and estimated test scope, performed requirement verification which reduced project costs by 20%

• Performed quality assurance (QA), system integration testing (SIT), led user acceptance testing (UAT) and ensured seamless go- live of releases for more than 15 million Vodafone mobile and fixed-line customers ACADEMIC PROJECTS

R project on financial and banking dataset (Rmd, Rattle, Shiny, tidyverse, stringr, dplyr, magrittr, ggplot2)

• Transformed, explored, and analyzed data of 12,000 transactions of 100 customers, and identified correlation among 23 variables

• Predicted annual salary of the customers with Linear Regression and Decision Tree using Rattle library Marketing Analytics project to improve sales of a coffee brand (SAS, Tableau, Price Elasticity)

• Analyzed the effect of change in sales to the change in price of the brand itself and based on competitors’ price

• Forecasted the sales of the coffee brand for 20 successive weeks by using Time Series Analysis method SQL Project on Home Credit default risk dataset from Kaggle (MySQL Workbench, MongoDB)

• Executed complex SQL and No SQL queries by using joins, subqueries, CTE, window, aggregate functions to get required outputs

• Performed cleaning and loading of data, created physical relational tables according to Entity Relationship Diagram Big data Project on Truck Fleet dataset (HDFS, HDP Tools, Tableau, ETL, Hadoop, Hive, JDBC)

• Created 4 tables using Hive, loaded data from HDFS via ETL and calculated the risk factor

• Processed data to create analytical reports and visuals using Tableau to identify risky truck drivers and idling trucks Machine learning using Python on Loan dataset (Python, NumPy, Pandas, Scikit-learn, Seaborn)

• Built 7 classification models to identify loan purchasers & created visualization using Seaborn & Matplotlib

• Executed Principal Component Analysis and Resampling Methods to acquire better train score EDUCATION

Master’s Degree, Business Analytics (Data Science) Jan 2019 – Dec 2020 The University of Texas at Dallas GPA: 3.4

Bachelor’s Degree, Information and Telecommunication Aug 2009 – May 2013 SRM University, Chennai, India GPA: 3.8

SKILLS

Languages/Tools: MS Excel, SQL, NoSQL, SAS, Stata, R, Python, Hadoop, Spark, Hive, SAP S/4 HANA, Google Analytics, AWS Data Models: Linear Regression, Logistic Regression, KNN, Decision Tree, SVM, Random Forest, Ridge, Lasso, PCA Project Management Methodologies: Agile, V-Model, Software Development Life Cycle (SDLC), Waterfall Data Visualization Tool: Tableau, Power BI, SAP Lumira, Qlik Sense Databases: Oracle, MySQL, MS SQL Server, Mongo

ORGANIZATION

Intelligence Analytics Society (Social Media Officer) Jan 2019 – Jan 2020

Contact this candidate