Profile

• More than 27 years of experience in Software Design and Development, Over 17 years experience in Business Intelligence solutions specialized in Cognos 10, Hyperion, OBIEE, SAP and Teradata environments
• Implementation experience with Master Data, Metadata, Data Governance, Data Quality tools and projects
• Have worked in Information Technology, Finance Controlling, Health Media, Health Care, Banking and Retail departments
• Data integration experience with developing solutions to integrate Source systems to EDW using Informatica and Data Stage
• Data Modeling experience with developing Star Schema Data Marts and Use Layers using ERWIN and Power Designer
• Expertise in building Financial, Budgeting, Forecasting, and Strategic Planning applications
• Proven Record for overall architecture and strategy for the deployment of Enterprise Data warehouse
• Leading Executive workshops to identify key business metrics, definition of planning and reporting requirements, design and development of planning models
• Expert in building KPI's, Scorecards and Dashboards for Executive Leaderships
• Technical lead to integrate Legacy system interfaces to EDW and Operational Data Stores.
• A strong communicator and creative problem-solver able to interact with all levels of client organizations
• A record of achieving project and company goals through effective design, strong leadership skills and conscientious follow-through ability to maintain composure in highly demanding Situations.

Product Specialty and Statistics:

Installations Over 300 Cognos 6, 7, 8 , 10 and Other Products

Architecture Default, Multi-Tier, Multi Platforms and Complex Routing Rules

Modeling Over 100 Models of various types and sizes

Reporting 100s of reports and enhancements

Dashboards 100s of Dashboard Development and Deployments

OLAP Over 100 cubes, from 10 MB to 2 GB with 10s, 20s of dimensions, Measures, and 100, 000s of categories

Migration Over 6 major migration projects

Upgrades Over 11 major upgrades projects

Support 100s of service calls, Changes Controls, Root Cause Analysis, IBM SR/PMRs

Roles Played:

• Business Intelligence Application Architect - Application Development Support
• Business Intelligence Infrastructure Architect - Infrastructure Architecture, Planning and Operations Support
• Business Intelligence Liaison Business Intelligence Liaison/Processes/Admin
• Business Intelligence Approver Meta Data Management, Governance and Best Practices
• Projects as Business Intelligence Architect and Technical Solutions Lead with various Domains:

Domain Expertise:

• Automotive Retail and Automotive Finance Sectors
• Health Media and Health Care Sectors
• Banking and Finance Sector
• Manufacturing Sector

Projects:

• IBM Cognos 10 Infrastructure: Application Architecture, Software Installation, Security architecture, upgrade process implementation
• BCBSM Implementation of Self Service Business Intelligence Solutions for the Claims Data

• MBFS - Implementation and Delivery of Operational Reporting on Operational Data Store for Portfolio System.
• Comerica: Implementation of Cognos 10.2 BI Solution and Enterprise Payment Reporting Solutions.
• Meta Data Management: Built Meta Data and Meta Data Repositories using Cognos Tools

Technical Skills

Clients Experience

Confidential

Accomplishments

• Led the self-servicing BI project for BCBSM.
• Designed the Use Layer for Claims Data
• Created a Semantic Layer using Cognos Framework Manager
• Created a Self Service Reporting Application for the End Users
• Created the ETL Mappings and Data Model for the Use Layer
• Created the Playbook for the RAVE Engine
• Implemented Dynamic Cubes for the BCBSM.
• Upgraded the Cognos 10.1.1 to Cognos 10.2.1

Confidential

Automotive Industry Sr. BI Solutions Architect and Delivery Lead.

Accomplishments

