Vijaya Chitta

ac2sfs@r.postjobfree.com 408-***-****)

OVERVIEW:

Have 3+ years of industry experience. Worked at Apple Inc. as QA analyst for about a year. Tested www.apple.com launch project. Active Freelance Quality Analyst at utest.com for about 3 years. Bronze Functional Tester and Gold Rated Usability Tester at uTest.com. Chosen as Favorite Tester by several clients of uTest.com. Tested products, continuous build cycles, mobile applications, web applications and websites. Have about 1 year of industry experience in Data Warehousing with Informatica 9.0.1, SQL and PL/SQL with Oracle 10g. Have fairly good knowledge in Java. Have familiarity with Agile methodologies. Have excellent communication skills.

OBJECTIVE:

Seeking position as a Quality Analyst.

EDUCATIONAL QUALIFICATIONS:

Masters degree in Computer Applications, Osmania University, India

SOFTWARE SKILLS:

Testing Websites, Mobile applications on iOS/Android devices, Web applications

Web Services Testing SOAP UI, REST API

Database Oracle 10g

Languages SQL, PL/SQL, JAVA, XML, CSS3, HTML5, Java Script

Application/Web Server Tomcat

Operating system Mac, Windows 7/8/10, Linux, Unix, iOS, Android

Test Management Tool JIRA

Tools XCode, iTunes, Charles, Text Expander, QuickTime Player,

Android File Transfer, Attache’, Airwatch, Kaleidoscope

4/2017 - 9/2017 QA Analyst at Hogarth Worldwide Inc

Client: Apple Inc., Sunnyvale (Unit: MARCOM QA)

Duration: 6 months

Functional, Layout, Performance and Regression testing of apple.com website on Mobile and Desktop.

Responsible for testing new releases on Apple.com. Worked on Launch Project WWDC(iPad Pro 10.5), Launch DM’s(testing Direct marketing emails), CA/ALAC(testing GEO pages before going live on Geo’s), Web Edit(testing on Production environment).

Tested and reviewed prerelease pages against a list of internal standards, filing bug for all issues, and providing QA approval before the pages go live

Intensively worked on Apple’s in-house tools, apps and processes

Performed Web Analytics testing using Charles

Tested various builds in integration, staging, and production environment

Tested web pages across various platforms (El Capitan, Yosemite, Mountain Lion, Win 7/8/10), browsers (Safari, Chrome, IE, Firefox, Edge) and devices (iPhone, iPad, Mac, Galaxy S7, Pixel, Nexus, Surface)

Evaluated HTML, CSS and JavaScript code and identified the affected pages to be validated using scripts to isolate the bugs

Performed Accessibility testing on browsers and iOS devices

Performed functional testing to ensure page layout, image alignment, video controls across view ports.

Tested hundreds of URL redirection rules written in complex regex

Tested thousands of image assets using automated tools to Apple's pixel-perfect standards

Worked very closely with QA leads and Production Managers to review and prioritize bugs

Environment and Tools:

Internal Automation Tools, AirWatch Tool, Android File Transfer, Text Expander, Charles, Attache',

Mac OS X, Win 7/8/10, Android & iOS Devices, Kaleidoscope, Quick Time Player.

7/2016 - 9/2016 QA Engineer at TEKsystems

Client: Apple Inc., Sunnyvale (Unit: MARCOM QA)

Duration: 3 months

Cross browser Desktop and Device testing of apple.com website

Responsibilities:

Test pages with multi media, animations, parallax effects on all viewports

Test on several iOS and Android phones and tablets, native browsers.

Test on desktops, remote machines in lab and remotely

File and verify bugs using in-house defect tracking tool

Participate in QA approvals

Test emails on all mail clients on Android and iOS devices.

Participate in Functional Testing, Regression Testing, Performance testing, Layout testing

Test Geo Alt pages specific to different locales

Test bandwidth throttle using Charles

Use Web Analytics to measure traffic and time spent on specific pages

Tested on various versions of Lab machines, devices, mobile and desktop Operating

Systems and Browsers.

9/2014 - Till Date: QA Analyst (Freelancer) at utest.com

Projects: Websites, Web and Mobile application testing

Project description:

Functional and exploratory testing of websites, web applications and mobile applications

Usability testing and submit usability surveys

Submit Test Cases and Test Reviews

Test early releases and continuous test cycles in short sprints.

Pre production testing and Beta testing

Find and report bugs and submit them through uTest Bug Tracking system

Test on several browsers such as Safari, Firefox, Chrome and Internet Explorer.

