Summary:

• Senior analyst database security global processing solutions risk analysis audit quality assurance uat test coordinator
• Experienced Information Technology and Security professional with 10 years of success in supporting Information Security and Administration for Databases and Applications within the financial industry. Led and implemented complex Global IT solutions successfully in business mergers, migrations and work flow solutions using multi technology environments. Effectively prioritizes activities and achieves defined objectives with high quality and standards. Ability to work in new technologies, environments and translate business requirements into IT solutions. Skilled technologist that thrives in a fast paced, rapidly changing environment and always brings an uncompromising commitment to customer satisfaction.
• Career Accomplishments
• Standardized IS processes/policies for DB Systems Experience in Provisioning and de provisioning/Identity Workflows, Access Management, RBAC Role-Based Access Control , Authentication and Authorization technologies Managed and improved service levels to achieve average 99 for an entire business area Achieved substantial cost savings through continuous improvement of processes Conducted UAT for over 150 products in Citi marketplace, VSR Led and trained Level One IT staff Developed and implemented complex user request workflows including eWorkflow, VSR, and automating Citi Marketplace product forms Conduct training for an international Level One support staff Excellent experience in Software Quality Assurance QA Testing Involved in Complete Software Testing Life Cycle and Software Development Life Cycle Good experience in Agile and Waterfall methodology Extensively worked as a QA Analyst in Web applications, Client Server Applications and Database Systems for different software domains Proficient in test execution and management of testing defects.

Professional Experience

Confidential

Role : QA Analyst Manual Testing

Environment: JAVA, PHP, Apache Tomcat, Dream Viewer, JQuery, Java Script, HTML, SoapUI, SQL, QTP, Selenium, HP ALM Quality Center , Mobile Application Testing, VBScript, XML, Web Services, Informatica.

• Experience working in an Agile environment, attended daily standup meetings, reviewed user stories.
• Designed and Developed Test plan based on BRD and User Stories.
• Developed and Executed Test Cases in VersionOne Tool.
• Tested all modules Patient Management, Doctor, Admin and Insurance Claims.
• Validated HIPPA rules.
• Validated the connection and data between Admin web services and Insurance claims web services.
• Written and executed SQL queries and Joins, Group By clause, having clause etc. to validate the data.
• Filed and tracked the defects using HP Quality Center ALM .
• Developed and executed test cases for EWS Enterprise Web Services /XML / SOAP and RESTFul services using SoapUI tool.
• Validated reports by executing SQL queries and compared the data using File comparison tool ExamDiff.
• Created Test Data for QA and UAT.
• Involved in Smoke Testing, Regression Testing and User Acceptance Testing.
• Involved in ETL Testing Data is extracted from flat files, multiple databases and transferred to target database. Validated the data as per the Mapping Documents.
• Tested Mobile version of the application.
• Prepared daily/ weekly status reports on Test case execution, defects, RTM etc.
• Involved in planning test execution activities, defect reporting and analyzing test metrics.
• Followed Agile/Scrum Methodologies for all of the project activities.
• Expertise in testing various applications developed in Java, .net, Oracle and C
• Well versed in analyzing Requirements, System Specifications, Use-Cases and Technical specifications
• Tested WebServices /XML / SOAP and RESTFul services using SoapUI tool
• Experience in writing Test Plan, Test Cases for Web and Client/Server applications
• Good experience in SQL queries and Joins Executing Shell script in UNIX / Linux
• Experience in GUI Testing, Regression Testing, Data Driven Testing, Functional Testing, Database Testing and User Acceptance Testing. Experience in Black Box testing
• Good at bug-reporting and bug-tracking using Test Management tools like Quality Center, Clear Quest, Bugzilla, VersionOne and Jira.

Confidential

Role: AVP, Global Id Administration

Environment: HP UX, IBM AIX, Sun Solaris, Windows, Sybase 12x, Oracle 9i/10g/11g, SQL Server 2000/2005, VB Script, Unix Shell, ASP 3.0, SQL Server Management Studio 2008, Visual Studio 2005, DB Artisan 8x, Toad 7.5, LDAP site minder single-on, Sybase Power Designer, Erwin, MS Access, SharePoint and Business Objects 12x, QTP , UFT , HP Quality Center, JIRA , CA IdentityMinder, Sun Identity Manager, Sun Access Manager, Login Management System Single Sign-on SSO , Oracle Identity Manager , Citimarketplace automated products

• Designed provisioning/deprovisioning workflow use cases, password management use cases, test cases and provided training.
• Responsible for testing automated products which used Sun Idm from Dev to UAT to Production implementation. Trained both level1 staff and end users on Sun IdM automation product.
• Worked towards facilitating the process of user ID provisioning / deprovisioning and account/role setup/modification. The product with a controlled workflow reduced errors, while enabling automated account fulfillment. As administrators had the ability to instantly view and change access rights.
• Citimarketplace had products/set workflows for managing access requests, with the option of multiple stages of reviews with approval requirements for each request. The application manager or business manager or BISO could further approve the request based on the complexity of the access being requested. This mechanism facilitated setting different risk level-appropriate approval processes for higher-level access.
• Provided comprehensive Database Architecture and Administration support for Sybase, MSSQL, Oracle
• 24/7 Client Support for 14,000 data servers globally, provide production support for existing processes
• Developed functional documentation which fully describes the current structure of the system, along with impacts to the system resulting from proposed changes.
• Guidelines from Frameworks: International Organization for Standardization's ISO27000 series:ISO27001 COBIT Control Objectives for Information and related Technology
• RCSA, Audit, and Risk Analysis and support.
• Risk and Control Self-Assessment RCSA : Conducted RCSAs within internal audit during the past several years. RCSA is a useful tool to front-end the audit process. This technique involved bringing the staff of an entire unit or several interrelated units together for a facilitated workshop. Not only risk and control issues were exposed and action plans were devised to address those issues. This allowed involvement of teams in assessing risk since they know the business process better than anyone else
• Details while processing RCSA self-assessments:A Obtained an understanding of business requirements, associated risks, organization structure, roles and responsibilities, policies and procedures, laws and regulations, management reporting and the control environment.B Evaluated the controls by reviewing whether documented processes exist, there are appropriate deliverables, responsibility and accountability are clear, and effective and compensating controls exist where necessary.C testing and validation of the controls .The assessments were tracked , submitted on the RCSA site. Gaps identified were escalated to senior management to have them remediate it.iCAPs were initiated to fix gaps.
• Worked on Design and Development of Information Security initiatives like Functional Id Management, Segregation of Duty, Emergency/Temporary Account management.
• Management of access control workflows and questionnaires in a standardized tool, reviewed and approved requests within a standard SLO
• Identified risks to the release by carefully evaluating scope and its complexity, and mitigated by partnering with Development and Product teams.
• Provide Subject Matter Expert level support for database security across multiple database systems.
• Cooperate with CATE Solution development teams and help with implementation of automation solutions on databases level.UAT conducted on citi marketplace products
• Worked with QA team to facilitate feed testing, worked on HP Quality Center with all of its modules.
• Reviewed and responded to all user feedback to ensure all items are addressed during test execution.
• Conducted daily, weekly checkpoint meetings with UAT participants during execution of tests.
• Documented BRD, FRD functional requirements, producing detailed functional specification.
• Work with build and component testing staff to ensure deliverables meet business requirements
• Work with business partners to help identify, analyze and resolve data errors and inconsistencies
• Generated daily, weekly, monthly metrics for the team.