OBJECTIVE

• Seeking a challenging position in an established organization as a Business Analyst to design and develop enterprise information systems by effectively utilizing my technical and business domain experience of Corporate Finance, Insurance P&C, Investment Banking, Portfolio Management, Equity Trading, Capital Market, Mortgages, Asset Management and Healthcare

SUMMARY

• Analytical, enthusiastic, innovative and highly motivated Business Analyst with 5 years of experience in all phases of the Software Development Life Cycle (SDLC) including requirements gathering, analysis, design, implementation, testing and deployment as well as software engineering methodologies such as Waterfall, Rational Unified Process, Agile, SCRUM and LEAN
• Comprehensive experience in SWOT analysis, Gap Analysis, As - Is and To-Be Business processes
• Extensive experience in Analysis, validation, Business Requirements Specifications and Functional Specifications, User Interface Design, ER diagrams, data flow models and used UML with RUP, Agile Modeling, Iterative models of SDLC (analysis to post implementation), and Testing (Test Plan, Test Cases, Unit Testing, Integration, System Testing and UAT)
• Extensive experience in gathering, managing and documenting business and functional requirements communicating effectively with upper management, developers and QA engineers
• Created the Requirements Traceability Matrix that traces the requirements to the next level
• Adapt at creating and transforming business requirements into functional requirements and designing business models using UML diagrams - Use Cases diagrams Activity diagrams, Sequence diagrams, State diagrams and business process flow diagrams using MS Visio, Rational Rose, Visual Paradigm
• Excellent facilitation skills in conducting walkthroughs, surveys, questionnaire, interviews JAD sessions, brainstorming sessions and managing project teams
• Experience in Project Management of development projects, maintaining project plans, keeping sponsor communications, submitting project status reports, doing QA testing of systems and solutions, following up on user change requests, assist in user level documentation and training manuals
• Good experience with writing SQL queries for data validation
• Excellent written and oral communication skills, analytical, problem-solving skills and decision-making skills, proven ability to manage small and large-scale projects and to interface with stakeholders with Client relationship management skills
• Have exposure in educating internal customers on business systems and procedures and working with other analysts and QA teams to set priorities and schedules

TECHNICAL SKILLS

Requirements Tools: IBM Requisite Pro, Doors, CaliberRM

Programming Language: Java/J2EE, C/C++, SQL, PL/SQL

Web Technologies: HTML, XHTML, XML, CSS, JavaScript

Databases & Tools: MySQL, MS SQL Server, Oracle 8i/9i, MS Access, TOAD, SQL Developer

Modeling & Wire framing Tools: MS-Visio, Rational Suite, Enterprise Architect, Visual Paradigm, Erwin, Balsamiq

Operating Systems: Windows XP/NT/Vista/7/Server 2003, RH Linux

Office Suite: MS Office (MS-Word, MS-Power Point, MS-Excel, MS-Project, MS-Outlook), SharePoint

BI & ETL Tools: Crystal Reports, SSRS, SSAS, SSIS, Talend, Cognos

Bug Tracking & Testing Tools: JIRA, Rally, QTP

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Business Systems Analyst

Responsibilities:

• Worked closely with the Financial Advisor (theSME’s) to obtain a detailed knowledge about wealth management, Risk Management andBaselIIcompliances
• Worked on Fixed Income, Bonds, Equities, Derivatives (Options and Futures), Portfolio Management, and Wealth Management, Alternative Investments, Hedge Funds, Private Equity Investment Processing, Corporate Actions
• Worked with the PM to decide upon the best methodology for the project and the best approach for requirement gathering
• Assisted Project Manager to manage schedules, deadlines, resources and collaborate on the project
• Acted as a liaison between Business Consultants and IT team to discuss best method for implementing Systems solutions that meet business needs
• Facilitated JADsessions to allow different stakeholders to communicate with each other, resolve problems at early stage
• Created User Requirement Specifications (URS), Business Requirements Documents (BRD) and Functional Requirement Specifications (FRS) documents using Rational RequisitePro
• Performedrequirement analysisandGAP analysisto show the current and proposed functionalities of the system
• Identified and createdUMLDiagrams including usecase diagrams, activity diagrams, sequence diagrams, and class diagramsusingMicrosoft Visio and developed Wireframes, Screen designs using Balsamiq
• Understood the business logic, user requirements and test-objectives to assist QA team to develop test plans, test cases, test case execution, tracked and managed change requests
• Analyzed design methodology for data mapping, data identification and data acquisition from various banking systems intoBaselIIdata warehouse. Evaluated overall functionality of systems developed for credit appraisal, credit administration, funds management, securities processing, risk management, and regulatory compliance includingBaselII
• Developed test plans, test cases coordinated and monitored User Acceptance Testing activities
• ConductedUAT(User Acceptance Testing) to make sure that all the user requirements are catered by the application

Environment: Windows 2003, MS Project, MS Excel, MS Visio, Requisite Pro, Balsamiq, Oracle 10g, SQL

Confidential, Boston, MA

Business Analyst

Responsibilities:

• Involved extensively in preparing and identifying features and then created business process requirements from the features list prepared in Excel
• Frequently interacted with core groups including End Users, SME’s, through extensive usage of Microsoft Live Meeting, development teams to understand the process during the requirement gathering phase
• Performed Gap Analysis and analyzed “As Is” and “To Be” business processes
• Created Business Templates using the norms of standard RUP methodology and implemented the same for the Business requirements and Functional requirements
• Mentored the Business Analysts and trained them in RUP Methodology.
• Modeled the Use Case Diagrams in Enterprise Architect generating the regular and alternate flows
• Involved with the Developers and helped them with Data Migration for all the User ID’s from the Desktop Environment to the Internet Environment and generated the reports with the help of Crystal Reports X
• Used the SOX compliance provisions mainly the Public Company Accounting Oversight Board requirements in documenting the functional requirements
• Worked extensively with MS Sharepoint and uploading all the documents created, checking them in/out for maintaining version history
• Involved in meetings to identify the new structure and modify existing structure as and when necessary during requirements creep. Used the Lotus Notes Instant Messaging when the Application manager was not available.
• Worked with Relational Databases while migrating the Users of SSO from Internet environment to Desktop Environment
• Trained the end user to use the system and performed UAT to evaluate it with the requirements

Environment: Windows 2003, Rational RequisitePro, Enterprise Architect, Oracle, J2EE, Servlets, Java Server Pages, Web Sphere, HTML, JavaScript

Confidential, Austin, TX

Business Analyst

Responsibilities:

• Conducted problem analysis, user interviews, gathered, analyzed and documented business requirements based on the analysis of HIPAA transaction processing workflow model
• Conducted customer interviews to define and document user requirements for Confidential applications
• Served as the primary liaison between the business line, operations, and the technical team throughout the project cycle
• Reviewed Project Charter Documents, authored Business Requirement Document (BRD) for tagging and tracing to Use-Case specifications, System Requirements Specification and UI Functional Specification documents.
• Involved in ICD9 and ICD10 gap analysis process and used HL7 standards
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams using Visual Paradigm and Rational Rose
• Analyzed and prioritized HL7 V3 and CDA model for cancer diagnosis.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Payer network, payer path and Tiger
• Assisted client in developing content and training materials; recommended enhancements and identified new business requirements
• Clarified QA team issues, reviewed test plans and test scripts developed by QA team to make sure all requirements will be covered in scripts and tested properly
• Participated in the bug review meetings, updated requirements documents as per business user feedback and change in functionality of application
• Assisted the user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation was in place

Environment: Requisite Pro, Office 2007, Rational Rose, HTML, SQL/MYSQL, MS Visio, Clear-Quest, C/C++, XML

Confidential

IT Business Analyst

Responsibilities:

• Worked with major business areas, reviewed and assessed information gathered, defined key facts and issues, identified potential problems and facilitated problem resolution for external client reporting
• Designed and developed project document templates based on SDLC methodology
• Established a business analysis methodology around the RUP (Rational Unified Process)
• Comprehensively performed requirement gathering for enterprise reporting system-using RequisitePro
• Identify data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process
• Extensive experience with SQL Server 2000 and Oracle in analyzing triggers, stored procedures, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
• Extensively used Talend, SSIS and SQL for analysis and mapping of data from Mayur Work’s Database for Portfolio Accounting at different stages of the ETL process
• Prepared the Business Workflow and timeline using MS-Visio and MS Project with input, output, pre/ post conditions
• Performed extensive requirement analysis including data analysis and gap analysis
• Designed, developed and executed Test Cases / Plan for various portfolio accounting & infrastructure upgrade projects.
• Helped the testing team document the system requirements and tested the system developed
• Designed and executed SQL queries for QA testing and report / data validation
• Trained various users, which enabled them to submit, review and approve changes within the document

Environment: Windows Server, Requisite Pro, MS-Office (Word, Visio, Project, PowerPoint, Visio), SQL, SQL Server, Oracle, Talend, SSIS, SSRS, Crystal Reports

Confidential

Jr. Business Analyst

Responsibilities:

• Gathered the requirements from stakeholders and users by means of personal interviews, brainstorming, video conferencing and questionnaire
• Acted as a liaison between the IT and Stakeholder’s, Subject Matter Experts (SME) to communicate the business requirements to the technical team
• Conducted a SWOT analysis to identify Strengths, Weakness, Opportunities, and Threats
• Developed UML diagrams from the functional specifications and requirements document using Rational Rose
• Prepared Work Breakdown Structures (WBS) to comply with the triple constraint: time, cost and scope
• Followed Traditional Waterfall model of software development
• Created and implemented test plan and thereby assisted Quality Analysts to test the product in a timely manner
• Interfaced with Quality Analysts for unit, integration, system and User Acceptance Testing.
• Communicated with top management to ensure that IT initiatives and involvement are clearly understood
• Reviewed and analyzed the business environment and identical process improvements
• Evaluated alternative solutions and recommended solutions that best meet the need of the business
• Defined and planned software releases in accordance with other software applications
• Helped in designing the database in Microsoft SQL Server using data modeling techniques
• Involved in data quality, data mapping and validation issues with other members

Environment: Windows Server 2003, MS Office, MS SQL Server, Java, J2EE, Rational Rose, Requisite Pro, XML, HTML