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/Cognos 8.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, Teradata 6.5/12.0/13.0 , and MS Access

PROFESSIONAL EXPERIENCE

Sr .Cognos BI Solution Architect

Confidential, TX

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 teh 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 teh 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 noledge on Impromptu catalogs to cognos 10 migration.
• Responsible for Setting up Groups/Roles to secure teh Models and packages
• Expertise in BI scorecards, and dashboards design, and development
• Leading team, and user training with cognos suite.

Environment: Cognos Impromptu, Cognos / 8.3/8.4/10.1/10/.2.1 (Framework Manager, Report Studio, Analysis Studio, Event Studio, Query Studio), Powerplay Transformer, CognosTM110.1,Teradata SQL Assistant, Toad, Erwin, Cognos SDK, Informatica(ETL),Teradata, DB2, SQL Server, and Oracle EBS, Java, Windows, UNIX, Power play Transformer, LDAP, and MS Office.

Sr. Cognos Developer/ BI Solution Architect

Confidential, Irving, TX

Responsibilities:

• Responsible for requirement, and technical documentation.
• Responsible for creating Content store, installations and Configurations of teh ReportNet
• Responsible for teh 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 teh Cognos Portal.
• Proficient with Relational data modeling in teh Framework Manager for Analysis Studioo reporting.
• Responsible for teh cognos security, and deploy reports from development to SIT, UAT and production.
• Responsible for teh cognos/Cognos reportnet infrastructure and installations.
• Created impromptu query definition (iqd), power cubes, and published into teh 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 Office.

Sr. Cognos Report net developer/Administrator

Confidential, IL

Responsibilities:

• Responsible for teh 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 teh 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 teh Framework Manager database layer
• Built teh Frame work Manager Models and Packages in teh Presentation layer.
• Published packages from ReportNet Framework Manager to Cognos connection server.
• Created folders, filters, prompts, and calculations in Framework Manager and also in teh Report Studio.
• Worked on Standard Reports in Report Studio and Ad-hoc reports in Query Studio for users.
• Expertise on creating and analyzing teh 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 teh 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 teh Target Data.
• Involved in testing of Informatica mappings.
• Created Workflow and run Workflows using Workflow manager.
• Loading teh snapshot tables - detail and Summary through Informatica as per teh Business rules defined for Extraction Process for teh reference and Fact tables.
• Configuring and running sessions using Workflow Manager. Monitoring teh sessions using Workflow Monitor.
• Reviewing teh Target Data warehouse for Record counts, Transformations done, Data qualities issues and track teh issues to closure.
• Creating scripts for Loading teh error Master table and detailing out teh Error capture strategies to teh Team.
• Highlighting any data file issues with teh source team, which will has an impact on teh Data loading to teh 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.

Sr. Cognos Reportnet Developer/Administrator

Confidential, Portland, Oregon

Responsibilities:

• Interact with teh Business users for teh requirement gathering.
• Understanding Database (Mainframe, SAP, and DB2) schema, data modeling and Data Warehouse.
• Analyzing and creating teh functional specifications and technical specifications to implement business logic for teh user requirement to generate Framework Manager models and Cognos reportnet reports.
• Responsible to Creating Content store, installations and Configurations of teh 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 teh 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 teh ReportNet in teh Framework Manager and cognos reportnet server and also access manager for Cognos series7.
• Worked on ReportNet Migration from SAP reports into teh Cognos ReportNet reports.
• Worked on Standard Reports in Report Studio and Ad-hoc reports in Query Studio for users.
• Worked on bursting reports for teh web users or email users.
• Expertise on creating and analyzing teh complex reports (Cross tab, drill-thru reports, Prompts, filters, and calculations)
• Expertise with creating reports from teh 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 teh 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 teh reportnet reports.

Environment: Cognos Report Net1.1 (Framework Manager, Report StudioQuery Studio, cognos configuration, and ReportNet SDK)Cognos EPseries 7.x, PP Enterprise Server,Impromptu, Powerplay Transformer, UpfrontAccess Manager, Mainframe, InformaticaETL), SAP, DB2Quest Central for DB2, Windows NT/2000, Unix (AIX).Java, VB script, Java Script, Cognos Script EditorVisualizer, and Metrics Manager.

Confidential, VA

Senior Consultant

Responsibilities:

• Interact with users for teh requirement gathering.
• Analyzing teh 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 teh cubes and Transformer models.
• Recommended to do teh complex database calculations in teh 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 teh relationships between query subjects in a Framework Manager for teh improving performance.
• Experience with writing SQL queries in reportnet for performance tuning.
• Expertise with performance tuning like, minimize teh calculations in teh 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 teh fast performance of teh 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 teh web users.
• Expertise with Migration from Impromptu to Reportnet.
• Working noledge 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, VisualizerAccess Manager, Cognos Report Net1.0 (Framework Manager, Report Studio, Query Studio, Cognos configurationand ReportNetSDK), LDAP Server or Netscape Directory Server, Oracle9i, Oracle warehouse Builder, DB2Decision Stream, Erwin, VBscript, CognosScriptEditor, Matrics Manager, Er-win, Cognos Migration Utility toolsCrystal reports, Windows, Unix Shell Scripting and UNIX (AIX, Sun Solories, and HP).