SUMMARY:

• 14 years of IT experience in Software Development and Testing of Web - Based, Client Server Applications.
• Expertise in implementation, Customizations and Integrations of eGRC RSA Archer 5.5 and 6
• Knowledge on eGRC Archer 6.1
• Expertise in Enterprise Governance, Risk and Sox Compliance.
• Good Knowledge on Threat Management, Vendor Management, Vulnerability Risk Management(VRM),Risk Mangement,BusinessContinuityManagement,ComplianceManagement,IncidentManagement,Policy-Management,Audit Management.
• Scripts and Applications codes in SeleniumRC, WebDriver, QTP and T-SQL Transactions.
• Experience in Automations Tools like Selenium,SOAPUI, QTP/UFT 10.0 and Exposure on QTP/UFT 11.5 UFT.
• Expert in Defect Reporting and Tracking using Test Director/HP Quality Center, JIRA, IBM Rational Clear Quest.
• Preparation of Test Plan, Test Cases, Test Strategies and Test Effort Estimation.
• Excellent skills in Database Testing. Experience in Testing Incoming Data values and out going data value with queries, stored procedures, functions and joins.
• Excellent Experience in Testing ETL Packages such as SSIS, SSRS, Informatica IDQ Validating Data in Destinations.
• Proficiency in customization & implementation of Web Applications
• Strong Experience in Agile Methodologies, Scrum Methodologies.
• Experience in Wealth Management and Invest management.
• Experience in creating Data marts from different Data sources, and filtering data in it and customizing and trouble shooting performance counters in it
• Strong troubleshooting and organizational skills.

TECHNICAL SKILLS:

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS)

Databases: MS-SQL Server 6.5/7.0/8.0/9.0/10.0, MS Access 97 & 2000

Reporting Tools: MS SQL Server Reporting Services, Integrating Services, Crystal Reports, Informatica, Analysis Services, Micro strategy.

Testing Tools: HP Quality Center, SmartBear, Selenium RC Junit, WebDriver JUnit, QTP/UFT 10.0, ITKO, SeeTest,Perfecto,Eggplant,Jamo.LoadRunner,Appium, MonkeyTalk.

Web Servers: IIS 5 and 6

Languages: MS SQL Server 2005(9.0)/2000(8.0)/7.0/6.5, T-SQL, VB.NET, C#, ASP.NET, TIBOC, BPF, AJAX,XML,PL/SQL, VB Script, JavaScript, Turbo C, C++, Java.Informatica.COBOL.MS CRM Dynamics.VisonPlus, RSA Archer Platform 5.5/6

Tools: MS SourceSafe, Legacy mainframes, MS Office 97/2000/XP, MS FrontPage 98/2000, MS Outlook 97/2000

Operating System: Windows 2000 Advanced Server/Server 2003/Professional/ NT 4.0, Win XP Prof/Standard, Win 98. Mac OS, IPhoneOS,IPad,Tablet, Android OS.

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, Virginia

RSA Archer Consultant/ Developer

Responsibilities:

• Expertise in Configuring the Operations Controls Platform Archer Platform.
• Involved in team grooming sessions for the finalizing the user stories for sprint.
• Involved in Setting up Notifications.
• Managed User Access and Importing/Exporting Data.
• Migrating from One Environment to another.
• Set up Dashboards, Reports,Iviews, Workflows and Workspaces etc.
• Attended the daily Scrum standup meetings and provided the updates on user stories which we are working to scrum master.
• Worked with Data Import Manager and Data feed Manager.
• Integrated the RSA Archer Product with external data sources to consolidate enterprise information.
• Designed best practices assessment campaigns to measures sox compliance across the organization.
• Developed various solutions for sox compliance and managed between the environments.
• Imported existing information from legacy systems into RSA Archer Applications and questionnaire.
• Interacted with various stake holders and created applications for Usecase solutions for Risk management and Policy management, Security management.
• Interacted with several technical teams across organization to gain partnership.
• Played a key role in Applications Architecture to work with client Goverance teams to align with the Enterprise Architecture standards and roadmaps.

Environment: RSA Archer Platform 5.5, WindowsServer 2012, SQL Server 2012,Rally, HP Quality Center ALM.

Confidential, Alpharetta, GA

RSA Archer Developer/ Administration

Responsibilities:

