Sql Server Project

ANKITA DATE

******.****@*****.*** 801-***-**** https://www.linkedin.com/in/ankitadate

SUMMARY

Information Systems major with about 3 years of experience in business analysis, data analytics and software development

Experience working with SQL Server and Oracle Databases, Informatica, Tableau, AWS, R, Cognos Reports, JavaScript and ASP.NET

Quick learner, good communication skills, possess outstanding analytical and problem solving abilities EDUCATION

UNIVERSITY OF UTAH, DAVID ECCLES SCHOOL OF BUSINESS Salt Lake City, UT Master of Science in Information Systems (GPA: 3.82/4) December 2016

Received a Graduate Fellowship from the David Eccles School of Business

Member TEK Club - AIS Student Chapter, Utah Oracle Users Group and Utah SQL Server Group UNIVERSITY OF MUMBAI, SMT. INDIRA GANDHI COLLEGE OF ENGINEERING Mumbai, India Bachelor of Engineering in Electronics and Telecommunication (GPA: 3.7/4) May 2012

Vice-Chairperson of IGTEL (student forum of SIGCE, Electronics & Telecommunication Department)

Member of IETE (The Institute of Electronics and Telecommunication Engineers) from 2009 - 2011 TECHNICAL SKILLS

Database: MS SQL Server 2012 (T-SQL), Oracle SQL Developer, TOAD for Oracle, MySQL

Tools: Informatica PowerCenter 9.5, Tableau, SSIS, SSAS, SSRS, PowerBI, QlikView, AWS, Informatica Cloud, Pentaho, MS Excel, Cognos, Putty

Functional: Waterfall and Agile methodologies, Project Development, Prototyping, Entity Relationship diagrams, System Analysis

Programming: ASP.NET 3.5, ASP.NET MVC, R, JavaScript, HTML, CSS, JQuery, PHP, Shell Scripting EXPERIENCE

INTERMOUNTAIN HEALTHCARE West Valley, UT

Business Analyst Intern (May 2016 – Aug 2016)

Gathered requirements to improve project tracking process within the team. Worked with business unit to determine the issues and chalked out the possible solutions. Presented document outlining pros and cons of possible solutions to help with decision making

Created data model and tables in Oracle. Analyzed and transformed data from multiple sources (EDW cube and team’s project data from Oracle) to create reports and dashboards using Cognos to track current and in-progress projects and resource utilization SYNTEL LIMITED Mumbai, India

Software Engineer (Dec 2012 – Apr 2015)

Worked on a team servicing a U.S. based client in the health insurance provider industry

Gathered business requirements and created documentation to track project workflow

Built table structures, stored procedures and SQL queries using Oracle Database. Created ETL mappings and workflow to transform and migrate data to SalesForce via Oracle staging using Informatica PowerCenter 9.5, Informatica Cloud and SalesForce in Agile methodology

Designed an application using ASP.NET MVC, SQL Server and scripts in JavaScript and JQuery to generate project proposals, revenue reports, resource utilization reports, etc.

Created and executed test plan to track test cases, steps and results Designed and developed Right Price Application to automate creation of project proposal and revenue calculation for Finance Department

Developed ASP.NET pages, SQL Server tables, stored procedures, queries and views

Reduced efforts, improved efficiency by 60%, created technical documents to track project progress, and performed manual testing

Received Stretch Award (Syntel Values award) for outstanding performance and exceeding expectations ACADEMIC PROJECTS

Identified maturity level and issues faced by Utah State Office of Education, devised strategies and projections to help in improving graduation rates. Analyzed data using Tableau to investigate factors affecting graduation rates and provided recommendations

Examined the data for medical costs in relation to the cost of living across all the states in the US for determining variation in medical costs. Performed Regression and Clustering in R, and analysis using Tableau to determine factors affecting medical costs

Examined the data warehouse architecture and business model for Powder Ski Resorts. Performed testing and created reports on the Enterprise Data Warehouse using Power BI, and provided a comprehensive list of issues and recommendations

Created Page Classification app for Purch Group, Inc. to search and updates records in the database using PHP & AngularJS and integrated it with AWS. Built the database using AWS RDS for PostgreSQL. Performed requirement gathering, prototyping, project management and application testing. Provided training to the team by creating technical documentation and presentations to use and the manage project EXTRA-CURRICULAR

Completed trainings on Udemy for PowerBI, SSIS, SSRS, SSAS, QlikView and Oracle ERP Essentials

2 years in Bharatanatyam Training (Indian Traditional Dance form) from Indian Music & Dance Academy, Mumbai

Fluent in English, Marathi and Hindi

Contact this candidate