aser

Designing, developing, implementing and maintaining ETL workflows, mappings, scripts, and stored procedures via Oracle's Data Integrator (ODI) ETL tool to support the data warehouse and reporting requirements.
Developing SQL queries/scripts to validate the completeness, integrity and accuracy of data within the ETL process testing cycle.
Reviewing and analyzing source data, analyzing and documenting data flows, and validating mapping specifications and business rules from data source to target.
Troubleshooting DW and data quality problems.
Identifying, coordinating and helping resolve the root cause of day to day production issues.
Creating system documentation including source to target data mapping, database design diagrams, programming specifications.
Recognizing business requirements in the context of BI and creating data models to transform raw data into relevant insights.
Creating dashboards and interactive visual reports.
Defining key performance indicators (KPIs) with specific objectives and tracking them regularly.
Analyzing data and displaying it in reports to aid decision-making.
Converting business needs into technical specifications and establishing a timetable for job completion.
Creating, testing, and deploying Power BI scripts, as well as executing efficient deep analysis.
Using SQL queries to get the best results.
Making technological adjustments to current BI systems to improve their performance.
Analyzing current ETL procedures to define and create new systems.
Developing and maintaining SharePoint reports using SQL Server Reporting Services (SSRS) to provide stakeholders with convenient access to critical business data.

Oracle's Data Integrator (ODI)
- Designing, developing, testing, debugging, implementing and maintaining ETL
workflows, mappings, scripts, and stored procedures, via Oracle's Data Integrator (ODI)
ETL tool, to support the data warehouse and reporting requirements.
- Developing SQL queries/scripts to validate the completeness, integrity and accuracy of
data within the ETL process testing cycle.
- Reviewing and analyzing source data, analyzing and documenting data flows, and
validating mapping specifications and business rules from data source to target.
- Troubleshooting DW and data quality problems. Identifying, coordinating and helping
resolve the root cause of day to day production issues.
- Creating system documentation including, but not limited to, source to target data
mapping, database design diagrams, programming specifications, etc.
• Power BI
- Recognize business requirements in the context of BI and create data models to transform
raw data into relevant insights
- create dashboards and interactive visual reports
- Define key performance indicators (KPIs) with specific objectives and track them regularly
- Analyze data and display it in reports to aid decision-making
- Convert business needs into technical specifications and establish a timetable for job
completion
- Create, test, and deploy Power BI scripts, as well as execute efficient deep analysis
- Use SQL queries to get the best results
- Make technological adjustments to current BI systems to improve their performance
- Analyze current ETL procedures to define and create new systems