Sr. Cognos Developer Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

                                          Sarah Sathi

sarah@yahoo.com                                                                                                     949-394-9876

                                                                                                                                                 

-------------------------------------------------------------------------------------------

Summary:

Ø  Nine years of IT experience with Sound knowledge and experience in different phases of software development life cycle (SDLC) including analysis, design, development, testing and production. Strong understanding of relational database design concepts and in depth knowledge of OLAP solutions Cognos 10,Cognos 8, Cognos ReportNet, Cognos Impromptu, Transformer, Power Play and Cognos Query

Ø  Including 7 years hands-on experience with the Cognos ReportNet suite (Framework Manager, Cognos Connection, Report Studio, and Query Studio) as both a developer and as an administrator.

Ø  Involved in migrating reports from ReportNet to Cognos8. Involved in a data migration process between different versions of Cognos.

Ø  Involved in migrating Catalogs, Impromptu reports from Cognos Series 7 to Cognos 8.  

Ø  Experience in designing models with Framework Manager involving Relational Models and Dimensional models.

Ø  Experience in installation and configuration of Cognos8 and Cognos ReportNet Environment.

Ø  Experience with ReportNet Software Development Kit (SDK) to customize reports.

Ø  Experience in Security Implementation in Cognos8, ReportNet, on various levels such as User level, Object Level, Row Level Security Implementation.

Ø  Developed OLAP applications using Cognos suite of tools and extracted data from the enterprise data warehouse to support the analytical and reporting for all Corporate Business Units.

Ø  Hands on experience administering, deploying and maintaining Models, Reports, and Cubes using ReportNet, Impromptu, Transformer, Power Play and PPES.

Ø  Published IWR reports and Power Play Cubes on the portal using Cognos IWR report administrator and Power Play Enterprise Server.   

Ø  Created dimension maps and multidimensional cubes using Impromptu Query Definition in Power Play Transformer.                                                                                                                                                                                                                                                                                                                                                                         

Ø  Involved in migrating Cubes, Power Play Reports from Cognos Series 7 to Cognos 8.

Ø  Developed MDX Queries, PL/SQL database stored procedures, packages and triggers to handle complicated business logic for Warehouse Product Database Administration.

Ø  Proficient in using best practices to support the reporting activities.

Ø  Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

Technical skills:

BI Tools	Cognos Business Intelligence 7.0, Impromptu 7.1/7.0/6.0, Impromptu Web Reports 7.0/6.0, Upfront, Cognos Query, Power Play Transformer 7.1/7.0/6.0, Power Play Enterprise Server, Access Manager, Cognos Visualizer , Cognos Script Editor, Cognos ReportNet 1.0.2/1.1 MR2, Cognos 8.3,  8.4 BI Series and Cognos 10.1, Cognos 10 BI Author Certified.
Languages	SQL, PL/SQL, C, C++, Oracle, Visual Basic 6.0/5.0
Data Modeling	Erwin 4.0 / 3.5
Front End	Visual Basic (6.0/5.0), HTML
Operating System	Windows 2000/ NT/ 98/ 95,MS-DOS, UNIX
Databases	Teradata ,Oracle 10g,9.x/8.x/7.x/6.x, MS SQL Server 2000/7.0/6.5
ETL Tools	Informatica 8.1 ,7.1

Education:   Bachelor of Engineering in Computer

                       University Of Ottawa, Canada, 2003

                        Certified in Cognos 10 BI Author (sr7607233)

Professional Experience

Client             : Acxiom, Conway, AR

Duration        : Nov 2010 to September  2011

Role               : Sr. Cognos Developer.

·        Worked with users, business analysts to define reporting requirements for various services and processes using Cognos 8 BI Suite (Cognos connection, Query Studio, Report studio, Analysis Studio, Event Studio and Framework Manager).

·        Used a variety of reporting packages to produce, automate, schedule, and distribute defined reports.

·        Worked on installation and configuration of Cognos V 10.1 and Cognos 8.4.

·        Created Active reports in Report Studio and Build Dashboard using Business Insight.

·        Mentor / help users with using Business Insight Advance to create Ad hoc reports.

·        Built Models and published Packages utilizing Framework Manager for various Departments using Cognos 10.

·        Created several packages in Framework Manager.

·        Creating several parameter maps, calculations and relationships in Framework Manager.

·        Creating and publishing several packages in Framework Manager.

·        Worked on CCS, SLA Data and Created different Reports using Cognos 8.4 BI Suite.

·        Worked on Stored procedure packages and created different reports.

·        Developed Lists, Crosstabs, Charts, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio and Query Studio.

·        Created calculations, filters and prompts in Report Studio reports.

·        Created user groups for distribution and assigned security based on different roles.

·        Generated various kinds of reports (Daily, weekly, monthly etc) in Cognos 8 BI Suite.

·        Responsible for creating Ad hoc reports for business users.

·         Created different joins according as per the user requirements.

·          Created OLAP Cubes in Cognos Transformer and analyzed the data using Cognos PowerPlay.

