Data Warehouse Sql Server

Gebeyehu Webe ***********@****.*** 206-***-****

Professional Summary:

● Skilled software professional with over 7 years of IT industry experience with Microsoft SQL Server, Integration Services SSIS, Reporting Services SSRS, Power BI,and Analysis Services SSAS environments.

● Created databases, and tables and provided constraints and user-defined rules and defaults.

● Hands-on experience in Performance Tuning and Query Optimization

● Developed SSIS Packages to Extract, Transform, and Load (ETL) data into the Data warehouse from SQL Server.

● Involved in building a data warehouse and DataMart with Dimensions and Fact Tables based on Business requirements.

● Write Stored Procedures to populate various dimensional tables and fact tables for the Data Warehouse.

● Experience loading facts and dimensions using SSIS Packages on data warehousing projects.

● Designed data structure with multiple facts and dimension tables to hold the source data to be used for building new reports.

● Worked on T-SQL programming, stored procedures, and views while developing Power BI and SSRS reports.

● Understand business requirements in BI context and design data models to transform raw data into meaningful insights.

● Hand-on experience using Azure DevOps, TFS, and GitHub for managing source code changes.

● Worked in Development, Testing, and Production environments.

● Organized, self-starter, and effective team member with excellent problem-solving skills.

● Good team player, Excellent interpersonal and Communication skills combined with self-motivation, initiative, and the ability to think outside the box.

● Expertise in defining the Business process flow and gathering business requirements. SQL Experience:

● Proficient in writing T-SQL Stored Procedures, Triggers, Constraints, Views, Functions, and Indexes using various DDL and DML commands.

● Strong knowledge of Data Warehouse methodologies, including Star and Snowflake schemas.

● Ensured data integrity by creating checks and constraints.

● Optimized query performance by modifying T-SQL queries and working with MySQL and PostgreSQL; performed table normalization, established joins, and created indexes.

● Expertise in performance tuning and troubleshooting, leveraging SQL Profiler for identifying and resolving slow-performing queries.

● Performed DBA tasks such as monitoring job failures and troubleshooting related issues.

● Developed, tested, and implemented Referential Integrity rules and regulations through constraints, triggers, and views within centralized SQL databases.

SQL Server Integration Service (ETL) Experience:

● Designed and implemented complex SSIS packages to migrate data from multiple sources for analysis, deployment, and dynamic configuration.

● Created ETL packages using SSIS to validate, extract, transform, and load data into data warehouse and DataMart databases.

● Transferred data from various OLTP sources, including XML, MS Excel, flat files, and Teradata, into SQL Server (2022/2019/2016).

● Troubleshoot SSIS package processes, resolving issues and enhancing performance.

● Implemented error and event handling techniques in SSIS to ensure efficient package execution.

● Led incremental load processes to transfer data from OLTP systems to data warehouses using various data flow and control flow tasks in SSIS .

● Automated SSIS package execution through SQL Server Agent jobs and Autosys. Technical Skills

Cloud Technologies Microsoft Azure,AZ-900

Databases MS SQL Server 2022/2019/2016/2014, Azure (Cloud Server), Access, My SQL, Oracle .

DWH/BI Tools SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) 2016, SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Informatica, Visual Studio, Cognos, Crystal Reports.Power BI

Operating Systems Windows Server 2013, 2011, 2010, Windows 8/NT/XP/Professional, MS-DOS, Red Hat Linux

Version Control GitHub, Power shell, TFS Azure DevOps Programming

Languages

T-SQL, PL/SQL 11g, Dynamic SQL, MDX, C,C#.NET, C++, C#, ASP (.NET), XML, HTML, VB.NET, VB Script, DHTML, HTTP, Shell Scripting, Tools and Utilities SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual SourceSafe 6.0, DTS, Business, AB Initio Intelligence Development Studio (BIDS), Crystal Reports, Power Pivot, ProClarity, Microsoft Office (MS), Lotus Notes, Excel Power Pivot, Excel Data Explorer, Tableau, Entity Framework, Google Workspace, Microsoft Dynamic

Education/Certifications:

● Bachelor of Arts in Accounting Information Systems AAU, 2017. Professional Experience:

Confidential

SQL/SSIS Developer / Software Engineer July 2022 – Present My key responsibilities include:

● ETL Development & Data Integration: Created and deployed ETL packages to integrate data from diverse sources, including SQL Server, flat files, Excel, XML, and Teradata, into the Data Warehouse. Managed data flow transformations using tools such as Data Conversion, Merge Join, Sort, and Conditional Split, ensuring seamless data migration and transformation across platforms.

● Database Development & Optimization: Wrote complex SQL queries, stored procedures, triggers, views, and defined indexes, constraints, and rules to optimize database performance. Ensured the database design followed industry best practices and maintained high standards of data quality and integrity.

● Data Sourcing & Reporting: Designed data sourcing strategies and performed data quality analysis. Defined and created data source views to map raw data into usable structures. Generated reports for business consumption using Power BI, SSRS, and custom APIs to fulfill business requirements and improve decision-making processes.

● Performance Tuning & Maintenance: Managed and optimized the performance of SSIS 2016/2019 packages, ensuring smooth execution and reliability. Utilized SQL Profiler and Database Engine Tuning Advisor for performance tuning. Monitored and performed database maintenance tasks such as consistency checks, index defragmentation, and scheduled SQL jobs through Autosys.

