SRI Pinnamaneni Sr. QA Engineer

ac73s6@r.postjobfree.com

US Citizen - 302-***-****

Resume of Sri Pinnamaneni 1

Professional Summary

Over 17 + years of experience as a UAT/Quality Assurance Lead tester and developer of datawarehouse, Legacy Client/Server and Web based applications.

Possess high quality and meticulous attention to Detail

Expertise in analyzing Business and Development Specifications, Use Cases, and Detail Design to develop test requirements and procedures.

Developed excellent professional skills by working independently and as a team member for manual and automation testing.

Poses excellent skills in Manual Testing along with skills in Automation Testing using WinRunner, Quality Center, QTP, Clear Case and Clear Quest Tools.

Involved extensively in writing Test plans & developed, executed and documented Test Cases.

Managed installations and upgrading of HP toolsets along with server upgrades and server replacements.

Strong skills in performing System, Acceptance, Regression, Integration, Stress, Performance, Load, Functionality, Front End and Back End Testing.

Involved in design review discussions with the Development team.

Involved in decision making to launch new builds.

Excellent skills in Bug Reporting using Quality Center, Rational Clear Quest and JIRA.

Extensive experience in developing Strategies for Extraction, Transformation and Loading (ETL) mechanism from discrete data sources using Ab Initio.

Experience using Ab Initio for data integration and data manipulation from various legacy data systems/warehouses.

Quick learner with an ability to easily grasp new technologies, software and IT architecture.

Proactive and out-of-the box thinking to come up with ideal solutions.

Excellent communication, interpersonal, technical, analytical and problem solving skills. Education Summary

Bachelors of Engineering in Information Technology Technical Summary

Testing Tools: Quality Center, Quick Test Pro, WinRunner, Rational Tools (Clear Quest, Clear Case), JIRA. Other Tools: DOORS, Sharepoint, Livelink

Languages/Scripting: SQL, Visual Basic, VB Script and Lotus Script, . Web: HTML, DHTML, and XML

OS: Windows 98, 2000, 2003, NT, XP, UNIX, Linux and DOS. Database: DB2, Oracle v8i, 9i, SQL, PL/SQL, MSAccess and SQLServer 2005, Microsoft Access. Schedulers: Autosys

Specialization Summary

Specialties: Datawarehouse Testing, ETL (Ab Initio) Knowledge, Project Management, Hands-on Testing, Mercury Toolset, SQL, PL/SQL, Scripting

Experience Summary

Client: Fannie Mae, VA Jan'14 – Present

I worked for Fannie-Mae with Acquisitions and Capital Markets UAT Team supporting MBS Pool, Cash Delivery, Legislator and RSS PeopleSoft applications

Responsibilities:

Interacted with client business partners and technology counterparts to understand the scope and requirements.

Provided Level of effort and measurable deliverable goals.

Created work break down structure and individual task items traceable on project plan

Involved in design, development and implementation on a multitude of manual tests for functional and regression tests.

Analyzed and Performed Gap Analysis based on requirements documents.

Clearly understood the requirements and prioritized tasks and exceeded expectations by delivering ahead of time.

Responsible for creating test cases and test scripts based on requirements.

Worked very closely with developers to determine issues that require hot-fix.

Close interaction with designers and software developers to understand application functionality and navigational flow.

Developed, executed and maintained manual functional tests and results in Quality Center.

Heavily involved in mapping the requirements to the test cases SRI Pinnamaneni Sr. QA Engineer

ac73s6@r.postjobfree.com

US Citizen - 302-***-****

Resume of Sri Pinnamaneni 2

Verified and validated requirements to ensure that the software satisfies the needs of the business users and allows them to perform their jobs effectively and efficiently

Developed Database Queries to Test the Oracle Database.

Interacted closely with Business analysts, Developers to understand the application thoroughly

Performed Gap Analysis on the requirements

Compared and analyzed actuals with expected results and reported all deviations to the appropriate individual(s) for resolution.

Client: Fannie Mae, VA Apr ' 13 – June’13

I worked for Fannie-Mae with Acquisitions UAT Team supporting projects like BURPS and Deal Factory Responsibilities:

Interacted with client business partners and technology counterparts to understand the scope and requirements.

Perform Integration Testing and support external business users for simulating or creating Loan commitments

Provided Level of effort and measurable deliverable goals.

Created work break down structure and individual task items traceable on project plan

