SUMMARY

• Over 7+ years of work experience in Business Analysis and Data Analysis in the Financial industry. Specialized in Implementation of Financial Tools, Data Quality, Project Financials, Budgets, Forecasts, Costs, Benefits, Requirements management, user acceptance testing, Change Management, Reporting, and SQL.
• Experienced within Individual Retirement Accounts IRA, Employer - Sponsored Retirement Plans ESR, Fixed Income Investments, Capital Market, and Wealth Management domains.
• Experience as a Business Analyst, Systems Analyst with a strong understanding of Business Requirements Gathering, Process Flow, Business Process Modeling, and Business Analysis.
• Worked on Defined Contribution plans, 401(k), 403(b) AND 457(b), Roth IRA with strong knowledge of retirement plans and the business rules associated.
• Excellent understanding of Financial Instruments (Stocks, Corporate and Government Bonds, CDs, MBS, Derivatives) and regulatory and compliance reporting.
• Worked on the complete Software Development Life Cycle (SDLC).
• Hands-on experience working on various Informatica Suites and Informatica Power Centre Tool
• Excellent Knowledge in RDBMS Concepts and Data Modeling using Erwin 4.0, Star and Snowflake Schemas.
• Excellent understanding of Data services, Data ETL using SQL query tools and applications.
• Served as a Code and Data Migrations Lead for multiple Sandbox & Production Environments.
• Experience in Data Lineage using Excel and Collabra.
• Proficient in using Agile Scrum methodologies, performed roles of Product Owner, Scrum Master following sprint/standup sessions and used JIRA & Version One extensively to write Epics, User stories, analyzed the Iteration Burn Down charts, and reviewed defects.
• Facilitated weekly and monthly business review meetings to keep SMEs, Stakeholders, product managers, executive staff, and team members apprised of goals, project status, resolving issues and conflicts, and preparing product demonstrations.
• Good comfort level with Capital Markets, Money markets, Trading Systems, Derivatives (Strong in Options), Equities, Fixed Income, US government Treasury Securities (T-Bills, T-Bonds, and T-Notes), Municipal Bonds, Stocks Trading Cycle, Margin Requirement, Mark to Market, Hedge Funds.
• Expert in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using SQL Server 2000/2005/2008.
• Excellent experi in data Extraction, Transformation and,ence Loading ETL using various tools such as SQL Server Integration Services SSIS, DTS, Bulk Insert, and Bulk Copy Program utility, SQL Replication and Log Shipping.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data warehouse/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence
• Extensive experiences in Investment Banking projects specialized in Securities Trading (stock trading, fixed income trading, and derivatives trading), wealth management, and risk management.
• Experience of working as a part of Scrum team and contributing to backlogs and Sprint planning sessions following Agile SDLC methodology. Good understanding of entire phases of Software Development Life Cycle SDLC .
• Experience in Competitive Analysis, Data Analysis, Gap Analysis, and understanding of ROI Analysis, P&L Analysis, SWOT Analysis, Impact Analysis, and Cost-Benefit Analysis.u

TECHNICAL SKILLS

Languages / GUI: C/C++, SQL

Databases: Oracle10g, PostgreSQL, DB2

Modeling Tools & Languages: Rational Rose, MS Visio, UML

Project Management Tools: MS Project

Requirement & Traceability Matrix: Rational Requisite pro, MS Excel

Change Management Tools: Rational Clear Quest, MS Office, Snag-It

Testing Tools: Links can, QTP, Win runner, LoadRunner

Web Technologies: HTML, CSS, XML, LAMP, AJAX

Operating Systems: MS-DOS, LINUX RH 9.x

Banking Protocols: FIX, SWIFT

Financial Terminals: Bloomberg, Reuters, Capital IQ

PROFESSIONAL EXPERIENCE

Confidential - Windsor, CT

Sr Business Analyst

Responsibilities:

• Support the Business by working with the development teams with responsibility for eliciting, understanding and documenting business needs to determine and recommend the most optimal solution to conduct software development.
• Assists in formulating creative, technical contributions to defining user business and functional requirements for enhancements and projects and implementing IT business solutions.
• Acts as an adept analytical resource focusing on critical business priorities.
• Assists in establishing plans for defining, delivering, enabling and supporting information technology components into the organization architecture.
• Requirements gathering and business design specification for the development of various new and enhancements to the existing business processes
• Participating in Joint Application Development (JAD) sessions with Subject Matter Experts (SME) to extract & understand business objectives.
• Ensuring conformance of product customization to the business specification
• Participate in technical reviews and inspections to verify 'intent of change' is carried through phase of project.
• Facilitating the scrum meetings and managing the processes.
• Analysis of System Problem Reports and providing post-fix testing signoffs.
• Analysis of Problem Requests raised by the Client and Providing Solutions to Problem Requests
• Created custom objects, custom fields, page layouts, search layouts to organize fields, custom labels, related lists, and other components on record pages.
• Designed and deployed Custom tabs, validation rules, Approval Processes and Auto-Response Rules for automating business logic.
• Implement pick lists, dependent pick lists, lookups, master detail relationships, validation and formula fields to the custom objects

Confidential - Stamford, CT

Sr. Business Systems Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Gathered the requirements and analyzed the potential modifications required for the retirement of applications to a vendor-based front end application.
• Responsible for documenting Market Risk, Credit Risk, Liquidity Risk critical data elements, data lineage, dashboard procedures, Visio flowcharts for Market, Credit, Securities lending, and Counterpart Credit risk, and control points for compliance needs.
• Creating input/output data requirements as well as authoring business rules of Defined Contribution (401-K / 403-B/457 B)
• Identifying and establishing retirement plan account identifiers for the Customer Profile
• Analyze Risks, documented Risk Logs, and created Requirement Traceability Matrix (RTM) as a roadmap for the 'TO BE' system
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for the technical team to develop prototype and overall system.
• Creating and Managing new tickets for Vendors in the JIRA system (Screenshots, Mock-ups)
• Gathered, analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders
• Designed a module to roll over member refunds to qualified retirement plans such as 401(k), 403(b), IRA, Roth IRA, etc.
• Excellent understanding of Trade Life Cycle, Front Office, Middle Office, and Back Office responsibilities, including risk assessment (Market Risk, Credit Risk), AML procedures and regulations
• Configured Bloomberg data License security and pricing information.
• Create and update BRD and Data Mapping documents for new reports, data sources, and data migrations to Preparation of Migration strategy and architecture document.
• As Team Member for the Financial Testing team, compiled metrics and statistics for management reports by Service Level Agreements.
• Used SunGard Omni Trade and Reconciliation Financial system to trade, reconcile, and report Mutual Fund movement within the firm.
• Coordinated team of Developers and Business Analysts responsible for testing specific proprietary SunGard Omni applications on Web, Client Server, and Mainframe environments.
• Prepared ETL (Extract, Transform and Load) standards, Naming conventions, and wrote ETL flow documentation for Stage, ODS, and Mart.
• Configured Pentaho BI Server for report deployment by creating database connections in Pentaho enterprise console for central usage by the reports deployed in the repository.
• Well versed in all the phases of Software Development Life Cycle (SDLC) using Agile/Scrum and Waterfall methodologies.
• Working with cross-function team including Back Office operations as well as client-facing financial advisors.
• Managed product backlog with the help of product owner by usingJIRAalso generated the reports to analyze the performance of the object.
• Assist with work request enhancement level-one estimates, script/program code modifications, and testing to support the enhancements. Design, code, test and assist with running one-shot programs that handle special non-batch updates to the Omni database online system.
• Conduct Brainstorming and JAD Session to gather Business Requirements from Market Risk Group, Risk Reporting Team, and other stakeholders (PMEs, Compliance, etc)
• Collabra Workflow development and configuration based on MS Data Governance Approach & Requirements and Worked with Finance, Risk, and Investment Accounting teams to create Data Governance glossary, Data Governance framework, and Process flow diagrams.
• Administered all Agile/Scrum process and assisted junior staff on the same.
• Managed software artifacts for the suite of investment products such as Online Banking and Brokerage, BIDS, Insurance etc.
• Analyzed the existing reports of the reporting system in the database. Checked the consistency of the data after ETL process using SQL queries.
• Securities settlement experience including DTC, Fedwire and Euroclear markets. Understanding of trade/journal flow (EQS), Bloomberg.
• Developed detail class diagrams and sequence diagrams using Rational Rose XDE implementing J2EE patterns in UML design.
• Performed Dependency Analysis (by identifying any breaks in lineage), root cause analysis and remediation as part of the data lineage effort.
• Worked on Risk analysis, Securities (Stocks and corporate bonds) and their valuation, Portfolio Management (risks and returns) and analysis, Asset Allocations Bond pricing, Financial Derivatives, Cash flows, financing structure, Capital Management, Stock Valuation, Amortization, etc.
• Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle.
• Generated third party contracts, statements of work etc.
• Helped Project Manager perform Impact Analysis andCostBenefitAnalysis during the planning phase.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Confidential - St. Petersburg, FL

Business Data Analyst

Responsibilities:

• Experience from Front to back office, worked with fund managers, financial advisors and technical team members.
• Interacted with Fixed Income business heads to finalize the Business Requirements for the application.
• Documented Requirements for Activity management, Fixed Income, Asset Management Services, Client portfolio management, Order management system, Performance, Equities, Reconciliation, Transaction capture/Execution and reporting requirements for the user interface.
• Resolved data and processing issues in supporting applications i.e.,Bloomberg, Summit and Confidential Access. Escalated complex issues to IT team.
• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance. Introduced Agile and RUP methodologies to reflect liquid nature of front- office improving time-to-market.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Pentaho PDI.
• Business Analyst in Retirement Services Reporting - IT within the Investment/Asset Management division of the firm.
• Currently, Business Analyst for implementation of Due Diligence Advisor Reporting Program.
• Previously, Business Analyst for Retirement Services Reporting (products include Defined Contribution Plans, Defined Benefit Plans, Variable Annuity Plans, Fund Factsheets, Investment Monitors, Analytical Grids, Plan Performance Memorandums) servicing the Retirement Services Client Sales Team.
• Worked extensively on complex financial reports providing detailed Performance data and Statistical analysis of Retail Funds, Institutional Funds, Manager of Manager Funds (Separate Account and Alliance), Variable Annuity Funds and Money Market Funds across a wide array of asset types like Fixed Income, Equity, Balanced and asset classes like Large Cap, Mid Cap, International, Health, Natural Resources, Balanced Allocation, High Yield Bond, Intermediate Govt., Money Market and Stable Value.
• Worked extensively on Raymond James Retirement's internet Advisor Reporting Tool (iART), an -winning web-based tool that services Raymond James Retirement\'s Manager of Managers investment platform.
• Acquired extensive market data knowledge working on Bloomberg real-time and data product suite (BPOD, B-Pipe, Platform, Server API, Event Trading Feed, and Bloomberg Data License).
• Acquired extensive marketdataknowledge working on Bloomberg real-time and dataproduct suite (BPOD, B-Pipe, Platform, Server API, Event Trading Feed, and BloombergDataLicense). Knowledgeable with 3rd party marketdatafeeds and technology platform offerings.
• Acted as a Product Owner as part of an Agile/Scrum team. As a product owner, I coordinated with development team personnel to ensure requirements are understood.
• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance. Introduced Agile and RUP methodologies to reflect liquid nature of front- office improving time-to-market.
• Designed and developed all Use Cases and UML models using Rational and Visio
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Strategically improved a CRM system allowing for an efficient organizational tool to track investment activity and client interaction
• Automated pricing feeds for numerous vendors, including Vanguard, Bloomberg (BVAL,DataLicense) and JPM.
• Develop and maintain Portal leveraging WebLogic Portal Design, C, C++, Java and JavaScript.
• Prepared detailed design documents to translate business process effectively for developers and product managers using MS Visio.
• Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.

Confidential - San Francisco, CA

Business Analyst

Responsibilities:

• Conducted one to one interviews with Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
• Wrote specification to implement application fee for trade-processing lifecycles from pre-trade analysis to post-trade risk management, settlement and regulatory compliance with SunGard's Capital Markets and Investment Banking solution
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing, Websphere and Cognos.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Created a test plan and a test suite to validate the data extraction, data transformation and data load and used SQL and Microsoft Excel.
• Prepared BRD'S for - Equity options, Equity index, Liquidity Ratio Analysis, Liquidity Gap Analysis.
• Designed and developed project document templates based on SDLC methodology
• Expert knowledge of capital markets, Asset management/Portfolio, Risk management, Retail private banking and Investment banking, Anti money laundering (AML).
• Handled wide variety of customer needs including deposits, withdrawals and other business activities. Processed all new account transactions
• Legacy trading system was re-written in Java and implemented using the standard RECOM Websphere J2EE architecture to run on fully licensed and vendor-supported infrastructure in order to comply with CITMP guidelines.
• Worked on multiple database environments including Oracle, SQL Server, HDFS and DB2
• Helped with Data Mapping between the data mart and the Source Systems
• Developed functional specifications and artifacts such as use cases, use case diagrams, user stories and activity diagrams
• Experience and knowledge of modern SDLC practices (Waterfall, Agile( Scrum, FDD, DSDM), Sashimi, RAD, Spiral), Experience with Express One Delivery and CMMI methodologies
• Identified and compared (Gap Analysis) source data elements and fields names of CR (Charles River), APL and PACE (Data Warehouse).
• Worked with Tax Compliance and Business Solutions Support to determine what updates needed to occur to product lines to ensure compliance with Federal, State and Local payroll tax agencies
• Performed Competitive Analysis on different online trading applications like GS, Microsoft, and SCHW etc.
• Checked the data flow through the Front-end and Back-end and extensively used SQL queries to extract the data from the database.
• Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
• Identified internal and external system Requirements, design and configuration set-up.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
• Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management.
• Generated requirements for Capital Markets - Fixed Income Investment Management Business, Portfolio Management, Hedge funds, corporate actions, Brokerage and Trading Model within the scope of both the Front and Middle Office.
• Developed Business Requirement Document as well as High-Level Project Plan.
• Worked with developers to make sure that they understood the Use Cases.
• Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.