SUMMARY

• Over 6+ years of experience as SQL/BI Developer in Database Design, Development, ETL Implementations, Designing, Developing and Support of OLAP/OLTP/ Data Warehousing system and visualizing reports using MS SQL, Microsoft Visual Studio (SSIS, SSAS, SSRS) and Power BI.
• Strong knowledge and experience in various sectors such as healthcare, HR, Social Services, and finance and banking
• Advanced experience with end - to-end business intelligence solutions from requirements and specification writing; ETL design, testing and deployment of packages; data visualization and development of dashboard platforms; scheduled delivery and automated data refresh; and system testing, optimization and performance analysis
• Hands on experience in using SQL Server and T-SQL for developing Stored Procedure, Tables, Triggers, User Defined Functions, Indexes and SQL Join.
• Experienced with Full life cycle of ETL development to address business needs including design, mappings, data transformations, scheduling and testing
• Advanced knowledge of Power BI Desktop, Power BI Services, Power Query, Power View, Data Management Gateway, Design and Management of dashboards
• Advanced knowledge of SSRS reporting platforms such as sub-reports, matrix, drill-down and drill through reports
• Experienced with SSAS, building, deploying and processing Cubes, data sources, data source views
• Demonstrated knowledge of Data Warehouse architecture and concepts, star schema, snowflake schema, data normalization and Denormalization, Data Mart, staging table
• Extensively uses SQL native tools like Index tuning wizard, Database tuning advisor (DTA), SQL profiler, Performance monitor, Activity monitor, Event viewer, Dynamic management views and Dynamic management functions for monitoring and performance tuning/troubleshooting
• Demonstrated knowledge and experience with SQL Server Installation, Configuration, Migration and administration
• Significant experience in Conceptual, Logical and Physical Modeling
• Extensive experience in Normalization and Denormalization modelling techniques
• Experience in publishing reports to Power BI Services, embedded Power BI reports into SharePoint Sites and configured Power BI Workspaces
• Experience in managing Power BI Subscription and managing users to access Power BI Reports
• Experience in writing T-SQL query in populating Dimension and Fact tables in Data Warehouse from staging tables using Incremental approach
• Experience in designing & implementing Database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
• Experience working with business owners to gather and define requirements for report generation
• Proficient in the use of Data Analytics Expressions (DAX) and Power Query
• Experience in Developing high performing, reliable, and scalable Self Service (SS) BI solutions
• Aptitude to learn new subjects and emerging technologies and articulate their business implication
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Databases: MS SQL Server 2008/2008R 2/2012/2014/2016/2017/2019

ETL Tools: DTS (Data transformation services), (SSIS) SQL Server Integration Services

Reporting Tools: Power BI, SQL Server Reporting Services (SSRS), Tableau 10.5/10.0/9.0 , Report Builder 2.0/3.0

Data Mining Tools: SQL Server Analysis Services (SSAS)

Database Tools: SQL Profiler, Database Engine Tuning Advisor, SSMS, Activity monitor, Performance monitor, SQL Agents

Language: Transact SQL (T-SQL), C#, C++, Visual Basic, Power Shell, Python

Operating Systems: Windows 7/8/10, Windows 98/2000/XP, Linux, MS DOS

Statistical Tools & Models: SPSS, R, Linear Regression, Binary Logistic Regression, Chi-Square test, T-test and Independent T-test analysis

MS-Office: MS-Word, MS-Excel, MS-Access, Outlook, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

BI Developer

Responsibilities:

• Implement the full cycle of power BI visualizations such as extracting and transforming data in Power Query, designing various visualizations in Power BI desktop, publishing reports into Power BI Services, and developing and managing dashboards
• Design and develop various BI reporting and visualization solutions including drill through and drill down reports, Matrix, Sub-report, Key Performance Indicator (KPI), Key Influence, Combo Chart, Ribbon chart
• Automate integration and reporting processes
• Created dashboards for tracking live data
• Generated pre-designed, dynamic and ad-hoc reports for end users
• Interact with end users, research and identify business requirements and translate business needs to technical specifications
• Create, maintain and improve databases, schema objects, SQL queries, stored procedures, indexes, functions and views for data migration and ad-hoc reporting
• Use Informatica PowerCenter Designer analyzed the source data to extract and transform from various source systems (Oracle, SQL Server and Flat Files)
• Clean and transform data in Power BI Query editor
• Migrated old data source platforms, built data mapping and integrated the ETL platforms with the target database
• Build calculated fields in DAX (Data Analysis Expression) for basic reports and analysis
• Develop ETL work flows and mappings to extract, transform, and load data into target environments, in line with current data loading architecture or on an ad-hoc basis
• Design, code, test, monitor, troubleshoot and improve ETL processes and reporting platforms
• Implemented Slowly Changing Dimensions to incrementally load dimension tables to the target Data Warehouse
• Presents project progress and reports to internal staffs and stakeholders
• Built and reorganize indexes for performance enhancements
• Collaborate with IT professionals to audit user access to SQL Server databases based on security standard methodologies

Environment: MS SQL Server 2016/2012, Power BI Desktop, Power BI Services, SQL Profiler, SSIS, SSRS, SSAS, SQL Server Management Studio, Visual Studio, Database Engine Tuning Advisor, SharePoint

