We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

Cincinnati, OhiO

SUMMARY

  • Over 8+ years as Senior Business Analyst for banking projects holding Domain knowledge across areas including Retail/ Consumer banking, Corporate banking, Regulatory and Compliance projects including but not limited to FINRA, BSA/AML, and AML/KYC.
  • Extensively experience in Finance industry, Credit Card, Investment Banking (GL, Personal Accounts, Check payment, ATM, Fraud - AML) and Mortgage industries.
  • Proficient in financial and middle office accounting systems for securities trading, investment and retail banking with extensive hands on work with products such as Princeton Asset Management (PAM, RKS, ePAM), Eagle Star Investment Accounting and Temenos.
  • Expertise in digital Payment concepts- domestic and International payment systems and processes, ACH, remittance, SWIFT, Wires, Real time payments, Payment Hub
  • Extensive experience onLegacy Wires, GB Wires, Legacy ACH, Global ACH.
  • Experience inRequirementsModellingby creating Business Process Model Notation BPMN, Use-Case models, User Stories, AS-IS, TO-BE process models, Entity Relationship Diagrams and Activity Diagrams.
  • Extensive experience on different types of Wires and ACH transfers and be able to triage the defects that are identified during the testing process, including providing root cause analysis.
  • Extensive knowledge and experience inAnti - Money Laundering (AML)/KYCandOperation Risk Managementin the large Investment Banks and Finance Companies.
  • Experience and knowledge in usingData Modeling Toolsand various otherBusiness Intelligence toolslikeTABLEAU, MS Visio, Lucid chart, UML, SSRS, SSIS, SSAS, MySQL,etc.
  • Worked extensively on the various data centered activities like Dataprofiling, Data mining, data migration, data modeling and the data quality/ assurance.
  • Knowledge of client-server and web based applications, strong database design (SQL) and modeling experience with project management skills with PHP.
  • Experienced in banking sectors such asPayment Processing (Automated Clearing House,credit networks,wire transfers),General Ledgermaster accounts,Fixed Assetinvoices,Cash Balancemanagement,Cash Flow Analysis,Intraday Liquidity.
  • Experienced in the Investment Banking Industry, Project Finance, Credit Card Industry, Mortgage Loan Origination, Loan Servicing, Treasury Services ACH, Wire Transfers etc.,
  • Worked with creating databases and structuring of Big Data on servers SQL and Sybase and in applications, using data generated from live and static feeds in a variety of formats
  • Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
  • Expertise in Banking & Regulatory Compliance's especially in AML, KYC and Basel Accords.
  • Experience in the evaluation and implementation of industry-standard enterprise-wide information security technologies and concepts, including Data Loss Prevention, Security Event Management, GRC Tools, Threat and Vulnerability Management, Identity and Access Management, Application Security, Computer Forensics.
  • Strong experience in creatingTest plans, Test cases and Test scenariosforvalidating business requirementsduringUser Acceptance Testing (UAT) as well as technical requirements
  • Extensive Knowledge inCapitalMarkets, Corporate Finance, Risk Management, Investment Banking, Mortgage, Financial Statement Analysis, Equity, Fixed Income, Alternative Investments, Derivatives, M&A, IPO etc.
  • Experience in Software Development Life Cycle (SDLC) process, Software Testing Life Cycle (STLC) and Product Development life cycle including Waterfall, Scrum/Agile, and QA methodologies.
  • Worked in Financial Services Industry in diverseCapitalMarketsdomains in areas such as Fixed Income, Financial reporting usingBusinessObjects and Spreadsheets.
  • Expertise in creating various project documents like BRD, FRD, Data mapping, data definition document, Data migration related documents, Test Plan, Test case, UAT Document etc.
  • Extensive experience working with XML, Schema Designing and XML data.
  • Expertise in retail banking sectors including lending, deposits, payments, cards, trade finance, treasury, regulatory reporting (BI), KYC, AML, payment system.
  • Expertise in preparingbusinessrequirementsdocument (BRD), functional andtechnicalspecifications, systems design andrequirementsspecifications.
  • Experience in Design 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.
  • Extensive skills in Unified Modeling Language (UML)Diagramslike Class,Activity/ State, Sequence, ERdiagramsusing Rational Rose and Microsoft Visio. Developing Use Casediagrams, Sequencediagramsand Classdiagrams,activitydiagram, swim-lanediagram, developmentdiagram, integrationdiagram, Using QC, MySQL, MS Project and prototyping tools.
  • Experience in Data transformation, Data Mapping from source to target database schemas, Data Cleansing procedures
  • Proficient in creating Risk Analysis documents, Risk Management Plan, User Requirement Specification, Functional Requirement Specification and Business Process Flows.
  • Excellent understanding of Database management system, Data warehousing concepts, Business Intelligence technologies and Data mining.
  • Experience in creating, writing, and executing Test Cases, Test Scripts from Business User Requirement documents and Functional Design Documents.
  • Experience in converting legacy reports to more contemporary programs such as Crystal Reports, Business Objects, MS Excel, MS Access, and SQL, and condensing number of reports to simplify processes

