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
BigData, Hive, Hadoop, Spark, Hbase,
Database Administration / Development
MYSQL, SQL Lite, SQL Server 2005/ 2008,Oracle
UI Design & Web Technologies
HTML5, CSS, XML, JSP, Servlets,
Windows, MacOS, Linux
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
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.
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).