Debanjan Das
Sydney,NSW
Summary
Dynamic Senior Integration Developer with extensive experience in the development of datawarehouse, data integration & business intelligence across diverse platforms. Adept at fostering collaboration and driving continuous improvement in data management processes.
Overview
15
15
years of professional experience
Work History
Senior Integration Developer
Western Sydney University
Sydney, NSW
06.2023 - Current
- Create data integration workflows between enterprise applications using integration methologies - S3, REST API, databases, SFTP, and SaaS platforms.
- Troubleshoot complex technical data issues related to integrations between various applications - HR, Finance, Billing, Student Management System, Library, Timetable, etc.
- Conducted end-to-end testing of integrated systems before going live or upgrading the application.
- Developed integration and ETL code version management with Python and GitLab.
- Set up and administer Tableau environments on Azure for the university's Learning and Research Business Division.
- Reconcile BAU tickets for SLA tracking of the IT Service Operations.
Senior Oracle Business Intelligence Analyst
DXC Technology
, NSW
08.2019 - 06.2025
- Developed ETL for data extraction from Oracle EBS application into the NSW Health Corporate Data Warehouse for the Finance Module.
- Customized ETL jobs for BIAPPS implementation and Fusion Analytics Warehouse Upgrade.
- Developed and enhanced NSWH BI reporting and dashboards in OBIEE.
- Worked on migrating on-prem OBIEE components (BI & Security) to the Oracle Analytics Cloud Platform.
- Developed OTBI reports for the AP module in the Oracle Fusion Application.
- Set up the Business Intelligence application on the Azure platform.
- Developed database views and data-level security in Enterprise Data Lake in Snowflake.
Oracle Consultant
Tata Consultancy Services
Sydney, NSW
07.2016 - 08.2019
- Support 24*7 Data Integration & Business Intelligence Platform
- Designed & developed near-real-time data integration solutions between enterprise applications - JD Edwards, Oracle HRMS, Kofax, etc.
- Defined & conducted annual disaster recovery for the DIBI platform
- Developed Business Intelligence reports in Oracle Business Intelligence reports in Oracle BI
- Provided continuous feedback for improvement of the existing data integration workflows
- Conducted integration code review and recommended coding best practices
- Played the role of onshore technical lead for onshore-offshore coordination and DWBI team management
- Provided technical guidance, coaching, and mentoring.
Oracle BI Developer
Tata Consultancy Services
KOLKATA, INDIA
03.2010 - 07.2016
- Designed and developed ETL workflows and data transformations.
- Prepared logical and physical data models.
- Performed data profiling, data deduplication and data cleansing for building a single customer view in Oracle Enterprise Data Quality.
- Assisted in customizing OOTB features of the Oracle BIAPPS application.
- Implemented Enterprise Asset Management analytics as part of BIAPPS implementation.
- Provided technical support for the setup and implementation of the Oracle Business Intelligence platform.
- Troubleshoot complex technical issues related to integrations between various applications.
Education
Bachelor of Technology - Electrical, Electronics And Communications Engineering
Bengal Institute of Technology
Kolkata,India07-2009
Skills
- Good understanding of data warehouse, ETL concepts
- Proficient in ETL development technologies: Oracle Data Integrator (11g, 12c, Marketplace), Informatica PowerCenter
- Proficient in P2P data integration strategies: REST API, S3, SFTP, relational database, and files (structured and semi-structured)
- Proficient in business intelligence software: OBIEE (12C), OACS
- Familiar with data visualization software: Tableau, OACS
- Proficient in database scripting languages: SQL (joins, subqueries, performance tuning, advanced functions) and Oracle PL/SQL
- Beginner-level expertise in scripting languages: PowerShell, Unix, Python
- Familiar with other scripting languages: Java
- Familiar with cloud platforms: Azure, Snowflake, and OCI
Timeline
Senior Integration Developer
Western Sydney University
06.2023 - Current
Senior Oracle Business Intelligence Analyst
DXC Technology
08.2019 - 06.2025
Oracle Consultant
Tata Consultancy Services
07.2016 - 08.2019
Oracle BI Developer
Tata Consultancy Services
03.2010 - 07.2016
Bachelor of Technology - Electrical, Electronics And Communications Engineering
Bengal Institute of Technology
Similar Profiles
Prithyraj MaitraPrithyraj Maitra
Results and Progression Support Officer at Student and University Planning, Western Sydney UniversityResults and Progression Support Officer at Student and University Planning, Western Sydney University
Gabriel AlimangohanGabriel Alimangohan
Electrical Engineering Student at Western Sydney UniversityElectrical Engineering Student at Western Sydney University
NATALIE GIULLIANONATALIE GIULLIANO
Casual Academics at Western Sydney UniversityCasual Academics at Western Sydney University
Kieran HostyKieran Hosty
Senior Archaeologist and Heritage Advisor at Hosty Heritage and ArchaeologySenior Archaeologist and Heritage Advisor at Hosty Heritage and Archaeology
Tom RooneyTom Rooney
Data Analyst Intern at CoreDataData Analyst Intern at CoreData