We provide IT Staff Augmentation Services!

Cognos Bi Consultant Resume

Torrance, CA

Summary:

  • 8+ years of extensive experience in IT industry which includes extensive Functional and Technical experience in Data Warehousing, Data Modeling, Business Intelligence (BI), Decision Support Systems (DSS) and OLAP, ETL tools, product development and Reports Generation.
  • 6+ years experience in Business Intelligence tools like Cognos 10.2/10 BI/ 8.4 (Report-Studio, Query-Studio, Analysis-Studio, Framework Manager, Cognos Connection, Metric-Studio, Event-Studio) Cognos EP Series 7 Power Play Transformer, Power Play Web, Access Manager, Report Administration, Upfront, Visualizer, Architect, Cognos Query, Scheduler, Notice Cast), and ETL tools like DataStage and Informatica.
  • Experience in working with various databases - Teradata,Oracle, DB2, SQL Server and MS-Access.
  • Expertisewith developing Framework Manager Modeling (Layers Architecture - Physical Layer, Business Layer, security, IQDS – Sources of Transformer, Packages) and Complex Report building with Report Studio.
  • Very good knowledge on Installation & Configuring the Cognos 10/8 tools in distributed environments on Windows/Unix.
  • Experienced with Metadata modeling using Framework Manager, creating Projects, Models, Packages, Security and Parameter mapping techniques.
  • Hands on experience in Report building (Crosstab, List, Dashboard reports) using Report Studio and Analysis Studio.
  • Experience developing complex reports using drill-through reports, prompts, dashboards, master-detail, burst-reports, dynamic filtering in Cognos.
  • Experienced in building scorecard reports and dashboard reports using metric studio.
  • Good Experience with MDX Functions in Report Studio using Multi-dimensional Sources and Cubes
  • Extensive experience with Cognos security (LDAP, Active Directory, Access manager, object level security, and data security).
  • Strong skills in visualizing the data.
  • Creation of Dashboard Reports using Report studio and adding it to the portals.
  • Outstanding experience in performance tuning of queries, stored procedures and UDFs.
  • Deploying models and reports from Staging to Production and administering users/groups/roles.
  • Proficient in SQL, PL/SQL, SQL*Loader also created the database objects like Stored Procedures, Triggers and Packages.
  • Extensive experience on production support and troubleshoot/test issues with existing reports and cubes.
  • Creation of Relational and DMR models using Framework manager
  • Excellent knowledge on data warehousing concepts - Star schema, Snow-flake schema and worked on both OLAP and OLTP databases.
  • Basic knowledge on ETL tools like Informatica& Data Stage.
  • Effective communications skills (verbal and written) for both highly technical and non-technical audiences.
  • Team Player, innovative, able to work efficiently, good in debugging, creative and strong desire to keep pace with latest technologies.

Technical skills:

Business Intelligence Tools: Cognos 10.2, 10.1, 10, 8.4, 8.3, MR2/MR1: Framework Manager, Cognos Connection, ReportNet, Report Studio, Query Studio, Analysis Studio, Event Studio, Dashboards, Powerplay Transformer(7.3 and 8.4.1) Business Objects XI Release 2

Databases: Teradata 12/13, Oracle 11g/10g/9i/8i, Netezza, DB2 9.5/8.5, SQL Server 2008/2005/2000 , MS Access

SQL Tools: Teradata SQL Assistant, Teradata Administrator, Toad, SQL Developer, SQL Plus

ETL Tools: Informatica 8.x/6.x, DataStage 8.x/7.x

Data Modeling: Power Designer, Framework manager, Cognos Analytical Application

Operating Systems: Windows NT/XP/2000/98, HP-UX, AIX, Solaris, Linux

Programming Languages: C, SQL, Java, C++, HTML,Microsoft Access, Excel.

PROFESSIONAL EXPERIENCE:

Confidential, Torrance, CA

Cognos BI Consultant

