Post Job Free
Sign in

Project Microsoft Office

Location:
Dublin, OH
Posted:
January 29, 2018

Contact this candidate

Resume:

Suneetha Lingamneni

804-***-**** ac38iy@r.postjobfree.com

Experience Summary:

** ***** ** ********** ** Software Testing and Test Automation.

Proficient in automation using UFT automation tool, which includes creation of automation plan and strategy document, automation framework creation, scripts development using VBScript, script debugging, scripts maintenance.

Extensive experience in Automation using Ruby & Cucumber automation tool, which includes automation framework creation, scripts development using Ruby programming, script debugging, scripts maintenance and training.

Strong experience in ETL testing using ETL Ab Initio.

Experience in SOAPUI, Selenium with Java and in Continuous integration with Jenkins,

Experience in database testing using SQL, DB2 and Teradata.

Good work experience on UNIX using Putty and on Team Foundation server.

Full life cycle STLC product testing experience.

Extensive experience in Manual (Black box), Regression, User Acceptance, Functional & Sanity Testing.

Excellent experience in writing Test Plan, Defining Metrics/SLAs, Test management, Effort estimation, Status reporting, Reviewing Test Plans, client interactions.

Strong experience in test case design, test execution, test data preparation, defect reporting & tracking.

Expertise in using test management tools QC/ALM.

Good Project management and team leading skills.

Experience in working with offshore teams and onsite-offshore coordination.

Experience in working on Waterfall and Agile Methodologies and in various domains like Banking, Insurance, Microsoft domains.

Technical Skills:

Software Testing Manual and Automation

Programming Language Ruby, Java

Automated Tools SOAP UI, Selenium, Ruby, Cucumber, UFT

Database Concepts SQL, PL/SQL, ETL Ab Initio

Database & GUI DB2, MS Access, SQL Server and Teradata 13.0

Tracking Tools QC/ALM, TFS, Microsoft Product Studio

Operating Systems Windows 7, Unix

Education:

Master of Computer Applications (MCA), - 2000

From University of Madras, INDIA

Project Experience:

Nationwide Mutual Insurance, DUBLIN, OH July 2016 – Till Date

Project: Department of Labor (DOL) - Morgan Stanley Fund Transfer, Fund Withdrawal Information

Role: Lead/Specialist-Testing

The Department of Labor (DOL) is expanding their definition of a fiduciary that has exposed opportunities for Nationwide to solidify existing partnerships and to grow as firms define their fiduciary status. The Morgan Stanley Fund Transfer project and Fund withdrawal information is one such opportunity. Nationwide will provide Morgan Stanley the capability to request real time Fund Withdrawal Information using web-service 212-09 and also the Real time Surrender Quote information using web-service 212-08 for any Policy. Morgan Stanley or any other carrier in future will utilize DTCC Value Inquiry web service to request real time fund transfer related financial information for a Policy. Nationwide will provide a real time response, which can be a success response with the contract financial information or a failure response with no contract financial information, upon request. Based on the Value Inquiry Information Morgan Stanley will choose to submit a request for Fund Transfer, Future Allocation Change to Nationwide using DTCC web services (102, 107,105). Nationwide must respond to the above fund exchange requests real time indicating if we accept or reject the request. If accepted, the transaction(s) will be processed overnight. Nationwide will send the final status (completed or rejected) to Morgan Stanley on Day 2 using the DTCC Confirm File.

Responsibilities:

Monitor the progress of all Stories and update the status of Tasks on daily basis in RTC as part of Agile process

Actively participating in Iteration planning meetings and providing estimates for all testing related tasks

Creating User Stories and Tasks in RTC

Frequently communicate project status to all stakeholders and track the Stories to closure in RTC

Proactively alert management for any impediments and involved in preparation of process related documents and user manuals

Involved in Requirements Analysis

Creating automation framework for DOL Morgan Stanley project

Proactively alert management for any impediments and involved in planning and preparation of process related documents

Creating and reviewing Test plans, Test scenarios, and Test results with the Team

Involved in System, Integration and Regression testing

Preparing Test Scripts using Unified Functional testing tool for IPS IADT application

