tableau developer / data analyst
PALAK PATEL (Tableau Developer/Data Analyst) ------------
------------/in/palak-patel-2517a588/ Contact:------------
Professional Summary:
? Around 3.5+years’ experience working in IT Industry with SQL developer and Tableau report services document delivery.
? Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
? Involved in full life cycle implementation, which includes Requirements Gathering, Development, Testing, Reporting, Go live and Reconciliation.
? Experience in using Tableau functionalities for creating different Requests, Filters, Chart, Interactive dashboards with Page and Dashboard Prompts.
? Strong Experience in Performing data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
? Created TableauScorecards, Dashboards, Heatmaps using show me functionality.
? Proficient in design and development of various Dashboards, reports utilizing Tableau Visualizations like DualAxis, BarGraphs, ScatterPlots, Pie-Charts, HeatMaps, BubbleCharts, TreeMaps, FunnelCharts, BoxPlots, WaterfallCharts, Geographic Visualization and other making use of actions, other local and Global filters per the end user requirement.
? Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculatedfields, Sets, Groups, Parameters etc., in Tableau.
? Experience with columnar database like AWS Redshift.
? Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau.
? Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps. Effectively used Data blending feature in Tableau.
? Good knowledge of data warehouse (DWH) Models, ETL process, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.
? Hands on installing, using and troubleshooting various software applications.
? Good knowledge on R, Python programming language, DBMS, RDBMS concepts.
? Worked with Different Databases like DB2, Teradata, Oracle, MicrosoftSQLServer, MicrosoftAccess databases, ExcelSpreadsheet etc.
? Able to work independently has a good interaction with team members.
? Good at understanding the client requirements and giving best solutions.
Education:
Masters in Information Technology and Analytics (The State University of New Jersey, Rutgers Business School) Dec 2018
Bachelor of Engineering in Electronics and Communication (Nirma University, Ahmedabad) July 2012
Technical Skills:
Programming Languages C, C++, SQL, QA, Oracle SQL, Linux, R, Python.
BI Tools BTableau Server, Toad, Tableau Desktop, Tableau Public, Tableau Reader, Tableau Prep, Power BI.
RDBMS/DBMS MS-Access, MS SQL SERVER, MYSQL, Teradata, DB2, Oracle
Database SQL Server, Oracle, OLTP, OLAP, MS SQL Server Enterprise, Manager, SQL Query Analyzer, Web Services.
Database Tools SQL Developer, SQL Plus, SQL Loader.
Methodologies Software Development Life Cycle, Agile, Waterfall, Snow Flake Schema.
Utility Packages MS-Office Suite, MS-Excel.
Operating System Windows Family, DOS, UNIX, Linux, Mac.
Coursework:
Data Analysis and Visualization (Tableau, Microsoft Excel), Business Database Management (MySQL), Business Application Programming (Python -NumPy, Panda), Marketing Research (SPSS), Business Forecasting (R studio), Analytics for Business Intelligence(R), Project Management, Information Security
Academic Project:
Predictive Analysis for Analyzing the Analyzer (Data Analysis and Visualization)–Use Machine Learning techniques like Logistic Regression, Support Vector Machine, Decision Tree to perform predictive analyst and generate report for visualization using Tableau. University career fair (Business Data Management)-Design and build a database system for the complete tracking of a University Career Fair. Design Relationship(ER) diagram, constraints supported by data model and perform different queries. (MySQL)
Nvidia Marketing Research for Autonomous Vehicles Chipset (Marketing Management)- Gather Data using different techniques and perform statistical analysis of Data (Microsoft Excel & SPSS)
Design IT strategy for Delta Airlines (IT strategy)- Study newsletters and current IT strategy use in Delta airlines. Find loop holes and design Strategy to overcome this issue.
Professional Experiences:
Data Intern, Paradyme Management, Greenbelt, MD Oct 2018- Dec 2018
? Designing and develop Tableau Reports, Documents, Dashboards and Scorecards for specified requirements and timelines.
? Developed various reports based on requirements.
? Experience on KPI (Key Performance Indicators).
? Prepared Dashboards using Calculations, Parameters in Tableau.
? Designed visualizations using Different Data views like barcharts, Trendlines, Cross-Tab, Scatter-plots and bulletgraphs.
? Created customized and interactive dashboards using data sources.
? Understanding the KPIs and Requirements Documents.
? Involved in creating dashboards by extracting data from different sources.
? Working with Tableau Desktop.
? Created dashboard using parameters, sets, groups, and calculations.
? Measure Value fields to create visualizations with multiple measures and dimensions.
? Involved in creating of data blending in case merging different sources.
? Involved in creating calculated fields, mapping, actions, and hierarchies.
? Publishing the dashboards on Tableau Servers.
Proctor, Rutgers University (Newark, NJ) Oct 2018 – Nov 2018
? Helping to professor in midterm and final exam and Assisting the lecturer to grade midterm exams.
? Grading weekly quizzes, homework, workshop problems at the direction of the lecturer, and keeping systematic records of the grades.
Business Generalist Intern, Esurgi (Baltimore, MD) Aug 2018 –Oct 2018
? Research and data gathering for appropriate site selection and pilot product demonstration.
? Cleaning up data based on client requirement.
? Spearheading pilot strategy, intellectual property protection.
? Assisting day to day business operations.
Data Analyst intern, Taken Mind (New York City, NY) June 2018 - July 2018
? Internship was primarily focused on financial Analysis and covered Python Fundamentals.
? Use Pandas for efficient Data Analysis, NumPy for high Speed Numerical Processing and data Manipulation and Analysis
? Use Matplotlib and Seaborn for Data Visualization.
Business Analyst, BoTree Technologies (Ahmedabad, India) Mar 2014 - Sep 2017
? Analyzed & interpreted data to Design & implement business strategies and managerial decisions.
? Assisted in implementing solutions to improve system efficiencies.
? Designed dashboards/scanned reports using Tableau/excle.
? Experience in data assessment/slicing using advanced Excel pivot tables.
? Worked on requirement gathering, source system analysis, designing functional & technical requirements for development team.
PALAK PATEL (Tableau Developer/Data Analyst) ------------
------------/in/palak-patel-2517a588/ Contact:------------
Professional Summary:
? Around 3.5+years’ experience working in IT Industry with SQL developer and Tableau report services document delivery.
? Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
? Involved in full life cycle implementation, which includes Requirements Gathering, Development, Testing, Reporting, Go live and Reconciliation.
? Experience in using Tableau functionalities for creating different Requests, Filters, Chart, Interactive dashboards with Page and Dashboard Prompts.
? Strong Experience in Performing data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
? Created TableauScorecards, Dashboards, Heatmaps using show me functionality.
? Proficient in design and development of various Dashboards, reports utilizing Tableau Visualizations like DualAxis, BarGraphs, ScatterPlots, Pie-Charts, HeatMaps, BubbleCharts, TreeMaps, FunnelCharts, BoxPlots, WaterfallCharts, Geographic Visualization and other making use of actions, other local and Global filters per the end user requirement.
? Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculatedfields, Sets, Groups, Parameters etc., in Tableau.
? Experience with columnar database like AWS Redshift.
? Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau.
? Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps. Effectively used Data blending feature in Tableau.
? Good knowledge of data warehouse (DWH) Models, ETL process, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.
? Hands on installing, using and troubleshooting various software applications.
? Good knowledge on R, Python programming language, DBMS, RDBMS concepts.
? Worked with Different Databases like DB2, Teradata, Oracle, MicrosoftSQLServer, MicrosoftAccess databases, ExcelSpreadsheet etc.
? Able to work independently has a good interaction with team members.
? Good at understanding the client requirements and giving best solutions.
Education:
Masters in Information Technology and Analytics (The State University of New Jersey, Rutgers Business School) Dec 2018
Bachelor of Engineering in Electronics and Communication (Nirma University, Ahmedabad) July 2012
Technical Skills:
Programming Languages C, C++, SQL, QA, Oracle SQL, Linux, R, Python.
BI Tools BTableau Server, Toad, Tableau Desktop, Tableau Public, Tableau Reader, Tableau Prep, Power BI.
RDBMS/DBMS MS-Access, MS SQL SERVER, MYSQL, Teradata, DB2, Oracle
Database SQL Server, Oracle, OLTP, OLAP, MS SQL Server Enterprise, Manager, SQL Query Analyzer, Web Services.
Database Tools SQL Developer, SQL Plus, SQL Loader.
Methodologies Software Development Life Cycle, Agile, Waterfall, Snow Flake Schema.
Utility Packages MS-Office Suite, MS-Excel.
Operating System Windows Family, DOS, UNIX, Linux, Mac.
Coursework:
Data Analysis and Visualization (Tableau, Microsoft Excel), Business Database Management (MySQL), Business Application Programming (Python -NumPy, Panda), Marketing Research (SPSS), Business Forecasting (R studio), Analytics for Business Intelligence(R), Project Management, Information Security
Academic Project:
Predictive Analysis for Analyzing the Analyzer (Data Analysis and Visualization)–Use Machine Learning techniques like Logistic Regression, Support Vector Machine, Decision Tree to perform predictive analyst and generate report for visualization using Tableau. University career fair (Business Data Management)-Design and build a database system for the complete tracking of a University Career Fair. Design Relationship(ER) diagram, constraints supported by data model and perform different queries. (MySQL)
Nvidia Marketing Research for Autonomous Vehicles Chipset (Marketing Management)- Gather Data using different techniques and perform statistical analysis of Data (Microsoft Excel & SPSS)
Design IT strategy for Delta Airlines (IT strategy)- Study newsletters and current IT strategy use in Delta airlines. Find loop holes and design Strategy to overcome this issue.
Professional Experiences:
Data Intern, Paradyme Management, Greenbelt, MD Oct 2018- Dec 2018
? Designing and develop Tableau Reports, Documents, Dashboards and Scorecards for specified requirements and timelines.
? Developed various reports based on requirements.
? Experience on KPI (Key Performance Indicators).
? Prepared Dashboards using Calculations, Parameters in Tableau.
? Designed visualizations using Different Data views like barcharts, Trendlines, Cross-Tab, Scatter-plots and bulletgraphs.
? Created customized and interactive dashboards using data sources.
? Understanding the KPIs and Requirements Documents.
? Involved in creating dashboards by extracting data from different sources.
? Working with Tableau Desktop.
? Created dashboard using parameters, sets, groups, and calculations.
? Measure Value fields to create visualizations with multiple measures and dimensions.
? Involved in creating of data blending in case merging different sources.
? Involved in creating calculated fields, mapping, actions, and hierarchies.
? Publishing the dashboards on Tableau Servers.
Proctor, Rutgers University (Newark, NJ) Oct 2018 – Nov 2018
? Helping to professor in midterm and final exam and Assisting the lecturer to grade midterm exams.
? Grading weekly quizzes, homework, workshop problems at the direction of the lecturer, and keeping systematic records of the grades.
Business Generalist Intern, Esurgi (Baltimore, MD) Aug 2018 –Oct 2018
? Research and data gathering for appropriate site selection and pilot product demonstration.
? Cleaning up data based on client requirement.
? Spearheading pilot strategy, intellectual property protection.
? Assisting day to day business operations.
Data Analyst intern, Taken Mind (New York City, NY) June 2018 - July 2018
? Internship was primarily focused on financial Analysis and covered Python Fundamentals.
? Use Pandas for efficient Data Analysis, NumPy for high Speed Numerical Processing and data Manipulation and Analysis
? Use Matplotlib and Seaborn for Data Visualization.
Business Analyst, BoTree Technologies (Ahmedabad, India) Mar 2014 - Sep 2017
? Analyzed & interpreted data to Design & implement business strategies and managerial decisions.
? Assisted in implementing solutions to improve system efficiencies.
? Designed dashboards/scanned reports using Tableau/excle.
? Experience in data assessment/slicing using advanced Excel pivot tables.
? Worked on requirement gathering, source system analysis, designing functional & technical requirements for development team.