- 6+ years of professional IT experience in Design and Implementation of Data warehouse for Finance and Telecom Domains .
- Extensive design, development and testing experience in OBIEE 10g/11g Financial Reporting, Oracle prebuilt Analytics, ODI 11g, Data Modelling .
- Strong experience in all phases of data warehouse lifecycle, from requirement gathering to post go live support .
- Experience in integration of different data sources like Oracle, Big Query, Flat files .
- Expertise in performance tuning of l ong running ETL jobs, OBIEE Report queries and Database.
- Strong Experience in Oracle RDBMS v10g/9i/8i .
- Extensive experience in working under tight deadlines for Month end closure activities for Financial systems at Confidential .
- Experience working with integration process for encrypted data sources such as - Headcount, payroll.
- Providing Production Support, for Financial data warehouse, implemented at Confidential .
- Skilled in understanding the Data patterns and key performance indicators ; streamlining of process to business intelligence tools.
- Strong experience in providing OBIEE Ad-hoc reporting Solution .
- Strong experience in troubleshooting and handling production support duties on a 24x7 schedule .
- Strong techno/functional knowledge of Oracle Apps modules - GL,AP,AR,SCM,OM .
- Worked in an Agile/Scrum Sprint environment.
- Strong experience training offshore developers on Data warehouse implementation lifecycle.
- Strong Sql, Pl/sql writing skills.
- Experienced in writing python Scripts .
- Experience creating reports using Oracle Smartview.
- Experienced in knowledge transfer process, preparing the required documentation and training the clients.
- Confident, Self-motivated, Excellent team player.
OLAP and BI Tool s : OBIEE 10g and 11 g,Hyperion,Oracle Reports 6i,10g, Oracle Apex.
Data Integration Tools: Informatica Power Center, ODI (Oracle Data Integrator),BODS,Pentaho.
Databases/Languages: Oracle 8i, 9i, 10g, 11g, PlSql,Sql, Python.
ERP: Oracle Applications 11 i (GL, AP, AR, OM, INV), Oracle R12(OM/GL).
Others: OBIA, DAC, JDeveloper, TOAD, SQL Developer, SQL Loader.
- Providing first hand Production support for Confidential Financial BI Solution which includes Major Financial Reportings- Balance sheet, P&L, Financial Planning, AP,Fixed Assets,Payroll,Headcount,Usage Tracking.
- Responsible for identifying/ fixing issues reported during Month/Quarter/Year close financial activities.
- Involved with Development team for Integration Testings and bug fixes.
- Providing Support on ETL solution implemented through ODI, involving integration between different data sources of Confidential - Oracle,Essbase,HFM, Confidential developed sources, File system.
- Interacting with Business Users/Client for daily Production Issues and Enhancement requests.
- Work on performance tuning of the Implemented etl mapping and obiee Reports.
- Responsible for proactively identifying the data issues and fixing them.
- Work on Data Validation Reports,for comparison between source and the Data warehouse, for sources -Oracle EBS, Hyperion,HFM, File systems.
- Providing Trainings / knowledge sharing to Offshore support.
- Providing Ad-hoc Reporting solution to Business Users.
- Responsible for identifying the enhancements in the existing Data Warehouse solution.
- Writing complex plsql solutions .
Oracle Data Warehouse Developer
- Writing complex pl/sql for Network and Finance Domain Data Marts.
- RPD Modelling for Data Marts in Network and Finance domain.
- ETL job development and configuration.
- Dashboard and Report development for Networks and Finance.
- Daily Support for Commercial Traffic and Revenue Reports and ETL Process.
- Developed traffic Reports in Hyperion.
- Involved in Data Migration projects for Distribution partners of Inmarsat.
Business Intelligence Developer
- Developed Centralized Business Intelligence System for All Business Units of Zamil.
- Configuration and Deployment of OBIA and DAC.
- Configured Oracle Pre built business intelligence Dashboards, Reports and RPD for Procurement and Finance modules.
- Writing complex SQL Ad hoc Queries
- Customization of Pre built Dashboards, Reports and ETL Mappings.
- Designed data warehouse for Inventory, Purchase and Machine Maintenance.
- Report creation for Stock Analysis; Material Management (Consumption, Issuance, and Received); Inventory Management; Requisition and operations reports.
- Reports creation for Machine Maintenance Module.
- Optimized and Fine tuned the Query and Mappings.
- Testing and Documentation.
- Provided Training to New Joiners for Oracle Database, Pl/sql, OBIEE, Data Warehouse Concepts, OBIEE,ODI.
Software Engineer/Techno Functional Developer
- Created reports for Sales Memo both in Debit and Credit.
- Developed reports for Payables and Receivables.
- Development of Journal Voucher and Localization reports