SUMMARY:

Shruti is an accomplished Senior Cognos Developer having 7 years of experience in Software Design, Development, analysis, testing, Data Warehouse and Business Intelligence tools.

Skills Inventory

• Hands on experience in Cognos10/8 series Query Studio, Report Studio, Analysis Studio, Metric Studio Score carding , Framework Manager, Cognos Connection and Cognos Series 7.x Cognos Report net 1.1, Cognos Impromptu, Cognos Power Play Transformer, Cognos Power Play, Cognos Scheduler, Cognos Access Manager, Upfront .
• Very good knowledge on Installation Configuring the Cognos 10/8 tools in distributed environments on Windows/Unix.
• Experienced with Metadata modeling using Framework Manager, creating Projects, Models, Packages, Security and Parameter mapping techniques.
• Expertise with Framework Manager Modeling Physical Layer, Business Layer, Packages and Complex Report building with Report Studio.
• Hands on experience in Report building Crosstab, List, Dashboard reports using Report Studio and Analysis Studio.
• Experience developing complex reports using drill-through reports, prompts, dashboards, master-detail, burst-reports, dynamic filtering in Cognos.
• Experienced in building scorecard reports and dashboard reports using metric studio.
• Experience with Transformer models and cubes that were used in Power play analysis and also these cubes were used in various Analysis Studio reports.
• Good Experience with MDX Functions in Report Studio using Multi-dimensional Sources.
• Extensive experience with Cognos security LDAP, Active Directory, Access manager, object level security, and data security .
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8.X Environment.
• Sound Skills in developing SQL Scripts, PL/SQL Stored Procedures, Triggers, Functions and Packages.
• Involved in OLTP/OLAP system study, analysis and E-R modeling, developing database schemas including Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Deploying Models and reports from Staging to Production and administering users/groups/roles.
• Basic knowledge on ETL tools like Informatica Data Stage.
• Extensive experience on production support and troubleshoot/test issues with existing reports and cubes.
• Ability to translate business requirements into technical specifications and interact with end users to gather requirements for reporting.

Experience

Confidential

Sr.Cognos Developer

• Gathered Business Requirements to develop reports using IBM Cognos 10.2.1
• Analyzed, designed, built and tested reporting solutions based on business requirements.
• Created Cognos 8.4 Framework Manager models including relationships, filters, aggregations, rollup processing, calculations, organized folders, merged query subjects, aliases, shortcuts, database layer, business layer, presentation layer, and have setup data/object security and successfully published the packages.
• Created Star Schema Models in Frame work manager.
• Created different reports using Query Studio and Report Studio.
• Developed various reports like List reports, Cross Tab reports and Drill through Reports using Report studio.
• Developed several complex reports using cascaded prompts, Drill Through, master-detail relationships, Page sets, Joins, Unions using report studio.
• Worked extensively on conditional variables utilizing conditional explorer in report studio.
• Created, organized and formatted reports, folders and other contents on Cognos
• Created joins with queries in Report Studio to generate the required Report queries.
• Extensively worked on Dashboards using report studio including render variables, master-detail relationships, singletons, prompts, filters, Conditional variables, HTML items, layout component reference and formatting the objects within report design.
• Involved in upgrading existing reports in cognos 8.4 to cognos 10.1and 10.1 to 10.2.
• Installation of cognos 10.1 Framework manager and transformers.
• Worked on migrtation of 8.4 to 10.1 and 10.1 to 10.2 using Life Cycle Manager
• Worked on Installation and Configration of cognos 10 in distributed environments on windows.
• Applied Security and User Authentication to the various User Groups.

Environment: IBM Cognos 8.4/10.1/10.2.1, Cognos 10 Business Insight, Cognos Work space, Framework Manager, Report Studio, Query Studio, Cognos Connection, Oracle 11g, Java

Confidential

Cognos Developer

• Converted business requirements into technical specification and design for Reporting Database/data mart, and Adhoc/standard reporting using Cognos 8BI.
• Implementation of Cognos 8.4 developed and assisted with development of long-term strategy for implementation of Cognos 8 features/integration into Enterprise Risk Management Technology departments' custom portal / infrastructure.
• Developed and enhanced reports incorporating sophisticated HTML/JavaScript techniques for navigation/usability.
• Re-designed Framework Manager Model to leverage Best practices to ensure predictable queries.
• Established framework for gathering and analyzing business requirements designed a star-schema datamart to meet requirements developed Cognos solutions to deliver information trained client's staff.
• Built metadata models, modified, and published several packages using Framework Manager according to the business needs which can be used by Report Developers
• Performed detailed documentation of design, development, testing and deployment activities
• Developed Standard Templates, Dashboard Reports, Standard Reports, Charts, and Drill through Reports, using Report Studio and Query Studio in Cognos 8.3 and 8.4
• Used different Score carding models using Metric Studio based on the existing organizational structure which will help identify meaningful metrics and KPI's Key Performance Indicators
• Monitored ad-hoc analysis using SQL and performed dimensional analysis using MDX functions in Report Studio
• Calculated measures and dimension members using MDX, statistical formulas, and other user defined functions for complex reports using Report Studio
• Developed filters, calculations, prompts, conditions, and created various reports, using Report Studio for users
• Worked with Relational Databases - Oracle and MS SQL and involved in ETL team discussions for Data conversion process.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection
• Designed, developed, administered and deployed Cognos Cubes based on requirement.
• Made judgments and took decisions while addressing complex business issues with minimal supervision
• Developed work estimates for assigned tasks, assessed constraints and dependencies, escalate and resolve issues in a timely manner
• Created user groups in Cognos Connection from Active Directory groups
• Maintained source/version control for Cognos models, reports and involved in Documentation for user training
• Administered installation, configuration, and software upgrades of Cognos applications and monitor Cognos servers
• Maintained Development/QA/Production Environments, including new installations, upgrades
• Written handwritten SQL inorder to validate the data and data fixes in order to improve the performance.
• Involved in upgrading existing reports in cognos 8.4 to cognos 10.
• Provided technical support on day-to-day basis and troubleshoot installations

