Professional Summary:

• 8 years of solid IT experience as Business Analyst in finance and trading with emphasis on bond securities, equity securities, fixed income, derivatives, foreign exchanges and other financial instruments.
• Proficient in lifecycle management of all events throughout the life of trade from issuance until expiry, including corporate action adjustments, early redemptions, option exercises, credit event processing and credit default swaps quarterly roll payments.
• Well versed with global derivatives settlements process across OTC credit, equity and fixed income derivatives, structured products, exotic swaps options and exchanges traded futures options.
• Broad experience in investment banking, capital markets and technology, specialized professional experience in global reference data, securities lending, prime brokerage and fund accounting, portfolio management.
• Wide knowledge of risk management involving credit risk, market risk, system risk and operational risk.
• Strong understanding of banking requirements and regulatory compliances, AML, Basel II, Dodd Frank Act, Bank Secrecy Act, Customer Identification Program KYC .
• Extensive knowledge multiple SDLC including Agile Scrum, Waterfall, and Rational Unified Process RUP Methodologies with expertise working with tools such as Rational Rose, Requisite Pro, Microsoft Visio, Microsoft Project, Microsoft Office Suite, Erwin Data Modeler
• Proficient in preparing BRD, FRD and in using UML for Business Process Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams, Wireframe prototypes and documenting them using Microsoft Visio.
• Great experience in business process management using different technical tools.
• Excellent skills in conducting JAD sessions with end-users, SMEs and development team for project meetings, walkthroughs and customer interviews.
• Expert in Test driven development testing methodologies for performing UAT, System Integration testing SIT , Business Acceptance Testing BAT and documenting test results.
• Participated with QA team in different phases of testing such as System testing, Functional testing, Regression testing and Integration testing for Quality Analysis.
• Deep understanding of ETL Process, MDM, RDBMS, Data warehousing, Business Intelligence technologies and data mining with advanced experience in database design, ER modeling for OLTP and dimensional modeling for OLAP.
• Good working knowledge in SQL, MS Access, Excel and Oracle and excellent in writing queries and pseudo codes.
• Strong Interpersonal skills, organizational skills, highly self-motivation to work at challenging environments.

Technical Skills:

Access, Oracle, MS Office with emphasis on Excel Pivot Tables, Data Mgmt Tools, VLOOKUP tools , XML, and Microsoft Visio 2005/2008 Windows, Microsoft SQL Server 2000/2005/2008/2012 , Oracle 8i, 9i 10g , UML, HTML, Quality Center, Adobe Professional, Rational Requisite Pro, Rational Rose, Rational ClearCase, Rational ClearQuest, Java, HTML, MS Project, Excalibur, J2EE, DB2, eReader, MS SharePoint, J2EE Technology, RUP, UML, Microsoft SQL Server 2012, Rally, JAD, Agile Scrum, Erwin Data Modeler, and Mercury Quality Center. SAS STATA, SPSS

Professional Experience

Role: Senior Business analyst

Project Description:

The goal of the project was to make enhancement of an online electronic trading platform and affirmation platform to its customers, brokers and institutional investors and to implement the graphing feature to the existing trading system for the premium clients. This new feature will help to summarize the investor's investment and help them improve their investment strategy. The graphing feature includes portfolio based and investment based graphs. It almost covered capital markets including fixed income, stocks, futures, options and foreign exchanges. With the new feature, the investors can see asset, sector allocations, rate of return, daily volume, technical analysis and other analysis.

Responsibilities:

Assessed the scope and impact of business needs through analysis and completion of all enhancement specifications.

• Conducted interviews with Subject Matter Experts SMEs in understanding different usage of all kinds of graphs. like pie chart of investment goal, sector, currency stacked value of asset allocation, investment, tax status
• Conducted interviews with investment analyst and investment advisor to get the function calculation return calculation, margin calculation, P L calculation behind each graph.
• Supported in-house clearing of OTC derivatives across multiple currencies, clearing houses and affirmation platforms as well as the testing of electronic trading platforms, trade lifecycle changes, affirmation platform releases and graphing feature releases.
• Maintained and updated OMS to compliance related SEC trading act.
• Facilitated Daily scrum meetings, sprint planning, sprint review, and sprint retrospective meetings.
• Documented business requirements and conducted BRD analysis. And applied UML methodology in MS Visio to elaborated functional requirements like, use case analysis, use case diagrams, activity diagrams, sequence diagrams to define work flow of the project to the IT developers.
• Worked with Product owner scrum master do develop artifacts such as Product Backlog, Sprint Backlog, Sprint Burn down Chart.
• Conducted JAD sessions with the stakeholders, end users and SME, to determine the critical business processes and identify key functional requirements for user's terminal adhering to the order management systems.
• Created a product roadmap for the various stages and releases throughout the project lifecycle. Managed the overall performance, publicized the team's progress and successes to make sure they are highly visible to stakeholders.
• Helped the project management doing business process management and conducted timely requirement review sessions with the Stakeholders and business and end users to ensure the product verification.
• Involved in MDM Process including data modeling, ETL process and prepared data mapping documents based on graph requirements.
• Wrote SQL queries to extract related data from transaction record database for OLAP purposes.

