We provide IT Staff Augmentation Services!

Senior Cognos Developer Resume

Hershey, PA

Career Summary

  • 8 years of IT experience including over 7 years in Enterprise Business Intelligence lifecycle implementation and Cognos BI tools.
  • Experienced in the design, build, maintenance, requirement gathering, report design, implementation and training.
  • Experienced in Cognos Series 8 Installation and Administration.
  • Expertise in building Models and Packages in Framework Manager and publishing those packages to the Cognos Connection.
  • Expertise in working with Report Studio, Analysis Studio, Event Studio, Metric Studio and Query Studio for Report Design in Cognos Suite.
  • Strong experience as a Reports Author with experience in gathering requirements, assessing, developing project designs, tests, research and data analysis.
  • Extensively worked on designing and building cubes in Powerplay Transformer.
  • Experience in performing administrative roles in Cognos Suite of products.
  • Expertise in Migration of the applications from Cognos Series 7 and ReportNet to Cognos 8BI.
  • Well versed in using Reporting Applications employing Impromptu, Cognos ReportNet and components like Framework Manager, Report Studio and Query Studio.
  • Worked with Relational Databases: Oracle, MS SQL Server, Teradata and DB2.
  • Expertise in creating and modifying tables in the Oracle database.
  • Expertise in SQL and Oracle PL/SQL in creating complex queries, functions and stored procedures required for the reports.
  • Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions.
  • Extensive exposure to various businesses spanning over spectrum of business sectors such as Finance and Insurance.
  • Proficient in all phases of Data Warehousing Concepts, and experienced in dimensional modeling and relational modeling in Star Schema and Snow-flake Schemas.
  • Proficient in Data Warehousing Concepts using Informatica Power Center, Power Mart, Repository Manager, Designer, Workflow Manager.
  • Expertise in SQL and Oracle PL/SQL in creating complex queries, functions and stored procedures required for reports.
  • Experienced in working with Software Development Life Cycle and implementation methods.
  • Proficient with accessing data in TOAD, implementing data solutions utilizing PL/SQL.
  • Strong Experience using SQL in development of reports, analyzing data in tables, cardinality between tables and joining tables.
  • Proficient in developing and executing test plans based on system and validation requirements.
  • Self-motivated with positive attitude, enjoy working in a technically challenging environment.
  • Good communication and interpersonal skills: a quick learner and a team player.

Technical Skills

OLAP/BI Tool : Cognos10 and 8 BI ( Framework manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Connection, Powerplay Transformer), Cognos ReportNet 1.1/1.02, Cognos Impromptu Administrator 6.x/7.x, Cognos PowerPlay 6.x/7.x, Transformer, Access Manager
Operating Systems : Windows 98, Windows2000 and WindowsXP, UNIX
Database : Oracle 8i/9i/10g, SQL Server 2000/2005/2008, MS-Access, DB2, Teradata
Languages : C, C++, SQL, PL/SQL, HTML, XML, JAVA
Software : Word, Excel, PowerPoint, Outlook, Adobe Photoshop

Professional Experience

Confidential, Hershey, PA May 11 - Present
Senior Cognos Developer

Confidential is the largest North American firm of chocolate and sugar confectionery products. Developed reports for the APO Team using information stored in Teradata, which helped in demand planning and forecasting of products. Using carrier modes, carrier freights created reports that way helped users and warehouse contacts to schedule deliveries including delivery time and delivery stop times.

Responsibilities and Deliverables:

  • Gathered, analyzed and documented the design and development requirements for reporting using Cognos Framework.
  • Created different packages and models in Framework manager based on the requirements and published them to Cognos Connection.
  • Developed cubes in Powerplay transformer and scheduled the cube build daily to update the cube.
  • Created burst reports and made them available to appropriate users resulting in saving lot of time and effort.
  • Developed List Reports, Crosstab Reports, Charts, Repeaters, Complex Dash Board reports, Master Detail Drill Through reports, Drill thru reports, multiple prompt page reports, Table of Index Reports, Page break reports in Report Studio.
  • Created and modified database tables and views in Oracle database.
  • Written stored procedures required to load the data into the oracle database and written complex queries, functions and stored procedures required for the reporting purposes.
  • Effectively used Event Studio to monitor the data and perform tasks when the data meets predefined Thresholds.
  • Created User Groups and Roles in Cognos connection to assign security for different cognos projects.
  • Scheduled and Distributed reports using Schedule Management tool in Cognos Connection.

