Data Analyst

RAMAPRASAD APPUSAMY

******************@*****.*** 469-***-**** https://www.linkedin.com/in/ramaprasadappusamy EDUCATION

Master of Science, Information Technology and Management GPA 3.7 / 4.0 University of Texas at Dallas, Texas August 2016

Courses completed: Advanced Business Intelligence, Business Data Warehousing, Data Management, Quantitative Introduction to Risk and Uncertainty in Business, Spreadsheet Modelling and Analysis of Algorithms Bachelor of Engineering, Computer Science and Engineering GPA 3.6 / 4.0 Anna University, India May 2012

TRAINING & CERTIFICATIONS

SAS Graduate Certification in Data Mining and Business Intelligence - University of Texas at Dallas

Cognizant Professional Certification in Microsoft SQL and Insurance Domain – Cognizant Technology Solutions

Python, Big Data and Data Mining techniques training - University of Texas at Dallas PROFESSIONAL EXPERIENCE

Workforce Insights Analyst Intern May 2016 – August 2016 Hewlett Packard Enterprise, Texas

Defined the problem and structured the data using Microsoft SQL Server Stored Procedures and Views

Resolved the uncertainty in data like outliers and missing values and used Quantitative and Statistical techniques in R studio to forecast employee attrition probability vs performance, salary, age, tenure, gender etc.

Analyzed data and synthesized raw data into insights, reports, dashboards and recommendations using Tableau

Prepared presentations and clearly communicated the findings and patterns to the Senior Leadership Team Business Analyst Intern September 2015 – April 2016 Real Time Resolutions Inc., Texas

Automated daily ETL tasks by scheduling SSIS packages which handles data conversions and transformations

Developed dynamic SSRS reports to generate daily transaction and pipeline reports for senior management

Created SQL Views, Stored Procedures to summarize and report the “fell through” and “drop off” amounts Business Intelligence Developer April 2013 – July 2014 Cognizant Technology Solutions, India

Created mappings using Informatica Designer and sessions using Workflow Manager to perform ETL tasks

Worked extensively on different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Rank, Lookup, Update Strategy, Stored Procedure, Sequence Generator and Joiner

Partnered with global cross functional and client teams to create Views using Teradata SQL Assistant Data Analyst August 2012 – February 2013

Adroit Techno Solutions, India

Developed business plans and models based on analysis of customer demographics and transactions dataset

Performed complex SQL query analysis including creation and maintenance of Microsoft SQL Server database for Business Intelligence purposes like Competitive Market Research, Pricing and Category Management etc.

Collaborated with a team of 8 members to complete the full life cycle development of the project including requirement gathering, process improvement, data conversion and analysis based on the business metrics TECHNICAL SKILLS

Databases: Microsoft SQL Server 2012, Teradata, MySQL, Oracle 11g, Vertica, MS Access Business and Reporting Tools: R Studio, SAS, Informatica, Business Objects, Tableau, SSRS, SSIS, Crystal Reports Other Tools: MS Visio, MS Excel 2013(VBA Macros, Pivot, VLOOKUP, Data Analysis, Solver) LEADERSHIP EXPERIENCE

Executive member and project member in various projects at ENACTUS UT Dallas Chapter

President of Computer Science Department at Kong Engineering College

Contact this candidate