PROFESSIONAL SUMMARY

• Professional Business Analyst with 8 years of Finance, Banking and IT experience.
• Experience in Business and Data Analysis with Investment Management, Credit Management, Trading Fixed Income, Equities and Money Market Instruments and Capital Planning with sound knowledge of financial instruments like Financial Budgeting, Portfolio Management, Investment Management value chain, Equities, Bonds, Mutual funds, ETFs, Derivatives like Futures, Forwards, Options (Put and Call options), Swaps, Straight Through Processing and Market Risk.
• Experience in Middle Office Operations on different platforms like Algorithmic Trading, High - Frequency Trading, Complex Event Processing through Financial Information Exchange protocol. In-Depth Knowledge of compliances like Dodd-Frank Regulation, IFRS, SEC, GAAP, SOX, ESMA, FINRA, FRTB, CFTC and HIPPA and its integration.
• Expertise in Software Development Life Cycle (SDLC) methodologies like Waterfall, Scrum-Waterfall Hybrid, Agile (Scrum, Test Driven Development, Kanban) in domains of Finance, Banking and IT.
• Assisted Project Manager in developing Project Charter, Work Breakdown Structure to have a high-level view of the project using MS Project and Project Plans, Gantt Charts.
• In depth experience in Requirement Gathering using techniques like Interviews, Brainstorming, Focus Group, Document Analysis, JAD sessions, Survey/Questionnaires. Documented Business Requirements Documents (BRD), System Requirements Specifications (SRS), and Functional Specification Document (FSD).
• Experienced in writing User stories and handling the Requirement Churn. Efficient in performing, prioritizing techniques, MoSCoW, KANO and Business Value Based.
• Conducted GAP Analysis by creating current and expected process flow diagrams and assisted in Impact Analysis, SWOT Analysis, Cost-Benefit Analysis, Root Cause Analysis and Feasibility Study.
• Proficient in tracing requirements throughout development life cycle by creating Requirement Traceability Matrix (RTM)using MS Excel & tools like JIRA.
• Handled Change Management in an Agile environment, negotiated with the Business and Developers on Triple Constraints to accommodate the change.
• Proficient in Prototyping User Interfaces using Wireframes and Mock-ups with focused attention to detail in enriching User Experience and User Interaction. Extensively created Entity Relationship diagrams (ER Diagrams). Designed Conceptual Models and Logical Models to help Developers.
• Created UML diagrams like Use Case Diagrams, Activity Diagrams, Sequential Diagrams using MS Visio.
• Created Test Plans, Test Scenarios, and Test Cases using MS Word, MS Excel, and JIRA.
• Extensive experience in building applications in Excel and Access using VBA, writing SQL queries used in generating reports and web apps development in C#. NET, VB.NET.
• Designed and implemented SQL queries & Stored Procedures using joins, unions, group by/order by and aggregate functions to extract data for timely reporting and Validation.
• Good Knowledge of Data Warehousing concepts like SAP HANA, RDBMS, Data Marts, Data Schemas, Roll-up, Drill-Down, Slice, Dice operation, OLTP, OLAP, Star and Snowflake Schema.
• Experience in Data Warehousing,Dimensional modeling, Data Normalization (1NF, 2NF), Data Indexing, ETL & mapping using and Informatica Data Quality for Data Profiling and Data Integrity.
• Expertise in Web Services, n-Tier SOA Architecture using SOAP, REST and FIX APIs. Strong understanding of XML, JSON and FIXML messages.
• Documented service-oriented architecture to connect compliance engine to various compliance web services using SOAP and REST API Documentation.
• Proficient in User Acceptance Testing (UAT) with experience in creating test cases and test plans & release skill sets. Assisted the Quality Assurance (QA) team to perform Integration Testing, Smoke Testing, System Testing, Black Box testing, GUI testing, Regression testing, Unit testing, Parallel Testing, Stress Testing Web Service and Volume tests.
• Active involvement in Post Production Validation and Production Support by creating in-process review document.
• Extensively used reporting tools like Rally, JIRA, Tableau, Version One, MS Office Suite, Sharepoint to create a visual representation of Data Analytics using Dimensions and Measures, MS Excel and IBM Cognos for BI reporting.

TECHNICAL SKILLS

Database and Data Analysis tools: Tableau, MS SQL server, Oracle 8/9/10, DB2, SAP HANA, MS Access, Sybase, R, SPSS Modeler, Informatica Power Center 9.6.1, Data Mining, Slicing, MS SSRS, Oracle BI Publisher, Quality Centre, Eclipse, SAP BPC, SAP S4 HANA

Programming Languages: MY SQL, C, JAVA, JQL HTML, Python.

Requirements, Test and Defect Management: IBM Rational Requisite Pro, HP ALM, JIRA, Quality Center, Confluence, Rational Clear Quest, Rational Rose, Service Now, Balsamiq

Modeling & Designing: MS Visio, Smart Draw, Process Model, Lucid Charts, Camtasia, VBA

Productivity tools: MS Office, MS Project, MS SharePoint, MS Word, MS PowerPoint, MS Excel.

Operating Systems: Windows XP, Windows 8, Windows 10, LINUX, UNIX

SDLC Methodologies: Agile/Scrum, Waterfall, Rational Unified Process (RUP), Water Scrum Fall.

Web Services API: AJAX, SOAP, REST, B-PIPE, XML, FIX, STML.

PROFESSIONAL EXPERIENCE

Confidential, Malvern, Pennsylvania.

Senior Business Analyst

Responsibilities:

• Assisted PM in Project Charter, Project Planning and Work breakdown structure using SAP tools.
• Elicited requirements from stakeholders via JAD Sessions, Structured Interviews and Questions/ Surveys.
• Analyzed feasibility of business requirements and defined scope, resolve dependencies by interacting with Stakeholders, Subject Matter Experts, Project Manager and Technical Lead.
• Strong understanding of SAP Predictive Modeling, SAP Asset Intelligence, Trade Life Cycle, Front Office, Back Office, Capital Markets, Derivative Markets and Equity Trading.
• Conducted extensive GAP analysis by identifying AS-IS and TO-BE process models and process flows, where and how big the GAP is, to identify specific requirements.
• Created UML diagrams like Use Case Diagrams and Activity diagrams using MS Visio.
• Assisted product owner in the prioritization of Product Backlog Items (PBIs)using MOSCOW technique and assisting the technical team in breaking down EPICS into user stories to meet the INVEST criteria.
• Handled requirement churn by assisting Subject Matter Experts(SMEs) in Risk and Impact Analysis.
• Used JIRA, Tableau, for tracking sprint progress, user story writing, backlog management, issue tracking, user story management and requirement traceability matrix and generate status reports.
• Prepared Test Cases, Test Plans, and Test Scenarios to perform System Testing, Interface Testing, Smoke Testing and Regression Testing, logged down defects, and systematically managed them in JIRA.
• Generated various risk reports from Bloomberg like Liquidity risk, Credit risk using Tableau and MS Excel.
• Interacted with Financial Analysts to understand Fundamental analysis, Financial models to calculate Expected Return, Market Risk and Portfolio Risk of the portfolio to be used in SAP Analytical tools.
• Conducted User Acceptance Testing(UAT) and executed Test Cases on Test Lab in HP QC for manual testing
• Worked on service-oriented architecture (SOA), REST and FIX Protocols; API documentation for JSON & FIXML messages in a multiple tier architecture; content management using TFS.
• Designed SAP data modeling along with the Development team using Attribute View, Analytic View, Calculation View, Procedures, and Triggers.
• Performed Installation, setup, configuration of SAP S4 HANA database, SAP S4 HANA studio and SAP S4 HANA client.
• Experienced in reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables, using system generating joins.
• Experienced in creating SQL views for performing data analysis and creating ad-hoc.
• Business System Integration in different modules in SAP modeling views.
• Designed and developed a Business solution in using finance data extracted from Real Time Databases like Edgar, SEC.
• Involved in Database Administration including creation and management of schemas for different data model objects and import/export content.

Environment: Waterfall-Scrum Hybrid, MS Visio 2013, MS Office 2013 (MS Word, MS Excel, MS PowerPoint), JIRA, SAP S4 HANA, Java, REST, JSON, FIX Protocol, HDFS, Mahout, MS Project, AJAX, HTML

Confidential, Smithfield, Rhode Island

Senior Business Analyst

Responsibilities:

• Worked closely with BI and Risk analyst for facilitating FOB regulation compliances under Dodd- Frank act to make a consolidated report of different portfolio holdings.
• Created Business requirements document, Functional specification document and project plan.
• Interacted with Risk Managers and Project Architects along with theBusiness Owners, to gather client-specificbusiness requirementsand translate them into a various business artifact for the technical team.
• Conducted meetings and JAD sessions with various stakeholders to gather requirements by performing as a facilitator, observer, and scribe.
• In-depth experience in Agile methodology wherein, I participated in the various sprint and scrum meetings.
• Worked with the development team and Business (Finance, Risk Accounting & Operations) to prioritize deliverables and release schedule for the projects.
• Involved in Domain discussions to give systems perspective in cutting down the compliance check workflow.
• Documented Messages in Business Terminology to display alerts, error messages, exceptions to the users.
• Conducted Business Planning Consolidation session for reconciling General Ledger to transaction sub-ledger.
• Created reconciliation tool in the macro to reconcile the GL balance and Transaction Balance.
• Discussed Audit outcomes with the PM, development team. Created Workflows on admin activities like Fire Drills, Pre and Post Forecasts, Organizational Risk Repository.
• Conducted data analysis for products including Bonds, Repos, Swaps, FX & Options.
• Assisted in Graphical & SQLScript based modeling in ERP environment.
• Created mappings using SQL Codes and used transformations like expressions, routers, lookups, filters, sorters and running workflow for proper time and session management.
• Assisted ETL developers to map data from different sources (Bloomberg B-Pipe and Thomson Reuters) and perform transformations for all the assets such as equities, fixed income and derivatives to the trader’s system enabling them to upload the order details as the business required.
• Assisted in increasing Data Integrity by performing Data Normalization, Data Standardization and Data Indexing to maintain accuracy and effectiveness of data using Oracle Database.
• Strong working knowledge in Web Services, XML, and SOAP API. Prepared XML documentation.
• Involved in User Acceptance Testing phase providing them with user guide user manual and was responsible for creating Requirements Traceability Matrix to track the requirements with different functional areas.
• Helped in developing QA Test plans for Manual, Functional, Integration and System Testing. Performed Black Box Testing. Assisted in Manual Testing, Automation testing, GUI testing, smoke testing, regression testing cases.
• Involved in the generation of test data inputs for data to enhance Recovery or Fail-over testing.
• Managed SharePoint repository for project artifacts. Maintained JIRA, Tableau, MS office for project management.
• Helped manage risk analysis and mitigation plans, status reports, and client presentations

Environment: Waterfall-Scrum Hybrid, Microsoft Office 2007, MS Visio, MS Project Plan, SharePoint, JIRA, VBA Macro

Confidential, Stamford, Connecticut

Senior Business Analyst

Responsibilities:

• Created Business requirement document for calculating and reporting margin & PnL for FX OTC Derivatives products.
• Worked with the development team and Business (Front Office Traders/Desk, Trade Capture, Product Control, Risk Managers) to prioritize book of work, plan release schedule for the projects
• Prepared project progress reports, status reports, risk/action log for ongoing basis.
• Worked with FO Desk and Middle office to create Business requirement document to reconcile Swap trades between Client and Credit Suisse books.
• Worked with FX Risk Manager to integrate FX trades with Prime Risk system to calculate client risk in terms of VAR, greek sensitivities for options & perform stress tests.
• Worked with the collateral management team for creating reporting requirements.
• Determined Net Asset Value (NAV) of Collateral placed and updated on a periodic basis.
• In-depth experience in Agile methodology wherein, I participated in the various sprint and scrum meetings.
• Performed data validation with use of SQL queries and functionalities like cardinalities, joins, views, aliases, aggregate etc and made reports using SSRS.
• Designed datawarehouse on Power center using extraction, Transformation and Loadingdatafrom heterogeneous source systems into the target MY SQL database.
• Administered ETL Process, identified source table, target table and mapped the data of various Portfolios and securities using Informatica Power Center and created the data-mapping document using MS Excel.
• Involved in web services using JSON for creating documents based on the business information using REST API.
• Involved in User Acceptance Testing, Manual Testing and Automation Testing, providing teams with user guide, user manual and was responsible for creating Requirements Traceability Matrix to track the requirements with different functional areas.
• Involved in developing the test strategy document and assisted in developing test plans, test case objectives and test Helped in developing QA Test plans for Functional, Integration and System Testing. Performed Black Box Testing. Assisted in GUI testing, smoke testing, regression testing cases.
• Worked with Tableau and Excel for reporting and analyzing the portfolio performance and fixed income analytics such as Asset Allocation, Cash Flows, Profit and Loss of Hedge.

Environment: Waterfall Scrum Hybrid, Microsoft Office 2007, MS Visio, MS Project Plan, SharePoint, JIRA, VBA MacroOppenheimer funds

Confidential, New York

Senior Business Analyst

Responsibilities:

• Interviewed various SME’s for detailed business processes and created business process flows for Online Marketing - Advisor Profiles project.
• Created Functional Requirement Document & Software Specification Document, Impact Assessment Document.
• Identified Use Cases from the requirements and wrote Use Case Specifications for FRD & SRS
• Created Wire-Frames/Screen Mockups using MS Office & Paint for the new GUI - Advisor Profile to ensure all requirements are captured correctly
• Assisted in creating Conceptual Model as well as Physical Model of the trading system using MS Visio.
• SQL Probing to check validity of existing data within the databases and to protect the systems from SQL Injection Attacks. Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
• Performed Data Mining and constructed SQL queries to find correlation and patterns in existing data, used Tableau in generating effective reporting to provide BI using various matrices critical to decision making.
• Identified and Integrated various data sources like OLTP and Flat files and performed Data Verification, Validity and Normalization in maintaining the accuracy and effectiveness of data on Oracle.
• For proper functioning of blotter engines which is connected to Bloomberg API’s like B-PIPE, wrote, tested and implemented PL/SQL stored procedures, functions etc.
• Integrated third party services for enhanced due diligence (EDD) on our onboarding customers, companies and ID documentation using REST API.
• Assisted in defining Acceptance Criteria for User Stories to perform User Acceptance Testing, Manual Testing and Automation Testing. Designed Test Cases, Test Plans, and Test Scenarios to perform System Testing, Regression Testing systematically in JIRA.
• Worked with Tableau Desktop, Confluence to perform data analysis of the traders and their stocks. Assisted the team in repository management and collaboration.

Environment: Scrum, Microsoft Office 2007, MS Visio, SQL Server, Quality Center 10, ShareP

Confidential

Business System Analyst

Responsibilities:

• Interacted with the Global Research Analysts & Global Compliance team to get a better understanding of client business processes and gathering business requirements.
• Conducted JAD sessions with Business, Developers and QA teams across the region to prioritize the deliveries
• Coordinated with Development team and QA team to plan the release schedules for all the regions.
• Developed specifications, diagrams and flowcharts for Development team to follow.
• Managed all the change requests on JIRA, Tableau.
• Interacted with offshore teams through meetings and online teleconferencing to resolve various issues
• Provided ad-hoc reports to Business users by writing SQL queries or VBA macros.
• Involved in scripting business logic in the web methods of Web Services and analyzing the Web Service Level Agreement (WSLA) document through XML for Service Level Agreement.
• Worked on a service-oriented architecture to connect compliance engine to compliance web services using SOAP API
• Reviewed test plan and test cases for User Acceptance Testing (UAT), Manual Testing and Automation Testing. Coordinated UAT and provided a demo in UAT to Business users.

Environment: Waterfall, Microsoft Office 2007, MS Visio, SQL Server, SharePoint, JIRA, Microsoft Project Plan

Confidential

Business System Analyst

Responsibilities:

• Conducted User interviews, gathered Business requirements and created Business Requirement Document & Functional Requirements Document.
• Liaised with a project manager with creating detailed project plans and assisted in developing, scheduling and tracking project timelines using MS Project.
• Managed business approval process, risk governance process and change management process for all the release.
• Lead JAD sessions to facilitate discussions of requirements, scope, priority, and dependencies.
• Suggested appropriate as well as technology-based solutions for enhancing functional efficiency of the organization and achieving business excellence.
• Involved in system interactive testing and helped testers in understanding the business and the design specifications.
• Implemented Web Services to update the information displayed in the browser and to authenticate the current users to ensure security and information sharing.
• Performed Manual Testing and System testing of O/P data flat files to fix any bugs, errors or redundancy.
• Data and Business Reporting with tools like JIRA and Tableau.

Environment: Agile, Microsoft Office 2003, Windows SharePoint, MS Visio, MS Project, Wall Street Office, Excel VBA, Struts, MS SQL, IBM rational pro.

Confidential

Junior Business System Analyst

Responsibilities:

• Worked on PHP, ASP and Java Technology to develop various web application for Corporate Audit staff project.
• Provided demo and user training to the auditors.
• Worked with the project manager and Business to report using JIRA, Tableau.
• Created ad-hoc and on-demand reports using SQL queries.
• Liaised with QA team to prepare test plan document, test cases and provided detailed functional specifications.
• Used Data Grid, Dataset, and Data Reader to perform CRUD. Used Power Center extensively for database manipulations and connections.
• Created a Data Layer with connection string to DB in local folder with entities & objects used in the application.
• Mapped current state processes using MS Visio and interviewed various SME’s in order to better understand the process.
• Coordinated UAT session with Business users and addressed the issues.
• Planned and extended post-implementation and maintenance support to Business users.

Environment: Waterfall, Microsoft Office 2003, Windows SharePoint Server 2007, SharePoint Designer, MS Access, SQL Server, IIS, PHP, ASP, Java, VB Script, Javascript, HTML