SUMMARY

• Over 11 years of experience in IT Industry with experience in analysis, design, testing, development, documentation and implementation of Cognos application. Extensive experience in developing scalable enterprise applications to the user needs which serves for Financial, Pharmaceutical and Market Research Industries.
• Expertise in working with Cognos for model design, Query Studio for Ad-hoc reporting and Report Studio for advanced report authoring. Expertise in implementing security in ReportNet with Access manager and third-party security providers like LDAP.
• Worked on multiple COGNOS BI/Data Warehouse projects with strong technical skills Modeling and Report Authoring and deep Functional/Domain/Business knowledge.
• Experience in COGNOS 10 8 Suite Framework Manger, COGNOS Connection, Report Studio, Query Studio and Analysis Studio with expertise in Metadata Modeling-Create project, Prepare Metadata, Prepare the Business View, Create and Manage packages, Set security and publish into portal.
• Extensive work experience in various versions of COGNOS Report Net and COGNOS EP Series 7.x Impromptu, Power Play, IWR, Power Play Transformer, Access Manager, COGNOS Upfront
• Extensively worked on Framework Manger in creating models and implementing 'best practices' while modifying relationships, resolving the loops and Dimensionally Modeled Relational data DMR/ROLAP .
• Complex Report Building Experience by using Tabular Objects, Tabular SQL, Filters Customized Prompts, Conditional Formatting and Complex Layouts like Cross tabs, sub reporting and Bursting.
• Experience with MDX Functions in Report Studio using Multi-dimensional Sources.
• Experience with Macro functions in Report Studio.
• Experience with Cognos Software Development Kit SDK to customize reports using JAVA
• Proficient in Score carding, Dash boarding and Implemented Security among various COGNOS applications
• Designed and developed OLAP applications, Transformer Models and Multidimensional Power Cubes
• Working Experience in design, validation and testing of reports and deployed applications from development to QA and then Production servers.
• Responsible for COGNOS software upgrades, patch installation and managing COGNOS security strategy.
• Strong programming experience in SQL and PL/SQL Procedures, Functions, Packages and Database Triggers .
• Profound understanding of Metadata Management, Data Governance and Data Stewardship Principles.
• Comprehensive involvement in all phases of application lifecycle development be it analysis, development, testing, debugging and User Acceptance Testing UAT with QA team.
• Excellent interpersonal skills with an ability to adapt to new and challenging environments and ability to work independently with good degree of independent judgment as well as with a team.

TECHNICAL SKILLS

• Data Warehousing Cognos 10/8, Framework manager, ReportNet 1.1/1.0, Report Studio, Query Studio, Cognos Connection, Cognos Impromptu , Cognos Powerplay Transformer , PowerPlay , Access Manager, Actuate, Visual Studio.
• Languages SQL, PL/SQL, Core Java, C, C , C , .NET
• ETL Tools Informatica, Data Stage, SSIS
• Operating Systems Windows, UNIX, LINUX, DOS
• Databases/RDMS Oracle, SQL Server, MS Access, Teradata
• GUI Tools VB 6.0/5.0
• Internet Tools XML, HTML, DHTML, JAVA SCRIPT, VB SCRIPT
• Packages MS Office

EXPERIENCE

Confidential

Sr. Cognos Developer

• Westfield Insurance, the primary subsidiary of Westfield Group, is a multi-line provider of business property liability insurance, personal lines insurance including auto, homeowner's and specialty , agribusiness insurance, and surety bonds.
• Responsible for the complete range of BI capabilities: reporting, analysis, score carding, dashboards and business event management.
• Involved in the Installation of COGNOS 10 and migration of reports from Actuate to Cognos 10
• Installed and Configured Go-Office in Cognos 10.
• Developed Framework Manager Models with physical layer and presentation Layer to cater the various business needs.
• Created various reports using drill through, cascaded prompts, conditional formatting and master detail relationship
• Expertise in deployment import, export of Cognos Reports from Environment to another Environment.
• Applied best practices on the Framework Manger models to refine and fine tune the models and provide best practices for day to day operations, performance analysis, tuning and capacity planning.
• Implemented data level, object level and package level security in Framework Manager
• Defined relationships and cardinality between different database tables.
• Set the properties for dispatchers and services and organized them into configuration folders
• Defined data sources and their associated connections in COGNOS Connection.
• Designed the Cognos Portlets and design enabling portlet interactions.
• Worked with DBA to setup the new Databases and Modify Databases for Reporting Models.
• Involved in creating reports based on Budgeting, Forecasting and planning.
• Created Reports for Business Executives to make the day today decisions in an effective way.
• Created Planning cubes using contributor to take edge decisions.
• Designed and developed complex active reports, charts, graphs and Interactive dashboards using Report Studio that was linked using hyperlinks and drill troughs. The reports are designed at a maximum of five levels of drill downs.
• Designed and developed reports using Cognos workspace advanced.
• Developed Ad hoc reports using Query Studio.
• Recreating the Metric Studio score cards to report studio by using Metric Package and provided the report level security.
• Trained Business Users and Created Ad-hoc reports to make better decisions rather than data Entry.
• Made use of complicated queries, conditions and filters. Extensively used conditional blocks, conditional formatting, conditional texts, different prompts and Static choices for the graphs.
• Implemented row level security in Report Studio to hide the drill through and reports from few users and provided access to some other users.
• Fine-tuned the queries for performance purpose and enhanced the performance of the reports.
• Implemented security in Cognos with third-party security provider LDAP.
• Administered the packages and reports in development and test environment.
• Implemented Securities on Reports, Packages and models.
• Used Cognos Connection for security, organizing, scheduling, monitoring activities and reports.
• Provided support for various teams over deployment issues and environment setup.
• Worked on Setup for SQL Trace for troubleshooting on Dev and QA Cognos servers
• Deployed packages, folders and content store from a development environment to sand-box environment
• Deployed packages from a development environment to test environment
• Prepared documentation to train end users regarding the functionality of Query studio and Analysis studio.
• Extensively used cascading prompts, drill-through, summaries, conditional formatting, grouping and sorting features to generate efficient and user-friendly reports.
• Involved in Informatica ETL mappings that transfer data from Oracle source systems to the Data Mart.
• Managed scheduling of reports, public and My folders and distribution lists, users, groups and roles using COGNOS Connection in COGNOS
• Designed, developed, refreshed and maintained the COGNOS Power cube using Power Play Transformer
• Extensively worked on Analysis Studio to explore business data to find trends and comparisons that answer their business questions.
• Created complex SQL views to avoid complex modular joins within reports and imported the views into Framework Manager
• Used Access Manager to provide a centralized environment to define, store and maintain security information for all COGNOS BI Applications
• Developed and Designed reports in Oracle BI Publisher.
• Involved in QA and Post-Production support.

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

