SUMMARY

• Senior Business Analyst with 7+ years of experience in business process analysis/modelling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
• Extensive experiences in Investment Banking projects, specialized in Securities Trading (stock trading, fixed income trading, and derivatives trading), wealth management and risk management.
• Expertise in Project Management me.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Financial domain expertise with extensive Credit/Debit Card application experience.
• Acquired extensive noledge of financial products and services, such as Fixed Income investments, Equities, Derivatives, Mutual Funds, Brokerage, portfolio management, Cash Management & Asset management.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• 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.
• Strong understanding of information technology capabilities and dependencies, including platforms, content management, e - document strategies and process mapping.
• In depth noledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Knowledge in teh ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• 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.
• Understanding of teh implementation of regulatory guidelines such as teh USA Patriot Act, Basel-II, Basel-III Sarbanes - Oxley Act, SEC Rule 10b-5, Securities Exchange Act of 1934 and basics of DTCC, FINRA, ISDA, ISIN, SEC, ECNs, SWIFT, STP, Dark Pools, Crossing Networks, ATS, etc. in Financial Institutions.
• Reviewed and recommended teh CCAR stress test scenarios and a new counte-rparty credit risk process.
• Responsible to Track, Document, Capture, Manage and Communicate teh Requirements using Requirement Traceability Matrix (RTM) which halped in controlling numerous artifacts produced by teh teams across teh deliverables for a project
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as teh lead of teh Projects.

TECHNICAL SKILLS

• ERWIN
• ETL: Ascential DataStage (7.x 6.x 5.x)
• Star-Schema Modeling
• Snowflake Modeling
• Bloomberg
• 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
• SQL Server
• 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, Plano, TX

Business Analyst

Responsibilities:

• Established a RUP (Rational Unified Process) centric system analysis methodology.
• Collaborated in building a system analysis process model using Rational Rose, RequisitePro, and Visio.
• Analyzed and studied Debit Card process and regulations to be complied for card services in detail. Gatheird requirements for Search Rates modules.
• Interacted with department heads to finalize system requirements, functional requirements and technical requirements and also created Business process model.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within teh Oracle database.
• Configure Clarity setting and setup .
• Review teh User Acceptance Test (UAT) plan and teh results of teh UAT execution by Software Quality Assurance (QA) to ensure compliance with teh requirements as documented in teh final approved version of teh BSD
• Involved in Developing Computer Based Training modules (CAPA) for Clarity Timesheet Management, Project Management, and Resource Management.
• 1 years proven MDM development implementation experience with IBM InfoSphere Master Data Management (MDM) on WebSphere Application Server (WAS), formerly called as IBM WebSphere® Customer Center (WCC) / DWL Customer Center.
• Dedicated account manager for IBM customers.
• Reviewed teh data model and reporting requirements for Cognos Reports with teh Data warehouse/ETL and Reporting team.
• Performed teh roles of a developer, Senior Developer, Subject Matter Expert (SME) & Onsite Technical Lead during teh 10 years in IBM
• Lead BRD reviews, feedback, and complete sign-off process.
• Created Requirement documents like BRD, FRD, etc depicting business flows & rules, processing-sequences, use-cases & inter-dependencies using UML-based standards
• Own, write, and complete Business Requirements Documents (BRD).
• Reviewed Business Requirement Documents (BRD) and Functional Requirement Documents (FRD) and coordinated with developers in writing Test Plans and formulate Test Cases
• Managed changes to baseline requirements through TEMPeffective application of change control processes and managed teh overall test process, according to teh Agile/ RUP methodology
• Built and managed teh overall test process, according to teh Agile Scrum methodology
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Developed strategic partnerships with teh business unit to prepare a solid noledge base of teh business line, including teh business plan, products, and process’ and revenue streams aimed towards problem solving.
• Responsible for producing process flow diagrams for TO-BE process flows and AS-IS process Flows using Microsoft Visio
• Experience in MDM workflow administration involving configuration, creation and modification of existing workflow.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Involved in Functional, Integration, Regression, User Acceptance, GUI and Stress Testing.
• Participated in User Acceptance testing by creating appropriate test data for teh modules according to teh user specifications.
• Initiated and implemented formal user acceptance testing for projects - a first for teh customer community. UAT extended to usability and ergonomics in addition to functional requirements validation.
• Involved in creation and execution of manual test cases in Mercury Test Director and automated Test Cases in QTP and analyzed teh Test Results.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Played a key role in teh planning, testing, and implementation of system enhancements and conversions
• Developed automated Test Scripts in Win Runner using Test Script Language (TSL) for Functional Testing, Regression Testing, Data Driven Testing, Usability Testing, and Verifying Specific content through using Checkpoints.
• Member of IBM's Consulting by Degrees Program, top 10% of incoming class chosen for fast-track management consulting leadership development program in IBM's Global Business Services
• Selected to be a Social Eminence Consultant for IBM's Industry Academy.
• Designed and architected solutions for client's requirements as well as enhance teh existing functionality by utilizing MDM infrastructure and by using teh Out-Of-Box features in IBM MDM Server.
• Developed teh ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
• Assisted in presenting reports and analysis to halp guide teh management.
• Researched and wrote Google product executive summaries to be utilized by IBM's Google Account Team.
• Assisted in development of training materials for new technology and process improvements.
• Developed and designed Supply Chain Management deck with two IBM Partners dat showcased IBM's understanding of teh company's product ecosystem and teh future of supply chain.