TECHNICAL SKILLS

Enterprise: Microsoft SharePoint Server 2010, Microsoft Office Project Portfolio Server 2010, EMC Documentum, InterAction, Perregrine Service Center, Remedy, StarTeam, HP Service Manager 7.0, HP Quality Center

BusinessModeling Tools: UML Modeling using Rational Rose, UML, MS Visio, Balsamiq, Axure

SDLC Methodologies: Waterfall, Agile-scrum, Waterfall-scrum, RUP, Scale-Agile

QA Test Tools: Mercury Interactive Suite Test Director 8.0, Quality Center, Test Director, Quality Center

Business Skills: Requirement, Defect and Project Management Tools Atlassian JIRA, HP ALM QC, MS SharePoint Server, Confluence, MS ProjectChange Management, Impact Analysis, RAD, JAD Sessions, Data analysis, SWOT analysis, Cost benefit analysis, Gap Analysis, ROI Analysis

Requirement Management: Rational Requisite Pro, MS Word, JIRA, Rational Doors, HP ALM V 11, QC

Project Management Tools: MS Project, SharePoint

Database: Microsoft SQL Server 2008, Oracle 11g, Microsoft Access 2010

Productivity: Microsoft Office Professional 2010, Microsoft Lync 2010, Microsoft Project 2010, Microsoft Visio 2010 SAPECC, SRM, HCM, NetWeaver, Business Objects

Desktop: Microsoft Windows 7, Windows XP, VMWare VDI Workstations, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential -Cincinnati, Ohio

Sr. Business Analyst

Environment: MS Office Suite, MS Visio, Windows, PL/SQL,JSON, SDLC, Flat Files, XML,Agile,Linux, Ubuntu, SQL Developer, UNIX, JIRA, Confluence, SQL Scripts, Visual Studio 2008 and 2012, MSSQL 2005 and 2008

