SUMMARY

• More than 8 years of experience working as a Business Analyst in Banking and Financial services sector to grasp the company vision and process flow, a track record of operating in self - organized, cross-functional teams and engaging successfully with key stakeholders and business communities.
• Knowledge of implementing SDLC in all phases of a project and experience working in different forms of SDLC like Agile, Waterfall, Scrum and Scrum-Waterfall (Hybrid).
• Experienced in analyzing methods such as GAP Analysis, SWOT Analysis, Risk Analysis, Impact Analysis, and Business Project Analysis, Process Flow Analysis, Root cause analysis, Document analysis and Cost-benefit Analysis.
• Experience creating detailed lists of reports: domain, platform, frequency, audience, action items, usability, recipient, make recommendations.
• Extensive Experience in Gap analysis to compare As Is with To Be business processes and offered solutions.
• Highly experienced in Designing and review of various documents including the 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.
• In-depth noledge of creating use cases, functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow.
• Experience in interviewing SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Experience facilitating and or participating in routine meetings to review catalog and report materials with various management teams.
• Organized JAD sessions to gather requirements at various stages. Good understanding of project process and ability to analyze business problems and identify solutions. Worked extensively with the team to meet business requirement, create prototypes and analyze workflow.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases.
• Experience testing implemented systems and system changes including liaising with QA teams to develop test cases, test plans, test scenarios, and generating test data and conducting manual testing.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Highly experienced in conducting requirement gathering sessions, feasibility studies and Impact Analysis and organizing the software requirements in a structured way using Rational Requisite Pro to track development.
• Expertise in designing and developing Test Plans and Test Scripts.
• Experience providing report assessments to business or data analysts to create detailed requirements for changes.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project follow the Business Requirements.
• Experience working on AML tools such as Actimize, Mantas and related topics noledge and understanding of fixed-income trading, asset management and portfolio management applications and how they are impacted by the Bank Secrecy Act, USA PATRIOT Act, Dodd Frank Act, Anti-Money Laundering, OFAC and Customer Identification Program, (KYC/CIP), Basel II compliance using industry standards and regulatory guidance, etc. Customer On boarding.
• Extensive noledge of finance domain including but not limited to: Asset Management, Mutual Funds, Bonds, Exchange Traded Funds ETFs, Credit risk management, Credit tracking, credit risk analysis,Trade Life Cycle, Fixed Income, portfolio management, Investment Banking, mortgage initiation, arbitrage, foreign exchange, options, asset allocation,SWIFT,amortizationscheme,Derivativeproducts such as Options and Futures, Sarbanes-Oxley Act, trading systems.
• Strong understanding of Equities and Fixed Income products with respect to Brokerage Operations, Margin trading and Securities Lending.
• Strong Experience on Multi Regulatory Reporting Jurisdictions -CFTC, EMIR, SEC, FATCA.
• Expertise in working with Credit Card and Banking industry, financial institutions, Risk Analysis, Financing structures, Capital management, Portfolio Analysis and Fixed Income.
• Strong noledge of the procedures of Banking & Regulatory Compliance's especially in AML, KYC, CCAR and Basel Accords.
• Experienced in Upgrading existing Credit Cards Vision Plus application by incorporating new functional changes introduced by MasterCard Visa network.
• Hands on experience in performing extensive requirement analysisincluding data analysis and gap analysis.
• Good Experience in Regulatory compliance with LCR and 2052a.
• Understanding of the regulations of the CFTC Swap Dealer and SEC Security Based Swap Dealer.
• Hands on Experience in Global Liquidity Risk Infrastructure (LRI), PPNR, Zero Based Budget, Projection, Prime.
• Experience in preparation of Financial Statements, Financial Audit and Strong noledge in accounting principles in areas like Company Account.
• Knowledge of Liquidity Coverage Ratio (LCR) rules, liquidity stress testing and Regulatory reporting and Reviewed financial statements and analyzed data for Year Fixed Rate (YFH).Expertise in Payment concepts- domestic and International payment systems and processes, ACH, remittance, SWIFT, Wires, Real time payments, Payment Hub.
• Experience in gathering business requirements, functional specifications and writing and executing test scenarios and plans for fixed income products for trading in options.
• Knowledge on CCAR Credit Risk Model validation of retail and commercial portfolio for the Bank's Business lines. Complete model validation - Input data, Methodology, Code implementation, Statistical Test, back testing and reporting.
• Experience analyzing existing reports (traditional, interactive and dashboard formats) for gaps, enhancements, consolidation, replacement or sunsettin.
• In-depth Knowledge on working of Anti Money Laundering, BCBS-239 Risk Reporting, Rule Engine, Retail Banking.
• Experienced in SQL, Access, Excel and internally developed business data and marketing tools, also experienced in UX design & testing.
• Proficient in using version control tools, Team Foundation Server (TFS), GITHUB and agile management tools like JIRA, RALLY.
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Stored Procedures.
• Experienced in extracting UI based information by querying the Oracle database using SQL queries.
• Strong noledge in SQL Server disaster recovery, backup/restore, migration and upgrade participated in disaster recovery drills.
• Experienced working as a Business Analyst in various roles and functions including Use Cases, Supplier Consolidation, Spend Analysis, Gap Analysis, Demand Analysis, Data and BI integration, Data Mapping, Order management, Vendor management, Reporting, Procure to Pay P2P, Project Management, Contract Management, Documentation, Testing, Inventory management, Supply Chain Procurement Metrics.
• Highly Experienced in Microsoft Office Suite including MS Visio, Excel, PowerPoint, HTML, Word and Outlook.
• Worked with defect tracking tools like JIRA, and Quality Center.
• Experience facilitating interviews with and follow-ups with subject matter experts and IT staff to elicit purposes and action items related to reports.

