Resume

Sign in

Data Analyst Customer Service

Location:
East Rutherford, New Jersey, United States
Posted:
January 15, 2018

Contact this candidate

Resume:

Summary

*.*+ years of professional expertise in Data Analysis, Data modelling, Data Cleansing, Requirement gathering, Documentation and Reporting.

Expertise interacting with business users to understand their needs and translate them into Functional specifications.

Experience multiple flavors of SQL and optimization techniques.

Experience with Data Extraction, Transformation and Loading (ETL)

Functional Knowledge of Healthcare, Insurance and e-commerce Domains.

Technical Skills

BUSINESS INTELLIGENCE TOOLS

MICROSOFT BUSINESS INTELLIGENCE (SSIS, SSRS), TABLEAU, POWERBI, MS EXCEL, SHAREPOINT

DATABASE & NOSQL

MS SQL SERVER, ORACLE SQL DEVELOPER, MYSQL

WEB

JAVASCRIPT, HTML, CSS, XML

DEVELOPMENT & PROGRAMMING

PYTHON, R PROGRAMMING, JAVA

METHODOLOGIES

AGILE, INCREMENTAL AGILE, SCRUM, RUP, WATERFALL, SPIRAL, XP, RAPID PROTOTYPING

TOOLS

AXURE, MS- WORD, MS- PROJECT, MS- POWER POINT, MS- VISIO, UML, USE CASE DESIGN

Professional Experience

Essen Health Care, Bronx, New York - Data Analyst September 2017 - Present

Extracting and Integrating data from disparate sources (e.g. cost and claims).

Preparing monthly status reports, aid in corporate projects that deal with health care, compare medical budgeting to their prior analysis, and assist in customer service issues.

Identify, analyze and predict the return on the claims using Python.

Communicating results of analysis to management via reports/presentations and assist management in implementing programs that provide solutions.

Surat Fabric, India – BI/Data Analyst March 2014 - May 2015

Created a master database in SQL server using SSIS packages for extracting all previous sales data from MS Excel, flat file and loaded those data into destination tables in MS SQL Server 2012 for easy analysis for future business studies.

Created ad-hoc performance and ROI reports using SSRS for businesses by tracking and analyzing KPIs and provided insight based strategic recommendations.

Modified stored procedures, triggers, functions, indexes, tables, views and joins to implement business rules and to improve performance.

Interpreted customer data, analyze results using statistical techniques (Cluster analysis, Predictive modeling) and provide ongoing AvE reports to the senior executives.

New Jersey Institute of Technology, Newark – BI Analyst Feb 2016 – January 2017

Improved University database structure and maintained database integrity.

Used SSIS to build data integration and workflow solutions.

Translated vast amount of data from sources and complicated relationships into simple, yet valuable analytics.

Worked with several departments to solve their analytics and reporting requests.

Academic Projects

Sentiment Analysis on Donald J. Trump Political Campaign Spring 2017

Tweets related to the campaign across the United States were fetched by a R Package.

Cleansed and Analyzed the data using statistical analysis techniques in R programming.

Enterprise Database Management Fall 2016

Collected raw data from the EPA website and performed data modelling/data preparation.

Cleansed and created a database for over a million records using MS SQL Server 2012.

Normalized the data to 3NF to improve performance.

System Design & Analysis Spring 2016

Designed, developed, prototyped, tested and deployed a high-level model of a parking system that provides the user with GPS coordinates of the parking location.

Created Use Cases, SRS documentation, Design documentation and Architecture documentation for the system.

Navigation Application (DISHA) Fall 2015

Designed a navigation application using Dijkstra’s algorithm in Java.

Integrated the application with a MS SQL Server database to the store the location and route data.

Education

Master of Science, Information Systems May 2017

New Jersey Institute of Technology, Newark, NJ

Bachelor of Engineering, Computer Science May 2015

Jhulelal Institute of Technology, Nagpur University, India



Contact this candidate