Project Manager Quality
Resume:
Kiran
Yonkers, NY
***********@*****.***
CAREER OVERVIEW
Quality Assurance Professional with proven, professional experience in Information Technology, In-depth understanding of Software Development Life Cycle (SDLC), QA process and solid communication skills.
Demonstrated ability to work independently as well as with in the team environment.
Areas of Expertise:
• Around 7+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of Database solutions for Client/Server Enterprise and Data Warehouse applications.
• Experienced in the analysis, design, implementation, and maintenance of high-volume, data intensive systems.
• Extensive experience in running various kinds of tests such as Integration, System, Regression, User Acceptance Test (UAT), Backend for Web (N-Tier) and Client/Server Applications.
• Experienced in defining Test Scenarios and writing Test Cases, Test Plans, Traceability Matrix based on business, functional and technical requirements.
• Expertise in writing complex SQL statements and tuning existing SQL statements for performance and scalability and extensive experience in stored procedures.
• Testing experience in both UNIX and Windows platforms, including troubleshoot and resolve issues related to client/server and web applications.
• Experienced in design review and requirement analysis with development team and the client and documented all phases of QA process.
• Thorough understanding of the Defect life-cycle process. Worked with cross functional testing teams and developers for closing defects.
• Hands on experience in Data Modeling, Data Warehouse Design, and Testing using ETL tools.
• Highly motivated team player with strong communication, analytical and inter-personal skills.
• Experienced in analyzing Business Requirements and Specifications.
• Strong understanding of QA Process, Agile, Waterfall and RUP methodologies.
• Strong knowledge in Core Java, J2EE technologies.
• Excellent at Problem Solving, Root Cause Analysis, and Problem Solutions based on Impact and Risk.
• A very good Team player and Enthusiastic with Excellent inter-personnel skills
EDUCATION / CERTIFICATIONS
Masters of Science, Computer Science with distinction. GPA:3.84/4.00
Mercy College, Dobbs Ferry, NY
Certifications:
• ISTQB Certified Tester
• ISTQB Advance Test Analyst
TECHNICAL SKILLS
Testing Tools: HP Quality Center, SoapUI, SoapSimulator, TestDirector, WinRunner, MDT,ITE,ClearQuest, Ztracker,Tortoise CVS, SVN, and Amdocs systems.
Languages: Java, J2EE technologies.
Databases: Oracle, MS Access, DB2, SQL Server, MySQL
Operating Systems: Windows XP and UNIX
Other: Toad, SQL Developer, Microsoft Project, All of Microsoft products
PROFESSIONAL EXPERIENCE
AT&T, Farmers Branch, TX Jun 2010 – Present
ETL/ Backend Tester
AT&T Inc. is the largest provider of fixed telephony in the United States, and also provides broadband and subscription television services. AT&T is the second largest provider of mobile telephony service in the United States.
CSTO, common service testing team which is responsible for testing all the services in the middleware layer which is common services, csi provides services to corporate clients, front end and all other e commerce applications. CSI has more than 500 services exposed and CSTO is responsible for test design and testing maintaining quality as per the ITUT standards.
Responsibilities:
• Reviewing Business Requirements and Functional Specifications documents in order to create Test Estimates, Test Design and Test Plan documentation.
• Performing the Unit, System, Integration, Regression and Acceptance testing.
• Used Quality Center for generating Requirements, Test Sets, and Test Plan and for reporting defects.
• Analyzing various sources and created mapping input output documents and studied and cleansed data and used Imp/Exp and SQL loader tools extensively to load data and transferring data to various systems.
• Performing extensive database testing by writing SQL, PL/SQL scripts to compare the UI results with the data in the database.
• Developed standard and re-usable containers and ETL Jobs using various transformations like Transformer, aggregator, joiner, column import, filter, lookup, and merge
• Performing data Quality Analysis to determine cleansing requirements.
• Creating Views and Stored Procedures to generate the reports from FMS warehouse database and verified if the reports are met the requirements.
• Acted as an excellent Data/test analyst helping/providing/creating data for various production scenarios in QA oracle database for our team members and as well as for other teams using SQL queries.
• Interacting with application developers to ensure smooth progress and completion of the QA cycle.
• Developing UNIX shell scripts to archive, zip and FTP the logs to FTP server.
• Detecting bugs & Classifying them based on the severity and retesting the application to ensure testing issues are resolved.
• Extensively worked on the functionalities like billing management, order managements, middleware Transactions.etc by testing various web services applications using SoupUI and SoupClient.
• Tested various BusinessRules using GEMS tool in middleware tier.
• Successfully completed very complex projects such as but not limited to Premier Dashboard, Single Sign on, MyATT\Myworld, MRE and IWE as micro cluster which requires good SQL knowledge for understanding the complexity.
• Performing middleware testing using ITE tool which is ITE leverages a powerful set of tools developed by the Middleware Infrastructure team that is proven to drive costs out of the software development and maintenance lifecycle. It modifies existing Enterprise Infrastructure tools and integrates those tools with some industry standard open-source products.
• Interacting with Manager and Team members regarding ongoing activities.
• Responsible for Test planning and overseeing all QA activities in the project
• Maintaining the requirements, test plan, test cases and defect reports using Quality center.
• Monitoring the test process by creating reports and graphs using Quality center.
• Tracking all the activities doing at both onsite and offshore and updating the same to the manager.
• Helping the team members in completing their tasks in given time.
• Generating the Test scenario, Test scripts, Test Conditions and Expected Results for Use Case.
• Involving in manual testing and performed different types of testing like Functional, System, Integration, Regression tests and Database testing.
• Extensively using Defect tracking tool Quality Center for posting the bugs, Validating and tracking them throughout its life cycle.
• Proactively interacting with Business Analysts and Developers regarding testing status and defect tracking.
• Reporting and maintaining application bugs and errors, verified fixed defects, and prioritized outstanding defects.
• Documenting the test results and test procedures.
Environment: Java, Tibco, J2EE, EMS, JMS, Web Services, Web Logic Server, CPP, Solaris , SQL Server, Altova XMLSpy, WinSCP, SharePoint, MDT,Toad, Quality Center.
GuidePoint Global, LLC, New York, NY Apr 2008 – May 2010
Backend Tester
GuidePoint Global is a world largest research firm with the acquisition of the Vista Research from Standard and Poor. It provides customized information solutions in the Healthcare, Technology, Media, Telecommunications, Energy, Industrials, Consumer Goods & Services, and Financial Services sectors. Comprehensive Expert Knowledge Network is a web based application which facilitates registered clients access to customized information solutions in different sectors. It assist its Clients by connecting with GuidePoint Global Advisors (Subject Experts) for research information on data products coupled with an industry leading compliance platform in different sectors.
Responsibilities:
• Successfully worked on multiple projects through careful planning/test structuring, meeting all program needs and schedules
• Translated Business processes into Informatica mappings in order to create Test Estimates, Test Design and Test Plan documentation
• Performed Data Quality Analysis to determine cleansing requirements
• Documented test cases corresponding to business rules and other operating conditions
• Maintained requirements and test sets using Quality center.
• Wrote test cases and test scripts for the functional testing and Regression Testing
• Tested Mappings and Workflows and verified loaded in Target Dimension and Fact tables
• Scheduled code reviews with team lead and Unix shell scripts are used for scheduling to automate the load process & While testing extensively used pmcmd to schedule and execute
• Used debugger to test data flow from Source to Target and fix problems and used test load options
• Worked with internal development group on functionality developed internally.
• Created custom Graphs and Reports for QA Leads, QA Manager, Project Managers, and Development Leads.
• Provided weekly status reports to QA Lead/Project Manager
• Created complex SQL scripts in performing back-end and data validation.
• Tested Archive & Purge process of market data files
• Involved in Importing market data files in various formats to market data templates
• Responsible for updating the existing System Test Cases against the Change requirements document.
• Preparing Requirement Traceability Matrix (RTM) and Defect Tracker.
Environment: UNIX, Oracle, Power builder, PL/SQL, JAVA, J2EE, JMS, JSP, EJB, WEB Services, WEB Logic, XML, SQL Developer, HP Quality Center.
MetLife, New York, NY Feb 2007 – Mar 2008
QA Analyst
MetLife is one of the leading Financial and Insurance Company. Worked in implementation of newly developed website MetLife Financial eService and MetLife Auto & Home eSERVICE. Using MetLife Financial eSERVICE customers can manage their individual variable life insurance policies and annuity contracts. Using MetLife Auto & Home eSERVICE customers manage their policy, billing and claim information. Most of the testing was done manually.
Responsibilities:
• Analyzed the Business requirements and Use cases to understand the application.
• Developed detailed Test Plan, Test Cases and executed them.
• Identified the test cases that are to be automated and those that are to be manually done.
• Documented Test Cases corresponding to the business requirements in Mercury Quality Center.
• Developed requirements traceability matrix between requirements and test cases to ensure maximum coverage of the requirements.
• Conducted GUI testing, Functional Testing, Smoke Testing, Integration Testing and User Acceptance Testing on the application.
• Extensively used SQL and PL/SQL for data integrity testing at the backend.
• Run SQL Queries using Toad.
• Extensively worked on Mercury Quality Center for bug reporting/tracking.
• Participated in Defect review meetings with both the stakeholders and developers
• Participated in weekly review meetings and GO/NO-GO meetings.
• Developed Defect Summary Report and Test Summary Report
Environment: Mercury Quality Center, QTP, Visual Studio 2005, ASP.Net, C#.NET, XML, XSLT, Java script, ASP, Share point, Oracle.
Idea Mobile, India Mar 2005 – Dec 2006
Engineer
Worked as a QA Analyst in testing Mobile billing system to bill Idea Mobile wireless customers, System has been developed with Oracle database and has a number of modules like CSM (customer service management), A/R (account receivable), G/L (general ledger), Reference table (predefined Standards), Price plan, MPS (message processing system), Billing
Responsibilities:
• Reviewed and analyzed requirement document for writing the Test cases.
• Involved in Manual and Automated testing.
• Involved in the creation and execution of manual test cases to facilitate both positive and negative testing
• Performed Configuration, System, Integration and User Acceptance Testing.
• Recorded the automated test scripts in Win Runner, executed them and tracked the defects using Test Director.
• Involved in tracking the status of the bugs logged.
• Interacted with Development team to validate test plans, test cases.
• Extensively communicated with customers and reproducing the problems in-house so that development can debug them.
• Involved in testing for compatibility with all the supported web browsers.
Environment: Windows NT/2000, UNIX, Java, J2EE, Servlets, Java Scripts, HTML, QTP, Win Runner, SQL
PriceWaterhouse Coopers (PWC), India Oct 2004 – Mar 2005
QA Tester
PriceWaterhouse Coopers organize around industries to share the latest research and points of view on emerging industry trends, develop industry-specific performance benchmarks based upon global best practices, and share methodologies and approaches in complex areas such as financial instruments and tax provisioning. In addition, our network is available to collaborate on accounting or technical issues unique to a particular industry, especially when interpretive guidance is needed.
Responsibilities:
• Involved in the system’s Requirement Analysis, Design, and unit testing
• Participated in System, Integration and UAT and testing
• Developed test cases and test scripts.
• Conducted application testing Manually
• Tracked defects using remote bug tracking system
• Worked with QMF to write queries to test the backend database
• Developed Test plans of the application as per technical specifications.
• Written Test Cases by analyzing different Test Conditions
• Performed GUI test for Data entry screen
• Tested User Interface inconsistency and application functionality.
• Documented the test cases, test results, test procedure and reported to team leader.
Environment: Test Director, QTP, HTML, Java, J2EE, Servlets, Java Script, XML, Web Sphere, UNIX, Oracle
REFERENCES
Available upon Request
Contact this candidate