PROFESSIONAL EXPERIENCE

Confidential - Tomball, TX

Sr. Business Analyst

Responsibilities:

• Primarily responsible in collecting requirements for Risk Data Aggregation and Reporting to comply with BCBS-239 regulatory requirements for Wholesale, Capital Markets data for Data quality rules, Measuring and Monitoring for OSI and Critical Risk reporting requirements.
• Worked on editing HTML and designing WebPages in Share Point.
• Acted analyzed KYC data to clarify the attributes, schemas and data structures.
• Worked as a part of the implementation team the role was to understand the existing business process for the Contracts Management System, gather requirements and create documentation for an improved Contract Management process in a system-agnostic manner to be used for Enterprise Content Management for several products.
• Assisting a team of subject matter experts as a liaison between enterprise customers and the engineering staff.
• Functional experience in FX Foreign Exchange processes, related applications based on technologies such asSWIFT. Also involved in applications for trade processing and Fund reconciliation.
• Participated in gathering requirements for the integration of various credit cards functionalities like account boarding, payment processing, collections and write-off.
• Acquired domain noledge on LCR and 2052awith respect toHQLA(High quality liquidity asset).
• Acted with the protocols of Banking and Regulatory Compliances - Anti-Money Laundering (AML), Consumer Identity Program (KYC/CIP), CCAR Regulatory Reporting, Dodd-Frank Act.
• Studied established Trading System to understand the processes and challenges in STP, which halped define project scope.
• Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
• Gathered analyzed and documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Elicited, analyzed, documented and communicated requirements for implementation of the trading system in the Agile Environment.
• Interacted with GAML (Global Anti Money Laundering) and Compliance Office to review the AML (Anti Money Laundering)/BSA (Bank Secrecy Act) requirements and provide Positive Risk Rating system to reduce Money Laundering activities.
• Wrote PL/SQL script to generate payable account data from the API file to transfer advanced PL/SQL scripting to MAINFRAMEORACLE.
• Full understanding of the structured trade life cycle (origination, trade modeling and execution, risk management, hedging, limits, credit risk management, ISDA standards and confirmations, reset processing, settlements, option event management, P&L analysis and reporting, account mapping and sub-ledger requirements, regulatory and compliance reporting).
• Used First Data credit card product Vision Plus modules CMS, TRAMS and it’s to customize GE Money business needs. Worked extensively on Credit Card functionalities.
• Maintained noledge of applicable rules, regulations, policies, laws, and guidelines that impact the finance and contract management process. Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Participated in Data migration into the CI System Knowledge Database in Microsoft Share Point using MS Office software such as MS Access, MS Word, MS Excel, MS PowerPoint, and MS Project.
• Integrated AutomatedClearing House ACH features for the Cash Advance capabilities of Private Label Credit Cards. Using Test Director to screen the illegal flaws posed by the QA and UAT teams before reaching Production, Fault Validation was done.
• Involved in training materials and interface requirements, adhered them to project management methodology.
• Providing reverse sessions to Business Team using Visio, Excel, and HTML Prototypes etc.
• Provided data feeds and followed SLA for other teams within the bank, like Comprehensive Capital Analysis and Review (CCAR) Reporting, Governance, Risk & Compliance (GRC) and Dodd-Frank Regulatory Reporting.
• Studied OTC Derivatives Trade Lifecycle to analyze trading processes and post-trade processing challenges, and recommended system settings to materialize the STP Environment.
• Prepared projections and developed plans to ensure business management functions TEMPeffectively advance the mission of CFTC.
• Collaborated in the implementation of a risk management framework to ensure corporate functions are following the Federal Reserve's Comprehensive Capital Analysis Review (CCAR) regulatory requirements.
• Served as a Supervisory Business Management Specialist for the Commodity Futures Trading Commission (CFTC or Commission) in the Division of Administration, Business Operation Branch.
• Provided input for executing CFTC-wide reconfiguration of strategic, operational, staffing, and program plans to ensure business management functions align to CFTC priorities and resources TEMPeffectively support the achievement of the CFTC mission.
• Reviewing CCAR to Custody Reconciliations Identify the discrepancies and take immediate action to fix the issue. If break is due to an erroneous or missing transaction in CCAR make necessary adjustments.
• Worked with Financial Analysts on Fixed Income Analysis (Pricing, Risk, Yield, Duration, and Recommended Strategy) with Excel to support trading, and reviewed with portfolio manager and traders.
• Managed daily / weekly P&L reporting, analysis, and risk attribution process for the Interest Rate Derivative (IRD) Product Line, in order to identify and resolve P&L issues.
• Implemented and Used SWIFT messaging system to test the flow of messages from and into the new system and was also involved in ETL process.
• ConductedJADsession to explain the implementation of the new process for the Outage Reporting Tool. HTML wire frames for the outage reporting new proposed layouts.
• Applied Iterative/Agile model in each SDLC phases, involved in daily Scrum Calls/Meetings, and incorporated change requests throughout the project lifecycle.
• Analyze and evaluate the financial information obtained from client to devise an appropriate portfolio and investment plan to meeting the client’s financial goals.
• Conducted gap analysis and made As-is-to-be diagrams to understand new business requirements and challenges in implementing new modules.
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
• Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High Level Requirements.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.
• Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
• Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites.
• Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
• Designed and developed Activity Diagrams, and Sequence Diagrams utilizing MS Visio.
• Documented the server farm requirements and requirements related to security within Share Point.
• Rewrite, Add and Define, Rewrite existing requirements, breakout into new requirements, and create additional documentation where appropriate.
• Performed complex SQL queries for retrieving data from the database, generating ad-hoc reports, and conducting data validation testing.
• Interacted with developers to resolves questions and discrepancies in documents, hands-on experience with SQL queries.
• Performed Data mapping, Business Unit mapping, and verified data structure by using SQL queries.
• Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
• Debugged Oracle PL/SQL troubleshooting and fixing bugs in Business Objects Reports.
• Performed Unit Testing and User Acceptance testing and documented detailed results.
• Provided input (scope, goals, risks, constraints, timelines and interfaces) to PM for project planning and control.
• Assisted QA team in developing test strategy, and test cases and actively monitored various types of testing - functional testing, Progression testing, system testing, load testing, smoke testing, and regression testing.
• Managed Requirement Traceability Matrix to ensure test cases are traceable to requirement specifications.
• Actively facilitated complete UAT process - creating UAT schedules, testing guidelines, managing feedback, follow-up, and resolving open issues.

