SUMMARY

• I am a seasoned and accomplished Business Analyst and Quality Assurance Analyst wif over Eight years of enterprise - level experience and a fundamental and practical understanding of business requirement gathering, business process flow, business process modeling and project management and Software Quality Management.
• Experience working wif both Agile and Waterfall methodologies wif knowledge of all SDLC processes.
• Strong experience in Back-End Testing for Oracle databases using complex SQL queries.
• Experience in developing Test Plans, Test Cases based upon the business requirements.
• Created Process Flow/Use Case/Class Diagrams/Interaction Diagrams using Microsoft Visio, Rational Rose and Rational Requisite Pro for modeling and capturing business requirements per UML methodology thus defining the Data Process Models.
• Experience in performing Gap Analysis, SWOT Analysis, Risk Analysis and Impact Analysis.
• Knowledge of Data Warehousing concepts and Extract, Transform and Load (ETL) processes.
• Wrote Test Cases, test plans during various release cycles, documented the in-detail defects using the Defect Tracking reports from Clear Quest and Quality Centre wif acquired expertise in Unit testing, Integration System and User Acceptance Testing (UAT).
• Experience in writing SQL queries as well as using SQL for organizing and abstracting data from MS access, Sybase, SQL server data bases, created reports, forms on MS Access.
• Used SQL to query new system during testing phase and to track the activities, wrote SQL scripts and queries to extract data from various data sources into the BI /Visualization tool, Excel, Tableau and to manipulate-validate output data of the reports.
• Expert in Product Development starting from Requirements analysis and review, functional designs, functional test scripts for unit, integration & system test cycles.
• Proficient in Word, MS-Excel, Power point, Visual Basic for applications, VBA macros along wif Hlookup and Vlookup functions.
• Experience in full Software Development Life Cycle (SDLC) including requirement analysis, design, development, testing, implantation and project documentation.
• Experience in testing Financial, and Mortgage applications on different environments.
• Proficient in analyzing the functional specifications and analyzing the actual results against the expected results reporting in Quality Center.
• Good experience of Bank Operations including NSF, Bank Charges & Fees, Banking Products and services like types of Accounts, CRA, and Overdraft.
• Managed and performed testing of Web-based application on both Windows and UNIX platforms.
• Strong working Knowledge in different databases i.e. Oracle databases, SQL PL/SQL, Toad, SQL Developer, SQL Assistant for Tara Data
• Experience wif process documentation and process documentation tools- MS Visio.
• Experienced in interacting wif business users and executives to identify information needs, gather Requirements, and authoring Business Requirement Documents (BRD), Use Case Diagrams, Activity Diagrams, Sequence Diagrams using UML modeling.
• Hands on experience wif validating data in various formats including XML.
• Knowledge of SQL and experience of writing SQL commands.
• Strong knowledge of Financial Modeling Techniques using Excel.
• Works closely and effectively wif all levels of management to satisfy project/productivity requirements.
• Self-motivated, customer-focused, teamwork oriented and strategically focused experienced professional wif strong analytical, pattern detection and problem solving abilities.
• Excellent in communication, problem-solving, and interpersonal skills. Good team player wif the ability to lead, manage and work independently in a time sensitive environment.

TECHNICAL SKILLS

Testing Tools: QTP, HP ALM 11.0, Quality Center 10.x, 9.x

Bug Reporting Tools: TestDirector, HP Quality Center, JIRA

RDBMS: MS SQL Server, Oracle, MS Access, Teradata, DB2

Methodologies: Software Development Lifecycle, Waterfall, Agile, Iterative, ScrumUML

Languages: C, C++, HTML, JAVA, C#, Visual Basic, SQL, PL/SQL

Operating Systems: UNIX, Windows XP/Vista/7

Servers: Web Sphere

Other Tools: MS (word, Excel, Power point, Visio), Rational Requisite Pro, ClearQuest

Web Browser: Internet Explorer, Mozilla Firefox, Google Chrome

