Rishi Joshi (RJ)

AWS Certified Big Data Engineer / Architect / Product Owner

Certifications

● Completed AWS Big Data Specialty Certification 2018. Valid License

● Completed AWS Certified Solutions Architect – Associate 2018 Valid License

● Completed M102: MongoDB for DBAs (2017)

Education:

● Admitted into Georgia Tech’s Online MS in Analytics, Atlanta, GA USA- 2019

● Master of Business Administration (M.B.A.), Pune, India University of Pune (formerly Poona), (Major: Financial Management)

● Bachelors in Computer Engineering (B.E.), Pune, India University of Pune (formerly Poona), (Major: Computer Engineering) Tech Skills:

Google Cloud Platform Architecture, Google Big Query, Google Composer, Google Cloud Storage, Google SQL, Google Dataproc, Cloudera Hadoop, AWS Architecture, AWS EMR AWS VPC, AWS RDS, AWS CLI,AWS S3, AWS IAM, AWS Aurora, AWS EC2,AWS SNS, AWS SQS,AWS SQF, AWS Dynamodb, AWS Redshift, AWS EMR, Ansible, Python, Chef, Mongo Cloud Manager, MongoDB, Json, MySQL Enterprise Monitor, MySQL, MySQL dump, Github, Cassandra DBA, SQL Server DBA, SCOM, Atom, Sublime, Oracle Cloud Control, Oracle Database 12c, Oracle RAC/ASM 11G, Oracle Data Guard, Oracle Goldengate, Oracle Performance Tuning, Big Data MapReduce, ETL, ELT, Gemalto SafeNet KeySecure Management Console, Vormetric encryption, OO Concepts, Perl, Powershell, Korn, Risc networks Cloudscape PM Tools: JIRA, Scaled Agile Framework, Pivotal Tracker, Microsoft One note, Visio, Box, Innotas Apps Supply Chain Asset Visibility Applications, Clinical Research Applications, RedCap, LIMS Methodologies: Multi Cloud, Cloud Lift and Shift, ITIL Certified, Ralph Kimball /STAR schemas Strengths:

• AWS Certified Big Data Specialty

• AWS Certified Solutions Architect-Associate

• Hadoop, AWS EMR, Parquet, ORC, Avro

• BI & Data Warehouse Architecture

• MongoDB/ Cassandra/ AWS Redshift DBA

• AWS CLI, Python, Perl, Ansible, Powershell,

PLSQL Scripting

• Encryption Technologies

• MySQL,Oracle, SQL Server, MongoDB DBA

• ElasticSearch

• Cassandra

• Google Cloud Platform

• Google Big Query

• Cloud lift and shift OnPrem --> AWS

• Cloud Migration AWS --> GCP

• Redshift, Aurora Cloud DBA

• POC Management and Assessment

• Database Security

• Relational and NOSQL Data Modelling

• Redshift,Oracle/MYSQL Performance Tuning

• Version Control Github

• PySpark

Immigration Status: US Citizen Contact#: 678-***-**** email: ade3rn@r.postjobfree.com Zebra Technologies. 05/2017-Current

Big Data Architect/ Senior Data Engineer / Product Owner

● As a PySpark developer created Transformations and Actions to build Data engineering pipelines to move snapshot and historical mdm (Mobile Device Management) data using AWS Glue, S3 and Spark 2.2 into ElasticSearch. Parquet files were used on S3 to improve performance and cost savings. Code was debugged using Glue developer endpoint and Jupyter notebook. Glue crawlers were used to build a data catalog.

● As a Big Data Architect on AWS to GCP migration: Provided consulting and advisory role in creation of Google Cloud infrastructure to support the migration from Cloudera on AWS to Google’s managed Hadoop platform. This project involved migration of 35 etl pipelines from PySpark on Cloudera to PySpark on Dataproc using SAFE agile project management framework involving Sprints and 4 PI’s (Program Increments).

● As a Product Owner for the Supply Chain Device Visibility Platform, I was responsible in creating product features to enable the customers to track devices which are in repair, in spare pool, inbound to customer and in operation. I was responsible for moving the product from Minimum Viable Product (MVP) to creating a finished product.

● As a Big Data Architect was involved in Data Modeling in ElasticSearch, Hive and PostgreSQL so that Dashboards can be run faster and within SLA’s . This involved bringing to conclusion discussions with Multiple stakeholders, Data engineers, DBA’s, Product Management personnel and User Interface developers. Emory University. 05/2012-04/-2017

Sr Data Engineer / Big Data Architect/ Data Warehouse Architect/Cloud Architect/Data Architect/Team Lead: Primary roles: Big Data Architect, Cloud Infrastructure Architect, Configuration Management Architect, Big Data DBA. Secondary role: Consultant, Developer, BI & Data Warehousing Architect

