We provide IT Staff Augmentation Services!

Programmer Analyst Resume

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

Hire Now