Environment: Cognos 10.1,Cognos 8.4 Suite Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio, Metric Designer, Metric Studio Event Studio , Power Play Transformer, DB2 8.1,Cognos Access Manger, Oracle 10g, Unix Shell scripting, Oracle E-Business Suite, Teradata, Shell scripting, UNIX, Tomcat/Apache.

Confidential

Cognos Developer

• Worked closely with client resources and business analysts to analyze and understand business requirements
• Customized data by adding Filters Calculations, Prompts, Summaries and Functions.
• Generated various reports List Reports, Grouped Reports, Cross-tab Reports, Chart Reports, and Drill -Through Reports.
• Added prompts and filters to modify existing reports to accommodate change in user requirements.
• Used Analysis Studio to create Analysis from Power Play Cubes
• Created complex multipage reports using multiple list reports and multiple queries to associate each of the list report
• Created simple to complex reports as well as Dashboard like reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, block, tables, master-detail, charts, various calculations and joins using tabular sets and tabular models
• Created dashboards crosstabs and charts to display the business details from different aspects and using different representations
• Created Prompts with static choices and conditional variables for rendering the multipage reports
• Used Filters for efficient retrieval of data and conditional variables for hiding summary totals for report
• Created professional reports in Report Studio and ad hoc reports in Query Studio
• Implemented Data Level Security, Object Level Security and Package Level Security
• Modified existing Cubes to comply with changes in the Requirements
• Performed scheduling and maintenance of reports using Cognos Connection and Microsoft SharePoint based support portals
• Involved in Installation of Cognos8.4 Frame Work Manager, Report Studio, Query Studio, Cognos Connection
• Performed Unit testing for all developed reports
• Involved in deployment process of all the reports and packages from Development to production server.

Environment: Cognos 8.4/8.3, Framework Manager, Connection, Report Studio, Query Studio, Analysis Studio, PowerPlay Transformer, MS Excel, SQL Server 2000, Adobe Acrobat, Windows 2000, Windows 2003 Server

Confidential

QA Analyst

Telstra Corporation ,Australia July 2007 August 2009

• Involved in Business Process Design and Technical Design reviews.
• Developed Test strategy and Test Plans to ensure that test cases reflect user needs for the Functional, User Interface, Usability and Security requirements.
• Worked Closely with Business Analysts and developers in writing and reviewing the Test Cases.
• Participated test case in review meetings and peer reviewed the other team members test scripts.
• Executed the test cases from Quality Center.
• Co-ordinate with configuration management team to get the patches applied to the environments in a planned manner.
• Performed Functional, System, Smoke and Regression testing of the application mapping to use cases.
• Testing Business object reports for data accuracy and integrity checks.
• Involved in Writing the Universe Document, Report Layout Document.
• Created several Ad-hoc reports in Business Objects XI R2 for data validation.
• Conducted backend testing by querying the database using SQL queries.
• Prepared test data for the test execution.
• Logged and tracked the defects using Mercury Quality Center and ensured all defects were resolved.
• Also conducted UAT testing and worked closely with the users to successfully complete testing within demanding schedules.

Environment: Windows XP professional, QTP 8.2, Mercury Quality Center, MS-Office, Oracle 9i, SQL, PL/SQL, TOAD,

Confidential

QA Analyst

Satyam Finance ,India October 2006 November 2007

• Participating in the design and requirements review meetings with the stakeholders conducted by development and business analysts.
• Analyzing the requirements and providing input for the Test Plan.
• Analyzing the software requirements documents and Business requirements documents and creating test scenarios using Decision Tables.
• Documenting the Test Cases and conducting Test Case review meetings with the Stakeholders, Developers, Business Analysts and Test Engineers.
• Performed Functional, Regression, Integration, Smoke Testing, Performance testing, Security roles and GUI Testing, Stylesheet Testing.
• Performed backend testing by executing queries using TOAD.
• Created and executed SQL test scripts to test certain functionality.
• Worked with CSV and XML files for Data Conversion utility to transfer data.
• Logged and tracked the defects and change requests using Rational Clear Quest.
• Created Test Evaluation Summary Reports and Requirements Traceability Matrix.

Environment: Windows XP professional, QTP, Mercury Test Director, Rational Clear Quest, MS-Office, Oracle 9i, SQL, PL/SQL, TOAD