Aarti Salaria
Dinanagar
Summary
Motivated, teamwork-oriented, and responsible Data Analyst with 3 & half year of experience in SQL, Dashboard & Reports designing. Skilled in SQL, sub-Queries, Query Optimization, writing Stored Procedure, SQL Views, SQL Queries, SQL Joins, User Defined Functions, Triggers, Indexes, CTE, SQL agent scheduler.
Overview
4
4
years of professional experience
Work History
SQL Developer
Arcstone Pte. Ltd
Mohali
07.2019 - Current
- Analyzed existing SQL queries to identify opportunities for improvements.
- Created optimal technical solutions to user needs with in-depth system analysis.
- Developed, implemented and optimized stored procedures and functions using T-SQL.
- Performed regular database backups to prevent information loss.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Work closely with the development team to provide support for database objects (stored procedures/triggers/views)
- • Design, create, and implement database systems based on the end user's requirements
- Analyses existing SQL queries for performance improvements.
- Create complex scripts, stored procedures, functions and triggers.
- Perform daily performance monitoring.
- Take a backup & restore backup according to requirement.
- Work on multiple projects same time.
- Schedule SQL agent jobs according to requirement.
- Build Informatic dashboards and custom reports according to requirement.
- Create OEE and OLE dashboards.
- Improve dashboards loading speed.
- Generated reports from data to support business decision-making and business performance monitoring
- Expertise in Dashboard designer tool and Custom report designer tool.
- Performed deployments, analysis, testing, debugging, implementation and documentation of the visualizations created by the tools.
- Working on several databases of client server and managed their project directly.
- Working on company’s tool as well like creating triggers or alerts as per the requirement, inserting/updating data into the tables etc.
- Giving presentations on company tools to my teammates and also giving training sessions to Junior teammates.
Education
B.Tech - Information Technology
Beant College Of Engg & Tech, Gurdaspur, Punjab
Gurdaspur07.2019
12th - Non-Med
S.S.D.A.V.Sr.Sec.School, Dinanagar, Punjab
Dinanagar2015
Skills
- Designing Dashboards/ Reports
- T-SQL Coding
- Query optimization
- Client Requirements
- Bug Fixes
- Documentation Management
- Basic knowledge of Power Bi, Tableau, SSRS, HTML, CSS
- Database Structures Expertise
Timeline
SQL Developer
Arcstone Pte. Ltd
07.2019 - Current
B.Tech - Information Technology
Beant College Of Engg & Tech, Gurdaspur, Punjab
12th - Non-Med
S.S.D.A.V.Sr.Sec.School, Dinanagar, Punjab
Similar Profiles
Ayesha BegumAyesha Begum
Software Engineering Lead at ArcstoneSoftware Engineering Lead at Arcstone
Pankaj Sunny RaiPankaj Sunny Rai
Sales Director at Quality Air Solutions Pte Ltd / Yihui Metals Pte LtdSales Director at Quality Air Solutions Pte Ltd / Yihui Metals Pte Ltd
Md Alamgir KabirMd Alamgir Kabir
HSE Officer at Seatrium SG Pte Ltd (Sembcorp Marine Pte Ltd).HSE Officer at Seatrium SG Pte Ltd (Sembcorp Marine Pte Ltd).
Varsha RaniVarsha Rani
Asst Professor at Beant Singh UniversityAsst Professor at Beant Singh University
AAKSHI MAHAJANAAKSHI MAHAJAN
HEAD( Management & COMMERCE DEPARTMENT) at Swami Sarvanand Institute of Management and TechnologyHEAD( Management & COMMERCE DEPARTMENT) at Swami Sarvanand Institute of Management and Technology