SUMMARY

• Senior Business Analyst wif 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 i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Financial domain expertise wif extensive Credit/Debit Card application experience.
• Acquired extensive knowledge 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 knowledge 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 the 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 the implementation of regulatory guidelines such as the 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 the CCAR stress test scenarios and a new counte-rparty credit risk process.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the 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 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
• 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 wif 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 wifin the Oracle database.
• Configure Clarity setting and setup .
• Review the User Acceptance Test (UAT) plan and the results of the UAT execution by Software Quality Assurance (QA) to ensure compliance wif the requirements as documented in the final approved version of the 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 wif 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 the data model and reporting requirements for Cognos Reports wif the Data warehouse/ETL and Reporting team.
• Performed the roles of a developer, Senior Developer, Subject Matter Expert (SME) & Onsite Technical Lead during the 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 wif developers in writing Test Plans and formulate Test Cases
• Managed changes to baseline requirements through effective application of change control processes and managed the overall test process, according to the Agile/ RUP methodology
• Built and managed the overall test process, according to the Agile Scrum methodology
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Developed strategic partnerships wif the business unit to prepare a solid knowledge base of the business line, including the 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 the modules according to the user specifications.
• Initiated and implemented formal user acceptance testing for projects - a first for the 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 the 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 the 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 the existing functionality by utilizing MDM infrastructure and by using the Out-Of-Box features in IBM MDM Server.
• Developed the 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 help guide the 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 wif two IBM Partners that showcased IBM's understanding of the company's product ecosystem and the 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 the various steps in the lifecycle and tan constructed the system in a way that the high risk customers would be easily identified and monitored.
• 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.
• 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 the underlying financial instruments and tan set up derivatives pricing parameters and trade capture options that drive the valuation of trades based on the market data to configure and test the system
• Involved in gathering and preparing the requirements documents for replacing the 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 wif Mercury Quality Center for bug and defect tracking.
• Involved in supporting over the counter (OTC) derivative trade capture and straight through processing (STP).
• Tested the Basel Advanced Measurement Approach ( AMA ) approach which allowed Fannie Mae to take account of their operational risks in assessing capital adequacy as part of the Basel get compliant project.
• Facilitated the User Acceptance Testing (UAT) wif Pega System Administrators and Business Users, documented any issues or defects and eventually got sign off from the right parties.
• Worked wif traders to develop modules to hedge long and short positions in bonds wif 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 the essential business elements, detailed definitions, and descriptions of the relationships between the 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 the Wire Frames, User Interfaces, AS-IS and TO-BE flows and the Use Cases to encapsulate the information wif 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 effective, 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 the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.
• Responsible for Developing the test modules in the Quality Center for the new requirements
• Provided key input in working wif users in defining project and system requirements.
• Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds.
• Conducted JAD sessions for communicating wif 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 the feasibility of their needs by coordinating wif the project manager and technical lead.
• Created Hive tables which are extracted by Ab Initio and populate the 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 the payroll outsourcing module for a 401(k)/403(b) plan sponsor application for a major mutual fund company.
• Maintained data model and synchronized it wif the changes to the 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 wif database developers for formulating the ER diagrams and data flow diagrams.
• Managed software artifacts for the 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 the formal SDLC implementation using the 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 the 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 the BPS Risk Management product wif involvement through the 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 wif the source and target system (data warehouse) data.
• Helped wif data modeling and defining the conceptual and logical model of the data warehouse.
• Worked in detailed design for the 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 the application
• Interacted wif 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 wifin the 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 wif call center managers to make sure that application meets their requirements.
• Assured that all Artifacts are in compliance wif corporate AGILE Policies and guidelines.
• Developed strategies wif 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 the 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 the Documents.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• 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 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.
• 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 extensively wif the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Conducted JAD sessions wif management, SME, vendors, users and other stakeholders for open and pending issues.
• Planned and defined system requirements to Wire Frames wif Use Case, Use Case Scenario and Use Case Narrative using the 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 that documentation deliverables from various groups are produced as needed.
• Assured that all Artifacts are in compliance wif corporate AGILE Policies and guidelines.
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Worked on BEA WebLogic Portal to simplify the production and management of custom-fit portals, allowing a shared services environment to roll out changes wif 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 the external projects in a release.
• Facilitated JAD sessions wif 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 the impacting projects that were agreed upon to be implemented in the 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 wif 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 wif new or revised attributes and customize screen views based on security.
• Maintain Clarity documentation and procedures placed in Knowledge Store for distribution to the user community.
• Extensively worked in designing the Testing approach for the ETL process in the Credit Data Provisioning Enterprise Data Warehouse (CDP).
• Creation of the data mart from existing Operational data Store and other sources.
• Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations (if any).
• Facilitated JAD sessions wif end users, development and QA teams.
• Created UAT plans wif several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
• Reviewed test results and coordinated wif testing and development team to correct the 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