Cognos Reportnet Developer by yaofenjin

VIEWS: 49 PAGES: 5

									                                            VENKAT. GARIKAPATI
                                            Garikapati2004@gmail.com
Cognos Reportnet Consultant                                                                              732-986-6511


Summary

   Seven 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
    Impromptu, Transformer, PowerPlay, Impromptu Web Reports (IWR), Cognos Upfront, Cognos Query
    (CQ) and Cognos Enterprise planning.
   Including 2 years hands-on experience with the Cognos Reportnet suite (Framework Manager, Cognos
    Connection, Report Studio, and Query Studio) on Windows, UNIX as both a developer and as an
    administrator.
   Involved in migrating reports from Impromptu to ReportNet. Involved in a data migration process
    between different versions of Cognos.
   Experience in installation and configuration of Cognos ReportNet Environment and Security, Experience
    with ReportNet Software Development Kit (SDK) to customize reports.
   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.
   Developed complex 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. Adept in using performance tuning and
    optimization techniques such as load balancing, table weighing and partitioning.
   Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work
    schedules and possess good communication skills.
Technical skills summary:
                                        Cognos Business Intelligence 7.0, Impromptu 7.1/7.0/6.0,
                                        Impromptu Web Reports 7.0/6.0, Upfront, Cognos Query,
              BI Tools                  PowerPlay Transformer 7.1/7.0/6.0, Power Play Enterprise
                                        Server, Access Manager.
                                        Cognos ReportNet 1.0.2/1.1 MR2
             Languages                  SQL, PL/SQL, C, C++, Oracle, Visual Basic 6.0/5.0
             Front End                  Visual Basic (6.0/5.0), HTML
         Operating System               Windows 2000/ NT/ 98/ 95, UNIX, MS-DOS
             Databases                  Oracle 9.x/8.x/7.x/6.x, MS SQL Server 2000/7.0/6.5
                                                                                                                       1
PROFESSIONAL EXPERIENCE:
Project#1
Client: Micron Technologies, Boise, Idaho                                    April 2005 - Present
Domain: Product Lifecycle
Cognos/Reportnet Consultant
Project: Micron is one of the world's leading providers of advanced semiconductor solutions. The data mart was
designed for the reporting for the Micron Technologies. The reports are used to track status various Production
Projects. Reports are retrieved data from the Micron PLM Data mart and reports provide detail and summary
analysis for the Micron Top Management.
Environment: Cognos ReportNet 1.1 MR2 (Framework Manager, Report Studio and Query Studio),
Cognos PowerPlay 7.3, Cognos Transformer 7.3, Power Play Enterprise Server 7.3, Oracle 9i (SQL, PL/SQL)
Roles and Responsibilities:
 Study the existing CRN environment and draft the Design Document for the expansion 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 procedure, functions and database triggers with advanced features like varrays, nested tables, locally
    managed tables 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.
 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.
 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.
 Built Power Play Cubes for Sales, Sales and Inventory, Inventory, Stock Ledger.
 Built Power Play Reports based on these cubes and published to ReportNet Server.
 Creating a Drill through from Power Play to Cognos ReportNet.
Project#2
Client: GlaxoSmithKline, Philadelphia - PA                                              Aug 2004- March 2005
Title: Sales Analytics for a Pharmaceuticals Company
Cognos/ReportNet Consultant
Project: A leading Pharmaceutical MNC with market leadership in most categories. GlaxoSmithKline (GSK) is a
world leading research-based pharmaceutical company with a powerful combination of skills and resources that
provides a platform for delivering strong growth in today's rapidly changing healthcare environment. The project is
designated to analyze what products are sale in which stores on what dates under which promotional conditions of
the Company. The reports are used to analyze the sales and profits. The Higher officials to know the effort put by
the down line officials till distributor and sales executives.
Environment: Cognos ReportNet 1.1 MR2 (Framework Manager, Report Studio and Query Studio), Cognos
PowerPlay 7, Cognos Transformer 7, Power Play Enterprise Server 7, Oracle 9i (SQL, PL/SQL)

