SUMMARY

• Over 7 years of IT experience in Cognos 10.2/10.1.1/8.4 , 8.3,Cognos Report Net, Framework Manager, Query Studio, Report Studio, Analysis studio, Metric Studio and Cognos Connection.
• Expertise with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
• Proficient in developing reports application employing Cognos 8 / Cognos 10.1 Componets like Framework Manger, Reports studio, Query Studio, Business Insight, Business Insight Advanced, Metric Stuido and Cognos Connection.
• Worked in BI for major health insurance and financial companies.
• Hands on experience in Report building (Crosstab, List, Dashboard reports) using Report Studio and Analysis Studio.
• Experience developing complex reports using drill - through reports, prompts, dashboards, master-detail, burst-reports, dynamic filtering in Cognos.
• Expertise in creating Dashboard reports using Java Script in Report studio.
• Experienced in building scorecard reports and dashboard reports using Metric studio.
• Expertise in building Multidimensional Cubes,Scorecards, Dashboards and Report Studiocomplex reports for higher management.
• Experience in Extraction Transformation Loading (ETL) Process,Creation of Data Marts using Decision Stream and Informatica.
• Developed dimensional data marts using Informatica/Cognos Data Manager.
• In-depth knowledge on SQL queries and working with SQL Server 2000/2005/2008.
• Extensive experience with Cognos security (LDAP, Active Directory, Access manager, object level security, data security).
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8.X Environment.
• Profound knowledge in Transformer model design and Power play Cube building
• Extensive experience on production support and troubleshoot/test issues with existing reports and cubes.
• Good understanding of data warehousing and ETL ( Extraction, Transformation and Loading) tools like Data Manger, including good knowledge of dimensional modeling.
• Ability to translate business requirements into technical specifications and interact with end users to gather requirements for reporting and trained them in Ad-hoc components.
• Implemented Tree Prompt, complex dimensional reporting using the MDX commands in Cognos.
• Work Experience on multiple platforms like Windows XP, Windows 2000/NT, Sun Solaris, IBM AIX, Unix shell scripting.
• Good interaction with clients, understanding Business Applications, Business Data Flow and Data Relations.
• Excellent understanding of Software Development Life Cycle and dimensional modeling techniques using Star and Snow-flake Schema Modeling
• Worked extensively on transformer in creating multidimensional cubes and developed power play reports to be published in report net server
• Strong knowledge on Internet based reporting and strong Analytical skills and attention to detail
• Providing support during theUser Acceptance Testing.
• Good experience in working with web servers like IIS, Apache, IHS etc.
• Excellent team player and Superior organizational and time management skills
• Excellent Inter-personal skills and a quick learner. Ability to get along with the team well, proven leadership qualities and client co-ordination.

TECHNICAL SKILLS

BI Tools: Cognos 10.2.1/10.1.1/8.4.1/8.3 , Report Net 1.0/1.1(Report Studio, Query Studio, Cognos connection, Framework Manager), Cognos Impromptu 7.x, Cognos Transformer & Power Play7.3/7.4, Impromptu Web Reports (IWR),Cognos visualizer 7.0, Cognos Query, Metric Studio, Cognos Upfront, Cognos Power Play, SQL server reporting services(SSRS),SQL Server Analysis Services(SSAS),MS Excel 2007.

ETL: Informatica Power Center 8.x, SQL Server Integration Services (SSIS).

Databases: Oracle 11g,10g,9i, MS SQL server, MS Access, DB2.

Database Tools: TOAD, SQL Server Management studio, Enterprise Manager.

Data Modeling: ER/Studio 3.5/4.0, Erwin 4.1

Languages: C, C++, SQL, PL/SQL, T-SQL, HTML, JavaScript and XML.

Web Servers: Apache web server, Microsoft IIS 4.0

OS: Windows 2000, Server 2003, XP, VISTA, Windows NT 4.0, Linux, Unix.

Other tools: Microsoft office suite

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Cognos Consultant

Responsibilities:

• Gathering functional requirements from business customers, analyzing and transforming them into business intelligence reporting specifications.
• Developed Technical Design Documents.
• Developed logical & physical modeling as per business requirements using ERWIN 3.5
• Designed and developed snowflake/starschemas for better understanding of models using ERWIN.
• Developed ADR catalog using Cognos Impromptu 7.x.
• Designed DMR models in Framework Manager.Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• Created list, crosstab and drill through reports for departments like claims, billing, members/subscribers in Report Studio
• Involved in creating IQD Files from Report net and designed power play models in Transformer.
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.
• Created BurstReports and MultilingualReports based on groups of users &Preferencesfor our Asian, African and European partners
• Created Drill Through Reports & Master Detail Reports for Accounts Department.
• Used Union, Intersection for creating queries.
• Created dashboards, portlets for various HR and payroll related reports. E.g. investments related to 401K plan were displayed as dashboards showing their investments, returns, losses, dividends earned, etc.
• Developed reports on risk analysis by comparing the internal data with the Experian risk analysis data. This enabled the Sr.management to take better risk decisions.
• Created complex reports that had multiple pages, with multiple lists, charts, graphs, etc.
• Created complex reports in Cognos mainly dealing with Member Data, Claims data and Provider Data.
• Created score cards using Metric Studio.
• Wrote Procedures and triggers in Oracle for file handling, data validation, Inserting data etc.
• Wrote and executed the test cases for various reports that were developed in Cognos.
• Involved with making changes in the reports generated as business requirements changed and carry out validation and verification of the reports.
• Created models in Transformer, built cubes and published cubes to Analysis Studio
• Carried out performance tuning of reports, model and database. (Indexes, partitions)
• Interacted with ETL team to gather the requirements for the reporting.
• Involved with the Solutions Architect and the QA team for validation and verification of the development.
• Worked on a POC for 10.2.1 dynamic cubes which is an In-memory technology that got introduced in the new version. This is in par with transformers with better performance.
• Exceptionally good and experienced in handling the problem and troubleshooting.
• Trained End users to operate the reports.

Environment: Cognos 10.2.1/ 8.4, Transformer 8.4, Report Studio, Cognos Impromptu 7.x, Query Studio, Metric Studio, Oracle 10g, Erwin 4.0, Power Play Enterprise Server, TOAD, PL/SQL, Data stage, UNIX.

Confidential, Washington, DC

Cognos Developer

Responsibilities:

• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Involved in gathering business requirements.
• Analyzed the business requirements and developed a model using Cognos framework manager and published packages for reports development.
• Developed list reports, crosstab reports and chart reports using report studio.
• Modified the prompt pages using HTML Scripts.
• Created Complex reports using Multiple Drill through, Conditional Layout.
• Developed Standard Reports, Charts, Drill Through Reports and Bursting Reports Using Report Studio.
• Created New Jobs using Cognos Connection.
• Scheduled Reports through Schedule Management in Cognos Connection.
• Defined, stored and maintained security information using Access manager.
• Coordinated all communications with the Database Management team.
• Unit testing of the reports to ensure the correctness of the data and responsible for resolving issues after QA testing.
• Developed, managed, and coordinated all user acceptance testing.
• Involved in training business users in Cognos Query Studio. Documented the whole reporting process.
• Used cognos Transformer to build multidimensional cubes and used it in Dashboards.
• Responsible for creating DMR model for simple adhoc reporting and analysis.
• Testing and improving Report Performance.
• Experience in writing SQL, T-SQL, PL/SQL Packages, Stored procedures, Functions, Triggers as per the business needs.

Environment: Cognos 8.4 Framework Manager, Cognos Impromptu 7.x, Report Studio, Query Studio,Transformer, Event Studio, Cognos Connection,Windows 2003 Enterprise Server, IIS Web server, oracle 10g.

Confidential, Newark NJ

Senior Cognos Developer

Responsibilities:

• Developed the Complex ADR catalog, Set up joins.
• Developed 150 reports along with the team by following the industry standards for formatting.
• Developed the complex State Group Cube with the Structure the Users wanted Transformer.
• Designed and Developed most complex Report named Monitoring and supported it.
• Maintained the access manger structure from Development to QA to Production
• Interacted with the users to gather the Powerplay requirements for Cubes. Developed the standard Powerplay reports.
• Interviewed business community to identify business, data, and delivery requirements.
• Designed models in Framework Manager.
• Updated & administered the security privileges at object level and data level for the user profiles in Framework Manager.
• Worked with Complex reports in Report Studio using master-detail relationship, drill through, burst options, cascading options and PROMPTS depending on user requirements.
• Created reports using cascaded prompts, value prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio
• Created reports containing multiple data containers like List, Cross-tab and Repeater tables
• Created dashboards for a managerial overview with drill up and drill down capabilities.
• Created models in Transformer, built cubes and published cubes to Power Play server.
• Scheduled reports using Cognos scheduler and emailed to various recipients as required.
• Worked on TOAD for Oracle database systems for creation of adhoc queries and for improving various performance issues.
• Experience with oracle as the target for the data marts.
• Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Test/validate system tables/files in System Test environment, UAT environment and finally in Production environment.
• Trained End users to operate the reports.
• Involved in monitoring Data stage jobs/processes and generating reports after successful job scheduling.
• Tuned performance of Data stage sessions for large data files by increasing block size, data cache size, sequence buffer length, and target based commit interval.
• Optimized and modified the triggers, complex store functions, procedures, user base data type.

