Data Information Technology

AISHWARYA RAVI

****************@*****.*** 312-***-**** 605 W Madison Street Apt #3303 Chicago IL 60661 OBJECTIVE

Seeking a full time position as Data Analyst in a challenging environment, where I can leverage my technical skills and work with a can- do attitude to achieve organization goals

Technical Skills and Qualifications summary:

1. Languages: SQL, PL-SQL, Java 5. Framework: Hadoop 2. Database: Oracle, MySQL, MS Access 6. Data Warehousing and Business Intelligence reporting 3. Analytical/Statistical Tools: SAS, R 7. Proficient in MS Excel, Word, and PowerPoint 4. Tools: SQL Developer, Toad, MS Visual Studio, MS Visio 8. Reporting Tools: SAP Business Objects, Tableau PROFESSIONAL EXPERIENCE

Cognizant Technology Solutions (A $12-billion Business Consulting and IT services Company) Jul 2012-Apr 2014 Programmer Analyst

Performed data analysis on transaction of actual cost funding data and processed the data for reporting

Developed complex Ad-Hoc reports in SAP Business Objects based on requests from business with less than 1% errors

Performed impact analysis on existing reports and reduced report refresh time from 10 minutes to 5 minutes by performance tuning the BO universe and reports

Liaised with clients to elicit functional requirements through brain-storming sessions and document analysis

Developed SQL queries to validate BO reports and ensured 100% match with database reports EDUCATION & TECHNICAL EXPERIENCE

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

Twitter Sentiment Analysis in R Nov 2016

Performed sentiment analysis to determine the sentiment score for each tweet from various cities posted by Donald Trump

Determined the mood associated with tweets and illustrated with trends and charts in Tableau Income Analysis in SAS - Regression Oct 2016

Performed linear regression to determine the most decisive predictor variables in predicting the income

Implemented Logistic regression, chi-square test to determine top 3 educational degrees, occupation that makes more than Illinois median income

Used various techniques like One-way ANOVA, BOX plots, Histograms to determine the strength of correlation and outliers Tax Strategy Analysis in SAS – K-Means Clustering Dec 2015

Analyzed and profiled complex data of residents of Chicago to perform cluster analysis and analyze property taxes paid by citizens

Performed data aggregation, data cleansing, cluster analysis, cluster profiling by importing raw data set in SAS

Identified key indicators to develop tax increase strategy for cluster groups and determined a workable tax increase of 20% from previous year

Pothole Analysis in Chicago using MS Excel Dec 2015

Leveraged pivot tables to summarize and find patterns in data and determine the budget spent on pothole repair, time spent to repair, zip codes with maximum potholes and average response time based on weather Movie Production Database May 2015

Developed a Movie Production Database Application using Oracle as the back-end and Microsoft Visual Studio Website as a front- end in which connections were established to MS Access and Oracle. Upon clicking, data would be retrieved from the database

Performed analysis using aggregate and average queries and generated various types of reports such as movie budget, scene cost in SQL Developer

CERTIFICATIONS:

Introduction to R(edx 6.1) Datacamp

Exploring BASE SAS 9 Programmer certification

Contact this candidate