SUMMARY

• Design & Development of models using Framework manager, both Relational and Dimensional as per COGNOS best practices.
• Creating Models & Packages from relational source and OLAP source (Power Cube, TM1 Cube) as well using Framework Manager.
• Creating Multi - dimensional Models and generating cubes using Power Play Transformer by taking database tables as source, for OLAP analysis comprising of dimensions, hierarchies, levels, categories, and measures
• Creating Cube Groups for a level in a Dimension for faster access of data
• Creating Views, Materialized Views, Stored Procedures and Functions based on the business requirements.
• Developed Standard reports & templates, Dashboard reports, invoices, Master Detail reports, Bursting reports and complex multi objects reports based on Relational Model, Dimensional Model and Cubes (Power Cubes, TM1 Cubes) in Report Studio for different business areas
• Extensively worked on different versions of Cognos - Cognos Report net, Cognos 8.2/8.4, Cognos 10, Cognos 11
• Extensively involved in multiple BI implementations using Cognos BI suite - from requirements gathering to Solution delivery
• Extensive Experience on Cognos Framework Manager to design Business Models -
• Dimensional Data modeling, Star Schema/snowflakes schema, Facts, Dimension tables
• Upgrading Report net reports to Cognos 8.2
• Upgrading reports from Cognos 8.2/8.3 to Cognos 10
• Migrating Business Objects reports to COGNOS
• Experienced with Multiple Relational Databases including Oracle and Teradata.
• Cognos Administration - Datasource connections, report/folder/package access management for users/groups, intra environment code deployments, reports / jobs scheduling, security management Framework Manager (data level, object level and package level security)
• POC for Migrating Cognos 7 reports to COGNOS 8.2
• Experience in doing Cognos POC/Pilot projects and demonstrated to the business to show the functionality - Dashboard reporting, analytical reporting and self service reporting capabilities
• Working with business teams / user groups to identify, gather, analyze requirements and develop business Intelligence functional requirements.
• Hands-on experience translating business requirements into technical specifications and effectively managing the execution of those specifications
• Preparing estimates, Design documents, Understanding documents and Mapping Documents
• Defining/documenting requirements, standards and guidelines for Cognos modeling & reporting
• Coordinate, administer and manage the Cognos reporting environments and analyze, troubleshoot and resolve development and support issues of moderate/high complexity of risk and data retrieval and performance tuning
• Analysis, design, development, implementation, up gradation, support and maintenance of IBM Cognos BI applications
• Ensure end to end delivery from requirements gathering to Solution delivery
• Being Point of contact for all technical / functional escalations
• Direct interaction with end customers and associated partner teams to ensure smooth business operations
• Worked for Auto-Finance, Banking & Pharmaceutical Clients
• Leading the team and regularly update the team with objectives of the project and expectations from individuals
• Trained Business users on Cognos Business Insight and Business Insight advanced.
• Enhancing the technical skill levels of all team members by imparting direct technical trainings
• 10+ years of experience in analysis, design, development and maintenance of Business Intelligence applications using enterprise Data warehouse tool COGNOS.
• Involved in various phases of the projects during this tenure that includes - working with business groups in identifying requirements, analyzing the requirements, Design, Development, Testing and Support
• Excellent experience with Cognos BI suite (Cognos 11,10.X, Cognos 8.X, Cognos Reportnet 1.1, Cognos Powerplay Transformer)
• Experience working as SQL developer.
• Possess solid analytical, interpersonal, communication and organizational skills combined with the ability to work in a fast paced environment as an individual and as well as a team member

TECHNICAL SKILLS

BI Tools: COGNOS 8.2, 8.4 (Framework Manager, Report Studio, Analysis Studio, Power play Transformer), ReportNet1.1

ETL Tools: Informatica

Database & Tools: Oracle 8i/9i/10g/11g, SQL Server, TOAD and SQL Developer

Operating Systems: Windows XP/2000/NT, UNIX

Programming Languages: C, HTML, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, NY

Cognos Consultant

Responsibilities:

• Working with Business groups to identify, analyze functional requirements and develop the Design documents for Cognos reports
• Collaborate with the upstream project teams to understand the data coming from upstream source systems and perform the impact analysis of the Confidential system.
• Perform data analysis and, collaborate with Data modeler and Architect’s to identify the Dimensions and Fact tables.
• Worked closely with Business groups to perform the domain data mapping to convert the Hospira Domain data to equivalent Confidential data.
• Created Framework Model Packages for different Business groups and published it for reporting needs
• Created Framework Model Packages for the self-service reporting needs of business
• Design and Developed report mockups and templates based on the Confidential guide lines and demonstrated to Business teams.
• Created reports to capture the ETL rejected data, perform the data analysis and propose the solution to reprocess the data after discussing with Business
• Design and developed Cognos reports based on the requirements.
• Enhanced existing Cognos reports to accommodate the new Hospira data as well.
• Created database objects like views, materialized views, functions to support ETL activities and reporting needs
• Performed data analysis of source system, and created ETL source to target mapping sheets for ETL activities
• Created Views to perform the reconciliation between source and target systems, worked closely with Business groups to resolve the discrepancies between source and target systems.
• Worked closely with Business users during UAT
• Address all the SIT and UAT issues
• Responsible in conducting sessions with Business groups to provide walkthrough of the reports functionality

Confidential

Cognos Consultant

Responsibilities:

• Working with Business Analysts and Business groups to identify, gather, analyze requirements and develop the Design documents for reports
• Created Framework Model and packages based on the requirements.
• Created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and publish the Package for reporting
• Design and Developed report mockups and templates based on the Confidential guide lines and demonstrated to GP Business teams.
• Design and Developed Complex Tabbed reports, List reports, Cross Tab reports based on requirements for VA team.
• Created reports by writing the Custom SQL at report level
• Applied Conditional rendering on the report objects to achieve the requirement.
• Created reports based on adhoc request from business to perform the operations
• Created database Views that are required for the reporting needs.
• Prepared test scripts and executed them effectively as part of testing.
• Coordinated with DB team and Cognos Support team to promote code to the higher environment.

Confidential, Jersey City-NJ

Responsibilities:

• Proposed, Designed and Developed a Centralized Strategic reporting solution that would suffice the reporting needs of the Business groups of GCRM
• Created POC that has got the Analytical, Dashboard reporting, Interactive and Self Service reporting Capabilities of Cognos and, demonstrated the same to the business groups
• Worked closely with business groups to indentify and gather requirements.
• Designed and Developed Framework Models for live reporting and analytical reporting needs.
• Created mockup reports and demonstrated to the business to get the look & feel of the reports.
• Designed and Developed Dashboards for different applications of GCRM to get an overview of the data at glance.
• Designed and Developed the Complex reports which has got the “Google Search” functionality using JavaScript’s.
• Created DB Views, Stored Procedures and Functions that are required for reporting.
• Designed and Developed Canned reports for Live reporting needs.
• Demonstrated the reports that are developed to the Business groups.

Confidential, Jersey City-NJ

Senior Cognos Developer

Responsibilities:

• Working with Business Analysts and Business groups to identify, gather, analyze requirements and develop the specification documents for reports
• As part of Report Rationalization, identify the existing reports & attributes, remove the duplicate attributes and provide the best solution which will help the users for better analysis
• Prepared Standard guidelines document for reporting, Framework Manager and reporting best practices documents & Report requirements template document.
• Interacting with Business groups on a regular basis and get all the Business queries clarified
• Responsible in clarifying all the Business & Technical queries of the team
• Ensure end to end delivery from requirements gathering to Solution delivery
• Created Framework Model and packages based on the requirements.
• Created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and publish the Package for reporting.
• Design and Developed report Mockups and templates based on the guide lines.
• Design and Develop reports like List, Cross tab, Charts based on the requirements and as per the Cognos best practice
• Review the code developed by the team and suggest the changes where ever required
• Ensure team is developing the reports as per the best practice
• Writing the SQL queries as part of report testing, verify the SQL queries written by the team and make the changes if required
• Responsible in conducting sessions with Business groups to provide walkthrough of the report functionality.

Confidential

Senior Cognos Developer

Responsibilities:

• Worked with business users to identify, gather, analyze requirements and develop business Intelligence functional requirements
• Prepared estimates, technical specifications, design documents and mockup reports based on the requirements.
• Designed and developed Canned reports, adhoc reports and Master detail reports
• Created burst reports as per the business needs.
• Effectively created Active dashboard
• Demonstrated Canned reports and Active dashboard to the users and got the sign off
• Reviewed development work done by the team and suggest improvements where ever required

Confidential

Senior Developer

Responsibilities:

• Participated in work shops, interacted Business users directly for requirements gathering.
• Provided estimates by analyzing the requirements for new Dashboards.
• Prepared technical specifications and design documents.
• Created mockups and presented to the endusers.
• Created Framework Package by taking TM1 cube as source.
• Developed Standard reports for different business units based on the requirements.
• Developed complex Dashboards by taking TM1 cube as source
• Enhanced existing reports in Production and provided fixes for the existing Production reports
• Worked closely with business users for UAT.

Confidential, Detroit-MI

Senior Developer

Responsibilities:

• Effectively prioritize the tasks & tickets and assigning them to the team members.
• Responsible for weekly status update to the Customer and forecast analysis for the remianing CSR/Incidents /service tickets.
• Development, Testing, and Maintenance of the Reports
• Creating Datasource connections,user groups,adding users to the existing groups, providing report/package/folder/Datasource connection access to the user groups
• Responsible for the deployment of reports,packages and folders.
• Responsible in providing support to hosting team for the patch activites on Windows App. Server
• Responsible for all kind of Goldrush Cognos application support activites.
• Responsible in montoring the schedules and enviornment.
• Responsible in fixing all kind’s of report issues.
• Responsible in updating Run book and Play book.
• Responsible in closing all the Incidents / service tickets with in SLA.
• Responsible in raising the Change request for the new releases and getting the approvals from the Client operations team.
• Responsible in educating the team to follow the defined sustain process for all the sustain activites.

