PROFESSIONAL SUMMARY:

• Business Intelligence Specialist (Cognos and Tableau Developer & Administrator) with over Fifteen years of experience in Architecture, Administration of Environment, Analyzing, Designing and developing of Reports using multiple databases within Healthcare, Supply Chain Logistics, Government, Banking, Financial Services and Insurance.
• Architectural Design, Installation, Configuration of Cognos Analytics (11.x), BI (10.x), Cognos TM1 (10.2), Planning Analytics 2.0.x and Tableau Server (2019.x, 2018.x, 10.x, 9.x and 8.x)
• Working with Cognos 11.x, 10.2.2, 10.1.1 and 8.4 Administrations, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Transformer, Workspace and Workspace Advanced, Dynamic Cubes.
• Developing Data Models (Star and Snowflake schemas) in Cognos Framework Manager and delivering packages for reporting application and multidimensional analytics.
• Worked on Cognos Server Administration activities like installing single and multi - node environments i.e. Content Manager and Dispatchers
• Users, Groups, Roles, Configuring Data Source Connections, Content Administration by deploying and migrating components, backing up the Content Store and enhancing Cognos Portals.
• Experienced in Business Data Analysis, Data Profiling, Business process modeling and using business analysis tools and processes.
• Developed Proof of Concepts using Cognos 11.x, 10, 8.4 to replace legacy system and upgrading Cognos 8.4 Environments, Models and Reports to Cognos 10.
• Experienced in Cognos SDK using Java for automation and custom reporting solutions.
• Designing & Developing reports having Prompts pages, Charts, Mixed Layout, Master Detail layouts, Query Joins, Query Unions and other sophisticated features such as Conditional Formatting and Bursting.
• Developing Active Reports for Business Users allowing them to explore their data and derive additional insight. These reports can be viewed when Users are offline.
• Upgrading Cognos 8.4 & 10.x dashboards to Cognos 11.x Business Insight Dashboards and developing new interactive dashboards and reports using Business Insight Advanced.
• Developing reports using External Data Source such as Excel, Text and CSV files.
• Developing Power Cubes using Cognos Transformer and Developing Reports using them.
• Upgrading Tableau to 2019.x, 2018.x, 10.x, 9.x and 8.x
• Administering Tableau tasks - creating sites, Backing up sites and environment, control access to users
• High level development support for Cognos and Tableau.

TECHNICAL SKILLS:

OLAP Modeling: Cognos 8.4, 10.1.1, 10.2, 11.x Framework Manager, TM1 9.5, 10.1.1, 10.2.2 and Planning Analytics

BI Reporting: Cognos 11.x, 10.x, and 8.4 Report Studio, Query Studio, Event Studio, Metric Studio, Analysis Studio, Transformer, Workspace and Workspace Advanced, Tableau Desktop 8.2, 8.3, 9.0.1, 10.x, 2018.x and 2019.x

Platforms: Windows XP, Windows Server 2000/2003/2008 , Linux

Languages: C, C++, SQL, Cobol

DBMS: DB2 9.1, SQL Server 2008, MS Access 2007, Oracle 10g, 11g, Exadata

Analysis Tools: MS Project, MS Visio, CAFE

Documentation: MS Excel, MS PowerPoint, MS Word

Methodologies: Agile, POC, Waterfall software development

PROFESSIONAL EXPERIENCE:

Confidential, Pleasanton, CA

Cognos & Tableau Developer and Administrator (Solution Architect)

Responsibilities:

• Requirements elicitation from Business users and Subject Matter Experts for business & Functional requirements, Hardware requirements, sizing of BI platforms.
• Gathering functional requirements, analyzing and transforming them into Analytical solutions.
• Manage, maintenance and upgrade plans for application upgrades and technical infrastructure changes or expansion.
• Perform detailed documentation of design, development, testing and deployment activities necessary to ensure sharing of knowledge with in the team.
• Installed, configured and upgraded Cognos BI 8.x to 10.x and 11.x TM1 from 9.5 to 10.x and working on Planning Analytics 2.x.
• Installing, configuring and Upgrade of Tableau 8.x, 9.x and 10.x (Distributed environments). Currently working on Tableau upgrade from 10.x to 2018.x and to 2019.x.
• Working on Cognos Server Administration activities like setting up environments for sandbox to production for internal and Business users.
• Working with enterprise security groups (ED and AD) to govern access to users by creating Users, Groups, Roles.
• Working with security groups like WSSO and Ping Authentication to be integrated with Cognos environments and with Active Directory group on Tableau.
• Configuring Data Source Connections, Content Administration by deploying and migrating components, backing up the Content Store and enhancing Cognos Portals.
• Experienced in Business Data Analysis, Data Profiling, Business process modeling and using business analysis tools and processes.
• Modelled, Designed and developed reports, dashboards and stories using Cognos and Tableau with datasources from Oracle, SQL Server, DB2, Teradata, Hadoop etc.
• Provide technical solutions to Application team there by empowering Business users in their day to day activities.
• Working with tools like Motio (for Cognos), Logshark, TabMon, TabJolt, Replayer, scout (for Tableau).
• Coordinate with various infrastructure teams (DBAs, Enterprise Directory, Mail service group, Windows upgrade, Server patching team, Packaging team etc.)
• Automation by scripting repetitive maintenance activities like environment recycle, backups, refresh Powerplay Transformer cubes, refresh Dynamic cube, file transfers etc.
• Design and develop admin reports with KPIs for senior management.
• Provided technical support for all applications hosted on the environments.
• Work with vendors like IBM (for Cognos) and Tableau (for Tableau Server and Desktop) in resolving product issue.
• Work with various groups to align platforms inline with our enterprise example: Infrastructure Lifecycle Management, Enterprise directory, Security patching team, DBAs etc.
• Work with Advanced Technology group to assess the latest versions of products and providing guidance to business users on their advantages.
• Work with vendors and conduct deployment reviews for Tableau and Cognos assess and plan for the growth of platforms.

Environment: Cognos Analytics 11.x, 10.x, 8.x (Framework Manager, Report Studio, Query Studio, Event Studio, Business Insight and Business Insight Advanced), Cognos Life Cycle Manager, Cognos Access Manager, Cognos Connection, Motio CI and PI for Cognos, Oracle 11g, SQL Server 2008, 2016 on Windows Server 2008, 2012 & 2016, Tableau Server 8.x, 9.x, 10.x, 2018.x and 2019.x), Logshark, TabMon, TabJolt, Replayer, scout (for Tableau).

Confidential, Chicago, IL

Sr. Business Analyst & Cognos Developer

Responsibilities:

• Visited Multiple Distribution Centers for Reyes Holding/Martin Brower to understand the Business processes in the Warehouse.
• Monitoring and Maintaining of Cognos 10.1.1, 8.4 environments (Prod, UAT and Development).
• Creating Models, Packages and Reports in Cognos 10.1.1 with multiple applications & databases like Paragon (Route Plan), Xatanet (Route Actual), JDE (Financial) & Warehouse Management System (Warehouse Mgmt.).
• Assisted in the Data Mart design for reporting and process flow of Data Warehousing. Working with Data Architect team and ETL team to get the required data for the reports.
• Imported data from different Data Sources and External Data in Framework Manager Models to create query subjects, Dimensions, Measures for developing Star Schemas . Published Packages to the users groups there by empowering Users to build their own reports.
• Implementing the best practice in Framework Manager Models like creating different Namespaces for imported Data Source Query Subjects, Business View and Presentation Layer.
• Monitor and control Access of users by creating Users, Groups and Roles in Cognos Access Manager.
• Created BI solutions to end users for review and approval.
• Developing canned and Ad-hoc Report Studio reports. Training to the end users.
• Cognos SDK with Java for automation and custom reporting solutions.
• Perform detailed documentation of design, development, testing and deployment activities necessary to ensure team knowledge sharing.
• Creating Drill Through definitions on packages for Query Studio and Analysis Studio reports.
• Assist business users with complex reporting requirements, assisting in design and/or troubleshooting efforts.

Environment: Cognos 10.2, 10.1.1, 8.4 (Framework Manager, Report Studio, Query Studio, Event Studio, Business Insight and Business Insight Advanced), Cognos Connection, Oracle 11g, SQL Server 2008 on Windows Server 2008, Linux.

