KAMAL KUMAR JESU RANJAN
Adamstown,Ireland
Summary
Professional with expertise in Azure technologies, including Azure Data Factory, Data Lake Storage Gen2, and Databricks. Demonstrated skills in data analytics and visualization using Power BI and Tableau, with additional experience in Snowflake and AWS S3. Proficient in version control and CI/CD practices with GitHub, GitLab, and Bitbucket, alongside Docker containerization and API development. Experienced in Agile/Scrum project management with JIRA and Confluence, enhancing team collaboration through SharePoint and Teams.
Overview
26
26
years of professional experience
2012
2012
years of post-secondary education
Work history
Data Analyst cum Engineer / Senior Developer
BNY Mellon
Dublin
2022.08 - 2024.03
- Built and maintained Azure Data Factory pipelines to ingest CSV and JSON data into Azure Data Lake Storage.
- Organised data in ADLS using Bronze, Silver, and Gold layers for efficient processing.
- Executed data transformations with Databricks (PySpark/Python) while monitoring pipeline performance.
- Developed Power BI dashboards for analysing financial transactions related to income and expenses.
- Utilised SQL to extract, join, and transform data from transactional databases and CSV/Excel files.
- Ingested raw data into Amazon S3, ensuring datasets were structured for consistent reporting.
- Automated data refreshes and dashboard updates in Power BI to improve reporting efficiency.
- Created GAMO GUI to enable effective management of user access rights for Geneva operations team.
Application Support Analyst
First Derivatives
Dublin
2021.07 - 2022.07
- Validated API integrations for Fenergo KYC platform using Postman and Swagger.
- Developed Tableau dashboards to monitor onboarding metrics.
- Maintained Agile documentation in Confluence, enhancing project transparency.
Team Lead / Application Support Engineer
Prodapt (Virgin Media)
Dublin
2021.01 - 2021.06
- Executed migration from ASP Classic to ASP.NET Core APIs, enhancing system performance.
- Designed ETL procedures and automated dashboards for improved service metrics visibility.
- Managed an offshore team of 8 developers, ensuring alignment with client stakeholders.
Senior Application Support Analyst
TCS (Aer Lingus)
Dublin
2020.02 - 2020.12
- Supported baggage kiosk systems through SQL diagnostics and issue resolution.
- Produced operational dashboards and conducted user acceptance testing reports.
- Collaborated on release testing to ensure functionality and performance standards.
Application Support Analyst
Orbis Mes Ltd
Dublin
2019.07 - 2019.09
- Executed system changes for FMCG clients including Guinness, Glanbia, and Mondelez.
- Extracted and validated data to produce weekly reports for clients.
Backend Developer
BNY Mellon
Dublin
2015.04 - 2019.06
- Migrated VB6 tools to C# ASP.NET MVC applications, enhancing software performance.
- Developed reconciliation systems and automated reporting workflows to increase efficiency.
- Integrated Oracle, SQL Server, and Excel-based sources for streamlined enterprise reporting.
Business Transformation Analyst
Citi Bank Ltd
Dublin
2013.01 - 2014.01
- Executed migration of Access databases to enhance data accessibility.
Generated financial reports for informed decision-making.
Business Transformation Analyst
Northern Trust
Dublin
2011.01 - 2013.01
- Optimised fund establishment procedures and elevated KPI reporting standards.
Senior Shareholder Services Associate
Morgan Stanley
Dublin
2011.01 - 2011.12
- Automated compliance documentation.
Senior Administrator
Custom House Global Services
Dublin
2008.01 - 2009.01
- Contributed to NAV calculations and upheld AML compliance.
- Undertaken complex diary management for busy executives.
- Negotiated contracts with vendors, securing favourable terms for the company.
VB Developer → DBA → Migration Lead
CAMS
Chennai
1998.01 - 2006.01
- Led Oracle SQL-based data migration for mutual fund clients.
Education
B. Com - Commerce
St. Xavier's College
India 1994.06 - 1998.04
PG Diploma - Computer Science
St. Joseph's College
India 1998.06 - 1999.04
MCA - Computer Science
Bharathidasan University, Trichy
Chenai, IndiaSkills
- Azure services expertise
- Data integration and storage
- Data analytics and visualization
- Version control systems
- Containerization technologies
- API development and testing
- Project management methodologies
- Collaboration tools and documentation
Project
Tech Stack: Azure Data Factory (ADF) | Azure Data Lake Storage Gen2 (ADLS) | Azure Databricks | Azure SQL Database | Postgres | Azure Synapse
Worked on couple of projects for the Azure Data Engineering Trainer, where the company and data are confidential. The project is in relation to the replication of real time project, which was worked with dummy data.
Career Enhancment Training and Projects
Tech Stack: Azure Data Factory (ADF) | Azure Data Lake Storage Gen2 (ADLS) | Azure Databricks | Azure SQL Database | SSMS | Power BI
Data Source (Kaggle): Adventure Works / Amazon Prime & Netflix / Mutual Funds
Architecture
Project Overview
1. Data Ingestion (ADF)
· Ingested transactional, customer data from a Dockerized PostgreSQL source using ADF. Designed scalable pipelines to support data loads.
2. Data Lake Design (ADLS Gen2)
· Implemented Bronze–Silver–Gold architecturefor raw, refined, and aggregated data. Standardized data storage using Parquet format.
3. Data Transformation (Azure Databricks)
· Performed data cleansing, enrichment, normalization using PySpark. Calculated business KPIs.
4. Data Warehousing (Azure SQL DB & Snowflake)
· Published Gold-layer KPI datasets to Azure SQL Database and Snowflake. Enabled downstream analytics and reporting use cases.data cleansing, enrichment, normalization using PySpark. Calculated business KPIs., Data Warehousing (Azure SQL DB & Snowflake), Published Gold-layer KPI datasets to Azure SQL Database and Snowflake. Enabled downstream analytics and reporting use cases. ETL Processing Project, Azure Data Factory (ADF), Azure Data Lake Storage Gen2 (ADLS), On Prem SQL Server, Postgres SQL, Kaggle: Customer Churn Analytics / COVID-19 Analytics/E-Commerce Sales Analytics, Designed and implemented end-to-end ETL pipelines using ADF. Configured Self-Hosted Integration Runtime (SHIR) to securely integrate on-prem SQL Server and PostgreSQL., Implemented full and incremental data loads and ingested data into ADLS Gen2 using optimized Parquet/CSV formats., Organized data using Raw, Curated, and Presentation layers to support scalable analytics. Performed data transformations and data quality validations using ADF Mapping Data Flows., Scheduled, monitored, and optimized pipelines using ADF triggers, logging, alerting, and performance tuning.
Personal Information
- Nationality: Irish
- Work Permit / Visa Status: Irish Passport Holder
- Ethnicity: Indian Origin
Timeline
Data Analyst cum Engineer / Senior Developer
BNY Mellon
2022.08 - 2024.03
Application Support Analyst
First Derivatives
2021.07 - 2022.07
Team Lead / Application Support Engineer
Prodapt (Virgin Media)
2021.01 - 2021.06
Senior Application Support Analyst
TCS (Aer Lingus)
2020.02 - 2020.12
Application Support Analyst
Orbis Mes Ltd
2019.07 - 2019.09
Backend Developer
BNY Mellon
2015.04 - 2019.06
Business Transformation Analyst
Citi Bank Ltd
2013.01 - 2014.01
Business Transformation Analyst
Northern Trust
2011.01 - 2013.01
Senior Shareholder Services Associate
Morgan Stanley
2011.01 - 2011.12
Senior Administrator
Custom House Global Services
2008.01 - 2009.01
PG Diploma - Computer Science
St. Joseph's College
1998.06 - 1999.04
VB Developer → DBA → Migration Lead
CAMS
1998.01 - 2006.01
B. Com - Commerce
St. Xavier's College
1994.06 - 1998.04
MCA - Computer Science
Bharathidasan University, Trichy