SUMMARY

• Around 7 years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, and Application Design.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and testing various methodologies.
• Hands - on working experience in Leading Market product such as Charles River and Eagle Pace.
• Strong understanding of banking requirements and regulatory compliances, CCAR Regulatory Reporting, Basel II, Dodd Frank Act, CAT, Bank Secrecy Act, Customer Identification Program (KYC).
• Extensive knowledge about the AML, Patriot Act, BSA, SAR, OFAC, Dodd Frank regulation, procedures and practices.
• Excellent knowledge in Asset Management, Wealth Management, Investment Banking, Derivative products. Such as Options and Futures, Credit Card, Insurance, Bonds, Sarbanes Oxley Act (SOX), GAAP, GAAS, IFRS, CCAR.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence.
• Strong knowledge of the Software Development Life Cycle methodologies (phases and gates) like Agile and Waterfall models.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
• Experience on CCAR, Basel II, Basel III, Dodd-Frank Regulatory Reporting FR Y-14A/Q Monthly, Quarterly, Annual, FRY9-C, RWA, DFA 165, DFA 165E and others required for banks for compliance reporting to various regulatory agencies.
• Expertise in Business Process Management Suite (BPMS), evaluating alternatives, reviewing recommendations with management, proactively managing change In-depth knowledge of Business Modelling methodology and tools such as MS Visio.
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Expertise in interaction with the business users to gather requirements based on the CCAR Regulation for Financial Statements, Basel II, Dodd Frank Act, Bank Secrecy Act, and Customer.
• Online banking application that enables customers to access their checking and savings accounts, and credit card account using the Internet.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

Business Modeling Tools: Rational Rose, Rational Enterprise Suite, MS Visio, Teleological System Architect

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Change Management Tools: Rational Clear Case, Rational ClearQuest

Project Management Tool: MS Project

Analysis / Modeling tools: UML, JAD, RUP, RAD, ETL, Informatica 7.1.1/6.5

Testing Tools: LoadRunner, Test Director, Mercury Quality Centre, JIRA, ALM

Operating Systems: MS Windows NT/98/95/2000, UNIX

Financial Systems: Global Plus FIS, Bloomberg, Charles River Development v18R3/19R1

Databases: Oracle 8i/9i, SQL Server 2000, MDM, Teradata, MS Access

Utility: MS Office Suite Word, Project, Excel, Visio, PowerPoint, Adobe Acrobat Suite

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

Business Data Analyst

Responsibilities:

• Performed data and integration validation from source system (Global Plus FIS) to Charles River Application (CRIMS/CRA)
• Analyzing data by reviewing it and located the code problems while migration of data from Global FIS to CRD
• Data validation on the positions, balance, gains & losses, and tax lot sections on major portfolios manually with FIS
• Performed suggestions on the security list and validate the errors in security types and securities
• Understanding the mapping document of Bloomberg and ICE to CRD and validate the missing field to CRD
• Developed data profiling solutions, run analysis jobs and view results, and create and manage data quality controls using Information Analyzer
• Reported code errors on Head of Household accounts for their taxes, market value and BOD values
• Assisted in the business process re-engineering documentation of the cash trading desk to efficiently integrate into Charles River.
• Work with development, testing and support team on the extracts and the upgrades
• Written test cases for portfolio management and trading section for UAT
• Performed mapping test cases to ALM and integrated with requirements in ALM
• Involved in SIT and UAT on the extracts from mapping perspective as well as data perspective
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Performed functional testing on workbench for equity trading and options trading

Confidential, Pittsburgh, PA

Business Analyst

Responsibilities:

