SAUD ALSHAMMARI
Phone – 202-***-****) • Email – ********@*******.***
Education
• M.S Management Information Systems -Bowie State University
• B.S Computer Engineering in Management Information Systems -University of Ha’il
• A.D in Business Administration -University of Ha’il Skills
• Informatica10.1/9.x
PowerCenter
• WEKA Tools
• Data visualization
• Dashboard
• Workflow Monitor
• OLAP
• Repository Manager
• Project Management
• Tableau
• Data Integration
• Data Warehousing
• Data Design
• Data Analysis
• R programming
• ETL
• SQL
• Python
• Fluent Arabic and English
Work History
RTG LLC MD/USA October 2018 to DEC 2021
ETL/Informatica Developer
• Developed SQL procedures, functions, stored procedures and packages within the mappings retrieving data, inserting new data, and updating database tables without errors.
• Successfully created and imported different types of sources in Informatica using Source Analyzer.
• Tuned Informatica mappings and sessions for optimum performance.
• Solved complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.
• Created mappings and procedures at the database level in order to optimize performance.
• Created and reviewed documents that mapped data thereby successfully moving them from source table to target table.
• Worked with various transformations including router transformation, update strategy, expression transformation, lookup transformation, sequence generator, aggregator transformation and sorter transformation.
• Debugged the Informatica mappings and validated the data in the target tables once it was loaded with mappings.
• Created Workflows, created Worklets and scheduled them using Workflow Manager.
• Worked extensively on different types of transformations such as Update Strategy, Look Up, Filter and Router Transformations.
• Use existing tools and methods to solve problems with existing types of data.
• Analyaze collected data to help stakeholders make better decisions.
• Developed Informatica Mappings to capture data changes from the operational source systems into data warehouse and data marts (SCD mappings).
Tools Used: Source Analyzer, Informatica10.1/9.x PowerCenter, Oracle DB, ETL, SQL, Tableau, spreadsheet Certifications and Awards
• Google Data Analytics Professional Certificate – 2023
• Information Systems Analysis Certificate – 2018
• Academic Scholarship for an Acadmic English School/ Georgetown University – 2015