● Cluster Configuration & High Availability: Installed and configured SQL Server Active/Active and Active/Passive clusters to ensure high availability and fault tolerance. Managed and monitored SQL Server jobs, alerts, and scheduled tasks for smooth operations.

● Automation & Task Management: Automated routine database tasks by developing and implementing stored procedures, triggers, and functions. Managed job schedules for monthly and weekly data feeds, ensuring timely data delivery from multiple sources, including various servers and resources.

● Backup & Disaster Recovery: Designed and implemented database backup and recovery strategies, ensuring data safety and availability in the event of a disaster. Managed data restoration processes to ensure business continuity.

● Documentation & Technical Support: Created and maintained detailed technical documentation for all development work, ensuring proper tracking of changes and adherence to project specifications. Provided technical support to internal teams, testing new solutions and resolving issues in a timely manner. Environment:

MS SQL Server 2022/2019/2016/2014, Visual studio 2019/2017 (SSAS/SSIS/SSRS), Microsoft Access 2016/2010, Microsoft Excel (Pivot Table), OLAP and OLTP, Outlook, MS SQL Profiler, SQL server Query Analyzer, Index Tuning Wizard, DashBoard by Crystal report, Erwin8/7.3/3.5,Windows 2007/2010 Advanced Server/Professional, Window XP, MS Access, My SQL.

KPMG

June 2020 - June 2022 SSIS/SQL Developer New York

● Developed logical and physical database models using ER-win, normalization techniques, dimensional modeling, and Enterprise Manager.

● Optimized schema design, performance, and capacity planning for data transformation processes related to reporting.

● Ensured adherence to best practices and standards in database development, maintaining high-quality, reliable systems.

● Defined and designed data sourcing strategies and data flows, ensuring thorough data quality analysis.

● Identified and defined data sources to create corresponding data source views, facilitating accurate reporting and analytics.

● Wrote complex SQL queries, stored procedures, triggers, views, and defined indexes, constraints, and rules on database objects.

● Developed and deployed SSIS packages to load data from OLTP systems into the Data Warehouse, streamlining data integration.

● Designed ETL packages to handle various data sources, including SQL Server, CSV, and Flat Files, transferring data from systems like Teradata Studio, MS Excel, MS Access, and SQL Server using SSIS versions 2019/2016.

● Configured and maintained Report Manager and Report Server, optimizing report generation and management.

● Tested and managed SSIS packages (2019/2017) to ensure smooth execution and functionality.

● Scheduled and monitored all SQL Server 2016 maintenance activities, including database consistency checks and index defragmentation.

● Designed and implemented stored procedures and triggers to automate tasks, improving system efficiency and reliability.

● Maintained project documentation and ensured all changes followed proper control procedures.

● Generated test data and conducted thorough database testing to meet project deliverables and specifications.

● Established and maintained database backup and recovery strategies to safeguard data integrity. Business Skills / Technical Skills:

MS SQL Server 2019/2016/2014, Visual Studio 2019/2017 (SSAS/SSIS/SSRS), Microsoft Access 2007/2003, Microsoft Excel (Pivot Table), OLAP and OLTP, Outlook, MS SQL Profiler, SQL Server Query Analyzer, Index Tuning Wizard, C#. Net, VB.Net. / Share point, Crystal Reports 8/ 9/10, ADO.NET, ASP.Net, FrameWork 2.0, C#, MDX, MDM, Oracle, DB2, DashBoard by Crystal report, Erwin8/7.3/3.5, Windows 2007/2005 Advanced Server/Professional, Window XP, MS Access, Java, My SQL Washington CareSource January 2017- May 2020 SQL/BI Developer Seattle,WA Responsibilities:

● SQL Development & Data Integration: Designed and developed SQL Server Integration Services (SSIS) packages using Business Intelligence Development Studio (BIDS) to extract, transform, and load (ETL) data from diverse sources, including Access databases, Excel spreadsheets, and flat files, into SQL Server for analysis and reporting. Utilized advanced SSIS transformations such as Data Conversion, Conditional Split, Bulk Insert, Merge, and Union All to execute complex data processing tasks.

● T-SQL Programming: Created robust T-SQL objects, including stored procedures, triggers, functions, indexes, tables, views, and joins, to implement business rules and logic effectively.

● Reporting Solutions: Developed and published SQL Server Reporting Services (SSRS) reports using SSRS 2019 to meet business needs. Customized report layouts to align with end-user requirements, ensuring accessibility and usability for managers and brokers.

● Data Cleansing & Transformation: Specialized in data cleansing techniques to maintain data consistency across single and multiple disparate systems. Expertise in using the Merge Join transformation to integrate data from various sources based on key columns.

● Database Administration & Maintenance: Managed critical database functions such as event logging, resource management, log files, file groups, security, and backup/recovery processes to ensure data integrity and availability.

● Scheduled ETL Workflows: Designed SSIS packages to facilitate data extraction from Access databases, Excel, and flat files into SQL Server 2019/2016. Scheduled and maintained nightly and weekly data loads through job tasks created in Visual Studio.

● Application Support: Collaborated with the application development team to resolve database-related issues, including deadlocks, query optimization, and debugging unexpected SQL results. Environment:

MS SQL Server 2019/2016, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, T-SQL, Oracle Enterprise Edition, Tableau Desktop, Power BI, Visual SourceSafe, Win 2003 Advanced Server, Power Builder 5, Erwin v7.2, C#.

Contact this candidate