• Involved the full life cycle of Archer Configuration and Development of Confidential
• Involved in Setting up Notifications various groups
• Managed User Access and Importing/Exporting Data.
• Migrating and managing the solutions from One Environment to another.
• Set up Dashboards, Reports, views, Workflows and Workspaces etc.
• Worked with Data Import Manager and Data feed Manager.
• Integrated the RSA Archer Product with external data sources to consolidate enterprise information.
• Imported existing information from legacy systems into RSA Archer Applications and questionnaire.
• Interacted with Functional analyst and created applications for Use case solutions for Risk management and Incident management.
• Interacted with several technical teams across organization to gain partnership.
• Played a key role in Applications Architecture to work with client Governance teams to align with the Enterprise Architecture standards and roadmaps.

Environment: RSA Archer Platform 5.5, WindowsServer 2012, SQL Server 2012,Rally, HP Quality Center ALM.

Confidential, Somers, New York

RSA Archer Consultant/ Developer

Responsibilities:

• Expertise in Configuring the Operations Controls Platform RSA Archer Platform.
• Involved in Setting up Subscription Notifications.
• Managed User Access and Importing/Exporting Data.
• Interacted with various stake holders and created applications for Usecase solutions for Risk management and Policy management, Vendor Management,Incident Management
• Configured the Iviews, Reports, Dashboard and Assigned to various Groups .
• Configured the Access controls for Various Roles and Groups.
• Developed various solutions for sox compliance module and managed between the environments.
• Interacted with several technical teams across organization to gain partnership.
• Involved in creating solutions for RSA Archer UseCase Modules
• Maintained and updated the various Policy Management Documents relevant to RSA Archer Platform
• Played a key role in Applications Architecture to work with client Goverance teams to align with the Enterprise Architecture standards and roadmaps.

Environment: Windows Server 2008, RSA Archer Platform 5.5, SQL Server 2008, HP Quality Center.

Confidential, NewYork City, NewYork

QA Analyst

Responsibilities:

• Participated in full life cycle of create invoice project. Analysis, design and documentation
• Involved in preparing Master Test Plan and Reviewing with Developers and made changes According to business requirement.
• Created and tested the SAP BO Objects reports and logged the defects and closed the defects
• Participated in QA Meetings and Review the Business requirements for create invoice project
• Review the Business requirements of the invoice applications documents
• Logged the Defects for SAP BO Objects reports and closed the defects
• Attended the triage call meetings and provided the status on various QC’s
• Using Quality Center to Log the defects and Analyze and Assign them to responsible team and update accordingly.
• Conducted the End-End Data Validation Testing for SAP BO Objects Reports
• Deployed the test scripts in TFS Server
• Created Oracle Stored procedure and functions
• Involved in preparing the Test Catalogs and Test Cases and Review with Test Lead.
• Involved in Authoring Test cases and Executing the test cases.

Environment: Windows Server 2008, FoxPro, Eggplant,Appium, SAP Business Objects, Oracle11g,HP Quality Center.

Confidential, Dallas, Texas

QA Analyst/ Automation Tester

Responsibilities:

• Participated in full life cycle of Master data management project. Analysis, design and documentation
• Involved in Business meetings with TIBCO Architectures and gathered the Requirements.
• Involved in Preparing Master Test Plan and Reviewing with Developers and made the changes according to business requirement.
• Involved in Preparing Test Catalog’s and Test Cases and Review with Test Lead.
• Involved in writing the Test cases and Executing the Test cases.
• Participated in QA Meeting’s and provided status for various QC’s
• Tested the TIBCO Web services using SOAP UI and Validated the functions in it.
• Implemented the data driven frame in SOAP UI and Java Tested various functions in web services with different sets of data.
• Conducted the end-to-end mobile web application testing using emulator and logged the defects for it.
• Conducted the task of executing test cases on various devices like emulator and IOS devices with firmware 5.1.2 with 4G network.
• Conducted the regression testing on IPhone, IPad and Tablet Devices.
• Handled responsibilities of defining mobile specifications and implementing the test plans.
• Implemented the telemetry approach for all mobile applications testing.
• Responsibilities included acceptance testing, functional testing, Integration testing, system testing and performance testing.
• Reviewed the mobile security policies and prepared the test plans.
• Using Quality center to log the defects, Analyze and Assign them to responsible team and update the status accordingly.
• Involved completely in Software Development Test (SDET) Environment.
• Implemented the Batch processing for T-SQL Procedures.
• Deployed test scripts in TFS Server.
• Prepared Test Summary report and conditional acceptance memo if required.
• Conducted the cross browser testing to check the compatibility of the Applications with different browsers ( Confidential, Confidential, Confidential ).

Environment: Windows Server 2008, TIBCO CIM, SOAPUI, Java, HP QualityCenter.XML SPY.XML Web services.

Confidential, Irving,Texas

