Cloud Data Analyst
Resume:
Shivdeep Singh
Alameda, *****
**********@*****.***
PROFESSIONAL SUMMARY
Experienced working in AWS cloud computing platform and many dimensions of scalability including EC2, S3, EBS, VPC, AMI, SNS, RDS, IAM, Route 53, Auto scaling, Cloud Front, Cloud Watch, Cloud Trail, Cloud Formation, Security Groups. Creation of Templates in Cloud Formation.
Experience with Cloud automation technologies such as Cloud Formation and Terraform. Experience on Ansible and Ansible Tower to automate repetitive tasks, to deploy critical applications quickly, and proactively manage the changes and wrote many playbooks to manage Web applications.
Implemented cluster services using Docker and Kubernetes to manage local deployments in Kubernetes by building a self-hosted Kubernetes cluster using Terraform, Ansible and deploying application containers.
Implemented cluster services using Docker.
Worked on the branching and build/release strategies using SCM tools GIT and also experienced in migrating GIT repositories to AWS.
Highly analytical and process and object oriented data analyst with in-depth knowledge of database types; research methodologies; curation, manipulation and visualization. Extracting data from Data servers. Furnish insights, analytics and business intelligence used to advance opportunity identification, process reengineering and corporate growth. Working on Relational Schema's and ETL techniques.
Academic experience of creating ER diagrams and making relation schema out of that. Used Apriori association in R studio to identify interesting association rules in the data set. Successfully implemented Naïve Bayes, Knn classification, and decision tree in R. Created heat map and bar charts in Tableau for visualization. Shell Scripting, Linux troubleshooting,
Orchestration-Dockers
VPC
EC2
S3
EBS
AMI
RDS
IAM, Route 53
Auto scaling
SQL, Transact SQL
R
JavaScript
Python
Cloud Front
Cloud Watch
Cloud Trail
Cloud Formation
Security Groups
SKILLS
EXPERIENCE
Database Analyst 07/2017 to 11/2018
Mid West Transport Apple Valley, CA
Writing SQL Queries and maintaining Databases, Extracting data from Microsoft SQL Server Database.
Organized and participate in lean events and focus group meetings Developed and maintain Standard Operating Procedures (SOPs), which include workflow diagrams, documented processes, and time frames.
Updated data and report metrics weekly, monthly, and quarterly on work performed within the transportation teams
Compiled data and send reports to sponsors every month. Develop & implement cost reduction and work process improvement projects when addressing vendors, carriers and other pertinent business partners. Work with management to help prioritize business and information needs. Conduct analysis, identify key insights and formulate data-driven recommendations to optimize the business
Database developer/Devops 12/2018 to 09/2019
Motor Vehicle Software Corporation Agoura Hills, CA Writing SQl queries and knowledge of Transact SQL. Maintaining Databases, Extracting data from Microsoft SQL Server Database.
Designed and created databases.
Wrote scripts to automate software update and deployment. Created AWS CloudFormation templates to create custom-sized VPC, subnets, EC2 instances, security groups. Worked on other AWS Services like Cloud Front, cloud watch, RDS, S3, Route53, Cloud Trail and also Worked on Simple Storage Service (S3), Simple Notification Service (SNS) and CloudWatch.
Used API's, chef, python and AWS CloudFormation Templates, migrated and automated cloud deployments.
Experience working on several Docker components like Docker Engine, Docker Hub, Docker Machine, Docker Compose and Docker Registry.
Experience with Ansible to automate repetitive tasks, deploy critical applications, written Ansible Playbooks using Yaml for Maintaining Roles, Inventory Files. Provisioned EC2 instances, configured auto-scaling and defining cloud formation JSON templates using Ansible modules.
Worked with Terraform key features such as Infrastructure as code. Experience with Cloud automation technologies such as Cloud Formation and Terraform for building, changing, and versioning infrastructure
EDUCATION
Master's: Information Technology 05/2019
California Lutheran University Thousand Oaks, CA
Emphasis on Data Management
OPERATING SYSTEMS
Linux (Red Hat 4/5/6/7), UBUNTU, WINDOWS
DATABASES
My SQL, MS Access, DB2, NoSQL (MongoDB, DynamoDB)
Contact this candidate