We provide IT Staff Augmentation Services!

Cognos Developer Resume

Dallas, TX

Sr. Cognos BI Consultant

SUMMARY

  • Around 8 years of IT experience in Software Application Design, Development, Testing, Documentation and Maintenance of Business Intelligence solutions, OLAP tools, Data Warehousing (DW), Database, Client/Server and Web based applications as Cognos BI/TM1 developer.
  • Received outstanding award for the contribution in 2012 at Confidential .
  • Experience in various COGNOS Tools –BI Cognos 10.1/8.4/8.3 / 8.2 / 8.1 ,.I Suite includes Report Studio, Analysis Studio, Query Studio, Cognos Connection, Impromptu, IWR, Power Play Transformer and Power Play Tools, Business Insight, Business Insight advance, Active Reports.
  • Sound Skills in Report Authoring in Report Studio – Custom Functionality in prompt page and Report Page using JavaScript in HTML ITEMS and Conditional Blocks to develop Hide and Show scenarios
  • Designed & Developed TM1 Processes, Dimensions, Cubes and Applications.
  • Extensively worked on COGNOS 10 Framework Manager – Creating Models in Framework Manager – Importing Meta Data from Different Sources, Dimension Hierarchy, Star Schema Grouping, and Packages
  • Extensively worked on Power Play Transformer - designing and building the Power play cubes using Transformer and developing the dashboard reports by using cube as data source.
  • Expert skills in developing complex reports using SQL, Co-related Queries, Sub Queries and Nested Sub Queries in Report Studio.
  • Expert in developing procedures in PL/SQL and T-SQL
  • Good experience on ETL tools like Informatica and SSIS.
  • Developed complex layouts using List, Cross tabs and Chart reports using Master-detailed relationships and Drill-through functionality.
  • Having good exposure in Data ware house Architecture, OLAP Technologies, knowledge in OLTP System Study, Database Schemas like Star schema and Snowflake schema used in relational and dimensional modeling.
  • Expereince in various database systems like Oracle, SQL Server and Teradata.
  • Expertise in installation and configuration of Cognos 10 Business Intelligence.
  • Experience and expertise in understanding existing business processes, data analysis requirements, business systems analysis and design, converting requirements specifications into detail reporting specifications.
  • Excellent troubleshooting /problem solving skills, ability to Mentor and desire to achieve the target
  • Excellent communication skills, Quick Learner, Highly motivated and hardworking IT savvy.

TECHNICAL SKILLS:

BI (OLAP) Tools: COGNOS TM1 8.2/8.4/10 BI Suite(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Designer, Metric Studio, COGNOS Connection), COGNOS Content store, LDAP Server, SDK,

Databases: Oracle 11g/10g/9i/8i/7.x, SQL Server 2000/2005,Teradata, DB2, Sybase, MS Access

Programming Skills: C, C++, Java, VB.Net, Java Script

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Cognos Developer

