SUMMARY:

• Over 7 years of IT experience as a Business Analyst, Quality Analyst in Banking and Finance domain.
• Knowledge on Software Development Life Cycle (SDLC) methodologies like Agile, Waterfall.
• Have understanding of various phases like requirement gathering, gap analysis, design, development, documentation and Testing.
• Proficient in authoring Business Requirement Documents (BRD) and identifying interfaces and business process specifications.
• Experienced in creating Use Case Diagrams, Data Flow Diagrams, and Sequence diagrams using UML modeling tools such as MS Visio.
• Preparing the analytical reports/documents to improve the business based on the historical data existing in the warehouse system using SQL assistant.
• Analyzing the data existing in the DataMart and co - ordinate the requirement to the developer on OLAP cube generation and other requirements.
• Worked on numerous cross platform applications and involved in Joint Application Developments (JAD), Interviews and Workshops sessions with end-user/clients/stake holders and the IT group.
• Exceptional problem solving and sound decision-making capabilities, coupled with excellent communication and interpersonal skills. Good track record for meeting deadlines and submitting deliverables on time.
• Have understanding on enterprise scheduling tool like Autosys.
• Expertise in writing SQL queries involving multiple table joins.
• Coordinated with Business Users for requirement gathering, business analysis to understand the business requirement.
• Used Teradata SQL Assistant tool as the database interface and run SQL queries.
• Have a good understanding on data warehouse concepts working on Oracle and Teradata databases.\u;;
• Assisted in System and User Acceptance testing
• Strong communication skills when working with developers, project managers, Subject Matter Experts, stakeholders and end-users
• Team player with strong client facing abilities, presentation, written and verbal interpersonal communication skills. Besides, ability to work in a team environment, including user interaction.

TECHNICAL SKILLS:

Management tools: MS Visio, MS Word, MS Excel

Formal notations and standards: UML

Languages: SQL

Databases: Oracle/Teradata

Bug Tracking tools: Jira, ALM, Clear Quest

Data Modeling: MS Visio

Operating Systems: Windows 95/98/NT/2000/XP

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

Responsibilities:

• Followed the Agile SDLC methodology throughout the project
• Gathered Business requirements through interviews and interacting with Project Managers.
• Designed and developed project document templates based on the scope and plan for the project
• Interacted with client and the technical team for requirements gathering and translation of Business requirement to technical specifications
• Gathered business requirements, functional, and Nonfunctional requirements
• Prepared the mapping document in coordination with the Data Analyst.
• Used Joins for analyzing data from multiple tables.
• Communicated with business and other functional stakeholders for all JAD sessions to derive and execute action plans, meeting deadlines and standards.
• Analyzed data and implement procedures to support development teams and front end users working with various applications.
• Used Teradata SQL assistant tool to query the tables.
• Used SQL Assistant tool to import the data from a csv file on desktop into Teradata to analyze the requirement.
• Using SQL Assistant ran joins on tables to understand and prep the data for reporting purposes.
• Provide support while loading data into Teradata databases
• Worked with enterprise scheduling tools like Autosys.
• Guided the developers in bulk data loading using the MLoad and BTEQ scripts into Teradata.
• Assisted in creating and reviewing test plan & test cases and conducted User Acceptance Testing
• Write use Cases for business requirement document (BRD).
• Conducted and participated in walkthroughs to discuss certain issues with the development and business team.
• Worked closely with management to keep track of the status of project.
• Involved in both Manual and Automated test plans and test cases.
• Performed functional, regression and performance testing in user acceptance test (UAT) environment and approval of the application.

ENVIRONMENT: MS Visio, ALM, Clear Quest, JIRA, Windows, MS-Excel, DIBS, UML, Teradata, Oracle, SQL

Confidential

Business Analyst

