Manager Data
Resume:
SHRAVAN
Sr. Cognos Consultant
eitye1@r.postjobfree.com
Professional Summary:
• Over 8+ years of Experience in Data Warehousing, Data Modeling, Business Intelligence (BI) Cognos.
• Extensive exposure to various business sectors such as Finance, Insurance, Pharma and, Retail.
• Very good understanding on advantages, limitations & advancements in recently released versions of Cognos products.
• Developed Reports using Cognos 10.1.1 Active Reports & Statistics.
• Experience in Cognos 8 BI (Framework Manager, Report Studio, Query Studio, Event Studio, Metric Studio, Analysis Studio and Cognos Connection) and Report Net1.1.
• Expertise in Data warehousing Concepts in OLTP/OLAP System Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modeling.
• Extensive experience in data analysis, development, SQL performance tuning, data warehousing ETL process, data conversions and user documentation.
• Upgraded Cognos 8.4 content to Cognos 10.1.1.
• Experience in Conceptual, Logical and Physical data modeling with strong knowledge of Data Warehousing concepts and Dimensional modeling Star schema and Snowflake schema.
• Experience in developing various reports like List reports, Crosstab reports, Charts, Dash Boards and Score cards
• Has very good experience in complete ETL cycle including data analysis, data mapping, conversion and data load.
• Involved in entire lifecycle development process of data warehousing.
• Expert at creating Multi-dimensional Cubes for corporate data using PowerPlay Transformer.
• Published cubes and PowerPlay reports to Upfront using PowerPlay Enterprise Server.
• Strong programming and debugging skills in SQL,PL/SQL
• Hands on experience in administering, deploying and maintaining models, reports and cubes
• Installed and configured various components, such as the Framework Manager and Content Manager.
• Experience with Cognos Software Development Kit (SDK) to customize reports using java.
• Extensive experience in gathering and documenting user requirements, report development, setup security infrastructure at Data and object levels as part of setting up reporting infrastructure.
• Experience in configuring the Repository, creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Strong Experience in User acceptance test, product support, version control and change management.
• Possess Excellent Communication (both verbal and written) & Interpersonal skills technically sound, Result-Oriented with strong Problem Solving skills.
Certifications:
• Cog 180 – IBM Cognos 8.4 BI Professional
• Cognos ReportNet Modeling Product Professional Cognos Certification Program
• Cognos ReportNet Administration Product Professional Cognos Certification Program
• Cognos ReportNet Authoring Product Professional Cognos Certification Program
Technical Skills:
OLAP Cognos 10, 8 BI 8.4/8.3/8.2/8.1 (Report Studio, Query Studio, Cognos Connection, Analysis Studio, Event Studio and Framework Manager), Cognos Go Office, Reportnet 1.1, Powerplay Transformer, Impromptu Web Reports (IWR), Upfront, Cognos Impromptu Administrator and MS-Excel
Data Modeling ERwin 4.x/3.5.2/3.x, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer
RDBMS Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/7.0,Terradata,DB2 9.0,Nateeza
ETL Informatica 7.x, PowerMart/Power Center (Source Analyzer, Data warehouse designer, Mapping Designer, Mapplets, Transformations), Data Manager, Data Stage
Operating Systems Windows 2000/XP, UNIX, and DOS
Languages C, C++, Java, SQL, PL/SQL, HTML, Java Script
Professional Experience:
Mercedes-Benz, MI May, 2011 – Till Date
Sr. Cognos Consultant
Sales Goal Reporting (SGR)
Mercedes-Benz is a multinational company, and the brand is used for automobiles, buses, coaches, and trucks, this is widely regarded as the first automobile and manufactured in multiple countries worldwide. IBM Cognos used to analyze their sales manger data worldwide by organization vice presidents to area level managers.
Roles and Responsibilities:
• Developing models using Framework Manager Techniques.
• Created Packages and published these packages on to Cognos Connection for creating ad-hoc reports using Query Studio and professional reports using Report Studio.
• Created new Query Subjects and arranged in different folder structure for Business View.
• Created complex reports like Crosstab, Drill throughs, Master detail, Dashboards and Burst Reports using Report Studio.
• Created reports using Conditional formatting, Conditional blocks, Conditional variables, Advanced Conditional styles and Conditional Layout features in Report Studio.
• Created queries in report studio using Join and Union.
• Developed Reports using Cognos 10.1.1
• Built Multi Dimensional Models (DMR) with Relational Data using Framework Manager and Deployed Packages to the Report Servers.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP – ROLAP)
• Experience in Deploying reports, cubes and packages from Development to Production environment.
• Created reports with custom prompt pages (using HTML and JavaScript) in Report Studio.
• Setting up cardinality (minimum, maximum & optional), Determinants to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Used Cognos Transformer to build multidimensional cubes.
• Developed DMR Models & IQD’s in Framework Manager.
• Fine-tuned the queries for performance purpose and enhanced the performance of the reports.
• Developed Prompt pages and Cascading input prompts to display only selected entrees in the report.
• Developed Report Views to organize reports in Cognos Connection
• Expertise in handling Administration tasks like bursting and scheduling the reports.
• Strong experience in all phases of testing including defining user acceptance criteria, developing plans/scripts, documenting expected results, execution of scripts, validating actual results.
Environment: Cognos 10 / 8.4 (Cognos Connection, Report Studio, Query Studio, Analysis Studio Framework Manager), Access Manager, Cognos Transformer, Oracle 11i, DB2, TOAD, Windows XP
State Farm Insurance, IL Sep 2010 – May 2011
Sr. Cognos Consultant
Risk Management Partners (RMP Project)
RMP, a division of State Farm Insurance, provides a variety of services related to the motor and liability insurance requirements of local authorities like Civil Authority, Police Authority and Scottish Authority. As part of its customer service offerings, RMP is planning to develop a comprehensive model that provides its clients a detailed analysis of their motor fleet as well as casualty portfolios and to utilize the analytic output to offer appropriate renewal advice to its Local Authority clients. The model will utilize actuarial practice and methodology for historical data analysis as well as forecasting.
Roles and Responsibilities:
• Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement.
• Built Multi Dimensional Models (DMR) with Relational Data using Framework Manager and Deployed Packages to the Report Servers.
• Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Developed Framework Manager models against Teradata and Oracle Database.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Delivered advanced/ complex reporting solutions such as Dashboards and Standardized Reporting including the bursting of reports globally using Cognos 10.1/8.4.
• Developed reports in Analysis Studio from Powerplay Transformer Cube.
• Developed Score Card Applications using Metric Manger and Metric Studio
• Migrated catalogs, Cubes, reports from Cognos Series 7.3/CRN to Cognos 8.4 using Migration Utilities.
• Customized Reports using HTML and JAVA SCRIPTS.
• Developed complex reports on SSAS cubes and Transformer cubes.
• Developed Forecast Budget Reports on SSAS and Transformer cubes using Report Studio in Cognos.
• Creating New Jobs using Cognos Connection.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Designed models by mapping business needs using Power Play Transformer and created multi dimensional cubes, cube groups, Power Play reports.
• Designed multidimensional models using Transformer.
• Decreased the Cube build times drastically and increased runtime performance.
• Third Party Security with LDAP and use those in creating Data Level, Object Securities in Framework Manager Models.
• Involved in Deploying reports, cubes and packages from Development to Production environment.
• Assigning work to the offshore team on daily basis.
• Setup Weekly Status Calls with offshore team.
• Coordinated training sessions and demonstration of Cognos tools to End-users.
• Developed technical specification document for the offshore team.
• Involved in the Installation and Configuration of Cognos 8.4 BI tools and Framework Manager.
Environment: Cognos 10/8.4 (Cognos Connection, Report Studio, Query Studio, Framework Manager), Access Manager, SQL Server 2005, Oracle 10g, Windows XP
JPMorgan Chase & Co. (JPMC), DE Mar 2009 – Aug 2010
Sr. Cognos Developer
Profit and Analysis Systems (PAS)
This project is to build financial cubes for the management based on their businesses, projects and lines of businesses to the managerial and decision-makers to help them to analyze the banking trends, company P/L’s and other budget analyses. The built cubes are then automated and reports are designed in Cognos reports and also with Excel Add-In templates.
Roles and Responsibilities:
• Gathered business requirements and designed functional and technical requirements documentation.
• Involved in Designing DMR models with Relational Data and Relational models using Framework Manager and deployed packages to the Report Servers.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Set up the Security at the package level, query subject level and the query item level.
• Used Governing techniques for improving performance of the Query.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Delivered Advanced Multidimensional reporting solutions using Report Studio.
• Developed Reports with multiple Cognos Viewers and integrated multiple Cognos reports onto a Single Page Report.
• Customized Reports by writing complex custom SQL.
• Customized Reports using HTML, JAVASCRIPT and SDK.
• Deliver advanced/ complex reporting solutions such as Dashboards, Scorecards and Standardized Reporting (including the bursting of reports globally) using Cognos 8.
• Creating IQD files from Report net and designed Power play models in Transformer.
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Involved in building the complex cubes and optimizing the cube creation.
• Built Multidimensional Cubes, Sub cubes for user groups using PowerPlay Transformer.
• Created and managed jobs and schedules.
• Published cubes and OLAP reports using Upfront Server.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Installation of Cognos 8 BI Tools and Framework Manager, setting Cognos configuration and integrating different components.
• Created Transformer models and generated OLAP cubes for multi-dimensional analysis of the data.
Environment: Cognos8.4 (Cognos Connection, Report Studio, Query Studio, PowerPlay studio,
Framework Manager), Cognos PowerPlay, Cognos Transformer, Access Manager, SQL Server 2005,
Oracle 10g, Windows XP
Pfizer, Collegeville, PA June 2007 – Mar 2009
Sr. Cognos Developer
Movement of Exposure Units (MEU)
Pfizer is a pharmaceutical giant using all set of Cognos products for their Financial (General Ledger, Income statement, and Balance sheet), Reporting, Forecasting and Budgeting needs. All the Currency translations, market analysis, constant rate, amortization calculations are performed in Finance applications (Cognos, Cognos Planning) for reporting and analysis purposes.
Roles and Responsibilities:
• Involved into business requirements and report specifications.
• Created relational and dimensional Framework Manager Models, packages, IQD files and configured them with appropriate security.
• Created Transformer models, generated OLAP cubes and published them to the Web portal.
• Developed various reports which include simple lists, cross tabs, charts, complex reports with tables in them, conditional block, static choices in prompt etc.
• Expertise in creating reports by using Master Details, Drill throughs, Drillup and DrillDown.
• Expertise in developing Prompt pages and Cascaded input prompts.
• Expertise in using Query Studio for developing Ad hoc reports.
• Expertise in developing Dash Boards using Report Studio.
• Used joins to extract data from different tables.
• Created portal pages for various departments and assigned security to portal pages and reports in Cognos connection.
• Scheduled and distributed reports using Schedule Management in Cognos Connection.
• Created Dashboards to present critical company data in a single report.
• Performed comprehensive Unit testing by comparing the Cognos reports against the database using SQL by using Toad and documented the same.
• Involved in designing of Test Plans, Test Cases, and Executed Test Cases.
• Involved in System and Integration testing as required to provide a Quality product.
• Migrating reports from Cognos 8.3 BI to Cognos 8.4 BI.
• Training users to use the Cognos Connection to access their corresponding reports.
Environment: Cognos 8.1/8.2 (Report Studio, Query Studio, Analysis Studio and Frame work manager), Cognos Go dashboard 8.4, PowerPlay Transformer 8.3, Toad 9.5, Oracle10g
Thomson Financials, MD Mar 2006 – May 2007
Cognos Developer
Report Analysis Forecasting
Thomson Reuters delivers critical information to leading decision makers in the financial, legal, tax and accounting, scientific, healthcare and media markets, powered by the world’s most trusted news organization. As the legacy systems are developed using various vendor specific applications, Thomson requires integrating data into a single data repository.
Roles and Responsibilities:
• Created packages using multiple data sources in Framework Manager.
• Created the packages defining the business rules and calculations with folders to store conditions, calculations and prompts.
• Worked on the Framework Manager to create metadata model and solved ambiguous relationships.
• Created ad-hoc reports in Query Studio and standard reports in Report Studio.
• Developed List, crosstab, drill through, master-detail using Report Studio and Query studio, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports.
• Scheduled reports, maintained public and individual folders, distribution lists, users, groups and roles using Cognos connection in Report Net.
• Created complex reports using multiple tabular models and tabular sets in Report Studio.
• Installed ReportNet Migration Tool and migrated Impromptu catalogs using impcat2xml command.
• Developed complex reports using impromptu with drill through capabilities, summarization, grouping and filtering.
• Accessed data from data marts using Cognos Impromptu & Cognos PowerPlay
• Created cubes using Cognos PowerPlay Transformer
• Applied User class security for Models in Transformer.
Environment: Cognos ReportNet, Cognos EP Series 7.3 (Impromptu, Upfront, IWR, Transformer, Power play), Oracle 9i, SQL Server, Windows XP.
Baskin-Robbins, India Feb 2004 – Mar 2006
Cognos Developer
Sales Reporting Warehouse (SRW)
The project is designated to know the sales and distribution of the Products manufactured by 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.
Roles and Responsibilities:
• Created Catalogs in Impromptu Administrator to create Reports.
• Created list reports and cross tab reports and drill through reports in Impromptu.
• Created Cubes by using Cognos Power Play for analysis.
• Created Models by using Impromptu Query Definition (IQD) in Power Play Transformer.
• Extensively worked on Power Play reports. Used Power Prompts Developer Studio for Designing Application. Created Prompts to User defined Filters. Used Power Play Enterprise Server to publish the cubes.
• Maintain the Cube Security by Category level and Dimension level.
• Written macro's to schedule the Power Cubes. Used Cognos Scheduler to schedule the Reports.
Environment: Cognos 7.0 (Impromptu, Power Play, Power Play Transformer, Power Play Enterprise Server), Oracle 8i, SQL Server 2000.
Contact this candidate