SUMMARY

• Extensive experience in Business/Data Analysis and Software Development Lifecycle (SDLC)
• Extensive experience in Financial, Mortgage and Banking Industry
• Experience in Business reviews, Functional and System Level Requirements and Design Review
• “Hands on” experience in Object Oriented Design using UML and RUP (Rational Unified Process)
• Vast experience in making Process flow diagrams and Data flow diagrams to document Business processes.
• Hands on experience in writing requirement for data centric application which uses RDBMS such as Oracle, MS SQL Server and MS Access.
• Experience with Data modeling in a decision support environment.
• Adept at data validation in RDBMS by writing SQL Queries.
• Experience using Rational Rose, Requisite Pro, Doors, Clearcase and Object oriented Design (OOD) methodology.
• Strong knowledge and experience in testing financial applications in manual as well as using automated testing tools like Mercury Quality Center.
• Expertise in coordinating a UAT Test effort before deployment of the software product to production.
• Experience in estimation of test effort and coordination of Test schedule with overall Project Schedule
• Solid proficiency in developing Business Based Functional Test Scenarios, User Interface, Business Requirement Analysis, System Specification Analysis, Testing Methodology and Test Plan Formulation
• Adept at writing System Test plans, defining Test cases, developing and maintaining Test scripts, Shell scripts, documenting all phases of QA process and Release management using PVCS
• Exposure to QA Principle SEI CMM levels, ISO 9001, Software Development Analysis
• Ability to build teams and create atmosphere that energizes others and the ability to consistently execute.
• Ability to mange multiple projects concurrently.
• Excellent interpersonal skills, problem solving and analytical abilities
• Expertise in Problem solving and Bug Tracking Reports using Bug tracking Tools
• Exceptional collaborator adept at bridging the business and technical needs.
• Solid business, communications and presentation skills adept at written correspondence to keep executive staff and team members apprised of goals, project status and resolving issues and conflicts.
• Extensive experience in working with Meta - Data Repository to identify data sources and create data mapping.
• Robust record of success in achieving complex objectives and timelines.

TECHNICAL SKILLS

Languages: HTML, SQL

Database: Oracle, SQL Server, MSAccess

Operating Systems: Windows 98/2000/XP, Windows NT.

Other Tools: TOAD, Rapid SQL, SQL Navigator, SQL Loader (Loading Utility), VISIO

Tools: and Technologies: MS Office, MS Access, FrontPage, Microsoft Visio

Requirement and Test Case Management: Rational Requisite Pro, Telelogic DOORS

Defect Tracking Tools: Test Director, Rational Clear Quest

Version Management Tools: PVCS, CVS, Rational Clear Case

PROFESSIONAL EXPERIENCE

Confidential, MO

Business/Quality Analyst

Responsibilities:

• The Option Symbology Initiative (OSI) is a plan to overhaul the existing method of identifying Exchange-listed option contracts, base on the approach set by the OCC, that as of February 12, 2010 there will no longer by an option symbol in its current format.
• There will be an elimination of alpha codes (OPRA symbol) that denote call/put, fractional strike prices and contract expiration information. It will be replaced with explicit data that uniquely identifies each contract with actual expiration dates (including day) and decimal strike price values.
• The new industry definition will create a Data Series that is represented by 4 key data elements to explicitly identify an Option Contract. This Option Data Series will consist of symbol, contract date, call/put indicator, and strike price. This change provides the ability to easily identify the details of an Option Contract, without the need to convert the expiration price, type or month from an embedded alphabetical code.
• Worked on the IBG (Independent Brokerage Group) Compensation and Billing System which used the Options Symbol in output trade files. The system obtained this information from data warehouse and stores it in its own database schema.
• Following are the different/essential steps which were the basic part of my job during OSI project towards the sub firm’s primary or secondary contacts and their Vendors:
• Checking of the accuracy of the test trade detail file’s format
• Setting up the test lab and test plan in using Quality Center.
• Running test scripts to check if the data is as per the requirement needed by the third party (Sub Firm).
• Reporting and coordinating bugs with technical team.
• Making sure from sub firm’s correspondents (primary/secondary technology contacts) whether they have any test environment or not. If they don’t have any test environment, explain them the need of it and help them creating one, if users do not have infrastructure for test environment making sure that they do not use/run any of these test trade detail files in production
• Contacting the central file distribution (CFD) team to transmit the files to respective subfirms.
• Contacting the primary technology contact and the vendor (if applicable) of the sub firms and letting them know about the transmission of the test trade detail file towards them through CFD two days ahead of time and helping them in testing the trade file.
• Keeping phone and email contact with correspondents till they actually receive and run these test trade detail files in their systems
• Reporting the details to higher management on day to day basis.

