SUMMARY

• Over 10 years’ experience in Administration, analysis, design, development, Testing and implementation of business intelligence solutions using COGNOS.
• Hands on experience in Cognos 10.1/Cognos 10.2.1 (Active Reports, Report Studio, Analysis Studio, Framework Manager, Cognos Connection) Migration Cognos 8.4 to Cognos 10
• Hands on experience in Cognos8 (Query Studio, Report Studio, Analysis Studio, Metric Studio (Score - carding), Framework Manager, Cognos Connection) and Cognos Series 7.x (Cognos ReportNet 1.1, Cognos Impromptu, PowerPlay Transformer, Cognos PowerPlay).
• Strong experience in creating and publishing packages in Framework Manager.
• Strong complex reporting skills - complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports
• Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.
• Interacted with Customers for requirement gathering, effective analysis and also to provide end-user training.
• Experienced in developing Dashboards Reports in Cognos 8, Cognos 10.1 and Cognos 10.2
• Experienced in report Unit Testing/ Integration Testing/SAT/UAT
• Expertise in Oracle 10G, 9i and MS SQL Server 2000, 2005 and 2008
• Experience in migrating Impromptu/IWR reports to ReportNet 1.1 and Cognos Series 7 to Cognos8.
• Experienced in configuration & administration of Access Manager.
• Involved in OLTP/OLAP system study, analysis and E-R modeling, developing database schemas including Star and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Proficient in all phases of Data warehousing concepts, and experience in dimensional modeling using Star Schema and Snow-flake Schemas.
• Excellent communication and interpersonal skills.
• Good work ethics, detail oriented, fast learner, team oriented, flexible and adaptable to all kinds of stressful environments. Possess excellent communication and interpersonal skills.

TECHNICAL SKILLS

Reporting &Analysis: Cognos 8i (8.1-8.4) and (10.1-10.2.1 ) Active Reports, Cognos Report Net 1.x, Cognos Framework Manager, Report Studio, Query Studio, Analysis Studio, PowerPlay, PowerPlay transformer, Impromptu web reports, Cognos Query, VBA, Excel.

Admin/Security: Access Manager

Methodologies: Star, Snowflake Schema

QA Testing: MTM, Microsoft Visual Studio (Unit/ Integration Testing/SAT/UAT)

RDBMS (databases): MS SQL Server 2000, 2005 & 2008, Teradata, Oracle 10G (PL/SQL), MS Access

Scripting Languages: Java script, VB script, Dhtml, Html

Operating Systems: Windows 7/XP/NT/2000/98/95, MS DOS, UNIX

PROFESSIONAL EXPERIENCE

Confidential, El Segundo, CA

BI - PM - Cognos Developer

Responsibilities:

• Create the business reports in Cognos Report Studio
• Create the Sales and Marketing Dashboards
• Create the reports from Pass through SQL
• Migrate the reports from development to production and testing
• Worked with Project Documents (BRD)
• Setting up different environments (development and production)
• Create the Ad-hoc reports in Report Studio
• Developed SQL Driven reports
• Used Teradata as Data base

Confidential, Camp Hill, PA

Cognos Developer

Responsibilities:

• Worked on project for Department of Public Welfare State of PA
• Create the business reports in Cognos(10.1) Report Studio
• Create the frame work models in Cognos Framework Manager
• Worked on MS SQL server 2008 (SSIS)
• Closed worked with ETL Developer (Informatica)
• Create the System Usability Documents (BRD)
• Setting up different environments (development, testing and production)
• Worked on PDM for create the DSD Reports
• Create the Dash Boards in Report Studio
• Worked on Cubes and create the Reports
• Create the Adhoc reports in Report Studio
• Testing (Unit/ Integration Testing, SAT/ UAT) in MTM and Create and resolve the Bug
• Administration/Security
• Developed SQL Driven reports.

Confidential, Lansing, MI

Cognos 8.4/10 BI Developer/Cognos Administrator

Responsibilities:

• Upgrade the reports from series 8.1 to series 8.4 and 10
• Worked on the migration of reports to test to Production Environment.
• Created Active reports in Cognos 10
• Created various portals involving Cognos 8 portlets.
• Used Data Access Layer to maintain keys, joins, SQL queries,
• Experience in developing models using prompts and filters.
• Added new Dimensions and Measures in the already existing reports in the Production.
• Performed BI Content Administration tasks including scheduling and content management
• Developed SQL Driven reports.
• Worked on MS SQL server 2008 (SSIS)
• Closed worked with ETL Developer (Teradata)
• Administered user access protocols and managed user accounts and access privileges.
• Setting up different environments (development, testing and production)
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Converted Complex Power-Prompt Reports into Cognos 8 Reports.