• Met with client groups to determine user requirements and goals.
• Followed Waterfall methodology.
• Captured and analyzed requirements through interactions with stakeholders.
• Finalized and documented the Business Requirements for the application with business heads through proper communication channels.
• Worked through Software Development Life Cycle (SDLC) from Requirements, Analysis, Design, Implementation, Testing through Production.
• Used SQL Assistant tool to export the data from the DataMart into csv format which was used as input for reporting by other backend teams.
• Developed Use Case diagrams with MS Visio
• Developed Entity relationship diagrams and prepared data dictionary.
• Created Data model diagrams associating myself with Data Analyst using MS Visio.
• Attended meetings with management to discuss the status of project.
• Trained the end users group and documented the functional instruction and user guidelines for the same application.
• Conducted training sessions to familiarize users with system and obtained deliverable sign-offs.
• Worked alongside with developers in tracking and resolving system defects in Jira and ALM

ENVIRONMENT: ALM, Clear Quest, JIRA, MS Visio, Windows, MS-Excel, Teradata, Oracle, SQL

Confidential

Business Analyst

• Performed Requirement Analysis by gathering both functional and nonfunctional requirements based on interactions with the process owners & stake holders and document analysis, represented them in Requirements Traceability Matrix (RTM).
• Worked with SME’s in Finance, Investment, Commercial and Personal banking to collect the Business process requirements, documented them in Business Requirement Document (BRD).
• Authored Functional Requirement Document
• Planned and defined system requirements to Use Case, Use Case Scenario, and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Created and maintained Narrative Use Cases and modeled Use Case Diagrams, Activity Diagrams, Data Flow Diagrams using MS Visio.
• Worked with data compliance teams, Data governance team to maintain the data models, Data Dictionaries; define source fields and its definitions.
• Experience in writing SQL queries in validating the data in table.
• Involved with the QA team to conceptualize, determine and develop test approaches and methods for unit testing, integration and functional testing.
• Performed manual front-end testing to check all functionalities of different modules
• Trained the end users group and documented the functional instruction and user guidelines for the same application.

ENVIRONMENT: MS Visio, SQL, Windows XP/2000, MS-Excel, MS Office, Oracle

Confidential

Jr. Business Analyst

• Played pivotal role in preparation of BRD. Interacted with various business owners to understand their requirements.
• Extensively used the concepts of Business Process Reengineering.
• Managing client communication unmistakably. Organizing the status calls and review calls for understanding and communicating the daily problems faced by the team members and taking remedial actions and risk mitigation.
• Developed Requirement Traceability Matrix (RTM).
• Worked on functional requirements to be inculcated in the project.
• Negotiated various deliverables with the stakeholders.
• Written SQL scripts to extract data for test purpose.
• Wrote Use cases skillfully. Developed Activity diagrams and process flow diagrams. Developed Business Processes. Helped process engineering. Conducted many sessions with client to figure out actors and cases.
• Identified and assisted to create Test Data for execution of Test Cases.
• Mentoring and training other business units.
• Coordination in writing test cases for UAT.
• Conducted JAD sessions with management, SMEs (Subject Matter Experts), vendors, users and other stakeholders for open and pending issues to develop specifications.

ENVIRONMENT: Mercury Quality Center 11.0, SQL, Windows, MS-Excel, MS Word, MS Visio, MS Outlook

Confidential, Phoenix, AZ

Business Analyst/ QA Analyst

• Worked with SME’s in Finance, Investment, Commercial and Personal banking to collect the Business process requirements, documented them in Business Requirement Document (BRD).
• Perform Requirement Analysis from the BRD
• Develop Traceability matrix based on Business Requirements.
• Involved in business requirements, user requests and bug status meetings.
• Developed and implemented test plan, setup test priorities and test scenarios.
• Manually performed Back-End testing by writing SQL queries.
• Involved in Sanity Testing, Functionality Testing, Regression Testing, Compatibility Testing, Backend Testing and Usability Testing.
• To work in correspondence with the Environment Coordinator/IT PMs to ensure environment availability for all the test regions SIT/QA and UAT.
• Developed SQL queries to verify the data in backend applications .
• Prepared the User manual of all the key functionality in the application to be used during the knowledge transitioning.
• Escalation of issues/concerns to the team lead.
• Enhancement and bug fixes
• Testing and Defects on pages are resolved using Firebug.
• Page level Testing is done on Pages using “Yslow” and standards are maintained

ENVIRONMENT: Mercury Quality Center 9.2, Windows, MS Excel, MS Word, MS Visio, MS outlook, Putty, Shell scripting, XML, HTML, CSS, Yslow, Firebug