PROFESSIONAL SUMMARY

• 10 yrs of Senior Business Analyst with extensive background in enterprise systems and applications. Specialized in leading requirement/specification analysis and documentation, testing and training in government and commercial agencies, including State Departments of Transportation and Human Services. Strong experience with GIS-based applications and migrations from mainframe and other legacy systems.
• In depth knowledge of Software Development Life Cycle SDLC , with thorough understanding of scoping, requirements, analysis/design, development, testing and training phases through Agile/Scrum, RUP and Waterfall processes.
• Solid understanding of gap analysis, requirements management, testing and project plans, with experience writing business and functional requirement documents, authoring use cases, and creating specifications.
• Expertise developing UML use case diagrams, work flow diagrams, data flow diagrams, flowcharts, screen mockups and report prototypes using tools such as Rational Rose and MS Visio.
• Experience in conducting joint application requirement/development JAR/JAD sessions with end-users, SMEs, development, and QA teams for resolving issues and making decisions.
• Strong knowledge of SQL and data mapping.
• Highly skilled in creation of UAT plans and cases covering business, functional and non-functional test scenarios specification of expected test results and UAT execution, including defect tracking and resolution.
• Experience creating test metrics, including test coverage, test results, requirement traceability matrix RTM and acceptance reports manually and using Test Director and Quality Center .
• Expertise in GUI testing and functionality testing of client/server and web-based applications
• Knowledge of stocks, bonds, options, futures, forwards, swaps and fixed income securities
• Knowledge of Financial Statement Analysis, Ratio Analysis, Prime Brokerage
• Excellent understanding of Credit Derivative products Credit Default Swap CDS , Credit linked note CLN , Total Return Swap TRS , Collateralize Debt Obligation CDO , Collaterized Mortgage Obligation CMO
• MS Access Dynamic- Microsoft Dynamics CRM 2011 is available as a cloud offering or an on-premises installation by a partner/customer. As in CRM 4 these versions can be highly customized using advanced extensions. New feature set includes Visualizations, Dashboards, Document Management, Grid Filters, Dialogs, Recurring Appointments, Custom Activities, Goal Management, Fetch based Reports, MAPI based Outlook clients, FLS etc.
• Knowledge of structured finance products Mortgage Backed Securities, ABS with
• Securitization process.Risk measurement-using metrics such as Duration and Convexity.
• Knowledge of Securities lending process, rebate rate, collateral.
• Good understanding of Bond pricing and trading, Equity trading cycle and Risk analytics.
• Hands on experience on funds transfer application including the messaging system like SWIFT and FIX protocol. CHIPS and Fed Wire.
• Extensive knowledge in Software development life cycle SDLC , Project management life cycle PLC
• Excellent understanding with methodologies like RUP, Agile, and waterfall.
• Assisted in Data Migration.
• Experience in documenting BRD Business requirement document and FRD Functional requirement document .
• Subject matter Expert: Fixed Income and Equity Trading system.
• Excellent communication/written skills.
• using ER diagrams, Data Mapping and Data definitions, Reference data.
• Experience in UML: /Use case diagrams, Activity diagrams, and Sequence diagrams, Class diagrams using various tools such as Ms Visio, Rational Rose and Visual Paradigm.
• Knowledge of working with various database such as Oracle9i, MS SQL Sever, MySQL, Sybase
• Knowledge of compliance such as BASEL I, BASEL II
• Hands on experience using SQL to query to the databases such as Oracle 9i, SQL server
• Interacted with the QA team and assisted them in creating test case, test plans, test scripts.
• Interacted with the change management team, Developing team, QA team, Business team and various other departments and performed UAT and system testing.
• Experience with application tools such as rational tools such as Rational requisite Pro, Rational Rose Case complete, visual paradigm MS Visio, MS Excel, MS Word, MS PowerPoint, MS Access.

Professional Experience

Confidential

Business Analyst