Identified key milestones and risks associated during the project cycle.

Prepared Test Strategy and Test Plan.

Developed, executed manual functional tests and results in Quality Center.

Identified root causes, analyzed and provided solutions to critical, medium and low issues in a reasonable timeframe.

Interacted closely with Business analysts, Developers to understand the application thoroughly

Performed Gap Analysis on the requirements

Created test summary report

Created Pre RTM and Post RTM

Compared and analyzed actuals with expected results and reported all deviations to the appropriate individual(s) for resolution.

Client: Fannie Mae, VA Oct ' 10 – May’12

I worked for Fannie-Mae under CLM – Accounting platform supporting accounting projects like RADAR 1.0, ARROW 2.1, Asset Servicing team supporting LRI Form582 project which is a web based application and SIR 3.0 (consolidation & De- consolidation process).

Responsibilities:

Involved in design, development and implementation on a multitude of manual tests for functional and regression tests.

Analyzed and Performed Gap Analysis based on requirements documents.

Prepared Test Strategy and Test Plan.

Clearly understood the requirements and prioritized tasks and exceeded expectations by delivering ahead of time.

Responsible for creating test cases and test scripts based on requirements.

Work with the developer very closely to determine issues that require hot-fix.

Close interaction with designers and software developers to understand application functionality and navigational flow.

Developed, executed and maintained manual functional tests and results in Quality Center.

Heavily involved in mapping the requirements to the test cases

Verified and validated requirements to ensure that the software satisfies the needs of the business users and allows them to perform their jobs effectively and efficiently

Developed Database Queries to Test the Oracle Database.

Tested different Business Objects reports across all the modules.

Extensively used Clear Quest for defect tracking

Validated all existing Upstream and Downstream interfaces

Responsible for preparing RTM using DOORs

Demonstrated thorough abilities and/ or a proven record of success for delivering professional data assurance services inclusive of accounting data analyses; enablement of data base automation tools; identification of data quality issues and related cleansing; data flow process reviews; risk assessments; and spreadsheet remediation and/or simplification

Performed GUI Testing / Validation.

Ran the Autosys jobs for each release and validated log files .

Developed Incident Summary Reports for each release.

Worked effectively to meet the dead lines for each release.

Developed Shell Scripts to run the BO Jobs in UNIX.

Developed Test cases and SQL queries to validate the data pulled in from the Data Marts and populated into the reports

Performed Requirement Coverage in Quality Center between Test Cases and Requirements. SRI Pinnamaneni Sr. QA Engineer

ac73s6@r.postjobfree.com

US Citizen - 302-***-****

Resume of Sri Pinnamaneni 3

Executed ETL jobs from UNIX command line

Used FTP to transfer files from different environments

Created and maintained test documentation and metrics

Developed SQL Queries like Complex Inner Joins, Outer Joins and Sub Queries to Test Oracle Database.

Validated back-end data using SQL and UNIX shell Scripts

Validated SQL Queries Results with Report Results.

Validated the quality of data against Flat file and Excel file.

Used MS Project to maintain the project plans.

Developed Test Summary and Defect Reports using ClearView Environment: Mercury Quality Center, Oracle, Clear Case, Clear Quest, Clear view, Doors, Req-pro, TOAD,MS- Word, MS-Excel, MS-Power Point, MS-Project, Windows XP . Client: GEICO, MD Sep ' 07 – Oct ' 10

Responsibilities:

Interacted with multiple business users and technical teams across the organization.

Analyzed and Performed Gap Analysis based on requirements documents.

Prepared Test Strategy and Test Plan.

Consumed releases and performed application shakeouts.

Executed Ab Initio (ETL) jobs and monitored the log files

Lead the QA Team and co-ordinated with management for effective project deliverables

Mentored and monitored team members to attain quality and maintained best practices.

Maintained testing dashboard and QA summary reports for senior management

Created and maintained test documentation and metrics.

Advised development team on reusable and re-runnable components.

Joined Testing Center of Excellency and participated in enterprise initiatives.

Demonstrates thorough knowledge and understanding of database concepts, including building relationships between tables, grouping data, and producing cohesive analyses

Defining resource requirements, project workflow, budgets, and billing and collection;

Identifying and addressing client needs, including developing and sustaining extensive client relationships;

Assisting with the leading of teams to generate a vision, establish direction and motivate members, create an atmosphere of trust, leverage diverse views, coach staff, and encourage improvement and innovation.

