GOWTHAM MALLIKARJUNA

ac1e6b@r.postjobfree.com linkedin.com/in/gowtham-m 918-***-****

3+ years of experience in Relational Databases, Business Analyst and Object Oriented Programming Proficient in creating User-friendly dashboards and reports understandable by non-technical audience Proven ability to collect, organize, analyze and extract useful insights from data using quantitative data mining techniques EDUCATION

Master’s in Management Information Systems - Oklahoma State University May 2017 TECHNICAL SKILLS

Data analytics Python, Tableau, R, SAS, MS Excel Pivot table, Vlookup, power pivot, Macros, VBA, SSRS, Teradata Programming & database PL/SQL, T-SQL, HTML, Oracle 11g, SQL Server, MySQL, PostgreSQL, MS Access, Mongo DB, Shell Scripting Project management & OS Microsoft Office Suite, Visio, Agile and Waterfall SDLC Models, Windows, Linux Certifications SAS Certified Base Programmer for SAS 9, SAS Statistical Business Analysis: Regression and Modeling Portfolio public.tableau.com/profile/gowtham.mallikarjuna#!/vizhome/Profile_10/Portfolio PROFESSIONAL EXPERIENCE

Information Systems Intern Oklahoma State University Data Analysis and Reporting Oct 2016 – May 2017

Responsible for database management, data quality assurance and provide data-driven business intelligence solutions

Improved ease of data access by acquiring, cleaning and structuring data from multiple disparate sources

Saved 60 hours of weekly reporting and ETL tasks by automation using python scripting

Generated KPIs for actionable business improvement recommendations using tableau dashboards

Analyzed Email Campaign Performance indicators like click rates and response rates to measure project success

Built classification algorithms to predict likelihood of recipient responding to campaigning mail

Evaluated new initiatives by interacting with business stakeholders and documented process improvements

Created SQL Queries to extract data from SQL Server Database for ad hoc request from stakeholders Software Engineer Analyst Accenture Database Development and Data analysis Oct 2012 - July 2015

Implemented operational database for CRM applications on multiple telecom projects

Created over 60 SQL Queries, Stored Procedures, Views, Triggers for data retrieval and database validation

Achieved 20% decrease in application response time by SQL query tuning and code optimization

Resolved 70% of database related issues during post production support with aggressive service-level agreements

Prepared the data for analysis by inspecting, cleansing, transforming and evaluated the data anomalies and outliers

Generated reports for ad hoc requests using SAS BASE programming / SAS Macros

Assisted in marketing analytics like customer churn modeling, building product recommendation engine and A/B testing.

Experienced with Data flow diagrams, use cases, Database normalizations and entity relationship modeling

Served as liaison between various IT teams to analyze business requirements and provide technical solutions

Managed code deployment and version control in Git repository for change requests and bug fixes

Implemented backend logic in PL SQL to parse XML service request received from external systems

Mentored 4 of new resources in the project and provided technical and functional Knowledge Transfer

Performed extensive work for validation and correction of data using advanced Excel concepts like Pivot tables, Macros and VBA ACADEMIC PROJECTS

Summarization of Amazon Product Reviews Tools: Python, Mongo DB

Built text mining algorithm to generate concise summary of large data sets of amazon product reviews using NLP

Performed sentiment analysis to segregate positive and negative review points

Extracted key words and phrases by n-gram analysis using python to reduce 70% of decision time Instacart Market Basket Analysis Tools: Python, R

Performed Market Basket Analysis using Instacart Open Source Data to understand customer purchase behavior

Built exploratory graphs using python Matplotlib and association rules using Apriori algorithms in R Statistical package

Developed product recommendation algorithm using collaborative filtering to suggest new products for existing customers. Analysis of Energy Consumption Patterns and production by solar panels Tools: Tableau, SQL, R

Performed statistical analysis using ANOVA to find any significant inconsistencies in electricity production in solar panels

Located clusters of inactive meters and high consumption connections by data visualization

Assessed and reported key influencing factors for energy consumption for different substations and connection types WEB LINKS

github.com/gowtham91m public.tableau.com/profile/gowtham.mallikarjuna#!/ AWARDS AND RECOGNIZATIOSN

Received Rising Star award for my outstanding contribution in data engineering at Accenture

Contact this candidate