Cognos Developer Lead Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

SUMMARY

·         Over 7+ years of experience in the Design, Development, and Implementation of Business Intelligence applications.

·         Development and Implementation of Applications using the complete Cognos product suite: Cognos 8.x (Framework Manager, Report studio, Query Studio and Analysis Studio), Transformer, Power play Client, Power play Web, Cognos Upfront, Access Manager and Report Net.

·         Expertise in building Multidimensional Models, DMR Modeled Packages and creating Power Cubes for distribution using Power Play Transformer.

·         Developed professional reports in Report Studio, Analysis Studio and ad hoc reports in Query Studio and generated documents using Scheduler.

·         Created Projects, Models and Published packages using Framework Manager.

·         Created List, Sub and Cross-Tab, Graph, Pie reports with Standard Filters, Calculation and Prompts using Cognos Studios.

·         Implemented Java scripting, Conditional formatting, dynamic sorting, multi prompt pages and report pages using multiple queries for providing better functionality in the reports.

·         Managed Security by creating User Classes in Access Manager 7.x/6.x and implemented, row level, data level and package level securities in Framework Manager.

·         Developed OLAP applications using Cognos suite of tools and extracted data from the enterprise data warehouse to support the analytical and reporting needs of different corporate business units.

·         Expertise in building multidimensional Cognos cubes and implemented special categories, sub dimensions, alternate drill downs, cube groups and currency conversions in the cubes.

·         Implemented automation of the cube generation process using batch files.

·         Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database schemas (Star Schema and Snowflake Schema) used in Relational, Dimensional and multi-dimensional modeling.

·         Working knowledge in Database Development, Data Modeling, and Applications development in SQL Server, Oracle 9.x/8.x.

·         Skills in Programming and Debugging using SQL, PL/SQL, C, Java, languages.

·         Experience in creating artifacts like functional design documents, technical design documents and unit test cases.

·         Strong analytical and problem solving skills, excellent team player. Ability and willingness to learn quickly

      and adapt to new environments and learn new technologies.

SKILLS

BI Tools                        Cognos 10,Cognos 8.x BI Suite (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Cognos ReportNet 1.x (Framework Manager, Report Studio, Query Studio), Cognos Impromptu 7x/6x/5x, Power Play Client, Power Play Transformer 7x/6x, Power Play Explorer for the Web and Enterprise Server Manager, Impromptu Web Reports.

OS                               Windows 95/98/2000/NT/XP, MS DOS and UNIX

   Web Servers                   Microsoft Internet Information Server (IIS) 4.0/3.0, IBM Web Sphere 4.x/5

   Languages:                    C, C++, SQL, PL/SQL, XML, HTML, Java basics

MS office                        MS Excel, MS word, MS PowerPoint, MS Access

Databases                      Oracle 9i/8i/7.x, SQL server 7.0/2000, TSQL, Sybase, MS Access 97/00/XP/03

ETL Tools                       Informatica Power Center7.x (Source Analyzer, Mapping Designer,  

                                       Warehouse Designer, Transformations).

Version Control              SVN

DB Client                       Oracle SQL Developer, Toad and SQL Plus.

EDUCATION:

Bachelors in Electronics & Computer Engineering

G.Narayanamma Institute of Technological Sciences, India.

EXPERIENCE

Cognos Developer Lead, GE Treasury, Stamford CT

Mar ‘11 to Present

GE is a Global Infrastructure, finance and media company taking on the world’s toughest challenges.

GE Treasury team is responsible for global funding and liquidity, cash management, capital management and treasury

services for all of GE’s worldwide operations.

Vault application is used for developing and implementing a “World Class”, source of truth bank account management

system for GE that aligns with the overall Treasury simplification initiative. The Vault application is a system designed to

support GE bank account management processes such as account creation, updates, deactivations, and audits.  Vault

will replace the existing BAAS system.  Vault Reporting Solution Phase (ITG 75406) provides a customized operational

reporting solution in support of all Vault bank account management needs.

Responsibilities:

·   Involved in the end to end life cycle of the project Vault BI Reporting Project.

·   Interacted with the Business users and gathered the Business requirements and reporting needs.  

·   Build the Functional specs, Technical specs and the data field mapping specs as per the requirements.

·   Define & manage overall work plan to ensure work is assigned & completed before deadline, within budget.

·   Responsible in building Frame manager model package, BR gatherings with end clients.

·   Created Metadata models from two different source systems which use SQL Server and Oracle.

·   Published packages into Cognos Connection using Cognos 8 Framework Manager and deployed the Reports from development portal to QA and Production.

·   Created isolated presentation layer, business layer and data source layers in the metadata model before publishing packages.

·   Implemented row level security in the Framework Manger model by importing the security groups and using the

   Parameter maps.

·   Created Master-Detail reports, Burst reports, Drill down/up reports, Drill-thru reports, Prompt Pages (Cascaded input  prompts and Simple prompts) in Cognos 8.

·   Used JavaScript to obtain certain functionalities like show/hide comments etc and edited the Cognos .js property files to implement feature of increasing the prompts width dynamically.

·   Created Component template references to maintain consistency with design and minimize the future changes in prompts and reports.

·   Enhanced performance by analyzing queries, modifying joins by reducing the outer joins and tuning strategies by database functions.

·   Responsible for the delivery of solution-oriented complex reports using Cognos Report Studio.

·   Created Unit Test Cases and did through testing of the reports by writing queries against Database using Oracle SQL Developer.

·   Created documentations for the FM Model, Reports and did the knowledge transfer to the Support team.

Environment: Cognos 10,Cognos 8.x BI (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio), Microsoft SQL Server, Oracle 10g, Oracle SQL developer.

Sr Cognos Developer, BASF, NC

Oct ‘10 to Mar’11

Badische Anilin and Soda Fabrik (BASF) was started in 1865 and is considered as world’s leading chemical Company which is operating in more than 170 countries and produces approximately 8000 products which includes Chemicals, Plastics, Performance Products, Agricultural products and Nutrition, Oil and Gas. Company uses all the latest technologies and one of them was Cognos BI which helped them in business reporting both in Germany and United States.

Cognos BI used by the Business for analysis of the Sales information at Region level, Distributor level and territory levels. Reporting is also done for Sales group which gives them updates every week with the help of dashboards and Key performance indicators (KPI).

Responsibilities:

·         Interacted with the Business users and documented their query, business analysis and reporting needs. Understood data and business logic underlying the requirements.

·         Created complex reports with multiple prompt pages and multiple page reports at different hierarchy levels of Sales data.

·         Created Customer facing reports, End user reports, and BASF sales reports for different USCROP and Turf & Ornamental Business Segments.

·         Worked as primary resource for the BI maintenance resource, implemented new change requests and provided support on daily basis level.

·         Interacted with the business users in gathering their requirements for new tasks and enhancements.

·         Created Region level, Distributor level and Territory level reports and implemented drill downs between all the reports.

·         Used Framework Manager to model metadata and created star schemas based on report requirements from different Oracle sources for use in Report Studio and Query Studio.

·         Used Java scripting and implemented new features like default selection of the prompt values and passing the parent prompt values to the cascading prompts.

·         Used Java scripting and implemented new features like default selection of the prompt values and passing the parent prompt values to the cascading prompts.

·         Implemented new features like Freezing columns, rows and titles of the List reports by adding new classes to reports styles properties files and applying them at layout level.

·         Created multi Query reports with joins, unions and parameterized filters.

·         Implemented horizontal scrolling, vertical scrolling of columns for lists, conditional hide/show of columns, dynamic sorting and conditional formatting etc in several reports for providing better functionality.

·         Developed Dashboard reports in Cognos 8 focusing on sales during past years.

·         Created dashboard reports with a combination of list and graph with multiple queries and implemented drill through.

·         Validated Report data with Data mart, tuned the Queries.

·         Provide seamless movement from dashboards and summary reports to detailed level reports.

·         Worked as production support assisting Customers and users for issues both of Technical and Non-technical nature.

Environment: Cognos 8.x BI (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio), Microsoft SQL Server Management Studio, Oracle Toad, Oracle 10g.

Sr Cognos Developer, United Health Care, MN

Feb ‘10 to Oct ‘10                      

UnitedHealth Group is a leading health care company, serving more than 75 million people worldwide. The Clinical Toolbox is partnering with segments across UnitedHealth Group to build a common suite of tools to improve the Clinical Delivery Process.  Cognos 8 was used to perform Self Service Reporting activities related to Functional Business Units (FBU).

Responsibilities:

·         Involved in the Full lifecycle Cognos report development for Self Service Reporting initiative to support the Clinical Tool Box. 

·         Worked with Care One and Clinical ODS teams to develop complex Report Studio modules within the Self Services Reporting infrastructure.

·         Assisted in defining and gathering all Reporting/Data requirements.

·         Interacted with the Business users and documented their query, business analysis and reporting needs. Understood data and business logic for all detailed reporting requirements.

·         Created functional BRD’s and technical BRD's.

·         Worked in creating the Care One ODS Self Service Framework Manager components and related Packages.

·         Responsible in creating the 75 + Metrics for the TCM Scorecard project based modules.

·         Created Ad-hoc Reports, tested, assisted with acceptance testing (UAT).

·         Created complex Case Management and Disease Management reports with multiple queries using complex Joins and Query references.

·         Worked with large datasets from various Namespaces in single report modules (by using joins, unions).

·         Created Multi Page reports using Date Prompts, List Prompts, Cascading Prompts, Conditional Formatting and Drill downs.

·         Optimized SQL, PL/SQL queries, stored procedures for better performance using oracle features EXPLAIN PLAN and Table Indexes.

·         Involved in analyzing joins to improve performance of reports.

·         Involved in documenting the project.

Environment: Cognos 8.x BI (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio),  Microsoft SQL Server Management Studio, Oracle Toad, Oracle 10g.

Cognos Developer, Coloplast, MN

Jun ‘09 to Jan ‘10                                            

Coloplast develops products and services that make life easier for people with very personal and private medical conditions. The business includes Ostomy care, Urology and continence care, and wound and skin care.

Cognos is used to run all Purchase, Production, Product/Pricing, Sales Analysis and Brand Analysis reports. Sales and Marketing departments can view various reports on previous sales and on present stock, which helps production and purchase team focus on profit and loss areas.

Responsibilities:

·         Gathered Business Requirements from various Functional areas, assisted in development of all Cognos Report Studio modules (Cognos 8).

·         Created advanced business reports using Report Studio and ad hoc reports using Query Studio.

·         Created Monthly Sales Reports and Daily Sales Reports by Customer, Item, Brand, Direct and Indirect Monthly, Day, Budget, Validation, Quantity, Estimate Reports with various Sales Order Lines.

·         Created with the development of complex Mater detail reports, Multiple Section Reports, Multi-Prompt reports based on the various hierarchies.

·         Created reports with multiple Lists, Chart, Pie and Cross Tab in single Report with Drill Through and advanced Conditional Formatting.

·         Created reports with Year-to-Year comparisons and their variances in invoice amounts at various hierarchical levels (Vice president, Directors, Sales Manager and Sales Reps).  

·         Used Bursting techniques to distribute reports.

·         Involved in the entire life cycle for Power Cube development including building Transformer Models (using Packages as the Data Source).

·         Worked on developing Power Play cubes to summarize figures including Store Sales, Unit Sales, Invoice Amount and Net Sales/Profits.

·         Created Alternate drill downs, multiple dimensions, Currency conversion and special categories in Transformer.

·         Responsible for working with Business analysts to write functional development documents.

·         Provided Extensive End User Training and Support.

Environment: Cognos 8.3 BI (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio), Cognos Power Play Transformer, Power Play Web, Oracle10.g.

Cognos Developer, Carlson Companies, MN

May ‘08 to Mar’09        

Carlson is a global group of integrated companies providing business and leisure travel, hotel, restaurant and marketing services directly to consumers, corporations and government entities. Carlson Wagonlit Travel (CWT) is a global leader specializing in business travel management. The IDSTUDIOS Project was involved in analyzing all related data for optimizing the travel programs and reporting the data to clients.

Responsibilities:

·         Understanding existing business model and customer requirements.

·         Installed, Maintained and Administered Cognos 8.3 BI.

·         Created Framework Manager Models, Power Play models and published to Cognos Connection.

·         Created various Technical, Business and Analysis layers in the Framework Manager Models.

·         Created Power Play Cubes with specific requirements such as Hotel, Car, Executive, Coupon, Air and Sub trip data based on Framework Manager Packages that were published to the portal. 

·         Implemented Time-based Partitioned Cubes, Cube views, Special time categories, alternate Drill downs and currency conversion in the cubes.

·         Automated the Cube Production pause/resume process thorough scripting when data loading to the database.

·         Published the Cubes as packages to Cognos Connection from Transformer for analysis in Analysis Studio.

·         Created reports including List Reports, Cross tab Reports, Chart reports from the Cubes and the Packages that are published to the Cognos Connection.

·         Created Burst reports and published the reports to the User Directory folders.

·         Created Jobs using Event Studio to sent notification to users when cubes were updated on a weekly basis level.

·         Used Cognos SDK to automate tasks and validate reports using Java.

·         Implemented Cognos Connection Security through Access Manager by defining Users groups, Roles and giving membership access to the users they belong to.

·         Provided training and support to End Users and assisted them in using the Cognos Studios for reporting and analyzing the data.

·         Closely worked with Cognos Support in fixing the issues & in identifying some of the product bugs.

Environment: Cognos 8.3 BI (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio), Cognos Power Play Transformer 8.3,Power Play Web, Cognos SDK, Oracle 9i,oracle SQL Developer, Java ,Access Manager,.

Cognos Developer, State Farm Insurance, CA

Apr 07’ to Mar’ 08                                          

State Farm has been in the business of providing excellent Automobile Insurance coverage at an affordable price since 1922. Auto Insurance is designed to help financially cover potential auto-related damages, loss or injuries. From analysis point of view the business is divided in 5 Specific areas: Policy, Vehicle, Driver, Claims and Coverage.

Cognos is used as BI tool and served as decision support system. Power Play Transformer is used for creating cubes, which enables users to slice and dice data in an intuitive way to provide data for Analysis purposes.

Responsibilities:

·         Created Power Play models and created cubes for publishing on to Cognos Connection.

·         Created Power Play Cubes with specific requirements such as Policy Distribution and Vehicle Distribution etc. 

·         Imported Cubes into Framework manager and published them as packages to Cognos connection for analysis in     Analysis Studio.

·         Created Driver, Vehicle, Policy and Claims Insurance Star Models in Frame work Manager.

·         Created Framework models and published to Cognos Connection so that users can query in Query studio and Report studio.

·         Star schema functionality was used to create history tables for analytical purpose /analysis reports.

·         Worked closely with business users and helped them use most of the Cognos 8 BI functionalities.

·         Configured Cognos 8 with Active Directory and implemented Security in Cognos at different levels (Groups and Roles) and used Capabilities feature to restrict Cognos access to different user groups.

·         Performed Sever Administration by monitoring Dispatchers, maintained database connections, high and low affinity processes, scheduled reports, maintained distribution lists and contacts.

Environment: Cognos 8 BI (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio), Cognos Power Play Transformer, Cognos Report Net 1.1MR2, Power Play Web, Upfront, MS SQL Server 2005

Cognos Developer, Alta Health & Life Insurance, CO 

Jan ’05 to Apr ’07            

                       

Alta Health & life insurance provides nationwide health care plans. It provides insurance upon the lives of human beings and against losses resulting from sickness, bodily injury or accidental death. Health insurance (accident and sickness) also includes agreements insuring against losses resulting from health care claims or expenses of health care.

It applies Cognos business intelligence to analyze and report on critical key performance indicators and drive corporate performance management initiatives throughout the enterprise. Analysis and reports created were involved in Member Appeals Automation, Clients reporting requirements on claims, prime alerts and Premium Analysis reporting.

Responsibilities:

·         Installing and Configuring Cognos applications such as Cognos Report Net, Cognos 8 BI tool.

·         Collecting user requirements and worked accordingly to the reporting requirements.

·         Created Power play Transformer Models, Power Cubes and implemented Drill through to Report Studio reports and Query Studio reports.

·         Published Power Play cubes & reports onto the Upfront using Power Play Enterprise Server.

·         Defined different user groups to provide high security for highly sensitive data.

·         Created List Reports, Cross tab Reports, Chart reports using Report studio and ad hoc reports using Query Studio.

·         Worked on developing standard Reports, Charts, Cross tab Reports, Drill-Through and Master Detail Reports enabling to understand and monitor current performance while planning future business strategies

·         Interacted with end users to identify key dimensions and measures that were relevant quantitative metrics in the analysis.

·         Used Framework Manager to model metadata from different SQL server data sources.

·         Created Framework Models with Star Schema groupings and published Packages to Report Net servers.

·         Worked as Administrator for Cognos Report Net and Cognos production environments.

Environment:  Cognos Report Net 1.1 MR2, 1.02 (Frame Work Manager, Cognos Connection, Report Studio, Query Studio), Cognos 8 BI, Cognos EP Series 7.3 Power Play, Transformer 7.3, Power Play Enterprise Server 7.3, Power Play Web, Access Manager, Upfront, Cognos Query, Scheduler), MS SQL Server 2000.

Download Resume Formathtm