To stop window scrolling,  please bring the cursor to the scrolling window 

   

---

 

Shaz Gagan

Objectives

Seeking a lead BI position where deep Hands-On expertise in data warehousing and business intelligence skills will be used to provide innovative solutions to clients’ business challenges with a focus on gaining clients’ trust.

Professional Profile

10 years of extensive and deep Cognos Business Intelligence experience with job roles as a Managing Consultant, Project Manager, Lead Business Analyst, Lead Information Architect and Lead BI Developer through software development life cycle. Project exposure includes overall planning, analysis, design, development and implementation of Cognos BI and data warehousing solutions across different enterprise platforms. Business experience spans a number of industries including Financial Services, Insurance, Banking, Biomedical, Pharmaceutical, Manufacturing, and HR/Payroll among others.

 

Summary of Skills

Core BI Skills (hands-on)

·         Ten years of extensive hands-on experience with design, development and implementation of Cognos business intelligence and data warehousing solutions through system development life cycle.

·         Expert in design and development of Cognos Framework Manager models (Relational and DMR) against OLTP and OLAP databases using Cognos recommended methodologies.

·         Extensive hands-on experience with designing and developing numerous Cognos 7.x and 8.x List and Crosstab reports (ranging from medium to complex) against data sources such as Oracle 9i/10g/11g, Netezza, MS SQL Server 2000/2005, IBM DB2, Teradata and Composite (CIS) 3.7

·         Experienced with Cognos TM1 in designing TM1 Server, dimension and cubes, Turbo Integrator to perform actions, and developing worksheet reports.

·         Experienced with Metric Studio/Metric Designer in creating scorecards around KPIs, targets and threshold alerts.

·         Experienced implementing row level, package level, folder level and report level security access on an enterprise wide level by creating/mapping Cognos users, roles and groups security with LDAP (Active Directory) using Cognos Configuration.

·         Deep knowledge and experience with inner working of Enterprise Datawarehouse and associated data marts, silo data marts, Star Schema vs. Snowflake Schema, OLTP/Normalized vs. OLAP/Denormalized database design, data integration tools, ETL toolsets and performance management technologies.

·         Three years of cumulative experience facilitating and creating functional and technical specs for SAP BW workflows and processes.

·         Expert with Cube design and development, IQD and Transformer modeling and proficient with DMR (Dimensionally Modeled Relational).

·         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.

·         Proficient with Cognos 8.x installation and configuration such as configuration of Internet Information Services (MS IIS), Cognos content store and Cognos Configuration enabling single-sign-on with Active Directory (LDAP)

·         Advanced with MS Project 2007/2003, IBM Rational Clearcase, MS Office Suite, Visio, and MS Project.

·         Proficient with Microsoft Business Intelligence technologies such as Reporting Services and Visual Basic, Object Oriented Programming Languages such as C/C++ and Java 1.2, Java Applet, HTML/XML, JSP/ASP, MDX/MOLAP, SQL/ROLAP, VB Script, Salesforce.com, website design and development.

·         Advanced in networking skills including remote desktop connection, file transfer protocols, static/dynamic IPs, mapping workstations and servers, enterprise level server installations, networking in n-tier environments.

·         Skilled in identifying, analyzing and gathering functional requirements and transforming them into technical requirements.

·         Proven communication and interacting with both internal and externals clients across all levels including offshore team members.

·         Strong with creating detailed and formatted template documentation of business and technical requirements and its maintenance.

·         Willingness to learn and a strong focus on project deliverables and managing client team.      

·         Exposed extensively with Cloud Computing for Business Intelligence.

 

Leadership Skills

·         Focused on building and strengthening client relationship and gaining client trust leading to positive impact on business development.

·         Expert in identifying business issues and challenges faced by clients and helping them through data driven insight with their challenges and operations.

·         Experienced in design and implementation of business intelligence solutions transposing and exposing data into meaningful information and making an impact on clients’ bottom line.

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

·         Strong ability to understand business and system needs, assess skills set requirements and staff projects accordingly. Develop and maintain project issues, project scope, project plans and project work plans.

