MRINAL RANA

ade06c@r.postjobfree.com

+1-647-***-****

Brampton, ON, L6P 3E8

GitHub LinkedIn

SUMMARY

•5 years of experience in IT including 2+ years in technologies such as OCI, BigData, Data warehouse.

•Certified Oracle Cloud Architect Professional, Architect, Developer Associate and Autonomous Database Specialist

•Certified Microsoft Azure Fundamentals and Oracle Cloud Foundations Associate

•Experienced in BigData tools such as HDFS, Hive, Spark, Sqoop, MapReduce, YARN, Flume etc.

•Proficient in SQL Server & Oracle development and Data warehousing.

•Graduate of the Information Technology Solutions Post Graduation program at Humber College

•Made Dean's Honours List every semester at Humber College

•Bachelor’s Degree in Electronics and Communications

•Leadership experience in Humber Academic and International orientations.

TECHNICAL QUALIFICATION

Troubleshooting: Ability to troubleshoot SQL Server, Oracle databases, Hadoop Cluster and software, hardware, and peripheral devices including printers, network issues, operating systems

Programming Languages: PySpark, R Programming, Cypher, JavaScript, CSS, HTML, XML, Java, Shell Scripting. Proficient in writing code, testing, debugging, and documentation

Software/Tools: R Studio, NetBeans, Neo4j, SQL Developer, SQL Data Modeler, Oracle APEX, SQL Server Management Studio, Oracle Virtual Box, Apache Ambari, Sqoop, SQL PLUS, HUE, Cloudera Quickstart VM, Visual Studio, MS Office (Word, Excel, PowerPoint, Access),

Operating Systems: Windows 10/8/7/XP/Window98, Linux, Mac iOS, Android, Ubuntu

Database: MySQL, Oracle, MS SQL Server, Hive, HBase

Web Technology: HTML5, Java Script, XML, J2EE(Servlets), J2EE servers, AJAX

CERTIFICATIONS

Oracle Cloud Architect Professional Verify Here

Oracle Cloud Architect Associate Verify Here

Oracle Cloud Autonomous Database Specialist Verify Here

Oracle Cloud Developer Associate Verify Here

Oracle Cloud Foundations Associate Verify Here

Azure Fundamentals Verify Here

WORK EXPERIENCE

Company: A4 Softtech, Parsippany, NJ September 2019 – present

Role: Cloud/Data Consultant

Responsibilities:

•Designed and created VCN, Route Tables, Subnets, Compute Instances, Load balancer for high availability and disaster recovery model.

•Projected the concepts of connectivity such as DRG, Internet gateway, NAT, Service gateway and security i.e. security list, network security groups, stateful and stateless ingress/egress.

•Demonstrated ability to manage the areas of storage, backups, server operating systems and networks.

•Designed the connectivity model to connect the compute instance with internet.

•Experienced architecting highly available systems that utilize load balancing, horizontal scalability, and HA .

•Analyzed client requirements and optimize Cloud services architecture for performance and cost.

•Delivered an optimized infrastructure services design leveraging public, private Cloud architectures and services.

•Introduced the strategy for connection and migration between on-premises and Oracle Cloud.

•Experienced in using Oracle SQL, Microsoft SQL Server, MySQL relational databases and NoSQL databases

•Hands on programming with Python, Java, R, Cypher

•Shell scripting: the ability to read, understand, modify, and write shell scripts

Company: Geo Global Realty, Mississauga, ON July 2019 – present

Role: Website Design/Data Assistant (Freelancer)

Website: www.geoglobalrealty.com; www.georealty.co; www.geocondo.com

Geo Realty is a full-service real estate company working with Right At Home Realty Inc. Brokerage and provides Real Estate services for local and international properties.

Responsibilities:

•Managing portfolio of three websites

•Implementing and managing IXACT CRM database with uploading new contacts and data cleansing

•Designing and added new content

•Supporting in digital marketing and social media promotion for organic growth using SEO, FB and Google Ads

Company: Arya Spa & Wellness, Brampton, ON September 2018 – present

Role: Web/Database Admin (Freelancer)

Website: https://aryaspawellness.ca/

