SUMMARY

• Over 8 years of Experience in Data Warehousing, Data Modeling, Business Intelligence (BI) Cognos.
• Extensive exposure to various business sectors such as Finance, Insurance, Pharma, Tele Communication and Retail.
• Very good understanding on advantages, limitations & advancements in recently released versions of Cognos products.
• Developed Reports using Cognos 10.1.1 Active Reports & Statistics.
• Experience in Cognos 10 and 8 BI (Framework Manager, Report Studio, Query Studio, Event Studio, Metric Studio, Analysis Studio and Cognos Connection) and Report Net1.1.
• Expertise in Data warehousing Concepts in OLTP/OLAP System Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modeling.
• Extensive experience in data analysis, development, SQL performance tuning, data warehousing ETL process, data conversions and user documentation.
• Upgraded Cognos 8.4 content to Cognos 10.1.1.
• Experience in Conceptual, Logical and Physical data modeling with strong knowledge of Data Warehousing concepts and Dimensional modeling Star schema and Snowflake schema.
• Experience in developing various reports like List reports, Crosstab reports, Charts, Dash Boards and Score cards.
• Played the role of a Lead Developer, Developer, Mentor, Business Analyst and coordinate with the off shore team in various DW projects.
• Has very good experience in complete ETL cycle including data analysis, data mapping, conversion and data load.
• Involved in entire lifecycle development process of data warehousing.
• Expert at creating Multi - dimensional Cubes for corporate data using PowerPlay Transformer.
• Published cubes and PowerPlay reports to Upfront using PowerPlay Enterprise Server.
• Strong programming and debugging skills in SQL, PL/SQL,TERADATA
• Hands on experience in administering, deploying and maintaining models, reports and cubes
• Installed and configured various components, such as the Framework Manager and Content Manager.
• Experience with Cognos Software Development Kit (SDK) to customize reports using java.
• Extensive experience in gathering and documenting user requirements, report development, setup security infrastructure at Data and object levels as part of setting up reporting infrastructure.
• Experience in configuring the Repository, creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Strong Experience in User acceptance test, product support, version control and change management.
• Experience with SSRS, SSAS SQL SERVER Reporting tools.
• Decisive team player with the ability to meet deadlines, handle multiple tasks and flexible in work schedules
• Possess Excellent Communication (both verbal and written) & Interpersonal skills technically sound, Result-Oriented with strong Problem Solving skills.

TECHNICAL SKILLS

OLAP: Cognos 10, 8 BI 8.4/8.3/8.2/8.1 (Report Studio, Query Studio, Cognos Connection, Analysis Studio, Event Studio and Framework Manager), Cognos Go Office, Reportnet 1.1, Powerplay Transformer, Impromptu Web Reports (IWR), Upfront, Cognos Impromptu Administrator and MS-Excel

Data Modeling: ERwin 4.x/3.5.2/3.x, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer

RDBMS: MS SQL Server 2012/2008/2005/7.0 , Oracle 11g/10g/9i/8i, Terradata,DB2 9.0,Nateeza

ETL: Informatica 7.x (Source Analyzer, Data warehouse designer, Mapping Designer, Mapplets, Transformations), Data Manager, Data Stage

Operating Systems: Windows 2000/XP, UNIX, and DOS

Languages: SQL, PL/SQL, HTML, Java Script, C, C++

PROFESSIONAL EXPERIENCE

Confidential

Sr Cognos Consultant

Responsibilities:

• Involved with the Business users and documented their Queries, Business and Reporting needs and analyzed the data and business logic underlying the requirement.
• DevelopedDMR and Relational models using Framework Manger againstSQL Server Database and also implementing the securities in the Framework Manager.
• Developed the packages using the Stored Procedures as the source and developed the reports.
• Developed List, cross tab, drill through, master-detail, chart, Conditional blocks and complex reports which involved Multiple Prompts and scheduling the reports using SSAS, Transformer Cubes and also using packages
• Expertise in using Query Studio for developing Ad hoc reports and training sessions for the Business users.
• Expertise in the Creating package for the end users for using Query Studio for the Ad hoc reporting purposes.
• Expertise in developing the reports using SSRS and also developing SSAS for developing the cubes.
• Expertise in creating PL/SQL scripts and stored procedures to transform the data from enterprise data warehouse to clear data mart to build dimensions and load data to fact tables.
• Monitoring the SQL jobs using the scheduler tool and fix the issues and also supporting the users and providing the Production support.
• Greatly involved in Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it.
• Maintaining the servers and database and archiving the data based on the user requirement.
• Customized Reports using HTML and JAVA SCRIPTS.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection based on the user requirement.
• Designed models by mapping business needs using Power Play Transformer and created multi dimensional cubes, cube groups, Power Play reports.
• Designed multidimensional models using Transformer.
• Involved in Deploying reports, cubes and packages from Development to Production environment.
• Worked extensively on monitoring the database, checking the log file size and free space in the data drives, connectivity of the databases.
• Strong experience in all phases of testing including defining user acceptance criteria, developing plans/scripts, documenting expected results, execution of scripts, validating actual results.
• Delivered advanced/ complex reporting solutions such as Dashboards and Standardized Reporting including the bursting of reports globally using Cognos 10.1

