SOMA SEKHARA SAINATH KESANAKURTHI

Salt Lake City, UT 385-***-****

adquj6@r.postjobfree.com www.linkedin.com/in/somasekhara-kesanakurthi-b04599205

EDUCATION

University of Utah, David Eccles School of Business, Salt Lake City, UT Expected Graduation: Dec 2022

Master of Science, Business Analytics GPA : 3.8

Coursework in Database Theory and Design, Statistics and Predictive Analytics, Business Analytics, Data Visualization, Data Mining and Data Warehousing

JNTU Kakinada, Vishnu Institute of Technology Aug 2013 - May 2017

Bachelor of Science, Electronics and Communication GPA : 3.5

Won Paper Presentation at IETE Event, Won paper presentation at ISTE Event on wireless networks.

SKILLS

Databases/Big Data: SQL Server, MySQL, DBEAVER, PostGres, SQL Developer, Excel/Access

Statistics: Linear Regression, Hypothesis Testing, Modelling techniques, Multi Linear Modelling, Logistic regression

Analytics/Visualization/CRM: R, Tableau, Power BI, MS- Access, Google Sheets, Oracle BI publisher

Web Tools/Technologies: CSS, HTML, XML

Project Management: Scrum, Waterfall, DevOps, Agile

Programming: R, Python, SQL, PL-SQL, Jython, Java,MS-Excel, Word, Power point

EXPERIENCE

Capgemini Private Limited Mumbai, INDIA

Operations and Maintenance Analyst Apr 2020 – Dec 2021

•Visualized sales trends in dashboards using Tableau and SQL

•Tracked KPI’s and provided useful insights by analyzing data of prior years to cut down the inventory management cost by 6% which saved $1,00,000

•Worked extensively on critical production issues on the below modules asset Management, procure to pay(P2P), supply chain management, workorder.

•Researched business strategies and provided recommendations on best practices and changes in technology

•Wrote automation scripts in Jython for asset management tool Maximo to avoid the class file changes

Junior Data Analyst Apr 2018 – Mar 2020

•Analyzed large sets of Sales Data using SQL, Tableau Prep, R and provided statistical approach which increased the sales by 3.5% in the year 2019

•Visualized data using Tableau, Power BI and Microsoft Excel.

•Coordinated with clients to identify application changes and provided technical business document to collaborate with software developers

•Managed technical performance expectations, supported and maintained project plan for technical work stream

•Advised to customers throughout the engagement of Deployed Changes in Application

PROJECTS

Air Quality Data Analysis Mar 2022

•Gathered and examined the data from the United States environmental protection agency website, to get insights and understand the key algebraic metrics and narrowed down the important ones, Designed SQL queries to generate business insight

Game Day Analytics Feb 2022

•Analyzed 3.4 million tweets of super bowl challenge ads and provided detailed insights which company ads were the most positively tweeted in the form of Visualization Using Tableau and R and presented to the Companies.

ACTIVITIES / INTERESTS

•Awarded Prizes for National level Technical symposium in paper and poster presentation

•President of Astronomy club in Undergrad college, organizer of College Cultural Activities and Campus Recreation Services

•Participated in 10K Run marathon organized by Capgemini on the agenda of “Run for your Health” in 2019.

•Participated in 8K Run marathon on the cause of “Run for a Girl Child”.

•I am a person with positive, helping attitude and always handles pressure situations with tranquility.

Contact this candidate