Beshoy Sadek

Experience

• 

  HelloTech Inc.

  Apr 2018 - Oct 2021

  IT Technician

  -Set up and troubleshoot Network and Software issues for residential and commercial clients.-Helped clients explore new data analytics tools and provided demos.-Trained clients on newly acquired software and electronics.-Answered clients’ technical questions regarding services provided by HelloTech.-Deployed and configured desktops and laptops for Windows environments.-Prepared and submitted extensive reports to HelloTech after meeting with clients.

• 

  Conduent

  Oct 2021 - Mar 2023

  Platform Configuration Engineer

  -Designed /Developed/Applied/Debugged various multi-terabyte databases and T-SQL Scripts.-Tuned SQL queries to run efficiently.-Deployed database upgrades (DacPac) and patches.-Performed ETL tasks via SSIS packages and other data extraction tools.-Maintained MS SQL Server databases. Performed Restore/Backup of databases.Set up LogShipping.-Set up and maintained replication between Primary and Mirror servers.-Set up and maintained QueryStore on SQL Server.-Set up and maintained Change Data Capture (CDC)-Designed and maintained proper Indexes and Statistics.-Created SQL Agent Jobs and SQL Automation Scripts for routine server maintenance.-Developed Shell scripts within SQL using SQLCMD and Powershell to automate various server tasks.-Performed analysis on ETL and VM performance.**Personal Key Projects at Conduent:-Developed a series of stored procedures which fully automated parallel restore and backup processes of multiple databases with 1-click.-Performance tuned a long-running script to complete under 5 hours instead of 45 hours.-Designed a Database to distribute and execute Data, scripts, and commands across remote SQL Servers-Created scripts to monitor SQL Server various health metrics and send email alerts.-Designed logic to detect transactional replication issues and automatically apply the fixes. Show less

• 

  Rexford Industrial

  Mar 2023 - now

  - Build a complex AI-based document processing system utilizing SharePoint and AI Builder (OpenAI & OCR) to extract data from PDF and Images load it into a database table.- Build Azure Data Factory Pipelines to dynamically map JSON data to align with Data Warehouse schema.- Build workflows using Power Automate to enable real-time data replication from external sourcessuch as Salesforce and Google API’s into the data warehouse.- Write PowerShell scripts to scan and move files from the filesystem to their respective directories with logging to SQL. Show less - Design and build an Azure Data Warehouse to hold data from various sources such as ERP, CRM, Blob, Flat Files, and API.- Design proper Constraints, Triggers, and Indexes to ensure data integrity and reporting performance.- Build dynamic ETL pipelines to populate the Data Warehouse using Azure Data Factory (ADF).- Develop complex SQL Stored Procedures, Functions, and scripts to extract and transform data from various Yardi modules (Voyager, GL, MLA, Jobs, AB&F, Deal Manager, Comm/Vendor Cafe).- Create and tune various Views and Ad-hoc T-SQL scripts used to populate Power BI datasets.- Develop Full/Incremental Load strategies of Fact and Dim tables using CDC and Change Tracking for SCD.- Develop advanced forecast and budget analysis via SQL using accounting and financial GL data.- Utilize Power BI (DAX) and SSRS to perform advanced financial analytics and deliver reports to stakeholders. Show less

  • Senior Data Engineer

    Jan 2024 - now

  • Data Engineer

    Mar 2023 - Jan 2024