SUMMARY

• Senior - level Business Intelligence / Data Warehouse practitioner with substantial years of experience in all aspects of analytics and optimization, software engineering, systems development life cycle (SDLC) with applications implemented across a wide spectrum of industries and organizations both local and international.
• Worked as a client-facing consultant for IBM's Business Analytics and Optimization group concentrating in the Financial Sectors. (insurance, banks and mortgage institutions).
• Well-versed in the whole gamut of BIDW tools and proven practices with core competencies in designing, building, configuration management and implementation of business applications specifically using Cognos products
• IBM-certified Cognos metadata modeler, report designer, and administrator.
• In-depth knowledge of Cognos tool sets (10.2.x (Business Workspace, Business Workspace Advanced, Cognos Connection, Framework Manager, Report Studio, Analysis Studio, Event Studio, Query Studio, Powerplay Transformer, Powerplay Studio, Cube Designer -Dynamic Cubes), Cognos 8.x and Cognos Reportnet, Impromptu 7.3, Cognos Power Play Enterprise Server 7.3, Power Play Transformer.
• Advanced Cognos BI development using SDK, Java, Javascript, HTML
• Expertise in multi-tiered (Business Layer, Intermediate Layer, Presentation Layer, Hierarchies, macros and folders) data modeling using Framework Manager and Transformer for multi-dimensional OLAP modeling.
• Migration expertise across different versions of Cognos.
• Strong knowledge of Cognos security implementation on all levels.
• Practical experience of Cognos integration with third-party ERP packages (SAP, Peoplesoft, TM1)
• Thorough understanding of Cognos products for enhanced reporting like dashboards (Cognos Insight/Workspace), scorecards and portal pages over the web and Cognos connection.
• Best practices knowledge in solving business problems with maximum view towards win and success.
• Hands on experience with implementation of full life cycle (SDLC) and Agile BI Projects.
• Strong and deep applications, honed in years of practical usage, of technical tools needed to build solutions.
• Good communicator and a bridge between business and technical users.
• Cross-industry exposure (financial services, telecommunications, energy, healthcare, entertainment, government and public agencies, retail and distribution, manufacturing).
• Proven ability to generate business requirements into functional and technical documentations and clearly communicate gaps as well as change management issues.
• Experience in different database platforms (Oracle 11g/9i/8i, Teradata, MSSQL, MySQL, DB2) as well as their respective scripting technologies (PL/SQL, T-SQL, Stored Procedures, Functions, Triggers) on UNIX and Windows environments.
• Excellent skills in writing, developing database stored procedures, views, triggers, alerts, packages, and functions.
• Extensive knowledge of Data warehousing methodologies and concepts - Star schema, Snow-flake Schema and worked on both OLAP and OLTP databases.
• Developed High Level Design Document (HLD), Business Requirement Document (BRD), Data Flow Diagram (DFD), Test Cases, Guideline document, Best Practices and User Manual.
• Interacted with customers and business users for requirement gathering, effective analysis and imparting end-user training.
• Experienced in business requirements definition and converting them into functional specifications and in creating Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams and Class Diagrams with good knowledge of Business Process Modeling tools like UML, RUP and Rational Suite.
• Developed training courses and trained business executives and end-users

PROFESSIONAL EXPERIENCE

Confidential

Cognos Consultant

Roles/Responsibilities:

• Cognos Cloud and TM1 back-end reporting
• FP&A technical support
• Advanced report development
• Report optimization
• Prepared user documentation to train users and functionality of each report.

Technologies: Cognos 10.2.2 (Cloud infra, TM1, Dynamic Cubes, MDX, CAFE, Cognos for MS Office)

Confidential, Encino, CA

Consultant, Cognos Modeling/Report Development

Roles/Responsibilities:

• FM Data Modeling,
• Advanced report development
• Report optimization
• Prepared user documentation to train users and functionality of each report.

Technologies: Cognos 10.2.2 (Framework Manager, Cognos Connection, Query Studio Report Studio, SQL Server

Confidential, Madison, WI

Consultant, Cognos-Oracle CC&B Integration

Roles/Responsibilities:

• Functional Analyst, Oracle CC&B and Cognos report design specifications
• Cognos report developer

Technologies: Cognos 10.2.x (Framework Manager, Cognos Connection, Query Studio Report Studio, Oracle Database 10g, TOAD, CC&B

Confidential, Schenectady, NY

Cognos Solution Architect/Consultant

Roles/Responsibilities:

• Developing Framework Manager Models in multi-tiered layers Physical, Intermediate and Presentation layers.
• Worked on resolving the Performance issues of the Cognos reports.
• Communicating with other team's members (Development Team, Technical Support, Business Support) in order to resolve the issues.
• Prepared user documentation to train users and functionality of each report.
• Developed cubes for higher level management.
• Involved in deployment and scheduling.
• Updating the project status to the team in weekly status meeting.
• Working closely with ETL teams during designing Summary tables/ views/ materialized views for reporting.
• Installation and Configuration of Cognos over a distributed environment.
• Designing Cognos Security architecture and implementation of single sign-on.
• Administration of tasks such as scheduling, deployment, dispatchers and jobs.
• Successfully migrated reports with zero impact on Production.
• Dimensional Modeling (Star and Snowflake schemas, DMRs, Custom Security) using Framework Manager.
• Advanced report design (Dynamic Sorting, Data Entry Validations, Drill-Through, Java Scripts, conditional formatting, cascading prompts, complex filters. Tab Prompts. Reports on OLAP Data Sources and bursting reports) using Report Studio.
• Cube Development using Transformer, Automating the Cube refresh process and implementation of advanced design concepts like Drill-through across tools (like drill-through from a Cognos Powerplay cube to a Reportnet/Cognos 8BI Report).
• Developed advanced reports using MDX with TM1 cubes consumed as datasource
• Review Query execution plans, Performing Database optimization and SQL tuning
• Developed Business intelligence Prototypes and reporting solutions that help end users access and analyze data in the data warehouse, data mart, or operational systems.

Technologies: Cognos 10.x (Framework Manager, Business Insight, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio, Cognos Administration), TM1, JavaScript and HTML, Netezza

Confidential, New York

Senior Consultant, Business Analytics and Optimization

Roles/Responsibilities:

• Analyzing requirement and preparing Report requirement documents and creating the Framework manger model.
• Used MDX functions to support multi-dimensional reporting.
• Designing the logical model that conforms to star schema concepts, different views (import, business, and external) as per Business requirement.
• Creating the views as per the business and reporting requirement. Creating the Determinants for the Views.
• Implemented Framework manager security for data access, object level access and package access.
• Developing the list reports, charts, drill through reports, master detail reports and multilingual reports using Report Studio and Query Studio.
• Analyze the performance of reports by programming SQL against the back-end DB and compare it with report run time.
• Import views to the Framework manager model and set the cardinality between them as per the business requirements.
• Setting up cardinality (minimum, maximum and optional), determinants to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Developed list, cross tab, drill through, master-detail, chart and complex reports which involved multiple prompts in Report Studio, burst reports against database.
• Adding business rules by defining different kinds of calculations and filter.
• Working experience with different date functions in Report Studio.
• Developed advanced reports using MDX with TM1 cubes consumed as datasource
• Troubleshoot end user issues with report and performance.
• Resolve tickets opened by end users for various problems.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Deploying the reports and package from Development to testing, Testing to Production environments.
• Developed a logical model that conforms to star schema concepts, different views (import, business, external) as per Business requirement
• Experience in writing with Javascript script and HTML in Cognos Report Studio reports based on requirements.
• Passing the prompt parameters in Report Studio reports using script.
• Dynamic sorting the Llist report Columns based on the requirements.
• Displaying the default date to yesterday date in date prompt.
• Create new page in the Cognos connection and embedded the different reports in the same page.
• Applying the security to display data based on the user security.
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
• Worked along with other administrators on Cognos migration.
• Experience in creating Client documents like Technical Design Document, Unit Test Execution Plan, Test Case Evidence and Explain Plan for developed reports

Technologies: Cognos 10.2.x (Framework Manager, Business Insight, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio, Cognos Administration), TM1, Business Objects, JavaScript and HTML, Oracle Database 10g, TOAD, SQL Scripts, PL/SQL.

Confidential, New York, NY

Consultant, Cognos Administration

Roles/Responsibilities:

• Involved in the complete cycle of Project Plan, Design, Installation, Development, Testing, Production Cut-over, End User Training and Post Production Maintenance of the system.
• Assigned security for users on folders, business units, Report studio, Query studio, Analysis studio and Metrics studio in DEV, UAT and PROD environments.
• Created data sources for new Packages/Power play Transformer Cubes in Cognos connection.
• Built the cubes on testing and production environments.
• Built the incremental cubes on testing and production environments.
• Monitored the report status and performance as part of daily job.
• Developed advanced reports using MDX with TM1 cubes consumed as datasource
• Changed data source manually for all the reports to fulfill the mock conversion from dev to test.
• Edited system.xml file for creating global templates.
• Created folders as per Business Units (LOB) in Cognos connection and set user class security.
• Added User Folder, User class and Users in Development, Testing and Production environments.
• Created new Users in Cognos importing text files in testing and production environments.
• Worked on Audit Package to generate reports.
• Administer user access protocols and manage user accounts and access privileges.
• Worked with ETL team for trigger file Modifications/status.
• Produced technical documentation in a professional manner to understand Cognos installation.
• Experience with Cognos servers and Cognos client software installation and configuration.
• Responsible for solving developer issues and performance tuning.
• Ability to support multiple instances of the product in Development, Test and Production in distributed environments (AIX and Windows).
• Configured, administering an authentication source that contains security information about users, user classes, user profiles, servers and data sources.
• Configured multiple user classes, defined dimension views and user class views for different user groups to provide high security for highly sensitive data.
• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Administer user access protocols and manage user accounts and access privileges.
• Used Framework Manager in building the models, cubes using different data sources.
• Created List Reports, Cross-tab Reports, Chart Reports, Repeaters, and Master Detail Reports using Report Studio.
• Created Query Prompts, Calculations, Conditions and Filters in the reports.
• Developed Prompt Pages and Cascaded input Prompts to display only the selected entries in the report.
• Closely involved in security administration.
• Closely worked with ETL team to design data marts by understanding user requirements and increasing the reporting efficiency.
• Created complex reports using Report Studio to meet business requirement
• Business Data Analysis, Design, Development of Multidimensional OLAP Cubes, deployment and provided drill-through targets to another cube, Power Play Portable Reports, Impromptu reports and Report Net reports.
• Tested the metadata model and relationships in Framework Manager.
• Communicated with users and other technical roles to understand critical error fixes, non-critical error fixes, and application enhancements that require a change to the system baseline.
• Created Dashboards based on requirements.
• Troubleshooted Cognos problems and tuned for performance.
• Provided administrative support for production issues.
• Performed cubes, report unit, system and acceptance testing.
• Involved in data migration process between different versions of Cognos.
• Addressing the performance and other Production issues with the Cognos 8 BI reports and Power Play cubes.
• Provided documentation, training users and Business Partners on Query Studio for ad-hoc Reporting.

Technologies: Cognos 10.2.x (Framework Manager, Business Insight, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio, Cognos Administration), TM1, Business Objects, JavaScript and HTML, SQL Scripts

Confidential, Berkeley Heights NJ

Consultant, Cognos Development

Roles/Responsibilities:

• Developing Framework Manager Models in multi-tiered layers Physical, Intermediate and Presentation layers.
• Worked on resolving the Performance issues of the Cognos reports.
• Communicating with other team's members (Development Team, Technical Support, Business Support) in order to resolve the issues.
• Prepared user documentation to train users and functionality of each report.
• Developed cubes for higher level management.
• Involved in deployment and scheduling.
• Updating the project status to the team in weekly status meeting.
• Working closely with ETL teams during designing Summary tables/ views/ materialized views for reporting.
• Installation and Configuration of Cognos over a distributed environment.
• Designing Cognos Security architecture and implementation of single sign-on.
• Administration of tasks such as scheduling, deployment, dispatchers and jobs.
• Successfully migrated reports with zero impact on Production.
• Dimensional Modeling (Star and Snowflake schemas, DMRs, Custom Security) using Framework Manager.
• Advanced report design (Dynamic Sorting, Data Entry Validations, Drill-Through, Java Scripts, conditional formatting, cascading prompts, complex filters. Tab Prompts. Reports on OLAP Data Sources and bursting reports) using Report Studio.
• Cube Development using Transformer, Automating the Cube refresh process and implementation of advanced design concepts like Drill-through across tools (like drill-through from a Cognos Powerplay cube to a Reportnet/Cognos 8BI Report).
• Review Query execution plans, Performing Database optimization and SQL tuning
• Developed Business intelligence Prototypes and reporting solutions that help end users access and analyze data in the data warehouse, data mart, or operational systems.

Technologies: Cognos 10.x (Framework Manager, Business Insight, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio, Cognos Administration), Business Objects, JavaScript and HTML, Oracle Database 10g, TOAD, SQL Scripts, PL/SQL.

Confidential, Waukegan IL

Consultant, Cognos-SAP Integration

Roles/Responsibilities:

• Managed deployments in different environments (Development, QA and Production).
• Provided IT service management solutions such as change, release and configuration management with Tools TFS and Subversion.
• Used MDX to support multi-dimensional reporting.
• Analyzed change impacts related to IT and business process controls.
• Analyzed the existing data mart and performed SQL data analytics to provide value to the business.
• Designed and created conceptual and logical data model to support multi-tenant data structures.
• Responsible for designing a logical dimensional model for the Product-User data mart.
• Followed standards, guidelines for abbreviations, class words and naming standards for data model.
• Created intermediate Star-Schema reporting layer using custom SQL views.
• Created filter and router transformations using Informatica.
• Created Cognos Framework Manager models (relational and dimensional).
• Created dashboard and scorecards prototypes using Cognos business Intelligence tool considering price strategist metric needs, industry standards and experience.
• Created complex dimensional reports in Cognos business intelligence Report Studio tool using MDX functions.

Technologies: Cognos 10.x (Framework Manager, Business Insight, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio, Cognos Administration), Business Objects, JavaScript and HTML, SAP BEx

Confidential, King of Prussia PA

Cognos Solution Architect/Consultant

Roles/Responsibilities:

• Analyzed business requirements and designed functional and technical requirements documentation.
• 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.
• Implemented security with LDAP and group level security in Cognos Connection Portal.
• Implemented Framework manager security for data access, object level access and package access based on the organization Level.
• Developed list, cross tab, drill through, master-detail, chart and complex reports which involved multiple prompts in Report Studio Worked on bug fixing and enhancements to existing Cognos reports in Report Studio and models in Framework Manager and development of any new reports.
• Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
• Worked on Analysis Studio to develop multi-dimensional reporting.
• Analyzed Business requirements from the analysts involved to analyze and map data from source systems to target operational data stores and data marts (data warehouse).
• Developed Cognos multi-dimensional cubes and published cubes in Analysis Studio to analyze the business reports.
• Customized Cognos Connection with appropriate reports and security measures.
• Implemented security with LDAP and group level security in Cognos Connection Portal.
• Created reports with optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Created drill through reports from dashboard to all summary/Trend reports, trend reports to summary reports and summary to detail reports.
• Developed Dash board reports to display all the information related to environment using Summary reports.
• Involved in training users about Business Insight interface where they can easily access all kinds of data in one work area.
• Experience in deploying reports, migrating objects and testing reports in different environments.
• Involved in end-user Cognos training

Technologies: Cognos 8.x (Framework Manager, Business Insight, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio, Cognos Administration), Business Objects, JavaScript and HTML, Oracle Database 10g, TOAD, SQL Scripts, PL/SQL.

Confidential, New York NY

Cognos Solution Architect/Consultant

Roles/Responsibilities:

• Involved in gathering business requirements and Interacted with the users and business analysts for better understanding of the reporting requirements.
• Involved in strategic planning for Framework Manager models.
• Interacted with development and management teams and provided technical assistance to developers
• Designed metadata models using Framework Manager and published packages to the Cognos connection.
• Created new Query Subjects and arranged in different Folder structure for Business View
• Created row level securities for all framework structures
• Formulation of joins, resolving relationship, cardinality in Framework Manager
• Created predefined filters in the metadata models.
• Worked on the upgrade project, involved in designing and development of new reports within Cognos environment
• Involved in the development of models using Framework Manger
• Developing complex dashboards using globally parameterized filtering in Cognos
• Involved in migrating reports from Brio to Cognos.
• Involved in discussion and was a part of the leadership team delivering reporting and planning solutions in a dynamic environment.
• Developed standard dashboard reports using multi-dimensional data, charts, drill-through reports, master-detail reports and burst reports using Report Studio and Query Studio
• Created conditional blocks, filters and other prompts for dynamic selection for users
• Scheduled and run reports through schedule management in Cognos Connection
• Responsible for report administration, and security setup and supported production related issues.
• Ensured all project related documentation is accurate, comprehensive, and current
• Interacted with the end users on a regular basis for resolving issues pertaining to the reports.

Technologies: Cognos 8.x (Framework Manager, Business Insight, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio, Cognos Administration), Business Objects, Brio, DB2

Confidential, Los Angeles CA

Cognos Solution Architect/Consultant

Roles/Responsibilities:

• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and fact Table in Framework Manager (Metadata Modeling).
• Developed list, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio using MDX and create the scorecard reports using the Metric Studio.
• Involved in customizing reports using Java Scripts and migrate the reports and packages to different environments.
• Developed reports using System Development Kit (SDK) by java scripts at the back end.
• Customized Reports using HTML and Javascript.
• Created regularly scheduled automated jobs to load data structures
• Customized Cognos Connection with appropriate reports and security measures.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Involved in Designing DMR models with relational data using Framework Manager and deployed packages to the Report Servers.
• Implemented Framework Manager Security for Data access, Object level access and Package access based on the Organization Level.
• Upgrade the report and packages version of COGNOS from 8.2 to 8.4 and Participate in the regression testing and unit testing.
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio & models in Framework Manger and development of any new Reports.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Modeled metadata from Oracle data source for use in Report Studio and Query Studio using Framework Manager.

Technologies: Cognos 8.x (Framework Manager, Business Insight, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio, Cognos Administration), JavaScript and HTML, Oracle Database 10g, TOAD, SQL Scripts, PL/SQL.

Confidential,San Bruno CA

Cognos Solution Architect/Consultant

Roles/Responsibilities:

• Gathered Business Requirements to develop reports using IBM Cognos as enterprise reporting
• standard for Supply Chain and returns management systems.
• Analyzed, designed, built and tested reporting solutions based on business requirements.
• Created Framework Manager models including relationships, filters, aggregations, rollup processing, calculations, organized folders, merged query subjects, aliases, shortcuts, database layer, business layer, presentation layer, and have setup data/object security and successfully published the packages.
• Created different kinds of complex reports that required precise formatting based on business requirements.
• Created different reports using Query Studio and Report Studio.
• Developed various reports like List reports, Cross Tab reports and Drill through Reports using Report studio.
• Developed several complex reports using cascaded prompts, Drill Through, master-detail relationships, Page sets, Joins, Unions using report studio.
• Worked extensively on conditional variables utilizing conditional explorer in report studio.
• Created, organized and formatted reports, folders and other contents on Cognos Connection portal.
• Created joins with queries in Report Studio to generate the required Report queries
• Extensively worked on Dashboards using report studio including render variables, master-detail relationships, singletons, prompts, filters, Conditional variables, HTML items, layout component reference and formatting the objects within report design.
• Tested reports for uniqueness of data using TOAD.
• Worked on defects/enhancements using IBM Serena Business Management tool and fixed a number of Cognos reports and had them moved to Production environment.
• Scheduled and bursted reports in HTML/Excel 2007/PDF formats to the end users based on the business requirements.
• Also performed unit/system testing of the reporting application including analysis of the data and wrote a number of SQL queries against Oracle database using Toad 10.6.
• Involved in upgrading existing reports in cognos 8.4 to cognos 10.
• Developed complex dashboards.
• Interacted extensively with Business Users in formulating user requirements, project enhancements and solving issues.
• Applied Security and User Authentication to the various User Groups.
• Resolved technically complex assignments and mentored junior staff.
• Worked on Toad for writing, updating and modifying the SQL Queries.
• Used Oracle Warehouse Builder to get the data from the target databases/datawarehouse.

Technologies: Cognos 8.x (Framework Manager, Business Insight, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio, Cognos Administration), Business Objects, JavaScript and HTML, Teradata, Oracle Database 10g, TOAD, SQL Scripts, PL/SQL.

Confidential, Foster City CA

Cognos Solution Architect/Consultant

Roles/Responsibilities:

• Advised the client on performance improvement optimization of various Cognos reports
• Made recommendations towards the development of new code or reuse of existing code.
• Participated in component and data architecture design.
• Interact with business analysts and IT analysts to efficiently and clearly interpret business requirement specification into detail reporting specification.
• Created detail Cognos reporting specifications.
• Created and maintained Cognos packages in Framework Manager.
• Performed report data analysis and created Cognos reports with complex SQL queries for items with different drill-through definitions, conditional blocks, drill-down items and different types of render variables.
• Developed Cognos Business Insight dashboard reports with various chart types.
• Worked under client service requests tickets issues, answered BA questions for reports data and layout.
• Mentoring application team in report and dashboard designs.
• Maintained different namespaces, groups and roles in Cognos Connection.
• Executed scheduling and distributing reports through schedule management in Cognos Connection.
• Performed Cognos Administrator functions.
• Provided on call support for client Cognos issues.

Technologies: Cognos 8.x (Framework Manager, Business Insight, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio, Cognos Administration), Business Objects, JavaScript and HTML, Oracle Database 10g, TOAD, SQL Scripts, PL/SQL.

Confidential, Bloomington IL

Cognos Solution Architect/Consultant

Roles/Responsibilities:

• Worked on Cognos Framework manager to import metadata from multiple data sources and to create subject-oriented business models, create and publish packages to Cognos 8 server.
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Used MDX functions to support multi-dimensional reporting.
• Creation of procedures, views, tables and functions according to business requirements in Oracle.
• Involved in migrating metadata and reports from Cognos 7 to Cognos 8 using utilities.
• Authored Reports using Report Studio and trained end users in building ad-hoc reports using Query Studio.
• Creating list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.
• Extensively worked in scheduling and deploying (staging to production) reports.
• Worked on complex reports using tabular objects, static prompt conditions.
• Built Power Play Reports based on these cubes and published to ReportNet Server.
• Developed advanced multi-dimensional reports using MDX functions.
• Successfully implemented the set-based design and join forcing conditions
• sub-quries and data synchronization techniques
• Helped the remaining team to resolve Computation and MultiValue errors in the reports
• Identifies, researches, and resolves ETL root cause of production issues or system problems.
• Performance-tuned ETL programs, Maintenance and enhancements of ETL code.
• Assisted client in training activities to the Business users
• Assisted client in creating business documentation based on the Cognos Framework Manager package. .

Technologies: Cognos 8.x (Framework Manager, Business Insight, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio, Cognos Administration), Cognos SDK, Multi-dimensional reporting using MDX, SAP Bex

Confidential, Madison WI

Cognos Solution Architect/Consultant

Roles/Responsibilities:

• Migrated cubes, reports from Version 7 to C8 using the migration utilities.
• Upgraded the environment from Cognos 8.1 to Cognos 8.2
• Creating cross-tab reports and chart reports using multiple queries and drill down capabilities in a single report to meet the business needs.
• Used MDX dimensional functions to build crosstab reports from cube datasource.
• Built Power Play Reports in Report Studio and Analysis Studio based on cubes published to Cognos Server.
• Built Power Play Reports in Report Studio by replicating the powerplay functionality in Report Studio using dynamic measure selection, dynamic sorting, ranking.
• Created dashboard reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
• Customize the Cognos connection portal using existing portlets and customized tabs.
• Worked on complex reports using static prompt and MDX functions and union conditions.
• Used Cognos SDK for passing prompt parameters to report studio reports.
• Customized reports using Cognos SDK and integrated with Portal.
• Used Java script for dynamic sorting of columns in list, cross tab reports.
• Used Cognos Office Connection to publish the reports in Powerpoint and format them for business presentation.

Technologies: Cognos 8.2 (Report Studio, Analysis Studio), Cognos Series 7.3/7.4 (Impromptu, Transformer), Cognos Office Connection 8.1.0, Oracle 9i, Toad, Tivoli LDAP, Cognos Migration Tools

Confidential, Scottsdale AZ

Consultant

Roles/Responsibilities:

• Installed and configured the Cognos 8.4 BI server environment, administering the servers, troubleshooting, performance tuning and implementing security, managing users, user groups and roles in the organization.
• Involved in requirement gathering from Business Users and developed Technical Documentation for the Business and Team.
• Created customized ad-hoc packages in Framework Manager for Query Studio users.
• Developed Framework Manager DMR models and PowerPlay Transformer cubes for reporting by Analysis Users.
• Created custom views in PowerPlayTransformer model to limit access to information in a cube to members of a given user class.
• Customized Cognos Connection with appropriate reports and security measures
• 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)
• Modifying the existing report based upon the change request by the user.
• Created a Metric Studio application by defining and creating scorecards, metric types, qualifiers and metrics.
• Loaded data to staging area and Metric store using flat files, relational tables and Transformer cube source.
• Extensively worked with stored procedure Query Subjects in FM and reports.
• Created diagrams and added reports to scorecard application.
• Created dashboard reports from cube using Report studio and adding it to the portal page using HTML Items for critical performance metrics Operations, Sales, Human Resources, Information Technology, and Standards using MDX functions.
• Created batch script to update and publish Cognos Powerplay cubes daily.
• Analyzed the accessibility of the Product & Developed evaluation sheet within the context of overall product priorities, timing and cost.
• Used Enhanced suppression in Cognos 8.4 Report Studio by suppressing reports against dimensionally-modeled relational, and OLAP sources.
• Used Java Script for passing prompt parameters to report studio reports.
• Developed PL/SQL Stored Procedures, functions and views in database to improve the performance of Cognos Report Studio reports.
• Upgraded Framework Manager packages, Transformer cubes and Report Studio reports from 8.3 to 8.4.

Technologies: Cognos 8.3/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio), Cognos Series 7.4 (Impromptu, PowerPlay Transformer, PowerPlay), Oracle 9i/10g/ (SQL/PLSQL), Cognos Access Manger

Confidential, Burlington MA

Senior Consultant

Roles/Responsibilities:

• Integrated Cognos with SAP datasource.
• Worked with Business Analysts, client users and internal systems resources on Cognos installations, upgrades, troubleshooting, and bug resolution
• Handled complete range of BI capabilities: reporting, analysis, score carding, dashboards and business event management.
• Enhanced the Cognos technical design and development process.
• Provided technical support for Cognos 8.4/8.3 applications including report analysis, development, maintenance, and report migration.
• Provide best practices for day to day operations, performance analysis, tuning and capacity planning.
• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
• Created star schema grouping for better understanding of the model & facilitate multi-fact (cross-fact) reporting.
• Ensuring clear query paths by resolving ambiguous relationships (loops, reflexive and recursive
• Setting up cardinality (minimum, maximum & optional), determinants to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts..
• Decreased the cube build times drastically and increased runtime performance.
• Designed multi-dimensional reports and models using Transformer and MDX
• Maintained the packages and reports in development, test and production environment.
• Created filters, prompts, calculations both at package level and report level.
• Created ad-hoc packages for the query users with pre-defined filter conditions, prompt customization
• Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models
• Implemented user group level custom view security in recruitment Analysis cube.
• Designed and implemented a robust security architecture which includes both row level security and object security.
• Involved in production support activities (monthly cube refresh, validating the cube results with the database results, analyzing the data by querying the database for data related issues)

Technologies: Cognos 8.x (Framework Manager, Business Insight, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio, Cognos Administration), Business Objects, JavaScript and HTML, Oracle Database 10g, TOAD, SQL Scripts, PL/SQL.

Confidential, Los Angeles CA

Cognos Solution Architect/Consultant

Roles/Responsibilities:

• Built complex Cognos reports using Cognos 8 and Cognos 10 suites.
• Responsible for the identification of data items through research, analysis, profiling, data mining, and data discovery of the source data.
• Converted old application reports into Cognos reports.
• Served as a liaison between the business experts/users and the project technical team to ensure the users requirements are understood and interpreted correctly by the technical team.
• Created complex SQL queries for reports layout with drill-through items, conditional blocks and render variables.
• Developed Cognos reports with different chart types and drill-through sub-reports.
• Worked with business analyst and users to analyze requirements and business rules.
• Created Cognos reports documentation.

Technologies: Cognos 8.x (Framework Manager, Business Insight, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio, Cognos Administration), Business Objects, JavaScript and HTML, Oracle Database 10g, TOAD, SQL Scripts, PL/SQL.

Confidential, Houston TX

Cognos Solution Architect/Consultant

Roles/Responsibilities:

• Engage with the US based reporting team and business analyst to understand the objectives of the analytics/reporting solution and translate those requirements into technical requirements and design
• Understand the reporting metadata model provided by the client for its products and understand its capabilities and limitations to better design the most appropriate solution for the customer
• Prepare and review technical design and artifacts
• Be responsible for developing and unit testing analytics and reporting deliverables with multiple report pages, prompts, calculations, nested queries, nested objects and variables working with application and data
• Work with the extended teams when reporting development is split between multiple teams to ensure that all analytics are built to the same reporting standards
• Work with the QA teams to ensure their understanding of the technical requirements and the ability to test reporting solutions
• Create and communicate effective packaging strategies for reporting
• Develop the best practices for deploying reporting packages across Development, QA and Production environments
• Facilitate production of ad-hoc and parameter-driven reporting using Cognos BI tools
• Assist in client product implementation and end-user training
• Work with reporting technical resources to design data models and related views to support client reporting needs
• Communicate with clients via on site meetings, conference calls and written correspondence
• Comfortably engage and communicate with both business and technology partners
• Keep abreast of current technology and future enhancements to the client's reporting framework and Cognos product and tools
• Develop, maintain and communicate best practices for report coding disciplines, naming conventions, folder organization, etc.
• Build a library of reporting templates based on different client implementations to speed up report development
• Present written and oral presentations to the business and technical development on report specifications
• Provide input to the Reporting Team Lead for better packaging and efficient distribution of reports.

Technologies: Cognos 8.x, Framework Manager, Report Studio, Analysis Studio, Event Studio, Oracle

Confidential, Los Angeles CA

Cognos Solution Architect/Consultant

Roles/Responsibilities:

• Built complex Cognos reports using Report studio, using Javascript to support customer functional requirements
• Worked closely with business users, gathering requirements, analyzing data and supporting existing reporting solutions.
• Performed Cognos user training.
• Managed and worked closely with the off shore team on various business projects.
• Created and maintained Cognos packages in Framework Manager.
• Designed production rollout process for Cognos applications.
• Promoted packages to production using Import/Export utility.
• Created and maintained Cognos jobs.
• Created, refreshed and supported Cognos Transformer models and cubes to support timely sales operations.
• Performed Cognos administrative functions such as creating user accounts, user classes and roles using Access Manager.
• Built and maintained Cognos reporting security.

Technologies: Cognos 8.x (Framework Manager, Business Insight, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio, Cognos Administration), Business Objects, JavaScript and HTML, Oracle Database 10g, TOAD, SQL Scripts, PL/SQL.