Confidential is the North American Toyota sales, marketing, and distribution subsidiary devoted to the U.S market. Its current headquarters in Torrance, California supervises 14 regional offices. TMS oversees sales in 50 states of Toyota, Lexus, and Scion products through a network of over 1,200 Toyota dealers (of whom more than 900 also sell Scion vehicles) and over 200 Lexus dealers. TMS develops Toyota's television campaigns and other nationwide marketing materials, and supervises dealer marketing to ensure that dealers present a uniform image. Scope of the Project involves development of reports using report studio to see how many customers have attended the event shows conducted by company and how many lead to sales within those customers which results in comparing the sales from current year to previous year. As a result it helps business users to come up with strategies to increase the sales count.Also developed campaigns using UNICA tool upon user request. The data revolves around sales, customer information and the event shows they attended.

Responsibilities:

  • Worked with Business Users and co-ordinate with them to understand and capture data/reporting requirements.
  • Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Analyzed the requirements and created technical design specs for Framework manager, and reporting for the same.
  • Worked on Modeling and Reporting against a Warehouse (OLAP) which is in the form of a Star Schema
  • Created project, namespace (Database View, and Business View), and folders and imported required metadata in Cognos Framework Manager.
  • Provided cardinality, check data usage, identifiers in the database view.
  • Created model query subjects, Data source query subjects, stored procedure query subjects as per the business requirements in the Framework Manager
  • Developed Reports using Report Studio.
  • Involved in modifying the existing Reports based upon the change requested by the user.
  • Developed List Reports, Cross Tab Reports, Charts, Drill through Reports and Master Detail Reports using Report Studio.
  • Developed Framework Manager Metadata model – relational and dimensional.
  • Modified, 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.
  • Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, Page Breaks, Master-detail, Drill Through, Drill Down, Drill Up.
  • Designed reports which show in graphical form using the bar charts, pie graphs and line graph.
  • Developed reports for the rolling time period and match back sales report.
  • Developed and Published Packages in Framework Manager - Connecting and testing the data source, created Database layer, Physical layer and Presentation layer, defining appropriate relationships between query subjects.
  • Created Value prompts, Date & Time prompts, Text box prompts, Cascading prompts and Tree prompts.
  • Used Report Studio, Analysis Studio and Business Insights to create simple to Complex reports.
  • Created Active Reports and used Business Insights Advanced to create reports.
  • Carried out Bursting of reports in Report Studio for monthly and weekly reports.
  • Worked on TOAD with ORACLE as a database.
  • Created folders, filters, power prompts, and complex financial calculations in Framework Manager and Report Studio.
  • Ability to write high level complex queries at the front end to build the reports.
  • Deployed the reports and package from Development to Testing and then Testing to Production environments.
  • Scheduling and Distributing Reports through Schedule Management in Cognos Connection
  • Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements
  • Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
  • Worked on the UNICA campaign tool for the Accessories department.
  • Build the campaigns monthly upon providing the requirements by the user.
  • Worked on testing and executing the campaigns monthly.
  • To blast the campaign for the most recent valid email customers, the term ‘Blast Priority’ has been introduced to avoid over communicating with the customers frequently by introducing the segments after thorough discussion with the users.
  • Blast Priority in campaign resulted in low number of bounced emails.

Environment: IBM Cognos 10.1.1 (Framework Manager, Analysis Studio, Report Studio, Query Studio, Metric Studio), Oracle 11g, SQL Developer, Windows 7, IBM UNICA Campaign 8.5.0.027 and marketing Platform 8.5.0.0.13

Confidential, Mansfield, MA

Cognos BI Consultant

Confidential is a $12 billion global healthcare products leader dedicated to innovation and long-term growth. Confidential creates innovative medical solutions for better patient outcomes and delivers value through clinical leadership and excellence. Scope of project includes migration of Business Objects reports to Cognos. Rationalizing reports to align to business needs, automation of current reports used for contract performance and/or administration, standardization of report development processes.

