SUMMARY

• 8 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
• Strong Domain knowledge on Financial concepts like Credit report, liquidity, security standards, compliance guidelines, Basel (I & II) regulations etc
• 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
• Extensively worked on different types of Business Intelligence /Business Objects solutions and reporting applications such as Cognos, SAS/BI, Crystal Reports and SSRS.
• 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
• Developed various automated and customized reports along with improved template formats for various data metrics as part reporting
• Designed & developed SAS BI solutions including data acquisition and data modeling.
• Regularly conducted Knowledge transfer sessions with Analysts, Developers, QA’s and provided updates to the Directors
• Worked with the marketing team and analyzed marketing data using SAS tools to generate reports, tables, listings and graphs
• Strong Domain knowledge of member benefits and claims processing, Medicaid/Medicare programs, physician contract, Part A to Part D and compliance guidelines.
• Scrum Master for Two internal projects both involving automating various manual processes in AGILE mode in order to improve timely delivery and quality
• Responsible for creating measurable KPI’s using score cards and dashboards for sales teams across all the markets which improved customer attrition and gave better demographic analysis for our Directors
• 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, SSRS report designs 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, SSRS reports, 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 involving concept modeling, conceiving and implementation details.
• 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
• Analyses, Create and extract Oracle tables from SAS and within Oracle by using SAS/Access, SAS/SQL.
• Involved in architecting the data marts, OLAP,ROLAP, MOLAP cubes for fast & flexible reporting of pre-summarized large datasets and decision support
• Extracted raw data from the warehouse and created SAS data sets that arerequired for the project analysis using SAS FTP and SAS/ACCESS and SAS/CONNECT.
• Consistently Organized various JAD sessions with multiple teams and carefully maintained the minutes documents
• Developed reports, Data views from CognosCubes for the Field reporting group
• Conducted Daily Status meeting with the development teams and Weekly Status meeting with Management and Steering Committee team
• Extensively worked on performance indicators for various business units (loyalty, telephone, retail etc) and established a monitoring process which benefitted in overall customer relationship management
• 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
• Documented Cost/Benefit analysis, Risk analysis and responsible for presenting progress status in a timely manner
• 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: SAS BI,SAS Base, SAS Macros, Cognos, 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 risk management, Basel (I & II) regulations, Federal laws, and security standards
• 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

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
• Performed Data analysis involving claims processing, provider contracting, Medicare/Medicaid Benefits etc in order to identify issues and provide new initiatives of effective solutions
• 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

Confidential

Business Analyst

Responsibilities:

• Played the role of a Business Analyst in a RUP environment by eliciting Business Requirements from business users by conducting various meetings
• Conducted various interviews and meetings for requirement gathering with key business users and SMEs
• Maintained and kept track of stakeholders requests for system enhancements and changes
• Used Rational Requisite Pro to analyze and document requirements
• Interfaced with development and testing teams to accomplish timely release objectives
• Analyzed the system functionality in relation to impacts of the change requests and other system modifications
• Documented the change requests and provided the reasons and root cause of change
• Created and Modified the Use Cases for the incoming change requests and system enhancements
• Developed test cases in accordance to business requirements, technical limitations and product knowledge and ensured all the possible scenarios are included in the test plan
• Controlled and tracked defects and change requests using Test Director
• Used Test Director to create reports and graphs to help review the progress of planning tests, running tests, and tracking defects
• Reviewed test objectives to make sure that all the possible scenarios are tested for the system enhancements
• Documented Meeting Minutes of various meetings and Brainstorming Sessions
• Developed project delivery schedule, managed projects and identified resources to successful completion

Environment: RUP, Rational Requisite Pro, Test Director, UNIX, Share Point, MS Project, MS Office