Environment: Cognos Series10, Cognos 8.4, Framework Manager, Cognos Powerplay Transformer, Cognos Connection, JavaScript, Oracle 11g, DB2, Microsoft SQL Server 2008, Toad.

Confidential, Miami, FL January 2009 - April 2011
Senior Cognos Developer/Administrator

The Project was to develop an automated process for daily extraction of End to End Right First Time, AMX and Customer Metrics from different sources such as CLFYRPT, OFS, Intergate, OTAPRD, etc. Also, these are to be presented in a professional manner by utilizing Cognos tools like Framework Manager, Report Studio, Metrics Designer and Metrics Studio.

Responsibilities and Deliverables:

  • Created and modified database tables and views in Oracle database.
  • Written stored procedures required to load the data into the oracle database and written complex queries, functions and stored procedures required for the reporting purposes.
  • Written stored procedures required to load and modify the data in the oracle database.
  • Developed PL/SQL Procedures, Functions and Packages in the oracle database.
  • Created different packages and models in Framework Manager based on the requirements and published them to Cognos Connection.
  • Implemented package level, object level and data level securities in Framework Manager.
  • Created burst reports and made them available to appropriate users resulting in saving lot of time and effort.
  • Developed List Reports, Crosstab Reports, Charts, Dash Board reports, Drill Thru reports, and multiple prompt reports in Report Studio.
  • Developed cubes in Powerplay Transformer and scheduled the cube build daily to update the cube.
  • Developed Scorecards in Metric Studio.
  • Effectively used Performance Tuning and Bursting reports.
  • Created User Groups and Roles in Cognos connection to assign security for different cognos projects.
  • Scheduled and Distributed reports using Schedule Management in Cognos Connection.
  • Prepared user and technical documentation and provided end-user training.

Environment: Cognos Series 8 (version 8.4), Framework Manager, Powerplay Transformer, Cognos Connection, JavaScript, Oracle 10g, SQL Server 2005/2008, DB2, Toad, SQL Plus, SQL Server Management Studio, SQL Loader.

Confidential, Sunnyvale, CA December 2007 - December 2008
Senior Cognos Consultant

Confidential, commonly known as NetApp, is a network storage and data management company headquartered in Sunnyvale, California. NetApp is the leader in advanced networked storage solutions. It provides an integrated solution that enables storage, delivery and management of network data. It is a member of the NASDAQ-100 and ranks on the Fortune 1000. Confidential is credited with the widespread adoption of Network Attached Storage or "NAS". This is a type of disk storage where the Storage Array, owns and controls the Filesystem and then present files and directories to hosts.

Responsibilities and Deliverables:

  • Installation and Configuration of Cognos 8 on Windows NT.
  • Created different data sources which in turn were used for creating different packages and models.
  • Created and published several packages in Framework Manager using star schema and defining layers in Framework Manager.
  • Involved in business requirement gathering by interacting with business users.
  • Designed and built multi-dimensional power cubes using transformer.
  • Created a multi-dimensional package from the cube and published it on to Cognos Connection.
  • Using the cube as data source, created different types of reports and graphs in Report Studio.
  • Worked on some of the existing reports to decrease the run time.
  • Created List, Crosstab and Chart Reports and also enabled Drill-Down and Drill-Up in Report Studio.
  • Migrated more than 200 reportsfrom Impromptu to Cognos Series 8.
  • Developed Dashboards and applied Drill-Through to them.
  • Created and modified database tables and views in Oracle database.
  • Written stored procedures required to load and modify the data in the oracle database.
  • Provided documentationto the end users and conducted training workshops.
  • Performed user acceptance tests and made sure that each report is approved.

Environment: Cognos 8 (Framework Manager, Query Studio, Report Studio, Deployment Manager), Impromptu, Cognos Transformer 7.0, Informatica power center, Designer, Workflow manager, Toad, Oracle 9i, Cognos Connection, Windows NT/2000, MDX.

Confidential, San Francisco, CA February 2006 - November 2007
Senior Cognos Developer/Analyst

