SUMMARY

• Professional Business Analyst wif 8 years of Finance, Banking and IT experience.
• Experience in Business Planning Consolidation, Data Analysis and Project Management wif Investment Management, Credit Management, Trading Fixed Income, Equities and Money Market Instruments and Capital Planning wif 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 Exchange Trade Management System, 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 teh 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 teh 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 wif teh Business and Developers on Triple Constraints to accommodate teh change.
• Proficient in Prototyping User Interfaces using Wireframes and Mock-ups wif 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) wif experience in creating test cases and test plans & release skill sets. Assisted teh 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, Hadoop, MS SSRS, Oracle BI Publisher, Quality Centre, Visual Source Safe (for version control) 6.0, PsPAD, Eclipse, SAP BPC, SAP 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, Selenium, Load Runner, 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:

• Functioned closely wif teh corporate business team, control teams and technology teams to understand teh end to end process, data security and Financial Compliance documents (MiFID 2), FRTB, JFRS, IFRS, SEC and GAAP.
• Elicited requirements from stakeholders via JAD Sessions, Structured Interviews and Questions/ Surveys.
• Analyzed feasibility of business requirements and defined scope, resolve dependencies by interacting wif Stakeholders, Subject Matter Experts, Project Manager and Technical Lead.
• Expertise in Predictive Modeling, Asset Intelligence, Trade Life Cycle, Front Office, Back Office, Capital Markets, Derivative Markets and Equity Trading.
• Business System Integration, Business Intelligence and Business Planning Consolidation in different modules in ERP system.
• Designed and developed a Business solution using data extracted from Real Time Databases like Edgar, SEC.
• Conducted extensive GAP analysis by identifying AS-IS and TO-BE process models and process flows, where and how big teh GAP is, to identify specific requirements.
• Created UML diagrams like Use Case Diagrams and Activity diagrams using MS-Visio.
• Assisted product owner in teh prioritization of Product Backlog Items (PBIs) using MOSCOW technique and assisting teh technical team in breaking down EPICS into user stories to meet teh INVEST criteria.
• Handled requirement churn by assisting Subject Matter Experts (SMEs) in Risk and Impact Analysis.
• Expertise in JIRA, Tableau for tracking sprint progress, user story writing, backlog management, issue tracking, user story management and requirement traceability matrix and generate status reports.
• Experienced in reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables, using system generating joins.
• Interacted wif Financial Analysts to understand Fundamental analysis, Financial models to calculate Expected Return, Market Risk and Portfolio Risk of teh portfolio to be used in ERP tools.
• Experienced in creating SQL views for performing data analysis and creating ad-hoc. Created SQL Queries and Stored Procedures using SELECT and JOIN for Portfolio Drill Downs to pull data.
• Designed Data modeling along wif teh Development team on using Attribute View, Analytic View, Calculation View, Procedures, and Triggers. Involved in Database Administration including creation and management of schemas for different data model objects and import/export content.
• Expertise in service-oriented architecture (SOA), REST and FIX Protocols; API documentation for JSON in a multiple tier architecture.
• Involved in scripting business logic in teh web methods of Web Services and analyzing teh Web Service Level Agreement (WSLA) document through XML for Service Level Agreement.
• Conducted User Acceptance Testing (UAT) and executed Test Cases for manual testing.
• Prepared Test Cases, Test Plans, and Test Scenarios to perform Automation Testing, Manual Testing, Acceptance testing, System Testing, Interface Testing, Smoke Testing and Regression Testing.
• Generated various risk reports from Bloomberg like Liquidity risk, Credit risk using Tableau and MS Excel.

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

Confidential, Smithfield, Rhode Island

Senior Business Analyst.

Responsibilities:

• Worked closely wif 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 wif Risk Managers and Project Architects along wif theBusiness Owners, to gather client-specificbusiness requirementsand translate them into a various business artifact for teh technical team.
• Conducted meetings and JAD sessions wif various stakeholders to gather requirements by performing as a facilitator, observer, and scribe.
• In-depth experience in Agile methodology wherein, me participated in teh various sprint and scrum meetings.
• Worked wif teh development team and Business (Finance, Risk Accounting & Operations) to prioritize deliverables and release schedule for teh projects.
• Involved in Domain discussions to give systems perspective in cutting down teh compliance check workflow.
• Documented Messages in Business Terminology to display alerts, error messages, exceptions to teh users.
• Conducted Business Planning Consolidation session for reconciling General Ledger to transaction sub-ledger.
• Created reconciliation tool in teh macro to reconcile teh GL balance and Transaction Balance.
• Discussed Audit outcomes wif teh 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 teh assets such as equities, fixed income and derivatives to teh trader’s system enabling them to upload teh order details as teh 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 wif user guide user manual and was responsible for creating Requirements Traceability Matrix to track teh requirements wif 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 teh 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 wif teh development team and Business (Front Office Traders/Desk, Trade Capture, Product Control, Risk Managers) to prioritize book of work, plan release schedule for teh projects
• Prepared project progress reports, status reports, risk/action log for ongoing basis.
• Worked wif FO Desk and Middle office to create Business requirement document to reconcile Swap trades between Client and Credit Suisse books.
• Worked wif FX Risk Manager to integrate FX trades wif Prime Risk system to calculate client risk in terms of VAR, greek sensitivities for options & perform stress tests.
• Worked wif teh 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, me participated in teh various sprint and scrum meetings.
• Performed data validation wif 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 teh target MY SQL database.
• Administered ETL Process, identified source table, target table and mapped teh data of various Portfolios and securities using Informatica Power Center and created teh data-mapping document using MS Excel.
• Involved in web services using JSON for creating documents based on teh business information using REST API.
• Involved in User Acceptance Testing, Manual Testing and Automation Testing, providing teams wif user guide, user manual and was responsible for creating Requirements Traceability Matrix to track teh requirements wif different functional areas.
• Involved in developing teh 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 wif Tableau and Excel for reporting and analyzing teh 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 Macro

Confidential, Liberty Street, 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 teh requirements and wrote Use Case Specifications for FRD & SRS
• Created Wire-Frames/Screen Mockups using MS Office & Paint for teh new GUI - Advisor Profile to ensure all requirements are captured correctly
• Assisted in creating Conceptual Model as well as Physical Model of teh trading system using MS Visio.
• SQL Probing to check validity of existing data wifin teh databases and to protect teh 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 teh 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 wif Tableau Desktop, Confluence to perform data analysis of teh traders and their stocks. Assisted teh team in repository management and collaboration.

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

Confidential

Business System Analyst

Responsibilities:

• Interacted wif teh Global Research Analysts & Global Compliance team to get a better understanding of client business processes and gathering business requirements.
• Conducted JAD sessions wif Business, Developers and QA teams across teh region to prioritize teh deliveries
• Coordinated wif Development team and QA team to plan teh release schedules for all teh regions.
• Developed specifications, diagrams and flowcharts for Development team to follow.
• Managed all teh change requests on JIRA, Tableau.
• Interacted wif 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 teh web methods of Web Services and analyzing teh 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, gatheird Business requirements and created Business Requirement Document & Functional Requirements Document.
• Liaised wif a project manager wif 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 teh 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 teh organization and achieving business excellence.
• Involved in system interactive testing and helped testers in understanding teh business and teh design specifications.
• Implemented Web Services to update teh information displayed in teh browser and to authenticate teh 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 wif 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 teh auditors.
• Worked wif teh project manager and Business to report using JIRA, Tableau.
• Created ad-hoc and on-demand reports using SQL queries.
• Liaised wif 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 wif connection string to DB in local folder wif entities & objects used in teh application.
• Mapped current state processes using MS Visio and interviewed various SME’s in order to better understand teh process.
• Coordinated UAT session wif Business users and addressed teh 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