Developer Project
Resume:
Mohammad Ali Khan Khattak
**** *** ********, ********, ******, Canada, H3J 2Y3
(Home) 514-***-****, (Cell) 514-***-****
Email: ***********.***********@*****.***
PROFILE
Business Intelligence Consultant specializing in BusinessObjects, Cognos, and MicroStrategy.
Worked with clients in numerous industries including Manufacturing, Finance, Retail, and Telecommunications.
Have a wealth of knowledge in Relational Dat abases and Data Warehouse development and equipped with exceptional
analytical, problem solving and communication skills.
SKILLS
Business Intelligence Tools & Methodology
Technical Documentation
TECHNOLOGIES
Reporting: BusinessObjects 4.0 and XI; MicroStrategy 8; Cognos 7, 8, and 10
DBMSs: Oracle, SQL Server, Teradata V2R5, V2R6, and V2R12
ETL: Informatica
Data Modeling: ERWin
CERTIFICATIONS
1. MicroStrategy Certified Project Designer
2. MicroStrategy Certified Report Developer
3. MicroStrategy Certified Platform Administrator
4. Teradata Certified SQL Specialist
PROFESSIONAL EXPERIENCE
Jan 2012 - Present
Abilis Solutions
BI Consultant/BusinessObjects Developer, Montreal, QC
BusinessObjects Reporting and Universe Design
Requirements gathering
User Training
IATA, Montreal, QC Jan 2012 - Present
BusinessObjects Developer, Environment: BusinessObjects 4.0
Project highlights: data marts for various subjects areas with reporting and universes for each data mart
Gathered requirements and analyzed source data
Assisted in data model design, developed universes, and reports based on aforementioned universes
July 2010 Dec 2011
TEKsystems
BI Developer, Montreal, QC
BusinessObjects Reporting and Universe Design
Mapping source data
July 2011 Dec 2011
Markel Insurance Company, Richmond, VA, U.S.A.
Cognos Developer; Environment: Cognos 7, Cognos 10
Project highlights: migration from Cognos 7 to Cognos 10.
Analyzed existing Cognos 7 Impromptu reports and Transformer cubes
Designed proof of concept reports in Cognos 10
Assisted in framework design by analyzing Cognos 7 catalogs
Mohammad Ali Khan Khattak
2208 Rue Duvernay, Montreal, Quebec, Canada, H3J 2Y3
(Home) 514-***-****, (Cell) 514-***-****
Email: ***********.***********@*****.***
ADESA, Carmel, IN, U.S.A. June 2011-July 2011
Project highlights: datawarehouse built on Oracle; reporting on Cognos 10
January 2011 April 2011
Lorillard Tobacco Company, Greensboro, NC, U.S.A.
BusinessObjects Developer; Environment: BusinessObjects XI R3.1
Project highlights: Designed reports in BusinessObjects, and assisted in universe design.
Assisted in development of complex reports with complex layouts, multiple quer ies, and dozens of variables per report
Assisted in performance tuning of the reports and suggested changes to universe design to accommodate reports
July 2010 December 2010
Peabody Energy, St. Louis, U.S.A.
BusinessObjects Developer; Environment: BusinessObjects XI R3.1, Oracle 10G
Project highlights: Designed universes in BusinessObjects, and assisted in report development.
Designed over 10 complex universes based on normalized models with multiple contexts per universe
Determined relationships between tables based upon various representative SQL based reports from the previous system
Wrote SQL queries to profile the data in the different schemas and handled exceptional data in the Universe
Assisted in the development of the source mapping docume nt
Assisted in development of over 15 reports with complex layouts and multiple queries per report
Assisted in performance tuning of the reports
December 2005- March 2010
Teradata Global Consulting Services
Professional Services Consultant, Pakistan
April 2009 March 2010
Djezzy (Orascom Telecom Algeria), Algeria
BI Team Leader; Environment: BusinessObjects XI R3.1
Assisted in the project plan for BI
Gathered application requirements, and assisted in source system analysis: documented business rules
Designed Presentation Layer
Created Report Matrix (Mapping between Presentation layer and Logical Data Model (LDM))
Assigned Presentation layer build tasks
Assisted in presentation layer build and test
Created BusinessObjects universes, reports and dashboards
Nokia Enterprise Data Warehouse (EDW), Finland March 2008- March 2009
BI Modeller and Developer, Environment: Cognos 8.2
Project included a complet e life cycle of BI Application on top of Teradata s Manufacturing LDM
Devised application design (Report/Universe Matrix, Model/Report/Cube Design)
Designed and developed Presentation layer, Semantic layer, Scripts, Reports, Cubes, and Security Model
Involved in Testing to Handover
SAKS Fifth Avenue, United States September - December 2007
BI Consultant, Environment: Cognos 8
Tasks: 1. Requirements Gathering;
2. BI Analysis and Reporting;
3. Devising and Implementing (BI Security and Authentication Model, Unit and Integration
testing of: Presentation and Semantic layer, and Aggregate Monitoring)
4. Conducted Knowledge Transfer Sessions
Telenor (Telecom), Pakistan April - August 2007
BI Consultant, Environment: BusinessObjects 6.5
Project included a complete life cycle of BI Application on top of Teradata s Communication LDM
Tasks: 1. BI Application Design: Report/Universe matrices, Universe, Presentation layer, and
Report design
Mohammad Ali Khan Khattak
2208 Rue Duvernay, Montreal, Quebec, Canada, H3J 2Y3
(Home) 514-***-****, (Cell) 514-***-****
Email: ***********.***********@*****.***
2. Development: BusinessObjects reports, Presentation layer scripts, and unified Universe
3. Testing: User Acceptance testing of the final BusinessObjects solution
DHL, Czech Republic Jan - March 2007
Cognos Developer, Environment: Cognos 8
Tasks: 1. BI Application Design: Report matrix, Univer se, Presentation layer, and Report design
2. Development: Reports and Presentation layer scripts
Daimler Chrysler Financial Services (DCFS), United States April - Dec 2006
Report Developer, Environment: Cognos ReportNet
Project: Complete life cycle of BI Application on top of Teradata s Financial Services LDM
Tasks: 1. Design: Presentation layer, and Report design
2. Development: Report Studio Reports, Presentation layer scripts
3. Documentation: Cognos Framework Model
4. Testing: User Acceptance testing of the complete Cognos solution
Askari Commercial Bank, Pakistan Feb - March 2006
Report Developer, Environment: Cognos ReportNet
Project: Complete life cycle of BI Application on top of Teradata s Financial Services LDM
Design: Report/Catalog Matrices, Catalog, Presentation layer, Report and Cube design
Development: Impromptu Reports, Transformer Cubes, Presentation layer scripts, and Unified Catalog
August 2004 - August 2005
World Food Program
Intern, Rome, Italy
August 2002- December 2003
McGill University
Researcher, Montreal, QC
EDUCATION
Bachelor of Science, Computer Science June 2002
McGill University, Montreal, Quebec, Canada
Bachelor of Science, Biology and Mathematics June 2000
McGill University, Montreal, Quebec, Ca nada
REFERENCES AVAILABLE UPON REQUEST
Contact this candidate