SUMMARY

• More than seven years of experience in Cognos BI development and administration with key activities in all of the stages of the SDLC, including installation, configuration, support, analysis, design, testing, troubleshooting, and documenting Cognos BI solutions.
• Technical expertise in data warehousing Relational, Dimensionally modeled Relational DMR , and OLAP Cubes modeling and development, schemas Star and Snowflake , logical data marts and table structures fact and dimension using data modeling tools such as Framework manager, Cognos transformer, and Cube designer.
• Installed, configured and worked on Cognos BI suites, including business insights and advanced, report studio, analysis studio, workspace advanced, Cube designer and Framework manager.
• Developed solutions for management dashboards, BI analytics or Operational BI and documented technology roadmaps through collaboration with the data management, ETL and business teams.
• Delivered solution-oriented complex reports using Report Studio, Ad-hoc reporting interfaces using Query studio, multi-dimensional analysis and visualizations from OLAP cubes using Analysis Studio and Workspace Advanced, dynamic interactive analytics using Active Reports, created checkpoints and alerts in Event Studio, and developed scorecards and metrics in Metric Studio.
• Advanced knowledge of reading and writing SQL/MDX query languages.
• Analyzed SQL/MDX queries in database tools to troubleshoot report performance issues.
• Implemented Web technologies to customize the reporting environment in order to organize and visualize business metrics and KPIs into logical sets of dashboards and data visualizations.
• Customized Cognos connection with appropriate reports, scheduling and maintenance of reports and security measures, defined users, group and role-based access in order to provide access control to events, cubes, views, dimensions, rules, alerts, scorecards, portals and dashboards.
• In-depth Knowledge of SDLC using the iterative and incremental methodologies such as RUP, Agile, Scrum, and non-iterative methodologies like waterfall methodologies.
• Mentored and trained users in report navigation and worked closely with business leaders and data warehouse developers to ensure consistent and accurate reporting using reporting tools.
• Experienced in deploying, migrating, analyzing, performance tuning and optimizing models, packages, reports and cubes from development to QA, and then from QA to production environments.
• Developed and implemented best practices development and modeling standards, tips or techniques, version control, testing and security setup .

SKILLS

EXPERIENCE

Confidential

• Performed Data Analysis to identify data gaps, by generating and comparing reports from EDW with reports from existing BDW legacy system.
• Decomposed models, reports, and cubes from 8.2 consolidated business logic and converted them to a new Cognos 10.2 BI standard template for consistency of look and feel, performance tuning, and hand-off to support team for future support.
• Collaborated with the Data Architects and SMEs on the enterprise data strategy and subsequent foundational initiatives such as data quality improvement process, master data management, metadata strategy, etc.
• Involved in the ETL Mapping team discussions to solve the issues in mapping specification document or design from the old source system to the new EDW.
• Responsible for mapping report fields with Data Marts tables and columns that ultimately led to the creation of framework manager models and cubes with various facts and dimensions in order to meet changing business requirements.
• Created various advanced list, crosstab, charts, dashboard, master-detail, active reports, drill-down, and drill-through reports.
• Developed reports for customized data based on parameters, functions, filters, and conditional variables.
• Worked with the latest RAVE Visualizations in Cognos Workspace Advanced and Report Studio for building interactive reports for the end users.
• Created Dashboards for Cognos portal for everyday access and easy identify of history, performance metrics KPIs , and projections.
• Documented functional specifications, technical specifications and unit testing requirements as assigned.
• Performed Unit Testing on developed reports including data validation spot checks and verification of results against specifications.
• Conducted Performance Testing with realistic data volumes to assess if desired benchmarks are achievable.
• Implemented security to support business requirements.
• Determined scheduling and report distribution or access needs for migrated reports.
• Coordinated the work activities with an offshore team that involved performing code reviews, report design check-lists, gap analysis, and data validation thereby providing technical direction and feedback to offshore support development resources, helping them solve various issues.

