Bhavya

Sr. Cognos Developer

actka2@r.postjobfree.com 908-***-****

Summary:

Over 8 years of total IT industry experience as Cognos Certified Professional in analysis, design, testing, development and implementation of client/server applications

Good experience in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 7/ 8/10 and Cognos Report Net

Good understanding with Cognos architecture.

Sound skills in Cognos 10 BI Suite (framework Manager, Cognos connection, Report Studio, Analysis Studio, Event Studio and Query Studio, Transformer)

Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio

Having experience on dashboard reports building using report studio.

Developed database schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.

Experience in DMR model designing using Framework manager.

Very good experience in Report building using Report Studio and Analysis Studio

Work Experience in Transformer model design and Power play cube building

Experience in Installation and configuring the Cognos 10/8 and CRN environment and implementing third security tools Tivoli directory Server and Sun One with Single Sign on

Familiar with Cognos EP software where you can develop budgets and forecasts

Experience in OLTP/OLAP system study, analysis, E-R modeling and developing database schemas like star schema and snowflake schema.

Basic knowledge of BIA (Business Insight Advanced).

Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment.

Having knowledge on ETL tools like Informatica, Data Stage.

Good experience in Oracle SQL and PL/SQL

Worked with senior academic and administrative officers in support of financial management.

Having experience with TM1 for analytical and reporting applications

Experience in interacting with end users to gather requirements for reporting

Developed Cognos Planning solution enables a flexible and transparent process of forecast, while integrating with the in-place IBM Power Play solution.

Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving skills.

Technical Skills:

Reporting Tools: Cognos 10.2/8.2/8.3/8.4/8.1 Suite (Framework manager, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio) Cognos EP Series 7.3, Business Objects 5.1, Cognos Impromptu 7.3, Power Play 7.3, IWR, Visual Studio.

ETL: Informatica, Data Manager and data stage.

Databases: Oracle 8i/9i/10g, SQL Server 2000/5.0, DB2, Teradata, IBM Neteeza

Operating Systems: Windows 2003 Enterprise Server, XP, 2000, UNIX, and Linux

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, IHS)

Languages: C, C++, C#, SQL, T-SQL, PL/SQL, Shell Scripting, asp.net

Professional Experience:

Client: Solar Turbines Inc, San Diego, CA Jan 15 – Till Date

Role: Cognos Developer

Solar Turbines Incorporated, a subsidiary of Caterpillar Inc., is one of the world’s leading manufacturers of industrial gas turbines.

Products from Solar Turbines play an important role in the development of oil, natural gas and power generation projects around the world. Solar Turbines’ products include gas turbine engines (rated from 1590 to 30,000 horsepower), gas compressors, and gas turbine-powered compressor sets, mechanical-drive packages and generator sets (ranging from 1.1 to 22 megawatts).

Responsibilities:

Involved in the complete Software Development Life Cycle of projects starting from requirements gathering phase to deployment and maintenance.

Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.

Involved in Designing models with Relational Data using Framework Manager and published packages to the Cognos Reporting Servers.

Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.

Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.

Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.

Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.

Developed Dash board reports to display all the information related to environment using Summary reports.

Created Master Detail reports, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.

Created optional filters/prompts in report studio using Java Script and HTML.

Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.

Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production

Deploying models and reports from Development to Production and administering users/groups/roles.

Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas

Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support.

Environment: Cognos 10.2.1 (Framework Manager, Cognos Connection, Report Studio, Analysis Studio, Workspace, Workspace Advanced, Transformer and Event Studio) Informatica Power Center 9.1, Oracle11g, SQL Server 2008, Flat Files, Toad 9.0, Erwin, PL/SQL, Windows 7, UNIX.

Blue Cross Blue Shield, Washington, DC Jan 14 – Jan 15

Sr. Cognos Developer

This project is to build Member, Provider and Claims reports for the respective business groups to help them analyze plan performance metrics.

Responsibilities:

Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.

Involved in Designing models with Relational Data using Framework Manager and published packages to the Cognos Reporting Servers.

Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.

Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.

Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.

Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.

Upgraded Framework Manager Models, Transformer Cubes from Cognos 8.4 to 10.2.1.