Responsibilities:

  • Created and designed wireframes and mock-up screens using Balsamiq mockups, designed UML diagrams like use case, activity and sequence diagrams using Lucid chart.
  • Responsible of creating the Meta data mapping forAnti money laundering (AML)under their financial crime & compliance program andknow your customer (KYC).
  • Worked as Business analyst with the projects in developing ACH, EFT, Credit card, and Debit card processing applications.
  • Create variousflow diagramsusingMS VISIOforfuture state analysis,ABOR IBOR reconciliation,ABOR Excess Returns,Active Equityand for otherTarget Operating Model(TOM) to define the flow of data on both happy and unhappy scenario from source to end user.
  • Created TO-BE process model of the new application being developed by using BPMN diagrams and Use-Cases
  • Created workflows forTBAmortgage trading and fixed issues with collateral.
  • Interacted directly withBusinessUsers and created technicalblueprintfor the whole project.
  • Created sequence/processflows, and use cases documenting functional (FRDs) and system requirements (SRDs) allowing development team to start development phase ahead of schedule
  • Responsible for providing sensitive credit data to the business readiness team, to support data migration from legacy to target systems.
  • Work with the developer in the team inportfolio level data mappingusing unique security related entities likeCUSIP,ISIN, andTKRto compare data from various data sources likeABOR data source,Neoxam,Aladdinand integrate all data into oneSecurity Reference Master(SRM)Hub.
  • Responsible for ensuring smooth delivery of regular executive business AML/KYC presentations/reports and the final outputs for ad-hoc projects KYC enhancements to the onboarding process in conjunction the understanding and supporting the frontline user and customer experience.
  • 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
  • Interacted directly with stakeholders to identify and evaluate improvement opportunities and explained issues.
  • Drive various internal strategic initiatives regarding new and existingcapitalmarkets
  • Identified, assessed, and documented business requirements, recommended business priorities, and advised business on options, risks, and costs.
  • Involved in surveillance of Wire, checks, ACH, World Check and adhoc request from FIU (Financial Investigation Unit)
  • Worked various data migration initiatives likeapplication data migration, reporting data migration
  • Interacted with the Subject Matter Expert (SME), Stakeholders and Elicited business requirements for product change requests, enhancements participate in requirements prioritization.
  • Creating wireframes using Lucid Charts, Visio, Powerpoint
  • Documented functional specifications for multiple components for achieving the ability to send and receive currency or cash via various Electronic Funds Transfer System (EFT) such as CHIPS and ACH
  • Documented requirements in Confluence and user stories in JIRA
  • Followed AGILE Scrum methodology throughout the project and used Rational Rose, Visio and Requisite pro - RUP to analyze the requirements
  • Involved in Analysis Model that includes entity classes, use casediagrams, sequencediagrams that provide the development team a view of the requirements for Construction phaseactivity.
  • Tracked and communicated user stories, bugs, issues, and tasks to the development team using JIRA.
  • GeneratedBusinessRequirementdocuments(BRD), Functional Specificationdesigndocuments(FSD) and Functional RequirementDocuments(FRD).
  • Researched data issues and identify the root cause in source systems, data warehouse and data marts using various data analysis techniques, data profiling and data mining activities.
  • Responsible for providing analysis of products and initiatives with respect to data requirements, data flows, data modeling, workflow context and design.
  • Created detailed Use cases,BPMN flows,Functional Specifications, UML diagrams to remove ambiguity of the requirements communicated by clients or SMEs.
  • Performed requirements modeling and developed Analysis Diagrams, Activity Diagrams, Sequence Diagrams, and State Diagrams, Data Models, and Use-Case relationships using RUP tools in Agile Methodology.
  • Created use casediagramusing UMLactivitydiagramfor online credit card transaction system.
  • CreatedBusinessRequirements Documents, Functional and Software Requirements Specification.
  • Involved with the Software Quality Assurance (SQA) Team to develop Test plans.
  • Involvedin Enterprise reporting system to support Risk Analysis, Securities and their Valuation, Asset Management, risks and returns, Bond Pricing, MBS, ABS, Derivatives (repos, interest rateswaps),
  • CreatedTechnical, Functional &Businessrequirementsdocumentation Developed User Stories and Use Case documentation Organized all teams to coordinate on projectrequirements
  • Responsible for the full data life cycle from gathering business requirements, upstream data feed analysis, data mapping and resolving data quality issues
  • Conducted extensive analysis of KYC data to understand the attributes, schemas and data structures.
  • Analyzed data to detect deficiency in transaction components that indicate a potential for fraud and/or money laundering activity.
  • Used Visio to create business processes, business flow diagrams and work flow diagrams for Commercial Lending & Securities Lending process
  • Used SQL, SSMS and SSIS, Sybase, Excel VBA, Access VBA and Microsoft Applications Excel, Access and Word to design, develop and deploy software applications, including the Comprehensive Credit Analysis and Review CCAR application.
  • Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports, Checklists, Job Aids, Test Readiness Review Documents,Test Summary Reports.
  • Designed and developed Informatica Mappings and Sessions, Workflows based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
  • Extensively used SQL queries to retrieve data from Oracle database using PL/SQL developer and Sybase. Tested and modified PL/SQL Packages, Stored procedures and functions.
  • Utilised the knowledge of SDLC (Software Development Life Cycle) and development practices (ranging from traditional to Agile) while deploying projects.
  • Responded resourcefully to fraud indicators to resolve conflicts between allegations and facts.
  • Created the XML control files to upload the data into Data warehousing system.
  • Proficient in using databases and analytics, developing macros in MS excel and VBA for data mining and visualization.
  • Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance
  • Translated requirements documentation into UAT test plans, designed "production-like" test case coverage and test data, and performed manual system testing to validate all requirements are met.
  • Conducted Integration Testing, Upgrade Testing, and Certification testing and supported the Production Releases.
  • Worked closely with the Dev team and assist them in producing a quality code.
  • Attended install task plan meeting for UAT.
  • Assisted with risk assessment, mitigation and re-planning efforts when necessary.
  • Ensured that all test cases are updated with any corrections.

