Balasubramani Palanisamy
BI Engineer
Bangalore
Summary
Highly-motivated Data Science Engineer 15 years experienced in delivering quality results across demanding projects. Applies excellent systems understanding and engineering knowledge to resolve complex technical issues. Evolves thinking and practices to improve department abilities and opportunities.
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
13
13
years of professional experience
Work History
Business Intelligence Lead
American Express
10.2019 - Current
- SMART is a business Intelligence reporting tool that provide standardized reporting and analytic through an easy to access, self-service interface. Provides BI teams with advanced reporting capabilities on market place intelligence, spend trends across all industries.
- Collaborated with Product Owner and other colleagues to identify requirements, detect problems and deliver improvements through analysis, reports and data management.
- Communicated with clients to discuss project details, review deliverables and receive sign-off before implementation.
- Worked in Power Platform Power App, Power Automate, Power BI and One App with Power BI Integration.
- Built end-to-end ETL pipelines using AWS Glue + PySpark, processing large-scale datasets for analytics teams.
- Designed and maintained Airflow DAGs for ingestion, validation, and transformation workflows, improving pipeline reliability.
- Implemented S3–Athena–Glue Catalog data lake structure, enabling seamless querying and metadata management.
- Migrated legacy Hive scripts into modular Airflow DAGs, improving orchestration, transparency, and failure recovery.
- Converted complex HQL queries into optimized BigQuery SQL with improved performance and reduced query cost.
- Scheduled, monitored, and maintained Airflow jobs, ensuring smooth execution of daily/weekly ETL pipelines.
- Refactored Hive-based workflows into PySpark/BigQuery-compatible transformations, modernizing the data ecosystem.
- Implemented parameterized Airflow DAGs using Python operators, reducing code duplication and simplifying maintenance.
- Instance, CDP pipeline for the code deployment in production
Talend ETL Lead
Mind tree
01.2018 - 10.2019
- Akzonobel basically paint manufacturer Industry Company in UK and across the world delivering the products. Consume the upstream web service call data and migrate the data from mongodb database collection.
- Discussed and analyzed business functionality with the AKZONOBEL team, developers to make new Talend ETL rules, modifications.
- Team handling and code review for junior resources code.
- Deploy the Talend ETL code in bit bucket Git and merge the code in dev branch environment.
- Creating the Adhoc reports and Dashboard, Implemented Row Level, Column Level Security.
- Talend ETL Development and Talend Admin Console (TAC) Deployment process.
BI Engineer
Nalashaa Solution
08.2017 - 01.2018
- Mums, the largest program within the Sage Screening Program family, is a breast and cervical cancer screening program. For eligible women, Sage provides free office visits for breast and cervical exams, as well as a screening mammogram and Pap tests. If one of your screening tests shows a problem, Sage covers many diagnostic services and can often connect to treatment coverage, if needed. Sage partners over 400 clinics throughout the state.
- Discussed and analyzed business functionality with the Mums team, developers to make new reports, modifications.
- Migrating and modifying existing Jasper reports as per new requirements.
- Create new Input Controls, Drop down lists, resource bundles on the Jasper Server.
Software Engineer
Avankia Software Solution
04.2013 - 08.2014
- Assessed linkages between system components and implemented improvements to optimize connectivity, compatibility and functionality.
- Formulated functional specifications to support systems developers.
- Implemented PayPal Integration in Salesforce Apex Development using Rest call.
- Created few Apex Development and Salesforce triggers.
Education
Bachelors of Technology -
Bannari Amman Institutes of technology
Erode, Tamilnadu01-2007
Diploma in Information Technology - undefined
Rajaji Institutes of Technology
Salem, TN01-2002
Higher National Diploma - Science
Gugai Higher Secondary School
Salem, TN01-2000
Skills
- Talend ETL, Pentaho ETL
- BI Reporting tool Power BI, Jasper BI, BIRT, and SSRS
- Power App, Power Automate
- AWS Glue ETL, AWS Quick sight
- Google big query, Google Data studio
- AWS, AWS Quick Sight, ETL
- Domo BI, AWS Redshift
Friendly, positive attitude
ADDITIONAL INFORMATION
- Certified Google Data Engineer
- Certified Post graduate Diploma Data Science Engineer in Amity University.
- Certified Data Analytics from Cornell University
- Certified PL 300 Power BI Data Analyst
- Talend ETL Data Integration Certification In Progress.
- AWS AI Practitioner certification in progress
Timeline
Business Intelligence Lead
American Express
10.2019 - Current
Talend ETL Lead
Mind tree
01.2018 - 10.2019
BI Engineer
Nalashaa Solution
08.2017 - 01.2018
Software Engineer
Avankia Software Solution
04.2013 - 08.2014
Diploma in Information Technology - undefined
Rajaji Institutes of Technology
Bachelors of Technology -
Bannari Amman Institutes of technology
Higher National Diploma - Science
Gugai Higher Secondary School