Geb Berhea

Sr. SQL/BI Developer

ad3l4o@r.postjobfree.com

Mobile:240-***-****

PROFILE SUMMARY

6+ Years of Extensive Experience in SQL Developer /Power BI Developer /MSBI, and Tableau.

Skilled in Business Intelligence Applications Design, Development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Expertise in Extraction, Transformation, loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.

Published Power BI reports from Power BI desktop to Power BI service.

Created different visualization in Power BI according to the requirements.

Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.

Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and power

Strong ability to analyze user requirements, Business Requirement Specifications.

Expert in Data Discovery, Data Preparation and Data Modeling.

Extensive experience with SQL Server with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, and FILTER functions.

Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned sprints.

Expertise in Power BI Desktop, Power BI Service by designing and developing multiple advanced visualization report and dashboard.

Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL query.

Experience in creating advanced chart types, visualizations, and complex calculations to manipulate the data as per business need through Power BI

Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI.

Involved in creating Filters, quick filters, table calculations, calculated measures, and parameters in Power BI.

Hands on experience with SSIS and Azure Data Factory to extract, transform and load data into database.

Experienced working with Excel Pivot, VLOOKUP and other advance options.

Extensive experience on interaction with system users in gathering business requirements and involved in developing projects.

Designing and implementing scalable and secure cloud infrastructure solution on Microsoft Azur.

Integrate Azure Synapsis Analytics with other Azure services, such as Azure Data Factory and Azure data breaks, to create end- to- end data pipelines.

Proficient in SQL and T_SQL development with Azure Synapsis analysis, including store procedures, user – defined functions, and complex queries.

Good communication skills, interpersonal skills and proven ability to perform both as an individual and as a team player. TECHNICAL SKILLS

SQL Server and BI

Tools:

SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, BI Development Studio, SSIS, SSRS, Data Transformation Services, Scope, Tableau, Power BI.

RDBMS: SQL Server 2012/2008/2005/2000, 7.0, MS-Access, Redshift, Snowflake,azure database Languages: Java, T-SQL, PL/SQL, JavaScript, HTML, CSS Operating System: Linux, Mac OS X, Microsoft Windows/Advanced Server, MS-DOS, UNIX. Methodologies: Logical and Physical Database Design, Star Schema, Snow-Flake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE

Senion Professional Application Designer Jan 2021 -Current Gainwell Technologies, McLean, Virginia

Responsibilities

• Requirements gathering from the business analyst and preparing POC documents for the design & development of BI solutions (ETL/Reporting)

• Using SSIS, loaded XML data to the Database tables and Extracting Data using SSIS into Excel Files for Marketing purpose.

• Designing BI solutions with Microsoft SQL Server 2008 / 2008 R2 / 2012/2019

• Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base.

• Involved in SSIS ETL Transformation for de-normalization of data sources using UNPIVOT and UNION.

• I worked extensively in ETL and data integration in developing ETL mappings and scripts using SSIS.

• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.

• Created Crystal Reports with ole object extracting image file from the database and URL links.

• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults and complex SQL statements.

• Write high performing SQL (DML, DDL), triggers, stored procedures, and packages.

• Written complex SQL queries to retrieve data from Dynamic CRM and display in SSRS reports and Power BI . Created SSIS job to verify accounts and leads from excel file

• Developed the SQL programs and involved in optimizing stored procedures and queries for faster retrieval and server efficiency SSRS and SSIS.

• n-depth experience on MS SQL as part of a development role

• Used Quality center (Defect tracking tool) for Bug fixing and resolution details.

• Involved in mock testing and Unit Testing and Integration testing in SSIS, SSRS.

• Created automated stored procedures for day end operations using SQL server agent.

• Coordinated with front-end for implementing logic in stored procedures and functions.

• Performance tuning of SQL queries and stored procedures using server Profiler and Index Tuning Wizard in SSRS and SSIS.

• Working knowledge SQL Server security features such as ownership chaining

• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs

• Worked in importing and cleansing data from various sources like DB2, Oracle, flat files.

• Customized the formatting of the Crystal Report using formulas at the section level.

• Maintained the database schema in source code control (MS Team Suite Database Edition preferred).

• T-SQL programming, Complex Query writing, Query Optimization and Database Tuning.

• Worked with DTS packages and MS OLAP Services.

• Converse implementation limitations and data driven solutions with all levels of the project team and management.

• Maintained consistency of the client's Database using DBCC.

• Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.

• Created different views using SSRS and Power BI that were published by the business stake holders for analysis and customization using filters and actions.

• Implemented Azure Synapse Analytics to manage and analyze large volumes of data, optimizing data processing workflows.

• Designed and implemented data pipelines using Azure Synapse Studio, ensuring efficient extraction, transformation, and loading (ETL) processes.

• Utilized serverless SQL pools in Azure Synapse for on-demand querying of large datasets, improving data exploration capabilities.

• Collaborated with cross-functional teams to develop data models and schemas for effective data storage and retrieval.

• Utilized Azure DevOps for continuous integration and deployment (CI/CD) pipelines, automating software.

• Developed interactive Power BI dashboard to provide actionable insight for business stakeholders.

• Extract, transform, and load (ETL) data from various sources to create a unified dataset for analysis.

• Collaborated with cross-functional team to understand business requirement and translate them into effective BI solutions.

• Conducted data modeling and implemented data relationship to ensure accurate reporting.

• Extensive experience in developing complex DAX formulas to drive meaningful insight and key performance indicators

(KPIs) for business analysis.

Environment: SQLServer2012,2016,2019, 2008/2008 R2, Business Intelligence Studio (SSIS, SSRS), T SQL, Erwin, TFS, MDX, Oracle 10g, ProClarity, MS Excel, Power BI, Azure Synapsis SQL/Power BI Developer March 2018-Dec 2020

Capital One Bank

Responsibilities

• Worked with Business Systems Analysts to fine tune specifications by ensuring that all database constraints are satisfied and perform impact analysis of changes

• Collaborate with business teams to design, implement, and deliver reporting and advanced analytics to drive business performance

• Collaborated with application developers in creating databases and tables to support development activities and drive optimal efficiency.

• Instituted complex stored procedures, triggers, functions, indexes, tables, views, SQL joins, and other T-SQL code for business rules implementation.

• Development and maintenance of configuration control policies to identify Hygiene breaks, using SQL Stored Procedures

• Executed performance tuning, queries optimization, and redundant and inconsistent data removal.

• Work as Cloud Administrator on Microsoft Azure, involved in configuring virtual machines, storage accounts, resource groups.

• Executed performance tuning, queries optimization, and redundant and inconsistent data removal.

• Experience in SQL modules such as packages, procedures, functions, and other database objects

• Conducted tuning of queries and database performance using Database Tuning Advisor and SQL Server Profiler

• Completed incremental load with several Data Flow Task and Control Flow Tasks using SSIS and created and implemented master child package using variables in SSIS.

• Experience creating Filters, quick filters, table calculations, calculated measures, and parameters in Power BI.

• Have good experience in creating advanced chart types, visualizations, and complex calculations to prepare the data as per business needs through Power BI.

• Experience utilizing DAX functions like Aggregation, Counting, Logical, Information, Text, and date functions.

• Good understanding of the Data modeling (Dimensional & Relational) concepts like Star Schema Modeling

• Well versed in query optimization for performance tuning.

• Experience Working on complex KPI scorecards, heat maps, tree views, circle views, bar charts. Data visualizations and an interactive dashboard helped the business get a good handle on the team's productivity.

• Developed visual reports, dashboards, and KPI scorecards using Power BI desktop

• Connected to data sources, importing data, and transforming data for Business Intelligence

• Excellent in analytical thinking for translating data into informative visuals and reports

• Able to implement row-level security on data and understand application security layer models in Power BI

