SUMMARY:

• Experience in business, system analysis, design, development and implementation of Business Applications for 8+ years.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Experience with Fixed Income and Interest Rate Derivatives, Syndicated Loans.
• Asset classes covered include Interest Rate Swaps, Credit Default Swaps, Foreign exchange swaps and Equity options.
• Worked as a Liaison between Trading and Debt Capital markets to execute syndicated loans
• Experience in business - user and end-user interaction with an in-depth understanding of business systems functionality and technicality.
• Extensive working experience in MISMO, XML Compliance, Content Management, Mortgage LPS System and other reporting tools.
• Extensive knowledge of Business Visual tool such as iRise for UI Interface
• Expertise in Project Planning, Project Design, Gathering requirements, creating Functional specifications, creating Use cases and E.R. and data flow diagrams.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Designed workflow and prototype models for website using UI tools such as iRise, Axure.
• Created Hi- Fidelity GUI mockups for Windows application and websites.
• Skilled in MS Access - Creating Tables, Queries, Reports, Macros using VB Script.
• Have good communication skills both Written and Oral, Management Skills. Ability to work in tighter schedules and a quick learner.
• Expertise with concentration on Use Case modeling using UML, Business Process Modeling, Data Modeling, Change Management, Software Development methodologies and Systems Testing of client server and web-based systems.
• Experience in designing and developing reports using Microsoft Reporting Services (MSRS), Crystal Reports, MS Access, and Data View web part
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.
• Design advanced SQL queries, stored procedures, triggers, scripts, cursors Create, maintain, modify, and optimize SQL Server databases
• Collaborate with applications developers on data modeling, and E-R diagrams
• Developed, executed and maintained Test Scripts. Reviewed and documented system Test Plans and performed UAT. Good knowledge of SQL queries and PL/SQL procedures.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Experience in writing test plans, defining test cases, developing and maintaining test scripts.
• Expertise with QA Methodology to ensure robust functionality.
• Prepared Workflow diagrams analyzed AS-IS and TO-BE scenarios, designed new process flows and documented the business process and various business scenarios.

TECHNICAL SKILLS:

Project Methodologies: Unified Modeling Language (UML), Rational Unified Process, Agile, RAD and Waterfall

Business Modeling Tools: MS Visio, MS Project

Requirements / Document Tools: Rational Requisite-Pro, Rational Rose, Clear Quest, Clear Quest, Clear Case

Database: DB2, MS SQL Server

Operating System: Microsoft Windows XP / Vista / 7, Apple OS X, Linux Ubuntu

Data Analysis / Financial Modeling: MS Excel (Pivot tables, Vlookup, Macros)

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Business Analyst

Responsibilities:

• Responsible for Business Process Evaluation (BPE) and Industry Best Practices analysis for Home Finance and Commercial Lending divisions (separate projects) encompassing analysis of back office systems, processes and consumer-direct web services
• Created functional specifications and design requirements for integration of current Wholesale Management System with Dealer Loan System to meet business requirements.
• Involved in formatting data stores and generate UML diagrams of logical and physical data.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• User Rational clear quest for accessing requirement and design documents.
• Responsible for creating UML modeling plan, Use Cases, process flows, screen flows and business requirements documentation to model system development specifications, using Visio and Rational Requisite-Pro.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Developed strategic partnerships with the business units to develop a solid knowledge base of the business line; including the business plan, products, and process and revenue streams.
• Managed the database using SQL and Unicas Affinium Campaign to execute queries against large data sets in an Oracle environment to generate lead lists for new and recurring marketing campaigns based on the documented business requirements.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.

Environment: Mainframes, COBOL, JCL, Db2, Visual Basic, Oracle, Teradata, UNIX, Rose, Agile, MS office, Cognos, MS Word, MS Excel, MS Visio, SAS, RequisitePro, Load Runner, Win Runner

Confidential, Winter Park, FL

Business Analyst

Responsibilities:

• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance
• Excellent in Trade risk experience (Futures, Commodities, Currencies, Equity, and Stocks etc.)
• Conducted highly interactive JAD sessions with project stakeholders, subject matter experts (SME’s), users, QA analysts and project management team for requirement gathering, and identifying and resolving issues.
• Coordinated JAD sessions to understand the user requirements and also their system’s Implementation.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Involved in GAP analysis around the identification of business rules, business and system Process flows, user administration, requirements and assumptions.
• Created analytical models that estimate future credit risk and losses at the account level for all existing and prospective loan products.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Prepared manual test scripts using Rational Test Manager; Tracked defects using Clear Quest.
• Identified Use cases from the requirements and wrote UCS (Use Case Specification).
• Coordinated team in bringing about Business Requirements, Architectural Specifications, Corporate Priorities and Functional Specification and maintain Requirement Traceability Matrix.
• Applied Unified Modeling Language (UML) to design Use Case Diagrams, Activity Diagrams, and Sequence Diagram.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• Used MS Project and assisted project manager in making Project Plan with necessary modifications.
• Maintained the data integrity of the Baan ERP system by developing an end-user strategy for data cleansing and engineering revision control
• Process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution.
• Designed and implemented basic SQL queries for QA testing and Report / Data Validation
• Responsible for organizing the Quality Analyst (QA) walk through to explain proposed changes.
• Used Test Director Application for automated testing. Coordinated with the test team to check the weekly status and report the same to the project manager and discussed project manager and other team regarding State Flow Process.

Environment: MS Visio, MS Office Suite, Java, Oracle 9i, Test Director, Agile, VB, Client Server, UML, RUP, Windows XP, Test Director, MS Project

Confidential, West Palm Beach, FL

Business System Analyst

Responsibilities:

• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Involved depth understanding of Credit Risk management for the application
• Conducted User Interviews and Work Shops to gather accurate Business Requirements
• Served as a liaison between the business team and the technical team by identifying, understanding, and documenting their needs.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Worked with management and users to analyze specify and design business applications and document current processes for efficient operations (re-statement on general ledger, account payables and receivables and P/L) using Rational Tool (RUP).
• Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk
• Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
• Worked on data modeling and produced data mapping and data definition documentation
• Configured the Data mapping between Oracle and SQL Server 2005
• Created Use Case Diagrams, Workflow and Activity Diagrams; and documented Use Case Narratives.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II
• Experience with Defect and Change management tools preferably Rational Clear Quest and Mercury Quality Center.
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Worked as a business analyst to conduct JAD and elicitation sessions with the Private Banking, Capital Market business users and stakeholders to analyze end user objectives for Basel II Asset Classification and CRMT system and created business requirements specifications, use cases diagrams

Environment: RUP, UML, Crystal Reports, Oracle, SQL, Lotus Notes, Agile, JAVA, HTML, MS VISIO, MS OFFICE (Word, Excel, MS Access, PowerPoint, Project), Basel II

Confidential, San Antonio, TX

Business Analyst

Responsibilities:

• Analyzed consumer surveys and gave technical inputs in Business meetings.
• Actively participated in the resolution of Production Report issues and also the gathering and analysis of ever changing Reporting Requirements of users
• Involved in the meeting with business and marketing team for requirements gathering in definition stage.
• Gathered the reporting requirements of the Trade Position Reporting for various Secured and Unsecured Financial Products including Derivatives like Equity Swaps, FX Forwards, Currency Swaps, Interest Rate Options and Forward Rate Agreements (FRA) and formulated the Business Rules for the same in the Oracle Data Warehouse with Crystal Reports as the front end reporting tool
• Ensured IT security and SOX Compliance requirements are implemented in New Systems, Enhancements and Upgrades
• Asset classes covered include Interest Rate Swaps, Credit Default Swaps, Foreign exchange swaps and Equity options.
• Ability to organize, document and track changes and defects using the Rational Clear Quest and archive change request in Clear Case.
• Worked as a Liaison between Trading and Debt Capital markets to execute Syndicated loans
• Created narrative Risk Manuals and flow charts identifying internal risks to Investors Bank and Trust for Global Treasury/Global Treasury Operations.
• Monitored compliance of Global Treasury/Global Treasury Operations desks (Asset Liability Management, Broker/Dealer, Foreign Exchange, Investment Portfolio, Money Desk, Securities Lending and Wire Room Operations) with regulatory and internal requirements.
• Performed compliance projects as requested by Global Treasury/Global Treasury Operations Management.
• Monitored daily compliance reporting for all Global Treasury desks.
• Assisted with integration of former Investors Bank and Trust Institutional Custody Department into Wealth Management Services.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Assisted with preparation for internal audits, and Federal Reserve Board audits.
• Provided Anti-Money Laundering review of State Street/Investors Bank and Trust clients.Completed other compliance projects.
• Implemented complex views, procedures, functions, packages and triggers in PL/SQL
• Performed Data Validation of the data flow from the front-end to the back-end using SQL to perform the Back-end testing on the database
• Facilitated negotiations with clients (other arrangers) for the finalization of syndicated facilities (conditions, term sheet, covenants)
• Ensured that relevant UML diagrams and Tools (Rose, RequisitePro) were used in all requirement documents e.g. Business Requirements, Functional Specifications.
• Facilitated the Customer in defining the high-level Functional Requirements and needs.
• Gathered the Requirements, Develop Process Model and detailed Business Policies and modified the business requirement document
• Documented approved change controls to add them into business design.

Environment: MS Visio, PowerPoint, Quality Center, Rational Requisite Professional, Rational ClearQuest, Rational Test Manager, Rational Clearquest,, Microsoft Visio, Rational Requisite Pro

Confidential, Austin, TX

Business Analyst

Responsibilities:

• Extensively involved in Risk analysis, Securities and their valuation, Asset Management (risks and returns), Asset Allocations, Bond pricing, Financial Derivatives, Cash flows, financing structure, Portfolio Analysis, etc.
• Responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans.
• Worked with production staff to identify and map detailed current processes, identify gaps and failure points, perform root cause analysis and develop functional requirements that supported overall strategy, goals and objectives, and develop and document the functional requirement documents.
• Developed and implemented highly complex statistical reports ranging from delinquency analysis to portfolio stratification of Sub-Prime Mortgage portfolio.
• Reconciled, collected and monitored the $10 million daily cash flow of loan portfolio acquisitions.
• Ensured SOX and internal control and process compliance
• Experience with business process and Information technology process and procedures re-engineering
• Performed IT Risk Assessment and IT scoping based on COSO and COBIT frameworks for SOX
• Recommend and coordinated IT SOX requirements and supported Implementation
• Plan and scope the internal audit process pertaining to Sarbanes-Oxley act of 2002
• Played a key role in the company SOX compliance efforts including process documentation
• Prepared month-end results of business unit's financial performance.
• Involved with the following financial products: Fixed Income (Bonds, Money Market Instruments, Mortgage Backed Securities and Asset backed securities), over the counter derivatives (credit default swaps, interest rate swaps, Total Return Swaps), Structured Products (MBS, CMBS, CMO, ABS, CDO, CBO & CLO), trade capture application and risk management
• Gathered requirements, analyzed credit card processing life cycle workflow and documented Statement of Work, Functional specifications and user requirements specifications
• Traced Requirements to High Level Design, Test Cases and Product Requirements
• Implemented a custom build solution to Baseline Requirements on basis of software releases
• Created infrastructure for proactive systems analysis using Requisite Pro and other rational tools
• Facilitated Joint Application Development (JAD) sessions to gather requirements from SME’s from different groups

Environment: RUP, UML, Rational Requisite Pro, Enterprise Architect, MS Project, MS Visio, MS Office, DOORS, SQL Oracle