QA Analyst/ Lead

Responsibilities:

• Defined Testing Process and strictly following the process until testing is certified for the test phases.
• Participated in Full Life cycle for multiple Data project analysis, design,documentation, development and testing.
• Implemented Data Driven Test Script using Selenium RC Junit .for Smart Offer Project.
• Implemented Keyword Driven Test Scripts using Selenium Junit.
• Created Test Plan and Test Scenarios and Test cases according to Business rules and Functional Requirements.
• Worked with Business Analyst, developers and managers to resolve the Key issues in Project.
• Worked with BMC Quality Center to log the defects and analyze the tickets and assigning them to responsible team member
• Tested Web services using SOAP UI and SOA Reported Defects to developer. And generated Reports
• Created the scenario based automation test scripts right from scratch for whole smart offer project.
• Conducted White Box Testing for Smart Offer Tool.
• Implemented the Data Driven into SOAP UI and tested various functions in Web services.
• Responsibilities included acceptance testing, functional testing, Integration testing, system testing and performance testing.
• Involved in Performance testing of Application using Jmeter.
• Generated Logs and reports using Jmeter.
• Implemented the cucumber frame work using selenium Java(Junit).
• Troubleshooted the Automated test scripts and deployed into centralized server.
• Deployed the E-Commerce Automation (Smart Offer) Scripts in Centralized server SVN.
• Responsible for performing the Functional, Integration, Regression and UAT Testing.
• Fixed the issue in Data driven test scripts and delivered bug free test scripts.
• Conducted Cross Browser Testing to check the compatibility of the Application with different Browsers ( Confidential, Confidential, Confidential ). By configuring the Grid Nodes Testing.
• Worked as mentor for Whole Automation Project and guided the Offer team how to run automation test scripts using Selenium .Conducting review meetings with offer shore team and getting updates on Various QC’s and updating the status accordingly.
• Implemented the Behaviour Driven Development BDD Framework and fixed issues in it.
• Worked on Continues integration tool with Jenkins
• Worked in Agile/Scrum Methodologies.
• Created Keyword Driven Framework using junit Web driver.
• Participated in Review meetings and provided update on various QC’s.
• Created Screen shots for using Selenium junit for all Applications in project
• Executed test cases manually and identified the mismatches and logged the defects using HP Quality Center.

Environment: Windows Server 2003, Java, Junit,SOAP UI, SOA, Selenium, Web Driver BMC Quality Center, Fitnesse, Jmeter, LoadRunner, XMLSPY

Confidential, Pennington, New Jersey

QA Analyst & Engineer

Respons ibilities:

• Defined Testing Process and strictly following the process until testing is certified for the test phases.
• Participated in Full Life cycle for multiple Data project analysis, design, documentation, development and testing
• Created Test Plans, Test Scenarios, Test cases, Test Scripts, Traceability matrices according to Business and Functional Requirements.
• Work with business analyst, developers and manager to develop test plans, produce test scenarios and repeatable test cases/scripts through all parts of the development lifecycle, execute and sign - off for a high volume of data and regular release schedule for successful project delivery.
• Responsibilities included acceptance testing, functional testing, Integration testing, system testing and performance testing.
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Participated in QA meeting for providing update status on Various QC’s.
• Tested the IF Service of TIBCO for OAO Applications and Using SOAP UI solved the issues as per Business Requirement
• Conducted the GUI Functional and Integration testing for Mobile Applications using Emulator and Simulator tools and logged the defects for it.
• Implemented the telemetry approach for mobile application testing.
• Worked on various firmware like 4.4.1,5.2.1 for IOS and API level 5,6,7, for Éclair and API 18 for KitKat for Android.
• Conducted the end-to-end testing for mobile applications and various devices like IPad, Tablet.
• Conducted end-to-end testing for Android devices using ADB commands.
• Review the mobile security policies and prepared test plan.
• Assigned the task and provided the guidelines for mobile applications
• Implemented Parameterization in SOAP UI and Validated the various Restful Services and written Test Cases for and reported the defects to Developers..
• Conducted White box testing for OAO and US Trust projects.
• Implemented Data Driven in SOAP UI and tested various functions in Web Services. With Data..
• Implemented Data driven Test scripts using Selenium RC Junit for OAO Project.
• Implemented Hybrid driven test scripts using Selenium Junit and TestNG for Alerts projects.
• Implemented Fitness Framework using Selenium Junit for CAMU Project.
• Responsible for the Analysis of software applications and computer systems, Focus of the effort is on batch process modules, UI screens, and Reports
• Implemented the cucumber frame work (BDD) using Selenium Java(Junit).
• Conducted the Node Testing with Grid Nodes for cross browsing testing.
• Implemented the Batch Processing for T-SQL Procedures.
• Mentor testers and answer technical questions related to SQL and test strategy.
• Using Clear Quest, Quality Center to log the defects, analyze them and assign to the responsible team and update with the proper data to reproduce the defects.
• Troubleshooted the automation test scripts and applications using Log files and Fixed issues in it.
• Analyzing Test Results, Recording Defects encountered while Test execution and Tracking them to their closure.
• Worked on with Continues Integration tool of Jenkins.
• Wrote test case scripts; executed and documented detailed results and summary reports.
• Executed systems and data quality testing to ensure all development deliverables are production ready.

