SUMMARY

• 7+ years of IT experience in varied domains like health care, finance, insurance, logistics.
• Experience in various Cognos suites Cognos 10 (framework Manager, Data Manager, Cognos connection, Cognos Administration, Cognos Business Insights and Dashboard, Report Studio, Analysis Studio, Event Studio, Query Studio and Metric Studio); Cognos 8.x (framework Manager, Data Manager, Cognos connection, Cognos Administration, Report Studio, Analysis Studio, Event Studio, Query Studio and Metric Studio); Report Net 1.1, Cognos Impromptu and Analysis Tools such as Cognos Transformer & Power Play, Access Manager).
• Installed and configured IBM Cognos 8.x & 10.1 BI in single server and multi server environment.
• Migrated reports, metadata, packages & models from IBM Cognos 8.4 to 10.1
• Prior involvement in end - to-end BI Life Cycle Development Process - Requirement Analysis, Design, Feasibility Study, FRD Preparation, Development, Maintenance, Testing and Production Support.
• Extensive experience in structuring metadata, creating cardinalities between query subjects, developing models and publishing packages using Framework Manager.
• Expertise in designing and developing DMR and Relational models using star and snowflake schemas.
• Created Ad-Hoc reports using Query studio and Trained power users to use Query Studio for Ad-Hoc reporting.
• Developed complex reports using List, Crosstabs, Chart, Map and Repeaters using Cognos Report Studio.
• Experience developing complex reports using drill-through, prompts, master-detail, burst options, dynamic filtering, etc., in Cognos.
• Extensively worked on Conditional Formatting of reports using conditional styles, Render variables and Conditional variables.
• Worked on Analysis Studio to develop multi-dimensional reporting.
• Extensive experience in creating Scorecards in Metrics Studio for performance evaluation.
• Automated reports generation according to a schedule or by trigger using Cognos Scheduler and OS scheduler.
• Proficient in Performance Optimization of reports and Multidimensional Cubes.
• Developed Complex dashboard reports for various reporting requirements.
• Strong understanding of relational database design concepts and in depth knowledge of OLTP, OLAP and BI Verticals in analysis, design, testing, development and implementation of client/server applications.
• ETL experience using Cognos Data Manager & Informatica PoweCenter.
• Ability to collaborate on a team with infrastructure, data warehouse, and business analysis resources, and clearly communicate solutions to both technical and non-technical team members.
• Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess good communication skills.
• Very good Experience with Strong problem solving skills, ability to develop strategies for clients, and provide detailed documents to clients.
• Ability to work effectively in a team as well as individually. Ability to write and maintain technical documentation to describe Reports development, logic, testing, changes, and corrections.

TECHNICAL SKILLS

Business Intelligence Tools: Report Studio, Analysis Studio, Event Studio, Query Studio and Metric, Framework Manager, Data Manager, Power Play, Cognos connection, Cognos Administration, Transformer, Cognos Business Insights and Dashboard Reports, Studio IBM Cognos Series 10, Series 8, Series 7 (Impromptu, ReportNet)

ETL Tools: Informatica, Data Manager

Scripting & Programming: SQL, XML, Unix Shell scripting, Windows Batch scripting, Java Script

Databases: Oracle 11g, Oracle 10g, Oracle 9i, SQL Server 2005/2008

Database Management: SQL*Plus, Oracle SQL Developer, Quest Toad

Business Tools: MS Office Suite - Word, Excel, PowerPoint, Project, Visio

Quality Assurance: QTP, Selenium IDE

Project Management Methodologies & Tools: Agile Scrum, Waterfall, ‘V’, IBM Rational Clear Case, Version One, Team Track, HP Quality Center, CVS, Remedy

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Sr. Cognos Reports Analyst / Developer

Responsibilities:

• Migrated reports, metadata and packages from IBM Cognos 8.4 to 10.1
• Designed, enhanced, and maintained Framework Manager models to support business requirements
• Worked with business users to design and develop Cognos BI reports using Report Studio with data drill down and slice and dice options
• Developed List Reports, Cross tab Reports, charts and Drill-Through Reports
• Designed and developed complex reports including sub-reports, graphical reports, and well-formatted reports according user requirements
• Designed and developed dashboards
• Designed, implemented, and administered Cognos Securities and BI Portal
• Unit tested reports for Quality Assurance in DEV environment & helped with User Acceptance Testing
• Provided technical support using Team Track defect tracking tool
• Trained and supported Cognos end users in creating ad-hoc reports using Query Studio
• Loaded data into Data Warehouse using Cognos Data Manager ETL tool

Environment: Cognos 8.4, Cognos 10.1 Server, Report Studio, Query Studio, Analysis Studio, Data Manager, Windows Server 2008 R2, Oracle 11g, Quest Toad for Oracle v11.0, IIS Server, Team Track.

Confidential, Jersey City, NJ

Cognos Developer

Responsibilities:

• Interacted with the business users, gathered requirements and prepared technical specifications.
• Designed Framework Manager Models and defined cardinality relationships between query subjects.
• Created different Packages for different business areas & published the Packages to Report studio users.
• Developed List Reports, Cross tab Reports and Drill-Through Reports.
• Migrated reporting changes from DEV to Production environments.
• Extensive experience in the use of conditional formatting during report development in Report Studio.
• Initiated training for the business users to do ad-hoc reporting using Analysis Studio.
• Involved in building Definition Files, Fact Builds and Dimension Builds for loading data into Data Warehouse tables using Cognos Data Manager.
• Implemented data profiling and quality check in Data Manager.
• Worked on Maestro Scheduler to run the Data Manager Jobs, Reports and File Transfers across Development and Production Environments. Created Batch Files to execute the jobs.
• Provided customer support using Remedy Ticket handling tool.
• Designed and Prepared a Training Manual for the business users.

Environment: IBM Cognos 8.4 Suit, PowerPlay Transformer 7.4, Frame Work Manager, Report Studio, Analysis Studio, Windows Server 2003 R2, IBM - Tivoli-8.3 (Maestro Scheduler), Oracle11g, Oracle SQL Developer 1.5.4, Hyperion Essbase Client, IIS Server.

Confidential, Des Moines, IA

Cognos Developer

Responsibilities:

• Gathered Business Process Requirements from business users, for the reports to be developed.
• Working with data modelers and provided them with queries required to develop the facts and dimensions in the data model
• Tested the Metadata model and relationships in Framework Manager
• Created various reports like lists, cross tabs, charts, complex reports with conditional block, static choices in prompt etc
• Used Query Studio for developing Ad hoc reports and Report Studio for developing Dash Boards.
• Used joins to extract data from different tables
• Created calculations, filters, prompts and conditional formatting in Report Studio reports.
• Developed hide and show reports by using Conditional blocks
• Expertise in developing Prompt pages and Cascaded input prompts
• Moved and deployed reports from Development to testing and production servers using Content Administration
• Upgraded reports from Cognos 8.3 BI to Cognos 8.4 BI
• Provided administration support and Development support for production issues.
• Scheduled and distributed reports using Scheduler in Cognos Connection

Environment: Cognos 8.4/8.3 BI Suite (Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio), Cognos Transformer 8.4, Oracle 11g, SQL Server 2005/2008.

Confidential

Cognos Developer

Responsibilities:

• Involved in the entire project life cycle of Migrating Reports and Models from Cognos 8.2 to 8.3.
• Converted Hyperion SQR reports to Cognos 8.3 Reports. Understood reports created in SQR, mimicked the report logic while preserving complex formatting and design of SQR reports in the Cognos 8 Reports.
• Created many reports working closely with the business and the technical team to deliver various reports for HR and Finance Departments.
• Coordinated with Benefit and Tax group to gather functional requirements and created secure reports for the departments.
• Created Impromptu and Excel reports in Cognos 8 RS Reports.
• Involved in the implementation of Security.
• Developed models in Framework Manager and published packages into Cognos 8.3 environment.
• Worked with the DBA and Data warehousing personnel to sort out on any performance tuning issues.
• Generated and analyzed various trace files on the Cognos servers to nail down exact causes of performance bottlenecks.
• Trained business users on Query Studio.

Environment: Cognos 8, Cognos ReportNet v1.1 MR2, Framework Manager 8.3 and 8.2, Cognos7.1 Series (Impromptu, IWR, Access Manager, Upfront and all Server Administration), Java Script, Oracle 10g and Windows 2000, UNIX, PL/SQL Developer.

Confidential

Cognos Developer

Responsibilities:

• Installed and configured Cognos 8 environment.
• Built models containing complex security requirements from imported metadata.
• Modified packages to suit business needs and tuned them for performance improvement of reports in terms of run time by defining filters and adding calculations.
• Conversion of existing Impromptu Reports to report studio reports.
• Developing Standard reports, Charts, Drill through reports, Master Detail reports
• Using Report Studio and ad hoc reports in Query Studio
• Created list reports, cross tab reports, chart reports using Report Studio.
• Created query prompts, calculations, conditions & filters, prompt pages, using Report Studio for several reports.
• Created Complex reports using custom prompts and Tabular Objects.
• Scheduled and distributed reports through Schedule Management in Cognos Connection.
• Developed Multi-Dimensional Analysis and built Power Cubes using Cognos Power play and Transformer and created drill through reports for the cubes.
• Associated with ETL team to create data marts to build a data warehouse environment and provide constant updates about the necessary changes required.

Environment: Windows NT/2000, UNIX Server, Cognos 8.2 (Frame Work Manager, Report Studio, Query Studio), Cognos Suite7 (Impromptu, Power play, Upfront, Access Manager), Oracle9i

Confidential

Business Analyst - Logistics

Responsibilities:

• Worked on the development of Confidential Transportation Product suite.
• Broke down epic requirements in the BRD into smaller stories during Agile Scrum meetings.
• Conducted information sessions to explain functionality to the development team through the use of use case diagrams.
• Conducted fortnightly meetings with sales team and enterprise analysts to better understand and prioritize end user expectations in order to align development with requirements.
• Involved in Agile sprint planning to determine development, quality assurance and documentation effort for each of the stories; and Sprint retrospective meetings.
• Ensured smooth sprint Velocity through planned resource allocation and making sure that development spikes in burn down are minimal.
• Attended daily standup meetings to ensure smooth implementation of sprint goals.
• Responsible for keeping test metrics, maintaining test servers, tracking defects and making sure that defect tickets are worked on in a timely manner.
• Wrote and executed functional test cases and test cases against requirements.
• Performed automated & manual (black-box) testing activity on Windows & UNIX platforms as well as performance testing activity.
• Experience with all stages of the software development life cycle (SDLC) & familiar with V, Waterfall software development models & Agile project management methodology.
• Demonstrated developed application and stories to the product owner.

Environment: Toad, IBM Clear Case, Team Track, Version One, SQL Plus, Oracle 9i, Confidential Transportation 7.4.0, AIX, Windows Server 2003