Preparing automation test scripts for Regression testing

Creating test scripts on Ruby and Cucumber for PALLM Annuity system

Demo Automation framework to product owners and Internal product services teams

Support teams in all Automation Testing related aspects

Participating in Retrospective and Agile meetings

Environment: Windows 7, Main Frames, Ruby 2.2, Ruby Mine 6.3.3, Cucumber, Selenium, JAVA, HP UFT, and Tortoise SVN

CAPITAL ONE, RICHMOND, VA Jan 2015 – June 2016

Project: ATDD Automation Frame work for Enterprise letters

Role: Test Lead/Test Automation

ATDD Framework provides developing routines that can be used to increase stability, decrease down-time, and provide a more reliable experience to the customer. This framework is built for all IFM applications CARD, BANK, Capstone and Rewards. Building ATDD Frame work enables all features teams in EFIT (enterprise fulfilment) to reuse, own and enhance for testing application specific functionalities for letters.

The framework consists of:

ATDD Code built in Ruby Mine using Ruby, Cucumber and Gherkin

Regression Testing capabilities that will reduce the likelihood of new changes negatively impacting existing code

Functional System Testing capabilities that will drive development efforts

Through Acceptance Test Driven Development

Generating html reports using Pretty Face gem

Emailing Test results reports to team

Responsibilities:

Monitor the progress of all Stories and update the status of Tasks on daily basis in Version1 as part of Agile process

Actively participating in PSI planning meetings and providing estimates for each sprint deliverables

Representation of Stand up, Sprint Planning and Grooming meetings

Creating Stories and Tasks in Version One.

Frequently communicate project statuses to all stakeholders and track the Stories to closure

Proactively alert management for any impediments and involved in preparation of process related documents and user manuals for ATDD Framework

Requirements understanding from Enterprise correspondence teams

Preparing Gherkin stories for Test scenarios and creation of Test Scripts

Reviewing Test scenarios, and Test results with the Agile teams1

Involved in System, Integration and Regression testing

Coordinating Dependent teams and developers and making sure that dependencies are not impacting our deliverables

Tracking defects and following up with Enterprise Teams

Worked on Ruby and Cucumber

Demo Automation framework to product owners and Enterprise correspondence teams

Support Enterprise teams in all ATDD Automation Testing related aspects

Participating in all Agile ceremonies

Ensure latest code is checked in to Sub Version repository on daily basis

Environment: Windows 7, Unix, Ruby 2.0, Ruby Mine 7.1.4, Cucumber, SQL, Selenium Web Driver, Team Foundation Server, Putty and Tortoise SVN

CAPITAL ONE, RICHMOND, VA Jun 2013 – Jan 2015

Project: Amex/Discover Cards Conversions to Capital One accounts

Role: Sr Quality Analyst/Test Automation developer

Capital One’s recent acquisition of AMEX and Discover card portfolio has resulted in the need to integrate the systems at AC/DC CRS with those with in Capital One. As a result of this, ACDC Branded Book Portfolio accounts now need to be converted into Capital One account and all the AOs and ALEs that existed on these accounts should be translated or converted into Capital One’s format of AOs and ALEs. Customers will experience an association change and be converted to a MasterCard product during the conversion. New card and PIN numbers will be created with a MasterCard BIN during Dress Rehearsal. Customer facing number (for accounts not receiving new plastics) will be provided via a letter during Dress Rehearsal. Amex/Discover credit bureau data will be “merged” with Master Card data to ensure only one credit line is reported. Agents will be unable to perform a chargeback, retrieval, or dispute on any Amex/Discover transaction. Association Hard Switch will occur Amex/Discover authorizations will be shut down on the same day the MasterCard plastics begin working. For Offer Management Environment, Account-Offers will need to be loaded via a standalone on-demand process. The conversion will start with delivery of files from CRS to TS2 and creation of the accounts in TS2. Once converted, TSYS files will be delivered to the DDE which will consist only of the converted accounts. Offer Management will use these files to create Account offers and Account level exclusion data.

Responsibilities:

Monitor the progress of all Stories and update the status of Tasks on daily basis in Version1 as part of Agile process

Preparing high level scenarios, Test cases and Test Data

