Manager Data

Ozjan Bakir

Address: *** ***** ***, *******, ** 07508

Phone: 973-***-**** Email: *******@*****.***

Core Technology Skills

Cognos (Cognos 7- 10, ReportNet, Access (DB design), SAP SD, Business

Framework Manager, Transformer, Report Objects, PeopleSoft, Excel (pivot tables,

Studio, Query Studio, Analysis Studio) vlookups, macros)

Oracle 11g/10g/9i PLSQL, SQL Developer, Star and Snowflake model design

Oracle SQL*Plus, SQL Server Databases Strong project management and task

scheduling skills driven by excellent

Relational and Dimensional Data Warehouse

design methods requirements gathering abilities

Data Flow Diagrams, Wire Framing, Entity Installed C8.x-C10.x platform

Relationship Diagrams (MS Visio, Project)

Professional Experience

Johnson and Johnson Healthcare Systems – Supply Chain

Skillman/Piscataway, NJ 11-14 to Present

Business Analyst III

Interacted with business owners gathering information for the development of User Requirement Specifications

Developed Functional Requirement Specifications for 6 complex Line Item Fill Rate and Customer Focus reports

Developed data flow diagrams and entity relationship diagrams based on new model specification designs

Tested data integrity of set of initial reports in Cognos with Oracle SQL Developer with multiple sets of criteria

Wrote initial Business Case for Cognos implementation, GAP analysis, Priority matrix, and RACI matrix

Performed extensive detailed root cause analysis and wrote 8 page document detailing micro and macro issues

Managed 4 offshore technical resources for reverse engineering Access dbs and developing cube requirements

Developed source to target mapping documentation to supplement existing reporting logic to provide ETL team

Engaged in system testing, monitored, and UAT; documenting processes and results for first phase of reports

United States Dept. of Energy

DC Metro Area 2-14 to 4-14

Senior Software Engineer/Business Analyst

Lead meetings with business owners for user requirements to define functional requirement specification

Interviewed over 50 candidates for various BI/DW roles for upcoming dashboard reporting implementation

Ran meetings to sell client on additional work to be done for maintenance new dashboard and report suite

Created technical design specification and modeled operational cubes for dimensional reporting via Transformer

Documented step by step Dashboard usage with SOPs for user community and published on DOE intranet

Project lead on client reporting initiatives, wrote business and use cases for anything Cognos related

Lead several root cause analysis meetings with technical business owners regarding dashboard data integrity

Host Hotels and Resorts

Bethesda, MD 1-13 to 7-13

Senior Cognos Developer/Business Analyst

Screened, interviewed, and recommended prospective contractors for upcoming full Data Warehouse rebuild

Created functional requirement specifications after a series of meetings and client personnel interviews

Developed GAP analysis documentation focusing on all of BI departments technology and business processes

FM/Transformer model/cube development, Data Source creation, SSIS package creation, data transformation

Create new star schema data architecture for Food and Beverage data from ETL to presentational reporting

Field, prioritize, delegate and address all technical user issues arising from anything Cognos related

Involved in all aspects of development in Cognos 10, Transformer, Impromptu, and SQL Server

United States Dept. of Defense – Navy, Office of Civilian Human Resources

DC Metro Area 9-11 to 1-13

Senior Consulting Software Engineer- Data

Project Management, development, and documentation of all aspects of Enterprise OLAP data projects

Led Meetings to present case for additional billable hours needed for upkeep for new Dashboard reports

Technical lead on multi-tab HR Dashboard for Civilian military branch driven by Transformer cubes

Screened and interviewed over 20 candidates and was key decision maker for new developer positions

Redesigned 60% of Cognos 8.4 reports originally based on poor relational packages to being cube driven

Created Business Process Flow and Entity Relationship Diagram documentation outlining dashboard project

Lead interactive demo presentations, trained key executives, and regional personnel on Dashboard usage

Analysis and testing of existing model’s stored procedures and join architecture to improve performance

Integration of Metrics Department inefficient analytic methods into C8.4 via conditional formatted reporting

