Download
Download Resume.doc

Shaz Charles Gagan
 For Innovative & Customized BI Solutions


Download

Profile

Mobile

A proven professional with Cognos BI expertise in the area of design and development of BI reports, analytics, dashboarding and Analytics  implementing solutions with consulting firms such as IBM and Accenture.​


​Experience working as a BI Specialist with the following.

  • Cognos BI (7.x, 8.x, 10.x, 11.x) & some Tableau Desktop v9.x, Cognos Framework Manager metadata models
  • BIG Data Hadoop (HDFS & Map Reduce), HBase, Hive, Sqoop and Spark
  • Query against Oracle and SQL Server databases
  • Expertise in managing both internal & external stakeholders' expectations
  • Comfortable with facilitation and presentation skills using effective communication style, tools and techniques.
  • Big proponent of agile development methodologies throughout System Development Life Cycle


Please click and review my project details by clicking the 'CV Project Details' button above. Scrolling down will provide details such as clients' name, location, roles played, project duration, BI technologies used and other pertinent information.

916.474.1986


Shaz Charles Gagan
www.shaz4cognos.com

Seeking a lead Cognos Business Intelligence position where deep expertise in Cognos BI skills in the area of data warehousing, ETL and Analytics will be leveraged in order to provide innovative solutions to business challenges and gaining client trust.

PROFILE

Deep back ground with an experience of about fourteen years working within the Information Management and BI professional space holding various positions and roles such as Managing Consultant, Senior Consultant, Project Manager, Enterprise & Information Architect, Lead Technical & Business Analyst and Lead BI Developer through software development life cycle.
Project exposure includes overall Planning, Analysis, Design, Development and Implementation of BI Analytics layers including data warehousing and ETL solutions across different enterprise platforms resolving issues for Fortune 100 clients and representing consulting firms such as IBM, Accenture and other prestigious firms in many geographic regions across the globe. 
Implemented solutions across a variety of industries including Financial Services & Banking, Insurance, Biomedical, Pharmaceutical, Manufacturing, Entertainment, Media and HR/Payroll among others.

CORE BI QUALIFICATIONS

•        Extensive experience in design and development of BI & Analytics Solutions leading a group of onshore, near shore and off shore resources, managing stakeholders expectations, integrating BI solutions within Enterprise Data Warehouse, resolving business & technical challenges, administration, communication and collaboration with technical and functional staff members through software development life cycle around datawarehousing, reporting & analytics solutions.

•        Hands On expertise in developing Cognos reports (v7.x, v8.x and v10.x), Interactive Dashboards, Transformer Cubes and other BI components including Tableau modeling and dashboard against tableau workbook, administration tasks such as creating data sources via Cognos Connections, security and other BI components such as conditional based alerts and notifications.

•        Ground up experience in the design and development of Cognos Framework Manager Models against relational data sources such as Oracle,  SQL Server and  multi-dimensional data sources (SAP Info Cube) leveraging BI best practice, standards and methodologies.
 

•        Skilled in identifying, analyzing and gathering functional requirements and transforming them into technical requirements including decomposing complex technical requirements into easy to understand sub components. Also, capable of distinguishing enhancement vs needs, requirements vs solutions and skilled in implementing requirements change management within the SDLC.

•        Conditioned and comfortable with implementing best practices, methodologies and standards in BI application development.

•        Deep knowledge and experience with inner working of Enterprise Datawarehouse and associated data marts, silo data marts, Star Schema vs. Snowflake Schema, Normalized vs. Denormalized database design, ETL toolsets and performance management technologies, Big Data Apache Hadoop, MapReduce and Hadoop Distributed File System (HDFS) Framework.     

•        Solid SQL skills against relational databases such as Oracle 11g/10g/9i, Netezza, Teradata, and SQL Server 2000/2005 utilizing PL/SQL developer, Toad, Query Analyzer, and Enterprise Manager.

•        Deep experience in executing Proof of Concepts projects, communicating road maps and helping clients design and transform their ‘As-Is’ into ‘To-Be’ reporting platforms and system architectures.


LEADERSHIP & SOFT SKILLS 

•      Focused on building and strengthening client relationships and gaining trust by providing innovative solutions leading to increased business development.

