SUMMARY:

• 10+ years of IT experience in software design, development, testing, maintenance and Delivery.
• 7 + years in Cognos (BI), Data Warehousing, Data Modeling, Websphere, Informatica (ETL), Decision Support Systems (DSS) and Customer OLAP application development in Windows and Unix
• Worked in a Data Warehouse and Business Intelligence Projects, Informatica (ETL), Cognos Impromptu, Powerplay, Matrics Manager, CognosTM1, Cognos Planning, Cognos Architect, Vizualizer and ReportNet1.x/Cognos8.1/8.2/8.3/8.4.
• Expertise in Cognos 6.x/7.x/8.x, Business Objects, Crystal reports, SAS, MS - Analysis Reporting, Datastage, Data Manager and Informatica.
• Expertise in Relational Database Management System (RDBMS) and Data Modeling.

TECHNICAL SKILLS:

OLAP/BI Tools: Cognos10/8, cognos reportnet1.0/1.1, cognos planning, Cognos Cognos Impromptu Administrator 6.x/7.x, PowerPlay 6.x/7.x/8.X, Upfront, Powerplay Transformer7.X/8.XAccess Manager, Impromptu Web report Server (IWR), Powerplay Enterprise Server, Metrics Manager, Scheduler, visualizer, Cognos Migration Utilities, Macros, TM1,ReportNet1.x/8.x (Framework ManagerReport Studio, Query Studio, cognos configuration, and Cognos SDK) and, Microsoft Access, SSIS, SSRS Crystal reports, OBIEE, and Business Objects.

ETL Tools: Datastage, Data manager, Decision stream, Abinitio, and Informatica.

Languages: Java, Java Script, HTML, XML, VB 5/6, VB Script, SQL, PL/SQL, T-SQL and C

O/S: UNIX, Sun Solaris, UNIX shell scripting, Windows 98/NT/2000

GUI: Developer/2000 (Forms 4.5/5.0, Reports 3.0/2.5), VB and PB.

ERP: Oracle Financials 10.x/11i (GL, AR, AP, OE, and AOL), SAP and Peoplesoft.

Other Tools: Actuate Developer Workbench 4.0, SQL* Loader, SQA suite, Erwin, and Toad

Web Servers: IIS, and Apache

Navigation Tools: Toad, Quest central for DB2, SQL Analyzer, SQL Navigator, and Teradata SQL Assistant

Security: LDAP and Cognos access manager

Error Tracking Tools: HP Open View, and Clear quest

Version Control: CVS, and VSS

RDBMS: Oracle 7.x/8.x/9.x/10g, Sybase, SQL Server 6.x/2000/2005/2008, DB2, Teradata6.5/12.0/13.0, and MS Access

PROFESSIONAL EXPERIENCE

Confidential

Sr .Cognos BI Solution Architect

Responsibilities:

• Worked on requirements gathering, analysis, design, and documentation
• Created Meta data models for reporting using Framework Manager.
• Crated Data source query subjects, Model query subjects and stored procedure query subjects based on the business logic.
• Created Packages and published into Cognos portal.
• Worked on DMR models in Cognos Framework manager, and powerplay cubes
• Created various reports List Reports, Grouped Reports, Cross-tab Reports, Chart Reports, and Drill-Through Reports using Report Studio.
• Improved the query performance using Governor tab.
• Created Model Filters, Query Filters, User access filters Detail filters, Summary Filters, Prompts, Parameters and Calculations.
• Created Ranks and conditional formatting in reports and enabled multi lingual feature.
• Published Power play cubes to Cognos 10 and created various reports using analysis studio.
• Worked on Cognos(Single signon, and e-Directory) security. For package level, Data, object level security
• Worked on various impromptu reports and catalog security.
• Hands on knowledge on Impromptu catalogs to cognos 10 migration.
• Responsible for Setting up Groups/Roles to secure the Models and packages
• Expertise in BI scorecards, and dashboards design, and development
• Leading team, and user training with cognos suite.
• Responsible for requirement, and technical documentation.
• Responsible for creating Content store, installations and Configurations of the ReportNet
• Responsible for the gap analysis, technical design, implementation, and deliverables.
• Co-ordinate with developers, distributes work, and report reviews.
• Active Team Player with Cognos Framework Manager design, and publish Package in the Cognos Portal.
• Proficient with Relational data modeling in the Framework Manager for Analysis Studioo reporting.
• Responsible for the cognos security, and deploy reports from development to SIT, UAT and production.
• Responsible for the cognos/Cognos reportnet infrastructure and installations.
• Created impromptu query definition (iqd), power cubes, and published into the cognos connection portal.
• Responsible for Server Administration, Report Administration, and production related issues.

Environment: Cognos 8/10 (Framework Manager, Report Studio, Analysis Studio, Query Studio, cognos configuration), Oracle10g, SQL Navigator, Erwin, Abinitio (ETL), Java, Windows, UNIX, Cognos SDK, Power play Transformer, PPES, LDAP and MS

Confidential, IL

Sr. Cognos Report net developer/Administrator

Responsibilities:

