SUMMARY

• Resourceful and dynamic Business Analyst with Around 8 years of experience with strong business analysis skills and strong knowledge of the software development life cycle (SDLC) utilizing Water fall and agile methodologies.
• Highly experienced in various domains including Finance, Investment banking, Mortgage and Insurance.
• Highly experienced in broad range of technologies including business process tools such as MS Project, MS Office Suite, MS Visio, Data Warehousing concepts, Reporting Tools (SSRS, crystal reports), OLAP, OLTP and Web design.
• Over 3 years of experience with detailed working knowledge of Eagle Pace, Eagle Pricing Center, Eagle Reference Manager
• Strong querying knowledge
• Strong experience in client interaction, understanding business applications and business data flow and experienced in conducting JAD Sessions, Interviews and client meeting to gather requirements.
• Extensive Experience in using business modeling and configuration management tools like Rational Rose, MS Visio for creating use case diagrams and work flow diagrams.
• Experienced in modeling Transactional Databases and Data Warehouses using tools like Erwin.
• Experienced in Implementing Normalization/De - normalization techniques for optimum performance in OLTP/OLAP database environments.
• Strong knowledge of RDBMS concept, logical/ physical data modeling, Dimensional/ER Modeling, Star and Snowflake schemas.
• Experienced with Data Warehousing/ ETL technologies and working knowledge of basic data warehousing design concepts.
• Expert in facilitating and defining the entire Testing Life Cycle including Test strategy, Test planning, Test case preparation, Test execution and Defect management.
• Experienced in conducting Automation, Performance, User Acceptance Testing using various tools including Rational Suite and coordinating with the UAT participants.
• Experienced in using Rational Requisite pro for managing requirements throughout the application lifecycle.
• Adept in deploying the projects by involving in go-live processes and getting client feedback timely.
• Strong customer/user advocate, apt negotiator with excellent analytical, communication, decision-making, organizational, interpersonal, and presentation skills.

TECHNICAL SKILLS

• UML (Unified Modeling Language)
• Erwin (7.5)
• Microsoft Office suites (Word
• PowerPoint
• Access
• Excel
• SQL Server 2008/2010 pivot-tables
• Outlook
• Project
• Visio
• Rational Tools (clear quest clear case)
• HP Quality Center
• Quick Test Pro 9
• Azure/Private Cloud
• SharePoint
• System Center
• Win runner and Load Runner.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Business System Analyst

Responsibilities:

• Prepared Business Process Models that include modeling of all the activities of the business from the conceptual to procedural level.
• Experienced in implementing and troubleshooting Engle and PACE platform.
• Upgraded Eagle (Star & Pace) application from version 6.0 to version 12x based on the business needs.
• Responsible for coordinating global technical support relating to the Eagle software product PACE.
• Performed data profiling on the implementation of Enterprise Data Warehouse and analysis reporting data mart
• Project experience in one or more areas encompassing Investment Performance Calculations, Attribution, Pricing, Investment or Fund Accounting, Enterprise Data Management, and Market/Reference Data.
• Strong understanding of multiple asset classes including Equities, Fixed Income and Derivatives.
• Worked closely with the Project Manager to plan how the work can be broken down into logical components to facilitate focused and efficient requirements gathering.
• In charge of creating and maintaining the Business Requirement Document (BRD).
• Detailed knowledge of pricing center work flow
• Used Requisite Pro to document requirements, associate change requests with requirements and connect requirements.
• Facilitated business requirements gathering sessions (JAD sessions) with the client, and overlooked the creation of Use Cases/Activity Diagrams and Functional Specifications using Visio.
• Performed feasibility study and risk analysis to identify the most critical requirements from the user’s perspective.
• Conducted one-on-one meetings with the project SMEs (in person or by phone) to gather the requirements.
• Assisted Project Manager and provided regular project communications to the project manager and business areas.
• Expert in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS) of MS SQL server 2005/2008.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Obtained and maintained a comprehensive understanding and acted as a subject matter professional for the designated applications and their respective interdependencies and integration points in business operations and processes.
• Strong knowledge of Business Process and System Analysis principles using several visualizations like flow char, functional block diagram, control flow diagram, gantt chart etc.
• Documented business workflows textually as well as in UML diagrams (State diagrams) using Vision and forwarded them to stakeholders to review.
• Created wireframes for the web application layout that could be understood by both business and technical personnel.
• Ability to document business and user requirements, such as process flows, functional requirements, user interface mockups, user stories numeric and conceptual data diagrams.
• Used IBM Rational Requisite Pro to manage a requirements traceability matrix, made in MS Visio.
• Maintained test suites and performed performance testing using Load Runner.
• Provided post-implementation support for the new web application used by the clients.
• Promoted Business Process improvement for better feasible business models.

