PROFESSIONAL PROFILE

Over 9 years of I.T. experience with expertise in Business Intelligence and Data warehousing Analysis, Design, Development, Customization and Implementation of various Software applications and generation of Reports and Dashboards using various Databases. Experienced in BI suite, Data Modeling, Marts and Relational and Dimensional Models.Experience of Agile and Waterfall methodologies and Software Development life cycle SDLC .

Summary:

• 9 years of experience in BI suite IBM Cognos 10.1, Cognos 8.4.x Framework Manager, Cognos connection, Report Studio, Analysis Studio, Metric Studio, Event Studio and Query Studio , ReportNet 1.1, ReportNet, SDK, Cognos Impromptu 7.x/6.x, and Analysis Tools such as Cognos Transformer Power Play 7.x/6.x Access Manager and Data Manager
• Strong work experience of Agile and Waterfall methodologies and Software Development life cycle SDLC .
• Expertise in Framework Manager Modeling Physical Layer, Business Layer, Packages and Complex Reports developed in Report Studio and Query Studio and Analysis Studio.
• Good Experience in Created DMR and Relational Model in Framework Manager.
• Expertise in creating Business Dash boards, Charts, Professional reports in Report studio.
• Created Ad-Hoc reports using Query studio, Analysis studio and Trained power users to use Query studio, Analysis studio for Ad-Hoc reporting.
• Good Knowledge and understanding on ODS, Data Warehouse, Datamarts, Star and Snow Flake Schemas.
• Experience in developing Agents, Events and scheduling using Event Studio .
• Experience in creating Drill throw definitions for packages to reports for detailed analysis Analysis Studio.
• Created Various Dashboard Reports for different Business Areas based on Cubes and DMR
• Experience in customizing the Cognos connection portal using portlets and CSS Cascading Style Sheets.
• Experience in Migrating and upgrading reports from Cognos EP Series 7/CRN to Cognos 8.x and IBM Cognos 10.1
• Utilized Best Practices and Proven Methodology in modeling data, ETL and other BI development process
• Expertise in Data warehousing Concepts in OLTP/OLAP System Analysis, Database Schemas like Star Schema and Snowflake Schema Dimensional Modeling and Relational Modeling Concepts.
• Experience in Implementing Security using LDAP sources Sun One, Tivoli and Cognos Access Manager.
• Experienced on tools such as Erwin and MS Visio Professional when building data models.
• Experience in RDBMS such as Oracle 8i/9i/10g/11g, SQL Server 2000/2005, DB2 and Teradata.
• Functional experience in gathering the business requirements and resolving issues pertaining to the reports on day to day basis.
• Experience in writing Tabular SQL, PL/SQL code, stored procedures, Views, Functions as per the business needs.
• Experience in report performance tuning, SQL tuning and following best practices for model and report development.
• Strong experience in creation of Jobs, report scheduling, events, agents and report bursting and setting up the file system location for output creation.
• Deploying models and reports from Development to Production and administering users/groups/roles
• Proven ability to understand business problems and able to apply technology to formulate workable solutions with excellent Interpersonal and Communication Skills.
• Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes, and corrections.
• Participated in various meetings with offshore and functional teams to reviewing requirements, and Functional clarifications, participated in Regression, System, Integration, Functional and Performance Testing.
• Provided key project inputs by working with users and developers in defining several functional and technical issues of project and system requirements.
• Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess excellent communication and administration skills, highly motivated and with an aptitude for success and able to work in a team environment with minimum supervision.

Technical Skills:

Professional Experience:

Confidential

Cognos Reporting Consultant

Responsibilities:

• Worked closely with Business Analysts and team members for gap analysis and to streamline the Technical Requirements Functionalities for Cognos Financial Reporting and Dealer Power Mart Analytics.
• Developed Complex and Professional Dealer Power Mart Dashboard in Cognos and integrated reports that were built in Report Studio using Cognos Portlets for dynamic communication of prompt and report interaction.
• Designed and developed financial analysis reports in Analysis Studio using Cognos Cubes/ MDX functions.
• Designed and developed MDX/OLAP Cross tab financial forecast reports, Charts in Report Studio and created conditional page layout, sections, page breaks, sorting, summaries, grouping, drill down, drill up.
• Worked with the Data Modeling team to assist in developing the Financial Data Mart for Financial Data reporting.
• Maintained and Published Models and Packages as reporting needs.
• Created reports with filters and custom prompt pages using HTML and Java Scripts in Report Studio.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Conditional formatting, Conditional blocks in Report Studio.
• Customized the reports by applying filters, calculations, conditions, prompts text box, tree, value, date and Cascading Prompts in Report Studio
• Involved in designing the Drill UP and Drill Down reports according to the business needs.
• Created Drill through reports from Dashboards to all summary/Trend reports, Trend reports to Summary reports and Summary to Detail reports.
• Developing Analysis Studio views of analysis from dimensional modeled packages and made the reports using them in Analysis studio.
• Created Jobs in Cognos Connections and User groups for Scheduling the Batch Reports and Deployed the Jobs in Various Servers.
• Involved in Deploying the Packages, reports and Jobs from Development to UAT server and from UAT to Production Server.
• Created dashboards for immediate visibility into key performance indicators KPIs for corrective action and rapid decision-making using Metric Studio
• Extensively Involved in IBM Cognos 10 POC dashboard and given presentation to the Business users.
• Created Lists, Cross tabs and Active reports using IBM 10 Cognos Report studio.
• Created dashboard using IBM Cognos 10 Business insight and created complex professional reports using Business insight advanced.
• Worked with Cognos SDK team in designing the parameter page and with various cross application teams for rendering report in XML, PDF, and HTML format.
• Used IBM Cognos Life Cycle manager for data validation and regression testing while up gradation of reports.
• Worked on Cognos connection customization using Cognos Portlets and appropriate cascading style sheets CSS .
• Created dashboard using Business insight and created complex professional reports using Business insight advanced.
• Defined the Event Studio Event conditions, created agents to detect and alert the production issue occurrences in the BI reports.
• Defined the file system for report bursting and scheduled the user reports to report server.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.

Environment: IBM Cognos 10.1 Business insight, Business insight advanced, Active Reports, Life Cycle manager 8.4, Framework Manager, PowerPlay, PowerPlay Transformer Cognos Connection, Report Studio, Query Studio, Analysis Studio, Cognos Scheduler, Content Manager, Go Dashboard, Cognos SDK, Oracle 10g, MS SQL, MS Excel, Active Directory LDAP , IBM RAD Version 6, WAS Version 6, Apache Tomcat, Java, SOA, HP Quality Center, Windows XP, Unix, Toad, SQL Developer, Configuration Manager, MS Share point. SAP ECC 6. PeopleSoft. SAS EG9.

Confidential

Senior Cognos Developer/BI Consultant

Responsibilities:

• Gathered business requirement specifications from Product Management Team in implementing IBM Cognos 8.4 for Financial Merchant Services Analysis project.
• Transformed business requirements into Cognos reporting technical specifications for building the business intelligence dashboard layout for multiple corporations.
• Worked with business users coordinating Change Requests CR and developed the business intelligence reports as per client needs.
• Architected the Framework Manager model in publishing transaction and card packages among multiple data sources for budget and forecast reporting.
• Designed and published PowerPlay cubes utilizing Cognos Transformer to facilitate analytical MDX analysis reporting.
• Created multidimensional cubes in Powerplay Transformer and established data source connections from Oracle utilizing Cognos Framework Manager and published transaction and card cube packages to Cognos connection.
• Developed reports on activations and card balances which involved multiple prompts, filters, calculations, multi-page, master detail relationships and implemented drill through definitions.
• Created filter calculations, prompts and complex financial calculations in the reports as per the client applications.
• Participated in firm-wide architecture working groups and ensured that the technology organization was aligned to the corporate technology direction.
• Developed the reports utilizing the advanced functionalities for enriched user experience in Report Studio using master detail, multi prompt pages, multi optional and required parameters to support business needs.
• Implemented object level and data level security for the Framework Manager objects.
• Demonstrated ability to adjust priorities based on changing situations and handled several high priority projects at once.
• Created and executed system test plans to ensure fail safe integration of a program into a production environment and coordinated the integration testing, UAT and resolved support issues.
• Trained external and internal users on Cognos Reports and Cognos application utilization.
• Performed code reviews and evaluated the work of other individuals to ensure artifacts met the applicable standards and best practices.
• Established strong working relationships with the business, operations and other technology team members.