Confidential, New York, NY

Business Analyst

Environment: Windows NT/XP, PL/SQL, Flat Files, XML,Oracle, SQL, SQL Server, RUP, VBScript, CRM, SharePoint, SDLC, JIRA, Unix, DB2, Adobe Photoshop, UNIX, JSON, Agile, HP Quality Center, agile, VISIO,JIRA, Confluence, Business Objects.

Responsibilities:

  • Responsible for Leading the Business Process Reengineering effort and for the SRS (Software Requirements specifications) documentation of the build out of the FWA dashboard and for client reporting.
  • Designed and developed Use CaseDiagrams,ActivityDiagrams, SequenceDiagrams, ClassDiagramsand web page mock-ups using MS Visio.
  • Involved in planning, identification, creation and execution of detailed Test Plans, Test cases and Test Suites for Functional Testing using MS-Word and MS Excel.
  • Use TOAD to run SQL queries from Eagle PACE (data warehouse) for research and provide adhoc reports to fund administration, fund accounting, compliance and clients.
  • Research and resolve reporting issue, securities reference issues in the Eagle STAR/Eagle PACE system.
  • Worked onElectronic Bank Statement (EBS), Positive pay, ACH paymentsandWire Transfer,liquidity forecastandconfiguringandcustomizing multiple payment methodsandautomatic clearing.
  • Provided detailed documentation of the due diligence performed. Other duties as assigned to assist with effective administration of the AML/KYC Policies.
  • Created BPMN modeling diagrams detailing functional business requirements and specific interface needs including developing improvements to existing processes to deliver improved business performance;
  • Tracing requirements throughout the developmentprocessand verifying adherence using the Requirements Traceability Matrix (RTM).
  • Worked extensively with SMEs in understanding and documenting their requirements pertaining to Loan Origination, ARM, Escrow Analysis, ACH based Accounts, maintaining and analyzing customers Accounting books and many other business Areas.
  • Gathered primary input/output requirements and modeled the processes in wire frame using MS Visio in web redesign process incapitalmarketfor international payment in security and user access control.
  • Extensively involved in Risk analysis, Securities and their valuation, Asset Management (risks and returns), Asset Allocations, Bond pricing, Financial Derivatives, Cash flows, financing structure, Portfolio Analysis, etc.
  • Analyzed the business requirements of the project by studying the Business Requirements Specification document & AML Rules.
  • Execute processes and postings of related to vendor maintenance, manual checks, ACH/Wire payments, and stop payments.
  • Ability to analyze data in legacy applications to determine data migration/integration complexity, to identify data gaps against new requirements or conflicts across multiple legacy applications.
  • Designed wireframes and mockup screens Balsamiq and designed UML diagrams like Use case, Activity Diagrams, and Sequence Diagrams using Lucid chart.
  • Participate in internal meetings as well as with vendor, quality assurance and IT department to review current issues, upgrades, and enhancement within the Eagle Star mutual fund accounting system.
  • Used SQL Queries, ensuring various data table entries, data integrity and data validity.
  • Performed conceptual and logical data modeling and created Entity Relationship (ER) diagrams.
  • Designed Use Case diagrams,Blueprints, Activity diagrams, and Process flows
  • Extensively involved in System testing, User Acceptance Testing
  • Kept all testing requirements, test cases in Test Director and executed all test cases from Test Director.
  • Documented the entire testing process, test cases and test results.
  • Proficient in creating Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams. Designed Use Cases and UML models using MS Visio and Lucid Charts.
  • Collaborated with theCapitalMarketbusinessclients to clarify and prioritize their current and future needs.
  • Designed BO reports to present the data broken down by the countries regulatory office and to highlight any suspicious activity that needs to be acted upon to prevent money laundering (AML) and fraud.
  • Executed requirements, use cases and iterative/incremental project and requirements management to their projects in the context of the SDLC.
  • Conducted JAD sessions, workshops and brainstorming with SMEs andagileteam for project updates & involved in the weekly meetings to discuss the status of the current project.
  • Defining test cases, creating test scripts, analyzing bugs, interacting with QA/development teams in fixing errors, and performed UAT using JIRA.
  • Created/maintained project schedule using MS Project showing all of the deliverables' target dates.
  • Involved in process analysis and data analysis using SQL and Excel involving the product attributes of Broker Dealer products like Delayed Delivery,
  • Analyzing plain PL/SQL and APEX based software programs and applications.
  • Defined data requirements and elements used in XML transactions.
  • Used SSIS to automate ETL processes for manipulation of large volumes of data between SQL and Sybase
  • Created Business Requirement documents (BRD's), such as SRS & FRS and integrated the requirements and underlying platform functionality.
  • Customized Requirement Management, Requirement Traceability,Issue Tracking,Defect Management, User story Managementand Work Allocation using Project management toolJIRAand collaborative toolConfluence
  • Designed and modified SQL Queries, Stored Procedures, Triggers, etc., to extract data from SQL/Sybase database directly into Excel reports
  • Evaluated, documented business, functional requirements, asset protection (loss prevention/safety), prepared use cases, sequence diagrams and class diagrams with Rational Rose.
  • Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
  • Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
  • Evaluate existingprocessesto understand problems and collect data to perform root cause analysis; create processflow-charts and diagrams using Microsoft Visio software.
  • Involved in Data Mapping, Data Transformation and Cleansing rules for the Master Data Management Architecture involved OLTP, ODS and OLAP.
  • Worked extensively on NORKOM, the enhanced Anti - Money Laundering (AML) analysis and risk detection/management system, which enables to fight crime and create reports on the flagged transactions.
  • Used Agile Method for daily scrum to discuss the project related information.
  • Involved in Data mapping, logical Real time data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
  • Responsible for creating Use Cases, Business Process Modeling and Work Flow Diagrams using MS Visio and MS Excel Performed the requirement analysis and documented the requirements.
  • Configured the Data mapping between Oracle and SQL Server 2005.
  • Identified customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
  • Created use case scenarios and documented work flow and business process using Rational Rose

Confidential, Boston, MA

Business Systems Analyst

Environment: Oracle 8x/9i, Asp. Net, SQL,Agile, Jira, TFS, Rally, DOORS, PL/SQL, UNIX, Flat Files, MS Project, MS Office Suite, Agile,RUP, UML, Clear Case 2002, XML, Confluence, PHP,Rational Clear Quest 2002, MS office suite 2003, MS Visio 2003

Responsibilities:

  • Involved in all phases of software development life cycle (SDLC) in RUP framework.
  • Performed and documented GAP analysis, ROI analysis and Cost benefit analysis
  • Analyzed and collected business requirements, identified system interfaces and created the requirements specification document.
  • Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
  • Analyzed Fidelity Investmentsbusinessprocesses and related systems forAMLwhile collaborating with Risk and Legal groups to ensure product design and configuration was consistent with compliance program goals.
  • Experienced with the procedures of Banking & Regulatory Compliances - Anti-Money Laundering (AML), Customer Identification Program (KYC/CIP), CCAR Regulatory Reporting, Dodd-Frank Act.
  • Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
  • Created business process workflow diagrams using Business Process Modeling Notation (BPMN)
  • Identified and shaped the analysis strategy at a crucial time for ACH payment services product by mapping the middleware and external vendor services to UI design for online and Mobile Banking.
  • Interviewed Subject Matter Experts, communicated business requirements and addressed development issues to meet project deadlines.
  • Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle.
  • Created input data files in XML to validate various scenarios.
  • Involved in creating ACH Files for multiple origination accounts CTX, Child Support, PPD, CCD, Payroll and Tax Payment (CCD).
  • Evaluates wire transfers and other payments for potential fraud, money laundering, patterns and inconsistencies.
  • Exported test cases from excel to Mercury Quality Center using the MS Excel Add in.
  • Involved in all phases of Software development life cycle (SDLC) usingAgileScrum methodology.
  • FollowedAgile, methodology for project execution, and used Storyboards as one of the requirements elicitation technique.
  • Wrote data mapping documents, data transformation rules and maintaining data dictionary, data migration and interface requirements documents.
  • Assisted QA lead in developing high leveltest scenarios, test cases, test plansand documentedrequirement traceability matrixto track thetest coverageassociated to business requirements using Confluence.
  • Modified/created Balance Sheet Report summary and detailed analysis, Intraday Report, Overnight Report and other financial reports using T-SQL scripts, VBA, SQL/Sybase and Excel
  • Gathered data and functional requirements from subject matter experts in Field Operations, Accounting and Loss Prevention in order to design and implement system enhancements that increase quality of workflow, response time and controls.
  • Provided feedback to AML analysts with respect to the quality of case escalations, trends and issues, or best practices in order to assist in the development of the alert analysis process.
  • Assisted in batch execution using Unix Shell script and execution of SQL procedures.
  • Analyzed data quality and procedures, and production support for a small ad agency. Data mapping.
  • Business Requirements Document (BRD), Functional Requirements document (FRD) and System Requirements Specification (SRS)
  • Construct complex pricing models and competitive pricing analysis in MS Excel and other pricing tools
  • Applied Unified Modeling Language (UML) methodologies to design Communication Diagram, Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
  • Extensively interacted with both user group and development team.
  • Performed GAP analysis to identify source and target data and KYC information and documented them in Business rules
  • Performed data analysis and validation of AML/KYC data on eFront.
  • Analyzed clients' business requirements and processes through workshops, workflow analysis, stakeholder interviews and user stories.
  • Worked with the QA team for validatingTest PlanandTest CasesforIntegration testing, Regression Testing, Whitebox Testing, black Box Testing, Smoke Testingand assisted in facilitatingUser Acceptance Testing (UAT)
  • Gatheredtechnicalrequirements, working withbusinesscontinuity testing, assisting with technicaltesting and troubleshooting in relation software/personal computer interfacing.
  • CreatedBusinessprocessflowsand dataflowsto supplementBusinessrequirements.
  • 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 rateswaps, swap options, credit defaultswapsand total returnswaps) and portfolio allocation and management.
  • Gained expertise in requirement management and profiling stakeholders usingBlueprintsrequirement management tool.
  • PreparedRequirements Traceability Metrics (RTM), positive and negative test scenarios, detailed orientedTest Scripts, Test Kickoff documents, Test Scorecardfor test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
  • Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
  • Incorporated the best practice methodologies as advocated by the Rational Unified Process.
  • Designed and analyzed Business Process Model, Use Case model and test procedures based on RUP methodology.
  • Developed Use Cases, Activity Diagrams and Sequence Diagrams and other UML diagrams for a clear understanding of the project vision by using VISIO and Lucid charts.
  • Provided detailed documentation of the due diligence performed. Other duties as assigned to assist with effective administration of the AML/KYC Policies.
  • Tested Complex ETL Mappings and transformations from source flat files to target tables.
  • Maintaining all data in Jira tool related to test cases and bug tracking.
  • Involved in writing SQL query to create Views, Triggers, in PL/SQL as per functionality.
  • Wrote user requirements specification (URS) and Functional requirements specification (FRS) Documents as per the Business requirements and process flow.
  • Designed and developed project templates based on SDLC Methodology
  • Developed UML Use Cases for the application and prepared the detailed Work flow diagram based on the proposed enhancement for the system.
  • Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on daily basis.

