Data Information Technology

AARATHY RAVI

***********@*****.*** 734-***-**** 1427 Valley Lake Dr #606, IL 60195

OBJECTIVE

An ambitious graduate, seeking a Data Analyst full-time position in a challenging environment, where I can help organization to analyze business data with my technical and data analysis skills and add value to organizational goals. Skills and Qualifications summary:

1. Languages: SQL, PL-SQL, Java 6. Effective interpersonal and organizational skills 2. Analytical/Statistical Tools: SAS, R 7. Data Warehousing and Business Intelligence reporting 3. Database: Oracle, MySQL, MS Access 8. Proficient in MS Excel, Word, and PowerPoint 4. Tools: SQL Developer, MS Visio 9. Client interfacing and managerial skills 5. Framework: Hadoop 10. ERP: SAP R/3 4.7, SAP ECC 6.0, Web Dynpro, Reports, Smart Forms PROFESSIONAL EXPERIENCE

Enzen Technologies Pvt Ltd Jul 2012-Dec 2014

SAP Technical Consultant

Reviewed business requirements to develop initial technical design for new systems solutions

Sound knowledge in working with SAP ABAP, SAP upgrade projects

Experience working with SAP Cross-application concepts like BAPI, BADI, RFC

Extensive working knowledge of ABAP/4 workbench, Data Dictionary, classical and interactive reports using ALV, Smart Form, Dialog Programming

SAP Enhancements & User Exits like menu exits, field exits and screen exits are created upon client requirements.

Developed design of technical specification document, code designing with unit test document plan by coordinating with on-site team members

EDUCATION & TECHNICAL EXPERIENCE

Master of Science in Information Technology & Management, Specialization – Management Information Systems, Illinois Institute of Technology, Chicago – CGPA: 4.0/4.0 Dec 2016 Bachelor of Engineering in Electronics & Instrumentation Engineering, Anna University, Chennai – CGPA: 8.77/10 May 2012 Relevant Courses: Advanced Data Management, Object Oriented System Analysis and Design, Object Oriented Application Development Service Oriented Architecture, UML Based Software Development, Data Analytics, Hadoop RELEVANT ACADEMIC PROJECTS

Text Analytics Using R Dec 2016

Performed Analysis on the company P & G DEF 14 A filings to find the compensation trends using R

Performed Text Mining analysis by creating a Corpus and Term Document Matrix to find most frequently used words, generated graphs and word clouds. Identified Key Event Indicators which related to company’s performance and CEO salaries Tax Strategy in SAS – K- Means Clustering Oct 2016

Performed Cluster Analysis using SAS and Excel on Illinois property & income data set, to determine the best fit clusters and negate any outliers

Profiled the various clusters based on income, Property Value and several other profile variables. Created effective and up to date Tax increase strategies for the state of Illinois

Pot holes Analysis in Chicago Using MS-EXCEL Sep 2016

Leveraged pivot tables, Vlookup to analyze the historic data related to pothole repair combined with weather data (2011-2015) and calculated top budgeted amount, zip codes with maximum potholes filled Data Warehousing Case study – Rob & Coronel 8th Edition June 2016

Created a data warehouse design by analyzing the main facts and dimensions (using Visio) to keep track of the computer lab usage statistics of university students. Developed a star schema model to help analyze Charter data. Tutor Database Application Dec 2015

Developed a college Tutoring Database Application for a consulting firm ‘Clyburn Consulting’ using Oracle as the back-end and Microsoft Visual Studio Website as a front-end. Upon clicking, data would be retrieved from the database

Performed analysis using aggregate and average queries and generated various types of reports with charts and graphs to calculate top services offered to a student and to show the analysis in a presentable format CERTIFICATIONS:

Introduction to R (edx 6.1) Data camp

Contact this candidate