• Lead projects to automate transactional, reporting and analytic processes to increase the business productivity for MBFS BICC
• Effectively Applied new data management and analytic technologies to solve challenging Business problems for MBFS
• Provided leadership project level management in the planning, evaluation, implementation, operation control of BICC BI applications, data and analytical tools
• Work closely with partners across the business to develop strategies, evaluate and implement new technologies
• Managed daily activities, issue resolution and communication across project execution teams in order to deliver projects on-time, on-budget
• Developed peer and cross-functional relationships to maximize best practice sharing team effectiveness between BICC Organization and IT Organizations
• Managed supplier relationships to ensure ongoing delivery operational support of high quality, cost effective solutions for MBFS
• Responsible for Implementing Cognos 10.2 Environment and Developing the NEXUS Operational Reporting for the Client on a time and material Contract.
• Developed SOW and Scope Statements for the Client
• Liaison between Client BICC and IT Departments for Successful Delivery of the Solution.
• Responsible for delivering the 300 operational reports.
• Leading the Development with a team of 7 Developers both onsite and off-site model
• Architected the Reporting Solution for the ODS
• Architected the FM Model for the Operational Data Store
• Responsible for the overall deliverables for the Client
• Responsible for the resource planning and budget control of the project
• Responsible for identifying and resolving the Risks and Risk Mitigation plan.
• Responsible for the status presentations to the Steering Committee of the MBFS
• Mentoring and Coaching the Client Staff for successful transition of the Project.
• Developed the Dash Boards for Project Status and Deliverables for MBFS.

Confidential

Accomplishments

• Responsible for introducing Cognos 10.1 Suite of Products and their capabilities, enhancing the functionality and performance of the existing applications there by adding business value and increasing the Return on Investment ROI .
• Responsible for migrating/consolidating current applications/environments running on traditional reporting methods using Office and Desktop Publishing products and transforming, eliminating time consuming, tedious application development processes to simple and streamlined processes delivering Centrally Authored, Cross Functional, and Self Service environments adding business value and achieved considerable cost savings.
• Responsible for downsizing the Cognos infrastructure from 10 Physical servers to 25 VM servers saving Software/Hardware costs upto 5000/Cognos Instance.
• Responsible for License Cost Savings of over 250,000 during upgrade to cognos 10.1 phase through license Auditing process.
• Responsible for Consolidating Cognos 8 Environments to Cognos 10.1 to increase resource utilization as well as reduce operational cost by 2000/Instance/Year.
• Responsible for Design and establishing central hosting environment with servicing capability of 5000 users on large BI server farm that is highly available, Scalable, Fault Tolerant and Load Balanced.
• Heavily used Motio PI tool for Environment Administration and reduced the time to monitor/Administer the Cognos Environment from 4 hours to hour on a day to day schedule.
• Responsible for Infrastructure Planning, designing encompassing Cognos Hardware/ Software Requirements Gathering, Hardware Procurement, Capacity, Scalability, Availability and Contingency planning options, Installation Options, Server configurations, Performance Tuning, and Security Strategies.
• Responsible for license management and vendor engagement.
• Responsible for Migrating Crystal, Business Objects and Legacy Reporting Environments to Cognos 10.
• Responsible for the end to end design, development and implementation of a Business Intelligence solution using Cognos BI to support the various functional areas for Comerica Bank.
• Architected and Implemented Multi-Tier and highly scalable Cognos 10.1 environment on Windows 2008 VM environment with load balancing and failovers.
• Responsible for Cognos Capacity planning and working with IBM Vendor for Licensing Costs
• Implemented Cognos UI customization to promote the Comerica BA branding as Analytic Central
• Created a road map for Cognos 10.1.1 upgrade and Cognos 10.2 Release.
• Successfully upgraded the existing Cognos 10.1 to Cognos 10.2 Release with full 64 bit capabilities.
• Working on Dynamic Cubes POC
• Working on Cognos Insight 10.2 POC
• Responsible for recommending appropriate application architecture, design, hosting environment based on business requirements by classifying applications into Real Time/Operational Reporting, Data warehouse / Data Mart categories and suggesting required Cognos capabilities Report, Analysis, Dashboards and Score carding and Migrating legacy applications deployed in older versions.
• Responsible for setting up Proof of Concept environments and creating proof of concepts introducing users to Cognos Products and demonstrate their capabilities providing product awareness and demonstrating the feasibility of special requirements with prototypes and hands on experience for the Project Management and Development teams.
• Responsible for Application and Production Support using incident management, enterprise change control, root cause analysis processes for 2000 users, 10 applications, 5 environments, 50 servers.
• Responsible for documentation initiative involving maintaining global documentation database on Content Management Servers providing references to Guidelines, Best Practices, Operational Procedures, Client Software Installation Procedures, Cognos Feature Walkthroughs, Slide Shows and User Training.
• Responsible for Metadata Design Standards, Guidelines and Best Practices based on Vendor recommended as well as various Industry Proven Techniques.
• Responsible for Report Design Standards, Guidelines and Best Practices based on Vendor recommended as well as various Industry Proven Techniques.
• Responsible for Deployment Standards, Guidelines and Best Practices.
• Responsible for training various user groups across the organization as well as development, support personnel to bring them up to speed quickly to handle BI activity and mentoring the teams to enable them to handle the support, delivery challenges effectively.
• As a member of the Project Management team played a key role in Project Planning, Prioritization and execution.
• Responsible for BI Infrastructure, Development, Operations and Support for the entire corporation playing several roles - Solution Architect, Subject Matter Expert, Product Specialist and BI Liaison.
• Responsible for Data Quality, Metadata Management stewardship.

