PROFESSIONAL SUMMARY

• Over eight years of extensive experience as a business analyst in business requirement gathering and analysis, business process re - engineering, object oriented design and modeling and also project management system.
• Excellent in business process modeling notation and workflow modeling tools.
• Good understanding of the software development life cycle (SDLC), rational unified process and agile- scrum methodology and testing life cycle.
• Expert in writing functional and nonfunctional requirements.
• Experienced in developing electronic trading system, web based portfolio management system, wealth management and financial software applications.
• Extensive usage of the GL, P&L and financial statements and analysis.
• Experienced with fixed income products like treasury (bonds, notes and bill), Mortgage backed securities (MBS), municipal bonds, corporate bonds, junk bonds and convertible bonds.
• Valuation applications and strong analysis knowledge of the financial statements, financing structures, derivatives, capital management, portfolio analysis, stock valuation, amortization and budgeting.
• Proficient in creating use case diagrams, class diagrams, sequence diagrams, collaboration diagram, state transition diagram, activity diagrams using UML methodology of MS Visio.
• Experienced in performing GAP analysis by identifying existing technologies and documenting and enhancing to meet end state requirement.
• Excellent experience in change control process and maintaining requirements traceability.
• Excellent knowledge of SQL and T-SQL to access database like MS SQL Server.
• Experience of ETL (Extract, Transform, Load) tools for data analysis and data warehousing.
• Strong working knowledge of Data Modeling, Data Mapping, Data Validation and Business Objects.
• Strong data collection, analysis and interpretation skills.
• Extensively used SQL server integration services to load data from flat files to SQL server, SQL Servers to flat files, excel files.
• Performed data migration using extraction, transforming and loading to the database archives.
• Extensive experience in creating business requirement document (BRD) and functional requirements document (FRD).
• Experience in creating and maintaining the requirement traceability matrix (RTM) conducting Joint Application Development (JAD) sessions, project meetings, reviews and walkthroughs and customer interviews.
• Expertise in developing testing documents - test strategies, test plans, test design specifications, test case specification and test procedures.
• Experienced in preparing and developing the user acceptance test (UAT) plan and obtaining the necessary signoffs from the concerned business units.
• Exceptional communication and interpersonal skills together with the ability to learn new concepts.

TECHNICAL SKILLS

Methodologies: RUP, SWOT, SDLC, UML, BRD, SRS

Tool Rational: Rose, MS Visio, QTP, MS Project, MS Office Suite, Quality center (Test Director), XML, HTML, Cognos, Blueprint.

Databases: MS SQL Server 2000/2005, MS-Access, Sybase, Oracle9i, DB2

Software: SAP R/3 4.7, SAP Solution Manager 4.0, QuickBooks

Technologies: Java Script, C, C++, SQL 2005/2008, PL/SQL, VB, C#.NET, ASP.NET, VB.NET, Visual Studio

Operating System: Windows 9X/NT/2000/XP/Vista/7, Mac, UNIX, LINUX

Reporting Tools: SQL Server Reporting services, Crystal Reports.

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential, Philadelphia, PA

Responsibilities:

• Analyzed the existing reports, procedures, extracts used to generate the manual reports.
• Worked with the business team to envision the Book of Business reports, Information to be displayed, drill down functionality, navigation.
• Facilitated the JAD sessions with the primary stakeholders, end users for requirement elicitation.
• Worked with the Oracle technology team to implement the reports on a corporate tool called OBIEE.
• Worked with the Oracle Identity Manager team for the security project. Discussed the strategy to ensure the security of the application, granting user an access to the application and functionality being offered by user.
• Worked on drafting BRD and FRD.
• Assisted usability team and documented specifications for the user interface.
• Worked with the technology team during the design and development of the project.
• Assisted testing team for drafting the test plan, test cases and test scenarios.
• Coordinated the testing efforts in QA testing, UAT.
• Conducted user training sessions for the end users of the application.

Environment: MS VISIO 2007/2010, MS OFFICE suite, MS Project Management, Microsoft SharePoint, Enterprise Architect,, HTML, SQL server 2005/2008, HP ALM center, Clarity

Business Analyst

Confidential, King of Prussia, PA

Responsibilities:

• Worked with the SMEs for both platforms, understood two different businesses and find the gaps between them.
• Facilitated the JAD sessions to communicate with the SMEs and stakeholder and allowing them to share their perspective and issues.
• Worked on the managed Accounts business, proposal system, Model Tools and other managed accounts related systems.
• Worked directly with the clients to understand the requirements and providing the solution to the issues clients were facing.
• Gathered requirements to solve the business need for the hPNC clients on Pershing managed account solutions platform, keeping the gaps in mind.
• Prepared BRD and FRD for gathered requirements.
• Prepared use cases for the requirements.
• Experienced drafting the change requests to the project and the business processes.
• Worked with the usability team to change the organizational hierarchy for the Pershing offered platforms.
• Acted as a liaison between the business team and technical team to get them quickly on an agreement.
• Developed new workflows with the help of the Lombardi workflow.
• Worked on account opening solution, single sign-on solutions for the various projects.
• Developed project plan in accordance with the project manager.
• Performed testing on the projects and participated in the business testing.
• Have experience on unit testing, integration testing.
• Worked on different modules of the project and assisted QA during the integration testing to ensure the different modules of the program function properly.

Environment: MS VISIO 2007/2010, MS OFFICE suite, MS Project Management, Microsoft SharePoint, Enterprise Architect,, HTML, SQL server 2005/2008, Quality Center.