• Project 1: BDIS-EMAP Project involved implementing a comprehensive bridge data information system BDIS with electronic mapping EMAP that is GIS-enabled using Esri and is integrated with a roadway information system RIS .
• Project 2: Statewide Learning Management system SLMS Project involved creating a learning module for a user productivity tool and required extensive data mapping and data conversion while migrating off a legacy system.
• Project 3: Statewide Financial System SFS Project involved integrating NYS DOT with new Statewide Financial Systems.
• Project 4: Enterprise Comprehensive Civil Rights Reporting CR2 Project involved upgrading construction reporting systems to provide civil rights reports.
• Project 5: Business to Government B2GNOW Contract Compliance Module Project involved implementing COTS diversity management software and integrating with existing systems.
• Project 6: E-Discovery process Project involved creating an application for retrieving documents from servers, backup tapes, and other electronic media.

Responsibilities

• Performed analysis and design for GIS-Esri interface with BDIS- EMAP.
• Worked with mainframe migration team to ensure that all components common to all migrations were designed and assigned clear ownership.
• Performed data conversions and data validation.
• Conducted JADs with stakeholders at multiple different phases of the software development life cycle SDLC to discuss and resolve open issues.
• Delivered presentations to management and executives on the progress of the project after every phase of SDLC based on RUP methodology.
• Held regular meetings with the business user groups, system architects, developers, database developers, quality testers, to assure that all details of the projects were discussed and issues were resolved quickly, and provided current project status updates.
• Mentored testing team in building the test cases.
• Gathered user and business level requirements from SMEs from multiple departments including Accounting, Finance and Information Systems and designed the business requirement collection approach based on the project scope using RUP.
• Created use case models, analysis models, design models and implementation models authored use cases created use case diagrams and behavior diagrams sequence diagrams, activity diagrams based on UML methodology using IBM Rational Software Modeler and MS Visio.
• Conducted surveys and interview sessions and translated them into functional and non-functional requirements.
• Made recommendations to improve the application performance.
• Used SQL queries to transfer data from the server to the web page and to review reports and perform data validation.
• Successfully performed migration from legacy system to a web-based application.
• Utilized Service oriented Architecture SOA by IBM to create and track the architecture design of the process.
• Worked on XML Schemas, SOAP and WSDL.

Confidential

Business Analyst

Responsibilities

• Interviewing Pension Fund Advisors, portfolio managers to understand their current business processes and functional requirements, identify, assess and gather their future needs and transform them to functional specifications.
• Preparing rules as per as various compensation plans, retirement plans, and employer sponsored plans etc.
• Preparing reports for the various plans annually and semi-annually
• Manage project by controlling project scope, identify and resolve key issues and risks timeline to ensure quality, on-time deliverables.
• Applied Agile Methodology and scrum methods by conducting bi -weekly Sprint meetings.
• Perform data analysis to identify trends to better understand the current business process and data modeling to define the new system while integrating the current and future business requirements.
• reconciliations by appropriate deadlines
• Contact internal departments and external contacts when necessary to resolve corporate actions issues
• Resolve discrepancies and take action on routine matters and inquiries from external clients and internal departments
• Escalate more complex issues following procedures to ensure timeliness and accuracy of processing
• Interface with clients and other departments on routine matters and inquires
• Write/create functional specifications documents with supporting use case diagrams and preferably traceability matrices and data flow diagrams.
• Assist the technical team in understanding and developing the appropriate functionality, work with the development team to ensure that they understand the specifications and participate in design review to ensure the integration of all requirements
• Organize and catalog all asset, product, and economic data
• Provide tools for ensuring data quality / overrides
• Capture and store intellectual capital and best-thinking
• Create consistency in data, workflow, and appearance across all tools
• Work with training team to document system scenarios and identify roles impacted and help develop a change management/training plan.
• Generate reports that measure the performance of the portfolio within the accounts and groups, the overall accounts, return on investments, average modified duration.
• Verify the data in order to develop custom reports for the portfolio managers by models, asset classes and security holdings per account.
• Utilizing SQL queries to perform data analysis in order to gather data and analyze
• MS Access Dynamic- Microsoft Dynamics CRM 2011 is available as a cloud offering or an on-premises installation by a partner/customer. As in CRM 4 these versions can be highly customized using advanced extensions. New feature set includes Visualizations, Dashboards, Document Management, Grid Filters, Dialogs, Recurring Appointments, Custom Activities, Goal Management, Fetch based Reports, MAPI based Outlook clients, FLS etc.
• Worked on XML Schemas, SOAP and WSDL.

