Lidiya
lidugirma@gmail.com
571-351-9198
Philadelphia, PA 19093
SQL Developer
15 years experience W2
2
Recommendations
Average rating
368
Profile views
Summary

  • Complete understanding of Software Development Lifecycle and core area of experience in validating end-to-end business scenarios of B2B (Business to Business) applications, Enterprise Applications developed expertise in SSIS/SSRS.
  • Good exposure to entire Software Life cycle Phases (Feasibility, System studies, Design, Coding, Testing, Implementation and Maintenance).
  • Experience in creating Index, Views, complex Stored Procedures, appropriate user defined functions (UDF) and effective Triggers to facilitate efficient data manipulation and data consistency on Microsoft SQL Server database platform.
  • Having over 5 years of strong ETL and data integration experience in developing ETL mappings and scripts using Microsoft SSIS.
  • Extensive experience in MS SQL Server 2008/2008R2/2012/2014 and solid hands on experience in installing, configuring, managing, monitoring and troubleshooting SQL Server in Dev, Testing and Production environments.
  • Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2012/2014.
  • Proficient with SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)/SSDT, SQL Profiler, Performance Monitor. Experienced with the creation of SSIS packages in Data Extraction, Transforming, and Loading (ETL) from various sources using SQL Server Integration Services.
  • Extensive experience with writing T-SQL scripts, stored procedures, triggers and functions, creating SQL Server Jobs/alerts, and scheduled tasks to automate tasks.
  • Strong experience with server/database/scripts Performance tuning and optimization.
  • Experience with monitoring, troubleshooting and resolving database issues in 24×7 production environment.
  • Strong experience with SQL Server performance monitor and performance tuning, maintenance and SQL Server version upgrade.
  • Results-Driven with ability to take initiatives and meet deadlines in a fast paced changing environment Strong analytical and communication skills with the enthusiasm to learn new technologies.

Experience
Education
Computer Science Addis Ababa University
Skills
Database Design
2021
8
SQL
2021
7
SQL Server
2021
7
SSRS
2021
7
ETL
2015
6
OPTIM
2022
6
SSIS
2021
6
BI Developer
2014
5
Database Backups
2014
5
Project Management
2014
5
BSA
2021
4
Data Conversion
2021
3
Data Integrity
2021
3
Agile Methodology
2021
1
Auditing
2015
1
Business Analysis
2015
1
Business Intelligence
0
1
Business Requirements
2015
1
Data Integration
0
1
Data Warehousing
2015
1
Erwin Data Modler
2021
1
JIRA
2021
1
Microsoft Excel
2021
1
MS Access
2021
1
Oracle
2021
1
Performance Tuning
0
1
SQL Developer
2021
1
SQL Server Developer
2015
1
Stored Procedure
2015
1
T-SQL
2015
1
T-SQL Developer
2015
1
Triggers
2015
1