Representation of Stand up, Sprint Planning and Grooming meetings

Frequently communicate project statuses to all stakeholders and track the project to closure

Proactively alert management for any impediments and involved in planning and preparation of process related documents

Reviewing Test scenarios, and Test results with the Agile teams

Involved in System, Integration and Regression testing

Coordinating Dependent teams and developers and making sure that dependencies are not impacting our deliverables

Tracking defects and following up with developers

Demo to the Product Owners

Ownership of Integration Testing

Used Ab Initio and Mainframes Jobs for extracting, cleaning, transforming and loading data into Card Data Warehouse(CDW) and Offer Management Environment(OME) databases

Worked on DB Visualizer and Teradata to validate the results/data using SQL queries

Worked on SOAPUI, Ruby, Cucumber, Selenium web driver, Java, ATDD, Service Virtualization for Offer treatment services API Testing

Ensure that delivered solutions match the clients’ original intent.

Environment: Ab Initio ETL, Main Frames, DB2, SOAP UI, Ruby, Cucumber, SQL, Selenium, JAVA, Team Foundation Server, Teradata 13.0, ALM, HP UFT

ALLSTATE INSURANCE, CHICAGO, IL Sep 2011 – May 2013

Project: PQS – PTD

Role: Test Lead

Product test delivery (PQS PTD) is the testing group for Allstate Insurance. Any project implement should be tested and signed off by Product Test Delivery (PTD) before it’s moved to production. We test all lines of business like Auto, Property and specialty lines. The specialty lines include the insurance for the off road vehicles such as Motor Boats, Motor Home, and Vehicles used in desert, etc. There are two applications available with Allstate Insurance for handling the Policy related transactions. They are the Alliance and the Alstar application. These applications will be used mainly used by the Exclusive agents working for the Allstate Insurance Company. The functionality of the Alliance and Alstar will be tested by PQS PTD team. Alliance application is developed in Java/JSP and DB2 is used as the backend. This application use the same database used by the Alstar application. Alstar Application is developed in AS 400 Mainframes system and Back end as DB2.

Responsibilities:

Analyzing Project requirements Creating Test Strategy Plan Reviewing Test plan and Test data creation.

Reviewing Test execution progress, Result Analysis, validation and recommendations, Defect management.

Ensure that delivered solutions match the client’s original intent. Monitor time line and raise risk if there is any deviation.

Frequently communicate project statuses to all stakeholders and representing PQS team in project status meetings.

Proactively alert management to any pending project short falls. Project sync up meetings with stake holders.

Provide test effort estimation and schedule milestone definition. Review project risk and mitigation plans and provide Project metrics dashboard to key stakeholders.

Handle Production defects

Environment: Windows XP, AS400, Java/JSP, DB2, Mainframes, Clear Case, Quality Center 9.0

Microsoft Corp, Dublin, UK Aug 2010 – Jul 2011

Project: Microsoft Office14 (2010) Support

Role: Senior Software Test Analyst

The primary function of this project is testing UI and functionality of MS Office 2010 applications Service Packs (SP1) and various Office products for future releases like Office Web Apps 2010 SkyDrive versions which is new future Microsoft introduced in Office 2010, Office365 Testing by performing Localization, Globalization and International Sufficiency testing across 39 languages.

Responsibilities:

Scheduling, Assigning and coordinating the team Members.

Actively involved in estimation and project planning

Attending Requirement Walk through meeting

Coordinating with Business, to resolve the Questions rose by offshore team.

Daily status reporting

Provide Estimation technical inputs, guide and mentor team members, Defining Metrics/SLAs, Test management effort

Co-ordination defect triage meeting

Involved in RCA for rejected, warranty defects and Shake out issues

Actively involved in creating Test design specifications, Test plan and reviewed Test cases and results before client review meetings

Taken Complete ownership for Office web apps SkyDrive releases

Reviewed Test Case Categorization based on Priority (Sanity, Acceptance and Comprehensive)

Modification and maintenance of Test kit as the Product evolves

Environment: Microsoft Office 2010, MS Office 2007, Windows Vista, Visual Studio 2005, Team foundation server, Product Studio, MS SQL and Office Web applications 2010

