Data Analyst

Summary:

Dynamic professional with almost * years of experience as Business Systems Analyst in all phases of the SDLC; analysis, design, development, testing, implementation, documentation and user training. Certified in Data Science with knowledge of data analysis, data mining techniques, statistical and machine learning methods. Passionate and value driven with strategic mindset that focuses on problem solving task and maintaining priorities on strict deadline.

Highlights:

Data Analysis, Business Analysis, Advance Excel, Data Mining, Data Preparation, Machine Learning, Statistics, Predictive analytics, Data Visualization, Data Warehousing, Data Modeling, Business Process and Improvement, Business Intelligence, Big data, Data Management, Python Programing, Project Management, SDLC, CRISP-DM, Agile and Waterfall.

Professional Experiences:

Mercury Insurance Services, Brea, CA: Business Systems Analyst 11/2017- 7/2019

Involved in identifying business needs, requirements gathering, writing FRDs, technical specification and mapping documents to support development teams for the Enterprise Data Warehouse (EDW)/Business Intelligence and Reporting Team.

Analyzed and collaborated with Data Modelers and DBAs in designing and building dimensional data models and data profiling from different application sources in EDW.

Designed, developed and maintained business process documentation, data dictionary, reporting formats and KPIs related to each business process and user reports.

Experience in designing, creating and delivering data reports, metrics and visualizations in MicroStrategy and Tableau for various insurance reports used by the analytics team.

Experience in writing SQL queries for data analysis and reporting in the multiple databases such as Netezza, Oracle, SQL Server and DB2.

Performed root cause analysis of ETL code (in Informatica) to quickly identify data quality issues as part of maintenance project/ETL projects.

Expert in defect analysis/documentations and used Mercury Quality Center to log and track defects as a part of maintenance efforts for EDW project.

Created ad-hoc reports in MicroStrategy and SQL for reporting, testing and validation.

Experience in data analysis and visualization using Advance Excel, Tableau, MicroStrategy and Power BI.

Performed UAT and provided training and support to the business users from analytics, marketing and finance teams for the inquiries with quick analysis.

Expertise in using Microsoft office suite and Visio for business process and improvements.

Experience working with IT internal team to ensure feasibility of user requirements.

Experience working with QA in writing test cases/plans and execution.

Experience in Advance Excel concepts used for data analytics.

Experience in Agile, Waterfall methodologies using ALM/ Quality Center, JIRA, SharePoint and Smartsheet application for project management and SDLC tracking.

Good Understanding of industry best practices, governance and change management.

A good team player with excellent analytical, interpersonal, communication skills, and a fast learner

Change Healthcare, Nashville, TN: Business Analyst 12/2016- 8/ 2017 (Contract)

Served as a liaison between the business and IT department by conducting daily calls/meetings with stakeholders, developers, QA Team, and UAT Team to document changes and apply them to tableau reports for senior management.

Gathered requirements, wrote functional requirements and maintained Tableau functional reports based on user requirements.

Analyzed data to identify and create key business components and performance Indicators (KPI) in Tableau.

Used Advance Excel for data analysis.

Involved in extensive data profiling and data analysis activities.

Experienced in writing test plans, test cases, maintaining test scripts as well as reviewing and approving test cases prepared by QA members based on the use case.

Performed UAT meetings with different business units.

CVS Health, Woonsocket, RI: Business Analyst Associate 1/2016- 10/ 2016 (Contract)

Involved in data migration project to migrate 12,000 lease information from SLIM environment to Tririga Application Environment.

Conducted requirements gathering and business analysis to understand business strategy for data migration project.

Establish and maintain liaison relationship with business users and IT in order to provide effective functional requirements.

Extensively used Microsoft Excel for data analysis.

Supported development teams, QA teams through requirements document and technical specification documents and supported business users for UAT and implementation.

Conducted data analysis to maintain data quality using SQL server.

Education

Master of Business Administration/Project Management (06/2015)

Cambridge College School of Management, Cambridge, MA

Bachelor of Science in Media and Technology (06/2011)

University of Massachusetts, Boston, MA

Certification and Licenses

Data Science Certificate Program (4/2020), University of California, Irvine

Power BI Certification (4/2020), 365 Data Science

Skills

BI Tools: MicroStrategy, Tableau, Power BI, Business Objects

Database: Netezza, DB2, Microsoft SQL Server Management Studio, Microsoft Access, Amazon Redshift, Oracle.

Programming Language: Python

Data mining tools: Knime

Other Tools: Quality Center/ALM, DB Visualizer, Informatica, Hadoop, Microsoft Office and Advance Excel.

Dikshyant Rajbhandari

Business Systems Analyst

*********.************@*****.*** Phone- 617-***-****

References and Recommendations in LinkedIn Profile LinkedIn URL

Contact this candidate