نبذة عني
1.5+ years of work experience as a Data Analyst with knowledge of scripting languages (SQL, Python, and Unix shell commands) to extract, transform, and load ETL jobs efficiently. Experienced in database management, wareh…
1.5+ years of work experience as a Data Analyst with knowledge of scripting languages (SQL, Python, and Unix shell commands) to extract, transform, and load ETL jobs efficiently. Experienced in database management, warehousing, dimensional data modeling and data manipulation and visualizations using Power BI. Have experience working in both Software Development Life Cycles and Agile environment.
الخبرة
Data Analyst
Conducted extensive data analysis through writing, executing, and performance tuning SQL queries.
Managed data projects and addressed ad-hoc requests using data management tools such as Microsoft Excel and SQL/BigQuery.
Created and maintained data visualizations/reports in PowerBI and Tableau, utilizing DAX functions for creating measures and calculated fields, and Power Queries for data transformation.
Created both list and drill down reports identifying the data hierarchy.
Ensured data accuracy and reliability through daily data validation and quality checks at the database level.
Designed, developed, and maintained relational databases for effective data storage and retrieval.
Streamlined data processing by implementing business rules and logic for the extraction and loading of SQL servers and Big Query and experience of XML, JSON, CSV files ingestion.
Have worked on creating Staging, Dimension and Fact Table in accordance with business requirement.
Developed, tested, and automated data pipelines using Ascend.io.
Created complex ETL packages with SSIS for data extraction from staging to partitioned tables with incremental load, and automated index management before and after the ETL process using SQL scripts.
Utilized Python libraries like Pandas and NumPy for data manipulation and exploration.