概要

Experienced in different business Intelligence tools and technologies e.g. Oracle BI (OBIEE)
Expertise in Advanced/Complex PL/SQL
Expertise building ETL processes from scratch
Exposure to BI tools (OBIEE and OBIA) with Oracle E-Business Suite as a source
Strong relational database modeling (SQL Server, Oracle, MySQL)
Experience with OBIA BI Apps ETL objects
Experience with BI Publisher, Oracle Data Integrator (ODI) and Informatica, MS SQL Server, Oracle, Machine learning

Good programming experience in C# .Net, VB.Net, Access VBA, Java, Servlet, ASP (.NET and Classic) Strong Database development experience in writing functions, procedures, triggers and views in MSSQL

Personal Strengths: Adaptability, Communication, Quick learner, Research, Innovation

Tools:
ETL Development (Informatica, Oracle Data Integrator)
BI Publisher (with Siebel CRM, Oracle EBS)
Data warehouse architecture
OBIEE Answers (Direct Database Request)
QlikView
CRM (Siebel, Zoho)
Data Mining (Oracle Data Miner, RapidMiner)

Business Intelligence (BI)
Designing and developing BI solutions and data models
Extracting, transforming, and loading (ETL) data from various sources into data warehouses or data marts
Creating reports, dashboards, and visualizations using BI tools like Oracle BI, QlikView, or Power BI
Performing data analysis, identifying trends, and generating insights to support decision-making

Software Engineering and Development
Designing, coding, and testing software applications using programming languages such as Java, C#, or Python
Applying software engineering principles and best practices for developing scalable and maintainable solutions
Utilizing software development frameworks and tools to streamline development processes
Collaborating with cross-functional teams to gather requirements, design solutions, and ensure successful software delivery

Database Management
Designing and managing relational databases, including schema design and optimization
Writing complex SQL queries to retrieve and manipulate data efficiently
Ensuring data integrity, security, and performance through proper indexing and database maintenance
Familiarity with database technologies such as Oracle, SQL Server, or MySQL

Data Integration and ETL
Extracting, transforming, and loading data from various sources into data warehouses or data marts
Implementing ETL processes using tools like Informatica, Microsoft SSIS, or Talend
Data profiling, cleansing, and validation to ensure data quality and consistency

工作经历

公司标识
Sr. Business Intelligence Consultant
Abbusys Ltd
Nov 2010 - Jan 2018 | Karachi, Pakistan

Tools
Siebel Analytics 7.x
Oracle Business Intelligence
Informatica 7.x, 8.x, 9.x
Data warehouse Application Console (DAC)
PL/SQL
QlikView
Sisense Prism Business Intelligence
Siebel CRM
Zoho CRM
Oracle Data Integrator 11G/12.1.3
BI Publisher
Extract Data from OLTP perform calculation on data as Business need and load it in OLAP Develop graph, charts and other representation techniques to show data.
Development of reports and dashboards in Oracle BI Publisher
Develop ETL jobs as per business rules using ETL design document
Validated the report generated using PL/SQL queries.
Creating trending reports for senior management reporting such as annual and quarterly comparisons
Define best practices in Data Warehouse, Business Intelligence & Data Management.
Perform data modeling activities, data integration/ETL strategy, data conversion, and validation & migration strategies.
Participate in database design sessions with other developers.
Participate in daily mentoring activities of on-shore resources.
Design/develop testing processes to ensure end-to-end performance, data integrity and usability

学历

Quaid-e-Awam University of Engineering, Science & Technology
学士, 理工学士, B.E Computer System‎
Computer Systems
2008

技能

初学者 .NET
中级 Design With UML
熟练 Microsoft SQL
熟练 MS SQL Server
初学者 MVC
中级 MySQL
熟练 OLAP
初学者 Paradox
熟练 PL and SQL
熟练 Query Language
中级 Siebel
熟练 Softwares Design
熟练 T-SQL
熟练 Windows

语言

熟练 英语
熟练 乌尔都语

Muhammad 联系人

Rahila -
CyberVision International