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.
  • Experience in developing PL/SQL database stored procedures, packages and triggers to handle complicated business logic for Warehouse Product Database.
  • 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:

Business Intelligence: Cognos 10.2, 10.1, Cognos 8 BI (8.4, 8.3, 8.2, 8.1), Cognos Series 7, Report Net 1.1

OLAP Tools: Cognos Tools (Transformer, COGNOS Script Editor, Scheduler, Notice Cast)

Programming: C, C++, HTML, XML, SQL, PL/SQL, SAS (Basic)

Databases: Oracle 11g/10g/9i, MS SQL Server2005/2008, MS Access

Environment: DTS, SSIS, SSRS, SSAS, COGNOS

Office Tools: Microsoft Office 2003/2007/2010

Operating Systems: Windows 98/ 2000/ XP & UNIX

Database Tools: TOAD, SQL PLUS, Oracle developer, DB2, Teradata

EXPERIENCE:

Confidential, El Segundo, CA 

Sr. Cognos Developer,

  • Gathered reporting requirements from Business and created technical specification.
  • Involved in Framework manger model design.
  • Worked on Cognos10.2 to develop the user required reports.
  • 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.
  • Worked on Framework Manager Voyager model for adding the new tables and updating the query subjects and published to Dev.
  • Involved in intensive end user training (business users in Report studio and Query studio) with excellent documentation support.

Environments: Cognos 10.2, 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.
  • Performance tune the complex reports for better performance after migrating them to 10 series.
  • Maintenance activities involve Server monitoring, health check status of the environments.
  • Coordinate with vendor for issue resolution.
  • Migrated complete content store from Cognos 8.3 to Cognos 8.4 and to Cognos 10.1 tested reports in different Versions.
  • Developed 40 reports as part of Red Project where reports of 3 Heritages and different LOB’s are involved.
  • Created various report types like list reports, cross tab, charts and dashboards that cover the entire range of enterprise reporting requirements.
  • Developed some BIA reports to test the functionality of Cognos 10.1 BIA.
  • 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 Blade logic, Autosys.

Confidential, Horsham, PA

Sr. Cognos Developer

  • Developed various complex, advanced reports with drill down, slice and dice capabilities using Analysis Studio.
  • Designed models using Framework Manager and deployed packages to the Cognos8 server.
  • 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.
  • Developed complex reports-Conditional Block Reports, Drill-Through Reports, Dashboard Reports, Master-Detail Reports, Burst reports, Dynamic sorting reports using Report Studio.
  • 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.
  • Created various report types like list reports, cross tab, charts and trend reports that cover the entire range of enterprise reporting requirements.
  • Used various functionalities in report studio like drill troughs, conditional formatting, parameter displays, conditional blocks, rendering variables.
  • 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 Info view 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.
  • Created Models and Packages using Cognos Framework Manager and published packages to Cognos Connection.
  • 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.
  • Created folders, filters, prompts, and complex calculations in Framework Manager.
  • 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.
  • Extensively used Cognos 8.2 features like Conditional Blocks, Bookmarks, Conditional Formatting, HTML, Cascading Prompts and Tree Prompts
  • Good knowledge in Agile Project Management Methodologies since Confidential Bank 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, Riverwoods, 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.
  • Provided security to the Cognos 8.3 in Access Manager through LDAP Server.
  • Created IQD’s out of framework manager for Power Play Cubes.
  • Created training guides for different projects to efficiently use Power Play Cubes, reports and Report.Net Reports, Cognos 8.3 Query studio and Report studio.
  • Created list reports, cross tab reports, chart reports, master detail reports, drill through reports and reports with lot of conditional formatting using Report Studio.
  • Administration involved Installation and configuration of COGNOS servers, implementing security, managing users, user groups and roles in the organization.
  • 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, San Francisco, 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.
  • Conducted hands on Cognos 8 open lab where customers come in with their questions and we work with them 1 on 1 directly in Cognos Connection.
  • Opened many cases to solve issues like Cognos 8 Quality environment security wiping out, Cognos 8 moving packages to different environments.
  • Built Report.Net packages for many daily and monthly usage reports using Framework Manager 1.1 MR1 and Cognos 8, for different projects.
  • 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,, Oracle9iand Windows 2003 Server.

Confidential

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.
  • Created Multi-Dimensional Cubes and Reports as per the User Requirements.
  • Installed Cognos Power Play Transformer for Client, Cognos PowerPlay Server.
  • 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.

Hire Now