Environment: - Cognos 8, Cognos 10 Active Reports BI, Cognos Connection, Report Studio, Analysis studio, Frame Work Manager, Oracle 10g, PL/SQL, XML, Windows NT/4.0 and Teradata

Confidential, Wayne, NJ

Cognos 8.4/10 BI Developer/Security Administrator

Responsibilities:

• Used Framework Manager to create models, packages and publish packages to the Cognos 8 and Cognos10 Server.
• Used Data Access Layer to maintain keys, joins, SQL queries,
• Created Active report in Cognos 10
• Upgrade the reports from series 8.1 to series 8.4 and 10
• Experience in developing models using prompts and filters.
• Distributed reports to various agents using Bursting.
• Added new Dimensions and Measures in the already existing reports in the Production.
• Performed BI Content Administration tasks including scheduling and content management
• Developed SQL in TOAD and exported results to Access Database.
• Developed SQL Driven reports.
• Administered user access protocols and managed user accounts and access privileges.
• Setting up different environments (development, testing and production)
• Deployed the reports from development to testing and from Q.A. to production through deployment tool.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Administer user access protocols and created user accounts and access privileges

Environment: - Cognos 8, Cognos 10 Active Reports BI, Cognos Connection, Report Studio, Query Studio, Analysis studio, Frame Work Manager, Oracle 10g, PL/SQL, XML and Windows NT/4.0

Confidential, Chicago, IL

Cognos 8.4 BI Developer

Responsibilities:

• Used Framework Manager to create models, packages and publish packages to the Cognos 8 Server.
• Experience in developing models using prompts and filters.
• Distributed reports to various agents using Bursting.
• Added new Dimensions and Measures in the already existing reports in the Production.
• Performed BI Content Administration tasks including scheduling and content management
• Developed SQL in TOAD and exported results to Access Database.
• Administered user access protocols and managed user accounts and access privileges.
• Setting up different environments (development, testing and production)
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Created various portals involving Cognos 8 portlets.
• Administer user access protocols and created user accounts and access privileges

Environment: Cognos8, Cognos10, Cognos Connection, Report Studio, Query Studio, Analysis studio, Frame Work Manager, Oracle 10g, SQL, Scheduler, XML and Windows NT/4.0

Confidential, NJ

Cognos Consultant

Responsibilities:

• Analyzed the existing Oracle Form based Client server System.
• Analyzed the DataMart.
• Created the Design Specifications for the Requirement Specification
• Worked on Data Mapping for the models.
• Created the Framework Manager Models.
• Provided the prompts in Query Studio
• Created predefined Filters for the Ad-hoc users.
• Applied three levels of security to the model (Data, Object and Package)
• Published the models in Development Environment and applied the Folder security and access capabilities for the users
• Migrates the reports to Test Environment. Ensured that it works fine when migrated to Test and good to go for Production.
• Working on the migration of reports to test to Production Environment.
• Converted Complex Power-Prompt Reports into Cognos 8 Reports.
• Implemented Prompt skipping in Cognos 8 Reports.
• Worked on Access Manager for administration purpose.

Environment: Cognos 8.4(Framework Manager, Report Studio, Query Studio), Oracle 10 and Windows Server 2003.

Confidential, NJ

Cognos BI Developer

Responsibilities:

• Strong in Database designing and Modeling
• Created CPF (Project files) and Published projects from the FM Models
• Tuned FM using Governor Settings
• Created Query subjects, query items, Filters, Namespaces
• Handled Complex Queries as separate Query Subjects.
• Supported Multiple Languages and Multi currency using Parameter mappings
• Updated various database changes into the Framework manager model
• Designed and jobs to fine tune the metadata
• Build complex packages using various tool options.
• Created various Reports (HTML, XML, PDF, CSV), Queries/Filters/ Conditional Variables
• Connected to various models to create Burst Reports, Filters, Cascading Prompts
• Customized reports using various features Header/Footer, run report with options, etc.,
• The reports ranged from using repeaters, conditional variables and many complex calculations
• Used Conditional explorer for the usage of variables and hide and show the different reports on the same selection criteria
• Created drill-through reports for detail reports.
• Generated Various Reports (List, Crosstab, Chart, Repeater)
• Build complex reports using various tool options
• Interacted with the business users and assisted them to use query Studio to develop ad - hoc reports.
• Accomplished various user request using Sorting/ aggregation tools, Grouping/Ungrouping, Expand/Collapse Group, Formatting tools, Swap options, setting up web page size / page breaks

Environment: Cognos 8.3 (Framework Manager, Report Studio, Query Studio), Decision Stream 7.1, Cognos 7.x, Oracle 9i and Windows 2003.