Swadesh Mondal

Working in advanced analytics with a background in the financial sector in Heidelberg.
Working entire data analysis process, from gathering and analyze requirements to data management, and creating insightful reports and visualizations using tools like SQL/Tableau/Bex/BOA/WEBI and others.
Working on SAP BW/BW4HANA, SAP BO.
Trained BOA and Tableau users.
Expert on Query design and development with different complex calculation.
Worked to develop business architecture using requirement such as scope, process, alternatives, and risk.
Responsible to design and develop new datasets, data feeds, reports, and analysis features ensuring high performance and future scalability.
Responsible for logs and dashboard to find stability & root cause of issue.
Responsible for performance bottleneck, capacity management and platform stability.
Experienced in support of ETL, processes, process chain setup & monitoring of data loads.
Responsible for harmonizing reporting requirements and documenting standard reporting packages for all business lines.
Working Development, update and performance improvements of reports.
Continuous improvements, maintenance, alert management and incident management of automated Reports.
Experienced on SAP BW Administrator or have SAP Basis knowledge.
Expert in performance tuning and regular housekeeping tasks.
Expert Mapping Designer to load the data into Datamart, Enterprise Data warehouse (EDW) and Operational data store using different transformations like Aggregator, Expression, Stored Procedure, External Procedure, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations.
Responsible for different ETL development.
Development and improvements of reports

Collected, cleaned, and analysed large datasets using SQL and Python to identify trends and business opportunities.
Developed interactive dashboards in Tableau/Power BI to track KPIs, improving decision-making efficiency.
Automated data extraction and reporting processes, reducing manual workload.
Collaborated with cross-functional teams to translate business requirements into data-driven solutions.
Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica/OWB/ODI to extract the data from multiple source systems that comprise databases, flat files to the Staging area, EDW and then to the Data Marts.
Responsible for data ingest & ETL activities with Nifi.
Developed ETL control tables, error logging, auditing, data quality.
Excellent knowledge of TSQL & SQL.
Responsible in star schema data modelling and design specific to data warehousing and business intelligence environment.
Concurrently, responsible for the support and administration of large enterprise level data warehouses holding customer transactions information.
Planned, co-ordinated analysis, design and extraction of encounter data from multiple source systems into the data warehouse relational database while ensuring data integrity.
Managed the development and execution of test plans and effected corrective action on data quality issues.
Responsible to analyse client's business requirements and processes through document analysis, workshops and workflow analysis.
Responsible evaluate risk related requirements implementation, testing processes and project communications.
Responsible for Big data implementation with Unica.
Data loading from Oracle to Hive, Impala & Hbase for Campaign with different integration.
Responsible for DB scaleup & performance improvement.
Responsible for data ingest & ETL activities with Nifi.

Collected, cleaned, and analyzed large datasets using SQL and Python to identify trends and business opportunities. Developed interactive dashboards in Tableau/Power BI to track KPIs, improving decision-making efficiency. Worked on experienced in SAP BW/BW4HANA, SAP BO. Automated data extraction and reporting processes, reducing manual workload. Collaborated with cross-functional teams to translate business requirements into data-driven solutions. Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica/OWB/ODI to extract the data from multiple source systems that comprise databases, flat files to the Staging area, EDW and then to the Data Marts. Developed ETL control tables, error logging, auditing, data quality. Excellent knowledge of TSQL & SQL. Responsible in star schema data modeling and design specific to data warehousing and business intelligence environment. Concurrently, responsible for the support and administration of large enterprise level data warehouses holding customer transactions information. Planned, coordinated analysis, design and extraction of encounter data from multiple source systems into the data warehouse relational database while ensuring data integrity. Managed the development and execution of test plans and effected corrective action on data quality issues.

