SUMMARY:

• Sr. Business Analyst professional with 10+ years of track record in requirements gathering, performing gap analysis, data analysis and document between 'As - is' and 'To-be' processes.
• Experienced in different facets of Business analysis including Retail Banking, Investment Banking, Commercial lending, Marketing and IT.
• Having excellent communication, organizational and presentation skills, inter-personal relationship and ability to be part of team.
• Liaison between the cross-functional teams, top management clients, users and any stakeholder involved in the project.
• Experience in creating Business Process Models for business from conceptual to procedural level i.e. Designing a Project and Defining the Scope, managing the project until delivery.
• Experienced in creating business process using use case, UML Class diagrams.
• Provide weekly report of AFS stock that have not met the delivery dates as per the order book and discuss those issues with the Asia team about making decisions on extending the delivery dates or air freight the materials to the customer’s location based upon the cost.
• Skilled at gathering requirements by conducting one on one interviews, brainstorming sessions and Joint Application Development (JAD) sessions.
• Worked on mapping of MSP Web services to Enterprise Interface Partners and coordinated with FIS on MSP.
• Good financial product working experience (including pricing, risk management and related reporting/compliance knowledge): Derivatives (Option, Swap, CDS, future/forwards), Commercial Lending/Credit product (term loans, bridge loans, syndications, participation/assignments, commitments, letter of credit, etc.), Fixed Income (Rates, Repo, FX, Commodities).
• Ensured critical trade data is encrypted as PCI- DSS compliance before CRUD operations are performed on SQL also ensured the SSRS reports built by the development team are as per the client requirements.
• Facilitated and participated in Joint Application Development (JAD) sessions, and white board sessions to keep executive staff and the team members apprised of goals, project status, and resolving issues.
• Experienced in valuation of equities, management of IPO's, Commercial Lending loan processes.
• Ability to analyse needs and product requirements to create a design.
• Excellent in SQL Probing to check validity of existing data within the databases and to protect the systems from SQL Injection Attacks. Ensured crucial data elements alone pulled data from the DB for PCI- DSS compliance.
• Expertise in MS Office, MS SharePoint, MS Visio, JIRA, with hands on experience in Data Analysis and Reporting using Advanced MS Excel, SQL. Hands-on experience in Database Management Systems such as SQL Server and Oracle.
• Experience in Business Requirement Document (BRD), Functional Specification Document (FSD), Workflow design, Use cases design and Wire frames design for projects.
• Demonstrated ability to document business processes and write detailed functional requirement document (FRD) or business requirement Specification (BRS), Software Requirement Specification (SRS) and Use Case Specification.
• Experienced in preparing process documents like Project plan (Scheduling and maintain the project timeline (Project planning/ tracking)), change request tracking, Project status report, Project issues and risk mitigation plan / reports.
• Blueprint of the prototype / application were designed using MS Visio and MS Office.
• Involved in MDM Process including data modelling, ETL process, and prepared data mapping documents based on graph requirements.
• Wrote SQL queries to extract related data from transaction record database for OLAP purposes.
• Extensive Experience with data analysis including data modelling, data mapping and data validation.
• Having working experience in SQL and Oracle Databases.
• Having involved in Full Implementation Life Cycle of the application (SDLC) and in post implementation support using Agile Methodology, and Waterfall.
• Utilized data mining techniques to find meaningful relationships between data, using SQL queries.
• Having experience in Documentation tools like MS Visio, Microsoft Office.
• Excellent technical writing skills and ability to peer review technical documents for grammar, content and style of writing.
• Ability to work under tight timeframes. Capability to handle sensitive and complex issues with discretion and good judgment.
• Effectively tested, logged and managed defects found during project system testing, functional testing using BRD with different browser for web applications and validating outputs generated.
• Proficient in developing UAT plans, UAT cases, executing UAT.
• Skilled in training end user and ensure readiness of the user for UAT and train the trainer.

WORK EXPERIENCE:

Sr. Business Data Analyst

Confidential, Cincinnati, OH

Responsibilities:

• Worked with QA team on conducting user acceptance testing (UAT) and involved in preparing a detailed user manual for all the applications.
• Worked on several reporting tools like crystal reports, SQL server reports, report writer etc.
• Worked on various process improvement projects within Capital Markets and ensure timely and accurate results of all project deliverables.
• Moved the Commercial Team from a MS Excel based pipeline sales report to a Customer Relation Management System and administer the process with the team on a weekly schedule.
• CR's (Change requests) implemented for direct lending/ commercial lending/Fix Income/liquid credit/Commercial loans and Defined and manage contract migration status reporting.
• Performed data analysis on the existing data warehouse's of AFS, ACBS and InfoLease.
• Involved in identifying and measuring sales, customer service, credit risk, and performance metrics via data and quantitative analysis and on-site meetings with management teams within the retail bank's Sales, Underwriting, and Collections departments
• Involved in conducting detailed analyses to identify patterns, trends, anomalies and schemes in transactions and relationships across multiple businesses/products and compiled suspicious activity reports for BSA/AML Management.
• Interacted with teams in AFS, ACBS and InfoLease to extract the information for the reports.
• Involved in achieving credit approval on commercial loans underwritten.
• Created Customer master data and converted Account receivables from legacy to AFS solution.
• Worked on documenting PCI- DSS compliance requirements and created traceability matrix with given functional requirements. Oversaw design, test and user acceptance of software and ETL with adherence to PCI standard.
• Worked on gathering new business requirements related to ACBS interfacing systems. Documented current state as-is system process related to affected systems.
• Supported the analysis, planning, implementation and evaluation of Dealer Finance/Commercial Loans to new IBM DB2 Web-based AFS system.
• Performs analyses of the business goals, objectives, and needs of the general business environment for the appropriate FIS segment, division, group or line of business.
• Involved in developing data requirements for straight through processing of data from source system to ACBS.
• Assist with customer data requirements, data acquisition and data validation for the AML and Fraud SaaS product line.
• Performed Data Mapping and Data profiling to map various source systems to the new Target source system.
• Conducted weekly meetings to decide the Policies and Procedures to be followed while constructing new sites. Tested Loan IQ operations related to the commercial loan trading system.
• Involved in developing Market Risk and Credit Risk functional specification for Value at Risk VaR and Regulatory Capital functional specification for the calculation of the Risk Weighted Assets RWA exposures.
• Coordinated with Analysts, Managers, Developers and Testers for complex projects during the SDLC.
• Performing UAT testing, data validation and data migration. Interfacing with technical staff (i.e. Developers, Database and System administrators).
• Work with vendor technical support to identify ongoing issues and defects that need to be resolved for the Commercial Lending System. Utilized Commercial Lending banking application and was responsible for the design and process flow of the system.
• Involved in defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance. Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market.
• Involved in identifying Use cases from the requirements and wrote Use Case Specifications and Created business process workflow diagrams.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Involved in User Acceptance Testing, gathered and documented User Manuals and Business Rules.

Business Analyst

Confidential, Charlotte, NC

Responsibilities:

• Effectively served as Business Analyst for Performance Measurement Audit and Capacity Tests; responsibilities included creating test cases, scripts, test execution schedule, coordinating data set up, managing resources, creating project task plans.
• Worked on formal interviews, Live Meetings and JAD sessions with business users Subject Matter Experts (SME's) for requirement gathering.
• Involved in preparing test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Worked on user interviews, gather requirements, and analyse the requirements.
• Analysed the AS-IS and TO-BE processes to understand the key findings, the short-term considerations, the long-term considerations and its benefits.
• Involved in writing Use cases to demonstrate the business requirements and assisted in developing business models.
• Utilized the business requirements to develop detailed user interface for the application prototype.
• Assisting in developing to new Work desk web portal system that supports ACBS.
• Involved in designing and developing different use cases, activity diagrams, sequence diagrams, Object Oriented model (class/object diagrams) using MS Visio and UML.
• Participated in Business Requirement and Technical Design Sessions for converting Commercial Loan's legacy systems to AFS.
• Reviewed and provided feedback on business requirements through JAD sessions with SME's.
• Used Microsoft Project to track project and implementation plans for system interface.
• Used Data modelling concept to define legacy applications and design interface plans with AFS.
• Worked on the system and user acceptance testing. Define the test plan, test cases and automation of the test scripts using Rational Suite Tools.
• Used Rational Rose to design and develop Use Cases Scenarios, Use Cases Models, Activity Diagrams, Sequence Diagrams, State chart diagrams, OOAD using UML.
• Worked along the Administrator of several Consumer lending systems, FIS ACBS lending system, as well as the Unifi, MSP and Reimbursement systems.
• Analysed, established, and monitored regulatory compliance processes and documents for multiple mortgages, consumer and commercial lending systems within the financial services sector.
• Involved in developing the Business Flow Diagram using MS Visio.
• Worked on different facets of Business analysis including Retail Banking, Investment Banking, Commercial lending, Marketing and IT.
• Worked with cross-functional teams for building the use cases.
• Involved in creating the project templates for Use case specification, Change request form, functional specification documents and Business Requirement documents and Defect status form.
• Worked with the design team to assist them extensively in designing the database.
• Worked with IT staff in the use of data to satisfy informational and reporting requirements using SQL and DBMS.
• Worked on workflow, process diagram and GAP analyses to derive requirements for existing system enhancements
• Used Microsoft office suite of products for documentation and data interpretation for reporting test status.
• Used MS Visio and MS Excel extensively to develop the use cases.
• Worked with onshore and offshore teams to communicate requirements and review test cases and test plans.
• Worked closely with the project manager in handling the whole project.
• Used Data mapping to collect and show relations between data.
• Assisted the technical team in defining the candidate system matrix and feasibility matrix.
• Supported User Acceptance testing (UAT) and collaborated with the QA team to develop test plans, test scenarios, test cases and test data to be used in testing, based on business requirements, technical specifications and/or product knowledge.

Business Analyst

Confidential, Wellesley, MA

Responsibilities:

• Involved in user interviews at both in-house and client locations, gathering and analysing requirements using Requisite Pro - RUP.
• Involved in developing Banking Web Portal Application for Mortgage and Retail Banking.
• Involved in the Activities of Data Profiling, Data Integration and Data Quality.
• Delivered Enterprise Data Governance, Data Quality, Metadata, and ETL Informatica solution.
• Worked on the ETL Informatica mappings and other ETL Processes (Data Warehouse).
• Implemented Data Modelling standards, including element-naming conventions.
• Extracted data from company's current software ALS using SQL to build queries AFS Automated Financial Systems used primarily for commercial construction loans.
• Involved in developing strategies for the Data warehouse, while managing the data quality/integrity in the Datawarehouse.
• Transferred data with SAS/Access from the databases MS Access, Oracle into SAS data sets on Windows and Unix.
• Involved in Training of ACBS Business Users & QA team for enhanced features & new reports
• Planning & scheduling of Teradata hardware and network updates on Pershing infrastructure.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Created Gap Analysis document between OSI and AFS Commercial Loan systems.
• Wrote Functional Requirements document for AFS Escrow implementation and data conversion project.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Retail and Commercial Lending Systems.
• Worked on Business Intelligence reports development efforts by working closely with MicroStrategy, Teradata, and ETL teams.
• Involved in data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Worked on functional requirements, ETL Informatica mapping and modelling deliverables using Kimball dimensional modelling methodology and ERWIN toolset.
• Involved in custom changes to Calypso software in order to replicate vanilla and exotic OTC derivative products.
• Understood Fixed Income, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing.
• Worked on daily basis with the main frame team and lead data warehouse developers to evaluate impact on current implementation.
• Identified research, realize, investigate, analyse, define and document business processes and Use Case scenarios.
• Involved in GAP Analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Attended Workflow and Process Diagram to derive requirements for existing systems enhancements.
• Worked with development and testing teams to accomplish Timely Release Objectives.
• Using detailed knowledge of application features and functions assessed Scope and Impact of business needs throughout analysis and completion of all enhancement specifications.
• Involved in developing Use Case Diagrams, Activity Diagrams based on Object-Oriented Design (OOD) using Rational Rose according to the UML methodology to define business processes.
• Using detailed knowledge of application features and functions, assessed scope and impact of business needs throughout analysis and completion of all enhancement specifications.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Assisted with User Acceptance Testing of Systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.

Business Analyst

Confidential, Portsmouth, NH

Responsibilities:

• Involved in Joint Requirement Planning (JRP) sessions with SME's in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Worked with other project teams with data analysis, data mining and data profiling as needed.
• Participated in the ETL migration ETI to DataStage and in the DBMS migration Oracle 11g to Teradata.
• Performed data analysis, data reconciliation and data retrieval from various systems along with identification of data gaps and data quality issues for Basel II Credit Risk Mitigation System (CRMT).
• Worked on context sensitive on-line help files for a wholesale banking software. This involved creating animated help screens, writing RTF files, capturing screens, creating hotspots and compiling help files.
• Worked on tasks among development team monitored and tracked progress of project following agile methodology.
• Assisted in the collection of financial data and conducted data mining.
• Used Visio to create use cases, activity, and workflow process diagrams.
• Involved in data profiling on datasets with millions of rows on Teradata environment, validating key gen elements, ensuring correctness of codes and identifiers, and recommending mapping changes.
• Incorporated the Informatica Velocity approach for Mapping design, development and Data Governance.
• Involved in designing of on-line transactional processing (OLTP), operational data store (ODS) and decision support system (DSS) (e.g., Data Warehouse) databases, utilizing Data vault (hub and spoke), dimensional and normalized data designs as appropriate for enterprise-wide solutions.
• Involved in dealing with different data sources ranging from Flat files, Oracle, Sybase, SQL server, Teradata, Ms Access and Excel.
• Used MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint & MS Project for project documentation.
• Involved with the trading activities of Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives; and Futures including Commodity Futures Contracts and Financial Futures.
• Involved in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Involved in documenting process flows for Credit applications in compliance with PCI- DSS to ensure deletion of cardholder data after the retention period.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business use.
• Worked on ETL Informatica development task's like creating jobs using different stages, debugging etc.
• Worked with business users and banks for loan data related issues, loan quality issues, and fraudulent loans; Being the liaison between business and technical teams, work with several internal teams involved for interfaces, and different groups like development, testing, change requests, production team, for processes involved, and getting issues resolved on time.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Worked on GAP Analysis for RDR and HUB Tables for each source system populated in RDR and HUB.
• Interacted with users for verifying user requirements, managing change control process, updating existing process flow, FRD and TDR documents.
• Use of data transformation tools such as DTS, SSIS, Informatica or DataStage.
• Worked on application requirements with UML modelling (MS Visio) and documented Dialogue application output management and FileNet Enterprise Content Management solutions.
• Worked with SQL and Data Warehousing for arrangement of customer data.
• Worked on Pivot tables (for handling dynamic data/tables for averages, Sum and other functions), Used Macros and created custom data validation rules, VLOOKUP, Array formulas in excel.
• Worked with Data Warehousing team in Metadata Modelling and gathering requirements for product catalogue data load specifications for Data mapping and Data Modelling.
• Worked on PL/SQL and Dynamic SQL to extract Data from Oracle databases. TOAD software used for creation of packages and stored procedures. Used Erwin for database modelling.
• Worked on Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
• Performed the physical database design, normalised the tables, worked with DE normalised tables to load the data into fact tables of Data warehouse.
• Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team
• Assist the technical team in translating application functionality into application architecture and the production of a System Functionality document.
• 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.
• Involved in creating and managing Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Worked on UML Diagrams such as Activity, logical, Component and Deployment views to assist development and engineering in understanding the requirements using Rational Rose.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.
• Attended Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Worked closely with Testing team and helped in testing the Informatica mappings, workflows, Ab initio Graphs and Teradata scripts.

Business Analyst

Confidential, Pittsburgh, PA

Responsibilities:

• Involved in performing Requirements Elicitation by conducting interviews, surveys, workshops and created BRD and FRD.
• Involved in creating Business Requirements Documents (BRD), Functional Requirement Specification (FRS), User Requirement Specification (URS) and Change Request (CR) document.
• Interacted with Senior Management to understand their requirements regarding integration of Previous Day reporting and Current Day Reporting.
• Highly involved in interacted with various teams to create Business Rules for batch processing in ACH payment transfers.
• Involved in gathering requirements from Accounts Payable and treasury team for ACH payment transfers.
• Conducted Gap Analysis of the features and functionality of current platform version and new version to determine the new functions to be added in.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System).
• Involved in Data Analysis, Data Validation, Data Modelling, Data Profiling, Data Verification, Data Mapping, Data Loading, and Data Warehousing/ETL testing.
• Involved in managing entire project life cycle and performed GAP Analysis to differentiate between the "AS-IS" and "TO-BE" systems.
• Worked in software engineering methodologies or SDLC like Agile and Waterfall methodologies.
• Good understood and documenting process flows for Credit applications in compliance with PCI- DSS to ensure deletion of cardholder data after the retention period.
• Used JIRA for planning and tracking the portfolios, stories, roadmaps, themes, ideas, defects, tasks, tests and issues.
• Worked with the Product Management team in order to ensure effective scope management and resource planning.
• Involved in designing and reviewing 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.
• Involved in conducting release planning in Agile environment & coordinated releases with development team & software quality assurance team for timely delivery.
• Worked as subject matter expert for all Image related projects and changes involving check transformation to ACH electronic payments.
• Worked on Subject Matter Experts (SMEs) and carefully recorded the requirements by asking questions and documented all the requirements so that they could be understood by both businesspeople and technical teams.
• Involved in designing mock-up User Interfaces and Wireframes to communicate visual data flow to the end users with the help of iRise and MS Visio.
• Attended Daily Agile/Scrum meetings, Sprint planning, Sprint review, and Sprint retrospective meeting.
• Worked on various Use Cases and UML methodology to define the Data Flow Diagram (DFD).
• Worked on disbursement cycle by interacting with Business Stakeholders to improve the existing ACH payment transfers.
• Worked with treasury management team to understand the current user interface system for the payments section and how the ACH, Wire transfers should show up in the application.
• Involved in creating User Interface Document (UID), Wireframes, Prototypes to help developers in the development process.
• Involved in developing UML Use-Cases and Use-Case diagrams to understand how the user is interacting with the system.
• Analysed and prioritized Sprint Cycle Time Boxed Tasks, Acceptance Criteria and User Stories from Product Backlog to Sprint Backlog and review the Prototype on regular basis in Scrum Agile SDLC.
• Involved in managing Product and Sprint Backlog and helped Product owners with the Release plan.
• Involved in various analysis using techniques such as GAP Analysis to understand As- Is and To- Be process,
• Worked with the application developers to create test strategy to implement various phases of testing like Performance, Integration, Unit and User acceptance testing.