UTTAM KUMAR PATRA www.linkedin.com/in/uttampatra

ac6mnx@r.postjobfree.com Pittsburgh, PA 15217 +1-412-***-****

EDUCATION

Carnegie Mellon University, Heinz College of Information Systems Pittsburgh, PA

Master of Information Systems Management May 2018

Coursework: Database Management, Data Science & Big Data, Unstructured Data Analytics, Business Intelligence & Data Mining SAS, Exploring & Visualizing Data R, Decision Making Under Uncertainty, NoSQL Database Management, Statistics for IT Managers

SOA University, Institute of Technical Education & Research Bhubaneshwar, India

Bachelor of Technology - Information Technology May 2012

SKILLS SUMMARY

Languages: SQL, HiveQL, Python, R, Java

Tools: HUE, Tableau, Jupyter Notebook, SAS Enterprise Miner 14.2, RStudio, Microsoft Excel Solver and PowerPivot, Netbeans 8.1

Databases: Oracle 11g, Hive, Cassandra, PostgreSQL

Packages: scrapy, Pandas, numPy, matplotlib, seaborn, bokeh, statsmodels, scikit-learn, pyspark, ggplot2, dplyr, plyr, splines, tidyr

Technologies: Apache Spark, Hive, Oozie, Sqoop, Hadoop, HDFS, MapReduce, Google Analytics, Amazon EC2 for scikit-learn

Functional: Business Analysis, Project Management, ERP, High-Tech, Banking & Financial Services, Healthcare, Agile

Certifications: Advanced SQL, DataCamp Python Data Analysis, Google Analytics Beginner, Professional Scrum Certified - I

WORK EXPERIENCE

Tata Consultancy Services Bangalore, India

I.T. Analyst June 2012 – May 2017

Ensured end-to-end flow of data through middleware components facilitating bank’s financial and non-financial transactions.

Designed and monitored Managed and External Hive tables optimizing streamed data transfers from disparate data sources.

Managed slowly changing dimensions of all tables in Hive and verified changed column data against former type.

Wrangled data from Hive data warehouse schema directories and created various dashboards in Tableau using Hive connector.

Automated ETL data loading process in Hive using Oozie workflows and designed complex SQL queries for data processing.

Optimized customer experience from BI reports and conceptualized campaigning process for paperless billing adoption.

Designed Python scripts for wrangling data from flat files and logging systems fetching credit card details for reporting.

Assessed customer requirements, recommended solutions and defined business metrics for reporting to stakeholders.

Possess an understanding of Data warehouse workflows, pipelines, data marts, OLAP cubes and mapping rules for design.

ACADEMIC PROJECTS

Capstone Project Manager - Parkway West Career and Technical Center, CMU Spring 2018

Explored & Analyzed data occupation and industry data to analyze growing market trends relevant to a vocational course.

Visualized Bureau of labor statistics and department of education data using Python toolkits and created dashboards in Tableau.

Recommended popular vocational programs common in other centers and visualizing it using heatmap in Tableau.

Analysis of Fall Detection using Machine Learning Algorithms, CMU Spring 2018

Trained the data to predict classification of cases being Fall or No-Fall using Naïve Bayes, K-NN, SVM and mean normalization.

Feature engineered, selected, and predicted the average time when a person is facing a Fall and improved RMSE score by 0.2.

Data Analysis of Traffic Fatalities in the United States in Tableau, CMU Spring 2018

Cleaned and manipulated unstructured data sources and wrangled data using Python pandas toolkit for further visualization.

Used new clean data sources and created various visualizations of driving factors, road conditions, and distractions.

Analyzed the visualizations using geospatial, heatmap and bubble charts observing accident-prone zones and their severity.

Market Analysis for Autonomous Vehicles with IoT, CMU Spring 2018

Hypothesized market segments for IoT integration to Autonomous vehicles and IoT data will help make decisions in real-time.

Devised disruptive methods the trucking industry can utilize for revenue generation and seamless delivery to customers.

Business Intelligence & Data Mining of a European bank using SAS, CMU Fall 2017

Designed K-means clustering model of customer and market segments and applied BI strategies for target marketing.

Imputed customer data and trained for logistic regression and predicted customer’s decision to take term deposit in future.

Created DecisionTreeClassification model and pruned the tree avoiding overfitting and reduced the misclassification rate by 3%.

Data Modeling and SQL Data Analysis of Car Rental Company, CMU Summer 2017

Modeled the database and enforced check constraints, primary key and foreign key constraints on all database tables.

Designed complex SQL queries in Oracle for join operations, subqueries, windowing and analytics functions on large datasets.

Contact this candidate