Environment: Windows, MS Office(MS Word, MS Excel, MS Powerpoint, MS Visio), .Cognos, NET, Oracle, Crystal reports, RUP, UML, SQL, User Acceptance testing(UAT),Teradata,Clarity, SWOT analysis, GAP Analysis, Win Runner,IBM,MDM.

Confidential, Boston, MA

Business Analyst

Responsibilities:

• Researched teh various steps in teh lifecycle and tan constructed teh system in a way dat teh high risk customers would be easily identified and monitored.
• Exposed to and worked with Subject Matter Experts in Fixed Income Annuities, Equities, Swaps, Finance, Trading Cycle, Portfolio Analysis & Management, Asset Management, Bonds and Bond Trading Cycle, Pricing, Derivatives.
• Designed and Developed equity reference data flow diagrams business process models using Microsoft Visio for eagle pace equity reference data ware house system.
• Write and edit monthly and quarterly fixed income mutual fund market and client commentaries, product performance and attribution results.
• Also performed Data Analysis for pricing feeds coming from Reuters, Bloomberg and Enterprise Security Master (ESM).
• Reconciled weekly, monthly, and year end reviews of current and prior year accounts in both CCaRs and CAFRM
• Develop content for marketing materials designed to promote fixed income products.
• Set up market data including zero curves, correlation matrices, dividend curves, etc., and teh underlying financial instruments and tan set up derivatives pricing parameters and trade capture options dat drive teh valuation of trades based on teh market data to configure and test teh system
• Involved in gathering and preparing teh requirements documents for replacing teh existing commercial lines of businesses from legacy to web-based system
• Apply custom changes to Calypso software in order to replicate vanilla and exotic OTC derivative products
• Supported web design and user-interface layout for public and internal web based solutions.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
• Involved in supporting over teh counter (OTC) derivative trade capture and straight through processing (STP).
• Tested teh Basel Advanced Measurement Approach ( AMA ) approach which allowed Fannie Mae to take account of their operational risks in assessing capital adequacy as part of teh Basel get compliant project.
• Facilitated teh User Acceptance Testing (UAT) with Pega System Administrators and Business Users, documented any issues or defects and eventually got sign off from teh right parties.
• Worked with traders to develop modules to hedge long and short positions in bonds with credit spread calls and puts. Wrote rules to calculate payoffs based on credit derivatives trading strategies and calculations of credit delta and gamma to determine change in bond value.
• Prepared High Level Logical Data Models and BRD’s (Business Requirement Documents) supporting documents containing teh essential business elements, detailed definitions, and descriptions of teh relationships between teh actors to analyze and document business data requirements
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Developed and designed teh Wire Frames, User Interfaces, AS-IS and TO-BE flows and teh Use Cases to encapsulate teh information with ease.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is TEMPeffective, efficient, standardized, coordinated, and integrated.
• Used MS Visio for Process modelling, Process mapping and Business Process flow diagrams.
• Designed and developed project document templates based on SDLC methodology
• Performed extensive Requirement analysis and developed use cases and workflows.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• Played a key role in teh planning, User Accepted Testing, and Implementation of system enhancements and conversions.
• Involved in Technical Documentation, Unit test, Integration test and writing teh Test plan.
• Responsible for Developing teh test modules in teh Quality Center for teh new requirements
• Provided key input in working with users in defining project and system requirements.
• Designed and Developed ETL (Extract, Transformation & Load) strategy to populate teh Data Warehouse from teh various source systems feeds.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.
• Developed business requirement specification documents as well as high-level project plan.

