| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
USA CitizenKey Skills and KnowledgeQA 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 & SolutionsTelecommunication, Finance, Mortgage, ETL, Data ware House, Software development methodologiesManagementProviding LOE, Project Progress Monitoring and reporting, Conducting Interviews, Creating deliverablesDatabasesOracle, DB2, SQL Server, Sybase, Access DB,Netezza,Redshift, PostgreSQLCertification:Cognos Report Net ProductCognos Report Net AuthoringCognos 8 BI AuthorCertified Scrum MasterAgile Safe 5.1Operating SystemsUNIX, DOS, Windows NT/2000 and Windows 95/98/XPProgramming Languages & ToolsSQL, UNIX, Clear Case, Clear Quest, Quality Center (ALM), POSTMAN, SOAPUI ProOffice Productivity ToolsLotus Notes, Outlook ExpressTechnical DocumentationTest Plan, Test Case, Software Migration Report, RTM Document, Defect matrix, Test summary report, Software Testing Progress graphs and documentation, Application User manuals, JIRA,XRAYEducationMasters in Electronic Media, 2005 IndiaBachelors in Industrial Electronics, 2003 IndiaSkills Summary15 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 ExperienceFannie Mae, Herndon Dec2014 PresentRole: Test Lead ContractorResponsibilities: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 RTMUsing 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 & ScorecardsPerforming 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 buildThe 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 2014Role: Backend Tester ContractorResponsibilities:Involved in requirement analysis and rectifying any discrepancies.Write Test plans and Test cases for Integration testing, System testing, Stress testing., Performance testing, Regression testingCoordinate 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 toolParticipated in enhancement meetings to distinguish between bugs and enhancements.Also documenting and maintaining the System test cases and generation of test summary reportsMonitoring and reporting the system test progressTrain the test team on different parts of STLC (System Testing Life Cycle) and test tools.Times Magazine Oct 2010 Jan 2012Role: Cognos DeveloperResponsibilities:Understand the requirements from Team membersDevelopment of Reports in Cognos 8 Report StudioEnhancing Existing Reports with the changes requestedTesting newly developed and Enhanced reports.GE Global Signaling, Grain Valley, Missouri, USA Oct 2007 Aug 2010Role: Cognos/Informatica DeveloperResponsibilitiesUnderstanding 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 playTransformer, Oracle, APPWORX, AS400, Windows XP, UNIXGE Energy - HQ Cognos Level 3, Atlanta, GA Aug 2006 Oct 2007Role: Cognos DeveloperResponsibilities:Creating various reports as for the requirements of the management.Designed Drill through reports.Developed the Cross tab, list reports and graphs as per therequirements.Developed Adhoc reports using Query Subject.Developed Reports using stored procedure as Data sourcesInvolved in preparing the technical specification document as per theuser requirement.Involved in Preparing of test case,user manuals, technical specificationdocumentDeveloped some reports with concept of cascading and value promptsas per the Business requirements.Involved in testing the reportsEducationMasters in Electronic Media, University of Madras, Chennai, 2005 IndiaBachelors in Industrial Electronics, Bharathidasan University, Trichy, 2003 IndiaProfessional Training and certificationsCognos Report Net ProductCognos Report Net AuthoringCognos 8 BI Author |