Confidential

Business Analyst/ QA

Description

This project was for the Municipal Bonds Division of Wachovia. The division would like to view P/L attributes and Risk analysis based on their cash and hedge positions. The system will provide a user interface for display of real-time and end-of-day values of positions along with P/L and ability to perform risk assessments. This user interface will be used by various types of users, and each user will be able to customize and save their views. Users will be able to slice and dice P/L and risk values by accounts, deals, desk or a combination of these and be able to view them as aggregates. The system will primarily deal with Municipal instruments and their Hedges. The products include short and long-term bonds, structured products, taxable bonds, and hedges to Municipal positions.

Responsibilities

• Conducted brainstorming sessions to understand client specifications and requirements. Documented business processes using Business Requirement Document format, and Functional Requirement Specifications Document
• Extensively created use cases and activity diagrams
• Conducted weekly meetings with clients to review functional specifications and resolve open issues
• Analyzed various risks that had to be accounted in risk calculation engine.
• Modeled risks and performed sensitivity analysis in Excel spreadsheet and shared the document with the technical team, and traders, facilitating effective communication
• Associated with product evaluation, product customization and system integration. Involved in Gap Analysis around the identification of business rules, business and system process flows, user administration, requirements and assumptions
• Involved in the design of various screens such as the real-time and end-of-day values of P/L attributes, Risk Risk sensitivity views.
• Assisted in developing ER models for database design
• Used SQL to perform data analysis
• Supported development of QA test plans for functional integration and system testing
• Involved in developing test case objectives to ensure accuracy in depiction and computation of risk associated with the securities, reported errors to the appropriate team and performed black box testing, after correction of errors by the technical team.
• Liaised with external parties - stock lenders, brokers, custodians and clients
• Maintained sound controls over the settlement process.
• Work to tight deadlines and adapt to a face paced environment
• Reduction of cost while improving service quality.

Confidential

Business Analyst

Description

The Project required managing the software for handling the equity trades within the trading cycle. The software was designed to handle all the trade exceptions at various levels. The System handles various kinds of issues within trade cycle. The Global transaction Software effectively manages equity trades and the exceptions happening due to various data mismatch, manual error or incompatible file transfer. It provides complete details of the exception and also allowed proper routing to appropriate teams based on exception type and provided approval workflow.

Responsibilities

• Worked with Business Sponsors, Business Users, and Project Managers to poll key stakeholders, to understand the different transactions.
• Supported the team to manage the exceptions and figuring out various root cause of the issue.
• Defined and prepared project documentation including: Project Definition Documents, Project Plans and Functional Specifications using standardized processes meeting both vendor and internal documentation requirements
• Worked extensively on Global transactions manager software management.
• Configured the transactions classifications with the exception handling software.
• Assisted the development team in interface development and performing unit testing
• Wrote User cases for the various exceptions handling module.
• Effectively worked with QA teams to review test requirements and documentation.
• Maintained weekly project status reports, issues and documents.
• Assisted Business Users with UAT planning and execution for new products and functionality
• Assisted in Prime Brokerage: Securities lending and hedge fund processing.
• Acted as a liaison between users, developers, testers, and implementation specialists

Confidential

Title: Business Analyst/QA

Description

This system dealt with the trading of fixed income securities such as bonds, commercial paper, asset backed securities and money market securities repos . The system enabled to easily create orders, execute trades, and manage investment portfolios. The trade could be executed through trade blotter or manager workbench. The system also generated various status messages at various levels to smoothen the trading process. The system had an option for the trade to be executed through trader or can be done through done deal method. With the done deal functionality the system can check the compliance and execute the trade at the same time. This system also enabled to manage and track commercial lending.

Roles and Responsibilities

