Summary
Overview
Work History
Education
Skills
Certification
Tools And Technology
Training
Timeline
Generic

Teferi Tobo

Rockville,MD

Summary

Over 8 years of in-depth experience in Software Design, database design, development, administration and maintenance of SQL Server 2016,2017, 2014/2012/2008/2008R2/2005/2000 large scale databases. Excellent experience level skills in Objects creation such as Tables and Views, Table Normalization, created Data Types, user functions, views, user profiles, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency. Excellent experience in writing T-SQL queries, creating clustered and non-clustered Index, working on Data transformation, Cleansing and Data Migration. Extensive experience in Microsoft stack of BI solutions - SSRS, SSIS with MS SQL 2012/2008/2005. Proficiency in creating diverse types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and Updating existing SSRS, Power Bi and crystal report. Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server. Experience in Extraction & Migration of Data from heterogeneous data sources Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities. Experience in transforming unstructured data from various data sources using SSIS Transformations Conditional Split, Data conversion, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data. Used change data capture (CDC) control task that makes efficient data loading (incremental load after initial loading of data). Created SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors. Knowledge in migrating DTS packages, reports and analysis services projects from SQL Server 2000/2008/2012 to SQL Server 2005/2008/2012/2014. Experienced in database server performance tuning and optimization of Complex SQL queries. Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance. Performed DBA tasks using Enterprise Manager and Query Analyzer. Accomplished in creating Packages, configure SQL server jobs, scheduling set up alerts. Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures. Participate in planning, implementation, and growth of our infrastructure on Amazon Web Services. An excellent team player& technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project 24x7 Production Database on Call Support.

Overview

8
8
years of professional experience
1
1
Certification

Work History

SQL Developer

Eastpointe
01.2023 - Current
  • Closely work with customer to collect and analyze data before star coding
  • Wrote Complex Stored Procedures, Triggers, Views and Queries
  • Created indexes, Constraints and rules on database objects
  • Wrote and implement SQL Stord procedure, vies and SQL quires for data input to crystal report
  • Test and modify existing crystal reports and deploy to web server for customer usage
  • Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS)
  • Used SQL Server Agent to automate the SSIS package execution and configure different alerts
  • Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2017/2019 and then created reports using this data using SSRS
  • Set up database backup and recovery strategies
  • Maintained all records of project status and followed changes as per control procedures
  • Provided technical support to internal developers and external clients
  • Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

SQL / ETL Developer

Envision
Remote
12.2022 - Current
  • Wrote Complex Stored Procedures, Triggers, Views and Queries
  • Created indexes, Constraints and rules on database objects
  • Developed stored procedures to transform data from enterprise data warehouse to SQL server and load data to dimension and fact tables
  • Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target destination by performing different kinds of transformations and data cleaning using SQL Server Integration Services (SSIS)
  • Configure SQL Server Agent to automate the SSIS package execution and fallow up on job execution and configure different SQL job alerts
  • Prepare deployment packages, scripts and change document to push to production and follow up and validate if the change completed successfully to all environments
  • Scheduled and monitored all maintenance activities of SQL Server database consistency checks and index defragmentation
  • Maintained all records of project status and followed changes as per control procedures
  • Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications
  • Optimized schema, performance, and capacity planning of various data transformation processes related to the reports
  • Make sure that standards and best practices in database development were followed and maintained and documented
  • Work closely with analyst to understand the requirements for developing
  • Work on assigned tasks, Attend Standup/Planning/Issues review/Change Control and Customer facing meetings as representative of the team.

SQL, ETL, SSRS Developer

