SUMMARY

• Over 8 years of Experience in Data Warehousing, Data Modeling, Business Intelligence (BI) Cognos.
• Extensive exposure to various business sectors such as Finance, Insurance, Retail, Energy, and Government.
• Very good understanding on advantages, limitations & advancements in recently released versions of Cognos products.
• Installation and Configuration of IBM Cognos 10.2.2 in a distributed Windows 2012 environment.
• Implemented security in Cognos with Active Directory and Novell E directory
• Involved in IBM Cognos Upgrade from 8.3 to 10.2 using IBM Cognos Lifecycle Manager
• Worked on IBM Cognos 8.3 BI, Powerplay Transformer 8.3, and IBM Cognos 10.2.1 BI, PowerPlay Transformer 10.2
• Developed Reports using Cognos 10.1.1 Active Reports.
• Experience in Cognos 8 BI (Framework Manager, Report Studio, Query Studio, Event Studio, Metric Studio, Analysis Studio and Cognos Connection)
• Expertise in Data Warehousing Concepts in OLTP/OLAP, Star Schema, Snowflake Schema for Relational and Dimensional Modeling.
• Experience in Conceptual, Logical and Physical data modeling with strong knowledge of Data Warehousing concepts and Dimensional Modeling Star schema and Snowflake schema.
• Experience in developing various reports like List reports, Crosstab reports, Charts, Dashboards and Scorecards
• Involved in entire lifecycle development process of data warehousing.
• Expert at creating Multi - Dimensional Cubes for corporate data using IBM Cognos Cube Designer and PowerPlay Transformer.
• Published cubes and PowerPlay reports to Upfront using PowerPlay Enterprise Server.
• Hands on experience in administering, deploying and maintaining models, reports and cubes
• Installed and configured various components, such as the Framework Manager and Cube Designer.
• Experience with Cognos Software Development Kit (SDK) for automation.
• Extensive experience in gathering and documenting user requirements, report development, setup security infrastructure at Data and object levels as part of setting up reporting infrastructure.
• Strong Experience in User acceptance test, product support, version control and change management.
• Possess Excellent Communication (both verbal and written) & Interpersonal skills technically sound, Result-Oriented with strong Problem Solving skills.

TECHNICAL SKILLS

Cognos BI Tools: Cognos Framework manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Cognos Connection, Power play Transformer Cognos SDK.

Database: DB2 10.5, Oracle11g, MS SQL Server 2012,Teradata

ETL Tools: Informatica 9.5.1, Data stage 11.5, SSIS

Programming skills: Java Script, SQL, PL/SQL, HTML, XML.

Operating System: Windows Server 2012/2008/2003 and Windows 10/8/7, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, Lincoln, NE

Sr. Cognos Administrator and Developer

Responsibilities:

• Worked with the IBM Cognos 10.2.2 for the reporting needs of Nebraska office of Probation and Administration.
• Worked closely with users on business requirements and other reporting needs.
• Gathered report requirements by working directly with the users.
• Documented the report requirements and business requirements.
• Trained the users to use Cognos for their reporting needs and for ad-hoc reporting.
• Installation and Configuration of IBM Cognos 10.2.2
• Installed Cognos 10.2.2 in a Windows 2012 distributed environment.
• Configured the Cognos components in both the environments
• Created Cognos content store database in DB2 environment from the DDL script
• Configured the ISAPI gateway for better performance of the Cognos.
• Installed IBM Cognos Samples
• Restored the Cognos DB2 Samples and configured them in Cognos.
• Configured the security in IBM Cognos 10.2.2 with Active Directory
• Created security groups to give access to different type of users with different level of access.
• Installed DB2 10.5.0.5 Advanced Workgroup Server Edition and DB2 Runtime Clients on Client machines.
• Created databases and granted privileges to users in DB2
• Installed InfoSphere Information Server Enterprise Edition 11.5
• Identified reports in OBIEE to convert to Cognos and with more enhancements.
• Metadata modeling is done using IBM Cognos Framework Manager 10.2.2
• Developed the Cognos advanced reports using Report Studio.

Confidential, Chicago, IL

