SUMMARY

• An IBM Cognos Certified Analyst with over 7+ years of specialization in OLTP/OLAP/Data Warehousing, BI tools and in analysis, design, testing, development, and implementation of client server applications.
• Extensive experience working with Cognos Analytics 11.0.5,10.2.2, 10.2.1, 10.1.1, 8.1, 8.3, 8.4.1 suite, Business Intelligence Reporting Suite (Framework Manager, Analysis Studio, Report Studio, Event Studio, Query Studio, Transformer, Active reports using RAVE visualization and Cognos Administration).
• Created IQD’s in Framework Manager to use in Cognos Transformer using externalized method for building up of Multidimensional Cubes.
• Hands on Experience with Framework Manager Modelling (Physical Layer, Business Layer, Packages) and Complex Reports (List, Cross tab, Charts, Maps, Drill - through, Master-Detail and Cascading) and Dashboards building with Report Studio.
• Worked on advanced features of Report Studio such as Conditional Variables, Conditional Blocks, Drill-through, Page set, Master-Detail relationships, Jobs, Scheduling and Bursting of Reports and various kind of prompts (Value prompt, Date prompt, Textbox prompt)
• Extensive Experience with Cognos 10.x BI Studio, Framework Manager and Cognos Dynamic cubes in 10.2.1.
• Extensive experience in Installation, Configuration & Migration of the Cognos 8.4/8.3 BI Environment to higher versions Cognos 10.1.1 and 10.2.1 which is the latest version
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Worked on complete Life Cycle Development process, which includes analyzing business needs, documenting business information requirements, technical designs, development, integrating, Implementing and Production Support using Cognos as a BI tool.
• Experienced in using Java script and HTML to create dashboard reports.
• Experienced in Migration of other reports into Cognos (BO to Cognos) and version up-gradation in Cognos (8.4 to 10.2.1).
• Resolve Cognos software related issues on end user computers and provide on-call support 24*7
• Experienced in Reports Deployment from development environment/server to Testing and Production environment/server using Content Administration
• Experienced in Kron shell scripting for deployment, Scheduling & start and stop services reports in cognos
• Experienced in controller M for scheduling reports
• Experience in analyzing business needs and translate them into technical specs and maintain the information flow in the team.
• Proficiency in working with Relational Databases like Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , DB2 and database access tools like TOAD, and SQL Assistant.
• 3+ years of strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica and data stage.
• Extensively worked with ETL team and gathered/provided the requirements for the project.
• 5+ years of experience in developing procedures, packages and functions in DW environment and to use them in creating models in FM.
• Experience Securing the Framework Manager models for data level, object level and package access security.
• Experience in creating Audit reports which can track the maintenance of Cognos server.
• Experience in providing Cognos security and administration for all internal and external users includes creation / modification of Cognos roles, AD groups, and user interface portals.
• Experience in deploying reports and packages and maintaining enterprise level security (LDAP/Active Directory). Installation/configuration and set-up of new Cognos environment.
• Involved in many cross training session and SPOC for direct training to the users to provide knowledge on the tool and its features, as well experienced as Project Manager and lead the team.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules.
• Conducted the end-user trainings and created the user help documents and played as a mentor to the newly joining team by giving knowledge transition in both technical and functional areas
• Proven experience in development and implementation of applications in various domains viz. Insurance, Banking and Travel.
• Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes, and corrections.
• Good Communication and Interpersonal skills. Technically sound, Result-Oriented with strong Problem solving skills. Innovative & efficient.

TECHNICAL SKILLS

