PROFESSIONAL SUMMARY:

• Senior Business Intelligence Consultant with over 7 years of professional experience as IT consultant in Administration, Architecture, Design, Development and Deployment of data warehousing and business intelligence applications using Cognos 10 BI Suite, Cognos 8 BI Suite, Report Net, and Cognos Series 7.
• Experience in developing and maintaining Framework Manager Models both Relational and Dimensionally Modeled Relational (DMR) models.
• Experience on Cognos 10.1.1 and Cognos 8 with Framework Manager, Analysis Studio, Cognos Connection, Report Studio, Query Studio, Active Reports, Cognos Workspace, Workspace Advanced, Dash boards, Business Insight and Business Insight advanced.
• Experience in migrating reports from Cognos Series 7 to Cognos 8.4.1 and Cognos 8.4.1 to Cognos 10.1.1 and also troubleshooting and fine tuning the migrated reports.
• Experience in database modeling and designing for improved performance.
• Expert in creating and publishing packages in the Framework Manager from various data sources in Report Net. Generated different kinds of reports in Report Studio, created templates and multilingual reports.
• Experience in Data warehousing, Data Architecture & Extraction, Transformation and loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica PowerCenter.
• Experience in installation, configuration and administration of Cognos 8.3/8.4/10.1.1 in a distributed environment.
• Experienced in implementing Cognos SDK and integrating Cognos with the corporate Reporting Portals.
• Experience in configuration and setting up security (users/groups/roles and access privileges).
• Experience in designing Complex Power play Transformer Models for building the cubes including externally rolled up measures.
• Expertise in advanced SQL Query writing and PL/SQL programming.
• Expertise in Performance tuning of the existing Cognos Reports and Cubes.
• Working knowledge on different data sources ranging from flat files, Oracle, PL/SQL Server, and DB2 databases, SQL Server and Sybase.
• Highly motivated and focused problem solver with a passion to improve business processes by implementing innovative business solutions.
• Extensively worked in interacting with Business Users to collect User Requirements.
• Experience in Oracle PL/SQL and database Performance Tuning by implementing Parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, re - building indexes and also used the Explain Plan and SQL Tracing.
• Experience in writing, testing and implementing SQL/T-SQL/PL/SQL, Stored Procedures, Triggers and Functions.
• Experience in writing sql queries, stored procedures, and SSIS and DTS packages.
• Performance tuning in an Oracle environment
• Experience in working with different operating systems like Windows 7, Windows XP Professional, UNIX, and Linux.
• Experience in developing applications using programming languages like C, C++, and Java.
• Highly motivated, result oriented professional with a short learning curve and strong communication skills.
• Web-based application development, framework object development experience.

TECHNICAL SKILLS:

BI Tools: Cognos 10.1.1/8.4/8.2/8.0, Cognos Report Net 1.1, Report Studio, Query Studio, Framework Manager, Business Insight and Business Insight advanced, Analysis Studio, Cognos Workspace, Workspace Advanced, Metric Studio, Event Studio, Cognos Impromptu, Cognos Transformer, Cognos SDK, Cognos Scheduler,Tableau

ETL Tools: Informatica PowerCenter 9.5/9.1/8.6, Workflow Manager, Workflow monitor, Warehouse Designer, Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Informatica Server.

Operating Systems: Windows 2000/2003, Windows XP Professional/7/8, Windows NT, UNIX, Linux

Languages: C, C++, SQL, PL/SQL, HTML

Databases: SQL Server 2000/05/08, Oracle 8i/9i/10g/11g, MS-Access, Teradata.

SQL Tools: SQL Assistant 6.2, SQL plus, Toad SQL Loader, SQL Query Analyzer

Database Tools: TOAD, SQL Developer

Data Modeling Tools: MS Visio, Erwin

PROFESSIONAL EXPERIENCE:

Cognos Developer

Confidential, Dallas, TX