Analyzed sales data using SQL and Python, identifying trends that boosted revenue.
Processed and cleaned financial datasets, improving data accuracy.
Created monthly KPI reports using Excel and Power BI, supporting strategic planning for senior management.
Assisted in developing a risk assessment model, reducing potential losses.
Developed ETL framework for processing and monitoring import of flat files in SSIS for key client.
Responsible for mappings using different look-ups like connected, unconnected and Dynamic look-up with different caches such as persistent cache.
Responsible for SQL business intelligence in Exalytics machine.
Responsible for analysing information and analysing data.
Implemented and managed client health and welfare databases and customized application parameters.
Developed and implemented custom data validation stored procedures for metadata summarization for the data warehouse tables, for aggregating different subscribers switching data, for identifying winning and losing carriers, and for identifying value subscribers.
Improved encounter data quality by up to ninety percent on most measures as defined by Business Reporting unit.

Results-driven data analyst with expertise in SQL, Python, ETL, and BI reporting, delivering actionable insights, optimized data pipelines, and high-quality dashboards to support strategic decision-making and improve operational efficiency.

Performed statistical analysis to support sales forecasting and inventory management.
Presented findings to stakeholders through clear visualizations and reports.
Responsible for Entire project planning and execution for project migration.
Responsible for manpower and off-shore delivery team setup.
As leading member of customer service board, spearheaded and directed implementation of departmental Intranet, resulting in greater speed and access to information for both internal staff and outside clients.
Collaborated with programmer to develop contents and architecture, initiated cross-training with other departments to improve work flow and stream line project completion.

Results-oriented leader with expertise in delivering data-driven insights for sales forecasting and inventory management, managing end-to-end system migration projects, and driving operational efficiency through enterprise initiatives and cross-functional collaboration.

Responsible for issue identification and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
Responsible for Oracle Database migration to Exadata using various method applicable.
Database performance tuning on ad-hoc request.
New database provisioning on Exadata machines and Sql Database.

Senior data and delivery leader with a strong track record in driving strategic decisions through analytics, leading complex system migrations, and improving operational efficiency via cross-functional collaboration and enterprise initiatives.

Managing database security.
Creating and assigning the appropriate roles and privileges to users depending on user activity.
Analysis production, UAT, LT issues and find out exact solution.
Handle database performance and Application performance.
Lead the product deliveries by participating in requirement Analysis, Planning, Issue resolution and Change control.

Managing database security. Creating and assigning the appropriate roles and privileges to users depending on user activity, Analysis production, UAT, LT issues and find out exact solution, Handle database performance and Application performance.

Solving production issues on various application systems.
Managing database access control.
Creating and assigning the appropriate roles and privileges to users depending on user activity.
Resolution and Root Cause Analysis of Production issues.
Developed some new functionality and modify the existing, according to customer requirement.
Write Program specification, peer reviewing of the codes.
Spearheaded a project to implement company standards and establish procedures to ensure a unified data management approach.

Experienced data and systems professional with expertise in resolving production issues, managing database access, performing root cause analysis, and implementing new functionalities. Proven track record in establishing standardized data management procedures.

Working in advanced analytics with a background in the financial sector in Heidelberg. Working entire data analysis process, from gathering and analyze requirements to data management, and creating insightful reports and visualizations using tools like SQL/Tableau/Bex/BOA/WEBI and others. Working on SAP BW/BW4HANA, SAP BO. Trained BOA and Tableau users. Expert on Query design and development with different complex calculation. Worked to develop business architecture using requirement such as scope, process, alternatives, and risk. Responsible to design and develop new datasets, data feeds, reports, and analysis features ensuring high performance and future scalability. Responsible for logs and dashboard to find stability & root cause of issue. Responsible for performance bottleneck, capacity management and platform stability. Experienced in support of ETL, processes, process chain setup & monitoring of data loads. Responsible for harmonizing reporting requirements and documenting standard reporting packages for all business lines. Working Development, update and performance improvements of reports. Continuous improvements, maintenance, alert management and incident management of automated Reports. Experienced on SAP BW Administrator or have SAP Basis knowledge. Expert in performance tuning and regular housekeeping tasks. Expert Mapping Designer to load the data into Datamart, Enterprise Data warehouse (EDW) and Operational data store using different transformations like Aggregator, Expression, Stored Procedure, External Procedure, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations. Responsible for different ETL development. Development and improvements of reports