Data mining

Tommy Gonzalez-Age **.**** Calvin Street Owings Mills MD 21117

adryaj@r.postjobfree.com

Cell-443-***-****

**** ****** ****** ****** ***** MD 21117

Data Mining

Tommy Gonzalez-Age 26.

4121 Calvin Street Owings Mills MD 21117

adryaj@r.postjobfree.com

Cell-443-***-****

Highly skilled business acumen with an experience in analytics and business intelligence needed to guide decisions. Extensive experience in Data visualization, Data analyst, Data reporting, Datawarehousing, and Data modeling. Experience with SDLC implementation, Agile and Scrum methodology, Quality Assurance coupled with strong client handling skills. Adept knowledge of DataAnalysis, skilled in python; created dashboards, reports and analysis gave me confidence to deliver my abilities and talent into the real world.

My passion for business intelligence and data analytics enabled me to gain a strong understanding of problem-solving, process improvement, client interaction and communication skills. All of which I leverage to solve complex business problems for the organization.

Technical Expertise:

ETL/Business Intelligence Tools: Qlikview, Tableau, SAP Business Objects (BI 4.0), SAP BO Dashboard, Microsoft BI Tools (SSIS, SSAS, SSRS), Periscope, Microsoft Visio

Database: Oracle, MySQL, MS SQL Server, SAP HANA, MS Access

Programming: SQL, R, Python, C, Hadoop, Hive, Pig

Libraries: Pandas, NumPy, Plotly, SciPy, Matplotlib, ggplot2, pymysql, urllib2, psycopg2

Other Software/Tools: MS Office, IBM Bluemix, IBM Watson, AWS, Microsoft Azure, WEKA

Authorized to work in the US for any employer

Work Experience

Data Analyst

MountainTop Data

-

Woodland Hills, CA

June 2019 to Present

• Requirement gathering and data collection from various social media platforms.

• Developed a custom application to capture the rawhtml of any given URL in python.

• Use AWS instance to run the application across various Virtual machines.

• Implement parser to extract massive data from rawhtml into MySQL.

• If data available in csv, text, excel format we use ETL tools to transform the data.

• Create dashboards to deliver status of projects.

• Perform query optimization to make optimum use of the resources.

• Perform data mining on social media profiles using R/python based on project requirements.

Graduate Assistant

California State University

-

Los Angeles, CA

April 2018 to January 2019

• Assisted students and professor in maintenance of database for management students.

• Performed maintenance activities in an online database by creating item records, making corrections based on error reports, and keeping statistics.

• Helped professor in maintaining the students grade files by creating macros in the excel sheet.

• Managed and maintained online Portals for Professors.

Business Data Analyst

Cross-Tab Marketing Services Pvt. Ltd

-

Mumbai, Maharashtra

June 2016 to June 2017

• Analyzed massive data using SQL, MS Excel & R to monitor the success rate of surveys.

• Helped clients to get insights from their data.

• Handled clients in both technology & healthcare sector.

• Clean, transform and convert data using R or python depending upon the data provided by the client.

• Importing & Exporting of data from multiple source like text, CSV, HTML, XML

• Designing and planning BI solutions.

• Writing relational and multidimensional database queries.

• Recommended a new method to share the analysis report and to track survey progress using Tableau.

• Creating Dashboards & visualization for the insights.

• The idea of delivering reports in form of dashboard & proper graphs was appreciated by my seniors and clients.

• Used Python, JavaScript snippets to retrieve information.

• Optimized digital marketing campaigns for Instagram.

• Conducted market research and prepared analytical reports.

Data Analyst Intern

Techinfoplace Softwares PVT. LTD.

-

Gujarat, India

April 2015 to March 2016

• Created SSIS Packages to integrate data coming from Text files and Excel files.

• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.

• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.

• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.

• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.

• Created SSIS/DTS packages to copy tables, schema and views and to extract data from Excel and Oracle.

Tutor

Gujarat Technological University

-

Gujarat, India

April 2014 to April 2015

• Working as a tutor my basic duties were to deliver the topics related to SDLC & Database to juniors.

• These were after college lectures, meant specifically for students who were working on any projects and had difficulty to solve them.

• Provided individual mentoring & suggested changes to the project related to SDLC.

• This job help me not only achieve confidence to speak and express my ideas in public but also lead to gain adept knowledge in database.

Education

Master's in Information Systems

California State University

-

Los Angeles, CA

2017 to 2019

BE in Computer Engineering in Computer Engineering

Gujarat Technological University

-

Gujarat, India

2013 to 2017

Skills

Data Analysis (3 years), Big Data (3 years), SAP Implementation (1 year), Project Management (2 years), Business Analysis (3 years), SDLC (2 years), Research (3 years), Supply Chain Management (3 years), Pivot Tables (4 years), Data Mining (2 years), Tableau (3 years), Microsoft Office (5 years),Python (3 years), SAP ERP (2 years), powerBI (3 years), R (2 years), MapReduce (2 years), Hadoop (2 years), Cascading Style Sheets (CSS) (2 years), HTML, Javascript, Microsoft SQL Server (2 years),QlikView (1 year), Pandas (Software) (3 years), SAP BusinessObjects, IBM Watson, IBM Bluemix,Periscope Data (2 years), Oracle Database, Blockchain (2 years), C/C++, IBM Cloud, Problem Solving,Teamwork, Critical Thinking, ERP Implementations, ERP Implementation Project Management, Hive,Apache Pig, Apache Spark, SAP HANA, KPI Dashboards, Scorecard, ETL Tools, Business Intelligence Tools, MySQL (2 years)

Links

https://www.linkedin.com/in/jeeljoshi

Awards

Graduate Student & Faculty Mentor Recognition Reception

2019-04

• The Decision Sciences Institute (DSI) hold annual meetings for people from the world of dataanalytics to interact with current researchers, industry experts and fellow enthusiasts. they invited me to present it at their annual meeting, scheduled to be held at Chicago Illinois (USA).

• THE OFFICE OF GRADUATE STUDIES awarded me for Travel & Professional Development Grant for the same.

TDS Monitoring usin RO - Poster Presentation

2016-11

• This was our final year project poster presentation. Internet of things based project contains system of interrelated computing devices that are provided with unique identifiers (IP and PORT) and the ability to transfer data (Arduino Controller) over a network (ESP8266 WIFI) without requiring human-to- human or human-to-computer interaction.

• We have published research paper on “TDS Monitoring Using IoT" on Volume 4 Issue 11, November 2016 in International Journal of Scientific Engineering and Research (IJSER).

Publications

Study Of TDS Monitoring Using IoT

https://www.ijser.in/archives/v4i11/IJSER151106.pdf

2016-11

• ESP8266 WIFI is used for self-contained system on chip with integrated TCP/IP protocol stack that give any microcontroller access to Wi-Fi network.

• Keywords- TDS METER, ESP8266 WIFI, Arduino Controller, IntelliJ IDEA Software, Arduino Controller Software

Additional Information

Technical Expertise:

ETL/Business Intelligence Tools: Qlikview, Tableau, SAP Business Objects (BI 4.0), SAP BO Dashboard, Microsoft BI Tools (SSIS, SSAS, SSRS), Periscope, Microsoft Visio

Database: Oracle, MySQL, MS SQL Server, SAP HANA, MS Access

Programming: SQL, R, Python, C, Hadoop, Hive, Pig

Libraries: Pandas, NumPy, Plotly, SciPy, Matplotlib, ggplot2, pymysql, urllib2, psycopg2

Other Software/Tools: MS Office, IBM Bluemix, IBM Watson, AWS, Microsoft Azure, WEKA

Contact this candidate