SUMMARY:

• Over 15+ Years of experience as a Business Analyst/Business System Analyst in various domains including Banking Finance, Mortgage, e - Commerce .
• Expert communicator (written, verbal and presentation) involved in high level interaction and influence with variety of audiences (Senior Executives, Clients PMs, developers, SME) as well as PMO.
• Experience analyzing and documenting project scope documents and SOWs, project plan, project/requirement change request forms, BRD, FRD, SDD, requirement traceability matrix, use cases/sequence diagrams, UML, wireframes/mockups, end user documentation and BPM notations.
• Worked extensively with teams for development of Business Rule Engines to support SOA architecture and web services.
• In depth knowledge of the Software Development Life Cycle (SDLC) using Agile and other methodologies such as Rational Unified Process (RUP) and Waterfall.
• Experienced working with Business Intelligence (BI) and Data warehousing tools like Cognos, Hyperion Essbase and Informatica.
• Experience in design, configuration, development and deployment of Business Intelligence applications using OBIEE.
• Proficient in IBM Security Identity and Access Management (IAM).
• In-depth knowledge of Project Management Book of Knowledge (PMBOK).
• Working knowledge in writing SQL query for identifying databases involved in the application development.
• Created defect tracking using HP QC and JIRA and reviewed them in subsequent iterations of the application development process.
• Strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income, Foreign Exchange, Derivative (OTC) & Back-Office operations.
• Knowledge of Mortgage Loan Origination, Servicing, Closing, Loss Mitigation, Loan Modification, Appraisal, Credit, Income and Title functionalities.
• Understanding of investment banking, asset management and other fund management functions.
• Understanding of different mortgage instruments like Mortgage Backed Securities (MBS), Collateralized Mortgage Obligations (CMO), Asset Backed Securities (ABS), including the tranche structuring and credit enhancement processes to manage prepayment and credit risk. Knowledge and understanding of the functions of mortgage agencies like Ginnie Mae, Fannie Mae and Freddie Mac.
• Working knowledge of Amazon Web Services (AWS) and Cloud Data Management.
• Exceptional problem-solving and communication, with in depth understanding of Big Data Application, Databases, Enterprise Architecture and Cloud technologies. Enjoy getting hands-on development experiences.
• Good experience in core PL/SQL development. Implemented pl/sql objects like Stored Procedures, packages, Triggers.
• Extensive experience in developing and enhancing applications for financial processes including Hedge Funds Pricing, Trade and Settlements operations.
• Worked with star and snow flat schemas to create fact and dimension tables.
• Performed ETL and analyze different sources of incoming data and performed various transformations.
• Worked extensively with application programmers to develop proposed solution prototypes.
• Obtained expertise in performing System, Acceptance, Regression, Integration and Functionality Testing.
• Exceptional understanding of the QA life cycle, from test plan, test scripts, issue resolution to User Acceptance (UAT), System Integration (SIT) and end-to-end testing, and Test driven development (TDD).
• Proficient in Creating and Transforming Business Requirements into software requirement specification (SRS) using MS Word and Rational Requisite Pro.

SKILL:

Project Methodologies: RUP, Waterfall, Agile (SCRUM)

Business Modeling Tools: MS Visio, Rational Rose

Requirement Management Tools: Rational Requisite Pro, Caliber RM, Enterprise Architect

Quality Management: DevTrack, Bugzilla, Jira, Quick Test Professional

Defect Tracking Tools: Rational Clear Quest, Quality center

Cloud Technologies: Rational Clear Quest, Quality center

Languages: C#, Java, HTML, .NET, XML

Operating Systems: Windows NT/XP/2000/7

Web dev tools: Dreamweaver, FrontPage

Databases: Oracle 11g, Oracle (8i/9i/10g), SQL Server, MS Access

Tools: MS PROJECT, SQL, HTML, SharePoint, MS Office

BI/ETL Tools: Informatica, SSIS, OBIEE 11g

EXPERIENCE:

Confidential, Boston, MA

Business System Analyst

Responsibilities:

