Shalini S

About Shalini S

Presently working as Software Engineer at HCL Technologies from Jan 2021 to till date.• Establishing a track record of 3+ years of experience in the project Ryder and OTIS as Data Analyst.• Excellent hands-on Experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS.• Experience in by using Row Transformations, Block and Unblock Transformations for Performance Tuning in SSIS packages.• Acquire data from primary or secondary data sources and maintain databases/data systems.• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.• Utilized Power BI (Power View) to create various analytical dashboards.• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.• Used different type of Filters available in Power BI for creating reports.• Developed reports like Parameterized, Drill Down, Drill Through, Tabular, Cascading reports by using Power BI.• Modified reports as per new requirements.• Troubleshoot T-SQL, SSIS errors and performance issues and address them as required.• Wrote complex SQL queries involving multiple tables from different databases using Joins, Stored Procedures, Temporary tables, functions.• Involved in Normalization and De-Normalization of tables for faster query execution and data retrieval.• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.• Created and designed several SSIS packages by using Control Flow and Data Flow level elements.Worked on data extraction, transformation and loading the data between various data sources and destinations.• Highly worked on Control Flow and data flow elements like For Loop Container, for- each Loop Container, Sequence Container, Data Flow task, Execute SQL task, Script task, File System task, Send Mail task etc.• Migrated SSIS packages from SQL server 2008 to 2017.• Published dashboard reports to online Power BI could service for the use of report consumers.• Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.• Tuned performance bottlenecks by analyzing SQL statement, creating indexes, using hint, tuning database parameters and using SQL profile and so on.

Experience

1. Senior Software Engineer

   HCLTech

   Oct 2023 — Present

Education

• Kingston Engineering College

  B.E, Electronics and Communication Engineering

  2016 — 2020

• Shri vardhaman jain matriculation higher secondary school

  SSLC

• Shri vardhaman jain matriculation higher secondary school

  Intermedia, Mathematical Biology