Environment: Cognos 10.2 / 8.4 (Cognos Connection, Report Studio, Query Studio, Analysis Studio Framework Manager, Business Insight/Advanced)), Cognos Transformer, SQL SERVER 2008/2012, SSRS/SSAS, SQL SERVER, Oracle, PL/SQL, Windows.

Confidential, NC

Sr. Cognos Consultant

Responsibilities:

• Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement.
• Built Multi-Dimensional Models (DMR) with Relational Data using Framework Manager, designed models and deployed Packages to the Report Servers.
• Developing models using Framework Manager Techniques and also implementing the logics (joins, union, multiple filters,) within the Framework for the ad-hoc reporting for the end users and trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Created new Query Subjects and arranged in different folder structure for Business View and also manually created the query subjects using the complex SQL.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Developed the new dashboard right from scratch i.e., gathering the requirements from end user and implemented and delivered in a time.
• Developed List, cross tab, drill through, master-detail, conditional blocks, chart and complex reports which involved Multiple Prompts in Report Studio against TM1 Cubes and report bursting.
• Developed Reports with multiple Cognos Viewers and integrated multiple Cognos reports onto a Single Page Report.
• Creating New Job and scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Experience in Deploying reports, cubes and packages from Development to Production environment.
• Customized Reports by writing complex custom SQL.
• Customized Reports using XML, HTML, and JAVASCRIPT.
• Worked with the Data analysis, development, SQL performance tuning, data warehousing ETL process, data conversions and user documentation.

Environment: Cognos 10 / 8.4 (Cognos Connection, Report Studio, Query Studio, Analysis Studio Framework Manager, Business Insight/Advanced)), Access Manager, Cognos Transformer, Oracle 11i, Teradata SQL ASSISTANT, PL SQL, DB2, TOAD, Windows XP

Confidential, MI

Sr. Cognos Consultant

Responsibilities:

• Developing models using Framework Manager Techniques.
• Created Packages and published these packages on to Cognos Connection for creating ad-hoc reports using Query Studio and professional reports using Report Studio.
• Created new Query Subjects and arranged in different folder structure for Business View.
• Created complex reports like Crosstab, Drill throughs, Master detail, Dashboards and Burst Reports using Report Studio.
• Created reports using Conditional formatting, Conditional blocks, Conditional variables, Advanced Conditional styles and Conditional Layout features in Report Studio.
• Created queries in report studio using Join and Union.
• Developed Reports using Cognos 10.1 and also Active Reports.
• Built Multi-Dimensional Model with Relational Data using Framework Manager and Transformers.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP - ROLAP)
• Experience in Deploying reports, cubes and packages from Development to Production environment.
• Setting up cardinality (minimum, maximum & optional), Determinants to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Used Cognos Transformer to build multidimensional cubes.
• Developed DMR Models & IQD’s in Framework Manager.
• Fine-tuned the queries for performance purpose and enhanced the performance of the reports.
• Expertise in handling Administration tasks like bursting and scheduling the reports.
• Strong experience in all phases of testing including defining user acceptance criteria, developing plans/scripts, documenting expected results, execution of scripts, validating actual results.

Environment: Cognos 10 / 8.4 (Cognos Connection, Report Studio, Query Studio, Analysis Studio Framework Manager), Access Manager, Cognos Transformer, Oracle 11i, DB2, TOAD, Teradata, Windows XP

Confidential, IL

Sr. Cognos Consultant

Responsibilities:

• Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement.
• Built Multi Dimensional Models (DMR) with Relational Data using Framework Manager and Deployed Packages to the Report Servers.
• Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• DevelopedFramework ManagerModels againstTeradata and OracleDatabase.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Delivered advanced/ complex reporting solutions such as Dashboards and Standardized Reporting including the bursting of reports globally using Cognos 10.1/8.4.
• Developed reports in Analysis Studio from Powerplay Transformer Cube.
• Developed Score Card Applications using Metric Manger and Metric Studio
• Migrated catalogs, Cubes, reports from Cognos Series 7.3/CRN to Cognos 8.4 using Migration Utilities.
• Customized Reports using HTML and JAVA SCRIPTS.
• Developed complex reports on SSAS cubes and Transformer cubes.
• Developed Forecast Budget Reports on SSAS and Transformer cubes using Report Studio in Cognos.
• Creating New Jobs using Cognos Connection.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Designed models by mapping business needs using Power Play Transformer and created multi dimensional cubes, cube groups, Power Play reports.
• Designed multidimensional models using Transformer.
• Decreased the Cube build times drastically and increased runtime performance.
• Third Party Security with LDAP and use those in creating Data Level, Object Securities in Framework Manager Models.
• Involved in Deploying reports, cubes and packages from Development to Production environment.
• Assigning work to the offshore team on daily basis.
• Setup Weekly Status Calls with offshore team.
• Coordinated training sessions and demonstration of Cognos tools to End-users.
• Developed technical specification document for the offshore team.
• Involved in the Installation and Configuration of Cognos 8.4 BI tools and Framework Manager.