Confidential - Falmouth, ME

Business Analyst

Responsibilities:

• To understand current market needs and difficulties in introducing new modules, I conducted gap analysis and generated As-is-to-be diagrams.
• Worked closely to the new interface program (file path) TEMPhas been introduces for the transactions coming from external (Ex MasterCard/Visa network) source into Vision plus System.
• Worked on loading and writing XML files using a Dataset, Standard Monthly, Weekly and Daily reports were saved as XML files. These XML files were formatted using XSLT files into XHTML for viewing in a web browser.
• Ensured that information obtained is consistent with BSA/AML policy.
• Strategic sourcing procurement specialist, skilled in managing supply chain, vendor contract management, inventory and logistics, audits, coordinating equipment, demand and maintenance scheduling with customer service posture.
• Worked with the procedures of Banking & Regulatory Compliances - Anti-Money Laundering (AML), Customer Identification Program (KYC/CIP), CCAR Regulatory Reporting, Dodd-Frank Act.
• Extensively worked on Contract lifecycle management tool like Oracle Contract Management ranging from establishing corporate contract policies to tracking contract performance.
• Responsible for end to end support for state farm enterprise credit cards product: Visa, MasterCard, Amex and Discover.
• Interviews and follow-ups with subject matter experts and IT personnel to elicit purposes and action items for reports were conducted and facilitated.
• Confirmed that BSA/AML Policy and Procedures and satisfies regulatory requirements were consistent with the information.
• Assisted in the administration and review of Client Risk Scoring, Client Identification and KYC documentation oversight/management requirements.
• Proficient in writing SQL queries for data analysis and validation.
• Coordinate with the Commercial lending group and manage daily credit risk exposures with strong attention detail.
• Verified all aspect of Client Identification Program (CIP) and necessary account opening documents are provided and in accordance with no You're Customer (KYC) and Bank Secretary Act (BSA) standards.
• Involved in analysis of KYC data to understand the attributes, schemas and data structures.
• Support CCAR and BASEL (II) data acquisition teams to validate and reconcile data from various systems.
• Organized weekly Project Status and Task Review meetings, created PowerPoint presentations and project updates using MS Project for management review.
• Interacted with the Client On boarding Risk and Controls team to establish a quality assurance program for Client On boarding to include methodology and sampling methods and ensure compliance with policy and regulatory requirements.
• Prepared payments and financial transactions by verifying and auditing documentation, entering account information into journal entries and requesting disbursements.
• Cooperated with CCAR team on delivering of the Basel capital regulatory results to serve the CCAR various reporting forms.
• Worked on the enhancements of Actimize SAM and WLF module and TEMPhas good noledge of CTR and CDD modules of Actimize.
• Interacted with Actimize team to understand their data requirements and integration of the application with AML processes.
• Organized the project into phases to impose management control using stage-gate reviews such as high-level user stories, test scenarios, Dimension modeling, Client reference data, Data Mapping, ETL etc.
• Created project charter and project plan, presented different solution and time lines with the halp of project manager.
• Created flow chart diagrams using MS-Visio and BPM modeling.
• Created data mapping document for the application after finalizing the attributes and tables with business users
• Identified and communicated dependencies and potential risks to the completion of the project including resources, costs and systems.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate TEMPeffectively with them.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Used Rally tool for requirements management and tracking user stories in a sprint and product backlog.
• Tracking business reporting issues on JIRA by creating problem statements that halp breakdown the underlying issue.
• Involved in maintaining project progress and status through MS Project. Extracted periodic/ monthly status reports to the Project Manager to serve as the team's assessment of the project and its schedule.
• Worked on Traceability Matrix table to uniquely identify and trace the business requirements to general design to testing as to prove that the requirements have been developed into a solution and that it TEMPhas been tested and tracked.
• Interacted with developers to resolves questions and discrepancies in documents, hands-on experience with SQL queries.
• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Business Process Models.
• Supervised and managed project throughout SDLC to ensure that project management methodology based on RUP is followed during the project lifecycle using MS Project.
• Worked both on site and remotely as a team lead, I was involved in the development of business and functional specifications in support of Basel II/ III BCBS239 reporting.
• Developed customized SQL reports and queries for management decision-making and operational management.
• Performed back-end testing on the Oracle database by writing SQL queries and executed SQL scripts for data validations with MIS team.
• Wrote PL/SQL script to extract accounts payable data from API file to send to MAINFRAMEORACLE, advanced PL/SQL programming.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing).
• Assisted with the development of test plans and strategies, coordinated testing events, and executed test cases in support of changes to business systems.
• Participated user acceptance testing cycle; worked withbusinessusers to definebusiness scenarios, user acceptance test cases and user acceptance criteria.

