We provide IT Staff Augmentation Services!

Team Lead - It Architect/cognos Administrator/cognos Developer Resume

2.00/5 (Submit Your Rating)

Bloomington, IL

SUMMARY

  • 10+ years of experience in IT industry with experience in Analysis, Design, Development, Maintenance and Implementation of Client/Server, Data Warehouse and Business Intelligence using Relational Database Management Systems (Oracle, MS - SQL Server, MS-Access and IBM DB2) applications on Windows NT/2000/98 and Unix/AIX Platforms.
  • Around 7 years of experience with IBM on various Data warehousing technologies.
  • Worked extensively on OLAP Models using COGNOS and HYPERION Technologies.
  • Experience as a Primary Contact for On-Call/Production Support and Off-shore Coordination for Cognos / Hyperion Administration and Development Projects.
  • Involved in setting up of Infrastructure of IBM Cognos 10/ Cognos 8/ Cognos 7 environments.
  • Mentored and trained Software Developers and Business clients on Cognos Products like Framework Manager, Report Studio, Query Studio, TM1 and Cognos Planning Etc.
  • Around 4 years of experience in Hyperion Essbase ver 11/9x/7x/6x, Hyperion Planning 9x/4x, EAS, Hyperion Reports 9x/7x, Essbase Excel- Addin, Hyperion Analyzer 7x and HAL.
  • Experience in Analysis, Design, Installation and Configuration of Hyperion Essbase Server, Essbase Administration Services (EAS), Planning ver 9x/4x, Reports, Shared Services, Analyzer and Essbase Excel Add-In Services.
  • Experience in working on ETL (Extraction, Transformation, and Loading) mechanism using Informatica 7x/5x and Knowledge on Datastage.
  • Rich experience in Systems Analysis and Design. Excellent experience in Solutions Design from Scratch. Experienced in guiding teams in Implementing BI Solutions where little or no documentation of existing reporting system exists.
  • Well-versed in developing reporting applications using Cognos 10.x/8.x. Extensive experience in the usage of tools such as Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio and Cognos Connection, TM1 and Cognos Planning
  • Solid experience with Cognos 10.1/8.3, Cognos ReportNet and Cognos Series 7 product suite and managing user security using sources such as Sun One Directory Server LDAP, Active Directory etc. to create and manage User profiles, groups and roles.
  • Used features in Cognos administration like monitoring activities, system and schedule
  • Setup security using Access Manager Administration.
  • Extensive experience in using features like watch items, watchrules, new tab portal pages, pagelayers, context filters, singleton object creation, table of contents, and no data content option.
  • Extensive experience in features in Cognos administration like monitoring activities, system and schedule
  • Experience in DMR techniques and cube creation by using cognos report and package
  • Excellent experience in Oracle 8i /9i/10G and SQL
  • Experience in writing SQL and UNIX/AIX scripts, Stored Procedures and Functions using PL/SQL.
  • Experience in Dashboard and Scorecard creation.
  • Knowledge in Data Architect, Data Analysis providing Business Intelligence solutions using Informatica- Power Center/Power Mart.
  • Experience in dimensional modeling using Star Schema and Snow-Flake Schema
  • Experience with Logical and Physical data model design, Relational and Dimensional models with ERWIN tool.
  • Expertise in defining client's requirements, functional specifications, designing documentations and testing strategies as per Quality Standards.
  • Have good Business Analysis skills, communication, problem solving, time management and interpersonal skills with ability to work in a team and individually.
  • Experience of working with Insurance, Financial, Healthcare, Telecom and Manufacturing Domains.

TECHNICAL SKILLS

Operating Systems: Windows 2008 R2/2000/NT/XP/2003, Unix/AIX, MS-DOSIBM Websphere.

RDBMS: Oracle 10g/9i/8i/7.x, SQL Server 2000, MS-Access 2000IBM DB2.

Languages: C, SQL, PL/SQL

GUI: Visual Basic 6.0

ETL Tools: Informatica 5.0, Datastage.

Reporting Tools: Cognos 10 BI/Cognos8/Cognos 7 - Suite of Products. Hyperion, Business Objects, Crystal Reports 8.0, Micro strategy, SAP Business Intelligence. Hyperion Reports 9x/7.2Hyperion Analyzer 7x, Essbase Excel Add-In, Cognos 8BI ver.8.3 (Framework Manager, Report Studio, Query StudioAnalysis Studio, Event Studio), Cognos Report Net 1.1Cognos Power Play, Impromptu, IWR. Business Objects, Crystal Reports 8.0, Micro strategy, SAP BI.