Responsibilities:

• Interact with the Line of Business for requirement gathering by participating in Joint Application design/development sessions to understand and document business requirements and development process.
• Worked with Stored Procedure Query Subjects and Direct SQL reports in Report Studio.
• Experienced in writing and understanding complex SQL queries.
• Installation and Configuration of the Cognos 10.1.1 multi-server environment.
• Designed the Logical model that conforms to Data Modeling (Star schema, Snow Flake schema concepts), Different views (Import, Business, External) as per Business requirement.
• Involved in testing and validating data in new or converted reports generated in Cognos10.1.1 report studio against the SQL DB.
• Created various List Reports, Cross Tab Reports, Chart Reports, Repeater Drill-Down and Drill-Through Reports, Master-Detail Relationships in Report Studio.
• Implementation of Active Reports for each client for summarized data transactions.
• Created Complex reports using various prompts like Value Prompts, Date & Time Prompts, Text Box Prompts, Cascading prompts.
• Used Render variables and data items to hide confidential information in the reports.
• Provided drill-thru report functionality with drill thru to a different report in Report Studio.
• Used variable like String and Boolean for all conditional formatting and rendering requirement.
• Created Conditional Block reports to dynamically hide or show reports objects and provide the end user the option to view the data in different formats.
• Developed complex reports, multi-query reports and sub select queries to meet the client requirements.
• Involved in Deploying reports, packages from Development to Production environment.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists using Cognos connection in Production.
• Involved in implementing Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed Standard Reports, Charts and Master Detail Reports using Report Studio.
• Created a custom prompt page by enabling system driven cascade options, dynamic dimension selection and conditional display of prompts.
• Create additional reports on an ad-hoc basis as requested by business users. and guiding end user to help understand BI reports and reporting parameters.
• Designing SharePoint site, providing report links for easy access to the end users.
• Member of BI change control process, approving changes deployed from CognosDev to CognosUAT and Prod environment.
• Send weekly BI team updated to the project manager.

Environment: Cognos 10.2/10.1 Report Studio, Query Studio, Analysis Studio, Cognos Business Insight, Cognos Business Insight Advacned, Framework Manager, Share point, SQL Server 2008, Windows XP.

Reporting Analyst

Confidential, San Jose, CA

Responsibilities:

• Interacted with Business Users to prepare and update the Business Process Requirements and Software System Requirements.
• Participated in daily meetings for project implementation in agile methodology.
• Build Adhoc reports to support the business finance and administration part of the business from all supported EPM/EMR platforms.
• Effective involvement in Analysis and Design Phases, Enterprise reporting design, estimation and development.
• Worked with stake-holders from Finance, Billing and Provider organizations to understand reporting and analysis requirements.
• Implemented GE Informatics (PrecisionBI) framework for the purposes of ad-hoc and static reporting as well as operational dashboards.
• Worked with stake-holders to develop and implement GE Centricity Business. Specific duties included the configuration of SEC+ and Web Framework model, Electronic Document Management (EDM) for forms delivery and scanning.
• Worked extensively in administering servers, optimizing performance, and set access permissions in Cognos 10.1.1.
• Worked with Stored Procedure Query Subjects and Direct SQL reports in Report Studio.
• Designed the Logical model that conforms to Data Modeling (Star schema, Snow Flake schema concepts), Different views (Import, Business, External) as per Business requirement.
• Worked with the Conformed dimensions, Balanced/Un-Balanced Hierarchies, ragged Dimensions.
• Setting up Cardinality (minimum, maximum & optional), Determents to avoid double counting, and supporting loop joins, optimize data source, and identify dimensions and facts.
• Implemented Framework manager security for Data access, Object level access, Package access and Row level access.
• Developed some custom report templates based on user requirements.
• Developed the Drill Through Reports, Master Detail Reports Using Report Studio and Query Studio.
• Working experience with different date functions in Report Studio.
• Created the Bar charts and list reports using Cognos Report Studio and Analysis studio.
• Modified Power Cubes by adding new Dimensions, Levels and Measures.
• Developed Dash Board reports in Report Studio using MDX Functions.
• Writing the Java Script in Report Studio Reports to display default values in value prompt.

