Project Management

SUKHDEEP SINGH

Email: **************@*****.***; Cell: 718-***-****

PROFESSIONAL PROFILE

A Business Analyst with strong business and technical knowledge with about 8 years experience in the financial services sector.

• Creative and Aggressive person capable of forming and maintaining positive and productive team environments and with integrative thinking skills.

• Strong experience in analyzing, designing, developing, testing, and managing information technology projects in financial services industry Rates & Currencies, Investment Banking and Fixed Income Securities, Equity, OTC as well as Exchange Traded Funds (ETF), Foreign Exchange and EFT funds.

• Excellent skills in Business Analysis, OO Analysis, Data Analysis, Requirement Analysis, Business Modeling and Use Case Development using UML methodology.

• Excellent Analytical skills to understand the business process and Functionality, Requirements and to translate them to system requirement specifications. Developing functional specifications for business process refinement and automation, data modeling, system Architecture, conducting feasibility studies, scope.

• Worked with rational suite of tools to create requirement documents and also on Mercury Tools for testing.

• Use Case development and UML modeling using modeling tools like Rational Rose/MS Visio and Enterprise Architect.

• Expertise in graphical depictions of use cases including state diagrams, activity diagrams, sequence diagrams, use case diagrams, component-based diagrams including the business workflow.

• Comprehensive knowledge of the testing lifecycle within web, client server & Mainframe environment.

• Identified risks from disruption of operations and services by following contingency planning process

• Created Test Plans, Test Cases, Test Scenarios and Test Strategies for Quality Assurance and UAT.

• Hands on experience on Web based and Client/Server applications, Back End Testing, Regression Testing, Black Box testing, and Integration Testing.

• Extensively involved in using Test Director / Clear Quest to report bugs and manage Change Request.

• Performed Data Mapping of the entire module and performed complete analysis to integrate Risk Analyzer with the online processing tool.

• Expertise in defining process flows, assembling data dictionaries and transferring business knowledge to the development team.

• Develop User interfaces, requirements sessions, Conducted JAD (Joint Application Development) and RAD (Rapid Application Development) sessions.

• Hands on experience of Data manipulation, performance testing on MySQL and MS-Access using SQL scripts.

• Providing traceability across the project by analysis and review of project elements involved in traceability including testing artifacts, end-user support documentation and training materials.

• Extensive Documentation Skills for use in Standardization of Testing and Programming Procedures and Guidelines.

TECHNICAL SKILLS

Methodologies RUP, UML

Testing Tools Rational Enterprise Suite, Test Director, Win Runner, Load Runner, Quality Center

Change Management Tools Rational Clear Quest.

Business Modeling Tools Rational Rose, Microsoft Visio

Project Management Microsoft Project, Microsoft Office

Programming Languages SQL, PL\SQL, Visual Basic, Java, JavaScript, HTML, C ,C++

Databases Oracle, MS SQL Server, MS-Access, Informatica, Toad, Hummingbird.

Web Technologies Microsoft FrontPage, Lotus Notes

Operating Systems UNIX, IBM Mainframes, Windows 95/98/NT/2000, Linux

PROFESSINAL EXPERIENCE

Client: Standard and Poors, NY, NY Aug’10 – Till now

Position: Sr. Business Analyst/PM

Being part of the Regulatory Project, CESR (Commission of European Securities Regulators) shall establish a central repository (CEREP) where credit rating agencies (S&P) shall make available information on their historical performance data including the ratings transition frequency and information about credit ratings issued in the past and on their changes. To meet CESR regulations S&P has to implement a process to address CESR requirements, which is to make available raw data about credit ratings issued in the past 10 years including all EU endorsed ratings. After the first batch, this information needs to be provided on a 6 month periodic basis (semi annually). The Primary objective of this project is to comply with regulatory requirements and ensure that data collection, transformation, packaging and delivery is being done within the specified time periods. Internal verification and approval or the information is required before submitting the data. As the primary BA I was responsible for eliciting requirements using Agile methodology.

Responsibilities

• Responsible for creating and having all user stories in Version One.

• Took the lead in assigning all user stories to the scheduled sprints.

• Lead planning sessions with Data Managers, IT and Business Process Management to do the user story sizing exercise.

• Created various artifacts like BVR and defined Milestones for Opportunity, Feasibility, Risk and Realization phases of Agile.

• Scheduled training sessions with trainers to make sure that changes to impacted Applications are captured and documented for the end users.