Magellan Health Maryland
02.2020 - 10.2022
  • Create Complex Stored Procedures, Triggers, Views, Cursor, Constraints, user and system functions and decision-making statements on database objects to address different issues and monitor those identified issues
  • Worked closely with SME’s end users/internal customers to understand project/requirement scope
  • Support on Requirements gathering, Analysis and Design of all the client requirements
  • Analyze system problems, determine root cause, initiate corrective action, and provide follow up to ensure that correction is made
  • Create different SQL scripts to address Issues and resolve client incident issues within set service agreement
  • Identifies, automates and implements business process efficiencies using SSIS and SSRS BI solutions
  • Designed new ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS) and upgrade different existing Packages
  • Data warehouse development viz
  • Requirement’s analysis, application design, development (including ETL and database), code migration, testing, and implementation in Production environment, Production support and on call support for night jobs and weekend support
  • Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages
  • Enhanced the functionality in database and data warehousing
  • Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS
  • Update existing SSRS by updating different views and stored procedures used to generate the reports
  • Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
  • Provide Production Support in terms of incident management: identifying issues, reporting incidents, escalations, troubleshooting, problem resolution in a timely manner, and post implementation reviews.

SQL/ETL developer

Thermo Fisher Scientific
Boston Tewksbury, MA/Remote
06.2019 - 01.2020
  • Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards
  • Understand user requirements and Data Model defined and developed by the business analysts and data architects
  • Implemented different types of constraints on tables
  • Designed and applied entity and attributes description and definition for the models
  • Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases
  • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler
  • Created ETL process using SSIS to Extract, Transform and Load source data into respective target tables to build the require Datawarehouse
  • Update the existing Package depending on the requirement and update the table, procedure if required
  • Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS
  • Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source)
  • Experience in developed C# scripting for packages using Scrip task when required
  • Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages
  • Enhanced the functionality in database and data warehousing
  • Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases
  • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency
  • Migrated data from IBM-DB2 to SQL Server 2008/2012/2016/2017 with SQL Server Integrated Services (SSIS)
  • Complete Jira ticket assigned in specified sprint on production support and different issues.

SQL/SSIS/SSRS developer

Duluth trading
Wisconsin, Madison
06.2018 - 05.2019
  • Wrote Complex Stored Procedures, Triggers, Views and Queries
  • Created indexes, Constraints and rules on database objects
  • Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system
  • Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS)
  • Develop C# code in as per requirement in developing SSIS Package
  • Used SQL Server Agent to automate the SSIS 2008/2015 package execution
  • Developed stored procedures to transform data from enterprise data warehouse to SQL server and load data to fact tables
  • Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS2012/2014 and then created reports using this data using SSRS
  • Configured and maintained Report Manager and Report Server for SSRS
  • Identified and added the report parameters and created the reports based on the requirements using SSRS 2015
  • Tested and managed the SSIS 2015 packages and was responsible for its security
  • Scheduled and monitored all maintenance activities of SQL Server 2016 including database consistency checks and index defragmentation
  • Set up database backup and recovery strategies
  • Designed and Implemented the Stored Procedures and Triggers for automating tasks
  • Maintained all records of project status and followed changes as per control procedures
  • Provided technical support to internal developers and external clients
  • Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications
  • Expertise in offshore onsite model
  • Coordinating teams
  • Following ups
  • Follow standards and best practices in database development and work with team to archive the set delivery date.

MS SQL Developer / BI Developer

Capital one
Mclean, VA
05.2016 - 05.2018
  • Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications bathed on set requirements
  • Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous data sources (SQL Server, Flat Files, Excel source files, XML files etc.) Designed and developed data load jobs using SSIS package and scheduled in SQL Agent
  • Wrote stored procedures and User Define Scalar and table-valued Functions (UDFs) to be used in the SSIS packages and SQL scripts
  • Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions
  • Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008R2/2012 Analysis Services (SSAS) and Reporting service (SSRS)
  • Developed tabular and Matrix Reports like Drill down, Drill through, sub reports and parameterized reports using SQL Server Reporting Services 2008 R2
  • Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS)
  • Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference
  • Used Bulk Copy program (BCP) to import and export substantial amounts of data in and out of SQL Server databases
  • Participated in Databases Architecture and data modeling design
  • Inspected the reports and fixed bugs in stored procedures and tuned Reporting Services to the T-SQL
  • Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided
  • Database Administration, Production and Development Support
  • Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring
  • Worked closely with SME’s end users/internal customers to understand project/requirement scope and involved in providing solution to implement or support production issues
  • Reviewed and developed data models and database designs with development teams
  • Worked on Agile Methodology and Microsoft Team Foundation Server (TFS).

