SUMMARY

• 8+ years of experience as a Business Analyst wif solid understanding of Business Requirements Gathering, Data Analysis, Data Mapping, Data integration and Business Analysis.
• Diverse experience in procedures of Banking, Financial Services, Investment Banking & Regulatory Compliances - Anti-Money Laundering (AML), Customer Identification Program (KYC/CIP).
• Strong understanding of Capital Markets, Fixed Income, Equities, Risk Management, Mutual Funds, mortgage products, Collateralized Assets, Loan Processing Applications and Portfolio Management.
• Experience in performing Gap Analysis to check teh compatibility of teh existing system infrastructure wif teh new business requirements using AS-IS and TO-BE business process tools.
• Extensive experience in gathering, managing and documenting business and functional requirements and communicating effectively wif stakeholders, developers and QA testers.
• Expert in Business Process Modeling, Data Flow Modeling, Work Flow Analysis, Use Case Analysis, ER Diagrams, GAP analysis, SWOT analysis, Cost benefit analysis and ROI analysis
• Extensive experience in importing, managing and tagging requirement documents, and designing project deliverables (Traceability Matrix) usingvarious tools.
• Good noledge of broad range of technologies, including business process tools such as Microsoft Project, MS Access, MS Visio, MS excel and technical assessment tools.
• Expertise in business analysis skills and experience in working in SDLC for Various methodologies including RUP, Agile, Scrum/XP and Waterfall.
• Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, interviews, brainstorming and joint application development (JAD) sessions.
• Proficient in creating Sequence Diagrams, Activity Diagrams and Class Diagrams.
• Very strong presentation and written/verbal communication skills. Ability to work under pressure and meet deadlines.
• Hard working, positive thinking, self-starter wif a strong goal orientation.
• Excellent meetings facilitator wif good inter-personal and conflict resolving skills.
• Proven success as a business analyst through teh years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
• Effective in working wif business stakeholders, VP’s, MD’s, Support Managers off-site and on-site, Senior Project Managers, Project Managers, Solution Architects.

TECHNICAL SKILLS:

• Rational Requisite Pro
• Rational Rose
• MS-Visio
• Rational Clear Quest
• Rational Clear Case
• Assembly
• Basic XML
• Mantas AML. AML Research Tools: LexisNexis
• Factiva
• World-Check
• Subversion (SVN)
• Microsoft Access MS SQL Server 2012/2008R 2/2008/2005/2000
• MS SQL Server 2008/2005 MS SQL Server Integration Service (SSIS)
• MS SQL Server Reporting Services (SSRS)
• Microsoft Office Suite 2007
• Word
• Excel
• PowerPoint
• Outlook
• Microsoft Project
• Erwin
• Web sphere
• Active directory.

PROFESSIONAL EXPERIENCE:

Confidential, CT

Sr Business Analyst

Responsibilities:

• To develop and maintain strategic relationship wif business partners, while understanding their needs, associated wif IT solutions and requirements.
• Analyze complex business problems and provide expertise in identifying, evaluating and developing solutions that are cost effective, while complementing business processes and consider data quality requirements.
• Collect and document business, functional and user requirements such as leading workshops, regulatory reporting, Cashflows, writing use cases, creating context diagrams, performing stakeholder analysis, Approval, and Inventory Management etc.
• Collaborate regularly wif other Business Analysts on cross-functional requests and solutions. While coordinating and working wif international treasury, banking and securities, payment and cash management projects.
• Experienced in Data analysis andbusiness intelligence skills
• Supports Project Managers in planning, execution and management of project tasks and risks. Conduct month-end transactions, reconciled bank accounts, Audit Reporting, and recorded quarterly loan transactions.
• Participated in Business Data Analysis and design wif teh Data Analyst in defining data sources and required data content for teh data warehouse component.
• Implemented Agile SDLC methodology and involved in project management. Worked on Scrum Methodology as well as on SDLC procedures in teh implementation of Spotfire
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Teradata.
• Worked wif teh Retail Deposits AML team, Risk/Fraud, business management to ensure prompt remediation of any identified deficiencies.
• Experienced in Data warehousing and Business Intelligence in analysis, design, development, testing and implementation of teh reporting and ETL components.
• Assisted in development of Test Plans and assisted QA team in System testing to ensure teh new system satisfy all User requirements.
• Develop and maintain project plans for reporting purposes.
• Conduct walk-throughs wif teh end users and stakeholders to gather teh modification requests from teh user to upgrade or change teh business specifications for teh product.
• Facilitate JAD sessions to allow different stakeholders to communicate their perspectives wif each other, resolve any issues and come to an agreement quickly.
• Conduct FRS and walk-throughs wif teh designers, developers and stakeholders.
• Use FrontPage templates to create an entire site and has achieved uniform and consistent formats for all teh web pages.
• Understanding teh Business Logic, User Requirements and Test-Objectives to develop test plans, test cases, and test case execution using Test Director.
• Perform all kinds of testing including regression, system, integration, end to end, functional, back end, and front end testing.
• Conduct UAT (User Acceptance Testing) to make sure that all teh user requirements were catered by teh application.
• Use SharePoint to ensure all team members has easy access to all teh documents created.
• Assist Project Manager in using MS project to track teh budget/ Cost tracking.

