SUMMARY:

• Over 11+ years of IT experience in the software life cycle in analysis, design, development, testing and deployment for many applications and out of which 10+ years in DWH Business Intelligence with strong technical exposure and good experience of OLAP Tool like Cognos BI/Analytics.
• Wide experience in developing Cognos architecture
• Solid expertise on usage of Cognos 10.XX/Analytics and 8.4 tools like (Framework Manager, PowerPlay Transformer, Cube Designer, Analysis Studio, PowerPlay Studio, Report Studio, Event Studio, Query studio, Cognos Workspace, CWA, Cognos Connection, Administration and Active Reports).
• As a Cognos Architect/Developer I possess dynamic technical knowledge, excellent report designing and creating skills.
• As a Cognos Administrator, Proficient in installation, configuration, upgrades, fix - pack implementations and migrating Cognos content across versions and platforms including Windows, Linux Red Hat, AIX
• Implemented security using AD, LDAP and Cognos Access Manager in Cognos reports and Packages.
• Well versed with all Data Warehousing Concepts.
• Proficient in implementing best practices in Framework Manager and Cognos Transformer in developing relational and dimensional packages (relational and DMR).
• Proficient in developing, optimizing cubes and dynamic cubes in Cognos Transformer for OLAP reporting
• Proficient with SQL concepts and OLAP tools
• Expertise in designing interactive dashboards, having user friendly capabilities such as dashboard Prompts, navigation, drill-down, etc.
• Excellent documentation and communication skills, willingness to learn the latest cutting edge Technologies.
• Have experience in migration of Crystal Reports to Cognos Reports using IBM Cognos BI.
• Basic Knowledge on Cognos TM1 Architect(Cubes, Dimensions, Turbo Integrator), Loading Data into Cubes using Turbo Integrator, Creating TM1 Cubes, Dimensions and populating the Cubes.
• Good knowledge of SDLC and Software Testing Life cycle.
• Extensive experience in Manual testing using Black Box Testing Techniques.
• I can adapt to any diverse environments well, handle critical issues, and can accept challenging assignments with enthusiasm.
• Ability to work independently and as well as team environments.
• Strong interpersonal and excellent communication skills.
• Provide technical consulting for upper management, new programmers, and consultants regarding best practices in Business Intelligence.
• Extensive experience in databases like Oracle, IBM DB2,SQL Server, Teradata and CLOUD (AWS)

TECHNICAL SKILLS:

DWH-BI Tools: Cognos 11,10.2 & 8.4 (Framework Manager, PowerPlay Transformer, Cube Designer, Analysis Studio, PowerPlay Studio, Report Studio, CWA, Event Studio, Query Studio, Administration, Active Reports) Cognos Report net 1.1, Cognos TM1 Architect (Cubes, Dimensions, Turbo Integrator), Informatica Power Centre 9.5/7.1

Databases: DB2 9.5/9.1, ORACLE 9i/10g, SQL Server, Teradata and AWS (CLOUD)

Tools & Utilities: AQT, SQLDBX, SSH Secure File Transfer, TOAD, Putty, Edit Plus, Winscp, SQL LOADER, Control-M, IBM Clear Case, VERSIONONE and Aginity Workbench for Redshift

Operating Systems: UNIX, WINDOWS XP/2000/07/08 and AIX

Domain Skills: Telecom, Health Care, Retail, Banking and Airline

Programming Languages: SQL, PL/SQL, SQLPLUS, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, NC

Responsibilities:

• Created DSN on XML files (HTTP urls) by co-ordinating with Development team.
• Administered Cognos Connection by managing users & groups, object permissions, schedules, general administration tasks.
• Deployed Cognos content from Cognos 10.2 to Cognos10.2.2.
• Involved in Installing, Configuring, Customizing and Maintaining Cognos Products.
• Worked with the users for report enhancements and other data related issues.
• Developed DMR model for standard reports.
• Created Relational FM Model for users Adhoc reporting purpose to create their owned reports using Query Studio and CWA.
• Designing dashboard templates as per the requirement & dashboards content which includes complex tabular reports, bar charts, water fall charts, score cards, Bubble charts etc.
• Converted numerous excel based reports and dashboards to rich Cognos visualizations.
• Created groups, bins, hierarchies, sorts, sets and filters to create focused and effective visualizations.
• Performed query tuning and data modelling to improve performance efficiency.
• Monitored security and performance of Cognos 10.2.2 on regular basis.
• Developed dashboards using Cognos Workspace Advanced.
• Involved in testing and fixed the bugs raised during testing.

