We provide IT Staff Augmentation Services!

Sr. Cognos Developer Resume

El Segundo, CA

SUMMARY:

  • Over 8 years of IT experience in Data warehousing and Business Intelligence projects in multiple capacities including, Technology Administrator, Developer and Designer.
  • Strong experience in Cognos 8.x, Cognos 10.1.1 including Framework Manager. Experience in Migration from Cognos 8.2 to 8.3 and Cognos 8.4 to Cognos 10.1.1.
  • Excellent experience in designing the Star and snowflake models for Data Warehouse.
  • Reporting exposure includes development as well as maintenance of report in different Cognos versions.
  • Excellent analysis, troubleshooting, communication, planning, coordination and documentation capabilities.
  • Install and configured IBM Cognos 10.1.1 software on servers (multiple environments).
  • Interacted with various levels of staff across multiple departments, Domestic and International, to provide Cognos BI System Support and Development services.
  • Experience in designing automated processes to replace repeated manual processes.
  • Experienced with full life cycle Methodology for implementing Data warehouse and Business Intelligence Reporting system.
  • Self - motivated and possesses ability for critical thinking, analysis, good interpersonal and communication skills. Technically motivated and creative and User oriented with a desire to learn client's business requirements.
  • Excellent communication skills, management and leadership qualities.

Technical Skills:OLAP/DSS Tools: Cognos BI 8.x(Administration and Security, Report Studio, Query Studio, Analysis Studio) Cognos BI 10.1.1(Administration and Security, Report Studio, Query Studio, Analysis Studio, Event Studio, Dashboard)

Methodology: Star Schema, Snowflake Schema

Databases: Oracle 11g/10g/9x, IBM DB2 9.5, MS SQL Server 2000/7.0/6.5 , MS Access, IBM Netezza 7.0

Tools: TOAD Data Modeler 2.25, SQL*Plus, SQL* Loader, BMC BladeLogic, Autosys.

Languages: SQL, PL/SQL, HTML, Oracle

OS: Windows 7/2008/2003

Servers: Internet Information Server, Active Directory Server, LDAP

Professional Experience:

Confidential, El Segundo, CA

Sr. Cognos Developer

  • Gathered reporting requirements from Business and created technical specification.
  • Involved in Framework manger model design.
  • Developed U.S. Based brand scorecards using Cognos Report Studio.
  • Used List, Crosstab and Chart based report types.
  • Reports show data by retailer, by brand and by item with charts showing of Week Over Week % Change, YTD based Last 6 week’s comparison of CY and LY data.
  • Developed Conditional variables to highlight negative values.
  • Worked on Joins to combine Yearly and Weekly data.
  • Involved in Unit testing of all the reports.
  • Migrated reports and package from Dev to QA environment.
  • Developed various complex, advanced reports with drill down, slice and dice capabilities using Analysis studio.
  • Involved in intensive end user training (business users in Report studio and Query studio) with excellent documentation support.

Environments: Cognos 10.1.1, Framework Manager, Report Studio, Analysis Studio, Query Studio, IBM Netezza 7.0

Confidential, Hartford, CT

Sr. Cognos Developer

  • Enterprise Production Support for all BI tools.
  • Production support activities involving problem tickets, Incident management, root cause analysis, server maintenance.
  • Maintenance activities involve Server monitoring, health check status of the environments.
  • Coordinate with vendor for issue resolution.
  • User support activities includes user raised Incidents, service tickets, quotes related to all BI tools.
  • Used Remedy to track the status of the tickets.
  • Onshore/Offshore work allocation, prioritize the work requests.

Environment: Cognos BI 10.1.1, ­Oracle 10g/11g, LDAP, BMC Bladelogic, Autosys.

Confidential, Horsham, PA

Sr. Cognos Developer

  • Developed various complex, advanced reports with drill down, slice and dice capabilities using Analysis Studio.
  • Developed bursting models (Framework Manager) to the reports and created IQDs for Powerplay Transformer.
  • Developed metrics, scorecards and reports for the users.
  • Extensively worked on bug fixing in the reports in Cognos Report Studio.
  • Created Various Dashboards and Portal pages in Report Studio.
  • Created complex dashboards using gauges, maps, charts and other graphical elements to show multiple results together.
  • Administered changes to PowerPlay Cubes, to generate intuitive reports for better analysis.
  • Involved in intensive end user training (business users in Report studio and Query studio) with excellent documentation support.
  • Scheduled report jobs using the Cognos scheduler and performance tuned the report queries.
  • Created cubes with time, Location and Hierarchy levels for customer using Transformer. Used the Transformer models to create Power cubes and generated Powerplay reports.