• Responsible for the requirement gathering and technical design.
• Proficient with operational (RDBMS) Database schema, data modeling and Data Warehouse methodologies.
• Responsible for creating Content store, installations and Configurations of the ReportNet
• Imported Metadata from source database to Cognos ReportNet Framework Manager.
• Responsible for Cognos application security, and administration.
• Analyzing metadata relationship and Provided Cardinality in the Framework Manager database layer
• Built the Frame work Manager Models and Packages in the Presentation layer.
• Published packages from ReportNet Framework Manager to Cognos connection server.
• Created folders, filters, prompts, and calculations in Framework Manager and also in the Report Studio.
• Worked on Standard Reports in Report Studio and Ad-hoc reports in Query Studio for users.
• Expertise on creating and analyzing the complex reports(Cross tab, drill-thru reports, Tabular SQL, Prompts, filters, and calculations)
• Expertise with writing SQL queries for testing report data.
• Responsible for migration, and deployment
• Worked on dash boards/graphical reports.
• Migrated reports from Impromptu to ReportNet.
• Involved in dimensional data modeling, Star Schema design using Erwin.
• Involved in the Installation and Configuration of Informatica 7.1.2
• Involved in fixing invalid Mappings, testing of Stored Procedures, Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Involved in testing of Informatica mappings.
• Created Workflow and run Workflows using Workflow manager.
• Loading the snapshot tables - detail and Summary through Informatica as per the Business rules defined for Extraction Process for the reference and Fact tables.
• Configuring and running sessions using Workflow Manager. Monitoring the sessions using Workflow Monitor.
• Reviewing the Target Data warehouse for Record counts, Transformations done, Data qualities issues and track the issues to closure.
• Creating scripts for Loading the error Master table and detailing out the Error capture strategies to the Team.
• Highlighting any data file issues with the source team, which will have an impact on the Data loading to the Data warehouse.

Environment: Cognos Series7.4, Cognos ReportNet1.1/Cognos8.3 (Framework Manager, ReportStudio, QueryStudio, cognos configuration, Analysis Studio, and ReportNet SDK), Oracle 9i, SQL, PL/SQL, PL/SQL Developer tool, Informatica7.1.2, TOAD, Windows NT/2000, Unix, and MS Office.

Confidential, Portland, Oregon

Sr. Cognos Reportnet Developer/Administrator

Responsibilities:

• Interact with the Business users for the requirement gathering.
• Understanding Database (Mainframe, SAP, and DB2) schema, data modeling and Data Warehouse.
• Analyzing and creating the functional specifications and technical specifications to implement business logic for the user requirement to generate Framework Manager models and Cognos reportnet reports.
• Responsible to Creating Content store, installations and Configurations of the ReportNet
• Worked on data security, and package deployment (exports and imports).
• Created and maintained Projects, Models, and Packages using Cognos ReportNet
• Analyzing and Define mappings to build the Frame work Manager Models and Packages with Query Subjects and Query items.
• Published packages from ReportNet Framework Manager to Cognos connection server.
• Created folders, filters, prompts, and complex business calculations in Framework Manager and Report Studio.
• Provided security to the ReportNet in the Framework Manager and cognos reportnet server and also access manager for Cognos series7.
• Worked on ReportNet Migration from SAP reports into the Cognos ReportNet reports.
• Worked on Standard Reports in Report Studio and Ad-hoc reports in Query Studio for users.
• Worked on bursting reports for the web users or email users.
• Expertise on creating and analyzing the complex reports (Cross tab, drill-thru reports, Prompts, filters, and calculations)
• Expertise with creating reports from the multiple data sources, and conditional formatting.
• Extensively worked on performance tuning in ReportNet.
• Expertise with creating page breaks, drill-thru, and master/detail reports
• Expertise with writing SQL queries and PL/SQL Stored procedures, functions.
• Importing power cubes from the powerplay enterprise server to reportnet cognos connection server.
• Created IQD’S with Cognos Framework Manager and created power cubes in Powerplay Transformer.
• Involved in report unit testing, and migration from QA environment into Production.
• Expertise with creating dash boards, pans/sheets/any graphical reports.
• Proficient with Visualizer tool for creating graphical presentation of the reportnet reports.

Environment: Cognos Report Net1.1 (Framework Manager, Report

Confidential, VA

Senior Consultant

Responsibilities:

• Interact with users for the requirement gathering.
• Analyzing the User requirement for report generation.
• Created calculated categories, special categories, leaf categories, rollup functions, dimensions, measures and data sources to generate Transformer models and Cubes.
• Worked on performance tuning to maintain fast performance of the cubes and Transformer models.
• Recommended to do the complex database calculations in the ETL/any RDBMS to improve performance.
• Generated Multi dimensional power cubes using Transformer models.
• View power cubes and developed Powerplay reports in Powerplay for Windows/Excel.
• Published Impromptu reports and Cubes on Upfront using Cognos Server Administration tool.
• Provided security to Cognos applications using Access Manager Administration tool.
• Involved in scheduling reports and cubes using Macros.
• Involved in ReportNet Installation and configuration.
• Exported Catalogs using Cognos migration utilities tool and imported .xml files in Framework Manager.
• Created Projects, Packages, and models in Report Net Frame Work Manager.
• Verified the relationships between query subjects in a Framework Manager for the improving performance.
• Experience with writing SQL queries in reportnet for performance tuning.
• Expertise with performance tuning like, minimize the calculations in the Cognos level, and restrict user privileges using governors in Framework Manager.
• Used to create namespaces for working with one/multiple data sources.
• Publishing packages from Framework Manager to generate ad-hoc/managed reports in Cognos connection using Query Studio/Report Studio.
• Worked on Complex reports like, cross tab, drill-thru, reports.
• Created calculated columns, filters, Model synchronization, and prompts.
• Created index for the fast performance of the reports.
• Responsible to create and maintain Content Manager, Content store, enabling LDAP/Series7/Network security, and Server configuration.
• Expertise with configuration and security in reportnet.
• Worked on design, develop, and test metrics based scorecards using Metrics Manager.
• Responsible to creating burst reports to distribute reports to the web users.
• Expertise with Migration from Impromptu to Reportnet.
• Working knowledge on upgradation and migration form Crystal reports to cognos.
• Worked on trouble shooting and performance tuning (Trouble ticket Analysis and Resolution) in Cognos.

Environment: Cognos EPseries 7.x, PP Enterprise Server, IWR server, Upfront, Visualizer,