SUMMARY

• Over 8+ years of IT experience including over 7+years in Cognos Business Intelligence, RDBMS and Data Warehousing.
• Cognos experience including: Report Studio, Query Studio, Analysis Studio, Metric Studio, ReportNet, Data Mart, Star Schema, Snowflake Schema, powerplay Transformer(7.3, 8.4.1 and 10, Macros, Determinants, Testing, Documenting and Implementation of Business Applications.
• Modeling experience in Framework Manager, creating and maintaining packages, design Relational and Dimensionally Modeled Relational (DMR) Metadata and maintenance of the metadata - model, developing reports, and training business users to develop reports.
• Experience in Cognos 10 Installation and Architecture.
• Working experience with Oracle 10g/9i/8i, SQL Server 2005/2000, PL/SQL, MDX Editing, SQL Plus, Erwin & ETL Informatica, Teradata, Hyperion, Data Loading, and DTS.
• Proficient with planning, design implementation, troubleshooting and performance tuning support of Cognos and SAP Business Information Warehouse Reporting.
• Performed Database and Server administration including Production support, Logical and Physical Design, Performance Tuning, Monitoring space usage, System configuration, Creating devices, Adding logins/users, Dumps/Recovery, Back up, Task scheduling on SQL 6.5/7.0.
• Responsibilities included analysis, design, development, testing and maintenance of the system.
• Strong experience in performing data analysis and translating business requirements into long term information architecture solutions.
• The lead reporting team that is responsible for deploying and developing business intelligence applications with the use of Cognos.
• Worked as accounting programmer using Cognos Impromptu, SQL, Cognos PowerPlay and Access VBA.
• Worked and Involved in migrating the reports from Webfocus to Cognos and Cognos to Business objects.
• Experience in OLTP/OLAP System Study, Analysis and ER Modeling, Maintaining Database Schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling.
• ExperienceinMS SQLServerdatabase adminactivities likeInstallation, Configuration, Database design, Backup & Recovery,Database Security,Performance tuning and Query Optimization.
• Worked onCognosSecurity Administration,third-party security providers likeLDAPandSun ONE.
• KnowledgeableinUNIXShell Scripting,XML, HTML, MDX.
• Has good experience in working with MDX Overview, Basic MDX, Advanced MDX and TEMPEffective MDX in Report studio and Transformer.
• Excellent in training the users.TEMPEffective Team player - Ability to work in teams.
• Excellent oral and written communication skills, analytic, problem-solving, multi tasking and interpersonal skills

TECHNICAL SKILLS

Business Intelligence Tools: Cognos 10,8.4, 8.3, MR2/MR1, Framework Manager, Cognos Connection, ReportNet, Report Studio, Query Studio, Analysis Studio, Event Studio, Datamanager, Dashboards, Powerplay Transformer(7.3 and 8.4.1), SAP HR/SAP BW.

Database & Tools: Oracle 10g/9i/8i, SQL Server 2008/2005/2000 , MS Access and TOAD, MS Access, SQL Plus, Sdk.

ETL Tools: Informatica 8.x/7.x, Data stage, SSIS 2008

Data Modeling: Erwin 4.x/3.x,Framework manager.

Operating Systems: Windows Solaris/NT/XP/2000/98.

Programming Languages: C, SQL, Java, C++, Microsoft Access, Excel.

Hardware: Installation & configuration (Informatica 7.1) and Operating system Troubleshooting.

Testing Tools: Manual Testing, Unit level testing.

PROFESSIONAL EXPERIENCE

Confidential, NEWYORK, NY

COGNOS BI LEAD

Responsibilities:

• Worked on complete life cycle of Cognos 10 Administration and Cognos BI (Installations, Security, Configurations, Migration and deployment.
• Worked closely with Clients and Business Users to analyze and understand business requirements and Participated in requirements gathering meetings / Sessions.
• Developed technical specifications, data identification and also recommendations on the preferred solution for development, and deploy efficient BI solutions
• Worked on technical design specs for Framework manager, and reporting per the requirements.
• Created project, namespace (Database View, and Business View), and folders and imported required metadata in Cognos Framework Manager.
• Created to new stars in DB2 based on the cardinality required.
• Provided cardinality, check data usage, identifiers in the database view.
• Created model query subjects, Datasource query subjects, stored procedure query subjects as per the business requirements in the Framework Manager
• Provided version control using CVS for FM Packages, and reports.
• Created schema prompts, required, optional prompts, perameter files, perameter mappings for automation using macros.
• Worked on multiple database, and multiple datasource in Framework Manager to generate reports
• Created standard reports in Cognos Report Studio, and Analysis Studio.
• Responsible to build the Framework Manager models and packages as per the business requirements.
• Published the Packages, and provided security in Framework Manager.
• Created folders, filters, prompts, and complex business calculations in Framework Manager and Report Studio.
• Worked on various reports like, List, Crosstab, drill-thru, multi-query, master/detail, prompted, dashboards, portlets, and tabular reports.
• Designed complex reports with union queries, and SQL queries
• Improved long running reports performance thru writing SQL queries, resolving complex joins in framework manager, filters, and using stored procedures.
• Wrote java scripts for report prompts automation.
• Expertise to understanding, analyze, Cognos, data warehouse(OLAP), and OLTP data
• Designed transformer models, and powerplay cubes using powerplay transformer.
• Worked on powerplay studio to slice/dice Cognos cubes,
• Worked on performance tuning to maintain fast performance of the cubes and Transformer models.
• Recommended to do the complex database calculations in the database to improve report query performance.
• Provided customer training in Report Studio, and Query Studio.
• Developed number of prototypes for the business users. This project was bases of star schema, OLTP data. Involved in multiple phases, which included requirement gathering, design, and development and unit testing.
• Responsible to provide tech support for Abbott customers, and also leading offshore team.
• Strong knowledge on data warehousing methodologies, and best practices.

Environment: Cognos 10/8.4, Report Studio, Framework Manager, Query Studio, Event studio, Powerplay Studio, Analysis studio, Powerplay transformer8.4, Teradata12.0, and Oracle10g, Informatica, Unix and windows.

Confidential, Indianapolis, IN

Senior Cognos BI Consultant

Responsibilities:

• Worked on complete life cycle of Cognos 10 Administration (Installations, Security, Configurations, Migration, and deployment.
• Worked closely with Clients and Business Users to analyze and understand business requirements and Participated in requirements gathering meetings / Sessions.
• Developed technical specifications, data identification and also recommendations on the preferred solution for development, and deploy efficient BI solutions
• Worked on technical design specs for Framework manager, and reporting per the requirements.
• Created project, namespace (Database View, and Business View), folders and imported required metadata in Cognos Framework Manager.
• Provided cardinality, check data usage, identifiers in the database view.
• Created model query subjects, Datasource query subjects, stored procedure query subjects as per the business requirements in the Framework Manager
• Provided version control using CVS for FM Packages, and reports.
• Created schema prompts, required, optional prompts, perameter files, perameter mappings for automation using macros.
• Worked on multiple database, and multiple datasource in Framework Manager to generate reports
• Created standard reports in Cognos Report Studio, and Analysis Studio.
• Responsible to build the Framework Manager models and packages as per the business requirements.
• Published the Packages, and provided security in Framework Manager.
• Created folders, filters, prompts, and complex business calculations in Framework Manager and Report Studio.
• Worked on various reports like, List, Crosstab, drill-thru, multi-query, master/detail, prompted, dashboards, portlets, and tabular reports.
• Designed complex reports with union queries, and SQL queries
• Improved long running reports performance thru writing SQL queries, resolving complex joins in framework manager, filters, and using stored procedures.
• Wrote java scripts for report prompts automation.
• Expertise to understanding, analyze, Cognos, data warehouse(OLAP), and OLTP data
• Designed transformer models, and powerplay cubes using powerplay transformer.
• Worked on powerplay studio to slice/dice Cognos cubes,
• Worked on performance tuning to maintain fast performance of the cubes and Transformer models.
• Recommended to do the complex database calculations in the database to improve report query performance.
• Provided customer training in Report Studio, and Query Studio.
• Developed number of prototypes for the business users. This project was bases of star schema, OLTP data. Involved in multiple phases, which included requirement gathering, design, and development and unit testing.
• Responsible to provide tech support for Abbott customers, and also leading offshore team.
• Strong knowledge on data warehousing methodologies, and best practices.

Environment: Cognos 10/8.4, Report Studio, Framework Manager, Query Studio, Event studio, Powerplay Studio, Analysis studio, Powerplay transformer8.4, Teradata12.0, and Oracle10g, Er-Win, HP Openview, CVS, Windows 2003 server, MS-ADS(LDAP), Unix and windows.

Confidential, Saint Louise, MO

Senior Cognos BI Consultant

Responsibilities:

• Involved in installing 8.4.1 version of Cognos transformer.
• Creating Cognos Configuration for the dispatchers servers.
• Created Access manager for batch maintenance of users and user classes.
• Worked as admin for security systems.
• Imported all cubes from 7.3 Transformer to 8.4.1. Transformer version.
• Used 7.3 catalogs to convert into 8.4 catalogs and created models in frame work manger and published the packages.
• These packages are used to create data sources in Report studio.
• The Iqds are removed and placed new data sources from report studio.
• Changed the data sources has Report studio.
• Cubes are Created in 8.4.1 transformer and published them to Cognos connection (verified the out puts in analysis studio).
• The cubes created in 8.4.1. Transformer is send into two dispatchers to see the mdc files in powerplay .
• Automation of cubes is made using commands.
• Created batch scripts for cleaning logs, building cube, refreshing the cubes, scheduling and publishing the package.
• Created Trigger file to run this Automation.
• When data ware house gets refreshed the cube should automatically gets refreshed and publish the packages.
• This makes all the reports and dashboards which are using this package get new data every day.
• Set up Data, object and Package security in Framework Manager.
• Created Query Subjects, Query Items which are not present in Data warehouse.
• Report Bursting is done on some reports based on particular columns.
• Constant detecting and fixing various issues that arise from changes at server, package, & database level, appropriately using best practice
• Createdthe Jobs andscheduledthe Jobs.
• Has good experience in working with MDX Overview, Basic MDX, Advanced MDX and TEMPEffective MDX in Report studio and Transformer.
• Create reports in Report studio and query studio worked on Company internal dashboard Projects
• Published developed Packages on to Cognos Connection
• Diagnose and resolve application bottlenecks and performance issues.
• Worked as admin for security systems.
• Performance tuning and maintenance of numerous Cognos reports against new business requirements.
• Extensive testing and Manual alteration of complex SQL before including them in Cognos Queries and enhancing its performance.
• Created new Query Subjects and arranged in different Folder Structure for Business View.
• Involved in Testing and exploring new tools Report Studio and Query Studio (Report Net).
• Developed standard reports, Charts, Drill through Reports, Drill up, Drill down Reports and Multilingual Reports using Report Studio and Query Studio.
• Create Query Prompts, Calculations, Conditions, and Bookmarks & Filters.
• Develop Prompt pages and Conditional Variables.
• Finally reports are assembled and fixed in Dashboards views and scorecard views.
• Good at writing scripts in java for buttons, prompts, and reports automation.
• Reports are made in smart phones on Daily bases with monthly reports and weekly reports
• Applications are made for iphone, and used Cognos reports to open them in phones

Environment: IBM Cognos 8.4.1 - Report Studio, query studio, Analysis Studio, Framework Manager, Metric studio, Sql Server,DB2, Datamanager, java, Unix Shell Scripting, Oracle, Informatica, Windows XP, IBM Info sphere Cubing Service, Cognos Dash Board,7.3 transformer,8.3 transformer and 8.4.1 transformer, Cognos Impromptu 7.1, Cognos Impromptu 7.3.

Confidential, LONG ISLAND, NY

Cognos BI Consultant

Responsibilities:

• Major tasks include design and preparation of project plan and provide Business Intelligence Solution using Cognos 8.
• Used Cognos Connection as Web Portal for managing reports.
• Used Cognos 8 Report Studio to create Professional Reports & Query Studio to create Ad-hoc Reports.
• Creation of Models, Project and Publishing Packages using Framework Manager.
• Set up Data, object and Package security in Framework Manager.
• Created Query Subjects, Query Items which are not present in Data warehouse.
• Report Bursting is done on some reports based on particular columns.
• Published developed Packages on to Cognos Connection.
• Created Jobs and scheduled the reports to run at a particular time and emailed the same to users.
• Creation of Complex Multi-Object Reports using Lists, Charts, Crosstabs, Images using Report Studio.
• Involved in creation of Prompts and Cascading of Prompt pages and also applied Conditional Formatting for reports
• Cognos decision stream experience worked on dimensional framework, transformation model and handled slowly changing dimensions.
• Created different type of report formats like PDF and Excel 2000.
• Developed Standard List reports and Crosstab reports.
• Involved in migration of report from Cognos to business objects.
• Implemented Drill Through and Prompts for better utilization of reports.
• Created power play cubes using Transformer (Power Play).
• Drill-through is done from Cognos cubes to ReportNet reports and also dynamic generations of Ad-hoc reports are done using drill-through.
• Worked with editing SQL and .MDX in Report studio.
• Used compound data sources and consolidated data in order to trim down cube size and improve performance.
• ExperienceinMS SQLServerdatabase adminactivities likeInstallation, Configuration, Database design, Backup & Recovery,Database Security,Performance tuning and Query Optimization.
• Worked onCognosSecurity Administration,third-party security providers likeLDAPandSun ONE.
• KnowledgeableinUNIXShell Scripting,XML, HTML.
• Java scripts for batch files,trigger, and automation.
• Active participation in all aspects ofQualityAssuranceandin providing24 x 7production support.
• Involved in Migration of Cognos 8.2 to Cognos 8.3 using Migration Utility.
• Created Graphs and charts in metric studio.
• Bursting of reports is done and separated the reports for different sections of the company.
• Finally reports are assembled and fixed in Dashboards views and scorecard views.

Environment: IBM Cognos 8.4.1 - Report Studio, query studio, Analysis Studio, Framework Manager, Metric studio, Sql Server,DB2, Access, hyperion, XML, Datamanager,, TERA DATA, Windows XP, IBM Info sphere Cubing Service, Cognos Dash Board.

Confidential, New York

Cognos consultant

Responsibilities:

• Create Metrics Dashboard from scratch that included Drill-Through, Bookmarks, Filters, Calculations, Query Joins, Stored Procedures, Graphs, Crosstabs, Lists, Conditional Formatting, Conditional Blocks, and Master Detail Relationship.
• Worked with Oracle 10g/9i/8i, SQL Server 2005/2000, PL/SQL, SQL Plus, Erwin & SQL, Data Loading.
• Optimization by modifying the Query Subject Relationships.
• Migrated reports from webfocus to Cognos.
• Responsible for SD security set up and testing.
• Designed and tested "Sales Order, Service Order, Shipping, Billings, and EDI Inter-Company" processes.
• Layout design for "Customer Invoice, Sales Order, Delivery Notes, Quotes".
• Liaison with ABAP programmers for advanced configuration.
• Worked as admin for security systems and Toad.
• Worked on Cognos architecture, Web server, App server, CM server and VMware.
• Used power play transformer for creating the cubes.
• Frame work manager for creating package.
• Made Data Mart/Data Warehousing design recommendations for enhancements and alterations, based upon issues discovered during business requirements
• Create and maintenance of Dashboard that contains 80+ queries.
• CreatedDash boardsto unit data from different core areas such as sales, finance, logistics, Inventory management, in order to get a dynamic, real-time multi-department picture.
• Modeling of new subject areas to support reporting deliverables.
• Constant detecting and fixing various issues that arise from changes at server, package, & database level, appropriately using best practices.
• Creating new Jobs using Cognos Connection.
• Worked on Cognos Security Administrator (CSA) to restrict User access.
• Scheduled reports through Schedule Management in Cognos Connection.
• Maintain user accounts, mapping of security to groups, roles and folders and tabs on the portal.
• Use of predefined Cognos roles, and create new roles according to users’ specific business objects.
• Introducing new concepts of making Queries run faster and more efficiently by using new Cognos concepts and working closely with Database Team.
• Performance tuning and maintenance of numerous Cognos reports against new business requirements.
• Extensive testing and Manual alteration of complex SQL before including them in Cognos Queries and enhancing its performance.

Environment: IBM Cognos 8.4.1 - Query Studio, Report Studio, Analysis Studio, Framework Manager, Metric studio, Sql, DB2, Access, XML, java, Datamanager, Business objects, SQL\ MDX.SAP HR/SAP BWDATA, Windows XP, IBM Info sphere Cubing Service, DB2

Confidential, Atlanta, GA

Cognos consultant

Responsibilities:

• Diagnose and resolve application bottlenecks and performance issues.
• Worked as admin for security systems.
• Used, TERA DATA, Web server, App server, CM server and VMware,
• Created Packages using Cognos 8 Framework Manager models and published.
• Designed Star & Snowflake Schema in Framework Manager from various database tables.
• Created ad-hoc and complex reports using Query Studio and Report Studio.
• Used Metric studio, power play transformer for creating Cubes.
• Advanced Cognos Administration like Server, Content and Portal.
• Scheduled Reports through Schedule Management in Cognos Connection.
• Bursting the reports in to different sections is done.
• Server Administration including managing, monitoring and tuning Cognos 8 dispatchers.
• Specify Security Settings after installation, modifying its initial access permissions by granting and denying access to users using business objects.
• All reports were brought in to Dashboards and brought in to good view as per Client.
• Created average Summary and Percentage and user defined Calculations, user friendly Filters, Prompts, Cascading Prompts, Conditions & Bookmarks.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection, to run on daily, weekly, monthly, & quarterly basis.
• Creating Query Prompts, Calculations, Conditions, Bookmarks & Filters.
• Created Catalogs and established the connections to the database in Data Manager. Applied many logical filters to the data while loading into the target.
• ImplementedSecurityinCognosConnection by creating User Groups, Users and assigning privileges to various Users for accessing Reports.
• Createdthe Jobs andscheduledthe Jobs.
• Created scripts using java, UNIX.
• Involved in Migrating reports.
• Involved in testing anddocumentationandmaintainedtheBI environment.
• Worked on Informatica Power Center - Designer, Workflow Manager and Workflow Monitor. Developed number ofComplex Informatica Mappings, Mapplets and Reusable Transformations to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Used Expression, Filter, Joiner, Lookup, Router, Aggregator and Update Strategy transformations.

Environment: Cognos 8.2,8.1 - Metric studio, Query Studio, Report Studio, Analysis Studio, Framework Manager, DB2, Sql, Powerplay Transformer, Cognos Connection, java, Hyperion, Toad, Scheduler, Access, XML, Erwin 3.5.2, PL/SQL, ETL Informatica Power Center 7.x, Windows Solaris, Oracle 9i/8i, Datamanager, Dashboards.

Confidential, Jersey City, NJ

Cognos Developer

Responsibilities:

• Created Packages using Cognos 8 Framework Manager models and published them to the server.
• Designed Star flake & Snowflake Schema in Framework Manager from various database tables.
• Created ad-hoc and complex reports using Query Studio, Report Studio & Analysis Studio.
• Scheduled Reports through Schedule Management in Cognos Connection.
• Customize the appearance of Cognos 8 Web interface by using styles.
• Responding to user based errors on all applications that has been built by the development function of IT, TERA DATA.
• Powerplay transformers are used to create cubes and metric studio is show critical and charts.
• Keeping track of ongoing bugs and application errors with the goal of elimination.
• Adherence to the insurance companies’ change management policy, which is based on changing laws and/or industry best practice.
• Involved in extensive documentation and report specification, which was subject to approval by the client before design?
• Work closely with ETL team in development of data marts, and for enhanced overall data warehouse design.

Environment: Cognos 8.1, Query Studio, Report Studio, Framework Manager, Cognos Connection, Power play Transformer, Dashboards, Teradata, Java, Unix shell scripting, Metric Studio, SAP HR/SAP BW, SQL Server 2005, ETL Informatica Power Center 7.1, Windows 2000, Scheduler, XML, Toad.

Confidential, New York, NY

Cognos Developer

Responsibilities:

• Created Fact and Dimension Tables in Star Schema in Framework Manager
• Created and published packages in Framework Manager.
• Created ad hoc and complex reports using Query and Report Studio
• Query optimization by modifying Query Subject Relationship, among other Framework Manager related tasks
• Created List and Crosstab Reports in Report Studio from scratch which included Prompts, Filters, Drill Through and Calculations.
• Developed several reports involving multiple Prompts, Cascading Prompts, Conditional Formatting, Filters, Page Breaks, resulting in significant decrease of redundancy and increase in accuracy of data presented
• Created Jobs for Schedule Management.
• Used Repeater Table to group data appropriately and to manipulate the display of repeated cells by specifying limits.
• Identified the dimensions, hierarchies and performance measure for Analytical requirements. Designed the Transformer Model and build thePower Play OLAP CubesusingPower Play Transformer
• Implemented dimensional based security in cubesusingAccess Manager.
• ScheduledandDistributedreports through Schedule Management in Cognos Connection. Involved in Production Support

Environment: Cognos 8 MR1 - Query Studio, Report Studio, Analysis Studio, Framework Manager, Windows 2000, Microsoft Access, Oracle 8i,Informatica.

Confidential, New Jersey, NY

Cognos Developer

Responsibilities:

• Testing and improving Report Performance.
• Performance tuning is done.
• Worked in admin part.
• Participated in meetings with users to get business requirements and understand the reporting needs.
• Built models using Framework Manager.
• Created Joins at Report & Framework Manager level as per users’ requirements.
• Updated database tables to accommodate the change in reporting requirements and time constraints.
• Change Level Span as the grouping level would need to be altered.

Environment: Cognos ReportNet 1.1 MR1 - Query Studio, Report Studio, Framework manager, Excel, Cognos Metrics manager 2.2, SDK, XML, SQL Server 2000, Cognos Connection, Windows 2000

Confidential

Cognos Developer

Responsibilities:

• Used Metric studio, power play transformer for creating Cubes.
• Advanced Cognos Administration like Server, Content and Portal.
• Scheduled Reports through Schedule Management in Cognos Connection.
• Bursting the reports in to different sections is done.
• Server Administration including managing, monitoring and tuning Cognos 8 dispatchers.
• Specify Security Settings after installation, modifying its initial access permissions by granting and denying access to users using business objects.
• All reports were brought in to Dashboards and brought in to good view as per Client.
• Created average Summary and Percentage and user defined Calculations, user friendly Filters, Prompts, Cascading Prompts, Conditions & Bookmarks.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection, to run on daily, weekly, monthly, & quarterly basis.
• Creating Query Prompts, Calculations, Conditions, Bookmarks & Filters.
• Created Catalogs and established the connections to the database in Data Manager. Applied many logical filters to the data while loading into the target.
• ImplementedSecurityinCognosConnection by creating User Groups, Users and assigning privileges to various Users for accessing Reports.

Environment: Cognos, Informatica 7.1 (Designer, Workflow Manager, Repository Manager), Oracle 9i, Windows XP Professional.