SUMMARY

• Over 8 years of extensive experience as a Business Analyst in Business Requirement Gathering, Business Process Flow, Business Process Modeling, User Acceptance Testing, Business Analysis, Enterprise Datawarehouse, Data Analysis, Data Mapping and Data Modeling.
• Hands on experience and involvement in phases of Software Development Life Cycle such as Waterfall, Scrum, Hybrid (Scrum - Waterfall) environment and extensive knowledge on Extreme Programming, and Rational Unified Process.
• Experienced in user requirements gathering, Use Case design and analysis, Use Case specifications, Scenarios, Business processes, Workflow diagrams, process flows and technical documentation, using Unified Modeling Language (UML), and Rational Suite.
• Experienced in Accounting & Financial Analysis and performing GAP Analysis
• Knowledge of Federal and State billing regulations and tax compliance
• Adept with Office Automation tools (PowerPoint, Excel 2007 Pivot tables/VBA, Word, Access and Visio)
• Knowledgeable in GAAP, FAS, A/R, A/P, G/L, SOX methodologies and standards
• Experienced Business Requirements Management and documentation in DOORS
• Experienced in Data Analysis, Accounting & Financial Analysis and performing GAP Analysis Extensive project management experience and knowledge of SOA methodologies and Lifecycles.
• Experienced in B2B and B2C Omni channel (Both portals and order Management) .
• Experienced Data Warehouse Analyst who is well-versed in several database platforms and proficient in several kinds of extraction tools.
• Proficient in Creating and Transforming Business Requirements into software requirement specification (SRS) using MS Word and Rational Requisite Pro.
• Good understanding on Capital market such as Equities, Equity Derivatives Fixed Income - Corporate Bonds, Government Securities, Mortgage Backed Securities (MBS), Collateralized Mortgage Obligation (CMOs), Asset Backed Securities (ABS), Collateralized Debt Obligation (CDOs).
• Understanding of OTC derivative products such as Options, Futures, Forwards, Swaps, Credit Derivatives, Credit Default Swaps, Credit Linked Notes.
• Highly experienced in various areas of Investment Banking: Portfolio Management, Fixed Income, Annuities, Trading Life Cycle, Stocks, Bonds, Futures, Options, Hedging, Equity Research, Mutual Funds, Securities trading and Commodities.
• Knowledge of Anti Money Laundering (AML), Bank Secrecy Act (BSA), Comprehensive Capital Analysis and Review (CCAR) and Dodd-Frank Act. Working knowledge and understanding of Suspicious Activity Reporting (SAR) and OFAC reports.
• Created User Requirement Specification (URS), Functional Requirement Specification (FRS), business process flow System.
• Expertise in liquidity risk reporting, treasury operations.
• Sound Proficiency in analyzing and Creating Use cases, Use Case Diagrams, wireframes for UI Design, Activity diagrams, Class diagrams, Data Flow Diagrams, Business Flow Diagrams and Navigational flow diagram and Sequence diagrams using MS Visio and Rational Rose.
• Experienced in conducting Daily Scrum meeting, Planning Sessions, Backlog updates, User Stories updates
• Exceptional ability to research, analyze and translate technical information to end-users at all levels.
• Hands full of experience in MS Office Suite, MS Project for Project Plan, MS Visio, Rational Suite Rational Rose, Rational Requisite Pro, Rational Clear Case and Rational Clear Quest.
• Involved in GUI testing, Functionality Testing, Regression testing, System Testing, Unit Testing, Integration Testing, Performance Testing, and Stress Testing.
• Subject Matter expertise in Investment Banking, Fixed Income, Trade Life Cycle, Mortgage Origination, Mortgage Service, Secondary Mortgage Market, Loan, Credit Cards, Insurance, and Portfolio Investment Analysis.
• Strong understanding of Mortgage Backed Securities, Capital Markets, Retail Banking, including Credit Card, Mortgage, Account Transactions, Wire Transfers, Bill Payment.
• Strong knowledge of Finance, Accounting, and Sox Compliance.
• Recognized as being dynamic, result-oriented, analytical and organized in managing multiple priorities.
• Cross functional experience in Financial Services Industry Investment Banking, Retail Banking and Brokerage Services Banking.
• Extensively interacted with the QA Team in executing the Test Plans, Providing Test Data, Creating Test Cases, Issuing STR’s upon detection of bugs and collecting the Test Metrics.
• Thorough knowledge of Requirement analysis, Planning, Scheduling & Tracking projects.
• Excellent knowledge in Asset Management, Wealth Management, Investment Banking, Derivative products such as Options and Futures, Credit Card, Insurance and Bonds.
• Broad Knowledge in reviewing Test Procedures, creating Test plans and detailed test plans for UAT, Test scenario, defining Test cases, both System & Integration and executed many test cases Test Data reviewing and maintaining and executing detailed Test scripts for UAT, analyzing bugs, interacting with team members in fixing errors and User Acceptance Testing (UAT) and also assisted in post - Production support.
• Experience with Oracle SQL and Toad, Teradata DW and Teradata SQL Assistant.
• Extensive experience in creating screen mockups, conducting Gap Analysis, Stakeholder analysis, Impact Analysis, SWOT analysis, Feasibility analysis, Risk analysis, modeling Businesses Processes, and preparing Training manuals and Knowledge Transfer manuals.
• In depth Knowledge in Data Warehouse including Data Mart, Dimensional Modeling (Star schemas& Snowflake Schemas), ER (Entity Relationship) Modeling, Normalization, De-Normalization, Logical Model and conceptual model.
• Proactive with excellent interpersonal and communication skills, experienced in working with different personalities, and with developing positive and cooperative working environments.
• Strong problem-solving, team-building, leadership, critical thinking, business acumen, strategic thinking, presentation, negotiation skills and adept at creating, editing, and coordinating extensive communication networks.
• Creative and Enthusiastic Self-Starter.