• Interacted with the developers and QA on resolving the reported bugs and various technical issues using QC.

• Worked directly with SME’s to capture, elicit and clarify various technical and business needs.

• Worked with BPM, IT and Data Managers to come up with Business and Technical Process flows.

• Responsible for creating Business Value Realization Plans.

• Being a scrum master, was responsible for daily scrum meetings, status updates and maintaining task list in Version One (V1).

• Worked on collecting requirements for Informatica and Pega systems process flows.

Environment: Windows, Microsoft Office suite, Microsoft Visio, Paint, SnagIt, QC 9.2, VersionOne.

Client: Credit Suisse, NY, NY Feb’10 – Aug’10

Position: Sr. Business Analyst/PM

Prime Margin application used by Prime Margin Operations and Prime Margin Risk Management teams for calculation and reporting of various margin requirements for all clients of Prime Brokerage. Client facing application Prime View derives the calculation from PM and gives it to Prime Services clients upon request. My responsibility was to get requirements for a new utility called WhatIf. WhatIf will give Prime Services the ability to plug in various attributes and see the results if the market data changes in future. Example: If all Russian stock went down by 20%; how will the given clients be affected?

Responsibilities

• Conducted interviews with key business users to collect requirement and business process information.

• Created Artifacts and defined Milestones and iteration plans for Inception and Elaboration phases of SDLC.

• Derived many Functional Requirements’ (FR) based on Business Requirements (BR) also broke down FR to use case format for Development team to get effort estimates.

• Created mockups for better understanding of the FR process.

• Created various current and proposed process flow diagrams.

• Helped in creating Fixed Income Margin methodology Functional requirements.

• Created missing documents for existing Prospect Portfolio process; which helped us in finding loopholes in the current process and then created FR for proposed process which would help eliminate many drawbacks.

• Kept track of all open and closed issues/defects in Quality Center (QC).

• Worked on middle and back offices to keep application functionalities and performance based on regulatory requirements.

• Responsible for many projects and working on completing the full SDLC.

• Expertise in managing, conducting and tracking defects and change control requests in HP QC.

• Created multiple CR (Change Request) documents for changes in BR as well as FR.

• Made Traceability Matrix for BR, FR and other relevant requirement documents.

Environment: Windows, Microsoft Office suite, Microsoft Visio, Paint, SnagIt, QC 9.2.

Client: Morgan Stanley, NY, NY Jul’08 – Feb’10

Position: Sr. Business Analyst/PM/QA

As part of Global Wealth Management, MS360 is the revamped version of a legacy system called AIS. It incorporated current functionalities of AIS as well as many new applications and functionalities with a better user friendly UI. This application is integrated with many external MS applications like LENS, FA Dashboard, BMD, ClientServ and is one of the last downstream users of data. My responsibilities included addition of new functionality, ‘Practice Management’. Targeted audience was FA’s so they can check their book of business, goals and metrics.

For Managers a different application Branch Manager Dashboard (BMD) gives them the overview of each FA and how well are they performing. Having comprehensive details on National Sales, Division, Region, Complex, Parent and Branch gives BM the overview of how well their Branch is doing against other Branches.

Other responsibilities included management and addition of new functionalities to existing application like FPL, Global Currency, Defaulted Bonds, Related Securities, PLA, Margin, PI, Top Holdings, Research Center, VSP and many more.

Responsibilities

• Solely responsible for creating a MS compliant look and feel of the new apps.

• Created mockups of the new application and worked with developers on daily basis to help understand the functionality behind each screen.

• Extensively involved in UAT for new and added functionalities.

• Had weekly presentations with the business to show and give walk troughs of new added functionalities.

• Performed JAD sessions with Business users to eliminate various issues concerning the development of the online system.

• Interacted with TR and other exchanges to get required data based on Requirements.

• Monitored client expectations and conducted weekly user interviews.

• Responsible for creating SRS, Technical Specs, Use case and Test case docs for the new application.

• Worked on full End to End SDLC of many projects.

• Involved in every stage of the traditional Waterfall methodology.

• Rigorously involved in doing weekly releases of new functionalities to existing and new applications.

• Followed Contingency Planning Process to identify and eliminate risks from disruption of operations and services.

• Conducted many Brainstorming sessions and surveys to gather requirements.

• Had multiple training sessions with FA’s and business community to help understand the functionality, flow and relevance of the app.

• Created wireframes on the fly using multiple software like PowerPoint, Visio, Paint, Excel, FrontPage and Photoshop.