• Proficient in making DAX queries in Power BI desktop

• Expertise in using advanced level calculations on the data set

• Able to develop tabular and multidimensional models that are compatible with warehouse standards

• Adopted, developed, publishing, and scheduling Power BI reports as per the business requirements

• Able to properly understand the business requirements and develop data models accordingly by taking care of the resources

• Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS) or API automation. I and Also, experienced in developing custom visuals for Power BI.

• Create SSIS packages to extract data from different sources.

• Proficient in data blending and increased the dashboard performance by extracting data.

• Strong commitment to organizational work ethics, decision-making, and managerial skills.

• Improved queries and database performance using Execution Plan and Database Engine Tuning Advisor. Environment: SQL Server 2005/2008 /2008 R2, SSIS, SSRS, OLAP, OLTP, Erwin, Performance Point Server, SQL Server Business intelligence Development Studio (BIDS), T-SQL, VB.NET, ASP, ASP.NET, C#, MS Excel, Windows 2000 Server, T-SQL, MS Visual Studio.NET, Unix

MSBI/Power BI Apr 2016 – Jan 2018

Cotiviti Healthcare, Blue Bell,PA

Responsibilities

• Interacted with the business users for understanding the business requirements and the existing system.

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.

• Created the views in the intake-database for the MS Sales hierarchies to be use in the store procedures in Staging database.

• Created many complex Query's and used them in Power BI Reports directly to generate reports on the fly.

• Using SSIS Package identified the Up-streams and imported the required tables into intake-database, Store Procedures are created in staging database using the intake-database tables & views.

• Checking the code into TFS (Store Procedures, Views, Tables, Schema) for the deployment process for the production environment.

• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2016 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, and union all.

• Using SSIS Package identified the Up-streams and imported the required tables into intake-database, Store Procedures are created in staging database using the intake-database tables & views.

• Checking the code into TFS (Store Procedures, Views, Tables, Schema) for the deployment process for the production environment.

• Programming experience in Database Oracle & SQL Server and ETL tools.

• Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.

• Create reports in Power BI preview portal utilizing the Tabular Model via Analysis connector.

• Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.

• Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.

• Used One Drive for storing different versions of Power BI report.

• Published Power BI Reports in the required origination's and Made Power BI Dashboards available in Web clients and mobile apps.

• Created Dashboard and the Content Pack for the originations to get the updated Power BI Reports. And added the refresh time for each tile in the dashboard.

• Responsible for complete maintenance and delivery of scheduled releases.

• Requirements gathering from the business analyst and preparing POC documents for the design & development of BI solutions (ETL/Reporting)

• Using SSIS, loaded XML data to the Database tables and Extracting Data using SSIS into Excel Files for Marketing purpose.

• Designing BI solutions with Microsoft SQL Server 2008 / 2008 R2 / 2012

• Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base.

• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS.

• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.

• Created Crystal Reports with ole object extracting image file from the database and URL links.

• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults, and complex SQL statements.

• Created automated stored procedures for day end operations using SQL server agent.

• Performance tuning of SQL queries and stored procedures using server Profiler and Index Tuning Wizard in SSRS and SSIS.

• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files.

• Customized the formatting of the Crystal Report using formulas at the section level.

• Maintained the database schema in source code control (MS Team Suite Database Edition preferred).

• Worked with DTS packages and MS OLAP Services.

• Maintained consistency of the client's Database using DBCC. Environment: MS SQL Server 2008/2008R2, MS SQL Server Reporting Services, MS SQL Server Integration Services, ProClarity, C#, ASP.NET, VB.NET, OLAP, UML, Erwin, DTS/SSIS, BIDS EDUCATION BACKGROUND

Saint Mary University -Computer Science

University of Maryland– Bachler of Cyber Security and Data Science John’s Hopkins University Bootcamp -Coding in Full Stack/ JavaScript/HTML-CSS/React/SQL/MYSQL/PL-SQL/API/NODE JS/NOSQL/Angular

Contact this candidate