• Developed test plans and test cases for API Testing and performed functional testing based on business requirement on HTTP request and response, subsystem calls, log file and events of different advertiser listings in Web, Mobile Web and Mobile App.• Automated API test cases using Ruby and Cucumber framework and ran regression test before each release.• Created UI test scenarios and verified changes on the advertiser web and mobile landing pages using various browsers, new mobile landing page templates and internal GUI for A/B Testing of different landing page templates. Knowledge of Selenium automation framework. • Retrieved test data in Oracle using SQL and created or modified test data if the required one did not exist in DB.• Wrote Hive queries to retrieve data in search, impression and ad click events and verified the data was correct after joining with events in the pipeline.• Participated in End to End Testing with external teams to verify the advertiser listings displayed on yp.com and m.yp.com and events were fired correctly for reporting.• Supported stage, sandbox and production releases and ran smoke tests on each environment after release.• Logged the defects through Jira and identified any errors or exceptions in log file. Worked with developers to resolve the defects and retested the fixes.• Communicated with Product Manager to understand the business requirement and raised the questions if not clear.• Used Jenkins as the CICD tool to promote new builds from developers to QA environment.• Participated in Scrum sessions, Sprint Planning, Backlog grooming and Project Releasemeetings.• Documented the QA test approach in wiki.

• Created production and ad hoc reports by querying millions rows tables from Oracle and validated the reports to fulfill user requirements.• Participated in report migration from legacy reporting platform, Actuate, to new reporting platform, MicroStrategy by evaluating the active reports, identifying the gaps between legacy against new Data Mart and preparing the Product Requirements Document.• Implemented MicroStrategy reports and freeform SQL reports using MicroStrategy Desktop, created new metrics, prompts, filters and templates and used pass-through functions in metrics and filters definitions. Built ad hoc reports in MicroStrategy Web.• Project lead for the MicroStrategy Report and Data Dictionary web application using PHP and JavaScript to enable search capabilities on available MicroStrategy reports and dashboards for all Yahoo!s.• Project lead for the Integrated Ticketing Interface web application to consolidate multiple ticketing creation sites into one for the team in order to improve the ticket tracking and prioritization efficiency.• Project lead for identifying and decommissioning inactive executable files in legacy reporting system in order to improve CPU and disk space utilization and prepare for migration. • Administrated on user creation/alternation, grant user privilege roles and permission on various reports in Actuate BI Tool.• Responsible for assigning tickets to the team members and organized training for the new team members.

• Developed and deployed the listing tracker application to increase the efficiency of getting listing information from different sources and help to improve data quality by diagnosing inconsistency of data, comparing up to five different listings and removing the duplicated records through data tracing. • Implemented the job tracker application to easily monitoring job status in development and production environments and discovering failure of jobs quickly.• Improved the visualization of job dependency by representing jobs in graph through Graphviz.• Applied different DBI to extract data from Oracle, PostgreSQL and MySQL.• Built web application using Ruby on Rails MVC framework, HTML, CSS, JavaScript and Ajax on Linux platform.