Rohit Agrawal

About Rohit Agrawal

Bachelor of Engineering in Information Technology (IT) with 14+ years of experience in Testing, Debugging, DevOps, Cloud Infrastructure and Applications, Big Data, Product & Program Management, People Management, Configuring and Implementing software applications for E-Commerce and Telecom domain. Hold H1B Visa for the USA.Presently working with Oracle as Principal Member of Technical Staff in FAW-NAW Team of Oracle Analytics Cloud. Certified Oracle Cloud Infrastructure 2021 Associate with thorough knowledge of Cloud Infrastructure like load balancers, networks, application, object storage and underlying mechanism. Well versed in Unix/Linux, Shell Scripting, Oracle, SQL, Big Data, Hadoop, Cloud Infrastructure, Dockers, writing and executing test cases, Bug reporting and tracking. Good with Terraform, Kubernetes, Grafana, Presto, Solr, Hadoop, Kafka, ActiveMQ, PostgreSQL, Telemetry, Oozie, Zookeeper, Pig, Hive, HTML, UI Automation using Selenium WebDriver, TestNG, API automation using Rest Assured Framework and NoSQL like MongoDB, DynamoDB. API development using SpringBoot. Testing experience includes Grey Box, Black Box, Usability, UI, Android App, Desktop, M-site, Cloud Applications, Functional, System, Regression, Performance, Integration, Smoke, Sanity, Database, API Testing Automation using Rest Assured Framework, Front-end Automation using Selenium WebDriver / Selenium Grid and Backend Automation with Oracle/MySql/MongoDB/DynamoDB as back-end database in Unix Environment. Product & Program Management, Customer handling and management with onsite experience. Expertise in debugging and root-cause analysis with Passion for figuring out why software fails and for communicating and executing efficient repair plan. Extensive work experience on Agile, Scrum and Waterfall Models. Setting up of Hadoop Clusters, Big Data Testing. Used Crystal Reports for creation of reports and data extraction. Implemented various Softwares, Change Requests (CR) at customer location (onshore as well as offshore). Experience in Bug Tracking tool Sim, Trac, Jira. 5+ years of experience in People Management as QA Lead.

Experience

1. Principal Member of Technical Staff

   Oracle

   Apr 2019 — Present · Bengaluru, IN

   Working as Principal Member of Technical Staff in FAW-NAW Team of Oracle Analytics Cloud. • Certified Oracle Cloud Infrastructure 2021 Associate with thorough knowledge of Cloud Infrastructure like load balancers, networks, application, object storage and underlying mechanism.• Created API using spring boot framework to be used in CI-CD.• Owned end-to-end testing of Netsuite integration with OAC and automated NAW (Netsuite Analytics Warehouse) service CI-CD.• Onboarded BEET (Basic end to end testing) framework and set-up Beet Tests to make Oracle Analytics Cloud (OAC) Organisation OCI (Oracle Cloud Infrastructure) compliant.• Performed POC for OCI Test Service framework, Build Service & Dockerized Test suite. Single point of contact for Provisioning, Pipeline, Content and Customisation Teams to onboard this framework.• Identified T2 metrics to set-up Alarms for Oracle Analytics Cloud (OAC) applications including Provisioning, Pipeline, Content and Customisation Teams & infrastructure.• Multi-region deployment through Shepherd based on Terraform.• Performed POC and Set-up Test Canaries for OAC Organisation which was then adopted by all FAW- NAW Teams including Provisioning, Pipeline, Content, Customisation and Infra.• Worked on POC of integration Lumberjack (OCI Logging module) and Telemetry with Test Canary. • Created maven utility to read secrets using Instance Principal and Resource Principal.• Worked closely on Data Warehousing for the Analytics Team.• Created Grafana Dashboards for OAC Org including Provisioning, Data Pipeline, Content and Customisation Teams. This helped in Data Analysis and immediately identifying any abnormality in the pattern.• Actively shared gathered knowledge with Peers across Teams through Wiki pages and zoom sessions.• Wrote various Runbooks for QA-Ops work.

Education

• St. Karens Secondary School

  All India Secondary School Examination

  1994 — 2004

• Kendriya Vidyalaya

  All India Senior School Certificate Examination

  2004 — 2006

• SJCIT

  Bachelor of Engineering (B.E.), Information Science & Engineering

  2007 — 2011

Skills

• Big Data
• Team Management
• Xml
• Black Box Testing
• User Acceptance Testing
• Oracle
• Requirements Analysis
• Regression Testing
• Integration
• Manual Testing
• Eclipse
• Testing
• Core Java
• C++
• Android Apk Testing
• System Testing
• Html
• Software Quality Assurance
• Postgresql
• Mysql
• Agile Methodologies
• Java
• Scrum
• Telecommunications
• Test Cases
• Hive
• Presto
• Java Enterprise Edition
• Test Automation
• Shell Scripting
• Pl/Sql
• Unix
• Hbase
• Databases
• Mobile Applications
• Sql
• Linux
• C
• Hadoop