Suparna Bhattacharyya
Pune
Summary
I am a result-oriented Data & Analytics Manager with 15 years’ success in leading multidisciplinary teams and delivering industry-leading analytics projects. Proficient in SQL, Power BI, ETL and Tableau, I aim to drive business growth through data-driven strategies and decision-making. Having wide range of experience in Retail, Industry, HR domains, Banking, Utilities, Automobile etc.
Overview
16
16
years of professional experience
2
2
Certifications
Work History
Manager for Tool Migration of ETL & Reporting
Capgemini India
Pune
- Working as Manager for Tool Migration of ETL & Reporting from ITBM, SAP BO to Tableau
- Collaborated with Data Lake, Data Repository & Machine Learning Streams to prepare E2E BI Solutions
- Effectively Managed Reporting platform under ITBM to ServiceNow Migration
- Currently Leading BI Transformation from ITBM to Tableau & Enterprise Data Lake using AWS Services - S3, Redshift, Lambda, Dynamo DB
- Analyzed & Built Contractual Obligations of Various accounts on Tableau & built SLA Registry & DB
- Defined Automation & Transformation Strategies for Service Management Group Report Automation using ITBM, Tableau
- Proposed design for Agnostic data model for ServiceNow & Remedy in AWS
- Effective Demonstration of solutions to different Stakeholders to bring more business to Organization
- Currently focus on Cloud platform (AWS, Informatica cloud) to improve the data insight.
Project Manager Data Analytics
Infosys India pvt Ltd
Pune
01.2022
- Create project plan to fit stakeholder and customer needs and deliver within budget on desired outcome
- Define project role and responsibilities in close collaboration with customer, including project scope and objective
- To ensure cross functional understanding amongst project members
- Perform project tracking through clear and concise status report and time management report
- Proactively identify the issues and track project member progress against commitments
- Effectively managing the project cost and also got gold rating in project management.
Data Analytics (Manager) Johnson and Johnson
Capgemini India pvt Ltd
Pune
01.2021 - 01.2022
- Handling 10 member team of Data Analytics
- Regularly and effectively communicate development status to senior management
- Proficiency using Scrum/Agile project management tools (JIRA)
- Proven track record of project/program management
- Prioritize features with the development teams given their capacity
- Evangelize and facilitate use of Game Analytics across all decision makers in the company
- Work directly with business executives to identify and understand key design and business questions, and standardize key metrics and measures
- Stay abreast of state-of-the-art analytics trends and innovative tools/developments
- Establishes project charters, scope and manages components of the project design and implementation of plans according to the guidelines established in the project charter, working closely with Programs management Team, and project sponsors.
BI Report Lead
IBM India pvt Ltd
Pune
01.2015 - 01.2021
- Working as Interactive dashboard Designer, Design the dashboard as per the requirement using Tableau and SAP Lumira Designer
- Got appreciation for tableau work from Client for tableau dashboard work
- Coordinating with Business stakeholder and gather requirements on one to one basis in Agile delivery environment
- Created KPI dashboard using Lumira Designer on top of SAP BW BEX query
- Develop scripting and CSS for the Complex dashboard requirement in Lumira Designer 2.2
- Connect with BW 4/HANA with tableau dashboard, preparing data marts once data is extracted with tableau using splits, custom splits, pivoting techniques etc
- Once initial development is complete connection are being switched to LIVE
- Created required KPIs as per business and publishing them to Tableau online repository integrating multiple data source using joins and various data blending techniques
- Involve into integration with cloud migration form SAP BW to AWS S3 bucket.
BI Data visualization (Tableau Developer)/Reporting lead
IBM India pvt Ltd
Pune
01.2015 - 01.2021
- Achievement: Achieved the highest rating as the top performer
- I am leading the BI reporting of 13 members, provide solution for complex report, and complex logic for universe design to archive report output without any bug
- Understanding the functional specifications and preparing the Technical Specifications, preparing technical design and development, unit test plans
- Created dashboard for HR department for the client, presented three different visualization for the same data and presented demo to HR Directors and tower Leads
- Live version included 4 sets of dashboards with key HR KPI’s and trend graphs in Tableau
- Ensure Bug Fixes are done following the prescribed Processes
- Created Tableau report on Amazon Redshift
- Provide End to End support to the user.
Senior BI (Tableau/SAP BI) Developer
Accenture
Pune
01.2013 - 01.2015
- Responsible to create BI reports using Web Intelligence, Crystal report, provide solution to user for Dashboard using SAP design studio
- Interacted with business analyst to gather business requirements and designed functional and technical requirements documentation
- Consume HANA views in tableau dashboards, preparing data marts once data is extracted within tableau using splits, custom splits, pivoting techniques etc
- Once initial development is complete connections are being switched to LIVE
- Create interactive dashboards using parameters, filters, calculated fields and applying hierarchy functionality
- Ensure data loads run smooth without any delays or failures
- Ensure communication to the users is precise and apt
- Validating Tableau reports against HANA database for data validation/UAT
- Implementing navigations techniques between multiple dashboards using action filters as well as passing parameters to URLs
- Creating required KPIs as per business and publishing them to Tableau online repository integrating multiple data sources using joins and various data blending techniques.
BI Developer
TCS
Pune
01.2010 - 01.2013
- Provided leadership to DW/BI skill enhancement initiative
- Created Web intelligence report for ecommerce domain for M&S, also involved in migration of BOXIR2 to BOXIR3
- Strong experience in Design universe, developed complex report, schedule reports, publish report and report bursting and have strong knowledge in database SQL
- Created BO reports on top of BEX query
- Experience to create cost estimation and project estimation for the project requirement
- Ensure Bug Fixes are done following the prescribed Processes
- Enhancement in Universes and reports to accommodate User requirements
- Creation of AD groups and assigning rights to users
- Scheduling of BO reports and taking proper BIARS before any change
- Analyzing and solving complex tickets within required SLA
- Attending meetings with the clients to make them understand the technical aspects of change request
- Grooming team members to avoid escalations.
Associate BI Developer
Capgemini
UK
01.2008 - 01.2010
- Worked as IBM DataStage Developer
- Understand the requirements of each mapping, the complexity and preparing timelines
- Develop the jobs, sequences as per the design document and create Unit-testing documents for the jobs
- Review of UAT test plans, Preparation of application user Manuals
- Supporting UAT Users in testing
- Provided Warranty Support for the project while staying at onsite
- Generate ad hoc reports for test the data in production.
BI Developer
Capgemini
UK
01.2008 - 01.2010
- Work as data modeler, design the data model using oracle data modelling tool
- Created physical data model diagram
- Created table in the database, design ETL jobs as per as per the data model, load data in the DataMart
- Created Bteq script in Teradata for multiload, fast load of data.
Education
B-Tech in IT - undefined
WBUT
Higher Secondary - undefined
WBCHSE
Secondary - undefined
WBBSE
Skills
Waterfall- Scrum
JIRA
Risk Management
Budgeting
Resourcing
Product roadmap
Cost management
ETL
AWS S3
Redshift
Lambda
DynamoDB
Tableau Desktop
Power BI
SQL
PLSQL
Python
Certification
Certified in OCA.
Professional Highlights
- Having Total Professional Experience of 15+ years in IT experience in Data & Analytics.
- Proficient in Team management and building, resource planning and management, Time and schedule management.
- Received Gold rating for project management.
- Currently handling team of 20 people for Data Analytics.
- PSM and PSPO trained. Preparing for certification.
- Post-Graduation in Data Science and Business Analytics from Texas University.
- Subject Matter Expert of Data Analytics – Tableau Desktop, SAP BO, AWS Redshift, IBM DataStage.
- Having experience end to end implementation of Cloud/Non-Cloud data warehouse
- Expertise in Data modeling, ELT using SQL, implementing complex Stored Procedures and standard DWH and ETL concepts
- Regularly and effectively communicate development status to Business stakeholder/senior management.
- Proficiency using Scrum/Agile project management tools (JIRA)
- Working with Business stakeholder for requirement gathering.
- Proven track record of project/program management
- Prioritize features with the development teams given their capacity
- Coordinate with data generators and core data engineers to ensure data integrity across all Central Reports/Dashboards. Perform lifecycle assessment on all deliverables and develop long term strategy for Descriptive/Inquisitive analytics
- Proven knowledge of working with various Tableau Desktop functionalities capabilities (Filters, Hierarchies, Sorting, Sets, Parameters, Custom Groups, Creating Story, Mapping, Custom Geocoding, etc.
- Leading, encouraging and mentoring other team members to enable them to deliver quality code.
- Strong debugging, analytical, logical and interpersonal skills.
- Proficient in Agile, Waterfall methodology. Experienced in JIRA, Agile Central and Confluence. Supervise efficient utilization of all Business Intelligence projects and deliveries.
Timeline
Project Manager Data Analytics
Infosys India pvt Ltd
01.2022
Data Analytics (Manager) Johnson and Johnson
Capgemini India pvt Ltd
01.2021 - 01.2022
BI Report Lead
IBM India pvt Ltd
01.2015 - 01.2021
BI Data visualization (Tableau Developer)/Reporting lead
IBM India pvt Ltd
01.2015 - 01.2021
Senior BI (Tableau/SAP BI) Developer
Accenture
01.2013 - 01.2015
BI Developer
TCS
01.2010 - 01.2013
Associate BI Developer
Capgemini
01.2008 - 01.2010
BI Developer
Capgemini
01.2008 - 01.2010
Manager for Tool Migration of ETL & Reporting
Capgemini India
B-Tech in IT - undefined
WBUT
Higher Secondary - undefined
WBCHSE
Secondary - undefined
WBBSE