Environment: IBM COGNOS 10.2.2 (Framework Manager, Report Studio, Query Studio, Workspace), XML, Oracle, Informatica Power Centre 9.5 and UNIX

Confidential, OR

Senior Cognos Developer and Administrator

Responsibilities:

• Validated database views and tables of architectural frameworks.
• Created DSN on Amazon Redshift database using JDBC driver by co-ordinating with Administrator.
• Remodelled the existing Framework Model using DSN created on AWS CLOUD for reporting purposes.
• Performed query tuning and data modelling to improve performance efficiency.
• Monitored security and performance of Cognos 10.2.2 on regular basis.
• Validated dashboards using Cognos Workspace Advanced.
• Created FM Model for users Adhoc reporting purpose to create their owned reports using Query Studio and CWA.
• Validated Standard Reports, Master Detail Reports in Report Studio.
• Done testing of reports by writing specific SQL queries against Redshift database.
• Involved in testing and fixed the bugs raised during testing.

Environment: IBM COGNOS 10.2.2 (Framework Manager, Report Studio, Query Studio, Workspace Advanced), AWS and UNIX

Confidential, OR

Senior Cognos Developer

Responsibilities:

• Validated database views and tables of architectural frameworks.
• Developed Framework Model using BI Views with Macros and Parameter Maps for reporting purposes.
• Performed query tuning and data modelling to improve performance efficiency.
• Monitored security and performance of Cognos 10.2.2 on regular basis.
• Created dashboards using Cognos Workspace.
• Created Active Reports which provides an interactive analytics experience in a self-contained Cognos Business Intelligence application for browsing and exploring data offline.
• Created FM Model for users Adhoc reporting purpose to create their owned reports using Query Studio.
• Developing Standard Reports, Master Detail Reports using Report Studio.
• Done testing of reports by writing specific SQL queries
• Involved in testing and fixed the bugs raised during testing.

Environment: IBM COGNOS 10.2.2 (Framework Manager, Report Studio, Query Studio, Workspace), Teradata, SQL Server 2012 and Windows 2012

Confidential, WA

Senior Cognos Developer and Administrator

Responsibilities:

• Installed and configured Multi sever Cognos environment and maintained Cognos architectural solutions.
• Validated database views and tables of architectural frameworks.
• Developed user training materials for each framework.
• Provided technical support for migration process from Crystal reports to Cognos 10.2
• Developed Framework Model using stored procedure query subjects with Macros and Parameter Maps for reporting purposes.
• Performed query tuning and data modelling to improve performance efficiency.
• Monitored security and performance of Cognos 10 on regular basis.
• Created Form based reports, Barcode reports using Report studio.
• Created Active Reports which provides an interactive analytics experience in a self-contained Cognos Business Intelligence application for browsing and exploring data offline.
• Created alerts using Event studio.
• Implemented Archiving of scheduled reports into a File System.
• Developing Standard Reports, Master Detail Reports using Report Studio.
• Done POC on Dynamic Cubes.
• Done testing of reports by writing specific SQL queries
• Involved in testing and fixed the bugs raised during testing.
• Conduct & coordinate peer reviews for code and testing.
• Conduct weekly meetings to review module and project milestones.

Environment: IBM COGNOS 10.2 (Framework Manager, Report Studio, Event Studio), DB2, Oracle 11g and LINUX/UNIX

Confidential, NJ

Cognos Lead/Developer and Administrator

Responsibilities:

• Coordinated with Business analyst to convert business Requirements into technical specifications.
• Participated in Requirements understanding.
• Participated in admin activities like Cognos 10 server installation, security set up and scheduling activities.
• Developed DMR (Dimensional Modelling of Relational Data) and Relational Models using Framework manager.
• Created Package as a source for the Cubes and Reports development by using Framework Manager Metadata Modelling.
• Developed cubes using PowerPlay Transformer.
• Created reports using Report studio.
• Created analysis views using Analysis studio.
• Worked on the performance improvement of the reports by creating Views/Aggregate tables.
• Done Documentation for each Report/Cube.
• Developing Standard Reports, Charts, Drill through Reports, Master Detail Reports and Bursting Reports using Report Studio.
• Done testing of reports by writing specific SQL queries
• Worked on the performance improvement of the cubes by using hints at Modelling level.
• Provided solution for the build of High Data Volume (Exceeding 2GB size) cubes with PowerPlay Transformer TBP (Time-Based Partitioning) concept.
• Involved in testing and fixed the bugs raised during testing.
• Conduct & coordinate peer reviews for code and testing.
• Conduct weekly meetings to review module and project milestones.

Environment: IBM COGNOS 8.4 & 10.2 (Framework Manager, Transformer, Report Studio, Analysis Studio), SQL Server 2008 and Windows XP/2000/7

Confidential

Senior Cognos Developer

Responsibilities:

• Coordinate with business analysts for preparation of technical specification.
• Provide techniques to create a Package as a source for the Cubes/Reports development by using Framework Manager Metadata modelling tool from the source of IQDs.
• Created drill through reports to browse the information from summary to detail
• Developed Detail filters, Summary filters, and Group filters.
• Designed list report with Multi select & Reprompt cascading reports.
• Involved in developing Value prompt, Select & Search prompt as per requirements.
• Designed list templates with parameterized filters.
• Created reports with scorecard functionality using conditional formatting.
• Created Active Reports which made offline analytics easy to get truly portable business intelligence.
• Applied conditional blocks to conditionally hide objects.
• Designed a list report with the merging of data cells.
• Designed list templates with the Groups & Sections in eliminating the duplicates.
• Bursting of reports to different users depending on distribution requirements
• Created drill up and drill down reports
• Involved in testing and fixed the bugs raised during testing.
• Conduct & coordinate peer reviews for code and testing.
• Conduct weekly meetings to review module and project milestones.

Environment: IBM COGNOS 10.2 (Framework Manager, Transformer, Report Studio, Analysis Studio), Oracle 10g, IBM DB2, Teradata and Windows XP/2000.

Confidential

Senior Cognos Developer

Responsibilities:

• Maintaining a team by sharing knowledge.
• Resolved the issues at time.
• Review of Test Cases and Maintenance of Defect log.
• Performed unit testing for the developed code.
• Created Package as a source for the Cubes development by using Framework Manager Metadata modelling tool from the source of IQDs.
• Worked on the performance improvement of the cubes by using hints at Modelling level.
• Provided solution for the build of High Data Volume (Exceeding 2GB size) cubes with transformer TBP (Time-Based Partitioning) concept.
• As a Control-M Developer, created cyclic jobs on developed UNIX scripts for High Data Volume cubes building and publishing and scheduled Jobs.
• Followed Check in and Check out process regularly using IBM Clear Case.
• Participated in CR implementation.
• Responsible in management activities like Client Interaction, time sheet updating and defect tracking in the project and also involved in tracking of errors in application.

Environment: COGNOS 8.4 (Framework Manager, Transformer, Power Play Studio, Analysis Studio), Oracle 10g, Windows XP, Winscp, Putty, UNIX and Control-M

Confidential

Senior Cognos Developer

Responsibilities:

• Participated in Change Requests Implementation
• Done Design Documentation for each Report/Cube and Go-Live Document
• Developed cubes using Transformer 8.4
• Created Healthcare reports using Report studio.
• Created critical reports using Analysis studio.
• Done testing of reports by writing specific queries
• Prepared low level design mapping documents which comprises of:

Environment: COGNOS 8.4 (Framework Manager, Transformer, Report Studio & Analysis Studio), PL/SQL, SQL Server 2000, Oracle 10g, Windows XP/2000.

Confidential

Cognos Developer

Responsibilities:

• Coordinated with Business analyst to convert business Requirements into technical specifications
• Participated in Requirements understanding
• Prepared low level design mapping documents which comprises of:
• Developed DMR (Dimensional Modelling of Relational Data) and Relational Models using Framework manager.
• Developed cubes using Transformer 8.4.
• Created reports using Report studio.
• Created analysis views using Analysis studio.
• Worked on the performance improvement of the reports by creating Aggregate tables.
• Done Documentation for each Report/Cube.
• Done testing of reports by writing specific db2 queries.