Environment: Mainframes, COBOL, JCL, Db2, HTML, Oracle, Rose, WebLogic, Javascript, Quality Center, Six Sigma, MS Word, MS Excel, MS Visio, LoadRunner, WinRunner

Confidential - Covington, KY

Business Analyst/data analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed teh feasibility of their needs by coordinating with teh project manager and technical lead.
• Created Hive tables which are extracted by Ab Initio and populate teh relevant EDW tables.
• Responsible for managing relationship for a group of client accounts & mainframe administration of daily participant level transactions, valuation & statement processing of 401(k) plans.
• Designed & developed teh payroll outsourcing module for a 401(k)/403(b) plan sponsor application for a major mutual fund company.
• Maintained data model and synchronized it with teh changes to teh database
• Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.
• Completed special projects utilizing advanced Excel functions (pivot tables, v-lookups)
• Used SSIS to transform and load data into SQL database via FTP from XML files, MS Excel as source data
• Created tables, views, indexes, triggers and complex stored procedures in Sybase TSQL to store maintain data.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Interacted with database developers for formulating teh ER diagrams and data flow diagrams.
• Managed software artifacts for teh suite of investment products such as Online Banking and Brokerage, BIDS, Insurance etc
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• Experienced in running Hadoop streaming jobs to process terabytes of xml format data
• Running queries and pivot tables for specific task pertaining to accounts
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Converted DB2 Logical data models into Teradata Logical and Physical database models
• Developed and managed teh formal SDLC implementation using teh Lean/Agile Methodology.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Validated teh test data in DB2 tables on Mainframes and on Teradata using SQL queries.
• Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and commercial lending system.
• Good Experience in publishing reports and dashboards to Tableau server
• Tested data warehouse ETL process using SSIS (Integration Service)
• Responsible for business system analysis of customizing teh BPS Risk Management product with involvement through teh whole SDLC
• Created logical and physical database design, data structures and maintained it by using SQL tools like
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin
• Created report schedules on Tableau server.
• Developed BRD documents for Securitized Inventory (CMO, ABS, MBS, and ABCP). BRD targeted new Basel II Compliance requirements.
• Wrote Complex SQL queries to verify report data with teh source and target system (data warehouse) data.
• Helped with data modeling and defining teh conceptual and logical model of teh data warehouse.
• Worked in detailed design for teh use cases and developed detail class diagrams and sequence diagrams using Rational Rose implementing J2EE patterns in UML design.
• Creating, Process Flow Diagram, Context Diagram and Activity diagrams using UML.
• 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
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Building, publishing interactive reports and dashboards using Tableau server.
• Evaluated Competitors offerings and products including fixed income and derivatives
• Involved depth understanding of Credit Risk management for teh application
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within teh Oracle database
• Support management, Legal, Consumer Affairs, Accounting, producers, andbusinessareas via ad hoc reports utilizing SQL and other query tools such as: DB2, TOAD, MS Access, Crystal Reports, MS Excel, and SAP.
• Write simple to complex TSQL scripts using Case Statements, Where Clauses, Subqueries, and Union
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• UAT testing performed along with call center managers to make sure dat application meets their requirements.
• Assured dat all Artifacts are in compliance with corporate AGILE Policies and guidelines.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Led and conducted JAD sessions for requirements gathering, analysis and design of teh system.
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Aided management in standardizing web applications by preparing GUI standards and recommending alternatives for in corporation in a phased, iterative manner.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Worked on Documentum for Version Controlling, to maintain up to date changes in teh Documents.
• Assisted to develop teh Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product noledge.
• Conducted User Acceptance Testing, gatheird and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, EVPN, RUP,VBScript, Dreamweaver, Sharepoit,Adobe Photoshop, Caliber RM MIS-IP, C#. NET, ASP.NET, UNIX, Business Objects, TestDirector, LoadRunner,crystal report.

