Sr.Business Analyst

Gayadri Prahalathan Email: **********@*****.***

Sr.Business Analyst Phone: 518-***-****

Professional Abridgement

Sr. Business Analyst with around 6 years of experience in Business Analysis & Quality Assurance with TechMahindra(INDIA), Accenture(USA),Celtic Testing Experts(USA) and TCS (INDIA).

Progressive business & technology experience providing vision and leadership by leveraging subject matter expertise in information system’s methodology from conceptual design through documentation, implementation, user training, conducting quality reviews, enhancements and vendor management strategies.

Worked with most reputed clients like General Electric (Tech Mahindra), Citi (TCS), FannieMae (Accenture) and Aarons (Celtic Testing Experts).

Proficient in Capturing Business requirements of complex projects which has stakeholders across the globe. Experience in conducting workout to understand the AS-IS process and worked with the stakeholders to define the TO-BE process based on the business needs.

Expertise in working with application on RDBMS databases like Oracle, MS SQL Server using SQL Queries and proficient in Agile Methodology – Scrum.

Proficient in working on Scrum tools such as Rally, JIRA, Confluence (Atlassian) and Giffy diagrams.

Extensive knowledge on creating Functional Specification Document (FSD) and Business Requirement Document (BRD) along with testing process

Proficient in requirement gathering and testing of Distributed Web-Based, Client-Server, Enterprise wide applications of Java, J2EE & .Net on Windows and UNIX Operating Systems

Excellent Customer orientation skills and significant experience successfully leading complex work streams on time and on budget.

Conversant with all the processes in Software Development Life Cycle (SDLC) starting from Requirement gathering, requirement analysis and dissemination, Quality (QA/QC) testing cycles (STLC) and implementations.

Experience includes working with cross functional team and global development teams in Onshore/Offshore Model.

Experience with internal and external stakeholder communications and outreach, including the development of presentations and other materials that promote the rethinking of core business processes and envisioning of a reengineered environment.

Expertise in object modelling and Object Oriented design methodologies (UML). Experience with UML diagrams like Class, Object, Use Case, State and Activity diagrams.

Scholastics

Apr- 2008

Bachelor of Technology in IT (Information Technology) – Anna University

Professional Membership

Professional Society / Certification

Member Since / Date Certified

ISTQB – ISEB Certified Tester

Dec 2011

HP Quality Center 10.0

Feb 2011

HP Quick Test Professional

Dec 2009

Accolades

Won ‘On the Spot Award’ for an inspiring role model to colleagues from TCS

Certified for outstanding contribution to TCS Citi eBiz relationship.

Rewarded with TCS gems for procuring ‘Star of the month’.

Got appreciation from FannieMae for on-time delivery of continuous sprints.

Won ‘Pat on the Back award’ for best performance in Triumph Projects.

Technical Skills

Operating Systems

Windows 98/NT/2000/XP and Solaris, UNIX, Mac

Languages

JAVA/J2EE, PL/SQL

Databases

Oracle 9i/8.x, 10g, PL/SQL, MS Access

Web Related

J2EE, JSP, JDBC, JavaScript, HTML, VBScript

Project Management Tools

Microsoft Project 2003/2007

Project Methodologies

SDLC, Agile.

Tools & Utilities

Eclipse, Rational Rose, VMware, Citi Smart, Rumba Mainframe, QC, QTP, Version One, IBM Clear Quest,Putty, Rally, confluence

Version Controller

CVS, Clear Case

Defect Tracking Tools

Bugzilla, QC, JIRA

OOAD Artifacts

Class Diagram, Sequence Diagram

Domain Knowledge

Energy, Banking, Finance, Retail

Projects Involved

Client: GE P&W, Tech Mahindra

Role: Sr.Business Analyst

Project: MyAE (My Application Engineer)

Apr 2014 – Apr 2016

Project Description: MyAE acts as a ONE-STOP data source that brings technical data to fingertips. It connects data from various sources (SFDC, Pegasus, Support Central, PLM, Prop cost etc.)by pulling the data of Project and Opportunity from various systems and allows team to share and communicate throughout a bid cycle.

Environment: JavaScript, JQuery, AngularJS, PL/SQL, Oracle

Role Description:

Requirement analysis on interaction with Business.

Conducting User interview to gather business requirements and define user stories

Ensure that all the requirements are documented and tracked

Designed and developed requirement specification documents like BRS & FRS.

Document Functional & Technical specifications and obtain customer signoff

Co-ordinate with all the respective teams and remove any blockages for development team.

Driven weekly scrum calls with developers, testers & stakeholders to keep track on the progress.s

Testing - unit testing & integration testing with the testscripts.

Active participation in SIT,UAT & production move.

Defect Management and minimization

Responsible for overseeing the Quality procedures related to the project.

Client: Aaron’s, Inc., Atlanta, US

Role: Business Analyst/Quality Analyst

Project: Customer Tracker 2.0

Mar 2013 – Apr 2013

Project Description: Aaron's, Inc. is a lease-to-own retailer & a national leader with more than 1,800 Company-operated and franchised stores across US. The goal of the project is to track customer agreement data in the system through LexisNexis & their stores through SQL queries.

Environment: .NET, VersionOne, Oracle 10g, SQL, T-SQL

Role Description:

Interacted with Business team, Architects to understand Business logic and User Requirements.

Decomposed user stories, technical requirements, business rules into BLIs (Backlog Items).

Produced high quality documentation that includes: E1, E2 Estimation, Test Plan, Test Case solution specification, Functionality grid and Test Cases.

Have done walkthrough with clients on prepared documents to ensure the requirements coverage.

Test data conditioning well before the kick start of testing.

Used popular agile management tool VersionOne for test execution.

Performed Shake out testing once initial build is deployed in the test environment.