Developed Pharma Dash board reports to display all the information related to environment using Summary reports.

Created Master Detail reports, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.

Created optional filters/prompts in report studio using Java Script and HTML.

Implemented Cognos SDK code to retrieve all the report schedules from the content store.

Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports

Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production

Deploying models and reports from Development to Production and administering users/groups/roles.

Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas

Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support.

Environment: Cognos 10.2.1 (Framework Manager, Cognos Connection, Report Studio, Analysis Studio, Workspace, Workspace Advanced, Transformer and Event Studio), Cognos SDK, JavaScript and HTML, SQL Server 2008, Oracle 11i, DB2 v7, Windows 2008, SQL, PL/SQL.

Mercedes Benz Financials Systems (MBFS), Farmington Hills, MI Aug 12 – Dec 13

Sr. Cognos Developer

Mercedes-Benz Financial Services is one of the leading captive financial services providers in the world, and the global financial services company of Daimler AG.Doing business as Mercedes-Benz Financial Services and Daimler Truck Financial, company financing for automotive and commercial vehicle dealers and their retail consumers in the United States, Canada, Mexico, Brazil and Argentina.

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.

Developed Framework Manager Models against Teradata and Oracle Database.

Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.

Developed Dashboard reports using Business Insights in Cognos 10

Developed report studio reports using Conditional Formatting and Cascading Prompts. Developed List, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.

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 Power play Transformer Cube.

Customized Reports using HTML and JAVA SCRIPTS.

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.

Worked with Production issues, trouble shooting and bug fixing.

Tested the reports with various testing methodologies like Functional testing, Regression testing and UAT.

Environment: Cognos 10 / 8.4 (Cognos Connection, Report Studio, Analysis Studio Framework Manager), Cognos Transformer, IBM Information Analyzer (Data stage) 8/9, Oracle 11i, Tera Data, TOAD, zLinux

Morgan Stanley, NYC Apr 11 – Aug 12

Sr. Cognos Consultant

Morgan Stanley is a global financial services firm headquartered in New York City serving a diversified group of corporations, governments, financial institutions, and individuals. IBM Cognos used to analyze their fixed income data worldwide by clients, cost centers and users.

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 complex reports like Crosstab, Drill throughs, Master detail, Dashboards and Burst Reports using Report Studio.

Implemented tuning settings changes for cognos query time limit in both Dev and Prod environment as per the user requirement.

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.

Built Multi Dimensional Models (DMR) with Relational Data using Framework Manager and Deployed Packages to the Report Servers.

Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP – ROLAP)

Created reports with custom prompt pages (using HTML and JavaScript) in Report Studio.

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.

Fine-tuned the queries for performance purpose and enhanced the performance of the reports.

Developed Report Views to organize reports in Cognos Connection

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, SSIS, SSRS, SSAS, BIDS and T-SQL,Oracle 11i, MSSQL Server 2008,TOAD, Unix

Citi Bank, New York, NY Jan 10 – Mar 11

Sr. Cognos Consultant

The purpose of this reporting program is to analysis the Dispute Functionality make determination if dispute can be immediately resolved.

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.

Developed Framework Manager Models against Teradata and Oracle Database.

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 8.4.

Developed reports in Analysis Studio from Powerplay Transformer Cube.

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.

Developed technical specification document for the offshore team.

Environment: Cognos 8.4 (Cognos Connection, Report Studio, Query Studio, Framework Manager),

Access Manager, SQL Server 2005, Oracle 10g, Windows XP.

Marriott International, Inc Mar 07 – Dec 09

Cognos Consultant

The aim of this project is to develop consolidated reports to their business by using Cognos BI as a reporting tool.

Responsibilities:

Gathered business requirements and designed functional and technical requirements documentation.

Installed and Administered Cognos products (8.4) in both gateways and dispatchers in distributed environment.

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.

Worked with ETL team for loading /Extracting data from Nateeza data base.

Security Administration for setting up users, groups and roles and creating access permissions.

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.

Environment: Cognos8.2 (Report Studio, Query Studio, Analysis Studio, Framework Manager), PowerPlay, Transformer, Access Manager, Nateeza, Oracle 10g, Windows XP

Contact this candidate