Bemnet Bemnet
SQL Developer
Emeryville
0
Followers0
FollowingI use my skills in crafting complex T-SQL codes, designing ETL processes using Azure Data Factory, and creating compelling Power BI visualizations. I have a proven track record in managing MS-SQL Server systems from 2008R2 to 2019, ensuring their smooth operation and optimal performance. My expertise extends to the entire database development lifecycle, including data modeling with SSMS, creating BI solutions with SSRS, SSAS, and Power BI. I am adept at working in Agile environments and possess strong analytical, problem-solving, and communication skills. What sets me apart is not just my technical proficiency but also my commitment to delivering efficient and tailored database solutions that align with business objectives.
Careers
SQL DEVELOPER
EAST WEST BANK
Full time contract12/2020 -
- Developed complex T-SQL codes to create/update database objects such as Tables, Views, Stored Procedures, User Defined Functions, Triggers, Indexes, and Cursors.
- Used Joins, Correlated and Non-Correlated Sub-Queries for complex business queries involving multiple tables & calculations from different databases.
- Used Azure Data Factory to copy data from On-Premise Server to Azure Synapse , created Copy Activity.
- Experienced with Dynamic SQL and developed procedures utilizing the functionality.
- Used SSIS to create ETL packages to Extract, Transform, and Load data to Data Warehouse and Data Mart Databases.
- Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging Database.
- Extracted data from different sources (CSV, Excel, MSSQL, and Oracle database sources) and loaded to Data Warehouse using SSIS complex data transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split, Lookup, Fuzzy Lookup, Slowly Changing Dimension, Derived Column, Row Count, and more) for existing/new packages.
- Provided Data Lake Access to various groups and users using the ACLs in Azure Storage Explorer.
- Developed SSIS packages using the For Each Loop Container in the Control Flow elements to process all Excel files within the folder, a File System Task to move files into the Archive after processing, and an Execute SQL task to insert transaction log data into the SQL Table.
- Well experienced in using Table Variables and Common Table Expressions (CTEs).
- Scheduled Jobs for executing the stored SSIS packages which were developed to update the database using SQL Server Agent. Also, involved in the deployment of SSIS Packages.
- Used advanced features of T-SQL to Design and Tune T-SQL to interface the database and other applications most efficiently.
- Generated Sub-Reports, Crosstab, Conditional, Drill-Down reports, Drill-Through reports, and Parameterized reports using SSRS.
- Created customer trend visualization in Power BI from a dedicated Synapse server source.
- Created reports to retrieve data using Stored Procedures that accept parameters.
- Experience working in Agile/Scrum environments.
Education
ERITREA INSTITUTE OF TECHNOLOGY
INFORMATION TECHNOLOGY
09/2012 - 05/2016Bachelor's DegreeClass of 2016
Skills
SQL Server, cloud computing designETLData VisualizationSSISSSRSData EngineeringData analyticalAgile methodologiesPower BI
Experience8+ years
Hourly rate$60/hr
Open to
remote
Welcome to Outdefine
A free tokenized community dedicated to connecting global tech talent with remote job opportunities. Our platform is designed to help you connect, learn, and earn in the tech industry while providing the chance to collect DEF tokens. Join our vibrant community today and explore a world of possibilities for your tech career!
Join for free