SUMMARY

• 9 Years of experience in Software Development in roles of Business Analyst, Data Analyst and SQA - Manual and Automation.
• Well versed with complete Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) process with expertise in Software Quality Assurance, Business
• Analysis, Implementation & Maintenance of Data and Applications and Quality improvement to ensure that the process is of the type and quality needed and expected by the client.
• Possess proven capabilities in Project processes tailored for Waterfall, SCRUM and Agile SDLCs.
• Proven capabilities in Offshore Management and Team building.
• Backed by excellent communication, attention to detail, self-motivation, problem-solving, organizing and planning skills, with ability to work independently or in team environments to meet or exceed client expectations.
• Hands on experience on managing teams.
• Experience in writing Business Requirement Documents depicting business flows & rules, processing-sequences, use-cases & inter-dependencies using UML-based standards.
• Extensive experience in Data Analysis.
• Hands on Experience in creating Data Mapping requirements.
• Hands on experience in Creating & Maintaining Traceability Matrix for maintaining & tracking scope from Initiation to Closure phases of the SDLC.
• Experience in Business Analysis using UML standards, Data Analysis, Analysis of Data Flows, Business Rules definition, Gap Analysis.
• Experience in preparing business cases, use cases, Business Models, process & state charts, activity diagrams, UI screen mockups, interviewing stakeholders, conducting JAD sessions.
• Experience in full development life cycle including developing and implementing test plans, test scripts and processes - for Functional and ETL test environments.
• Good knowledge of Back End / ETL Testing, comfortable with Databases, Data Files, Data mapping, Data Mining, Data analysis using SQL and relational database technology. Extensive Experience writing and executing complex SQL queries with joins across multiple tables.
• Hands on experience in Automation using UFT and TAF Framework and running scripts through QC.
• Experience in running UNIX commands in a Database environment.
• Experience in managing the test defect tracking resolution and retesting cycles and ensuring the issues are properly tracked from discovery to closure using Quality Center and JIRA and uploading all test artifacts on Sharepoint.
• Hands-on experience with System Testing, Functional Testing, Stress Testing, Integration Testing, Regression Testing and Back End Testing.
• Extensive experience in assisting business with User Acceptance Testing (UAT) and PROD checkouts after deployment.

TECHNICAL SKILLS

Environment: ETL, Java

Testing Tool: UFT, TAF

Test Reporting Tool: Quality Center, JIRA

Operating System: Windows Family, UNIX, LINUX

Database: Aqua Data Studio, Oracle, MS SQL Server 2005/2008, MS Access, DB2, Squirrel

Testing Language: VB Scripting

Web Technology: XML, HTML

Version Control: SVN

UML Tools: MS VISIO

Other: MS Office (Word, Excel, PowerPoint)

PROFESSIONAL EXPERIENCE

Confidential, Boston MA

QA Automation Lead

Responsibilities:

• Utilize Agile methodology to complete all testing activities within allocated time Period.
• Understand the business requirements, use cases documents for any new Confidential enhancements.
• Prepare Testing strategy, Test approach, Test Plans, Test scenarios and Test cases.
• Write, maintain, and execute test scripts, test plans using Automation tools like UFT and TAF Framework.
• Manage deliverables to meet milestones and scheduled releases.
• Complete the Testing process, effectively by Utilizing tools like SQL Squirrel Client, RTC, HP ALM Quality Center & UFT.
• Perform Smoke Testing, GUI Testing, Functional Testing, Database testing, End to End testing and Regression Testing.
• Frequent Client and Business Interaction to deliver better quality product.
• Perform internal review for Test cases and Test Execution results done by Offshore Team members to ensure the quality.
• Lead daily Stand up call with Off-shore team to get the accurate testing status.
• Lead vendor and SS daily status meeting.
• Conduct internal demo on the final product that was tested and getting Feedback from Product Owner.
• Utilize HP-ALM (Quality Center) to conduct test activities including writing, execution of test cases, logging, tracking defects, and publishing of reports with test metrics.
• Overall Test Management: Design, Execution, tracking issues and coordinating project activities to meet project deliverables.
• Provide on-going Test Execution Status project reports to State Street Manager.
• Participation in project meetings/design groups with other team members.
• Handle Knowledge sharing sessions to new resources in my team.
• Work closely with peer employees to share knowledge and get expose to the business in greater extent.

Confidential

Business Tester / Business Analyst

Responsibilities:

