Professional Summary

• Acted as a liaison between business people who have a business problem and technology Efficient in creating Use Case Diagrams, Activity Diagrams and class diagrams, using Unified Modelling Language UML and Object-Oriented Analysis Design.
• Good written and oral communication ability in translating the business requirements into Business Requirement Documents BRD , Functional Requirement Documents FRD , Requirement traceability matrix and System Requirement Specification.
• Developed and Published Packages using Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Have Good Knowledge in Cognos TM1 Perspective, TM1 Contributor and TM1 Architect
• Currently supporting 12 Cognos TM1 Applications
• Expertise in Business Process Modelling, Process Improvement, Feasibility Analysis, Gathering-Elicitation Management of requirements, GAP Analysis, Design Development of Business Applications Project Management Skills.
• Sound skills in Cognos 10 BI Suite framework Manager, Cognos connection, Report Studio, Analysis Studio, Event Studio and Query Studio, Transformer, TM1 and good knowledge in reporting tools like Business objects, Hyperion, BIRT and Tableau
• Good understanding with Cognos architecture.
• Good experience in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS 8.2, 8.4 and 10.2
• Highly skilled IT Professional with over 9 years of experience working for major corporate clients, with an extensive and wide range of IT leadership, planning, programming knowledge, skills, abilities, and experience working as Applications Analyst, Systems Analyst, Project Manager, Solutions Architect.
• Created Multipage tabbed Portlet, Dashboard Reports in Cognos 8.4 and cognos 10.2
• Created Dashboards using Report Studio. Used functionalities like drill troughs, drill down.
• Knowledge in OLTP/OLAP system study, analysis, E-R modelling and developing database schemas like star schema and snowflake schema.
• Expert at creating Multi-dimensional Cubes for corporate data using Power play Transformer.
• Experience in Security Implementation in Cognos8, Report Net, on various levels using third-party security providers like LDAP, Active Directory, and Series 7.
• Developed data Mappings between source systems and warehouse components.
• In-depth Knowledge of SDLC using the Non-iterative methodologies like waterfall methodologies.
• Experience in conducting Joint Application Development JAD sessions and interviewing Subject Matter Experts SMEs , asking detailed functionality aspects of business process and carefully updating the information to the requirements in an easily understandable format.

• Prepared and executed functional Test Plans for User Acceptance Testing UAT to support business users.
• Energetic, self-driven and passionate with good relationship management, team management and communication skills.
• Extensive experience with cross country teams and working directly with offshore teams also.

Areas of Expertise

Skill Set

Professional Experience

Confidential

Cognos Developer/Project Lead

Responsibilities:

• Supporting 12 TM1 Applications using cognos TM1 Perspectives, TM1 contributor and TM1 Architect
• Supporting Cognos EP applications
• Worked extensively on creating Models using Framework Manager and publishing the packages on Cognos Connection for reporting purposes.
• Created DMR models using Framework Manager.
• Created Dashboards Reports in Report Studio using Dimensional Model DMR developed in Framework Manager
• Created filters and prompts with in the Model for improving performance of the Model.
• Troubleshoot the Error Codes in Case Statements and debug from DB
• Analyzed and develop requirements specification documents for reports as per client requirements and planned business Process
• Tested reports in Query Studio for upgrading it to Cognos10.2
• Performed Systems Administration activities for Cognos Planning and CognosBIand Cognos TM1applications
• Schedule reports with different selection scenarios to obtain the runtime and errors.
• Perform Reports Data Validation by comparing Cognos generated SQL using Toad
• Helping technical team to understand and to convert the business needs BRD into system requirements by coordinating with the business on a non-technical level, and with the System Analyst on technical level.
• Developing Test scripts to perform business flow testing in UAT environment.
• Coordinate with Data Modellers to review and correct the cardinalities from FactTables to DimensionTables.
• Prepared recommendation reports for calculation, and case statements to move into the framework manager from reports to improve Report performance.

Environment: Cognos10.2 and 8.4 Report Studio, Query Studio, Analysis Studio, Framework Manager,TM1,EP ,Spotfire,Informatica 9.1,Oracle 10g

Confidential

Sr. Cognos Consultant/Project Lead

Responsibilities:

• Built Strategic, Analytical and operational dashboards using Tableau and Xcelsius.
• Interacting with report users to gather the requirements.
• Involved in Design meetings and designing test cases and test plans
• Developed Business Requirements Document BRD ,Functional Specification Document FSD and Technical Specification Document TSD
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Involved in reviewing business requirements and analysing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Understood the business requirements document and Data model design document to come up with the Cognos model design.
• Performance tuning of the application

Environment: Java, Greenplum, Tableau

Confidential

Sr. Cognos Consultant/Project Lead

Responsibilities:

• Involved in installing and configuring Cognos 10.1,8.4BI and worked with modelling, Report Studio and Analysis Studio.
• Worked extensively on creating Models using Framework Manager and publishing the packages on Cognos Connection for reporting purposes.
• Created models using Framework Manager.
• Created filters and prompts with in the Model for improving performance of the Model.
• Deployed the packages and reports from Dev to QA and Prod.
• Used Cognos Connection to administer and scheduling reports to run at various intervals.
• Set security for individual reports in Cognos Connection.
• Used Analysis studio to drill down on cubes and perform business analysis.
• Created Lists, Groups and Cross-tab reports with Drill-through functionality using Analysis studio.
• Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
• Created standard and Ad hoc reports using Cognos Query Studio.
• Developed reports in Report Studio upon requests from business users
• Busted Reports to various Recipients within the organization using Report Studio.
• Created Query Prompts, Tree prompts, Query calculations, Conditions Filters.
• Developed Complex reports in Report Studio using Complex SQL queries
• Created list reports, cross tab reports, chart reports, Master detail reports, Drill through reports and reports with lot of conditional formatting using Report Studio.
• Involved in creating Test plans, Unit testing and UAT of the Report Studio reports.
• Created Power play Cubes using Power play Transformer generated Power play Reports.
• Used time state rollups, average rollups and external rollups in some Transformer Models.
• Created IQDS out of Cognos 8.4 Packages.
• Created dimension maps and multidimensional cubes using Impromptu Query Definition in Power Play Transformer.
• Created many cross-tab, ranked, graph and business mix reports by using Power Play 7.3.
• Created many Power Play web views cross-tab and chart according to the end users demand.
• Involved in scheduling Report Studio and Query Studio reports and sending reports via email to several business users.
• Involved in Designing DMR models with Relational Data and Relational models using Framework Manager and deployed packages to the Report Servers.
• Set up the Security at the package level, query subject level and the query item level.
• Used Governorsettingsfor improving performance of the Query.
• Performed Systems Administration activities for Cognos Planning and Cognos BI applications
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.

Environment: Cognos10.1 and 8.4 Report Studio, Query Studio, Analysis Studio, Framework Manager , Power Play, Transformer, Informatica 9.5, Oracle 10g

Confidential

COGNOS Developer

Responsibilities:

• Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement.
• Used COGNOS 10.1.1 to develop Framework Data modeling for inbound/outbound reports for logistic business requirements
• Devloped Daily, Weekly, Monthly Quarterly and yearly Timesheet reports
• Built Multi-Dimensional Models DMR with Relational Data using Framework Manager and Deployed Packages to the Report Servers.
• Generated report bursting using Cognos users CAMID
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Developed Framework Manager Models against Oracle Database.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Tested reports in analysis studio for upgrading it to cognos10.1
• Delivered advanced/ complex reporting solutions such as Dashboards and Standardized Reporting including the bursting of reports globally using Cognos 8.4.
• Developed reports in Analysis Studio from Power play Transformer Cube.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Designed models by mapping business needs using Power Play Transformer and created multi-dimensional cubes, cube groups, Power Play reports.
• Designed multidimensional models using Transformer. Decreased the Cube build times drastically and increased runtime performance.
• Customized Reports by writing complex custom SQL.
• Security Administration for setting up users, groups and roles and creating access permissions.
• Deliver advanced/ complex reporting solutions such as Dashboards, Scorecards and Standardized Reporting including the bursting of reports globally using Cognos 8.
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Involved in building the complex cubes and optimizing the cube creation
• Developed technical specification document for the offshore team.

Environment: Cognos8.4,10.1 Cognos Connection, Report Studio, Query Studio, Framework Manager ,

SQL Server 2005, Oracle 10g, Windows XP.

Confidential

Analyst Programmer

Responsibilities

• Understood the functional requirements provided by the Report users.
• Developed technical specification documents for the reports and get the approvals from the respective application owners.
• Developed the reports List, Cross tabs, Chart, Sub-reports, Drill-through reports and validate the report data with the backend data.
• Direct contact with users to discuss about the issue and LANDesk their PC's whenever required.
• Analysed the SAP BW Queries for data related issues.
• Analysed and resolved application BExanalyser and BW Web browser related issues.
• Handled the issues of the Client created in-house SAP application, PRISMA.
• Communicated with End-users/Onsite coordinators to understand the business requirements in the specification provided
• Involved in designing detail filters, summary filters, grouping and associations, calculations and develop the report with the client specific guidelines for report development.
• Developed List, Cross-tab, Chart, and Drill through reports or Sub reports as per the analysis made on the user requirements.
• Provided services to the new/existing users for any issues related to PRISMA.
• Daily PRISMA data load errors correction and reporting the daily status to Client.
• Involved in regular Client meetings.

Environment : BEx analyser, Windows XP, PRISMA tool, SAPBW,Cognos 8 Series, Windows XP, SQL Server, Visual Source Safe

Confidential

Cognos Developer

Responsibilities:

• The ticket may include the following types of activities like Analysis, Data Correction, and Development of new programs set up activities.
• Created Impromptu Web Reports and published them on the web server and later on upfront.
• Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.
• Provided security for Cubes of various User classes. Used Date Wizard to create time dimension in Transformer for creating cubes and Power Play reports.
• Created Multi-dimensional reports by implementing Multi-Dimensional Cubes using Power Play and Transformer.
• Created standard and Ad hoc reports using Cognos Impromptu Designed catalogs and defined User Classes, Security and Privileges.
• Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
• Created Standard Reports using Report Studio and Ad- Hoc Reports using Query Studio.
• Created Framework Manger Models and created and published packages into the portal.
• This project was enhancement of legacy application and production support
• Monitored production jobs
• Provided production support to the application users and maintenance
• Estimation of the enhancement.

Environment: Oracle 9i, Cognos 8.1, Cognos Impromptu Framework Manager, Cognos Connection, Query Studio, Report Studio ,Cognos Impromptu Admin/User, Power play Transformer, Power play for Web/Windows