Project Manager Engineer
Resume:
PRIYA SAMBASIVAN
************@*****.**.**
OBJECTIVE
To obtain a Software Test Engineer / Data Analyst position with a dynamic and fast growing company and contribute my education, skills and experience to the organization - with primary focus on working with team members to support software development including testing and documentation.
SUMMARY
Over 7 years of software development and extensive testing experience (with the ability to identify and analyze problem areas) in project based company using client-Server and Web technologies.
1.5 years as a Software Engineer developing projects for Croner Publications Ltd., UK and Royal Commission., UK, which resulted in increased client base for Churchill Software Services India Pvt. Ltd. Efficiently analyze, track and executed projects on time.
1.5 years of experience working as a project coordinator at ExcelSoft Technologies.
8 month contract with the Internet Explorer team at Microsoft as an SDET.
2 year contract working as a Lead Test Analyst for the Interactive Voice Response (IVR) team at AT&T.
1.5 years working as an Analyst for the Boeing Company.
Presently working as a QA Analyst for the backoffice team at ING DIRECT.
EXPERIENCE
ING DIRECT – Sharebuilder Securities Corporation: April 2010 – Present
QA Analyst – Backoffice Team
The project involves delivering a cost basis solution to customers, internal departments, and the IRS – for equities 1099B reporting, tracking gains and losses, etc.
JOB DUTIES:
1. Design testcases for user stories in each sprint from product backlog
2. Setup data prior to test: This involves understanding the underlying table design and stored procedure functionality to insert/update/query values in backend tables
3. Setting up batch applications on a virtual machine, configuring the properties file of every batch application prior to running the app.
4. Load data in warehouse database by running ETL after setting up data in the backend database. Also use ETL to load data into datamart.
5. Execute functional tests as well as regress defects found in the sprint.
6. VersionOne: Add tasks to user stories, update hours in sprint tracking, review burndown chart to track project progress.
SKILL SET:
Methodology: Agile Scrum Process
Languages: SQL
RDBMS: Sybase ASE
Internet Technologies: SOAP XML
Test Tools: HP Quality Center 9.2
Other Tools: VersionOne, Sybase Central 4.3, Sybase SQL Advantage
EXPERIENCE
The Boeing Company. Sept 2008 – Feb 2010
Analyst – 787 Goldcare Integration Test Team
JOB DUTIES: are twofold –
1. As an Analyst, analyze functional requirements and design, define, develop and execute test cases for GoldCare. Contributing to the test plan, developing test cases based on software specifications and SME input, executing and reporting of test cases results. Create and execute queries using TOAD – to retrieve results from backend Oracle database as part of test validation.
Integration testing utilizing a short iteration delivery cycle from multiple integration application sources. Communicate state of the application to the project stakeholders as required. Communicate anticipated or actualized risks as well as gaps in functionality. This is based on the execution of simple, moderate, and complex test scenarios. Work in close collaboration with the project managers, developers, suppliers, and business users to define critical areas for testing. Ensure quality and reliability of back-end and front-end applications, for airborne and ground-based airline systems. Help application owners understand the testing process and the quality state of their applications and environment. Work with cross-functional teams.
Testing includes – smoke, unit, functional, regression and release testing/pre-production testing.
2. As a backup for the Test Lead – preparing daily status reports, holding defect triage sessions and communicating status to PM, writing release notes after test release.
Responsibilities include:
• Understand the various enabler applications in play and the function of each.
- Enabler applications include Maintenance engineering management, Toolbox, Electronic log book, Airplane health management, Airline operations control, Situational awareness, Integrated materials management.
• Review the P490s / test plan documents and ensure they are accurate and have in-depth coverage for every CR targeted for the current release prior to signing off on the document.
• Write P750s / test scenarios for every transaction that occurs between enablers.
• Translate the P490s to testcases, which are maintained in HP Quality Center.
• Ensuring 787 data is consistent among different enablers prior to test, by performing DIS [Data initialization services].
• Conduct IUT, IFT and IRT test cycles prior to handoff to Pilot team / release to production.
- This includes role-based testing [Chief Engineer, Stock clerk, Line planner, Materials Coordinator, AOC engineer, MRO engineer, Planner, Superuser, etc..] in addition to functional testing of the applications.
- Use QTP to record and play back scenarios
• Identify, record and track defects found during test in Mercury QC.
- As part of the defect identification process, we are required to read the XML messages that are passed back and forth between enablers.
- Root cause analysis of the defects.
- Execute scenarios in PILOT environment as part of troubleshooting defects – to identify change in functionality between releases.
• Troubleshoot when messages do not reach the intended enabler application
- This can be because the listener in the broker application goes down and needs to be restarted and message reforwarded to the queue.
- This can be because of bad/incorrect message format.
- Check configuration file properties of the tool.
• Track CRs (Change Requests) in CASCQ, a change management system – which is a customised version of Rational Clearquest.
• Run performance metrics reports.
• Write up and execute queries against PM database [Oracle] in order to retrieve test data and also verify the outcome of certain test scenarios.
• Provide feedback to developers on the issues during daily triage call
• Prepare weekly status reports.
SKILL SET:
Operating Systems: Unix, Windows XP
Languages: SQL
RDBMS: Oracle 11i
Internet Technologies: SOAP XML
Test Tools: Rational ClearCase, ClearQuest, HP Quality Center 9.2
Others: Microsoft Office, Excel, Visio, TOAD
Dendreon. Aug 2008 – Sept 2008
Software Test.
Rapid testing for an AGILE scrum cancer research project.
AT&T. Sept 2006 – Aug 2008
Lead Analyst - Test
Responsibilities include:
1. Document the test plan, design test scenarios and test sets, as well as execute them – Functional, Integration & Regression tests.
• Work with the Business Analyst to review business requirements, analyze the High Level Design Documents (BRD, FSD) provided by the business and FA to understand the business/system requirements.
• - This included in-depth understanding of the call flow, and if all the specifications were mapped to the call flow/database tables, as part of requirements.
• Understand the underlying Oracle database table design and relationships for creating simple SQL statements in order to add/modify test data prior to testing cycle.
• Translate the requirements and flow diagrams into test plan and test scenarios
• Further break up the test scenarios into test cases [Rational ClearCase was used to write manual test cases]. This includes querying the database for values and creating views - using TOAD and SQL statements that would later be used in the testcases.
• Present the test scenarios and testcases written to the FA, Business Analyst and Project manager in order to get their approval to sign-off on the modules.
• Data validation [querying the billing system database for relevant data using SQL]
• Test set execution as part of functional and system testing cycles and provide production support during the pre-prod testing phase. This includes analyzing the call record logs using the terminal emulator that supports the Rlogin.
• Editing the SOAP XML for values of tags which is used as an input to the Java application into the IVR system
• Create test accounts using Telegence and CARE UI, for use in testing.
2. Create defect reports: Log defects using Mercury Quality Center / Rational ClearQuest and follow-up on the status of defects
3. AUTOMATION: Executing automation scripts using HAMMER CallMaster 5.1
A. Creating CSV files which would have the list of preconditions and testcases, and the list of functions [and the values associated with them thereof] for every precondition/testcase.
B. Associating data [CTNs] to the index and adding them to the database.
C. Troubleshoot failures
4. Create a power point presentation outlining the functionality of the module, the changes made to the database to accommodate the new business requirements, the testing strategy and the type of data needed to execute those test sets.
5. Mentor the new recruits on the team.
SKILL SET:
1. Oracle 9.2 – SQL & TOAD 7.4
2. UNIX
3. In-depth understanding of XML file manipulation [SOAP XML] and transactions and n-tier to DB logic – using XML Spy
4. Rational Tools - ClearCase and ClearQuest
5. Mercury Quality Center 9.0
6. Hammer CallMaster 5.1
7. MS-Office Suite – Word, Excel, PowerPoint, VISIO.
Microsoft Corporation. Jan 2006 – Sept 2006
SDET1/STE2
Responsibilities include:
• Build install and configuration – Partition the hard drive on the machines – to safe OS and Test OS, and Install the most recent build of Vista OS on the Test drive and run updates, install IE7 on the OS. Sometimes had to VPC/Remotely connect to the lab machines which would already have the OS builds installed.
• Run BVT [Build Verification Tests] - Testing Internet Explorer 7.0 on the new Vista OS (32 and 64-bit machines, including Itanium) and backward compatibility on XP Pro, Windows Server 2003 and other older OSs.
Functionality testing covered the following areas :
AppCompat – IE7 compatibility with applications like Word, InfoPath, Visio, QuickBooks Pro, Messenger service etc.
ExtCompat – Compatibility with extensions to IE like toolbars, menus and other add-ons
SiteCompat – IE7 compatibility with different websites.
• Bug filing and investigations – Log defects using Product Studio 6.0. Get the stack trace and dump file during IE crashes.
• Test set design, test set execution and maintenance
– wrote manual testcases for ExtCompat and SiteCompat using TacticsUI - MS Proprietary tool, in order to test the IE7 compatibility with newer versions of toolbars and messengers that google/yahoo released.
• Test automation – run automation scripts and analyze failures using Piper.
• Other responsibilities --areas in test plans, tracking issues, status reporting (prepare weekly status reports containing details of testcase failures on build versions, automation failures and code fixes), running stress tests (using MS Proprietary tool called hammer).
SKILL SET:
1. OS set-up and configuration: Windows Vista, W2K, XP, XPSP2, W98, W98se, ME, NT4server, Win2k3 server, 64-bit client or server
2. Basic networking experience--troubleshooting connectivity issues
3. HTML, Javascript/_Jscript
4. Experience with test infrastructure used by IE, Avalon or MSN Explorer/client
5. General IE technology knowledge--ActiveX, XML, HTML, DHTML, etc.
6. Web experience
7. Familiarity with VPC client
8. Bug tracking database – Product Studio 6.0 [Microsoft proprietary]
9. Automation Tool – Piper, Stress tool – Hammer
10. Tools for automated software build – ASI Installer, WTT
ExcelSoft Technologies Pvt. Ltd. Feb 2002 - June 2003
Project Coordinator
Responsibilities include:
Coordinating Projects
• Attend team meetings to keep abreast with the development in each project; also record minutes of meeting for documentation purposes.
• Deliver presentations about overview of projects and test methodology to newly inducted team member(s).
• Review team test reports and escalate high-priority issues to developers.
• Prepare weekly status reports of project status – manhours Vs tasks completed, pending tasks Vs estimated time to complete them, deadline date. These reports were used by the Project Manager to track the projects, to make sure they do not exceed the projected timeline.
Software procurement from vendors
• Initiate and follow-up on calls and assist in decision making by comparing prices, warranty, delivery dates and service contracts.
Billing clients (in the area of Enterprise consulting)
• Prepare weekly bills for clients based on the tasks performed.
SKILLS:
MS Office Suite: Word, Excel, Outlook, and PowerPoint.
Churchill Software Services India Pvt Ltd. April 1999 – Sept 2001
Software Engineer
PROJECTS
1. Client: Croner Publications Ltd., UK
Team Size: 24
Responsibilities: Re-engineering, GUI enhancements, applying Churchill standards, generating reports, testing and documentation.
Front End: Developer 2000 - Forms 6.0 & Reports 6.0
Database: Oracle 8.0
O.S.: Windows NT-4.0
Details: The project aims at providing complete functionality of a publishing house. It comprises of modules such as Customers, Products, Stocks, Sales Order, Sales Ledger, Subscriptions and Royalties. The project was initially
developed in Forms - 3.0 on Unix and then migrated onto Forms - 6.0 with enhanced functionality on Windows - NT 4.0.
Duties and Responsibilities:
- The project involved reverse engineering using Designer/2000 and Developer/2000, viz. re-generating modules, identifying existing components and developing reusable components – add new PL/SQL code in forms where required. Create stored procedures to be referenced by the PL/SQL code.
- The testing effort involved using creativity to design test sets, and execute test sets during unit testing of modules, functional, regression, performance and acceptance testing.
- Perform in-depth functional testing to validate software conformance to specifications.
2. Client: Royal Commission, UK
Team Size: 16
Responsibilities: Re-engineering, GUI enhancements, applying Churchill standards, generating reports, testing and
documentation.
Front End: Developer 2000 - Forms 6.0
Database: Oracle 8.0
O.S.: Windows NT-4.0
Duties and Responsibilities:
- The conversion effort involved reverse engineering using Designer/2000 and Developer/2000.
- Repair/Fix obsolete code, add new PLSQL code where required. Create stored procedures used in PL/SQL code.
- Testing effort involved unit and bottom-up testing of modules, performance and acceptance testing.
3. Web development and testing: The project is close to an e-shopping software (without financial data handled), which was developed on the same lines as the previous project CRONER. The registered customers were displayed categories of
products to choose from, and the items in each category. The customer would then be given a choice of adding his selection to the shopping cart or directly place an order.
Duties and Responsibilities:
- Involved in the design of tables for storing data and Front-end development
- Creation of web pages for customer login, displaying product details, facilitating user selection of items and adding to the shopping cart, etc.
- Perform unit, functional and acceptance test on the modules.
Designation: Web developer
Tools used: Allaire Homesite 4.0
Database: Oracle 8.0
Role: Design, development and testing.
SKILLS:
Operating Systems: Windows NT, Windows 95/98/XP/Vista, UNIX
Languages: Java, C, SQL (queries, views, triggers, stored procedures), PL/SQL.
Front End: Developer 2000 - Forms (4.5/5.0/6.0), Reports (2.5/3.0/6.0)
RDBMS: Oracle 7.3, 8.0, 9.2
Design Tools: Designer 2000
Internet technologies: HTML, JavaScript. Knowledge of VBScript, ASP, XML.
PROFESSIONAL CERTIFICATIONS:
Sun Certified Programmer for the JAVA 2 Platform 1.4
Brainbench certified Oracle Developer 2000 Programmer
Aptech /Asset certification in Oracle 8.0 (SQL, PL/SQL), Developer 2000, Client-Server concepts
EDUCATION:
Bachelor of Science in Computer Science and Engineering from University Of
Mysore, India securing First Class with Distinction.
Contact this candidate