SUDHIR RAI

469-***-**** adegta@r.postjobfree.com www.linkedin.com/in/raisudhir github.com/sudhirrai15 EDUCATION

The University of Texas at Dallas, TX, USA (M.S. Management Information System) 2018-2020/GPA-3.6 Uttar Pradesh Technical University, UP, India (Bachelor of Technology, Information Technology) 2009-2013/GPA-3.6 SKILLS

Certification Business Intelligence and Data Mining, Tableaus Analyst, Desktop Specialist, SSA-C02(in progress) Tool & languages SAS, Tableau, QlikView, Power BI, Python, R, Data Mining, Statistic, Microsoft Excel, Agile Database MySQL, SQL Server, PostgreSQL

Big Data Spark, Hadoop, MapReduce, YARN, FLUME, HIVE Cloud Computing AWS (EC2, S3, EMR, Route53, DynamoDB, Redshift, Aurora, EBS, Lambda, QuickSight) PROFESSIONAL EXPERIENCE

Primus Global Services Inc., Irving, TX, USA Jul 2019-Nov 2019 Data Analyst Intern

• Improved demand forecasting that reduced backorders to retails partners by 13%

• Created Visually impactful dashboards in Excel, Tableau and AWS QuickSight for data reporting using pivot tables and VLOOKUP. Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful actionable information

• Increased the claim clearance process by 30% by generating a validation report to improve the billing practice Capgemini, Hyderabad, India Aug 2016 Jul 2018

Associate Data Analyst

• Identified 60% of a fraudulent transaction by transforming and cleaning structured and unstructured financial data in Python and SQL to analyze various sources for fraud transaction

• Developed dynamic and interactive dashboards in Power BI to provide tracking of key financial performance metrics

• Analyzed and confirmed the legitimacy of customers fraudulent credit card transactions resulting increase ongoing transactions by 10%

Wipro Limited, Hyderabad, India Jan 2014-Aug 2016

Software Engineer

• Extracted data using SQL and performed cleansing, modeling, and filtering of data over the different region for analysis in Python

• Decreased in fraud Telephone PIN transaction after encrypting TPIN using IBM encryption routine caused increased usage of a credit card by 15%

• Created dashboard to present type of transaction causing fraud and factors contributing in a fraudulent transaction ACADEMIC PROJECT

Visualize Impact of a refinery in states (Tableau, R script) Oct 2019-Dec 2019

• Understanding the uncertainty involved due to natural disaster in USA that could shut down oil refinery, 60% natural disasters caused by a hurricane to Citgo Refinery between 2004-2015

• Extracted data using SQL and converted the raw data into meaningful visuals in Tableau to better quantify overall risk on people and infrastructure system

Consumer complaint Analysis (Big Data, AWS, Hadoop, Yarn, MapReduce, Hive, Flume, Python) Feb 2019-Apr 2019

• Identified 80% web-complaint out of which 90% were solved after examining, preprocessing and conducting descriptive analysis on 42000 consumer complaints data using Hadoop, Hive, PySpark, AWS EMR, and S3

• Displayed 80% of complaints are against credit score bureaus were loan providing institutions Predict Customer lifetime value (SAS E-miner, SAS) Sep 2018-Dec 2018

• Performed predictive analysis on 10000 customer’s data to predict the most profitable customers by performing PCA, Decision Tree, Linear regression using SAS E-Miner resulted in respective MSE value of 0.0188 and 0.020

• Resulted in retaining and focusing on a customer with a luxury vehicle and 2 policies to increase the revenue