SANKARESHWARAN S

ad2blc@r.postjobfree.com +91-975******* Chennai, India

Scholastic Record

Sri Krishna Arts & Science College Bachelors in Computer Application Coimbatore 2017 – 2020 Cumulative GPA: 7.0%

Skill Set

• Python

• SQL

• Power BI

• Amazon Web Services

• Microsoft Business Intelligence

• Data Visualization

• Data Migration

Databases: MSSQL Server 2017, Postgresql 12.9

Tools : Power BI, MSBI Data Tools, Pycharm, WinSCP, Putty, Symphony OneIT. Work Experience

HTC Global Services Engineer Chennai Nov. 2020 – Present Client: Clix Capital Services Pvt.Ltd

• Interacted with mangers and users to understand and analyse the Business Requirement and Implemented the requirement on production based on Business Requirement Document as per SDLC life cycle.

• Successfully migrated huge volume of Customer & Finance data from Oracle 12c to a Postgres 12.9 using SQL Server Integration Services (SSIS).

• Implemented Amazon Auto Scaling Group (ASG) in production servers and modified load balancing algorithm to ensure that application was able to handle multiple transactions, resulting in a 50% reduction in latency and 90% uptime of servers.

• Exposure in writing complex SQL queries using Joins, Sub queries and analytical functions to generate classic reports & Dashboards through logical scripts.

• Monitored long-running queries and created Indexes to fine-tune the queries in production environment to optimize CPU & Memory utilization.

• Skilled in analysing & debugging REST API services based on their curl code, request & response.

Projects

Executive Summary Dashboard:

Skills: PowerBI, Data Modelling, Data Cleansing

• Cleaned unstructured & poorly formatted data to improve their quality.

• Designed a star schema by identifying required dimensions and facts

• Built Power BI Dashboard to visualize business KPI’s monthly revenue, Returns, Sales.

• Built Visualizations to show the sales & Customer detail with real time data. ETL Solution for Data Validation:

Skills: SQL Server, SQL Server Integration services, Data Analysis

• Loaded data from CSV file to SQL Server table and moved the Source file to archive folder.

• Matched the Loaded data with another table in SQL server based on business condition.

• After validation, only matching data will export to excel file from SQL server. Personal Details

Email ID : ad2blc@r.postjobfree.com

Mobile No : +91-975*******

LinkedIn Profile : linkedin.com/in/sankareshwaran-s Current Location : Chennai