SUMMARY:

• Over 16 years of IT experience which Includs over 13 years of experience in the Analysis, Design, Development, Testing, Documentation and implementation of Business Intelligence Analytics Solutions .
• Experience in Developing Data Modules, Dashboards, Reports using Cognos Analytics(Cognos 11.x)
• Extensive experience in developing Cognos10.2.2/8.x Framework Manager (DMR, Relational) Models, Report Studio Reports, Query Studio Reports, Analysis Studio Reports, Event Studio Reports, Powerply Studio Reports, Metrics Studio, Powerplay Tranformer Cubes, Cognos Connection, Portlets, Catalogs, Security, Impromptu Reports, PowerPlay Reports, Cognos Configurations .
• Extensive experience in developing Dashboards using Cognos Workspace, Workspace Advanced, Cognos Business Insight, Business Insight Advanced, and Cognos Report Studio .
• Extensive experience to Design and Development of Cubes using Cognos Powerply Transformer .
• Experience in developing Cognos Active Reports .
• Experience in create Dynamic Cubes using Cognos Cube Designer .
• Worked with SAP BEx Query Designer and built Cognos Reports based on BEx queries .
• Expertise In SAP BOBOJ 4.X Tools: Information Design Tool(IDT), Web Intelligence (WEBI), Dashboards, Explorer, and Office Analysis .
• Mentored and Trained Software Developers and Business clients on Cognos Products like Framework Manager, Report Studio, Query Studio, Analysis Studio Etc.
• Rich experience in Systems Analysis and Design. Excellent experience in Solutions Design from Scratch. Experienced in guiding teams in Implementing BI Solutions where little or no documentation of existing reporting system exists.
• Hands on experience in working with different data sources including SAP BW, Oracle, DB2, MS SQL Server, Flat files, Excel and Access .
• Setup security using Access Manager Administration.
• Experience in HP Service Manager (Service Management Tool).
• Involved in Installation and Configuring Cognos 7 and Cognos 10.X/8.X Environment.
• Involved in Migrating the Cognos Series 7 to Cognos 8 and Cognos 10 Environment.
• Involved in Migrating the Cognos 10.2.2 to Cognos 11.
• Strong knowledge in Datawarehouseing concepts.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Business Intelligence Tools: IBM Cognos 11/10.2.x\8.x (Framework Manager, Report studio, Query Studio, Active Reports, Business Insight, Business Insight Advanced, Cognos Workspace, Cognos Workspace Advanced, Power play Studio, Analysis Studio, Event Studio, Power play Transformer), Cognos Report Net 1.1, Cognos 7.X suite (Cognos Impromptu Administrator 7.x/6.x, Power play Transformer 7x, Power play User 7x, Cognos Upfront, Impromptu Web Reports (IWR), Power Play Enterprise Server, Cognos Server Administrator).

Scheduling Tools: Lotus Notes, Control - M, UC4.

RDBMS: Oracle 8i/9i/10g/11g, MS Access, MS SQL Server 2008/2005, IBM DB2.

Languages: C, C++, SQL, SQL*Loader, PL/SQL, JavaScript.

EXPERIENCE:

Confidential, VA

Solution Architect \ Senior Developer

• Created prototype and presented Data Module using multiple files, Dashboard and Reports to high level Business users .
• Initiated to design and development of Data Modules, Dashboards and Reports using Cognos 11 for PSAT and SAT K12 Internal Reporting Systems.
• Involved gathering requirements from business users for Reporting.
• Extensively used Report, Dash Board and Data Module components to create Reports, Dash Board Reports and Modules using Cognos 11.
• Created various reports for PSAT, SAT internal k12 business users.
• Involved testing of Report with Business Users.
• Initiated to design and development of SAT, PSAT Models, Reports, Cubes, and Dashboards for the External K12 Reporting Systems.
• Involved gathering requirements from business users for Reporting.
• Setup security in Framework Manager Models.
• Created Active Reports for high level Business Community users.
• In this Project Extensively used Framework Manager, Report Studio, Query Studio, Analysis Studio, Power play Studio, and Event Studio to create Models, Reports.
• Created Students Information Dashboards Reports Using Cognos Work Space, Work Space Advanced, and Report Studio.
• Extensively used Report Studio to create different kinds of reports like List Reports, Cross tab Reports, Chart Report, Conditional Formatting Report, and Drill through Reports, Master Detail Report, and Burst Reports.
• Converted Packages and Reports from CQM to DQM. created Dynamic Cubes using Cognos Cube Designer .
• Extensively used Power play Transformer to build Students Cubes.
• Extensively Involed to interact with ETL teams .
• Created Reports Using MDX functions against Power play Transformer Cubes and Dynamic Cubes.
• Users training on Cognos Tool.
• Perform day-to-day support activities & work in the Cognos Support team and development project teams to understand business requirements, models and reports design .Transition the same knowledge to the team for full support.
• Involved testing of Report with Business Users.

