SUMMARY

Detail - oriented, well-organized, quick-learning and self-motivated team player who is passionate on computer science dedicates to the career in utilizing my strong analytical, problem-solving, and technical skills to help expanding organizational growth and profits.

TECHNICAL SKILLS

Databases: Oracle, MySQL, PostgreSQL, MS Access

Languages: Java, Ruby, Cucumber, PHP, JavaScript, Perl, Ajax, SQL, PL/SQL, Shell Script, HTML, CSS

Business Intelligence: MicroStrategy, Actuate Operating Systems Linux, Windows

PROFESSIONAL EXPERIENCE

Confidential

Senior QA Software Engineer

Responsibilities:

• 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.
• 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 Release meetings.
• Documented the QA test approach in wiki.

Confidential

Software Engineer - Internal Reporting Team

Responsibilities:

• Created production and ad hoc reports by querying millions rows tables from Oracle using SQL and PL/SQL and validated the reports to fulfill user requirements.
• Led the project for identifying and decommissioning inactive executable files (around 2000) and output files (around 3500) in legacy reporting system to improve CPU and disk space utilization and prepare for migration.
• Participated in report migration (around 700 reports) from the legacy reporting system, Actuate, to the new reporting platform, MicroStrategy.
• Led the MicroStrategy Report and Data Dictionary project to build the web application using PHP and JavaScript and test the application to ensure delivery of quality product to enable search capabilities on available MicroStrategy reports and dashboards for all Confidential s.
• Developed and enhanced web-based Sales Dashboards using PHP and JavaScript to provide key performance indicators (KPIs) which allowed users to evaluate different states of achievement against business goal.
• Evaluated the US and International reports in Actuate, identified the gaps between legacy against the new Data Mart and prepared product requirements document (PRD) for report migration.
• Implemented MicroStrategy reports and freeform SQL reports using MicroStrategy Desktop, created new metrics, prompts, filters and template and used pass-through functions in metrics and filters definitions. Built ad hoc reports in MicroStrategy Web.
• Participated in the User Acceptance Test (UAT) and demonstrated the newly developed MicroStrategy reports to the users.
• Generated Actuate usage report for report migration planning and provided the MicroStrategy usage report by using Enterprise Manager to reflect report adoption.
• Led the Integrated Ticketing Interface project to build the web application using PHP and JavaScript to consolidate multiple ticketing creation sites into one for the team in order to improve the ticketing tracking efficiency and prioritization.
• Managed the creation/alternation of users in the system, granted user privilege roles and permission on various reports in Actuate.
• Created operational reports by extracting data from multiple data sources such as Siebel and Bugzilla using Oracle and MySQL to streamline internal processes.
• Responsible for assigning tickets to the team members and organized the training for the new team members.

Confidential

Software Engineer (Summer Intern) - Data Systems

Responsibilities:

• Successfully developed and deployed a listing tracker application to increase the efficiency of getting advertiser listing information from different sources throughout the ETL process 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.
• Developed 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 MV C framework, HTML, CSS, JavaScript and Aj ax on Linux platform.
• Used SVN version control system to maintain current and historical versions of files.

Confidential, Pomona

Student Assistant

Responsibilities:

• Developed, maintained and updated college website using JavaScript, HTML and CSS through Adobe Dreamweaver.
• Kept the correct information in student database and Listserv.
• Collected and analyzed student data and provided accurate Excel reports to the director and coordinators in the department.