SUMMARY

• Professional Business Analyst with 8 years of Finance, Banking and IT experience.
• Experience in Business Planning Consolidation, Data Analysis and Project Management 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 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 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, Hadoop, MS SSRS, Oracle BI Publisher, Quality Centre, Visual Source Safe (for version control) 6.0, PsPAD, Eclipse, SAP BPC, SAP HANA, AXIOMSL

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

Senior Business Analyst

Responsibilities:

• Function closely with Business and IT teams to work on Cloud-based database defined as Common Data Lake (CDL) to deliver faster solutions meeting aggressive deadlines and resolving redundancy in a Hybrid project methodology and dynamic work environment.
• Collaborate with Project Manager on creating Project Management Plan and work with a team of Business Analyst to define and group project’s discrete work elements using MS project and achieving the milestones by tracking change impacts & schedules.
• Responsible in gathering, analyzing and writing business requirements by conducting eliciting techniques like JAD sessions, interviewing, brainstorming, one-to-one meeting, Transforming the requirements collected in JAD sessions into requirement specification documents and distinguishing it into Functional, Non-Functional Requirements and Business Rules.
• Designed and developed UML diagrams like Use Cases, Activity Diagrams and Sequence Diagrams.
• Created data mapping document of different source and target by analyzing end to end workflow for ongoing sales incentives and commission payments to improve the overall producer experience.
• Gather, analyze and document Business requirement document (BRD), data requirements, functional and non-functional specifications, assumptions, constraints, dependencies and AS-IS state of the existing product.
• Conduct elicitation techniques such as document analysis, focus groups, prototyping, interviews and joint application development (JAD sessions) to analyze the business needs and baseline the scope of work which is acceptable to the customers and feasible for the developers to implement and execute.
• Facilitate Change Management effectively by tracking the business requirement changes, performing impact analysis, seeking necessary approvals and maintaining requirements backlog.
• Assist IT Architects to build physical and logical architecture, draw process flow diagrams, data flow diagrams, application screen mock-ups and UML diagrams such as use case and activity diagrams using MS Visio.
• Work on sandbox and production instances of MS SQL Server to write SQL DDL and DML queries and create schemas, tables, views, materialized views, stored procedures, functions, triggers etc. to generate reports.
• Assist QA lead in preparing the test plan and conducted knowledge transfer sessions for an offshore QA team to help them understand the solution and user journey flows.
• Write test scenarios, test cases and requirement traceability matrix for user acceptance testing (UAT) in HP ALM, co-ordinate UAT with business users, track defects in HP ALM and work with development team/vendors on bringing defects to closure.
• Create SharePoint Discussion describing the possible defects/breakages and corresponding fixes, for post-production support and maintenance activities.

Confidential

Senior Business Analyst

Responsibilities:

• Functioned closely with the corporate business team, control teams and technology teams to understand the 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 with 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 AXIOMSL platform.
• 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 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.
• 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 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 Axiom and 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 with the 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 the web methods of Web Services and analyzing the 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, AxiomSL

Confidential

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 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

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 in Axiom
• 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 Macro, AxiomSL

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