Barkat Halani

About Barkat Halani

Specialties:>> IT professional with 18+ years of extensive experience in application design, development, and implementation Oracle EBS (11i/R12) projects for Oil and Gas, IT Services, manufacturing and engineering industries.>> Providing end-to-end solutions using Oracle technologies for EBS R12 modules related to SCM, OTC, and P2P (INV, BOM, ENG, WIP, OM, PO, AR, AP, GL).>> Oracle Certified Professional Application Developer (SQL, PL/SQL, Oracle Forms, Oracle Reports), certification for ITIL foundation.>> Data conversion/migration, using open interfaces/APIs, design and development of RICE components, Data extractions, cleansing, transformations, and building enterprise Data Warehouse/Data Marts using Informatica PowerCenter.>> data warehousing, ETL architecture, creating database design, entity relationship modeling and dimensional modeling using Star and Snowflake schema, and tuning Mappings and sessions for better Performance.>> Database back-end programming in PL/SQL for creating Packages, Database Triggers, Functions, debugging and tuning the PL/SQL code, tuning complex queries for performance and optimization, designing and developing complex interfaces for Bank, Engineering, Manufacturing, and SCM modules, creating materialized views and packages for outbound interfaces for data warehouse.>> Handling production support tickets, creating SRs, writing data fix scripts for production issues, writing technical specs, unit test scripts, coordinating with end-users and BAs.>> Good knowledge of Oracle Forms/Reports, BI/XML Publisher, Workflow, Business Events, Alerts, Unix Shell Scripting. Worked on many complex forms and report modules.>> Experience of working with offshore development team in India and project delivery within schedule/budget.Technical Skills: Oracle EBS R12, SQL, PL/SQL, Informatica PowerCenter, Oracle Reports/Forms/Workflow, SQL*Loader, Data Loader, BI/XML Publisher Reports, UNIX Shell Script, ETL Processing for DWH/DM

Experience

1. Sr IT Programmer Analyst

   Puffer-Sweiven

   Sep 2019 — Present · Houston, TX, US

Education

• SP University

  Bachelor's degree, Computer Science

  1984 — 1987

Skills

• Data Warehousing
• Testing
• Bi Publisher
• Unix
• Oracle Applications
• Oracle E-Business Suite
• Erp
• Business Intelligence
• Integration
• Oracle Manufacturing
• Enterprise Resource Planning (Erp)
• Oracle Payables
• Oracle
• Requirements Analysis
• Oracle Soa Suite
• Obiee
• Xml Publisher
• Business Analysis
• Oracle General Ledger
• Oracle Engineering
• Software Development Life Cycle (Sdlc)
• Business Process
• Oracle HR
• Sdlc
• Oracle Discoverer
• Oracle Bom
• Informatica
• Oracle Reports
• Oracle Forms
• Order Management
• Pl/Sql