Business Systems Analyst

Jaydeep J Chopde

202-***-**** ● ******.*******@*****.*** ● Alhambra, CA 91803

CALIFORNIA STATE UNIVERSITY, Los Angeles May 2019

Master of Science in Information Systems

UNIVERSITY OF PUNE, Maharashtra, India Dec 2016

Bachelor of Engineering in Electronics

Skill-set: Requirement Gathering, Gap Analysis, Business and IT Workflows, SOP’s, Software Development Process and Documentation, Analyzing Information, Teamwork, Software Maintenance, Written Communication and Process Improvement.

Tools: Power BI, Tableau, MS Excel, MS Visual Studio, MS Visio, MS Teams, SharePoint and HP ALM.

Platforms: Windows, Linux and MAC

Methodologies: Agile and Waterfall Mode

Certifications: Java version 6 Oracle Certified Professional.

Kaiser Permanente, Pasadena, CA July 2019 - Present

Project 1 (TD2EX – Query Migration)

Jr. Analyst

Team: Defect management and Release management (Query Migration/Disaster Recovery)

Responsible for identifying defects and creating a ticket with Life Cycle Management Tool.

Comparing the SQL queries for duplicates.

Assigning the tickets to the respective teams for a resolution.

Validating the solution (Teradata to Exadata query Conversion) and routing it to the end-user.

Generating daily, weekly and monthly reports defects statuses.

Piloting Follow-ups and documenting Quality center for the interested parties.

Providing support to Sr. Director(s) by performing moderately complex administrative activities that require a high level of initiative and judgment.

Provide support to multiple projects and handle sensitive information with the strictest confidence

Participates in committee meetings, prepare and distribute meeting notification, correspondence and agenda materials. Takes and transcribes minutes, prepares presentation materials, manages logistics and oversees action items. Keeps detailed project notes and records.

Creates and distributes correspondence relevant to the team, project or program (internal and external).

Develops and maintains accurate and complete files for projects and programs; continues to monitor for integrity and completeness.

Updates necessary tracking system(s) to ensure that project and/or program status is maintained with complete accuracy.

Communicates all issues to management prior to reaching critical status.

Schedule department resources such as people, meetings, appointments, rooms, and equipment.

Prepare presentations, reports, spreadsheet, and other documents as required for project needs

Creates and distributes correspondence relevant to the team, project or program (internal and external).

Assists with administrative preparation for various meetings.

Develops and maintains accurate and complete files for projects and programs; continues to monitor for integrity and completeness.

Updates necessary tracking system(s) to ensure that project and/or program status is maintained with complete accuracy.

Project 2 – Business Systems Analyst October 2019 - Present

Team: PMO

Develop uses cases for the application replacement.

Translate the business requirements into functional requirements for development.

Collecting and prioritizing functional requirement for new application by working with the stakeholders.

Analyze the upstream and downstream applications integration to the database.

Understanding data needs of various user areas, suggest solutions and build as necessary.

Performing GAP Analysis for Current state system with of the shelf vendor product and future state system.

Creating Business/IT workflows.

Build and manage inter-team project plans and keep stakeholders and sponsors informed.

Tracking and managing the action items for record keeping.

Creating and reporting Project progress reports based on the approved matrix.

Sentiment Analysis of Amazon Reviews

Objective was to determine customer behavior towards the least rated product on amazon. This was achieved by studying the sentiments of customers using the amazon review data.

Amazon review data from AWS S3 bucket was ingested into Hadoop.

Hive was used to create external tables and query that stored data.

Visualizations were done using Power BI and Tableau.

Market Analysis for Google Playstore Apps

The objective of this project was to clean, analyze and visualize playstore data using python to find useful insights about the app popularity and relation between popularity and ad revenue.

Pandas, NumPy and SciPy libraries were used to clean and extracting patterns.

Trained the model to predict app if the app will be popular using Scikit-learn (Decision Tree classifier)

Visualization was done using Matplotlib & Seaborn.

Automate Inventory Management System

The objective was to create and maintain a database for inventory stock using MySQL and provide an interactive dashboard of the inventory. Also, to automate the processes of reordering the stock using triggers.

Database used for this application is MySQL.

Server used is Apache Tomcat Server.

Connection of webpage to the database is done the JSP Servlet pages.

Application is designed using HTML5, CSS, JavaScript, AJAX, jQuery.

The 14th Asia Pacific International Conference on Information Science and Technology (APIC-IST 2019) Title: Big Data Predictive Analysis of Amazon Product Review https://www.manuscriptlink.com/conferences/apicist2019/download/14462/

MS Excel

LinkdIn

June-20

SDLC Training

KP Learn

Jan-20

Tableau: MyDashboard Training

KP Learn

Jul-19

Tableau Sever: Getting started and basic interacting with Content

KP Learn

Jul-19

My SQL Training

LinkdIn Learning

Mar-18

Python 3 Essential Training

LinkdIn Learning

Sep-17

Programming Foundations: Object oriented designs

LinkdIn Learning

Sep-17

EDUCATION

SKILLS

INDUSTRY EXPERIENCE

ACADEMIC PROJECTS

PUBLICATIONS

TRAINING AND CERTIFICATIONS

Contact this candidate