Tools Technologies:

Rally, MS Office, MS Project, MS Visio, MS Outlook, Adobe Professional, Quality center, MS Access, Microsoft SQL Server 2012, HTML.

Role: Senior Business Analyst

Confidential

Project Description:

The project's goal was to improve Loan Origination and Loan Servicing system to help the related department to improve Default management. The user can get the default payment report at any time they want to check the loan status under management. This will enable the users to come up with alternative payment methods for those default payments and avoid loans from going into an inactive status. This system can track all loan and mortgages data information with the banking system. Besides this additional features must be applied such as:1 Record and maintain the full history of each loan change and repayment structure at loans and sub loans level. 2 Maintain audit trail for loan modification approvals and loan changes. 3 Ability to change due date, or defer a payment to the end of the loan to help troubled borrowers. The project followed Agile methodology

Responsibilities:

• Conducted JAD sessions with the stakeholders, end users and SME, to determine the critical business processes and identify key functional requirements for the new system adhering to the Mortgage Servicing Industry practices and FDIC guidelines.
• Identified the key Stakeholders and the business users of the application.
• Facilitating Daily scrum meetings, sprint planning, sprint review, and sprint retrospective.
• Applied Basel III and get the calculation function related with capital requirements, leverage ratio and liquidity requirements.
• Working with Product owner On Artifacts Such as Product Backlog, Sprint Backlog, Sprint Burn down Chart and did business process management.
• Publicized the team's progress and successes to make sure they are highly visible to product owner / stakeholders.
• Created a product roadmap for the various stages and releases throughout the project lifecycle.
• Elicited requirements through brainstorming sessions and identified primary actors their roles and functions.
• Created various UML models like Use Case diagrams, Activity Diagrams and process flow Diagrams in MS Visio.
• Created and managed all the requirement artifacts in Quality Center.
• Conducted timely requirement review sessions with the Stakeholders and business and end users to ensure the product verification.
• Involved in data modeling to design tables for reporting purposes.
• Wrote SQL queries to extract reference data from various databases.
• Actively conducted and participated in weekly meetings to analyze the progress and maintain status reports.
• Created test cases reviewed test cases and maintained the Requirement Traceability Matrix RTM .
• Performed Functional and UAT testing before the system went live.

Tools Technologies:

SQL, JAD, Agile Scrum, UML, MS Office 2010, MS Visio, Quality Center.

Confidential

Role: Senior Business Analyst

The goal of the project was to improve an equity trading System and add the new reporting features to the existing system. It provides the investors a tool to keep track of subscriptions and redemptions, capital commitments, calls and distributions across portfolios and investments. Build and share portfolio rebalancing and reallocation scenarios with the optimal Portfolio Planning Module. The user can get various different report on specific time based on different investment tracking purposes. The project followed RUP methodology.

Responsibilities:

• Cooperated with project manager to define project scope, major features, risks, developed project time lines and did business process management.
• Conducted User Acceptance Testing UAT of new rates clearing eligible products
• Did client and sales support, and overall support of trade flow to vendor and in-house systems.
• Analyzed and researched on the paper documents about investing reports requirements. Then documented them as BRD to explain each report's function.
• Examined Order Management System OMS to ensure compliances with upgrade requirements, and generated documents for the workflow of exiting system and desired system that involve Cash Analysis, Portfolio Analysis, Order Initiation, Order Execution, Trade Clearing, and Booking, and performed gap analysis.
• Derived functional specifications using UML models including user case diagram, activity diagram, and sequence diagram, and collaborated with software architects and developers to ensure that the applications conform to the requirements and helped to understand the business flow and account relationships in accordance to the specific databases and tables involved in development
• Prepared data mapping documents to support ETL process and involved in building data models to construct staging warehouse for reporting purposes.
• Maintained Traceability Matrix for the current business processes and proposed changes.
• Assisted Project Manager in managing project progress, estimating delivery schedule and supporting implementation and application using MS Project.
• Developed test plans with QA team and helped to develop test scenarios according to different report needs for system testing and performance testing.
• Reviewed test cases, maintained the Requirement Traceability Matrix RTM to ensure appropriate documentation is in place.
• Conducted UAT, documented and reported user feedbacks to management team, and Created user manuals included the explanation of different reports and how to execute.

Tools Technologies:

RUP, UML, Rational Requisite Pro, Rational Rose, Rational ClearCase, Rational ClearQuest, Windows 7, Java, SQL, HTML, MS Excel, MS Word, MS Project, Excalibur.

Confidential

Role: Senior Pricing and Risk Business Analyst

