Raghav Arora

Developed a data pipeline to transform data from CSV to Parquet and later push it to Impala. Further, reports were automatically published via PowerBI. To automate this process, I used the Oozie workflow and Hydra framework.

An automation script to track virtual machine usage. I acted as an automation developer in this project where his script used to track machine usage and based on which automatically sends an email to users at different times like after 60, 85, and 90 days. If no action is taken by the user, the machine gets decommissioned automatically.

Helped transition request and support forms to BMC Helix. It was done by understanding the following requirements:

• The existing functional process
• Gather requirements for the new process
• Technical capabilities
• BMC Helix limitations
• Scope for automation
• Collaborating with architects, businesses, and PMs
• Team setup for workflow designing and automation
• Timely progress update

Automated different tasks in virtual machine automation like assign, un-assign, decommission, and machine state. End-to-end automation was done with the help of PowerShell, VM APIs, Active Directory, and SCCM.

Integrated all scripts with Ansible Tower (AWX) and used AWX API in MVD application to invoke tasks.

Acted as the lead for cloud transformation and did the following to achieve it:

• Defined the automation strategies and clear guidelines in transitioning infrastructure to cloud environment.
• Implemented the 3 Musketeers pattern including Docker, Docker Compose, and Make to automate data gathering and wrangling with Jenkins Pipeline on AWS.
• Developed Soap API automation packs using SoapUI and integrated them with Jenkins Pipeline.
• Enabled log back in automation scripts and integrated it with EFK—Elasticsearch, FluentD, and Kibana.
• Converted existing end-to-end automation scripts into the component level.
• Led a team of three members.

To ensure cloud infra stability and before moving clients to prod env, proposed to go ahead with like to like testing by comparing two environments output. It was achieved by doing the following:

• Created a pipeline to fetch logs from Splunk using Splunk API, transform them, and store them using Python.
• Automated verification process for comparing 50,000+ responses on a daily basis using xmldiff and a customized Python script.

Acted as an individual contributor for this project. This application was developed as a single source of truth for all the user data. The client can subscribe to the data for any source, using any mode. Automation was needed to ensure all data sources and connections were working fine.

I developed an automation framework from scratch to ensure all the data sources and connections are working fine in an application. After that, an email was sent to all the business people for any failure or success. In case of failure, the bug was supposed to be logged and assigned to the developer.

Developed an automation framework using Java, Cucumber, Selenium 3.0, and TestNG. I also conducted the development and maintenance of Java-based automation test scripts and was involved in the development of automation test scripts using Ranorex with C#.

I was in charge of planning—the creation of test strategy, TRA, TDRA, implementing and coordinating testing activities like test plan and test creation, execution, and test analysis, and defect management. Conducted team-leading activities, such as guiding the team members with the functional specification and stakeholder management. Created the POC using Cypress, Mocha, and Chai.

Automated end-to-end automation and bug lifecycle flow using Jenkins, Bitbucket, Jira, and Zephyr. Understood the technical and functional specifications and implemented project plans within deadlines. Contributed to all aspects of testing, including functional, regression, and database.

Created an algorithm to do bug triaging using Jira API, multinomial Naïve Bayes algorithm, and snowball stemming.

Performed sentiment analysis by scraping RBS news using Beautiful Soup, Selenium, and Vader and visualizing via WordCloud.

Developed automation framework for the BWS Android app using Java and Appium. Integrated the automation framework with BrowserStack to test the app on multiple devices. Created an Azure pipeline to achieve seamless execution of app automation.

Joined the startup as its first QA engineer to create QA processes and strategies. Communicated with founding members and department heads to discuss timelines and development pipelines. Automated sanity and regression suites for API and UI. I also performed security testing.

Framework to automate static, streaming, and historical market data, by automating following below steps:

• Subscribing to API for data.
• Parsing data in XML and JSON format.
• Loading data to Oracle Database.
• Running SQL queries to figure out the difference between two data providers.
• Analyzing results manually.

Scrapped the following data from asx.com.au and investing.com using Python, Beautiful Soup, Selenium, Proxy, Captcha API, and MySQL:

• Announcements
• Earning Calendar
• Dividend Calendar
• Economic Calendar
• IPO and Floats

Developed a web crawler using Excel, Python, Beautiful Soup, JavaScript, and Proxy to track thousands of patent application statuses and update them on a daily basis. Application status needed to be checked from six different country websites.

Scrapped property data listed on Indian real estate websites like 99acres.com and magicbricks.com using Java, Selenium, and Excel. To remove logos from the images fetched from the real estate website, I used OpenCV.