SUMMARY:

• 9+ years of experience in IT Industry with experience in Software Administration Analysis, design, testing, development, documentation and implementation of client server applications.
• 7+ years of experience with Business Intelligence tools like Cognos 8, Report Studio, Analysis Studio, Metrics Studio, Query Studio, Framework Manager, Cognos ReportNet1.1 MR1 Impromptu Administrator, Impromptu Web Reports (IWR), PowerPlay, Documentum, Transformer, PowerPlay Enterprise Server (OLAP), Upfront and IWR Server Administration and Access Manager and Directory Server.
• Extensively worked on Power Play Transformer for building up of Multidimensional Cubes.
• Experienced in building analytical queries and reports to support the business requirements.
• Created User Groups, Roles to implement the Cognos Security, using LDAP.
• Used Cognos Connection extensively to administer Reports as well as the Cognos 8 Server.
• Involved in the process analysis, catalog design and performance optimization of Business Intelligence Reports.
• Extensively worked on DMR (Dimensionally modeled relationship).
• Created Business Intelligence Reports using Cognos Impromptu, Powerplay, ReportNet, and Series 8.
• Created data models and implemented user access level security using Architect.
• Developed OLAP solutions using Cognos and published Reports using Cognos Upfront.
• Administered Access Manager to implement Security among Cognos applications.
• Installed and Configured Cognos for building multidimensional Cubes.
• Good hands on experience on ETL tools like Informatica etc.
• Automated Reports and generated Documents using Scheduler, Noticecast.
• Created and managed reports in Zero - footprint environment using ReportNet.
• Strong understanding of data warehousing concepts like Star Schema, Snowflake Schema and Dimension modeling for analysis requirements.
• Strong interpersonal skills, with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS:

BI Tools: Cognos Series 8, Cognos Business Intelligence 7.0, Cognos Impromptu 5.2/6.0,7.x, Cognos Transformer & Power Play, Impromptu Web Reports (IWR), Cognos Query, Documentum, Cognos Architect, Cognos Upfront, Crystal Reports 6.x/7.x, Business Objects.

Database Tools: Query Analyzer, SQL Loader, SQL Navigator SQL Plus.

Languages: C, VB, SQL, PL/SQL, T-SQL, Perl, HTML, and XML.

Operating System: Windows 2000, Windows NT 4.0, UNIX (Sun Solaris, AIX)

Databases: Oracle10g, 9.x/8.x/7.x/6.x, MS SQL Server 2000/7.0/6.5 , DB2, MS- Access, Toad.

Internet Technologies: ASP, HTML, DHTML, Java Script and VB Script, .Net.

PROFESSIONAL EXPERIENCE:

Confidential, Mansfield, MA

Senior Cognos Consultant

Responsibilities:

• Analyze the existing Supplier Scorecards and dashboards.
• Actively involved in meetings with Business Usersfor designing the Functional and Technical requirementsfor new report development.
• Work on the PO detail report and drill thru reports of that PO detail.
• Customized data by adding Filters Prompts to the reports.
• Participated in JAD sessions provided the session Deliverables to the client for the approval.
• Work with project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
• Worked Supplier Performance Management (SPM) Self Service reporting.
• Worked on all the drill thru of self service reports (In process, Incoming, PO detail etc).
• Worked on the dynamic reporting using JavaScript (Asc and Dsc order).
• Provide Cognos to Business Users for self-service reporting purpose.
• Involve in validation of reports to detect any potential problem in reports.
• Fixed the errors in year end critical PO Detail Reports.

Environment: Cognos 8.4, Framework Manager 8.4, Report Studio, Query Studio, Scorecards, Dashboards, Microsoft Excel, Microsoft Visio, Oracle, SQL Server.

Confidential, Albany, NY

Senior Cognos Consultant

Responsibilities:

• Analyze the existing FACETS reports in Cognos 8.3 environment.
• Actively involved in meetings with Business Usersfor designing the Functional and Technical requirementsfor new report development and migration of existing reports.
• Work closely with the database team for the enhancement.
• Analyze Relational Modelsin Framework Manager to suit reporting requirement and self service reporting capability.
• Actively involved in the meetings with system analyst for requirement gathering.
• Handled the issues related to the Framework manager model.
• Create the report views for the set of users.
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Deploy packages and Reportsfrom one Cognos server to other server.
• Created database connections for different data sources.
• Used Oracle Toad to extract Data from the Database.
• Work on RTC tool to generate the tickets.
• Created simple to complex reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, master-detail, tables, charts, filters, prompts, various calculations and joins using tabular sets and tabular models.
• Moving applications from one server to other using Deployment Manager.
• Moved projects from development to QA and then Production servers.
• Tuned the performance of the reports by using the metadata compression method.
• Used Cognos Connection extensively for organizing, security, scheduling and distributing reports.
• Create Run, and Schedule Reports and Jobs using Cognos Connection.

Environment: Cognos 8.3, Framework Manager 8.3, Report Studio, Query Studio, RTC, Oracle, Toad, FACETS.

Confidential, Bloomfield, CT

Senior Cognos Consultant

Responsibilities:

