PROFILE SYNOPSIS:

• IBM Certified Cognos Developer with 10 years of experience in Business intelligence reporting, Design, Development, Testing, Documentation and Implementation of Cognos applications and maintenance of Data warehouses, Databases, Data marts and providing solutions for Health care, Government, Manufacturing, Retail, Insurance and Banking domains. In this stint, have encompassed diverse roles like Team Lead, Team Member, Business Analyst and Subject M Confidential er Expert.
• 10 years of excellent experience on complete Cognos suite (Cognos 10.2, 10.1, 8.X, Reportnet 1.1 MR2, Framework Manager, Powerplay Transformer, cube designer and Impromptu 7 series).
• 3 years of development experience with cognos 10.x version and 6 years of development experience with cognos 8.x.
• High proficiency in Cognos Report studio,Event Studio,Metric Studio,Analysis Studio, Framework Manager and Powerplay transformer .
• 10 years of excellent experience on Database applications and sound skills in developing SQL Scripts, Stored Procedures, functions, packages. Experience with SQL Server 2008 R2/2005,Oracle 10g,Netezza
• 7 years of Cognos administration experience on Cognos installation, configuration and Security setup.
• Sound knowledge on Data Warehousing Concepts and relational, dimensional modeling with designing star schema and snow flake schemas using Framework Manager as per the reporting performance requirements.
• Hands on with preparing BRD’s, Unit Testing, User Acceptance testing, and Testing Documentation.
• Knowledge on reporting tools BOXI R2, SSAS and SSRS .
• Strong experience in ETL tool SSIS .
• Superior knowledge of Cognos Server Architecture and great expertise on Cognos installation, configuration, single sign on access, production deployment, server maintenance, Content store backup, recovery, Security administration and server performance monitoring.
• Expertise in Cognos admin activities like Promote objects to upper environments, grant/deny folders access to users, Data source creations, grant access to different studios to developers and users
• Proficient in Cognos SDK
• Experience in Cognos Dynamic Cubes
• Proficient in Cognos Workspace and Workspace Advanced
• Extensively worked on Report performance tuning
• Hands on experience on Cognos TM1 10.2.2
• Good experience in automating SSIS Packages through Sql Agent Jobs
• Extensively worked on Sqlserver T Sql, Stored Procedures, Temp tables, CTEs and Netezza Sql(NZ Sql)
• Strong troubleshooting and production Support skills and coordination/ interaction abilities with end users.
• Scholastic Background and s:
• IBM Certified Designer - Cognos Report Authoring.
• IBM Certified Metadata Modeling
• Oracle Certified Associate
• Microsoft Sql server

TECHNICAL SKILLS:

Business Intelligence Tools: Cognos 8.x, 10.x, Cognos ReportNet, Cognos Powerplay Transformer, Business Objects XI R2, Microsoft SSAS, SSRS

Planning Tool: Cognos TM1 RDBMS Oracle 10g/9i/8i., MS SQL Server2005/2008 R2, Netezza and MS-Access, Excel

ETL Tools: Microsoft SSIS, Informatica

Programming Languages: C, C++, Java, SQL, PL/SQL Web / Scripting: HTML, JSP, Java Script IIS, Tomcat 4.x/5.x:

Data Modeling: Star Schema Modeling, Snow Flake Modeling and FACT & Dimensions

Testing Tools: Manual Testing, Unit level testing

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Cognos Architect / Data Modeler

Responsibilities:

• Working directly with end users as an Architect to gather reporting requirements.
• Working with Client Technical Leads and Business/Functional leads for technical design
• Involved in analyzing business requirements gathering and documenting Functional & Technical specifications for Framework Manager Models and Reports
• Design and Develop complex DMR and Relational Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Setting up cardinality (minimum, maximum & optional), Determinants to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Securities in Framework Manager Models.
• Create Audit Package and Audit Reports for tracking
• Assist admins in configure multi-server environment with multiple dispatchers and content managers. Set up back up mode to avoid production downtime
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Designed and Implemented new dashboards using Portals pages and Cognos workspace.
• Developed Active reports for users to use offline.
• Design and develop Complex Dashboard Reports, Drill through Reports, Master Detail Reports using Report Studio, Query Studio and Analysis Studio.
• Create Standard Reports using DMR and Relational model Packages
• Write HTML/Java Script in Cognos Report Studio reports as per the requirements.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Worked on resolving the performance issues after report migration.
• Developing complex queries using Transact SQL and Netezza (NZ Sql).
• Involved in providing technical assistance by responding to inquiries regarding errors, problems or questions with programs/interfaces.
• Involved in the part of understanding the performance issues and resolving them.
• Part of preparing the Unit Test Cases (UTC) and performing system testing in development environment and created documentation for all the processes involved like applying security for reports, deployment, portal customization etc.
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Performance tuning of production Reports
• Ensure quality deliverables as per project plan and timelines
• Train End users on Cognos Query Studio and Report Studio
• Production support for BI applications

