Career Objective

To be associated with a progressive organization that gives me scope to apply my skills and enhance my knowledge and to work dynamically towards the growth of the organization.

Summary:

• Overall 6.7 Years of Experience in analysis, design, development, deployment and maintenance of software product life cycle of various applications.
• 5.5 Years of Experience in Development of various business applications using Cognos8x/10x
• More than 1 year of experience in Production support of Cognos applications
• Cognos 10 BI Author and Cognos 10 BI Metadata Model Developer Certified
• Completed Cognos 8.4 Admin training by IBM.
• Successfully performing role of Cognos Production Support onsite lead wherein supporting 250 live applications
• Excellent knowledge and hands on working experience with Cognos tools: Cognos Series 8x,10x BI Report Studio, Query Studio , Framework Manager, CUA , Power play Transformer.
• Expertise in developing ad-hoc reports using Query Studio, creating complex analysis quickly by using Analysis Studio, analyzing metrics and other performance measures within an organization by using Metric Studio.
• Experience in designing interactive Dashboards with user friendly capabilities such as Prompts, Navigation and drill-down using Cognos Report Studio
• Proficient in Meta data modeling with Framework Manager and experienced in layered approach such as Physical Layer, Business Layer and Presentation Layer.
• Also worked with data level, Object level and package level security in Framework Manager.
• Sound knowledge of designing and developing OLAP Cubes using Transformer.
• Worked on Security Access to client using LDAP .
• Trained End Users in using the Ad-Hoc components like Business Insight Advanced.
• Prepared User Guides/Workshops for the practice.
• Good exposure in Relational Databases Oracle, MS SQL server, DB2 and MS Access for modeling and for supporting analytical and reporting needs of Corporate Business needs
• Deploying Models and reports from Staging to Production and administering users/groups/roles.
• Excellent communication and interpersonal skills. Excellent Team coordinating Skills with the Development Team and Deliverable dates.
• Excellent team player at all levels with ability to perform independently.
• Proficient at developing and implementing training programs to enhance the efficiency, competency and motivation levels of the employees in line with organizational objectives.
• A keen communicator with problem solving analytical abilities.

Projects Handled

Confidential

Role : AMS Cognos Lead Onsite

Software : Cognos8.4

Database : Oracle 9i/10g

Responsibilities:

• Perform Service Request management, Incident Management and Problem Management
• Leading a team of 12 members from onsite
• Providing production application support for more than 250 Cognos Applications from onsite single handedly
• Actively involved in product upgrade activities Cognos 10.2.1 Upgrade
• Involved in setting up Groups/Roles to secure the models and packages using Access Manager.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Deployed Packages, Folders and Content Store from Test to Development and Production environments.
• Maintain Authorized User Documentation and training of Customer Help Desk support.
• Provide Authorized User support for routine queries i.e. how to's not addressed by the Help Desk, and other activities as necessary to troubleshoot and resolve Incidents and Problems.
• Perform error correction and preventative maintenance
• Perform production control, scheduling and operations support
• Develop necessary modifications and updates to support compliance with legal and regulatory requirements or other industry changes
• Conform to Customer application development standards and recommend changes, where appropriate, to further optimize or promote maturity within the Applications.
• Develop, modify and/or enhance Customer quality assurance processes to ensure quality and reliability of modifications or Enhancements injected into the portfolio.
• Develop a mechanism for measuring productivity and report regularly to Customer this should include recommendations for Enhancements to optimize the Application footprint and impact on Infrastructure resources
• Perform a semi-annual test of disaster recovery plan in conjunction with Customer's overall disaster recovery IT plans.
• Collaborate with Customer team as required for resolution of Problems and Incidents
• Gather minor enhancement requirements from users and provide estimates for the same
• Prepare estimates for the application support and share it with customer

Confidential

Role : Senior Cognos Developer

Software : Cognos10x , Informatica 9.0

Database : Oracle 9i/10g

Responsibilities:

• Interacted with business analyst and SME team to gather reporting requirements and designed functional and technical reporting requirements documentation.
• Complete analysis and development of Reports as per client requirement.
• Providing the solution approach for multiple country implementation
• Building data model that will meet both Ad-hoc reports and standard reporting needs for business
• Involved in designing / creating the Cognos Cube/FM Model for reporting
• Designed Reports using most of the Report studio features Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up , Prompt pages and Conditional Variables, calculations, child reports, HTML items.
• Developed and Published Packages in Framework Manager, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and assigned security rules to them in Framework Manager.
• Bursting the reports in various formats, such as html, PDF, excel and sending via e-mail based on the sales area and different levels of administration.
• Implemented DMR model using Framework Manager.
• Scheduled Reports and Power Play Cubes to run on Daily, Weekly and Monthly basis.
• Involved in organizing and prioritizing the day to day work items for the team.
• Involved in training users about Business Insight interface where they can easily access all kinds of data in one work area.
• Managing and responsible for all deliverables from offshore
• Involving in quality check activities for all deliverables
• Regular KT sessions to new joiners.
• Undergone Informatica 9 learner trainings
• Providing the requirements to the ETL team for implementation
• Performing the role of C2 champion
• Handling a team of 6 from offshore

Confidential

Role : Senior Cognos Developer

Software : Cognos10x

Database : Oracle 9i/10g

Responsibilities:

• Understand the requirements given by the client. Preparing a questionnaire to get the clarification from the client regarding the requirements.
• Analyzing the underlying database tables to create perfect model, depicting correct relationships among the query subjects.
• Creating data model in Cognos Framework Manager 8.4/10.
• Worked on Implementing Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Worked on Power Play transformer model and cube design
• Developed Master Detail Reports, Drill through and custom prompting reports, and scheduled reports for efficient resource utilization.
• Worked on Performance Tuning and troubleshooting of Cognos reports
• Developed complex Dashboard reports with multiple tabs and Drill through to the multiple reports.
• Extensively used dashboards with prompts, filters, conditional formatting, drill through and master detail relationships for the Management.
• Participated in Technical Designing of Reports, developing Framework models
• Developed list, cross-tab and chart reports using multiple queries in a single report and conditional formatting to highlight the business needs.
• Extensively used filters, calculations, prompts, conditions and developed SimpleList, Cross Tab, and Charts reports using Report Studio.
• Worked on Query Optimization, developing Query Prompts, creating Prompt pages and Conditional variables
• Set up models containing query subjects, query items, and namespaces from scratch as well as from imported metadata.
• Extensively implemented complex reporting functionalities using Conditional formatting, Conditional blocks using multiple variables and parameters.
• Created multiple complex reports by using complex queries, detail and summary filters.
• Created and modified various List Reports, Grouped Reports, Cross Tab Reports and Drill-Through Reports.
• Developed Multidimensional Models Cubes using Cognos PowerPlay Transformer.
• Applied Cascading Prompts functionality in runtime for narrowing the final results for better understanding of the requirement.
• Created Query calculations, Layout calculations, Filters and Prompts for usage in various reports. Preparation of functional and technical design document.
• Development of 25 Cognos reports which ranged from Medium to Complex category.
• Performance tuning of the reports for faster execution.
• Package import/export using Cognos administration
• Providing support during SIT/UAT
• Implementation of Change Requests requested on client side tracking system.
• Creation of Powerplay Cube for reporting.
• Development of ETL process using the in house tool ESDR and Oracle for data loading process.
• Working as a DP coordinator for the project to meet quality needs and ensure all the team-mates are following quality process.
• Preparing Start up Audit documents for MCC CI and Facing Monthly Quality Audits.
• Preparing WSR and MSR

Confidential

Role : Cognos Test Lead

Software : Cognos8.4

Database : Oracle 9i/10g

Responsibilities:

• Handling a team of 5 from offshore.
• Understanding of the BRD for the project.
• Understanding DRD for the reports.
• Writing Test cases for SIT for reports based on DRD docs.
• Implementing and executing test cases using iTko Lisa tool QC.
• Analyzing the results.
• Defects Management.

Confidential

Role : Analyst Programmer Cognos Developer

Software : Cognos8, Power play

Database : Oracle 9i

Responsibilities:

• Incorporate new features of Cognos 8.3 while rewriting reports on new platform.
• Document each and every component of new or migrated reports.
• Involved in creating Functional, Technical, Meta Data and Test documents.
• Rewriting reports as per existing 7 series applications and utilize the Cognos 8.3 features to enhance the report functionality.
• Involved in crafting complex calculations, Dashboards.
• Created Drill through reports as part of the project requirements.
• Closely work with project team to follow the process reviews and quality standards.
• Developing reports in both Report Studio and Analysis Studio.
• Developing reports using different conditional variables.
• Developing reports with different kinds of prompts and filters add interactivity for users.
• Created drill up/down reports to go up to end of the hierarchies.
• Preparing test cases and perform unit testing on reports.
• Developing reports by using dimensional Functions

Confidential

Role : Analyst Programmer

Software : Cognos8

Database : DB2

Responsibilities:

• Creation of framework manager models using normal joins.
• Creation of different types of data sources connection for DB2 and SQL server in FWM.
• Applying filters, calculations in framework manager.
• Creation and publishing packages in framework manager.
• Interacting with Business Users for gathering Business Requirements to develop the reports.
• Creation of FS Functional Specification and TS Technical Specification for reports based on business specification.
• Created List, Crosstab, Chart reports using Cognos8 Report Studio.
• Created Pages in the reports to display depends on Prompt values.
• Created Drill through reports.
• Developed Prompt pages and used Conditional formatting.
• Created Prompts, calculations, Conditions Filters.
• Testing of reports developed Data level testing .
• Creating UTP for the Developed reports.
• Created adhoc reports using Query Studio.

Confidential

Role : Analyst Programmer Cognos Developer

Software : SSAS SQL Server Analysis Studio BIDS

Database : SQL Server

Responsibilities:

• Responsible for creation of Database schema with Facts and Dimensions tables .
• Creating a Data source and Data source view in SSAS BIDS .
• Creating and deploying a Cube using SSAS.
• Analyzing the cube with help of Cube browser.
• Adding calculations using MDX.
• Creating KPI's to analyze the business growth.
• Creating actions for drill through reports and URL reports.
• Using different perspectives for different users.
• Adding translations to use different languages in cube browser.

Confidential

Role : Analyst Programmer Cognos Developer

Software : Cognos 8, Impromptu, Sql Navigator

Database : Oracle 9i.

Responsibilities:

• Involved in Analyzing Business requirements and Interacting with Business Users for gathering Business Requirements to develop the reports.
• Designed, Developed and Implemented an Enterprise Wide Reporting system using Cognos 8.2.
• Creating and Publishing packages to Cognos 8 Environment.
• Created several List, Crosstab, Chart, Repeater reports using Cognos8 Report Studio.
• Created Pages in the reports to display depends on Prompt values.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
• Developed Prompt pages and used Conditional formatting.
• Created Prompts, calculations, Conditions Filters.
• Developed Dash Board Reports on Cognos 8 report Studio.
• Created adhoc reports using Query Studio.
• Developed reports using impromptu.
• Testing of reports developed Data level testing .
• Creating UTP for the Developed reports.
• Creation Prompt Page Templates for Different kinds of reports.
• Java scripting for Prompt pages. Handling Tabbing Functionalities and implementing constraints for selection based on business need .