• Performed pre analysis of the user requirements, assigned priorities and translated the requirements to functional specifications and mapped the requirements to appropriate business rules.
• Created the detailed requirements document for entering and retrieving Fixed Income securities.
• Assisted in loading the parameters and creating fixed income order through manager work bench.
• Assisted the project manager and PMO office for project management including the budget.
• Gained experience in investment operations and project management related to Commercial paper Issuance and securities lending.
• Implemented the usage of GSCC for the same trade confirmations on US treasury.
• Planning, updating and maintaining the project plans/charters and project progress reports.
• Involved in defining project scope, project plans and timelines communicating the same to project and technical team members throughout the project life cycle
• Prepared activity diagrams using Rational Rose according to UML methodology
• Maintained various versions of the documents generated during the project and managed them by incorporating the change request modifications
• Extensively carried out User Acceptance testing UAT by closely working with users and Developers
• Prepared user training manuals and conducted user training sessions
• Worked with sales/traders, front office, settlements, Exchange Traded Derivatives OMS to roll out derivatives products
• Provided program reporting and management presentations
• Assisted in developing operating models for the new derivative's system
• Participated in various integration initiatives which shall include analyzing requirements, documenting requirements and participating in testing
• Performed the client reporting and updating of the project on a regular basis
• Involved in deployment and production testing
• Assisted in loading the parameters for commercial lending.

Environment

Case Complete for use case writing, Rational Rose, MS Office, MS Visio, SQL server, Visual studio 2005, Bloomberg, Reuters

Confidential

Title: Business Analyst

Description

The system was developed for trading and managing the equities. It helped the user of the system portfolio managers and traders to customize the order according to the changing nature of the market. The system also provided the pre-trade and post execution compliance monitoring tools. It also provided the various alternatives to the different scenarios like what if scenarios . It was integrated and was interface to several external systems like Accounting, reporting systems.

Roles and Responsibilities

• Business requirements by interviewing users and subject matter experts SME .
• Analyzed business/system requirements using requirement scrubbing and assigned
• appropriate priorities and linkages to the requirements.
• Involved in analyzing the current business process gaps and establishing the improved standard processes
• Planned facilitated project status, requirements walkthrough meetings including the JAD sessions.
• Effectively managed the requirements and prepared functional specification and Use Case documents.
• Analyzed the existing SQL queries for the performance and wrote new SQL scripts for back end testing and data validation.
• Involved in change request management and impact analysis for the proposed changes.
• Developed and maintained the issue / defect matrix and provided the status reports to senior management
• Involved in the creation of project status reports as well as requirement traceability matrices RTM .
• Developed the user guides and operational manuals for new features, upgrades and modifications.

Environment

MS Office, SQL database, NET programming, MS Visio, Winrunner for testing.

Confidential

Title : Business Analyst

Roles and Responsibilities

• Supported all order modification/ cancellation.
• Allow customer to buy online and pick up - testing.
• Tested native shipping and handling time using calculation engine.
• Analyzed the existing SQL queries for the performance and wrote new SQL scripts for back end testing and data validation.
• Involved in change request management and impact analysis for the proposed changes.
• Worked with sales/traders, front office, settlements, Exchange Traded Derivatives OMS to roll out derivatives products

Environment

manhattan associates distributed Order management system.

Confidential

Title: Business Analyst

Description

The project involved Mortgage Financing Application. The firm's representative submits customer's application in a fronted top view and the lender can view the information of the customer. The loan-underwriting engine is used for the lender to make the decision whether to approve a loan or not. When lenders submit their loan data into the system, the system is run through regression and Statistical analysis. Decisions are based on the result of the analysis. Web based user-friendly portal. Personalized information of the customer and categorizing into Risk, High Risk and Low Risk

Roles and Responsibilities

• Interacted with Project Sponsor, developers and end-users to formulate business requirements
• Worked according to the activities/roles laid down in each phase of software development life cycle created using Rational Unified Process
• Performed Requirements Analysis, analyzed and documented the system specifications, Business requirements and detail design of the business using Requirements inventory for the requirement tracking and analysis
• Developed blueprint and tested the prototype. Designed base template, mockup of Graphical User Interface, webpage lookup field mockup and the report generation feature of the system
• Created Use Case Specifications according to the business requirements and designed using Rational Rose by creating Activity diagrams, State chart diagrams, sequence diagrams, and conducting web page mock ups in Microsoft Visio
• Successful implementation of online transaction processing applications and its associated modules like database testing and validation
• Involved in Version control and change management configuration

Environment

MS Office, SQL Database, JAVA programming, MS Visio.