Database Engineer/Developer

Mansi Deo

* ******* ******, *** **, Salem NH ****9 603-***-**** ***.*@*****.***.***

GOAL

Experienced Database Developer seeking a position in the data pipeline with a career goal of working in Data Analytics and Business Intelligence.

SKILLS

Databases: Oracle 10g/11g/12c, MSSQL 2008-2012, PostgreSQL, MySQL, Cassandra BI Tools: Tableau, Qlik, PowerBI, SQL Server Reporting Services (SSRS) Data Integration Tools: Talend, SQL Server Integration Services (SSIS) Languages: SQL, PLSQL, Java, Python, R, C, UNIX, HTML, T-SQL, CQL Big Data Technologies: Apache Hadoop (MapReduce, HDFS), AWS Data Analytics: Clustering, Classification

Cloud Technology: Microsoft Azure

Other Software Tools: Visual Studio 2008-2015, OTM, Oracle Apex, QC, JIRA, SVN, NetBeans, Toad, Eclipse, IntelliJ EDUCATION

Masters of Science, Information Systems: Northeastern University, Boston, MA Dec 2016 Relevant Courses: Application Engineering & Development, Engineering of Big Data Systems, Data Warehousing and Business Intelligence, Business Analysis, Program Structure and Algorithms, Web Development Tools and Methods Bachelor of Science, Electronics & Telecommunication Engineering: Nagpur University, Nagpur, India June 2009 PROFESSIONAL EXPERIENCE

Software Engineering Intern: DEKA Research and Development, Manchester NH May 2015-Dec 2015

Elicited requirements from various non-technical teams, Designed and Developed an application for a formulary in Oracle Apex 4.2

Automated Reporting for data and code analysis using Toad

Automated unit testing using UTPLSQL and improved the Code Coverage to 100%

Implemented Advanced Oracle Security - Transparent Data Encryption (TDE), Network Security (TCPS), Oracle Key Store

Designed and developed Oracle DB 12c Multitenant Architecture and managed all aspects of database including Database Administration for enterprise cloud-based medical device software product Senior Software Engineer: Tech Mahindra Limited, Pune, India Apr 2010-Jan 2014

Automated various business processes by implementing Oracle Transportation Management 6.1 (OTM 6.1) while consulting with various international clients

Developed codes to configure complex automation algorithms, packages, functions and stored procedures using SQL and PL/SQL

Analyzed production data to identify the root cause of issues and provided solutions to the defects in code/configuration, and significantly reduced production issues

Designed and generated ad-hoc and scheduled reports using Oracle BI Publisher

Led query tuning and optimization exercises to improve performance of the system running on high data volumes; also managed master data in various OTM environments

ACADEMIC PROJECTS

Contoso Data warehousing and Business Intelligence Project Northeastern University, Boston MA Fall 2016 Designed the Database Model, performed Data Integration to load data into the Data-warehouse from various sources (DB Servers, Excel/CSV/txt files) using Talend and SSIS. Performed ETL while monitoring and enhancing the performance. Created interactive dashboards and provided valuable BI reports using Tableau, Qlik Sense and PowerBI. UK Crime Data Analysis Northeastern University, Boston MA Spring 2016 Analyzed the dataset using Python, Hadoop and AWS to get a holistic picture of the state of crime in UK. Performed Machine learning (Clustering) using Microsoft Azure to assist people to gauge the character of a specific area by projecting it on maps using Google fusion tables.

Medical Device Inventory Northeastern University, Boston MA Fall 2014 Autonomously designed and implemented an inventory system to ensure effective management of shared medical devices for a network of Hospitals using JAVA. Along with the essential features, the application also included data analysis using BI techniques to provide action ready information.

Contact this candidate