Resume of Business Intelligence Developer

Title
Business Intelligence Developer

Primary Skills
Business Objects

Location
Canada-ON-Milton

Posted
Nov-18-07


• Over 13 years of experience in the IT consulting industry.
• Team member of Business Intelligence, Reporting and Data Warehousing.
• Over 5 years experience in Business Objects.
• In depth knowledge of Oracle RDBMS; Sybase RDBMS; excellent knowledge of SQL and PL/SQL language.
• Certification Exam #1 1Z0-001 Introduction to Oracle: SQL and PL/SQL


TECHNICAL SKILLS
Databases Oracle 9i, 8.0 & 8i, Sybase, MS Access (Ver. 1, 2, 97 & 2000)
Packages Business Objects XI, 6.5.2, 6.1 & 5.1, Informatica, DBArtisan, Toad, PL/SQL Developer, Erwin, Visio, Oracle Developer 2000 (Forms 5.0, Report 3.0 & Graphics 3.0), Cognos Impromptu 5.0 & 6.0, Visual SourceSafe 6.0, MS Outlook 2000, Lotus Notes, UltraEdit, MS Project and MS Office.
Languages PL/SQL, SQL, XML, C/C++, Java and Visual Basic Access
Operating Systems Windows-NT, Windows 2000, Windows 95/98, Ultrix & UNIX

EXPERIENCE
ING Insurance - Toronto, Ontario
Business Intelligence Developer, December 2006 to Present
Security Administration of Business Objects XI Release 2. Managing the Business Objects security using CMC and CCM of over 600 users. In charge of migrating reports and universe between DEV/QA/PROD environments.

• Developed the security for users and groups using CMC.
• In-charge of managing Development, QA and PROD Environments.
• Log cases with Business Objects for issues like session time outs and other technical issues.
• Developing and modifying reports using Web Intelligence in BO XI.
• Developed Universe in BO XI.
• Lead test integrator for our Policy & Premium project, in charge of the team of 2 developers.
• Designed the user Registration process for Business Objects. This process is designed in Lotus notes. Business Objects security portion designed using Oracle Form.


Morgan Stanley (Compuware) - Montreal, Quebec
Business Intelligence Developer, May 2005 to November 2006
Team member of Business Intelligence group to develop Business Objects reports and Data Warehouse for the HR department.

• Developing reports for PeopleClick, Campus Recruiting and Learning Management system.
• Technical support clients for the reports problem.
• Developed and modified Informatica mappings to load data from LMS transactional system to the HR datawarehouse. This ETL process contains workflows which runs 4 hourly, daily and weekly basis.
• Monitored and troubleshooted the data loading problems of Informatica.
• Developed Informatica mapping to load data from an old application to the new application. Developed Data warehouse based on new Latitude application.
• Provide on-line and telephone support to our client all around the globe.
• Developed and maintained Packages and views in LMS system in Oracle.
• Experience with Business Objects Reporter, Designer, Supervisor, Web Intelligence and Infoview.
• Experience with a Business Objects deployment including knowledge of Business Objects security, infrastructure, installation, configuration, administration and end user support.
• Developed and Maintained Data Marts and Data Warehouse for HR department.
• Mastered the techniques of Dimensional modeling (Dimension table, Fact table, Star Schema and Snow flakes schema).

CGI - Montreal, Quebec
Database Developer, February 2001 to April 2005
In-charge of the team to design, develop and deliver Business Objects reports to our client PSE&G in New Jersey USA. Developed three universes, which were used to develop Business Objects reports. In charge for creating and modifying all the objects in the universe. This creation of universe and reports for PragmaLine product involved several client and internal meetings to gather specifications, design and development of the final product. Design and developed Oracle tables, views, triggers and packages for our PragmaLine product.

• In-charge of the team of three people. Manage the whole process from reports specification gathering, sign off of reports specification document, reports development, reports testing and reports delivery. This whole process involves various visits to client sites and conference calls.
• Designed three Business Objects Universes for our client PSE&G, which have tables, linked from two Oracle Databases. These universes have several measures, dimensions, User Prompts and many contexts.
• Developed many reports with Business Objects reporter module.
• In-charge of Business Objects supervisor module and Business Objects Web Intelligence module.
• In-charge for writing reports specifications which involved several meetings with client.
• Installed Business Objects Full client and Business Objects Web Intelligence several times on different machines.
• Wrote Oracle packages, procedures, functions and triggers using PL/SQL.
• Mastered PL/SQL programming, bring new ideas to my company like Pragmas, Savepoints, Partial Rollbacks, used temporary tables to create an Oracle trace.
• Wrote Oracle packages to ETL data from old system to new PragamLine system.
• Developed Data warehouse to be used for Cognos reports.
• Designed reports using Cognos Impromptu.
• Mastered Oracle tools like Oracle Worksheet, Schema Manager, Enterprise Manager, Import & Export, Instance Manager, SQL Net Easy Configuration, Storage Manager and Data Manager.

CIBC (INTRIA Items Inc.) Mississauga, Ontario
Contractor, November 2000 to January 2001
Designed and developed a database using MS Access 2000 for the Production tracking system. This database tracks the production per function and produces the productivity per function, team, shift, day, week and month. It also produce the over all loaded productivity and equivalent of full time employee for the day, week and month.


ALCATEL Contracting, France
Senior Programmer Analyst, July 95 to June 2000 (Consulting in Bangladesh)
Project of Dhaka Chittagong Fiber Optic Link and 150K Digital Telephone Lines installation with Bangladesh Telephone and Telegraph Board.
• Used PL/SQL to create procedures, functions, packages and triggers.
• Designed and developed Tables, Indexes and Views in Oracle Database.
• Troubleshoot Oracle database problems, query optimization and table relationships.
• Consulted with client, reviewed problems and developed proposals, specifying phase by phase engagement to utilize, present hardware or to purchase advance hardware, to design and installed sophisticated systems and implement and initial operations of new systems including orientation of personnel.
• Lead a team that designed, developed and maintained the software using MS Access on Windows NT platform.

Data Processing Manager, April 92 to June 95 (Consulting in Pakistan)
Project included installation of 182K Digital Telephone Lines. A Turnkey project, which was implemented and handed over to Pakistan Telecommunication Corporation in time and under budget.
• Managed a team of Software Consultants.
• Designed and developed Personnel, Accounts, Design, Procurement, Warehouse, Quantity Survey & Reporting and Fixed Asset Management Modules.

EDUCATION
Bachelor of Science June 1991
Major: Computer Science California State University, Dominguez Hills, U.S.A.

Bachelor of Science June 1987
Majors: Physics, Chemistry and Mathematics University of Karachi, Pakistan

COURSES ATTENDED
• Informatica 2005
• C++ 2002
• Business Objects (Reporter, Designer, Security and Web Intelligence) 2001
• Cognos Impromptu 2001
• Oracle (Version 8.0 Enterprise Edition) Database Administration 1999
• Oracle SQL and PL/SQL 1999
• Oracle Developer 2000 1999

REFERENCES Available on request

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in Canada-ON-Milton »
View all resumes in Canada-ON »

View other Business Intelligence Developer resumes