GitHub: https://github.com/Shivam**** LinkedIn: https://www.linkedin.com/in/shivamgupta13/

Shivam Gupta

MASTER STUDENT

Applied Computer Science

Dalhousie University

Halifax, Nova Scotia

+1-902-***-****

Email: addp1a@r.postjobfree.com

SKILLS:

Programming Languages:

Python/Python3, C/C++, Java,

JavaScript, SAP ABAP, Unix, HTML,

SQL.

Databases:

MySQL, SQL Server, MongoDB,

Oracle, SAP BW, Firebase, AWS

RDS, S3 bucket. SAP HANA

ETL:

Data warehousing using

Informatica tools.

Web Development:

React.js, Node.js, Angular.js,

Express.js

Prototyping tools:

proto.io, balsamic, InVision.

Cloud Services:

Amazon Web Service, Microsoft

Azure. AWS – RDS, Docker, S3

bucket, boto3, GCP Container

systems

Open Source framework:

Big Data using Hadoop, Apache

Spark.

Data Visualization:

Tableau, IBM Cognos, Neo4j, SAP

BO/Bex, Cognos framework

manager.

Others:

Git, Natural Language Processing,

MS Office, Android Studio,

Network Security. Agile Scrum,

Project Management, InfoCube,

InfoPackage, DSO, PSA

WORK EXPERIENCE

Data Analyst (Sep 2015 – Oct 2018)

Infosys Ltd. Headquarters, Bengaluru, India

3.1 years’ experience in Python, SQL Server, ETL, Tableau. Worked extensively in Data Analytics and BI. Experience in Data integration and management.

Undergone Infosys Data Analytics and BI training and scored 96%.

Involved in analyzing, designing, development, and implementation of analytical technologies and data warehousing concepts. Experience with the relational database. Reporting experience with SAP BO and Bex.

Extensively used MS-Excel (Pivot, V-lookup, Macros), SQL Server, and Reporting and Visualization tools such as Cognos, and Tableau.

Achievements:

Developed Report for Indian Ministry of Corporate affairs using Tableau, which identified the company information region wise on a map. Received an appreciation from the Minister of Legislative Assembly for creating an efficient solution for data analysis.

Extracted, Transformed and Loaded Infosys’ Payroll and Salary Analytics Data and made many reports on Financial modules like AP, AR, Treasury and, etc. for business stakeholders. Worked alone for Month End, Quarter End and Year-End Result.

Developed and shared a Yearly report to Infosys’ CEO, which helps in identifying the company’s growth.

EDUCATIONAL QUALIFICATIONS:

Master of Applied Computer Science (Jan 2019 – Present) GPA: 3.9/4.3 Dalhousie University, Halifax, Canada

Relevant Courses: Mobile Computing, Data Warehousing, Advance Web Development, Serverless Data Processing, Developing UI/UX, Network Security, Software Comprehension, Technology Innovation. Bachelor of Technology, Information Technology (2011-2015) GPA: 7.4/10 Guru Gobind Singh Indraprastha University, New Delhi, India Relevant Courses: Data Structures, Design and Analysis of Algorithms, C, OOPS, Java, Operating Systems, Database Management Systems, Discrete Math, Object Oriented Analysis and Design, Computer Architecture, Programming.

PROJECT

Data Analysis using Twitter Search and Stream API, Sentiment and Semantic Analysis:

Extracted tweets using Search and Stream API, Cleaned the data and Stored it in MongoDB.

Used Apache Spark Cloud and performed Map Reduce operation to find out the word counts.

Used Natural Language Processing (tf/idf) to identify Positive, Negative or Neutral tweets. Case study of Ocean Data using Node.js/MongoDB/MySQL:

Extracted, Cleaned, and uploaded the real time Ocean data in MySQL workbench and separately for MongoDB and integrated it with a Node.js application. Database Project on real-time Nova Scotia data:

Extracted NS data from NS websites and open data, cleaned and stored it in MySQL Workbench. Created a Star Schema for different domains.

Visualized the data using IBM COGNOS and Neo4j.

Serverless Data Processing Project: AWS: RDS, S3, LEX, ECR/ECS, EC2 GCP: instance, Docker, Cloud run

Created a Login module using RDS, S3, and boto3 SDK in AWS and similarly in GCP using Docker images of node.js full stack application and executed it using Google Cloud Run. Covid-19 Web application: MongoDB, Express.js, React.js, Node.js: Visualized Covid-19 tracker.

Contact this candidate