: Cognos 10.2.1(Framework Manager, Report Studio, Query Studio, Event Studio), Netezza, Microsoft Sqlserver 2008 R2, Microsoft SSIS (ETL)

Confidential, Dallas, TX

Sr. Cognos Developer/Cognos Admin

Responsibilities:

• Partner with the Data Warehouse Architect to ensure the data model supports the reporting requirements

• Used Cognos Connection for the design of reports using Report Studio and Query Studio
• Weekly meetings with clients to gather required information for solutions
• Involved in creating various Rapid Development Templates Reports
• Worked on Cognos installation and configuration and security setup
• Creating a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications.
• Worked as a Cognos admin and expertise in Cognos server maintenance, Content store backup and recovery, Security administration and server performance monitoring.
• Involved in Cognos installation, configuration and security set up using active directory.
• Add users to Cognos Groups
• Apply security to Reporting folders based on security groups
• Involved in Audit database configuration in Dev, QA and Prod environments.
• Maintained Security in all three Environments namely Development, QA and Production.
• Modify Report style xmls to create new pallets
• Design and implement a robust security architecture which will include both row level security and object security.
• Created Active Reports, Complex Dashboard Reports, Drill through Reports and Master Detail Reports using Report Studio and Business Insight Advanced.
• Involved in designing the best possible approaches to develop the models using Framework Manager and published the packages to Cognos Connection
• Create SDK program to display all users and their access to reports
• Update the reports and queries belonging to the package through Cognos SDK
• Update Owner of the reports through SDK
• Migrated the reports from Development Environment to QA and Production Environment
• Prepared detailed user manual(s), for different package(s), explaining the business rule behind all the fields in the package and illustrate the functionalities available in Query Studio, to help users create ad-hoc reports.
• Create Event Studio Trigger to schedule the reports based on ETL Load completion
• Involved in tuning the SQL and Reports to reduce the report runtime.
• Used Business Glossary for Metadata Management
• Train end users on application and clarify their questions

Environment:: Cognos 10.2.1(Framework Manager, Report Studio, Event Studio), Cognos SDK, Oracle 11g

Confidential, Dallas, TX

Tech Lead (ETL and BI)

Responsibilities:

• Prepared detailed user manual(s), for different package(s), explaining the business rule behind all the fields in the package and illustrate the functionalities available in Query Studio, to help users create ad-hoc reports.

• Create SSIS Packages by creating different types of tasks
• Created Flat file source and OLEDB Data source connections to pull data from CSV files and Netezza tables
• Created expressions on Data source connections to dynamically create connection strings in SSIS
• Used Sequence containers to combine set of transformations
• Used Merge join to pull data from different tables with Outer joins
• Crated configuration tables to store connections information
• Migrate SSIS Packages to UAT and Production
• Automate SSIS Packages through Sqlserver Agent
• Extensively worked on Netezza (NZ Sql) to create reporting data and use those NZ sql in SSIS to populate Reporting Tables
• Create a metadata Models and publish as a package to Cognos connection
• Define Burst groups, Burst Keys and recipients to distribute a single report with multiple outputs with Cognos bursting
• Designed Reports with various conditional form Confidential ing to identify the measures for the different types of reports.
• Create dynamic parameters to change the database connection on the fly.
• Migrate Cognos Packages and Reports to UAT and Prod environments
• Involved in tuning the SQL and Reports to reduce the report runtime.
• Migrated the reports from Development Environment to QA and Production Environment
• Review team work before delivering to client
• Train end users on application and clarify their questions

Environment:: Cognos 10.2.1, Microsoft SSIS, Netezza

Confidential, Phoenix, AZ

BI Lead

Responsibilities:

• Understanding existing business Data Model and customer requirements