Environment: COGNOS 8.4 (Framework Manager, Transformer, Report Studio & Analysis Studio), Data stage 8.1, db2 9.5, Windows XP, IBM AIX

Confidential

Business Associate

Responsibilities:

• Mapping business requirements into system functionality and preparing the design.
• Developing SQL/PLSQL procedures for extracting data from different transactional systems.
• Designing Analytics (cubes) by using COGNOS Power play Transformer
• Resolving Customer Raise requirement (CR) as per planned period.

Environment: COGNOS (Framework Manager, Report Net and Power play Transformer), Oracle 9i, Windows XP

Confidential

Software Engineer

Responsibilities:

• Involved in gathering, defining, and analysing requirements.
• Analyse functional specifications to help determine the design approach.
• Involved in Designing high level design documents in identifying the issues.
• Designed low level design documents to provide the report development summaries.
• Merging two list reports using Master-Detail relationship to provide summary detail information
• Involved in designing various list reports with the data formats.
• According to report requirements designed reports with group calculations.
• Created drill through reports to browse the information from summary to detail
• Developed Detail filters, Summary filters, and Group filters.
• Designed list report with Multi select & Reprompt cascading reports.
• Involved in developing Value prompt, Select & Search prompt as per requirements.
• Designed list templates with parameterized filters.
• Created reports with scorecard functionality using conditional formatting.
• Applied conditional blocks to conditionally hide objects.
• Designed a list report with the merging of data cells.
• Designed list templates with the Groups & Sections in eliminating the duplicates.
• Bursting of reports to different users depending on distribution requirements
• Created drill up and drill down reports.
• Designed the Charts for Comparative & Trend analysis.
• Involved in performing testing each report with unit & system testing.
• Developed Recurring schedules a/c to user requirements.
• Created a Job with the sequential batch processing.
• Developed headers & Footers in formatting the list reports.
• Built models, packages, published packages using Framework Manager.
• Verifying the correctness of report data with the data from the backend.

Environment: Cognos 8.0/ 8 .1 (Framework Manager, Cognos Connection, Query Studio, Report Studio) Oracle 9i, TOAD 7.6.0.11 and Windows 2000.

Confidential

Responsibilities:

• Involved in gathering, defining, and analysing requirements.
• Involved in interaction with end users, supervisors, and data architects for clarifying the report requirements, determining data sources and data requirements for building models.
• Developed complex and standard list reports, cross tab reports, charts, and drill through reports using Report Studio and Query Studio.
• Preparing highly precise business intelligence reports.
• Developed List, cross tab, Master-detail and chart which involved Multiple Prompts, Filters, multi-page.
• Created the calculations, conditions, prompts and cascading prompts.
• Performing grouping, sorting and filtering on the data.
• Scheduling and distributing reports through Scheduler in Cognos Connection
• Used the Governor option to set up the performance settings.
• Summarizing the reports created.
• Documentation of final reports and analysis of reports.
• Developed and published packages in Framework Manager.
• Prepared Test Cases for Reports

Environment: Cognos 8.0/ 8 .1 (Framework Manager, Cognos Connection, Query Studio, Report Studio) Oracle 9i, TOAD 7.6.0.11 and Windows 2000.

Confidential

Responsibilities:

• Developing reports from the Design Report Docs.
• Designed a list report with the merging of data cells.
• Designed list templates with the Groups & Sections in eliminating the duplicates.
• Built models, packages, published packages using Framework Manager.
• Developing Standard Templates, Reports, Charts, Drill Through Reports, Master Detail Reports and Bursting Reports Using Report Studio.
• Filtering data, adding prompts, conditional formatting.
• Worked for report testing & performance tuning of reports.
• Verifying the correctness of report data with the data from the backend.
• Preparing test cases and test documents.

Environment: Cognos Report net 1.1 (Frame work manager, Cognos Connection, Report Studio, Query Studio), Oracle 9i, TOAD 7.6.0.11., Windows 2000.