• Analyze the existing LEA reports in Cognos 8.3 environment.
• Actively involved in meetings with Business Usersfor designing the Functional and Technical requirementsfor new report development and migration of existing reports.
• Actively involved in the meetings with system analyst for requirement gathering.
• Created and analyze complex list reports, crosstab reports, page break reports and master detail relationships usingReport Studio.
• Created User Groups, Roles to implement the Cognos Security.
• Build the Cubes manually using batch processing.
• Created IQD files in Framework Manager and by using those IQD files created powerplay cubes.
• Worked on small enhancement on the cubes according to ADS.
• Change the IQDS for the cube as per the new requirement.
• Analyze Relational Modelsin Framework Manager to suit reporting requirement and self service reporting capability.
• Create the report views for the set of users.
• Work Extensively in Access Manager.
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Migrate the reports and cubes from testing to production environment.
• Created new reports and cubes based on the business requirements.
• Deploy packages and Reportsfrom one Cognos server to other server.
• Created database connections for different data sources.
• Provide Cognos to Business Users forself service reporting purpose.

Environment: Cognos 8.3, Framework Manager 8.3, Report Studio, Query Studio, Powerplay Transformer, SQL Server, DB2, Microsoft Excel, Hyperion, BRIO Intelligence.

Confidential, Hopewell, NJ

Senior Cognos Consultant

Responsibilities:

• Study the attributes, relationships, versions, renditions, formats, workflow, and security from Docbase (Documentum).
• Understanding existing business model and user requirements.
• Extensive interaction with Business Users and gather information and requirements.
• Work in Framework Manager to create a Relational model.
• Create the reports in Report Studio, Query studio and Query studio related to BLIS Package.
• Works on SQL Plus and Oracle SQL developer.
• Worked extensively on Oracle database.
• Created several different types of ad-hoc reports like Simple List, Grouped List, Section Heading, Crosstab, and Nested Crosstab.
• Good hands on experience on version control tool.
• Created User Groups, Roles to implement the Cognos Security, using LDAP.
• Moved projects from development to QA and then Production servers.
• Designed and Prepared an IQOQ (Installation Qualification/Operational Qualification) for the Users.
• Provide Cognos to Business Users for self service reporting purpose.
• Used Cognos Connection extensively for organizing, security, scheduling and distributing reports.

Environment: Cognos 8.4, Framework Manager 8.4, Documentum, SQL plus, Oracle SQL Developer, Samson, Oracle, PL/SQL, SQL Server, Microsoft Excel, Microsoft Visio, Report Studio, Query Studio.

Confidential, Juno Beach, FL

Senior Cognos Consultant

Responsibilities:

• Work in Framework Manager to create a multidimensional model (DMR).
• Study the batch processing which is used to upload the data into the cube.
• Worked extensively on Oracle database. Troubleshoot for SQL issues/performance issues.
• Understand the existing cube and replace that cube with the DMR in Framework manager.
• Worked on views and materialized views.
• Extensive interaction with Business Users and gather information and requirements.
• Create the reports in Report Studio, Query studio and Analysis studio related to new model.
• Replace the existing report package from cube to Framework manager package.
• Works on SQL navigator for creating the scripts.
• Involve in migration of cognos from 8.3 to 8.4.
• Report Documentation using DWH (Data warehouse) tool.
• Handled the issues related to the Framework manager model.
• 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, master-detail, tables, charts, filters, prompts, various calculations and joins using tabular sets and tabular models
• Created several different types of ad-hoc (Simple List, Grouped List, Section Heading, Crosstab, and Nested Crosstab) Reports and represented data graphically by Charts utilizing Query Studio.
• Formalized the reporting process by creating the technical specification and requirement specification.

Environment: Cognos (8.3, 8.4), SQL Navigator(4.4), Oracle discoverer, Oracle, PL/SQL, SQL Server, Transformer (8.4), Framework Manager (8.4), Microsoft Excel, Microsoft Visio, Report Studio, Query Studio.

Confidential, Bloomington, IL

Senior Cognos Consultant

Responsibilities:

• Work with project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
• Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
• Proven experience building ad-hoc and complex reports using prompts and parameters in Report Studio and Query Studio.
• Validate the report in content store for the changes.
• Involved in designing Models using Framework Manager.
• Moving applications from one server to other using Deployment Manager.
• Involved in setting up sign-on for Groups/Roles to secure the Models and packages.
• Also involved in planning a model which help the business in making suitable decisions.
• Created complex reports based on business user requirements.
• 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 custom prompted reports in Report Studio, Bursting reports to different user groups.

Environment: Cognos 8.4 BI, Cognos 8.3 MR2, Cognos 7.x, Impromptu, Solaris, IWR, Power Play, Upfront, Framework Manager, Oracle, SQL Server, PL/SQL, Windows 2000, Microsoft Excel, Microsoft Word.

Confidential, Clinton, MA

Cognos (BI) Developer

Responsibilities:

• Installed and configured Cognos 8.2 in Dev and Cognos 8.3 in Multi server Distributed Environment.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.
• Created multiple Dashboard reports for multiple packages.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Migrated Reports from Cognos 8.2 to 8.3.
• Install Cognos 8 on Solaris operating system.
• Initiated for the users to do ad-hoc reporting using Query Studio.
• Extensive experience on Structuring Metadata and Cognos Models using Framework Manager.
• Provided support for slowly changing dimensions in data marts.
• Designed and Prepared a Material for the Users.
• Created List Reports, Cross tab Reports and Control Charts.
• Thorough knowledge of Cognos 8 architecture and administration functions including Content store, Framework Manager, and Report studio/Analysis/Query Studios /Metric Studio reports development.
• Implemented Security for Data access, Object level access and Package access.
• Used Cognos Connection extensively for organizing, security, scheduling and distributing reports.

Environment: Oracle 10g, SQL Server 2005, Cognos 8.2, Sun Solaris, Data Manage, Power Play Transformer 7.3, Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection)

Confidential, Parsippany, NJ

Cognos Consultant

Responsibilities:

• Managed Product data by developing Framework Manager Metadata Model in Cognos 8 MR2.
• Developed Relational Model as well as Dimensional Model (DMR) with use of hierarchies for advanced functions.
• Created various complex reports in crunch time to meet the deadline. Reports included complex calculations using various functions, filters and multiple HTML formatting.
• Tuned the performance of the reports by using the metadata compression method.
• Created Templates by gathering Requirements from Business Analysts.
• Created Dashboard reports for business users.
• Developed Standard Reports, Charts, and Drill through Reports, Master Detail Reports and Bursting Reports using Report Studio.
• Developed reports with Prompt pages with HTML items, Multiple Report Pages with Page Breaks and Conditional Variables.
• Fixed the errors in year end critical Ad-hoc Reports.
• Provided Production support for managed reports and the users Ad-hoc reports.
• Created job aids for Business users in Query Studio, Analysis Studio and Cognos Connection.

Environment: Cognos 8 BI, Analysis Studio, Event Studio, Framework Manager, Metrics Studio, Cognos Connection, Report Studio, Query Studio, Cognos Configuration Manager, Content Manger, Cognos Architect, Windows 2000, Oracle 9i, PL/SQL.

Confidential, Alpharetta, GA

Cognos Consultant

Responsibilities:

• Involved in Installing and Configuring ReportNet Server, Framework Manager.
• Involved in understanding the Business and all Departments within SSA Global.
• Involved in Strategic Planning for Cognos ReportNet Framework Model.
• Built Models and published Packages utilizing Framework Manager.
• Created database connections for different data sources.
• Created Reports (Simple & Complex) using Query Studio and Report Studio for purpose.
• Created, organized and formatted reports, folders and other contents on Cognos Connection portal.
• Created several different types of Professional Reports (Mailing Labels, Web Page Style, Cascading, Linked / Drill Through, Production, Ranking, etc) with complex formatting utilizing Report Studio.
• Produce Queries and Reports in Multiple Languages. Format, Present and Distribute Reports utilizing different Layouts, Multiple Report Objects and Multiple Logical Pages.
• Create Run, and Schedule Reports and Jobs using Cognos Connection.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos connection.

Environment: Cognos ReportNet 1.01, Framework Manager, Cognos Connection, Report Studio, Query Studio, Microsoft Access, Microsoft Excel, MS SQL Server 2000.

Confidential, NY

Cognos Consultant

Responsibilities:

• Extensive interaction with Business Users and gather information and requirements.
• Developed and created classes with Dimension & Measure Objects and specified the hierarchies.
• Installed and configured Cognos Power Play and Impromptu software.
• Participated in the development of catalogs, multiple queries with complicated reports and query definition files using various join and filter conditions in Impromptu.
• Created Dimensional Maps, Transformer Models, Power-Cubes and Drill through.
• Worked extensively with Power Play Enterprise Server and the Upfront in publishing the cube.
• Created Snapshots to minimize data processing when the network traffic for the database is heavy.
• Involve in creating the catalogs for the impromptu reports.
• Created Reports using multiple data providers like Packages, Personal data files, Stored Procedures and Free Hand SQL.
• Optimized Catalog by using Database Interaction, Client/Server balancing, and Database functions, Table Weighting and Qualification, Governors Settings.

Environment: Cognos Impromptu 6.06, Cognos Power Play 6.6, Cognos Transformer, Cognos Power Play Enterprise Server, Access Manager, Cognos Upfront, SQL *Loader, Oracle 9.0, Windows NT/2000.

Confidential

Programmer Analyst

Responsibilities:

• Developed data specific Impromptu reports with various filter conditions.
• Developed drill through reports to provide attention to details and analyze the business data.
• Improved the usability of the reports by creating prompts and filters.
• Created and maintained User Profiles in the Catalog to administer security.
• Used Access Manager to provide security to the Cognos applications.
• Published Impromptu, Power Play reports and cubes on the web.
• Time scheduled the report publishing using the scheduler.
• Troubleshooted the IWR reports.
• Coordinated the server migration process of the Impromptu, Power Play reports and the Cubes.

Environment: Cognos Series 7.0 (Impromptu, Power Play, IWR Server, Transformer, Upfront, Access Manager), Sybase, SQL Server and Windows 2000.