• Did extensive documentation to follow MS application release process flow.

• Performed smoke testing, regression testing, end to end to test the functionality of the system and acted as a liaison between the Business users and the Development team.

• Interacting with the developers on resolving the reported bugs and various technical issues.

• Testing for all projects, UAT, Smoke, UVT, Regression, and Functional testing including data validation.

• Daily interaction with the Dev team through many KT sessions to make sure that the requirements are understood clearly.

• Worked on various projects and managed their Project and Test Plans.

• Created multiple Use Case SRS’s for multiple releases and applications.

• Worked with the development team and the Business users to eliminate various issues and assumptions.

• Involved in Data Services discussion to better understand and implement in-house data requirements.

• Created documentation for multiple Projects whose end users will be FA, BM, CM and Regional Managers.

Environment: Windows, Microsoft Office suite, Microsoft Visio, Paint, FrontPage, SnagIt, QC 9.2.

Client: Merrill Lynch, NY, NY May’07 – June’08

Position: Sr. Business Analyst/QA/Developer

ETD is one of the major hubs of ML in providing data to many of the downstream users. Being part of ETD hub my responsibilities included working on various projects. The goal of FUSION (Trade processing, Error Handling system)project was to create a database from scratch so that it can be the golden source of data and the users will have the ability to view details of the data they are receiving, rather than looking at a flat file. I was responsible for creating wireframes of the entire application and document requirements after having many requirement gathering sessions with various users.

Another responsibility included doing production support for daily issues in the database. Worked on incoming feeds from various exchanges and constantly analyzed changes in feeds so the enhancements can be done accordingly. Had to do weekly or ad-hoc releases to avoid recurring issues.

Responsibilities

• Created wireframes of a new application and worked with developers on daily basis to help understand the functionality behind each screen.

• Have daily meetings with users to get detailed requirements and feedback on created mockups.

• Created test cases to perform smoke testing on the new application. Documented various sections of the application including Entitlements and Error processing.

• Worked with users to get new requirements so they can get appropriate access to the database.

• Created Views and tables in the database using SQL to meet end user needs.

• Worked on Informatica Workflow manager, Designer to monitor, restart, put jobs on ice, suspend, delete and update jobs.

• Worked with Risk to derive value of credit derivatives based on underlying assets.

• Helped in managing CDS’s as part of portfolio management.

• Worked on creating new JIL’s for many Autosys jobs using UNIX.

• Worked as First/Second level support for production issues; extensively involved in daily production support issues.

• Had numerous sessions with the end users to provide data in a transparent manner from the Hub.

• Had JAD sessions with users and provided numerous SRS’s and technical specifications.

• Involved in full SDLC of projects I was responsible for.

• Provided rough estimate reports as to various enhancements to the Hub which came as user requirements.

• Contributed in creating a shared knowledge base called Confluence. Added documents created by myself along with current status.

• As part of troubleshooting; helped reconcile index data. Worked on JIRA to maintain; track and update issues.

• Experience in working with a Fund Manager to process and redeem ETF’s.

• Created documents for recurring and known issues so users and developers can benefit from them.

• Reviewed, prioritized, classified , analyzed problematic solutions and created excel documents for weekly review meetings

• Worked on Bloomberg terminal to check for information so it can be reconciled correctly with existing data as part of troubleshooting.

• Worked on accessing application logs to identify if the automated jobs succeeded and ran ontime.

• Worked in UNIX to access databases and troubleshooting production support issues.

• Worked partially on shell scripting; which involved in updating various ‘ksh’ and ‘batch’ files.

• Used Informatica to troubleshoot failed jobs; monitor workflows and worked on Power Center.

Environment: Windows, Microsoft Office suite, Microsoft Visio, Informatica, SQL, UNIX.

Client: Deutsche Bank, NY, NY Oct’06 – May’07

Position: Sr. Business Analyst/QA

One of the many services Deutsche Bank’s (DB) Prime Brokerage (PB) business provides its hedge fund clients is securities financing. The calculation of the related interest charges and borrowing fees is currently handled by two distinct applications – Interest Rate Calculator (IRC), which supports US PB clients, and Eclipse, which supports International PB clients.

The current approach of two calculators suffers from several disadvantages, which include the inability to meet client requirements for consolidated balances across geographies and currencies, the higher costs associated with supporting multiple applications based on differing technologies, as well as other functional deficiencies arising from changes in the underlying PB businesses. New Dashboard GFC (Global Financial Calculator) was designed to over come the deficiencies, disadvantages of legacy systems.

