Suresh Radhakrishnan

• Through the Azure Databricks have to designed to facilitate data quality, as well as providing recommendations for defining business logic to implement custom rules
• Ingesting the data into the Databricks SQL workspace
• According to the customer input file, implement the ETL queries to extract valid data by using Databricks pipelines
• Through the validation rules monitoring the data quality and cleansing
• Worked with lot of custom development or Enhancement projects to apply new changes or change request and new functionalities
• Involved as a part of requirement gathering and requirement analysis meetings
• Done the Performance tuning for long running Procedures
• Written unit test cases for all requirements

· Working with SQL and SQL Server 2016 development.

· Created Stored Procedures, Functions, Triggers, Views, and Indexes.

· Create SSIS packages to load the data into SQL Server database from different type of files like (.txt, .xls) files.

· Analyzing the requirements and understanding the functionality of both source and target systems.

· Written stored procedures and triggers for development of mobile applications.

· Plan, design and implement application database code objects, such as stored procedures and views.

· Supported all production operation activities, with focus on integration and development of new and existing products and services.

· Participating in regular status meetings and prepared weekly reports on the status of the application.

· Working with SQL and SQL Server 2016 development.

· Create SSIS packages to load the data into SQL Server database from different type of files like (.txt, .xls) files.

· Worked with different type of Transformations like Derived column, conditional split, multi casting, lookup, Union all, OLE DB command, and some custom transformations.

· Implemented Environment variable, Parent package variable and SQL Server configuration for SSIS Packages.

· Implemented Error handling using Event handlers and implemented Logging using SQL Server Logging.

· Worked with lot of custom development or Enhancement projects to apply new changes or change request and new functionalities.

· Done the Performance tuning for long running Procedures.

· Create unit test cases for all requirements.

· Analyzing the requirements and understanding the functionality of both source and target systems.

· Developing a frontend to explore the Employee data by their Salary and personal information wise also connect with their records from Backend by using SQL Server 2012.

· Leave information such as applying leave like PL, CL, and ML etc. All are developed both front end by using RVW 3.0, DW report and backend in the projects.

· Workflow logics developing for Approval leave, separation, Allowances, timesheet approvals for the Middle East countries.

· Supported all production operation activities, with focus on integration and development of new and existing products and services.

· Evaluating the requirements and understanding the functionality of both source and target systems.

· Developing a frontend to explore the Employee data by their Salary and personal information wise also connect with their records from Backend by using SQL Server 2012.

· Leave information such as applying leave like PL, CL, and ML etc. All are developed both front end by using RVW 3.0, DW report and backend in the projects.

· Workflow logics developing for Approval leave, separation, Allowances, timesheet approvals for the Middle East countries.

· Supported all production operation activities, with focus on integration and development of new and existing products and services.

· Participating in regular status meetings and prepared weekly reports on the status of the application.

· Responsible for getting, Understanding the business specifications, preparing technical specifications, DTS packages.

· Responsible for creating appropriate loaders and relational writes to load data from SSIS.

· Using different transformations like excel source, data conversions, Lookup, OLEDB command, derived columns, OLEDB destinations etc.

· Plan, design and implement the database objects such as Stored Procedures and Triggers, Cursors.

· Build and maintain indexes and complex queries for data analysis and extraction.