Ankur Agarwal
Pune
Summary
- Well-qualified product management professional familiar with Agile and scrum systems and how to effectively manage product development timelines.
- 15 Years work experience as Business Analyst- Product Owner in Investment Banking and Application Life cycle Management.
- Data intrigue me and I enjoy working with Data to get meaningful output. Have enjoyed playing part in Data Sourcing and Warehousing and Mining in different stages of career.
- Certified Product Owner & SAFe Agile Practitioner having good communication & negotiation skills backed by Techno-Functional & Operational knowledge.
- Good hold on functionality of Capital market products like CDS, IRS, Bonds, etc. with their Accounting Treatment as per the Trade events.
- Understanding of SWIFT system and different codes used to initiate transactions. Good hold on SQL language to perform data queries, extraction, and compilation for analysis of gaps & defects.
- Facilitated change management from Project conceptualization to implementation.
- Worked on Projects related to the change required for different Financial & Regulatory reporting requirements like US GAAP, IFRS9, HGB etc.
- Expertise in preparing business documents like FSD, front to back Mapping, RAID Log, Map & gap Analysis, etc. to facilitate application operability and data requirements.
- Well versed with JIRA, JAMA, Confluence, ALM, and Oracle SQL Developer. Preparation of Test plans and Scenarios to validate the efficacy of the designed system in ST, SIT, UAT cycles.
- Possess skill set to define & set up accounting rules and schema to post correct ledger entries as per the Trade Event.
- Worked for various esteemed clients across the globe which helps in adapting to the organization's culture and perform better to deliver results.
Overview
14
14
years of professional experience
Work History
Assistant Vice President
Deutsche Bank
Pune
01.2015 - Current
- Part of Product Owner & Business Analyst Team involved in Data Sourcing, Warehousing and Mining from upstream and implementation of Accounting Sub-Ledger for Deutsche bank Entities.
- Ingest Data from multiple sources and stitch them together to get output which will be enriched later to generate data which is required for Reporting.
- Maintain Product Backlog based on the Priority and Business Value so it can be picked as per the capacity.
- Create new Aggregation Rules as per mandatory values required; define Accounting Schema as per the GAAP, IFRS, FSI requirements.
- Define Filter & Exception rules to ensure correct Data is consumed & processed.
- Conduct workshops and training sessions for Developers and Users on the proposed solution design.
- Impact analysis of the proposed solution to ensure smooth path for the development & implementation of the Application
- Prepare Test plans and Scenarios to confirm the efficacy of the designed system and solution in ST, SIT, and UAT cycles and provide post Go-live support
- Projects Delivered - Daily Close, Data Sourcing, AcS-SubLedger, F-SIP-BREXIT, BHW
Consultant (Business Analyst)
Cap Gemini
Pune
10.2013 - 12.2014
- Requirements gathering from users through different tools which aid in the process to implement SPARC Sub-ledger for HSBC global entities
- Create tactical plans and functional design to provide efficient & cost effective business solutions
- Conduct workshops and training sessions for developers and users
- Analysis of the extracts and validation of the results as per the trade life cycle and accounting events
- Created SQL Queries (TOAD) with several parameters for Backend/DB testing
- Log new requests in QC for the bugs in the application and helped developers to track and resolve the problems
- Provide post deployments support to Users and Stakeholders.
- Projects Delivered - SPARC (Client-HSBC Investment Bank-GLT)
Process Specialist (Financial Analyst)
Cognizant
Singapore
02.2012 - 10.2013
- Perform month-end closing (including P/L & B/S review and journal postings)
- Monitoring and control of key operational processes supporting the business and ensure compliance to internal control standards, accounting policy
- Co-ordination of any changes in business organisation that impact the general ledger and cost centre structure
- Handled consolidation & maintenance of daily/weekly/monthly MIS & report the same to stakeholders
- Participate in system implementation projects as a part of Technology enhancement.
- Project Delivered- Wealth Management & Financial Reporting
Associate Process Manager (Team Lead)
eClerx Public Ltd
Pune
11.2009 - 02.2012
- Prepare payment advice and coupon calculation to get the affirmation of the client on the periodic payment through SWIFT
- To obtain credit approvals from the Front and Middle Office for certain cash flows that may present any concerns from a risk perspective
- Draft SQL queries to get the specific trade information to as per the requirement on different financial applications
- Managed and Lead 12-member team of analysts for settlement of different capital market deals
- Checking calculations and trade bookings done in Murex and request to make the necessary amendments in case of any discrepancy
- Initiated process improvements activities via submission of suggestions to management to develop User friendly systems.
Education
MBA (International Business) -
Indira College of Management
01.2010
MBA (Finance) -
MIT College, Pune University
01.2009
B.Com -
M.D.S. University, Ajmer
01.2007
H.S.C -
M.P.S, Ajmer affiliated to C.B.S.E.
01.2004
S.S.C -
M.P.S, Ajmer affiliated to C.B.S.E.
01.2002
Skills
- Business Analysis and Product Management
- Maintain the Product Backlog as per the Business Value
- Data Warehousing and Data Mining
- Design Accounting Rules as per Product
- Client Relationship/ Stakeholder Management
- Requirement Gathering
Technical Skills and Applications Known
- Well versed with Oracle SQL to draft complex queries to get required data from Database.
- Good experience of working on Tools like JIRA, Confluence, ALM, QC, JAMA, Toad, Bloomberg Screen, Bit Bucket, Sharepoint.
Current Address
Flat # C2-1101, Pune, 411015
Linguistic Abilities
- English
- Hindi
Passport Number
P3285376
Pan Card Number
ALCPA7915K
Hobbies and Interests
- Travelling & Exploring cultures
- Art of Cooking
- Wildlife enthusiast
Timeline
Assistant Vice President
Deutsche Bank
01.2015 - Current
Consultant (Business Analyst)
Cap Gemini
10.2013 - 12.2014
Process Specialist (Financial Analyst)
Cognizant
02.2012 - 10.2013
Associate Process Manager (Team Lead)
eClerx Public Ltd
11.2009 - 02.2012
MBA (International Business) -
Indira College of Management
MBA (Finance) -
MIT College, Pune University
B.Com -
M.D.S. University, Ajmer
H.S.C -
M.P.S, Ajmer affiliated to C.B.S.E.
S.S.C -
M.P.S, Ajmer affiliated to C.B.S.E.
Similar Profiles
Dnyaneshwar BhogilDnyaneshwar Bhogil
Trade and Transaction Analyst at Deutsche Bank Group, Deutsche BankTrade and Transaction Analyst at Deutsche Bank Group, Deutsche Bank
PRADEEP KUMARPRADEEP KUMAR
Assistant Vice President at Deutsche India Private Limited (Deutsche Bank Group)Assistant Vice President at Deutsche India Private Limited (Deutsche Bank Group)
Manoj Singh SolankiManoj Singh Solanki
Senior Analyst at Deutsche India Pvt. Ltd- Deutsche Bank GroupSenior Analyst at Deutsche India Pvt. Ltd- Deutsche Bank Group
Amit KulkarniAmit Kulkarni
Vice President at Deutsche India Pvt. Ltd, Deutsche Bank of India, DBOIVice President at Deutsche India Pvt. Ltd, Deutsche Bank of India, DBOI
Pratik ChaflePratik Chafle
Data Engineer Manager at SaksoftData Engineer Manager at Saksoft