Sign in

Business Analyst

King of Prussia, Pennsylvania, United States
August 18, 2018

Contact this candidate


Curriculum Vitae

Name: Kalpana Joshi

Status: EAD card holder

Mobile: 484-***-****


DOB: 2nd August 1986

Address:*** **** ******,

King Of Prussia, PA,



7 years of experience in the Investment Banking industry (Deutsche bank Operations India and Barclays Shared Services) as a Business Analyst in both Risk and Finance functions

Extensive experience in Project related tasks such as eliciting business requirements, requirements analysis, creating Business Requirement documents (BRD), documenting functional specifications documents (FSD), data flow diagrams (DFD), training users, Risk reporting, Financial reporting, Regulatory reporting, Project management, Workflows

Designed workflows in Sparx /BPMN, Microsoft Visio for implementation in platforms such as JIRA

Proficient in the MS Office Suite (MS Visio, Word, Excel, Power-point, Access)

Working knowledge of the Business Intelligence platform Qlikview for Risk reporting

Extracted data for data sourcing projects using SQL from databases such as MS Access, SAP BI layer

Proficient in Stakeholder Management, Project Planning, Resource Planning, Issue Tracking

Collaborated with teams in multiple locations (Mumbai, Manila, London, New York, Kiev, Pune, Chennai, Noida)

Liaise between business and technical personnel to ensure a mutual understanding of processes and applications

Coordinated with users (Business/IT/Testing) to provide walkthroughs, get approvals and signoffs, build Test cases, UAT (User Acceptance Testing), trainings

Experienced in the Waterfall and Agile Project Management Methodology. Agile in scrum using JIRA platform.

Experienced in creating Use Cases, User Storys, Epics, managing product backlogs, scrum backlogs

Working knowledge of finance and risk concepts such as CCAR, Basel Norms, FRTB, IFRS, Accounting basics, Market Risk, Credit Risk

Working knowledge of data modelling, business process modelling, map gap analysis, current state analysis (CSA), Future State analysis (FSA), Change Management, Impact analysis, SWOT analysis, cost benefit analysis, Software Development Lifecycle (SDLC), Risk Management, SharePoint

Working knowledge of financial markets and financial products such as loans, bonds, derivatives

Conducted data sourcing from systems/data warehouses such as GBS, FISS, SAP BW

Excellent Communication, Decision-making, Problem solving, Analytical, Interpersonal skills


Career Break while associated with Barclays: June 2017 – Feb 2018

Project 1: Suzaku (Aug 2014- June 2017)

Company: Barclays Shared Services, Mumbai

Role: Risk Business Analyst

Designed workflows in MS Visio for the Trade Approval Requests (Approximate Bookings, Pre-Trade Approvals, Limited Trade Approvals etc) as per the Market Risk Trade Approval Standards

JIRA platform was used for the implementation of these workflows

These workflows automated the process of manual data uploads and approval seeking process by streamlining the same and housing all the information in a single platform with the ability to generate reports as per user requirements and application limitations

Collaborated with stakeholders consisting of Market Risk Managers (MRMs), Credit Risk Managers (CRMs), Product Control (PC), Front Office, Operations, Trade Control

Created Business Requirements Documents (BRD), Functional Specifications (FSD), Test Cases and conducted User Acceptance Testing (UAT)

Chaired the walkthroughs and provided training to the users

Assisted in issue management as well go live support to users

Coordinated with the IT team to build the workflows on the IT platform

Lead the team and took over the Project Management responsibilities in the absence of the Project Manager

Performed map gap analysis of the current state architecture (CSA) and future state architecture (FSA) of Market Risk

Project 2: IFRS9 (June 2016-Oct 2016)

Company: Barclays Shared Services, Mumbai

Role: Risk Business Analyst

Involved in the data sourcing and analysis of existing source system feeds/files for loans/bonds GBS, FISS

Sourcing of the related source system feeds data from finance database SAP BW

Above feeds were then analysed to check if they align with the future state reporting requirements as per the IFRS9 Regulatory norms for Investment Banks.

Performed map gap analysis and then analysed the most appropriate system to source the missing information

Project 3: Outback (Oct 2015-June 2016)

Company: Barclays Shared Services, Mumbai

Role: Risk Business Analyst

Designed templates in QlikView as per the requirements of the Market Risk Managers for fixed income products

