Candidates About

Eswar Musiboyina    

Data-driven Analytics professional with 3.5 years of experience in developing, modernizing and maintaining Enterprise Data Warehouse for Technology and Healthcare clients using MSBI, Big Data and Microsoft Azure HDInsight’s.

EDUCATION

Master of Science, Business Analytics, University of Texas, Dallas                    GPA – 3.8                              Aug 2016 - May 2018

Bachelor of Technology, Electrical Engineering,  K L University                        GPA – 3.7                               Aug 2010 - May 2014

TECHNICAL SKILLS

Certifications:                                 SAS-UTD Data Mining and BI Developer,  CCA Spark and Hadoop Developer (CCA 175)

Programming:                                Scala, C#, Python,  SAS, SQL, MDX, PowerShell

Business Intelligence Tools:        MSBI Tools – [SSIS, SSAS, SSRS], Mondrian, Tableau, Power BI

Databases:                                      MS SQL, MongoDB, Vertica, Redis

Big Data Ecosystem:                     Hadoop, HIVE, Sqoop, Impala, Flume, Spark, Oozie

Tools:                                               MS Office, Visual Studio, BIDS, IntelliJ IDEA, TFS, GIT, SVN, JIRA

WORK EXPERIENCE

Big Data Engineer Coop, Mede/Analytics - Dallas, TX                                                                                          May 2017 - Present

·         Developed data pipelines using Hadoop, SPARK & MSBI to generate dashboards for Healthcare Payer clients to identify where improvement initiatives are needed most and determine their revenue impact.

·         Monitored daily, weekly and monthly data loads for 50+ Healthcare Payer clients and fix issues generated in ETL.

·         Developed Scala scripts for dynamically parsing, validating and converting input text files into ORC in HDFS.

·         Improved query performance to 10% by implementing MS-SQL Performance tuning & optimization techniques.

·         Reduced DB storage utilization by 40% by migrating from traditional SQL backup restore to NetApp's Snap Manager (SMSQL) for snapshot backup and recovery.

·         Automated test cases to validate files by using PowerShell scripts and reduced QA effort.

·         Built real-time Clicks dashboards to gain insights about client adoption and engagement details using Spark streaming tools like Apache Flume, Kafka with REST API as source.

·         Designed POC to process logs for aggregation and analysis, create dashboards by using Elastic search& SPLUNK.

Business Intelligence Developer, Infosys Ltd - India                                                                                             Aug 2014 - Jun 2016

·         Designed SSIS packages to pull data from 40+ upstream sources. Implemented delta pulls to reduce run time.

·         Increased query performance, by optimizing the performance of various SQL scripts, stored procedures and triggers by identifying slow running queries using SQL Profiler and execution plan. 


·         Developed Multi-Dimensional cubes on SSAS to generate insightful and automated dashboards in Power BI to solve analytical needs and established right metrics using MDX for the key decision making purpose.

·         Migrated legacy system built using MSBI tools to MS Azure Data Lake using Hive scripting and Azure Data factory.

·         Built Azure Resource Manager(ARM) templates to deploy, manage &monitor all Azure resources into single group. 

·         Designed and developed automated test cases for ETL packages from On Premise to Azure and ensured successful migration for more than 2TB of data.

·         Actively participated in talent development initiatives across the business unit and trained 20 associates in MSBI.

Data Intern, Nanomindz Technologies - India                                                                                                           Jul 2013 - Dec 2013

·         Collected the Base-line data covering Consumer Indexing, GIS Mapping, mapped the entire power distribution using ArcGIS, AutoCAD to decrease power thefts to level of 15% and increase the reliability of power supply.

ACADEMIC PROJECTS

Predictive Analytics using SAS, R

·         Analysed 5 years scanner panel data to find out the drivers affecting Market Share for our brand using Elasticity model (Log-Log Model), RFM analysis to create customer segments, Brand Choice Model (Multinomial Logit) to model purchase behaviour of consumers and ARIMA Model for Forecasting.

·         Predicted telecom customers churn with 96% accuracy by using logistic regression, random forests & C5.0 model.

·         Predicted the sales price of house by analysing 79 explanatory variables describing (almost) every aspect of houses by using advanced regression techniques, Decision trees, Gradient Boosting, Ensemble modelling with an error of 20k.

Twitter Sentiment Analysis: KAFKA, FLUME, PYTHON

·         Created data pipeline using Flume, Kafka and SPARK streaming to fetch tweets about US airways reviews.

·         Implemented sentimental analysis on reviews expressed by travellers for US airways using Spark Mllib and the natural language toolkit[ NLTK] and calculated the flight satisfaction measure with accuracy of 95%.

ADDITIONAL INFORMATION

·         Received Infosys Insta Award for achieving 100% customer satisfaction throughout all the critical releases. 


·         Eligible to work in the U.S. for internships and for full-time employment for up to 36 months without sponsorship.