Environment: Cognos 11/10.2.2 (Data Module,Report,Dashboard,Framework Manager, Report Studio, Active Reports, Event Studio, Query Studio, Cognos Connection, Analysis Studio, Metric Studio, Powerplay studio, Cognos Workspace, Cognos Workspace Advanced, Powerplay Transformer), Oracle, SQL Server, Windows.

Confidential, SC

Solution Architect \ Senior Developer

• Initiated to design and development of Framework Manager Models, Reports, Cubes, and Dashboards for the Finance, Budget, and HR Data.
• Involved gathering requirements from business users for Reporting.
• Setup security in Framework Manager Models.
• Initiated and Created Active Reports (Submitted, Funded) for high level Business Community users.
• In this Project Extensively used Framework Manager, Report Studio, Query Studio, Analysis Studio, Power play Studio, and Event Studio to create Models, Reports, and Events.
• Extensively used Power play Transformer to build Finance, and HR Cubes.
• Created Grant, HR, and Finance Dashboards Reports Using Cognos Work Space, Work Space Advanced, Cognos Business Insight, Business Insight Advanced, and Report Studio.
• Extensively used Event Studio to create ( Hiring, Terminations) Events for Reports.
• Created more complex Faculty, and Student Work Load Report using Report Studio.
• Extensively used Report Studio to create different kinds of reports like List Reports, Cross tab Reports, Chart Report, Conditional Formatting Report, and Drill through Reports, Master Detail Report, and Burst Reports.
• Familiar to create Dynamic Cubes using Cognos Cube Designer .
• Extensively Involed to interact with ETL teams .
• Created Reports Using MDX functions against Power play Transformer Cubes.
• Users training on Cognos Tool.
• Perform day-to-day support activities & work in the Cognos Support team and development project teams to understand business requirements, models and reports design .Transition the same knowledge to the team for full support.
• Involved testing of Report with Business Users.

Environment: Cognos 10.2.1(Framework Manager, Report Studio, Active Reports, Event Studio, Query Studio, Cognos Connection, Analysis Studio, Metric Studio, Powerplay studio, Business Insight, Business Insight Advanced, Cognos Workspace, Cognos Workspace Advanced, Powerplay Transformer), Banner, Oracle, SQL Server, Windows.

Confidential, MI

Solution Architect \ Senior Developer

• Initiated to design and development of Framework Manager Models, Reports, and Cubes for the Finance, Budget, and HR Data.
• Involved gathering requirements from business users for Reporting.
• Setup Row level security on Organization Dimension in Framework Manager Models.
• Created Dashboards and Scorecards per Business users Request.
• Initiated and Created Active Reports for high level Business Community users.
• In this Project Extensively used Framework Manager, Report Studio, Query Studio, Analysis Studio, and Power play Studio to create Models and Reports.
• Extensively used Power play Transformer to build Power play Cubes.
• Created Dashboards Reports Using Cognos Work Space, Work Space Advanced, Cognos Business Insight, Business Insight Advanced, and Report Studio.
• Extensively used Report Studio to create different kinds of reports like List Reports, Cross tab Reports, Chart Report, Conditional Formatting Report, and Drill through Reports, Master Detail Report, and Burst Reports.
• Familiar to create Dynamic Cubes using Cognos Cube Designer .
• Created and maintained security using LDAP (Access Manager).
• Extensively Involved to Integrate SAP BW with Cognos to create Framework Models, and Reports against Info Cubes and BEX Queries.
• Created Reports Using MDX functions against Power play Transformer Cubes.
• High level users training for how to use Query Studio, Analysis Studio, and Power play Studio.
• Perform day-to-day support activities & work in the Cognos Support team and development project teams to understand business requirements, models and reports design. Transition the same knowledge to the team for full support.
• Involved testing of Report with Business Users.

Environment: Cognos 10.2 (Framework Manager, Report Studio, Active Reports, Event Studio, Query Studio, Cognos Connection, Analysis Studio, Metric Studio, Powerplay studio, Business Insight, Business Insight Advanced, Cognos Workspace, Cognos Workspace Advanced, Powerplay Transformer), SAP BW, Oracle, SQL Server, DB2, Windows.

Confidential, IL

BI Architect

• Created prototype and presented HP Service Manager, and Work load Management Models, and Reports to high level Business users .
• Developed Service Manager and Work Load Management Packages Using Framework Manager and published.
• Migration Cognos 7 (Catalogs, Reports, Cubes) to Cognos 8 and Cognos 8.4 and Cognos 10.1.
• Maintenance and support to Cognos 7 and cognos 8.4 and Cognos 10.1.
• Created Changes Management, Problem Management, and Handle cubes using power play Transformer 8.4 and Exported cubes into cognos Connection. Using this cubes created various Reports using Analysis Studio, Power play Studio, and Report studio.
• Using MDX function created complex reports in Report studio using Cube as Package.
• Created Manager Dash Board Reports (Incident, Interaction, Request, Problem, and Resource) using Report Studio.
• Created Triggers using Event Studio for various Report Studio reports.
• Created Reports like List Reports, Cross tab Reports, Charts Reports, Conditional formatting Reports, Drill Through reports, and Burst Reports using Report studio.
• Created Port lets in Cognos Connection.
• High level users Training.
• Created various cubes using Power play Transformer.
• Deploy all Reports and Packages from Dev environment to production Environment.
• Schedule all the Reports in COGNOS connection.
• Created and maintained security using LDAP (Access Manager).

Environment : Cognos 10.1/8.4/8.3 (Framework Manager, Report Studio, Event Studio, Query Studio, Cognos Connection, Analysis Studio, Metric Studio, Powerplay studio), AccessManger, Oracle, SQL Server, DB2, Cognos PowerplayTransformer, Cognos Enterpries Server, Toad, Windows NT\2000, Unix.

Confidential, NY

Senior Cognos 8.4 / SAP BI Consultant / Architect

• Extensively worked with BEx Query Designer.
• Worked with Users for defining the reporting needs and helped design / develop flexible queries and pre-calculated reports using BEx reporting features likes variables, exception, and conditions.
• Imported Charactistics, key Figures, Calculated key figures, restricted key figures, variables, and Authorization Variables from BEX Queries into Framework Manager.
• Created Finance and Accounting Models Using Framework Manager and published to Cognos Connection.
• Extensively used Framework Manager, Report studio, Query Studio, Analysis Studio, and Event studio.
• Using MDX created various complex reports in Report studio using Cube as Package.
• Created IQD’s using Framework Manger .
• Created various cubes using Power play Transformer.
• Schedule all the Reports in cognos connection.

Environment:: Cognos 8.4 (Framework Manager, Report studio, Query studio, Analysis Studio, Event Studio, Cognos Connection), Oracle, Power play Transformer, SAP BW, Windows.

Confidential, IL

Senior BI Consultant / Architect

• Analyzing the business requirements.
• Created and presented Prototype Models and Reports to high level Business users .
• Developed Enrollment and Dem Packages Using Framework Manager and published to Reportnet Server.
• Used DMR (Dimensionally Metadata Relational) or OLAP Modeling created Enrollment Model.
• Created Student Enrollment and Start Rate Cubes using power play Transformer 8.3 and Exported cubes into cognos Connection. Using this cubes created various Reports using Analysis Studio and Report studio.
• Used MDX created complex reports in Report studio using Cube as Package.
• Developed Dash Board (Consolidated, Soar) Reports using Report Studio.
• Created Reports like List Reports, Cross tab Reports, Chats Reports, Conditional formatting Reports, Drill Through reports, and Burst Reports using Report studio.
• Created IQD’s using Framework Manger .
• Created various cubes using Power play Transformer.
• Deploy all Reports and Packages from Dev environment to production Environment.
• Schedule all the Reports in congas connection.
• Created and maintained security using LDAP (Access Manager).

ENVIRONMENT: Cognos 8.4/8.3 (Framework Manager, Report Studio, Event Studio, Query Studio, Cognos Connection, Analysis Studio, Metric Studio), AccessManger, Oracle, SQL Server, PowerplayTransformer, Cognos Enterpries Server, Toad, Windows NT\2000.

Confidential, IL

Senior BI Consultant / Architect

• Some of my main Administration roles Security setup for all users, Deployment from dev to Production, Scheduling, Monitoring server, and schedule jobs.
• Created Financial, and Accounting Model (Financial, Accounting) and Packages Using Framework Manager and published to Cognos Connection.
• Using DMR or OLAP Modeling created Budget and actual Models.
• Created Trading summary and Accounting Cubes using power play Transformer and imported into Framework Manager, Created Package and Created Reports using Analysis Studio and Report studio.
• Using MDX created complex reports in Report studio using Cube as Package.
• Developed various Dash Boarding Reports using Report Studio.
• Created Triggers using Event Studio for various Report Studio reports.
• Created Reports like List Reports, Cross Tab Reports, Chats Reports, Conditional formatting Reports, Drill Through reports, and Burst Reports using Report studio.
• Created Various Port lets (Capital Management, Performance Management, Cap Recons, and Perf Recons) in Cognos Connection.
• High level users Training.
• Created IQD’s using Framework Manger .
• Created various cubes using Power play Transformer.
• Wrote the sql statement for Data validation of Report Studio Reports.

