Arun Palanisamy Online Resume

Jun 2019

Present

Lead Developer

Alfa Laval Lund, SE

Development and maintenance of Alfa Laval's assortment control process that identifies which parts are currently being used and which can be terminated.
Created complex Stored Procedures, Joins, Cursors, Triggers, Functions (UDF), Indexes, Tables, Views, Constraints for Assortment control.
Developed wide variety of SQL code with features like CTE, Window/Ranking Functions, Recursion, Linked Server, PIVOT, XML PATH etc.,
Developed reports and dashboards in Power BI from multiple data sources for MDM framework and Assortment reporting.
Implemented several DAX functions for various fact calculations and efficient data visualization in Power BI.
Involved in creating data visualizations like Donut Chart, Line Chart, Slicer, Card, Maps, Tables, Slicers, Drill Down Reports etc.,
Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task etc.,

Environment: SQL Server 2012/2016, SSMS, SSIS, SSAS, T-SQL, Power BI, Teamcenter, NX, Python, Visual studio 2013/2015

Jan 2019

Jun 2019

Senior Developer

ZF Friedrichshafen, DE

Developed customized interactive reports using PL/SQL and Oracle Apex.
Upgraded several ZF internal application from oracle apex 3.2 to 18.2.
Migrated to Apex universal theme.
Improved performance of several report response by fine tuning the SQL queries.
Resolved all migration related issues by replacing deprecated functions with recent efficient functions.

Environment: Oracle Apex 3.2, Oracle Apex 18.2, Oracle SQL, PL/SQL, JQuery ,JavaScript

Jun 2017

Dec 2018

Senior Developer

Nokia Networks Finland, FI

Team Lead and Service Delivery Manager(SDM) for Nokia's MDC Data Quality Application.
Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
Effectively made use of Packages, Stored Procedures, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Joins, Sub-Queries and Dynamic SQL for developing Apex applications.
Experience in using several built-in database packages such as DBMS_JOB, DBMS_OUTPUT and DBMS_SCHEDULER .
E2E responsible for continuity of a running application / infrastructure, and for ensuring service quality and security. Also verifying and monitoring delivery / operational processes.
Managed integration related issues with Enovia and SAP P20 systems.
Experience in developing interactive grid, interactive reports, classic reports and forms using Oracle APEX.
Project planning and management of Demand Releases.
Evaluated and improved development work of other developers on team, working to provide training, constructive criticism and knowledge transfer.

Environment: Oracle Apex 3.2, Oracle 11g,PL/SQL, JQuery, JavaScript, Enovia, SQL * Plus, SQL Developer.

Jan 2016

May 2017

Developer

Nokia Networks Finland, FI

Development, Support and Maintenance of MDC Data Quality (DataQ) Application using Oracle Apex, PL/SQL, JavaScript.
Handled critical incidents and service requests.
Application server management : Oracle HTTP server 11g / 12c.
Well understood process related topics (SNOW) with hands on knowledge of Incident, Change, Demands and Problem.
Solving all integration related issues and application bug fixes - Unix File permissions, Firewall port issues, DB link issues, Grant privileges
Experience in backup and recovery procedures of databases and ITSC manual.
Handling Availability & Performance automated scripts for DataQ

Environment : Oracle 11g, SQL*Plus, PL/SQL ,SQL Developer, JQuery, Javascript

Jan 2014

Dec 2015

Junior Developer

Nokia Networks Finland, FI

Responsible for Data validation of migrated data from MxPDM to Enovia.
Developed PL/SQL packages, functions and stored procedures for comparing migrated data with original data to identify the mismatches.
Involved in Data migration of hardware sales items from panasonic to Enovia.
Developed TCL scripts for creating, modifying , expanding and connecting objects.
Involved in creating several Excel macros and PowerQuery.

Environment : Oracle 11g, SQL*Plus, PL/SQL ,SQL Developer, TCL

Arun Palanisamy