•      Initiated, drafted, finalized, presented and obtained approval of the strategic and tactical roadmap of departmental BI and Analytics for all refineries within continental United States, Canada and South Africa.

•      Experienced with identifying business issues and challenges faced by clients and helping them through innovative industry insight and data driven solutions.

•      Aligned with market innovation, data trending and the art of transforming complex issue into easy to understand materials during client meetings, SOW and proposal (RFP/RFI) processes.

•      Strong insight into understanding business and system needs, assess skills set requirements and staff projects accordingly. Develop and maintain project issues, project scope, project timelines and project work plans.

•      Strong business acumen, competent working with diversified team members and clients across the globe, client focused, effective communication, problem solving & trouble shooting, and on-time quality deliverables.


CAREER SUMMARIZED HISTORY

Chevron, San Ramon CA, US                    11/2013 – Current
Lead Cognos BI 

•        Overall responsible for the implementation of Cognos BI functional excellence framework within Downstream and Chemicals and all refineries across the globe. This included Cognos v10.x and Cognos v11.x artifacts such as standards reports & dashboards, analytics, OLAP cubes and other BI components against Oracle 11g database, DataStage ETL and sourced from SAP, Ariba, Meridium and Maximo UI application infrastructure platform.

•        Responsibility included but not limited to support and maintenance of Enterprise Cognos BI reporting and Analytics infrastructure related to refinery equipment and assets in all refineries supporting approximately 2500 end users across the globe. 

•        Assisted team members with coaching as well as occasional hands on edits and tweaks with design and development of new reports, edits to Cognos Framework Manager Model, packages, dashboards, ERWIN models, scheduling and conditional notification of other BI artifacts.

•        Managed a team of onshore and offshore BI developers, architects, programmers, ETL developers, business and technical analysts in delivering enterprise level Cognos BI solutions to challenging issue with a goal of managing user expectations.

•        Built a network of Cognos BI skilled resources and trusted business partners by taking the initiatives and building relationships not only on professional level but also on a personal level resulting in the development of high performing team in Mexico, India and Philippines data centers.

•        Recognized and rewarded for identifying anomalies from audit reports around third party licensing cost and user roles. This resulted in cost saving measures and an overall savings of over $96K within the IT OPS business unit.

•        Collaborated and managed key stakeholders’ expectations in the design, development and implementation of an upgrade project which involved replacing legacy RIMS (Reliability Information Management Systems) application with a modernized and upgraded Mark Logic application designed for Big Data solutions.

•        Initiated and made contributions to new processes with reference to ticket management, change management, change control and transparency of incidents with key stakeholders through the incident management life cycle.

 
IBM, San Francisco CA, US                    03/2010 – 10/2013   
Management Consultant

•      Assigned to multiple BI related projects as a Management Consultant to provide innovative solutions to clients such as Bank of New York Mellon, County of Los Angeles, Bank of America, General Motors, and IBM Blue Harmony. 

•      Responsibilities include demonstrating leadership in the design and hands on development of Cognos Business Intelligence reporting platforms as a Lead BI Architect, Lead Solution Architect, Lead Metadata Model and Report developer through planning, design, development, deployment, & testing phases of the BI project life cycle. Please see details below.

•      Experience also includes managing BI developers, project updates and status call, actively participating in Thought Leadership sessions, transforming complex technical concepts into easy to understand facts and, integrating them into professional Power Point templates and presenting them to the audience.


KAISER PERMANENTE (W2 Contractor), Pleasanton CA, US                    01/2010 - 03/2010
Project Manager

•      Responsible for project execution and monitor/control segments of the project management process.

•      Managed and defined the Scope Management which comprised of Product Scope along with Project Scope.

•      Created a list of deliverables and WBS which helped in creating project plan & timelines, estimates, activity list and risk assessment.

•      Assisted architects and developers in the design and development of Cognos FM metadata modeller and assorted cross tab reports through System Development Life Cycle process.

•      Led and facilitated the requirements gathering process with the client team members, resolving issues with project challenges and constraints, facilitated daily status meetings to assess/mitigate risks (if applicable) with team members.



ACCENTURE, San Francisco CA, US                    03/2007 - 12/2009
Senior BI Consultant

