Professional Summary:

Highly motivated SQL server developer with over 9 years of IT experience in database and business intelligence technologies with expertise on ETL process, SSIS and SSRS.

Strong experience with T-SQL (DDL & DML) in implementing and developing stored procedures, triggers, nested queries, joins, cursors, views, user defined functions, indexes, user profiles, relational database models.

Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.

Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.

Experience in error handling and debugging coding issues and troubleshooting production issues.

Expertise in SQL Server Integration Services (SSIS).

Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.

Transformed data from one server to other servers using Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).

Excellent knowledge of scheduling jobs and alerts using SQL Server Agent.

Ability to handle Multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.

Good ability to quickly grasp and master new concepts and technologies

Worked with Business Analysts, Web development team, and users on Microsoft Business Intelligence solutions.

Tools and Technologies:

Database Tools: SSIS, SSRS

Languages: T-SQL, C#,

IDE: Visual Studio 2003-2022

Operating Systems: Windows Server 2000, 2003, 2008, 2012,2016,2019

Case Tools: MS Visio

Version control: TFS, Jira, Git

Methodology: Agile, Waterfall

Education:

BSC In Electrical and Computer Engineering

Certifications:

Microsoft Certified: Azure Fundamentals

DevOps Foundation Certification

Professional Experience:

RSI - Willington, DE August 2019 to Present

Sr. SSIS/SQL Developer

Responsibilities:

Involved in creating functional and technical specification documents after gathering requirements from business.

Create complex functions, scripts, stored procedures and triggers to support application development.

Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Experience in SSIS script task, look up transformation and data flow tasks using T-SQL and C# scripts.

Experience with SSIS performance tuning using error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with C# in SSIS.

Extensively used SSIS transformations such as script component, Cache Transformation, Lookups, Multicast, Derived column, Conditional split, Execute SQL task, Data conversion, Row count and Send Mail task etc.

Created ETL Extraction Strategy architecture as part of Development plan to extract and load data from source systems to staging.

Experience in importing/exporting data between different sources like Access/Excel/Flat file etc. using SSIS.

Used Script task component and established iterative load for faster retrieval and improve performance.

Experience in ETL processes involving migrations and in sync processes between two databases.

Experience in creating configuration files to deploy the SSIS packages and scripts across all environments.

Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Created SSIS packages for File Transfer from one location to the other using FTP task.

Involved in performance tuning of TSQL queries, Stored Procedures and SSIS.

Optimized query performance by creating missing indexes.

Capable of functioning in an agile development environment, at times extracting data to enable discovery to help refine report specifications.

Environment: Microsoft SQL Server 2016, Microsoft Data tools, SQL Server Integration Services (SSIS), Visual Studio 2019 and 2017, TFS as a version control.

Howard Bank - Arlington, VA June 2018 to August 2019

Sr. SQL Server SSIS/SSRS/T-SQL Developer

Responsibilities:

Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from SQL Server 2012 MS Excel and Flat files.

Used various transforms in SSIS to load data from flat files to the SQL databases.

Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.

Prepared Visio diagrams/documents to track and implement the blueprint of the ETL dataflow/process implementation from Initial phase, Ongoing, Deployment to Production Environment.

Created SSIS packages to mitigate into the data warehouse database from heterogeneous databases/data sources.

Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.

Worked on Design and implement row level data warehouse security.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages

Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).

Configured Reporting Services in SQL Server 2008R2.

Generated Reports using Global Variables, Expressions and Functions for the reports.

Write Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2012.

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad and PL/SQL Developer.

Implemented Event Handlers and Error Handling in SSIS packages.

Used Visual Team Foundation server for version control, source control and reporting.

Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views using T-SQL code and SQL joins for applications.

Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.

Involved in Normalization and De-Normalization of existing tables for faster query retrieval.

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.

Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.

Environment: SQL Server 2012, 2014 Enterprise Edition, Microsoft Visual Studio 2012 MDX, T-SQL, MS Access, MS Excel, Windows 2008 Server, OLAP, Visual basic .NET.

One Medical- Willington, DE August 2016 to 2018 May

Sr. SQL BI Developer

Responsibilities:

Analyze, design, develop, implement and maintain different processes/jobs by using Pervasive Data Integrator and SSIS.

Assist with implementation of new business, products or contracts by the analysis of business requirements.

