Business Intelligence Analyst
Resume:
*********@*****.***
Mirza Ahmed Ishaq Baig
Summary
** ***** ** ********** ** a Team Leader/Analyst to Provide functional/technical support for Business Intelligence and ERP applications. Technical expertise in the area of BI/applications design, development, testing and maintenance.
Design, implement and deploy business intelligence solutions Using Business Objects, Qlikview. Good experience in Data Warehouses and Business Intelligence tools
Education
MCA (Master of Computer Applications), India
Bachelor of Commerce From Osmania University, India
Diploma in Mechanical Engineering from Board of Technical Education & Training.
Higher Diploma in Software Engineering from APTECH COMPUTER EDUCATION.
Certified Business Intelligence Professional (CBIP) from TDWI (tdwi.org)
Certified Data Management Professional (CDMP) from ICCP (Certificate # 100457)
Hardware
PC Compatibles, Hand Held PC’s (PSION), Intermac Pocket PC.
Op. Systems
Windows, Linux
ERP
Oracle EBusiness Suite 12.x, IFS Applications 2004 and 2001-3(Finance & Distribution)
Databases
Oracle 11g, MS SQL, HP Vertica
Languages
SQL, PL/SQL, Java, Visual Basic, C, Oval, Pro*C, Asp
Business Intelligence
SAP Business Objects, Qlikview, Xcelsius, Oracle Business Intelligence Enterprise Edition (OBIEE), Cognos 8
Others Skills
Microsoft SSIS, Oracle Application Server 10g, Oracle Portals, IFS Portals, Oracle Development Tools, Development using Oracle. Oracle Discoverer, Forms, Reports, PL/Sql Programming, (Forms 10g/4.5/5/6i, Reports 10g/2.5/3/6i), A.S.P, (Active Server Pages). Microsoft Office Suite (Excel, Word, etc), File Magic (Imaging Software), Filenet Imaging Software, Watermark Imaging Application. T.O.A.D (PL/Sql Developer), Oracle APEX, VMware workstation. BI.
Training
TRAINING of IFS Applications.
Time Management.
Business Objects Administration and Universe Design.
Project Management from Al-Khaleej.
Qlikview Training.
WORK EXPERIENCE
Mar 2011 – Present
The Savola Group., Saudi Arabia
Senior Business Intelligence Analyst
Environment: Windows, Oracle, Oracle 12c, PL/SQL, Oracle Development Tools,, Business Objects XI R2 / R3.1 /4.1/4.2, QlikView, QlikSense
Responsibilities
Provide BI related support to IT and end users in different business units across geographies for their BI needs
Develop and test detailed functional designs for business solution components and prototype.
Supervising BI application Design, Build, Test, and Deploy activities.
Empower the users for self-service BI. Enabling the users to have Information on demand.
Ensure Policies of HQ are cascaded to the Business Units.
Provide technical expertise on Design, Performance Tuning, Data modelling, Data Warehousing for applications.
Partner with Business Intelligence and Business operational teams to implement new requirements.
Developed and enhanced several universes on top of different Oracle EBS Modules (AP,AR,GL,FA,OM,PO,HR etc..) using both relational and dimensional models.
Provide users with a semantic layers to create operational and Analytical reports reducing IT dependency.
Liaise with Business Object support to rectify technical issues.
Analyse, Design and Test Business Objects Components against data warehouses and operational data stores.
Implement extraction, transformation, loading (ETL) tasks.
Translate business requirements into report and dashboard designs.
Implement object/data level security within Business Objects and Qlikview.
Install, configure and upgrade the SAP Business Objects / Qlikview platform.
Design data warehouse/data marts/Data modelling.
Universe design and Reports development.
Business Objects Administration for Security domain which includes creating users, groups, assign responsibilities and Active Directory Integration.
Impart training on BO and Qlikview to IT Teams and End Users.
Create visually stunning dashboards using Qlikview.
Dashboard created using QlikView and uploaded to Qlik Community
GL Dashboard http://community.qlik.com/docs/DOC-7672
AP Dashboard http://community.qlik.com/docs/DOC-6263
Order to Cash (Order and AR) https://community.qlik.com/docs/DOC-8847
Mar ‘97 – Feb 2011
Al-Rabie Saudi Foods Co. Ltd., Saudi Arabia
Business Intelligence Manager
Environment: Windows, Oracle, Oracle 9i/10g, PL/SQL, Oracle Development Tools, OBIEE, Business Objects XI R3.1
A leading Dairy/Juice Manufacturing Company
Business Intelligence Responsibilities
Install, Configure the Business Objects / OBIEE platform.
Design data warehouse/data marts for Al-Rabie's BI Application. Data modelling using star schemas.
Experience in Universe design and Reports development.
Knowledge on BO Security domain which includes creating users, groups etc
Designed Input routine to enter data for BO Performance Manager Metrics and Goals.
Installation of Performance Management tool.
Designed Universe for the Performance Management Dashboard.
Created measures, metrics, Created Goals, Alerts and Rules.
Created a Corporate dashboard with analytics using Xcelsius and DashBoard Builder.
Design Universe, Reports, and Dashboard as per the requirements.
Develop ETL script to transfer data from OLTP systems to the warehouse.
Creation of BO Universe Creation of Physical, Business Model and presentation layers / OBI RPD Development.
Design and development of dashboards and reports using OBI Dashboards and OBI Answers.
Avoid manual work that goes into development of reports.
Impart training on BO XI internally to project team.
ERP Responsibilities
Providing functional and technical support for the enhancement, Implementation/Maintenance of IFS (Industrial and Financial Systems) an ERP
Analyze business needs and see how IFS (Erp) could fulfil these goals. And offer recommendations.
Business process review to determine how Al-Rabie will use IFS in various business domains such as Distribution and Finance.
Mapping of Al-Rabie Business Process with the business process of IFS.
Analyse the business needs and give suggestions to improve the flow of data. And recommend changes and produce specifications for new systems.
Actively participate in design, development, testing and implementation phases of SDLC.
Development/Customisation of the system and coding as per the specifications.
Enhance existing systems and propose technical and commercial solution to satisfy these requirements.
Translate business needs into functional specifications.
Manage the application development project deliverables and milestones.
Finding and executing continuous process improvements.
Identify data conversion requirements and participate in data mapping, data cleansing and data conversion tasks.
Module and system testing strategies, exhaustive post-upgrade testing and test plans development.
Reporting to the management regarding the status of the project.
Working over Oracle discoverer, Business intelligence tools. Application server.
Customisation of IFS Reports and Forms. Design, develop reports.
Ensure adherence to quality standards.
Supervise and coordinate the activities of related IT staff.
Coordinate with vendors and IT staff on projects.
Imparting Training to the Users on IT Applications.
Business to Business Integration (B2B) of IFS Application with Tetra Pak B2Bi Solution and Other Vendors
Integration of our existing HRMS Module with IFS Applications.
Responsible for Application Tuning. Refine, Tune Sql and PL/Sql Code. To reduce the overall database load.
Working with API’s (PL/SQL Packages) provided to interact with the IFS Applications.
Prepare documentation for IT process, systems documentation and users manuals.
Also Involved in Analysis, designing, development & Implementation of customized software for the company, using ORACLE 9i & Developer Suite 10g (Forms 9i/10g, Reports 9i/10g), Implementation of Hand Held Computers for Sales. Deployment of Discoverer solution.
Portal Development using Oracle Portals and IFS Portal.
Audit existing applications for inefficient code and fix or offer alternatives as needed. Ability to work with other developers to improve their code.
Web-Enable Systems.
May 96 – Dec 96
Alfanar Co., Riyadh - Saudi Arabia
A Company basically involved in trading of electrical goods.
Position Programmer
Environment: Novell Netware 4.x, Developer 2000 and Oracle 7.x, MS-ACCESS and FoxPro.
Involved in designing and developing of tailor made software for the company, using MS-ACCESS, ORACLE 7.X & Developer 2000. Also responsible for giving support for system related problems.
Developed software for the preparation of quotations. A module, which facilitates the user to make pre-formatted quotations, and helps to keep, track of the status of the quotation.
Developed a Sales Analysis Software (Sales Analyzer). Which helps the user to analyze the day-to-day sales, Debtors List, Monthly/Yearly sales etc. using Developer 2000.
Responsible for usage & maintenance of imaging software (File Magic Series 4). Also have gained expertise in Imaging / Workflow Applications like FileNet & WaterMark software.
Role: Responsible for development and maintenance of the above systems. Conduct User Training for the system.
Oct '95 - Mar '96
NASHSOFT SYSTEMS PVT LTD., HYDERABAD - INDIA
Position Customer Support Engineer.
Involved in giving Technical Support for Virus Related Problems.
The major part of the job was retrieval of data from crashed Hard disks, Manual Rebuilding of partition table, Boot record Entries, FAT, Root directory Entries Using Software Like Diskedit & Nashdisk. Wrote utilities to make a key disk (A disk used to make software machine dependent, copy proof)
Apr 95 – Aug 95
FRONTIER INSTITUTE OF INFORMATION & TECHNOLOGY., HYDERABAD. - INDIA
Position Faculty.
Involved in imparting Software Training. And responsible for guiding in real time projects for the students by using FoxPro 2.5, ORACLE.
Technical Support: Installation of all major software, Faculty improvement programs and monitoring of live projects.
Role: Training, Responsible for development and maintenance of the projects.
Sep 93 – Jul 94
BUSINESS INFO SYSTEMS, HYDERABAD. - INDIA
Position Programmer.
Worked as a PROGRAMMER and involved in various projects like “Assistant Principle”, Construction Management Module, and Question bank using FoxPro.
Also involved in giving user training for the above mentioned software.
Role: Programmer responsible for coding & relevant documentation.
Contact this candidate