SUMMARY

• Nine 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 BI applications using Cognos tools such as Cognos 10 BI (Framework Manager, Analysis Studio, Power Play Studio, Report 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
• Extensive experience with migration projects, and upgrading Cognos tools (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 also with large databases in production environments
• 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 also 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 training end users and junior level developers on the usage of Cognos Connection, Query Studio and Analysis Studio
• Involved in Performance Analysis and Tuning
• Mid-level knowledge of COGNOS administrative and security tasks
• Experienced Onsite/Offshore model and successfully worked with Offshore team
• Skillful in Problem-Solving, analyzing and resolve issues
• Ability to learn, adapt and apply new skills and technology
• Team player with excellent analytical, communication and project documentation skills

TECHNICAL SKILLS

Technologies: BI Cognos 10.1, Cognos 8 and Report Net

Database: Oracle 9i/10g,Teradata,DB2

Application: IBM Cognos 10.1 Reporting studios, IBM Cognos 10.1 Framework Manager, Cognos 10.1 Power play transformer and Erwin

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Technical Cognos Lead

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 users to understand the functionality of Query Studio and scheduling of the reports
• Implemented reports with Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail
• Designed and Developed Advanced Prompt Pages using various varieties of Prompts and validating the Prompts 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
• Developed and Maintained technical documentation of the implementation
• Trained end users in Business Insight/Workspace & Business Insight/Workspace Advanced
• Created dashboards for senior management to have a single view on 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 documents for my team members on how to schedule the reports into external portal from Cognos and learn the component for their business needs
• Created active reports for the management reports which gives a high level view of data with tabbed inter phase and decks
• 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 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 presentations to expose the development work to end users and the stake holders
• Interacted with the offshore teams to support work and helping them in resolving the issues
• Provided support on the existing applications and acted as an SME for resolving the issues
• Worked on a tight deadlines and delivered the reports in given 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
• 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

Environment: Cognos Report Studio 10.2, Framework Manager 10.2 and Teradata

Confidential, Irving, TX

Technical Cognos Lead

Responsibilities:

• Gathering the requirements and prepare report design documents.
• Planned an approach for documenting, categorizing and packaging the requirements.
• Involved in designing & 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 report outputs 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.
• 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.

Environment: Cognos Report Studio 10.1, Power play Transformer 7.4, Framework Manager and Teradata

Confidential, Baltimore, MD

Technical Cognos 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 training through the release cycle.
• Prepared training materials, developing Business models and training 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.

Environment: Cognos Report Studio 10.1, Power play Transformer 7.4, Framework Manager and Teradata

Confidential

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 List, Cross tab, Chart, and Repeater Reports using Report Studio.
• Created reports having multiple Report Pages, Prompt Pages (with Select & Search, value prompt, text box, Date, 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.

Environment: Report net, Cognos Report Studio 8.1, Power play Transformer 7.3, Framework Manager and Teradata