Confidential, Detroit-MI

Senior Developer

Responsibilities:

• Getting a better understanding of the business and existing processes to set up a team for reports development
• Had several discussions with the end users to understand the business needs and obtain detail requirements.
• Prepared estimates, technical specifications, Understanding documents and mockup reports based on the requirements.
• Effectively prioritize the tasks and assigning them to the team members in a high-pressure business environment.
• Responsible for weekly status update to the Customer and forecast analysis for future project tasks.
• Created Framework Model and packages as per Cognos best practice from multiple datasources.
• Implemented Object level and data level security in Framework Manager to restrict the business data access to specific users/user groups.
• Responsible for the delivery of solution-oriented complex reports using Report Studio.
• Reviewing the code/reports developed by the team and guide them to follow the best practice.
• Developed Various on demand invoices and letters for Confidential .
• Enhancements of existing Framework Model and reports as per the business requirement.
• Developed several complex Dashboards which will capture Total Portolio,New Volume,Delinquencies, Loses, Recoveries and Payments.
• Optimized the performance of reports by modifying queries,query properties, report design and layout
• Created Multi-dimensional Models and generating cubes using Power Play Transformer by taking IQD as source, for OLAP analysis comprising of dimensions, hierarchies, levels, categories, and measures
• Migrated Business objects reporting application to Cognos 8.2
• Created Framework Model by taking BO Universe as source.
• Suggested and Integrated multiple BO universes in one Framework Model which reduces the opeartional and maintenance cost
• Upgraded Report net1.1 reports to Cognos 8.2
• Created Database Stored Procedures, Functions and Views as per the requirements.
• Created Views, Materialized Views, Stored Procedures and Functions based on the requirements.
• Wrote complex SQL queries to validate the Cognos reports data.
• Frequent interaction and co-ordination with other teams like DBA team, ETL team and testing team
• Created Views, Functions and Stored Procedures in Oracle which are required for Cube build and report writing.
• Upgrading reports/packages from Cognos 8.2 to Cognos10.1

Confidential

Developer

Responsibilities:

• Co-ordinate with the Customer to understand the business needs and obtain the detailed requirements
• Worked with users to get clarification for all the business queries.
• Prepared technical specifications,design documents and mockup reports.
• Developed Framework Model by importing tables from database and defining the relationships between the tables.
• Creating and publishing packages as per the business requirement.
• Designed and Developed different types of reports like List reports, Crosstab reports,Chart reports, Drill through reports and Master Detail reports in Report studio.
• Developed interactive dashboards for End Users.
• Loaded the sample data into Development database using SQL Developer.
• Created deployment files and performed deployments to SIT.
• Coordinating with ETL team to validate the business rules and to address the defects during SIT
• Worked with tester and end users during SIT and UAT to address defects.
• Provided warranty support post production.

Confidential

Developer

Responsibilities:

• Involved in requirements gathering and translating them into technical specifications and Design documents for all the CSR’s.
• Designed and Developed Framework Model for different Regions and different departments per business needs.
• Created calculated columns, filters, organized folders in Framework Manager Model to suit the reporting needs.
• Enhanced existing Framework Models by adding more tables, establishing joins and creating new calculated items as per the reporting needs.
• Created differe
• nt types of reports like List, Cross tab and Charts using Report Studio
• Created reports using objects like Union Operators, Joins,conditional layouts and layout component reference in Report Studio
• Created reports with different types of prompts like Textbox,Value,Date,Select&Search prompts and cascasing prompts
• Extensively used cascading prompts, drill-through, summaries, master detail reports, conditional formats, grouping and association features to generate efficient Crosstab and List reports.
• Wrote complex sql’s to perform unit testing. Created DB Views and Functions that are required for reporting.

Confidential, Dallas-TX

Developer

Responsibilities:

• Worked as SQL developer, created Views, Materialized Views etc
• Created Stored Procedures and Functions that are required for the Reporting needs.
• Involved in the Development, Testing, and Post Production Maintenance of the Reports.
• Involved in creating Metadata models and Packages using Framework Manager.
• Created IQD’s Using Framework Manager to build the cubes.
• Developing the reports as per the user requirement.
• Extensively used cascading prompts, conditional variables,drill-through, summaries, master detail reports, conditional formats, Conditonal blocks, render variables,grouping and association features to generate efficient Crosstab and List reports as per the requirement.
• Designed and Develped multidimensional models using Powerplay Transformer to generate cubes for multidimensional analysis.
• Modified existing cubes by adding new Dimensions,Levels, measures and categories, enabled alternate Drill-down path as per the requirement.
• Extensively worked on fixing the bugs in the existing reports