Confidential, MO

Business Analyst

Responsibilities:

• Worked extensively with SMEs in understanding and documenting their requirements pertaining to the decommissioning, migration and archival of complex applications with multiple points of interface.
• Interacted with software architects to design effective archival solutions taking into consideration business interests.
• Was involved in all stages of the conversion project-requirements gathering, analysis, design, implementation and testing.
• Experience working on solution design and process definition, business process modeling using BPMN.
• Worked extensively with Developers to analyze, identify and document dependencies between application main frames and third party vendor tools.
• Worked with the Business users and IT leads to bring them together to ascertain that there were no conflicts of objectives or in the case of potential conflicts, to mitigate them to the extent possible for the mutual benefit of all stakeholders. All issues were documented in Rational Clear Quest and escalated whenever necessary in order to meet all deadlines.
• Co-authored business requirements documents with various project teams. Extracted, discussed, and refined business requirements from business users and team members.
• Facilitated and managed meeting sessions with committees of SMEs from various business areas including Law, Marketing, Loan Services and Records Management.
• Developed and implemented processes and tools for requirements gathering, Analysis, planning, tracking and testing.
• Extracted & loaded data using MS SQL Server.
• Responsible for preparing spreadsheets using MS Excel and work flows using Visio and Axure.
• Transforming requirements from MS Excel to new repository using Requisite Pro & MS Excel.
• Continuously interacted with developers for exploring MS SQL Server database & data tables.
• Responsible for joining tables with one to many or many to one relationship.
• Analyzed user problems, including business processes and identified, researched, investigated, defined and documented business processes
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Assisted in organizing training for team members and users to become more responsive.
• Acted as a resource in understanding how Information systems carried out business functions and assisted in ensuring a timely and effective implementation.
• Collaborated with the QA team to develop the test plan, test conditions and test cases to be used in manual testing based on business requirements, technical specifications and/or product knowledge.
• Responsible for extracting and testing securities reports using Speedscan.
• Analyzed and documented business application components for assigned applications.
• Worked with the Decommission 09 Lead, Architect and other team members to assess current capabilities and identified high-level requirements for decommissioning of their assigned applications.
• Identified and defined application deliverables for decommission effort for their assigned applications.
• Worked with the Work stream Lead, Applications/Portfolio Architects and other team members to define metrics and performance goals for the applications within their assigned applications.
• Participated in transitioning the requirements and use cases to the Data Archival team and ensure a clear and complete understanding of the requirements for their assigned applications requiring Data Archive.
• Ensured adherence to all quality management plans and standards by participating in quality management reviews for their assigned applications. (Identify Responsibilities).
• Developed documentation based on input gathered from a variety of sources including analysis results and feedback from the business community.
• Analyzed and documented business processes.
• Worked with project sponsorship to gain consensus and approval on all project deliverables
• Reviewed project deliverables for completeness and quality and compliance with established project standards

Confidential, McLean, VA

Business/Data Analyst

Responsibilities:

• Responsible for defining the scope and business rules of the project, gathering business requirements, and document them textually or using models.
• Served as a liaison between Clients and Technical Staff to resolve any conflicts.
• Conducted the FRS and URS reviews and walkthroughs with designers, developers and stakeholders.
• Conducted user interviews, gathered requirements, and analyzed the requirements using Rational Rose, Requisite Pro, RUP.
• Used Rational Clear Case to track changes and project status for Change Configuration Management.
• Based-lined the requirements in DOORS. Categorized, prioritized and scrubbed requirements to manage project scope. Used customizable attributes such as priority, status and difficulty for each requirement in order to organize and prioritize.
• Used Rational Clear Quest for tracking defect tickets, enhancement requests and change requests.
• Worked on the Confidential Technology Delivery Model (FTD).
• Worked on creating the Business Continuity Plan and did Business Impact Analysis.
• Created the non-requirement artifacts for FTD to be in compliance with the Sarbanes - Oxley Act of 2002.
• Responsible for maintaining daily status reports, weekly dashboards, risk log and issues log.
• Involved in preparing Test Plans based on User Requirements Document (URD) and prepared the Test Cases and Test Procedures
• Actively involved in User Acceptance testing
• Heavily involved in compilation and validation of Financial Reports like Control reports, Validation reports and Exception Reports.
• Performed reconcilliations manually using MS Access and SQL queries and created Report Prototypes in MS Excel to validate Use Cases and and create UAT results.
• Involved in data validation and data integrity between Central Data Warehouse and the Transactional Datastore.
• Wrote SQL Testing scripts for Backend Testing of the data warehouse application.
• Reviewed and validated test plans, test cases, test scripts and results and helped in documenting them for audit purposes.
• Involved with regular walkthroughs and meeting to discuss bottlenecks in the system and possible solutions with the development team.

