SUMMARY

• Actimize Sr. Business Analyst in IT industry wif over 8 years of experience in business process analysis/modelling, business requirements gathering, database design and development of Web Based, and Client/Server applications
• Having excellent working experience working wif Financial Services(Securities and Banking Domain) Industry
• Having expert level experience on TOAD, DOORS, MS Office Suite & SQL
• Extensive experiences in Banking projects, specialized in Securities Trading (stock trading, fixed income trading, and derivatives trading), wealth management and risk management.
• Having extencive experience in Project Management
• Extensively worked on ETL Informatica transformations TEMPeffectively including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Union, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator and created complex mappings
• Acquired extensive noledge of financial products and services, such as Fixed Income investments, Equities, Derivatives, Mutual Funds, Brokerage, portfolio management, Cash Management & Asset management.
• Deep understanding and experience of Investment Management, Asset Management, Prime Brokerage Services, Money and Capital Market Instruments
• Excellent understanding of equity reference data warehouse concepts such as equity reference data marts, disk utilization analytics Meta equity reference data, logical and physical equity reference data modeling.
• Responsible for Data analysis / Data Mapping, origination of Asset Backed Securities (ABS) and Asset Backed Commercial Paper (ABCP) conduit facilities backed by multiple asset classes including Collateralized Debt Obligation, Residential and Commercial Mortgages, Commercial Loans and Bonds, Automobile Loans and Leases, Trade Receivables, Credit Cards, Home Equity Loans, Equipment Loans and Leases and Student Loans.
• Good experience and noledge of Data warehousing & RDBMS concepts including OLAP, dimensional modeling using Star Schema and Snow-Flake Schema designs.
• Extensive experience in working wif data feeds from several data vendors including Bloomberg and Reuters for market & reference data management
• In depth noledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Interface wif clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.

TECHNICAL SKILLS

• ERWIN
• ETL: Ascential DataStage (7.x 6.x 5.x)
• Star-Schema Modeling
• Snowflake Modeling
• FACT and dimension tables
• Erwin 4.0
• Business Objects
• Micro strategy
• Erwin 4.x
• C/C++
• Java SE 1.4
• TURBO PASCAL 7.0
• VB.Net
• HTML
• COBOL
• Transact SQL
• ANSI SQL
• UNIX shell scripting (korn shell) SQL Server
• TOAD
• DOORS
• MS Office Suite
• RDBMS
• SOA
• SAP SD
• MySQL
• Agile/Scrum
• Oracle 8i
• Visio
• Sybase ASA (6 - 9).ASP/ASP.net
• PHP
• Microprocessors 8085 & 8086
• Unix
• MVS
• MS Windows/95/98/NT/2000/XP
• MS DOS
• MS Office 2000

PROFESSIONAL EXPERIENCE

Confidential, Birmingham, MI

Sr. Business Analyst

Responsibilities:

• Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• In depth involvement wif the design for the strategic template for the CI system in features like Mutual Funds, Investment Portfolios including Equities and Fixed Income(Options, Futures, Bonds) Fees Distribution, Educational Services. SWOT Analysis, Product Features and strategic decisions.
• Rolled out documentation for BRP supporting the deployment teams using Domino, wif DBLookups into deployment databases
• Implemented Actimize Anti-Money Laundering (AML) system to monitor suspicious transactions and enhance regulatory compliance.
• Develop UML diagrams like Use Cases Diagram, Activity Diagram, Sequence Diagram, Class Diagram and Coloration Diagram on scenarios for validating Entity Reference Data management and verification of customer records: legal name, address, business purpose, legitimacy and analysis of transaction activity.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data wifin the Oracle database
• Designed and developed Oracle PL/SQL scripts for Data Import/Export, Data Conversions and Data Cleansing
• Announcing Microsoft Dynamics CRM December 2012 Service Update .
• Design and implementation Microsoft CRM Architecture.
• Facilitated JAD sessions to expedite the processes of data mapping
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database.
• Exposed to and worked wif Subject Matter Experts in Fixed Income Annuities, Equities, SWAPS, Finance, Trading Cycle, Portfolio Analysis & Management, Asset Management, Bonds and Bond Trading Cycle, Pricing, Derivatives.
• Involved in the analysis of the functional, technical specifications, reference data mapping document and conceptual diagrams.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data wifin the Oracle database
• Extensively involved in the automation of Regression Test Cases by scripting.
• Custom installation and integration of MS CRM Outlook client.
• Create and maintain requirements, test cases and defects in Mercury Quality Center
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Responsible for providing analytical support in the Design, Development and Implementation of Project.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team