Responsibilities:

  • Provided BI solutions across all areas of Cognos support, design and development of BI applications and Data Warehouse projects.
  • Actively participated in requirements session with product line management to understand Reports requirements on Cloud and Mobility packages.
  • Imported metadata from various data sources such as SQL Server, Oracle and Teradata and created Cognos Framework Manager Models and published packages into the portal.
  • Used various framework manager features to create Dimension Hierarchy, Star Schema Grouping and applied security, filters and calculations accordingly
  • Created Lists, Groups and Cross-tab reports with Drill-through functionality using multiple queries in a single report and Customized the same using java script to extend the prompt functionality.
  • Created reports by using Query Calculations, Layout Calculations, Text items, Crosstab Space with Text and Images.
  • Developed dashboards for executives using Business Insight using portlets and applied global filters.
  • Created Multi-dimensional reports by implementing Multi-Dimensional Cubes using Power Play and Transformer.
  • Provided security for Cubes of various User classes. Used Date Wizard to create time dimension in Transformer for creating cubes and Power Play reports.
  • Preparing documents for the integration of TM1 and Cognos BI, and shared to onsite and offshore team.
  • Created a project plan and made team to working accordingly to reach the goal on time.
  • Involved in developing TM1 input page in .ASPX and understanding the Code behind it.
  • Developed a Java Script to pull the TM1 input Page to Cognos and also java script for handshaking of TM1 and Cognos BI.
  • Validating data and Comparing in TM1 prospective excel and in TM1 web with Cognos Report Studio.
  • Solved most of the Complex part in TM1 and Cognos BI integration.
  • Training resources on TM1 and Cognos.
  • Created most of the Documents like Technical Document, LLD, TM1 and BI integration document, Work flow Document, Project Plan, Document on report format and Standards etc.
  • Developed most of the reports along with the team, made them understand the requirements and deliverables.
  • Handled Critical situations in QA and Production Support in the final Stages of the project
  • Managed and designed the Cognos BI and TM1 integration for reporting and analysis.
  • Responsible for conducting pre sales presentations before C-level executives and winning an account
  • Created a project plan and made team to working accordingly to reach the goal on time.
  • Involved in developing TM1 input page in .ASPX and understanding the Code behind it.
  • Developed a Java Script to pull the TM1 input Page to Cognos and also java script for handshaking of TM1 and Cognos BI.
  • Validating data and Comparing in TM1 prospective excel and in TM1 web with Cognos Report Studio.
  • Solved most of the Complex part in TM1 and Cognos BI integration.
  • Built Power Play (Multi –Dimensional) Reports in Report Studio by replicating the power play functionality in Report Studio using dynamic Measure selection, Dynamic Sorting, ranking.
  • Scheduled and distributed reports using Schedule Management In Cognos connection.
  • Used Informatica PowerCenter to extract data from various data sources to Teradata and Oracle for reporting needs.
  • Used PL/SQL to load data from flat files from Mobility Order team to Oracle database for generating reports.
  • Testing the reports for data accuracy, formatting and performance.
  • Trained and supported Cognos end users (information consumers and power users) on basic navigation in Cognos Connection, Business Insight Advanced, and report/package usage based on business requirements.

Environment: Cognos BI 10.1/10.1.1/8.4 (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer, TM1, BIA, Business Insight and Event Studio), javascript, Informatica 8.6.1, SQL Server 2008, and Windows server, Cognos TM1.

Confidential, Dallas TX

Cognos Developer

Responsibilities:

  • Managed the Cognos Planning and TM1 project as IBM Cognos implementation methodologies standards.
  • Used Cognos Business Intelligence suite for sales reporting and analysis.
  • Performed ETL for Integration of internal and external data of related products to get market analysis and share.
  • Developed Dashboard for sales rep’s individual business data, sales and market share in the different territories, as well as their sales targets using Cognos Business Insight.
  • Designed and implemented the regional marketing managers’ dashboards to present an overview of all sales reps in their region and their target to meet expectations.
  • Used Framework manager security to restrict viewing of sales performance to regional managers.
  • Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
  • Involved in setting up the Cognos 8 BI environment to Client locations.
  • Administer user access protocols and manage user accounts and access privileges.
  • Used Windows Scheduler and VB Script to automate cube builds and report refresh.
  • Used Cognos 8 BI Framework Manager in building the Models, Cubes using different data sources.
  • Designed functional solution for planning applications in TM1 financial performance management environment.
  • Developed and implemented the best practices in designing and development for TM1 financial planning applications.
  • Led the TM1 proven solutions in business process, performance improvement, and system implementation.
  • Designed and implemented TM1 architecture for the corporate planning system and applications.
  • Migrated EP planning models and applications to new Cognos TM1 system.
  • Developed and maintained the planning models in TM1 environment.
  • Managed the on-site and offshore team and developed client relationship through all phase of the implementation cycle.
  • Managed the change and control process in the financial planning solution design and architecture
  • Developed traffic-light functions, particularly valuable as signals so that user can get the analysis quicker.
  • Created List Reports, Cross-tab Reports, Chart Reports, Repeaters, and Master Detail Reports using Report Studio.
  • Created Query Prompts, Calculations, Conditions and Filters in the reports.
  • Developed Prompt Pages and Cascaded input Prompts to display only the selected entries in the report.
  • Used SSIS extensively to extract load data from various data sources.
  • Migrated several existing Cognos Impromptu Catalogs into XML files and imported the xml files as data sources into Cognos ReportNet.
  • Closely involved in security administration using Series 7 for the Cognos ReportNet reports.
  • Closely worked with ETL team to design data marts by understanding user requirements and increasing the reporting efficiency.