·         Experience with managing the entire system implementation lifecycle, strategic roadmap creation, business case/ROI justification, meeting facilitation, requirements and functional specification documents, user testing procedures, conducting demonstration, and training.

·         Experienced working on several proposals (RFP/RFI) collaborating with other specialists including executives and partners.

Professional Experience

Current Employer                                                         Mar 2010 – Current  
Managing Consultant
San Francisco, CA

Bank of America – Project 3
BI Lead                                                                            Jan 2012 – May 2012

Core Technologies Used
Cognos 10.1 Report Studio, Business Insight, Cognos Framework Manager, Oracle 10g, Oracle Data Integrator

 

General Motors – Project 2                                           Jan 2011 - Dec 2011
Lead Information Architect

Core Technologies Used
Cognos 10.1 Report Studio, Business Insight, Cognos Framework Manager, Oracle 10g, Oracle Data Integrator

  

IBM Blue Harmony – Project 1                                      Apr 2010 - Dec 2010
Solution Architect

Core Technologies Used
Cognos TM1 9.5, Oracle 11g, BEx Query and SAP Info Cube

KAISER PERMANANTE                                                      Jan 2010 – Mar 2010  
Project Manager (W2 Contractor)
Pleasanton, CA.

Core Technologies Used
Cognos 8.4, Cognos Framework Manager, Report Studio, Oracle 10g, Informatica 8.6

 

ACCENTURE                                                                       Apr 2007 – Dec 2009  
    Sr. Systems Integrations and Technical Consultant
    San Francisco, CA

Projects Assignments

Walt Disney – Project 6                                           Aug 2009 - Dec 2009
Sr. Consultant Developer                       

Core Technologies Used
Cognos 8.3 (Report Studio), Cognos Metric Studio 8.3, Cognos Framework Manager 8.3, SAP NetWeaver 7.0

 

Boston Scientific – Project 5                                    Mar 2009 - Aug 2009
Sr. Lead Business Analyst

Core Technologies Used
SAP BW, Cognos 8.4 (Report Studio, Query Studio) Cognos 7 Transformer, Cubes, & PowerPlay client, Cognos Framework Manager 8.4, SQL Server 2005, Clear Case, SQL DTS Packages

Accenture Outsourcing – Project 4                        Jan 2009 – Mar 2009
Sr. Solution Architect

Core Technologies & Tools Used
8.1.2 (Report Studio) Oracle 10g, Informatica 7.0, MS Visio & Framework Manager 8.0

 

Solar Turbine (Caterpillar Company) – Project 3        Jan 2008 - Dec 2008
Sr. Consultant Developer

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 – Project 2                               Sep 2007 - Dec 2007
Cognos SME

Core Technologies Used
8.1.1 MR1 (Report Studio, Query Studio) Oracle 10g, Informatica 7.0, & Framework Manager 8.0

 

Genzyme Biosurgery – Project 1                        Apr 2007 - Sep 2007
Sr. Consultant Developer

Core Technologies Used
8.1.2 (Report Studio) Oracle 10g, Informatica 7.0, & Framework Manager 8.0

 

INFORTE CONSULTING                                            Sep 2005 – Mar 2007  
Cognos Specialist
Chicago, IL 60601

Projects Assignments

Aon - Project No. 3
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 - Project 2
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 - Project 1
Consultant Developer

Core Technologies Used
Oracle Administrator, Oracle Discoverer, Discoverer Plus and Oracle Desktop, Oracle 9i, SQL Plus and PL/SQL Developer.

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

 

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

 

ACADEMICS ~ CERTIFICATION ~ TRAINING                     

NORTHERN ILLINOIS UNIVERSITY                                           
DeKalb, IL
Bachelors in Science
Major: Business Administration

WILLIAM RAINEY HARPER COLLEGE                                      
Palatine, IL
Associates in Applied Science
Major: Computer Information Systems
Certification in C/C++

ACADEMICS ~ CERTIFICATION ~ TRAINING

Cognos 10 (Web Training)                                                    Oct 2011
Cognos TM1                                                                      Aug 2010
Cognos Metric Studio                                                          Sep 2009
Partner Certified Cognos 8.1                                                          May 2008
Partner Certified Reportnet                                                   Jun 2006