Confidential, Albany, NY

Cognos Administrator & Developer

Responsibilities:

• Monitoring and Maintaining of Cognos 8.4 environments (Prod, UAT and Development). Maintaining the Content Manager and Dispatcher servers by changing environment parameters, XML files, bringing up and down the environment, Installing Fix Packs etc.
• Setting up Cognos 10.2, 10.1.1 environment(s).
• Upgrade Models, Packages and Reports in Cognos 8.4 and also test the upgrade to Cognos 10.1.1.
• Imported data from different Data Sources and Externalized Data in Framework Manager Models to create query subjects, Dimensions, Measures for developing Star Schemas . Published Packages to the users groups there by empowering Users to build their own reports.
• Implementing the best practice in Framework Manager Models like creating different Namespaces for imported Data Source Query Subjects, Business View and Dimensional Model(s) i.e. DMR’s.
• Monitor and control Access of users by creating Users, Groups and Roles in Cognos Access Manager.
• Created Prototypes of proposed BI solutions to end users for review and approval.
• Developing canned and Ad-hoc Report Studio reports. Training to the end users.
• Manage maintenance and upgrade plans for application upgrades and technical infrastructure changes or expansion.
• Cognos SDK with Java for automation and custom reporting solutions.
• Perform detailed documentation of design, development, testing and deployment activities necessary to ensure team knowledge sharing
• Creating Drill Through definitions on packages for Query Studio and Analysis Studio reports.
• Review and test the peer team developed Framework models and reports.

Environment: Cognos 10.2, 10.1.1, 8.4 (Framework Manager, Report Studio, Query Studio, Event Studio, Business Insight and Business Insight Advanced), Cognos Connection, Oracle 11g, SQL Server 2008 on Windows Server 2008.

Confidential

Project Manager

Responsibilities:

• Monitoring and Maintaining of Cognos 8.4, 10.1.1 environments (Prod, UAT and Development). Maintaining the Cognos servers.
• Upgrade Models, Packages and Reports in Cognos 8.4 and also test the upgrade to Cognos 10.1.1.
• Assisted in the Data Mart design for reporting and process flow of Data Warehousing. Working with Data Architect team and ETL team to get the required data for the reports.
• Imported data from different Data Sources and Externalized Data in Framework Manager Models to create query subjects, Dimensions, Measures for developing Star Schemas . Published Packages to the users groups there by empowering Users to build their own reports.
• Implementing the best practice in Framework Manager Models like creating different Namespaces for imported Data Source Query Subjects, Business View and Dimensional Model(s) i.e. DMR’s.
• Monitor and control Access of users by creating Users, Groups and Roles in Cognos Access Manager.
• Created Prototypes of proposed BI solutions to end users for review and approval.
• Developing canned and Ad-hoc Report Studio reports. Training to the end users.
• Developing Power Cubes using Cognos Transformer.
• Requirements elicitation from Business users and Subject Matter Experts for business & Functional requirements, data mapping and reporting needs.

Environment: Cognos 10.1.1, 8.4 (Framework Manager, Report Studio, Query Studio, Event Studio, Business Insight and Business Insight Advanced), Cognos Connection, Oracle 11g, SQL Server 2008, DB2 9.1 on Windows Server 2003/2008.

Confidential, Rochester, NY

Sr. Cognos Developer

Responsibilities:

• Developed and updated Star schema models using Cognos 8.2 Framework Manager with Oracle 10g, SQL Server 2005 as data sources.
• Developed a Relational Models and Dimensional Models of Relational (DMR) data source. Created and published packages for reporting.
• Created Power Cubes using Transformer.
• Used Branching and Merging to update FM models by multiple developers/Users.
• Developed canned and Ad-hoc reports (List, Crosstab, Charts, Drill up-Down, Drill Through reports) using Report Studio and Query Studio.
• Created Analysis Report with calculations using the DMR data source in Analysis Studio.
• Created Events, Tasks and Content Maintenance Tasks using Event Studio for weekly and monthly back-up of Content Store.
• Worked with business analysts, end users, and data architects to understand and define the information delivery requirements and supporting structure for the BI application.

Environment: Cognos 8.2 (Framework Manager, Report Studio, Query Studio, Metric Manager), Cognos Connection, Oracle 10g and Project Management methodologies on Windows Server 2003.