Environment: Windows Server 2003, Quality Center, Java,Junit, C#,TFS,ASP.NET,TIBCO,BPF,SQL Server 2008,RestFull Webservices, SOAPUI,IOS,Android Emulator, Simulator,SOA, Clear Quest,Selenium RC

Confidential, Montpelier, Vermont

QA Analyst & Engineer

Responsibilities:

• Complete Responsibility in manual testing, Automation testing of the compliance and discretionary projects in both Auto and property lines of business.
• Prepared Test Plan Which covers the Test Estimation for Future Release.
• Performed manual testing of Active X components for windows flavor (Windows XP/2000/NT).
• Created Mappings for the Requirements in Test Lab from iteration to Iteration
• Participated in Business meeting for gathering requirements for multiple projects.
• Executed test cases manually and identified the mismatches and logged the defects using HP Quality Center.
• Execute and sign off on test scripts. Work closely with Ops Manager to update Release Grids.
• Wrote test case scripts; executed and documented detailed results and summary reports for P&C Applications
• Preparation of Test Procedures, Executing Test Cases both manual and automated test cases using HP Quality Center.
• Executed SQL Queries for Database end-to-end testing
• Supported production deployments over the weekends.
• Configure test environment for the specific test cases, created test data and execute manual tests, document results.
• Conducted White box testing for SSIS and SSRS Packages and Reports for Property and Causality (P&C) Applications.
• Implemented Data Driven Test Scripts for Whole Project. Using selenium RC Junit.
• Responsible for performing the Functional, Integration, Regression and UAT Testing .
• Worked on Web services to combine component based development and internet standards and protocols that include HTTP,XML, SOAP UI and Web services Description language.
• Perform Integration test by running ETL jobs, validating data loads, troubleshooting job execution errors and executing test scripts
• Work with development, QA, and Automation engineers to research, design, and develop complex test automation units.
• Implemented the Batch Processing for T-SQL Procedures for SSIS Packages.
• Using JIRA to log the defects, analyze them and assign to the responsible team and update with the proper data to reproduce the defects.
• Participate in production release validation to ensure successful deployments of products without any performance issues.
• Prepared Test Summary report and conditional acceptance memo if required.

Environment: Windows Server 2003, JIRA,SQL Server 2008, SOAP,XML, TIBCO, BPF Services,Informatica, Web Services, SOAPUI, Clear Quest.

Confidential, Mclean, VA

QA Analyst

Responsibilities:

• Create test script and test cases by working with business analysts and developers to review business requirements, functional specifications and technical solution design.
• Analyzed Use Cases and developed Test Plan, Test Scripts and Test Cases and executed them.
• Executed the test scripts on different releases as well as in different modes and validated the actual results against the expected results using HPQC.
• Performing Smoke, Integration, Validation and Compatibility testing of the application manually.
• Automated Test cases and developed tests for Regression Testing using Mercury Imperative’s Quick Test Pro.
• Involved in the conversion of Manual regression test cases to Automation Test Cases
• Maintained automation scripts, object repositories, functional libraries in Selenium Junit RC
• Generated Bug (Defect) Reports and track the status of each defect.
• Worked with the development team to create a suite of test data to exercises data validation and actual ETL functionality
• Created Data Driven Frame works using QTP/UFT 10.0.
• Performed Data Validation of the data flow by performing end to end testing.
• Used Quality Center for defect tracking and reporting (logged defects, change Requests, recorded defect details, assigned severity and reported defect status).
• Involving in Risk Analysis, Root cause analysis, Walkthroughs and Release support
• Developed and executed SQL queries to verify the proper insertion, deletion and updates into the data Warehouse supporting tables and cubes using TOAD.
• Worked closely with the development team and the State user in an Agile environment to quickly identify issues
• Interaction with developers for resolving the critical bugs and functionality modifications.

Environment: QTP, QualityCenter9.2,SOAPUI,Webservices, Java, JavaScript’s, HTML, VBScripting, Oracle10g/11g,WindowsXP.

Confidential, New York City, NY

QA Analyst/ QALead

Responsibilities:

• Participated in full life cycle of CRM Sales and Services Project, Analaysis, Design and Documentation.
• Perform quality assurance analysis and testing on an Enterprise-level web application for the Life style Products
• Responsible for application analysis, test strategy development, test case creation, test script development, test execution, defect tracking and reporting.
• Involved in Business Requirement with various CRM experts.
• Responsible for the Analysis of software applications and computer systems, Focus of the effort is on batch process modules, UI screens, and Reports.
• Create automated test scripts for CRM Applications using QTP for automation of the manual scripts
• Perform Backend database testing to validate the data using complex SQL queries,
• Created a data driven framework using QTP and Automation Scripts using QTP.
• Worked on Web services to combine component based development and internet standards and protocols that include HTTP,XML, SOAP and Web services Description language.
• Conducted Cross Browser Testing to check the compatibility of the CRM Applications with different Browsers ( Confidential, Confidential, Confidential ).
• Conducted Review meetings for Tickets raised for CRM Applications and closed the tickets.
• Use chart graphs to test positive & negative scenarios based on the test cases
• Work with development, QA, and Automation engineers to research, design, and develop complex test automation units.
• Managed the team of 10 people and Guided them how to run automation test scripts using QTP.
• Conducting the review meetings with team and getting updates on Tickets’s and updating the Status accordingly.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Participate in all stages of testing, such as Unit, Integration, Regression System and UAT testing, in both manual and automation environment.
• Absorb and understand system design, data model, and functional components of large software system

Environment: Windows server 2003, JIRA, SQL Server 2008,QTP, SiebelCRM, SOAP,XML, Web Services. Clear Quest.

Confidential, Edison, New Jersey

QA Analyst/ Engineer

Responsibilities:

• Installed, Upgraded, and configured SQL Server 2000 and replication servers on Sun Solaris and Windows NT.
• Reviewing business requirement documents to get a better understanding of the system on both functional and business perspectives
• Perform quality assurance analysis and testing on an Enterprise-level web application for the Life style Products
• Responsible for application analysis, test strategy development, test case creation, test script development, test execution, defect tracking and reporting.
• Involved in Business Requirement with various Retail experts.
• Responsible for the Analysis of software applications and computer systems, Focus of the effort is on batch process modules, UI screens, and Reports.
• Create automated test scripts for Retail Applications using QTP for automation of the manual scripts
• Perform Backend database testing to validate the data using complex SQL queries,
• Created a data driven framework using QTP and Automation Scripts using QTP.
• Conducted Review meetings for Tickets raised for Retail Applications and closed the tickets.
• Work with development, QA, and Automation engineers to research, design, and develop complex test automation units.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Participate in all stages of testing, such as Unit, Integration, Regression System and UAT testing, in both manual and automation environments.
• Mentor testers and answer technical questions related to SQL and test strategy
• Identify the test environments and prepare the Test Environments booking and maintenance Plan. Coordinated the testing with different teams.
• Prepare Detailed Test Schedule and Test Resource Allocation W.R.T Test Estimation provided.
• Conducted Cross Browser Testing to check the compatibility of the Application with different Browsers ( Confidential, Confidential, Confidential )
• Configure test environment for specific test cases, create test data, and execute manual tests, document results, assigning the defects to development team and update defect tracking systems.
• Participated in regular project status meetings related to testing

Environment: Windows Server 2000, SQL Server 2005, T-SQL, Quality Center, TestDirector, QTP.

Confidential

Sybase Administrator

Responsibilities:

• Designed and developed user interfaces using web forms.
• Involved in the Design of the Database (Sybase Server ).
• Used Custom built Application Framework to build the Data Access Layer.
• Created Complex Stored Procedure in Sybase Server 11.5 .
• Tracking and closing the Issues.
• Designing and modeling database according to Requirement. And made changes according to it.
• Tested Sybase databases. Using DML Commands.
• Implemented Complex Procedures using UNIX Shell scripting Programming Language.
• Maintained all the databases and making working in optimal level.
• Created database, Managed storage devices, fragment, segment, threshold, and administered security role.login,user/alias/group,object/command permissions.
• Created Web services for PMS and Document management Modules Using ASP.NET
• Created Custom and User Controls using ASP.NET Webforms.

Environment: Windows Server 2000 Sybase Server, C#,ASP.NET IIS, WebServices.JavaScripts.