CHANDA RATILAL CHHATBAR
Abu Dhabi
Summary
As a Senior Data Architect and ETL Specialist, I possess a profound grasp of the intricate technicalities involved in Data Warehousing and Data Modelling. My expertise extends to Data Analysis and spearheading Digital Transformation initiatives, coupled with robust ETL/BI Support. With over 20 years of dedicated experience in crafting solutions with ETL tools, I have honed my ability to align technical strategies with business requirements. I am confident in my capacity to deliver exceptional value to your organization through my deep-seated knowledge and hands-on approach.
Overview
21
21
years of professional experience
1
1
Certification
Work History
Senior Data Architect
SEHA
Abu Dhabi
10.2023 - Current
- Company Overview: SEHA is the largest and most comprehensive healthcare network in the UAE and owns and operates all the public hospitals and clinics of the Emirate of Abu Dhabi. The Corporate BI Department caters to all internal facility reporting and external reporting.
- Partnered with business stakeholders and healthcare teams to translate complex requirements into scalable, high-impact data solutions supporting clinical and operational analytics.
- Designed and implemented scalable data architectures to enhance data accessibility and integrity.
- Led cross-functional teams in the development of enterprise data models to support business objectives.
- Established best practices for data governance, ensuring compliance with industry standards and regulatory requirements.
- Streamlined ETL processes, improving data processing efficiency and reducing latency across systems.
- Mentored junior architects on advanced database design principles and strategic data management techniques.
- Collaborated with stakeholders to align data solutions with organizational strategies, driving informed decision-making.
- Evaluated emerging technologies to recommend tools that enhance analytics capabilities and operational efficiency.
- Optimized existing data frameworks, resulting in improved performance and reduced maintenance overhead across platforms.
- Led cross-functional teams on high-visibility projects involving multiple departments within the organization.
- Implemented effective data governance policies, ensuring consistent use of data elements across the organization.
- Conducted periodic performance tuning exercises to proactively address potential bottlenecks in the system.
- Mentored new hires on best practices followed by the organization aiding their smooth transition into their roles.
- Collaborated closely with developers to ensure seamless integration between application systems and databases.
- Optimized query performance with proper indexing strategies, significantly reducing response times.
- Mitigated security risks by implementing strict access controls and monitoring solutions for sensitive information protection.
- Enhanced data integrity by designing and implementing robust data models and schemas.
- Evaluated emerging technologies in the field of data management, recommending strategic investments for long-term benefits.
- Provided technical guidance to junior team members, fostering career growth and skill development.
- Actively participated in regular code reviews helping improve overall code quality across the team.
- Integrated disparate data sources into a cohesive and well-structured data warehouse for advanced analytics capabilities.
- Developed comprehensive database documentation, facilitating better collaboration among team members.
- Streamlined ETL processes for improved data quality and reduced processing time.
- Implemented monitoring mechanisms that identified issues before they became critical problems resulting in minimal downtime.
- Established efficient backup and recovery procedures, safeguarding valuable company assets during unforeseen events.
- Collaborated with business stakeholders to translate requirements into actionable data architecture plans.
- Designed scalable and maintainable database systems, anticipating future needs and growth potential.
- Simplified complex datasets through normalization techniques, enabling easier interpretation by endusers.
- Created multi-site system architecture plans to reduce redundancy across entire organization.
- Migrated numerous legacy systems to newer technologies, reducing costs, and enhancing efficiency of computing tasks.
- Generated customized architecture specifically optimized for several database technologies.
- Designed internal process improvements to automate repetitive tasks, shortening data delivery times.
- Authored full Center of Enablement (CoE) design plan optimized for governance and performance metrics sought by client.
- Gathered, defined and refined requirements, led project design and oversaw implementation.
- Established and secured enterprise-wide data analytics structures.
- Managed identification, protection and use of data assets.
- Incorporated cloud architecture into new facility planning, reducing need for on-site equipment and technical support personnel.
- Unified disparate data structures and operating environments during revamps of processing facilities, data centers, and more.
- Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.
- Documented and communicated database schemas using accepted notations.
- Led the end-to-end design and implementation of data warehouse solutions using Informatica PowerCenter, improving data retrieval times by 35% and accelerating reporting for critical healthcare KPIs.
- Designed and developed logical and physical data models, defining data standards to ensure accuracy, compliance, and security across healthcare data systems.
- Delivered precise business, functional, and mapping requirements to enable seamless ETL development and integration across diverse healthcare datasets, including Primary Care, Home Care, Telemedicine, and Mental Health services.
- Applied advanced ETL optimization techniques in Informatica PowerCenter to enhance data processing performance and reliability.
- Collaborated with Quality and Compliance teams to meet Department of Health (DOH) regulatory requirements, ensuring timely and accurate KPI reporting for internal and external stakeholders.
- Established and enforced data governance frameworks and best practices to maintain high-quality, secure, and compliant healthcare data.
- Provided technical leadership and mentorship to junior data engineers, promoting best practices in data architecture, ETL development, and performance tuning.
- Facilitated team meetings to align project goals, monitor progress, and ensure on-time delivery of critical healthcare analytics solutions.
- Key Contributions:
- Redesigned and automated the Primary Care JAWDA KPI requirements, along with Home Care, Telemedicine, and Burns KPIs, achieving 100% reporting accuracy and reducing manual workload by 95%.
- Automated KPI builds for Physician Productivity Reporting, improving data processing efficiency by 95% and accelerating decision-making for clinical operations.
- Redesigned the Fusion Employee data integration for KPI reporting, significantly reducing integration time and improving data consistency and reliability across healthcare systems.
- Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
- Collaborated with system architects, design analysts and others to understand business and industry requirements.
- Developed and delivered business information solutions.
- Drafted conceptual and logical data models for high-level system planning tasks, optimizing each model to customers' needs and budgets.
- Designed data models for complex analysis needs.
- Verified isolation of data to specific geographic borders to comply with national and international data transmission laws and regulations.
ETL / BI Specialist
Abu Dhabi Islamic Bank
09.2012 - 10.2023
- Company Overview: Management Information System (MIS) and Data Lake are the key information system for Core Banking, Trade Finance, Treasury, Wealth Management, Covered Cards and Debit Cards Systems in ADIB. Data from various sources is loaded on daily and monthly basis. This data forms the key for business to make their decisions.
- Spearheaded stakeholder engagement to elicit business requirements, converting them into precise technical specifications and delivering accurate project timelines.
- Executed Informatica ETL processes with adherence to best practices, ensuring robust end-to-end testing against comprehensive test plans.
- Pioneered the establishment of Informatica ETL standards, promoting consistency and efficiency in new ETL projects.
- Performed database query performance tuning to optimize system efficiency.
- Simplified complex business requirements into clear design solutions, aiding high-level architectural decisions.
- Enhanced team expertise by sharing insights on banking processes and systems, strengthening business relationships and trust.
- Managed production operations, including code deployment and issue resolution, to guarantee continuous data availability.
- Played a pivotal role in large-scale data migration from RDBMS to data lakes.
- Led the strategic transition and redesign of ETL jobs from Informatica PowerCenter to Informatica BDM.
- Collaborated with vendors to audit and refine ETL code for critical projects such as FINNONE and OFSAA, implementing essential modifications.
- Addressed urgent data inquiries from audit teams, producing high-priority reports and meeting diverse business needs.
- Directed server upgrades for Informatica, overseeing installation, repository migration, and administrative tasks.
- Supported Data Center and Azure Cloud migration initiatives, including ETL testing responsibilities.
- Key Contributions:
- Assignment 1: Successfully Converted and automated all old MIS system processes to Informatica PowerCenter ETL Code. This helped in ensuring that Business is able to access the accurate data on daily and monthly basis for Business Reporting. This MIS served as a example to convert all the other system’s data loading into Informatica PowerCenter ETL and by end of 2015 all the Bank’s process were converted successfully.
- Assignment 2: Al Etihad Credit Bureau is a ongoing project for the Ministry of Finance. Their goal is to acquire all the Credit Risk information for their analysis. This is one of the challenging areas for ADIB which had been completely designed by me during the initial setup.
- Assignment 3: Key contributor in designing and end to end implementing the personal financial applications as part of Digital Transformation project.
- Assignment 4: Key contributor in migration of MIS data to Data Lake using Mass Ingestion. Involved in migration and redesigning of Informatica PowerCenter jobs to Informatica BDM.
Team Lead / Senior ETL Developer
Accenture
Bangalore & Mumbai, India
02.2010 - 08.2012
- Project 1: Media Services
- Client: Kohl’s Retail, US
- Duration: May-2012 till Aug-2012
- Role: Team Lead / Senior ETL Developer
- Tools/Technologies: INFORMATICA 8.6.1, Teradata Client 13.0, Mainframe, UNIX, Oracle
- Description: Media Services is a key system for communicating to 900 newspaper vendors. It helps schedule all print advertising and serves as our analysis tool in determining where our advertising should go. The current tool was written in house and is now on an unsupported version of software. This project is to replace the older application in a new, supported environment. The scope of the project is to handle the Business Logic and implement the ETL process using Informatica, UNIX, Mainframe, Teradata and Oracle.
- Project 2: PWM Conversion
- Client: Morgan Stanley Smith Barney, New York, USA
- Duration: Jul-2011 to April 2012
- Role: Team Lead / Senior ETL Developer
- Tools/Technologies: INFORMATICA 8.6.1, INFORMATICA PowerExchange 8.6.1, SQL Server 2005, UNIX
- Description: PWM i.e. Private Wealth Management is an Integration project has been assembled to address the migration of PWM data to MSSB platforms, while ensuring business and operational continuity. The project has identified 17 functional tracks to define specific data mapping, validation and operations approach requirements. The basic scope of the project is to handle the Business Logic and implement the ETL process using Informatica, Unix & SQL Server.
- Project 3: MSSB Conversion
- Client: Morgan Stanley Smith Barney, New York for Accenture
- Duration: Feb 2010-June-2011
- Role: Senior Software Engineer
- Tools/Technologies: INFORMATICA 8.6.1, INFORMATICA PowerExchange 8.6.1, SQL Server 2005, UNIX
- Description: MSSB is an Integration project between Smith Barney and Morgan Stanley and involves the migration of data from Smith Barney legacy system to MS Applications. There are 27 identified different tracks, each track covers multiple applications and each application has multiple files which needs to be converted.
- Roles / Responsibilities:
- As a Team lead, liaising with onshore counterparts for meticulous business requirements elicitation.
- Translated business needs into actionable technical designs, advocating for robust implementation strategies within Informatica.
- Crafted precise project estimations, ensuring a comprehensive overview of end-to-end delivery timelines.
- Achieved on-time delivery of project milestones, adhering strictly to predefined effort and schedule constraints.
- Directed a dynamic team of 7-10 members, smoothing out any analytical, developmental, or testing roadblocks.
- Pioneered the development of reusable components, significantly reducing redundancy and enhancing asset library.
- Conducted thorough code reviews to guarantee alignment with business objectives and quality standards.
- Managed the deployment of high-quality code, coordinating with onshore teams to ensure punctual release schedules.
- Engaged proactively in change management, adapting delivered code to evolving business requirements.
Asst. Systems Engineer
Tata Consultancy Services
Bangalore, India
06.2007 - 01.2010
- Project 1: Strategic Market Data (MRI - Market Data)
- Client: JP Morgan Chase, New York for TCS
- Duration: Feb-2009 to Jan-2010
- Role: Asst. Systems Engineer
- Tools/Technologies: INFORMATICA 8.1, Windows NT, Oracle 10g, Unix
- Description: The project is aimed at providing a single market data distribution hub for all Credit and Market Risk applications within Risk Technology by converting the CRI market Data and MRT BAU Market Data into one single platform. This is a part of the Market Risk Initiative, the firm wide three-year program to strategically renovate the market risk infrastructure started in 2007.
- Project 2: Market Risk Infrastructure Initiative (MRI)
- Client: JP Morgan Chase, New York for TCS
- Duration: June-2007 to Jan-2009
- Role: Asst. Systems Engineer
- Tools/Technologies: INFORMATICA 8.1, Windows NT, Oracle 10g, Unix
- Description: The JP Morgan Chase MRI (Market Risk Infrastructure) Program is a strategic initiative that will be implemented from 2007 – 2009. MRI is a three-year program and the improvements will be delivered in phases. The initial project focus was to develop a foundation of future state of infrastructure, strategic calculation and analysis as well as to deliver a unified set of initial reports. From 2008 to 2009, additional standard reports and reporting functionalities will be delivered
- Roles / Responsibilities:
- Conducted comprehensive technical analysis, including feasibility studies and requirements analysis, to support development and ensure effective ETL processes.
- Developed High Level and Low Level Design Documents tailored to business requirements as an ETL developer.
- Executed data modeling for Oracle tables, drawing parallels from Sybase tables, and pinpointed both Business and Non-Business Keys across various data sources.
- Proficiently utilized ETL tools to migrate data between Oracle and flat files, crafting mappings with diverse transformations to embed business rules into the Target system.
- Designed XML Tag sets to facilitate the reconciliation of Sybase and Oracle data post-load.
- Demonstrated expertise in handling Connected & Unconnected Lookups, Joiner, Aggregator, Expression, Router, Unconnected Stored Procedures, and XML.
- Enhanced workflow efficiency through the implementation of parallel processing techniques.
- Focused on performance optimization in Informatica by employing Key Range partitioning strategies for expedited data staging and loading.
- Developed and executed unit test cases, actively participating in unit testing and database deployment processes.
Software Engineer
Hewlett Packard
Bangalore, India
01.2005 - 06.2007
- Project 1: Flashpro DW Services
- Client: In-house
- Duration: Apr-2005 to May-2007
- Role: Software Engineer
- Tools/Technologies: Power Center 6.2, Oracle 9i, BO 6.5, MS Office 2003, Windows NT, Unix
- Description: Flashpro DW is a major reporting tool that provides business information on the channel business. Flash-Pro focuses on Whole sellers, 1st Tier Partners, Corporate Resellers and 2nd Tier Resellers business. Flash-Pro DW maintains and enhances whole seller, reseller information and HP Shipments and Orders information database with up-to-date contact information, partner hierarchy and profiling elements in order to meet target users’ requirements.
- Roles / Responsibilities:
- Spearheaded knowledge transfer from vendor, including on-site immersion in France to assimilate project specifics and workflows.
- Engineered and implemented source definitions for data extraction from various inputs to relational tables utilizing Informatica Power Center.
- Developed comprehensive target definitions with Informatica Power Center’s warehouse designer.
- Proficient in leveraging ETL processes for efficient data loading from Oracle and flat files into Oracle databases.
- Mastered the use of key Informatica transformations including aggregator, expression, lookup, update strategy, router, and rank.
- Managed Informatica Server operations, including session creation, scheduling, monitoring, and execution communication via pre and post-session emails.
Education
B.Sc. - Computer Science
Mount Carmel College
Bangalore, KarnatakaM.Sc. - IT
Sikkim Manipal University
Skills
- Informatica PowerCenter 6x,7x,8x,9x,10x
- Informatica PowerExchange 861,Informatica Developer/Informatica BDM 1040 Informatica Mass Ingestion
- Apache Spark, Hive, Kafka, Azure
- MS Access, Oracle 9i/10g, Sybase, SQL Server 2012,2016,2019, Teradata 130, Hive
Certification
- I am a Informatica Certified Developer (8.X)
- Oracle Certified Associate (OCA)
- Completed Financial Markets – A Beginner’s Module
- Data Science Foundation
- Introduction to Career Skills with Data Analytics (LinkedIn)
- MONGO DB for SQL Experts
Languages Known
English
Gujarati
Hindi
Kannada
Professional Synopsis
- Over 20+ years of IT industry expertise, specializing in Business Intelligence, ETL, and reporting with Informatica PowerCenter, PowerExchange, and BDM.
- Advanced proficiency in SQL across multiple databases including Sybase, MS SQL Server, Oracle, Teradata, and Hive.
- Comprehensive experience in business requirements analysis, documentation, design, development, UAT, production launch, and post-launch support.
- 12+ years in the Banking sector with knowledge of Core Banking, Trade Finance, Treasury, Wealth Management, and various card and eBanking systems.
- 2+ years in Retail and Capital Markets.
- Close to 2 year in the Health Care sector, collaborating with users and quality departments to meet BI requirements.
- Strong grasp and experience of Data flow, Data Modeling, Dimensional modeling, and schema design using star and snowflake schemas.
- Designed and implemented ETL/Data Warehousing solutions for enhancing data accuracy for reporting across various domains/ platforms.
- Proficient in managing Informatica administrative tasks, issue resolution, and root cause analysis.
- Close to 2 years of hands one experience with Informatica Big Data platforms, Data Lakes, Azure, and Hive.
- Skilled in mass data ingestion from RDBMS to Data Lakes using Informatica.
- Led ETL job migrations from Informatica PowerCenter to BDM platforms.
- Managed data migration projects involving Mainframe to SQL Server and Sybase to Oracle conversions.
- Dedicated to team support and education on process understanding.
- Exceptional analytical, conceptual, and communication skills.
References
Will be pleased to furnish upon request.
Training
- Informatica BDM
- Concepts of Big Data
- Basics of Artificial Intelligence and Machine Learning
- Data Science Foundations
- MongoDB for SQL Experts
Timeline
Senior Data Architect
SEHA
10.2023 - Current
ETL / BI Specialist
Abu Dhabi Islamic Bank
09.2012 - 10.2023
Team Lead / Senior ETL Developer
Accenture
02.2010 - 08.2012
Asst. Systems Engineer
Tata Consultancy Services
06.2007 - 01.2010
Software Engineer
Hewlett Packard
01.2005 - 06.2007
M.Sc. - IT
Sikkim Manipal University
B.Sc. - Computer Science
Mount Carmel College