• Used Cognos Connection for the design of reports using Report Studio and Query Studio
• Involved in creation of different kinds of complex reports
• Created Models & Packages using Framework Manager and published to Cognos Connection
• Developed the Burst reports in Report Studio
• Involved in Deployment of Reports from Development Environment to QA and Production Environment
• Created various IQD package in Framework Manager and used this IQD’s in power play transformer to create various models and build cubes
• Create Dimensions, Hierarchies, Measures as per reporting requirements and build cubes
• Worked extensively on Cube creation using Cognos Powerplay transformer and Cube Automation for automatically updating cubes and saving them on the designated folders according to the client’s requirements.
• Generate multi-dimensional reports through cube package
• Prepared detailed user manual(s), for different package(s), explaining the business rule behind all the fields in the package and illustrate the functionalities available in Query Studio, to help users create ad-hoc reports.
• Involved in ETL to create tables required for Reporting

Environment:: Cognos 10.1, Powerplay Transformer, Oracle 11g (Sql,PL/SQL)

Confidential, Minneapolis, MN

Senior Cognos Developer

Responsibilities:

• Understand Functional design documents and Business requirement documents

• Prepare technical documentation for Framework Manager Project, Reports
• Create a Framework manager Package with Presentation layer and publish to Cognos Connection
• Create different types of prompts(Value Prompt, Radio Prompt, Date Prompt, Search prompt) in Report prompt pages
• Create different types of layout calculations and query calculations
• Apply dynamic sorting and dynamic grouping for report objects through Grouping and Sorting
• Prepare Unit Test case documents for User Interface and Data part
• Execute Test Cases and do data validation by running sql queries
• Fine tuning of report queries by creating inline views to improve reports performance
• Create Materialized views to improve performance of reports and point the reports to these new materialized views to pull data
• Migrate report to production and Post-Production support

Environment:: Cognos 10.1.1, Oracle 10g, Windows NT

Confidential, Thousand Oaks, CA

Sr. Cognos Developer

Responsibilities:

• Analyze the report design specs

• Create Metadata Model consists of creating Namespaces, Query Subjects, filters and Calculated Measures
• Publish the Package to Cognos Connection
• Create List Reports(Master Detail) by using Report Studio
• Create Sql in Report Studio for some of the Reports.
• Create Value Prompts, Text Box Prompts and Cascading Prompts
• Worked with Data through Filtering, Sorting, Grouping Identical values, calculations, and summarization, changing the data format. Using prompts to filter data.
• Use various conditional variables to do the conditional form Confidential ing
• Update the reports according to the client requirements
• Develop & Unit testing the Reports

Environment:: Cognos 8.2, Oracle 9i, Informatica, Windows XP

Confidential

BI Developer

Responsibilities:

• Understand Functional design documents and Business requirement documents

• Prepare technical documentation for Framework Manager Project, Reports and Powerplay transformer cubes and data mappings
• Create a Framework Manager Project by creating Database and Presentation Layers
• Create a List reports/Cross reports/Charts with Report Studio
• Create multiple queries and multiple report pages
• Create different types of prompts(Value Prompt, Radio Prompt, Date Prompt, Search prompt) in Report prompt pages
• Create cubes and publish to Cognos connection to create standard reports through Analysis studio
• Prepare Unit Test case documents for User Interface and Data part
• Execute Test Cases and do data validation by running sql queries
• Handle Report performance issues

Environment:: Cognos ReportNet, Powerplay Transformer, Oracle 9i, Windows NT.

Confidential

SSIS/Cognos Developer

Responsibilities:

• Understand Functional design documents and Business requirement documents

• Analyze the report design specs
• Create multiple Source to Target transformations through SSIS (Sql server Integration service)
• Create Execution Task, Sql Task .Job Task transformations through SSIS
• Create SSIS packages for Exception Reports.
• Creation of Package in Framework Manager
• Create List Reports, Cross Tab Reports, Charts, Sectional Reports & Drill through reports by using Report Studio
• Create Value Prompts, Text Box Prompts and Cascading Prompts
• Update the reports according to the client requirements
• Development & Unit testing the Reports
• Create Report views and scheduling the reports by jobs
• Involved with Scheduling and Distributing Reports through Bursting
• Create Framework manager and report specifications.

Environment:: Cognos 8.2, Powerplay Transformer, Oracle 9i, Windows XP.