TECHNICAL SKILLS

Data-Oriented: Erwin, PL/SQL

Universal: VISIO, Irise Studio

Quality Management: JIRA, Mercury Quality Center, Track Wise, VersionOne, RTC, HP ALM/ QualityCenter

Reporting: SSRS, Cognos, MSAccess, Irise Manager, OBIEE, Tableau, Tamarac

Project Management: MS Project, Excel Spreadsheets

Change Management: Bugzilla, Clear Quest, SharePoint, Rational Clear Case

Configuration Management: PVCS, CVS, Clear Case, SharePoint

Testing: SIT, UAT, Unit test, Rational Robot, Rational Test Director, Win Runner, Load Runner and Manual Testing

Requirements Tools: Rational Requisite Pro, Irise Manager

Web Languages: PowerBuilder, CSS, HTML, XML

Languages: C, C++, Java, Visual Basic, J2EE

Databases: Oracle (9i), MS SQL Server, MS Access, ETL Informatica, Teradata, TOAD

PROFESSIONAL EXPERIENCE

Confidential, Pittsburg, PA

Business Analyst

Responsibilities:

• Created functional & technical specifications for an in-house front office trading application whose main products were related to ABS (Asset Backed Securities), CDO (Collateralized debt obligations) and Whole Loan Mortgages.
• Reviewed, implemented, and maintained policies and procedures to ensure compliance with all federal (including FCRA, Fair Lending, OCC, and CFPB) and agency requirements.
• Extensively involved in migrating the fields of financial instruments such as Fixed Income, Derivatives Securitized Products such as MBS on Trading Platform.
• Prepared for GAP Analysis; identified and documented improving areas to meet capital markets requirement regulations.
• Worked with traders on defining compliance requirements for trading MBS, ABS, Bonds and ELNs.
• Analyzed and managed Supply Chain reports, dashboards and performance metrics
• Researched and documented design specifications using various UML diagrams in Visio to support design activities.
• Tested the current Dashboard portal to make it to accommodate Business Process Management and contributed to Implementation Plans.
• Analyzed and tested various processes of Healthcare submission and processing process functionalities including testing the corresponding web services
• Collaborated with business units and delivery teams requesting system changes to clarify business requirements and benefits of changes.
• Provided technical support and coaching to team members.
• Performed requirement gathering and knowledge extraction about the Investment banking and Capital markets using both formal and informal sessions through JAD sessions
• Created test cases and provide testing along with coordinating UAT.
• Constant interaction with Capital Market business users for job shadowing, understanding certain issues which I need to deal with for completing Proof of Concept and BRD.
• Helped with Data Mapping between the data mart and the Source Systems.
• Reviewed data & respond in a timely manner to various, numerous lender & vendor questions/ requests in connection with closing loans and/or ongoing loan covenants; loan document review
• Assisted the principal consultant with Application Rationalization and IT Portfolio Management.
• Worked with mortgage originations, servicing, loss mitigations and loan modifications
• Worked on the new Wealth Management Accelerators (WMA) which will enable private banks and wealth managers to provide a superior digital banking experience.
• Performed periodic searches in the Orchestria System to identify e-mail addresses that could be added to the restricted list or "blacklist"
• Assisted the SR Bank Personal Wealth Management business in updating its various regulatory policies in conjunction with their recent conversion to the Pershing platform
• Worked closely with Mortgage Specialist and Sales Opener to ensure that all information obtained on application is complete, legible and ready for underwriter review.
• Conduct audit trail reviews, trade practice surveillance, market surveillance, and real-time monitoring
• Implement the firm’s global trade surveillance strategy which provides oversight and controls to reduce risk.
• Participated in data modeling, data analysis and requirement documentation. Extensive experience in Financial Service industry related t - Credit Risk, Market Risk, Market Risk, Credit Risk, Liquidity Risk, Basel II/III, CCAR
• Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud
• Executed treasury products as options, swaps, futures, forwards, swaps and debts.
• Thorough knowledge of treasury operations Match Funding, Fund Transfer Pricing, FATCA reporting
• Assist Director of Treasury and Cash Management with corporate credit card maintenance and fraud detection
• Helped document the rational and requirements behind the XML architecture that encompasses data origination, secondary market and servicing data for implementing MISMO standards
• Developed Order validation and Order management web services for order entry web tickets.
• Drew visual workflow diagrams using formal notation such as the Business Process Modeling Notation (BPMN).
• Compiled a performance report for the Wealth Managements primary SIBEL CRM system, which was reviewed by senior management. The report listed new objectives, completed tasks, and a status update on current projects.
• Studied existing KYC/CIP system and prepared test data for CDD and EDD based on inputs.
• Remediation of FATCA tax-related documentation.
• Tested Trade Cycle (Front end) for Equities, Fixed Income, Bonds, Treasuries and Credit Derivatives to verify the alerts at different stages of a trade.
• This module included Online Bill Payments, Transfers, Online Bank Statements & Check Images, email & Wireless Alerts Conducted multiple gap analysis against Basel II, II.5 and III rules. Validated Basel II framework, including internal rating systems (PD, LGD, EAD models) and RWA calculation.
• Used to coordinate between developers and client for debugging of proxy server application using fiddler
• Worked on multiple projects across Billing and Marketing domains.
• Participated in Request for Proposal (RFP) and selection of new systems vendor
• Resolved all the issues pertaining to Point of Sales (POS) and the various transactions made at POS are checked and processed using the Debit Cards and Credit Cards.
• Developed business requirements, GAP analysis, use case diagrams and data flow diagrams.
• Involved in Defect Reporting, Defect Tracking and in Preparation of Defect Report using HPQC.
• Performed User Acceptance Testing of Phase I build of Basel III system.
• Developed wireframes and mock ups using Adobe Dreamweaver for UI Design Teams.
• Wrote SQL queries to understand data relations and variances from other source systems.
• Provided end user support. Created and delivered end user training on application functionality.

