Uploaded File
Lidiya
MS SQL BI Developer
Philadelphia, PA
Check for availability
Actively seeking
Lidiya
90
views
MS SQL BI Developer
2 recommendations
2
Recommendations
Average rating
90
Profile views
SQL SSRS SQL Server SSIS ETL BI Developer Database Backups Microsoft Excel MS Access Erwin Data Modler
Remove Note
View Note
Recent Experience
SQL Developer 06/16 - present
SQL SQL Server Oracle SSIS SSRS Agile Methodology SQL Developer Erwin Data Modler MS Access Microsoft Excel JIRA
Sr. MS SQL Server Developer (T-SQL, SSRS, SSIS) 02/15 - 12/15
SQL Business Analysis Business Requirements Stored Procedure SQL Server ETL SSRS T-SQL Triggers Auditing T-SQL Developer Data Warehousing
MS SQL BI Developer 05/09 - 12/14
SQL SQL Server ETL SSIS SSRS Database Backups BI Developer
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.

Top 5 Skills
SkillsProficiencyLast Used
SQL
2018
SSRS
2018
SQL Server
2018
SSIS
2018
ETL
2015
Education and Certifications
Computer Science Addis Ababa University
Preferences
Availability:
Willing to relocate?:Yes
Relocation preference
Any location
Prepared to Travel:No travel (0%)
Employment Type:Any
Security Clearance:No clearance
Citizenship:Employment Authorization Document