Microsoft Corp, Dublin, UK Nov 2007 – Aug 2010

Project: Microsoft Office14 (2010) Localization

Role: Senior Software Test Analyst

Localization testing involves Web based Testing for Server Applications, functional and UI Testing for both Server and client Office Applications. The primary function of this project is testing UI and functionality of MS Office 2010 applications by performing Localization, Globalization and International Sufficiency testing for 39 languages on continuously released builds. This Project involves creating UI and functional automation C# scripts using Microsoft Automation Framework. Also, the objective of the Server applications for MS Office 2010 like Office web apps 2010, MOSS (Microsoft Office share point server), WSS (Windows share point services), Project Server and Groove Server is the Web based Testing server applications along with localization and Globalization checks

Responsibilities:

POC for Office web apps 2010 application from Offshore

Requirement Gathering and Analysis

Coordinating with Business, to resolve the Questions rose by offshore team.

Scheduling, Assigning and coordinating the team Members.

Co-ordination defect triage meeting

Attending status meetings and representing testing team for Office web apps

Actively involved in estimation and project planning

Attending Requirement Walk through meeting

Actively involved in creating Test Plan, Test design specification documents

Designed Test Cases

Involved in executing the functional testing.

Responsible for tracing the test cases to the requirements

Environment: Microsoft Office 2010, MS Office 2007, Windows Vista, Visual Studio 2005 SP1, Team foundation server, Product Studio, MS SQL and Office Web applications 2010

Microsoft Corp, Redmond, WA Aug 2006 – Oct 2007

Project: OLSE (Offshore Leverage Sustenance Engineering)

Role: Software Test Engineer

This project is to provide the sustenance activity to the Microsoft Windows platform in various flavors of operating systems. This has various Kernel components and User mode components and different applications to test.

Responsibilities:

Requirement Analysis

Designed test cases

Actively involved in testing the functionality of File System Kernel service components like LFS (Local File Systems - ntfs.sys, fastfat.sys) for various Windows operating system flavors like NT4 Client and Server family Windows 2000 Server family, Windows XP Client, Windows Server 2003 on different architecture like x86, x64 and Itanium 64.

I was involved in testing of the Service packs, which includes bug fixes, and security updates, Builds testing, and closing of bug activity by performing the regression testing.

Involved in triage meeting, bug tracking and bug closure activities in Product Studio

Environment: OS: Windows XP, NT4 and Server 2003

Microsoft Corp, Redmond, WA Oct 2005 – July 2006

Project: MSN TV

Role: Software Test Engineer

The MSN TV brings together a variety of news, sports and entertainment to the TV screen. We can watch Mails, News, entertainment, sports and more MSN Video news clips, Customized weather and stock info etc. MSNTV gives flexibility of connecting to the internet using Narrow band phone line and Broadband Ethernet connection. Apart from the basic internet connectivity, it also enables data sharing using UNC (Universal Naming Convention) and UPNP (Universal Plug Play) features. More Over it is possible to upload pictures and do some basic photo editing like rotation and printing variants like portrait and Landscape. The main features of this are Web Compatibility, WMP Compatibility, Flash, TV Lens, Photos, and Favorites.

Responsibilities:

Actively involved in all Testing activities like functional testing, Regression and System Testing Methodologies, bug reporting including some of the major ones, which are the backbones to the application.

Actively involved in creating Test Plan.

Designed Test Cases.

Involved in triage meeting, bug tracking and bug closure activities in Product Studio

Responsible for tracing the test cases to the requirements

Environment: Windows XP, MSN TV, Microsoft Office 2003 and Product Studio

Cova Technologies Inc., US May 2004 – Sep 2005

Project: E-PROCUREMENT (B2B)

Role: Software Engineer

E-Procurement software is developed to establish online E-Procurement portal for procurement of products that shall be accessed from any location using standard Internet browser and shall facilitate to quickly sell or purchase products.

Responsibilities:

Analyzing requirements

Preparing Technical design documents

Designed UI Forms

Involved in development

Involved in Unit testing

Environment: Windows XP, .NET, SQL Server 2000



Contact this candidate