Environment: Cognos 8.2 10.1.2 Framework Manager, Transformer, Report Studio, Query Studio, Workspace Advanced, Cognos Connection , Oracle 11.x, Oracle SQL Plus, TOAD for Oracle, Informatica 9.6, JavaScript, Windows 7, Windows Server 2008, Baan 5c, ERP LN

Confidential

• Worked with the Senior Data consultants and ETL developers to design a data mart to support reporting requirements and created Report Specs RS , Data Definition Specifications DDS , Functional Specs FS and Cognos Framework Manager Specs FMS .
• Involved in the dimensional data modeling and populated the business rules using mappings into the repository for data management.
• Collaborated with IT and pharmacy project managers for the production of inter-regional utilization reports, drug cost, and quality initiatives monitoring reports and ad-hoc requests.
• Designed DMR relational models using Framework Manager, data mart models as cubes in Transformer, developed complex BI reporting using multidimensional expressions MDX , and automated scripts of cube builds after the ETL completion for a monthly refresh.
• Created various advanced list, crosstab, charts, dashboard, drill-downs and drill-through reports.
• Created dashboard reports using the Report Studio and Cognos Connection to deliver a Pharmacy Management Dashboard that helped Executives and Managers to monitor performance of pharmacies going live on ePIMS Enterprise Pharmacy Information Management System .
• Maintained development versioning control using TFS that allows check-in and check-out code files such as Cognos FM packages, Cubes, and Report Studio's XML report schemas.
• Tested and validated the report output against the database in order to analyze the SQL codes for problem resolution and performance optimization.
• Deployed packages, folders and content stores from a development environment to test and then to production environments.
• Created audit data sources connected for Dev, QA and Prod environment in order to periodically monitor application usage/system usage.
• Applied security in Cognos connection by controlling privileges for users, groups and roles to the various packages, reports and dashboards.
• Trained the end users to effectively use the reporting tool Query Studio, Analysis Studio, and Business Insight Advanced to build and customize their Ad-hoc reports.
• Responsible for implementing best practices on Cognos report designs, development and testing.
• Developed and documented a technology roadmap through collaboration with infrastructure and technical support engineers to provide technical direction for Cognos 10.2.1 installation/upgrades.

Environment: Cognos 10.1.1 Framework Manager, Transformer, Administration, Report Studio, Analysis Studio, Query Studio, Business Insight Advanced, Cognos Connection , Oracle 11.2, Oracle SQL Plus, TOAD for Oracle, JavaScript, Microsoft TFS, VisualCron, Windows 7, Windows Server 2008 R2

Confidential

• Developed complex data models and reports according to business rules specified by Business Analysts in functional design documents and report layout mockups.
• Worked effectively with the DW/ETL team to optimize the database through techniques including data elements and relationships, appropriate indexes, partitioning strategy, and summary tables.
• Researched and defined items for creating dimensions having multi levels of granularity and base measures under Dynamic Cubes advanced calculations and aggregate rules for metrics under a Virtual Cube and mapped data items for summarized fact tables under Aggregate Cubes.
• Utilized multidimensional expressions MDX to add advanced calculated members to the Virtual Cube and other dynamically calculated values to the Report Studio reports.
• Created DMR models, published the packages using Framework Manager with Governor settings to restrict unnecessary querying, and then generated reports based on these packages.
• Developed crosstab reports for customized data based on advanced conditional rendering/formatting, master-detail relationships as lists and repeater tables, conditional blocks, exception highlighting, slicers, filters, parameter displays, and aggregate functions.
• Implemented JavaScript Prompt API functionality, built parameter maps, and referenced parameter functions for tree and value prompts in order to get a more cohesive path for the users to navigate through prompt pages.
• Created a reporting template with local classes and layout component references to be used by report studio developers.
• Created active reports for more interactive behavior in offline reporting.
• Designed the company's portal page having sectioned views for scheduled reports and dashboards, alerts, ad-hoc capabilities, and scorecards to give users a 'homepage' for their reporting needs.
• Assisted the ETL team to build Teradata BTEQ scripts and make Korn Shell script modifications for data loading and unloading in UNIX.
• Worked on performance tuning, query optimization, break-fix activities, validation, and testing of framework models, dynamic query cubes, and reports at different stages of development.
• Deployed packages and reports from development servers to UAT and from UAT to production.
• Maintained a spreadsheet log of the validation statuses, issues and errors of models, data items, and measures and resolved them with the BI team, prioritized by scheduled moves to production.
• Documented all phases of work including gathering requirements, join relationship diagrams, database diagrams, report layouts and other program technical specifications using current specified design standards for new or revised solutions.