Responsibilities:

  • Worked with users and coordinated with Business Objects developers to understand and capture data/reporting requirements.
  • Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Developed Reports using Report Studio.
  • Created different reports for YTD and MTD comparisons.
  • In developing a report, used Prompt pages and reports pages using Java Script.
  • Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
  • Created and updated Framework Manager models and published to Cognos Connection.
  • Built flexible Framework Models to handle current and proposed future reporting requirements.
  • Created complex reports in Cognos 10.1 Report studio while replicating the reports from Business Objects.
  • Created Value prompts, Date & Time prompts, Text box prompts, Cascading prompts and Tree prompts.
  • Modified the existing Reports based upon the change requested by the user.
  • Redesigned the reports by using Conditional Formatting like highlighting the data and to show or hide the data.
  • Extensively worked on Performance Tuning of the reports, SQL.
  • Worked on Business Objects i.e, view the data, run the data, sorting, filtering etc to convert existing reports into Cognos.
  • Developed List Reports, Cross Tab Reports, Charts, Drill through Reports and Master Detail Reports using Report Studio.
  • Worked on drill through reports and test the data to be used in testing based on business and user requirements.
  • Wrote SQL queries to understand the code of the Business Objects Universe and implement the changes while building the model in the Framework Manager.
  • Created Technical requirements for developers to build their reports on Cognos.
  • Created Models, Projects and Published Packages using Framework Manager, Implemented best practices in Framework Manager Models.
  • Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
  • Carried out Bursting of reports in Report Studio for monthly and weekly reports.
  • Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements
  • Designed Visual Web Analytics for PCA’s Website Visitors Data and Motion Charts( Tableau, Google Motion Chart Widget).
  • Designed Interactive Visualizations of Fragmentation, Compression, Usage, Query Optimization Statistics for all SQL Server Instances and Databases across entire corporate network.

Environment: IBM Cognos 10.1 (Framework Manager, Analysis Studio, Report Studio, Query Studio, Metric Studio),Business Objects XI Release 2, Oracle 10g, SQL Developer, Windows 7, Tableau.

Confidential, Irvine, CA

Cognos BI Consultant

Confidential is an international pharmaceutical company headquartered in Petah Tikva, Israel. It specializes in generic and proprietary pharmaceuticals and active pharmaceutical ingredients. It is a global leader in consumer products and animal care. It provides different types of complex vaccines, Consumer products and health products. The Project dealt with Migration of reports from Actuate to Cognos.

Responsibilities:

  • Worked with users and coordinated with actuate developers to understand and capture data/reporting requirements.
  • Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Developed Dashboards using Business Insight and business insight advance.
  • Created Active reports for YTD and MTD comparisons.
  • Worked on go office to refresh data in PowerPoint which use Cognos reports as source
  • Customized prompt pages and reports pages using Java Script
  • Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
  • Performed key Project Management roles in analyzing project timelines and man hours required for each individual project, analyzed some of the cost issues and fixed them.
  • Created and updated Framework Manager models and published to Cognos Connection.
  • Built flexible Framework Models to handle current and proposed future reporting requirements.
  • Developed Technical requirements, design requirements and user acceptance documentation by placing Screen shots of actual Report and tested report in documentation.
  • Created complex reports in Cognos 10 Report studio while replicating the reports from Actuate.
  • Worked on drill through reports by creating HTML references.
  • Wrote complex SQL queries to understand the actuate code and implement the changes.
  • Created Technical requirements for developers to build their reports on COGNOS.
  • Worked along with developers to create some of the high level reports for POC to the users.
  • Created Ad hoc and batch reports with complex functionality to replicate the actuate reports.
  • Created Models, Projects and Published Packages using Framework Manager, Implemented best practices in Framework Manager Models.
  • Worked on Performance tuning of report with huge queries using concurrent query execution forbetter performance of report.
  • Carried out Bursting of reports in Report Studio for monthly and weekly reports.
  • Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements
  • Designed Visual Web Analytics for PCA’s Website Visitors Data and Motion Charts(Qlikview) Designed Interactive Visualizations of Fragmentation, Compression, Usage, Query Optimization Statistics for all SQL Server Instances and Databases across entire corporate network.