Environment: Cognos BI 8.4, Framework Manager, PowerPlay, PowerPlay Transformer Cognos Connection, Report Studio, Query Studio, Analysis Studio, Cognos Scheduler, Configuration Manager, Content Manager, Go Dashboard, Oracle 10g, MS SQL, DB2, Info sphere Cubing services, SDK, Java J2EE, IBM RAD Version 6, WAS Version 6, Apache Tomcat, Java, SOA, HP Quality Center, Windows XP, Unix, Toad, Quest Central, SQL Developer., MS Excel, MS Visio and MS Project.

Confidential

Senior Cognos Developer

Responsibilities:

• Worked with business users to gather business requirements and mapped into technical requirements for developing the Business intelligence reports.
• Created customized, complex reports in Cognos 8.4/8.3 Report Studio and ad-hoc reports in Query Studio and implemented master detail relationships and drill through definitions.
• Created complex package reports using conditional blocking as per the business needs.
• Created Executive Dashboard to bring multiple reports together to show information in context. Reports included Monthly Renewal Activity, Submissions Quotes and New Business, Claims Backlogs etc.
• Responsible for creating separate models and packages as per the requirements and reporting needs.
• Administered the security for package, reports and created user groups and implemented security as per the needs.
• Developed the complex cross tab reports and list reports using functions.
• Worked on versioning of the Cognos reports using database tables and Java utilities.
• Developed list, cross tab, drill through, master-detail, chart and complex reports which involved multiple prompts, filters, calculations, multi-page and multi-query with joins.
• Developed master detail reports, multi query and multi page master reports as per business needs.
• Created models in Framework Manager, Meta data filters, prompts and joins among multiple data sources for reporting.
• Responsible for the daily, weekly and monthly releases of deployments of the packages and reports to different environments.
• Administrated Cognos portal and specified user roles, permissions using LDAP
• Responsible for handling and maintaining Cognos Content Store, Content Administration and backup related issues of the Cognos content store
• Responsible for handling and maintaining Cognos Content Store, content administration and backup related issues.
• Created and scheduled events using Event Studio for production error monitoring to provide the updates to the business users.
• Worked with Cognos SDK Developers for report invocation using SDK code and resolved the parameter issues.
• Developed PowerPlay cubes and published packages utilizing Cognos Transformer to facilitate OLAP analytical reporting.
• Designed and developed analysis reports in Analysis Studio analyzing MDX expression using cubes.
• Created multidimensional cubes using IQDs and created models in Power Play Transformer.
• Worked on Cognos Security Administration by providing the accesses and privileges to the users and user groups using Access Manager.
• Coordinated system test plan execution for the integration of code in to the production environment, UAT, UVT and smoke tests and resolved the production support issues.
• Created user manuals for internal and external user training and orientation. Provided documentation and tutored the end users how to use different types of studios.
• Assisted the ETL team in extracting data from other main frames, transformed them to multi-column card format and loaded into data marts.

Environment : Cognos BI 8.4, 8.3, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Cognos Scheduler, Transformer, Configuration Manager, Content Manager, Cognos Planning, TM1 Web, DB2, Oracle 10g, MS SQL, Apache Tomcat, Java, SOA, HP Quality Center 9.2, CA Ervin, MS Visio, Windows XP, Unix, Toad, SQL Developer, Quest Central. Informatica Power Centre Abinitio.

Confidential

Cognos Financial Consultant

Responsibilities:

• Involved in the full SDLC of the project, worked with users from gathering requirements to the support of the application.
• Created customized reports in Cognos 8.2 Report Studio and ad-hoc reports in Query Studio.
• Designed data cubes using Microsoft OLAP services, Power Play Transformer for cube design and Power Play to facilitate executive, management and end user reporting.
• Designed MDX/OLAP reports using Report Studio features conditional formatting, conditional page layout, sections, page breaks, sorting, summaries, grouping, and drill down, drill up .
• Created filter calculations, prompts and complex financial calculations in the reports as per the client applications.
• Developed prompt page reports, drill up, drill down and drill through reports, used conditional blocks and conditional variables as per reporting needs.
• Developed complex reports in Report Studio using multi prompt pages, multi optional and required parameters to support business needs.
• Worked on and resolved many production issues and involved in defect resolution of reports.
• Responsible for Frame Work Manager modeling, package creation and administered the models.
• Implemented object level, data level security for the Framework Manager objects.
• Worked with the Database Administrator to resolve the data related problems in the report development
• Designed and developed OLAP Cubes in Transformer and generated Power Cubes.
• Performance tuned the reports and models as needed.
• Developed different kind of report formats using XML, HTML and Excel formats and analyzed the XML for parameter naming conventions.
• Responsible for unit testing, tested the data integrity wrote SQL commands to check the data quality to find out data issues.
• Worked on user requirements, design specification, unit and integration tests to ensure code migration to production.

