Data Analyst Engineer

Nidhi Singh

Business Analyst

Long Island, NY ***61 *****.********@*****.*** 716-***-****

Summary

Over 1 year of experience as an Associate Business Analyst.

Performed a role as Business Analyst and Data Analyst with a strong knowledge of Software Development Life Cycle (SDLC)

Experience in conducting JAD sessions with various sponsors like stakeholder, product owner, external and internal users for requirement elicitation.

Expertise includes client interaction, requirement elicitation, coordination of the project deliverables, coordination with technical resources, conducting brainstorming sessions.

Experience in writing detailed Business Requirements Document (BRD), Functional Requirements Document (FRD) and Solutions Requirements Specifications (SRS).

Hands-on experience in creating Data Flow, Activity and Sequence Diagrams using MS Visio and iGrafx.

Experience in creating mock-up screens based on the BRD and FRD.

Facilitated working sessions with the business and other key stakeholders to examine the current process and prepare accurate and detailed process models such as “As Is” and “To Be” process maps.

Involved in writing SQL queries for data analysis.

Involved in the creation of UAT test plan, test cases and test strategy.

Experience in creating Pivot tables using MS Excel. Based on the pivot tables create charts on the dashboard.

Experience creating report and chart in Tableau.

Creating User Manual and FAQ documents for the end users and provide them training for using the application.

Additionally, great presentation skills in regards to communication with both business and technical teams.

Education

Masters in Information Systems – Pace University, NY, USA GPA 3.84/4 May2018

MBA - Amity University, Noida, India GPA 7.25/10 Jun2013

Professional Experience

Marine Products Export Development Authority, New York

July 2018 - Present

Data Analyst Intern

Responsibilities

Develop and maintain ETL processes utilizing SQL scripts, SSIS and other ETL engines (Power BI, Tableau)

Design, develop, and maintain reports & visually informative dashboards using data visualization tools e.g. Tableau, Power BI based on business requirements

Generate presentations on key findings as evidenced by the data and analyses performed

Write SQL queries to extract data, clean and analyze data in SQL Server Management Studio

Filter, sort, and classify extensive data into clear and concise categories using Tableau and excel tools, for e.g., pivot tables, VLOOKUP function and other complex functions and formulas

Analyze and produce ad-hoc reports

Praxis Solutions, Gurgaon, India

October2014 - July2015

Associate Business Analyst

The project was to evaluate the current process of developing and publishing policy/mortgage letter, and provide recommendations for efficient operation. After performing the assessment and providing the recommendations, we worked on the enhancement of their document management tool and application system. The project aimed to make these features more efficient and interactive for the end users.

Organized and managed the Business Process Reengineering (BPR) project under minimum supervision to implement an automated business workflow using SharePoint 2010 to improve the policy development process

Utilized six-sigma DMAIC methodology to assess existing workflow and options to resolve open issues and inefficiencies

Designed and reviewed various documents including the Business Requirement Documents (BRD), Functional Requirement Documents (FRD), Software Requirement Specifications (SRS), Use Case Specifications, SIPOC and related InfoPath electronic forms for Business Process Automation.

Created As-Is and To-Be process flow diagrams using visio and iGrafx and reviewed with business team to make sure the activities and their sequences are correctly captured and in right direction.

Coordinated among multiple technical, business, operational and testing teams on implementation of the projects

Conducted brain storm sessions to overhaul the existing platforms and change the methodology in the workflow of functionality

Reviewed Test Scripts and performed the testing to validate the changes for business

Utilized Use Cases and scripts to translate business requirements into product-specific designs and configuration

Communicated with the key stakeholders on the progress of the key projects and programs

Organized Joint Application Development (JAD) sessions, walkthroughs, and interviews sessions with end-users/clients/stake holders and the IT group to gather the requirements

Contact this candidate