Business Intelligence Tableau
Resume:
Hiral Patel
**************@*****.***
SUMMARY
SAS Base certified, over 7+ years of experience in IT industry with designing and development SQL Server database, analyzing, and management of Business Intelligence data warehouse.
Extensive experience with all phases of Software Development Life Cycle in different environments.
Capable to use Data Visualization tools like Tableau, Python, SAS to create visually powerful and actionable interactive reports and dashboards.
To creates effective Business Intelligence (BI) solutions and analytical dashboards / analytical tools for business users in Tableau.
Capability to build and publish customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server and good understanding of tableau architecture.
To create Tableau Scorecards, Dashboards using stack bars, bar graphs, scattered plots, geographical maps, line/pie graphs, and Gantt charts.
Design, Implement and Maintain ETL processes and integrating data from different sources.
Expertise creating different type of SSRS reports including Cross-tab, Conditional, Drill-down, Sub reports and parameterized and meta-data reports.
Capable to write SQL Queries, triggers, functions and store procedures for data validations and testing.
Extensive familiarity with PL/SQL, Oracle and MySQL database management.
Experienced in developing customized interactive reports and dashboards from multiple data sources.
Proficient in analyzing, Designing and Implementation of Software Quality Assurance and Business Analysis.
Experienced on Web-based, Client/Server applications conducted both Manual and Automated testing.
Capable writing User stories, creating Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams and extensively used MS Visio for UML.
Excellent expertise in writing Test Plans, Test Scenarios, Test Status Reports, Defect Metrics using test management and defect tracking systems such as HP Quality Center (ALM).
Quick learner, able to work well independently or as part of a professional computer program development team, capable to study new technologies and tricky concepts rapidly and utilize in a productive manner.
Self-Motivated and possess the ability for critical thinking, analysis, good interpersonal and communications skills, ability to work excellently as an individual and also as a proactive team member with minimum amount of supervision.
Member in the PHI THETA KAPPA Honors Society for the Computing and Information Disciplines.
TECHNICAL SKILLS
Languages
Java, Fundaments of Python, HTML, CSS, Visual Basic – VB.Net
Operating Systems
Windows 2000/XP, Vista 7/8, Windows 10
Databases
Microsoft SQL Server, MS Access 2003/2007/2013
MySQL, NoSQL, T SQL, PL/SQL
Tools /Application
Microsoft Office Suite(Excel, Word, Power Point)
QuickBooks Pro 2008/2010/2013, Point of Sale, Eclipse editor, MS Visio, UML, Office365, Microsoft Project, Visual Studio 2015/2010
ETL/ Reporting Tool:
Server Integration Service(SSIS), SQL Server Reporting Services (SSRS), Excel 2016/2013/2007, Tableau 9/10, Qlik Sense
Testing/ Tracking Tools
Selenium Web Driver, IDE, TestNG, Maven, QA, HP QC/ALM
Certification and Corporate Training
Tableau Desktop 10.3.2018 Training 2018, NJ
SAS Base certified – January 2018
Business Analyst Training, NJ
SQL Programming Training, NJ
QA & Software Automation & Manual Testing, NJ
HTML Programmer from Brain Bench
Quality Management Program from NIIT
Education
Associate degree in Applied Science, Computer and Information Systems (USA).
Honors Diploma in Systems Management from NIIT (India), Sep-1999.
Bachelor of Science Gujarat University (India), May-1997.
Professional Experience
PRODYGEE, NJ September 2017 - Present
Business Intelligence Developer
Intelli365 (Predictive Data Analytics System) is a software product which provides intelligent data analytic and solutions to customers helping them make various decisions which are based on the historical data. It uses algorithms to identify behavior of customer. It also helps to detect any abnormal events and prevents fraudulent and unauthorized activities. The software helps identifying, analyzing and interpreting trends/ patterns in complex data sets. Software provides a nice user interface to allow user to schedule data load, run analytic, allow user to define different rules and display dashboard for all loads and predictions for each data loads.
Responsibilities:
Gather and document project requirements and translated them into the functional and non-functional specification for BI reports and applications.
Participate in software development life cycle steps like requirements gathering, analysis, designing, and development using case tools data flow diagram system and program specification for business application need.
Design, develop, and deploy extraction, transformation and loading of data from multiple data sources.
Worked with database team to understand application, logical and physical data model.
Work to create, develop and deploy multiple Drill down, Drill through, Sub-report and Parameterized reports by using SQL Server Reporting Services (SSRS).
Involve in reviewing business requirements and analyzing data source from Oracle/SQL Server/Excel
Generate Tableau Dashboards with quick/context/global filters, parameters and calculated fields on Tableau reports.
To creates effective Business Intelligence (BI) solutions and analytical dashboards / analytical tools for business users in Tableau.
Capability to build and publish customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server.
To create Tableau Scorecards, Dashboards using stack bars, bar graphs, scattered plots, geographical maps, line/pie graphs, and Gantt charts.
Effectively utilizes features and Best Practices of Tableau and visual analytics to maximize impact and utility of visualization products.
Developed meaningful tableau dashboards with advanced data visualization, calculation, and user-friendly interactions to support decision making.
Provided Production support to Tableau users and wrote customized SQL query to support business requirements.
Reviewed documents with QA team, clarified any questions or issues, and presented to the project manager for approval and implementation.
Environment: SQL Server 2010/2012, Oracle 12c, SQL Server Management Studio (SSMS), SSIS, Visual Studio 2008/2010, Tableau 9/10, MS Office Suite 2013 (Excel/Word/PowerPoint)
Studied Computer and Information Systems (USA) 2013 – 2018
Middlesex County College (Edison, NJ)
Associate in Applied Science, Computer and Information Systems Cumulative GPA: 3.60/4.0
•Relevant Coursework: Data structures, Database Management System, Information Technology
•Honors: PHI THETA KAPPA Honors Society member
Mars Infotech Ltd, India June 2002- July 2004
SQL / Report developer
Worked as SQL / Report developer with the team of Developers, Designers, Business Analyst, and Testers to build large scale and enterprise level of applications and provide maintenance support.
Responsibilities:
Gathered and documented project requirements, get it from multiple data sources and created data sets and translated into the functional and non-functional documents, which used for BI reports and applications for analysis.
Participated software development life cycle steps like requirements gathering, analysis, designing, and development using case tools data flow diagram system and program specification for business application need.
Worked with database team to understand application, logical and physical data model.
Design, develop, and deploy extraction, transformation and loading of data from multiple data sources.
Created and implemented SQL Queries, Stored procedures, Functions, and Triggers in SQL server.
Worked to create, develop and deploy multiple Drill down, Drill through, Sub-report, Crystal and Parameterized reports by using SQL Server Reporting Services (SSRS).
Provided assistance and support to developing team members as required.
Environment: Windows, Oracle9i, MS SQL Server 2008, SQL Server Management Studio, SQL Server Reporting Service, Import/Export Wizard, MS office suite 2007.
Talent Infoway Ltd, India Feb 2000 – May 2002
SQL Developer
Worked as SQL developer with the team of Developers, Designers, Business Analyst, and Testers to build large scale and enterprise level of applications and provide maintenance support.
Responsibilities:
Gathered and documented project requirements, get it from multiple data sources and created data sets and translated into the functional and non-functional documents, which used for BI reports and applications for analysis.
Participated software development life cycle steps like requirements gathering, analysis, designing, and development using case tools data flow diagram system and program specification for business application need.
Worked with database team to understand application, logical and physical data model.
Design, develop, and deploy extraction, transformation and loading of data from multiple data sources.
Created and implemented SQL Queries, Stored procedures, Functions, and Triggers in SQL server.
Worked to create, develop and deploy multiple Drill down, Drill through, Sub-report, Crystal and Parameterized reports by using SQL Server Reporting Services (SSRS).
Provided assistance and support to developing team members as required.
Environment: Windows, Oracle9i, MS SQL Server 2008, SQL Server Management Studio, SQL Server Reporting Service, Import/Export Wizard, MS office suite 2007.
Contact this candidate