ENVIRONMENT: Cognos 8.3/ 8.2 (Framework Manager, Report Studio, Event Studio, Query Studio, Cognos Connection, Analysis Studio, Metric Studio), Oracle, SQLServer, DB2, PowerplayTransformer, Cognos Enterpries Server.

Confidential, IL

Senior BI / SAP BW Consultant

• Created Hospitals (Total Hospital, Total Hospital Effdat, and Hospital goals), and Daily sales (BW Model) Models Using Framework Manager, and published to Reportnet Server.
• Developed Reports for Hospital, and Daily sales Models using Report Studio, Query Studio, and Analysis Studio.
• Created Reports using Drill through Reports, List Reports, Cross Tab Report, Dash Boarding Reports, Busting Reports, and Conditional formatting Reports using Report studio.
• Created Port lets in Cognos Connection.
• Developed advanced reports using Report Studio, and Adhoc reports using Query Studio.
• Created various BW Reports (MM, Finance, and HR) in Cognos 8 using BW Bex Queries.
• Deploy Reports and Packages from Dev environment to production Environment.
• Schedule all the Reports in cognos connection.
• Maintained security throughout the company using LDAP.
• Maintained congas connection portal.
• Production Support and maintainace (Cognos daily activities support).
• Created catalogs, IMR Reports, and IQD .
• Developed Various PowerPlay Transformer models using IQD in Powerplay Transformer.
• Developed PowerPlay cubes, and PowerPlay reports .
• Using Powerplay Enterprise Server Published Cubes into Upfront .
• Created links between powerplay enterprise server, and cognos connection to move the Cubes to cognos connection .
• Presented the reports and Cubes to business users.

Environment: Cognos 8.2 (Framework Manager, Report Studio, Query Studio, Cognos Connection, Analysis Studio), SAP BW, AccessManger, Oracle, SQL Server, DB2, Cognos PowerplayTransformer, Cognos PowerPlay, Cognos Enterpries Server, Toad, Windows NT\2000.

Confidential, IL

Senior Consultant

• Modified and created the existing Global HR Data Models, and Packages according to our Reports Using Framework Manager, and published to Reportnet Server.
• Developed various Reports for their Global HR Department multiple view select and dynamic data columns.
• Created complex Reports using drill through reports, multiple prompts, filters, and dynamic data columns using cognos 8.
• Created Cast Based and Structure Based Headcount Reports of Global HR Data using Report Studio, Query Studio, and Analysis Studio.
• Tested reports and compared the output values.
• Setup Security in cognos 8.
• Developed PowerPlay Transformer models .
• Developed PowerPlay cubes and PowerPlay reports .
• Presented the reports to business users.
• Trained business users.

ENVIRONMENT: Cognos 8 (Framework Manager, Report Studio, Query Studio, Analysis Studio), AccessManger, Oracle, SQL Server, PowerplayTransformer, Cognos PowerPlay, Cognos Enterpries Server, Toad, Windows.

Confidential, IL

Report Net 1.1Senior Consultant

• Created Various Models, and Packages using Framework Manager, and published to Reportnet Server.
• Developed advanced reports using Report Studio, and Adhoc reports using Query Studio.
• Created various reports like List, Cross tab, Drill Through, Summary Details, and Charts.
• Schedule various reports Using Schedule Management used in Cognos Connection.
• Deploy the reports from one environment to another environment using Deployment Management tool.
• Security using Access Manager.
• Catalog creation and modification.
• Adding columns in Catalog after they are added in already existing tables.
• Developing and Customizing Impromptu Reports.
• Created standard and Ad hoc reports using Cognos Impromptu tool.
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Created List Reports and Cross Tab Reports and Drill Through reports.
• Created power play models and cubes using Transformer (Power Play).

ENVIRONMENT: Reportnet1.1MR1 (Framework Manager, Query Studio, Report Studio), Cognos EP Series 7 Impromptu 7.0/7.1, Cognos Power Play 7.0/7.1, Cognos Transformer7.0/7.1, Access Manger Power Play Enterprise Server, Windows NT/2000, Oracle 9i/8i, SQL Server 7.0 and DB2.