• Assist in the administration and review of Client Risk Scoring, Client Identification, Client Onboarding, identifying Key Risk Indicators(KRI) and KYC documentation oversight/management requirements.
• Led and implemented end-to-end AML KYC process and platform transformation initiative to improve BOW’s AML Customer Due Diligence (CDD), Enhanced Due Diligence (EDD), Customer Risk Profiling processes to comply with OCC consent order requirements and AML regulations.
• Troubleshoot CDD and WLF alert issues working with Actimize and identified and reported trends of fraudulent inquiries to senior management.
• Thorough understanding of various modules of AML including Watch List Filtering, Suspicious Activity Monitoring, CTR, CDD, and EDD.
• Prepare Business & Functional requirement documents for securities reporting application using standard SDLC templates in MS Word.
• Maintain SDLC standards by documenting Project Request Document, Project Planning Document, BRD, FRD, Scope Document, RISK Scorecard, and Planning Phase End Metrics.
• Developed Tableau Data Visualization using Pareto's, Combo charts, Heat Maps, Box and Whisker plots, Scatter plots, Geographic Map, Cross tabs and Histograms.
• Write business requirements document for installation of Actimize AML WLF (Watch List Filtering) and Actimize AML CDD (Customer Due Diligence).
• Study the existing KYC/CIP system and prepared the test data for the CDD/EDD based on the inputs.
• Published and shared dashboards and views on Tableau server.
• Use AML tool Actimize to generate reports through collecting data from various databases to automate the whole process of CTR, transaction monitoring.
• Executed two week iteration and worked with the cross-functional mobile application team to ensure that all the requirements were compliant with overall project goal and scope for mobile and web based products.
• Create High Level Design Document, Test Plan & Test Case Document, UAT testing and Release Plan.
• Conduct full analysis/Investigations on all types of accounts from Low to High Risk countries/clients for client data like Retail and Institutional Clients during the client onboarding.
• KYC Doc review during Client onboarding. Understand risk factors.
• Monitoring and scenario analysis of payment sources/channels and wire transfers.
• SAM Profiling models for transactions. Stand alone and Unusual behavior analysis.
• Define dashboards/DART views in Actimize RCM application.
• Prepare the report publishing frequencies and the media in which it shall be published (SharePoint), also prepare the document for filing frequency and filing format of the SARs, CTRs to the regulatory agencies and internal systems which adhere to AML principles and procedures.
• Study the existing KYC/CIP system and prepared the test data for the CDD/EDD based on the inputs.
• Use JIRA to maintain and update status of each change request, enhancement, production issue and bugs for test results.
• Involve in making appropriate commitments through story selection, sizing and tasking.
• Involve in Scrum Sprint Planning Sessions, Backlog Grooming, Sizing, Sprint Retrospectives & Reviews, Daily Stand ups, User Stories and Acceptance Criteria.
• Create and prioritize the Back Log in JIRA, coordinate Planning Sessions and maintained User Stories and Acceptance Criteria.

Confidential

Responsibilities:

• Conduct Brainstorming and JAD Session to gather Business Requirement s with Regulatory and Compliance subject matter experts to have a good knowledge of Confidential reporting.
• Conduct Gap Analysis of the features and functionality of current platform version and new version to determine the new functions to be added in.
• As part of Confidential , worked on Stress Testing solution to check the health of the portfolio of investments for the client to ascertain Capital adequacy.
• Launch EC2 instances with Linux AMI and bootstrapping with Apache using Bash scripting, using auto-scaling and load balancers (ELB). Also, defined Security Groups depending on access parameters provided.
• Implement and maintain monitors, alarms, and notifications for EC2 instances using CloudWatch and SNS.
• Manage multiple relational databases usingcapita SQL and Amazon Web Services (AWS) (EC2, S3, Redshift) for processing, cleaning, and verifying the integrity of Doubleclick data used for analysis.
• Collaborate with engineering team to standardize analytic methods and improve our analytics pipeline using redshift database and MongoDB.
• Acting as a liaison between business and technology team and communicating on project scope and objectives across the project.
• Create EC2 instance, S3 buckets and gateway parameters for both Windows/ Linux environment as required to upload the Reg report from Lombard platform implemented in production to the Federal Reserve repositories and utilized to update filing processes for Regulatory Reports (FR Y-9C, FFIEC 009/009a).
• Design detailed FRD, and Solution Options Document per BRD and Basel regulatory Requirements using Power Designer.
• Model detailed design of the system using UML diagrams including Sequence Diagrams, Activity Diagrams and Data Flow diagrams using Smart Draw.
• Worked with Risk Reporting team to generate new Standard Pillar 3 Reporting framework and distinguish firm-wide global standards as per unique requirements for US site.
• Extensively involved in Data Governance process. Assisted in data grouping and defined relationship among the different tables.
• Participate in configuration of IHC Reporting System and other in-house reporting software /systems.
• Design and implement basic SQL JOIN queries for QA testing and validate reports generated in Axiom.
• Loaded the data into database tables using SQL*loader from TXT and CSV files.
• Use JIRA to maintain and update status of each change request, enhancement, production issue and bugs for test results.
• Involve in making appropriate commitments through story selection, sizing and tasking.
• Involve in Scrum Sprint Planning Sessions, Backlog Grooming, Sizing, Sprint Retrospectives & Reviews, Daily Stand ups, User Stories and Acceptance Criteria.
• Create and prioritize the Back Log in JIRA, coordinate Planning Sessions and maintained User Stories and Acceptance Criteria.
• Use SharePoint to store, organize, share, and access information from almost any device.

Confidential

Responsibilities:

• Perform business specification (BRD) and data requirements, Use Case models, GUI, use cases, functional specifications and data flow diagrams, ER diagrams, unit testing and beta testing to create a library of financial modeling tools for our applications for the analysis and modeling of derivatives for valuation, pricing and simulation, interest rate risk assessment, cash flow forecasting, intraday quotations from data feeds, contract specifications, trade capture, trading, trade processing and settlement, compliance, risk management as per ISDA and FpML standards/specifications for various trading platforms including Bond trading.
• Provide detailed FpML API specifications of various products on trade submissions for higher volume clients.
• Responsible for Fixed Income and OTC Options part of the project. Involved in the Monte Carlo simulations using market data and to value the trades. Simulated yield curves with different spreads under various scenarios and used these curves to simulate the P/L path.
• Analyze the existing business process flows for Equities and Derivatives to gain understanding of the existing system and documented the business process flows for the proposed system.
• Collaborate with Change Management Group and IT to prepare a detailed derivatives infrastructure for trading for implementing the derivatives trading application - a diagrammatic flow of investment process, trading, data transaction between application, pricing and analytics, database, data feeds and back office integration (trade confirmations, processing, settlement, collateral management, market data), portfolio valuation including bond rating and accounting.
• Perform detailed research analysis & prepared a diagrammatic investment and trading process for derivatives instruments including CDS, CDS Index, CDS Options, Equity Swaps, Interest Rate Swaps, and Exotic Options.
• Coordinate with various data feeds (Reuters, Bloomberg, Markit) for market data, data, counterparty data, and credit data; mapped them to the oracle database for credit derivatives pricing, corporate bonds, municipal bonds and analytics.
• Involved in the trade submission to ICE, CME from MarkitSERV for clearing through MarkitWire APIs avoiding clients to build to multiple bespoke CCP interfaces.
• Analyze systems and data to identify functionality gaps for front end module, Trade Worksheet and Back office Module for various CDS and asset management platforms which includes fixed income, annuity, mutual funds and bonds.
• Involve in manual trade data reconciliations, analyzing the chart of accounts, tracking the GL transactions and validating them from their mainframe systems. Work closely with the business users to build the models and delivered based on the sign-off.

Confidential, NYC, NY

Business Analyst/Data Analyst

Responsibilities:

• Performed business specification (BRD) and data requirements, use case models, GUI, use cases, functional specifications and data flow diagrams, ER diagrams, unit testing and beta testing to create a library of financial modeling tools for our applications for the analysis and modeling of derivatives for valuation, pricing and simulation, interest rate risk assessment, cash flow forecasting, intraday quotations from data feeds, contract specifications, trade capture, trading, trade processing and settlement, compliance, risk management as per ISDA and FpML standards/specifications for various trading platforms including Bond trading.
• Provided detailed FpML API specifications of various products on trade submissions for higher volume clients.
• Responsible for Fixed Income and OTC Options part of the project. Involved in the Monte Carlo simulations using market data and to value the trades. Simulated yield curves with different spreads under various scenarios and used these curves to simulate the P/L path.
• Analyzed the existing business process flows for Equities and Derivatives to gain understanding of the existing system and documented the business process flows for the proposed system.
• Business flows documented contained information flowing from upstream applications to the downstream applications and any impact made using GUI by the users.
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications.
• Used Scaled Agile Framework to describe the working progress of the project.
• Collaborated with Change Management Group and IT to prepare a detailed derivatives infrastructure for trading for implementing the derivatives trading application - a diagrammatic flow of investment process, trading, data transaction between application, pricing and analytics, database, data feeds and back office integration (trade confirmations, processing, settlement, collateral management, market data), portfolio valuation including bond rating and accounting.
• Made detailed research analysis & prepared a diagrammatic investment and trading process for derivatives instruments including CDS, CDS Index, CDS Options, Equity Swaps, Interest Rate Swaps, and Exotic Options.
• Coordinated with various data feeds (Reuters, Bloomberg, Markit) for market data, data, counterparty data, and credit data; mapped them to the oracle database for credit derivatives pricing, corporate bonds, municipal bonds and analytics.
• Involved in the trade submission to ICE, CME from MarkitSERV for clearing through MarkitWire APIs avoiding clients to build to multiple bespoke CCP interfaces.
• Performed detailed analysis and work - flow diagrams for derivatives trading which included - preparation of market & data, analysis & decision support, modeling a contract, preliminary instrument setup on the application.
• Created tables, views, joins and store procedures to meet client requirements.
• Analyzed systems and data to identify functionality gaps for front end module, Trade Worksheet and Back office Module for various CDS and asset management platforms which includes fixed income, annuity, mutual funds and bonds.
• Involved in manual trade data reconciliations, analyzing the chart of accounts, tracking the GL transactions and validating them from their mainframe systems.
• Worked closely with the business users to build the models and delivered based on the sign-off.

Confidential, Greenwood Village, CO

Business Analyst

Responsibilities:

• Designed application components in an AGILE environment utilizing a test driven development (TDD) approach.
• Created and maintained project tasks and schedules.
• Performed data profiling in the source systems that are required for New Customer Engagement (NCE) Data mart.
• Manipulated, cleansed & processed data using Excel, Access and SQL.
• Responsible for loading, extracting and validation of client data.
• Analyzed raw data and developed recommendations.
• Wrote SQL scripts to manipulate data for data loads and extracts.
• Involved in defining the source to target data mappings, business rules, business, and data definitions. Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents (FRD) for each source to target interface.
• Coordinated with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Documented data quality and traceability documents for each source interface.
• Worked with internal architects, data warehouse developers by assisting in the development of current and target state data architectures.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Also worked on some impact of low quality and/or missing data on the performance of data warehouse client. Identified design flaws in the data warehouse.
• Worked on customizing Repository and configure metadata objects (Subject Area Table Column) and Web Catalog Objects such as Dashboards, Pages, Folders, and Reports.
• Worked with BI/ETL developers to perform Data Modeling (Physical & Logical), Data Analysis and wrote High level and Low level Design Specifications for ETL and Business Intelligence (BI).

Confidential, Foot Hill Ranch, CA

Business Analyst

Responsibilities:

• Worked as a business analyst to build Strategy Web application for financial statements and inspections.
• Identify, research, investigate, analyze, define and document business processes.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML and Business Process Modeling.
• Conducted user interviews, gathered requirements, analyzed the requirements using Rational Rose requisite pro - RUP.
• Documented functional specifications to automate the loan approval process for home Mortgage (online application, workflow - for the credit department, upon approval the system routes the application to the underwriters for review).
• Acquired in-depth knowledge of the banking industry (Mortgage, Assets, and Accounts Receivables/Accounts Payables).
• Gathered business requirements through interviews, surveys and observing from account managers and UI (User Interface) of the existing Brokerage Portal system.
• Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Involved in testing all the data elements in Mortgage Account Inquiry Service, which is called to obtain Mortgage loan data from MSP.
• Worked on mapping of MSP Web services to Enterprise Interface Partners and coordinated with FIS on MSP.
• Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Developed timelines for project delivery and managed projects and resources to successful completion.
• Liaison for projects with other corporate departments, including Executive, Legal and Information Services as well as vendor relationships.
• Assisted in development of materials for new technology and process improvements.
• Participated in developing of Materials for the new technology and User .
• Worked effectively with Project Manager in handling the whole project.

Environment: SDLC, RUP Methodology, Rational Clear Quest, UML, Oracle, MS Project and MS Office

Confidential, Jacksonville, Florida

Associate / Team Manager

Responsibilities:

• Manage and oversee settlement services to ensure smooth and efficient workflow.
• Requirements gathering, documentation and analysis using appropriate tools and techniques by identifying and solving complex business facing problems and help to drive the necessary resulting change.
• Partnering with functional groups to produce process mapping in complete end to end business view and following analysis, produce recommendations for improvements in terms of efficiency and control.
• Engage with key stakeholders to facilitate workshops and provide data to these sessions to enable fact based conclusions to be drawn.
• Consolidate all above aspects into a concise business case with clear identification of issues, required actions, costs and benefits.
• Working with core team from the business, agree defined action plan with owners and dates and follow through to delivery.
• Ensuring all key stakeholders understand project milestones, risks and issues.
• UAT - supporting test script development and execution.
• Working with IT, Finance, and the business to ensure a Front to Back deliver.
• Responsible for the team dealing with defining and documenting industry best practices for trade settlement of all bond, equity and derivative trades and Emerging Markets.
• Responsible for staff, implementing controls and ensuring adherence to all procedures.
• Provide career related guidance to sub-ordinates, responsible for identification and recruitment.
• Attend industry meetings/ seminars to keep abreast of industry developments whilst maintaining an understanding of the impact regulatory change (EMIR/ Dodd-Frank) will have on Operations.

Confidential

Senior Business Analyst

Responsibilities:

• Project Manager/Business Analyst for business requirements for a fixed income/derivative front-to-back implementation project. Business requirements involved primary elicitation from the client’s Derivatives and Treasury team, writing of use cases, authoring BRDs and gaining approval of deliverables from the business users.
• Prepare and generate MIS Reports on daily/monthly basis with a view to apprise top management of the routine Trade Lifecycle Management business operations and assist in critical decision making process.
• Support the Pre and Post settlement process for Confidential Bank’s client base across all regions involving the Trade Transaction Lifecycle Management for Investment Banking Products - Asset Back Securities (ABS), Credit Default Swaps (CDS), Total Return Swaps (TRS), Cross Currency Swaps, Interest Rate Swaps (IRS).
• Identify reconciliation issues and provide resolutions through interaction with Trader, Marketer, Middle Office, Static Data & Clients.
• Use Bloomberg to investigate obligations and securities for calculating accruals on the trades.
• Assist Senior Management on feedback of Team members for Year End Performance Management objectives review.

Confidential

Business Analyst

Responsibilities:

• Business Analyst in the Front/Back Office support group. The desk trades in Interest Rate Swaps, Swaptions, Caps, FRAs, Bonds and Credit Derivatives.
• Manage a team of five business analysts to work closely with the Front/Middle/Back and Risk users to identify issues, gather requirements and then prioritize the tasks for the development team to design and deliver projects and ensure efficient functioning of the desk.
• Coordinate activities with numerous groups in the bank during project implementations.
• Manage the requirements gathering, design, development and delivery of XML based trade message generation from trading systems. These messages are now consumed by various systems in the Bank.