Apply in-depth knowledge of systems and business to the development of technical design for large complex processes and projects.

Evaluate trading partner requests for new and modifications to existing applications and programs/processes /maps.

Conduct research and make recommendations on ETL products, services, and standards in support of procurement and development efforts.

Participate in project meetings, providing input to project plans and providing status updates.

Creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.

Maintain detailed documentation and process flows of all data integration and EDI processes. Created new and existing processes are appropriately documented, including both technical and user documentation.

Create and Modify Processes and maps, according to the business. Performing the ETL operations to support the data loads and transformations for EDI Processes.

Create Datasets, Maps, also and Process using Pervasive Data Integrator. Handled pipe delimited files, fixed format files in pervasive data integrator.

Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files and loading into SQL server.

Created Data Flows for Aggregate, sort, lookup, merge, union all and fuzzy lookups and Used containers for repetitive control flow tasks.

Worked with production support team for a while to handle high priority issues.

Created SSIS Packages to integrate data coming from Text files and Excel files.

Monitoring of processes to automate the process of loading data into data targets and assist the team to schedule daily/weekly/monthly jobs.

Participate in project meetings, providing input to project plans and providing status updates.

Deployed pervasive process to production servers, scheduled the process to run daily, weekly, monthly loads.

Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.

Environment: Microsoft SQL Server 2012/2008 R2, Microsoft Data tools, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Windows Server 2008R2.

ZTE, Addis Ababa, Ethiopia Mar 2014 to Jan 2016

Sr. SQL Server SSRS/SSIS Developer

Responsibilities:

Involved in migration from SQL Server 2005/2008 to 2012

Used Data Flow task, execute package task, Execute SQL Task, for each loop container in SSIS for transformation of the data.

Created SSIS Packages to import the data from different databases, XML, text files, Excel files.

Used the SSIS Import/Export, migrated the Database such as Oracle and Access database, flat files to SQL server 2008.

Convert business requirements into actionable technical requirements for the project.

Performed data conversions from flat files into a normalized database structure.

Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) has assigned.

Created awesome dashboards with Power Pivot.

Developed optimal stored procedures and queries to create data sets for reports.

Expert in creating Star schema cubes using SSAS.

Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.

Sound Knowledge and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.

Good understanding of SSRS with Report authoring, created weekly and monthly reports as per requirement using SSRS.

Configured mail tasks to know the job status of SSIS packages.

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.

Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.

Used SSRS Report Manager to assign roles, permissions and to create report schedules.

Designed the ETL for merge operation as migration was to be done in phases with the view of shutting down old processes as transition happens to new data warehouse, old becoming void eventually.

Build database queries and test cases for the testing team to test the reports.

Environment: SQL Server 2008/2008 R2/2012, SQL Query Analyzer, SQL Profiler, SSIS, SSRS, SSAS, Windows Server 2003/2008, OLAP, Crystal Reports, XML, XSL, .Net, Visual Studio 2008, ETL, MS Excel, MS Access.

Ethio telecom, Addis Ababa, Ethiopia July 2013 to Feb 2014

SQL Server Developer

Responsibilities:

Involved in the Requirement Analysis, Design phase and Development phase of SDLC model system.

Worked closely with Business Analysts to produce all required documentation.

Worked with Product Development Team to architect Database Design and strategy.

Worked with Business Users to architect Data Warehouse strategy based on reporting, analytical and dishoarding requirements

Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.

Created, insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.

Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Developed SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.

Involved in deploying, configuring and managing reports using Report Manager and Report Builder.

Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.

Migrated data from various sources into SQL Server 2008 using SQL Server Integration Services 2008.

Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.

Developed SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Implemented & managed database clustering, failover and load balance technologies as per client requirement.

Developed, tested & implemented a robust database backup and recovery strategy with client assistance.

Reviewed and fine-tuned stored procedures and triggers before production migration.

Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.

Developed entity-relationship diagram and data dictionary for project coordination; created SQL create, alter, and insert scripts.

Environment: MS SQL Server 2012/2008, SSIS, T-SQL, .NET, Visual Basic 6.0, XML, MS SQL Query Analyzer, SQL Profiler, Visual Studio 2010, MS Access, Excel, SQL Profiler, Team Foundation Server, Windows 2007.

Contact this candidate