Datawarehouse Architect Resume

SUMMARY

Over 6 years’ work experience as Business Intelligence Consultant and Datawarehouse Architect, who has specialized knowledge in Finance and Information Technology, focus in Financial Services, Energy and Mining Sector.

PROFESSIONAL EXPERIENCE

Confidential

Datawarehouse Architect

Responsibilities:

Development and design of Reports and Dashboard.
Configuring and design the Write Back forms functionality.
Development of Oracle PL/SQL and tuning programs for ETL Process.
Developing of Web Services to call the PL/SQL ETL Procedures.
Setting SMTP Server for Mailing and the integrating with Oracle BI Delivers.
Integrating SSO EBS - ICX security with Oracle E-Business Suite R12 and Oracle BI 11g.
Drill back functionality, drill down from Oracle BI 11g to Oracle E-Business Suite R12.

Confidential

Engineer Support

Responsibilities:

Confidential

Functional and Technical leader

Responsibilities:

Gathering the business requirements to configuring and modeling the repository.
Extracting information from Oracle E-Business Suite R12 - Fixed Assets.
Developing of Oracle OLAP Cube for the charge of data.
Development of Oracle PL/SQL and tuning programs for ETL Process.
Model Slowly Changing Dimension 1 and 2.
Development and design of Reports and Dashboard.
Customizing Oracle BI Catalog with CSS and Views (Pivot Table, Table, Graph, etc.).