BI Tools: Cognos 10.2.X, Cognos10.1.X, Cognos Business Intelligence (8.1 to 8.4) (Report Studio, Query Studio, Analysis Studio, Metrics Studio, Cognos workspace, Configuration Manager, Cognos workspace advanced, Cognos Administration, Cognos Dynamic cubes in 10.2.1 and in using MDX functions, Report Net, Cognos Access Manager, Business Objects.

Modeling Tools: Cognos Transformer & Cognos Framework Manger

Querying Tools: Toad, SQL-Plus, SQL Developer, SQL Management Studio

ETL Tools: Informatica workflow designer, Data Stage, Data Manager

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

RDBMS: Oracle Exadata, Oracle 11g/10g/9i/8.x, MS Access/Excel, DB2, and SQL Server

Operating Systems: Windows 2003/2008/2012 R2, UNIX, AIX, Sun SOLARIS

PROFESSIONAL EXPERIENCE

Confidential, Littlerock, AR

Sr. Cognos Admin/Analyst/ Developer

Responsibilities:

• Responsible for understanding business requirements and translating them into high quality report deliverables.
• Implemented patches and other day-to-day Cognos administration tasks including creating folders/reports/users and migrating reports/folders/users from Dev to QA to Production
• Provided Cognos security and administration for all internal and external users includes creation / modification of Cognos roles, AD groups, and user interface portals.
• Created structured Database by using Transformations in ETL end which can be used to create Packages, Reports and Cubes.
• Primary point person for troubleshooting issues related to infrastructure, application performance, security access and enforcements, source control, and report distribution
• Developed and Implemented Reports and Interactive dashboards to help drive business decisions.
• Expertise in designing Framework Manager Packages and Reports.
• Complex Report building experience in Report studio by using Drill up and Drill down, Master/details queries, and filters customized prompts, conditional formatting, drill-through, Crosstab, Variables Created Models using Curam as a source.
• Created Dashboard with PIE, Line, Combination chart and stacked Bar chart for Proof of Concept.
• Created Reports for Adhoc Request using Sql overwrites.
• Migration of Cognos objects from one version to other. Versions worked on: Cognos 10, Cognos 11.
• Deployed Reports, Packages and Folders from DEV to UAT INT., UAT & PROD
• Developed AR Works Work Requirement Metrics and Portal Metrics Report for MAGI .
• Developed complex Reports, and Dashboards using Cognos BI.
• Extracted the data from Relational Database, Flat Files and Loaded into the target Data warehouse.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager
• Created Medium ETL Mappings, Workflow for Datawarehouse tables using Informatica
• Ensuring clear query paths by resolving ambiguous relationships (Role-playing dimensions, loops).
• Developed Java scripts to customized Prompt selections.
• Used Kron shell scripting to communicate cognos servers
• Used Controller M for scheduling reports
• Created Summary and detail reports and navigated from summary and Detail Reports.
• Created Jobs and scheduled reports which are indeed necessary for the clients.
• Created structured Database by using Transformations in ETL end which can be used to create Packages, Reports and Cubes
• Environment: Cognos Analytics 11.0.5 (Dashboard, Report Studio, Workspace, Workspace Advanced, Analysis Studio, Cognos Connection, Framework manager, Cognos Administration), IBM DB2, AX 7, Toad, Microsoft Excel, Microsoft Access, SQL Server, Kron shell, Controller M.

Confidential, Dallas

Sr. Cognos Developer/Admin/Analyst

Responsibilities:

• Created models (.cpf) in Framework Manager Modeling tool and publish packages in Cognos Connection.
• Created structured Database by using Transformations in ETL end which can be used to create Packages, Reports and Cubes.
• Created a Framework Manager Model and Power Play with calculated columns, filters and Macros from different data source and created packages to suit the reporting needs of the client.
• Created PowerPlay cubes using multiple data sources, which are retrieved by Cognos Packages
• Created Complex Multi-Object Reports using Lists, Charts, Crosstabs, Bursting and Images using Report Studio and Ad-hoc reports in Query Studio.
• Preparing User manuals, Operational Guides, Planning and Conducting User trainings.
• Upgraded reports from Cognos 8.4 to Cognos 10.2.1 and created new active reports in Cognos 10.2.1.
• Developed reports and dashboards using Active reports RAVE visualization, Report studio, query studio, business insight in Cognos 10.2.2.
• Provided Cognos security and administration for all internal and external users includes creation / modification of Cognos roles, AD groups, and user interface portals.
• Worked on Implementation, testing, and documentation of new and updated Cognos reporting packages to be moved into production environment per request by project.
• Implemented patches and other day-to-day Cognos administration tasks including creating folders/reports/users and migrating reports/folders/users from Dev to QA to Production
• Support all Cognos configuration requirements regarding new clients and client database migrations. Includes working with DBAs for setting up and testing new Oracle data sources used by Cognos.
• Assist internal and external clients with problem reports, and demonstrating how to use Cognos Analysis Studio, Report Studio and Query Studio.
• Utilize the Cognos SDK, and third-party tools to support infrastructure interfaces and administration
• Created Jobs and scheduled reports which are indeed necessary for the clients.
• Primary point person for troubleshooting issues related to infrastructure, application performance, security access and enforcements, source control, and report distribution.
• Partner with DBA team, Systems team, Networking team, Middleware team, Data Architect, Business Intelligence team to facilitate issue resolution.
• Responsible for Cognos audit, security, usage and licensing monitoring and partners with the BI Reporting Lead and developers to assist with report development for these areas.
• Support for developers to trouble shoot report issues related to Cognos configuration and/or report SQL for slow-running and nonfunctioning reports scheduled in Cognos
• Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.
• Provide administrating support to data warehousing, database and server technologies
• Administered several projects and completed them successfully through 'Cognos Administration'
• 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 10.x (Transformer, Cube Designer, Report Studio, Workspace, Workspace Advanced, Analysis Studio, Cognos Connection, Framework manager, Cognos Administration), Oracle 11g, Windows 2003/7, Toad, Microsoft Excel, Microsoft Access, SQL Server.

Confidential, NY

Cognos Admin/Developer

Responsibilities:

• Worked with Business Users to get the user requirement for creating multi-dimensional cubes and canned reports.
• Responsible for Installation, Configuration & up gradation of Cognos 8.4.1 to 10.2 & 10.2.2 at the client location and successful implementation of the whole project in terms of upgradation.
• Developing a logical model that conforms to star schema concepts, different views (data/physical, business, and Presentation layers) as per Business requirement
• Interaction & Req. Gathering from the client. Handled different meeting like POC, demos etc. with stake holders.
• Developed multidimensional models from multiple data sources using PowerPlay Transformer.
• Refined the multi-dimensional models using special categories like excel, IQD, packages, alternate drill-down path, calculated measures, etc. to better suit user needs.
• Partitioned Power cubes and updated the cube using incremental update.
• Did performance tuning on power-cubes to reduce query time and partitioned cubes.
• Updated Power Cubes with new data base columns using IQDs generated in Framework Manager via externalized method.
• Used PowerPlay for further analysis, slice and dice, drill down and creating reports from cubes.
• Developed Complex reports using Report Studio which includes various report types ranging from simple lists, crosstabs and chart through complex dashboards, drill-through, master-detail and conditional formatting.
• Created multipage reports involving prompts, cascading prompts, conditional rendering and conditional highlighting.
• Identify technical need of the organization and the project requirement and ensure maintenance and control continuity of the Cognos environment
• Partner with the Data Architect, the DBA team, and the Systems team on data and meta-data retention, back-ups, caching, and disaster recovery.
• Worked on 3 tier metadata modeling in Framework Manager and published multiple packages.
• Created Active Reports (using data tabs, data decks etc.) and Dynamic Cubes in Cognos 10.2.
• Updated Active Reports using Scheduled jobs.
• Analyzed existing solution containing cubes reports, materialized views and worked with the functional team to create technical documents.
• Installed, configured and administered various Cognos components such as the Cognos BI server, Framework Manager, Transformer and Cube Designer.
• Upgraded Cognos from 10.1.1 to 10.2.1 and tested for multiple environments like Development, Testing, UAT and Production using Cognos life cycle manager.
• Supported the reports in Production environment and transferred knowledge on maintaining/modifying reports in the future to the support team.
• Provide administrating support to data warehousing, database and server technologies
• Identify technical need of the organization and the project requirement
• Ensure maintenance and control continuity of the Cognos environment
• Working knowledge of the various monitoring features and metrics incorporated in the Cognos Connection Portal
• Administered several projects and completed them successfully through 'Cognos Administration' tool

Environment: Cognos 10.x (Transformer, Cube Designer, Report Studio, Workspace, Workspace Advanced, Analysis Studio, Cognos Connection, Framework manager, Cognos Administration), Oracle 11g, Windows 2003/7, Toad, Microsoft Excel.

Confidential, Dover NH

Cognos Developer

Responsibilities:

• Developed from scratch and enhanced existing framework manager model with addition of new tables, views, relationships, name spaces, folders, query subjects, query items, calculations, filters, dimensions and hierarchies.
• Developed Packages in Framework manger and cubes in Transformer.
• Created the complex reports like drill through capabilities from Cube-to- Cube and Cube- to- Relational reports.
• Developed crosstab and list reports in Report Studio and special formatted them using Style variables, Conditional Styles and Render variables to create alerts, highlight selections and to hide columns, rows, sub-totals based on certain conditions
• Developed master-detail reports, drill through reports,
• Developed and setup reports for bursting that will personalize the users data based on their ownership selection
• Used report formatting, sorting, grouping, sections, headers, filters, prompts, conditional blocks, String/Boolean variables, page breaks, and master-detail to develop complex reports.
• Developed Detail level design documents and Unit Test Case documents.
• Worked with the Business Users to UAT the developments and applied changes & fixes based on their feedback.
• Attended Change management meeting to get approval of the deployments with all the required UAT evidences and documentations

Environment: Cognos 8.3 (Framework Manager, Transformer, PowerPlay, Report Studio, Query Studio, Analysis Studio, Metric Studio), DB2