Lead on development and testing of migration of all SQL and Impromptu reports to C8.4 and C10 upgrade

United States Dept. of Justice – Executive Office of Immigration

Falls Church, VA 9-10 to 9-11

Senior Enterprise Data Architect

Designed and developed Metadata Models for Trouble Ticket Tracking and agency wide Court Case application

Played role of Project Manager and Relationship Manager for BI solutions, the prime contractor, and DOJ

Creation, maintenance, and testing DB, Business, and Presentation layers in FM as well as developing data item

calculations, measures, alias tables, dimensions, publishing packages, and security group/role administration

Alter and test table relationship cardinalities from original database import to efficiently suit reporting needs

Transformer model/power cube design, testing, and development off list report or package data sources

Batch script development, testing, and maintenance for automated nightly, weekly, and monthly cube builds

Development, scheduling, and bursting of simple to complex reports using all report studio capabilities including

drill through/up/down, crosstabs, bookmarks, nested objects, variables, complex case/if-then statements, data

item calculations, master detail relationships, in report joins/unions, and HTML/JavaScript integration

Migration, new development, testing, and documentation of Impromptu and Crystal reports to Cognos 8.4

Lead meetings for direct user/business requirements gathering, visioning, presentation, and training with

Government personnel to increase user competence for usage of Agency CIO Dashboard reporting suite

AIG (Chartis) and Millennium Pharmaceuticals

Boston, MA 6-08 to 03-10

Business Analyst - Business Intelligence Consultant - Chartis Insurance and Millennium Pharmaceuticals

Developed functional requirements for P&C metrics reporting initiative based on JAD sessions and GAP analysis

Developed and maintained monthly, quarterly, and annual casualty insurance reports via Cognos 8.3

Interviewed candidates for numerous technical roles from which 90% were hired from recommendation

Recreation of 38 advanced calculation, prompt, and conditional intensive C8 reports against new model

Fulfilled client ad hoc reporting requests based on assessed business requirements for Insurance Claims data

Developed reports with in report join and union logic for emergency client needs within Report Studio

Continual modification, testing, and creation of C7 catalogs for new claims, risk, and litigation reporting projects

Integration of complex SQL logic into Framework Manager and development of stored procedures

Automated and scheduled recurring reports by creating Cognos script based macros eliminating manual tasks

Booz Allen Hamilton

Parsippany, NJ 3-07 to 05-08

Data Systems Analyst – Cognos Reporting Team

Designer and Technical lead (Modeler and RS Developer) for ‘Expense Online’ reporting suite project

Reporting development and maintenance in Framework Manager, Cognos 8.2, ReportNet, and Impromptu

Model modification and package publishing for relational model via Framework Manager; content store purging

Continuous ad hoc testing, analysis, and report creation utilizing PL/SQL and SQL*Plus to meet business goals

Solved global business user field problems regarding all firm wide reports from all division across the company

Migration and testing for data integrity in Development, QA, and Production environments within Cognos 8.2

Constant consultation with DW team for reporting inefficiencies, execution plan testing, Oracle patch upgrades,

business requirements, functional requirements, technical design and overnight processes

The Hertz Equipment Rental Corporation

Park Ridge, NJ 7-04 to 3-07

Operations Reporting Analyst

Report development, testing, maintenance, and modeling with ReportNet and Impromptu for all of user needs

Reporting of financial and operational statistics to CEO, VP of Operations, and Director of Fleet Planning

Financial/Quantitative analyses to develop yearly budget and statistical regression analysis for all regions

Variance, ROI, P&L, and Statistical analysis implementing cost structure a cost structure reduction system

Automated regional/divisional Fleet Operations conditionally based metrics reporting via Cognos ReportNet

Recommended to changes to existing plan based on ongoing forecasts and event based impromptu reporting

Education/Certifications

IBM Certified Administrator – Cognos 10 BI 10-11

Rider University, Trenton, NJ 12-03

BS in Business Administration, Major: Finance, Minor: Mathematics

Contact this candidate