Immigration Status

USA Citizen

Key Skills and Knowledge

QA management, SDLC, STLC, Requirement Analysis, Quality Center (ALM), SQL, Python,AWS,Oracle, UNIX, ACCESS, Test Tools (QTP), Production Support, UAT support, Informatica Power center 8, Cognos, SSRS Reports development.

Domain Expertise & Solutions

Telecommunication, Finance, Mortgage, ETL, Data ware House, Software development methodologies

Management

Providing LOE, Project Progress Monitoring and reporting, Conducting Interviews, Creating deliverables

Databases

Oracle, DB2, SQL Server, Sybase, Access DB,Netezza,Redshift, PostgreSQL

Certification:

Cognos Report Net Product

Cognos Report Net Authoring

Cognos 8 BI Author

Certified Scrum Master

Agile Safe 5.1

Operating Systems

UNIX, DOS, Windows NT/2000 and Windows 95/98/XP

Programming Languages & Tools

SQL, UNIX, Clear Case, Clear Quest, Quality Center (ALM), POSTMAN, SOAPUI Pro

Office Productivity Tools

Lotus Notes, Outlook Express

Technical Documentation

Test Plan, Test Case, Software Migration Report, RTM Document, Defect matrix, Test summary report, Software Testing Progress graphs and documentation, Application User manuals, JIRA,XRAY

Education

Masters in Electronic Media, 2005 India

Bachelors in Industrial Electronics, 2003 India

Skills Summary

15 years of professional IT experience in software development and Quality Assurance with an extensive background in quality assurance, design verification, production support.

Extensive experience in ETL testing, backend testing and development methodologies like Agile, Water fall.

Experienced in leading integration testing and User Acceptance testing.

Vast experience in Finance and Mortgage domain,

Excellent writing, presentation and communication skills. Experience bnnbnd in demonstrating to both technical and executive team.

Experienced in mentoring and motivating cross-functional teams. Good team player and individual contributor.

Hands-on ability to direct and improve quality programs, reducing defects and improve overall efficiency and productivity.

Project Experience

Fannie Mae, Herndon Dec2014 – Present

Role: Test Lead – Contractor

Responsibilities:

Analyzing Use Case Specifications and formulated project scope and objectives.

Participate in agile meetings and technical planning meetings.

Develops and documents application test plans based on business requirements and technical specifications.

Created/assisted test deliverables namely test plan, test strategy, test cases and RTM

Using JIRA and SharePoint Sites to store all testing results, metrics, test plan documents, defect tracking and reporting.

Working closely with Product Development team to ensure all software bugs are caught in house before the software is delivered to the customer.

Skills include -Requirements Gathering & Analysis, User Acceptance Testing (UAT), Enterprise Implementations Dashboards & Scorecards

Performing shakeout and running the runbook steps after each migration.

Executing ETL jobs and data comparisons (test cases) in AutoSys.

Exclusively used Informatica for job Monitoring and debugging failure jobs.

Data validation is done by DTF (Data Testing Framework )

Generating RTM (Requirement Traceability Metrics) for management statistics.

Documenting and maintaining System test cases, generation of test summary reports.

Migrating data from Oracle to Redshift (AWS) and performed data validation.

Executing and monitoring the stored procedures in EMR.

Validating the data in ATHENA and GLUE tables.

Job execution from EMR.

Perform Business Validation in Production.

Support release activities.

Validation in production environment.

Reviewing the results with Business.

Scope of testing includes.

- Manual Testing

- Functional Testing of various modules of the application.

- Interface, Integration Testing of the application

- Performance Testing

- Regression Testing on each new build

The job requires frequent interaction with the USER to understand the requirements.

Primarily Testing but also perform business analysis for the requirements.

Freddie Mac, Mclean, VA April 2013 to May 2014

Role: Backend Tester – Contractor

Responsibilities:

Involved in requirement analysis and rectifying any discrepancies.

Write Test plans and Test cases for Integration testing, System testing, Stress testing., Performance testing, Regression testing

Coordinate and prepare the test data.

Responsible for loading the loans in the system, processing the loans and testing the loans for expected results with desired messages.

Executing the automation scripts and analyzing the results.

Performing smoke testing after each new build.

Performing data analysis and creating test bed and conducting data base testing.

Involved in meetings with Data Modeling team to discuss on the reported defects.

Report the issue in the bug tracking tool

Participated in enhancement meetings to distinguish between bugs and enhancements.

Also documenting and maintaining the System test cases and generation of test summary reports

Monitoring and reporting the system test progress

Train the test team on different parts of STLC (System Testing Life Cycle) and test tools.

Times Magazine Oct 2010 – Jan 2012

Role: Cognos Developer

Responsibilities:

Understand the requirements from Team members

Development of Reports in Cognos 8 Report Studio

Enhancing Existing Reports with the changes requested

Testing newly developed and Enhanced reports.

GE – Global Signaling, Grain Valley, Missouri, USA Oct 2007 – Aug 2010

Role: Cognos/Informatica Developer

Responsibilities

Understanding the functional requirement documents.

Interacting with the OSC to discuss the status of the project, clarify any queries regarding the functionalities.

Worked closely with business users while gathering requirements, analyzing data and supporting existing reporting solutions.

Designed various types of reports according to end user requirements.

Created different kinds of reports including List, Cross-tab, Charts, Conditional Block and Prompts, Dash Boards and Master Detailed Reports in Report Studio.

Developed the Reports using the Prompts, Filters, Drill Through and Calculations in the Reports.

Applied the Conditional Formatting using the conditional variables to high late the data and rendering the objects.

Developed the complex reports using Query Calculation and Layout Calculation.

Designed Drill-through reports and Dash board reports.

Responsible for mentoring and training Cognos developers.

Developed Prompt pages and Conditional Variables.

Testing and improving Report Performance.

Assisted in creating Cubes in Analysis Studio and involved in building multi-dimensional cubes in Power play transformer.

Control procedures for Development, Test, Staging, and Production.

Validated the Reports with database and review the Reports and test cases.

Consistency in having FTR (First Time Right), OTD (On Time Delivery).

Developing and maintaining the existing Informatica mappings.

Analyze the changes to the existing systems and defect fixes /new requirements, mappings involved and validate the changes implemented starting from Source to Staging to Core (Data Mart).

Creating Schedule in Appworx for Informatica mappings and for the Procedures.

Monitoring important jobs in Appworx.

Environment: Informatica PowerCenter 8, Cognos 8.3, Cognos Report Net, Power play

Transformer, Oracle, APPWORX, AS400, Windows XP, UNIX

GE Energy - HQ Cognos Level 3, Atlanta, GA Aug 2006 –Oct 2007

Role: Cognos Developer

Responsibilities:

Creating various reports as for the requirements of the management.

Designed Drill through reports.

Developed the Cross tab, list reports and graphs as per the

requirements.

Developed Adhoc reports using Query Subject.

Developed Reports using stored procedure as Data sources

Involved in preparing the technical specification document as per the

user requirement.

Involved in Preparing of test case,user manuals, technical specification

document

Developed some reports with concept of cascading and value prompts

as per the Business requirements.

Involved in testing the reports

Education

Masters in Electronic Media, University of Madras, Chennai, 2005 India

Bachelors in Industrial Electronics, Bharathidasan University, Trichy, 2003 India

Professional Training and certifications

Cognos Report Net Product

Cognos Report Net Authoring

Cognos 8 BI Author

Contact this candidate