Confidential, Dallas, TX

Business Systems Analyst

Environment: Excel, Oracle, SQL, Agile, SDLC, Confluence,PHP, JIRA, Business Objects, PL/SQL,XML, Flat Files, Informatica, Agile,Power Point, MS Project 2003, MS Word and MS Visio.

Responsibilities:

  • Analyzed business requirements and segregated them into Use Cases and activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
  • Assisted in the calibration and validation of Mantas AML scenarios and behaviour detection logic.
  • Led Business Analysis and Functional Specification areas to plan and execute various consent order projects, ensuring adherence to regulatory requirements (AML, KYC, Dodd-Frank, etc.).
  • Created test data required for a release which involved modifying xml files that contain appraisal data.
  • 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.
  • Designed ETL mapping documents, various mappings with Transformation rules and complex mappings including Slowly Changing Dimensions.
  • Performed extensive UAT and Regression testing on KYC module of eFront for defects and enhancement of the risk management system.
  • Performed Data Count Validation, Data Analysis, and Data Quality Validation in Data Migration
  • Involved with the Business user communityInventory Control,Retail store,Online store,and Loss Preventionto elicit requirements and identify the basic need of the users.
  • Reviewed and analyzed Suspicious Activity Reports (SAR) narratives completed by AML investigators.
  • Performed AML functions on an on-going basis, including detection / reporting of suspicious transactions and activities; conduct reviews for the enhancement of the AML functions, and perform AML risk assessment when required.
  • Performed Anti Money Laundering investigations including transaction monitoring reviews for alerted accounts.
  • Created and maintained Requirements Traceability Matrix (RTM) to trace technical requirements to theirbusinessrequirements and the test case requirements to their functional requirements.
  • Extracted the business requirements for the end users keeping in mind their need for the application and developed the BRDs
  • Analyzed Review & propose enhancements for Web Creative deliverables, ensuring adaptability of the UI to CBOL guidelines, identify potential fraud scenarios & traceability back to Requirements.
  • Involved in Data mapping of contribution files from multiple clients to in house database. Developed Meta data.
  • Executed developer requests to create new database and database objects in Sybase, Oracle and SQL Server.
  • Collaborate with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs.
  • Capture of Functional Requirements and delivery of Functional Requirements Specification.
  • Capture of User Interface Requirements and delivery of User Interface Requirements Document.
  • Used Quality Center/Test Director for requirement management, test planning, scheduling, executing test cases, managing and tracking defects.
  • Worked on linking Edge with customer payments via. ACH, over-the-counter check deposits, Wire Payments, Lockbox transactions, check reconciliations etc.
  • Analyzed client data, documentation and negative news in order to determine client risk profile as established under the global KYC procedures.
  • Developed several activity and sequence diagrams with swim lanes and UML components to show entity relationship diagrams (ERD)usingLucid chart and Microsoft Visiofor the developers and data architects, helping them to gain a clear and precise understanding of the system requirements and visualize the system functionalities.
  • Translated all the business requirements in discovery phase to business process modeling using UML. Also used activity diagrams and process flow.
  • Involved in SWIFT messaging transformation for transactions processing/used Omgeo ALERT as the web-based platform. SDLC process implementation of defects/testing
  • Effectively used tools like SQL developer, putty for Unix, Clear case for version management, HP Quality Center for requirements, test planning and defect tracking.
  • UsedTest Case distributionandtrend reportsto track the progress of test case planning, implementation and execution results. PerformedSmoke Testingto evaluate builds
  • Coordinated the development of the UAT test scripts, UAT test scenarios and Master Test Plan and successfully lead the User Acceptance Testing (UAT) effort
  • Develop Test Plans, Test Cases and Traceability Matrices from functional requirements (FRDs or User Stories).
  • Captured the high-level requirements inConfluenceandJIRAto trace epics and user stories.
  • Have developedbusinessprocessmodelsfrom interviews with end-users further Created Flow Charts andProcessFlow diagrams, Use Case Diagrams, Class Diagrams, Activity Diagrams / State Chart Diagrams usingBPMN, Microsoft Visio and Rational Rose according to UML methodology thus defining the DataProcessModels.
  • Participated in meetings with various Fraud Vendors and asked appropriate questions based on the business requirements for Fraud.
  • Co-operated with Data Base Administrators (DBA) in Data Base Testing using SQL
  • Various versions of the documents generated during the project were maintained and managed using Rational ClearCase.
  • Captured Business Features and delivery of Business Requirements Document.
  • Captured Reporting Requirements and delivery of Reporting Requirements Document.
  • Created test scripts for all the test cases in PL/SQL.
  • Analyzed business requirements and segregated them into high level and low level Use Cases, Activity and Sequence using Rational Rose according to UML methodology.
  • Derived Functional Requirement Specifications based on User Requirement Specification. Understand and articulate business requirements from user interviews and then convert requirements into technical specifications.