OLAP Tools: Hyperion Essbase, Hyperion Planning. Hyperion Essbase 9x/7.1.3/6.5, Hyperion Planning 9x/4.0.1Cognos 10/8BI -Framework manager, Cognos 7x PowerplayCognos Planning, Cognos TM1, Business Objects 5.1.

Project Management: Project Management, Leadership, Methods Tools Cluster, Contracting for PMs, Financial Management

Domain Knowledge: Insurance, Financial, Healthcare, Telecom and Manufacturing Domains.

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

Team Lead - IT Architect/Cognos Administrator/Cognos Developer

Environment: Cognos 10.1/ 8.4/ 7.4 ( Vantage, Business Insight, Report Studio, Query Studio, Analysis Studio, Framework Manager, Cognos Connection), Powerplay Transformer, Powerplay Studio, Impromptu Administrator, Cognos Server Administrator, Cognos TM1, Cognos Planning, Controller, Contributor, Access Manager, Cognos Upfront, Content Store, Oracle 10g/9i, IIS, Web server, IBM DB2, SQL Server 2005/2008, Windows XP/2008 R2.

Responsibilities:

  • My role and Responsibilities include:
  • General IBM Cognos product support
  • Testing new releases/fixes/service packs related to Cognos.
  • Installing and tuning the Cognos products on servers in UNIX and Windows environments
  • Coordinating the release and issuance of new products to client workstations
  • Consulting on projects and other development efforts across departments
  • Monitoring product performance, troubleshooting, diagnostics, system configuration
  • Provide Publishing and setting up of Data sources. This requires strict adherence to standard publishing procedures in order to ensure we are able to keep track of the Cognos Reporting Applications under development and published to production.
  • Provide Capacity planning information based on current system peak usage and new Application usage projections to determine capacity issues.
  • Responsible for addressing all incidents assigned to the Cognos Work Groups. Identify Cognos System Impacts and initiate “Cognos Impact Emergency Action Plan”. Escalate/communicate system impacts appropriately. Provide proactive monitoring of Cognos Reporting Systems.
  • Provide Cognos developer guidance and support the direction toward strategic development.
  • Provide Administrative support to Reporting Applications using or developing in Cognos BI.
  • This includes items such as:
  • Provide developer access to Cognos development tools and ensure adequate training or assistance has been made available as necessary. This includes Workstation Enhancement approver for Client Developer Tools as well as Set/update capability permissions to give access to Cognos Connection tools.
  • Provide Cognos infrastructure consulting to project and/or BI Dev Support Team.
  • Maintain Publishing Procedures and ensure they are followed by the Team.
  • Provide Cognos developer guidance and support the direction toward strategic development.
  • Ensure proactive support & stability of Cognos BI Reporting infrastructure amidst System
  • Environment changes & Releases as well as capacity planning based on Reporting Application development and implementation to production.
  • Troubleshoot the administrative & technical problems for both first and second level support applications.
  • Administering the Cognos environment which includes monitoring system performance, managing dispatchers and server loads, Tuning server performance for peak demand and off-peak loads and managing content manager and its relative services
  • To Install and Configure the Cognos 10.1.1 environment (IBM BI and Cognos Planning).
  • Tuning the Performance of Cubes that deals with historical data by tweaking the cube parameters and eliminating any redundant elements being retrieved.
  • Serve as Lead of Analytics and Reporting team, motivating the team and performing responsibilities for reports related to production.
  • Handling the comprehensive setup, testing & administration of Cognos Series 10.1/8.4/7.3 & 7.4 toolset including Framework Manager, Report Studio, Analysis Studio,
  • Query Studio, Event Studio, Powerplay Studio, Cognos Planning Analyst, Contributor, Controller, Cognos Transformer, TM1, Cognos Impromptu, PowerPlay, Access Manager and Upfront.
  • Working on Upgrading the Cognos 8.4 Environment to Cognos 10.1 / 10.1.1 Environment.
  • Deploying reports and packages from development to QA and QA to production environment.
  • Experience in establishing the application managed services in Confidential to prove low cost and high productivity.
  • Migration of the reports from Cognos 7 to Cognos 8.3/10.1 environments.
  • Validating & troubleshooting migrated metadata models and reports in Cognos 8.3/8.4 environment.
  • Setting up and testing types of drill through (Cube to cube & Cube to report) in both homogeneous and heterogeneous environments.
  • Manage and provide assistance to the offshore resources.
  • Provide training and support to the Business Partners at State Farm.

