Email id – firstname.lastname@example.org LinkedIn: https://www.linkedin.com/in/DhavalMetre007
Business Analyst with professional 3.5 years of experience in business analysis, data analysis & data visualization.
Profound knowledge of requirement gathering, creating functional documents like use case, business flow charts, test scripts.
Extensive knowledge of creating automated dashboards using Tableau, SQL, Data Warehousing, ETL, BI Systems.
Extensive experience in Software Development Life Cycle (SDLC) and Agile – SCRUM Project Management Process.
Analytical Skills: Tableau(certified), Power BI, ETL - SSIS, SSRS, SQL, Advanced Excel, Google Analytics, Crystal Reports, SAS
Management Tools – JIRA, MS Project, HP ALM
Languages: Python, R, C, HTML, Java, VBA
Databases: MySQL, Oracle, MSSQL, Teradata, Access
Management Skills: Agile – SCRUM Project Management, PDLC (Project Development life cycle)
Office Software: MS – Visio, Word, Office, Outlook, Access, PowerPoint.
Professional Work Experience:
Data Analyst – Student Assistant University of Texas at Arlington [January 2018 – May 2018]
Collected student’s data, ensured data quality, preformed data cleaning and data wrangling.
Performed analysis & research regarding student’s performance with respect to different demographics & departments and helped UTA administration to design & implement career development programs.
Designed functional Dashboards using Tableau for reporting and ran SQL queries for data retrieving.
Data Analyst Silver Touch Technologies Inc [June 2015 - March 2016]
Gathered data from multiple data sources & munged the data. Used Power Pivot, V lookup and Macros for data interpretation.
Implemented trend analysis and forecasting on real-time data by using Tableau and apply in business solutions.
Tracked KPI’s like conversion rate, bounce rate, number of customers visiting webpages using Google analytics.
Created tables, views, SQL joins, complex queries and statements for data analysis & reporting.
Achieved 7% increase in sales by conducting market basket analysis using Tableau and providing recommendations.
Business Analyst Cyber Q Consulting Pvt Ltd [June 2013 - May 2015]
Participated in JAD sessions to gather requirements for development of Web and Android mobile applications.
Translated business requirements into various functional documentation – FRD, Use Cases, flowcharts, sequence diagrams etc.
Retrieved Data using complex SQL queries like Joins, Views for preparing reports.
Performed GAP analysis to compare the existing system with the proposed system. Perform Root Cause Analysis.
Functioned as the primary liaison between the client and the technical team and resolved process issues throughout the project cycle. Conduct training sessions for clients to prepare them to use the system.
Prepared the test plan and test scenarios. Executed functional test cases and validated it as per SRS document.
Performed functional testing-Black Box, smoke, sanity, system, regression, ad-hoc, user acceptance testing (UAT).
Saved Cost & time by identifying critical bugs at early stage of software development. Tracked defects using JIRA tool.
Master of Science in Information Systems at University of Texas, Arlington [May 2018]
Bachelor of Engineering in Electronics and Telecommunications, Nagpur University, India [June 2013]
Analysis & Design Project: Information System for a non-profit organization [Spring 2018]
Created SRS document after analyzing functional, non-functional and feasibility requirements
Analyzed the requirements & created Used cases, Activity and Sequence diagram using Microsoft Visio.
Project Management: Conveyor Belt Project [Fall 2017]
Create project scope statement. Used MS project to create WBS, assign resources, identify slack and project status.
Created a baseline budge calculating the risk and its impact. Generated quarterly status report & a closure plan for the project
Data Science: Sentiment Analysis and Topic Modelling for Twitter Data Using Python [Spring 2017]
• Used Twitter API to collect live tweets, and sentiment analysis was conducted.
• Created word clouds and Genism and NMF were used to perform topic modelling of the collected tweets