خلاصہ

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
نومبر ۲۰۱۰ - جنوری ۲۰۱۸ | 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