Extracted data from Mainframe and loaded to SQL server tables.

Created a batch based Pre-process using PL/SQL and unix wrapper.

Executed UNIX k-shell scripts to invoke application jobs.

Domain expert in supporting “Quality Center” functions like unlocking scripts, terminating dead sessions, creating new domains, creating new projects along with workflow setups to application leads.

Provided expert QTP advice along with resolutions to the issues raised by user community.

Validated the source and target database based on the business requirements writing SQL and PL/SQL scripts in TOAD tool.

Manually tested and validated OASIS service application by verifying cloned policies within training environment.

Took ownership for executing scripts for training environment validation every week.

Identified root causes, analyzed and provided solutions to critical, medium and low issues in a reasonable timeframe.

Clearly understood the requirements and prioritized tasks and exceeded expectations by delivering ahead of time.

Responsible for creating test cases and test scripts based on requirements.

Maintained positive customer relationship by exceeding expectations.

Responsible for code migration (gatekeeper) approvals and policy copies into various testing environments.

Developed an automated process to reduce the time for data movements from client server to mainframe datasets.

Developed visual basic programs to process data from access database on front end to mainframe dataset on the backend.

Involved in the complete lifecycle of automation, including testing and deployment to improve the efficiencies and reduce the manual errors.

Supported scheduling of jobs during off-peak hours to have the data available in multiple test environments.

Actively provided innovative ideas to reduce the man hours and to increase performance and efficiencies.

Handled release management meetings every day following the SDLC process to have a smooth release

Actively learned new process and developed templates for documenting the process, metrics etc.

Involved in Regression testing, Functional testing, Integration, system, and UAT testing

Responsible for preparing RTM (Requirement Traceability Matrix). Environment: QTP, QC, JIRA, Ab Initio 1.13, UNIX, Oracle, PL/SQL, SQL Server, Remedy, Mainframe, MS Access. Client: Fannie Mae, VA Jul 2006 – Aug 2007

I Worked for Fannie Mae under Enterprise Sys & Management aka ESM umbrella for PCMPLUS group currently using Remedy product that was customized per business requirements. Two new applications were built and customized using Remedy called - DBMod Request Tracking Form (DRTF) and ESM Request Tracking Form (ERTF) along with couple SRI Pinnamaneni Sr. QA Engineer

ac73s6@r.postjobfree.com

US Citizen - 302-***-****

Resume of Sri Pinnamaneni 4

more enhancements to the existing applications called - SLA Measurement Form, Help Desk Form, Motive Replacement Project and Voice Of Customer (VOC).

Responsibilities:

Involved in design, development and implementation on a multitude of manual tests for functional and regression tests.

Wrote baselines for all the Remedy Applications.

Responsible for preparing Test Cases, Test Summary Reports, Testing and Status Reports.

Proficient in using Quality Center tool for defect tracking and reporting.

Developed, executed and maintained manual functional tests and results in Quality Center.

Heavily involved in mapping the requirements to the test cases

Executed automated scripts in QTP and stored the results in Quality Center.

Responsible for analyzing the documents and executing test scripts.

Analyzed the design requirements for preparing the test scenarios.

Responsible for writing test cases based on requirements.

Responsible for executing the test cases, upon successful completion, responsible to promote/migrate the application using Clear Quest.

Customized the queries using CQ to pull the data out.

Responsible for prioritizing and assigning Services Online (SOL) requests for DBMod Tracking Form and ESM Request Tracking form using Lotus Notes application.

Administer and support the user community to access the Remedy system.

Resolve, monitor and draw metrics for the help desk tickets that were assigned.

Support user base for completing the help desk tickets by walking them through the supported resolutions.

Mentor and coach the users the usage and workflow of the DBMod and ESM Request Tracking Forms.

Compiled full shakeout test plan for monthly migration along with making the results available in SharePoint.

Work with the developer very closely to determine issues that require hot-fix.

Participated in the External User Testing Process and developed methodologies.

Participated in the Oracle Upgrade processes, testing for evaluating the effectiveness of the upgrade system testing performed for the purpose of finding problems before release. The test activities and procedures represent those deemed effective for determining that the test effort has been successful.

Built our own queries by integrating Business objects with quality center for running the reports for monthly migrations.