Environment: Scrum, Oracle, OBIEE, PL SQL, HP ALM/ QualityCenter, Rational Requisite Pro, Rational ClearCase, SharePoint, Business Objects, Rational ClearQuest, Mercury WinRunner, Microsoft Visio, ERwin3.5.2, JIRA, Java.

Confidential

Business Analyst

Responsibilities:

• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Coordinate the activities of subordinates in the Interface Team and organize weekly status Meetings.
• Facilitated JAD sessions with the clients and assessed the facts of the discussion to not only gain an understanding of the issues but to drive to a solution for Data Retention.
• Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose (UML).
• Actively interacted with different business groups to perform the Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
• Documented existing applications with the creation of UML sequence diagram and class diagram to document.
• Involved in development & documentation of Software Requirements Specification (SRS) using Borland Caliber RM.
• Deeply understood and documented process flows for Credit applications in compliance with PCI-DSS to ensure deletion of cardholder data after the retention period.
• Design wireframes, using Balsamiq, to create innovative web-based workflows for UI Design and submission reports to align with client objectives and adhere to Government section 508 compliance rules.
• Ensured data retention period falls under Escheatment Process of SEC (Securities Exchange Commission), FinCen (Financial Crime Enforcement Network), and OCC (Office of the Comptroller of the Currency).
• Project coordinated the new State Records Center software implementation.
• Perform analysis of records to develop and implement records management programs and procedures
• Performed data and admin duties for the new Secretary of State Records Center software.
• Provide assistance to directorates on records management program to ensure that all offices are adhering to applicable laws and regulations as well as standards, procedures and guidelines from the National Archives and Records Administration.
• Involved in BI reports development efforts by working closely with Micro strategy, Teradata, and ETL teams.
• Designed and Administered Teradata Scripts, Tables, Indices and Database Objects.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in Requisite Pro.
• Generate tables, listings, and graphs using Excel, also used Excel to generate end of day reports for input into OBIEE.
• Prepared Use cases and activity diagrams for a source system using Enterprise Architecture (EA) tool.
• Used MS Visio to design the process flow for data deletion utility for cardholder data which exceeds the data retention period.
• Used BEA (BPM Tool) to map Process flows and migrated Visio Process flows into BEA Tool.
• Detected and documented the defects using Mercury Quality Center.
• Use of data transformation tools such as DTS, SSIS, Informatica or Data Stage.
• Jointly worked with Security Analyst in creating Incident Response Plan.
• Developed test plans in conjunction with team leads and business personnel and performed unit, integration, regression testing.
• Designed management and executive level communications, reports, training material related to technology incidents and a repository for the documentation, diagrammed and wrote a clear process to follow and storage for all documents/diagrams
• Created JIRA Stories, JIRA tickets in the Ticketing System for changes to high-level signature authorities, WIKI pages and RCA Legal/Compliance Review Process
• Execute test scripts, coordinated & conducted UAT testing.
• Worked with the Project Manager in documenting the Project Progress to ensure deliverables.
• Assisted the Project Manager in setting realistic project expectations and evaluating the impact of changes.

