System Analyst BI
Magrabi Retail
Total years of experience :12 years, 3 Months
Maintaining and Creating:
-Standard Data Flows:
Custom Extractors
Generic Extractors
Data sources
Info sources
Transfer Rules
Data Transfer Processes (DTPs)
Update Rules
Info packages
Info package groups
Info objects
ODS
DSO
Info cubes
Process Chains
-Reporting Tools
BEx Queries
WEBI Reports and Dashboards
xCelsius Dashboards
Crystal Reports
-BEX Queries
Variables
Calculated key figures
Restricted Key Figures
Infoset Queries
Workbooks
-BEx Analyzer
-BEx Browser
Reporting with:
SAP Business Objects Business Intelligence 4.0 Universes
SAP Business Objects Webi reports
BICS Connections
Crystal Reports
Live Office
-Conducted analysis to recommend SAP best practices
System Performance Tuning
-Upgrades from SAP BW 3.5 environment to SAP BI 7.4 environment
•Implement MYSQL procedures to automate different work processes
•Create reports and dashboards using Cognos 10 integrated with Oracle 10g database
•Prepare data views and tables for data analysis tools
•Build Cubes for analysis using Cognos Transformer Tool
•ETL procedures and Jobs run on daily, monthly and weekly basis
•Cognos 8 planning
•Database administration
•Can deal with all database issues
•Cognos, 10 Framework (creating packages, apply security roles, relationship construction)
•Cognos 10 Administration and installation process from scratch
•Good knowledge of business analysis
•Analysis of raw data to support Decision making
•Segmentation of data to analyze data
• Report developing*SQL using Report Builder
• Technical support for Oracle E-business suite
• Training new users to use Oracle HR, Financials and Payroll Modules
• SQL & PLSQL Coding using TOAD
Minor software Engineering also interested in sales
American Diploma with honors