Ramzi Harb Email & Phone Number

Morristown, NJ, US

Morristown, New Jersey, US

Morristown, New Jersey, US

• Led the design and development of a cloud-based data lakehouse leveraging Azure Synapse Workspace, Service Bus Messaging, Azure functions, Pipelines, Spark Pools, Python and Power BI, enabling scalable and agile data.
• Migrated an internal SQL Server data warehouse to an Azure Synapse dedicated SQL pool, successfully loading transactional data and establishing a foundation for future cloud-based data warehousing.
• Successfully migrated the first in-house.NET web application with a SQL Server backend to Azure, enabling DevOps integration and paving the way for future cloud deployments.
• Initiated Power BI adoption within the company by establishing a new Power BI service for the company, including data gateway configuration for on-premises application access.
• Developed a suite of Power BI reports leveraging Cloud, SQL, Excel, and Azure DevOps providing financial and IT operational insights.
• Championed IFRS 17 readiness for our Canadian branch by optimizing data loads for IFRS 17 reporting, enabling granular financial analysis, and implemented STAT and GAAP expense loading, significantly contributing to.

New York, NY, US

New York, NY, US

• Managing all requirements gathering, designing and development of 2 accounting applications with the goal of integrating required data for GAAP, Federal and STAT regulatory reporting through the MetLife balance sheet.
• Collaborating regularly with Business and IT partners at various levels of the organization to gather business requirements, transform them into SSIS packages to load data into SQL Server databases, assemble the data.
• Redesigned an entire application from scratch to replace an obsolete database design causing a complex reporting structure and slow processing time. Created a brand new star schema data mart with over 50 new tables.
• Created a brand new MVC.Net website to enable the business to maintain 30 reference data tables and allow for uploading and downloading of several data files through adjustment facilities.
• Automated all code deployments to every environment including SSIS, SSAS, Database and Webservers saving hours of work every month. Supporting the Architecture team to roll out the automation to the broader team.
• Partook in a Big Data POC where I was an integral part of the analysis of Hadoop and Polybase. Was able to quickly learn the technologies and guide several colleagues on the full potential of the tools.

New York, NY, US

• Managing all planning, designing and development of 2 accounting reporting applications with the goal of integrating all required data into datamarts and making it available for 10Q, 10K and Federal external reporting.
• Collaborating regularly with Business and IT partners at various levels of the organization to gather business requirements and transform them into automated SSIS packages to load data into SQL Server 2012, assemble.
• Maintaining complex business rules and processes within the datamarts in support of multifaceted reporting.
• Developed.Net applications for the business to interact with the datamarts and apply required adjustments.
• Built new SSAS multidimensional Cubes to drastically improve ad-hoc and pre-canned reporting.
• Suggested and re-developed an existing reporting solution for a reconciliation process by leveraging SQL Server and Excel that has saved the business hours weekly by simplifying and replacing different layers of BI.

New York, NY, US

• Led a team of onshore and offshore consultants to develop data marts, BI reports and strategic metrics reporting to support the Production Management Organization.
• Responsible for designing, developing and implementing interactive dashboards for Operational and Key Performance Indicators (KPI) metrics that are available on demand in digital form
• Have created dashboards using SharePoint SSRS, SharePoint 2010, MS SQL Server 2008, IBM Cognos 8, HTML, JavaScript, XML and more.
• Work with senior management within and outside my organization to understand requirements, and work with my team to successfully execute while ensuring timely delivery.
• Designed and developed automated ETL processes with the goal of integrating multiple systems. ETL includes but not limited to creating SQL jobs to Extract, Transform and Load environmental and incidental data from.
• Leading a project that involves a complete redesign and migration of non‐normalized databases into a data warehouse with a Staging, Warehouse and Data Mart databases with the focus on achieving better performance and.

As a college student, I was a QC Technician at Focused Tech, a document imaging company. Part of my responsibilities included scanning of confidential documents, performing quality control on those documents and finally indexing them. That process allowed for paper documents to be digitally stored for easier global access and document security.

New York, NY, US

On my second summer with MetLife, I joined the same team as I had interned with during my first summer in 2007. I was given similar responsibilities, however, I was also placed on a side project to collect and produce metrics for the entire QA organization. I was able to automate data gathering and analysis using MS office suite and VB Macro development.

New York, NY, US

I Interned with MetLife as a Quality Assurance Analyst as part of the MetLife/Inroads intership program. During my internship, I was introduced and exposed to all aspects of application development with a focus on software testing. One of my responsibilities was to develop and create test cases that could be used by our teams on specific applications based.

Master Of Business Administration - Mba, Finance

Information Studies, Information Technology