Confidential - San Jose, CA

Business Analyst

Responsibilities:

• Facilitated mortgage loan securitization as liaison between cross-functional departments and vendors.
• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Facilitated meetings with client team to begin process identification and agile project setup.
• Analyzed information and requirements and documented them. Reviewed the Business Requirement document and detailed the Systems Requirement document.
• Translating requirements into User Stories and maintaining necessary User Story meta-data to support overall solution backlog management and prioritization processes.
• Participated in Daily Agile Scrum "Stand-up", Biweekly Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories.
• Conducted JAD sessions with management, SME, users and other stakeholders for open and pending issues.
• Involved in Analyzing, manipulating and updating Database using SQL.
• Worked with SQL queries using MS Access for data manipulations.
• Involved in data governance/ data stewardship business/systems analyst needed to work as part of a team on data governance and writing SQL queries.
• Utilized JIRA to communicate constantly changing functional and design requirements with business users and developers.
• Worked with Senior Business Users in Market &Credit Risk Management, Prime Brokerage, Auditing/Compliance, and Back & Middle Office to prioritize and secure Budgeting for Projects and Day - to-Day Support.
• Acted as a liaison between business users and technical department managing a team of subject matter experts.
• Worked on Development and Support activities like Acquisition, Delivery, Crystallization, Synchronization, and Workflow etc., which involved creating new consolidation rules using formula engine language.
• Facilitated JAD sessions conducting requirement gathering with the Wealth Management heads and managers to gather User Interface Specifications and Business Process Specifications and documented in the Business Requirement document (BRD), Functional Requirement Specification (FRS) for application development.
• Performed requirements gathering from the business users of the system while adhering to SDLC (Software Development Life Cycle) industry best practices.
• Run Daily Outbound Performance Report, and Confirmation's Dodd-Frank Exception Report. This report comprises individual drafting volume across four asset classes (Rates, Equity, Commodities, and Credit Notices).
• Worked on enabling automated transfer by enhancing flexibility, and straight - through processing (STP) of payment initiation, clearing and settlement transactions using ACH, wires, and/or checks by aligning the ISO 20022 XML messaging standard with Automated Clearing House formats (CCD, PPD, CTX) and SWIFT MT standards (MT103, MT202).
• Enhanced procedures and controls throughout the accounting department, processing journal entries and performing accounting corrections to ensure accurate records
• Monitored and re-evaluated deposit accounts to minimize or eliminate risk and fraud.
• Use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MS Project for data migration in to the CI System Knowledge Database in Microsoft Share Point.
• Assisted QA team in executing Test plans and wrote Test Cases.
• Verify various accounts details in various banking mainframe regions using test scripts in Quality Centre& filling defect logs if any.
• Collaborated with quality assurance/quality control to ensure that the final product met all the requirements.
• Cooperated with various teams during the user acceptance testing (UAT) of the final product.

