PRIYANKA M

ac8bwd@r.postjobfree.com 732-***-****

https://www.linkedin.com/in/priyanka-mishra-79347aaa/ SUMMARY

Experienced in designing and developing Use Cases, Activity Diagrams, Sequence Diagrams, and project reporting using Visio, assessing business processes and requirements.

Equipped with strong analytical and problem solving skills; keen to details, flexible, accountable and an advocate for creating a team atmosphere.

Excellent communication, presentation and interpersonal skills with the ability to work with employees at all levels of the organization.

Experience in writing SQL queries in oracle database. EDUCATION

Master of Science in Management Information Systems Fairleigh Dickinson University, Teaneck, NJ

Bachelor of Engineering in Electronics and Telecommunication Engineering St Vincent Pallotti College of Engineering and Technology, Nagpur (MH), INDIA CORE COMPENTENCIES & SKILLS

System Analysis and Design

Agile, Extreme Programing (XP), Waterfall

Logical design (ER diagrams)

Programing Languages & Development Environments

PL/SQL, T-SQL, R, Python, MATLAB, Eclipse,

NetBeans, SQL Developer, Jupyter Notebook,

Datatel, Informer, Pycharm

Data Analysis (ETL & Reporting Tools)

SQL Server Integration Services (SSIS), SQL

Server Reporting Services (SSRS), Tableau

Familiar with

BigData, Hive, Hadoop, Spark, Hbase,

Machine learning

Database Administration / Development

MYSQL, SQL Lite, SQL Server 2005/ 2008,Oracle

UI Design & Web Technologies

HTML5, CSS, XML, JSP, Servlets,

Platforms

Windows, MacOS, Linux

EXPERIENCE

Intern, Fidelity Investments (Capital Markets) Jan 2018 - Dec 2018

Participated in all the phases of SDLC, starting from requirement, design, development, testing and implementation phase

Experience in writing SQL queries in oracle database

Analyzed system specification and user requirements

Worked directly with developers, Project Manager and business contacts to produce Test Scripts and Test Conditions

Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams and OOD using Visio.

Prepared and Executed Test Plan, Test Scripts and Test Case Document for User Acceptance Testing based on functional and technical specifications Graduate Research Assistant Jan 2018 - Dec 2018

Department of Administrative Science, Fairleigh Dickinson University

Generated reports related to faculty and students by firing SQL queries using Informer reporting tool.

Used Development shell to upload online courses and work on HTML coding for their proper and accessible representation.

Attended Management–Faculty meetings to track suggestions and plans for curricular development.

Worked on MS office products like Word, Excel, Access, PowerPoint, Project etc.

Checked for plagiarized and copy right materials and ensured to use it appropriately.

Used Software Camtasia for preparing Transcripts of the videos. Graduate Research Assistant Aug 2017 - Dec 2017

Department of Computer Science, Fairleigh Dickinson University

Part of a team of 4, was responsible for maintaining and developing ongoing college research project based on Machine Learning and Python.

Designed, implemented and maintained a database using SQL Server and also created application database code objects, such as stored procedures and views.

Responsibility included building and maintaining SQL scripts, indexes, and complex queries for data analysis and extraction.

Establish relationship between student GPA and performance with Exploratory Data Analysis

(EDA) using Pendas methods

Establish grading patterns of instructors using Data Visualization of histogram/count plots and Sankey diagram using Seaborne and Plotly respectively

Analyze student’s performance over successive semesters by visualizing connected scatter plot using Plotly

Data Analyst Sep 2015– Dec 2016

Kotak Investments, Bangalore, India

Project: Investment Maintainance Management Systems (IMMS)

Worked with Business Analysts and DBA and gathered business requirements, business analysis, coordinated with testing team.

Experience in working on Agile framework and various phases of Software Development life cycle (SDLC) (Analysis, Requirements gathering, and Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.

Experience in writing T-SQL, working on SSIS, SSRS, Data Cleansing, Data Scrubbing and Data Migration.

Designed data mapping and filtering, consolidation, cleansing, integration, ETL, and customization of data mart with SQL queries to implement segmentation model created.

Performed extensive back-end testing by writing SQL queries and PL/SQL stored procedures to extract the data from the SQL database.

Developed project plan and managed project scope ACADEMIC PROJECTS

E-commerce Project

The Project was to prepare the best E-commerce Business proposal. This involves a lot of research work about the market and resources. After doing all the studies we made Business Proposal of online website which is all about dogs. Proposal includes Business Model, Competitive Advantages, Strategies, Revenue generation etc.

Implementing Tic TAC Toe in Java

Class was divided in the team of 3 members each to compete with other teams. The project was divided into 3 sections:

1. The first part is the board functions. These include initializing the board, printing a representation of the board and a check to see if the board is full.

2. The second part is the win conditions. Here we have a simple function which will tell us if there is a win or not on the board. This function will call other functions to check the rows, the columns and the diagonals for a win condition.

3. The last part is the player functions. These control which player mark is active and where a user can place their mark on the board

(Prediction Engine)Machine Learning

Part of a team to build a prediction engine for the salary of any US jobs. This help employers and job seekers figure out the market worth of different positions. Python, Pandas and Scikit are used to build this project

Cloud Computing Architecture

The project provides an analytical description and the fundamental design of an important contemporary development in computer-system architecture. It offers a solid technical description of the development. We analyzed the hardware and the software involved in making the project possible and presented the paper.

EZ-Pass System

Designed, developed and Managed EZ-pass system working in a team of four. We developed complete system from Analysis, use cases to functional software. Used UML to prepare Analysis and System Design Model.

Online Banking System (Advance Java Project)

Successfully developed and deployed a manageable and maintainable web application by implementing MVC design and pattern to support basic functionalities as: Admin Options: - Show All Accounts, Open Account, Close Account, Deposit Amount User Options: - Transfer Money, Withdraw Money, View Account Used: - HTML5, CSS3, MS SQL Server and reusing models code.

Event Planning Website and Eye Testing Website

Design, Develop and manage website for Event Planners and Eye Care Centre from grounds up using HTML, PHP, CSS, MYSQL

Worked on Front end and Back end. Used XAMPP software to create and store Database AWARDS & ACTIVITIES

Won Efficient Website Building Competition during last semester Academic Project

Member of PYFI (Pallottine Youth International Forum) NGO for the welfare of the community.(Since 2011)

Co- coordinator of the College Annual Fest (2014)

High School Volleyball team member. Represented LFSS School at various inter-school meets.

Winner of the Techplanation inter college competition (2014).

Presented the paper in a National Conference on Wireless Communication and Networking (2013).

Contact this candidate