•      Assigned to multiple BI related projects as a Senior BI Consultant and assisting clients with gathering requirements, design and development of Cognos BI deliverables according to specifications, deployment and testing of assigned deliverables such as FM metadata models, dashboards & reports, report distribution & notifications, Cognos Admin duties, enterprise reporting portal design and development, among others. 

•      Experience also included updating project status & updates, conducting status call meetings by working with fellow team members, training, troubleshooting BI challenges and issues within allocated project timelines.

•      Assigned to Cognos BI projects with clients such as Disney (Burbank, CA.), Boston Scientific (Natick, MA.), Solar Turbines (San Diego, CA.) and Genzyme (Cambridge, MA.)


INFORTE CONSULTING, Chicago IL, US                    09/2005 - 03/2007
BI Consultant

•      Worked as a BI Consultant in the area of Cognos BI Implementation and Data Integration projects as a Cognos application developer.

•      Responsibilities included developing Cross tab, List reports and Dashboard reports including Cognos Admin duties such as apply patches, deploy and migrate from one environment to another, identify and resolving report performance issues, start/stop Cognos Application and Dispatcher services,

•      Gained experience working on multiple different BI related projects with clients such as AON (Chicago, IL), State Street Global Advisors (Boston, MA.) and Estee Lauder (Manhattan, NY).


HEWITT ASSOCIATES, Chicago IL, US                    03/2002 - 09/2005
Senior Support Specialist

Gained experience with Cognos Business Intelligence suite and learning to identifying and troubleshooting skills working as a BI support specialist. Introduced to Cognos version 7.x and Cognos version 8.x. Responsibility included assisting internal clients and few external clients with Cognos Impromptu Reports, Cognos 7.x Catalogs, and Multi-dimensional Transformer Cubes. 


IBM PROJECT DETAILS 

BANK OF NEW YORK MELLON
10/2012 - 10/2013 (Role: Lead BA & Solution Architect in Manhattan NY.)

•      Managed 3 onshore resources with the design of Oracle 11g data model, designed & development of Cognos Multidimensional Metadata Model and approximately 125 Cognos reports (medium to highly complex reports).

•      Initial responsibility included input to the project plan, screening and interviewing resources to join the team and gathering requirements on a high level from the client team members.

•      Designed and presented a solution outline and architecture Power Point Template based upon the high level requirements.
I
•      Conducted multiple work sessions for each business domain and presented a solution outline based upon gathered requiremen
ts with reference to end to end business intelligence solution.

•      Made major decisions with reference to Business Intelligence design roadmap in close collaboration with support from SMEs and Project Management.

•      Managed to architected and obtain prompt approval from the client for a conceptual BI solution design comprised of Cognos 10.2 BI application suite, reporting datamart designed in Star/Snowflake schema against Oracle 10g relational data store, Informatica ETL toolset extracting data from existing datasources such as PeopleSoft and others.

•      Actively participated in all requirements gathering workshops with reference to data architecture and data design of a reporting datamart, business rules, and calculations including Cognos Framework Metadata Model.

•      Collaborated and participated in discussions with infrastructure team members with reference to installation, configuration, server sizing particularly around Cognos Dynamic Cubes.

•      Created test plans, designed and developed an initial 3-layered Cognos DMR Framework Manager Metadata Model.

•      Designed and developed complex FIAS (Finance Integrated Allocation Solution) and CPE (Customer Profitability Engine) reports.

•      Setup the Lotus Notes portal to upload documents to an internal data repository for ease of sharing documents and collaboration.

•      Created an account with IBM Cognos support, assisted developers with opening new PMRs by reporting bugs and getting resolutions during model and report development processes.

•      Assisted client contacts with ad-hoc reporting model, report development and getting acclimated to the new BI environment.

•      Actively participated and assisted project manager in all major meetings including weekly status meetings, communicating progress of the project with the client, raising issues and concerns and other pertinent communication.


COUNTY OF LOS ANGELES
05/2012 - 10/2012 (Role: Cognos Dashboard developer in Los Angeles, CA.)

•      Assigned as a Lead BI Information Architect, Cognos Framework Manager Modeller, and Report Developer for a Proof of Concept Project.

