SUMMARY:

• Around 17 years of Professional experience in building dashboards, analysis, modeling, design, development, testing and support of Business Intelligence and Data Warehousing projects.
• Experience in Denodo 7.0 admin/development Tableau admin/development and Control - M admin.
• Experience in Cognos 11, Cognos 10.2, Cognos 8 Suite, Report Net, Cognos Series 7 Analysis tools such as Cognos Transformer & Power Play Series 7.
• Experience in Cognos 11, Cognos 10, Cognos8, Report Net and PPES administration.
• Experience in Cognos Portal customization.
• Experience in Cognos Portal and Metric Studio Scorecard security.
• Extensively worked on Transformer for Data Modeling of the corporate data for building up of Multidimensional Cubes.
• Sound working knowledge of Oracle 9.x/8.x/7.x, PL/SQL, MS SQL Server (including stored procedures, database triggers and SQL programming).
• Successfully upgraded production systems from Cognos v5.x to v6.x, v6.x to Series 7 and Series 7.1 MR2 and then to the Cognos 8, Cognos 10 and 11 platform.
• Attended Adaptive Warehouse .
• Strong knowledge of Hadoop ecosystem tools Hive, Spark, Sqoop, Pig, Oozie, Apache Drill, Flume
• Salesforce Admin

TECHNICAL SKILLS:

BI Tools: Tableau, Denodo, VizAlerts, Cognos 11, Cognos 10,Cognos 8.3, Cognos 8.1(Report Studio, Query Studio, Metric Studio, Event Studio, Analysis Studio), Cognos EP Series 7, Cognos Report Net 1.1 (Report Studio, Query Studio, Framework Manager, Cognos Connection, and SDK), Power Play, Transformer

RDBMS: Oracle 10g/9i/8.x/7.x, DB2, SQL, PL/SQL, MS SQL Server 2000/7.0/6.5 , MS Access

Languages: SQL and COBOL

Big Data Tools: Hive, Spark, Sqoop, Pig, Oozie, Apache Drill, Flume

Application Servers: Apache Tomcat server, IIS 4.0

Operating Systems: MS-DOS 6.22, Windows 95/98/2000/NT 4.0/XP, UNIX, Sun Solaris 8.0, MVS

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

BI Administrator

Responsibilities:

• Denodo Admin/Development support
• Supporting multiple Cognos environments.
• Worked on Cognos 11 upgrade project.
• Control-M Admin support
• Tableau Admin/Development
• VizAlerts

Confidential, San Diego, CA

BI Administrator

Responsibilities:

• Supporting multiple Cognos environments.
• Worked on Cognos 11 upgrade project.
• Control-M Admin support
• Tableau Admin/Development

Confidential

Cognos Administrator

Responsibilities:

• Worked on Cognos 11 upgrade project.

Confidential, Los Angeles, CA

BI Architect/Cognos S r Developer/Cognos Administrator

Responsibilities:

• Played a key role as a complete solution architect to build FRD dashboard.
• Involved in finalizing the metrics and attributes needed for the FRD reports. Provided logic for ETL team to define metrics.
• Designed all the required tables in database. Designed and implemented benchmark data for comparison with actual metrics.
• Designed star schema model in FM to build 4 different star schemas with four fact tables and defined calculated metric involving multiple fact tables.
• Designed dashboard pages to build dynamic pages using iframes.
• Involved in validating all the metrics stepping outside my area to help business analyst in getting correct values for the metrics to validate with dashboard numbers.
• Sometimes discovering issues at source level metric calculations by analyzing the source data in source tables.
• Involved in presenting dashboard to external clients.
• Created metadata model using framework manger model according to the Cognos best practice model (Physical Layer, Business Layer, Presentation Layer and Subject area) with various calculated measures across the multiple facts and columns with macros.
• Involved in software installation and application of bug fixes on Cognos servers
• Involved in converting the functional specifications to technical documents.
• Involved in building dashboard pages with various types of chart reports and list reports.
• Involved in creating layouts to accommodate pages dynamically on the dashboard.
• Involved in creating drill through mechanism between the dashboard pages
• Involved in all phases of development, testing and deployment to production
• Created different kinds of prompt reports, list reports and cross tab reports
• Involved in building the reports with conditional formatting and conditional blocking for different kinds of business requirements
• Involved as administrator in migrating Cognos 8.3 platform onto high quality cloud environment (Savvis) with upgrade to Cognos 10.2.
• Maintaining Data Source Connections.
• Installing and Configuring Sun One LDAP server
• Developed Active Reports in Cognos 10.2
• Developed List, Crosstab and Dash Board reports in Cognos 10.2
• Setting thresholds for system metrics and monitoring metrics on scorecard pane
• Created user classes and users in Access manager.
• Created custom Audit Reports.
• Portal Customization

Environment: Cognos 10.2, SQL Server and Windows 2000.

Confidential, San Francisco, CA

Cognos Sr Developer

Responsibilities:

• Developed List, Crosstab reports in Cognos 10.1
• Created metadata model using framework manger model according to the Cognos best practice model(Physical Layer, Staging Layer, Logical Layer and Subject area)
• Involved in converting the functional specifications to technical documents.
• Involved in all phases of development, testing and production support
• Supporting the business users with their adhoc requests and delivering them on timely basis
• Created different kinds of prompt reports, list reports and cross tab reports
• Worked on complex drill through reports.
• Involved in building the reports with conditional formatting and conditional blocking for different kinds of business requirements
• Building models and publishing packages in Framework Manager to the Cognos 10.1 portal.
• Development of filters, calculations, prompts, conditions, and created various reports, using Cognos 10.1.

Environment: Cognos 10.1, Power Play 10.1, Oracle 10 and Windows 2000.