Confidential, Chicago, IL

Team Lead - Cognos Admin / Developer

Environment: Cognos 8BI v 8.3 - Cognos Report Studio, Cognos Query Studio, Cognos Analysis Studio, Cognos Framework Manager, Cognos Connection, IBM AS 400, Showcase Query, i-Series, SQL, PL/SQL, Windows NT/XP/2003.

Responsibilities:

  • Worked closely with business users in gathering requirements, analyzing data and supporting existing reporting solutions.
  • Involved in developing complex Cognos Reports using Report Studio to support Confidential Clients.
  • Customized data in the reports by adding Filters, Prompts, Calculations, Summaries and Functions.
  • Developed Standard Templates, Reports, Charts, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio and Query Studio.
  • Involved in demonstration and training on IBM Cognos BI to the Business Users.
  • Managed and worked closely with the off shore team on various business projects.
  • Created and maintained Cognos packages in Framework Manager.
  • Designed production rollout process for Cognos applications.
  • Promoted packages to Production using Import/Export utility.
  • Created, refreshed and supported Cognos Transformer models and cubes.
  • Performed Cognos administrative functions such as creating user accounts, user classes and roles.
  • Built and maintained Cognos reporting security.
  • Scheduled and Distributed reports through Schedule Management in Cognos Connection
  • Interact with Customers to determine their needs, gather and Document requirements, communicate with customers throughout the development project.
  • Involved in Unit Testing, User Acceptance testing, and Testing Documentation.
  • Analyze business needs and translate them into technical specifications and maintain the information flow in the Team.
  • Created standard Lists reports and Cross-tab reports and Ad hoc reports using Report Studio and Query Studio.
  • Develop Project Plans, Track Project Execution, Manage changes, develop and execute Implementation Plans as per quality standards.
  • Be the primary contact to manage Customer expectations, resolve issues, and provide project status with regard to Cognos Reporting enhancements.
  • Provided both ad-hoc and structured training to users on an ongoing basis.

Confidential, Novato, CA

IT Specialist - Hyperion Essbase / Planning Consultant

Environment: Hyperion Essbase 9.3/7.1.3, Hyperion Planning 9.3/4.0.1, Hyperion Reports 9.3/7xHyperion Essbase Excel Add-in, Hyperion Analyzer, Oracle Hyperion System 9.3/9.2 (Hyperion Essbase, Planning & Reports ), IBM DB2, Mainframe OS/390,Windows 2003, IBM AIX, IBM Websphere.

Responsibilities:

  • Involved in customization and maintenance of the Budget Data Outline Structure (Hyperion Essbase Cubes).
  • Developed scripts to process budget data through Hyperion calculation scripts (complex scripts).
  • Involved in customization of budget reports and maintained these reports through Hyperion Reports tool (AIX Web server).
  • Installation and Configuration of Hyperion Essbase 9x, Essbase Administration Services, Hyperion Planning, Hyperion Reports, Shared Services and Essbase Excel add-in for various environments.
  • Involved in Development and performance-tuning with Hyperion Analytic Services (Essbase) multidimensional databases including Outline, Rule Files, Calc Scripts, Reports, database optimization.
  • Maintain Hyperion servers, create batch files and Maxl scripts to automate the data load process, Dimension Building, calculations and back ups.
  • Monitors system and database access, performance, resource utilization and tune database performance.
  • Perform accurate analysis and effective diagnosis of client issues and manage day-to-day client relationships at peer client levels.
  • Involved in analyzing the client's requirements and develop budget reports through Hyperion Planning & Reports.
  • Provide Hyperion Security to all the Business Users based on their specific access permissions through Hyperion Planning and Shared Services.
  • Ability to extract and post budget data from and to Peoplesoft General Ledger.
  • Involved in the process of updation of budget data through Excel add-in Hyperion lock/send.
  • Developed and maintained all kinds of business critical and complex reports as per business requirements.
  • Involved in the System Administration of different servers integrated with Hyperion servers, by testing the servers during patchwork on these servers with latest versions.
  • Involved in defining requirements, functional specifications, designing documentations and testing strategies.
  • Provided Production support to existing cubes.
  • Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions.
  • Created, modified, and supported Essbase calculation scripts and report scripts.
  • Implemented Quality standards on the application and ensure the team follows these procedures to meet the quality goals and deliver the work requests as per schedule.
  • Interact with Customers to determine their needs, gather and Document Requirements, communicate with customers throughout the development project.
  • Develop Project Plans, Track Project Execution, Manage changes, develop and execute Implementation Plans as per quality standards.
  • Be the primary contact to manage Customer expectations, resolve issues, and provide project status with regard to Hyperion Essbase, Reporting changes and enhancements.
  • Provided both ad-hoc and structured training to users on an ongoing basis on the Budgeting process tools like Hyperion Reports, Essbase Excel Add-in and Hyperion Essbase.