Education

Bachelor In Engineering -

Skills

  • Software Design
  • Database design
  • SQL Server 2016, 2017, 2014/2012/2008/2008R2/2005/2000
  • Objects creation (Tables, Views)
  • Table Normalization
  • Data Types
  • User functions
  • Data integrity
  • Performance tuning
  • Indexes
  • Triggers
  • T-SQL queries
  • Data transformation
  • Data cleansing
  • Data migration
  • Microsoft stack of BI solutions (SSRS, SSIS)
  • Cross-Tab reports
  • Drill-down reports
  • Summary reports
  • Parameterized reports
  • Sub reports
  • Updating existing SSRS, Power Bi, and Crystal reports
  • SSIS Packages
  • Import Export Wizard
  • DTS SSIS
  • BCP & Bulk Insert utilities
  • SSIS Transformations (Conditional Split, Data conversion, Lookup, Merge Join, Sort, Derived Column)
  • Change data capture (CDC)
  • Migrating DTS packages, reports, and analysis services projects
  • Database server performance tuning
  • Optimization tools (Index tuning wizard, SQL Profiler, Windows Performance Monitor)
  • DBA tasks using Enterprise Manager and Query Analyzer
  • Packages creation
  • SQL server jobs configuration
  • Capacity Planning
  • Disaster Recovery
  • Troubleshooting
  • Backup and Restore procedures
  • Amazon Web Services infrastructure planning and implementation
  • Team player
  • Technical strength
  • 24x7 Production Database on Call Support
  • Crystal reports
  • ETL packages
  • SQL Server Agent
  • Deployment packages
  • Scripting
  • Change document
  • Maintenance activities
  • Production support
  • Test data generation
  • Schema optimization
  • C# scripting
  • Jira ticket management
  • SQL code standards
  • Data modeling
  • OLAP cubes
  • SQL Server 2005/2008R2/2012 Analysis Services (SSAS)
  • SQL Server Reporting Services (SSRS)
  • Bulk Copy program (BCP)
  • Database Administration
  • Performance monitoring
  • Agile Methodology
  • Microsoft Team Foundation Server (TFS)
  • Visual Basic
  • JAVA script
  • Microsoft Office Tools
  • Windows Server 2000, 2003, 2008, 2008R2, 2012
  • Backup Utility
  • Lite Speed for SQL Server
  • Visio
  • Microsoft SQL Server 2012/2014 Databases administration
  • Microsoft SQL Server 2005, 2008, and 2008R2/2012
  • Microsoft Office tools (Word, Excel, Access TM, PowerPoint)
  • Bachelor In Engineering

Certification

Microsoft /Administering Microsoft SQL Server 2012/2014 Databases.

Tools And Technology

SSIS and SSRS, SQL Server Reporting Services (SSRS), Report Builder, Visual Basic, C#, T-SQL, basic knowledge on JAVA script, Microsoft Office Tools, Windows Server 2000, 2003, 2008, 2008R2, 2012, Backup Utility, Lite Speed for SQL Server, Visio

Training

  • Microsoft SQL Server 2005, 2008, and 2008R2 /2012
  • Microsoft Office tools (Word, Excel, Access TM and PowerPoint).

Timeline

SQL Developer

Eastpointe
01.2023 - Current

SQL / ETL Developer

Envision
12.2022 - Current

SQL, ETL, SSRS Developer

Magellan Health Maryland
02.2020 - 10.2022

SQL/ETL developer

Thermo Fisher Scientific
06.2019 - 01.2020

SQL/SSIS/SSRS developer

Duluth trading
06.2018 - 05.2019

MS SQL Developer / BI Developer

Capital one
05.2016 - 05.2018

Bachelor In Engineering -

Similar Profiles

CREATE PROFILE
Teferi Tobo