Sr. Cognos Developer

Responsibilities:

• Hands on working with the latest version of Cognos 10.2.1
• Worked with Arkansas SNAP project data for developing the reports
• Involved in identifying the data form different subject areas and ER diagrams.
• Built the metadata model using Framework Manager for Arkansas SNAP project following the best practices of IBM Cognos
• Involved in writing the complex SQL queries and store procedures for developing the reports.
• Developing the prototypes and designing the reports using Cognos Report Studio.
• Developed Active Reports using the Report Studio
• Cognos report bursting to file system and to emails.
• Worked on Cognos Transformer 10.2.1 to build the powerplay cubes.
• Optimized the powerplay cubes by partitioning and creating cube groups.
• Created custom views to implement the security
• Installed Cognos SDK and imported the SDK lib. Into eclipse.
• Worked on Cognos SDK to automate the package publishing and deployment.
• Deployment of models, packages and reports between the environments.
• Worked with IBM DB2 database using IBM Data Studio 4.1.1
• Involved in development and testing the Cognos Reports.

Environment: IBM Cognos 10.2.1 (Framework Manager, Cognos Connection, Report Studio, Cognos Powerplay Transformer, Cognos SDK), Informatica 9.5.1, IBM DB2, IBM Data Studio

Confidential, Pittsburgh, PA

Sr. Cognos Developer

Responsibilities:

• Collecting the requirements from the business user and designing the Technical design document.
• Designed and developed the reports using Confidential Retail data.
• Built the OLAP cubes using the IBM Cognos Cube Designer.
• DMR Packages are created using Cognos Framework Manager
• Built the cubes using the best practices in Cognos.
• DMR and Virtual Cubes are used for developing the reports.
• Used Dynamic Query Analyzer to improve the performance of Dynamic Cubes with Aggregate Advisor.
• Advanced Prompting is done by using JavaScript for prompting.
• Data is queried using MDX expressions.
• MDX functions are used in developing the reports from Dynamic cubes.
• Reports are developed using complex reporting techniques and designs.
• Involved in Resolving the Production issues.
• Tested the reports after upgrading and fixed the issues in the reports.
• Worked in test and development environments.

Environment: IBM Cognos 10.2.1(Framework Manager, Cube Designer, Cognos Connection, Report Studio), Informatica 9.1,Oracle 11.2, Teradata 14.1, Teradata SQL Assistant.

Confidential, Bloomington, MN

Sr. Cognos Developer

Responsibilities:

• Involved in requirements gathering from business users, report design, report development, and support of all client/server layers and components of the data warehouse.
• Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement.
• Documented the requirements according to the reporting needs with business logics included.
• Metadata modeling using Framework Manager best practices.
• Created new Query Subjects and arranged in different folder structure for Business View and also manually created the query subjects using the complex SQL.
• Adding multiple languages to the Metadata model and Package.
• Worked on IBM Cognos 10.2.1 Report studio to develop the reports.
• Customized reports using JavaScript.
• Developed drill through reports using date prompts and different output versions (pdf, Excel, CSV).
• Deployed the Cognos reports and package.
• Developed multilingual reports.
• Integrated with Confidential +Gyr user interface to display the reports.
• Worked in Development and QA environments.

Environment: IBM Cognos 10.2.1(Framework Manager, Cognos Connection, Report Studio), Informatica 9.0, Oracle 11g, WebSphere, UNIX, Oracle SQL Developer

Confidential, Detroit, MI

Sr. Cognos Developer

Responsibilities:

• Involved in IBM Cognos Upgrade from 8.3 to 10.2
• Worked on IBM Cognos 8.3 BI, Powerplay Transformer 8.3, IBM Cognos 10.2 BI, Powerplay Transformer 10.2, Linux, WebSphere, VVM.
• Preparing the upgrade procedure and steps to take while upgrade.
• Installing BI server on Linux and configuring the servers and Transformer installation.
• Consistency check between the environments.
• Worked on reports comparison between both the versions and worked on upgrading the Framework manager models, Transformer Models.
• Generating and scheduling the cubes in 10.2 environments and make sure 8.3 and 10.2 are functioning the same way.
• Security setup on the BI servers. Data and layout validation.
• Working with customer testing and development team on the complex issues.
• Upgrading the Java scripts used for the reports and Dashboards. Worked on many DMR and Relational models on the upgrade process.
• Involved in fixing the reporting issues as a part of Information Management team before and after upgradation.
• Worked in Development, QA, and Production and Sandbox environments.

