SUMMARY:

• Summary/14+ years of experience as an SDET and QA manager working on a wide variety of projects, most notably for Microsoft, Yahoo, and Bank of America.
• Experienced in end - end testing of Business Intelligence software from testing data sources, ETL, data warehouses, and reporting software for multiple projects at Microsoft, The Bill and Melinda Gates Foundation, and Bank of America.
• Extensive experience in Object-Oriented programming in C#
• Last project was in a Big-data environment and SAP Business Objects for the Data Warehouse.
• 6+ years of experience in developing automation testing framework
• Utilized open source technologies in an enterprise environment (Linux, Apache, MySQL, Java) in last project.
• Extensive experience using configuration management tools including Octopus, and Metal tool (for ETL).

TECHNICAL SKILLS:

• TeraData Data Warehouse, SAP Business Intelligence, Informatica
• SSIS/SSAS/SSRS, SAP Business Object, ETL Process
• Data Migration, Replication, Teradata, Universe Design Reporting System
• Microsoft SQL Server 2012/2008, Oracle, MySQL, DB2, T-SQL, SQL
• PL/SQL, VSTF, OOP, Java, J2EE, JBOSS, JMeter, Websphere
• Apache, C++, C#, ASP.NET, VB.NET, XML, Perl, PHP, Flash
• Visual Studio 2012, Windows 7.0/8.0, MS .NET environment
• Source Depot, UAT, Quality Center, JIRA, TFS, Bugzilla
• SharePoint, SOAP, RESTful, Web Services, TCP/IP, Octopus, Metal tool, Ingeniux, SDLC, Agile

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Sr. SDET QA Lead

Environment: /Tools used: Business Intelligence, Cosmos (Big Data) Data Warehouse, SAP Business Intelligence, SAP Business Object, Universe Design Reporting System, Microsoft SQL Server 2012/2008, VSTF, Visual Studio 2012, SSIS/SSAS/SSRS, Windows 7.0/8.0, MS .NET environment, ETL Process, Data Migration, Replication, ETL process, Source Depot, UAT, Quality Center for managing bugs and creating Test Cases, Selenium Web Driver, SharePoint, Open source Java, Linux, Apache, MySQL, Agile Methodologies

Responsibilities:

• Worked with Dental ETL Process to handle data validations for the providers, eligibility, groups, patient treatments, claims, payment processing on a Big-Data environment.
• Designed and developed Automation testing framework
• Created and managed the functional test plans/test cases and testing cycles to validate from data sources, staging, ODS -ETL transform, data marts, cubes, to reporting system.
• Created the BI testing process and release process to work consistently with release management, development team, and product support.
• Worked with SSIS, SSAS, and SSRS to run the SQL jobs, validate the analysis data and reports.
• Worked diligently with managers, development, and test teams to analyze all requirements; and to design documents to ensure consistency among all requirements.
• Managed to escalate and resolve complex technical issues to millions of external users by tracking the Escalation Tools and communicated through Exchange server.
• Set up Quality Center to track all the requirements, test cases, defects, and testing reports.
• Worked with SAP Business Intelligence tool to design the Universe reporting system and testing by validating the generated reports via Webi and SQL queries.
• Designed and developed Automation testing framework from scratch for Selenium Web Driver using C# and Java.
• Managed the testing cycle to provide the test methodologies include BVT, functional, performance/load, data validation, referential integrity, security, regression, end to end testing.

Confidential, Redmond, WA

Senior SDET QA Lead

Responsibilities:

