Data Analyst Information Technology

Rohan Shah

551-***-**** ** Manhattan Avenue, Jersey City, NJ **************@*****.***

OBJECTIVE – 3+ years of Data Analyst experience in data visualization and developing valuable insights. EDUCATION

Stevens Institute of Technology Jan 2019-Dec 2020

Master of Science in Information Systems (Business Intelligence & Analytics) GPA 3.86/4 Hoboken, NJ University of Mumbai Aug 2015-May 2018

Bachelor of Engineering in Information Technology Mumbai, India SKILLS

Tools: Tableau, MS Power BI, Advanced Excel, MS Office, Google Analytics, Splunk, Mixpanel, Tableau, Metabase, Airflow Programming & Web Development: Python, C++ HTML5, CSS WORK EXPERIENCE

Data Analyst Verizon Branchburg, New Jersey June 2021 – Present

• Splunk & Tableau dashboards to establish reporting with multi-dimensional layers for high level summary to detailed widget information. Organize Models by root cause category, app, sub-team and predict the accuracy for root cause

•Built out the data and reporting infrastructure from the ground up using Tableau/PowerBI and SQL to provide real-time insights into the product, marketing funnels, and business KPIs. Design relevant ThoughtSpot artifacts (worksheets, searches and liveboards) that will help drive desired end-user experience.

• SQL scripting to mine data from various systems, create multi-table joins to grab the data needed for visualization and other analysis gaining a strong working knowledge of Verizon business application and processes.

• Developed and implemented Metabase dashboards to highlight key business metrics such as transaction volume and average processing time and as well to measure important KPIs.

• Involved in information gathering sessions to gather business requirement, data design requirements, preliminary logical data model and system changes into functional requirements

•Extracted complex fields from different types of log files using Regular Expressions for the end-to-end event monitoring infrastructure of business-aligned applications. Developed Splunk scripts to capture and analyze data alerts when the response time or traffic falls above or below expected limit.

• Developed & published reports and dashboards using PowerBI and written effective DAX formulas and expressions. Managed project plan, project completion, facilitating issues, maintaining control over scope & ensuring that project artifacts are maintained

• Identified data quality/data capture gaps & worked with source data system owners to extract the missing information

• Implemented efficient SQL queries to retrieve data for mission-critical insight generation & presented findings to executives. Identified potential risks to client data, services & providing recommendations on steps to remediate Data Analyst Crewasis New York March 2021 – August 2021

•Researched on big data/analytics projects that integrate large volumes of data from multiple source systems, performed analysis, interpret results, & recommended key insights to stakeholders.

• Aligned with Agile Methodologies, scrum stories, and sprints in a Python-based environment in association with data analytics and Excel data extracts.

• Worked with the BP&A team to develop & implement intuitive dashboards to provide insights about the user growth & consumption. Improved existing methods for analysis, persuaded senior management to adopt new methodology ACADEMIC PROJECTS

Credit card fraud detection Hoboken, NJ Jan. 2020 – Dec. 2020

• Detected significantly more fraud cases with significantly fewer false positives & false negative with 90% accuracy score

Analysis of jobs affected due to Automation on Twitter Hoboken, NJ March. 2019 – Dec 2020

• Constructed 3 k-mean clusters for no-risk, low-risk and high-risk, based on susceptibility of losing jobs in near future

VOLUNTEERING & LEADERSHIP

A team of 5-members raised donations for Hoboken Shelter, serving underprivileged with essential care in pandemic

Contact this candidate