Environment: Cognos 10/8.2 BI (Frame work Manager, Analysis Studio, Event Studio, Report Studio, Query Studio), COGNOS ReportNet1.1 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Cognos Series 7 Version 3 (Impromptu Administrator, IWR, PowerPlay, Transformer, PowerPlay Enterprise Server, PowerPlay Web, Access Manager, Upfront), Access Manager, Oracle Migration Utility, Oracle9i/10g, SQL Server, SSIS, TOAD 9.0, LDAP, IIS and Windows 2003 Server, Cognos TM1.

Confidential, Dallas

SQL/ Cognos Developer

Responsibilities:

  • Involved in designing, implementing and maintaining Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views and complex SQL and T-SQL procedures.
  • Identified the dimension, fact tables dimension, fact tables and designed the data warehouse using star schemas.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files
  • Migrated data from different sources (text based files, Excel spreadsheets) to SQL Server databases using SQL Server Integration Services (SSIS).
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Quickly learnt Installed Cognos suite of products and implemented reports on Connect clients usage.
  • Built interactive reports by applying HTML/Java Script reporting techniques for dynamic presentation of data.
  • Developed multiple report types including List, Crosstab, and Chart, and features such as cascading prompts, dashboards, drill through, conditional blocks, conditional variables, date range buckets, date conversions, and weekly, monthly and yearly aggregations and scheduling as per functional requirements.
  • Developed Trade summary reports using Impromptu Web Reports
  • Troubleshooted and fixed Cognos production report, cube and data issues based on priority.
  • Worked closely with business leaders, data modelers and data warehouse developers to ensure consistent and accurate reporting across the business.
  • Developed metadata/packages in Framework manager for new projects on a multi server environment based on technical specification.
  • Tuned reports and queries for performance when needed.
  • Provided documentation, training users and Business Partners on Cognos BI reporting tool.

Environment: SQL Server, SSIS, SSRS, Cognos 8.2 BI (Frame work Manager, Analysis Studio, Event Studio, Report Studio, Query Studio, Cognos Connection), Cognos Series 7 Version 4 (PowerPlay Transformer, PowerPlay Enterprise Server), Java Script

Confidential, Los Angeles-CA

Responsibilities:

  • Worked with Cognos 8.1 during this requirement because Capital One was migrating Impromptu Catalogs to Cognos 8.1 and PowerPlay cubes to Cognos 8.1
  • Worked extensively on creating the Model and publishing the package on Cognos Connection for future reporting.
  • Designed and developed the Cognos 8.1 Framework Manager Metadata Model using PowerPlay cubes, Impromptu Catalogs as Data Sources to accommodate future growth in reporting requirements.
  • Single Handedly Migrated cubes and Impromptu Catalogs from Series 7 to Cognos 8.1 MR1.
  • Created cube model packages in FrameWork Manager. A folder structure is used to group the cubes of the same nature in Upfront.
  • Optimized the cubes and set up Framework Manger model so that the cubes can be used in Analysis Studio and Report Studio.
  • Gathered the requirements from Business Users and created the reports based on those requirements in Analysis Studio as well as in Report Studio.
  • Upgraded Reportnet to Cognos 8.1 to get the required results as per the client requirement.
  • Designed, developed, Tested and improved Report Performance.
  • Created reports using cube views in production Series 7 in the Upfront folder.
  • Trained Business users in Analysis Studio.
  • Created reports by using data from various data marts created by DataStage jobs.
  • Created Frame Work Manager Models using PL/SQL stored Procedures.
  • Migrated ReportNet 1.1 MR1 package on to Cognos 8.1
  • Created Dashboards in Cognos 8 BI to communicate complex information quickly.

Environment: Cognos 8.1 BI, Analysis Studio, Event Studio, Framework Manager, Metrics Studio, Cognos Connection, Report Studio, Query Studio, Upfront, Cognos 7 series Impromptu, PowerPlay, IWR, Cognos

Hire Now