We provide IT Staff Augmentation Services!

Sql/bi Developer Resume

4.00 Rating

Addis Ababa, EthiopiA

SUMMARY

  • Over 9+ years of experience in IT industry which includes 8+ 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.

Environment: MSSQL Server 2012, 2014, SQL Server Integration Services(SSIS), T-SQL, MDX, XML, Data Transformation Services (DTS), Win Server 2008, 2012, Unix, Linux, Win XP/NT, MS SQL Reporting Services(SSRS)

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

Confidential, Addis Ababa, Ethiopia

Technical Support Specialist (System Database Administrator)

Responsibilities:

  • Provided Technical Support to IBM’s corporate clients all over the North America
  • Helped customers regarding their IT related needs and provide best solutions for their software, hardware or networking requirements
  • Fixed issues by using technical knowledge, troubleshooting and problem solving skills
  • Provided technical knowledge and training after the solution implementation or issue resolution
  • Installed, configured and supported different applications, system and database software which includes Windows, Linux, Lotus Notes, SQL Server, Ms Office and more
  • Acted as a mentor for newly hired or junior associates when necessary
  • Helped others at the department level in maintaining and improving service level

Environment: SQL Server, Windows NT/2000/XP, Linux, Lotus Notes

We'd love your feedback!