Confidential, NJ

Business Analyst

Responsibilities:

• 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 teh scope of both teh Front and Middle Office.
• Worked extensively with teh QA team for designing Test Plan and Test Cases for teh User Acceptance Testing.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using teh UML (Unified Modeling Language) methodologies.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• 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.
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Developed and managed creation of technical documentation to communicate features, benefits, positioning and impacts to different audiences and ensured dat documentation deliverables from various groups are produced as needed.
• Assured dat all Artifacts are in compliance with corporate AGILE Policies and guidelines.
• Responsible for gathering requirements from users in operations group and performing data mapping for teh application, confirm and vacillating teh requirement at time of BA testing
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into teh Data Marts.
• Worked on BEA WebLogic Portal to simplify teh production and management of custom-fit portals, allowing a shared services environment to roll out changes with minimal complexity and effort.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Casewise modeller, IBM Websphere, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Confidential, Las Vegas, NV

Business Analyst

Responsibilities:

• Gatheird high-level requirement for all teh external projects in a release.
• Facilitated JAD sessions with SMEs and system analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
• Created functional requirement documents for teh impacting projects dat were agreed upon to be implemented in teh current release.
• Preparation of deliverable; business process design and workflow, system requirement documents, detailed syetem functional and non functional specification.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Used BEA (BPM Tool) to map Process flows and migrated Visio Process flows into BEA Tool.
• Developed As-Is and To-Be Process Flow Diagrams
• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams.
• Manage AML related projects, BRD and FRD developments, and UAT testing
• Create/edit project documentation (BRD, FRD, Use Cases, Risk Analysis, etc.)
• Update Clarity screens with new or revised attributes and customize screen views based on security.
• Maintain Clarity documentation and procedures placed in Knowledge Store for distribution to teh user community.
• Extensively worked in designing teh Testing approach for teh ETL process in teh Credit Data Provisioning Enterprise Data Warehouse (CDP).
• Creation of teh data mart from existing Operational data Store and other sources.
• Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all teh impacting projects and updated teh documents based on recommendations (if any).
• Facilitated JAD sessions with end users, development and QA teams.
• Created UAT plans with several test cases for each project to ensure dat teh system runs smoothly after teh proposed enhancements or changes has been made.
• Reviewed test results and coordinated with testing and development team to correct teh issues.
• Developed timelines for project delivery, and managed projects/resources

Environment: Microsoft Office Suite, Microsoft Visio, Unix, User Acceptance testing(UAT),Cognos, Documentum, Teradata, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, ETL, VBScript, C#. DOORS, C++, NET, ASP.NET, Business Objects, TestDirector, LoadRunner