Data Analyst

GAUTHAM MUDDAM

469-***-****, *******.****@*****.***

SUMMARY

* ***** ** ********** ** data analytics and data warehousing

Expertise in predictive modeling, data mining and statistical data analysis

Proficient in using statistical tool like TABLEAU, SAS

Good problem solving, data visualization, documentation and presentation skills

WORK EXPERIENCE

Data Analyst Intern Elo Touch Solutions February 2016 – July 2016

Build interactive dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently

Reviewed basic SQL queries and edited inner, left and right joins in Tableau Desktop by connecting live and static datasets

Generated context filters and handled performance issues while dealing with huge volume of data.

Created Tableau dashboards using Bars, Lines and Pies, Maps, Scatter Plots, Gantts

Involved in creation of complex stored procedures, triggers, tables, views and other SQL joins

Interact with end users on a regular basis to resolve issues

Business Intelligence Intern Lennox International Inc. February 2015 – December 2015

Worked with the end users to gather requirements and create operational reports and dashboards

Developed Business Intelligence solutions utilizing Web Intelligence 4.0, Tableau Desktop

Preparing dashboards using calculations, parameters in Tableau

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters in Tableau

Worked on the development of dashboard reports for the Key Performance Indicators for the top management

Created queries in BEx Query Designer using filters, calculated key figures, restricted key figures, variables and structures

Involved in working with different database environments and moving of universes and reports between PROD, DEV and TEST

Evaluated Web Intelligence against Tableau and Qlikview by creating same Reports/Dashboards with similar KPIs on all three tools

Analyst Programmer Infosys Technologies Limited July 2011 – November 2013

Project: National Australian Bank (NAB)

Key contributor to a data-warehousing project involving maintenance, migration, extraction, transformation and loading of data into target tables which is then used for reporting and analytics

Worked with SME’s in resolving data quality issues and service improvement initiatives

Automated reconciliation process using SQL and shell scripts

Analyzed and resolved issues with production data causing discrepancies in reporting at downstream systems like Anti-Money Laundering (AML), Customer Analytics (CA) and Decision Support

Automated the data migration from one database to another via dB link

Tuned SQLs for running longer hours to reduce the processing time by analyzing the oracle explain plan and incorporating the oracle hints wherever required

Implemented an Oracle 11g upgrade project for National Australian Bank (NAB) Oracle database 10g, which included changing the already running SQL, scripts wherever required

EDUCATION

Master of Science – Information Technology and Management December 2015

University of Texas at Dallas, GPA – 3.45

Bachelor of Engineering – Computer Science May 2011

Manipal Institute of technology, Manipal, India

SKILLS

Business Intelligence: SAP Business Objects 4.0, MSBI(SSRS,SSIS), R, Tableau Desktop and Qlikview Desktop

Programming Languages: PL-SQL, SQL, T-SQL, Python, C and C++.

Tools: MS Excel, BEx Query Designer, Information Design Tool, SAS Enterprise Guide, SAS Enterprise Miner

Database Systems: MS Access, MS SQL Server 2012, Toad, Teradata and Oracle SQL Developer 11g

Operating Systems: UNIX, Windows NT, Windows 2000 and Windows XP.

CERTIFICATIONS AND HONORS

The SAS Institute/ UT Dallas Graduate Certificate in Data Mining and Business Intelligence December 2015

Deans Impact Scholarship, Naveen Jindal School of Management, UT Dallas January 2015

ACADEMIC PROJECTS

Business Intelligence: Using SAS (Predictive Analysis)

Designed several models to predict factors involved in getting a vehicle SmartWay certified (Environment friendly).

Implemented various prediction techniques like Decision Trees, Logistic Regression and Neural Networks and came out with a champion model using the model comparison upon factors like ASE, MCR etc.

LEADERSHIP AND ORGANIZATIONS

Board of Directors, SAP Users Group October 2014 – December 2014

Sports Officer, Indian Student Association January 2015 – December 2015

Treasurer, Comets Cricket Club, UT Dallas April 2015 – December 2015

Contact this candidate