Environment Cognos 8.2 BI, Framework Manager, Cognos Connection, Report Studio, Query Studio, Metric Studio, Event Studio, Analysis Studio, Power Play Transformer, Access Manager, XML, HP Quality Centre, Microsoft Excel, MS Visio, Oracle 9i, MS SQL Server 2005

Confidential

Cognos Developer

Responsibilities:

• Involved in the installation and configuration of ReportNet.
• Worked on Cognos Security Administration by providing the accesses and privileges to users and user groups using Access Manager
• Administrated Cognos portal and specified user roles in Cognos Access Manager.
• Responsible for release management, production deployments of the Meta data packages and reports to different environments.
• Responsible for handling and maintaining Cognos Content Store and backup related issues of the Cognos content store.
• Designed a multidimensional model using star schema grouping and implemented best practices to provide reporting solutions with logical groupings of tables.
• Performance tuning to reduce filters and restrict user privileges using governors in the model.
• Scheduled the Power Play Transformer to refresh Power Cubes and Power Play to update the contents of the report.
• Responsible for package modification, creating Separate packages as per the requirements and reporting needs.
• Developed list, cross tab, drill through, master-detail, chart and complex reports which involved multiple prompts, filters, multi-page, multi-query, burst reports against database.
• Created Cognos Transformer Models and generated Power Cubes by externalizing Query Subjects using IQD as data sources in Cognos Framework Manager for MDX analytical reporting needs.
• Created budget and forecast dashboard reports according to requirement.
• Implemented security using Access Manager and migrated security form Access Manager to Active directory.
• Coordination of integration testing, UAT, UVT and smoke tests and resolved the support issues.
• Deployment of the reports and the cubes in the production environment in upfront.
• Responsible for release management and documentation management.
• Developed and tested the reports in Report Studio and coordinated with the client for UAT.
• Provided customer support to help users create reports using advanced options.

Environment: Cognos 8.1, Framework Manager, Report Studio, Query Studio, Analysis Studio, Transformer, 7.3 Impromptu, PowerPlay, ReportNet1.1 MR1, Oracle 9i, MS SQL Server 2005, Win NT, IIS Web Server, Windows 2000, UNIX, Configuration Manager, Content Manager.

Cognos BI Consultant

Responsibilities:

• Interacted with direct clients to understand and document business requirements, develop technical specifications and recommendations on the preferred solution for development and deploy efficient BI solutions.
• Developed projects and packages in Framework Manager and published packages to Cognos Connection.
• Produced reports in various formats like PDF, CSV, HTML and languages.
• Developed reports using filters, prompts, calculations and conditional blocking and formatting.
• Migrated Impromptu catalogs and reports from EP Series 7 to Report Net.
• Created filters, calculations, conditions, graphs, and prompts as per different reporting requirements.
• Created several lists, cross tab, chart and repeater reports using Report Studio. Extensively worked on resolving report issues relating to data anomalies working with Database team.
• Maintained projects using VSS as the version control mechanism.
• Produce queries and reports in multiple language formats, presented and distributed reports utilizing different layouts, multiple report objects and multiple logical pages.
• Involved with scheduling and distributing reports through Schedule Management in Cognos Connection.
• Responsible for unit testing using TOAD and checked the data for the reports, resolving the reporting issues.

Environment : Cognos BI 8.1, Framework Manager, Cognos ReportNet1.1 MR1, Framework Manager, Report Studio, Query Studio, EP 7 Series, Impromptu v7.0, Power Play Transformer, Upfront, Oracle, MS SQL Server 2000, HTML, SQL , Unix, Windows NT.Reports, MS SQL Server 2000.