Himanshu Patel
Mobile: 805-***-****, Email: ******@*****.***
Headline
Adaptable Data Analyst skilled in recording, interpreting and analyzing data in a fast-paced environment. Advanced proficiency in all aspects of Excel, MySQL and various tools. Experienced in relational DBMS, MySQL, SQL Server and performance tuning.
Highest Degree
California Lutheran University Thousand Oaks, CA May 2017
Master’s in Information System Technology GPA: 3.67
Course Work: Data Management, Data Analytics, Management Concept of I.T, Distributed Systems, Fundamental of Web Development, Project Management, Big Data
Professional Experience
LeadFerret, Inc: Woodland Hills, California (October 2016 – May 2017) Data Engineer
Responsibilities:
Part of a team extracting, processing, parsing, normalizing, indexing, and storing raw HTML data into a usable format using MySQL.
Achieving structured data from raw data by creating MySQL functions, Parsers (parse raw data) and stored procedures.
SSH cluster using putty and other actions using Linux commands.
Keeping the Management of Database.
Graduate Assistant: California Lutheran University, California (March 2016 – November 2016)
Responsibilities:
Assisting and collaborating with the California Lutheran University’s Dean and an assigned supervisor to perform and complete the task.
Scheduling and planning the student course registration processes.
This included developing code using JavaScript in Adobe Acrobat Professional, maintaining its integrity and security.
Technical Skills
Languages/Platforms
MySQL, SQL Server, R, Hadoop, Hive, Pig, C, C++, Java, JavaScript, HTML5, CSS3, WordPress
Desktop & Server Applications
Microsoft Office ( Advanced Excel, PowerPoint, Word, Visio), Ubuntu, Linux
Tools
Tableau, M.S Access, QlikSense, HDFS, Eclipse, SSRS, SSIS, Crystal Reports, Visual Studio
Academic Projects
Big Data Analysis: (May 2017)
This is the overview of the project where I used Amazon Reviews of Electronics section. In this project, the main objective was to implement various Big Data patterns on the dataset. It was implemented in Hadoop, Java, and Tableau for graphical virtualization. Hive and Pig were also used for further analysis on the data.
Data Analytics (January 2017)
The motto of the project was to identify the patterns in the dataset to find the reason of data appears in dataset. The further requirement was to perform the required data cleaning, processing and then visualization of the datasets using QlikSense &R.
Project Management (August 2016)
In this project, we have to manage the project of a building dome with Gold LEEDS certification by applying Project Management documentation. It involves documentation like Business Case, Project Charter, WBS, Gantt chart, etc. The tools used were Microsoft Project, Microsoft Word and PowerPoint.
Data Management(August 2016)
Database development using Microsoft Visio and Microsoft SQL Server 2014. The project was developed using the phases of database life cycle (DBLC) i.e. conceptual design, logical design (ERD and Relational diagram), and physical design and implementation phases.
Developed a Website using HTML5 and CSS3(January 2016)
The website created was for a fictitious pizza company named “Pizza Palace”. It was responsive website using just HTML5 and CSS3.
Areas of Expertise
Web development (HTML5,CSS3,WordPress)
Data Management(MySQL, SQL Server, SQL Elite)
Data Analysis(Excel, QlikSense, Tableau)
Competencies
Adaptable to any work environment.
A vivid learner with proven analytical and practical skills, motivated and goal-oriented.
Problem solver and excellent communication skills.