Environment: Rational Enterprise Suite (Rose, ClearCase, ClearQuest), RUP, Visual Basic, SQL, SQL Server, Oracle, C#.Net, Quality Center, TOAD, DOORS, MS Office Suite, Project Management, Windows Forms, Web Forms, LoadRunner, WinRunner, DOORS, Project Management.

Confidential, Jersey City, NJ

Sr. Business Analyst

Responsibilities:

• FallowedAgile(Scrum) Methodologyto implement the project in OTC of Fixed Income products
• Gathered Business requirements by conducting JAD/ JAR sessions and documenting them in a BRD/FRD
• Conducted walkthroughs for handling complex security issues arising due to implementation of Straight Through Processing (STP) radar
• Expert in using SQL queries to extract data from the database
• Extensive experience in checking and maintaining the quality of data in the warehouses by performing data profiling
• Involved in gathering of business requirements, interacting wif business users and translation of the requirements to ETL High level and Low-level Design
• Coordinated in implementing a project for Fixed Income Securities like different kinds of Bonds, Default swaps, Rate swaps for Exchange as well as Off-Exchange Trading
• Participated in creating a platform to get direct feed from Bloomberg
• Led focused group meetings wif SME's and management to realize SOA awareness wifin the company.Optimized the use of bank-owned life insurance (BOLI) to fund both non-qualified and qualified benefit expenses.Responsible for the development of a Data Warehouse for personal lines property and casualty insurance
• Worked wif Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system Reference Data Management.
• Deep understanding of various investment alternatives for portfolio such as equities, treasury and corporate bonds, debentures, derivatives (futures, forwards and options), commodities, private equity, real estate, hedge funds and venture capital markets.
• Data Mapped on the sell-side of OMS which does Pre-trade, Trade, Post-trade and transform electronic communication of pre-trade and trade message between Financial Instrument
• Involved wif the QA team to conceptualize, determine and develop test approaches and methods for unit testing, integration and functional testing, load and usability testing according to the application complexity and test requirements.
• Used Calypso Trading Platform which is a Risk Management Platform. It is mainly to deal wif CDS and IRS for safety and soundness of Market. The Collateral Management and Margining been handle by that software
• Responsible for identifying, documenting and testing the data mapping feeds from several reference data Management, to risk applications
• Extensively involved wif the trading activities of Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives; and Futures including Commodity Futures Contracts and Financial Futures.
• Writing new COBOL, DB2 programs to handle Claim centre messages (from front end via XML) processed in the Mainframe from the front end system called Claim Centre (CC) using GUIDEWIRE working wif SQL SERVER Data.
• Generated requirements for Capital Markets - Fixed Income Investment Management Business, Portfolio Management, Hedge funds, corporate actions, Brokerage and Trading Model wifin the scope of both the Front and Middle Office.
• Worked wif project management to analyze change requests to determine what is being requested and programming required. Worked on data modelling and produced data mapping and data definition documentation.
• Worked wif 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.
• Conducted quality assurance checks on KYC/CIP reference data to ensure authoritative sources of reference data are available to all areas of the firmWorked on brokerage applications for trading, risk management and processing. Wrote BRD & FRD by gathering requirements from SME's using Murex Mx Asset Manager, to build up
• Gained good understand of OTC Life Cycle Processes
• Improvising STP trade processing for the various clients reducing manual intervention on trade processing
• Worked closely wif the QA Team to review and enhance the Test Plan and Test Cases
• Worked closely wif UAT Team wif the business users and took sign off
• Used SharePoint to create a noledge repository and operated the local repository as an administrator

