CAREER SUMMARY

• Around 7 years of IT experience in Business Intelligence systems such as Analysis, Design, Development, Deployment, Testing, and Dimension Modeling. Extensively worked on various versions of COGNOS and involved in implementation of complete life cycle of BI systems.
• Around 7 years of experience COGNOS 10 10.1/10.1.1 Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight, Business Insight Advanced, Cognos Connection and Transformer , with COGNOS 8 8.4/8.3/8.2 , COGNOS series 7 suite Cognos Impromptu Administrator 7.x/6.x, Impromptu Web Reports IWR 7.x/6.x, Power Play Transformer 7.x/6.x, Power Play Enterprise Server PPES and Access Manager
• Expert in creating Active Reports in Cognos 10 Report Studio.
• Trained power users in Business Insight Advanced to create reports using externalized metadata
• Proficient in Meta data modeling with Framework Manager and experienced in layered approach such as Physical Layer and Business Layer, Presentation Layer...etc.
• Experience in DMR modeling with Framework Manager
• Outstanding experience in creating report layout as List, Cross Tab, Chart and Repeater table
• Created complex reports with advanced features such Master detailed sections, Conditional formatting, Render variables, Drill-through, Page Set, Java Script and Bursting using ReportStudio
• Experience in working with Cognos Business suite installation and configuring tools.
• Experience in Reports Deployment and Reports scheduling
• Hands-on experience in Design and Develop the Transformer model and Power play cube
• Extensive experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8
• Used Analysis studio for multi-dimensional analysis and created context filters for better performance
• Implemented security at Cubes using Apex, Cloak, Suppress, Exclude
• Implemented security at various levels such as Package, Object and Data level using FM
• Involved in creating Technical Design documents
• Involved in Reports Testing and UAT
• Experience in databases such as Oracle 10g/9i/8g, SQL SERVER 2000/2005, DB2 and Teradata
• Experience in SQL Queries, CreatingViews, PL/SQL Stored Procedures, Functions, Triggers, Cursors as per the business needs requirements
• Experience in Production/CustomerSupport, Deployment, Development and Integration.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules
• Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving skills

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Senior Cognos Developer

Responsibilities:

• Involved in gathering Requirements from Business users and prepared Functional Requirement Specifications for report development
• Was involved in creating different Dimensional and relational Models by pulling the data from multiple data sources like Oracle, SQL Server 2005 and published packages to the Cognos Connection
• Involved in creating active reports using the /Cognos 10 version, which are mostly targeted towards the business users.
• Created the framework model using the layered approach i.e. using Database Layer and Business Layer, defining appropriate relationship between query subjects in Framework Manager
• Set up the security at the package level, query subject level and query item level
• Resolved different ambiguous relationships between query subjects while creating Framework manager model
• Prepared documentation and was involved in the life cycle of creating the reports.
• Was involved with Scheduling and bursting the reports in various formats, such as Html, PDF and excel according to user requirements in Cognos Connection and sent the reports through E-mail feature
• Created alternate drills down paths in some of the dimensions to enable users to analyze data as per their requirement
• Used Analysis Studio for multidimensional analysis and slice dice the cube data
• Provided List, Cross tab, chart and repeater layouts used for presenting the data in better way
• Deployed reports from developmentenvironment to productionenvironment
• Applied various kinds of prompts such as Value prompt, Date prompt, Textbox Prompt, Select Search Prompt for report's better performance
• Created reports using advanced features like Master-Detail, Drill-through, Conditional Formatting and Page set

Environment:

COGNOS 10 10.1/10.1.1 Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight, Business Insight Advanced, Cognos Connection and Transformer , Cognos Transformer, Oracle10g, Windows 2000/XP.

Confidential

Senior Cognos Architect

Responsibilities:

• Involved in Requirements collection with Business users and prepared Functional Requirement Specifications for report development
• Developed the Framework Manager model by pulling the data from multiple data sources like Oracle, SQL Server 2005 and published packages to the Cognos Connection
• Resolved different ambiguous relationships between query subjects while creating Framework manager model
• Created Database Layer and Business Layer, defining appropriate relationship between query subjects in Framework Manager
• Set up the security at the package level, query subject level and query item level
• Designed models by mapping business requirements using Transformer and created multi-dimensional cubes by using IQDs which are generated from Framework Manager by externalized method property of the query subjects
• Involved in creating Active reports and Business insight advanced.
• Created Dimensions, Levels, Calculated Measures, Special Categories with relative time period and Cube groups
• Created alternate drills down paths in some of the dimensions to enable users to analyze data as per their requirement
• Used Analysis Studio for multidimensional analysis and slice dice the cube data
• Provided List, Cross tab, chart and repeater layouts used for presenting the data in better way
• Applied various kinds of prompts such as Value prompt, Date prompt, Textbox Prompt, Select Search Prompt for report's better performance
• Created reports using advanced features like Master-Detail, Drill-through, Conditional Formatting and Page set
• Developed Reports against Database using Tabular SQL for complex scenarios
• Designed and Developed dedicated package for business users with business naming conventions and trained the end users on how to develop reports in Query Studio
• Scheduled the reports according to user requirements in Cognos Connection and sent the reports through E-mail feature
• Bursting the reports in various formats, such as html, PDF and excel
• Deployed reports from developmentenvironment to productionenvironment
• Prepared documentation at each level of process
• Involved in Report testing and UAT