• Created both data sourcing and functional controls according to BCBS 239 Principles.
• Wrote Data sourcing controls whose purpose was to match similar bucket names with different feed names.
• Wrote functional controls that consisted of functional and threshold controls that were conditional based that either the control objective was either met or failed/red flagged given certain buckets. Functional controls consisted of
• Collateral Pool, Mortgage Rating, Mortgage PD, LGD, Guarantor, Lombard, Credit Limit, and Exposure, respectively.
• Threshold controls usually dealt with periodic controls such as monthly and yearly and dealt with within a 2% threshold of difference.
• Located bucket names for all of the above controls in Toad 12.6 RDBMS by running SQL queries.
• Also, utilized Enterprise Architect 12.1 to locate bucket names germane to controls within the WM data model.
• Conducted JAD sessions with other BA’s that were based in Mumbai, London, and Krakow, respectively.
• Co-ordinated Master List of all controls in the pipeline off of SharePoint as per quarterly release.
• All types of controls mentioned above were to be placed in different sections in Zeus Control Tool (“ZCT”) by BCBS Principle viz.
• Accuracy, Consistency, and Completeness. ZCT enabled authorized users to look at different internals of UBS as it pertained to credit risk.
• Was responsible for performing a cash products gap analysis for the UBS front-end trade order entry system called etrader in relation to the Charles River IMS 8.1.4.
• Monitor OTC transaction flow from order management systems to GlobeOp and then into Invesco’s IBOR (Investment Book of Record) platform
• Implementing new strategies, business analysis, management consulting or business performance with wealth/asset managers and SMES
• 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.
• Developed & executed several Optimized queries in SQL on this data.
• Experience in data profiling, checking the data quality for data analyzing and reporting via Power BI, SSRS or Tableau
• Created data governance and privacy policies specifying contract implementation.
• Involved in Compliance of credit risk management and data integrity through regulatory reporting - policies and procedures pertaining to OFAC and BSA.
• Experience in working with MS Dynamics CRM and data integration with Salesforce CRM
• Work with the project teams on implementing the defined business Roles within Access & Identity Management (AIM) solution
• Execute and track security process related activities including User ID management
• Manage operations within the IAM environment at the client, including application patching and upgrades and certificate management
• Worked on Master Data Management (MDM) for maintaining the customer information and also for the ETL rules to be applied.
• Assisted in the business process re-engineering documentation of the cash trading desk to efficiently integrate into Charles River.
• Created and maintained the Business Requirements Document (BRD) while providing walkthroughs for the Line of Business.
• Evaluated Competitors offerings and products including fixed income and derivatives.
• Performed in Credit Analysis, Fixed Income and Fund Investing with an understanding of the wider Financial environment
• Worked with Dev team to understand and review Java code of certain projects.
• Throughout the project, was involved in giving clarifications on domain and product functionality for the team.
• Provide support to Business Units for Large Currency Reporting (LCR), Anti Money Laundering, Atomize KYC, SAS AML, and Suspicious Activity Report (SAR) Filings.

Confidential, Chicago, IL

Business/Data Analyst

Responsibilities:

• Develop BRD and data mapping logic to 14Q line items and Pre-provision Net Revenue (PPNR) configuration in Axiom, validating the data mapping using SQL developer.
• Reviewed and selected Charles River (CRD) OMS/trading software package via IT standardized RFP process.
• Participated in the design of DQ tracking metrics, dashboard and reports
• Worked in Eagle PACE Integration (experience in modules like Message Center, Eagle ML and Eagle Web Panel etc)
• Identify and analyze business problems and defined the scope of activities required to address issues, including requirement definition, logics changes, process review, impact assessment and operational streamlining where necessary
• Involved depth understanding of Credit Risk management for the application.
• Responsible for investigating and explaining business drivers underpinning significant financial movements across B/S, funding and RWA for LOB's, senior management, LEC's, Corporate Reporting.
• Reviewing swap confirmations covering all OTC products such as total return swaps, equity options, structured equity products, convertible bond options, credit defaults, rates and fixed income products
• Main duties included project management of the Active Equities Trading Charles River IMS (v8.2) integration initiative migrated from Macgregor XIP.
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Implemented Analytics & Data requirements for Wealth Management’s metadata management tools.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Involved in preparation of test cases for source to target count testing and other ETL business functional tests.
• Develop, optimize and support Informatica PowerCenter components to provide MDM ETL processes for data extraction, transformations and loading of data
• Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
• Discussed with SMEs across different businesses units to gain solid knowledge of the existing Credit Risk Calculation System and assisted in preparing an advanced Risk Assessment and ROI Management.
• Understanding the fixed income bonds trading and regulatory requirements.
• Performed yield calculations and checking liquidity risk, interest rate risk and exchange rate risk.
• Elicited and mapped securities requirements via Bloomberg to Charles River.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop profitotype and overall system.
• Interacted with Architects, business and other stakeholders and created the Back-End Use Cases for Online Payments project.
• Map business functions underlying data and data models, perform data reconciliations, gap analysis at function and data level for CCAR reporting.
• Create data maps in the FR-Y 9C, 14Q and analyze in detail FR-Y 9C HC-K, 14Q PPNR Schedules to achieve automation process.
• Collaborate with Axiom developers to link data to Federal Reserve Schedule templates.
• Liaise with Axiom team to co-ordinate all aspects of testing, including planning, execution and close out of UAT phases with reporting team.

