מיכאל שפירא, רו"ח

מקצועיות ואמינות

חולון, Israel

Freelancer

Contact

-->

ABOUT

SQL Developer at Halman Aldubi Investment House
Highly skilled with T-SQL (including: Querying, DML, DDL, writing complex queries and stored procedures, use variables, cursors, loops, etc.)

Investment Management

LANGUAGES

Hebrew

Native or bilingual proficiency

English

Professional working proficiency

Russian

Limited working proficiency

SKILL DETAILS

Finance

Economists

Internal Auditors

CFOs

Accountants

Coaching

Family Economics Coaching

Writing & Editing

Academic Papers & Reports

Software & Programming

DB - MSSQL, SQL Server

Product manager

EMPLOYMENT HISTORY

April 2015 - Today

מבקר מערכות מידע ו - Data Analyst בביקורת הפנימית

בנק דיסקונט , תל אביב

Highly skilled with T-SQL (including: Querying, DML, DDL, writing complex queries and stored procedures, use variables, cursors, loops, etc.).
Use T-SQL and IDEA program for:
• Performing data cleansing and analysis.
• Performing parallel computing.
• Generating Excel reports.
Perform systems and processes regulatory periodic audits.
Perform systems and processes analysis in order to:
• Spot deficiencies and recommend solutions.
• Save costs and boost ROI.
• Design and implement controls.
Write internal Audit reports for high management and executives.

January 2013 - April 2015

מבקר מערכות מידע - רואה חשבון חיצוני

KPMG , תל אביב

Financial and operational data analysis using SQL, IDEA and Excel.
•Validate integrity and accuracy of reports (including BI reports).
•Develop ETL (Extract, Transform, Load) processes for Parallel simulation audit techniques using
SSIS (SQL Server Integration Services).
•Audit Entity Level Controls ("ELC"), Information Technology General Controls ("ITGC") and
Application level controls.
•Assist with the design and implementation of controls to remediate outstanding deficiencies in
design.
•Financial statements Audit according to IFRS standards.