Environment: Manual Testing, Quality Center, QTP, CQ, Remedy, UNIX, Windows2003. Client: JP Morgan Chase Bank, DE Jan 2002 – Jun 2006 The stream i was actively involved is Customer Promotion Selection System based on ETL and web front where in business need to qualify the card holders for the available promotions based on the various credit scores and mail the promotions along with the card holders statement on time based on the card holders preference cycle date. Responsibilities:

Involved in the complete QA Lifecycle activities like Pre-testing phase, acceptance testing phase and testing phase.

Analyzed System and Functional requirements, developed & executed detailed Test plan, Test cases, Test scripts for testing the functionality using Mercury Quick Test Pro.

Create test cases and used Autosys to test Ab Initio codebase.

Tested all stages right from Extraction, Transformation and Loading (ETL) from discrete data sources written in Ab Initio.

Used Autosys to execute Ab Initio deployed scripts and UNIX wrapper scripts.

Created and executed PL/SQL packages to automate testing.

Used basic UNIX commands to maneuver within the application.

Identified test data based on specifications (example: user interface/friendliness criteria, compatibility with browsers/environment, database response, volume constraints, security, network criteria) of the product. Involved in QTP architecture of modular test tree for automating testing processes and creation of reusable scripts.

Created test cases for various levels of test such as Integration test, Regression test, System test, End-to- End test and User Acceptance test for different modules.

Executed test cases manually. Compared and analyzed actual with expected results and reported all deviations to the appropriate individual(s) for resolution.

Used ADO objects to connect and retrieve the data from database.

Used VBScript file to load all the function libraries using Library functions in QTP utilities.

Implemented QTP to handle Shared Object Repositories.

Documented and tracked test scripts, test results, test analysis, and reported the defects using Quality Center.

Involved in compatibility testing with other software programs, hardware, operating systems and network environments.

SRI Pinnamaneni Sr. QA Engineer

ac73s6@r.postjobfree.com

US Citizen - 302-***-****

Resume of Sri Pinnamaneni 5

Performed the Back-End testing to ensure data consistency on front-end by writing and executing SQL queries on the Oracle database.

Close interaction with designers and software developers to understand application functionality and navigational flow.

Prepared detailed Test Metrics on a weekly basis for the project members to know the status of the application Environment: Quick Test pro, Ab Initio 1.13, UNIX, Quality Center, DOORS, ORACLE, SQL*PLUS, PL/SQL, TOAD, Windows 2000/NT.

Client: IBM, NY Sep 1999 – Dec 2001

Worked as a QA Tester responsible for developing Test Cases,Test Procedures depending on the Application specifications for an Integrated Product System. The integration project used an extensive repository of product information and provided means for efficient delivery and pricing and maintaining of products. We maintain all the information regarding a particular product based on their Id. Responsibilities:

Developed, executed and documented manual and automated test scripts to support requirements.

Collected the application specifications from Business Analyst. And developed the Test cases.

Interacted extensively with development groups and end-users.

Performed functional testing, regression and system testing of the application.

Developed test scripts using with Winrunner to check Links, Images, and also to verify data within the application.

Wrote SQL queries for data verification and backend testing.

Tested the functionality of web pages using with different types of browsers like Netscape, IE on different versions.

Used Test director tool for tracking bugs, defects, and project management issues.

Investigated software bugs and interacted with developers to resolve technical issues.

Documented and reported bugs found out during the process of testing in the bug database

Generating the defect report, analyze and come up with suitable root causes and action items.

Involved in walk throughs and code reviews.

Environment: Win Runner, Load Runner, Test Director, Manual testing and SQL Client: Fidelity Investments, NH Mar 1997 – Jul 1997 FESCO is the division of Fidelity Investments that manages the Payroll as well as the Health and Welfare benefits of other organizations. The HOBS (Health and other benefits software) system is used for the health and welfare management purpose. I was associated with the development, unit, integration testing of the Reporting tools of this system. Responsibilities:

Develop pre-load programs using COBOL, JCL to load data into the DB2 from VSAM data sets.

Developed several DB2, COBOL batch applications to have the file extracts and send it to external systems.

Used ENDEVOR to promote code to different levels such as system, pre-prod, production.

Used IDCAMS to define, copy VSAM datasets

Developed JCL’s to backup the data into VSAM datasets.

Used QMF to test complex queries

Prepare test plans, test cases and test data

Performed coding, unit testing, regression and progression testing

Provided production, implementation and environment support Environment: COBOL, JCL, DB2, VSAM, Endevor.

Contact this candidate