• Onboard and train offshore resources.
• Work closely with BA and PO to understand requirement.
• Update tasks on RTC on daily basis.
• Follow daily team tracker to see stories assigned to the team members.
• Test planning and Test execution for the stories assigned.
• Upload test cases in QC.
• Upon story completion upload results to RTC and send it for approval to PO and BA.
• Take active part in Planning, Backlog refinement and Retro meetings.
• Raise Impediments, and Escalate if needed.
• Demo stories at the end of the Iteration
• Pull stories from sister Agile teams based on Business Priority.
• Monitor release tracker to complete BUAT and CUAT check outs.
• Support PROD releases for PROD checkout.

Confidential

Responsibilities:

• Discuss and analyze the requirement document with PO.
• Understand the configuration changes that needs to be done for each release.
• Maintain the change control document internally.
• Validate the version control for various functions against vendor received TON’s.
• Develop Test Cases, Test Plans based on BRD, vendor test plan and impact analsis.
• Cordinate testing effort with team china.
• Run regression test cases through UFT.
• Run cucumber scripts for API testing.
• Run recovery if needed for various environment issues.
• Write SQL queries for ORD related test cases/ projects.
• Update task and test artifacts on RTC.
• Run all the test cases on QC.
• Run COA for various testing purposes.
• Raise defect on IIMS, vendor application for their reference.
• Raise defect on QC for SS internal purposes.
• Work closely with Scrum master and product owner to resolve any impediments.
• Take active part in Backlog refinement, planning and retrospective meetings.
• Assist business with UAT testing and application configuration.

Confidential

Responsibilities:

• Understand and analyze requirements, discussions with BA, review the FSD.
• Develop Test Cases, Test Plans based on Business Requirements Specifications.
• Build Automation Suite with comprehensive test cases for regression using TAF and UFT.
• Run TAF scripts through Quality Center in various DEV and IST environments.
• Prepare and execute test cases after thorough analysis of each requirement.
• Write SQL queries to perform backend testing.
• Worked with various teams Onshore / Offshore for coordination of testing. Offshore based out of China.
• Send out Weekly Test Status Report to Business and QA Managers.
• Used JIRA to report defects.
• Test Coordination of all Confidential Application Defects with the Vendor based in Denmark.
• Test Coordination with Confidential APAC and London team.
• Data migration from External Business Conduct (Legacy App) to Confidential Application.
• Assist business with UAT testing

Environment: Functional Testing, UFT & TAF, JIRA

DATA ANLYST

Confidential

Responsibilities:

• Understanding functional requirements & performing manual testing.
• Creation of test cases for DATA MIGRATION.
• Create and execute SQL queries to perform source to validation.
• Prepare data migration manuals for the QA team.
• Raising & Maintaining Defects using QC.

QA/UAT Analyst

Confidential, East Providence, RI

Responsibilities:

• Understand and analyze requirements, discussions with BA, review the FSD.
• Create / Review Test plans, Test Cycles, Test-Reports.
• Conduct and actively participate in reviews, walkthroughs of test cases.
• Review the ETL mappings (Informatica) to ensure the transformation rules are applied correctly.
• Defect lifecycle management & analysis.
• Daily and Weekly Status Reporting to the Client and Senior Management Review.
• Identify fields and data defects with required information in ETL process in various jobs and one to one mapping.
• Test Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Validate the data in the reports / extracts by writing simple to complex SQL queries in the transactional system.
• Maintained and Ran QTP scripts to validate data in staging and target databases.
• Oversee the historical loads in UAT and PROD environments.
• Work on Integration of all the processes in UAT/PROD.
• Prepare test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
• Create and execute SQL queries to perform source to target testing on DB2 database. Perform the following tests:
• Condition and prepare regression test data to meet the testing requirements in UAT.
• Test the entire data reconciliation process for multiple source and target systems.
• Write complex SQL scripts using joins, sub queries and correlated sub queries.
• Provide input into project plans for database projects providing timelines and resources required.
• Test analytical reports using Analysis Studio
• Worked with various teams Onshore / Offshore for coordination of testing for various projects.
• Performed Impact Analysis at various stages for Production issues.
• Ran regression tests during testing of Production enhancements.
• Used Quality Center for Defect Management.

Environment: ETL, Aqua Data Studio, Quality Center.

Confidential

Business / UAT Analyst

Responsibilities:

• Followed ITIL methodology to improve the quality and reduce defects
• Interacted with multiple cross-functional teams ensuring that all business requirements are captured correctly and report progress to all levels in the organization
• Performed analysis of business rules, business and system process flows, user administration to be used for the new merged platform
• Supported Unit Testing and System Integration Testing (SIT)
• Developed Requirement Traceability Matrix to record the relationship of the requirements to the design, development, testing and release of the software
• Executed SQL queries on relational databases to create daily reports
• Used Rational Rose for Use case modeling.
• Responsible for developing Business Requirement and Functional Requirement Document and documenting the requirements in Mercury Quality Center
• Acting as a liaison between the technical, business, testing groups to provide them with required specifications/documentation and to resolve any issues in between.
• Worked with the User experience team to design the GUI for the application.
• Partner with the LOBs to understand strategic goals, and identify technology components to enable business results
• Identified, researched, defined and documented user problems and automated/manual business processes.
• Actively solicit, analyze, prioritize and negotiate customer requirements from scope definition through detailed system requirements
• Perform root cause analysis, develop solution options, and influence the organization to adopt recommended solutions/trade offs

Environment: Use Cases, SQL, UML, HTML, JAD, Quality Center, Oracle, Java, XML, MS-Office, Windows, Rational Rose, Rational Requisite Pro, Windows, HTTP, Six Sigma.

Confidential

Responsibilities:

• Developed a project plan using Microsoft Project based on details contained BRS and also a project plan to schedule and assign work and manage the project.
• Worked closely with project managers, business users to formalize a business idea and define requirements.
• Interacted with the business users and division supervisors to gather the requirements.
• Gathered requirements for building a current business process that hosted day to day trading activities of various commercial recordings divisions.
• Developed functional documents like Mail and Receipting, New Filings, Status and Copies business requirement specifications.
• Analyze gathered requirements data, verify requirements and create business requirement specifications (BRS).
• Created process flow diagrams using Visio.
• Conducted JAD and brain storming sessions with the business users and stakeholders.
• Conducted meetings with all the division supervisors to ensure that all the requirements are met.
• Implemented the approved suggestions and modified the current process flows.
• Created Requirement Traceability Matrix to make sure the current project requirements are being met.
• Developed test cases and participated in UAT (User Acceptance Testing).

Environment: Test Cases, JAD, Quality Center, SQL, XML, FTP, MS-Office, Windows, Rational Rose, FileNet, MicroFiche, Windows, Visio.

Confidential

Responsibilities:

• Worked closely with project managers, business users and developers to formalize a business idea and define requirements using rational requisite pro.
• Analyze gathered requirements data, verify requirements and create functional specifications (FRD/FRS).
• Gathered requirements for building a sub-ledger that hosted day to day trading activities of various hedge fund clients and assist in reporting and accounting.
• Followed CMMI to improve the quality of process outputs and reduce defects
• Queried relational databases using SQL on a daily basis to resolve operational issues and assist business and IT in better understanding of business requirements.
• Gathered requirements for creating "Affirmation Engine" that would assist in matching trades and confirm and straight through processing (STP) for the clients.
• Expertise in Business Process Modeling and Use Case Modeling using Unified Modeling Language (UML) and Rational Rose tool.
• Created Requirement Traceability Matrix to make sure the current project requirements are being met.
• Work with Development and QA teams to transition business requirements into QA test cases and assist in UAT.
• Acted a project manager/business analyst for the Buy-In project and build a new application using service oriented architecture (SOA) and XML to assist the Stock-Borrow Loan team in sending Buy-In requests to DTC for post settlement date clearings.
• Managed enhancements and defects promptly to assist the operations in resolving issues.

Environment: Use Cases, SQL, UML, JAD, Quality Center, Java, XML, FTP, MS-Office, Windows, Rational Rose, Rational Requisite Pro, Windows, HTTP, Six Sigma.

Confidential

Responsibilities:

• Developed business requirements and process workflows
• Managed the development of a reporting capability of current and historical fund performance prices made available on restricted web sites for viewing by client customers.
• Defined requirements for a daily feed of fund performance data from the fund data warehouse, coordinated systems testing, and supported UAT.
• Followed Six Sigma methodology
• Gathered requirements and managed the implementation of a private, secure ftp site allowing authorized print vendors to download files containing sensitive shareholder information

Environment: MS-Office, Six Sigma, RUP, SDLC, Use Cases, Quality Center, HTTP.

Confidential

Responsibilities:

• Assist clients in implementing and enhancing the CRM solutions.
• Day to day interaction with clients to operate and work on these CRMs.
• Production support and serve enhancement requests for these clients.
• Create Business Requirements for the enhancement requests and Development / Implementation support for these enhancements.