Data Analyst Tableau
Resume:
Around *+ years of experience in Development, Implementation and Maintenance of Business Intelligence tools and applications. Passionate on building data driven products and provide simple digital experience for end users and bring analytics and performance to measure success.
• Successfully developed automated tableau reports, which eliminated 60% of manual reports.
• Resolved 30% problems related to data quality or inconsistencies.
• Identified possible sources for data population and promoted the use of shared data within a business area.
• Knowledge of designing and creating various analytical reports and Dashboards.
• Expertise in advanced analytics using sets, parameters, graphs, and charts.
• Experienced in data transformation, data mapping, data migration from source to target database schemas, data cleansing procedures.
• Drive big data and predictive analytics development.
• Involved in the preparation of Detailed Design Documentation.
• Flexibility to adapt to the availability and needs of business subject matter experts or lack thereof and still produce results/recommendations.
• Assisted the application teams with the data needs related to new releases or other changes and updated the data models as needed.
• Excellent problem-solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.
• Management experience in a customer service (Sales & Marketing) with handling chat, phone, and emails. EDUCATION/TRAININGS SKILLS & COMPETENCIES
MBA, Information & Technology (Alliant International University, 2016) B. TECH, Computer Science (Rajasthan Technical University, 2012) Oracle Expert SQL Certified.
SAP Student Recognition Award.
TECHNICAL SKILLS
SQL, Tableau, MySQL, MS Office, MS visuals, Active Directory, OBIEE, DBeaver, Alteryx, Service Now, Jira, Confluence, HiveQL, Teradata, Power BI, TIBCO, Oracle, Basic Python and R, PL/SQL Sr. Data Analyst
Client: Amway Corp. Apr ’18 – Jul ‘20
Responsibilities:
• Build custom SQL to support business requirement and production support for market research. Which helped to gain 18% of customer growth.
• Build analytical reports to support one or more functional areas (e.g., Market Research, Sales, Marketing, Legal, Finance, etc.).
Gaurav Patel
Sr. Data Analyst
Hard working professional who thrives in a fast-paced challenging work environment. Excellent skills in data analysis. Proven record of interacting successfully with customers and employees. History of completing assignments on-time within specified guidelines. ***************@*****.***
Phoenix, AZ
@Gaurav. Patel
SUMMARY
PROFESSIONAL EXPERIENCE
Data Analytics / Business Intelligence Alteryx
Goal Oriented Strategic Planning
Enterprise Analytics Tableau
Leadership
Data Science Team Player
SQL Business Oriented
HiveQL
Excel
Data Validation / Mapping
• Design & analyzes business data to support strategic and tactical decision-making, to assist in long-range business planning, to evaluate the effectiveness of different organizational initiatives, and to support effective, targeted communications.
• Identifies fact based best practices to further the development of solutions-oriented sales programs.
• Develop ad-hoc and recurring reports & analyses to assist in tracking various aspects of business performance.
• Develop technical ability in research methodologies, data analysis and data management approaches and techniques.
• Design technical specifications reports after Interaction with market research team and business analyst to analyze business needs.
• Resolve problems related to data quality or inconsistencies.
• Work on data validation and classification.
• Created Tableau Dashboards with interactive views, trends, and drill downs.
• Worked on loading data into Tableau from various data sources.
• Mastered the ability to design and deploy rich graphic visualizations.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Develop and visualize data reports using artifacts on global analysis for day to day business enhancement.
• Utilized tableau server for Building, publishing customized interactive reports and dashboards, report scheduling.
• Develop Alteryx workflow for data validation purpose connecting one or more data sources.
• Build automated tableau reports using Alteryx server by scheduling workflow on recurring day and time. Data Analyst
Client: State of Arizona Department of Child Safety Feb’17 – Mar ‘18 Responsibilities:
• Analyze data to identify missing, incomplete, or invalid information. Contact originators of source documents to resolves questions, inconsistency, or missing data.
• Assist in supporting multiple SQL server data repository, which may include documenting database architectures and analyzing datasets to identify missing, incomplete, or invalid information.
• Worked with ETL to create source to target mappings and performed validation for source to target mappings.
• Worked on development of various Tableau reports/ dashboards.
• Facilitate, conduct, and document data mapping session.
• Data profiling to come-up with strong data rules.
• Strong understanding of relational data structures, theories, principles, and practices.
• Migrate Database Services from on-premises to Azure Cloud Environments using SSMS, updating the connection strings, collaborate with development and QA teams to maintain high-quality deployment.
• Ability to find requirements by conducting interviews and facilitating/participation in data modeling sessions with business clients.
• Provide a standard design for the construction of data mapping documents and oversee their generation.
• Worked on Agile methodology for product development.
• Involved in sprint planning sessions and sizing the user stories in AGILE environment.
• Worked very closely with Product owners and Data SMEs to lay down solution for data driven products. Marketing Analyst
GVM Global Inc Sept ’16 – Jan ‘17
Responsibilities:
• Process and sort lead from various vendors and generate reports that analyze competition and customers.
• Communicate with stakeholders across global markets to understand revenue optimization and business performance related questions.
• Support strategic and operational initiatives to produce effective reporting and actionable insights.
• Maintain flow & process with sales team to close our tasks and opportunities.
• Analyze marketing metrics to identify cause and effect relationships.
• Managed clients' information and maintained relationship with old and new customers.
• Coordinate between database development and business teams such as Revenue Management and Supplier Optimization teams to align and enhance the understanding data and analytics capabilities.
• Strong engagement skills including communications, time management and prioritization skills.
• Ability to understand business processes and commercial implications to make strategic recommendations.
• Worked on development of various Tableau reports/ dashboards.
• Created Tableau Dashboards to visualize aggregated data and published on server. Helpdesk Assistant at IT department
Alliant International University Mar ‘15 – May ‘16 Responsibilities:
• Responsible to provide online, classroom base, student, faculty & staff support, and coordination.
• Work on Helpdesk related projects as assigned by supervisor.
• Verify that suggested solutions effectively resolve the users' problems through verbal or email follow up.
• Resolve Level 2 work orders. Elevate complex and/or high priority problems to the appropriate support groups for resolution.
• Effectively, professionally, and respectfully represent other Information Technology staff members, teams, and their services to the client community.
SQL/BI Developer
Red Spark Technologies, Baroda Mar ’13 – Jun ‘14
Responsibilities:
• Involved in pre-existing reporting system to update and modify based on end user requirement.
• Team member of the BI module and involved in analysis of business requirements, metric matrix, and dimensionality modelling.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Worked with the report development Manager and other team members on report requirements based on exiting reports/dashboards in Excel, timelines, testing, and technical delivery.
• Extracted and collected data to create needed reports.
• Validated accuracy of data to ensure database integrity.
• Managed customer expectations proactively to maintain high satisfaction.
• Developed various Charts and Graphs like Bar chart (Side by Side, Stacked), Line graphs, Pie -Charts etc.
• Developed Crosstab reports to provide detailed information to users. Reading Music Volleyball Driving Volunteer/Social Services INTERESTS
Contact this candidate