Environment:COGNOS 10 10.1/10.1.1 Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight, Business Insight Advanced, Cognos Connection and Transformer , Cognos 8.4, Cognos Transformer, Oracle10g, Windows 2000/XP.

Confidential

Senior Cognos Developer

Responsibilities:

• Interacted with business users and prepared Functional Design Specifications
• Developed Technical Design Specifications for reports and also recommended preferred solution for report development
• Created Framework Manager Model based on business requirements for reporting and Dimensionally Modeled Relational DMR for multi-dimensional analysis
• Created Database, Business and Dimension layers with defining appropriate relationship between query subjects in Framework Manager
• Created Regular dimensions, Fact dimensions, Levels and Hierarchies
• Implemented Third Party Security with LDAP and used roles groups in creating Data Level, Object Level, Package Level securities in Framework Manager model
• Created multi-dimensional analysis reports using DMRmodels in Analysis Studio and applied context filter for better analysis
• Created score cards with multiple formats using metric studio
• Created reports with detailed and summary filters, provided various kinds of prompts such as Value, Date, Textbox etc.
• Developed complex reports in report studio using prompts, parameters, filters and conditional formatting
• Extensively used Query Studio for developing Ad hoc reports
• Customized the reporting environment by adding new portal skin including corporate logos and approved colors and new links
• Creating and Managing Jobs and Schedules
• Created portal pages/Dashboards by including business critical reports to monitor the business in a single glance
• Scheduled and managed events using Event studio
• Involved in Report testing and UAT

Environment:Cognos 8.3 BI Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event studio , DB2, Windows XP, UNIX

Confidential

Cognos Report Writer

Responsibilities:

• Involved in the entire project life cycle from Analyze, Design and Development of reports
• Migratingreports and cubes from Cognos series 7 to Cognos 8
• Upgraded existing Cognos 7.1 catalog and reports to Cognos 7.4
• MigratedCognos 7.4 catalog and reports to Cognos 8.1 using Cognos migration utilities
• Migrated numerous Cognos Series 7.1 cubes and models to Cognos 8
• Developed complex reports, standard Reports, Master Detail reports, Bursting reports, drill-through reports with calculated columns, filters, and prompts using Report Studio
• Created new enhanced reports using Report studio
• Created AdHoc reports using Query Studio
• Developed Portal Pages/Dashboards
• Managed Scheduling of reports, maintenance of public and individual folders, distributionlists, users, groups and roles using Cognos Connection in Cognos 8
• Report deployed from Development to Testing and production servers using Content Administration
• Documented Migrationprocess
• Coordinated in training sessions and demonstration of Cognos tools to End-users
• Involved in creating Technical Design documents
• Involved in Reports Testing and UAT

Environment:

Cognos 8 Report Studio, Query Studio, Cognos Connection , Cognos 7 Series Impromptu, Impromptu administration, IWR, Powerplay Transformer, Upfront , Oracle 9i, UNIX, TOAD, Windows XP.

Confidential

Cognos Developer

Responsibilities:

• Designed, developed and maintained catalogs, Impromptu reports, templates, hot files, PDF files, snapshots, drill through.
• Created various reports List, Crosstab, Mailing Labels, Form Letter, Free Style using Cognos Impromptu tool by querying the database
• Reporter Operations such as Sum and Average, Intersection, etc., Exception Highlighting Sorting, Ranking etc.
• Used Impromptu's optimizing features like table weighing, governors, bulk fetch
• Enabled users to access the distributed HTML reports through local network intranet/internet, and via email
• Created Hierarchies from providing drill down options for the end-user
• Different department users used the Powerplay environment that is customized for each user depending on the requirements
• Defined conditions, calculations and prompts in the catalog
• Extensively worked on prompts based on the user needs and format required
• Used Multidimensional analysis for Data Retrieval using Powerplay structure
• Generated reports as per the requirements using Cognos Impromptu
• Created IQDs using Impromptu Administrator
• Created standard and Adhoc reports Formats, Layouts, quality data to carry using Cognos Query
• Published the IWR reports on the web server.
• Created User Prompts, Conditions and Filters to improve the report generation

Environment:

Cognos 7 Series Impromptu, Cognos Server Administration, Cognos Upfront, Impromptu Web Reports IWR , Cognos Query, Metrics Manager Erwin Data Modeler, Windows 2000 server, MS SQL Server 2000, MS ACCESS, Windows XP, 2000