Ugandar Hari Email & Phone Number

Melbourne, VIC, AU

Melbourne, Victoria, Australia

• Enhancing ETL processes by ingesting the data related to Novated Leasing, Salary Packaging and Fleet Management into Azure Data Lake from multiple source applications such as SQL Server, Azure SQL Database and JSON.
• Incorporated new source from Azure SQL Database by creating new linked service, creating new pipelines and loaded the raw data into Snowflake Database.
• Incorporated new columns from SQL Server to the existing table in Snowflake DB – end to end by executing the recovery process to update the ConfigDB, pointing the database to the recovery tables and triggered the ADF.
• Transformed the data using DBT Cloud, by creating DBT models, tests and snapshots and loaded the transformed data into Snowflake Database.
• Created DBT macros to perform generic and custom tests to test the data issues, unique, not-null, duplicate issues, to generate merge query for incremental load and masking policies for PII data (Personally.
• Deployed the Azure Data Factory pipelines (ARM templates) and DBT models using Azure DevOps by creating feature branches and pull requests.

Australia

• Integrated Databricks with DBT Core, transformed the data using Models and loaded the transformed datainto Databricks SQL Warehouse.
• Worked in Singular and Generic Tests to perform the query testing before loading the data into DWH.
• Invoked Macros from the DBT Models to convert the date columns and to find the difference between twodates.
• Created Jobs and Delta Live Tables to build Lakehouse architecture in Databricks and managed taskorchestration.
• Migrated the code changes using Databricks repos to higher regions.
• Coordinated with cross applications platforms such as FFL, SDWX and SDS2 to understand the regressiontesting efforts.

Melbourne, Victoria, Australia

• Interacted with stakeholders to define project goals, scope, performance requirements, timelines and deliverables.
• As a Technical Lead, I have been involved in design discussions, allocated tasks to Data Engineers, performed code reviews and made sure my team members are on the same page.
• Mentored and trained the Data Engineers, supported them to grow their technical skills and understanding of best practices.
• Created an End to End pipeline in Azure Synapse Analytics workspace to extract, transform and load.
• Extracted the data from source system applications (On-premises SQL Server) and ingested into Azure Data Lake Gen2 using Data Factory pipeline.
• Transformed the data using Databricks Notebooks and converted the data into delta file format in the Spark pool.

Adelaide, South Australia, Australia

• Worked in Azure resources including Azure Data Lake, Data Factory, Databricks, Synapse Analytics andPower BI.
• Created Azure Data Factory pipeline and ingested the data from SQL Server On-premises database andloaded the data into Data Lake Storage Gen2.
• Worked on reading multiple source data formats such as SQL database, csv and text files and convertedinto delta file format.
• Integrated Databricks Notebooks into Data Factory pipeline, transformed the data using PySpark scriptsto create type2 dimensions and transaction data and loaded them into Data Lake Storage.
• Created tables in Snowflake, loaded the data using Azure Data Factory into Snowflake database, analysedthe data by creating storage integration, stage and executed copy command to insert the records.
• Scheduled the Data Factory pipeline using triggers to automate the ingestion, transformation and loadingof delta data into Data Lake Storage and Snowflake database.

Chennai, Tamil Nadu, India

• Interacting with clients, requirements gathering and preparing requirement specification and design documents for project deliverables.
• Migrated existing on-premises application to Microsoft Azure.
• Created Data Factory pipelines to ingest the data from the source, executed Databricks instances to transform the data using PySpark scripts.
• Loaded the transformed data into SQL Database for reporting purpose based on business users' need.
• Analysed the data by connecting the SQL Database in MS SQL Server Management Studio and updated the PySpark code based on the query output.
• Managed Azure Active Directory to create security groups and added users in the groups to give resource groups access to the security groups using IAM roles assignment.

Chennai, Tamil Nadu, India

• Analysed the specification document and Mainframe jobs.
• Involved in initial study of system, coordinated requirements gathering sessions with business analysts, end users and people from other applications.
• Involved in impact analysis, preparation of requirement specifications and design documents (High Level and Low Level Design) for project deliverables.
• Involved in source to target mapping document and migration of Mainframe batch components to the ETL target system.
• Developed sequencers and jobs in Datastage Designer and a process to check if source and target are in sync.
• Scheduled the jobs and executed them using Autosys.

India, USA