SUMMARY:

• 11+ years of experience in enterprise data warehousing, OLAP and report generating systems.
• Extensive knowledge in data warehousing concepts with dimensional data modeling, star schema/snowflakes schema, fact and dimension tables.
• Involved in the design, development and testing phases.
• Expert in business intelligence applications using Cognos tools such as Cognos 10 BI, (Framework Manager, Report Studio, Analysis Studio, Power Play Studio, Event Studio, Query Studio), Power Play Transformer and Report net.
• Created Various Dashboard Reports for different Business Areas based on Power Play Cubes and DMR’s.
• Implemented dynamic reports and cascading prompts using Java scripts.
• Created bursting reports and scheduled the same.
• Extensive experience with migration projects, such as upgrading Cognos tools to newer version (worked on upgrades Report Net to 8.1, 7.1 to 7.4 8.4 to 10.1).
• Worked on Cognos 8 Dimensional Functions on OLAP Data source and with large databases in production environments.
• Involved in Performance Analysis and Tuning
• Mid - level knowledge of COGNOS administrative and security tasks
• Strong in transformer for designing multi-dimensional Cubes using Star Schema. Developed Multi-Dimensional Models in Transformer and generating Power Cubes for OLAP that comprise dimensions, hierarchies, levels, categories, and measures.
• Created Framework Manager Packages following best practices in multi-user environment.
• Experience in dimensional mapping, creating dimension views to implement the data security and grouping and partitioning the cubes.
• Implemented robust security architecture, which will include both row level security using Macros in FM model and object level security too.
• Proficient in end users and junior level developers on the usage of Cognos Connection, Query Studio and Analysis Studio.
• Undergone in Informatica and can work in real time scenarios.
• Experienced Onsite/Offshore model and successfully worked with offshore team in India.
• Problem-Solving skills to analyze and resolve issues.
• Ability to learn, adapt and apply new skills and technology.

SKILL:

BI Tools: Report Net, Cognos 8 Versions, Cognos 10 Versions, Framework manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Go-office, Workspace and Dynamic Cube Designer.

Database: Oracle 9i/10g, SQL Server, Teradata, DB2 and Vertica

BI Supporting Tools: HP Quality Center, JIRA, Service Now Incident Mgmt. Tool and Autosys and Erwin

Scripting: JavaScript, UNIX and LINUX

EXPERIENCE:

Confidential, Carson City, NV

Senior BI Cognos Developer

Responsibilities:

• Analysis of business requirements, coding or modifications of new program, creation of documentation, testing and maintenance of application.
• Contributing to the development of innovative principles and ideas.
• Developing strategy and leads large, cross-division functional teams or projects the affect the organizations long-term goals and objectives.
• Creating custom reports, custom reporting tables using SQL.
• Defining and capturing metadata and rules associated with ETL processes.
• Creating reports/dashboards against relational and multi-dimensional data sources.
• Performance tuning reporting queries and dashboards.
• Working with Cognos tools like Framework Manager, Query Studio, Report Studio, Workspace, Event Studio and Dynamic Cubes
• Managing User ID's and User groups like Providing Privileges to the users and User Groups in Cognos Admin Console.
• Installed Cognos 11(single server) and worked in migrating the reports from Cognos 10.2.2 to 11.

Tools: Used: Cognos Report Studio 10.2.2, Framework Manager 10.2.2 and Vertica

Confidential, Minneapolis, MN

Senior BI Cognos Developer

Responsibilities:

• Analyzed the business, designed and developed the Framework Manager models to meet the reporting requirements.
• Created transactional based reports for various countries and Bursted based on different user groups.
• Deployed packages, folders and Content store from a development environment to test and then to QC and Production environments.
• Built DMR models and developed reports out of it using MDX functions.
• Generated SQL/MDX and analyzed Native SQL to trouble shoot the report issues.
• Performed Unit testing on Dev and supported the users on UAT and Production.
• Developed and Maintained technical documentation of the implementation.
• Created the canned reports for unit testing of the data loaded into the staging tables for E.T.L folks to perform the easy testing.
• Worked on a POC (Proof of concept) to view the 10.2 dynamic cubes functionality and implemented the cubes and pushed till UAT (User acceptance testing) environment.
• Worked closely with business teams to make sure the development is in line with the requirements and interacted with DM and ETL folks to make sure the tables are loaded as per the needs and in optimal performance retrieval way.
• Worked on tight deadlines and delivered the reports in expected time frame including the testing and documentation.

Tools: Used: Cognos Report Studio 10.2.2, Framework Manager 10.2.2 and Oracle

Confidential, Jersey City, NJ

Senior BI Cognos Developer

Responsibilities:

• Analyzed the business, designed and developed the Framework Manager models to meet the reporting requirements.
• Created custom prompted reports in Report Studio and bursted reports to different user groups
• Implemented reports with Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master - Detail.
• Designed and Developed Advanced Prompt Pages using various Prompts and validating them using Java Script.
• Generated SQL/MDX and analyzed Native SQL to trouble shoot the report issues.
• Performed Unit testing on Dev and supported the users on UAT and Production.
• Extensively worked on performance tuning both at Cognos and database level to bring optimal performance.
• Developed and Maintained technical documentation of the implementation.
• Created complex dashboards for the senior management to have a single view on the complete business.
• Created the canned reports for unit testing of the data loaded into the staging tables for E.T.L folks to perform the easy testing.
• Created active reports for the management reports which gives a high-level view of data with tabbed
• Inter phase and decks.
• Worked closely with business teams to make sure the development is in line with the requirements and interacted with ETL folks to make sure the tables are loaded as per the needs and in optimal performance retrieval way.
• Interacted with the offshore teams to pass over the support work and helping them when ever needed.
• Provided support on the existing applications and acted as an SME for resolving the existing issues.
• Worked on tight deadlines and delivered the reports in expected time frame including the testing and documentation.
• Wrote complex SQL's for the report views which gives optimal performance.
• Migrated the Reports which are built on SAS and Essbase

Tools: Used: Cognos Report Studio 10.2.2, Framework Manager 10.2.2, JavaScript and Teradata

Confidential

Senior BI Cognos Developer

Responsibilities:

• Analyzed the business, designed and developed the Framework Manager models to meet the reporting requirements.
• Created custom prompted reports in Report Studio and Bursted reports to different user groups
• Implemented reports with Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master - Detail.
• Designed and Developed Advanced Prompt Pages using various Prompts and validating them using Java Script.
• Generated SQL/MDX and analyzed Native SQL to trouble shoot the report issues.
• Performed Unit testing on Dev and supported the users on UAT and Production.
• Extensively worked on performance tuning both at Cognos and database level to bring optimal performance.
• Developed and Maintained technical documentation of the implementation.
• Created complex dashboards for the senior management to have a single view on the complete business.
• Created the canned reports for unit testing of the data loaded into the staging tables for E.T.L folks to perform the easy testing.
• Created active reports for the management reports which gives a high-level view of data with tabbed
• Inter phase and decks.
• Worked closely with business teams to make sure the development is in line with the requirements and interacted with ETL folks to make sure the tables are loaded as per the needs and in optimal performance retrieval way.
• Interacted with the offshore teams to pass over the support work and helping them when ever needed.
• Provided support on the existing applications and acted as an SME for resolving the existing issues.
• Worked on tight deadlines and delivered the reports in expected time frame including the testing and documentation.
• Wrote complex SQL's for the report views which gives optimal performance.
• Migrated the Reports which are built on SAS and Essbase

Tools: Used: Cognos Report Studio 10.2.2, Framework Manager 10.2.2, JavaScript and Teradata

Confidential, Jersey City, NJ

Senior BI Cognos Developer

Responsibilities:

• Analyzed the business, designed and developed the Framework Manager models to meet the reporting requirements.
• Performed the analysis on the report requirements and suggested end users on the usage of dashboards to minimize the maximum report runs.
• Trained and supported the users to understand the functionality of Query Studio and scheduling of the reports.
• Created custom prompted reports in Report Studio and Bursted reports to different user groups
• Implemented reports with Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master - Detail.
• Generated SQL/MDX and analyzed Native SQL to trouble shoot the report issues.
• Trained end users in Business Insight/Workspace & Business Insight/Workspace Advanced.
• Created complex dashboards for the senior management to have a single view on the complete business.
• Created the canned reports for unit testing of the data loaded into the staging tables for E.T.L folks to perform the easy testing.
• Worked on a POC (Proof of concept) to view the 10.2 dynamic cubes functionality and implemented the cubes and pushed till UAT (User acceptance testing) environment.
• Worked closely with business teams to make sure the development is in line with the requirements and interacted with ETL folks to make sure the tables are loaded as per the needs and in optimal performance retrieval way.
• Created excellent presentations to expose the development work to the end users and the stake holders.
• Wrote complex SQL's for the report views which gives optimal performance.
• Implemented internal Cognos Security - Column Level, Row Level Security using Security tables to secure sensitive data with Security Filter, Macros, Session Parameters and Parameter Maps.

Tools: Used: Cognos Report Studio 10.2.2, Framework Manager 10.2.2, JavaScript and Teradata

Confidential, Irving, TX

Senior BI Cognos Developer

Responsibilities:

• Gathering the requirements and prepare report design documents.
• Planned an approach for documenting, categorizing and packaging the requirements.
• Involved in Designing and creating various models and Publishing packages in Framework Manager.
• Developed advanced reports using Report Studio.
• Created Complex, multipage reports involving prompts, Cascading prompts, Conditional rendering and
• Conditional formatting.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups and Created Scorecards and Metrics using Metric studio.
• Created dashboards for immediate visibility into key performance indicators KPIs for corrective action and rapid decision - making.
• Performance tuning on power-cubes to reduce Query time and partitioned Cubes.
• Tested and validated the report output against the database to measure performance of reports.
• Involved in Installations of Go Office on User's Desktop machines with the help of Desktop Services and configuring it to Dev and Prod environments.
• Used Go Office tool to import and refresh the Cognos content in MS PowerPoint for business analysis.
• Developed Complex dashboard reports for various reporting requirements.
• Built DMR and Cubes in Transformer using IQDs, packages, reports, etc., as a data source.
• Identified various dimensions and measures required for the generation of a cube.
• Implemented changes and thus improve performance for the existing cube using MDX functions.
• Performed Troubleshoot on various existing reports that had issues and fixed Remedy tickets from production system.
• Scheduling and monitoring the workflows.
• Developed complex PL/SQL stored procedures, packages and triggers to handle complicated business logic for Warehouse Product Database Administration.
• Created reports, Complex and Cross Tab reports using Cognos Report Studio.
• Deployed packages, folders and Content store from a development environment to test and then to QC and Production environments.
• Uses Aggregate Join Indexes and Teradata load tools to speed cube creation and updates.
• Extensively worked on Teradata modeling and ODBC configuration.
• Extracted data from different Sources like Oracle, DB2, Teradata and Flat Files.

Tools: Used: Cognos Report Studio 10.2.1, Power play Transformer 8.4, Framework Manager 10.2.1, Cognos GO-Office and Teradata

Confidential, Baltimore, MD

BI Technical Lead

Responsibilities:

• Involved in all phases of the data warehouse project lifecycle, which includes assessment, business requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report development, performance tuning, and data delivery mechanisms.
• Involved in the design and implementation of the balanced scorecard and online analytical processing (OLAP) solutions
• Participated in the design, development, deployment and support of Reporting solutions in the areas of Sales& Marketing, Forecast & Planning and Supplier Performance.
• Collaborated with business to develop high - level designs including logical models and functional specification documents.
• Actively worked with the BI team and Business to transition the application into Production Environment by providing support and through the release cycle.
• Prepared materials, developing Business models and users in Query Studio according to their specific needs and requirements.
• Assisted and worked with ETL developers and data modelers to make sure that model being developed is according to the business requirements
• Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks.
• Recommended and designed summary tables to be used in reports to optimize performance.
• Wrote SQL scripts and developed audit reports to compare warehouse data with the staging and source data.
• Administered Cognos BI Server Environment
• Managed Package Migrations and Deployments from one Environment to another.
• Developed a metadata model in Framework Manager by following best practices.
• Implemented Tables of Contents and hide and show functionality in Reports.
• Supported existing reports in production environment.
• Design and review Technical Design Documents and queries through onsite/offshore mail coordination.
• Identify gaps in the database migration and discuss the impact with several business teams.
• Participate in daily /weekly status calls and meetings to discuss the project issues and work with all the teams to close the issues.

Tools: Used: Cognos Report Studio 10.1, Power play Transformer 8.3, Framework Manager 10.1 and Teradata

Confidential

BI Cognos Developer

Responsibilities:

• Modeled and Reported against an Operational Data Source (OLTP).
• Upgraded Report Net Models and reports to Cognos 8.2.1 Environment.
• Created several Lists, Cross tab, Chart, and Repeater Reports using Report Studio.
• Created reports having multiple Report Pages, Prompt Pages (with Select & Search, value prompt, text boxDate, Interval, Cascading, tree prompts).
• Used Conditional Blocks, Conditional Formatting to merge 2 or more Cognos Report Net reports and
• Developed Consolidated Reports in C8.
• Developed Templates, Master Detail Reports, Chart Reports and Multilingual Reports using Report Studio and Query studio.
• Generated SQL/MDX and analyzed Cognos SQL, Native SQL to trouble shoot the report issues.
• Performed Unit testing to verify if the Actual Results meets the Expected.
• Deployed Packages, Reports to Test Environment using Content Administration.
• Involved in creating OLAP hierarchy, Dimensions, formulas & power cubes using Cognos Transformer and Reports using Power Play.
• Created Member based Security, Custom Views, Dimension Views, Apex Custom views, Cloak.
• Added Drill through reports to another cube (. mdc file) from the same model, to overcome row or category limitations.
• Created Model Query Subjects, Data Source Query Subjects, Stand alone and Embedded Filters to
• Implement the Complex Business Logic.
• Implemented internal Cognos Security - Column Level, Row Level Security using Security tables to secure sensitive data with Security Filter, Macros, Session Parameters and Parameter Maps.
• Developed Hierarchies and Measures to support Adhoc Reporting, Multi Dimensional Reporting.
• Published Packages to Cognos Connection and implemented Package Level Security.
• Managing User ID's and User groups like Providing Privileges to the users and User Groups in Access
• Manager.
• Automated the Monthly cube refresh Process using Command Line options and scheduled it using Windows Scheduler.

Tools: Used: Report net, Cognos Impromptu, Cognos Report Studio 8.2, Power play Transformer 7.3, Framework Manager, Erwin, DB2 and Teradata