Confidential

• Primary Responsible for 24/7 Production Support of Cognos Application and administration of Cognos Servers Development, Pre-Production and Production
• Designed the Security Model for Cognos Application using GM LDAP Authentication
• Performance tuning of Cognos Reports and Cognos Server for long running queries
• Designed Framework Manager meta data models using Relational Schema and DMR modeling Concepts for Standard Reporting needs as well Ad-hoc reporting needs.
• Designed the Best Practices of deploying Cognos Content in a Distributed Environment
• Front Office lead for General Motors NASR Cognos Application.
• Designed and implemented SSO for GM NASR Cognos Application.
• Designed Migration plan and migrated Cognos ReportNet 1.1 to Cognos 8.4 Version.
• Implemented a Centralized Cognos Portal using Cognos Portlets accessing the content from vari- ous Cognos Applications.
• Trained Cap Gemini Internal IT team in Cognos 8.4
• Trained General Motors End Users in Cognos 8.4 Ad-hoc reporting

Confidential

Responsibilities as Cognos Architect:

• Developed EIM Project Management Dashboards by extracting data from Clarity Project Management Tool.
• Implemented a Centralized Cognos Portal using Cognos Portlets accessing the content from various Cognos Applications.

Confidential

• Designed and implemented the Business Intelligence solution, process and methodology for the HealthMedia Data Warehouse Project
• Involved in Business Requirement Gathering and Mapping requirements to Technical Specifications
• Developed Best Practices and Documented the process as a standard process for the HealthMedia
• Developed Balance, Breathe, Nourish, Relax, Depression and Insomnia Executive Summary Reports for Health Media
• Designed, Build Cognos Framework Manager Projects detail and DMR models
• Designed Reports/Content Deployment Process, Security Administration and Develop, run, and distribute System Management Reports on Dev/Test/Prod Environments
• Implemented the Server tuning, Report tuning and Auditing of Report usage on the production server
• Developed Business Intelligence SQL Views using Oracle 10g Database for better performance of Cognos 8.4 Reports.
• Developed Oracle SQL Scripts in ORACLE 10g for Testing data in reports.
• 24/7 Production on call support for Cognos Application.

Confidential

Major Accomplishments:

• Consolidated Cognos Series 7 and Cognos 8 Environments and saved 20,000 per month.
• Conducted In-house Cognos 8 training for Power Users and Consumers and saved 500,000
• Successfully rolled out Dealer Credit Business to use Cognos 8 platform and sundown their Java based reporting solution and saved 100,000 Per year.
• Sundown Hyperion ESSBASE Environment and migrated over to Cognos 8 Environment and saved 50,000 per year.
• Consolidated all Cognos 8 Licenses based on the Usage review and reduced the number of Li censes and saved 45,000 on Maintenance Cost per Year
• Migrated Crystal reports 8.5 to Cognos 8 and sundown the Crystal Reports environment and saved 50,000