Confidential, San Francisco, CA

Business Process Analyst

Responsibilities:

• Drove to deliver Statement of Work, High Level Design, Detail Design Document, Systems impact analysis,
• Testing plan reviews, project estimation, solution architecture and continuity of business (COB) setup.
• The system provides enhanced Business Process Management (BPM), new Portfolio Reporting System for High Net worth
• Clients, vendor management and Credit Risk Management.
• Understanding of fixed income bonds trading and regulatory requirements
• Performed calculations in fixed income bonds like yield and exchange rates
• Worked with financial analysts and having good understanding of fixed income bonds, derivatives and their regulatory requirements
• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the PM and technical lead.
• Worked with FAs and RAs to conduct Credit Risk Measurements like calculation of RWA (Risk Weighted Asset).
• Worked throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing agile methodology.
• Conducted a comprehensive use case analysis to determine key abstractions such as loan underwriting, loan-closed, borrowers-info, mortgage-payments etc., and their mapping to the standard analysis mechanism to enable maximum reuse.
• Take line of responsibility for time sensitive disbursement of business critical payments, processing checks and review of incoming and outgoing SWIFT messages (Category 1xx, 2xx, 3xx, 5xx and 9xx)
• Worked on SWIFT Alliance Access SAA, MERVA etc and analyzing the impacts related to SWIFT with MT and MX message types.
• Development of tools designed to improve the accuracy and efficiency of existing accounting processes.
• Interacted with Architects, business and other stakeholders and created the Back-End Use Cases for Online Payments project.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional
• Requirements to Systems Requirements.
• Provided Zendesk Customer service for the clients on tools & service of the financial applications.
• Wrote SQL statements to extract data from the Tables.
• Developed excel models to derive the amortization schedule for Whole loan products and Mortgage Backed Securities.
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Assisted QA team in developing Test Scripts, Test Cases and Test Plans for the User Acceptance testing (UAT).
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Confidential, Buffalo, NY

Business Process Analyst

Responsibilities:

• Involved in client interaction to understand business processes from a data perspective and converting business logic to SQL, PL SQL codes to facilitate reporting.
• Responsible for handling and understanding complex to very complex business logic and writing back-end blocks (procedures/functions/packages) to run in Oracle database.
• Automated recurring reports/works using scripts and macros.
• Design for consistency, performance, maintainability, and reliability for different web application to enhance the security levels
• Responsible for the creation of executive dashboards, business requirement documentation, data mapping, and data cleansing and data governance processes for monthly business reviews.
• Involved with data architects for designing of business area specific schemas service-oriented architecture.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008R2 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained daily and weekly loads of data by creating the corresponding system integration design.
• Enhanced performance of databases using optimization techniques-normalization, Indexing, and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes.
• Supported Application Development team with any database issues, updates or new releases and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.

Confidential

Business Analyst

Responsibilities:

• Facilitated JAD sessions with the stakeholders to elicit the requirements.
• Developed Use case diagrams and relationships of association and composition.
• Developed key Use Cases which has significant impact on architecture of the application.
• Responsible for delivering BRD's, User stories, Use cases and Process diagrams using ARIS and BPMN.
• Worked on the development of non-functional requirements.
• Estimated, Resolved escalated the issues and risks.
• Developed traceability matrix for visibility from FSD, BRD to Test case and defects.
• Validated, categorized and prioritized the requirements.
• Coordinated with the project manager regarding the planning of the releases.
• Worked as a scrum master and facilitated concurrent releases and designed Kanab’s.
• Reviewed Test Strategy, Test Plan and Test Cases documents with the Testing Team and provided my inputs to the team.
• Utilized data to create dashboards and performance matrices for review.
• Reviewed and signed off test cases as a delegate to Application Business Owner.
• Wrote SQL queries to generate ad-hoc reports, validate to maintain data integrity.
• Created multiple SharePoint site collections using the different templates based on the needs, created user guide and trained the business users.
• Worked on time estimations in the See Now Do application for the all phases of the project.
• Involved heavily in the UAT to validate all key scenarios as a delegate to business User.
• Created and published the project status in SharePoint and HP QC for approval process.
• Worked with business, Identity and Access Management (IAM) team for the requirement gathering on user privileges, authentication and authorization policies, single sign-on, access level instructions on IAM.