Shreya Patel
SHREYA PATEL
9494 Carroll Canyon Rd ,San Diego, CA- 92126 | ------------ | ------------
PROFESSION SUMMARY
? Data Analyst with experience in interpreting and analyzing data in a fast-paced environment.
? Proficient at discovering the hidden trends and patterns in huge amounts of data using Mining, Forecasting and Reporting.
? Experience in Data mining & Warehousing, Artificial Intelligence, Computer Architecture, storyboarding and preparing documents and
reports while managing complex data analysis responsibilities.
? Experience with various tools such as Python, SQL, Tableau, Excel.
EDUCATION
Alliant International University January 2018 - August 2019
Master of Science in Data Analytics
L. J. I. E. T Gujarat Technical University August 2013- June 2017
Bachelor of Engineering in Computer Engineering
TECHNICAL SKILLS
Programming and Database: Python (Pandas, NumPy, and SciPy), R, JAVA, C#, MySQL, Microsoft SQL server, SAS, SAP, Oracle.
Data Visualization: Tableau, QlikView, Power BI, Spark, IBM SPSS, Hive.
Advanced Excel: EXCEL (Pivot, VLOOKUP, HLOOKUP), Data Analysis, XL Miner, Solver, Charts and Graphs.
Analytical tools: MATLAB, GUI, Google Analytics, Google AdWords, Adobe Analytics, Social Media Analytics Platforms.
Methodologies: Waterfall, Agile, Scrum Master, Relational Database, Tech- Savvy.
Predictive Modelling Algorithms: Logistic Regression, Linear Regression, Decision Trees, K-Nearest Neighbors, Naive Bayes Classifier
Random Forests, Boosting, Support Vector Machines.
PROFESSIONAL EXPERIENCE
Alliant International University- San Diego, CA June 2018- Present
IT Technician Analyst
? Adept at Providing Designing and executing details thorough software tests & Computer Support.
? Skill in Systems Troubleshooting, Installations, and Maintenance of Numerous Software Packages, Microsoft Operating Systems &
Hardware’s.
? Perform diagnostics and troubleshooting of multiple issues, document help desk tickets/resolutions, and Administration, maintenance,
control and support of System Management servers at divisional and enterprise.
? Item maintenance by computer upgrades, hard drive upgrades, basic computer hardware, software upgrades (Weigh up to 50lbs).
? Provide technical assistance and support for incoming queries and issues related to computer systems, software, and hardware either in
person or over the phone.
? Administration, maintenance, control and support of System Management servers at divisional and enterprise level.
ACADEMIC PROJECTS
Edge Fish - San Diego, CA May 2019 – Present
Data Analyst, Volunteer Intern
? Performing data profiling and analyzing, applying various data cleansing rules, design data standards and architecture/ design the
relational models with SQL/ Excel.
? Projects through generating dashboards in Tableau & PowerBI to Understand end-to-end data flows, identifying data dependencies in
support of delivery, release, and change management.
Medical Drug Records Prediction Project January 2019- May2019
? Developed Interactive Dashboard by analyzing the data from American youth’s lifestyle abuse by determining data mining goals,
producing data mining project plan to clean and modify data using SQL, R programming, SPSS, Tableau Desktop and Excel.
? Identify, analyses, and interpret trends and patterns in transactional data set using data mining and sales forecasting using Python.
Car Dealership and Website Redesign Project June 2018- December 2018
? Defined milestones, determined project scope, time and cost using project management strategies by designing use case diagrams,
communication diagram, sequence diagram and GUI using Microsoft Visio and Argo UML. Gathered business requirements and
developed the project baseline and presentation using Microsoft Project and Microsoft PowerPoint.
? Developed ETL Packages for different requirements in MS SQL Server for integrating data from heterogeneous sources (Excel, CSV,
Text Format data) using SSIS.
Olympics data analyze Project January 2018- May 2018
? Developed a project for analyzing Past 10 Years on Olympic record. Analyzed data using Excel and created visualizations using
Tableau, the analysis helped to determine the performance of Player & Country and identify the most winning, defeating & loosing
player & Country.
Glaciers - Ahmedabad, India January 2017- May 2017
Data Administrator, Volunteer Intern
? Conducted statistical analysis to validate data interpretations using Python and R, as well as presented research findings, status reports
for data mining, data cleansing, data munging and machine learning.
? Developed the Stored Procedures, SQL Joins, SQL queries for data storage and retrieval, and exported the data into CSV, Excel files
into database for data extractions, data processing, and business needs.
SHREYA PATEL
9494 Carroll Canyon Rd ,San Diego, CA- 92126 | ------------ | ------------
PROFESSION SUMMARY
? Data Analyst with experience in interpreting and analyzing data in a fast-paced environment.
? Proficient at discovering the hidden trends and patterns in huge amounts of data using Mining, Forecasting and Reporting.
? Experience in Data mining & Warehousing, Artificial Intelligence, Computer Architecture, storyboarding and preparing documents and
reports while managing complex data analysis responsibilities.
? Experience with various tools such as Python, SQL, Tableau, Excel.
EDUCATION
Alliant International University January 2018 - August 2019
Master of Science in Data Analytics
L. J. I. E. T Gujarat Technical University August 2013- June 2017
Bachelor of Engineering in Computer Engineering
TECHNICAL SKILLS
Programming and Database: Python (Pandas, NumPy, and SciPy), R, JAVA, C#, MySQL, Microsoft SQL server, SAS, SAP, Oracle.
Data Visualization: Tableau, QlikView, Power BI, Spark, IBM SPSS, Hive.
Advanced Excel: EXCEL (Pivot, VLOOKUP, HLOOKUP), Data Analysis, XL Miner, Solver, Charts and Graphs.
Analytical tools: MATLAB, GUI, Google Analytics, Google AdWords, Adobe Analytics, Social Media Analytics Platforms.
Methodologies: Waterfall, Agile, Scrum Master, Relational Database, Tech- Savvy.
Predictive Modelling Algorithms: Logistic Regression, Linear Regression, Decision Trees, K-Nearest Neighbors, Naive Bayes Classifier
Random Forests, Boosting, Support Vector Machines.
PROFESSIONAL EXPERIENCE
Alliant International University- San Diego, CA June 2018- Present
IT Technician Analyst
? Adept at Providing Designing and executing details thorough software tests & Computer Support.
? Skill in Systems Troubleshooting, Installations, and Maintenance of Numerous Software Packages, Microsoft Operating Systems &
Hardware’s.
? Perform diagnostics and troubleshooting of multiple issues, document help desk tickets/resolutions, and Administration, maintenance,
control and support of System Management servers at divisional and enterprise.
? Item maintenance by computer upgrades, hard drive upgrades, basic computer hardware, software upgrades (Weigh up to 50lbs).
? Provide technical assistance and support for incoming queries and issues related to computer systems, software, and hardware either in
person or over the phone.
? Administration, maintenance, control and support of System Management servers at divisional and enterprise level.
ACADEMIC PROJECTS
Edge Fish - San Diego, CA May 2019 – Present
Data Analyst, Volunteer Intern
? Performing data profiling and analyzing, applying various data cleansing rules, design data standards and architecture/ design the
relational models with SQL/ Excel.
? Projects through generating dashboards in Tableau & PowerBI to Understand end-to-end data flows, identifying data dependencies in
support of delivery, release, and change management.
Medical Drug Records Prediction Project January 2019- May2019
? Developed Interactive Dashboard by analyzing the data from American youth’s lifestyle abuse by determining data mining goals,
producing data mining project plan to clean and modify data using SQL, R programming, SPSS, Tableau Desktop and Excel.
? Identify, analyses, and interpret trends and patterns in transactional data set using data mining and sales forecasting using Python.
Car Dealership and Website Redesign Project June 2018- December 2018
? Defined milestones, determined project scope, time and cost using project management strategies by designing use case diagrams,
communication diagram, sequence diagram and GUI using Microsoft Visio and Argo UML. Gathered business requirements and
developed the project baseline and presentation using Microsoft Project and Microsoft PowerPoint.
? Developed ETL Packages for different requirements in MS SQL Server for integrating data from heterogeneous sources (Excel, CSV,
Text Format data) using SSIS.
Olympics data analyze Project January 2018- May 2018
? Developed a project for analyzing Past 10 Years on Olympic record. Analyzed data using Excel and created visualizations using
Tableau, the analysis helped to determine the performance of Player & Country and identify the most winning, defeating & loosing
player & Country.
Glaciers - Ahmedabad, India January 2017- May 2017
Data Administrator, Volunteer Intern
? Conducted statistical analysis to validate data interpretations using Python and R, as well as presented research findings, status reports
for data mining, data cleansing, data munging and machine learning.
? Developed the Stored Procedures, SQL Joins, SQL queries for data storage and retrieval, and exported the data into CSV, Excel files
into database for data extractions, data processing, and business needs.