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

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship