SUMMARY

• Ability to bridge communication amongst technical and non - technical project staff and customers.
• Strong skills in documenting business requirements and systems analysis.
• Over 7 years professional experience as Business Analyst in Banking and Financial Services
• Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases
• Excellent in developing and evaluating business process models
• Proven success as a Business Analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions
• Led implementations, JAD/RAD sessions, testing, training and support for business intelligence solution tools
• Led requirements gathering for BI reporting solutions for Data Warehouse/Decision Support Systems (DSS) development integrating Cognos management and administrative reporting report design;
• Nurtured relationships of technical staff and functional owners of multiple source systems throughout the application development Life Cycle (SDLC)
• Managed documentation and process flows for internal teams and client project teams
• Created system specification/technical documents and functional process documents
• Supported business owners in issue resolution, benefit plan discrepancies, plan utilization concerns and suspected abusive activity using online business intelligence applications, customized analytics, and BI report development
• Developed training material and trained staff; performed knowledge transfer and ongoing client support
• Evaluated process flows and procedures and user application interfaces
• Developed project plans, managed project resources, managed project status, managed time lines, deliverables and documentation, and managed client expectations
• Wrote proposal responses to RFPs and RFIs
• Supported users in developing reports for data analysis and trend analysis using Cognos Report Studio/Query Studio, MS Access, and Toad
• Worked with Data Models (Dimensional and Relational); performed data mapping and gap analysis; analyzed data to validate accuracy and quality of data for data mart loads (utilized database structure knowledge)
• Worked with large data sets from multiple sources using tools such as Toad and MS Access to insure data integrity and reporting capability, data analysis and data conversions
• Created use cases, test cases and testing strategies and validation of requirements; Created test plans (system, acceptance and regression) for data validation and application development
• Worked with Unified Modeling Language (UML) tools to develop behavioral and interactive diagrams and some structural diagrams.
• Managed processes for test plans, test plan execution, release management and defect tracking
• Monitored application utilization, identifying software bugs and quality testing implemented designs
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/data mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Experienced in document sharing applications including MS SharePoint and documenting user stories using Rally.

TECHNICAL SKILLS

• UML
• MS Access
• SQL Server
• MySQL
• PL/SQL
• Oracle DBA
• DB2. ATG
• Windows 98/2000/XP basic UNIX
• HTML basic XML
• MS Office Suite-Excel Macros
• Project
• Visio
• Informatica
• Adobe Photoshop
• Flash
• Cobol
• SharePoint
• Cognos
• Crystal Reports
• .Net
• C
• C++

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Analyst

Responsibilities:

• Responsible for requirements gathering, analysis, detailed process flow design, user acceptance testing and rollout of new & modified feature functionality deployed on the website applications
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content
• Analyzed the data collected and process maps to determine the root causes and identify opportunities
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Experienced in developing technical documentation and ability to understand business analysis.
• Expertise to analyze problems, decision making skills and analyze issues according to the situation from different perspectives.
• Interfaced between Business new product builders and System platform builders
• Worked on data modeling and produced data mapping and data definition documentation
• Interacted with the business users in knowing the business views and gathered the reporting requirements to design the universes and business objects
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues
• Created technical design documentation for the data models, data flow control process, metadata management.
• Strong ability to build client relationships and create client satisfaction throughout the project.
• Professional experience in data analysis, operations management and development, design, documentation and testing
• Provided training and gave support to users on how to install the project software, used to communicate with various teams and provided escalation to development, other network support teams.
• Extensively involved in the modeling and development of Reporting Data Warehousing System
• Performed UAT testing along with call center managers to make sure that application meets their requirements.
• Conducted meetings on project SRS (Software Requirement Specification), have excellent written and verbal communication skills.
• Came up with test cases from the requirements, validated/exercised those test cases in form of integration and regression tests. Used Test Director to map the requirements with test cases (manual), used Mercury Quality Center to document test cases

Environment: RUP, UAT, GAD (Gap Analysis Document), MS Visio, MS Office, Java, J2EE technology, .NET, ASP.NET, SQL Server, Windows 2000 Advanced Server, UNIX / Oracle Platform

Confidential

Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead
• Worked on broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehouse, Data Modeling and Design
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of Technical Design (UI screen) using Microsoft Visio
• Perform Gap Analysis of the processes to identify and validate requirements
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Responsible for creating Report Design Documents (RRD) and Test Plans for unit testing
• Designed the business requirement collection approach based on the project scope and SDLC Methodology
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams
• Core responsibility involved complete manually testing of the User Acceptance Test (UAT)
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access
• Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Word, Excel, Outlook, MS Visio, Casewise modeller, Borland CaliberRM, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Cognos, Sybase, VBScript, C#. DOORS, Java, C++, NET, ASP.NET, Business Objects

Confidential

Business Analyst

Responsibilities:

• Developed business process models in RUP to document existing and future business processes
• Performed extensive requirement analysis including data analysis and gap analysis
• Designed and developed project document templates based on SDLC methodology
• Involved in UML design diagrams as Conceptual Model, Use case diagrams, Domain modeling Diagrams using Magic Draw
• Interacting with business users in gathering requirements and involved in writing Business Requirements specifications
• Involved in creation of use-case template that is incorporated in writing all use cases
• Involved in interaction with architects during domain modeling
• Interacted with developers in addressing clarifications
• Collaborated with Quality Assurance team in testing system changes
• Involved in training the business users in using the application
• Assisted Project Manager and client to understand the business and functional requirements for project development phase
• Recognized for excellent ability to multi-task on project consisting of diverse sets of people, platforms and parallel timelines via exceptional communication, organizational and interpersonal skills
• Bridged communication between the client and the project team. Developed and conducted internal training programs for developed applications. Developed and updated training documentation and course materials
• Created Test Plans and implemented testing methodologies. Made recommendations on how to improve current or proposed systems

Environment: Rational Rose, Rational Req Pro, RUP, WinRunner, LoadRunner, MSOffice2000, Java, J2EE, .Net, SQL Server