Business Benefits:
  Daily availability of sales/stock information.
  Sampling information captured and available on-line - ability to analyze sampling effectiveness.
  Weekly sales information and sales force performance monitoring
  Effective Forecasting and Trending (Planning)
  Performance Comparison with competition (over time, season, prescribe, geography)
  Development of customized tables, complex joins, and specialized exception reporting requirements were
     some of the complexities addressed in the project.
  Powerful and ad-hoc analytical capabilities including pivoting and drill-downs

                                                                                                                  2
Responsibilities
 Installation of ReportNet 1.1 MR1 and Framework Manager 1.1 MR1, setting Cognos configuration and
   integrating different components were part of the project.
 Communicated with the business users to comprehend the requirements.
 Designed the reports and catalogs using impromptu as per the requirements.
 Extensively used PowerPlay Transformer to convert the data into power cubes.
 Modified Power Cubes by adding new Dimensions, Levels and Measures. Designed Cognos Transformer cube
   models using reports modeled according to user needs.
 Installed Cognos ReportNet and Framework Manager in an interim environment as a proof of concept.
 Involved in migration of catalogs from Impromptu to ReportNet using Migration Utility.
 Created customized BI reports linking various databases, to meet the user requirements
 Designed models using Framework Manager and deployed packages to the ReportNet Servers.
 Created standard and Ad hoc reports using Cognos Query Studio.
 Created Reports to evaluate the business performance based on various financial indicators.
 Created Lists, Groups and Cross-tab reports with drag and drop functionality.
 Developed Templates, standard Reports, Master Detail Reports, Bursting Reports and Multilingual Reports
   using Report Studio and Query studio. Provided training on Query Studio to create Ad-hoc Reports.

Project#3
Client: AIG (American International Group, Inc) Atlanta                     July 2003-Aug 2004
Domain: Health Care/Finance
Cognos Developer
Project:      American International Group, Inc. AIG 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. The project involved designing of 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.
Environment: Cognos ReportNet 1.1 MR1 (Framework Manager, Report Studio and Query Studio), Cognos
Power Play 6.6, Cognos Impromptu 7.1, Cognos Transformer 6.6, SQL Server 2000 and Windows NT
Responsibilities:
 Interacted with Business users to identify key dimensions and measures for business performance.
 Extracted data from Oracle data marts.
 Generated reports using Cognos Impromptu and Power Play.
 Created Hot Files to be used as Lookup tables to prepare reports and reduce querying time
 Formed joins and database definitions according to the requirements.
 Created Prompts, set Filters and Calculations.
 Generated Multi-Dimensional reports using Power Play.
 Enhanced existing Power Cube as per user requirements.
 Made use of both Auto and Manual Design for creating Power Cubes.
 Created Time dimension properties.
 Developed Impromptu Web Reports and published them using Upfront.
 Used Access Manager to meet the security requirements of the reports and cubes on the Upfront.

Project#4
Client: Herff Jones Inc, USA                                               Oct 20002 - July2003
Title: Infrastructure Data Services One Bill
Cognos/Report net Consultant
Project: Herff Jones is one of USA’s foremost private sector companies with a market capitalization of around
Herff Jones. A Data Mart had to be developed for the Sales Sector that catered to the reporting requirements of the
Business Users. The Data Mart was implemented using the features of Oracle 8i like Change Data Capture that was
used to capture the changed data from the source system. The project is designed to know the sales of the Products
manufactured by the Company. The reports were analyzed on Product sales in different time periods at various

                                                                                                                 3
Promotional Conditions. Ad-Hoc Reporting was to be developed on this Data Mart along with End User
customization.
Environment: Oracle 8i, Cognos Impromptu Admin/User, Impromptu Web reports, Power play Transformer,
Power play for Web/Windows, PPES, Upfront Server 7, Pl/SQL
Roles and Responsibilities:
 Interpreted complex Business specifications developed by the client and generated cubes and reports to meet
    customer specifications.
 Created standard and Ad hoc reports using Cognos Impromptu Designed catalogs and defined User Classes,
    Security and Privileges.
 Created Lists, Groups and Cross-tab reports with Drill-through functionality.
 Created Multidimensional 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.
 Calculated fields, created manual dimensions and used special categories for creating cubes and reports using
    Transformer models
    Created Impromptu Web Reports and published them on the web server and later on upfront.
 Created News boxes in Upfront and customized the environment. Set Security for News Item and New boxes
    in Upfront. Set Privileges for user classes by defining News Index Admin.
 Created notification Agents using Notice Cast to keep the users updated on the event changes.

