Neha Banthia

Cell: 201-***-**** ac8jim@r.postjobfree.com https://www.linkedin.com/in/neharakeshb/

Summary

Proficient with SQL. Experience working with MySQL and MSSQL to populate, clean, retrieve and join information in large data sets.

Programming proficiency in Python and Java.

Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical.

Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse using Microsoft SSIS and Herme Tech.

Highly analytical, motivated and persistent. Also, quick and eager to learn new technologies.

Punctual, level-headed, and highly organized.

Good personal and written communication, independent and a team player.

Work Experience

Ammon Labs Dec 2017 – Nov 2018

Database Programmer

Worked on building the database for the company in order to use the raw data for analytics and reporting and for media value using HC1

Analyzed the raw data, provided insights and created reports on top drugs used in every state for the benefit of government and state police monthly reports which helped in reducing the drug usage in every state

Initiated in cleaning the raw data from Comtron using SQL, Excel and utilized the unused 20 years of data for creating results for Ammon Index

Worked on the healthcare data, conversion of HL7 format to the readable format for sales team, accounting and analytics team

Worked on the migration of 20 years of Company’s historical data into company’s database MySQL Sever from the legacy software

Integra Technologies May 2017 – Dec 2017

Data Analyst

Used SAS and SQL data query tools to build, test, evaluate, and maintain robust data analysis and MIS reporting for management to make timely, informed decisions

Queried multiple relational databases using MS SQL Server; regularly joining disparate data sets together to form the basis for testing an analytical hypothesis

Developed SQL SSIS Packages to extract data from various data sources such as Excel and flat files into SQL server 2005 using different transformations like derived column, sort, and aggregate transformations.

Interpret data, analyze results using statistical techniques and provide ongoing reports using Informatics desktop and server

Mcintyre Group March 2017 – April 2017

Data Analyst

Analyzing data, cleaning it, extracting and processing it and transforming the data as per company’s requirement

Collaborated with business process owners and other project teams and provided technical support to configure and manage SAP profiles and roles to meet the business needs

Created monthly performance report summarizing response time, performance and statistics for sales team, marketing team and manager which helped them to increase the sales by 17%

Provided data related insights that drove changes in client’s response time, delays and resolved cost issues

Acquire data from primary or secondary data sources and maintain databases/data systems

Egen Solutions Sep 2016 – Feb 2017

Software Developer

Involved in developing the platform and building market features such as global components that are used across the organization

Worked with developers to correct issues with current applications and resolved ticket issues for our clients in JIRA

Created technical documentation to help on-boarding/existing developers for effective software delivery.

Actively involved in all aspects of Application lifecycle management following Agile-Scrum Methodology to produce high Quality Application

Poetic Justice Films and Entertainment April 2014 – Aug 2014 Data Analyst

Analyzed social media and website KPIs within weekly, monthly, quarterly, and ad hoc reports. Draw insights to aid in creating data-driven business strategies

Created optimized data reporting processes using Microsoft Excel resulting in multiple hours saved per week

Monitored key search and display conversion metrics for different markets for clients utilizing custom dashboard widgets

Work closely with management to prioritize business and information needs

Eastern Software Systems Nov 2013 – April 2014

Software/SQL Developer

Experienced with Software Development Life cycle as a PL/SQL Developer, which includes Analysis, Development, Implementation and testing

Provided functional support and customization to the client on ERP as per client’s process cycle and requirements

Analyzed functional specification and use cases and created release and required documents.

Monitored data for accuracy for clients; responsible for loading, extracting and validation of data prior to reporting; reduced reporting failures by 30%

Created database schemas, tables, views, stored procedures, alter tables and columns, table indexes, data cleaning.

Education

New York Institute of Technology, NY: M.S. in Computer Science (GPA 3.9/4.0) Sep 2014 - May 2016

University of Mumbai, India: Bachelor of Engineering (B.E.) in Computer Science (GPA 3.33/4.0) Aug 2009 – Jun 2013

Technical Skills

Languages: SQL, R, PL/SQL, SAS, Java, HTML, CSS, JavaScript, Spring(Core, MVC & Rest API), Hibernate, AngularJS, Ajax

Reporting BI Tools: Tableau, MS-Excel, MS-Visio, HC1, Infogram, Salesforce

Tools: R Studio, SAS 9.4, Eclipse, MySQL, Webstorm, TOAD, Tableau, Informatica, SAP ECC6, JIRA, AWS, Comtron, Orchard

Database: MySQL, MSSQL, Oracle

Projects

Movieflix (A website designed similar like Netflix with using some of its functionalities)

Designed and implemented a website where a user can login, signup, search movies and series and browse according to genre

Developed functionality to select top rated movies and top rated series based on IMDB ratings and a functionality to select latest movies and series

Developed UI using AngularJS, JavaScript, HTML5, CSS3, AJAX, Bootstrap and Spring, Hibernate, RestAPI in Java and MySQL to store and query data

Women Fertility Guide

Designed and implemented a website to educate masses on the subject of fertility. Through website, we aim to assist women, address their pregnancy related questions and concerns

Implemented Login/Sign up and Q&A module of this website

Developed UI using HTML, JavaScript, AngularJS and RestAPI in Java and MySQL used to store and query data

IP Multimedia Subsystem (MS Project: Computer Networks)

Designed and developed a network to test performance under different scenarios using OPNET.

Implemented the network with optimum performance.

Demonstrated Denial of Service (DoS) by adding malicious node attacking network using ping attack.

Leadership Experience

Appointed as tutoring manager for undergraduates – NYIT

Awarded merit-based scholarship of $6000 every year at NYIT, based on academic achievements

Member of National Service Scheme, Committee member of tech fest event Zephyr, India

Contact this candidate