Business Analyst

Confidential, New York, NY

Responsibilities:

• As-Is & To-Be documents review with business users to ensure business conditions and related requirements capturing.
• Prepared BRD and FRD for the gathered requirements.
• Conducted JAD sessions to allow different stockholders to communicate their perspective, resolve any issues and come to an agreement quickly.
• Worked According to the rules for GAAP (Generally Accepted Accounting Principles).
• Performed a key role in preparing software requirement specification (SRS), business requirement documents (BRD), user interface design, designing of application architecture and database modeling in project teams.
• Established business analysis methodology using agile dynamic systems development process.
• Developed use cases, workflow and screen mock-ups.
• Write detailed business requirements documents and assessment of current OTC derivatives instruction trade management processes for front, middle and back office.
• Interacted with the different SMEs deciding about the design and format of the reports.
• Recommend strategic initiatives and analyze OTC derivatives protocols and practices around DTCC, SWIFT, FpML and ISDA.
• Fixed several problems with B2B system that exchanges data between the company and its prime brokerage clients.
• Worked with data modelers and helped in enhancing data quality, data integration and data enrichment.
• Coordinated work plans between project manager and client using MS Project.
• Evaluated given problem, situation and crisis; investigate for solutions using data analysis practices and prepare analysis reports.
• Determine the methodologies and procedures for carrying out effective data analysis.
• Organized workshops, explaining technical design of the reports to be uploaded on business objects.
• Involved writing test cases and execution of tests phases.

Environment: Rational Requisite Pro, HTML, Java Script, Rational Rose, RUP, UML, SQL 2005/2008, PL/SQL, MS Office Suite, MS Project, MS SharePoint, Windows 2000, Crystal Reports, MS Visio 2007/2010.

Business Analyst

Confidential, New York, NY

Responsibilities:

• Detailed analysis of the existing systems and developed a model to develop a common fixed income trading platform with expertise in fixed income securities.
• Interacted extensively with business through JAD sessions and one on one interview sessions to write use cases, drawing UML diagrams and designing graphical user interface prototype.
• Worked closely with on-site and off-shore team members, resolving issues that surfaced during this stage for the software development lifecycle.
• Applied iterative model technique in every stage of the lifecycle.
• Perform analysis of the given data and draw accurate inferences, in accord with the objectives of the analysis.
• Managed the workflow process using SDLC methodology and iteration.
• Used UML to create state chart, sequence diagrams, activity diagram, and OOAD.
• Studied simple fixed income securities to more complex structured products like MBS.
• Extensively involved in user acceptance testing, Performance management and document user manual.
• Maintain the research database, update and upgrade it from time to time and ensure safe storage of data, performed data migration.
• Implemented data validation technique such as batch totals, cardinality check, check digits, consistency check, data type check, range check, referential integrity check etc.
• Developed use cases with UML diagrams.
• Worked directly with senior development engineers to identify areas to focus testing activities, report and track defects and project schedules.
• Used ERD (Entity Relationship Diagram) and performed data modeling.
• Performed system testing, UAT (user acceptance testing), performance management and documenting user manual.

Environment: Windows 2000,HTML, Rational Rose, JavaScript, BluePrint, SQL, MS Office Suite 2007, MS-Project, MS SharePoint 2007, Crystal Reports, MS Visio 2007.

Business Analyst

Confidential, New York, NY

Responsibilities:

• Acted as a liaison between the business team and the project development team by assisting in identifying, understanding and documenting business.
• Manually checked the important features of the OTC and according to that developed functional requirements that support overall strategy, goals, and objectives.
• Gathered business requirements from traders, portfolio managers, hedge fund managers and risk managements group to identify and map detailed current processes.
• Worked with developers to develop and document technical specification of system document.
• Worked autonomously within a team of data analysis, to analyze, review, update, edit, clean, translate and ensure accuracy of customer data.
• Participated in the logical and physical design sessions, developed design documents, generated Dataflow Diagram and System Processing Diagram to derive requirement for existing systems enhancements by using UML and created Functional Specification Documentation.
• Authored system requirements, System Design Documents and System Test Plans for the Extract, Transform and Load large data set of company data into the data warehouse resulting on customer approved transformation and successful on-time completion of new feature.
• Conducted System testing, developed test plan, test scenarios and test cases to be used in testing based in business requirements, technical specification and assisted User Acceptance Testing provided user training with detailed knowledge of application features and enhanced functions.
• Assisted in developing training materials for new technology, user feature and process improvement.

Environment: Windows 2005, MS SQL 2005,MS Visio 2007, MS PowerPoint, MS Office Suite 2007, MS Project, ASP.Net,VB.NET.

Business Analyst

Confidential

Responsibilities:

• Investigated and analyzed system to track activities of customer accounts for the portfolio investments.
• Analyzed business requirements documents, Activity sequence diagrams, written in MS word and MS Visio to develop functional and detail design specifications of the application.
• Monitored system resources to determine system components that can be modified to improve efficiency.
• Prepared written detailed business specifications, developed test plans and test cases.
• Conducted JAD (Joint Application Development) sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both technical and business people.
• Conducted requirements workshops among all project stakeholders to verify and validate the business requirements in UI design.
• Performed gathering, analysis, review and signoff of business requirements and conducting of interviews, sessions etc.
• Coordinated project scheduling with project manager.

Environment: Windows NT, MS Office Suite 2003, MS Visio, Crystal Reports, SQL, HTML, PL\SQL.