Environment: Rational RequisitePro and UML, Spotfire,AML Research Tools: LexisNexis, Factiva, World-Check ORACLE SQL, Microsoft Visio, MS SharePoint, Citrix XenApp, MS Project, MS Excel, MS Access, MS SQL server 2012, WebCash, Workbench, JIRA, workflows, MS Server Integration services, SSRS.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Implemented Agile SDLC methodology and involved in project management
• Gatheird relevant Business Requirements and acted on behalf of Product Owner.
• Prepared storyboards in MS Word and MS PowerPoint for better visualization of teh application.
• Created business requirement document, functional (FRS) and technical specifications for teh system.
• Applied Unified Modeling Language (UML) methodology to create use case diagrams and sequence diagrams in Rational Rose.
• Expert in BI (Business Intelligence) Skills. T-SQL design and tune T-SQL to interface teh data analysis and other applications in most efficient manner.
• Defined frameworks for Operational data system (ODS), master data (index data, prices, identifiers, and yields), Central file distribution (CFD) and Data Quality (DQ) and created functional data requirement (FDR) and Master Test Strategy documents.
• Used data analysis techniques to validate business rules and identify low quality missing data in teh existing Amgen enterprise data warehouse (EDW). Dataanalyst for thedatawarehouse component.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on teh fly.
• JIRA (Ticket) tracks and communicates status and issues wif tech team.
• Designed and deployed reports wif Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Tableau/Spotfire.
• Resolved issues and improvised teh process to ensure a stable and accurate solution.
• Worked to create structure in Access Database.
• Collaborated wif financial services as part of support for teh application.
• Validated business rules and all artifacts wif users, approval and sign off.
• Provided technical and business noledge to clients.
• Interacted wif teh architects, developers on business and technical issues, helping in designing of teh system; and testers to ensure all requirements were correctly translated.
• Worked wif teh team on security features: web, encryption, autantication and SSO possibilities.
• Updated and modified progress and resources allocation in MS project for teh team. .
• Suggested process and product improvements for teh application.
• Created test plans, scripts and facilitated UAT.
• Performed manual front-end testing to check all functionalities of different modules.
• Ensured that teh application met user and management expectations.

Environment: SQL Server 2008R2, ORACLE SQL, Rational Rose, Rational Requisite Pro, JIRA,Test Director, Rational Suite, MS Visio, MS Project, MS Access

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Performed teh Requirement Analysis and documented teh requirements for Regulatory reporting using Requisite Pro.
• Gained consensus for business requirements being fully met.
• Created Business Requirement document and Functional Requirement document using MS Visio and Word.
• Conducted research on incoming user requirements/modifications and suggested improvements for teh second release of teh application.
• Closely interacted wif designers and software developers to understand application functionality, navigational flow and updated them about end-user sentiments.
• Performed Risk Analysis of teh requirements to identify key business risk areas for project and prioritized application development and testing.
• Experienced in Data Modeling wif expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin
• Produced teh visual models for teh system using Rational Rose to create Use Cases, State Charts, Sequence Diagrams, and Activity Diagrams.
• Proactively identified opportunities and made recommendations to improve teh system’s effectiveness via data mining and analysis to understand user interactions wif system and to scope out opportunities to enhance user engagement and satisfaction.
• Facilitated weekly meetings wif teh review teams to continuously improve teh QA process.
• Conducted walkthroughs wif teh end-users and stakeholders to gather teh modification requests from teh user to upgrade or change teh business specifications for teh product.
• Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed.
• Analyzed system requirements, developed detailed Test Plan, Test Cases and test scripts for testing teh functionality, GUI and security.
• Interacted closely wif UAT Team to no their needs and problems.
• Helped in designing and implementing deployment process, and maintaining teh application in post deployment process.

Environment: Windows NT 4.0, Visual Basic, MS Visio, MS Office, XML, Oracle 8i, Test Director, Win Runner, Load Runner

Confidential, Boston, MA

Business Analyst/Data Analyst

Responsibilities:

