SUMMARY

• 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.

TECHNICAL SKILLS

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.

PROFESSIONAL EXPERIENCE

Confidential

Programmer Analyst

Responsibilities:

• 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 .

Confidential

Oracle Data Warehouse Developer

Responsibilities:

• 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.

Confidential

Business Intelligence Developer

Responsibilities:

• 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.

Confidential

Software Engineer/Techno Functional Developer

Responsibilities:

• Created reports for Sales Memo both in Debit and Credit.
• Developed reports for Payables and Receivables.
• Development of Journal Voucher and Localization reports