Data Sql Server

ANKITA DUTTA https://www.linkedin.com/in/ankita-dutta-878524145/

551-***-**** 623 Harrison Avenue Harrison, NJ-07029 *****@****.*** EDUCATION

New Jersey Institute of Technology (NJIT), Newark, NJ Masters of Science, Information System, GPA: 3.7/4.0 May 2018 Coursework: Data Analysis, Enterprise database Management, Introduction of Statistics using R and SAS, Web Mining, Management Of Technology, User Experience and Design, Business Process Innovation Jadavpur University, India

Masters of Business Administration May 2015

Megnand Saha Institute of Technology, India

Bachelors of Technology, Computer Science May 2011 SKILLS:

Programming Language: R, SQL, C, Python (basics)

Tools/Environment/OS: Windows, R Studio, MS Excel (Pivot Tables, Functions, Macros), MS Power-point, MS Word, MS Access, Tableau, SAP Lumira, Axure RP, Rapid Miner, SAS, MongoDB, MS SQL SERVER, PostgreSQL, Eclipse IDE, SSIS, SSRS Package. ONLINE CERTIFICATION(Udemy): Agile Project Management, The Complete SQL Bootcamp PROFESSIONAL EXPERIENCE:

Analyst Intern, M.L.G Construction, India January 2015- February 2016

• Participated in requirement gathering meetings and process reviews

• Created a payroll management system of employees using Excel, VBA and maintained the payroll system

• Aggregated data on Excel and removed discrepancies of data and visualized data using various operations MS EXCEL like Pivot Table.

• Studied and analyzed the current system and depicted AS-IS and TO-BE models using BPMN diagrams on VISIO, performed gap analysis on processes and systems to identify alternate solutions to business problems. Technology Intern, Indian Oil Corporation, India May 2014-December 2014

• Removed data discrepancies by addressing missing, duplicate and redundant data in Excel.

• Created visualization using Excel, documented all findings and created a recommendation on it PROJECT EXPERIENECE

Redesigning of dataset of National Emission Inventory to Normalized Form using Microsoft SQL Server, SSIS and SSRS

• Analyzing raw dataset, importing and cleaning the dataset using SSIS and SSRS package, redesigning new model for the dataset to normalized form, implementation of new model.

• Creating reports on environmental pollutant’s emission data from new model using SSRS package. And achieved performance tuning by indexing the key attributes of respective tables Geek Genie Course: User Experience & Design

• Identified and collected data on various problems faced by graduate students of NJIT by communicating with them.

• Built an system app in Axure RP for students called “Geek Genie“ where students can get information about college/University ratings, best professors, best courses and can also connect with the alumni, professors and fellow students through this platform.

Toxic Release Data Inventory Course: Enterprise Database Management

• Cleaned and normalized data using MS SQL SERVER, developed a STAR schema to create aggregations Natural Language Processing Course: Web Mining

• Identified the connection between the languages of the reviews using NLP

• Evaluated the accuracy of the model using various classification algorithm of machine learning in Python Market Basket Optimization using Eclat and Apriori Algorithm Course: Data Analytics

• Preprocessed data and generated all association rules from frequent itemset to optimize the revenue of the store by finding appropriate arrangement of the store using R

• Compared the results of both algorithms and find out the best pair of frequently bought itemset to optimize the sales of store. Improvement of Delivery System of Miracas.com Course: Business Process Innovation

• Examined the whole process, identified various risk factors and designed BPMN, AS-IS, TO-BE and GAP Model diagrams and Work Systems Snapshots to improve the efficiency of the delivery systems, Worked in the Agile environment.

Contact this candidate