Environment: IBM Cognos 10.2/8.3, Powerplay Transformer 10.2/8.3, Linux, WebSphere, VVM, Oracle 11g, TOAD.

Confidential

Sr. Cognos Developer

Responsibilities:

• Involved in requirements gathering from business users, report design, report development, and support of all client/server layers and components of the data warehouse.
• Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement.
• Built Multi-Dimensional Models (DMR) with Relational Data using Framework Manager, designed models and deployed Packages to the Report Servers.
• Developing models using Framework Manager Techniques and also implementing the logics (joins, union, multiple filters,) within the Framework for the ad-hoc reporting for the end users and trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Created new Query Subjects and arranged in different folder structure for Business View and also manually created the query subjects using the complex SQL.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Developed the new dashboard right from scratch i.e., gathering the requirements from end user and implemented and delivered in a time.
• Developed List, cross tab, drill through, master-detail, conditional blocks, chart and complex reports which involved Multiple Prompts in Report Studio and report bursting.
• Developed Reports with multiple Cognos Viewers and integrated multiple Cognos reports onto a Single Page Report.
• Creating New Job and scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Data is moved from one data source to another by using SSIS. Created Star Schemas using SSIS packages.
• Experience in Deploying reports, cubes and packages from Development to Production environment.
• Customized Reports by writing complex custom SQL.
• Customized Reports using XML, HTML, JAVASCRIPT
• Worked with the Data analysis, development, SQL performance tuning, data warehousing ETL process, data conversions and user documentation.

Environment: IBM Cognos 10/ 8.4 (Framework Manager, Report Studio, Analysis Studio, Query Studio, Cognos Connection), Cognos Report Net 1.1 MR2 (Framework Manager, Report Studio and Query Studio), Power Play Transformer 7.4, Power Play Enterprise Server 7, Informatica 8.1 power center, SSRS, oracle10g (SQL, PL/SQL), SQL server 2005.

Confidential

Cognos Developer

Responsibilities:

• Developing models using Framework Manager Techniques.
• Created Packages and published these packages on to Cognos Connection for creating ad-hoc reports using Query Studio and professional reports using Report Studio.
• Created new Query Subjects and arranged in different folder structure for Business View.
• Created complex reports like Crosstab, Drill throughs, Master detail, Dashboards and Burst Reports using Report Studio.
• Created reports using Conditional formatting, Conditional blocks, Conditional variables, Advanced Conditional styles and Conditional Layout features in Report Studio.
• Created queries in report studio using Join and Union
• Developed Reports using Cognos 10.1 and also Active Reports.
• Built Multi-Dimensional Model with Relational Data using Framework Manager and Transformers.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP - ROLAP)
• Experience in Deploying reports, cubes and packages from Development to Production environment.
• Created Data Warehouses using ETL tool SSIS.
• Created reports with custom prompt pages (using HTML and JavaScript) in Report Studio.
• Setting up cardinality (minimum, maximum & optional), Determinants to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Used Cognos Transformer to build multidimensional cubes.
• Developed DMR Models & IQD’s in Framework Manager.
• Fine-tuned the queries for performance purpose and enhanced the performance of the reports.
• Developed Prompt pages and Cascading input prompts to display only selected entrees in the report.
• Developed Report Views to organize reports in Cognos Connection
• Expertise in handling Administration tasks like bursting and scheduling the reports.
• Strong experience in all phases of testing including defining user acceptance criteria, developing plans/scripts, documenting expected results, execution of scripts, validating actual results.

Environment: Cognos 10 / 8.4 (Cognos Connection, Report Studio, Query Studio, Analysis Studio Framework Manager), Access Manager, Cognos Transformer, Oracle 11g, DB2, TOAD, Teradata, Windows XP