Confidential, Sterling, VA

Cognos Developer & Support

Environment: Cognos Reportnet 1.1 - Framework Manager, Cognos Connection, Report Studio, Query Studio, Access Manager, IBM AIX, Oracle 9i, Windows NT.

Responsibilities:

  • Involved in Designing the Framework Manager Model with Physical and Business Layers includes calculated query items with all Relationships and Joins and published to Cognos Reportnet.
  • Designed Cognos Reportnet Reports satisfying the Business need.
  • Built models, packages and published them using Framework Manager.
  • Developing Standard Templates, Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using Report Studio and Query Studio.
  • Created Query Prompts, Calculations, Conditions & Filters.
  • Worked extensively on creating the model and publishing the package on cognos connection for reporting purposes.
  • Provided Report and Query Studio access to MST Super Users, Developers, and Sustain groups to continue ongoing report development
  • Developed multi layer reports providing a comprehensive and detail reports with Drill Through Functionality using Model Drill Through’s and Report Drill Throughs
  • Extensively worked on Cognos joins, Conformed Dimensions and MUN’S(Member Unique Names)
  • Developed multiple reports using various templates like list reports, cross-tab reports and chart reports
  • Developed detailed and summary reports using Report Studio.
  • Provided Security to business users by creating users, groups and based on roles as per business requirements.
  • Developed Prompt pages and Conditional Variables.
  • Scheduled and Distributed reports through Schedule Management in Cognos Connection and Maintaining Files through File Management.
  • Involved in gathering report requirements with Business Users and converted them into project documentation.

Confidential

Cognos Developer

Environment: /Software:Cognos Report Net 1.1(Query Studio, Report Studio, Framework Manager, Cognos Connection), Power Play 7.3, Transformer, Access Manager, PPES, Oracle 8i, Windows NT.

Responsibilities:

  • Involved in Developing European view of Sales reporting.
  • Involved in providing controlled access to data based on the user profile.
  • Re-defined cube structure, added dimensions and measures, multiple currencies, easy switch between currencies.
  • Involved in providing web-based access for cubes and reports.
  • Dynamic, ad-hoc query access parallel to the cubes.
  • Involved in developing easy navigation from a single screen on the web between cubes and reports.
  • Created multi-dimensional cubes (Power Cubes) using IQDs.
  • Developed Drill-Thru Reports, Drill down Reports as per the user requirement.
  • Created IQD’S using the IMR’S for Building the cubes.
  • Created various dimensions, Hierarchies and measures as per the requirement.
  • Developed Models using Transformer and thus created Cognos Power Cubes to move the relative data mart into power cubes.
  • Created Folders and made entries in PPES, to record the Reports and Cubes.
  • Developed Ad hoc and canned reports using Cognos Report Studio, Query Studio and Cognos Power Play.
  • Developed drill through reports for drilling through from PowerPlay Cubes to ReportNet reports
  • Created Dashboards in Report Studio involving a mixture of data coming from both the relational database and PowerPlay cubes.
  • Involved in Cognos administration activities like creating and maintaining user groups, exporting cubes, packages and reports from Dev to Prod environments, scheduling cube builds, publishing the cubes on PowerPlay enterprise server, scheduling reports etc.
  • Involved in creating Packages using Framework Manager and published to Report Author.
  • Created Reports (List, Cross tab, Chart, Templates).
  • Using filters in List and Cross Tab Reports.
  • Involved in generating Adhoc Reports using Query Studio.
  • Involved in implementation of test cases.
  • Involved in the documentation of business requirements as per quality standards.

