Assistant Manager
Kohat Cement
Total years of experience :5 years, 5 Months
Developing Oracle Reports and Forms Development
▪ Developing PL/SQL packages, procedures, functions, triggers.
▪ Data Insertion through Interface and APIs.
▪ Developing Views and Materialized Views.
▪ Database Development Task (Table Creations, Alteration, Jobs) etc.
▪ SSRS Reports Development
▪ Database development and monitoring.
Microsoft Power BI
▪ Cleansing and Transformation of Data
▪ Pivoting and Un pivoting Data
▪ Building Data Models and Relationships
▪ Performed Data Quality and Functional Testing
▪ Developing Power BI Reports and Dashboards
▪ Designing Power BI data visualization utilizing cross tabs, maps, scatter plots,
pie, bar and density charts.
▪ Utilizing Power BI to create various analytical dashboards that depicts critical
KPIs.
▪ Involving
Oracle E-business Suite R12
▪ Oracle Forms Customization, Personalization & integration with R12
▪ BI/XML Publisher and Oracle reports development.
▪ Development of customized workflows, Alerts.
▪ Developing PL/SQL packages, procedures, functions, triggers.
▪ Developing Views and Materialized Views.
▪ Creating Quality Plans According to Organization Needs
▪ Database development and monitoring.
▪ Database Development Task (Table Creations, Alteration, Jobs) etc.
▪ Functional and Technical support of team members
▪ Defining Executable, Concurrent Programs, Request Groups and Responsibilities
▪ Creating Users, Suppliers, Customers, and Master Items.
▪ Creating Banks, Banks Accounts and Check Books.
▪ Data uploading through Interfaces, API’s and SQL Loader.
▪ Performance tuning of reports.
▪ Raising Service Request for oracle support.
Oracle BI (OBIEE)
▪ Translating business requirements into technical requirements.
▪ Creating interactive dashboards as per business requirements
▪ Creating Reports as per business requirements
▪ Working with Scheduling the different reports as per requirements
▪ OBIEE Report Bursting
▪ Working with OBIEE Administration Tool
Microsoft Power BI
▪ Cleansing and Transformation of Data
▪ Pivoting and Un pivoting Data
▪ Building Data Models and Relationships
▪ Performed Data Quality and Functional Testing
▪ Developing Power BI Reports and Dashboards
▪ Designing Power BI data visualization utilizing cross tabs, maps, scatter plots,
pie, bar, and density charts.
▪ Utilizing Power BI to create various analytical dashboards that depicts critical
KPIs.
▪ Involving in trouble shooting, resolving and finding data related issues and
validating data to improve the data quality
Oracle EBS R12:
▪
Developed Oracle Custom Forms and Reports.
▪
Personalized Oracle standard and custom Forms using oracle forms builder as per the Client requirements.
▪
Developed PL/SQL packages, procedures, functions, triggers.
▪
Developed Views and Materialized Views.
▪
Developed Xml Publishers Templates.
▪
Developed Custom Alerts and Workflows
▪
Used to Standard APIs and Interfaces
▪
Oracle EBS Functional Support (Suppliers and Customers Creations, Master Items, Value Sets, Quality Plans).
▪
Functional and Technical support.
▪
Performance tuning of reports.
▪
Data uploading through Interfaces, API’s and SQL Loader.
Oracle In-House Development:
▪
Developed Powerhouse System
▪
Developed Gate Pass System
▪
Developed LC form to capture information about LC
▪
Sales Tax Form for tracing Tax Invoices of Suppliers
I studied many subjects Software Engineering Programming Web Engineering Database