A

Amir Fereja

About

Detail

Maryland, United States

Timeline

work
Job

Résumé

Jobs verified_user 0% verified
  • Anteriad
    Data Engineer
    Anteriad
    Jun 2023 - Current (3 years 5 months)
    • Designed and implemented scalable, high-performance data pipelines and ETL processes to support enterprise analytics. • Architected and maintained cloud-based data warehouses using AWS Redshift, Snowflake, and Azure Synapse, enabling efficient data storage and retrieval. • Developed and optimized SQL queries and Python scripts to improve data integration and transformation. • Integrated distributed systems such as Hadoop and Spark to streamline big data workflows and ensure scalability. • Built and orchestrated ETL pipelines with Azure Data Factory (ADF), Microsoft Fabric, and Matillion to handle diverse data sources. • Collaborated with data scientists, analysts, and business stakeholders to gather requirements and design custom da
  • S
    Data Engineer
    Safe Rent Solutions
    Jul 2022 - Jun 2023 (1 year)
    • Designed and maintained automated ETL pipelines to support enterprise reporting and analytics. • Optimized database performance using partitioning, indexing, and query tuning for large-scale datasets. • Built and maintained data warehouses and data lakes using AWS S3, Redshift, and Azure Synapse. • Developed scalable data platforms and pipelines with Azure Data Factory (ADF), Microsoft Fabric, Matillion, SSIS, and Snowflake. • Implemented data transformation and enrichment processes to prepare data for reporting and advanced analytics. • Developed and managed database objects including stored procedures, triggers, functions, indexes, and tables. • Designed and developed Power BI dashboards with DAX and Power Query, integrating data
  • Molina Healthcare
    MS SQL/ETL Developer
    Molina Healthcare
    Apr 2018 - Feb 2020 (1 year 11 months)
    • Collaborated with SMEs and end users to define requirements and provide production support for healthcare reporting systems. • Designed and maintained logical and physical data models, creating test cases and documentation to validate business requirements. • Developed and optimized T-SQL queries, stored procedures, and database objects to implement healthcare business rules. • Built SSIS packages to extract, transform, and load data from heterogeneous sources into the data warehouse, automated workflows for daily, weekly, and monthly feeds. • Implemented SSIS transformations including slowly changing dimensions, fuzzy lookups, and conditional splits to support healthcare reporting needs. • Created and enhanced reports in SSRS to an
  • E
    MS SQL Server SSIS / SSRS Developer
    Ethio Telecom,
    Jan 2014 - Mar 2018 (4 years 3 months)
    • Gathered requirements and designed database solutions to support telecom billing and customer management systems. • Built and maintained data models in Erwin, integrating them into SQL Server for enterprise reporting. • Developed SSIS packages with advanced transformations (fuzzy lookup, derived column, incremental loads) to migrate legacy billing, customer, and contract data into modern systems. • Designed ad-hoc and parameterized reports in SSRS and Crystal Reports, tracking usage metrics such as logins, click-throughs, and customer demographics. • Automated processing of amortization schedules from CSV files, staging data, and moving it into core systems for billing calculations. • Implemented drill-down, drill-through, and matri
  • S
    SQL/BI Developer
    • Collaborated with SMEs and Business Analysts to define requirements, validate constraints, and perform impact analysis for database changes. • Designed and implemented logical/physical data models, prepared test cases, and documented solutions. • Developed complex T-SQL objects (stored procedures, views, functions, triggers, indexes) with optimization for performance and scalability. • Tuned SQL queries and reports using Profiler, Execution Plans, and Index Tuning tools. • Designed and deployed SSIS packages for ETL, including data cleansing, validation, and integration from heterogeneous sources. • Automated data imports/exports between SQL Server, CSV, Excel, and flat files. • Created and enhanced reports in SSRS (sub-reports, ma
Education verified_user 0% verified
  • B
    B.Sc.