SUMMARY

• 8+ years of experience as a Business Analyst with 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 the compatibility of the existing system infrastructure with the 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 with 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 knowledge 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 with a strong goal orientation.
• Excellent meetings facilitator with good inter-personal and conflict resolving skills.
• Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
• Effective in working with 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 with business partners, while understanding their needs, associated with 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 with other Business Analysts on cross-functional requests and solutions. While coordinating and working with 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 with the Data Analyst in defining data sources and required data content for the data warehouse component.
• Implemented Agile SDLC methodology and involved in project management. Worked on Scrum Methodology as well as on SDLC procedures in the implementation of Spotfire
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Teradata.
• Worked with the 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 the reporting and ETL components.
• Assisted in development of Test Plans and assisted QA team in System testing to ensure the new system satisfy all User requirements.
• Develop and maintain project plans for reporting purposes.
• Conduct walk-throughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the product.
• Facilitate JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Conduct FRS and walk-throughs with the designers, developers and stakeholders.
• Use FrontPage templates to create an entire site and have achieved uniform and consistent formats for all the web pages.
• Understanding the 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 the user requirements were catered by the application.
• Use SharePoint to ensure all team members have easy access to all the documents created.
• Assist Project Manager in using MS project to track the 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
• Gathered relevant Business Requirements and acted on behalf of Product Owner.
• Prepared storyboards in MS Word and MS PowerPoint for better visualization of the application.
• Created business requirement document, functional (FRS) and technical specifications for the 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 the 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 the 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 the fly.
• JIRA (Ticket) tracks and communicates status and issues with tech team.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Tableau/Spotfire.
• Resolved issues and improvised the process to ensure a stable and accurate solution.
• Worked to create structure in Access Database.
• Collaborated with financial services as part of support for the application.
• Validated business rules and all artifacts with users, approval and sign off.
• Provided technical and business knowledge to clients.
• Interacted with the architects, developers on business and technical issues, helping in designing of the system; and testers to ensure all requirements were correctly translated.
• Worked with the team on security features: web, encryption, authentication and SSO possibilities.
• Updated and modified progress and resources allocation in MS project for the team. .
• Suggested process and product improvements for the application.
• Created test plans, scripts and facilitated UAT.
• Performed manual front-end testing to check all functionalities of different modules.
• Ensured that the 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 the Requirement Analysis and documented the 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 the second release of the application.
• Closely interacted with designers and software developers to understand application functionality, navigational flow and updated them about end-user sentiments.
• Performed Risk Analysis of the requirements to identify key business risk areas for project and prioritized application development and testing.
• Experienced in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin
• Produced the visual models for the system using Rational Rose to create Use Cases, State Charts, Sequence Diagrams, and Activity Diagrams.
• Proactively identified opportunities and made recommendations to improve the system’s effectiveness via data mining and analysis to understand user interactions with system and to scope out opportunities to enhance user engagement and satisfaction.
• Facilitated weekly meetings with the review teams to continuously improve the QA process.
• Conducted walkthroughs with the end-users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the 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 the functionality, GUI and security.
• Interacted closely with UAT Team to know their needs and problems.
• Helped in designing and implementing deployment process, and maintaining the 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 with end users, stake holders and developers to gather functional and non-functional requirements of the system, and creation of user stories
• Implemented ACORD for reinsurance industry standards worked in the RUP environment for the elicitation, representation of requirements and in change management.
• Assessed the flaws in the existing as-is system and made clear recommendations of business process improvements and BPR, and incorporated them in the to-be system design.
• Analyzed the 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 the business requirements and process flow.
• Developed UML Use Case diagrams for faster and more efficient communication with stakeholders, by utilizing MS Visio.
• Made sure current project requirements were being met by using Requirement Traceability Matrix (RTM)
• Actively involved in creation of the UML diagrams such as sequence, activity and class diagrams for certain modules of the application using MS Visio and Rational Rose.
• Used Rational ClearQuest for all types of change requests, including defects, enhancements, issues and documentation changes with a flexible workflow process.
• Assisted and directly involved with QA team in creation of Test Cases and tests implementations.
• Presented and assisted end users for education and training about the 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 the 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 the second release of the application.
• CreatedDataFlow Diagrams, Use Cases and business process flowcharts on which the 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 the development team in the source to target mapping for ETL design.
• Performed Dataextraction,DataMigration andDataconversion using ETL tools from application front-end with Oracle databases anddatawarehouse.
• Proactivelyidentified opportunities and made recommendations to improve the system’s effectiveness viadatamining and analysis to understand user interactions with 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 with the QATeam to review and enhance the TestPlan and Test Cases.
• Reviewed development plans, quality assurance test plans, and user documentation to ensure correct interpretation of original specifications.
• Worked with the test team in Identifying and creating TestDatafor Smoke, Functional, and end-to-endtesting.
• Interacted closely with UAT Team to understand their needs and issues.
• Helped in designing and implementingdeploymentprocess, and thus maintaining the 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 with Use Case, Use Case Scenario and Use Case Narrative using the 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 with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
• Facilitated user acceptance testing and test strategies with Information Systems Group.
• Performed manual front-end testing to check all functionalities of different modules.
• Suggested measures and recommendations to improve the current application performance with the aid of SCR’s (Scope Change Requests).
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing).
• Trained the future users to coordinate their activities.
• Assisted the System Analyst to document all custom and system modification after the SCR’s were satisfactorily solved.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro and managed the concurrence of the parties involved with respect to the evaluation criterion.

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