Software Developer It Support

Mandeep Atwal

***.*****@*****.***, Cell: 425-***-****

https://github.com/AtwalMandeep

Objective: Creative and efficient software developer looking to continue my career at an exciting and growing application development organization. Technical Skill Summary

Database AWS S3, Mongo DB, HDFS, Microsoft Access, Microsoft Excel, MySQL Workbench, MySQL

Languages Scala, SQL, Spark, Core Java, HQL

Big Data Spark, Kafka, Map Reduce, Yarn, Hive, Hadoop Other technology Ubuntu, Intellij, Eclipse, NetBeans, Net Beans, My Eclipse, Visual Studio

Development Github, Git, AWS, Eclipse, Intellij, Net beans Work Experience:

Verizon Enterprise/Infosys

ProQuest IT Support Associate, Infosys Richardson/Irving Texas Apr 2022 – February 2024

Responsibilities:

● Sustained an existing application based on the evolving requirements of business using SQL Platform.

● Identify and resolve the tickets that is coming from At Your Ticket System using SQL.

● Create a Jira and describe the problem, then assign Jira to relevant person.

● Created reports to find out problems and inflight orders with issues to effectively control the tickets raised by end users.

● Ensure that my product queue’s description was met by addressing the tickets raised by end users through the At Your Service Ticket System.

● By prioritizing client production needs promptly, I effectively minimized the impact on revenue and helped the sales achieve their monthly goals.

● Work on escalating problem using query, find the issue and fix the problem in a timely manner and post implementation reviews.

● Work closely with business in managing day to day issues, resolve user queries.

● Perform in-depth research and identify sources of production issue Revature Jan 2022 to Apr 2022

P1

https://github.com/AtwalMandeep/Project1

HIVE-Project

Responsibilities:

● Load the beverage and branch data set into main table using LOAD query and perform action using the query.

● Created a menu based on given scenarios

● Created a data connection using Apache Spark session

● Selected data using Spark Sql query according to given criteria

● Created a partition view and displayed the data on command line

● Deleted the row and displayed the table using comment, note

● Created future query using data table on Microsoft Excel

● Projected coffee beverage consumption using equation created from polynomial trend line on graph.

Environment:

Hive, Scala, Spark

P2

https://github.com/SamuelTaylr/Project2

Responsibilities:

● Wrote SQL Queries to query and display data in Zeppelin

● Worked with 4 members of team

● Developed User Login Page

● Created spark query to fetch the information

● Convert the Data Frame to Dataset and perform queries on it

● Convert the CSV file into Tabular format

● Sourced the data for the project

● Convert the data frame to dataset and displayed in tabular form Environment:

Spark, Spark SQL, ZeppelinCollate, bundle, and transfer mail from one area to another. Back-End-Developer

Think and Learn Pvt Ltd Jul 2012- Jul 2013

Responsibilities:

● Analyzing the requirement document and preparing queries for clarification from client.

● Involved in High Level Design Document (HLD) preparation.

● Involved in developing HTML,CSS and JavaScript for client side presentation and, data validation on the client side with in the forms.

● Used jQuery core library functions for the logical implementation part at client side for all the application.

● Involved in business requirement gathering and technical specifications.

● Involved in the analysis, design, and development and testing phases of Software Development Lifecycle (SDLC) using Agile and waterfall methodology.

● Involved in Presentation Development using Struts Framework.

● Implemented J2EE standards, MVC architecture using Struts Framework.

● Implemented Servlets, JSP and Ajax to design the user interface.

● Implemented and configured various Action classes for handling the client requests using Struts framework.

● Wrote Web Services using REST for sending and getting data from the external interface.

● Used Design patterns such as Business delegate, Service locator, Model View Controller

● Hands on experience in resolving issues in the production server.

● Created Stored procedures using PL-SQL for data modification (Using DML insert, update, delete) in Oracle

● Interaction with Oracle database is implemented using Hibernate. EDUCATION

University of Washington, Seattle WA June 2016

Certificate in HTML and CSS web development

National High College, Dhuri, Punjab INDIA June 2005 Graduation in Arts

Shri Guru Harkrishan College, Patiala, Punjabi University INDIA June 2011 MCA (Master in Computer Application), Software Engineer Bachelor's Degree in Art/Art History from Punjabi University

Contact this candidate