• Over 8+ years experience in analysis, design, development and implementation of business intelligence solutions using COGNOS.
• Hands on experience in Cognos8 and Cognos10 (Query Studio, Report Studio, Analysis Studio, Active Reports, Framework Manager, (Cognos Connection) and Cognos Series 7.x, Cognos Impromptu, Cognos PowerPlay Transformer, Cognos PowerPlay, Cognos Scheduler, Cognos Access Manager, Upfront).
• Experience in the installation and configuration of Cognos8, and Cognos10 Report studio, Framework Manager, Cognos Series 7.x.
• 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 dimensiounal 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 and Cognos10
• Expertise inOracle 10G, 9iand MS SQL Server 2000 & 2005
• Experience in migrating Impromptu/IWR reports to ReportNet 1.1 and Cognos Series 7 to Cognos8 to Cognos10.
• 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.
• Knowledge in Planning, Designing, developing and deploying Datawarehouses / Data Marts with experience of both relational & multidimensional database design using Data Modeling tool ERwin (Physical and Logical data models)
• 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.

Academic Background:

Bachelor Degree

Associate Degree City University 
State: New York

Cognos:
Certified in Cognos10, Mata Data Modeling
Year: 2012

Technical Skills:

OLAP tools:Reporting &Analysis: Cognos 8i (8.1-8.4), Cognos 10 Cognos Framework Manager, Report Studio, Query Studio, PowerPlay, PowerPlay transformer, Impromptu web reports, Cognos Query, Upfront.

Security: Access Manager 
Methodologies: Star, Snowflake Schema
RDBMS (databases): MS SQL Server, Oracle 10G (PL/SQL), MS Access 
Scripting Languages: Java script, VB script, Dhtml, Html
Server Side Scripting: ASP, Java Servlet
Operating Systems: Windows NT/2000/98/95, MS DOS, UNIX
Multimedia: Adobe Photoshop, Flash, Dreamweaver
Microsoft Technologies: Site Server, XML, Biztalk, IIS

Project Experience

Confidential June2012,….
Taxes

• Experienced in Cognos 10.i, 8.i, Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection.
• Strong experience in creating and publishing packages in Framework Manager.
• Well-versed in developing reporting applications using Cognos Business Intelligence components like Report Studio, Framework Manager, Query Studio, Analysis Studio, and Cognos Connection.
• Strong complex reporting skills – complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.
• Extensively used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring to address healthcare related analysis needs
• 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.
• Involved in a data migration process between different versions of Cognos.
• Experienced in developing Dashboards Reports in Cognos 8
• Proficient in all phases of Data warehousing concepts, and experience in dimensional modeling using Star Schema and Snow-flake Schemas.
• Created and published packages in Framework Manager from various data sources. Generated different kinds of reports in ReportNet, created templates and multilingual reports.
• Strong experience in client interaction and understanding business application, business data flow and data relations from them.
• Knowledge in Planning, Designing, developing and deploying Datawarehouses / Data Marts with experience of both relational & multidimensional database design using Data Modeling tool ERwin (Physical and Logical data models)
• Worked with Different Databases like Oracle8i/9i/10g, SQL Server 2000, DB2, MS Access.
• Excellent communication and interpersonal skills.

Confidential Jan 2012 -- April 2012
Indepenedence, MO

Hands on experience in Cognos 10 (Active Reports, Report Studio, Analysis Studio, Framework Manager, Cognos Connection) Migration Cognos 8.4 to Cognos 10 
Expert in Business Intelligence Applications using Cognos Tools such as cognos 8BI, ReportNet (Framework manager, report studio, query studio and Analysis studio.

• Experienced in developing Dashboards Reports in Cognos.
• Involved in a data migration process between different versions of Cognos.
• Expertise in version upgrades and Migrating Impromptu Catalogs, PowerPlay Cubes, and ReportNet reports into Cognos 8.
• Strong background in building Metadata models using Framework Manager and Dimensional Modeling.
• Extensively worked on developing various kinds of reports in Cognos 8 Report Studio, Analysis Studio and Query Studio.
• Strong experience in business analysis and requirement gathering.
• Possess extensive experience with Cognos Framework Manager including importing Metadata Source, Modeling and applying table level, and data level security.
• Involved in modeling the Data. Expertise in tuning up the database queries.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Involved in all phases of the project life cycle
• Gathered and documented users’ needs for cognos solutions
• Strong experience in business analysis and requirement gathering.
• Possess extensive experience with Cognos Framework Manager including importing Metadata Source, Modeling and applying table level, and data level security.
• Setting up domain groups and assigning access rights to users and groups using the Cognos Server tools linked to standard LDAP.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports. 
  Worked on Dashboard reports.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Involved in extensive use of conditional formatting while developing reports in Report Studio. .
• Built reports with focus on optimization: used indexes on tables and made recommendations for summary tables where needed.
• Used OWB in Cognos 8 platform for data merging, extraction and transformation
• Experience in providing read access to all modeled data in IBM cognos 8 metadata environment
• Responsible for writing various documentations like technical specifications document, report specifications document and user manual

Confidential, NJ Jun 2008 – Nov 2011

Part of Avaya’s reporting structure is based on Cognos BI and ReportNet Portals. As a member of BI Team, designed and created various framework manager models and packages to suit customer needs. Generated various Query subjects and calculated complicated queries.

Responsibilities: Strong in framework manager 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 manger 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.4 Cognos 10 (Framework Manager, Report Studio, Query Studio), Decision Stream 7.1, Cognos 7.x, Oracle 9i and Windows 2003.

Confidential, NJ July 06 – April 08 Worked on Cognos 8 Migration Project for the Human Resources Department of Merck pharmaceuticals. Worked on a full cycle of Development of Adhoc Query Reporting as well as Professional Reports. As a BI Modeler created Framework Manager Models for various HR needs like Contingent Worker, Employee, Staffing and Training.

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 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 Migrated 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 PowerPrompt Reports into Cognos 8 Reports. Implemented Prompt skipping in Cognos 8 Reports. Worked on Access Manager for administration purpose.

Environment: Cognos 8 MR2 (Framework Manager, Report Studio, Query Studio, SDK), Cognos 7.3, Power prompts Oracle 9i and Windows Server 2003.

Confidential, MA Dec 2004 – May 2006

As a BI consultant, created Online and Data warehouse Reports for DSS. Spider focuses on providing a web based system, enhancing timeliness and availability of information regarding the children under the care of Department of Social Services, MA. Created User interface for entering the data about the Foster Care children under DSS care.

Responsibilities:

Analyzed the existing Oracle Form based Client server System. Created a Reporting requirement Document which contains information about the Reporting structure. Created Framework Manager Models and Published packages. Created Model Filters and Calculated columns in the model level. Designed the Report for Log of Consumers Served which provides the information about the resources and the kids under the DSS care. Worked on migrating reports to Cognos 8 in the test environment. Formatted the migrated reports with the help of Cognos 8 BI tools. Designed and published OLAP data in Analysis Studio for Analysis. Created Dashboards using Metrics Designer and Metrics Manager. Designed a cube for their warehouse data. Created the IQD’s using Framework Manager. Published the cube on PPES. Created a drill through from the cube to the report where the Analytical data can be drill through to get the detailed report. This cube displayed the Recurrence Percentage of Maltreatment of the kids. Created the calculated categories and measures for the cube. Facilitated the users to work on the cube and reports.