SUMMARY:

• 8+ years of IT experience in analysis, design, development, customization and implementation of software applications. IBM Certified Cognos BI Developer and Designer/Modeler. Extensive experience on Cognos 8.4/10 Business Intelligence Suites including Report Studio, Query Studio, Analysis Studio, Framework Manager.
• IBM Cognos Certified Report Author and Modeler with over 8 years of experience in Database, Data Warehousing & Business Intelligence with strong experience in Enterprise Data Warehousing tools
• Involved in Full Life - Cycle project activities from defining project roles and responsibilities, detailing project plans, requirements gathering and specification to implementation, testing and support
• Experience with the Cognos 8/10 BI tools (Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Metric Studio, Transformer) as a Developer and Administrator
• Involved in Metadata modeling using Cognos Framework Manager, Cognos Transformer
• Implemented Security at different levels in Framework Manager and Cognos Connection
• Expertise in developing Complex Reports (List, Crosstab, Drill through, Master-Detail, Charts, Maps, multi-query multi-prompt reports, burst reports) and Dashboards and Active Reports using Report studio
• Involved in the Cognos Administration Tasks like Creating Data source Connections, Publishing Packages, scheduling reports, User Creation, Assigning Security, Deployment of Packages and reports in different environments
• Involved in the Installation and Configuration of Cognos BI tools and Framework Manager
• Extensively worked on Relational Databases like Oracle, MS-SQL Server, DB2 and Teradata
• Experience with Dimensional Data Modeling and creating Star Schema/Snowflake Schema
• Experience in creating complex Stored Procedures, Tables, Views, Materialized Query tables, Indexes and SQL
• Strong experience in best practices design and performance tuning
• Have knowledge on Installation and Configuration of IBM Rational CLM (Rational Doors Next Generation, Rational team Concert, Rational Quality Manager) with specialist certification on Rational Doors Next Generation
• Played the role of a Developer, Lead developer, Mentor, Business Analyst and Architect in various DW projects
• Decisive team player with the ability to meet deadlines, handle multiple tasks and flexible in work schedules
• Having basic knowledge on Qlikview, Spotfire reporting tools and Informatica, Cognos Data Manager ETL tools.

TECHNICAL SKILLS:

Cognos 8.4 / 10: Framework Manager, Report Studio, Query Studio, Cognos Connection, Metric Designer, Metric Studio, Analysis studio and Event Studio, Transformer

Reporting Tools: Qlikview, Spotfire

ETL Tools: Cognos Data Manager, Informatica

Databases: Teradata, SQL Server, Oracle, DB2

Rational: Rational Doors Next Generation, Rational Team Concert, Rational Quality Manager, CLM

Data Modelling Tool: Erwin, ER Studio

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Cognos Developer

Responsibilities:

• Gathering and analyzing customer requirements and involve in various business discussions with the end users of the application
• Analysis of requirements, preparing design/program specification, Technical specification document
• Installation and Configuration of Cognos 10.2.2 Business Intelligence.
• Design and Development of Cognos Business Intelligence Reports, Dashboards.
• Design new Cognos packages using Framework Manager.
• Set up the Audit process for report environment.
• Lead a team of Cognos Developers and coordinate with stakeholders.
• Provide technical and functional guidance to team as necessary
• Identifying, documenting and implementing process improvement initiatives.
• Attending weekly customer meetings and internal Team meetings.
• Creating test scripts for Cognos reports testing and validating the test results.
• Understanding State Governments requirements on Medicaid Enrollment and Eligibility Program.
• Prepare and manage the Process documents, design templates.
• Installation, Configuration and maintenance of IBM Rational CLM.
• Administrating the defect and project management tools like IBM Rational Team Concert.

Confidential

Cognos Developer

Responsibilities:

• Developed detailed and summary reports using Cognos 8.4 BI Report Studio.
• Created Cognos Framework Manager Model and published packages for reporting activity in Windows environment.
• Involved in administration tasks like creating data source, publishing packages, creating users, role based user security and scheduling the reports
• Design and create reports using Report Studio.
• Design and Develop auto-migration of Cognos Deployment package from one environment to another environment.
• Enhanced the report by highlighting the data and hiding the objects using Conditional Formatting.
• Created Multi Page Dashboard (Portlet) for single point of access for all the reports developed in the Project
• Created burst table and did Bursting of reports.
• Created Cognos multidimensional cubes using PowerPlay Transformer for users to be able to get business information from Analysis Studio.
• Used Render Variables, String Variables for the better user friendly dashboard creation.
• Created Code Review Documents and Technical Unit Testing Documents.
• To work closely with the onsite team to ensure that the continuously changing project requirements are captured.

Confidential

Cognos Developer

Responsibilities:

• Developed detailed and summary reports using Cognos 8.4 BI Report Studio.
• Created Cognos Framework Manager Model and published packages for reporting activity in Windows environment.
• Involved in administration tasks like creating data source, publishing packages, creating users, role based user security and scheduling the reports
• Design and create reports using Report Studio.
• Enhanced the report by highlighting the data and hiding the objects using Conditional Formatting.
• Created Multi Page Dashboard (Portlet) for single point of access for all the reports developed in the Project
• Used Render Variables, String Variables for the better user friendly dashboard creation.
• Created Code Review Documents and Technical Unit Testing Documents.
• To work closely with the onsite team to ensure that the continuously changing project requirements are captured.
• Created burst table and did Bursting of reports.
• Created Cognos multidimensional cubes using PowerPlay Transformer for users to be able to get business information from Analysis Studio.

Confidential

Cognos Developer

Responsibilities:

• Work with Business Analysts to translate business requirements into technical specifications for new enhancements to existing Application using COGNOS.
• Created Cognos Framework Manager Model and published packages for reporting activity in Windows environment.
• Developed detailed and summary reports using Cognos 8.4 BI Report Studio.
• Enhanced the report by highlighting the data and hiding the objects using Conditional Formatting.
• Used filters, conditions, calculations, sorting, parameters, prompts, data format and various functions in the reports.
• Created User Manual, Code Review Documents, Technical Unit Testing and System Testing Documents.
• Handling deployment of packages in different environment, user training, knowledge transfer, support and transition activities

Confidential

Cognos Developer

Responsibilities:

• Developed detailed and summary reports using Cognos 8.4 BI Report Studio according to business requirements.
• Creating/Modifying metadata models using Cognos Framework Manager Model as part of Development/enhancement.
• Create different type of charts like Pie charts, Bar charts and Reports like List, Crosstab.
• To work closely with the onsite/offshore team to ensure that the deliverables are as per the Track without any delay and to provide updates related to continuously changing project requirements.
• Created Code Review Documents and Technical Unit Testing Documents.
• Handling deployment of packages in different environment, user training, knowledge transfer, support and transition activities
• Supporting the data issues while loading from Oracle to Teradata
• Creating Informatica Jobs to load data from various source systems into Data Warehouse.
• Creating test plan and SQL scripts for Cognos reports and Framework Manager model.
• Creating jobs, scheduling and Distributing Reports through Schedule Management in Cognos Connection
• Worked on Complex SQL queries for data testing