SUMMARY

• Cognos Lead with around 13 years of experience in leading the Design and Development with the primary focus on the Cognos 8.x Suite, Cognos 10.x Suite, Cognos 11.0.9, 11.0.5, Cognos Report Studio, Cognos Cube Designer, Cognos Transformer, Framework Manager, Cognos Power Play, PowerPlay Enterprise Server, Access Manager, Dashboards, Data Sets, Data Modules.
• Extensively worked on agile scrum methodology and attended daily scrum meetings to keep in sync with the team’s progress and also by using rally, an agile platform to track the team’s work online.
• Worked extensively on Cognos 11 in creating reports, dashboards and Framework Manager models
• Expert in reporting on Multi - Dimensional OLAP Cubes using complex MDX functions
• Experienced in troubleshooting bugs in Cognos 11
• Experienced in working with SSAS cubes
• Strong experience on Teradata as a backend support for Cognos reports.
• Experienced in implementing large-scale applications with leading technologies in Business Intelligence and involved in complete software development life cycle (SDLC)
• Extensive experience in Designing the Framework Manager models, to meet BI industry standards applied Physical Layer, Business Layer and Presentation Layer approach to increase the model durability
• Worked extensively on reports and dashboards built on DMR models and cubes using complex MDX functions
• Experienced in designing and development of DMR models.
• Installed and configured Cognos 11 Sand box environment for POCs on the new version
• Experienced in using DQM with the DMR models using 10.x Cognos Suite.
• Experienced with Rapidly Adaptive Visualization Engine (RAVE)
• Experienced in using Dynamic Query Analyzer to analyze the performance of the queries in Dynamic Query Mode.
• Created models with different data sources such as Oracle, SQL Server, SAP BW and MS Access
• Created IQDs in the Framework Manager which are considered as inputs for creating multi-dimensional cubes using Transformer
• Created complex Active reports using report studio
• Experienced in using the visualization tool to add and modify extended/latest visualizations to use in Cognos 10.2.1 Report Studio
• Extensive experience in creating Managed/Complex reports using Report Studio and creating ad-hoc reports using Query Studio
• Created different kind of analytical reports including templates, List, Cross-Tab, Chart, Repeaters using Report Studio
• Worked on integrating Max relationships with Cognos to use with Cognos Framework Manager from out of box Maximo
• Supported in upgrading Maximo 6.2 to7.5 with Cognos integration
• Worked on advanced features of Report Studio such as Conditional Variables, Conditional Blocks, Drill-through, Page set, Master-Detail relationships, Bursting and various kind of prompts (Value prompt, Date prompt, Textbox prompt)
• Experienced in Reports Deployment from development environment/server to Testing and Production environment/server using Content Administration
• Hands on experience in reports migrating from Cognos 7 series to Cognos 8.x
• Experienced in working in complex cluster installation configured Z-Linux Cognos Environments.
• Troubleshoot issues with existing reports and cubes, Expertise on creation and maintenance of models, which involved defining security, joins, cardinality, filters and governor settings Cognos 8.x and Cognos 10.x
• Designed and Created power cubes for multi-dimensional analysis
• Created multi-dimensional reports using Analysis Studio and applied context filters for better analysis
• Involved in managing Custom autantication for Cognos environments.
• Experienced in performing installations of Cognos BI server on new environments and CDL environments.
• Having experience in implementing security for Cubes and Package, Object and Data level security for Packages
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing database schemas (Star Schema and Snowflake Schema) used in relational, dimensional and multidimensional modeling.

TECHNICAL SKILLS

• Cognos BI Suite 11.0.7/10.x/8.x/7.x
• Query Studio
• Report Studio
• Analysis Studio
• Event Studio
• Cognos Connection
• Framework Manager
• Active Reports
• PowerPlay Transformer
• Impromptu Administration
• Data Manager Upfront
• IWR and PPES
• Query Studio
• Report Studio
• Framework Manager
• Metric Studio
• Maximo
• Netezza
• Aginity
• Oracle 8i/9i/10g/11g
• MS SQL Server 2000/2005/2008/2012
• MS Access 7.0
• SAP-BW
• Toad
• SQL-Plus
• SQL Server Management Studio
• Visio 2003
• Erwin Windows-98/NT/2000/XP/Vista
• Linux
• Solaris
• UNIX
• IBM AIX
• HP-UX
• DOS
• SQL
• PL/SQL

PROFESSIONAL EXPERIENCE

Senior Cognos Architect/Lead/Senior Developer/Administrator