Confidential, Santa Monica, CA

Cognos Administrator/S r Developer

Responsibilities:

• Involved as a lead administrator in migrating Cognos 8.3 platform onto high quality cloud environment (Savvis) with upgrade to Cognos 10.2.
• Maintaining Data Source Connections.
• Setting thresholds for system metrics and monitoring metrics on scorecard pane
• Created user classes and users in Access manager.
• Created custom Audit Reports.
• Portal Customization
• Installing and Configuring Sun One LDAP server
• Developed Active Reports in Cognos 10.2
• Developed List, Crosstab and Dash Board reports in Cognos 10.2
• Created metadata model using framework manger model according to the Cognos best practice model(Physical Layer, Staging Layer, Logical Layer and Subject area)
• Involved in converting the functional specifications to technical documents.
• Involved in all phases of development, testing and production support
• Created different kinds of prompt reports, list reports and cross tab reports
• Involved in building the reports with conditional formatting and conditional blocking for different kinds of business requirements
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Building models and publishing packages in Framework Manager to the Cognos 8 portal.
• Development of filters, calculations, prompts, conditions, and created various reports, using Cognos 8.
• Business Data Analysis, Design, Development of Multidimensional OLAP Cubes.

Confidential, Burbank, CA

Sr Cognos Developer

Responsibilities:

• Involved in Theatrical Implementation project.
• Reviewed existing cubes to identify areas of improvement and greater efficiency.
• Developed List, Crosstab and Dash Board reports in Cognos 8.3
• Created metadata model using framework manger model according to the Cognos best practice model(Physical Layer, Staging Layer, Logical Layer and Subject area)
• Involved in converting the functional specifications to technical documents.
• Involved in all phases of development, testing and production support
• Created different kinds of prompt reports, list reports and cross tab reports
• Involved in building the reports with conditional formatting and conditional blocking for different kinds of business requirements
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Building models and publishing packages in Framework Manager to the Cognos 8 portal.
• Development of filters, calculations, prompts, conditions, and created various reports, using Cognos 8.
• Business Data Analysis, Design, Development of Multidimensional OLAP Cubes.

Environment: Cognos 10.1, Cognos8.4, Cognos8.3, Cognos8.1 MR1, Report Net 1.1, Power Play7.3, Access Manager7.3, Power Play Enterprise Server 7.3, DB2 and Windows 2000.

Confidential, Santa Monica, CA

Cognos Administrator/ Sr Developer

Responsibilities:

• Worked with Cognos 10 and involved in the migration from 8.3 to Cognos 10
• Involved in System Configuration and software installation of BI Suite Products
• Installing and Configuring Sun One LDAP server
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Maintaining Data Source Connections.
• Setting thresholds for system metrics and monitoring metrics on scorecard pane
• Created user classes and users in Access manager.
• Created custom Audit Reports.
• Portal Customization
• Published Cubes and Reports to Cognos connection through Power Play Enterprise Server Administration and integrated access to information using Cognos Connection.
• Developed List, Crosstab and Dash Board reports in Cognos 8.3
• Created metadata model using framework manger model according to the Cognos best practice model(Physical Layer, Staging Layer, Logical Layer and Subject area)
• Involved in converting the functional specifications to technical documents.
• Involved in all phases of development, testing and production support
• Supporting the business users with their adhoc requests and delivering them on timely basis
• Created different kinds of prompt reports, list reports and cross tab reports
• Worked on complex drill through reports.
• Involved in building the reports with conditional formatting and conditional blocking for different kinds of business requirements
• Building models and publishing packages in Framework Manager to the Cognos 8 portal.
• Business Data Analysis, Design, Development of Multidimensional OLAP Cubes
• Set up Power Play Cube automation process.
• TM1 Cognos server Architecture, Installation, Configuration and Up gradation
• Integrated Cognos TM1 with Cognos BI and performed BI Reporting.
• Created TM1 cubes.

Environment: Cognos 10.1, Cognos8.4, Cognos8.3, Cognos8.1 MR1, Report Net 1.1, Power Play7.3, Access Manager7.3, Power Play Enterprise Server 7.3, Oracle 9i and Windows 2000.

Confidential, Winston-Salem, NC

Cognos Administrator/ S r Developer

Responsibilities:

• Gathering the requirements from the business people
• Involved in Software upgrades from Report Net 1.1 MR1 to ReportNet1.1 MR2 and to Cognos8 MR1, to Cognos8.3
• Installing and Configuring Sun One LDAP server
• Involved in Design/Development of Custom portals for three of the Business units on Cognos connection.
• Involved in implementing scorecard security.
• Maintaining Data Source Connections.
• Created user classes and users in Access manager.
• Created custom Audit Reports.
• Portal Customization
• Involved in gathering Business Requirements for New models.
• Interacting with Development and Management Teams.
• Built models using Framework Manager a tool of Report Net
• Involved in Testing and Exploring New Tools Report Studio and Query Studio (Report Net).
• Developing Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Map Reports using Report Studio and Query Studio.
• Creating Query Prompts, calculations, Conditions & Filters.
• Creating New Jobs using Cognos Connection.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection
• Testing and improving Report Performance.
• Users on Report Studio.
• Involved in Documentation for User .
• Designed models by mapping business needs using Power Play Transformer and created multi dimensional cubes, cube groups, Power Play reports
• Decreased the Cube build times drastically and increased runtime performance.
• Deployed Cubes and Reports on Power Play Enterprise Server and also Published to Cognos 8 and Report Net.
• Set up Power Play Cube automation process.

Environment: Cognos8.1 MR1, Report Net 1.1, Power Play7.3, Access Manager7.3, Power Play Enterprise Server 7.3, Oracle 9i and Windows 2000.