Environment: Cognos 8.2, Transformer 8.3, Cognos Impromptu 7.x, Report Studio, Query Studio, Metric Studio, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX, Cognos 8 RTM SDK.

Confidential, Dallas, TX

COGNOS Developer/Cognos Administrator

Responsibilities:

• Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.
• Managed Core Project, Responsible for delivery and resource allocation etc.
• Creating Teradata views and imported views and employed relation between views.
• Developed DMR modeling using Cognos 8 Framework manager.
• Enhanced the model, Tested and Created replacement IQDs’ using Framework Manager.
• Created Dimension IQD’s and Fact queries in Frame work Manager.
• Created Projects, Models, and Packages using CognosFramework Manager and deployed packages on Cognos Connection.
• Installed and configured Cognos 8.2 BI and worked with Cognos 8 BI modeling, Report Studio.
• Responsible for Access permission and administrating the server.
• Created highly Customized reports in Cognos 8.2 Report Studio and some of the Ad-hoc reports in Query Studio.
• Used HTML and Java Scripts for Advanced reporting purpose.
• Created different packages which contains the information about the customer like,cust name,address,ph no,plan used,mins used,mins remaining,rollover minutes.
• Gathered information like attempted calls, type of call (long distance, local), length of call, originated number, destination number, rates, time of call for creating report for billing of a customer.
• Implemented security in reports according to employee groups and roles according to the requirement.
• Implemented data profiling and quality check in Data Manager
• Involved in Creating Content store, installation and Configurations of the Report Net.
• Implemented Tree prompt and MDX Commands in Cognos.
• Experience in Deployment (Export, Import) using Cognos Connection Portal in Cognos 8.2 and Report Net.
• Created folders, filters, prompts, and complex financial calculations in Framework Manager and Report Studio.
• Developed Portlets and dashboards reports according to the user requirements.
• Tuned cube builds Impromptu Reports and Report Net reports and servers for better performance.
• Migrated numerous existing Cognos 7.4 impromptu catalogs to Cognos 8.2 Framework manager.
• Implemented Data Security using LDAP in Framework Manager 8.2.

Environment: Cognos Report Net 8.1/8.2,Framework Manager, Report Studio, Query Studio, Analysis Studio), Transformer, Cognos Impromptu, LDAP, Access Manager, IIS, Informatica, PeopleSoft, server 2005,Oracle 9i,TOAD.

Confidential

Cognos BI developer

Responsibilities:

• Closely Involved in Requirement gathering and Analysis for developing OLAP analysis, Dashboards, Complex Reports, Data mapping using Reports Studio and Query Studio, Business models and Packages using Framework manager and cubes using transformer for end users.
• Build complex reports and queries using a Dimensional model modeling using Cognos Framework Manager.
• Created star schemas, snowflakes, dimensional modeling and reports were made using Cognos reporting tools.
• Supplemented regular prompts, cascading prompts, filters, Data Layouts, Conditional style, static headers, Drill Through, sub queries to add interactivity for users in Report Studio & Query Studio.
• Customized data by adding Filters, prompts, Calculations, Summaries and Functions using Cognos 8 Report studio, scheduling report on Cognos Connection.
• Developed complex report using Cognos 8 Report/Query Studio and create Logical and Physical design in Frame work Manager.
• Developed KPI’s, dashboards based on the combination of reports, spreadsheets and charts to check the company’s present position in the market and based on that reports we have given some investing ideas.
• Responsible for security designed like Data, Object and Packages security in Framework Manager.
• Scheduled reports in Cognos Connection based on the reports to run daily, weekly or monthly basis.

Environment: Cognos 8.2 Framework Manager, Report Studio, Query Studio, Event Studio, Cognos Connection, SQL Server 2008, UNIX, Apache web server, MS access.

Confidential

Cognos Consultant

Responsibilities:

• Participated in the full lifecycle of Decision Support System development including business function analysis, design documentation, data extraction process, DSS development.
• Design documentation of Data Dictionary.Data Modelling was done using Erwin.
• Worked in team to build Fact builds, Dimension builds, Jobstreams for catalogs at different stages of development for Maximus Catalog.
• Developed SQL stored procedures and implemented Jobstreams.

Environment: DecisionStream6.5, Impromptu7.0, Transformer,PowerPlay, Upfront, IWR, SQL Server 2000