Environment: 10.2/8.4/7.3 Report Studio, Active Reports, Framework Manager, Workspace Advanced, Cube Designer, PowePlay, Cognos Connection , Teradata SQL Assistant v13.0, Teradata Viewpoint 14, BTEQ JDA Assortment Planning v8.0, JavaScript, SharePoint, UNIX Shell Script, Windows XP

Confidential

• Worked closely with business users to define reporting requirements and documenting the requirements in order to design, develop, maintain, and secure Cognos reports.
• Coordinated with the ETL team to design Data Marts by understanding user requirements and increasing the reporting efficiency.
• Developed Metadata models and DMR models using Framework manager.
• Created filters, prompts, calculations, summaries and functions in Framework manager as per the functional requirement specifications.
• Implemented Framework manager security for row level access and package access based on the department, region and store level.
• Created simple to complex reports as well as dashboard like reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, block, tables, charts, master-detail, maps, various calculations and joins using tabular sets and models.
• Performed a burst of reports against the regions, districts, and stores for delivering by email, appropriate outputs to the concerned district managers and team ambassadors in Cognos connection.
• Created several different types of Ad-hoc simple list, grouped list, section heading, crosstab, and nested crosstab reports and represented data graphically by charts using Query studio.
• Created cube and partitioned cube manually, added User Class views, Dimension Views, and drill through capabilities using various data sources in transformer to be analyzed in analysis studio.
• Worked on business insight and business insight advanced for creation of dashboards in order to provide a single integrated and self-service advanced authoring environment for business users.
• Created agents and added tasks in event studio to run reports based on specific business criteria.
• Designed different scorecards, metric types, UDCs and custom groups for field reports such as daily and weekly sales and traffic in the Metric packages.
• Interacted extensively with information services, being a key resource in most phases of the sales and traffic reporting capability development lifecycle, serving as a liaison between IT and end users.

Environment: Cognos 10.1.1 Report Studio, Query Studio, Cognos Connection, Framework Manager, Analysis Studio, Event Studio, Metric Studio, Metric Designer, Transformer, Business Insight and Advanced , Unica Campaign, Oracle 10g, TOAD 10.6, HTML, MS-Access/Excel/SharePoint, JDA Retail Ideas, Google Analytics, Windows XP

Confidential

• Worked with business analysts, client users and internal systems resources on Cognos installations, upgrades, troubleshooting, and bug resolution.
• Created models using Framework manager consisting of star schemas, dimensions, facts, calculations, links and multiple namespaces, applying proper securities and publishing packages.
• Collaborated with the ETL/Informatica teams to determine the necessary data models and UI designs to support Cognos reports by defining relevant attributes, dimensions, hierarchies and metrics.
• Developed list reports, cross tab reports, chart reports, reports with multiple prompts, cascading prompts and filters, conditional formatting, and multi-page layouts in Report Studio to respond to the complex business requirements.
• Worked with global drill, through definitions to drill through from analysis studio reports to report studio reports MOLAP - ROLAP .
• Created scorecards and dashboards with drill-through capabilities for analysis purposes to enable managers to monitor progress and results for sales and marketing data.
• Created tabular sets with except, intersect, and unions, as well as master-detail queries, dashboards and multi-dimensional reports using Report Studio.
• Created multi-dimensional cubes using PowerPlay transformer.
• Performed pivoting, drill-down, slice and dice and filtering operations for all OLAP applications.
• Developed shell scripts to build PowerCubes and automation of cubes refresh on the server in terms of batch modes.
• Managed scheduling reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection.
• Involved in preparing technical design specifications for the reports, and transferred technical knowledge specific to Cognos tools and the existing data model to other team members.
• Worked with the QA teams to design test plans and test cases for User Acceptance Testing UAT .
• Evaluated by troubleshooting, the data discrepancies and other issues in the canned reports, discovered by the users during the UAT phase.