Confidential, Vernon Hills, IL

Responsibilities:

• Lead development efforts for the Cognos team
• Created reports and dashboards based out of MSSAS cubes
• Created and maintained complex Multi-Dimensional Cognos reports using MDX functions
• Played a key role in maintaining expectations and providing estimates for multiple projects and quick-hits (Break-Fixes)
• Lead successful core team of diverse resources comprised of employees, contractors and off shore resources
• Assisted marketing executives in defining their reporting needs through formal requirements gathering exercises. Documented requirements to facilitate the data warehouse and reporting designs.
• Worked on Framework Manager, Report Studio on a day-to-day basis to support on-going requirements from business users
• Worked on creating schedules based on triggers and event studio based report delivery mechanisms
• Worked closely with the finance team to provide daily financial summary based reporting
• Ability to understand and speak the language of both the business and technical communities using effective communication skills in presentation and leadership roles.
• Worked with tools like Meta Manager and Net Vision to perform frequent audits on licenses and reports
• Worked with finance team to reconcile the differences between source systems and the data warehouse
• Worked on migrating 10.2.2 to 11.0.9 and 11.1.5 and testing the reports to identify bugs
• Integration of KPI’s that succinctly illustrate the status of the measures that matter most
• Worked with IT resources from other teams to learn environment, its complexities, limitations and data restrictions
• Worked on Query Studio, Analysis studio and Pyramid to analyze financial data for reporting needs and reconciliation
• Maintained Administration of three Cognos Instances with DEV, QA and Production environments for each
• Extensive dimensional report development based on MSSAS cubes
• Configured trigger utilities to maintain ETL Trigger based schedules and other Admin related configurations
• Ownership of PMRs and coordination with IBM to resolve issues during and after upgrades
• Worked with implementing named sets from MSSAS cubes in report studio for multi-dimensional reporting
• Created Data Sets and Data modules to use in Cognos Dashboarding in 11.1.5
• Worked on automating various reporting process to eliminate manual dependencies thereby reducing cost and ensuring effective use of resources
• Worked with business users and leadership team to prioritize the projects based on ROI
• Troubleshooting SQL Queries and MDX Queries on SQL server database to identify issues within the data in the report
• Created Cognos reports to identify issues with data in SSAS cubes while still in the processing server before being moved to the query server in-order to proactively avoid issues thereby reducing turn-around time for bug/data fixes

Environment: Cognos 10.2.2/11.0. 7 , Report Studio, Analysis Studio, Query Studio, Event Studio, Metric Studio, Cognos Analytics, Dashboards, Framework Manager, Microsoft SQL Server 2012, Microsoft SQL Server Analysis Services, NetVisn, Meta Manager 5.4, SSMS 2012

Senior Cognos Developer

Confidential, New York City, NY

Responsibilities:

• Worked on creating new interactive dashboards in Cognos 11
• Created very complex active reports and live reports
• Worked with the team in analyzing the requirements and coordinating with the client to get feedback as needed
• Data and functional testing performed on each of the developed reports/dashboards
• Created work arounds for a few bugs identified within Cognos 11
• Worked on multiple projects and switched depending on the client’s needs
• Performed Extensive development role while leading the project along with other team members
• Worked on creating DMR models in FM
• Worked on reports involving complex MDX functions
• Worked on Tree prompts based of Dimensional data
• Worked on applying changes and fixes to Framework Manager model including security based on session parameters and other filters
• Worked on building multi-lingual compatibility on all the reports/dashboards
• Helped business users build dashboards on Cognos Analytics

Environment: Cognos 10.2.2/11.0. X, Report Studio, Cognos Analytics, Active Reports, Dashboards, Framework Manager, Microsoft SQL Server 2012, Aginity

Senior Cognos Admin/Lead/Architect

Confidential, Loveland, CO

Responsibilities:

• Worked on creating new reports out of Cognos for various business entities
• Trained Business users in Business Insight Advanced and halped them leverage the tool to do self-service Analytics within Cognos
• Worked closely with the business users to understand their needs and derive requirements from their feedback
• Worked on Data Profiling to build PIs in Teradata
• Setup ODBC connections for Teradata to connect with Cognos
• Worked with Teradata Semantic Views layer when modeling with Cognos
• Configured parameters based on best practices for Teradata based reports
• Worked as an Administrator to perform day-to-day and scheduled maintenances on the environment and maintain stability.
• Working in a Process Based Leadership (PBL) environment
• Supported Operations on daily basis with working on tickets raised by business within Service-Now
• Worked with reports built of custom Java scripts embedded within the Server
• Worked with PeopleSoft and ARS interfaces
• Worked with Data Modelling and ETL teams to build/modify tables and jobs to support the reporting needs
• Built on P&L reporting involving complex MDCX functions out of Cognos leveraging the transformer cubes
• Built Inventory Accounting and AP/AR dashboards using dimensional data by making use of complex MDX functions in report studio
• Managed a team of four by halping them out with their daily activities in the reporting requirements
• Worked with team members in performing Peer reviews on code
• Worked in managing Security using active directory and access manager
• Worked on creating reports leveraging various tools within Cognos
• Participated extensively in Data mapping exercises with the DB team
• Worked on migrating Cognos from version 10.1.1 to 10.2.2
• Installed and Configured Cognos 11 Sand Box environment to build POCs on the new version
• Worked on creating a few reports for business users in Tableau
• Designed, Constructing, Testing and Deploying the Cognos Framework Manager Models, Packages, Reports and Power play Models.
• Worked on Cognos for MS Office and Cognos Café for Excel based reporting
• Worked on building complex reports and dashboards out of Cognos Dynamic Cubes
• Worked on implementing row level security on Cognos Dynamic Cubes in version 10.2.2
• Worked on complex MDX functions to report out of dimensional data
• Administered Cognos on a daily basis to maintain Data source configurations and various other parameters
• Created jobs based of triggers upon ETL loads and various other task completions

Environment: Cognos 10.2.2/10.1.1 , Transformer, Netezza, Aginity, Report Studio, Query Studio, Business Insight and Business Insight Advanced, Active Reports, Dashboards, Cognos Mobile, Power Cubes, TOAD, PL/SQL, Oracle 11g, Microsoft SQL Server 2012, Data stage.

Cognos Lead

Confidential, Chattanooga, TN

Responsibilities:

• Worked on Administering and configuring the Cognos environment for the reporting requirements
• Designing, Constructing, Testing and Deploying the Cognos Framework Manager Models, Packages, Reports and Powerplay Models.
• Managing a full sized Cognos team in managing the day to day activities for the report development and analysis
• Worked on integrating Max relationships with Cognos to use with Cognos Framework Manager from out of box Maximo
• Supported in upgrading Maximo 6.2 to7.5 with Cognos integration
• Helping the ETL team to load dummy data for mock-ups whenever needed.
• Guiding the ETL and DB team in setting up the transformation logic as per the report requirement
• Created reporting solutions based on the requirements from the business users and end users
• Managed daily meeting with the business team in discussing the mapping and the report development strategy
• Actively participated in migration process of 10.1.0 Cognos to 10.2.1
• Defining the Users, Group and Roles in LDAP using Cognos Access Manager.
• Preparing User manuals, Operational Guides, Planning and Conducting User trainings
• Installed and Configured Cognos for test environments
• Installed Fix Packs on existing Cognos Environments
• Worked on maintaining the communication with the IBM Support to manage the existing PMR’s and on any new issues being encountered
• Worked on creating a road map for development and migration of the reports developed in Cognos using ODS Data source to work with Oracle DataMart the it has been migrated to
• Worked on supporting the Database team in creating a replicated database out of the data mart with monthly refresh of data
• Worked closely with the Cognos developers in developing the reports and framework manager models based on the requirement
• Experienced as a scrum master in running the daily scrum meetings and managing the team’s tasks on a daily basis
• Created FM Models with using Multiple Data Sources and complex parameterized mapping features
• Worked on creating complex reports in report studio using MDX functions to use with DMR models
• Worked on writing complex SQL Queries to modify and suggest any fixes on performance improvement of the existing reports.

Environment: Cognos 10.x (Framework Manager, Transformer, Cube Designer, Cognos Connection, Report Studio, Rapid adaptive visualization tool(RAVE), Visualization Tool, Query Studio,Analysis Studio), Maximo 6.2/7.5, Informatica, Oracle 11g, SQL Server, ERWIN, TOAD, Windows 2000/2003/XP/7.

Cognos Lead

Confidential, Salem, NH

Responsibilities:

• Participating in daily scrum stand-up calls to exchange updates with the team and also discuss any challenges/defects encountered.
• Collaborated in executing a BI Strategy and Roadmap by contributing individually and collaborating with the team members by providing guidance and assistance on training and usage of IBM Cognos 10.x and concepts.
• Managed the offshore team on day to day activities guiding them in the development activities throughout the development cycle
• Experienced as a scrum master in running the daily scrum meetings and managing the team’s tasks on a daily basis
• Active participation in analyzing the requirement by having frequent sessions with the business team
• Worked with Semantic Layer from Teradata to create reports and dashboards
• Worked on setting up data sources for Teradata by installing the necessary db drivers
• Worked on Data profiling to identify PIs in Teradata tables
• Actively participated in migration process of 10.1.0 Cognos to 10.2.1 in a Z Linux Environment as well as Windows environment
• Involved in creation of AdHoc Reporting environment using Cognos SDK and integrating the same with the Client Portal.
• Application of Custom Autantication to the Cognos environment
• Worked on Cognos Life Cycle Manager to compare the reports and outputs in multiple environments during the migration process to retain report compatibility and consistency
• Worked on Fact and Dimension builds within Cognos Data Manager tool for ETL process
• Designing, Constructing, Testing and Deploying the Cognos Framework Manager Models, Packages, Reports and Power play Models.
• Extensively worked on developing extremely complex Active reports.
• Worked on scheduling, bursting of reports.
• Worked on bursting the reports in multiple scenarios (File system/E-Mail)
• Created complex dashboards and also worked with integrating them within web portals using CMS calls
• Worked extensively on exploring the mapping capabilities in Cognos and also used Cognos Map Manager to customize the existing features and layers.
• Worked on Query studio and also used JavaScripts within Report Studio to achieve complex functionalities.
• Worked on Cognos Work Space Advance for creating advance analysis and reports
• Worked on Rapidly Adaptive Visualization Engine (RAVE) and the Visualization tool.
• Worked on writing complex SQL Queries to modify and suggest any fixes on performance improvement of the reports.
• Worked on creating complex Drilldown and Drill Through reports
• Created complex Active reports using report studio and also worked on optimization of size and bursting of the active reports via E-mail and File System.
• Worked on Event studio to achieve a solution for integrating multiple attachments while bursting multiple reports using same email and also integrating another report within the body of the E-mail.
• Create IQDs using Framework Manager.
• Created FM Models with using Multiple Data Sources
• Experienced in using Data sources in Star Schema Model and also snowflake Schema
• Created Star Schema Grouping in FM Models whenever necessary.
• Created FM Models using Data Sources from Oracle, MS SQL Server, SAP BW and more.
• Implemented Data, Object and Package level security in Framework Manager
• Created Parameter maps in FM to implement dynamic functionality in the reports based on the prompt selections in Report studio
• Created Parameterized Data source selection dynamically using Macro function in Framework Manager
• Worked on integrating multiple FM Models into one Model to create Dashboards supporting multiple products depending on Business requirements
• Created dimension views and User Class views to implement the data security in the Powerplay Transformer Model
• Created DMR models and relational models depending on the reporting requirements.
• Created FM Models using Dynamic Query Mode
• Worked on Dynamic Query Analyzer to analyze the processing time for each step when using DQM and also debug the queries using the analysis.
• Involved in Performance Tuning of the reports.
• Active participation in weekly Cadence calls with IBM support to discuss various issues being faced with Cognos.
• Worked closely with IBM Support team to resolve multiple PMR’s raised by the team
• Preparing User manuals, Operational Guides, Planning and Conducting User trainings.
• Coordinating with the ETL team in defining the ETL logic for Reporting table loads and in setting up the timely schema refreshes for the Reporting Schemas.
• Helping the ETL team to load dummy data for mock-ups whenever needed.
• Debug the queries from within the report studio as well as framework manager and test them across the DB using SQL Developer/TOAD to improve performance and fix issues if any
• Work closely with the Deployment team to prepare necessary EAR files for Deployment using the BMC Blade Logic Tool.
• Used tools like Firebug to debug any errors or issues in the Java Scripts within the report studio and used the same to prepare Timely performance charts for the performance reviews of reports

Environment: Cognos 10.x (Framework Manager, Transformer, Cube Designer, Cognos Connection, Report Studio, Rapid adaptive visualization tool(RAVE), Visualization Tool, Query Studio,Analysis Studio), Cognos Data Manager, BMC Blade logic Automation Suite, Tortoise SVN, Oracle 11g, SQL Server, SAP BW, Siebel, ERWIN, TOAD, Windows 2000/2003/XP/7.

Senior Cognos Developer

Confidential, NJ

Responsibilities:

• Participating in the User meetings to analyze and prepare the reporting and analysis requirements of DSS users.
• Designing, Constructing, Testing and Deploying the Cognos Framework Manager Models, Packages, Reports and Powerplay Models.
• Experienced in migrating the existing Cognos Impromptu Catalogs to Cognos 8 Models.
• Enhancing the Powerplay, Framework Models and Reports to meet the changing business requirements.
• Created a Framework Manager Model with calculated columns, filters and Macros from different data source and created packages to suit the reporting needs of the client.
• Create IQDs using Framework Manager.
• Created dimension views and User Class views to implement the data security in the Powerplay Transformer Model
• Created various Powerplay reports for the Different user groups.
• Created various Crosstab reports and Drill through reports as per the user requirements using conditional formatting.
• Developed various complex and customized (Inserting tables and Blocks) reports using prompts like value prompt, date prompt, type in, cascading prompt, Select & Search Prompt and using conditional formatting as well.
• Extensively worked on Expense and Claims Cubes.
• Created various cubes using multiple datasources.
• Involved in Performance Tuning of the reports.
• Preparing User manuals, Operational Guides, Planning and Conducting User trainings.
• Collecting and sharing best practices and tips in Framework Manager modeling, security setup, Report Authoring, Stress testing and Performance tuning.
• Addressing the Performance and other Production issues with the Cognos 8 reports and Powerplay cubes.
• Defining the Users, Group and Roles in LDAP using Cognos Access Manager.
• Installed Cognos 8 On Windows 2000 Server and Configured the Dispatcher and Gateway.
• Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.
• Coordinating with the ETL team in defining the ETL logic for Reporting table loads and in setting up the timely schema refreshes for the Reporting Schemas.

Environment: Cognos 8(Framework Manager, Cognos Connection, Report Studio, Query Studio Analysis Studio), Cognos Report Net1.1, Cognos EP Series 7 (Impromptu, Powerplay, Powerplay Transformer, IWR, Upfront, Access Manager), Oracle 10g, SQL Server, DB2 7.0, ERWIN, TOAD & Sun One Directory Server, Sun Solaris, Windows 2000/2003/XP.

Senior Cognos Developer

Confidential, Washington, DC

Responsibilities:

• Gathering the Report requirements from the Users to Design the FM Model and developing the Dashboards, Cubes and Complex reports.
• Designed the Dashboard Templates and Created Various Dashboard reports for the Business Users.
• Design the Model for Different Business Areas and analyzing the indexes and Keys and creating star schema.
• Participating in the User meetings to analyze and prepare the reporting and analysis requirements of users.
• Designing, Constructing, Testing and Deploying the Cognos Framework Manager Models, Packages, Reports and Powerplay Models.
• Created a Framework Manager Models with Multiple Namespaces.
• Created a Framework Manager Models with calculated columns, filters and Macros from different data source and created packages to suit the reporting needs of the client.
• Created dimension views and Custom views to implement the data security in the Powerplay Transformer Model.
• Involved in installation Cognos 8.4 Suite on UNIX and Windows.
• Created Multiple Power cubes from Single Model.
• Created Dashboard reports from the OLAP source.
• Implemented the Dashboard reports with the various Cognos Dimensional Functions.
• Created various Crosstab reports and Drill through reports as per the user requirements using conditional formatting using the Rendering and Conditional Variables.
• Developed various complex and customized (Inserting tables and Blocks) reports using prompts like value prompt, Tree prompt, date prompt, type in, cascading prompt, Select & Search Prompt and using conditional formatting as well.
• Created Powerplay cubes using multiple data sources, which are retrieved by Cognos Packages and Reports.
• Extensively worked on the OLAP Data source Reports.
• Created UNIX shell scripts for atomization of the Cubes Refresh using the Crontab on the Cognos AIX Server.
• Involved in Performance Tuning of the reports.
• Preparing User manuals, Operational Guides, Planning and Conducting User trainings.
• Involved in the Cognos Administration like creating new Data source Connections and Creating Packages, handling the Deployment of reports copying from Development to Production server and also handling the user permissions on the Packages and Folders.
• Collecting and sharing best practices and tips in Framework Manager modeling, security setup, Report Authoring, Stress testing and Performance tuning.
• Addressing the Performance and other Production issues with the Cognos 8 reports and Powerplay cubes.
• Created various SQL for the test cases and also used some User-Defined SQL’sIn Framework Manager.
• Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.
• Coordinating with the ETL team in defining the ETL logic for Reporting table loads and in setting up the timely schema refreshes for the Reporting Schemas.

Environment: Cognos 8.4/8.3, (Framework Manager, Cognos Connection, Report Studio, Query Studio,Analysis Studio, Event Studio, Powerplay Studio), Cognos 8.4 Transformer, Cognos 8.1.1, Business Glossary, SDK, Data stage 6.0, Oracle 10g, SQL Server, TOAD, AIX, Windows 2000/2003/XP.

Cognos BI Developer

Confidential, San Diego, CA

Responsibilities:

• Developed Framework Manager Models with Physical layer and Presentation Layer to cater the various business’s needs (Folders, Filters, and Macros)
• Develop new reports on timely bases, by extracting new data from database by running the DTS packages and rebuilding the OLAP cubes
• Generate financial reports from Operating Statement Cube and Balance sheet Cube
• Developed Complex Report Studio Reports using Bursting, Tabular Objects.
• Securing Cognos Connection and setup ReportNet security by assigning users to the groups and roles defined in Cognos Namespace
• Applied Security and User Autantication to the various User Groups.
• Created reports in Impromptu and published them to the Upfront Server using IWR
• Build a dashboard report in PowerPlay which indicates the Key Performance Indicators (KPI)
• Created Drill- through reports and Customized Reports with Prompts (List. Cross tab)
• Developed Standard templates in Report Studio for developing reports.
• Created several different types of Professional Reports (Mailing Labels, Cascading, Linked /Drill Through, Production, Business, Ranking, etc…) with complex formatting utilizing Report Studio
• Created documentation to describe entire flow of the applications, program development, logic, coding, testing, changes and corrections
• Performed Unit testing for all developed reports

Environment: Cognos 8.4, Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Impromptu, Cognos PowerPlay, Cognos Powerplay Transformer, Cognos PowerPlay Enterprise Server, Cognos Upfront, SQL Server 2000, DB2, MS-Access, MS-Excel, Windows

Cognos BI Developer/Analyst

Confidential, Wilmington, DE

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Conducted requirements gathering sessions and interacted with business process owners to understand the functionality required.
• Analyzed and optimized the process. Prepared Business Requirement Document and tan converted the business requirements into Functional Requirements Specification and Technical Specification.
• Prepared meeting minutes and distributed to various participants and for artifacts purposes.
• Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Created models (.cpf) in Framework Manager Modeling tool and publish packages in Cognos Connection.
• Implemented data level and object level security in Framework manager.
• Created prompts, calculations, conditions & filters in the report as well as in the Framework Manager.
• Created Dashboards and modified the existing Dashboards using Report Studio.
• Created Drill through Reports and also used Conditional Formatting extensively.
• Improved performances of the Reports.
• Used TOAD extensively for Unit Testing and Analyzing the data.
• Created tables and Inserted/Updated Values using TOAD.
• Imported Excel data into Oracle tables using TOAD.
• Worked on LDAP Servers, created Users and their User groups using a tool called Cygwin and ZUM (built on VB 6.0). Modified ZUM tool code and also demonstrated the functionality of the tool to Production support teams.
• Set up required permissions in the Cognos Portals for the User group for security purposes.
• Document the list of changes that impact the reports using MS Word and MS Excel.

Environment: Cognos 8.3 BI, Framework Manager, Cognos Connection, Report Studio, Query Studio, Metric Studio, Impromptu 7.4, Cognos Power Play Transformer 7.4, Power Play for Web, Access Manager, XML, MS SQL Server 2005, Oracle, DB2, Windows 2003 server.

Cognos Developer

Confidential

Responsibilities:

• Worked with team, to understand the data and business logic underlying the requirements.
• Worked with Cognos 8.1 BI modeling, Report Studio.
• Created Cognos Data Models using Framework Manager and Data Mining using Analysis Studio
• Used Framework Manager to model metadata by analyzing the model design and published packages.
• Modified packages to suit the business needs and to improve the performance of the reports.
• Designed models using Impromptu Query Definition (IQD), created OLAP cubes in Cognos Transformer and analyzed the data using Cognos power Play.
• Decreased the cube build times drastically and increased runtime performance.
• Involved in migrating reports from Impromptu to report Net. Published all Impromptu reports to IWR upfront.
• Created Complex Multi-Object Reports using Lists, Charts, Crosstabs and Images using Report Studio and Ad-hoc reports in Query Studio.
• Creating prompt pages, filters and calculations according to the user requirements in Report Studio.
• Created 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.

Environment: Cognos 8(Report Studio, Query Studio, Cognos Connection, Analysis Studio), Report Net 1.1, Power Play Transformer 7.3, Impromptu 7.3, Access Manager, XML, Oracle 10g, TOAD, SQL Server 2005.