Confidential, Columbus, OH

Cognos Developer

Responsibilities:

• Confidential and Allied merged their DB2 databases because of their merger. Analyzed and executed a Proof of Concept for Micro strategy reports to migrate in Cognos 8.1.
• Developed Star schema model using Framework Manager with DB2 as data source. Developed a Relational Model and Dimensional Model of Relational (DMR) data source.
• Developed and published two packages for reporting.
• Developed about 15 Reports (List, Crosstab, Charts, Drill up-Down, Drill Through reports) using Report Studio and Query Studio.
• Created Analysis Report for LOB and Time as Dimension using the DMR data source in Analysis Studio.
• Created Events and Tasks using Event Studio for new Policies counts in the System.
• Identified the stakeholders and understood their role & defined business & functional requirements.

Environment: Cognos 8.1 (Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio), Windows Server 2003, DB2, Clarity, Project Management methodologies.

Confidential, San Diego, CA

Cognos Developer / BI Business Analyst

Responsibilities:

• Executed a Proof of Concept for migrating PeopleSoft reports (in HR Database) to Cognos 8.1.
• Developed Star schema model using Framework Manager with 5 Dimension and 1 Facts, with Oracle 10g as data source. Developed a Relational Model and Dimensional Model of Relational (DMR) data source. Created and published 2 Packages as part of POC.
• Developed and scheduled about 10 Reports (List, Crosstab, Charts, Drill up-Down reports), Burst reports according to managers using Report Studio.
• Created Basic Analysis for Employees, Skills and Appraisal Rating using the DMR data source in Analysis Studio.
• Created Events and Tasks using Event Studio.
• Created Dashboards with Reports and Metric studio content.
• Gathered requirements from the business users by conducting interviews, Q&A and brainstorming sessions.
• Develop project plan & schedules, system schematics and process work flows.
• Assured all artifacts/signoffs were in compliance with corporate policies and guidelines and archived.
• Updated Lessons Learned Knowledge database.

Environment: Cognos 8.1 (Framework Manager, Report Studio, Event Studio), Cognos Connection, Windows Server 2003, Oracle 10g, Microsoft Office, Project Management Methodologies.

Confidential, Jersey City, NJ

Cognos Developer / Project Lead

Responsibilities:

• Upgraded Windows Server from NT to XP and tested the MSI packages containing the Cognos catalogs and reports.
• Upgraded Cognos catalogs and reports from Cognos 5.0 to Cognos 7.3.
• Created Canned Reports and Ad-hoc reports using Impromptu according to Users requirements.
• Reports comprised of list reports, cross-tab reports and chart reports, hot files and Portfolios using underlying multiple query structure by using filters, calculations, complex expressions, conditional formatting, and prompts including cascading prompts.
• Maintained Impromptu Web Reports.
• Created dimension maps and multidimensional cubes and IQD files in Power play Transformer.
• Provided End User training and support
• Updated and modified Cognos distributed Catalogs for Yacht line of Business and other LOB’s.
• Created the Cognos Power Cubes in Transformer and distribute the multidimensional models.
• View the distributed Power Cubes using Cognos PowerPlay for Windows and Cognos Visualizer.
• Worked on enhancements to the existing Premium Entry systems and other corporate interfacing systems (CMS, CDCS etc.) for sending and receiving data.
• Assessed and documented business requirements, recommended business priorities and advised the business users on options, risks and costs during the upgrade to e-Marine project.
• Conducted business process modeling and generated scenarios for the technology functionality testing team.
• Develop system integration test scripts and ensured that the test results align to the business expectations.
• Worked on evaluating the business intelligence (BI) needs by identifying opportunities and proposing solutions to value addition for effective use of BI applications.
• Monitored Premium Entry System application and related mainframe jobs and COBOL programs to run the daily, weekly and monthly job to enter data into DB2 Tables.
• Provided on-call support for the entire application.

Environment: Cognos 7.3, Cognos 5.0, Windows NT & XP, Microsoft Visio, PL1, COBOL, JCL, DB2, File Manager, Endevor, Fault Analyzer, QMF, Shadow Server, Extra Personal Client 6.5.