Eden T Email & Phone Number

Hyattsville, Md, Us

Chicago, Illinois, United States

 Collaborated with Business Systems Analysts to fine-tune specifications and ensure database constraints were met.  Created Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by a front end application.  Optimized T-SQL queries for improved performance and executed impact analysis of changes ensuring minimal disruption to existing processes.  Defines Data Integration best practices for the data management environment.  Develops and maintains infrastructure systems (e.g., data warehouses, data lakes) including data access APIs.  Provides detailed guidance and performs work related to Modeling Data Warehouse solutions in the cloud or on-premise.  Understands Dimensional Modeling, Denormalized Data Structures, OLAP, and Data Warehousing concepts Designs, configures, implements, monitors, and manages all aspects of Data Integration.Framework.  Created packages with several Transformations in each Package making sure that the data is cleaned and confirmed before being sent to the Staging Area.  Developed and maintained Extract,Transform,Load(ETL) processes using SQL Server Integration Services (SSIS), ensuring the accuracy and integrity across multiple data sources.  Utilized Power BI components for data visualization, implemented row-level security, and managed the Power BI environment for seamless analytics.  Imported diverse data from various sources to Power BI, performed data cleaning, and applied DAX queries for effective data manipulation. 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.

Philadelphia, Pa

*Gathered requirements, performed data modeling, and developed logical and physical models to align with business needs.. * Created T-SQL stored procedures and triggers to enhance performance and functionality for database operations. * Utilized SSIS for data migration and transformation ensuring data integrity and efficiency in large scale projects. * Designed and implemented ad hoc reports using SSRS providing valuable insights to stakeholders and enhancing data driven decision making. * Managed alerts and monitored scheduled jobs guaranteeing the successful completion of essential tasks within the specified timeline. * Conducted index analysis and optimized SQL queries and stored procedures significantly improving database performance and responsiveness. * Participated in testing, bug fixing, and documentation efforts contributing to the overall stability and reliability of the developed solutions. * Developed incremental loading strategies using MERGE statements and improved performance through.

Addis Ababa, Ethiopia

* Designed and improved data models for Power BI dashboards resulting in improved data visualization and analysis. * Ensured data quality assurance through testing, auditing, and data ownership models ensuring accuracy and reliability in BI reporting. *Developed and optimized Extract,Transform,Load(ETL) jobs using SSIS for data extraction, transformation, and loading processes. * Connected applications to databases and wrote functions, stored procedures, and triggersto facilitate efficient data operations. * Imported and exported data from various sources using SSIS,contributing to the comprehensive and well integrated data ecosystem. * Demonstrated proficiency in data management by creating databases and schema objects ensuring a structured and organized data environment. *Developed visual reports, KPI scorecards, and dashboards using Power BI desktop delivering insightful data representations to support business decision-making.