Environment: Rational Suite (Rose, Requisite Pro), Rational Unified Process (RUP), LoadRunner, WinRunner, SharePoint, Windows XP/2000, TOAD, DOORS, MS Office Suite, Oracle, XML, PL/SQL, MS-Project, CaliberRM, MS-Office Suite, MS Visio, MS Word, MS Excel

Confidential, Stanford, CT

Business Analyst

Responsibilities:

• Develop trading solutions to re-hypothecate the positions; perform high-level feasibility analysis, industry & market analysis, risk analysis, trading workflow reconfiguration
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Design, develop, and validate testing methodologies for trading activities; perform trading-related testing via the new trading system, coordinate wif various F2B components, document results, and generate reports.
• Conducted business process modeling and analysis; identified, assessed and articulated gaps/operational risks associated; presented risk-mitigation and operational enhancement solutions to project management team
• Developed plan for data feeds and data mappings for integration between various systems, including XML set and ANSI SQL formats.
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
• Developed & executed several Optimized queries in SQL on this data.
• Query optimization using SQL Profiler and performance monitors to enhance the performance of database servers.
• Came up wif test cases from the requirements, validated/exercised those test cases in form of integration and regression tests. Used Test Director to map the requirements wif test cases (automated/manual), used QTP for automated testing. Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Financial products involved: Fixed Income, Equities, Bonds, Mutual Funds, Fund of Funds, Insurance, ment Planning, Generation Planning and complete Financial Planning.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time.)
• Strong hands on ability to use ANSI SQL in RDBMS (SQL Server, Oracle) for verifying source data preparation and assisting of data design input and trouble-shooting.Strong noledge of Business Intelligence, Data Warehousing and Business Architecture.
• Assisted wif test plans, test case and performance testing, and conducted UAT; facilitated discussion between business team and QA team on determine the test requirements and pass/fail criteria. Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Worked on Client/Server tools like SQL Server Management Studio to administer SQL Server.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Experience wif designing and verifying databases on Oracle and SQL Server RDBMS using Entity-Relationship Diagrams (ERD)
• Facilitated periodic system update Regression Testing and other systems integration testing by creating testing case, system static data, and relevant report and sign-off

Environment: Windows, Oracle, MS Visio, HTML, TOAD, DOORS, MS Office Suite, PHP, MS Access, UML, Quality Center, WebLogic, ANSI SQL, RDBMS, Requisite pro, Rational ClearQuest.

Confidential, Baltimore, MD

Business Data Analyst

Responsibilities:

• Experience from Front to back office, worked wif fund managers, financial advisors and technical team members.
• Interacted wif Fixed Income business heads to finalize the Business Requirements for the application.
• Wrote SQL statements to extract data from the Tables
• Planned and defined system requirements to Wire Frame wif Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Assisted wif project team in the whole project lifecycle phases including scope analyzing, requirements gatherings, developments and quality assurance.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Worked wif business line and external data providers (Makit, Credit Delta) to develop a suite of exposure management reports for the bank's Loan Portfolio and Credit Default Swap hedge book.
• Used MS Visio for Process modeling and Business Process flow diagrams.
• Successfully managed server applications and Project Management outsourcing of Mainframe ITI applications to Fiserv Outsourcing in LA to reduce processing costs.
• Conducted interviews wif various business users to collect requirement and business process information using MS Visio, Requisstite pro.
• 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.
• Worked on data modeling and produced data mapping and data definition documentation
• Created test cases, test plans for Charles River compliance rules for the algorithm tools.
• Designed and developed project document templates based on SDLC methodology
• Identified, researched, realized, investigated, analyzed, defined and documented business processes and Use Case Scenarios
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Prepared detailed design documents to translate business process TEMPeffectively 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.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Extracted data from Oracle database wif MS Access, and performed SQL query, data analysis and verification.
• Assisted in system and User Acceptance Testing, performed client presentations.
• Created customized reports in Charles River such as commission analysis report, boxed position report, take-over report, and compliance report etc. using Crystal Reports, Excel VBA and SQL.
• Assured that all Artifacts are in compliance wif corporate AGILE Policies and guidelines.

Environment: Windows, Oracle, SQL, MS Visio, TOAD, DOORS, MS Office Suite, HTML, PHP, MS Access, UML, Quality Center, WebLogic, Requisite pro, Rational ClearQuest.