SUMMARY

• Over all 7+ years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2012/2008/2005.
• Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.
• Excellent experience in SQL Server Programming (T-SQL), Integration services (SSIS), Analysis Services (SSAS), Notification Services and Reporting services (SSRS) in SQL 2005/2008R2/2012.
• Proficient in SQL Server and T-SQL in constructing Tables, Normalization techniques on database Tables.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Excellent experience in maintaining Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Excellent experience in developing stylish Drill Down, Cascading, Drill through, Parameterized, Sub reports and Charts using Global Variables, Expressions and Functions using SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Developed Cubes using SQL Analysis Services (SSAS).
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Operating Systems: Windows 2003 Enterprise Server, XP, 2000, 2008, 2012, Windows XP Professional, UNIX, Linux

Web Servers: IIS, Tomcat and Apache

Programming skills: C, C++, HTML, JavaScript, T-SQL, PL/SQL, Java, C#, ASP, ASP.NET, VB.NET, XML, MDX

Databases: MS SQL Server 2000/2005/2008/2012/2014, Oracle 8i/ 9i, 10g/11g

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS)(SSAS), (SSRS), Import Export Data, Bulk Copy Program (BCP), Talend Open Studio

Tools: Used SQL Enterprise Manager, SQL Server, Management Studio, SQL SERVER Profiler, Query Analyzer, Database Engine Tuning Advisor, SQL, Prompt, Team Viewer, VNC, Power DesignerSpy Schema.

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

SQL/BI DEVELOPER

Responsibilities:

• T-SQL development in database object creation and data manipulation with Tables and Views, User Defined functions, Indexes, Stored Procedures, CTE, Constraints and Triggers.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2014 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Restructuring existing data structures to increase performance.
• Processing analyses and design throughout the database implementation.
• Transformed data from one server to other servers using SQL Server Integration Services(SSIS).
• Developed data visualization reports and built dashboards using MicrosoftPowerBI to translate data into visual representations.
• Designed and modified existing packages accordingly by using the transformation tasks such as Lookup, derived column, condition split, union all, copy column, aggregate and audit transformation.
• Advised on SQL optimization, stored procedure design and other Database performance issues.
• Performed database backup and restore.
• Resolved bugs.

Confidential, Addis Ababa, Ethiopia

SQL DBA/DEVELOPER

Responsibilities:

• Creating table, Writing Stored Procedures, Triggers and User Defined Functions for the benefit of users.
• Creating Indexes whenever it is required by analyzing the queries
• Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Identify columns for Primary Keys in all the tables at the design time and create them.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Designed dynamic DTS and SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Created packages using DTS and SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
• Created many rich and highly interactive Web forms for user management module using ASP.Net 2.0, VB and HTML.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Upgraded MS SQL Server 2000 database to MS SQL Server 2005, by using Detach/Attach, Back up & Recovery.
• Moved the static data from various text files to SQL Server 2005 database using BCP Import and Export, Bulk Insert.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Provided support to the application developers on the application databases.
• Configured and Deployed different reports in the Servers using SQL Server 2005 Reporting Services.

Environment: MS SQL Server 2005, ASP.Net 3.5, C#.net 3.5, ADO.Net, Business Intelligence Development studio, Microsoft.NET, MS Office Access 2003, MS Office, MS Outlook 2003, VBScript

Confidential, Addis Ababa, Ethiopia

SQL DEVELOPER

Responsibilities:

• Involved in Table Design and creation of indexes.
• Interact with the users to understand requirements and document them.
• Analyzing the system requirements, business logic and specific line of business.
• Involved in Tuning of queries to enhance Performance.
• Involved in the Data migration activities to load the Data into different DB Schemas.
• Effectively supporting for decision making throughout the organization.
• Reviewed many T-SQL issues using management studio for better performance.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• Created many complex Stored Procedures / Functions and used them in to generate reports on the fly.
• Providing consultation on SQL Server to our development teams.
• Endure that the code is written keeping in mind any security issues such as SQL Injection.
• Develop reports in SQL Server Reporting Services.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Interacted with the business users to gather information about the report.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.

Environment: SQL Server SQL Server v2008/2008R2, Win NT v4, win 2000, Win 2003