EXECUTIVE SUMMARY:

• Team player with excellent interpersonal and communication skills. Technically competent and goal oriented with problem solving skills. Excellent team management and leadership skills. Additionally, great presentation skills in regards to communication with both business and technical teams.
• 8+ years of IT experience as a Business Analyst in deployment of web - based, client server applications developing business processes and system solutions for Banking and Financial Industries for various projects from conceptualization.
• Experienced in teh Financial Industry with exposure to Retail Banking, Investment Banking, Capital Markets (Equity, Fix Income, Swap, Fund, Mortgage, MBS, Forward, Future, Option and other Securities).
• Knowledge and exposure working with various regulations and compliance such as; FINRA, FINCEN, PATRIOTIC ACT, BSA, AML and KYC. Designed and implemented solutions pertaining to regulations.
• In depth of noledge of software development life cycle (SDLC), Waterfall, Agile/Scrum methodologies and Rational Unified Process (RUP), as well as data warehouse concepts such as OLTP, OLAP, ETL, Star and Snowflake Schema, data mapping, facts, and dimensions.
• Business requirement gathering from various sponsors and stakeholders by understanding business goals and priorities through research, formal-informal sessions, JAD sessions with teams, stakeholders and end users
• Drafting business requirements and functional requirements in teh form of BRDs, FRDs, and SRSs etc. With great technical detail to support actual implementation of project. Hands-on experience with MS Visio and Use Case diagrams for creating data flow/process flow diagrams such as flowcharts, activity charts, sequence diagrams as per UML.
• Proficiency in designing and reviewing, Expertise in implementing Test Plans, Test cases, Functional testing, Regression Testing and Integration Testing, UAT, as well as maintaining Requirement Traceability Matrices.

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Data Analyst

Responsibilities:

• Studied business needs, identified project stakeholders and their roles, recognized major deliverables and collected business requirements for teh project.
• Worked closed with teh business team, data sourcing team and IT solution team within teh bank to understand teh current business flow.
• Adept at designing business models using UML diagrams - use case, work flow diagrams and data flow diagrams.
• Knowledge of data analysis/modeling, reporting and extracting and analyzing data from various sources.
• Worked on data profiling and analyze data in teh database Oracle server by running SAS queries. Worked on profiling, cleansing & selecting data using excel.
• Studied teh existing KYP/CIP system and prepared teh test data for teh CDD and EDD based on teh inputs.
• Performed top hits analysis to determine noise words dat generating false positive alerts using SAS and Excel
• Identified source of data and provided data mapping documents (ETL) for mapping data from legacy systems to teh centralized KYC system for teh automation rating risk score purpose

Environments: Microsoft Office suites (Word, PowerPoint, Access, Excel Pivot, Outlook), Oracle SAS, JIRA and SQL Server Management Studio

Confidential, NYC

SAM

Responsibilities:

• Working with Nice Actimize team on issues, which have been reported by client.
• Worked on payment frauds by implementing SAM transactions management system to monitor various payments such as Swift/Wire, Faster payments, Debit Transactions, ACH/ Bulk Payments ETC.
• Working on teh various activities involving SAM implementations from IT side (e.g. sizing of currentsystem, hardware recommendations analysis, ETL changes to be made to incorporate teh new
• SAM system, educating IT team on teh various activities involving SAM implementation etc.
• My current engagement also involves teh design recommendation of current system, headingweekly meetings with IT and support team on any Actimize issues.
• Also worked on resolving/ detecting any issues/ failures in teh Actimize job and deep analysis before contacting Actimize support and try resolving any issues dat can be at client end.
• CDD upgrade is another project which me is working as a BA and owner from IT, managing teh activities, documenting teh various design changes to be done etc.
• Configured RCM as per user’s entitlements and authentications.
• Configuration and setting up PEP list for watch list module to screen and monitor costumers who fall under any sanctions,
• Communication and interaction with IT, support and business partners for any AML relatedsupport.
• Training teh IT team on various modules of SAM, CDD and Actimize in general with regards to current system and upcoming SAM-UDM and CDD upgrades.

Environment: Actimize SAM, JIRA, Microsoft Office 2010 (Word, PowerPoint, Access, Excel Pivot and VLOOKUP, Outlook, Project, Visio).

Confidential

Business Analyst

Responsibilities:

• Studied teh need to develop and implement dis project.
• Identified project stakeholders, their roles, identified major deliverables and collected business requirements for teh project.
• Organized teh project into phases to impose management control using stage-gate reviews such as high-level user stories, Business object, test scenarios, Dimension modeling, ETL Data Mapping, etc.
• Devised a work breakdown structure by decomposing teh project deliverables and FRDs.
• Identified resource requirements me.e., business analysts, software developers, testers, etc.
• Developed project schedule by incorporating resource availability and milestones for reporting.
• Prepared communication and information distribution plan for teh project.
• Coordinated development activities across various departments.
• Delivered presentations on prototypes of application to different groups in organization.
• Created wireframes and mockups for teh dashboard improvement project.
• Designed business process flow, data flow diagram, to help ETL team in data migration.
• Provided technical and procedural support for User Acceptance Testing.

Environment:Scrum, Microsoft Office suites (Word, PowerPoint, Project, Visio), MS SQL 2012, Quality Center, ALM5

Confidential, PA

Business Analyst

Responsibilities:

• Analyzed teh Client On-boarding systems of Confidential department, compiled Customer Due Diligence (CDD), Enhanced Due Diligence (EDD), Specialized Due Diligence (SDD) questionnaire and performed data analysis for further updates and development
• Conducted weekly requirement gathering sessions with Compliance, Client On-boarding and Risk Rating Team to understand teh regulatory requirements along with user requirements for teh system.
• Conducted data workshops on required data fields and grouping, and communicated to IT, supporting querying process
• Based on teh workshops, conducted GAP analysis on both teh systems and contributed to risk rating updates by identifying data attributes and supporting ETL process
• Performed business & functional analysis to create evaluation documents, workflow analysis recommendations, detailed system specifications and alternative future state depiction workflows & process diagrams.
• Conducted data mapping exercises and provided data mapping documents between legacy system and new system which was a crucial dependency for migration of teh system.
• Supported firm wide Risk Scoring Methodology periodic reviews and impact analysis by conducting SME and technical meetings and editing documents such as Impact Analysis Reports and Change Management Release Notes
• Served as a consultant on Alert Generation mechanism, SAM module workflow, and Policy Manager usage
• Supported investigation team on AML Alert Generation enhancement review and dashboard reporting using Tableau
• Maintained and created test cases for Subject Matter Expert Testing, NICE Actimize testing and System Integration Testing (SIT).
• Validated functional specification documents at teh workshops and gained sign-off from teh users.
• Worked in hybrid environment with waterfall implemented in initial phase and Agile for development phase.

Environment: MS Visio, MS Project, MS Office Suite (Word, PowerPoint, Access, Excel), MS SharePoint, JIRA, Quality Center, MS SQL Server, Oracle Server, NICE Actimize, Tableau, Spots fire

Confidential, Boston, MA

Business Analyst

Responsibilities:

• Involved in project initiation meetings with Purchase & Sales division and teh middle office teams dat coordinate with broker-to-broker traders.
• Documented teh workflow and activities of teh existing broker-to-broker trade and confirmation process using MS Visio.
• Worked extensively with trade middle office teams to gather teh trade blotter details for various financial instruments and created detailed mapping diagram to link them to teh new system.
• Involved in teh creation of use case scenarios like teh need for teh middle or back office user to view and remark about deviations in trade between brokers.
• Involved in Sprint planning meetings to identify and prioritize product backlogs dat included teh development of Oracle based database for collecting trade information, algorithm to compare internal trade details with teh counter-party trade details.
• Managed teh project flow, backlogs, requirements and test traceability matrix using VersionOne.
• Coordinated with teh development and testing team to conduct white-box testing on teh new application and database systems using HP QC and LoadRunner.
• Involved with middle office and back office teams to conduct UAT test on teh new Purchase & Sales application for broker-to-broker trade confirmation.

Environment: MS Office Suite, MS Visio, IBM Mainframes, VersionOne, HP QC, LoadRunner.

Confidential, Buffalo, NY

Business/data Analyst

Responsibilities:

• Worked as a coordinator between risk management team and IT team to clarify teh expected improvements in datasets/methodologies/approaches, and transfer them into functional requirements and specifications.
• Responsible for business requirement analysis, user stories documentation, data accuracy and quality check, process/approach/model verification and validation, defect management, and System Integration Test (SIT).
• Performed analysis of approaches and models for RWA calculation, as well as to assist in investigation, escalation and resolution of teh data issues.
• Communicated teh stress test process and scenarios to no teh potential influences from any changes located in RWA calculation or PPNR forecast.
• Clarified and documented teh user stories, teh functional and nonfunctional requirements, and created teh diagrams of relevant data flows and processes.
• Facilitated & leaded discussions addressing critical topics throughout teh stress testing process, including enhancements of RWA Calculation and PPNR forecast.
• Collaborated in teh implementation of a risk management framework to ensure teh functions are in compliance with teh Federal Reserve’s Comprehensive Capital Analysis Review (CCAR) regulatory requirements.
• Defined and completed acceptance test plans, test cases and scripts, system performance review report.
• Completed teh System Integration Test (SIT) to verify dat all related systems maintain data integrity and can operate in coordination with other systems in teh same environment.
• Submitted teh performance review report of teh new system to product owner.

Environment Agile Scrum, Microsoft Office 2010 suites (Word, PowerPoint, Project, Visio), MS SQL Quality Center

Jr. Business Analyst

Confidential

Responsibilities:

• Acted as teh Liaison between Line of Businesses (LOBs), Technology Partners (Source Applications) and implementation team.
• Designed trade-related work flow for fixed income trading flow through to teh settlement and accounting systems.
• Conducted JAD sessions with business and other Tech partners.
• Conducted meetings with business to gather teh business requirements, review teh requirements, understood teh system and workflow and converted those requirements into functional requirements.
• Chaired and attended day to day project meetings to discuss teh outcome of implementation processes, testing efforts, time lines etc. Wrote and distributed meeting minutes.
• Communicated teh status of project to different line of businesses and teams.
• Lead teh team in IST Testing, Defect Remediation and Solution Delivery.
• Proactively monitored project, identified scope/requirement changes. Identified project impact and escalated/notified management and project team as necessary.
• Involved in data mapping and data validation and created various data mapping documents.
• FollowedAgileand Scrum methodologies for various project phases
• Functional requirement document’s approval and signoff taken from business and other lines of businesses.
• Lead both on shore and Offshore teams to deliver Business solutions in a timely and efficient Manner.
• Worked closely with development and QA teams to ensure teh understanding of requirements and implementation meets business expectations.
• Acted as a business data analyst, helping analyze and design teh solutions to extract teh data from multiple OLTP systems into staging database, transform and load it into OLAP system.
• Responsible for business requirement collecting and analyzing, data flow clarification, data model documentation, data mapping, and test supporting.
• Gathered Business Requirements by constant interactions with Business Unit leaders, Subject Matter Experts (SMEs), Product Owner (PO), and other stakeholders.
• Analyzed teh functional and nonfunctional requirements, understood teh design and structure of different databases.
• Established teh data flows, and documented teh conceptual/logic/physical data models.
• Completed data mapping to facilitate teh conversion of risk analytic access.
• Wrote SQL data migration scripts and used data manipulating techniques to extract and process data into teh core data warehouse from various data sources.
• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs.