Data Engineering

Pragya Mishra

•** Park Drive Apt **, Boston, MA *2215 •Tel: 857-***-****

• Mail: ******.**@*****.***.*** •LinkedIn: https://www.linkedin.com/in/pragya-mishra-819ba640

EDUCATION

Master of Science in Information Systems, Northeastern University, Boston Aug 2015- May 2017

Application Engineering and Development

Database Management

Web Tools

Data warehousing and Business Intelligence

Web Design and User Experience

Data Analysis using Python

Bachelor of Engineering in Electronics and Communication Engineering, BIST 3.6 Sep 2008- Jun 2012

TECHNICAL SKILLS

Programming Languages

Web Technologies

Java, Python, JavaScript,, SQL

Angular JS, Node JS, Meteor JS, HTML5, CSS3, Bootstrap, JQuery, Spring MVC, Hibernate, JSP, Servlets, Ajax, Gulp

Database

MongoDB, SQL Server, MySQL, PostgreSQL, Oracle 11g

Tools

Eclipse, NetBeans, Apache Tomcat, Pycharm, Talend, QlikSense, AdventureWorks, Tableau, Power BI, GitHub, Power Pivot

Functional Skills

Software Development lifecycle, Agile methodology

WORK EXPERIENCE

Web Developer Intern May 2016- Sep 2016

Leap Doctor, Tampa, Florida

Developed a Job Search Portal for Medical Professionals in Meteor JS from scratch

Implemented Job Post section of the portal by feeding data to Mongo DB

Dynamically fetching of webpages and functionality as per the role assigned to the user

Deployed the Portal on EC2 instance of AWS

Senior Systems Engineer Jan 2013 – Jul 2015 Tata Consultancy Services, Pune, India

Worked in different SAP environment for role assignment and group assignments for the users according to their privileges, ensured regression testing of Supplier Relationship Management and Supplier Self Services Portal.

Implemented SRM Portal, Jive and Business Objects integration with British Gas Group Portal.

Google Search Appliance and Internal Control Framework reports to business on a monthly basis.

ACADEMIC PROJECTS

IOT based Telemedicine Application Saving Lives in Real Time - Streamlined and developed an Object Oriented Java Application with a user interface based on Swing. Used design pattern and integrated authentication and authorization for different user roles in the application. Incorporated Internet of Things (IoT) to monitor the patient’s critical health

Database system for Nano-oncology Treatment for Lung Cancer- Designed and Developed a relational database schema using MySQL that diagnoses and prescribes actions to treat Lung Cancer autonomously. Scripted Triggers and Stored Procedures that actuates the Nano-particle strands based upon the severity.

eCommerce Website- Developed a dynamic website using HTML5, CSS3 to design impressive GUI

Developed an add to cart functionality using Angular JS, Ajax and Mongo DB.

Job Search Portal using Spring MVC- Developed a Job search application using spring MVC used CSS3, HTML5 to design immersive GUI. Assigned different work areas to different users in the application which is identified by login credentials. Implemented ORM using hibernate to store the application's data in MySQL

European Soccer database analysis- Data analysis using python libraries numpy, pandas and plotting graph using seaborn and matplotlib. 11 European Countries with their lead championship and Seasons from 2008 to 2016. Performed various analysis on this dataset such as best player in terms of strength and goals.

Data-Warehousing on the Microsoft provided Contoso Retail DB- Performed ETL on Contoso Retail DB. Designed Fact and Dimension tables in snow-flake schema and implemented SCD’s. Performed Data Integration using Talend Open Studio which involved data-conversion, error handling, loading erroneous records in rejects table. Performed Data Visualization through Dashboards, Charts, and Maps by performing Trend analysis, Contribution analysis in Tableau, QlikSense, Power BI and Power Pivot.

CERTIFICATION/ BOOTCAMP

ITIL V3 IT Service Management Foundation Certification.

Contact this candidate