Confidential - New York City, NY

Business Analyst

Responsibilities:

• Involved in all phases of the SDLC, Agile, perform UAT testing. Understand, translate, communicate business requirements into detailed technical system specifications, and develop use cases.
• Obtained business requirements from business users and stakeholders using JAD sessions, brainstorming sessions, focus groups and personal interviews on AGILE/ SCRUM methodology.
• Worked as a void, expansion, consolidation, substitution, or sunsettin analyst for current reports (traditional, digital, and dashboard formats).
• Involved in Creation of Business and Functional Speciation’s in support of Basel II/ III BCBS239 reporting working both directly on site and remotely as a team lead.
• Worked on Methodologies & Governance frameworks for CCAR, ALLL/CECL, Stress Testing and Capital Planning & Regulatory Reporting for Consumer & Commercial Credit portfolios with Fixed Income trading desks.
• Drafted User Stories and Use Cases and Identified User Story points with the Developers and assigned user stories to Sprints in Agile Methodology.
• Worked on converting and documenting business requirements into BRD, User Stories and SRS.
• Used Use Cases, User Stories, Flow Charts, Process maps and Workflows Diagrams to supplement the planning phase.
• Worked with IT team members and stakeholders about requirement changes and updates.
• Reviewed existing functionality of online trading (Stocks & ETF’s), Options (Exchange Traded), MF’s and Bonds) to prepare for ported use of myFi& CPB. Overhauled necessary components and reworked existing processes to increase performance and reliability on par with expected additional volume.
• I performed gap analysis and developed As-is-to-be diagrams to better understand existing business demands and the challenges of adding new modules.
• Handled contract administration process duties to include, end-to-end signature process.
• Was involved in daily risk analysis and analyzed daily trading activity for an interest rate derivative portfolio (IRD).
• Assimilated the Business requirements from myFi, CPB and Benefits Access to formulate their version of Online Trading Application with their own compliances.
• Incorporated Automated Clearing House ACH functionality for the Private Label Credit Cards for Cash Advance abilities. Conducted Defect Validation using Test Director to screen the illegitimate defects raised by the QA and UAT teams before hitting Development.
• Gathered insights on present framework and laid out the client centric application (Presentations).
• Worked on billing system a cash management module and enhanced the encrypting standards that are required for the application.
• Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management.
• Built a “restricted security” tool for the group to allow for RT blocking of specific securities in the case of last minute reorganizing issues.
• Attended interviews and JAD sessions with stakeholders and other key decision makers in order to identify requirements and business-related information.
• Involved in maintaining project progress and status through MS Project. Extracted periodic/ monthly status reports to the Project Manager to serve as the team's assessment of the project and its schedule.
• Worked on Traceability Matrix table to uniquely identify and trace the business requirements to general design to testing as to prove that the requirements have been developed into a solution and that it TEMPhas been tested and tracked.
• Worked on SQL queries to retrieve data from Oracle for white box testing.
• Responsible to extract specific data set from Operation database (ODS) by using PL/SQL query in order to data cleansing process and new feed processing purpose.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Worked with requirement documentation used for Data Extraction, Data Transformation and Loading process as a part of data mapping procedures.
• Assisted Test Lead, Testers understanding business process and halped them for successful completion of Unit Testing, Integration Testing and Requirements Testing.
• Involved in test cases and participated in UAT (User Acceptance Testing).

