Data Social Media
Resume:
Shweta Patel
551-***-**** ********@*******.***
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