Damilola A.Osikoya

(BI/DW)

Phone: 647-***-****

Email: actha2@r.postjobfree.com

OBJECTIVE

I’m a Professional with over 6+ years of BI/Data warehouse experience and a track record for continuous career growth and progression. This is demonstrated through my diverse and extensive experience with Cognos, Tableau and SQL and Database administration and development, design, architecture, team leadership and mentoring/training. I also have a solid understanding of many aspects of the BI/DW project life cycle, including business requirements gathering, data analysis, and dimensional data modeling, and testing strategies

Career Summary

Have over 6 years experience of designing and modeling Business Intelligence Analytical Solution using (IBM Infosphere Architect, Visio and DB Designer, Crystal Reports.

5 years experience in designing, implementing and developing analytical application using IBM Cognos.

5 years’ Experience in Requirement gathering, Functional spec preparation & Client interaction.

Strong complex reporting skills – complex Drill-Through, Cross-Tabs, Summary Reports, Burst Reports.

4 years’ experience using Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring.

Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.

IBM Infosphere SQL Warehouse, SSIS SSRS

5 years’ experience in developing Dashboards Reports in Cognos 8 and 10

3 years in Databases: MS-SQL, IBM-DB2, Oracle and PostgreSQL

4 years using Data Modelling tools: IBM Infosphere Architect, Erwin, Visio, DB Designer

Other Key Skills

Cognos: IBM Cognos (7 to 10) (Report Studio, Analysis Studio, Active Reports, Business Insight, and Frame-work Manager, COGNOS Transformer)

Analytics Tools: SAS, SPSS, SQL Query, MS Access

Programming Languages: Basic understanding of C, C++, .NET (ASP.NET, VB.NET), Java, RDBMS, SQL Server, Oracle, MS-Access, SAS, Mainframe

Computer Skills: Microsoft office suite including (MS-Project & Outlook), IBM Lotus Notes

Packages: MS-Offices 2007 including MS Visio, MS projects, Open office, DB Designer, MS SharePoint

Scripting Language: HTML, XML

Work Experience

World Vision Canada Mississauga (Senior BI Developer/Report Analyst) April 2015 – Till Date

World Vision is a charity organization that focuses on underprivileged children predominantly in the third world countries.

This project was developed for installing cognos, migrating reports from analytics to cognos (BI 1.0) and integrating TM1 cubes with cognos cubes (BI 2.0). In parallel to this, new reports and dashboards were created to providing the information for key business areas. Microsoft SSIS was used for the extraction, transformations and loading of the various data to the centralized warehouse, MSSQL as the database and Cognos 10.2 for creating and managing reports.

Other Duties include:

Worked on Cognos 10.2 (From requirement gathering to deployment), MSSQL Data warehouse, Framework Manager, and JavaScript. Also led a team of 3 for executing reports as well as working on ADHOC reports, Technical Design and High Level Stakeholder Management.

Developed various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.

Migrated reports from Analytics to Cognos 10.2.

Developed models in framework manager

Automated daily sales reporting process by migrating 50+ reports from a manual process in Analytics to a more robust streamlined and secured Report net platform.

Interacted with clients to understand the reporting needs, evaluated requirements, designed, developed and implemented reporting deliverables using Power Play Cubes and Report net reports. Provided ad-hoc reporting support.

Migrated Cognos Cubes and Report net reports from an internal database system to an outsourced system. Researched and identified required report elements and gaps against new data sources.

Optimized Impromptu queries and cube build queries and provided strategies at the database level and Cognos reporting tool level to improve performance.

Designed and developed Database models using DB Designer.

Identified problems and limitation with current Cognos environment, addressed technical issues, applied hot fixes.

Administered Cognos environment including Report net, Enterprise Server, and Access Manager.

Provided 24/7 remote on-call operational support for the reporting application. Resolved production outages. Assisted and supported other applications for which the group is responsible for.

Cognos Administration, Installation, Troubleshooting errors and maintaining websitesUsed Active Directory to define Users, Groups and Roles and providing the single sign on option for the users.

Created procedures, wrote shell/batch scripts, created production control documents and scheduled jobs in enterprise automation software.

Provided user training on Report net reports and Power play cubes.

Led team meetings, providing status and defining go-forward approach based on achievable results.

Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.

Improved the performance of the reports

Environment: Cognos 10.2(Framework Manager, Report Studio, Business insight, Query Studio, Business Insight Advanced, Analysis Studio) Windows 7 AND 10, DB2 Database, Report Administration, Access ManagerISS, OD.

LLTCorp Mississauga (BI /Report Developer) Nov 2010 – April 2015

LLTC is a Business intelligence consultancy firm. Developed reports for different sectors including: Ministries, Manufacturing, Health, Banking and Financial. Also developed models, performed business analysis and developed reports (Including dashboards and scorecards). Projects worked on include: Call center performance reports, End of year reports, Credit Information Systems: This reporting system developed for a major financial company, to keep track of customers and their credit information.

Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.

Generated Complex reports in Cognos 10.1 report studio including Drill Down reports from DMR modeled Frame work model.

Performed Database tuning for performance.

Updated Framework Manager Model based on the requirements (creating aliases, relationships, shortcuts, calculations, filters, packages, importing metadata, database functions, etc

Designed Dimensional Data modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, and Physical & Logical data modeling, and defining relationships and cardinality between Query subjects.

Created multidimensional models (DMR) and published packages using framework manager and then generated reports from these packages. Developed dashboards with list, charts, and crosstab. Created ad hoc reports using Query studio based on requirements.

Used scripting techniques to achieve those that are not straight out of the Cognos box.

Extensively used Transformer to move relative Data Mart’s data into Power-Cubes and cube groups by designing Dimensional Maps and Transformer Model to perform On-Line analytical processing (OLAP). Created reports (in Report Studio) using Cube sources and Created Portal tabs based on the requirements.

Writing database procedures, functions and triggers.

Assisting developers with database activities.

Tuning of database queries for forms and reports.

Created Dashboards to present critical company data in a single report.

Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio

Deployed Reports, Packages and Folders from DEV to UAT and from UAT to PROD Environments. Implemented security for reports and packages.

Experience in developing Framework Manager Models and analyzed those models in analysis studio.

Gathered and analyzed business requirements from users and business community.

Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirement

Created Sophisticated Reports using Report Studio.

Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.

Vodacom Telecommunications, Johannesburg, South Africa (COGNOS Analyst) Aug. 2009 – Sept 2010

Conducted multiple interviews with business users to identify and define business scope, business information requirements.

Conducted multiple dashboard and scorecard workshops with users using Microsoft-Excel.

Analyzed reporting and ad-hoc analysis requirements and identified gaps.

Designed and developed Meta-data structure used in IBM Cognos 8.4.

Created and designed Dashboards, using Report Studio features and components such as (conditional blocks, Master-detailed relationships, cascading prompts, cross-tabs, charts, Table-of-Content, Multi-page reports, Drill-Through functionalities amongst others).

Trained Business and Technical Users

Used SAS for Analytics

Did performance tuning to enhance performance.

Developed and provided BI, Cognos and DW best practices.

Coordinated UAT (User Acceptance Testing) with business.

Defined and implement system integration tests.

Created supporting documentation of reports and data models for new and existing projects.

Create data mapping for Supplier Relation data mart.

Recommend option on BI solution strategy such as Administration, Security etc.

Baker Tilly (Tableau Reporter) May 2006 to July 2009

Roles and Responsibility:

Developed Scorecards and dashboards for decision making.

Analyzed data from diverse collection points dispersed among a dozen internal systems.

Helped decision makers to easily discover, track and assess trends such as an increase in the average length of sales or changed mind resulting in loss of customer utilization rates which eventually facilitated quicker operational adjustments to address them.

Conducted multiple interviews and JAD-sessions with business users to identify and define business scope, business information requirements.

HR Dashboard which provides dashboard analysis and reports for Employees.

Executive KPI Dashboard which provide dashboard analysis and reports for Monthly KPI’s of the Performance and defaults.

Inventory Dashboard which provides dashboard analysis and reports for Stock for various technologies.

Created data models, dashboards and reports in charts for Dashboard, performed System Integration Test, User Acceptance Test and moved to production environment.

Configured expressions and implemented business logic using set analysis.

Implemented the Security for application based on user roles.

Extracted the data from Relational Database, Flat Files and Loaded into the target Data warehouse.

EDUCATION

Babcock University, BSc Computer Information Systems, 2006

Oxford Brookes University, Masters in Computer Science, 2008

PROFESSIONAL CERTIFICATION

Microsoft Certified Solutions Associate MCSA – Windows Server 2012

SPECIAL SKILLS

Ability to communicate effectively with confidence and motivation. Ability to build relationships with the team and across other departments.

Excellent writing and oral skills.

Flexibility and innovative.

Enthusiastic, knowledge-hungry self-starter, eager to meet challenges and quickly assimilate newest and latest technologies, skills, concepts, and ideas.

Highly motivated with a desire to work hard and achieve high standards.

Ability to cope with change and adaptable to new situations.

Quick thinker and learner with the ability to multi-task.

REFERENCES

Available on request

Contact this candidate