Confidential, PA

Business Analyst

Responsibilities:

• Interviewed business users to gather business requirements and created Business Requirements document (BRD).
• Participated in noledge transfer meetings and discussions with consumer management and BSA/AMLOfficer.
• Translated the business requirements into functional specification document (FSD).
• Ensured that the business need as defined by the Product Owner are met by the Agile team.
• Conducted several user interviews and/or facilitate group sessions to identify business requirements including decision process needs, information sources, access privileges, and company standards. Also, conducted user story sessions, discuss user stories, capture story points and acceptance criteria.
• Worked withActimizedevelopers to implement their NICE system to our current KYC system.
• Analyzed financial transaction data from multiple data sources including Databases, CRM, flat files to be mapped to the application database.
• Created clear, complete and accurate documentation of user requirements and business process workflows.
• Analyze data and work with the quality control team. Other duties as assigned to assist with the TEMPeffective administration of theAMLand KYC Policies.
• Produce prioritized detailed business requirements for AML Cards, CitiKYC (Inbound and Outbound), CitiCMT etc.
• Created complex SQL query to extract transaction related data from multiple source for data validation.
• Performed data validation testing using SQL queries to validate data. Reviewed the vendor API to reduce stock issues.
• Analyzed data contained by the databases using Structured Query Language (SQL and PL/SQL) and Tableau to confirm data accuracy and integrity of various reports.
• Exposed to SQL queries while churning out relevant information from company's database.
• Working on data mapping for various products inDeposits, Securities, FX and Derivatives.
• Experience in the Payment Process which specifically provides support forDepositsystems that manages, plans.
• Strong understanding of commonmoneylaunderingschemes as well asAMLlegal and regulatory environment, laws, regulations, and guidance under the BSA and the USA PATRIOT Act.
• Monitored suspicious transactions and compiling and reporting associated currency transaction reports (CTRs) and monetary instrument logs (MILs) generated by ActimizeAML.
• Prepared functional requirements to define thesystemrulesby creating Use cases, interface design and data dictionaries.
• Identified and understood relationships among internalsystemsproblems, issues and data.
• Worked with a team of 5 qualityanalyst/testers within Agile Methodology.
• Defined and delivered test strategy, plans, andsystemsscripts.
• Validated different data sources to ensure alignment with the business requirements.
• Conducted through testing to make sure the application is developed as per the business requirements.
• Created UAT test plans and test scenarios & cases.