• Created test plans and test scripts to validate the prepaid in store activation process in different environments (test, staging and production) for the prepaid and postpaid customers.
• Worked diligently with Project/Product Managers and Dev/Test teams to analyze/review the requirements through the Scrum/Agile methodology to create requirements for sprints.
• Managed the UAT team to validate the operations project working with third party, GLG to integrate the web content before releasing to production.
• Hands on validation the CQ5 web content management tool to create the web templates for MyMobile, phone, internet, handheld devices, and security before releasing to production.
• Managed and logged the all defects in Quality Center to keep track of the resolution, priorities, and severities when running the bug regression and sent daily status reports.
• Created complex SQL scripts to validate backend features ensuring data worked properly.
• Worked with LoadRunner to run the performance/load testing.
• Created test processes, allocated resources, reviewed the project requirements.
• Assigned/guided tasks to teams and worked with other project managers/dev managers.
• Set up team meetings for status updates and monitored the team activities.
• Created the lead data exchange test scripts to include the requirements for end to end testing.
• Designed and developed Automation testing framework from scratch for Selenium Web Driver using C# and Java.
• Worked with PM, Dev, and Test teams to make sure all the requirements and test scripts are implemented and tested consistently.
• Ran the UAT scripts to verify and validate the requirements in UAT environment for Phase 1.
• Provided technical expertise to test team to perform the load testing with 500 users using AIMS system to generate tickets concurrently.
• Monitored the Product Studio bug tracking system to verify all bugs haven been logged, reviewed, and resolved.
• Worked on the test strategies for CAP system for integration with AIMS, BizTalk system, and Yahoo CRM system.
• Set up the Sharepoint site that is up and running with the Dev and PM teams to allow Yahoo and Microsoft to exchange lead data files.
• Granted access to team and Yahoo for users to upload and download the data files.
• Analyzed specs, schema flows, data mappings for Yahoo data exchange, AIMS, CAP, Biztalk and created test strategy.
• Set up and monitoring the bugs and triage them with Dev/PM team in Product Studio system.
• Worked with AdCRM and AIMS UI applications to verify the database fields on the UI.
• Created the Lead data CSV files to support the Dev and SMART warehouse team and Yahoo team.
• Worked with AdCRM database test server and set up local database server for running test data.
• Attended daily stand up meetings and meetings for Yahoo lead data exchange and Ticketing.
• Executed the UAT scripts for AIMS in UAT environment.
• Business Intelligence data warehouse Project
• Managed and coordinated the BI projects with offshore teams.
• Worked with clients using Informatica to extract data from Oracle database to import data to SQL server.
• Worked with Microsoft SQL 2008 to create test databases and Metal 3.0 tool for ETL process to create the SQL jobs and executed them to load data from different sources.
• Worked with Octopus deployment tool to install and configure builds into SQA test environment.
• Extensive system testing with Sincera automation tool to validate the data and schema from backend database and created many complex SQL test scripts to verify.
• Created and ran queries in Oracle databases to validate complex business rules from clients.
• Created and executed test plans and test cases for Business Intelligent data warehouse Projects, created complex SQL test scripts to perform the schema validation, data validation and row counts from source data to staging then to integration (data mart databases to sync with OLAP Cubes), and to distribution for publishing different types of Reports (SSRS, PPS, Proclarity, Excel) to Sharepoint portal.
• Conducted the system and integration testing (SIT), stress and volume testing, user acceptance testing, and final regression for end to end testing.
• Worked with VSTF (Visual Studio Team Foundation) to manage bugs and issues, test cases and source code.
• Work with Scrum Agile project life cycle.
• Created test processes, allocated resources, reviewed the project requirements.
• Assigned/guided tasks to teams and worked with other project managers/dev managers.
• Set up team meetings for status updates and monitored the team activities.
• Managed the testing cycle to provide the test methodologies include BVT, functional, performance/load, data validation, referential integrity, security, regression, end to end testing.

Confidential

Senior SDET/ QA Project Manager

Environment: /Tools used: Microsoft SQL Server 2005, WCF/ASMX, MS .NET environment, SQL DB Administration, DTS packages, Data Migration, Replication, ETL process, Source Depot, Selenium, software engineering process environment of SEI/CMM, UNIX/Linux, XML/SOAP, Java, Perl, SkyTap Virtual Machines with VMWare, Mercury Quality Center for Managing Bugs and creating Test Cases, Windows XP and SharePoint, VPN, Audio/Video, Interfaces, FTP, Wireless, Tomcat, Java, J2EE application servers, JBoss, Websphere MQ Series, DB2 and SQL Server, Viper project management, Pathfinder home loan pricing and processing, JIRA

Responsibilities:

• Coordinated the BI projects with offshore teams.
• Designed and developed automation testing framework and scripts for Selenium using Java.
• Worked with clients using Informatica to extract data from ORACLE database to import data to SQL server.
• Created and executed test plans and test scripts for weekly releases to production by working with Pathfinder home loans pricing and processing tool for different types of loans (30 year fixed loans, ARM loans, 15 year fixed loans, etc.) and packaging those loans to sell to investors.
• Performed regression tests to process consolidated loans and conforming ARM loans and verified test results with databases in SQL server 2005.
• Extensive system testing for ecommerce web site for many customer orders, process and ship them to different locations in the world.
• Strong understanding with SQL database, VB scripting and UNIX for QA testing different applications.
• Developed and maintained the automation test scripts to perform regression tests for releases.
• Grey box testing for all the code release including SQL stored procedures, code functions to be tested and debugged.
• Strong understanding of project life cycle, good communication skills, and great experience with multi-tasking.
• Good experience with defect tracking tools and automation of test cases and scripts.
• Managed the test databases and deployed code release to QA environment and configured all test locations.
• Worked with Viper project management tool to track all the projects, tasks and statuses for each release.
• Managed the Quality Center to keep tracked of business requirements, test plans, test scripts, bugs, and reports.
• Worked with LoadRunner to run the performance/load testing.
• Processed and validated 10 million of loans successfully before releasing to production.
• Managed the offshore test team of 8 resources in India to perform the entire BI data warehouse and reporting.
• Created test processes, allocated resources, reviewed the project requirements.
• Assigned/guided tasks to teams and worked with other project managers/dev managers.
• Set up team meetings for status update and monitored the team activities.