•      Assisted the Business Analyst with the transformation of functional requirements of dashboards into mock-up of charts, graphs and reports using Excel visualization. The Excel mock-up provided a prototype and visualization of dashboards and reports and gain client's confidence before creation of the actual Cognos reports.

•      Successfully transformed all functional specifications into technical requirements

•      Responsibility included design and development of Framework Manager model v10 against disparate source systems. Imported relational tables from Orbit Lite datamart and completed metadata modelling in Cognos Framework Manager by defining relationship and cardinalities between tables based upon requirements gathered from the client.

•      Accomplished design and development of dashboards and KPI reports (medium to complex) using Cognos version 10.1 with conditional formatting and report level data aggregation. 

•      Thoroughly conducted User Testing and assisted with User Acceptance Testing, data validation and integrity. 

•      Applied package level security for all Clusters and Departments.

BANK OF AMERICA
01/2012 - 04/2012 (Role: Business Analyst in Charlotte, NC.)

•      Managed and gathered functional and technical requirements, designed and developed Cognos FM Relational Metadata Model, and thirteen reports.

•      Responsibility included design and development of Framework Manager model version 10.1.0 against an OLTP database (Oracle 10g). Imported relational tables from datamart and modelled approximately 48 tables, including building and configuring relationships and cardinalities between tables based upon requirements gathered from the client.

•      Accomplished design and development of 12 reports (medium to complex) using Cognos version 10.1 with conditional formatting and customized filters. 

•      Thoroughly conducted user testing, data validation and data integrity.  

•      Successfully managed to demo the model and reports to the client team and managed to receive positive feedback and reviews from the client team.


GENERAL MOTORS
01/2011 - 12/2011 (Role: Lead Report Developer in Detroit MI.)

•      Led 4 onshore and 2 offshore developers with the migration, design and development of over 130 reports.

•      Created a Cognos 8 centralized reporting environment for easy access by power/ad-hoc users.

•      Upgraded from Cognos 7.3 to Cognos 8.4 Business Intelligence reporting application.

•      Analyzed, consolidate and reduce the number of standardized and ad hoc reports.

•      Responsible for gathering or clarifying report requirements and accepting complete ownership of report delivery.

•      Designed and developed 30 plus complex reports using Report Studio and responsible for their performances, data integrity and unit testing.

•      Invoked edits to Cognos Framework Manager Models around Transactional, Standalone and Month End reports.

•      Re-designed and transformed all legacy Impromptu reports to Cognos 8 reports.

•      UAT and data validation of newly created Cognos 8 reports.


BANK OF AMERICA
10/2010 - 01/2011 (Proof of Concept in Charlotte, NC.)

•      Project Scope involved evaluation of client’s existing BI infrastructure, identify gaps and provide a comprehensive assessment and a road map from ‘As-Is’ to ‘To-Be’ state with reference to Operational Risk and Control.

•      Assigned as a lead solution architect with an in depth knowledge and experience of Cognos BI toolset to understand the business and suggest reporting solutions.

•      Primary responsibilities included detailed analysis of existing business intelligence environment and provide innovative solution to their reporting needs and wants.

•      Executed the initial Assessment and Proof of Concept project which led to a full blown Enterprise Level implementation of Cognos Business Intelligence reporting environment.

•      Hands on involvement in the design and development of Cognos portal, dashboard, scorecard and reports.

•      Managed a group of client based IT team in the design and development of Cognos dashboard, scorecard, reports and portal.

•      Accomplished completion the assessment and proof of concept deliverables within budget and allocated time frame.


IBM BLUE HARMONY
05/2010 - 07/2010 (Role: Business Analyst for TM1 project in Southbury, CT.)

•      Initial responsibility included design and development of a TM1 Cube.

•      Participated in strategic sessions to define the unique architecture of Cognos TM1 Cube against SAP Info Cube.

•      Collaborated with the business and process team members for clarifications in the functional requirements to build the cube.

•      Transformed business and functional requirements into technical design document including all mappings to SAP Info Cube.

•      Created data dictionary containing SAP objects, dimensions, data sources, data types etc.

•      Designed the TM1 Cube with required data elements, facts and dimensions contained in the proposed requirements.