PROFESSIONAL EXPERIENCE

Confidential, Vienna, VA

Sr. Business Analyst

Responsibilities:

• Clarified client requirements, business needs and project objectives, via feedback sessions and client meetings, in collaboration wif all stakeholders on specification over NetSuite functionalities.
• Involved in preparing a simple and detailed User manual for the application, for an intended user.
• Identified and documented existing business processes and process flows by identifying working elements and entities, existent wifin the system.
• Developed new functionality to the existing application as part of change requests.
• Involved in writing test cases and Integration Testing and System Testing using automated test tools assisted manual testing and conducted UAT.
• Contributing to detailed deliverables and obtaining requirements documents and functional designs sign-off.
• Developing and maintaining Test Scripts, analyzing bugs and interacting wif development team members in fixing the defects.
• Assisted in quality assurance and user acceptance testing (UAT)
• Prepared product manual, user manual and training materials
• Analyzed application, system errors. Escalated issues to developers and verified fixes.
• Attended weekly defect report meetings and presented progress updates.

Environment: NetSuite, Windows XP, HTML, MS Office, MS Visio, Certain Datawarehouse, Enterprise Architect 7.5

Confidential, Monterey Park, CA

Business System Analyst/ QA

Responsibilities:

• Brain storming wif client on the Business Requirement Document (BRD), and convert BRDs into FRDs
• Followed Agile methodology.
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and tan documented them in a format that can be reviewed and understood by both business people and technical people.
• Researched on Best Industry Practices and explained the Business Users of the benefits and costs associated in implementing the same.
• Experience in using, collecting, modifying, and maintaining report on a SharePoint.
• Leveraged Bank systems, namely RUMBA and WebAmmo to obtain evidence required to perform End-to-End testing.
• Involved in generating reports form SAP-BO tool for each individual account that will be leveraged for test execution and account validation.
• Performed End-to-End account validation using Excel Matrices and generating an output to validate wif the data warehouse provided result.
• Participated in design walk-through wif Subject Matter Experts (SME’s) to baseline the business architecture.
• Used MS Visio to carry out business modeling and created use cases, use case diagrams, and activity diagrams.
• Providing review to Test Cases and Test Files generated by QA team.
• Interacted constantly wif the Business Users and Project Manager to keep them current wif the latest updates.
• Converted business requirements into System Requirement Specifications.
• Involved in requirement scoping and analyzing high priority requirements for implementation.
• Supported the QA manager in creating various testing scenarios for integration and system testing.
• Supported the QA team while conducting Unit and Functional Testing.
• Assisted the Business Users at the time of Application testing and User Acceptance Testing.

Environment: Windows, SAP BO Tool, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio),Scrum, MS Office, Rumba, WebAmmo, UAT, HP ALM, Agile, UAT and MS SharePoint.

Confidential, Richmond, VA

Business System Analyst

Responsibilities:

• Implemented and enhanced e-commerce applications Corillian’s Retail online banking, Mobile Banking wif Clair-Mail product that offers mid-tier regional banks their own mobile solution: SMS, mobile application, mobile remote deposit capture technology for checks and FISERV’s e-Cash/Cash Management System integrates online banking, payments & personal financial mgmt. tools onto the same interface: viewing & paying bills, viewing spending graphs, viewing balance & transaction detail, As consumers use it more, they become more loyal & profitable to financial institutions.
• Facilitated DailyScrumMeetings, Monthly Reviews meetings, Release Planning, Sprint Planning, Sprint Review & Sprint Retrospective meetings.
• Gathered user and business requirements for ACH (automatic clearing house) electronic network for financial transactions like processing large volumes of credit and debit transactions in batches, EFT electronic funds transfer from one account to another, either wifin single financial unit or across multiple databases and Fiserv Corillian Retail through interviews, surveys, prototyping and observing from senior managers and UI (User Interface).
• Educate team to gain knowledge onSCRUMMethodology and using Rally for User story and Task estimation.
• Coached team members onScrumprocesses and facilitated planning meetings and retrospectives.
• Involved creating BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements for development team.
• Planned and defined system requirements to Use Case, Use Case Scenario using the UML (Unified Modeling Language) methodologies using MS Visio. Designed ERD, DFD and also User Interface.
• Conducted JAD sessions wif management, users, financial analyst and other stakeholders for open and pending issues.
• Facilitating sprint planning asScrummaster for multipleScrumteams
• Implemented and deliveredbusinessprocesses in iterations (Sprints) using Agile-Scrum development methodology.
• Extensively involved in Knowledge Transfers and giving training to offshore QS Team. Also facilitating meeting wif the leads on both onshore and offshore.
• Scheduled meetings wif developers, System Analysts and testers to collaborate resource allocation and project completion using MS Project.
• Created team-building opportunities by coaching newScrumMasters across several groups, resulting in better understanding of product backlog items.
• Worked wif Development team to create conceptual, logical & physical data mapping.
• Involved wif QS team in Developing User Acceptance Test Plan, Test Cases, Test scripts and logging defects for manual testing using HP Quality center.
• Responsible for creating Integration and System test plan and User Acceptance Test (UAT) cases in all phases of the Software Development Life Cycle in loan systems using HP Quality center.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in RequisitePro.
• Performed Soap based and RESTFUL web-services testing.
• Suggested measures and recommendations to improve the current application performance.
• Conversions of accounts were implemented in Agile/Scrum methodology to produce artifacts in the different phases of the Software Development Life Cycle (SDLC).

Environment: MS Office, MS Project, MS Visio, SQL, Scrum, HP Quality center and Oracle.

Confidential, Boston, MA

Business Systems Analyst

Responsibilities:

• Collaborate wif business partners to develop the Business Case, Statement of Work, Requirements Specification, and Functional Design documents utilizing the Enterprise Project Management Methodology for Commercial Loan Services line of business.
• Developed the systems implementation project management plan wif milestones and steps from procurement of vendors to project implementation and maintenance.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Created specifications BRD, FTR, Use Cases - for Loan IQ front and middle-end-lending solution enhancements.
• Supported PMO by mentoring specific projects in application of the new SDLC based on the Rational Unified Process, especially from the project management, requirements and architecture perspectives.
• Wrote Use Cases, prepared use case diagrams (using Rational Rose & UML) and followed Agile at every stage of the processes
• Implemented the full project lifecycle phases including requirements gatherings, development and quality assurance.
• Member of twoscrumteams and participated in dailyscrummeetings,scrumofscrummeetings, sprint backlogs and retrospectives etc.
• Worked wif the Business community, Tech Lead and 3rd party vendors in gathering the requirements.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle
• Monitored and assisted in designing and development of Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Identified, researched, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
• Documented and delivered Functional Specification Document to the project team.
• Data mapping, data modeling (conceptual, logical, physical), data profiling, created specifications for database migrations & conversions and conducted testing on relational databases
• Provided technical support to the Database Team on Oracle, developed SQL queries for data extraction purposes.
• Collaborated wif Quality Assurance Analyst in Automated and Manual Black box testing.
• Organized cross training of team members and users to become more responsive.
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
• Used Rational Clear Case and Clear Quest as Configuration Management and Change control tools.
• Performed User Acceptance Testing (UAT)
• Full knowledge of phases of the Systems Development Life Cycle.
• Ability to work wif all members of the project team, following the project through the Systems Development Life Cycle and ensuring business objectives are met (extensive project life cycle experience).
• Responsible for creating business flow diagrams (using MS-Visio).
• Extensive experience wif User acceptance testing (UAT), System testing, Integration testing and build verification testing.

Environment: Rational Requisite Pro, Caliber RM, Scrum,SOAP-UI, Doors, MS-Visio, RUP, UML, Oracle 8i, SQL, PL/SQL, MS Office, MS-Project, Windows 2000, Crystal Reports.