Environment: Cognos 8.4 and 8.4.1 Cognos Connection, Framework Manager, Report Studio, Query Studio, Metric Studio, and PowerPlay Transformer , Cognos Dashboard, Microsoft Excel/Visio, IIS 6.0, UNIX Shell Scripting, Informatica 8, SQL Server 2005/2008 R2

Confidential

• Effectively partnered with finance customers ensured consistent and accurate flow of the information from business project sponsors to application/database developers.
• Communicated with business users, business analysts to analyze, design, developed the Cognos reports, dashboards, and DMRs.
• Implemented dimensional modeling and star schema grouping in Framework managers from a Cognos planning database.
• Developed using Report Studio, advanced functionalities such as building complex prompt pages, render variables parameters and parameter passing, master-detail, drill downs vs. drill through, various calculations, union and join queries and generated and troubleshooting report SQL.
• Worked extensively on various report layouts such as chart, list, crosstab and repeater for presenting the data in efficient manner in Report Studio.
• Performed data analysis for verifying Regional Data Warehouse RDW data, by generating and comparing reports from RDW with reports from existing legacy systems.
• Created the data level security for various objects like PandL, market summary, and Fact Query subjects in the Cognos Framework Manager to restrict users to access the level of data.
• Involved in the generation of different reports for different sets of data to target customer segments, in order to slice and dice and drill-through data for multidimensional OLAP analysis.
• Prepared end user documentation on models, packages, and reports for end users that help in using the developed reports and build ad-hoc reports using Query Studio.

Environment: Cognos 8.2 and 8.4 Framework Manager, Cognos Connection, Report Studio, Query Studio , Cognos Planning, PowerPlay Transformer 7.3, PowerPlay Enterprise Server 7.3, Oracle 9i, TOAD, HTML, JavaScript

Confidential

• Worked with the company in their efforts to upgrade from a Microsoft access and excel reporting system, to a more efficient data warehouse which utilizes Cognos.
• Worked in conjunction with the Oracle database team to design a data warehouse and Framework manager Metadata Model to work with the imported data.
• Developed and maintained Cognos impromptu and ReportNet reports for various IBM host applications and resolved data issues by interacting with various host teams across the world.
• Presented technical and functional flow of the application to client on report design and was involved in meetings to discuss technical challenges.
• Performed functional, technical testing and participated in application validation including QA efforts as they pertained to reporting, data, metrics, and report creation and executions.
• Integrated reports such as channel inventory details, sales out, and buy/sell detail to project Websites and monitored permissions to required members according to the business guidelines.
• Developed and maintained IBM Buy Analysis Tool iBAT Cognos reports for integrated supply chain management that combined innovative forecasting and inventory analytics with up-to-date visibility of inventories and channel sales information.
• Developed technical solutions for the delivery of auto generated mails to clients for proactive alerting stock-out/excess inventory situations.
• Evaluated data integrity issues in reports by interacting with DBA and technical teams.
• Executed advanced troubleshooting and performance monitoring of the IBM e-Commerce application by coordinating with multiple teams across the globe.
• Performed duties related to migration and conversion of data in present systems to one centralized database structure of the Oracle FLEXCUBE.
• Provided application consultancy to Canara Bank on pre and post migration issues i.e. RTGS, NEFT, ATM Transactions and e-Banking services .
• Delegated and managed performance and maintenance of Talisma CRM servers.

Environment: Cognos Impromptu and Impromptu Web Reports IWR 7.2, PowerPlay Transformer 7.2, Cognos ReportNet 1.0 Framework Manager, Query Studio, Report Studio , SQL Loader, Windows 2000, Oracle 8i, Oracle FLEXCUBE, UNIX, Windows 2000/IBM-AIX, IIS 5.1, Talisma Server