Solomon Berhane
Development
Maryland ,
Skills
Data Engineering
About
SOLOMON BERHANE's skills align with Programmers (Information and Communication Technology). SOLOMON also has skills associated with System Developers and Analysts (Information and Communication Technology). SOLOMON BERHANE has 8 years of work experience.
View more
Work Experience
INTEGRATION ENGINEER
July 2020 - Present
- and documented project requirements from stakeholders and translated them into functional and non-functional specifications for BI reports and applications and transformed them into deliverable solutions. * Participated in data mapping process, figuring out and documenting meanings of columns and tables as well as relationships among them. * Responsible for extracting data from internal and other external resources using T-SQL and PL/SQL based on business requirements such as Stored Procedures, User Defined Functions (UDFs) and Views * Tuned the performance of query statements by analyzing execution plans and logs/statistics in SQL Server Profiler/Database Engine Tuning Advisor * Designed and developed ETL packages to realize full loading and incremental loading to convert and migrate data, transform data using lookup, merge joins, derived columns, and built the target data warehouse and data marts based on Star Schema * Involved in designing ETL packages using breakpoints and analyzing progress to catch error information by SQL command in SSIS that sends an e-mail message when an error or a warning occurs or when a task fails. * Developed reporting solutions for different stakeholders from mock-up demos till deployment to analyse different dimensions as claims, transactions, appointments, supply, assets, and properties both in SSRS and Tableau * Developed reporting solutions including tabular reports, matrix reports, using cascading parameters to achieve Drill-down Reports, Drill-through Reports, as well as Linked Reports for security concerns in SSRS 2008/2012 for the front-end application usage. * Worked with QA team, clarified and solved the issues, delivered to the project manager for approval and feedback. * Optimized SSRS report performance by snapshots and indexes while writing query statements. * Optimized report performance by refining queries in T-SQL, removing redundancies, retrieving only essential data and using SQL methods efficiently. Environment: SQL Server 2008/2012/2016, SQL Server Management Studio (SSMS), Oracle, MS BI Suite (SSIS/SSRS), SQL Server Data Tools (SSDT), Visual Studio 2010, MS Office Suite 2010 (Excel, PowerPoint, Word), Tableau 8/10, Agile/Scrum, JIRA, Microsoft Visio
SQL BI Developer
American Family Insurance
August 2016 - June 2020
- Responsibilities: * Worked with business users and development staff to understand/determine requirements, collaborated with application developers for delivering the requirement on time and with scalability. * Worked closely with SME's end users/internal customers to understand project/requirement scope and involved in providing solution to implement or support production issues. * Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to validate the solution met requirements. And prepared documentation for same. * Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. (used CTE, temporary tables, user defined table types in codes developed) * Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008/2012. * Extensively used SQL server reporting services to generate reports on a weekly basis for a particular sales type in given period. * Wrote T-SQL queries, created dynamic Stored Procedures by using input values. * Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases. * Created Alerts for successful and unsuccessful completion of Scheduled Jobs. * Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager. * Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008R2. * Created reports using Global Variables, Expressions and Functions using SSRS 2008R2. * Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers. * Designed and implemented Stored Procedures and Triggers for automating tasks. * Maintained the table performance by following the tuning tips like Normalization, Creating Indexes * Design and create dash board reports which illustrate the data in tabular format and well formatted charts. * Automating the Dash Board process to retrieve information on failed jobs on all the servers. * Ensured best practices are applied and integrity of data is maintained through security and documentation. * Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, * data flow task, file system task, send mail task, active script task, xml task and various transformations * Generated Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers. * Using MDM method define and managed critical data to provide with data integration, a single point of reference. Tools & Technologies: Environment: SQL Server 2008/2012/2016, SQL Server Management Studio (SSMS), Oracle, MS BI Suite (SSIS/SSRS), SQL Server Data Tools (SSDT), Visual Studio 2010, MS Office Suite 2010 (Excel, PowerPoint, Word), Tableau 8/10, Agile/Scrum, JIRA, Microsoft Visio
Education