Confidential

Hyperion Essbase Developer

Environment: Hyperion Essbase 6.5, Hyperion Essbase Excel-Addin 6.5, Alpha Blox, Oracle 8i, Teradata, Windows NT, Unix.

Responsibilities:

  • Involved in the Requirements and Analysing Phase along with the team.
  • Involved in Building Outlines based on the business requirement.
  • Involved in creating Rule files to build dimensions dynamically.
  • Used Esscmd Interface for Building Outlines and Load Data.
  • Involved in creating Data Loads to load the data in the cube.
  • Created various Calculation Scripts for the Cubes.
  • Involved in Client Interaction and co-ordination with the team.
  • Involved in testing the Cubes and documenting the results.
  • Generating Reports through Essbase Excel Add-in and Report Scripts.
  • Involved in Documentation required to knowledge transfer for the users and for the administration and support.

Confidential, NJ

Cognos Developer

Environment: Unix, Oracle 8i, Cognos Impromptu Administrator 6.0, Upfront, Power Play 6.6(Transformer, PowerPlay for Windows, Access Manager), IWR, Windows NT.

Responsibilities:

  • Created Dimensions, Hierarchies and Measures as per the business requirements.
  • Involved in created multi-dimensional cubes (Power Cubes) using the IQD’s.
  • Created Cross-Tab, Sub-reports in Impromptu with Summaries, Drill-through and various filter conditions and prompt features to make report user-friendly.
  • Developed data-reporting infrastructure and created Impromptu catalog and Hotfiles for reporting and decision-support purposes.
  • Created User Profiles and provided User privileges in Catalog for security.
  • Involved in Troubleshooting the Impromptu Web Reports.
  • Responsible for improving cube performance and report response time.
  • Created catalogs as per the business requirement.
  • Created various joins, calculations, conditions and filters.
  • Customized data by adding Filter, Prompts, Calculations, Summaries and Functions.
  • Generated different types of reports basing on the catalog using impromptu.
  • Created various Drill-Thru reports.
  • Created various Impromptu Web Reports (IWR’S).
  • Involved in publishing the reports and cubes to Upfront.
  • Created user accounts, giving them privileges to view the cubes as per the User.
  • Created folders and made entries in PPES, to record the reports and cubes.
  • Involved in Migration of Models and Cubes to production.
  • Worked on Access Manager for providing security to Cognos Applications by creating Users and User Classes.
  • Involved in Installation, configuration and troubleshooting support, and maintenance of client-based Impromptu, PowerPlay, Transformer, Access Manager.

Confidential

Informatica Developer

Environment: Windows NT,Oracle 8i, MS-SQL Server, Informatica Power mart 4.7(Power Mart Designer, Repository Manager, Server Manager).

Responsibilities:

  • Used ETL, Informatica to load data fro MS sql server, Flat Files into the target Oracle database.
  • Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
  • Most of the transformations were used like the Source qualifier, Aggregators, Connected & unconnected lookups, Filters & Sequence for transforming Data as per user requirement.
  • Involved in creating the mappings in Informatica to Extract, Transform & Loading of the Data to various data marts
  • Responsible in maintaining & loading the files into the data warehouse.
  • Developed various transformations like joiner, Expression, Filter, Normalizer, Router, Union & Lookup Transformations.
  • Involved in creating star schema design.
  • Created Dimensions, Fact tables and hierarchies.
  • Involved in testing the mappings.
  • Schedule the mapping and populate the data warehouse system.

Confidential

Application Developer

Environment: Windows 2000, Oracle 7.3, Visual Basic 6.0, Seagate Crystal Reports 7.0.

Responsibilities:

  • Involved in the analysis of the system.
  • Designed database for Functional groups of the system.
  • Developed the user interface using Visual Basic 6.0.
  • Created Various Forms using Visual Basic 6.0.
  • Designed and Developed Database using Oracle 7.3.
  • Created Reports using Crystal reports.
  • Involved in database design, creating tables, forms using VB, modules and reports.
  • Involved in the documentation with team coordination.
  • As a Team Member worked with the Team and Designed database for the Account Module of the system.

We'd love your feedback!