Environment: Cognos BI 8.2, Cognos BI 8.4, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Framework Manager, Powerplay Transformer, Oracle 10g, LDAP.

Confidential, Phoenix, AZ

Cognos Developer

  • Creating forms and formatting them according to the user requirements.
  • Creating multi-page reports and applying page breaks to the report according to user requirements.
  • Created complex multiple Crosstab Reports.
  • Modeled the database using Framework Manager into a dimensionally modeled relational database from the relational data source.
  • Created Drill Through for the reports in Cognos 8.3.
  • Creating Master-Detail queries according to user requirements.
  • Optimized the performance of reports by modifying queries and changing the report layout.
  • Created detailed required support documents.
  • Migrated reports from Infoview refiner to Cognos 8.2/8.3 and supported the production environment.
  • Administered the servers and provided security authentication to the users.

Environment: Cognos BI 8.3, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Powerplay Transformer, DB2.

Confidential, Cleveland, OH

Cognos Developer

  • Designing framework manager model and publishing and presentation Layer, Model Query Subjects and handled the relationships between query subjects.
  • Gathering reporting requirements from LOB and converting it to technical specification for off-shore requirements.
  • Implementing Data Level Security in the framework model and Report Level Security with Users Groups.
  • Writing Complex SQL’s in Oracle as views and Stored Procedures to handle reporting needs. Creating complex reports, Drill Through reports and graphs in Report Studio.
  • Responsible for Cognos Code Moves among various environments Development QA/ Production.
  • Involved in Cube designing using Cognos Transformer and publishing cubes and designing reports using Analysis Studio.
  • Good knowledge in Agile Project Management Methodologies since Confidential had adopted it for all the projects.

Environment: Cognos BI 8.2, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Powerplay Transformer, Oracle SQL Developer, Oracle 9i.

Confidential, River woods, IL

Cognos Developer

  • Installed the required migration tools on the source computers.
  • Export the Cognos 8.3 metadata to XML format.
  • Migrated existing Cognos 8.2 reports and deployed to Cognos 8.3.
  • Created data source connections in Cognos 8.3
  • Troubleshooting and fixing problems in reports which are migrated to Cognos 8.
  • Published package from Framework Manager to Cognos Connection.
  • Created new reports using Report Studio.
  • Implemented document reports and applied page breaks to the report depending on the user requirements.

Environments: Cognos Migration tools (Impcat2XML, MigratetoC8, DeploytoC8), Cognos 8.3 Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, TOAD Data Modeler, Oracle9i.

Confidential, SanFrancisco, CA

Cognos Developer

  • Loading data from flat files to Staging area (Oracle 9i) using SQL Loader.
  • As an Administrator setup security.
  • Set up permissions to user classes, groups.
  • Defined Data Sources and their associated connections in Cognos Connection.
  • Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos connection in Cognos 8.
  • Deployed Packages from Development to QA Environment.
  • Backup Cognos 8 data including the Content Store, and Framework models.
  • Created different groups and roles and restrict them for some Reports.
  • Used Active Directory as third party authentication source.
  • Created ER modeling for Subscription DATA MART.
  • Created Data Modeling in star schema design for staging area.
  • Created Materialized views in Oracle9i.

Environments: Cognos 8, Framework Manager, Cognos Connection, Report Studio, Query Studio, Active Directory, Powerplay Transformer, TOAD Data Modeler , ,Oracle 9i and Windows 2003 Server.

Confidential,India

Cognos Developer

  • Prepared technical documents by gathering requirements from the users.
  • Set up permissions to user classes, groups.
  • Tuning performance of the poor performing Queries.
  • Defined Data Sources and their associated connections in Cognos Connection.
  • Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using ­­­­­Cognos connection in Cognos 8.
  • Deployed Packages from Development to Test Environment and to Production Environment.
  • Backup Cognos 8 data including the Content Store, and Framework models.
  • Production support and user training, assistance.
  • Starting the Cognos 8 server.

Environment: Cognos 8, Framework Manager, Cognos Connection, Report Studio, Query Studio, Oracle 9i and Windows 2003 Server.

Hire Now