Engineer Data

NEHA RAINA

Queens, NY ***** 929-***-**** ***********@*****.*** www.linkedin.com/in/neha-raina

EDUCATION

Pace University, Seidenberg School of CSIS New York, NY May 2018

Masters of Science (M.S.) in Information Systems GPA: 3.6

Recipient of International Graduate Student Scholarship Award

Nagpur University, Maharashtra, India June 2011

Bachelor of Engineering (B.E.) in Information Technology

TECHNICAL SKILLS

Languages MySQL, T-SQL, NoSQL, PHP

Data Analytics Tableau, SSRS, SSIS, Excel, Rapid Miner, SAS, Power BI

Database IDE Oracle SQL Developer, SSMS, MySQL Workbench

Test Management Tool Quality Centre (QC), Selenium IDE

Bug Tracking Tool Bugzilla, JIRA

ACADEMIC PROJECTS

Data Mining (Rapid Miner) May 2017

Generated a model using linear regression algorithm that allowed users to input various house features like sales price, bedroom, year built etc and the observation was to predict the price of the house.

Data Visualization (Tableau and Power BI) May 2017

Created dashboard for Golf Stats dataset using Tableau and Power BI to present data in the form of pie charts, bar graphs, scatter plots .

PROFESSIONAL EXPERIENCE

Capgemini May 2015 – Oct 2016

Database / Business Intelligence (BI) Analyst

Analyzed business requirements for a CRM system for TalkTalk Telecom Group to systematically create test scenarios/cases, perform unit testing and verify the functionality of the application.

Developed and maintained several data intensive ETL (Extract, Transform and Load) processes using SSIS and SAS.

Created analytical dashboards consisting multiple charts and graphs using Tableau for decision making and analysis.

Designed complex SQL queries for an online sales portal that allowed customers to place an order for TalkTalk brand to test its functionality and performance.

Extracted data from Oracle database into tabular format in Excel which was further used to carry out regression and functional testing of CRM that supported various front office functions.

Implemented Agile methodology and SDLC with JIRA systems to test complete application within sprint deadlines.

Cyient Limited Sept 2013 – April 2015

GIS Data Engineer

Created and debugged complex ETL processes for Arc GIS databases using functions and stored procedures which improved the speed of application.

Updated tables, views, worked on triggers, OLTP and coordinated between development and testing teams to ensure all defects are closed on time.

Assisted direct clients and stakeholders with analytics, data modeling, visualization and error management.

Analyzed, queried and manipulated GIS data according to defined business rules and procedures.

Determined root cause for data quality errors and made recommendations for long-term solution.

Created monthly reports using SSRS that helped managers to analyze the number of test cases fixed over time.

Infotech Enterprises Limited Mar 2012 – Sept 2013

Jr GIS Data Engineer

Understanding the Business requirement and Functional Specification documents to create use cases/workflow using Microsoft Visio.

Domain expert for Esri software, administer ArcGIS Servers, manage licenses, develop organizational best practices.

Prepared High-Level Design and Low-Level Design based on Functional and Business requirement documents of the project.

Responsible to run performance testing procedures to ensure the proper operations of the system.

Debugged Arc GIS databases and developed schemas, tables if required.

Build data management dashboards, web mapping applications, data models, and analytics tools for client projects and firm eminence.

Contact this candidate