Environment: IBM Cognos 10.1/ 10.2,Cognos 8.3/8.4 (Framework Manager, Analysis Studio, Report Studio, Query Studio, Metric Studio), Teradata 13, Oracle 10g, Teradata SQL Assistant, Teradata Administrator, PLSQL Developer, SQL Developer, Windows 7,Qlikview.

Confidential, Westfield Center, OH

Sr. Cognos Developer
Life Insurance system is designed and developed for Customer & Services Data Marts enterprise wide. This data warehouse is the data feed for the Universal Reporting System using Cognos as reporting tool. The system is basically designed for assisting doctors in their diagnosis and analysis processes. System requires wide range of reports to be generated to provide help in decision-making. Patient visit details, lab report details, group reports, historical details of patients, analysis reports etc are generated using Cognos.

Responsibilities:

  • Facilitated JAD sessions with external and internal Clients, in order to develop artifacts to support the development and implementation of Enterprise Architecture, Business Transformation, and Systems Development projects.
  • Worked on Totality-Data Mart Project in Cognos 10.1.
  • Worked extensively on Cognos 10.1 with Framework Manager, Report Studio, Analysis Studio.
  • Actively involved in Requirement Gathering from Business Users and Developed Technical Documentations for the Business and IT Team.
  • Created Prototypes for the business showcasing them the Models and future report samples and Dashboards.
  • Created Model Query subjects, Data Source Query subjects, Stored Procedure Query subjects as per the business requirements in the Framework Manager.
  • Designing the Logical model that conforms to star schema concepts, different views (Import, Business, and External) as per Business requirement.
  • Developed and Published Packages in Framework Manager - Connecting and testing the data source, created Database layer, Physical layer and Presentation layer, defining appropriate relationships between query subjects.
  • Used Report Studio, Analysis Studio and Business Insights to create simple to Complex reports.
  • Created Active Reports and used Business Insights Advanced to create reports.
  • Involved in modifying the existing Reports based upon the change requested by the user.
  • Extensively worked on Mobile platforms and access for Ipad.
  • Developed List Reports, Cross Tab Reports, Charts, Drill through Reports and Master Detail Reports using Report Studio.
  • Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, Page Breaks, Master-detail, Drill Through, Drill Down, Drill Up
  • Worked on TOAD with ORACLE as a database.
  • Involved in writing test cases for SIT (System Integration testing) and UAT (User Acceptance testing, Unit testing, Integration testing and System testing of the reports in Development, Testing and Production environments.
  • Involved in resolving Performance issues with various reports.
  • Worked on-shore/off-shore model. Experience guiding a team of 3 off-shore developers.
  • Prepared User Documentation to train users and to explain functionality of each report.

Environment: Cognos 10.1/8.4 suite (Query Studio, Report Studio, Analysis studio), Cognos Power Play Transformer, IBM Cognos Administration, IBM Cognos Express, Cognos Go Office, Teradata 12, Teradata SQL Assistant, Oracle 11g, SQL Server 2005, Process Explorer, Wireshark, Win NT/XP/2003/Vista, Citrix.

Confidential, Chicago, IL

Cognos BI Consultant

Confidential is the world’s leading marketing and media-information Company. The project focus was to create a state of the art BI solution that will address AC Confidential ’s reporting needs from internal and external clients.

Responsibilities:

  • Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
  • Arranged walkthrough sessions with the user group and QA teams to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
  • Installed and configured Cognos 10 BI and worked with Cognos 10 BI modeling, Report Studio.
  • Developed Framework Manager metadata model – relational and dimensional.
  • Modified, 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 Score Cards, Dashboard Reports, Standard Reports, Charts, and Drill through Reports, using Report Studio and Query Studio in Cognos 8.3 and Cognos 10.1.
  • Designed Cognos Power Cubes to provide analytical solutions for complex business requirements.
  • Developed Prompt Page Reports using Conditional blocks and Conditional Variables
  • Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data etc.
  • Created HR Reports based on Employee details, Leavers, Budget vs. Forecast reports etc.
  • Implemented security in reports according to employee groups and roles according to the requirement.
  • Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
  • Created folders, filters, power prompts, and complex financial calculations in Framework Manager and Report Studio.
  • Scheduling and Distributing Reports through Schedule Management in Cognos Connection
  • Creating user groups in Cognos Connection from Active Directory groups.
  • Supported the Cognos Development and Production environment.

Environment:Cognos 8.3/8.4/10.1 BI, Framework Manager, Cognos Connection, Report Studio, Query Studio, Metric Studio, Netezza, Oracle 10G, Windows 2003 server and TOAD, SQL Developer, PL/SQL Developer.

Confidential, San Antonio, TX

Cognos Developer

Confidential offers an online competitive bidding tool that significantly reduces the costs of products and services versus traditional competitive bidding methods. The company has demonstrated through the use of electronic bidding events like the real-time reverse auction, businesses and governmental agencies realize substantial savings versus the traditional paper-based procurement methods. In the transparent marketplace that Confidential creates, customer’s watch live, as real-time competitive bidding events result in lower costs for a variety of products and services.

Responsibilities:

  • Worked closely with Clients and Business Users to analyze and understand business requirements and Participated in requirements gathering meetings / Sessions.
  • Designed and developed highly customized reports in Cognos 8.3 Report Studio and Ad-hoc reports in Query Studio.
  • Analyzed the requirements and created technical design specs for Framework manager, and reporting for the same.
  • Created project, namespace (Database View, and Business View), and folders and imported required metadata in Cognos Framework Manager.
  • Created model query subjects, Data source query subjects, stored procedure query subjects as per the business requirements in the Framework Manager
  • Implemented the best practices of Cognos BI.
  • Created schema prompts, required, optional prompts, parameter files, parameter mappings for automation using macros.
  • Created standard reports in Cognos Report Studio, and Analysis Studio.
  • Responsible to build the Framework Manager Models and packages as per the business requirements.
  • Published the Packages, and provided security in Framework Manager.
  • Developed List, Crosstab, drill-through definitions, multi-query, master/detail, prompted, dashboards, and tabular reports which involved Multiple Prompts, multi-query, Cubes in Report Studio.
  • Designed and Developed Advanced Prompt Pages using various varieties of Prompts and validated the Prompts using Java Script.
  • Created highly Complex Reports using OLAP Cubes as Data Source for Multi-Dimensional Analysis.
  • Designed complex reports with union queries, and SQL queries
  • Improved long running reports performance thru writing SQL queries, resolving complex joins in framework manager, filters, and using stored procedures.
  • Developed number of prototypes for the business users. This project was bases of star schema, OLTP data.
  • Involved in Scheduling and Distributing reports through Schedule Management in Cognos Connection and Burst reports to different user groups.

Environment: Cognos 8.3 BI, Framework Manager, Cognos Connection, Report Studio, Query Studio, Metric Studio, Oracle 10G, UML, Windows 2003 server and TOAD, SQL Developer, PL/SQL Developer.

Confidential

SQL Developer

Confidential provides different financial services. The scope of the project that worked on was to facilitate in the maintenance and development of the application which supported personalbanking on wealth management, asset management, dealing with different types of accounts and services.

Responsibilities:

  • Involved in designing of Conceptual Logical Model and Physical Model.
  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
  • Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
  • Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment:SQL Server 2000/7.0, Oracle 8i, Windows NT, C++, HTML, T-SQL.

Hire Now