Confidential, Melville, NY

Business/Data Analyst

Responsibilities:

• Responsible for defining the scope and business rules of the project, gathering business requirements, and document them textually or using models.
• Interacted with cross-functional teams to facilitate gathering of business requirements.
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Served as a liaison between Clients and Technical Staff to resolve any conflicts.
• Analyzed Business Requirements, performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams/State Chart Diagrams and Robustness Diagram using Rational Rose.
• Wrote standard and complex SQL Queries to perform Data Validation to make sure test results matched back to expected results based on the user needs.
• Organized and Performed GUI Testing, Functional Testing, Regression, General Acceptance Testing (GAT) and support for User Acceptance Testing (UAT)
• Understand and articulate business requirements from user interviews, and workshops and then convert requirements into technical specifications.
• Conducted the FRS and URS reviews and walkthroughs with designers, developers and stakeholders. Also conducted feasibility and adaptability study.
• Conducted user interviews, gathered requirements and analyzed the requirements using Rational Rose & Requisite Pro RUP.
• Involved in preparing Test Plans based on User Requirements Document (URD) and prepared the Test Cases and Test Procedures.
• Actively involved in User Acceptance testing and Training of the end users.
• Assisted with change, issue, quality and risk management activities. Generated management reports on weekly and monthly basis.
• Prepared a package of Process flow diagrams to document the existing system.
• Involved in writing the Test Plan, numerous Test Cases and Test Scripts using Test Director
• Worked with the Business Users through interviews and (Joint Application Development) JAD sessions.
• Wrote queries to test reports from financial data mart.
• Categorized, prioritized and scrubbed requirements to manage project scope. Used customizable attributes such as priority, status and difficulty for each requirement in order to organize and prioritize
• Manual testing for checking the data flow of the application using SQL
• Created test cases for FDR to perform Integration tests and verify the integrity of the accounts built on FDR.
• Performed GAP analysis during the conversion process.
• Performed backend testing to check the system data integrity for insert, update, delete and retrieve transactions by writing complex SQL queries including joins, group by, having clause etc.
• Performed Functionality testing, Integration Testing, Unit testing and System Testing.
• Involved in preparing flow diagrams for the decision logic using Visio tool.
• Involved with regular walkthroughs and meeting to discuss bottlenecks in the system and possible solutions with the development team.

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Worked as a business analyst, my job was to interview clients to understand their business and functional requirements, gathering their future needs and transforming them to functional specifications.
• Reviewed Business Requirement Documents and the Technical Specification.
• Used UML notations for Object Oriented Design and Documentation
• Coordinated with System Analyst and Project Manager to setup the pre-validation and Validation environment to execute the scripts.
• Involved in UML, designed Use Case Diagram, Class Diagram, Sequence Diagram, and State Diagram for project documentation.
• Analyzed user statement of requirements to develop new reports.
• Extensive Knowledge of Rational Unified Process (RUP).
• Created UML diagrams/models to gain familiarity with code design
• Used RUP for the Business Modeling part of the Application
• RUP process model was used for the different phases of the application development of the Software Development Life Cycle
• Conduct daily build validation and report status to product and QA team.
• Designed the application using UML
• Recommended and coordinated development efforts and enhancements
• Generation of the UML Collaboration and Sequence Diagrams for specifying the call flow.
• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes using the Rational Clear Quest.
• Planned, scheduled, and controlled projects based on plans and requirements outlined by the business
• Interacted with developers to report software bugs and re-tested the fixed issues.
• Interpreted Use Case diagram, Sequence diagram and Class diagram with Rational Rose
• Gave valuable input in terms of Modification Requests and Enhancement Requests.
• Involved in meetings and walkthroughs.
• Responsible for weekly status.