·          Developed Models and Power Cubes in PowerPlay Transformer using multiple IQDs and data sources, implemented drill through to Impromptu reports. 

·          Updated the multiple IQDs depends on the requirement.

·          Modified Power Cubes by adding new Dimensions, Levels and Measures.

·          Maintained Cube security by user classes from Access Manager.

Environment: Cognos 10.1, Cognos 8.4BI Suite (Frame work manager, Business Insight, Business Insight Advance, Report Studio, Query Studio), Impromptu, PowerPlay, Transformer, Upfront, Access Manager, SQL  Server, Oracle 11 g, PL\SQL Developer.

                                   

Client             : Hines Horticulture, Inc., Irvine, CA

Duration        : May 2010 to  Oct  2010

Role               : Sr. Cognos Developer

·        Responsible for daily monitoring of the cube build over night and trouble shoot any failures in the process.

·        Worked on any tickets that were created by end users in regards to data issues.

·        Work Closely with the Sales and Finance department.

·        Created reports and Cubes  on Inventory On Hands, Shipped and Sold calculations.

·        Created reports indicating Return items reports for management team.

·        Worked with end users to gather requirements, develop requirement documents and build new cubes and reports.

·        Worked Extensively with the Framework Manager, Powerplay Transformer in order to build Framework Manger models,Transformer model and cubes.

• Built Power Play Reports based on these cubes and published to Cognos 8 Server.

·        Developed new automation processes to generate and deliver large amount of data to users outside the Hines’s Firewall.

·         Managed the Cognos Administration including trouble shooting server issues and grading access to the new users to the Cubes and reports.

• Provided technical support and administration for the existing Cognos Power Play Cubes.
• Developed numerous drill-through Power Play and Cognos 8 reports.

Environment: Cognos 8.4, Reportnet, Framework manager, Oracle 10g,Toad 7.4,

PowerPlay Transformer, Cognos Server Administration, Cognos Configuration

Client             : CCi, Santa Ana, CA

Duration        : Feb 2008 to  Apr 2010

Role               : Sr.Cognos Developer

• Loaded data into the BIS system from multiple data sources including Oracle and SQL

servers.

• Build and scheduled the DTS jobs in order to bring in the data on a daily basis into BIS
• Created tables , index and views in order to do reporting off the BIS data sources.
• Produced and enhanced stored procedures and ad hoc queries in SQL
• Optimized and modified the triggers, complex store functions, procedures, user base datatype
• Extensively used loops , conditions, functions and store procedures in producing monthly process data.
• Extensively used MDX functions and queries to retrieve data from the Analysis cube.
• Created a data models in Frame work Manager with data level security.
• Worked with the finance and Treasury departments in order to provide them with the Journal Entry and Other Financial reports
• Created reports that contains monthly and cumulative amortization for loan discounts and originations fees.
• Created reports for analysis and auditing purpose, including reports at the student detail level.
• Help the business get the reports by providing different delivery methods including Bursting to public mail Box / Common Shared Drive.
• Perform add hock  data extracts and reporting on the fly when requested by business users.
• Worked with the INSIGHT data warehouse in building and bring in Data from different Student Systems.

Environment: Cognos 8.4,  Framework manager, UNIX, Windows NT,PL/SQL, informatica Powercentre, Oracle 10g (SQL Plus).

Client             : DIRECTV, El segundo, CA

Duration        : Feb 2007 to Jan 2008

Role               : BI Team Lead

      Roles and Responsibilities:

• Worked on different projects that involved requirement gathering, creating project plans, managing project, creating Power Play Cubes, Multidimensional Power Play Reports, Cognos 8 Framework Manager Packages, and List, crosstab and charts report net reports by using Cognos 8, Report Studio, Framework Manager, Power Play Transformer, Power Play,  PL/SQL and Informatica
• Implemented Cognos 8, Developed Dimensional Models for Cognos 8 Analysis Studios, Migrated Power Play cubes to Cognos 8 Framework Manager.
• Designed multidimensional reports in Cognos 8 Report studio
• Created Dashboards for end users in Cognos 8 using “new page” option.
• Built Cognos 8 packages for many daily and monthly usage reports using Framework  MR2 and MR3 for different projects.
• Used Series 8 Report Studio to create list reports, cross-tab reports and chart reports with date, value and text box prompts.
• Implemented Security in Cognos 8 Packages before publishing.
• Wrote SQL queries to populate different calculated columns in reports.
• Scheduled Report.Net Reports to deliver through e-mail in PDF and Excel formats.
• Created Drill Through between Parent (Summary) and Child (Detail) Report.Net Reports.
• Designed and developed Cubes for Sales, Sales and Inventory, Inventory, Stock Ledger

       using Power Play Transformer V 7.3.

• Used time state rollups, average rollups and external rollups in some Transformer Models.
• Created dimension maps and multidimensional cubes using Impromptu Query Definition in Power Play Transformer.                                                                                                                                                                                                                                                                                                                                                                         
• Created drill throughs from Power Play Cube to Detailed Report.Net reports.
• Migrated Cubes, Power Play Reports from Cognos Series 7 to Cognos 8.
• Used features of Informatica Versions 6.x and 7.x like Designer and Workflow manger and Repository Manager.
• Created training guides for different projects to efficiently use Power Play Cubes, reports and Report.Net Reports.

