Summary
Overview
Work history
Education
Skills
Timeline
Generic

Pradeep Balan

Leeds

Summary

Accomplished data integration specialist with expertise in Talend, Databricks, and AWS services including Lambda and Athena. Proficient in Oracle technologies such as PL/SQL, Data Integrator, and Warehouse Builder, as well as SAP Hana and Sybase IQ. Adept at leveraging these skills to optimise data processes and drive efficiency. Committed to advancing data management strategies within dynamic environments.

Overview

21
21
years of professional experience

Work history

Sr ETL Engineeer

Evri
Leeds
2019.11 - Current
  • Executed ETL development with Talent 7.2/8.0, streamlining data integration processes.
  • Configured ESB jobs for efficient message consumption from RabbitMQ to SAP HANA DB.
  • Designed ETL processes optimising workflows for extraction, transformation, and loading.
  • Transferred data from various sources including DYNAMODB ,Oracle OCI to SAP HANA DB.
  • Implemented bulk loading procedures from SAP HANA to SYBASE via Talend.
  • Developed Python scripts for message replay to RabbitMQ and system adaptability.
  • Enhanced data security using advanced encryption techniques and strict access controls.
  • Migrated existing Talend jobs to Databricks, improving scalability and efficiency.

Senior software developer

JD Sports PLC
Manchester
2014.04 - 2019.11
  • Developed innovative software solutions, enhancing system performance and user experience.
  • Led migration of legacy systems to modern platforms, enhancing operational efficiency.
  • Populated data warehouse using PL/SQL scripts, facilitating accurate reporting.
  • Transferred historic data from legacy systems to Retail Analytics.
  • Converted Oracle reports into BI Publisher formats, improving report accessibility and user engagement.
  • Developed detailed packages and procedures for generating BI Publisher reports.
  • Designed subject areas for comprehensive report generation.
  • Administered version control procedures, safeguarding code integrity and preventing data loss.

Senior software developer

Mastek Ltd,Uk
Mumbai - India/ Leeds-UK
2008.05 - 2014.03
  • Analyze requirements and translate business needs into technical solutions
  • Defect fixes in ETL in UAT using ODI
  • Creating merchandising reports in Oracle BI Publisher Reports.
  • Bursting of reports using BI Publisher reports
  • Configuration for Bursting reports based on store number and delivering the same to the respective store
  • Architected and Implemented Physical and Logical Data Models based on Functional and Technical Requirements.

software Designer

  • Translate the logical data model to physical data model, and decide the optimal partitioning.
  • Design the Fact / Dimension tables (Star Schema) for Data warehouse
  • Design aggregate tables and Materialized views for Data Marts BI Reports
  • indexing strategy for warehouse and mart tables

Software engineer

Tata Consultancy Services LTD, India
Mumbai - India
2005.05 - 2008.04
  • Developed mapping for Data Warehouse population using Oracle BI tools to support data integration efforts.
  • Benchmarking and tuning ETL processes with Oracle 10g, SQL Trace, TKPROF, and AWR.
  • Generated dashboards and reports using OBIEE Answers.
  • Created design documents and physical models for comprehensive data mapping.
  • Maintained technical documentation to facilitate future project reference and enhance team collaboration.
  • Resolved complex programming issues to ensure uninterrupted system functionality.
  • Established user authentication protocols via external tables to enhance security.
  • Engaged with clients to gather requirements, estimate tasks, and ensure project deadlines were met.

Education

Bachelor Computer Applications -

Tilak Maharashtra University
Pune /India

Skills

  • Talend 61, 701, 80
  • Databricks
  • AWS Lambda function
  • AWS Athena GLUE
  • Oracle warehouse builder (OWB)
  • Oracle Data Integrator (ODI)
  • Oracle PL/SQL
  • SAP Hana
  • Sybase IQ

Timeline

Sr ETL Engineeer

Evri
2019.11 - Current

Senior software developer

JD Sports PLC
2014.04 - 2019.11

Senior software developer

Mastek Ltd,Uk
2008.05 - 2014.03

Software engineer

Tata Consultancy Services LTD, India
2005.05 - 2008.04

Bachelor Computer Applications -

Tilak Maharashtra University
Pradeep Balan