Vikas Choudary Dandamudi

BI Data Analyst

Capital One•  October 2019 - Present

Working in the Auto Finance area to transform the logic developed in SAP and Web Intelligence reports into Tableau. Built complex SQL scripts from scratch to bring in relevant metrics and aggregate the data before feeding BI tools Developed and maintained more than 20 reports in a span of 6 months. Also part of internal Tableau SME team to work on challenging requirements Communicate with internal clients to develop and translate a business requirement into an effective and insightful interactive analytical dashboard Structured the dashboard with a consistent layout with visuals at the top and corresponding Tabular data at the bottom for various analytical reports from multiple data sources by blending data on a single worksheet Created visually rich dashboards with bar graphs, scattered plots, geo maps, heat maps, crosstab with more than predefined limit of 16 columns Designed a dashboard with trend views, bullet charts to compare against a goal for associate performance and used parameters, sets, groups and calculations Combined the different views into a dashboard and published them to the Tableau server with a fixed refresh schedule Performance tuned the Dashboards to meet the SLA of less than five seconds of load/refresh on the Tableau server Provided ad-hoc support for the dashboard and views in the tableau production server Performed User acceptance testing with the business user and mentored them on how to slice and dice the data using different filters in the dashboard Collected, cleansed and provided analysis of structured data used for major business initiatives Created documentation(metadata) for the new tables created for production and worked with quality assurance associated to ensure standard data quality and naming conventions Used advanced Microsoft Excel skills to create Pivot tables, VLOOKUP and other excel functions Participated in weekly meetings and reviews with internal stakeholders and business groups Tools Used: Snowflake, Databricks, Oracle, SQL, Teradata, Tableau, JIRA, Confluence

Data Analyst

John Deere•  November 2018 - September 2019

Manage and deliver multiple projects of nature 1) Reliability Analytics 2) Proactive Insights/Innovation 3) Product/Process Optimization Perform Warranty and Reliability Analysis and Predictive modelling Responsible for delivering business insights from machine telematics data combined with various internal data streams Provide analytics solutions for identifying patterns or trends related to reliability performance using telematics data. Work with cross functional teams to develop actionable high impact data analytic solutions Responsible for developing reliability models, reliability test plans, and analyzing reliability risks for future product programs Working on Field Reliability Data Analysis, Design for Reliability (DFR),Root Cause Analysis (RCA),Failure Mode and Effects Analysis (FMEA),Design of Experiments (DOE) and Statistical Data Analysis Part hours Forecasting: Using survival analysis to predict the failure rate after x hours of usage of a part and use this model to map the demand of these parts at the dealer Predicting Failures: Using historic DTCs (Diagnostic Trouble Codes) and Engine Hours by product to forecast the customer failures correlating with warranty claims before they happen using logistic regression this helps in improving customer uptime during crucial harvest/planting seasons Failure Mode Classification: Use NLP (Natural Language Processing) and multi text classification to cluster warranty claims by Failure mode Tools Used: ER Studio, Teradata13.1, SQL, PL/SQL, Oracle, Python, Tableau, Hadoop, RStudio, Hive, Netezza

Data Engineer

P&G•  September 2017 - August 2018

Involved in extracting and transforming of Data from Enterprise data warehousing Actively involved in communication with Business Analyst, user acceptance testers and BPM for requirements gathering. Engaged in performing various ad-hoc queries Handled importing data from various data sources, performed transformations using Hive, Map Reduce, and loaded data into HDFS Created Hive queries that helped analysts spot emerging trends by comparing fresh data with EDW reference tables and historical metrics and processed the data using HQL (like SQL) on top of Map-reduce Worked on database design, relational integrity constraints, OLAP, OLTP, Cubes and Normalization (3NF) and Denormalization of database Experience working with Hive data, extending the Hive library using custom UDF's to query data in non- standard formats Developed PL/SQL packages, stored procedures, functions, alerts for ensuring the warehouse data integrity checks and shell scripts to balance the data between source and target tables after each ETL process Understanding client’s information needs, business objectives, and market sectors and implementing appropriate data analysis strategies Tools Used: ER Studio, Teradata13.1, SQL, PL/SQL, Oracle, Python, Tableau, Hadoop, Spark , Scala, Hive

Data Analyst

Bank of America•  November 2016 - November 2017

Worked as a part of Global Compliance team which test monitors the systems that acquire processes, reports and archives data from a worldwide network Conduct a time-sensitive, meticulous investigation and analysis of each instance of potential Anti-Money Laundering activity and/or suspicious financial activity across multiple jurisdictions and countries, utilizing a wide variety of research and analytical tools Assist in determining the effectiveness of existing technologies and processes in relation to the SQL Architecture, create necessary implementation/migration plans, and recommend new solutions as required Assist in leading the development and implementation of various strategic SQL Architecture initiatives around master data management, data quality, data management policies/standards, data governance, and metadata management Developed various python queries and pulled data from multiple data sources and used in different kinds of reporting Used python pandas numpy and various other libraries for analysis of data and loading tables in the database for analysis purposes Worked with complex SQL queries and developed reports using many different tables from python using Python-MySQL connector and MySQL dB package Performed Exploratory data analysis to track, report and monitor effectiveness of controls and in tracking, monitoring and escalation of risk related issues to management Tools used: SQL, Python, Tableau, SAS, Power BI, Oracle, Teradata, Excel, Toad, AWS Cloud Tools

Technical Analyst Intern

SERC Reliability Corporation•  May 2016 - August 2016

Worked on Federal Government Project-Outages and Risk Assessment Analysis which included data fields like Outages, Causes, Performance, Risks, etc Used Visual analytics to understand the relationships between variables Interpreted the findings at each step from business sense as well Reported the analytics results, insights and recommendations which helped the firm to take actions to avoid the outages and assess the Risks involved with outages

Teaching Assistant

University of North Carolina at Charlotte•  May 2015 - July 2016

Visual Analytics and Data Warehousing Course Participated in the assessment process using a variety of methods and techniques and provide effective timely and appropriate feedback to students to support their learning Mentored students along with Professor Atif Mohammed. (Tools used: Tableau, Excel, Sisense, R) The course introduces students to broad classes of techniques and tools for analyzing and visualizing data at scale. It emphasized on how to combine computation and visualization to perform effective analysis. Students worked in small teams to complete a research project exploring novel approaches for interactive data & visual analytics

Data Analyst

VN Steel Industried Ltd.•  May 2014 - January 2015

Provided scheduled and ad hoc metrics reports with actionable recommendations Identified key performance indicators by capturing client's business at each client level Extensively used SAS, Tableau and R to analyze various attributes such as market trends and sales to provide a comprehensive recommendation for products pricing Created Tableau dashboards for reporting and performed data analysis on daily, weekly, and monthly scheduled refresh of data based on business to ensure accurate and updated information and created Tableau dashboards for reporting recommendations

University of North Carolina at Charlotte, Charlotte

Data science and Business Analytics, MS•  January 2015 - August 2016

(GPA 3.8) Relevant Courses: Business Intelligence and Analytics, Big Data, Visual Analytics, Database Systems, Machine Learning, Advanced BI, Natural Language Processing, Data Warehousing