Enterprise Data Architect & DevOps Specialist

OSMAN M. ARBAB

+1-561-***-**** *********@*****.*** LINKEDIN-PROFILE

SUMMARY

Accomplished Enterprise Data Architect and DevOps specialist with 15+ years of experience spearheading complex, full-life-cycle data solutions within highly regulated environments, particularly healthcare. Expert in data warehousing, Big Data, and cloud computing solutions using Oracle, SQL Server, Azure, and AWS. Proven leader in managing large-scale data integration projects, optimizing database performance, and mentoring BI teams on advanced analytics tools including Epic Cogito, Tableau, and Power BI. Certified in multiple data analytic tools and fluent in medical coding systems (ICD-10, HL7 FHIR).

PROFESSIONAL EXPERIENCE

SENIOR DATA WAREHOUSE SPECIALIST JOHN HOPKINS HEALTH SYSTEM (01/2025 – Present)

Provided guidance in the design of technical and functional requirements for data integration projects.

Achieved multiple company-issued recognitions for design enhancements and leading error resolution.

Developed Epic Cogito reports and analytics solutions for Health Risk Assessments and Health Social Determinants.

Lead the development of ETL extracts based on HL7 FHIR guides for regulatory Centers for Medicare & Medicaid Services (CMS) compliance, delivering 24 daily files to third parties.

Architected SQL and SSIS extracts from Clarity, Caboodle, and the EDW.

Reengineered an ETL to prevent manual intervention by automatically sorting and ingesting multiple files at once.

Optimized a complex SQL query from 1 hour 43 minutes down to under 5 minutes.

Coordinated and conducted mass data cleansing initiatives including archival, tracing, metadata updates, etc.

Streamlined solutions for member enrollments, demographics, surveys, aggregate claims, and payer data.

Resolved production errors by collaborating with vendors, business teams, and other IT departments.

LEAD DATAWAREHOUSE DEVELOPER (CONSULTANT) TECHGEEKS, INC. (11/2012 – 10/2024)

Responsible for the tactical execution of data warehouses for high-growth healthcare organizations.

Managed oversight of a 6-member team of SQL/ETL/BI developers, external partners, and offshore resources.

Lead the design, development, operation of databases and ETL that integrate numerous software applications.

Identified and managed potential issues/risks impacting data warehouse stability and performance.

Designed, developed, tested, tuned, optimized, and implemented SQL procedural database code.

Consulting Assignments via Techgeeks:

BI Team Lead Health-First Health Plans, Inc. (11/2022 – 10/2024)

oLead a team of 6 remote developers to build/validate EDW (Snowflake schema) and Power BI solutions.

oMigrated SSRS reports to Power BI while enforcing regulatory and industry standards.

oLead UAT efforts across functional departments during the operation of new EDW and BI solutions.

oIntegrated data from multiple sources into DW; migrated SSIS/Informatica PowerCenter to ADF.

Senior Data-warehouse Engineer AAA National Office (11/2019 – 08/2021)

oArchitected, designed, and developed solutions for databases (Oracle-SQL Ser.), ETL (RedPoint), and Tableau.

oProvided production support for BI suites (Tableau) and marketing platforms (Salesforce, Engage).

oCore developer of stored procedures, views, and functions for hosted web applications, cubes, and BI.

Lead BI/ETL Engineer Kroger Specialty Pharmacy (02/2019 – 11/2019)

oResponsible for end-to-end solutions: building and testing Database, ETL, BI solutions (SQL/SSIS/Power BI).

oTranslated business requirements into specifications to implement dashboards and convert legacy reports.

oTransitioned project artifacts to Business Analysts and developers.

oLead cross-functional teams through BI implementation and company/vendor data extraction efforts.

Senior SQL/ETL Engineer Ingram Micro, Inc. (11/2018 – 02/2019)

oArchitected, designed, and developed database solutions (Oracle & MSSQL), ETL, C# scripts, and reports.

oPlanned and coordinated data migrations between systems.

oIdentified inefficiencies in current DB/SQL/ETL and implemented robust, optimized solutions.

oPerformed data modeling, cleansing, and normalization for Fact and Dimension tables.

Senior Data Management Engineer Health-First Health Plans, Inc. (06/2016 – 09/2018)

oDeveloped SQL/ETL Agent Jobs. Assisted DBA and DBD in Capacity Planning and Data Architecture.

oIntegrated data from multiple ODS sources (AMISYS) into DW; migrated SSIS to Informatica PowerCenter.

oConverted legacy Crystal reports to SSRS. Performed SQL optimization and performance tuning.

oBuilt system integration solutions with report subscriptions to comply with Government regulations and HL7.

SENIOR BUSINESS INTELLIGENCE ENGINEER TRACFONE, INC (11/2012 – 06/2016)

Spearheaded a team to improve data quality and perform remediation between internal and vendor records.

Managed software development projects and QA efforts; created Technical Design Documents.

Identified anomalies in redemption and revenue reporting using BI for different brands.

Coordinated data integrity and synchronization between inventory and transactional databases (PL/SQL).

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, C#, Python, C, C++ Platforms: Windows, Linux, UNIX (SUN Solaris)

Databases & Cloud: Azure, AWS, Oracle, SQL Server Tools & Packages: ADF/DataBricks/DevOps/TOAD /SSIS/SSRS/Power BI/VisualStudio/Informatica PowerCenter /Tableau Server/AutoSys/JIRA/GitHub/ServiceNow/Epic: Chronicles, Clarity, Caboodle Cogito

CERTIFICATIONS

Epic-Caboodle Development for Clarity

Epic-Clinical Data Model

Datawarehouse

Power BI Administration

Epic-Caboodle Development for Non-EPIC Data

Epic-Cogito (certificate No.126*******)

Linux Administration

Tableau Server Administration

Epic-Clarity Data Model

Data Engineering using ADF

Microsoft-PowerBI

EDUCATION

BS Computer Science Florida Atlantic University, USA (5/2016)

Honors: National Dean’s List, Phi Theta Kappa, Upsilon Pi Epsilon Honor Society

Contact this candidate