Environment: Cognos 10.1.1/8.4/8.4.1 Framework Manager, Cognos Connection, Cognos Administration, Report Studio, Query Studio, Analysis Studio, Cognos Business Insight, Cognos Business Insight Advanced, GE Informatics, GE Centricity, SQL Server 2005/2008, Windows XP

Cognos Developer

Confidential

Responsibilities:

• Developed Standard and Dashboard Reports, 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
• Used SQL Server Management Tool to check the data in the database as compared to the requirement given.
• Developed Cognos Framework report model and reports as per the requirements.
• Involved in effort estimation based on the complexity of the business and the report design.
• Understand the security model and implemented the Row-Level Security according to the requirements.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created Database layer, Relationship layer and Presentation layer, defining appropriate relationship between query subjects.
• Worked with Relational Database - MS SQL and involved in ETL team discussions.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports.
• Developed portal tabs to show report on Cognos connection.
• Used bursting options and scheduled reports to run at a different time to send e-mail to users.
• Develop and maintain technical documentation.
• Developed Multi-dimensional models (cubes) using Transformer.
• Developed models in framework manager and created reports to use them as source to transformer (to build cubes).
• Worked on cube refreshing on weekly basis & validating the data.
• Developed work estimates for assigned tasks, assessed constraints and dependencies escalate and resolve issues in a timely manner.

Environment: Cognos 10.1.1/8.4/8.4.1 Framework Manager, IBM Cognos SDK, Cognos Connection, Cognos Administration, Cognos Go Dashboard, Report Studio, Query Studio, Analysis Studio, IIS Web Server, ORACLE 11g, SQL, Toad

Cognos Developer

Confidential

Responsibilities:

• Interacted with Business Users to prepare and update the Business Process Requirements and Software System Requirements.
• Effective involvement in Analysis and Design Phases, Enterprise reporting design, estimation and development.
• Installation and Configuration of the Cognos 8.3 multi-server environment.
• Worked extensively in administering servers, optimizing performance, and set access permissions in Cognos 8.
• Administered secured function and features in Cognos 8 that has to be available for users based on the Job title.
• Developed Framework Manager Models having multiple data sources and published as multiple packages based on requirement.
• Migrated Impromptu reports to Report Net using migratetocrn command and deployed migrated reports to Report Net using deploytocrn command.
• Involved in migrating reports from Cognos Series 7 to Cognos 8.3 and also troubleshooting and fine tuning the migrated reports.
• Designed the Logical model that conforms to Data Modeling (Star schema, Snow Flake schema concepts), Different views (Import, Business, External) as per Business requirement.
• Worked with the Conformed dimensions, Balanced/Un-Balanced Hierarchies, ragged Dimensions.
• Setting up Cardinality (minimum, maximum & optional), Determents to avoid double counting, and supporting loop joins, optimize data source, and identify dimensions and facts.
• Involved in adding business rules by defining different kinds of calculations and filter.
• Implemented Framework manager security for Data access, Object level access, Package access and Row level access.
• Developed some custom report templates based on user requirements
• Developed the Drill Through Reports, Master Detail Reports Using Report Studio and Query Studio.
• Working experience with different date functions in Report Studio.
• Created the Bar charts and list reports using Cognos Report Studio and Analysis studio.
• Writing the Java Script in Report Studio Reports to display default values in value prompt.
• Multidimensional reports were created using Analysis studio.
• Created Parameter Maps and Parameter variables for using the same package with different applications.

Environment: Cognos 8.3/8.4,Cognos SDK, SQL Server 2005, SQL developer, DB2, Windows 2003 Server