Post Job Free

Resume

Sign in

Data Sql Server

Location:
New York, NY
Salary:
60000
Posted:
February 27, 2018

Contact this candidate

Resume:

NIMESH NANDISHWAR

201-***-**** ac4mv4@r.postjobfree.com

OBJECTIVE

Seeking a challenging Business Data Analyst position where my technical and communication skills will make a positive contribution to a corporation. I am keen to work independently and in a team environment to achieve project deliverables by successfully implementing contemporary business processes and system solutions.

CORE COMPETENCIES

Project Management, SDLC, Data Mining, User Experience Design, Data Analytics, Web Mining, System analysis and Design, Business Process Innovation, Finance.

SKILLS

Programing Language: RStudio, MySQL and Python

Reporting Tools: Tableau, Crystal Reports, Axure, ISM, Jira

Software Applications: MS Project, MS Office, PowerPoint, Advance Excel (Pivot, VLOOKUP), Citrix,

SAS-JMP, SAP ERP, Visio, MicroStrategy, AWS, SharePoint and Rapid miner. Java, mini tab, share point, visualization

EDUCATION

Master of Science in Information Systems specializing in Data analytics (GPA 3.8) May 2017

New Jersey Institute of Technology.

Bachelor of Engineering in Electronics and Communication Engineering (GPA 3.2) December 2013

Visveswaraya technological university

WORK EXPERIENCE

BUSINESS ANALYST at IBM

April 2014 - July2015

•Acted as primary resource for enterprise business analysis including the planning and scoping of data-driven strategies

•Pitched ideas to the management on Automation of simple issues with low resolution time based on the requirements gathered from the clients and stakeholders.

•Achieved alignment with teams by creating workflow diagrams, mock ups and holding SCRUM meetings.

•Create user cases based on the clients’(Bank Of Ireland) requirements and create RTMs, FRDs, BRDs using Agile methodologies.

•Managed the implementation cycle across the Development, QA and Support teams.

•KPIs indicated the incoming email of low resolution issues reduced by 20% due to the automation.

•Worked on the ISM(Jira) tool to create tickets and keep track of their progress with UAT testing.

•Identified a sub automation project to help the clients create their own tickets and tag it to the intended team.

•Created weekly reports using the Excel and analyzed it using pivot tables and VLOOKUP for employee efficiency.

•Used basic SQL queries to pull up data from the data dump and Tableau for daily reports creation.

•Trained new hires on the Business process and functionality of the systems.

ACADEMIC PROJECTS

Data Analytics (using Excel)

•We analyzed the cost, marketing expenditure and other target variables of an ecommerce company

and how it affected the sales. Tools used were Pivot tables and data analytics in Excel.

•We observed a delayed linear relationship between the marketing expenses and sales.

Web Mining using Rstudio (Prediction Model)

•Analyzed big datasets using R Studio to create models and predicted the results with high accuracy.

•The models were neural networks and regression models which was created after data cleansing.

•Predicted future occurrences of the target variable based on a linear relationship with some of the driver variables.

Data Analytics (using Tableau)

•Data visualization and analytics by building interactive dashboards using Tableau to analyze large data sets and make predictive analysis by drawing conclusions from the available data.

•The geographical dataset was analyzed by using decision trees and Tableau dashboard.

Systems Analysis and Design

•Created a complete design model for an app which fetches data from multiple websites and compares the products using Agile and Scrum methodologies, encompassing the System Development Life Cycle process.

•This included a detailed AS-IS and TO-BE modeling structure with user stories.

Project Management

•Constructed Work Breakdown Structure (WBS) using MS Project for a new summer resort.

•Identified the critical path for the project by constructing network schedule diagram, process flow diagrams and GANTT charts.

•Acted as the Scrum Master and used Agile methodologies.

Enterprise Database Management

•Imported dataset with 3+ million records into Microsoft SQL Server 2014 and performed data modelling, design processing, entities-relationship, normalization, building RDBMS server, fixing data using Data Manipulation Language, data visualization

• Microsoft SQL Server, SQL Server Management Studio, MS Visio

User Experience Design- Reputation Systems

•Personas, stakeholders and target demographics interviews, user scenarios, UX specs, claims analysis, storyboards, taxonomies, task flows, wireframes, prototypes, user acceptance testing, accessibility, interaction design, visual design and design patterns

•Know Axure RP Pro software tool and guidelines to design user interface and wire framing



Contact this candidate