Products tested span across several domains such as educational, media entertainment, healthcare, travel, financial, gaming, restaurant, social and communications, retail and E-tail, real estate, audio streaming, QuickTime videos

Knowledge of installing and updating iOS and Android applications. Knowledge of installing and updating applications on Mac and PC.

OS upgrades on mobile and desktop.

Responsibilities:

1.Did web and mobile application Exploratory testing, Functional testing, Regression testing, Usability testing, UI testing, Performance testing

2.Reported Functional, Technical, UI bugs

3.Submitted Usability surveys

4.Submitted review for every build for continuous test cycles

5.Extracted console logs, crash reports from mobile devices (iPhone and iPad) for reporting bugs

6.Installed various non-public iOS apps using QR Code and .ipa files

7.Communicated with Test Team Leads and Project Managers for various project related issues.

Environment and Tools:

Mac OSX 10.9.5, Windows 7, iOS7+, iOS8+, iOS9+, XCode, iPhone, iPad, iTunes, Various browsers such as Chrome, Safari, Firefox

3/2011 - 3/2012 Elite Technology Partners, LLC (NetLogic Solutions Inc.), Santa Clara, CA

Client: U.S. Bank, San Francisco, CA (1/2012-3/2012)

Project: Customer Product

All the existing U.S. Bank customer data had to be migrated from Informatica to SFDC (Salesforce) using Informatica mappings and ETL.

Responsibilities:

1.Implemented Informatica Mapping for the different stages of ETL.

2.Fixed the invalid mappings and troubleshoot the technical problems.

3.Worked on performance tuning by identifying the bottlenecks at sources, targets, PowerCenter transformations and sessions.

4.Handled Autosys jobs.

5.Modified Unix Shell Script for data extraction from raw data files for different teams.

6.Migrated Informatica mappings, sessions and workflows from development environment to UAT and production environment.

7.Migrated large volume of data into Salesforce doing upserts based on id in SFDC.

8.Performed unit testing at various levels.

9.Tested mappings using bulk data in UAT and deployed mappings to production.

10.Coordinated with different teams for requirements.

11.Wrote deployment documents. Worked on filing tickets and providing solutions.

12.Worked with large volume of data. (50 million records with 1 TB)

Tools and Environment:

Oracle 10g, Informatica 9.0.1, Salesforce, Winscp, Linux, putty, Windows 7, SharePoint

3/2011 - 12/2011 Elite Technology Partners, LLC (NetLogic Solutions Inc.), Santa Clara, CA

Project: HR Schema

Extract data from HR Schema and load the data into the target table EMPLPYEE_D_T1 using SCD type-1, type-2 and type-3 load.

Responsibilities:

1.Joined all the tables from HR Schema.

2.Created the target table EMPLOYEE_D_T1.

3.Created a procedure EMPLOYEE_D_T1_P to extract data from HR source table based and load data into the target based on the mapping document.

4.Wrote the logic in PL/SQL to extract data.

5.Developed several complex mappings in Informatica. Made use of variety of PowerCenter transformations, Mapping parameters, Mapping Variables, Parameter files in mapping Designer.

6.Developed workflows with Worklets, event waits, conditional flaws, email, and command tasks using Workflow manager and monitored them in workflow monitor.

7.Performed unit testing at various levels of ETL.

8.Integrated all the mappings and session and created worklets and workflows in the application folder and setting dependencies between the workflows.

9.Handled exceptions and performed unit testing.

10.Repeated the same objective for all three types of SCD's (SCD type-1, SCD type-2 and SCD type-3) and unit tested all the three types.

11.Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions.

Tools and Environment:

SQL Plus, Unix, Oracle 10g, Informatica 9.0.1, Winscp, putty, Windows 7, OLAP, OLTP, Star Schema, Snowflake Schema

COURSES COMPLETED

1. Introduction to SQL (De Anza College CA): Introduction to Oracle SQL, DML processing techniques, DDL techniques, selecting and sorting data, Joins, SQL functions, Oracle objects, Oracle data processing concepts to maintain large database systems and reports.

2. Advanced Java Programming (De Anza College CA): Emphasis on foundation technologies in Java that enable us to write server side programs in Java. Concepts include Inner classes, Collections, Exceptions, File I/O, Reflections, Cloning, Multi-threading and Socket programming.

3. Distributed Processing Using Java (De Anza College CA): Distributed computing using Java, JDBC, Sockets, Java Servlets, Java Server Pages, RMI, XML Parsing and transformations, Introduction to Web Services

4. Selenium with Java (Santa Clara Adult Education): Selenium Web driver with Java, JUnit, POM, XPath, CSS

REFERENCES: Available on request

Contact this candidate