Bala Chandar
Chennai
Summary
Dynamic Data Architect with over 13.8 years of experience at specializing in data engineering and architecture. Proven track record in developing robust ETL processes and BI dashboards, enhancing data quality and delivery. Skilled in team leadership, successfully led multiple teams to streamline data services, driving impactful results in high-stakes environments.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Data Architect
Hash Agile Technologies
Coimbatore
08.2024 - Current
- Domain – HealthCare, SupplyChain
- Clients – TrailCard, DeltaTrak, InHouse Product
- Responsibilities - Data Architecture and managing end to end data delivery.
- TrailCard : Setup a team of eight members from the scratch who are responsible for end to end data migration from legacy systems to Salesforce
- Used ADF & SQL Server to do the migrations
- Built generic framework for input DQ checks and BI dashboard for data analysis.
- DeltaTrak : Data ingestion from Postgres, Kafka, to Snowflake using AirByte.
- Data transformation using DBT Core for transformation and integration of multiple sources to create data marts in Snowflake.
- Build multiple BI dashboards in SuperSet for Shipment/Device track monitoring
- Product : Data Flow Monitor - Product development
Software Prod & Plat Engg Associate Manager (Data Engineering)
Accenture
Chennai
06.2018 - 07.2024
- Domain – Patent Risk, Pharma, EComm
- Clients – RPX, Roche, Loreal Paris
- Responsibilities - Data Architecture & Development of ETL pipelines for new features
- Below is a list of Products and Features I have worked on:
- Roche : LDM for Clinical Vault data warehouse and Data mapping for inbound & outbound flows
- Data Validation procedures in Snowflake for inbound data
- Loreal : Integrate multiple data sources using FiveTran and load to Snowflake.
- Develop models in DBT Core for data transformation to multiple data marts (analytics mart/ science mart)
- RPX : Led a team of ten members who are responsible for managing whole data services
- Designed and implemented PAIR Data Warehouse along with ETL processes for loading
- Developed BI Dashboard for ETL Job monitoring and Data Intake Flow monitoring
- Created Spark ETL Pipeline for Examiner metrics, SOLR Indexing, fetching data from various sources including Postgres, MongoDB, and Amazon S3, and indexing it into Apache SOLR
- Implemented ETL for loading Image File Wrapper into AWS S3
- Executed Pentaho ETL process pipeline for IFI Patent Data Integration
- Constructed a Custom Report Generation Framework and Job for sending reports periodically in different formats
- Scraped data of Judges, Lawyers, and District courts from US public sites using Python
- Developed Data Quality measure framework
- Developed Patent Alias framework for Asset Matching
Software Engineer - Level 2
YuMe
Chennai
11.2016 - 06.2018
- Domain – AdTech
- Products – YFN, YDMP & YFA
- Data modeling and ETL process for new Products/Features
- List of Products and Features worked:
- ETL process pipeline for Sampling and Forecasting
- ETL process pipeline for tracking conversion and segment pixel
- ETL– MOLAP – Multidimensional Data split for report
- Geo Data Refresh: Maxmind data updated process
- Data Modeling from Conversion Pixel & Cross Device features
- Generic Bulk Upload framework: Campaign / Placement Load
- Audience Inventory & Campaign Publisher – Reports – ETL Process
Senior Software Engineer
iLink Multitech Solutions
Chennai
10.2015 - 08.2016
- Domain – Oil/Gas
- Clients – Halliburton/ PETRONAS / ZADCO
- Well Event Management
- Spearheaded requirement gathering and solution brainstorming for iLink, driving the process from inception to implementation
- Collaborated with an international team, taking charge of the entire ETL module and ensuring the successful delivery of the products
- Designed and developed BI Web parts in Pentaho CDE and integrated with application portal
- Worked in Migration/transformation of raw source data
- Worked in Developing Teiid VDB
Software Engineer
Solartis Technology Services Pvt. Ltd
Madurai
05.2011 - 10.2015
- Domain – Insurance Policy administration
- Clients – STARR, AllRisks, Seneca, Liberty
- Worked on Data Modeling for new features – OLTP & OLAP for Insurance Policy lifecycle
- Worked in development of Generic import/ migration (between OLTP to OLAP) framework
- Worked in development of DB driven Rule flow (Decision table) for Insurance & created multiple reports using Pentaho reporting server & Power BI
- Worked as Delivery lead for multiple features with team of 5 members
Education
B.Tech - Information Technology
Mepco Schlenk Engineering College
Sivakasi04.2011
Skills
- Data Engineering
- Data modeling
- Cloud architecture
- RDBMS
- Snowflake
- SQL programming
- Data migration
- Warehouse models
- Database optimization
- ETL processes
- Master data management
- Metadata management
- Business Intelligence (BI)
- ELT Tools
- Data quality
- Team leadership
- Data analysis
Area of Expertise
- Data Model design - OLTP & OLAP Modeling
- Tools: Erwin; Power Architect; Workbench
- ETL - Pentaho DI (Kettle), Python, pySpark
- Business Intelligence (BI) - Power BI, SuperSet, Grafana, Pentaho CDE, Metabase
- ELT - FiveTran, DBT Core, AirByte, PeerDB
- Databases - Postgres, Snowflake, MySQL, MSSQL, Oracle, MongoDB, Hive, Big Data, Hadoop
Websites
Accomplishments
- Team Management: Build and led multiple teams from the scratch for end to end Data Services.
- BI Dashboard Creation: Developed BI dashboards that enhanced report accuracy using realtime data monitoring.
- ETL Pipeline Management: End to End data delivery from Intake to DW.
- Data Accuracy Improvement: Improved data accuracy through new data quality measure frameworks.
- Have On-Site Experience and worked with international clients directly.
Certification
- AWS Certified Data Analytics - Specialty 2023
- Data Architect, MIT Professional Education 2023
- AWS Certified Solution Architect 2021
Timeline
Data Architect
Hash Agile Technologies
08.2024 - Current
Software Prod & Plat Engg Associate Manager (Data Engineering)
Accenture
06.2018 - 07.2024
Software Engineer - Level 2
YuMe
11.2016 - 06.2018
Senior Software Engineer
iLink Multitech Solutions
10.2015 - 08.2016
Software Engineer
Solartis Technology Services Pvt. Ltd
05.2011 - 10.2015
B.Tech - Information Technology
Mepco Schlenk Engineering College
Similar Profiles
Rajeswari BeheraRajeswari Behera
Associate Software Engineer at Hash Agile TechnologiesAssociate Software Engineer at Hash Agile Technologies
Harika AkulaHarika Akula
Senior Quality Assurance Engineer at Hash Technologies LLCSenior Quality Assurance Engineer at Hash Technologies LLC
Justin JosephJustin Joseph
Senior Software Developer at Razorpay Pvt Ltd (Payroll - Agile Hire Technologies)Senior Software Developer at Razorpay Pvt Ltd (Payroll - Agile Hire Technologies)