Smitha Philip Email & Phone Number

Pretoria, Gauteng, South Africa

South Africa

• Building dashboards using Power BI• Design and develop reporting scripts in the various systems using MS-SSRS• Ensure correct and prompt development of report and related services• Optimizing and maintaining existing reports developed• Develop data extracts and data selections as required to establish the report datasets• Performance analysis of SQL queries• Tables, views, functions and stored procedure creation and maintenance• Extracting data from a data source and platforms such as SQL.• Design/maintenance ETL (Extract Transform Load) processes from the systems to using MS-SSIS• Interact and collaborate with clients to understand data specifications and to satisfy reporting requirements.• Assist with systems development and systems development requirements specifications.• Test all development for data accuracy, performance and system impact• Schedule extracts and report runs as required to deliver the required information to users• Development of all relevant documentation including code comments, process documentation.

Centurion

• SQL Performance analysis of SQL queries Tables, views, functions and stored procedure creation and maintenance• Extracting data from a data source and platforms such as SQL.• Design/maintenance ETL (Extract Transform Load) processes from the systems to using MS-SSIS• Design and develop reporting scripts in the various systems using MS-SSRS• Develop data extracts and data selections as required to establish the report datasets• Interact and collaborate with clients to understand data specifications and to satisfy reporting requirements.• Assist with systems development and systems development requirements specifications. • Test all development for data accuracy, performance and system impact• Schedule extracts and report runs as required to deliver the required information to users• Development of all relevant documentation including code comments, process documentation.

Centurion

• Create database queries• Create tables, views, stored procedures, functions in database• Ensure correct and prompt development of report and related services• Optimizing and maintaining existing reports developed• Perform quality checks on reports • Develop and Optimize stored procedures and functions using T-SQL• Automate jobs• Ensure assigned tasks are complete within the timeframe established by the project plan

Centurion

Bryanston

Pretoria Area, South Africa

Master Of Computer Applications (Mca), Computer Science

Bachelor Of Mathematics, Mathematics And Statistics