Confidential, CO

BI Developer

Responsibilities:

• Design and develop commercial data warehouse that supports analysis and reporting of banking services, sales and marketing activities
• Build, troubleshoot, modify complex and efficient queries, views and stored procedures
• Pulling and aggregating data from multiple disparate sources
• Provide solutions for data cleaning and transformation
• Develop and support the ETL process to extract, transform and load data from and to various heterogeneous sources and destinations
• Employed incremental and full loading to populate dimension and fact tables in to the Data Warehouse
• Review ETL processes for accuracy, maintainability and performance prior to implementation
• Create supporting documentation for new ETL processes
• Get data from multiple sources, and review and built data model and relationships among multiple tables
• Design and develop user friendly dynamic reports and dashboard using parameter, expression, conditional formatting, and grouping to reduce ongoing ad hoc requests
• Design appropriate BI solutions to measure trends and performances
• Built documentation package for human resources and managers to track and update project progress and other changing attributes
• Gather and translate requirements from end-users to develop and maintain BI reporting platforms
• Create written communication materials summarizing findings and support recommendations

Environment: MS SQL Server 2014/2012, SSIS, SSRS, Visual Studio, SSAS, Business object, T-SQL, ER-Studio, TFS, INOTAS, JIRA, Office365, Tableau 10.5/10.2, Database Engine Tuning Advisor, SharePoint

Confidential, Philadelphia, PA

BI Developer

Responsibilities:

• Assess and document data requirements and client specific requirements to develop user friendly BI solutions - reports, dashboards, and decision aids
• Design, develop, and maintain T-SQL - stored procedures, joins, complex sub queries for ad-hoc data retrieval and management
• Develops logical and physical data flow models for ETL applications
• Build, test and maintain automated ETL processes to ensure data accuracy and integrity
• Adapt and optimize ETL processes to accommodate changes in source systems and new business user requirements
• Build, test, and manage BI standard reporting templates and dashboards for internal and external use
• Build packages recording and updating historical attributes of employees using slowly changing dimension
• Configure percentage sampling transformation to identify sample respondents for survey research
• Employs merge join transformation to produce ad-hoc reporting of client demography, procedures, treatment history and cost of treatment
• Applied lookup and cache transformation and use reference table to populate missing columns in to Data Warehouse
• Transfer big data to and from the remote computer through File Transfer Protocol
• Troubleshoot data integration issues and debug reasons for ETL failure
• Build SSISDB Catalog and create parameters and environments for flexible project deployment
• Undertakes regular data mapping, parsing and ETL scanning
• Create custom reports for requested projects, and modify existing queries and reports in Power BI desktop and SSRS
• Managing snapshot and caching for SSRS performance
• Implemented security policies for SSRS reports
• Documentation of data environment and solutions to support end users and analysts
• Communicate internal business and technical users to capture business and technical requirements and specifications used to construct and deliver reports, dashboards, and analytics
• Create, update and test current OLAP data cubes

Environment: MS SQL Server 2012/2008/2008R2, MSSQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), T-SQL, Erwin Data Designer, Informatica PowerCenter, Windows XP.

Confidential, Addis Ababa, Ethiopia

SQL Developer/SQL Database Administrator

Responsibilities:

• Creating and modifying database objects -databases, tables, indexes, views, stored procedures, triggers, functions
• Participated in logical and physical data design and development of data warehouse
• Compile complex data sets from a variety of sources
• Developing and optimizing SQL queries, DDL /DML scripts, stored procedures, views, and functions
• Create and execute ad-hoc database queries and produce reports upon request from business stakeholders
• Design, build, test, and execute ETL packages to transfer transactional data into a data mart for reporting and analysis consumptions
• Troubleshoot and resolve ETL failures and performance issues
• Reviewing ETL workflows for performance, data consistency and integrity
• Manage reporting server and maintain end user access to reports and dashboards
• Deploy SSIS packages; and performing code review and defect analysis
• Built for each loop container together with file system task to copy, move, create, delete folder or file; and rename file and set attributes
• Build project and package parameters for flexible and easy deployment and runtime operations
• Work with stakeholders to understand the business and functional requirements to develop and architect Data Warehouse platforms
• Translate business needs to technical specifications
• Installing, configuring, managing, monitoring SQL Servers
• Import/Export files of different sources
• Manage and enforce database security by creating and managing logins, user privileges and roles and efficient resource management
• Automate and monitor maintenance plan jobs in SQL Server agent and task scheduler: such as shrinking database, backup database, index rebuilding, creating filtered indexes, index reorganizing, cleaning up, and updating statistics
• Reorganizing and/or rebuilding indexes to reduce disk space and enhance server performance
• Enhance SQL Server Databases performance by creating alias, indexes, views, triggers and Stored Procedures
• Analyzing query plans, troubleshoot Locks, Dead Locks using both SQL Profiler, Spotlight and DMVs and DMFs, and handling the isolation level and concurrency effects
• Performed data partitioning for efficient management of database tables and indexes

Environment: MS SQL Server 2012/2008R2/2008, SSIS, SSRS, SSAS, SQL Profiler, Database Engine Tuning Advisor