Confidential, Seattle, WA

SENIOR SDET LEAD

Responsibilities:

• Designed and developed automation testing framework for Selenium using Java.
• Developed and maintained automation test scripts to perform regression tests for all releases.
• SQL database tested successfully with stored procedures and tables for the Bill and Melinda Gates Foundation that gives money grants to charity organizations for different areas such as education, public library, and global health in the United States and different countries.
• Tested ETL backend for different source databases (GIFTS, EasyGrants, Great Plains, contract management, and enterprise reporting) that replicated to ODS Reporting database and then DTS process to transform the data to DataMart.
• Tested the GIFTS application/database that stored all the organizations information about approved grants, scheduled payments, transferred payments to Great Plains where all the approved payments are being processed and transmitted to the organization's bank.
• Worked with clients using Informatica to extract data from Oracle database to import data to SQL server.
• Worked with LoadRunner to run the load/performance/stress testing.
• Extensive system testing for ecommerce web site for many customer orders, process and ship them to different locations in the world.
• Strong understanding with SQL database, VB and UNIX for QA testing different applications.
• Grey box testing for all the code release including SQL stored procedures, code functions, and methods to be tested and debugged.
• Created test plans and test cases for database backend and front end testing by reviewing the software requirement documents and technical specifications.
• Worked with QA/Development/Program Management teams to ensure all the business rules, validations and requirements worked consistently.
• Created test processes, allocated resources, reviewed the project requirements.
• Assigned/guided tasks to teams and worked with other project managers/dev managers.
• Set up team meetings for status update and monitored the team activities.

Confidential, Redmond, WA

SENIOR SDET LEAD

Responsibilities:

• Worked with clients using Informatica to extract data from Oracle database to import data to SQL server.
• Worked with Web Runner for running web automated scripts.
• Developed and maintained the automation test scripts in C#, Visual Studio in .Net to perform regression tests for all the releases.
• Worked on the Microsoft Order Validation Engine that validates all the orders of Microsoft Products (Microsoft SQL Server, Xbox, Office XP, Windows XP, Visual Studio and other Microsoft servers).
• Tested back end and front end for Microsoft Partner Program-MSPP (Certified Partner, Gold Certified Partner and Converted Partner) and System Integration with UPP (Unified Partner Program applications diligently with good quality and successfully delivered to Microsoft UAT (User Acceptance Test) and Production site.
• Created Queries to run in Oracle server database to validate the business rules from the clients.
• Managed a team of 11 members to perform daily tasks including database validation, UI validation, end to end testing, creating test cases and test planning.
• Extensive system testing for ecommerce web site for many customer orders, process and ship them to different locations in the world.
• Strong understanding with SQL database, VB and UNIX for QA testing different applications.
• Gray box testing for all the code release including SQL stored procedures, code functions and methods to be tested and debugged.
• Worked with Load Runner to run the performance/stress/load testing.
• Good experience with defect tracking tools and automation of test cases and scripts.
• Created and executed detail Test Cases for MSPP project in Product Studio.
• Tested payment center for processing partner invoices by credit card, check and wire transfer payments with tax ware for different countries with localized languages.
• Attended weekly triage meetings with test, development and pm teams.
• Installed builds for code drops, SQL database and MSOps Service application.
• Backed up and restored the SQL database for different environments in Corpnet and Extranet.
• Created the Transact-SQL stored procedures and test queries to validate all the functionalities of different orders using business rules for retail, distributor and microsoft licensing orders.
• Created master test plan and test cases for system integration testing, user acceptance testing, and production testing.
• Managed and prioritized bugs to assign to developers to resolve them.
• Scheduled and attended weekly triage meetings with Test, Development and PM teams.
• Served as Test Team Lead of four QA/Test Engineers.
• Held regular status updates and meetings to coordinate progress with both teams.
• Performed smoke, stress, performance, security, benchmark, and BVT Tests.
• Strong understanding with SQL database, VB scripting and UNIX for QA testing different applications.
• Participated in (Software Development Life Cycle-SDLC) all of the planning phases of a software development process and done risk assessment as well as time and cost estimation on a great deal of projects within budget and on time deliveries.