Environment: Cognos 8, Report NET Version 1.1 MR3, Power Play 7.3, Power Play Transformation Server Version 7.3, Power Play Enterprise Server 7.3, Framework manager,  Informatica Power Center 6.1/7.1, UNIX, Windows NT, Oracle 9i.

Client             : Travelers, Hartford CT

Duration        : June 2005– Jan  2007

Role               : Senior Cognos Developer

St Paul Travelers Companies(STC) is a leading provider of a wide range of insurance products. STC is the second largest commercial lines insurer, providing a broad range of insurance products including workers compensation, integrated disability, property, liability, specialty line, surety bonds, inland/ocean marine and boiler and machinery. The scope of the project is to migrate complete Regional executive reports from Impromptu 7.3 to Cognos Series 8. The project involved designing of enhanced Functional Requirement Specifications for report development, defining relationships between different database tables and building models using Framework Manager. Reporting included the development of flexible scorecards, dashboards their web publishing.

Roles and Responsibilities:

·        Study the existing CRN environment and draft the Design Document for the Sales Analytics project.

·        Revise the Requirement Specifications with the users for better customer service and feasibility in CRN.

·        Logging Support cases with Cognos and follow-ups.

·        Built Framework Manager Model, and established the cardinalities to suit the business needs.

·        Developed procedures, functions and database triggers using with PL/SQL.

·        Implemented security for Data access, Object level access and Package access.

·        Created User Groups, Roles to implement the Cognos Security, using LDAP. Implemented and administered different levels of security and report bursting, using Cognos 8, Access Manager.

·        Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and designed with a star schema .

·        Assisted in Cognos migration projects: From Impromptu 7.3 (Catalogs) to Cognos 8

·        Involved in administration, development and support of existing & new (20+) Catalogs, Created Dashboard  and query definition files using various joins and filtering conditions using Impromptu administrator.

·        Developed list, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, Multi-page, Multi-query reports against multiple databases.

·        Involved in intensive end user training (both Managers and business users in Report studio and Query studio) with excellent documentation support.

·        Assisted in deploying the Cognos ReportNet Reports through their eReporting Portal using URL calls to dispatcher and also used SDK for certain functionalities like “Save to PDF” on some reports.

Environment: Cognos 8 (Framework Manager, Report Studio and Query Studio), Power Play 7.3, Transformer 7.3, Power Play Enterprise Server 7.3, Impromptu 7.3, IWR, Oracle 9i (SQL, PL/SQL), Win 2K Server,Teradata

Client             : AIG, Seattle, WA

Duration        : February 2003– May  2005

Role               : Cognos / ReportNet Consultant

American International Group, Inc is the world's leading international insurance and financial services organization, operating in more than 130 countries worldwide.  The primary concern of AIG was data integration within the Cognos Enterprise Business Intelligence solution. The scope of this project was complete enterprise reporting coverage.

Responsibilities included:

·        Involved in Requirements Gathering.

·        Designed prototypes and presented to users.

·        Created and enhanced Catalogs based on user requirements.

·        Configured User Profiles using Access Manager.

·        Implemented Impromptu catalog based security and Transformer model security.

·        Created different joins and views according to the specifications.

·        Created Alias Tables to avoid loops.

·        Created List, Cross-tab and Drill through Reports

·        Created different types of Prompts and Cascaded Prompts to address different report requirements.

·        Scheduled the Impromptu Reports, refreshing of Cubes.

·        Created User Classes with appropriate user rights using Access Manager.

·        Created and maintained news boxes using Cognos Upfront.

·        Published the Impromptu Web Reports and Power Play cubes using Cognos Server Administration tool.

·        Published the Impromptu Web Reports in pdf and Excel Formats.

·        Informatica (Power mart/Power Center) is used for extracting the data from Legacy systems to load into Oracle8i.

Environment: Power Play 7.1/7.3, Transformer 7.1/7.3, Power Play Enterprise Server 7.1/7.3, Impromptu 7.1/7.3, Oracle 9i (SQL, PL/SQL), Win 2K Server

Client             : Nortel Networks,Ottawa,CA

Duration        : Jan 2002– Dec  2002

Role               : Cognos Developer

Responsibilities included:

·        Create filters and conditions, formatting of Impromptu reports.

·        Identifying the Dimensions to Perform Business analysis.

·        Created hot files using Impromptu reports.

·        Modify and added new Dimensions and Measures in Cube according to the enhancement.

·        Used Cognos Power Play to analyze, display and present the Cube data in different types of charts.

·        Creating cubes and tuning cubes and presenting cubes according to the Business user Requirement and setting up security to cubes according to user classes.

·        Creating Dimensional views and subsets.

Environment: Oracle 7, SQL, PL/SQL, Cognos Impromptu, Cognos Power Play, Cognos Transformer, Powerplay for Excel, Powerplay for Windows.

Download Resume Format