Environment: Mercury Quality Center, SSIS, Informatica, OBIEE, SDLC, Oracle, MS Office, MS Project, MS Visio, PL/SQL, Teradata, Teradata SQL assistant, Rational Unified Process (RUP), Rational Suite (RequisitePro, Clear Quest, ClearPro), Windows XP, Java, SSIS, Jira.

Confidential

Business Analyst

Responsibilities:

• Developed custom InfoPath interface to streamline the process workflow for Project Feasibility, Resource Allocation and Capital Assessment of the SWMC billing department
• Worked on Fixed Income, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing.
• Conducted interviews with key business users such as product management teams and SME's to collect requirements and business process information.
• Gathered business requirements through interviews, surveys, and observing from account managers and product management teams and UI (User Interface) of the existing Web Application.
• Designed Replica DB for promoting Database Marketing of Leads across Salesforce CRM.
• Worked on LMS of CRM Sales force for lead generation campaign
• Identified business and functional requirements through JAD sessions, operational evaluation, RFP and proposal.
• Integrated different builds which included different iterations during the Agile process.
• Worked with the scrum agile methodology throughout the SDLC for the implementation of releases at online resources.
• Gathered and identified Business Requirements in DOORS and collaborated with the technical team to define Functional Requirements
• Analyzed data/workflows, defined the scope, and performed GAP analysis
• Incorporated the core modules in Microsoft Dynamics GP particularly The General Ledger for audit control to reduce transaction entry steps and increase accuracy incorporating data directly from one module to another.
• Developed wire frame diagrams for GUI that helps developers to prepare real time easily accessible screen layout. Ensure operational excellence by facilitating backlog grooming, sprint planning, retrospectives, daily scrum, and sprint reviews.
• Involved in creating user stories/tasks and translating them to technical specifications on Github Software. Observed and implemented mortgage originations, servicing, loss mitigations and loan modifications.
• Obtained and verified financial information, such as applicant's credit rating and income level.Analyzed and evaluated applicant's finances to decide if applicant qualifies for a loan.
• Communicated directly with mortgage banker, customers, agents and attorneys to achieve an ideal customer experience
• Engage with stakeholders to gather, consolidate, and analyze requirements for each tool, business process and for the overall Decline Curve Analysis (DCA) application rationalization
• Prepared and reviewed of closing documents for purchases, refinances and construction loans.
• Trade surveillance and post trade analysis to ensure trades are executed and cleared correctly through STP.
• Utilized PL/SQL coding and debugging skills to identify data integrity issues and recommend an optimal solution.
• Utilized SQL*Loader, PL/SQL and Putty to create ETL packages for data uploading and error handling into error tables.
• Implemented of recommendations from Basel Committee on Banking supervision on IT projects for Credit Risk, Operational Risk and Market Risk in line with Basel II
• Carried adjustment in operations of values of Credits, Debits, i.e. CVA/DVA, Fixed income security and credit derivatives.
• Facilitate the setup of North American ABS/MBS securities on the Bloomberg terminal including other asset types such as CMO, CMBS, CLO, RMBS, student loans and other various ABS.
• Completed Project Status Reports & led PMO meetings to update senior management and other stakeholders on progress, issues and deliverables of project.
• Responsible for developing and supporting requirements for service flow of Corporate Actions, Corporate actions response, Currency, Free movement, Mutual Fund Order and execution, Non-financial transactions and trading operational processing in Comerica's global wealth platform.
• Provided coverage for AML compliance monitoring, CIP, KYC and OFAC. Assisted the Internal Audit Analyst for various work-streams within CCAR Audit - e.g. Basel III, Treasury/Liquidity, RWAs, Capital Policy/Planning, and Risk Identification.
• Generate and coordinate client portfolio performance reporting through Tamarac software .
• Worked with Release Management, PMO, Executive Management, along with managers/staff in Development, ETT, UAT, Core Business and other areas, to plan, delivers, and track testing progress.
• Identified different risks such as credit risk (default risk), prepayment risk, inflation risk, and market risk. Project requirements for cash management practices adhered to accounting principles or GAAP.
• Worked with risk management tools for mortgage loan servicing, commercial & residential mortgage, and risk analytics for MBS.
• Conduct surveillance of SEF trades across multiple asset classes (rates/FX/credit/equities /commodities)
• Master Data Management, including on-going data integrity and validation of system changes and enhancements.
• Enhanced revenue and tax reporting by integrating the billing system with the general ledger
• Determine how new rules, regulations or policies affect surveillance activities.
• Tracking down issues and problems faced by customers in existing applications, analyzing them and providing effective solution.
• Generating reports based on common user issues and making modifications in applications to enhance user experiences.
• Reviewed Stored Procedures for reports and wrote test queries against source system (SQL Server) to match results with actual report against Data mart (Oracle).
• Understanding and review of various documents including Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
• Prepared requirement traceability matrices (RTMs) and managed all components of the business requirements.
• Conducted Mortgage relevant training to off-shore teams so future releases are delivered defect free.
• Helped in deployment of portal a venue for the on-line trading application a collaboration bundle solution.
• Worked as a liaison between developers and QA team in creating Test Plan and Test Cases using Rational Test Manager. Generated test data, and assisted QA team with manual testing whenever possible
• Created class diagram, sequence diagram, and collaboration diagram using MS Visio.
• Supported development team in unit testing by providing testing data during User Acceptance Testing (UAT) phase.

