Sathish Kumar Palanivel Email & Phone Number

Helsinki, Uusimaa, Finland

Helsinki, Uusimaa, Finland

Espoo, Finland & Chennai, India

• Client: Nokia Networks (Espoo, Finland)Technologies: Azure Databricks, Pyspark, Python, Azure SQL DW, Azure Data Lake Analytics, ADF, Azure Automation Runbooks, Data Vault 2.0, Azure SQL Database, Power BI, Azure.
• Working with product owners and other stake holders to gather functional and technical requirements and architect the design for developing analytical solutions
• Involved in Data modelling preparation and provided the solution to team for implementation
• Worked on Integration to BI system from various source including SAP BYD, Salesforce, Oracle using Azure Automation Account, Data Lake Analytics,Databricks and Data Factory
• SQL Development in Azure Synapse Analytics(DW) with modelling Data Vault 2.0(Hub, Sat, Link)
• Worked on PowerShell and Python for Automation and Machine Learning

Chennai, Tamil Nadu, India

• Client: HMD Global Oy (Espoo, Finland)Technologies: Azure Data Factory, Azure SQL Data Warehouse, Azure SQL Database, Azure Blob Storage, PowerBI, AAS and Azure IaaS & BI ComponentsResponsibilities:
• Played a key role in cloud migration of data warehouse and analytics systems in one of the important areas of the client´s business.
• Worked on dimensional & Fact data model for Azure SQL Data Warehouse
• Worked on Pipeline design and development in Azure Data Factory to load Fact & Dimension data from upstream systems to Data Warehouse and for data export to downstream system based on business requirement
• Optimized several SQL procedures by utilizing the parallel processing techniques in Azure Data Warehouse
• Extensively worked on cloud migration of on-prem Informatica Workflows to Azure Data Factory Pipelines

Espoo, Finland

• Client: Microsoft Mobile Oy(Finland)Technologies: SSIS, Teradata, Informatica, PowerBI, Oracle & Unix Shell scriptingResponsibilities:
• Worked on Detailed Transformation Design document for Informatica Mappings and Workflows
• Created reusable teradata Bteq scripts incorporated with shell scripts to be used in Informatica tasks
• Worked on migration from Informatica workflows to SSIS packages
• Implemented various level of phases on dataload such as staging, truncate, load ready and presentation layer of data warehouse in Teradata
• Optimization and performance tuning on Teradata and Informatica for data load and extract

Chennai Area, India

• Client: Nokia Corporation(Finland)Technologies: Teradata, Informatica, Tableau, Oracle, SQL Server, Java, Unix Responsibilities:
• Data quality validation between layers and fix the issue on any deviation
• Created Teradata scripts in Bteq, Mload and Fload for complex and bulk data operation for production support
• Informatica workflow monitoring, trouble shooting and fixing the issues in case of any failure
• Created Adhoc workflow, Oracle stored procedure for data loading for support task and developing new workflow based on business requirements for minor enhancement
• Troubleshooting production application issues and report into development team, Data quality monitoring between Oracle and Data warehouse on daily basis to make the data reliability for business operation