Arya Spa & Wellness is an urban spa destination in Mayfield Village of Brampton that caters to women and men who want stress relief and relaxation in a serene atmosphere.

Responsibilities:

•Designing, maintaining, manipulating MySQL database.

•Implementing updates, upgrades, and patches in a timely manner to limit loss of service using WordPress.

•Collaborating with development teams to discuss, analyze, or resolve usability issues.

•Testing backups and recovered plans regularly and resolve problems.

•Managing website based on both PHP, upgraded PHP including content and plugins.

COLLEGE PROJECTS

Project Challenge #1: The project entails creating a dashboard to provide analytics on membership usage of the platform.

Technologies Used: MySQL, HBase, JavaScript, Python, CSS, HTML

GitHub: https://github.com/MrinalRana/Codes/tree/master/College_Projects/Project_1

Project Challenge #2: To create a search on webpage which will fetch data through API

Technologies Used: JavaScript, HTML, AJAX, CSS, XML, JSON

GitHub: https://github.com/MrinalRana/Codes/tree/master/College_Projects/Project_2

Project Challenge #3: To design a testimonial page for website

Technologies Used: HTML, CSS, JavaScript

GitHub: https://github.com/MrinalRana/Codes/tree/master/College_Projects/Project_3

Project Challenge #4: Develop a multi-threaded client server database application so that multiple client applications can communicate with the server application to insert and retrieve data into/from Oracle database.

Technologies Used: Java, Oracle Database

GitHub: https://github.com/MrinalRana/Codes/tree/master/College_Projects/Project_4

Relevant Courses:

•BigData (Hadoop, Spark, Hive, HBase, Sqoop, YARN, MapReduce)

•SQL Server Development and Administration

•Oracle Development and Administration

•JavaScript, HTML, AJAX, CSS, JQuery, Java

•R Programming

•Data warehouse

•Neo4j (Cypher Programming)

•Business Intelligence (OBIEE, AWM)

Oracle Apex

EDUCATION

Program: Information Technology Solutions September 2018 - April 2020

Location: Humber College, Toronto, ON

Relevant Competencies:

•Imported and exported data from/to a MySQL database into HDFS using Sqoop/Spark

•Loaded data into and out of HDFS using the Hadoop File System commands

•Write the results from an RDD/DataFrame back into HDFS using Spark

•Loaded RDD/DataFrame data from HDFS for use in Spark applications

•Performed extract, transform, load (ETL) processes on data using the Spark API/SQL Loader/Data Pump

•Joined disparate datasets using Spark as well as written queries in MySQL/Hive to retrieve results with improved performance.

•Developed SQL queries to performed DDL, DML, and DCL.

•Created PL/SQL packages, procedures, functions, and triggers.

•Developed responsive, database-driven applications using Oracle APEX Forms and Reports.

•Created indexes, views, materialized views on database tables for better optimization and lower cost

•Developed nodes, labels, properties, and relationships in Neo4j graph database.

•Backup and restore done on MS SQL Server databases plus have traced and monitored the instances

•Updated web pages dynamically, read/send data from/to a web server with help of AJAX

•Employed XML and JSON in different data exchange applications, worked with APIs and JavaScript

Bachelor of Technology in Electronics & Communications June 2011 - June 2015

Dr. A.P.J. Abdul Kalam Technical University, India

CO-CURRICULAR RECORD (CCR)

CCR Certified Authentication Code: 62909895568120642256

Organization: Humber College Session 2019 - 2020

Activity: Orientation Programs

Role: Orientation Leader

Supported the Orientation program by answering questions, interacting with, and welcoming new Humber students. Orientation Leaders provide day-of event support during Orientation and participate in training and development programs.

Organization: Humber College Session 2019 – 2020

Activity: Bringing in the Bystander

Role: Workshop Attendee

This program teaches bystanders of sexual and relationship violence how to safely intervene in instances where an incident may be occurring or where there may be risk, how they can help survivors get the help and support they need, and how they contribute to the creation of a campus climate that reflects a commitment to safety for all.

AWARDS AND ACCOMPLISHMENTS

Dean's Honours List all semesters

REFERENCE

Available upon request.

Contact this candidate