Summary
Overview
Work History
Education
Skills
Timeline
Generic

Abdul Sami Mohammed

Orange,CA

Summary

Accomplished SQL/Business Intelligence Developer with expertise in data warehousing and modeling techniques at County of Orange – OCIT. Excelled in optimizing database performance and automating ETL processes. Demonstrated strong collaboration skills, delivering impactful Power BI dashboards. Enhanced data accuracy and reliability, achieving a 30% increase in reporting efficiency through advanced SQL queries and SSIS package development.

Overview

10
10
years of professional experience

Work History

SQL /Business Intelligence Developer

County of Orange – OCIT
California, USA
09.2023 - Current
  • Designed, developed, and maintained SQL databases to ensure data accuracy and reliability.
  • Created SSIS packages for data extraction from various systems into staging areas.
  • Collaborated with stakeholders to gather business requirements and align project objectives.
  • Developed interactive Power BI dashboards integrating with SharePoint and SSRS.
  • Optimized database performance through indexing, query tuning, and custom SQL queries.
  • Automated report generation to enhance efficiency and minimize manual tasks.
  • Provided technical guidance on creating visualizations from datasets using Tableau and Power BI.
  • Managed numerous ETL processes, documenting database architectures extensively.

Business Intelligence Developer

County of Sacramento – DCFAS
California, USA
10.2021 - 08.2023
  • Delivered Power BI reports by gathering requirements to support organizational decisions.
  • Developed calculated measures and columns using DAX queries tailored to project needs.
  • Constructed insightful dashboards and visualizations linked with SharePoint and SSRS.
  • Set up Power BI environment, overseeing workspaces and gateway configurations for optimal access.
  • Published reports in required organizations, ensuring dashboard availability in web clients.
  • Engineered diverse visualizations such as Clustered Column Charts and Line Charts with Power BI.
  • Maintained up-to-date dashboards through integration with on-premise data sources via Power BI Gateway.
  • Automated ETL processes using SSIS packages for efficient data flow into the warehouse.

Power BI Developer /SQL, MSBI Developer

Brain Lab Software India Pvt. Ltd
Hyderabad, India
03.2019 - 06.2021
  • Created effective reports using visualizations in Power BI, including bar charts and pie charts.
  • Utilized Power BI gateway to ensure dashboards reflect real-time on-premise data sources.
  • Developed drill down and drill through reports based on data hierarchy in Power BI.
  • Implemented data cleansing by pivoting and un-pivoting data models with Power Query.
  • Secured Power BI reports using Row Level Security and DAX filters for sensitive data.
  • Designed calculations and KPIs in SSAS, analyzing average product life and profit margins.
  • Constructed SQL queries with inline views and dynamic SQL to optimize database operations.
  • Generated diverse reports using SSRS, including monthly summaries and ad-hoc analyses.

SQL Server Developer

Bharti Airtel Limited
Hyderabad, India
01.2016 - 02.2019
  • Executed data transformation and loading into SQL Server databases using ETL tools like DTS and SSIS.
  • Developed dynamic SSIS packages for daily ingestion of Flat and Excel files into the centralized data warehouse.
  • Migrated DTS packages to SSIS, enhancing performance and maintainability.
  • Collaborated with Reporting Analysts to analyze data and create management reports based on requirements.
  • Built dimensional cubes with SQL Server Analysis Services (SSAS) and queried data utilizing MDX scripts.
  • Designed stored procedures, queries, and views to support robust SSRS reporting.
  • Enhanced SSIS reliability by scaling functionalities to meet changing requirements.
  • Executed scheduled jobs to ensure seamless operation of DTS and SSIS packages.

Education

Bachelor of Engineering - Information Technology

Osmania University
Hyderabad, India

Master of Science - Computer Science

Governors State University
University Park, IL

Skills

  • SQL expertise in programming
  • Data warehousing and modeling techniques
  • SSIS package design and development
  • Power BI reporting and dashboarding skills
  • Business intelligence analysis methods
  • ETL processes for data integration
  • Advanced SQL queries for analytics
  • Microsoft Excel skills for data manipulation

Timeline

SQL /Business Intelligence Developer

County of Orange – OCIT
09.2023 - Current

Business Intelligence Developer

County of Sacramento – DCFAS
10.2021 - 08.2023

Power BI Developer /SQL, MSBI Developer

Brain Lab Software India Pvt. Ltd
03.2019 - 06.2021

SQL Server Developer

Bharti Airtel Limited
01.2016 - 02.2019

Bachelor of Engineering - Information Technology

Osmania University

Master of Science - Computer Science

Governors State University

Similar Profiles

  • SAKUNTALA VELCHURI

    SAKUNTALA VELCHURISAKUNTALA VELCHURI

    Application Developer II at OCIT orange countyApplication Developer II at OCIT orange county

  • Selena Masse, Ed.S., NBCT

    Selena Masse, Ed.S., NBCTSelena Masse, Ed.S., NBCT

    Middle Grades Social Studies Teacher at Orange County Schools (C.W. Stanford Middle/Orange Middle School) and Person County Schools (Southern Middle School)Middle Grades Social Studies Teacher at Orange County Schools (C.W. Stanford Middle/Orange Middle School) and Person County Schools (Southern Middle School)

  • Larry Carver

    Larry CarverLarry Carver

    IT Security Analyst at Orange County Board Of County CommissionersIT Security Analyst at Orange County Board Of County Commissioners

  • Regina Guzman

    Regina GuzmanRegina Guzman

    Clinician at Western Youth ServicesClinician at Western Youth Services

  • COLIN BRECHEEN

    COLIN BRECHEENCOLIN BRECHEEN

    General Manager – Western U.S. at Loveday LumberGeneral Manager – Western U.S. at Loveday Lumber

CREATE PROFILE