Confidential, Charlotte, NC

Business Analyst

Environment: Rational Suite, SQL, Agile, MS Office Suite, JIRA,MS Visio, XML, SDLC,PL/SQL, Flat Files, JSON, Windows XP/2000, Dream Weaver, CRM, SQL, PLSQL, XML, VB, ASP, Crystal Reports

Responsibilities:

  • Facilitated various JAD sessions with development architects and business leads to develop both high-level and detailed application architecture to meet business needs
  • Involved in all phases of Software development life cycle (SDLC) usingAgileScrum methodology. Conducted and participated in sprint planning meeting
  • Worked with AML SME’s provided direction and guidance to employees on appropriate remediation action for high risk accounts.
  • Extensively researched and collected the customer financial documentations and completed research for suspicious activity reports on KYC, AML, and BA analysis reports for flagged accounts.
  • Responsible for the successful planning and execution of projects supporting cash management activities such as information reporting, controlled disbursements, wire transfer, ACH, internal transfer, check management, stop payment, imaging, and special reporting.
  • Translated business concepts into XML vocabularies by designing XML Schemas with UML
  • Created Vision & Scope document,BusinessRequirements Document (BRD), Functional Requirements Document (FRD), and Software Requirements Specification (SRS)by using various modeling standards/techniques including UML,BusinessProcessModelandNotation(BPMN)
  • Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
  • Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and store users for Requirement gathering in Definition Stage.
  • PreparedBusinessRequirement document (BRD), Requirement traceability matrix (RTM).
  • Gathered requirements, organized team meetings requirements from business users such as insurance policy managers, generated business process models, & use-case models, and created business requirements document (BRD) & functional requirements document (FRD).
  • Conducted research, analysis and provide qualitative/quantitative insights to lead and direct projects and initiatives to meet the Firm's AML/KYC Standards.
  • Worked with Relationship Managers to understand the client and to correctly assess the client's AML Risk Rating.
  • Effectively collaborated with senior compliance officers, AML colleagues, relationship managers, and other departments to ensure all facets of remediation project were completed on a timely basis.
  • Responsible for loading, extracting and transformation of client data from excel to MySQL
  • Analyzed, documented and managed requirements and changes to requirements usingBluePrint. Developed and maintained Requirement Traceability Matrix (RTM)
  • Wrote various SQL programs to run automation (PL/SQL) and reduce network traffic and challenge database performance
  • Extensive risk management experience conducting fraud and risk investigations for financial institutions and payment processing organizations
  • Compile and evaluate loan data, document findings, and perform regulatory compliance reviews
  • Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software.
  • Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, and data dictionary and data analysis.
  • Builtuse cases,activity diagram,sequence diagramsand collaboration diagrams that include functional and non-functional specifications to convey to the development teams adopting usingLucid Chart.
  • Created and maintained Narrative Use Cases (BusinessUse Cases, System Use Cases) and modeled Use Case Diagrams, Activity Diagrams, Data Flow Diagrams using MS Visio.
  • Analyzed the existingprocess, workflowand dataflowanalysis.
  • Work with region and country AML Compliance employee to support start-up of compliance-projects at regional and country levels.
  • Including defining the subsequent phases training, UAT, staff to perform test scripts, data migration and the uplift strategy (updating of customer information to bring them to the new KYC standards) review of customer documentation.
  • Performed Real time business process research/analysis/modeling and data mapping and modeling
  • Worked extensively with the QA team for designing and validating Test plans and Test cases for SAWS system for the User Acceptance Testing.
  • Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
  • Allocated task and tracked issues usingJIRAand used it to manage tasks and details related to the user stories
  • Created and modified complex Excel VBA scripts that interfaced directly with complex Sybase/SQL scripts
  • Worked with majorbusinessareas including customer service,escrowand reserve administration, collateral inspection and monitoring, purchase acquisitions.
  • Responsible for gathering requirements from Business Users. Responsible for creating the Functional Design and Test Plans, writing SQL queries to be embedded in the Java Code, the enhancements of the Database Design and perform testing during system test phase
  • Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
  • Identified Use Cases from the requirements. Created Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, and Sequence Diagrams, based on UML Methodology using Rational Rose and MS Visio.
  • Managed requirement specifications by using IBM DOORS, and provided guidance to the product feature teams by reviewing deliverables and resolve subject matter issues during the delivery of requirements.
  • Extensive work on financial instruments such as Bonds, Equities, Futures, Options, SWAP, Securities, Trades,CapitalMarketsand AML regulations to determine pertinence and consequence on functionality of the implemented system.
  • FacilitatedJADsession follow-up for Project Plan updates, gained consensus forUATrequirements
  • Assisted in the development of quality assurance artifacts including: Quality Assurance Plan, Test Plan and Test Case.
  • Create Business Requirements for new projects, enhancements, and defects through User Stories and Acceptance Criteria.
  • Worked collaboratively with the User Group, User Experience Analysts, and System Analysts to help document custom and system modifications.
  • Developed Traceability Matrix for maintaining/updating current and new system requirements using MS Excel.

Hire Now