Performed Functional testing to ensure that software requirement specified Standards and end user requirements along with Defect management.

Participation in kick-off meetings & scrum calls of every sprint throughout the phases of testing.

Client: Fannie Mae, Atlanta, US

Role: Business Analyst/Quality Analyst

Project: Multi Family Credit Pricing Upgrade

Oct 2012 – Feb 2013

Project Description: Fannie Mae, The Federal National Mortgage Association maintains a secondary market in home mortgages. The National mortgage finance company that helps strengthen the U.S. housing and mortgage markets, and supports affordable homeownership. The project includes a technical upgrade on JDK, Web logic & Oracle version for the Multi Family Pricing application.

Environment: Java, HP Quality Center, IBM ClearQuest, QTP, Toad, SQL,

Role Description:

Constant interaction with Business & Development teams.

Data extraction from DB using SQL queries.

Performed Sanity testing to ensure that the basic functionality of the app is not disturbed.

Documented business requirement specification & Functional requirement specification & obtained signoff from business.

Developed automated testscripts using QTP - Descriptive programming & Data driven framework.

Causal Analysis of UAT and Production defects.

Participated in Walkthroughs, Production Readiness Review meetings and Stand Up meetings.

Have given Knowledge Transition session on the project to UAT & other end users.

Client: Citibank, TCS, India

Role: Business Analyst

Project: Transfers to Delinquent card customers

Jan 2012 – May 2012

Project Description: Citibank, a major international bank, offers broad range of lending, deposit and membership based products & major services includes distance banking by phone, online banking and 24-hour online account access. Citi Cards offers a wide range of products to meet all of its customer needs – this project offers the Delinquent card customers the ability to make Minimum Amount Due within a period of 6 days after their due date in the Citibank Online Portal.

Environment: Java, HP Quality Center, QuickTestPro, Oracle, SQL Queries, VMware

Backend systems: Rumba Mainframe Display and Citismart.

Role Description:

Worked on Agile and SCRUM environment.

Created new acceptance criteria and enhance existing acceptance criteria on user stories.

Decomposed user stories, technical requirements, and business rules and extract

Positive and negative test scenarios.

Wrote SQL Query to extract data from various database tables for testing purpose.

Performed Data validation using SQL Queries.

Performed Regression Testing by executing the scripts developed with Quick Test Pro.

Coordinated with onshore with updates and status of Projects.

Interacted closely with stakeholders to meet the business needs.

Client: Citibank, TCS, India

Role: Business Analyst

Project: Non Receipt Reissue Account Compromise

Apr 2011–Dec 2011

Project Description: The goal of this project is to enhance the customer’s ability to self-service online by implementing online NRI Unblock (account activation) in preparation for a major cards brand conversion reissue. The online customer experience during Account Compromise Reissue will be enhanced in an effort to increase customer satisfaction and reduce call volume.

Environment: Java, HP Quality Center, Oracle, SQL Queries, VMware

Backend systems: Rumba Mainframe Display and Citismart.

Role Description:

Prepared Requirements documents and Functional Specification Documents.

Involved in gathering and setting up of Test data for the developed Test Scripts.

Created Test scripts for various testing stages like Functional testing and Regression testing.

Participated in Validation and data driven testing with different sets of data.

Performed User Acceptance Testing, Regression Testing, Functional Testing, Integration Testing and Adoc Testing on various modules.

Wrote complex SQL queries to verify the database tables for the data inserted.

Driven weekly bug meetings to discuss bugs along with testers and developers.

Coordinated bugs with developers and defect reporting and Tracking are done with Mercury Quality Center.

IPMS and other Quality related activities.

Client: Citibank, TCS, India

Role: Asst. Systems Engineer

Project: E-Bill Presentment

Nov 2010–Mar 2011

Project Description: Electronic bill presentment (eBills) through CBOL will allow customers to view their bills, receive alerts when a bill is issued and available for viewing, and make payments for those bills. Bill Payment hubs, like Citibank Online, offer the convenience of being able to view and pay most of a user’s bills at one site.

Environment: Java, HP Quality Center, QTP, Oracle, SQL Queries, VMware

Backend systems: Rumba Mainframe Display and Citismart.

Role Description:

Responsible for gathering requirements from specification documents.

Preparing Estimates of E1 & E2 for proceeding further with the project.

Written Test Plans, Test Scripts in Quality Center

Followed SEPG guidelines while writing test cases.

Subscription of Ebill alerts & running of batch jobs to generate alerts.

Performed Functional test, Integration testing and Black Box testing.

Managed requirements using Quality Center & mapping of requirements to Test cases.

Executed Regression Test Cases using QTP.

Causal Analysis of UAT and Production defects

Performed Product Testing for Patch releases as part of Production support

Client: Citibank, TCS, India

Role: Asst. Systems Engineer

Project: CitiAlerts

Mar 2009 – Oct 2010

Project Description: CitiAlert is an Internet-based notification system that businesses can use to send information to customers. It also provides customers the ability to subscribe to specific alerts related to their accounts and activity. Information is delivered via mobile phones and email.

Environment: Java, HP Quality Center, QTP, Oracle, SQL Queries, Unix, WinSCP

Role Description:

Prepared Feed files for processing of alerts through Batch Jobs in VMware.

Configured Job files for automation using UNIX commands

Designed and developed the test strategy and approach for testing and tested the applications.

Participated in Unit, Integration, UAT and System testing

Ran Batch jobs with the feed files prepared with customer data to generate alerts.

Test data extracted from the Oracle DB to create feed files.

Executed QTP Scripts for Regression and System testing.

Conducted application testing Manually.

Created manual test cases, uploaded Requirements & logged defects using QC.

Ensuring strict adherence to the TCS Quality Processes.

Contact this candidate