Responsibilities

• Wrote clear, concise detailed functional specification documents (FRD) and make the functionality of each section of the application as clear and simple for the development and testing teams.

• Worked with another BA and an IA developer in gathering the precise requirements and developed many wireframes.

• Understood the requirements on calculation logic for spreads.

• Provided first level of support for the prototypes created for users and also had numerous KT sessions with downstream users.

• Involved in giving multiple demos to users across multiple DB locations.

• Extensively involved in writing test cases and test plans and reporting bugs using Excel.

• Took ownership of Requirement Specification documents and FSD to constantly update and maintain them.

• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.

• Interacted with the stakeholders to get a better understanding of client business processes and gather business requirements.

• Performed QA/QT before the code went into production environment.

• Verified the functional aspect as per the Business Process and validated the interfaces with the other systems and data conversion from the legacy system.

• Derived Functional Requirement Specifications (FRS) based on User Requirement Specification URS. Understand and articulate business requirements from user interviews and then convert requirements into technical specifications.

• Contributed by adding signed documents to the shared drive so other departments can access them if/when required.

• Did data and calculation testing before the actual code was written and gave those calculations to the developers.

• Worked in front, back and middle offices.

• Responsible for creating test cases with samples on how to calculate Rebates, Interest Fees and Pricing for each Client and their corresponding accounts.

• Created scenarios on how to handle US and International clients in their corresponding currencies.

• Followed a Tiered approach for the calculation of Interest and Rebate/Fee Pricing.

• Performed Smoke (Sanity) Testing to test the basic functionality of the application and participated in complete testing life cycle.

Environment: Windows, Microsoft Office suite, Microsoft Visio, UML.

Client: CitiGroup, NY, NY Jun’06 – Oct’06

Position: Sr. Business Analyst

CitiTrak is a Circuit Management System (CMS) that is used by the provisioning team to manage circuit order processing, requisition approval, circuit asset maintenance (including moving, adding, changing circuit features and circuit disconnections; also known as MACD). Within Citigroup, the primary users of the system are from the Provision department and belong to the Network Economics group. CitiTrak has two modules: Order Management and Asset Management System. Currently CitiTrak does not integrate with any external systems online. However, there is a lot of information that comes in and out of CitiTrak. The flow of information is currently achieved manually.

The purpose of the FRD document was to enhance the productivity of CitiTrak by automating many processes. Many fields need to be added to CitiTrak system to get more detailed Reports. The purpose of getting more details is to better track all services, circuits, businesses associated with them, charge accounts, list of vendors, vendor hierarchy and many more enhancements including giving appropriate rights and access to appropriate businesses and departments. Eliminating limitations in CitiTrak and automating many manual procedures will reduce expenses.

Responsibilities

• Wrote clear, concise detailed functional requirements document (FRD) and user documentation in accordance to guidelines and standards of a level where developers can interpret, design and develop the application with minimum guidance.

• Interacted with the stakeholders to get a better understanding of client business processes and gather business requirements.

• Conducted user interviews, gathered requirements, and analyzed the requirements.

• Performed Gap Analysis of the As-Is and Should-Be process within the organization.

• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML, Visio.

• Worked on the UAT, Production environments to gain knowledge of the current application.

• Responsible for creating Use Cases for existing and new functionalities for CitiTrak.

• Provided initial level of support to users and tech support department.

• Wrote clear, concise detailed system requirements specification (SRS) documents and user documentation in accordance to guidelines and standards of a level where developers can interpret, design and develop the application with minimum guidance.

• Performed Data Mapping of the entire module and performed complete analysis to integrate Risk Analyzer with the online processing tool.

• Extensive participation in Error Review Meetings.

Environment: Windows, Oracle, SQL, Microsoft Office suite, Microsoft Visio, UML.

Client: JPMC, NY, NY Dec'05 – Jun’06

Position: Business Analyst

The scope of the project was to automate the Disclaimer Documentation. Currently the process was manual; all documents had to be sent manually to the clients to be accepted. This process needed to be automated so that the system will send the disclaimer document to the clients. If needed make new accounts, assign those accounts to different Documents, Document Groups and Business groups.

Responsibilities

• Responsible for creating Functional Specification Documents.

