Post Job Free

Resume

Sign in

SQL, Oracle, Advanced MS Excel (Pivot tables, VLOOKUP) SAS

Location:
Buffalo, NY
Salary:
$75,000
Posted:
April 24, 2019

Contact this candidate

Resume:

SAKSHI CHOUKSEY

ac868y@r.postjobfree.com www.linkedin.com/in/sakshichouksey1209/

*** ****** ********* *******, ** 14226 716-***-**** SUMMARY

Graduate student at University at Buffalo, School of Management, in MIS. Having with keen interest in data and analytics. Presently, actively seeking internship opportunity for summer, 2019, as a Data Analyst/ Business Analyst related roles. Well versed with SQL, Tableau and advanced analytics using Excel along with strong communication and client handling skills SKILLS AND CERTIFICATIONS

Analytics Tools: SQL, Oracle, Advanced MS Excel (Pivot tables, VLOOKUP, Analysis ToolPak, PowerPivot), MATLAB, SAS, Statistical Techniques: A/B Testing, Hypothesis Testing, Regressions, Decision Trees, Random Forests Business Intelligence Tools: Tableau, Google Analytics, Power BI Other Tools: Marvel Prototype Tool

Certification: Completed Oracle Database 12c: SQL Fundamentals, exam scheduled April 2019 WORK EXPERIENCE

Associate System Engineer

Pratibha Global Private Limited, Indore, India June 2017-May 2018

Fabricated project name Parkoye- designed for helping users to book parking spot using mobile application working both for corporate and non-corporate users

Collected, cleansed, analyzed and modeled customer’s data to drive major business initiatives and reduced project implementation timeline by 10%

Developed and implemented user-case strategies for project

Monitored first level support to system engineering processes EDUCATION

Master of Science in Management Information Systems, UNIVERSITY AT BUFFALO (GPA: 3.67/4.0) Sep 2019 RELEVANT COURSEWORK: Advanced Statistics, Data Visualization, Online Analysts Process Data Warehousing, Technology Innovation Management, Database Management Systems, Predictive Analytics, System Analysis & Design, Digital Marketing Analytics, Management of IT projects BACHELOR IN ELECTRICAL ENGINEERING, RAJIV GANDHI PRODYOGIKI VISHWAVIDYALAYA (GPA: 3.47/4.0) May 2017 RELAVANT COURSEWORK: Operating system, Engineering Economics, Microprocessors & Computers, Analog and Digital Communications, Reliability Engineering

RELEVANT PROJECTS

PREDICTION OF TICKET SALES FOR AN ICE-HOCKEY STADIUM IN BUFFALO, NY PYTHON TABLEAU Dec 2018 – Till Date

Gathered data from various departments and performed data analysis to understand ticket purchasing patterns

Built Tableau dashboards to visualize predictions on regular basis, helping analysts increase ticket sales by 15% ADHOC REPORT CREATION SQL Oct 2018 – Till Date

Extracted data using SQL from student information systems (SIS) to generate reports based on student demographics

Used advanced Excel capabilities such as pivot tables, VB macros, multilevel filtering to prepare data for reporting

Provided insights on student admission to program directors by building dashboards in Tableau and creating ad-hoc reports using SQL

HEART FAILURE INCIDENT AND MORTALITY ANALYSIS IN USA TABLEAU Aug 2018 – Sep 2018

Used Tableau Prep to perform data cleaning on various datasets extracted from Data.gov website

Identified factors affecting incident and mortality rates across all US 50 states

Created insightful user-centric dashboards; forecasted trends using Analytics Pane in Tableau ACHIEVEMENTS

Active member of SOM, ISACA and WIM clubs.

Participated at the national level swimming competition and awarded championship at the state level

Team head of swimming and volleyball teams



Contact this candidate