•      Developed comprehensive mappings for all required data elements including TM1 reports.


ACCENTURE PROJECT DETAILS 

WALT DISNEY 
06/2009 - 12/2009 (Role: Cognos Dashboard developer in Burbank, CA.)
Core Technologies Used
Cognos 8.3 (Report Studio), Cognos Metric Studio 8.3, Cognos Framework Manager 8.3, SAP NetWeaver 7.0

BOSTON SCIENTIFIC 
01/2009 - 06/2009 (Role: Cognos Report developer in Natick, MA.)
Core Technologies Used
SAP BW, Cognos 8.4 (Report Studio, Query Studio) Cognos 7 Transformer, Cubes, & Power Play client, Cognos Framework Manager 8.4, SQL Server 2005, Clear Case, SQL DTS Packages

SOLAR TURBINE                                 
01/2008 - 12/2008 (Role: Cognos FM Model & report developer in San Diego, CA.)
Core Technologies Used
Cognos 8.3 SP1 (Report Studio, Query Studio, Event Studio, and Analysis Studio) Oracle 10g (10.2.1), Informatica 7.0, Cognos Framework Manager 8.3 with IBM Websphere 6.0/HTTP Server on a Window 2003 (SP2) platform

BOSTON SCIENTIFIC 
07/2007 - 12/2007 (Role: Cognos SME in Shoreview, MN.)
Core Technologies Used
8.1.1 MR1 (Report Studio, Query Studio) Oracle 10g, Informatica 7.0, & Framework Manager 8.0

GENZYME BIOSURGERY
03/2007 – 7/2007(Role: Cognos Report developer in Cambridge, MA) 
Core Technologies Used
8.1.2 (Report Studio) Oracle 10g, Informatica 7.0, & Framework Manager 8.0
                                

INFORTE PROJECT DETAILS 
Aon (Chicago, IL)
09/2006 - 03/2007 (Role: Consultant Developer)
Core Technologies Used
Composite (CIS) 3.7, Composite Studio (Modeler UI and Manager), Cognos 8.1.2 (Report Studio, Analysis Studio, Query Studio and Event Studio), Framework Manager 8.0, Salesforce.com, Composite Studio 3.7 & Oracle 9i

State Street Global Advisors (Boston, MA)
01/2006 - 08/2006 (Role: Consultant Developer)
Core Technologies Used
Cognos 8.0 (Report Studio, Analysis Studio, Query Studio and Event Studio), Cognos Transformer v7.3, Framework Manager 8.0, MS SQL Server 2000

Estee Lauder (Manhattan, NY)
09/2005 - 12/2005 (Role: Consultant Developer)
Core Technologies Used
Oracle Administrator, Oracle Discoverer, Discoverer Plus and Oracle Desktop, Oracle 9i, SQL Plus and PL/SQL Developer.



HEWITT ASSOCIATES DETAILS


HEWITT ASSOCIATES                                                                            Nov 2003 – Sept 2005   
Cognos Support Specialist
Chicago, IL 60601

HEWITT ASSOCIATES                                                         Mar 2002 – Nov 2003   
Client Support Specialist
Lincolnshire, IL 60069


TRAINING HISTORY

• Mark Logic Database/Search Engine         (Jan 2016)
• Administering Mark Logic Server                 (Dec 2015)   
• HDFS Map Reduce, Pig, Hive                         (Jun 2015)
• Tableau Desktop v9.1                                         (Jan 2016)
• BIG Data and Hadoop                                        (May 2014)
• E2E, Experience to Expert Consultant      (Jan 2012)
• Project Management for GBS                        (Aug 2011)
• Cognos TM1 Training                                         (Apr 2010)
• Cognos Metric Studio Training                     (Sep 2008)
• Partner Certified Cognos v8.1                      (May 2006)
• Partner Certified Reportnet v1.3                (Jun 2006)
• SAP BW                                                                     (Aug 2005)

FORMAL EDUCATION
Bachelors in Business Administration.          (12/2002)
Northern Illinois University, DeKalb IL. 

AAS in Computer Information Systems         (06/1999)
William Rainey Harper College, Palatine IL.
Certification in C/C++