Environment: Cognos 10/8.4 (Cognos Connection, Report Studio, Query Studio, Framework Manager), Access Manager, Teradata, SQL Server 2005, Oracle 10g, Windows XP.

Confidential, DE

Sr. Cognos Developer

Responsibilities:

• Gathered business requirements and designed functional and technical requirements documentation.
• Involved in Designing DMR models with Relational Data and Relational models using Framework Manager and deployed packages to the Report Servers.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Set up the Security at the package level, query subject level and the query item level.
• Used Governing techniques for improving performance of the Query.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Delivered Advanced Multidimensional reporting solutions using Report Studio.
• Developed Reports with multiple Cognos Viewers and integrated multiple Cognos reports onto a Single Page Report.
• Customized Reports by writing complex custom SQL.
• Customized Reports using HTML, JAVASCRIPT and SDK.
• Deliver advanced/ complex reporting solutions such as Dashboards, Scorecards and Standardized Reporting (including the bursting of reports globally) using Cognos 8.
• Creating IQD files from Report net and designed Power play models in Transformer.
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Involved in building the complex cubes and optimizing the cube creation.
• Built Multidimensional Cubes, Sub cubes for user groups using PowerPlay Transformer.
• Created and managed jobs and schedules.
• Published cubes and OLAP reports using Upfront Server.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Installation of Cognos 8 BI Tools and Framework Manager, setting Cognos configuration and integrating different components.
• Created Transformer models and generated OLAP cubes for multi-dimensional analysis of the data.

Environment: Cognos8.4 (Cognos Connection, Report Studio, Query Studio, PowerPlay studioFramework Manager), Cognos PowerPlay, Cognos Transformer, Access Manager, SQL Server 2005Oracle 10g, Windows XP

Confidential, Collegeville, PA

Sr. Cognos Developer

Responsibilities:

• Involved into business requirements and report specifications.
• Created relational and dimensional Framework Manager Models, packages, IQD files and configured them with appropriate security.
• Created Transformer models, generated OLAP cubes and published them to the Web portal.
• Developed various reports which include simple lists, cross tabs, charts, complex reports with tables in them, conditional block, static choices in prompt etc.
• Expertise in creating reports by using Master Details, Drill throughs, Drillup and DrillDown.
• Expertise in developing Prompt pages and Cascaded input prompts.
• Expertise in using Query Studio for developing Ad hoc reports.
• Expertise in developing Dash Boards using Report Studio.
• Used joins to extract data from different tables.
• Created portal pages for various departments and assigned security to portal pages and reports in Cognos connection.
• Scheduled and distributed reports using Schedule Management in Cognos Connection.
• Created Dashboards to present critical company data in a single report.
• Performed comprehensive Unit testing by comparing the Cognos reports against the database using SQL by using Toad and documented the same.
• Involved in designing of Test Plans, Test Cases, and Executed Test Cases.
• Involved in System and Integration testing as required to provide a Quality product.
• Migrating reports from Cognos 8.3 BI to Cognos 8.4 BI.
• Training users to use the Cognos Connection to access their corresponding reports.

Environment: Cognos 8.1/8.2 (Report Studio, Query Studio, Analysis Studio and Frame work manager), Cognos Go dashboard 8.4, PowerPlay Transformer 8.3, Toad 9.5, Oracle10g

Confidential, MD

Cognos Developer

Responsibilities:

• Created packages using multiple data sources in Framework Manager.
• Created the packages defining the business rules and calculations with folders to store conditions, calculations and prompts.
• Worked on the Framework Manager to create metadata model and solved ambiguous relationships.
• Created ad-hoc reports in Query Studio and standard reports in Report Studio.
• Developed List, crosstab, drill through, master-detail using Report Studio and Query studio, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports.
• Scheduled reports, maintained public and individual folders, distribution lists, users, groups and roles using Cognos connection in Report Net.
• Created complex reports using multiple tabular models and tabular sets in Report Studio.
• Installed ReportNet Migration Tool and migrated Impromptu catalogs using impcat2xml command.
• Developed complex reports using impromptu with drill through capabilities, summarization, grouping and filtering.
• Accessed data from data marts using Cognos Impromptu & Cognos PowerPlay
• Created cubes using Cognos PowerPlay Transformer
• Applied User class security for Models in Transformer.

Environment: Cognos ReportNet, Cognos EP Series 7.3 (Impromptu, Upfront, IWR, Transformer, Power play), Oracle 9i, SQL Server, Windows XP.