SUMMARY

• 8 years of solid IT experience as Business Analyst in finance and trading with emphasis on bond securities, equity securities, fixed income financial instruments, portfolio management, trade life cycle and capital management.
• 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.
• 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 usingUMLforBusinessProcess Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams, Wireframe prototypes and documenting them usingMicrosoft Visio.
• Excellent skills in conducting JAD sessions with end - users, SMEs and development team for project meetings, walkthroughs and customer interviews.
• Expert inTest driven development & testing methodologiesfor performing UAT, System Integration testing (SIT),BusinessAcceptance Testing (BAT) and documenting test results.
• Participated with QA team in different phases of testing such asSystem testing, Functional testing, Regression testing and Integration testingfor 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:

Confidential, San Francisco, CA

Senior Business analyst

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 48 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 behind each graph.
• 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.
• 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.

Confidential, NJ

Senior Business Analyst

Responsibilities:

• Conducted JAD sessions with the stakeholders, end users and SME, to determine the critical business processes and identify key functional requirements for LoanServ 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.
• Working with Product owner On Artifacts Such as Product Backlog, Spring Backlog, Sprint Burn down Chart
• Helped the Scrum master to manage the overall performance and delivery of cross-functional
• Publicizing 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 DOORS.
• 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 database.
• 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.
• Managed change requests.

Tools & Technologies: SQL, JAD, Agile Scrum, UML, MS Office 2010, MS Visio, HPAC AND JAVA.

Confidential, MA

Senior Business Analyst

Responsibilities:

• Cooperated with project manager to define project scope, major features, risks and developed project time lines.
• 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, New York, NY

Senior Pricing and Risk Business Analyst

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, Chicago,IL

Business Portfolio Credit Risk Analyst

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, New York, NY

Junior Business Analyst

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.