Analysed the daily feeds for specific products to check if they reflect in the QlikView dashboards correctly for live dashboards

Project 4: Marco (July 2014-Aug 2014)

Company: Barclays Shared Services, Mumbai

Role: Risk Business Analyst

Post go live support. Compare Books for Credit Risk in old and new Risk warehouses to check for missing books/attributes. Preparation of a white paper for handover to the Operations team.

Project 5: Data Sourcing STRIDE New York- CCAR Delivery (Nov 2013-July 2014)

Company: Deutsche Bank Group Operations India (DBOI GS Pvt. Ltd), Mumbai

Role: Financial Reporting Business Analyst

Analyzed the data sourcing requirements on the basis of CCAR reporting standards

Performed Current State analysis (CSA) and Future State Analysis (FSA) of the Source system feeds such as Adjustment Manager by extracting the set of fields existing in the current files and then identifying the impact the values have on the overall finance numbers.

Map-Gap analysis of the current state Data model with the future state data model (Financial Data Standards)

Created Business Requirements (BRD), Functional Requirements (FRD), Functional Specifications (FSD) and Data flow diagrams (DFD) for the proposed solution for Daily Balance Position file creation

Project 6: Manage Financial Reporting Environment-STRIDE (June 2012-Nov 2013)

Company: Deutsche Bank Group Operations India (DBOI GS Pvt. Ltd), Mumbai

Role: Financial Reporting Business Analyst

Design process maps in Enterprise Architect (Sparx) for the modules `Manage Change Requests' and `Run Validations and Reconciliations' in line with Target Operating Model (TOM).

Assisted in the building of the Project Initiation Document (PID).

Built the requirements for Control Framework, Service Database for STRIDE program.

Map-Gap Analysis of existing Change control and Reconciliation processes with future state.

Analysed the current state General Ledger (SAP) and build the reconciliation process between future state (Financial Data Warehouse) with Legacy SAP.

Remediated the End User Developed Applications (EUDAs).

Created the detailed BRD and FSD for the mentioned processes and Prepared presentations and walkthroughs to receive sign off from the users

Formulated the Service Level Agreements (SLAs) for the above processes, test cases, perform UAT, and created training material for the users

Project 7: Data Sourcing and Quality Feeds Management (April 2011 - May 2012)

Company: Deutsche Bank Group Operations India (DBOI GS Pvt. Ltd), Mumbai

Role: Financial Reporting Business Analyst

Analysis of Financial, Regulatory and Risk reporting systems.

Map-Gap analysis of the current state Data model with the future state data model (Financial Data Standards)

Formulated Business Rules for the construction of Risk Standards-Financial Data Standards convertor.

Project 8: Internship in FAS 91 (May 2010- July 2010)

Company: General Electric Corp Capital Markets, Gurgram

Role: Intern

Consolidation of FAS 91 data and creation of templates to calculate the deferred and amortized costs and fees for different businesses of GE (Year 2010) and formulate a standard survey and template to calculate success ratios


MBA (PGDM-Finance, 2009-11): Institute of Management Technology, Ghaziabad, India (GPA 7.01/10)

B.Tech. (Electronics and Communication, 2005-09): J.S.S. Academy of Technical Education, Noida, India (73.5%)


Primary Skills: Business Analysis, Requirements Gathering and analysis, GAP analysis, Financial Reporting, Change Management, Agile and Waterfall Project management, Business Process Modeling, Data modeling, Workflows, Testing (UAT), Fundamentals of Bank Accounting, BASEL Norms, CCAR reporting, financial products loans/bonds/derivatives, Impact analysis, Cost Benefit analysis, SWOT analysis

Database: MS Access, SAP BW

Tools: MS Office Suite (Visio, Excel, Power Point, Visio), BPMN SPARX Enterprise Architect, MS Visio, Qlikview, JIRA


'Value Award' (Jan 2016) in Barclays for one of the key values as per RISES for showing 'Stewardship'

Employee of the Month award for months April 2016-Barclays, May-2012-DB, Jan-2013-DB, Jan-2013-DB

Culture messenger for Group finance at DBOI for the year 2012-2013 and actively involved in the CSR activities: DB Republic Run, Visit to School in Pali Village, Visit to the Old Age Home, Volunteer at the Blood donation camp, Sports Day for Underprivileged kids

Contact this candidate