SUMMARY

• 7+ years of Professional experience as Business Analyst with solid understanding of Business Requirements Gathering, Business Process Flow, Business Process Modeling, Project Management and Quality Assurance
• In depth knowledge in Banking, Finance, Mortgage Industry, Retail and Healthcare Services
• Hands - on experience in preparing Source to Target Mappings, Requirements Gathering using Software Development Life Cycle (SDLC) methodology and Rational Unified Processes (RUP)
• Extensively worked on UML (Unified Modeling Language) and Prototype Design; Conducting Joint Application Development (JAD) and Joint Requirement Planning (JRP) sessions
• Proficient with creating Test Cases and creating Test Data and Screen Mockups for Quality Assurance of client server and web-based systems
• Experience in working in all phases of Software Engineering, expert in gathering, developing and documenting Business Requirements Document (BRD), User Requirement Specification (URS), Functional Requirement Specification (FRS), System Requirement Specification (SRS)
• Extensive experience in Object Oriented Analysis and Design (OOAD) techniques with UML using Flow Charts, Use Cases, Class Diagrams, Sequence Diagrams, Activity Diagrams and State Transition Diagrams
• Proficient in performing Gap Analysis and Impact Analysis, Cost benefit analysis and ROI analysis
• Extensively interacted with the QA Team in executing the Test Plans, Providing Test Data, Creating Test Cases, Issuing STR’s upon identification of bugs and collecting the Test Metrics
• Experience in performing User Acceptance Testing (UAT) and documenting test results
• Experience with Designing and verifying Databases on Oracle and SQL Server RDMS using Entity-Relationship Diagrams (ERD)
• Experience in delivering the project, meeting all the technical requirements within the agreed triangle of constraints
• Experience working with WATER FALL methods and AGILE methods like XP and Scrum
• Good oral and verbal communications skills
• Good planning and organization skills, with the ability to lead components of medium to large sized projects
• Ability to prioritize and schedule multiple tasks on a day-to-day basis

TECHNICAL SKILLS

Operating Systems: Windows 95/2000/XP/Vista, UNIX and Linux, MAC OS

Programming Languages: C, C#, JAVA, SQL, PL/SQL

Databases: MS SQL Server, Oracle 9i-11i, MS Access

Rational Tools: Rational Rose, Rational Requisite Pro, Clear Quest, Clear Case

Modeling Tools: UML, Rational Rose 2000, and Microsoft Visio

Reporting Tools: Crystal Reports, Micro Strategy

Others: MS Office Suite, SharePoint, MS Project, HTML, XML, PHP, AJAX

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Business / Data Analyst

Responsibilities:

• Conducted JAD Sessions with the Business, IT and SME’s and documented the requirements for various projects
• Created and Presented Agenda’s, BRD’s, Functional Specifications, Project task lists and plans.
• Regularly conducted Knowledge transfer sessions with Analysts, Developers, QA’s and provided updates to the Directors
• Responsible for running Daily, Weekly, Monthly reports from both SQL Server and Oracle databases
• Primary contact for one of the Vendor regarding compliance and data related check points for one of the process
• Scrum Master for Two internal projects both involving automating various manual processes in AGILE mode in order to improve timely delivery and quality
• Analyzed different kinds of data from many systems and reported various comparisons, trends, statistics, errors and suggestions
• Tracking requirements, Continuously monitoring the deliverables, handling day to day issues by escalating them to proper channel are some of the key activities performed from a BA perspective
• Created and handled various ad-hoc queries, SQL scripts, and worked with QA on some of the testing procedures
• Responsible for conducting technical breakout sessions with different groups in order to capture process improvement requirements for some of the systems as per priority list
• Maintained Change control process, conducted thorough analysis on various parameters, documented and presented the same to the Managers and Directors.

Environment: SQL Server Management Studio, Oracle SQL Developer, MS Project, MS Access, MS Visio, Share Point, Elvis, Market Prominence, MS Office

Confidential, Englewood, CO

Business System Analyst

Responsibilities:

• Conducted interviews with the IT and Business teams for gathering Business and System Requirements
• Created and Presented Project Charter, BRD, Project timelines and Implementation plans
• Followed Scrum Methodology and played the role of Scrum Master, being productive and ensuring Sprint goals are achieved as desired by the Business Owners
• Prepared Source- Target mapping with transformation rules and performed extensive Data Profiling
• Closely worked with source systems in preparing the extract programs for Historical and Batch loads
• Created Functional Specifications Documents addressing various modules like Database, ETL and Web Services
• Consistently Organized various JAD sessions with multiple teams and carefully maintained the minutes documents
• Conducted Daily Status meeting with the development teams and Weekly Status meeting with Management and Steering Committee team
• Extensively performed Requirements analysis and Gap analysis and maintained the documents with clear version history
• Maintained a clear task list and continuously monitored it in order to make sure planning is translated into action in a right direction
• Designed Various use cases, flow diagrams, process models and reviewed with the team
• Assisted the DBA in creating the Data model and prepared a consolidated Data Dictionary
• Performed the role of liaison between Management, Business Customers and Development teams
• Assisted ETL, Web Services and QA teams during design, development and Testing
• Responsible for maintaining document repository and Version control using Share Point folder
• Performed Impact analysis along with maintaining Change request forms and responsible for change management
• Involved in implementation of Scrum Methodology to the project and prepared presentations and Business flows
• Documented Cost/Benefit analysis, Risk analysis and responsible for presenting progress status in a timely manner
• Effectively Communicated with the management and continuously helped in resolving/escalating Complex issues
• Used Quality Center for tracking the defects and ensured that they are properly addressed within time
• Conducted various Knowledge transfer sessions for Onsite as well as Offshore development teams

Environment: MS-Visio, MS Project, MS Office, Scrum, Visio, Quality Center, WebEx, Share point, Data stage, Java, DB2 database

Confidential, Chantilly, VA

Requirements Analyst / Project Coordinator

Responsibilities:

• Conducted interviews with the Source Team and Business Customers for gathering Business Requirements, System Requirements and Functional Requirements
• Documented Requirements in blueprint, Captured the feedback, and Created Mock up scenarios
• Created and reviewed Functional Specifications, Project Schedules, and Test plans
• Created Business Process Models using RUP to document current business process
• Performed extensive requirement analysis including data analysis and GAP analysis
• Drafted the Project Plan and coordinated with the Development and Test Teams
• Conducted and Coordinated Joint Application Development (JAD) sessions with different Teams
• Communicated changes in the requirements, and in turn changes in the schedules, if any, to the Client Team and Client Services Team
• Designed and developed Use Cases and UML models using Rational Rose and Visio
• Major role in the planning, testing, and implementation of system improvements and conversions
• Reviewed various Project Artifacts like High Level Design, Detailed Design, Unit Test Cases, and Integrated Test Plans etc
• Worked closely with the project team in planning, coordination and implementing QA methodology in Agile Environment with SCRUM strategy
• Domain knowledge on Credit market, Fixed income and Credit risk management
• Developed steps for User Acceptance Testing and Test scenarios / Test Plans with QA Team
• Provided Production support, Application support and performed analysis, troubleshoot of production issues
• Performed End-to-End testing on the release version of the software application and detected GUI bugs
• Identifying the bugs and logging them into Rational Clear Quest for tracking and auditing purposes
• Acted as a liaison between Management, End Users and Application Team (Developers / QA Team)
• Conducted Training sessions for Customer Service team about the product functionality and provided on site enhancement support
• Responsible for maintaining all the project artifacts in SharePoint Folder and creating versions of the documents to maintain history

Environment: Rational Analyst Suite (Requisite Pro, Rose, Clear Quest), RUP, UML, UNIX, AGILE, MS-Visio, MS Project, MS Office, Share point

Confidential, Calabasas, CA

Business Analyst

Responsibilities:

• Worked with the business community of different departments to gather their report requirements and analyzed them to create Business and Functional Requirements
• Performed GAP analysis between the current state and future state Data Warehouse environment identifying data gaps and quality issues
• Worked closely with the users to understand their current state of information availability and defined future needs based on analysis of Business Requirements, current state environments and future state warehousing implementation
• Worked extensively with SMEs in understanding and documenting their requirements as well as maintaining, analyzing customers accounting books
• Worked with the Business community and Tech Lead in gathering their requirements and data transaction information related to OLAP
• Organized and conducted JAD sessions with different groups of users
• Brainstormed and made decisions on which data and which decision support applications would be most beneficial
• Hands on experience in various modules like Bonds, Securitization, Loan Processing and Claims handling
• Actively involved in Data Mapping of tables from Source system to Target system, including preparation of Entity Relationship Diagram
• Collaborated with the QA team to ensure adequate testing of applications based on business requirements and technical specifications; maintained quality procedures, and Test Plans and ensured that appropriate documentation is in place for Audit Purposes
• Planned and provided production support by categorizing, prioritizing the issues, assigning support roles following rotation
• Coordinated User Acceptance Testing (UAT) and training.
• Used SQl and prepared scripts to run queries, perform analysis and generate reports
• Prepared the screen layout of the various reports that were generated at the end of the month for different departments using OLAP
• Facilitated discussions to help the business people anticipate future needs and opportunities
• Defined timelines for project delivery, and provided the status update to the client team on a regular basis
• Assisted the team in obtaining the required permissions, managed the Project and resources to successful completion of the Project

Environment: UML, ERD, Informatica, UNIX, SQL Server, Crystal Reports, Clear Case, Share point, MS Project

Confidential, Irving, TX

Business Systems Analyst

Responsibilities:

• Involved in Requirements Gathering from user groups and analyzed workflows and UI screen dynamics
• Customized the RUP framework and implemented it in the project
• Created Use Cases based on the Business Needs and Features (BNF’s) provided by the business team
• Worked on Microsoft SharePoint to centrally store, manage and access Business Artifacts across all platforms and teams
• Created Activity and Sequence Diagrams in UML using Rational Rose and also involved in creating the Business Process Models
• Documented and reviewed high level and detailed level requirements in Detailed Design Specification (DDS) document
• Created Need Analysis Documents of the requirements gathered through JAD sessions and individual elicitation sessions using Rational Requisite Pro
• Played a major role in developing web services to enable identity management, linking applicable data to the identity.
• Addressed the identity issues like security standards, privacy policies, data retention and protection
• Created the specs for the stored procedures and triggers, based on the business logic
• Followed RUP Quality Assurance and Testing Process. Interfacing with program management and executive teams regarding quality assurance goals
• Wrote SQL scripts for validating the data during UATs
• Set up definitions and process for test phases including Product Test, Integration Test, System Test and User Acceptance Testing (UAT)
• Participated in entering, tracking system defects in Rational Clear Quest
• Provided enhancement support for the usage of the web platform by conducting knowledge transfer sessions

Environment: RUP, Requisite Pro, Rational Rose, Oracle, Test Manager, Share Point, MS Visio, MS Project

Confidential, CT

Business Analyst

Responsibilities:

• Interacted with clients for gathering, analyzing and documenting business requirements
• Served as liaison between business team and various other project groups
• Extensive interactions with the client and the management teams to understand the requirements
• Followed an iterative approach to organize requirements into logical groups of business processes, business rules and information needs and ensured that critical requirements are focused upon
• Reviewed Technical Design Documents created by the development teams and validated them against functional specifications and provided useful suggestions / comments to be incorporated
• Used UML to model use case diagrams for functional requirements
• Created functional specification document which includes use case diagrams, sequence diagrams, collaboration diagrams that provides the developers a view of the requirements for the system development
• Utilized Rational Clear Quest for defect tracking
• Used MS Access and Excel to extract, administer and manipulate large data
• Domain knowledge on Project Accounting involving in billing, payment processing, claims, account and expense management
• Participated in knowledge transfer and co-ordination with the off shore development team
• Assisted in User Acceptance Testing, performed client presentations and demonstrations
• Effectively utilized Quality Center along with QA lead in tracking and monitoring the defects and various test cases
• Involved in Providing enough training on the new system functionality and features

Environment: Micro strategy, Java, Message Broker, UML, Rational Requisite Pro, HP Quality Center, MS Office