• Reviewed activity reports to ensure that personnel achieve sales quotas, processes claims promptly and credit collections to policyholder' accounts
• Conducted user interviews and JAD sessions wif end users, stake holders and developers to gather functional and non-functional requirements of teh system, and creation of user stories
• Implemented ACORD for reinsurance industry standards worked in teh RUP environment for teh elicitation, representation of requirements and in change management.
• Assessed teh flaws in teh existing as-is system and made clear recommendations of business process improvements and BPR, and incorporated them in teh to-be system design.
• Analyzed teh as-is and to-be systems to perform GAP Analysis and make recommendation for system enhancement.
• Executed data mapping documentation.
• Wrote business requirement specification (BRS) and functional requirement specification (FRS) documents as per teh business requirements and process flow.
• Developed UML Use Case diagrams for faster and more efficient communication wif stakeholders, by utilizing MS Visio.
• Made sure current project requirements were being met by using Requirement Traceability Matrix (RTM)
• Actively involved in creation of teh UML diagrams such as sequence, activity and class diagrams for certain modules of teh application using MS Visio and Rational Rose.
• Used Rational ClearQuest for all types of change requests, including defects, enhancements, issues and documentation changes wif a flexible workflow process.
• Assisted and directly involved wif QA team in creation of Test Cases and tests implementations.
• Presented and assisted end users for education and training about teh new system.

Environment: RUP, Rational Requisite Pro, MS-Visio, Rational ClearQuest, JIRA, Base Clear case, Java, Oracle, DB2, MS Project, MS Office Suite, Erwin

Confidential, Cleveland, OH

Business Analyst

Responsibilities:

• Acted as a liaison between technology and teh business clients to improve business processes and support critical business strategies.
• Facilitated JAD sessions for defining business requirements and follow-up for Project Plan updates.
• Worked extensively in Rational Requisite Pro to organize and catalog requirements.
• Gained consensus for business requirements being fully met and attainable technical development expectations. Created Business Requirement document and Functional Requirement document using MS Visio and Word.
• Performed research on incoming user requirements/modifications and suggested improvements for teh second release of teh application.
• CreatedDataFlow Diagrams, Use Cases and business process flowcharts on which teh actual system architecture would be based.
• Performed XML, SWIFT Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Assisted teh development team in teh source to target mapping for ETL design.
• Performed Dataextraction,DataMigration andDataconversion using ETL tools from application front-end wif Oracle databases anddatawarehouse.
• Proactivelyidentified opportunities and made recommendations to improve teh system’s effectiveness viadatamining and analysis to understand user interactions wif system and to scope out opportunities to increase user engagement and satisfaction.
• Responsible for verifying ofdataintegration/migration from various distributors systems into theDataWarehouse environment and maintaining Repository.
• Worked closely wif teh QATeam to review and enhance teh TestPlan and Test Cases.
• Reviewed development plans, quality assurance test plans, and user documentation to ensure correct interpretation of original specifications.
• Worked wif teh test team in Identifying and creating TestDatafor Smoke, Functional, and end-to-endtesting.
• Interacted closely wif UAT Team to understand their needs and issues.
• Helped in designing and implementingdeploymentprocess, and thus maintaining teh application in postdeploymentprocess.

Environment: SQL server 2005, MS Visio, MS Office, Requisite Pro, Erwin, SQL Server

Confidential

Business Analyst

Responsibilities:

• Accumulated system requirements from various departments like accounting, IS (Information Systems) through surveys and interviews.
• Incorporated RUP to create Business Requirement Document Specifications using MS Visio and MS Word.
• Planned and defined system requirements to Wire Frames wif Use Case, Use Case Scenario and Use Case Narrative using teh UML (Unified Modeling Language) methodologies.
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams in Ms Visio.
• Conducted JAD Sessions, SME, vendors, users and other stakeholders for open and pending issues.
• Responsible for meetings wif users and stakeholders to identify problems, resolve issues and improve teh process to ensure a stable and accurate solution.
• Created exceptions report which were tan submitted to project lead and stakeholders on a regular basis.
• Facilitated user acceptance testing and test strategies wif Information Systems Group.
• Performed manual front-end testing to check all functionalities of different modules.
• Suggested measures and recommendations to improve teh current application performance wif teh aid of SCR’s (Scope Change Requests).
• Developed strategies wif Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing).
• Trained teh future users to coordinate their activities.
• Assisted teh System Analyst to document all custom and system modification after teh SCR’s were satisfactorily solved.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro and managed teh concurrence of teh parties involved wif respect to teh evaluation criterion.

Tools: & Technologies:SQL Server 2000,MS Visio, MS Outlook, MS Project, SQL, MS Access, MS Excel and MS Word