Environment: Rational Unified Process (RUP), Rational Suite (RequisitePro, ClearQuest, ClearCase), Tamarac, Jira, MS Visio, Database Marketing, MS Project, Java, J2EE, Oracle, ALM, Mercury Test Director, MS SQL Server, Rational Rose, MS Access, iRise, Business Objects, Tableau, Power Query, Java, C, Hp quality center.

Confidential

Jr Business Analyst

Responsibilities:

• Responsible for identifying and documenting business rules and creating detailed Use Case’s. Created Use cases, Use Case diagrams, Business Flow diagram, Navigational Flow diagrams, creating process models, data flow diagrams, AS IS diagrams and Activity diagrams using Visio.
• Conducted workflow, process diagram and GAP analysis to derive requirements for existing systems
• Enhancements.
• Partner with clients/peers/technical groups to perform quality reviews on business requirements in order to determine if the requirements fulfill the demands of the end users.
• Conducted many informal Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
• Led JRP sessions and JAD sessions with end user community ensuring hat the software addressed all business needs and also conducted Rapid Application Development sessions (RAD).
• Worked closely with the UI/front end design team to model the screens, which met user, defined requirements and also company standards.
• Act as a resource in understanding how IS systems carry out business functions and assist in ensuring the timely and effective implementation.
• Assist with user testing of systems, developing and maintaining quality procedures, and ensure that appropriate documentation is in place. Responsible for all project documentations and end user training materials.
• Performed source data profiling to verify that data meets the business requirements.
• Facilitated Design/Development (technical design) review’s and ensured that business requirements are met.
• Developed system integration test plan and ensured customer acceptance / satisfaction.
• Ability to interact effectively to internal and external parties. Coordinating related support and development activities.
• Worked closely with the project managers to monitor progress, and the deliverables for the project
• Regularly scheduled meetings to review the project status/plan with senior technology staff.
• Responsible for creating a report on a weekly basis, listing committed dates, risks that impact project schedules and status information.
• Responsible for creating a series of reports on a weekly basis about the types and status of STR’s.

Environment: MS Excel, MS Visio, MS Access, SQL Server, Windows XP, MS Outlook, Test Director.