Professional Summary:

• Experienced IT Professional with over 9 years of experience in Business/Process and Systems Analysis in Financial Institutions Retail Banking and various application developments
• Well versed in performing Gap analysis and Data Mapping/ Process Mapping to document system and process inconsistencies and implemented solutions
• Designed and implemented Data Mapping and Mining Documents for various projects under ISO-9001 requirements to meet strict Quality Assurance standards.
• Extensive and diversified experience leading the implementations of Software Development Life Cycle SDLC Waterfall, RUP, RAD, Agile
• Sound knowledge of concepts like Gap Analysis, Risk Analysis, and Impact Analysis
• Expertise in coordinating Functional Testing, System Testing and UAT test effort and writing System Test Plans and formulating Test Strategies
• Excellent Business writing skills in writing Business Requirements Document BRD , USE Case Specifications, as well as thorough exposure of conducting JAD sessions and interviews with Subject Matter Experts SME and data stewards to understand the business process, business rules, and data requirements
• Strong knowledge in using the Six Sigma technique DMAIC for eliminating defect and reducing variations in business process as well as designed various useful business maps such as Flow charts.
• Analyzed SIPOC and RACI matrix to clarify the cross team members about their roles and responsibility to complete the business process
• Expertise in developing Functional Requirement Specifications FRS , Systems Requirements Specification SRS , Systems Design Specification SDS , Design Documents, Use Cases and Object Oriented Design using UML
• Strong knowledge of Data warehousing concepts Experience in database modeling and development of Entity Relationship Diagrams ERD
• Experience in designing Process Flow and Data Flow diagrams to document Business processes
• A team player complimented on working effectively with all levels of management
• Proficient in using UML for Business Process Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams and document them using Microsoft Visio.
• Designed and created data reports using various reporting tools.
• Able to effectively converse, relate and liaise with multi-functional teams, including business owner, stake holders, managers, architects, developers and testers at all levels.
• Excellent interpersonal skills in listening, mentoring, coaching, negotiation, mediation, influencing, conflict resolution and strong communication, written and presentation skills.

Technical Skills:

Professional Experience:

Confidential

Sr. Business Analyst

Responsibilities:

• Engage business and Risk Management stakeholders in priority discussions for feed integration projects for given asset class/set
• Complete, maintain and review project plans for each one of the project implementations
• Complete Test / Business Requirements Documents BRD , obtaining approval from key stakeholders
• experience working in a SAS analysis capacity on a UNIX application tier and accessing data in a DB2 and Netezza
• Obtaining formal sign-off of business requirements documents, explaining requirements to the software development teams
• Interface with the Business team while also collaborating with the IT team to deliver prioritized deliverables and work on the newly funded Global Positions System GPS project.
• Guides cost analysis process by establishing and enforcing policies and procedures providing trends and forecasts explaining processes and techniques recommending actions
• Experienced with risk metrics including capital and stress testing
• Expert knowledge of SAS analytic capabilities that include statistical analysis, forecasting, predictive modeling and data mining
• Experience analyzing business and system requirements and building SAS solutions that meet needs
• Hands on experience in credit risk in both consumer and institutional banking business lines
• Ability to present data with clarity from an insightful and actionable perspective
• Compare liquidity, profitability, and credit histories of individual or company being evaluated with similar establishments to determine risk
• supports the Global Credit Trading team which is a leading market maker in public debt across the credit spectrum, including high grade, high yield and distressed debt
• Engage business and Risk Management stakeholders in priority discussions for feed integration projects for given asset class/set
• Determines cost of operations by establishing standard costs collecting operational data
• Identifies financial status by comparing and analyzing actual results with plans and forecasts
• Create the current state and the future state BRD document for the GPS project and related to the new Oscar GUI, Position Management, P L calculation, Risk reporting, etc.
• Meet with decision makers, systems owners, and end users to define business, financial, and operations requirements and systems goals, and identify and resolve systems issues.
• Identify and establish scope and parameters of business analysis of multiple projects in relations to Credit Cards, Debit Cards, EFT and Retails banking systems.
• Collaborate in the planning, design, development, and deployment of new applications, and enhancements to existing applications.
• Prepare and deliver reports, recommendations, or alternatives that address existing and potential trouble areas in operating systems across the organization.
• Create system design proposals.
• Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.
• Lead design sessions in prototyping new systems for the purpose of enhancing business processes, operations, and information process flow.
• Plan and schedule project timelines and milestones using appropriate tools.
• Track project milestones and deliverables.
• Perform cost-benefit and return on investment analyses for proposed systems to aid management in making implementation decisions.
• Write business requirements and has strong traded products knowledge - specifically equities and equity related products
• Ensure compatibility and interoperability of in-house computing systems.
• Create systems models, specifications, diagrams, and charts to provide direction to system programmers.
• Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems, and other post-implementation support.
• Provide guidance and/or instruction to junior staff members.
• Functioned as a vital liaison between the business line, operations and the technical areas throughout the project cycle.
• Worked with development project teams with regards to functional specifications, quality assurance scripting, and product rollout.

Environment: Visual Basic, Oracle 10g, SQL Server 2005, HP Quality Center 9.0, XML and HTML, Rational Rose, MS Visio, MS PowerPoint

Confidential

Business Analyst

Responsibilities:

• Daily assessment of AML and SWIFT reports for potential suspicious activity
• Investigate, review and resolve AML related and economic sanction related alerts
• Analyze results by various attributes in order to provide metric reporting to management, responses to regulatory agencies, as well as trouble shoot reconciling issues with the data
• Used the Agile Scrum methodology for Software Development Life Cycle SDLC guidelines to carry out every step of the business modeling process.
• Followed reforms related to changes in the Mortgage Laws for the Real Estate portfolio.
• Perform the required KYC screening on existing clients by documenting and corroborating the information obtained on the client as required by the Global KYC Procedures utilizing a variety of independent research sources.
• Organized workshops with Subject Matter Experts SME to obtain domain level information.
• Added Functionality to existing Santander Bank website to allow its customers to prequalify for a mortgage in regards to credit card history utilizing Dodd Frank Wall Street Reform.
• Organized workshops with Subject Matter Experts SME to obtain domain level information in regards to credit score, Annual Percentage Rate APR , variable interest rate and credit limit.
• Lead discussions and JAD Sessions to gather business requirements and discuss possible solutions documenting them Software Requirement Specifications SRS .
• Elicited demands from the stakeholders and analyzed them for consistency, flexibility and completeness.
• Gathered Functional and Data Requirements, analyzed workflows and created Use Cases, Requirement Specifications, Report Specifications, Data Requirements, Data Mappings and Data Flow Diagrams.
• Documented use cases, created use case diagrams that described the behavior of the system and modeled them in Rational Rose.
• Identified, organized, and documented the changing requirements of the project using Rational Requisite Pro.
• Assisted in creating wireframes for web interface with the GUI design team.
• Logged defects to Rational Clear Quest and interacted with developers to resolve the defects then verify fixes and close bugs
• Dedicated a good portion of time with the QA team in front-end, back-end and Regression testing.
• Coordinated with the business partners in conducting the UAT User Acceptance Testing.

Environment: Agile methodology, Rational Suite Rational Requisite Pro, Rational Clear Quest, Rational Rose , Oracle, MS office suite 2007, SQL Server 2008

Confidential

Business Analyst

Responsibilities:

• Consistently documented functional and business requirements using use cases and Unified Modeling Language.
• Provided End-user support by supplying effective product, efficient process and functional solutions to resolve and enhance current user application functionality.
• Enhanced end-user access to a wide variety of data using Data warehouse modeling techniques.
• Assisted the Executives and the Department Heads in Disaster Recovery Operation during production process of applications.
• Interacted with prospects, clients and industry representatives for gathering, analyzing, writing and translating business and functional requirements into Functional specification documents.
• Maintained, communicated and tracked requirements using Rational Requisite Pro.
• Created and maintained artifacts by evaluating needs, clarifying requirements, and analyzing use cases and dependencies to recommend a course of action.
• Used MS Visio to create product maps and sequence diagrams.
• Worked closely with project manager and gave inputs in the strategic development of detailed project plans, work assignments, target dates in MS Project.

Confidential

Business Analyst

Responsibilities:

• Provides ongoing day-to-day support of a Private Wealth Advisor's book of business. Provide account information to clients and Private Wealth Advisors. Learn the business and products in order to assist Private Wealth Advisors
• Working with clients to ensure proper accounting opening procedures and documentation
• Providing account information to clients and Private Wealth Advisors and maintaining key client relationships
• work with the Wealth Management Digital channel managers to support a multi-year strategic roadmap to implementation
• responsible for the creation of business requirements documents and subsequent user acceptance testing of these requirements so that the roadmap can become reality
• Responsible for developing a charter, high level and detailed functional and non-functional business requirements and business rules for business and technology projects.
• Facilitates working sessions to drive to specific understanding of business line needs and ideas and participates in both strategic and tactical support of initiatives to address those needs and issue resolution
• Acted as a liaison between the business units and the technology teams.
• Organized meetings with the SMEs of the dependent systems. Conduct weekly issue meetings with customers.
• Created the dimension models and the created the physical data models.
• Written the specifications for the Data mapping and complex ETL transformation specs.
• Supported ETL developers with end-to-end ETL development of the new system to integrate the data in the existing Data Warehouse using SSIS.
• Lead JAD sessions and act as the lead facilitator for various projects from start to finish through the SDLC.
• Prepared BRD to ensure high-level design, updated BRD and FRD through working with the Desk heads and their different business units Investment Grade, High Yield, and Distressed Debt .
• Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Automated Batch Jobs to Load the Consolidated Data warehouse at scheduled times to run on a daily, weekly and monthly basis in Job Scheduling Console.
• Designed and developed SSIS Mappings to load data from existing trading system.
• Developed test cases and test scripts for system and UAT testing.
• Participate in Code Reviews, System Testing and UAT followed by production verification, postproduction testing and support.
• Participated in Bug-Review meetings with software developers, QA engineers, managers and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs
• Designing ETL flow, batch job creation, responsible for identifying and monitoring data ware house usage across several applications.
• Extensively used Quality Center for Test Management needs.
• Involved in end user training and support for new system.

Environment:

SQL Server 2008/2008R2, SSIS, SSRS, T-SQL, XML, XSD, Perl Script, TFS, Agile methodology

Confidential

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.
• 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.
• 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
• 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

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
• 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
• 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.
• 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 8i