Confidential

Sr. Cognos Developer

• Created DMR Dimensionally Metadata modeling using Relational Database Models Drill up, drill down Levels like powerplay in Cognos 8.4 Framework Manager for Analysis Studio.
• Involved in the Installation of COGNOS 8.4 and up gradation of Packages from Frame Work Manager, Reports from Report Studio from COGNOS 8.4 to COGNOS 10.
• Schedule various reports Using Schedule Management used in COGNOS Connection.
• Developed complex reports using Static Prompt and MDX functions and union conditions.
• Created various IQD packages in Framework Manager and integrated them to powerplay transformer to create various models and cubes.
• Providing COGNOS access by assigning roles and maintaining security for auditing purposes.
• Created roles in COGNOS connection and Access permissions were given to users.
• Preparing and presenting prototype Models and reports using Noetix views in Framework Manager.
• Experienced with SSIS DTS packages for Import and Export mechanisms.
• Coordinating with business users to understand the business rules and working with data warehousing team.
• Developed Several Reports using Query Studio and Report Studio in Cognos 8.3.
• Testing the developed reports for final deployment.
• Created complex reports in Report Studio such as list reports, crosstab reports.
• Designed and developed a strategy for a specific and vital reporting need. Emphasis was on a design to support current and historic reporting.
• Developed the Metadata layer by importing the required objects into Framework Manager
• Documented self developed reports and Framework Manager FM Models as well as supported them.
• Organized the metadata as per the requirement in Folders and Namespaces in Framework Manager.
• Published Packages to the COGNOS 8.3 server using Framework Manager
• Created IQDs by externalizing the Query Subjects in Framework Manager.
• Implemented the Security at data and object level in Framework Manager.
• Created various reports using COGNOS functionalities like Sub-Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formula's.
• Involved in design and development of Teradata BTEQ scripts
• Writing the SQL scripts using the teradata.
• Enhanced the existing BTEQ scripts according to new business logic.
• Customized data by adding the Prompts, Filters, Calculations, Summaries, Functions and Conditional formatting.
• Developed Multi-page reports, List reports, Charts, Drill through and Master-detail reports using Report Studio
• Designed the Dimensional Models for transformer and Power Play cubes using PowerPlay. Explored the cube data using the Report Studio and Analysis Studio.
• Scheduled the reports in COGNOS Connection and distributed them via mail.
• Responsible for creating test plan documents and documented the test results.

Environment: COGNOS 10 Report Studio, Query Studio, Analysis Studio, Metric Studio , Cognos 8.4 Go-Office, Teradata, Oracle 11g ,PL/SQL, Informatica, LDAP, Access Manager, Windows XP/2008, SharePoint, Perforce, HP Quality Center.

Confidential

Sr. Cognos Developer

• Sempra Energy companies develop energy infrastructure, operate utilities, and provide related products and services to its customers.
• Gathered Business Requirements to develop reports using IBM Cognos
• Analyzed, designed, built and tested reporting solutions based on business requirements.
• Created Cognos 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.2 to cognos 8.4
• Installation of cognos 8.4 Framework manager and transformers.
• Worked on Installation and Configration of cognos in distributed environments on windows.
• Applied Security and User Authentication to the various User Groups.

Environment: COGNOS 8.4 Framework Manager, Query Studio, Report Studio, Analysis Studio COGNOS Connection, COGNOS Configuration , Transformer, LDAP, Access Manager, IIS, Oracle 10g, Teradata, TOAD, Windows 2003/XP, UNIX.

Confidential

BI Developer

Capital Dynamics Pte Ltd is a global fund manager primarily managing the iCapital Global Fund, an open-end, zero load global fund and provides individually managed funds for accredited investors.

Environment: Cognos reportnet 8.1/8.2,Framework Manager, Report Studio, Query Studio, Analysis Studio, Transformer, PowerPlay Enterprise Server, Teradata, LDAP, Access Manager, IIS, PeopleSoft, server 2005,Oracle 9i,TOAD.

Confidential

Cognos Developer

Headquartered in Singapore, Flextronics is a leading, Fortune Global 500 Electronics Manufacturing Services EMS provider focused on delivering complete design, engineering and manufacturing services to automotive, computing, consumer, digital, industrial, infrastructure, medical and mobile OEMs.

Environment: COGNOS 8 Report Studio, Query Studio, Analysis Studio , ReportNet 1.1, COGNOS EP series 7 ver 4,Transformer, LDAP, Access Manager, Apache, powerplay, Oracle 9i,TOAD,Informatica,SQL Server 2005/2k, SAP BW,UNIX, Windows XP/2003.