Environment: Eagle Pace, RM Requisite Pro, SQL Server 2008/2010, Windows XP, MS Word, MS Excel, Microsoft Visio 2007, Swim Lane Diagram, MS Outlook, Azure/Private Cloud, SharePoint, System Center, HP Quality Center

Confidential, Cincinnati, OH

Business System Analyst

Responsibilities:

• Lead business initiatives including brainstorming on new functionality for current systems.
• Gathered and documented the requirements that were critical to the business mission and used those requirements to design application software using a Use Case in Requisite Pro.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Created use case scenarios and documents work flow and business process.
• Documented business workflows textually as well as in UML diagrams (State diagrams) according to RUP, for the stakeholder review.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Implemented Table Partitioning and Data Compression, Cache Connection for performance improvement.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Analyzed and documented Business requirements and detail design of the software for full understanding of the business.
• Expert in payment rejects and root cause.
• Conducted FRS and URS reviews and walkthroughs with the designers, developers and stakeholders.
• Used Requisite Pro to document requirements, associated change requests with requirements and connected requirements with Use cases.
• Highly efficient in reviewing project deliverables for quality and delivery assurance.
• Familiar with Cash positioning, debt management, and bank reconciliation.
• Performed feasibility, adaptability study and risk analysis to identify the business critical areas from USER perspective.
• Experienced in one or more Corporate Finance functions like regulatory reporting, general ledger, MIS and reference data.
• Strong knowledge of Business Process and System Analysis principles using several visualizations like flow char, functional block diagram, control flow diagram, gantt chart etc.
• Performed Business process redesign, business process innovation, process management and integrated business planning to improve all business processes among all cross-functional groups.
• Experienced working with technology stakeholders and liaising to SMEs.
• Worked closely with staff to produce and analyze quarterly, semi-annual and annual reports.
• Proven expertise to lead and facilitate sessions to deliver requirements to project teams (i.e. development, QA, training, etc.).
• Ability to gather, manage, and consolidate requirements from cross-functional groups.
• Extensively involved in gathering business requirements and system requirements and specifications. Provided conceptual solution. Translated conceptual solution into technical design. Extensively worked on system architecture. Used UML to create use cases, used case diagrams, classes & sequence diagrams.
• Prepared test cases, test plans, test strategies, traceability matrix for QA team.

Environment: UML, MS Visio, Rational Rose, SQL Server 2008/2010, Azure/Private Cloud, SharePoint, System Center, HP Quality Center

Confidential, Manhattan, NY

Business System Analyst

Responsibilities:

• Gathered and identified business requirements from the business stakeholders, users, SMEs and translated into FRD, BRD, and system specifications. Interact with all levels of project development team.
• Produced Functional Specifications for large trading systems. Reviewed and analyzed the entire Batch Jobs schedule and provide the analysis to the Technology support team to meet the goal.
• Assisted the project manager in creating detailed project plan and scheduling and tracking project timeline using MS Project.
• Assisted in dimensional logical model and physical model as per business requirements.
• Validated the data by creating data validation scripts to verify the loading process.
• Assisted test lead and testers understanding business process and helped them for successful completion of Unit Testing, Regression Testing and Functional Testing.
• Played a key role in UAT and validating the source to target data mapping.
• Conducted training sessions for the end users and documented various training manuals.

Environment: RM Requisite Pro, Windows XP, MS Word, MS Excel, Microsoft Visio 2007, Swim Lane Diagram, MS Outlook

Confidential, New York, NY

Business System Analyst

Responsibilities:

• Conducted interviews with the clients for gathering requirements and evaluation/analysis of their data. Converted the business requirements into IT specifications.
• Created Use Cases, Workflows, and Screen Shots for the Application.
• Developed the business and functional requirement specification describing and prioritizing of the requirements.
• Identified and implemented a small set of architectural mechanisms.
• Conducted regular walk-through with the developers and testers.
• Performed feasibility, adaptability study and risk analysis to identify the business critical areas from USER perspective.
• Supported IT unit creating functional specification documents for the design, development and implementation of strategic projects.
• Supported the assigned project manager with creating detailed project plans assisting in developing, scheduling and tracking project timelines.

Environment: Rational Suite