Uploaded File
Lidiya
lidugirma@gmail.com
571-351-9198
Philadelphia, PA 19093
MS SQL BI Developer
13 years experience W2
2
Recommendations
Average rating
210
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
SQL Developer
Information Technology
Jun 2016 - present

  • Designed, developed, tested, and implemented SSRS reports with multi-parameter and interactive sorting capability for business teams.
  • Developed Complex SQL queries using various joins. Tuning long-running SQL Queries, Procedures and Functions using SQL Profiler, SQL analyzer.
  • Develop script for manipulating data and ensure data integrity.
  • Designed, created and regular tuned of physical database objects (tables, views, indexes) in MS SQL Server 2012 to support normalized and dimensional models.
  • Create logical and physical data models.
  • Used SQL Server Profiler to trace long running queries for optimizing databases.
  • Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, and Oracle to SQL Server using SSIS various features such as multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion.
  • Work on Erwin, agile development process and JIRA.
SQL SQL Server Oracle SSIS SSRS Agile Methodology SQL Developer Erwin Data Modler MS Access Microsoft Excel JIRA Data Conversion Data Integrity Database Design BSA
Remove Skill
References
Average Rating

1 recommendation
Sr. MS SQL Server Developer (T-SQL, SSRS, SSIS)
Information Technology
Feb 2015 - Dec 2015

  • Partner with data and business analysts to refine the business requirements that must be met for building and maintaining data warehouses/marts built on Microsoft SQL Server 2012.
  • Designed, created and regular tuned of physical database objects (tables, views, indexes) in MS SQL Server 2012 to support normalized and dimensional models.
  • Worked as a primary T-SQL developer in creating complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
  • Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Data Balancing & Reconciliation, Exception Handling & Reject Recycling, Surrogate Key Generation & Assignment, Data Lineage Tracking, ETL Auditing, etc.
  • Used SQL Server Profiler to trace long running queries for optimizing databases.
  • Troubleshot SQL Server related CPU/Memory, I/O using Performance Monitor; Collaborated with system teams and development teams for codes release including MSSQL database changes and patches.
  • Documented All MSSQL database structures and functionalities. Worked with Auditors and Provided Database related documents.
  • Worked on 24x7 on-call rotation to support the production environment.
SQL Business Analysis Business Requirements Stored Procedure SQL Server ETL SSRS T-SQL Triggers Auditing T-SQL Developer Data Warehousing SQL Server Developer Database Design
Remove Skill
MS SQL BI Developer
Information Technology
May 2009 - Dec 2014
  • Designed and deployed SSIS packages using various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Slowly Changing Dimension, Aggregate, Conditional Split, and Derived Column Transformations.
  • Transformed data from MS SQL Server 2008R2 to MS SQL Server 2012 using OLE DB connection by creating various SSIS packages.
  • Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
  • Built reports in SSRS for errors generated by SSIS Packages generated Reports using Data Source Views in Report Builder created Drill Down, Drill through, linked and sub reports using SSRS.
  • Generated various type SSRS reports that could be used to send information to different vendors, clients and managers.
  • Scripted several database maintenance tasks reducing manual processes and related overheads.
  • Designed, developed, tested, and implemented SSRS reports with multi-parameter, chart, drill-down, drill-through, sub-report and interactive sorting capability for business teams.
  • Generated variety of business reports using SQL Server 2008 SSRS including matrix report, parameter report, and dashboard with charts and drill down function.
  • Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects. Tuning long-running SQL Queries, Procedures and Functions using SQL Profiler, SQL analyzer, Index tuning wizard.
  • Work with development teams to make best schema design that balances feature requests with performance concerns.
  • Coordinate with the team that responds to all system problems in order to reduce or eliminate production problems by analyzing production usage information and using that information to design a better architecture.
  • Built efficient ETL packages with SSIS to fetch, cleanse and transform data from various types of sources. Develop package configurations dynamically as well as populating variables dynamically.
  • Increase availability and performance of applications by gathering and analyzing server and database metrics with various monitoring tools.
SQL SQL Server ETL SSIS SSRS Database Backups BI Developer Project Management Database Design
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Computer Science Addis Ababa University
Skills
Database Design
2021
8
SQL
2021
7
SQL Server
2021
7
SSRS
2021
7
ETL
2015
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