Confidential is the largest national, multilane insurance corporation. Confidentialprovides insurance to its customers in various lines such as Private passenger automobile insurance, Homeowners insurance, individual life insurance, Tax-qualified annuities and life insurance, Group life and disability insurance with various lines in each sector.

Responsibilities and Deliverables:

  • Assisted System Administrators in Cognos Migration from Series 7 to 8 and installed Software Updates.
  • Involved in data gathering and developing models in Framework Manager and publishing the packages onto Cognos Connection.
  • Implemented Package level security and object level security in Framework Manager.
  • Created different filters and calculations in Framework Manager that can be used effectively while reporting.
  • Created packages using multiple data sources in the framework manager.
  • Provided object level and data level security for the packages using framework manager.
  • Created Simple List reports, Cross-tab reports, Conditional formatting and Drill-Through Reports using Report Studio.
  • Created burst reports and made them available to appropriate users resulting in saving lot of time and effort.
  • Worked using OLAP tool, Powerplay for building cubes and reports that meet the business requirements.
  • Strong experience in MS SQL and Oracle PL/SQL in creating complex queries, functions and stored procedures required for reports.
  • Optimized cubes by selecting appropriate methods, which include partitioning, time-based partitioning, cube groups and incremental updates.
  • Involved in Cognos Decision Stream ETL (Extraction, Transformation and Load) process.
  • Effectively used Schedule Management Tool.
  • Tuned transformer models for faster cube builds and access times.
  • Provided documentation to the end users and conducted training workshops.

Environment: Cognos 8 (Framework Manager, Query Studio, Report Studio, Deployment Manager), Cognos Transformer 7.0, Informatica power center, Designer, Workflow manager, Toad, Oracle 9i, Cognos Connection, Windows NT/2000.

Confidential, Riverwoods, IL Feburary 2005 - January 2006
Cognos Developer

Confidential, a business unit of Morgan Stanley, operates the Discover Card brands including the Discover Classic Card, the Discover Gold Card, the Discover Platinum Card, the Miles Card from Discover Card and an array of affinity cards. This project was to assist the Marketing departments to understand the spending patterns of the customers and to improve the success rate of marketing campaigns by generating and using more accurate and up-to-date customer lists.

Responsibilities and Deliverables:

  • Gathered reporting requirements from Business Users.
  • Incorporate business logic in models by using available features of Framework Manager.
  • Performed modeling of metadata from scratch in Framework Manager.
  • Creation/ Modification of reports based on the business requests sent by the client.
  • Built multi-dimensional power cubes using Power play Transformer by using IQD as a Data Source.
  • Published various packages to Cognos Connection in order to use for Query Studio for creating ad-hoc reports and Report Studio for developing the advanced reports.
  • Developed Standard Templates, Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting Reports using Report Studio and Query Studio.
  • Extensively worked on building Transformer Models - dimension hierarchy, drill-down.
  • Performed optimization on the existing reports to decrease the run time to meet the real time requirements and made changes to the existing reports for good look and feel for the users.
  • Used SQL navigator in the project and created necessary views required to meet the report requirements (if necessary).
  • Performed user acceptance tests and made sure that each report is approved.
  • Provided support and troubleshot problems as required.

Environment: Cognos ReportNet 1.01/1.1, (Framework Manager, Query Studio, Report Studio), Oracle 8i.

Confidential, India March 2004 - January 2005
Programmer

Confidential is one of the largest engineering and manufacturing enterprises in India is ranked among the leading Power Plant Manufacturers in the world. Confidential has 14 manufacturing plants and number of service centers spread all over the country and abroad.

Responsibilities and Deliverables:

  • Worked with a group to implement E-R model that is used to maintain the pay role checks and employees information.
  • Had good understanding of E-R model in real time environment and was also responsible for report design.
  • Determined different types of joins required between tables and specified cardinalities required for generating meaningful relationships.
  • Used JDBC to create user interface with predetermined functions.
  • Used SQL * Plus extensively and generated a relational tables.
  • Created various forms for the users to enter, maintain and process the data.

Environment: Oracle 8, Forms 4.5, Reports 2.5 and Windows 98, UNIX.

Education

  • Bachelor of Technology.

Hire Now