The goal of the project was to develop a software to perform real-time pricing of Natural Gas and Oil, Utilities, futures, derivatives, and options and also to implement a Reporting project with Extensive suite of standard reports with output options including Crystal, Word, PDF, CSV and HTML, as well as email and mobile device reporting capabilities and ON BOARDING new product / new market. Besides, this other goal of the project was to minimize market risks, which would reduce the costs that incurred on investors and company. Therefore this software enabled consumers to compare their investments with the following industry and company risks: liquidity risks, interest rate risks, operation risks, and default risks. Since the pricing of forecasting included global markets the software enabled for investors currency rate risk and commodity risk options for investors. The project followed Agile methodology.

Responsibilities:

• Performed price forecasts using historical data and econometrics to estimate price movements for commodities on the CME CBOT, NYMEX , and ICE NYBOT exchanges. Day ahead pricing models
• Audited and reviewed ERCOT Energy Reliability Council of Texas portfolio to maintain proper trade valuation and risk management.
• Analyzed different financial risk sources and their potential impacts on forecasted pricing of Natural gas and Oil futures, derivatives, and options.
• Built the specifications for the reports required for the stakeholders with various forms of output such as HTML, Crystal, Word, PDF, CSV and HTML, as well as email and mobile device reporting.
• Facilitated meetings, JAD sessions with business users, SMEs and development teams for requirements gathering and analysis.
• Documented business requirements, functional requirements, use cases and creating roadmaps and business vision documents including business process models.
• Applied UML to create activity and sequence diagrams to explain process flows and functional specifications.
• Coordinating due diligence, setups, configurations, and ongoing maintenance of client and account reference data
• Acquisition on boarding Lead the Operations on boarding of several large derivative and physical portfolios across different commodity products. Included pre-execution due diligence and post execution integration
• Created reference data: master confirmations, counterparties, client funds and credit terms. Managed reference data projects covering test execution, data analysis for new client integration.
• Developed User Acceptance Testing plan, created UAT Test Cases and carried out UAT successfully.
• Assisted User to use the application by creating User Guide, giving user training, presenting PowerPoint decks and developing Help Desk Scripts and FAQ files.

Tools Technologies:

Windows, MS Office MS Word, MS Excel, Adobe Illustrator, MS PowerPoint, MS Visio , J2EE, DB2, eReader, MS SharePoint, J2EE Technology, Oracle, UML, Microsoft SQL Server 2012, Rally.

Confidential

Role: Business Portfolio Credit Risk Analyst

Project Description:

The goal of the project was to enhance Portfolio Credit Risk Management System for risk adjusted performance, concentration risk, market risk, meeting regulatory requirements, and enhancing revenues. This system would allow the client to continuously evaluate transactions, portfolios, balance, various trade offs, regulatory capital requirements, and risk adjusted returns compared to market.

Responsibilities:

• Gathered, analyzed and documented the user stories for the need for the need for new module or reusability of an existing module by performing GAP analysis.
• Facilitated the weekly meetings with the review teams to continuously improve the QA process for the application development.
• Made presentations for conduction walkthroughs with stakeholders.
• Conducted JAD Joint Application Development for the requirement gathering and used Rational Requisite Pro to analyze and prioritized the requirement.
• Created Business Process Model and prepared BRD,FRD using use cases, UML diagrams.
• Constantly partnered with project leads to ensure the team is producing solutions that meet established standards, procedures, practices, address issues, risks, and mitigation plans.
• Worked with requirements analysts and subject matter experts to identify, understand, and document business needs for the data flow to create market risk and credit risk modules.
• Performed data analytics with emphasis on credit scoring, credit risk, behavioral models, loan loss, and general-purpose risk/profitable models.
• Proactively identified and removed blockers, facilitated frequent retrospectives, shared metrics to identify, and implemented improvements.

Tools Technologies:

Microsoft Office Suites Word, Power Point, Access, Excel, Rational Requisite Pro, Outlook, Visio , Windows, Microsoft SQL Server 2000 2005 , Oracle 8i,9i 10g , UML, HTML, and Quality Center.

Confidential

Role: Junior Business Analyst

Project Description:

The objective of the project was to perform database inquiries and program forecasting analysis application to develop program reporting measure program performance meet client data and reporting requests provide pipeline forecasts and projections and support data requests and reporting needs of other team members as needed. The project followed Waterfall methodology.

Responsibilities:

• Compiled and analyzed program and project level data such as energy savings, incentives and application status.
• Managed and performed quality control on program operation databases
• Developed complex databases and spreadsheets with accompanying detailed data dictionaries for internal, client, and regulatory submissions
• Developed monthly reports, regulatory reports, pipeline forecasts and invoices
• Identified and created specifications for database improvements
• Developed reports, processes, graphs, and dashboards to track key program performance metrics
• Developed, document, and automate energy efficiency program processes
• Performed critical analysis of program data to identify operational and data anomalies and exceptions
• Quickly translated data and accompanying analysis into internal, client, and management presentations
• Analyzed market research inclusive of market analysis, market assessment, market risk and market segmentation

Tools Technologies:

Access, Oracle, MS Office with emphasis on Excel Pivot Tables, Data Mgmt Tools, VLOOKUP tools , SQL Server 2005, XML, and Microsoft Visio 2005.