Senior DW Engineer Resume

TECHNICAL SKILLS

Languages: SAS, PL/SQL, C#, SQL

Databases: SQL Server, Oracle, Informix

Business Intelligence Tools: SAS Enterprise Guide

DWH automation tools: WhereScape

Operating Systems: Windows, Linux

Others: shell scripting, SAS for Unix.

PROFESSIONAL EXPERIENCE

Confidential

Senior DW Engineer

Responsibilities:

Developed the internal Charging/Pricing model for 2017 for Infrastructure and Operations.
Remodeled the existing employee data, and implemented the necessary changes across all impacted applications and data structures.The new model significantly simplified the process of using employee data across the DWH.
Designed and implemented new data models in the DWH.
Developed ETL tools to extract data from various sources and load data into the DWH.
Created data marts and data views for the Service Reporting team and other departments.
Improve the performance of the DWH.
Played a key role in implementing the new DWH for Infrastructure and Operations.

Confidential

Senior SAS Developer

Responsibilities:

Designed and implemented data marts (e.g. clients, accounts, deposits, funds), which became the main data source for ad - hoc reporting.
Implemented ad-hoc and monthly SAS reports related to accounts, funds, deposits, pension schemes, and customers.
Analytics and calculating monthly KPIs related to accounts, funds, deposits, pension schemes, and customers.
Implemented a report for correlating bank-adviser-client meetings wif customer product engagement.
Designed and developed an automated application for generating marketing campaigns that target specific customer segments through multiple communication channels.
Developed a SAS application for reconciliating financial transactions between SimCorp Dimension and the internal accounting system.
Optimized and refactored the application for Customer Segmentation and other customer-related applications.

Confidential

SAS Developer

Responsibilities:

Designed and developed reporting applications for the Sales department.
Developed Analytics/Reports such as "Product offering optimizations", "Product suggestions for customers", "Commercial Alerts".
Data analysis for the Sales department.
Refactored internal and regulatory reports to use IFRS (International Financial Reporting Standards).

Confidential

BI Consultant

Responsibilities:

Developed regulatory reports for the Confidential Bank such as "Availability of funds and engagement", "Liquidity" etc.
Other internal reports and Data analysis.
Mobias Bank Project, Confidential Wrote shell scripts for extracting data from Informix databases. Contributed to the creation of the DWH and developed SAS applications for loading data into the DWH.
Developed complex financial regulatory reports for the Confidential Bank of Moldova such as the Balance sheet, Monetary Statistics, Opened positions in foreign currency.
Also developed the report for Suspected Money Laundering Transactions.
Developed various other reports and data export applications for the bank's internal use.