Data Analyst Assistant

Ganga Gudi

addlf0@r.postjobfree.com https://www.linkedin.com/in/gangagudi/ 312-***-****

Illinois Institute of Technology, Chicago GPA – 3.8/4 May 2020 Master’s in Information Technology and Management (Data Management) Visvesvaraya Technological University, Belgaum, India GPA- 3.5/4 June 2015 Bachelor’s in Computer Science.

Technical skills:

Programming Languages: Python, SQL, R programming, Java, Java Script Software: SSRS, MS SQL, Oracle SQL, Informatica

Tools: Tableau, MS Power BI, SSRS, SSIS, Python (Scikit Learn, Pandas, NumPy, Matplotlib, seaborn, plotty, cufflinks), Jupyter, Pentaho, SharePoint, Microsoft Visual Studio, Microsoft access, IBM Products: Service Now, Sterling B2B Integrator, Sterling File Gateway, Active Directory, Jira

Cloud Technologies: Microsoft Azure, HDFS, MapReduce, Spark, Hive, Pig, Kafka Work Experience:

PCMI Corporation, Chicago Position: BI Analyst Intern January 2020 – April 2020

• Built optimized stored procedures that provides efficient BI solutions for customer reports using MSSQL

• Created quality reports for cloud-based platform, Policy Claim and Reporting Solution using SSRS and PowerBI to handle huge insertion of data using dynamic programming techniques

• Performed data migration tasks (ETL) for storage of report and data files as per customer requirement using SSIS

• Performed Functional, Integral, Performance and Regression testing related to Data warehouse applications.

• Created and analyzed tables in database using snowflake model for faster access of data during report creation Illinois Institute of Technology, Chicago Position: Research Assistant June 2019 - Sept 2019

• Built efficient information retrieval system in construction corpuses based on Random walk Algorithm using Python.

• Preprocessed the documents through tokenizing, stemming, capitalization, stop word and punctuation removal.

• Retrieved the documents in the right order using Random walk algorithm.

• Designed dashboards and reports on Tableau for the pipelines and data, analyzed during the research. Tata Consultancy Services Position: Data Analyst Dec 2015 - June 2018

• Designed and developed various SQL scripts as part of automation of manual monthly reporting to third party consumer and various analytical reports from multiple data sources using Tableau.

• Scheduled monthly operational reports based on the business requirement.

• Worked in Managed File Transfer (MFT) Project for file/data secure transfer.

• Lead the offshore team for integration/system/performance to guide the team in developing optimized code deliverable. Academic Projects:

Restaurant Website Data Analytics, Illinois Institute of Technology, Chicago August 2019 - Dec 2019

• Preprocessed about 50,000 records of data collected for further analysis on restaurant service, food, customer visits and ratings using Python

• Created dashboards and implemented visual analytics on the data using Tableau

• Built several models and classify applications, achieved 90% accuracy using the Classification and Multiple regression models

• Built a recommender system using collaborative filtering based on the user reviews and ratings on the restaurant Analysis on Market during Black Friday, Illinois Institute of Technology, Chicago February 2019 - Apr 2019

• Preprocessed about 30,000 records of data collected for further analysis on sales and customers and ratings using R

• Created dashboards and implemented visual analytics on the data using PowerBi

• Implemented Decision Trees, Random Forests, Naïve Bayes, KNN and Logistic regression to predict sales during Black Friday

• Time Series Analysis of the Black Friday sales to understand the trend of purchase made by customers in the city between the years 2014 to 2018 Travel Booking Consultancy Management Application, Illinois Institute of Technology, Chicago August 2018 - Dec 2018

• Created a GUI for the air booking consultancy to add customers, flights, travel plans and view customer travel history

• Implemented a Client Menu to edit information, change flights, tickets and view bills using Java, MySQL and JavaFx Chicago Crime Analysis : Illinois Institute of Technology, Chicago August 2018 - Dec 2018

• Examined, analysed, cleaned and transformed the Chicago Crime Dataset with over 100,000 records

• Predicted the arrests made against the crimes by building a Multiple Linear Regression Model

• Cluster Analysis of the crimes based on the Location of the Crimes to gain insight over the streets with the highest crime rate

• Visually recognized the highest crime areas by generating a heat map for the city along with several other Crime Statistics reports Achievements:

Awarded Tech Edge Scholarship at Illinois Institute of Technology worth 10,000 USD for exceptional academic background

Contact this candidate