• Wrote clear, concise detailed functional requirements specification (FRS) documents and user documentation in accordance to guidelines and standards of a level where developers can interpret, design and develop the application with minimum guidance.

• Interacted with the stakeholders to get a better understanding of client business processes and gather business requirements.

• Conducted user interviews, gathered requirements, and analyzed the requirements using Requisite Pro (RUP).

• Conducted JAD sessions for communicating with Stakeholders and Project directors.

• Worked as a CRM for providing weekly progress reports.

• Created Entity Relation diagrams to represent the relationships existing between design the internal schema of a database, depicting the data tables, the data columns of those tables, and the relationships between the tables.

• Created business process workflow diagrams

• Linked business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement

• Expertise in Performance Management and implementing its benefits.

• Identified and created all necessary Business Use Cases from requirements, created UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, and Class Diagrams using Microsoft Visio.

• Understood the business logic, User Requirements and test-objectives to develop test plans, test cases, and test case execution using Test Director.

• Communicated extensively with the clients and with different levels of management to identify requirements, use cases and to develop functional specifications.

• Helped create design documents and prototypes for the outlook of the application user interface.

• Had numerous JAD sessions and RAD sessions with the Business users and the design team for the development of the project.

• Had sessions with users to make them understand the technical aspects of the application.

• Helped create various screen shots and wireframes for developers to better understand the functionality of the system.

Environment: Windows, Oracle, SQL, Microsoft Office suite, Rational Requisite Pro, Microsoft Visio, Test director, Win Runner, Load runner, UML

Client: State Street, Boston, MA Mar’05 -Nov’05

Position: Business Analyst

The scope of the project was to upgrade the existing accounting system that is PMIS to RKS. RKS is the core accounting system which would be used by SSgA and which is to replace the PMIS accounting application. RKS processes accounting information using data from multiple applications. Various other applications in SSgA would rely heavily on the data available in RKS.ROR – User Extracts application would use accounting information from RKS and provide a mechanism for operations users to pull data without impacting the performance or volume demands on the RKS application.

Environment: Windows, Oracle, SQL, Microsoft Office suite, Rational Requisite Pro, Rational Rose, Microsoft Visio, Clear Quest, Test director, QTP, Load runner, Rational Unified Process (RUP), UML.

Client: RBC Mortgage Company L.L.C., Raleigh, NC Oct’04 -Feb’05

Position: Business Analyst

The project I worked on involved modules for Accepting Monthly Payments, Monitoring Delinquencies, Managing Escrow Accounts, Managing Foreclosures, Investor Accounting, Lien Releases and Customer Notifications.

Environment: Windows, Oracle, SQL, Microsoft Office suite, Rational Requisite Pro, Rational Rose, Microsoft Visio, Clear Quest, Test director, QTP, Load runner, Rational Unified Process (RUP), UML.

Client: Fidelity Investments, Boston, MA Aug’03-Sep’04

Position: Business Analyst

The scope of the project was to develop an application using HTML and Java which enables potential customers to perform searches for the Stocks Rates, Fixed Income and Derivatives and how the market is doing currently. Giving complete news and stories about the recent events related to Investment (such as Stock, Bond and Market).It provided clear and complete picture of the clients assets in position, full brokerage capabilities, access to IPO’s and research data. One could also browse Fidelity's no-load mutual funds including international, index, sector, and exchange-traded funds. Also find the right fund for them.

Environment: Windows, Oracle, SQL, Microsoft Office suite, Microsoft Visio, Test director, Win runner, Rational Unified Process (RUP), Requisite Pro, Clear Case, Clear Quest, UML

Client: First American Bank, Dallas TX Jun’ 02 - Jul’ 03

Position: Business Analyst

The purpose of this project was to integrate the vendors from the Security Bank and First American Bank side. The project aimed at migrating all Security Bank programs into existing First American Bank servicing platform and all rewards fulfillment and redemption activity would be integrated into the existing First American Bank Card Services rewards platform. It offers a variety of banking products and financial solutions like personal banking, small business, retail banking, home financing and equity loans, asset management, wealth management, corporate and investment banking and credit card services to its customers.

Environment: Windows, Oracle, SQL, Microsoft Office suite, Requisite Pro, Clear Quest, Microsoft Visio, Test Director, Win Runner, Rational Unified Process (RUP), UML.

Education:

MS – Computer and Electrical Engineering (New York Institute of Technology)

BS – Computer Science (St John’s University)

BS – Computer Science (A.S.S.M. College India)

Contact this candidate