Profile of P
P Warehouse Management Systems
Highly skilled IT professional with a proven track record of 7 years in the industry. Expertise in data warehousing, reporting, analysis, and ETL implementation. Proficient in various business intelligence tools, including OBIEE, Informatica, and Oracle BI Apps.
Skills:
**Technical Skills:**
* **BI Tools:** OBIEE 11g/10g, OBIA 11.1.x/7.9.x, BI Publisher, SmartView, Catalog Manager
* **Dimensional Data Modeling:** Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling
* **Data Warehousing/ELT/ETL:** ODI 11.1.1.7, Informatica Power Center 9.x/8.6.1/8.1.1
* **OBI Apps Modules:** Oracle Financials [GL, AP, AR], Oracle Projects, Oracle Manufacturing [OM, PO, INV]
* **Databases:** Oracle 11g/10g/9i/8i/8.0/7.x, MS SQL Server 2012/2008/2005
* **Operating Systems:** Windows 2000/XP/7, Window NT, Unix, Linux
* **Programming GUI:** SQL, PL/SQL, SQL Plus, Unix, Perl, Shell Scripting, Java
* **Web Technologies:** HTML, Java Script, JSP, XML, XSLT, Web Services
**Other Skills:**
* Excellent communication and interpersonal skills
* Strong domain knowledge in Banking, Insurance, Utilities, and Benefits Administration
* Proficient in data warehouse development life cycle, including requirement analysis, dimensional modeling, and implementation
* Expertise in configuring metadata, building OBI Repository, and developing Business Models
* Experience in configuring interactive dashboards with drill-down capabilities
* Ability to grasp the big picture, conceptualize, and develop solutions