Business Intelligence Data Analyst

Hakan Ogmen

Senior Data & Analytics Consultant

>20+ years of experience in Business Intelligence

Profile

Hakan "Hank" Ogmen is a seasoned BI Lead/Manager with over 22 years of experience in Cognos BI and other applications. He holds a Bachelor of Science in Computer Science from McNeese State University. He excels in Business Intelligence including OLAP/BI tools such as IBM Cognos Suite, Power BI, and Tableau. Hakan’s extensive work experience includes leading teams, interacting with business users, developing reports, and managing BI steering and assessment groups. Hank has successfully overseen global data warehouse teams, ETL processes, and the implementation of Business Intelligence in multiple facilities worldwide. He has led and overseen multiple reporting migration projects that consisted of moving from one platform to another. His skills encompass report authoring, dashboards, security implementation, and Cube model development. Hank's career highlights include training over 2000 users, troubleshooting report performance, and managing BI projects during Oracle and Cognos implementation. He brings a wealth of expertise in BI suite administration, ETL processes, and developing and maintaining global reporting applications. Hank is a proactive problem-solver with a robust technical skill set and a proven track record in BI development and management roles.

CGI + Momentum experience

JMFamily, Team Lead (01/24 – Present)

Leading Senior Consultant on a team of 15 developers and data modelers using MS Power BI.

Served as Technical Lead and oversaw report development life cycle.

Developer/architect to design and build semantic models

Design and develop advanced dashboards and reports using Power BI, and SSRS

Analyze data to identify trends, patterns, and insights that can inform business decisions

Present data findings to stakeholders in a clear and actionable manner

Collaborate with business analysts and stakeholders to gather and understand business requirements

Provide technical guidance and support to the BI team

Implement best practices for data modeling, data governance, and data security

Communicate project updates, changes, and requirements to all team members

Implement new data analysis programs and methodologies

UKG, Senior Consultant (10/21 – 12/23)

Leading Senior Consultant on a team of 8 developers and data modelers using IBM Cognos Analytics.

Interaction with business users to gather requirements and design functional and technical requirements documentation.

Served as Technical Lead and oversaw report development life cycle.

Assisted internal UKG Teams with migrating reports from legacy backend to newer platform.

Developed List, Cross tab, Chart reports using Cognos functionalities like Conditional Formatting and set operations like union and joins in report Studio.

National Oilwell Varco, Cognos BI Manager (11/11 – 10/21)

Leading BI Steering & Assessment Group. Working with Core Team of the facilities going thru Oracle conversation. Standardizing and customizing reporting needs.

Lead team to migrate over 150 OBIEE Reports to IBM Cognos. This included the whole project lifecycle of business meetings, requirements gathering, report consolidation, and user testing and acceptance.

Creating documentation and training the Business users on newly built IBM Cognos Reports which consisted of “how to” documents and best practices of reporting.

Leading the Global Data Warehouse Team. Nightly ETL processes, Dashboards, and global reporting.

Leading on Modeling using framework manager to import metadata from multiple data sources and to create subject matter models, create and publish packages.

Leading Global BI Developers reports and dashboards using Report Studio and Tableau

Managing and overseeing the implementation of Business Intelligence to 23 facilities during the Oracle implementation. (Netherlands, Denmark, France, Brazil, Mexico, Orange, Cedar Park, Covington, Galena Park, Norway, UK, Russia)

Lead technical row for BI strategies and solutions.

Lead Oracle/Cognos Steering Committee

Trained over 2000 users, from Cognos Fundamentals thru Advanced Reports Studio Development.

The Shaw Group, Senior Cognos BI Developer / Administrator (06/09 – 11/11)

Interaction with business users to gather business requirements and designed functional and technical requirements documentation.

Worked on framework manager to import metadata from multiple data sources and to create subject matter models, create and publish packages.

Worked extensively on relationships between query subjects to better represent the logical structure of the business and the user requirements.

Used Framework Manager to externalize query subjects in order to generate IQD data sources for Powerplay cube creation in Powerplay Transformer.

Built and Published the Packages to Cognos Connection and Cognos 8 Server according to user requirements.

Experienced in creating different types of security in models using framework Manager.

Secure Cognos Connection by assigning user to the groups and roles defined in Cognos Namespace.

Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.

Worked on creating list reports, cross-tab reports and chart reports using multiple queries in a single report and by using filters, calculations, conditional highlighting

Used conditional formatting to achieve identical results in different formats like HTML, PDF and EXCEL.

Proficient in developing Business Intelligence dashboards comprising several lists, charts, and cross-tabs in a single page as well as multiple pages.

Involved in installation, configuration and upgrade of Cognos ReportNet to Cognos 8.3/8.4.

Worked on creating Prompts and Cascading Prompts Pages

Worked on summary reports and detail Reports, drill-thru reports. Created drill through reports and associated with the summary reports to get details. Validated report results with the source data and sanctioned the reports to production environment.

Created scorecards and metrics using Metric Studio.

Experienced in creating events using Event Studio.

Worked on scheduling and publishing the report to the Cognos Connection.

Deploying Reports and Packages from one environment to other environments.

Created users and giving authorizations to the system users depending on their roles

Developed Cube models using Powerplay Cognos 8.3 / Cognos 8.4 Transformer. Modified power cubes by adding new dimensions, levels and measures. Published cubes as packages to cognos connection using framework manager and published cubes directly from Cognos 8.3/cognos.8.4 Transformer using new publish functionality.

Extensively worked on scheduling Weekly, Monthly and Quarterly Cubes and Reports.

Developed standard Templates for various kinds of reports.

Worked on Cognos production tickets to meet business requirements.

Conducted Team Meetings Every week, assigned tasks to team members and updated the status in weekly Meetings.

Trained end users on Query Studio for Ad-hoc reporting

Acted as lead in troubleshooting Report performance problems

Prior experience

Senior Cognos BI Developer at Southwestern Energy Company (04/08 – 04/09)

Cognos BI at Synagro Technologies (01/03 – 03/08)

MIS Manager at Seagate Travel Group (06/00 – 12/03)

Senior Programmer/Analyst at Sonic Systems International (06/99 – 05/00)

Graduate Assistant at McNeese State University (09/95 – 05/97)

Education

Bachelor of Science in Computer Science, 1997

McNeese State University, Lake Charles, Louisiana

Skills summary

Operating Systems – Windows XP/2000/NT/98/95

Technical Skills – OLAP/BI Tools: Cognos 8/8.2/8.3/8.4/10.2 11 (Cognos Connection, Framework Manager, Report Studio, Query Studio and Metric Studio, Transformer 8.3/8.4, Administrator, Transformer), Tableau 9.2/ 9.3

Databases – Oracle /8i/9i/10G/11G, SQL Server 2000, MS Access

Contact this candidate