Swapnil Indurkar
Head Reporting and Analytics
Pune
Summary
Strategy leader with 19 years of experience in Data, Reporting and Analytics leadership roles. Specialized in setting and managing global and culturally diverse teams with continuous focus on automation and data transformation by delivering large Data Lake, Data Warehousing projects end to end. Skilled in financial management and stakeholder relations. Collaborative and dedicated to building and leading talented and motivated individuals.
Overview
19
19
years of professional experience
5
5
years of post-secondary education
Work History
SVP,Markets Data and Reporting Lead
CITI India Pvt LTD
Pune
08.2023 - Current
- BU Head from Pune managing and maintaining team of 80 people
- Design Data and Reporting strategy for Markets Business Control tech
- Implementation of Data Lakehouse architecture using S3 as storage for onboarding in house application data for business unit
- Pune CSC site governance
- Architecture of Self-service Model in Tableau for MIS reporting
- Requirement gathering and Estimations
- Starburst setup for Data Access over S3
- Design Strategy for Partitioning and Control Frameworks for Data pipelines using Python, Pyspark
- Kafka streaming using CDC in Mongo DB
VP,Reporting Tech Lead
CITI India Pvt LTD
Pune
08.2019 - 07.2023
- Designing and Implementing Data and Reporting Architecture for Equities Business
- Design and develop reporting solution using Spark, Impala
- Design of reporting framework using Python
- Manages and maintain EOD client confirms reports
- And planned and executed migration of EOD reports from Ocean (Netezza) to Olympus using spark and Impala SQL's
- Lead and manage Qlikview team from offshore, Designed and Developed complete Market Share Dashboard in Qlikview for all 3 regions
- Involved in setting up Tableau in project and created EOD reporting dashboard for US sales Desk
- Part of EQ Data Olympus Management team
- Setting up Tableau Cluster and Power BI cluster for MIS reporting
- Requirement gathering and managing Data for Equities reporting
AVP ,Reporting Architect
Barclays Technology
Pune
07.2012 - 08.2019
- Responsible for complete BO deliverables from Offshore as BO Architect
- Reverse Engineering Old Sophis System and enhancing Data model to cater to Users Needs
- Design and development of Adhoc Universe
- Design dashboard in Qlikview
- Setting Section Access, Defining Authorization in Qlikview
- Design and Setting up User authentication and Authorization of Infoview folders
- Managing User and User Groups in CMC
- User demo and creating canned reports as per requirement
- Delegation and coordination of work to team members
- Ramping up team competency by giving them training in BO and Derivative Domain
- Development of Feeds/Reports to downstream system (Settlement system like FISS, Ledger Feeds and Middle Office Operations)
Software Development Advisor
Dell International Services
Pune
04.2011 - 06.2012
Technical Lead
Wipro Technologies
Pune
12.2009 - 03.2011
Project Lead
Syntel LTD
Pune
01.2008 - 01.2009
Software Engineer
Satyam Computers
Hyderabad
08.2005 - 12.2007
Education
MBA -
Indian Institute of Management (IIM A )
Ahmedabad, India 10.2023 - 11.2024
B.E - Electronic And Telecommunication
D.A.V.V
Indore, India 08.2001 - 05.2005
Skills
Machine Learning Knowledge
Data integration
Business Intelligence
Data Warehousing
Data Quality Management
ETL development
Big data technologies
Data Analysis Expertise
Data Visualization Techniques
Business intelligence tools
Business intelligence tools
Technology Expertise
- BigData Technologies : Spark/Impala/Hive
- Programming :Python ,Pyspark
- Architecture :Delta Tables /Data Lake/Lakehouse
- Distributed systems and databases: Netezza , Teradata
- Transactional databases : SQL Server, Oracle, MySQL
- Reporting tools: Tableau, Qlikview, Business objects
- ETL: BODS,Informatica
- Storage :S3,Rainstore
- DevOps : U deploy , Lightspeed , Harness , Team City
- Cloud Technologies : ECS , Kubernetes
- Analytics: Machine Learning enthusiast using Python and perceiving AI and deep learning
Timeline
MBA -
Indian Institute of Management (IIM A )
10.2023 - 11.2024
SVP,Markets Data and Reporting Lead
CITI India Pvt LTD
08.2023 - Current
VP,Reporting Tech Lead
CITI India Pvt LTD
08.2019 - 07.2023
AVP ,Reporting Architect
Barclays Technology
07.2012 - 08.2019
Software Development Advisor
Dell International Services
04.2011 - 06.2012
Technical Lead
Wipro Technologies
12.2009 - 03.2011
Project Lead
Syntel LTD
01.2008 - 01.2009
Software Engineer
Satyam Computers
08.2005 - 12.2007
B.E - Electronic And Telecommunication
D.A.V.V
08.2001 - 05.2005
Similar Profiles
Poonam KumariPoonam Kumari
Assistant Vice President – Projects & Transformation (LEAD BA) at Barclays IndiaAssistant Vice President – Projects & Transformation (LEAD BA) at Barclays India
Punit MundraPunit Mundra
Manager (C11)- Financial Planning & Analysis at Citi Bank (Citi Corp Services India Pvt. Ltd.)Manager (C11)- Financial Planning & Analysis at Citi Bank (Citi Corp Services India Pvt. Ltd.)
Tauseef AhmadTauseef Ahmad
Assistant Vice President at Citi Corp Services India Pvt. Ltd. (Citi Bank)Assistant Vice President at Citi Corp Services India Pvt. Ltd. (Citi Bank)