Project#5

Client: Present Key Corp Inc, Cleveland, OH                                 March 01- Oct 2002
Title: Cognos Developer
    Project: KeyCorp has grown into one of the largest financial services companies in the United States, with
    assets totaling close to $83 billion. KeyCorp had to turn raw data into meaningful information with limited time
    and resources, reduce long lead time for report generation and get a deeper insight for making business
    decisions. This Project provided web based reports of the current and future financial needs based on the
    information received from the transactions available in the Data Warehouse.
Environment: Cognos Impromptu 6.1, Cognos Powerplay 6.1, Cognos Transformer 6.1, Impromptu Web
    Reports 6.1, Cognos Upfront 7.0, Notice Cast 7.0, Oracle 8i, Windows 2000.

Responsibilities:
    Involved in Creation of Packages in Cognos ReportNet.
    Created standard and Ad hoc reports using Report Studio and Query Studio.
    Created Multiple Reports with Cognos Impromptu and Power Play.
    Created LIST, Group and Cross tab reports with Drill Through functionality
    Created business Mix and Reports for Comparison
    Created Multi Dimensional Cubes using Power play Transformer for         multidimensional (IQD) reports.
    Drill Down and Drill Through functionalities were used in the cubes and reports
    Data retrieval, Multidimensional analysis, Power Play structure. Reporter Operations such as Sum and
      Average, Intersection, Exception Highlighting, Sorting, Ranking etc.
    Developed solution models for Adhocs.
    Involved in optimizing power Cubes.
    Report building and publishing upfront 7.0.
    Outstanding Onsite support.

Project#6
Client: Reptron Inc, Miami                                               Feb 00 - Feb 01
Environment: Windows 2000 server, Business Objects Tools (Designer, Business Object- Reporter), Oracle 8i
ECT: Reptron Inc is a leading electronics manufacturing services (EMS) company offering a full range of integrated
supply-chain solutions for the world. Reptron Inc is a leading global provider of electronics manufacturing and
integrated supply chain services .we serve the World’s most innovative companies in industries that rely on high-
tech electronics. Our employees have hand in designing, making and servicing products that people around the
                                                                                                                   4
world rely on everyday. It has around 64 centers (called as sites) worldwide in 3 regions (Asia/Pacific, America,
Europe). Its head office is located in California (CA)
As Business Objects Developer
Responsibilities:
  Involved in creating Universe using Business Objects 5.1 Designer and Worked with database connections.
  SQL joins Cardinalities, Loops, Aliases, Aggregate Conditions, Parsing of Objects and Hierarchies.
  Created reports with filters and measures, Exception Highlighting, Sorting, and Ranking etc.
 Project#7
 Virtual Insure
 Client: CMG Asia Life Assurance Ltd, Hong Kong.                            Jan 99 - Feb 00
 Environment: Java 2.0, JSP 2.0, java script, Oracle 7 and Html.
 Description: Virtual Insurance is a robust web-based solution that enables an Insurance company or an
 Insurance Intermediately to transact & consummate business with a variety of operational entities. It automates
 the business process in which these entities participate by automating the process workflows, making your
 business processes more streamlined and unhindered by bottlenecks.
 Roles and Responsibilities:
  Understanding the client requirements and project functionalities.
  Designed and coded most of forms.
  Understanding of the system with the KAP (Knowledge Acquisition Process) conference calls.
  Involved in Manual Testing.
Education:
     Master of Science in information technology from Bharathidasan University, TN, india.
     Bachelor of Electronics form Nagarjuna University, A.P, India.




                                                                                                               5

								
To top