● As a Big Data Architect for AWS Big Data Center Builds: Providing consulting and advisory role in creation of AWS EMR clusters. This included transient as well as permanent clusters for processing and converting large sets of data to enable the Data Solutions team to run reports using Jupyter Notebooks.

● As a Data Architect Created a Denormalized Star Schema Data Model for stabilizing Universities Security Portal to make it a scalable and reliable application. Partitioned several Oracle tables using Interval Partitioning and wrote PLSQL scripts to drop older partitions and to archive data. Currently in the process of upgrading Oracle from 11.2.0.4 to Oracle 12.2.

● As a Big Data Architect built a Cassandra service and installed/created/partitioned/queried and backed up several Cassandra nodes in a cluster. Recently helped in migrating Cassandra 2.2.5 to Cassandra 3.1.1. Added nodes and decommissioned nodes to resize cluster using nodetools

● Managing Standalone Mongo service: For Champs Child Health and Mortality Prevention (Champs) Built and monitored Mongo database service with Data at rest for customer using a Security appliance Vormetric and Mongo Cloud Manager. Helped Customer troubleshooting Json queries. Completed upgrading Mongo from 3.2.9 to 3.6. The database was primarily being used to ingest unstructured data.

● AWS Security Control Policies Enablement: Building Test cases so that data is secure in the cloud for the following AWS services: AWS RDS (Oracle, SQL Server, MySQL, Postgres, Mariadb), Dynamodb, Aurora Cluster

(MySQL and Postgres), Amazon Redshift, Elastic Cache. Enabled SSE-KMS for data at rest and downloaded certificates for Data in motion.

● AWS Cloud DB creation cookbooks: Created low cost AWS footprint by creating new AWS CLI based scripts so that Development template database in AWS RDS (Oracle, SQL Server, MySQL, Postgres, Mariadb) and DynamoDB, Aurora can be built on the fly and shutdown during off peak hours.

● As Configuration Management Architect: Compared Chef and Ansible on various categories so that a proof of concept can be executed to choose a product for the University.

● Managing Development, Maintenance and ETL for School of Medicines applications using Oracle on Windows using Powershell and PLSQL scripts.

Immigration Status: US Citizen Contact#: 678-***-**** email: ade3rn@r.postjobfree.com Ericsson/Sprint Corp., 4/2007- 04/2012

Team Lead/Data Architect/Devops Architect: Primary roles: Team Lead/Data Architect and Mentor. Secondary role: DBA.

● Led a team of 8 DBAs providing mentorship, guidance and support on a 24 by 7 basis. Managed, monitored, analyzed and resolved crisis to help customer.

● Ansible Cookbook for Patching and Password rotation: As a Devops architect wrote programs to change passwords of 10’s of MySQL database servers using Ansible. Developed Ansible scripts to create new database users on multiple environments. Programmed Ansible’s jinja2 templates to configure the my.cnf file to install MySQL databases on a number of hosts. Deployed ClamAV and Ubuntu Unattended upgrades using Ansible scripts. These playbooks were then put into Git and associated with Ansible Tower so that runbook automation can be performed. Ansible Cookbook for SQL Server: Used Terraform to bootstrap python on a target AWS Windows server so that Ansible can install SQL Server using Ansible playbooks. These scripts were then put into Github by using push and pull.

● Scaled up customer traffic on a 4 node Oracle 11g RAC/ASM by performing SAN migrations, OCR/voting disk migrations, node addition and deletion and performance tuning.

● Improved system uptime by creating MAA Architecture using Oracle Dataguard Physical Standby, Logical Standby and Snapshot Standby configurations.

Sprint Nextel Corp., 06/02-04/2007

Data Warehouse Architect/ Data Architect: Primary Assumed role: Data Architect. Secondary roles: Oracle DBA, Data Analyst, Business Intelligence Analyst, Revenue Analyst, Mediation Analyst

● This project involved loading flat file data into several staging tables and transforming it using PL/SQL and perl scripts into an Oracle database which was Star Schema based. It involved applying several business rules to transform data so that it could be sliced and diced to make business sense. Queries were optimized by building Materialized views. This was all done under the Ralph Kimbal methodology of Data Warehousing. Oracle Corp., 09/98-05/02

Sr. Principal Consultant: Primary Assumed role: Project Manager. Secondary roles: ETL Analyst, BI consultant, Data warehouse architect, Data Modeler, Report Writer, Requirements gatherer and Systems Integrator

● Achieved higher customer satisfaction as a Technical Manager for a $2 million project by converting legacy energy revenue reporting applications to Oracle at Kerr McGee, Oklahoma City, OK. Grew sales volume by at least 30% by leading a staff of 3 developers and 2 Business Analysts to build a Dealer Analysis application to help understand product mix and value lines at Interstate Batteries, Dallas, TX. Immigration Status: US Citizen Contact#: 678-***-**** email: ade3rn@r.postjobfree.com

Contact this candidate