Shweta Patel

**** ****** ***

Apt*, NJ *****

551-***-**** ac8a8o@r.postjobfree.com

OBJECTIVE

Experienced technology enthusiast with structured approach to problem solving looking for spring internship/full time roles

SUMMARY

Worked as a Data Analyst in Race Academy, working with multiple database to record and report student admission data.

SQL Server and My SQL certified professional with expertise in writing complex queries along with data extraction and cleaning.

Advanced Microsoft Excel for Data Analysis certified professional with proficiency in handling huge amount of data and mining crucial and relevant data using advanced techniques like VLOOKUP, HLOOKUP, Pivot Table and Macros.

Performed analysis of Digital traffic to make improvements in sales, engagement strategies, and marketing tactics.

Highly proficient in MS Access, SharePoint, PowerPoint, Microsoft Project and database tools such as SQL Server Management Studio (SSMS), MySQL Workbench and Visual Studio 2017 including the ability to analyze, summarize and manipulate large volumes of data.

Strong analytical skills with the ability to collect, organize, analyze and disseminate significant amount of information with attention to detail and accuracy.

EXPERIENCE

Race Academy, India June 2015-May 2017

Data Analyst

Developed and maintained historical student and school data files to monitor and track performance.

Interpreted and reviewed assessment data with administrators and teachers and Ensured the validity of all data presented to staff using advanced MS Excel functions

Created data visuals using Excel Charts (Line, Pie & Bar charts).

Maintained weekly school Dashboard to track progress by using various data sources like Google Analytics, Google AdWords, including surveys, activity logs, and quantitative data reports.

Used social media to better understand our industry and identify new opportunities.

Maintained SQL scripts, indexes and complex queries for data analysis and extraction.

Created custom reports, writing stored procedures and optimizing custom reporting tools for MS SQL Server databases.

Developed reporting services at institutional platform for the academy delivering high performance monitoring of candidate assessment resulting in program enhancements enabled by optimized reporting

Created data visuals using advanced Excel functions (Line, Pie & bar charts) for stakeholder requirements with structured prioritization model and implemented CRM in RDBMS by sourcing data through various data points

Created, implemented and enhanced stored procedures by optimizing with indexing and scheduling for real time and batch-based processes in reporting services used by stakeholders for forecasting student performance and trends

Implemented front end technologies like HTML 5, CSS and PHP for dashboard creation

Performed data scraping on social media platform to analyze trends and innovate new business ventures

Managed dashboard on a weekly basis for the academy by using data sources like Google Analytics, Google AdWords, including surveys, activity logs and quantitative data reports

EDUCATION

Stevens Institute of Technology - Hoboken, NJ Expected Graduation: May 2019

Master of Science in Information System GPA: 3.7

University of Houston – Clear Lake – Houston, TX Master of Science in Management Information Systems Attended from: August 2017- Dec 2017

Awarded with MIS Graduate Merit Scholarship.

Rungta College of Engineering and Technology – Raipur, India Graduation: May 2015

Bachelor of Engineering, Electronics and Telecommunication GPA: 7.73/10

Coursework: Financial Decision Making, Data and Knowledge Management, Organizational behavior and design, Project Management and Fundamentals, Data Warehousing/Business Intelligence, Fundamentals of Computer Networking, Internet Application and Development

ACADEMIC PROJECTS

Angular 2 Complete E-Commerce App

A full stack development project, we developed the code for both front-end and backend

Developed the front-end code using Angular 2, HTML, CSS, TypeScript, bootstrap

Developed and maintained a fully running small-scale project for online shopping system with secured payment gateways

Implemented SQL queries for database design and maintenance

Data Management Information System for Insurance Company

The project is focused on Insurance Management System, which shows information about different parts of insurance company, such as Agent, Customer, Policy, Employee, Claim Handling and other related concepts.

The objective of the project here, is to implement a database management system, such that, it uses the different tables to evaluate the performance of Insurance company

SKILLS

Data Visualization: Tableau

Technical Languages: MS SQL, MySQL, JavaScript

Digital Media Tools: Google Analytics, Google Tag Manager, AdWords manager, Facebook Business Manager

Office Application: Microsoft Word Excel, PowerPoint, Access, Microsoft project, Visual Basic

Software Suites: Responsys, Google Analytics, AdWords, Photoshop, Adobe creative suite

ACTIVITIES

Student Diversity, Equity and Inclusion, University of Houston—Clear Lake Fall 2017

Arranged events, workshops and programs for Student welcoming

Participated in Cultural awareness and involvement

Actively worked as a team of 4 students to create a website for managing the various events to be held. Implemented SQL queries for database design and maintenance

Languages: Fluent in English, Hindi, and Gujarati

Contact this candidate