Cognos Consulting

New Cognos BI resource 050311-001

2011-03-05T07:26:00.000-08:00

Email us if you would like to contact this new resource.

PROFESSIONAL SUMMARY

Over 12 Years of experience in IT includes 10 Years of experience in all phases of data warehouse development lifecycle, from gathering requirements to testing, Application Design, Development, implementation, and support. 2 Years in Web and Windows Application design and development using Microsoft technologies.

• Extensive experience in design and implementation of Data marts and Data warehouses using Cognos Suite 7 (Impromptu, Transformer, Power play, ReportNet) ; Cognos 8.1/8.2/8.3/8.4 BI.
• Experience on Cognos 8 BI tools (Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, PPES, PowerPlay Transformer, Data Manager, Cognos Macros) as a developer, administrator and Architect.
• Expert in creating Data Models in the Framework Manager from various data sources.
• Generated different kinds of reports in ReportStudio & QueryStudio, created templates and multilingual reports. Deployed the reports into various environments like test and production.
•Migrated Cognos Series 7 catalogs and reports to Cognos 8 using utilities.
• Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
•Solid understanding of data warehousing, OLTP and OLAP concepts. Performed data extracts.
• Working knowledge of designing multidimensional architecture for Extract, Transform, Load environment with Informatica and Cognos tools.
• Have experience in IWR (Impromptu Web Reports), Publishing using Upfront, maintaining Users, User classes, Deployment, Scheduling the Reports and sending Updated Reports to Recipients through E-Mail by using Notice Cast.
• Provided technical and functional consulting to corporate and divisional users for Cognos.
• Experienced in Data Mining, Multidimensional Data Analysis using Power Cubes.
•Extensively worked with databases like SQL Server 2000/2005/2008; Oracle 9i/10g.
•Experienced in Installing & configuring various Cognos environments. Customized environments using Cognos SDK.
• Good team player with excellent communication skills, analytical and learning new technologies.
•Strong experience in Client interaction and understanding business applications, business data flow and data relations.
•Having domain expertise in Finance, Insurance, Healthcare and Manufacturing.

•TECHNICAL SKILLS

BI TOOLS: COGNOS 8BI:
REPORTNET 1.1(MR1/MR2):
COGNOS SERIES 7.X:
DATA MODELLING TOOLS:
OPERATING SYSTEMS

LANGUAGES:

DATABASES:

SOFTWARE PACKAGES:

TOOLS & UTILITIES:

Framework Manager, Analysis Studio, Report Studio, Metric Studio, Event Studio

COGNOS connection, Framework Manager, Query studio, Report studio, Management Tools, Server Administration Tools, Configuration Manager, Scheduler.

COGNOS Impromptu Administrator, Impromptu User, Impromptu Web
Reports, COGNOS PowerPlay Transformer, PowerPlay User, PowerPlay
Web Reports, PowerPlay Enterprise server, Upfront Administration,
Access Manager, LDAP Server, Configuration Manager, Scheduler.

Informatica Power Mart 4.7, Power Centre 4.7, ER win 4.0, Cognos
Decision Stream 7.1

Ms-DOS, Windows 95/98/2000, NT, SCO-UNIX

SQL, PL/SQL, C, C++, VB 6.0, ASP.Net, VB.Net

SQL Server 2000/2005/2008, Oracle 9i/10g, DB2, MS-Access

MS-Office 2003, Microsoft Word, Excel and Power Point

Toad, FrontPage, Visual Interdev

PROJECTS PROFILE

AIG Insurance, NYC, NY
Cognos Architect

Project Description: AIG is a is a world leading property-casualty and general insurance
organization serving more than 40 million clients in over 160 countries and jurisdictions.
Worked on several projects like LRMS (Liquidity Risk Management System) and RPC (Regional
Pricing committee) for the enterprise Risk Management Team and Marketing Risk Management
Team.

LRMS Application is a Liquidity risk management system for calculating Assets Cash flows,
Liquidity Cashflows for various buckets. The systems also shows Sensitivities in the reports.

Regional Pricing Committee system helps in estimating Market Price, compare Market prices,
calculate variance between month ends for various products of the types Fixed Income and
Equities.

Contributions:
• Involved in interacting with the Business Analysts/Users to get the high level
requirements and translating them to functional definitions, and ultimately to technical
design and implementation.
•
Performed data quality analysis, gathered information to determine data sources, data
targets, data definitions, data relationships, and documented the business rules.
• Worked with data architects to develop data models, design specifications, and
metadata documentation.
•Prioritized the deliverables for the Developers based on Business priority.
•Interacted with the supporting IT groups, in order to ensure that there wouldn't be any
delays which would slow down the project progress..
• Analyzed the old reports in Java and did a reverse engineering to come up with the
design of Data Marts.
•Designed Data Marts with various Dimensions and Fact Tables.

(10/09) – Till Date

Implemented several complex queries in SQL and used Report Studio.
Used JavaScript to validation of prompt page and created several Conditional Block in
reports to display different outputs based on prompt page selections.
• Designed and implemented security at different levels, one at Framework Manager,
other at folder level in Cognos Connection and third was data level security built at division
level.
• Involved in defining mappings to build the Framework Manager Model and Package
with customized Query Subjects and Query items and published package from Framework
Manager to Cognos Connection.
•Presented the report deliverables to the Business Users for UAT and implemented the
changes based on their recommendations.
• Extensively involved in writing Oracle PL/SQL Procedures, Triggers, Views,
Materialized views and Sequences for the application.
•Involved in scheduling, distributing, bursting of reports.
•Involved in developing POC using Cognos TM1.
•Migrated successfully Cognos 8.4.1 reports to Cognos 10.

•Environment: Cognos 10, Cognos 8.4.1 BI(Report Studio, Analysis Studio, Query Studio, Event
Studio and Metric Studio), Cognos TM1, Oracle 11i, PL/SQL Developer,PVCS, Windows 2003

UBS, NYC, NY
Lead Cognos Developer

Project Description: UBS Wealth Management Reporting portal is highly functional and
Interactive portal where management, advisors can track client portfolio’s, identify the trends
and events affecting global and local markets, and apply them to the interests and financial
objectives of private clients.

Contributions:
• Interacting with the users for understanding of Data Analysis and gathering business
requirements.
• Prepared all the required documents for Cognos objects like high level design
documents, unit test plan documents.
•Worked with users for design finalizations and assessments of the requirements.
•Extracted and Transformed data from Heterogeneous Databases based in SQL Server
2005, DB2 UDB and Oracle 10g using Decision Stream.
•Presented proof of concept to demonstrate that heterogeneous data sources can be used
in Cognos.
•Worked with data architects to develop data models, design specifications, and metadata
documentation.
•Assist in the development and architecting data warehouse initiatives and reporting needs
for the business.
•Design and create complex framework manager models connecting to various databases
like Oracle, SQL Server and DB2 UDB in a single model. Also making the model
consistent with the reporting requirements.
•Performed model refinement from time to time to enhance performance by incorporating
lookup tables to avoid CASE and DECODE statements used at Framework Manager
level.
• Involved in defining mappings to build the Framework Manager Model and Package
with customized Query Subjects and Query items and published package from
Framework Manager to Cognos Connection.
•Created folders, filters, prompts, and complex business calculations in Framework
Manager Model.
• Expertise in developing Standard Reports, List Reports, Cross-tab Reports, Charts,
Multiple-levels of Drill through Reports and Master Detail Reports Using Report
Studio.
•Created Ad-hoc reports in Query Studio for users.
•Customized reports using Cognos SDK according to reporting requirements.
• Created Score Cards, Dashboards and Key performance Indicators for decision support

(04/08) – (09/09)

using Metric Studio.
Scheduled reports, maintained public and individual folders, user groups and roles using Cognos Connection in Report Studio. Extensively worked on Performance tuning, Testing and validating the data in Cognos.

•Environment: Cognos 8.4 BI, Cognos 8.3 BI (Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio and Metric Studio), Cognos Decision Stream 7.1, SQL Server 2005, Oracle 10g, TOAD 8.6, Windows 2003

IFC (International Finance Corporation), Washington, DC
Cognos ReportNet Consultant

Project Description: CAPRI (Capital Pricing and Risk) application objective is to provide the
business analyst an integrated data and a flexible analysis and reporting framework, for their
financial and risk assessment activities in the department IFC of World Bank.

Contribution
• 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.
• Created Relational Data models and Dimension Data models using Framework
Manager to represent the business information and making the model consistent with the
reporting requirements.
•Created User Groups, Roles in Cognos Connection to implement the Security Filters in
Framework Manager Model.
•Created Technical Specifications and Functional Specifications for all reports.
• Created Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple-levels of
Drill through Reports and Master Detail Reports Using Report Studio.
• Created, organized and formatted reports, folders and other contents on Cognos
Connection Portal.
•Developed Cognos transformer models using Cognos Powerplay Transformer.
•Developed Analysis studio Reports and cubes using Analysis Studio.
•Developed Customize and Burst Reports using Report Studio.
• Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.
•Created Run and Schedule Reports and Jobs using Cognos Connection.
•Provided technical assistance, training and mentoring to Users and Business Partners.

Environment: Cognos 8.1 BI (Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio and Metric Studio),Oracle 9i, Windows2000 Server

GSK (Glaxo Smithkline), King of Prussia, PA
OLAP Developer

Project Description: The purpose of the Profit Management Analysis and Reporting (PMAR) Tool is to enable GSKTS (GSK Trading Services) and GSKE (GSK Export) to perform the profit management reviews. These reviews are required to ensure that the target profit is achieved by GSKTS and GSKE.

In addition to transfer prices and sales volumes, the profit is also dependent on associated expenses and costs for example Promotional expenses, Freight charges etc for which the allocation will be performed in PMAR.

(08/06) – (03/08)

(01/05) – (07/06)

Contribution
• Involved in Installing and Configuring ReportNet Server, Framework Manager, Report Studio, Query Studio and Cognos Connection Portal.
•Interacted with business users for their requirement.
•Involved in Startegic Planning for Cognos ReportNet Framework Model.
•Built Models and published Packages utilizing Framework Manager.
•Created database connections for different data sources.
•Created Reports (Simple & Complex) using Query Studio and Report Studio for training purpose.
• Created, organized and formatted reports, folders and other contents on Cognos Connection Portal.
• Created several different types of ad-hoc (Simple List, Grouped List, Section Heading, Crosstab, and Nested Crosstab) Reports and represented data graphically by Charts utilizing Query Studio.
• Created several different types of Professional Reports (Mailing Labels, Cascading, Linked /Drill Through, Production, Business, Ranking, etc.) with complex formatting utilizing Report Studio.
•Loaded data from the files got in different formats into the development and production systems using DTS.
•Used DTS to migrate the existing data from MS-Access to Sql Server 2000.
•Worked with ETL team in designing the data model using Star Schema.
• Created a model using Framework Manager and packed the model with Reports and published on to the ReportNet Server.
•Developed Customize and Burst Reports using Report Studio.
• Produced Queries and Reports in Multiple Languages, Format, Present and Distribute Reports utilizing Different Layouts, Multiple Report Objects and Multiple Logical Pages.
•Created Run and Schedule Reports and Jobs using Cognos Connection.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
•Tested and debugged Cognos metadata layer reports.
•Developed Standard templates in Report Studio for developing reports.
•Performed Unit testing for all developed reports.

Environment: Reportnet1.1MR2, Framework Manager, Query Studio, Report Studio,
Cognos Connection, SQL, Oracle 9i, TOAD 7.4., UNIX

CISCO, San Jose, CA
Cognos ReportNet Consultant

Project Description: Sarbanes-Oxley Express (SOX Express) is an Internal Controls Management System that empowers CEOs, CFOs and financial management officers to document internal controls as setup by the Sarbanes-Oxley Act.

SOX Express allows users to easily see the status of their internal controls documentation project, and provides a secure repository for the storage of their IC documentation.

SOX Express has many features that assist users in documenting their internal controls. Some of the most important are:
• The Compliance Repository
• Powerful Compliance Automation
• Configurable Interactive Monitoring
• Unparalleled User Productivity

Reports which help the management to view the data captured using Sox Express tool are
developed using Cognos ReportNet.

Contribution
•
Co-ordinate with On-site team in gathering the business requirements of reports.

(01/04) – (12/04)

•

Modifications in the package already developed by Open Pages (Third Party) based on the reporting requirements.
Responsible for getting the reports developed by the team members and delivering the same to the user after doing unit testing Deployed packages, folders, and content store in production environment.

•Environment: Cognos ReportNet 1.1 MR1, Oracle 9i, TOAD 7.4., UNIX

CISCO, San Jose, CA
ETL Developer

Project Description: Channel Bookings, maintains the orders CISCO gets from customers.
Bookings could be Entered i.e., customer places an order and Not Cisco Booked (NCB) i.e.,
Order raised but not purchased or No revenue on that order. After the order is booked, if it
satisfies the Cisco Policy then it is Invoiced and then GL-posted, Credit Memo or Debit Memo
accordingly.

Contribution
•
Co-ordinate with On-site team in gathering the business requirements.
• Developed and implemented the enhancements in ETL procedures using Informatica tool and deployed successfully.
•Developed and implemented PL\SQL procedures.
•Involved in testing phase.
• Responsible for documentation of the anticipatory risk factors where failure of the ETL mappings can take place and necessary steps to be taken when failure occurs.

Environment: Informatica Power Mart 4.7, Power Centre 4.7, Oracle 9i, TOAD 7.4.,Unix

Bear Stearns (Investment Banking firm),NYC,NY
Cognos Consultant

Project Description: Bear Stearns is one of the leading companies in Investment Banking. Bear Stearns plan was to migrate all their reports from Infomaker, Power Builder to Cognos Impromptu. There were nearly 200 reports to be converted into cognos - impromptu from power builder. Impromptu reports were developed using catalog where the catalog is built using tables, views and stored procedures (OLTP design). The reports were developed in impromptu and published in Upfront where the user is provided to view the report in four
different formats (Pdf, Excel, CSV, Html). Power prompt applications for some of the above mentioned reports are also developed to facilitate the validations of input parameters more appropriately.

Contribution

•Interacted with the users for understanding and gathering business requirements.
Involved in the analysis, design, develop, testing, deployment and user training of analytical transactional reporting system.
Involved in design and development of user classes, filters, calculations, prompts and conditions in Catalog and query definition files in Impromptu Administrator.
Optimized by assigning relative weights to the tables in the Catalog and Query Performance (in Governor's settings).
Created Catalog in Impromptu Administrator to create Reports.
Generated reports using Cognos Impromptu tools querying database.
Created list reports and cross tab reports and drill through reports.
Created various Drill through reports from report to report.
Created User Classes and Users in Access manager.
Created Cubes by using Cognos Power Play to analysis.
Worked on Cognos Security Administration to restrict the Users.
Created Models by using Impromptu Query Definition (IQD) in Power Play
Transformer.

(12/02) – (12/03)

(08/01) – (11/02)

Extensively worked on Power Prompts.
Used Power Prompts Developer Studio for Designing Application.
Created Prompts to User Defined Filters.
Used Power Play Enterprise Server to publish the cubes.
Maintain the Cube Security by Category level and Dimension level.
Used Cognos Scheduler to schedule the Reports.
Updated Impromptu Catalog by adding tables and creating new joins.
Good knowledge in Unit/integration Testing.
Extensively worked on TOAD tool, testing the queries.
• Discussed business requirements and mapped business needs using Cognos Transformer.
•Successfully developed and implemented Metrics using Cognos Impromptu.
•Developed Visualizer Charts to make better decisions.
• Installed, Configured and did Performance Tuning Cognos EP Series as Business Intelligence tool.

•Environment: COGNOS EP Series (Impromptu Administrator, Impromptu Web Reports Power
Play, Transformer, Power Play Enterprise Server, Access Manager, Server Administrator,
Upfront (for Web),Power Builder,DB2 (UDB) 8.1,Windows2000 Server

Universal Textile Mills , India
Cognos Consultant

Project Description: Processes that Identify, Prioritize and Improve areas of performance that have the greatest impact on customer loyalty. Keep as many customers as possible, keep them satisfied, keep them loyal, and keep them for life. Measuring their performance over time and against competitors, how they drive customer feedback through the organization to build lasting customer relationships.

Contribution

•Extensive interaction with Business Users and gather information and requirements.
Installed and configured Cognos Power Play and Impromptu software
Developed reports like drill through reports, sub reports, list reports using Cognos Impromptu.
Created catalogs from multiple databases with the help of Hot Files (.ims)
Enhanced the existing reports and created new reports as per the user requirements.
Handled optimization of queries for better response from impromptu.
Created Models by using Impromptu Query Definition (IQD) in Power Play Transformer.
Created Catalog and assigned joins as per the requirements.
Generated the reports using Cognos Impromptu by querying the data from different database tables as per the requirement.
Customized the reports by adding calculations, conditions and functions.
Created List Reports, Cross Tab Reports and Drill through reports.
Created Filters, Conditions and Prompts in Catalog.
Defined, created, maintained and published Power cube and PowerPlay web reports and published IWR reports on the web.
Worked extensively on Oracle database. Troubleshoot for SQL issues/performance issues.
Participated in the development of catalogs, multiple queries with complicated reports and query definition files using various join and filter conditions in Impromptu.
Created Dimensional Maps, Transformer Models, Power-Cubes and Drill through.
Did detailed reports, catalogs, folders filters, prompts, calculated columns and conditions for multi dimensional analysis.
Published on IWR Server.
Worked extensively with Power Play Enterprise Server and the Upfront in publishing the cube.
Automating tasks with Cognos Scheduler using Macros, Cognos Script Editor and Cognos Script Dialog Editor.

•(03/00) – (07/01)

•Optimized Catalog by using Database Interaction, Client/Server balancing, Database functions, Table Weighting and Qualification, Governors Settings.

Environment: Cognos EP Series 7, SQL Server 7.0, Windows 2000

Client Dalmia Securities Limited, India
Senior Developer

Project Description: BrokBO is the Product, which handles the brokers back office activities.
This product provides a complete solution to automate the back office activities. The system allows to define various related brokers and handle their trading activities like…

•Processing the trade files (both Capital Market and Futures & Options)
•Handling the Deliveries of Securities to Clients and Stock Exchange.
•Managing Accounts of Brokers defined in BrokBO system.
Generating various reports for brokers like trade summary report, Obligation reports, service tax reports, stamp charges reports etc.,

Contribution

Responsible in the Analysis of client specification, designing and documentation.
Developed dynamic web pages using ASP.NET.
Involved in manual functional testing.
Developed Test Scenarios and Test Cases.
Responsible in the analysis and evaluation of third party tools.
Responsible in developing stored procedures and database design in SQL Server

Environment: Asp.Net, VB.Net, Ado.Net, SQL Server 7.0, Windows 2000

Delco Remy Electricals India Ltd, India
Senior Developer

Project Description: Information Management System (IMS - Prod) is a Production based system including Production Plan, Material Requirement Plan and Marketing plan. Basically it is made in to a product which suites any type of production environment. The various modules included in this product are Marketing, Engineering, Purchase, Stores, Sub Contract, Production and Dispatch. Each module deals with the corresponding department in depth to input all the required data and let us to analyze the data for generating detailed reports for designing the plans (like production plan, marketing plan etc)

Contribution

•Responsible in design and development.
Developed dynamic web pages using ASP.
Responsible for developing Database design.
Responsible for developing User Interface.

•Environment: Visual Basic 6.0, Ms-Access2000 / Oracle, Windows 98

Academic Qualification:

Msc (S/W Applications), Bharathiyar University, Coimbartore, India
BSc(Computer Science) , Sri Venkateswara University, India

(03/99 - 02/00)

(06/98) – (02/99)

Certifications :

1. Cognos ReportNet Modeling Product Professional
2. Cognos ReportNet Server Administration
3. PowerPlay Series 7 Product Professional

New BI Resource Available 20100919-001

2010-09-19T17:29:00.000-07:00

New BI Resource Available 20100919-001

Email us today if you`re interested in this resource

Looking for a part-time remote Cognos Developer/Architect job.

Experience developing different Cognos solutions for last 4.5 years as an architect/developer/project manager.

new cognos job

2010-07-15T19:51:00.001-07:00

http://c8jobs.blogspot.com/2010/07/forrester-research-is-hiring-for-data.html

Cognos 8 Diagnostic: Cognos 8 Diagnostic tools are coming soon...Be s...

2010-07-08T17:58:00.000-07:00

Cognos 8 Diagnostic: Cognos 8 Diagnostic tools are coming soon...

Be s...: "Cognos 8 Diagnostic tools are coming soon... Be sure to visit: http://bicentre.blogspot.com/ http://bicentresdkguide.blogspot.com/ http:..."

New BI Resource Available 20100427-001

2010-04-27T18:18:00.000-07:00

Email us today if you`re interested in this resource

To work with team spirit in an esteemed organization where my knowledge of Information Systems can be utilized in organizational and personal growth. A challenging position in the field of Information Systems that would provide an opportunity for learning and applying Software Engineering and Database Development skills based on the knowledge of current tools, trends and technologies. I am confident, self-motivated and hard working. I usually get pleased to meet new people and user groups to keep myself up to date. I am target oriented and willing to swim on horizon of Information Technology Management.

Summary:

A Senior Application Developer/Team Lead with over 5 years experience in full Life Cycle development including business analysis, architecture, design, development, deployment & Management using Microsoft technologies. Extensive experience in Design & Architecture of Data Models and Database for MS SQL Server. 3 years of experience in Business Intelligence using Pentaho, Cognos 7 and Cognos8. 3 years experience in designing and developing desktop applications on Microsoft platform using VB, VB.NET, SQL Server 2000 and Crystal Reports. Have domain knowledge of various businesses like Banking, Stock Exchange, Mortgages, E-Learning and Insurance division. Developed various desktop and web enterprise applications using Cognos, VB, VB.NET, Crystal Reports, Teradata, Microsoft SQL Server and MS Access.

Technical Skills

B.I Tools: Cognos 7, Cognos 8, Pentaho Kettle

Databases: Teradata, MS SQL Server 2000 & 2005, MS Access, Oracle and DB2.

Languages: VB, VB.NET.

Development Tools: Visual Studio.NET, MS Visio, MS Project and MS Office.

Reporting Tools: Crystal Reports, JReports, Active Reports, SQL Server Reporting Services, Crystal Xcelsius

Live Cycle Tools: Adobe Live Cycle Designer 7.1 & 8.1

Version and Source Control: Visual Source Safe, SVN

Education & Credentials

SZABIST- Karachi, Pakistan

M.S in Computer Science, completed in 2006 with 3.66 CGPA.

BAHRIA UNIVERSITY- Karachi, Pakistan

B.S.E in Computer Science, completed in 2004 with 3.28 CGPA.

Adamjee Science College- Karachi, Pakistan

Intermediate – Pre Engineering , completed in 2000 with B Grade.

Al Murtaza School- Karachi, Pakistan

Matriculation - Science, completed in 1998 with A Grade.

Awards

Certificate of Achievement – Outstanding Performance from RBS
Exceptional Team Award from Systems Limited.(Worked as Component Lead in this project)
Outstanding Team Award from Systems Limited.(Worked as Team Lead in this project)

Professional Experience

From: December 2009-Till Date Data Warehouse Engineer at 360Training

Description:

Responsibilities include Designing and Development of Data warehouse and to keep intact with all of the systems running in company. Be involved in full life cycle development and implementation of enterprise data warehouse, BI reporting and analytical services.

Designed and Developed Data Warehouse to be capable of containing all Revenue Related Data. Tools: SQL Server 2005/2008
Developed ETL to migrate data from all the Systems that are currently being used in company which include Virtual University , Learner MS , Learner Course MS , My Classroom Management. Tools: Pentaho Kettle , SQL Server 2005/2008
Improvement of the Database Designs and Optimization of queries that are not performing effectively. Tools: SQL Server 2005/2008
Working with Network Operations team to resolve Performance and Other Database related issues. Helping out other teams in Query Optimization and Database Development.
Migration of Store Front(IBM) Data to Data Warehouse . Tools: Pentaho Kettle , SQL Server 2005, DB2
Migration of Quick books Data to Data Warehouse . Tools: Pentaho Kettle , SQL Server 2005, QODBC

From: June 2008-December 2009 Assistant Manager – Business Intelligence Unit at RBS

Description:

Responsibilities include Managing a Data Warehouse, understanding new requirements, analyze the problems, suggest the solutions, implement the changes, develop BI analytics such as (Reports, Cubes and Dashboard), and perform the verification with associate department.

Developed Cubes for Operations, AD&E, Liabilities and Asset Marketing by which user can perform various analytics like Cross Sell, CM Retention and Segmentation. Tools: Cognos 7, Teradata
Designed strategic reporting for Consumer Risk Management some of which includes IS-Was analysis, Vintage Analysis, Utilization Analysis, Collection & Collection Performance Reports, and Product Caps Report. Tools: Cognos 8, Teradata
DWH Administration Tools: Teradata
Providing demand analytics and reports for different departments like Operations, Finance, AD&E, Business Quality, Branch Banking, Wealth Management Unit, Secured Assets and Unsecured Assets. Tools: Teradata, Excel
Designed and Developed Reports & Dashboards for Business Heads/Branch Banking Users which include Weekly Dashboard , Monthly Dashboard , Comparison of Current Picture with SPLM , Branch Performance Report , Turnover Report, Account Deepening Report.

Tools: Teradata, Cognos 8

From: Feb 2007-May 2008 Senior Software Engineer at Systems Limited

Description:

Responsibilities include Managing Team, understanding new requirements, analyze the problems, making project plan, initiate development and implement the changes, updating stakeholders, taking care of each and every step from analysis till deployment.

Worked as DBA/Team Lead for Reporting Module/Forms of Victors Application designed for Lenders First Choice (Title Insurance Application). Tools: Cognos 8.2 (BI Tool) / SQL SERVER 2005 (Back end)/Adobe Live Cycle 7.1,8.1(LiveCycle Tool)
Worked as Team Lead for Reporting Module of Registrar/Transfer Authority system designed for Central Depository Company. Reports were designed for Corporate Actions, Administration, General, Transfer and SBP sections. Tools: JReports (Reporting Tool) / Oracle 10g (Back end).
Developed the Reporting module of Visi Loan Review designed for Bank of America and Freddie Mac. Reports for all type of loans were developed.

Tools: Crystal Report (Reporting Tool) / SQL SERVER (Back end) / ASP.NET (Front end)

From: July 2006-Feb 2007 Software Engineer at Wavetec Pvt. Ltd.

Description:

Developed Stock Game for Dubai Financial Market. This project is a game and all the operations and functionality are same as of Real Stock Market. SG is designed for the competition which is arranged by DFM for the students of different schools every year. Important feature of this project is that it was designed in such a way that it’s not restricted to one market and one student can play in more than one market at a time with the same portfolio affected. Tools: ASP (Front end) / SQL SERVER (Back end).
Designed and Developed eqConfiguration System. This project is basically a configuration system for Electronic Queue Management System It was designed various clients in UAE. This project has two other parts, which are Desktop Ticket Dispensing Unit, which talk with router and get the ticket number and then print that ticket, other part was LCD TDU Screen that is a picture based screen, it also have the same functions as Desktop TDU, but from pictures. Tools: VB 6.0 (Front end) / SQL SERVER (Back end) / ROUTER (Linux Based)
Designed and Developed Attendance Management System for HR Department. Basically this project was having two parts, one was related to Attendance itself and other was a small portion of HR, so that other salary calculation and other matter of HR could also be resolved using this system. This project also consists of some reports and other process to implement other management policy. Tools: VB.NET (Front end) / SQL SERVER (Back end) / Crystal Report (Reporting)

From: March 2005-July 2006 Assistant MIS at Crescent Leasing Corporation Limited

Description:

Designed and Developed Lease Management System. This project consisted module for Leasing, Depreciation, Assets and CIB. Tools: VB 6.0 (Front end) / SQL SERVER (Back end) / Crystal Report (Reporting).
Developed CresTreasury. This project consist modules for Treasury and Money Marketing. Tools: VB 6.0 (Front end) / SQL SERVER (Back end) / Crystal Report (Reporting)
Developed Attendance Management System. This project was having two parts, first the interface with the IGAURD Machine which recorded the Attendance and secondly the reports and other process to implement other management policy. Tools: VB 6.0 (Front end) / SQL SERVER (Back end) / Crystal Report (Reporting) / IGAURD (Server)
Designed and Developed ChequeInfo System, which main aim was to do the cheque management and other issues related to cheques. Tools: VB 6.0 (Front end) / SQL SERVER (Back end) / Crystal Report (Reporting)

Does your Cognos 8 report need to follow Section 508?

2010-04-24T06:38:00.001-07:00

http://cognos8help.blogspot.com/2010/04/section-508-compliance-guide-now.html

new cognos job

2010-04-08T19:08:00.000-07:00

http://c8jobs.blogspot.com/2010/04/ibm-cognos-business-intelligence.html

New Cognos Job

2010-01-09T19:07:00.001-08:00

http://c8jobs.blogspot.com/2010/01/senior-technical-specialist.html

New Cognos Job

2009-10-12T20:00:00.001-07:00

http://c8jobs.blogspot.com/2009/10/cognos-planning-and-performance.html

20090702-001

2009-07-02T04:51:00.000-07:00

Email us today if you're interested in this resource.

PROFILE

Around 56 Months of IT industry experience. Currently, working as a Senior Software Proffesional for TietoEnator Corporation, Pune for last 2 months. Experience in BI - Cognos 8.

Earlier experience – Worked for HSBC Software Development India Pvt Ltd for 54 months as Senior Software Engineer.

SKILL

Reporting	Cognos 8, Framework Manager, OLAP/DMR Modeling, Report Studio, Query Studio, Analysis Studio, Powerplay-Transformer.
Web Programming:	Core Java, JavaScript, HTML, XML, XSLT
Databases:	Oracle, DB2
MISC	UML, Rational Rose, Quality Center, Dom Doc, Clarity

TRAINING:

CA Unicenter based (At Computer Associates training center - Chicago):

UR376 Unicenter Service Desk: Analyst Operations
URV386 Unicenter Service Desk: Administration

Cognos Reporting (At Cognos Incorporated training center - Chicago):

Cognos 8 BI - Report Authoring - Part 1
Cognos 8 BI - Report Authoring - Part 2
Cognos 8 BI - Metadata Modeling - Part 1
Cognos 8 BI - Metadata Modeling - Part 2
PowerPlay OLAP Modeling for Series 7 Version 3 & Cognos 8 BI
Cognos 8 BI - Server Administration
Cognos 8 BI - Content Administration

PROFESSIONAL EXPERIENCE

TietoEnator Corporation, Senior Software Proffesional (May 2009 – Till date)

HSBC - Pune, Senior Software Developer (Nov 2004 – May 2009)

Project Details:

Project Name:	Gepardi - Mankeli Reporting (Cognos 8 Reporting)
Duration:	May 2009 – Till Date
Organization:	TietoEnator Corporation, Pune
Client:	Elisa Telecommunications, Finland
Summary:	Elisa Telecommunications is Finland’s second largest telecom company. Gepardi is the project contains around 120 applications which are maintained and enhanced by TietoEnator. Out of 120 applications 25 applications are BI applications and Mankeli is one of the 25 applications which is the most important reporting solution as it is the financial reporting for Elisa. Mankeli reporting is used as CMS (Corporate performance management solution) by finance department to report on the sales data on monthly, quarterly, six monthly, year to date and yearly basis. Earlier this project was maintained and enhanced by IBM and we have taken over the project from them. Proper knowledge workshops were organizes at Elisa premises in Finland. I was there at Finland to represent Cognos Reporting area. Also the project involves Informatica and Oracle related work. Cognos system has 12 packages, 5 CUBES, 120 reports and 470 users.
Role:	Development Lead: Attended Knowledge transfer sessions at Elisa premises in Finland by IBM to TietoEnator Corp. Involved in acquiring knowledge about Project Architecture (both technical and business). Involved in knowledge transfer on existing Cognos reporting solution. Prepared resource estimation based on the work for next quarter. Prepared workshop notes which will help the new team members who will join the team. Prepared the ROTA for taking up support stuff
Environment	Cognos 8

Project Name:	Global Service Desk (Cognos 8 Reporting)
Duration:	Aug 2006 – May 2009
Organization:	HSBC GLT Pune
Client:	HSBC USA
Summary:	Global Service desk is service management tool. This will be used across HSBC group to log and record incidents, problem, request, issues, and change order. This application will be implementing the best practices of ITIL recommendation on to the out of box application from CA called Unicenter Service Desk. We are creating reports out of both real time database i.e. Oracle and Data warehouse i.e. DB2 for customers all over the globe in HSBC. We have reports out of relational model and cubes.
Role:	Framework Modeler and Report author. Analysis of user requirements. Involved in Data warehouse design Identify fields from OLTP system to be migrated to Data warehouse depending on reporting requirements Creation of data warehouse requester spreadsheet Written transformation logic to de normalize data warehouse Written scripts to test data in data warehouse in all three environments viz Dev, UAT and PROD Involved in metadata modeling using framework manager. Involved in creation of IQD for input to Transformer. Involved in creation of Dimensional data model. Involved in preparing Prototype (Screen mockups for reports). Involved in preparation of Unit Test Cases Involved in Framework Modeling and peer review. Involved in development of reports. Working as Onsite coordinator at client side in Chicago US. Coordinating with client on user requirements and responsible for all the deliveries from offshore. Involved in development of reports. Supporting the existing reports and working on amendments to reports post production of release 1.
Environment	Cognos 8

Project Name:	Global Service Desk – PLADA Integration (Cognos 8 Reporting)
Duration:	Jan 2006 – July 2006
Organization:	HSBC GLT Pune
Client:	HSBC USA
Summary:	PLADA stands for Performance Level Agreement Database Application. PLADA is tool to document service level agreement between IT Service and business.
Role:	Started analysis of PLADA OLTP system (Oracle). Based on reporting requirements I will be designing data warehouse.
Environment	Cognos 8

Project Name:	Global Service Desk (Customization of CA Unicenter Service desk as per HSBC Global requirement)
Duration:	Jun 2005 – Dec 2005
Organization:	HSBC GLT Pune
Client:	HSBC USA
Summary:	Global Service desk is service management tool. This will be used across HSBC group to log and record incidents, problem, request, issues, and change order. This application will be implementing the best practices of ITIL recommendation on to the out of box application from CA called Unicenter Service Desk.
Role:	Software Developer – Team Member Understanding of design and architectural documents. Involved in preparation of Page Specification and Functional Specification Document. Involved in preparing Prototype. Involved in preparation of Unit Test Cases Involved in coding and peer review. Worked for 18 months as Onsite coordinator at client side in Chicago US. Coordinating with different offshore teams i.e. Development Team, Cognos Reporting Team, Testing Team and Technical Writing Team. Involved in promoting the package from development to UAT and then from UAT to Production environment. Involved in Requirement discussion for Reports (Using Cognos). Involved in development of reports.
Environment	Unix, Oracle, HTMPL and spell code (propriety CA’s Language.)

Project Name:	HSBCnet eSecurities
Duration:	Jan 2005 – Jun 2005 Worked on four releases i.e. Release 8, Release FT2, Release 9 and Release 10.
Organization:	HSBC GLT Pune
Client:	HSBC Vancouver Canada
Summary:	HSBCnet is the service provided by HSBC to its corporate clients. HSBC eSecurities plays the role of custodian. HSBC Securities Services (HSS) provides comprehensive global, regional and domestic securities services to corporate and institutional clients. Development and testing (unit and end-to-end) for eSecurities as per technical specifications provided and to the HSBCnet and the eCommerce CoE general development guidelines
Role:	Software Developer – Team Member Preparation and Understanding of design document i.e. Use Cases, EDR, and IDR. Involved actively in writing Unit test cases and E2E test cases uploading them to Quality Center and also involved in manual execution of test cases. Involved actively in XML, XSLT and Java Coding. Involved in peer-peer testing phase. Worked as Onsite Coordinator for four months at client side in CANADA.
Environment	XSLT, Servlets Using UIMS AND EBSA Framework Web Server/Application Server: WepSphere 5.0 IDE: WSAD 5.1.2

EDUCATION

July 2004

Bachelor of Engineering (Information Technology), RGPV University, Bhopal

Remote Cognos Development Opportunity

2009-07-01T09:29:00.001-07:00

Does your organization require temporary support doing Cognos development? If so, then the BI Centre can give you that short term, or long term, support to help you meet your deliverable.

We can assist with model development, report development, SDK coding, testing, QA, technical documentation and even project management.

Feel free to contact us today to discuss your needs.

email: businessintelligencecentre@gmail.com

3+ years Cognos Developer -- 20090125-001

2009-01-25T07:27:00.000-08:00

Email us today if you're interested in this resource.

Professional Summary

Having 3+ Years of experience in IT industry of which 2.9 years of experience in the area of data warehousing as a Report developer
Extensive experience in Cognos Report Net 1.1,Cognos Impromptu
Having knowledge in Cognos 8, Cognos Power Play and Framework manager
Developed different types of reports using Report studio, Query studio and Cognos Impromptu
Excellent knowledge in Data warehousing concepts
Can play a vital role in the team and able to absorb technical knowledge quickly

Employment History

Working as a Cognos Consultant for Satyam Computers, hyd, since july2007 to Till Date.
Worked as a Software Engineer for FCG SOFTWARE, Bangalore from Sep 2005 – July 2007.

Technical Skills

OLAP Tools : Cognos Report Net 1.1, EP 7 Series and Cognos8

ETL Tools : Informatica 7.1.1

Databases : Oracle 9i

Operating Systems : Windows 2000/XP

Languages : C, C++ and SQL

project profile

Project #1

Title : Sales Information System (Aug 2007 to Till Date)

Client : San Miguel Corporation (SMC)

Environment : Reportnet1.1, Oracle 9i

Role : Report Developer

Description:

San Miguel Corporation (SMC), Philippines is the largest publicly listed food, beverage and packaging company in Philippines. SMC's food and agribusiness units make animal feed, Coconut oil, dairy and meat products the scope of this Project is to capture the Sales and Marketing processes and data warehouse to maintain client’s history and current data. Data

From Operational Source System was extracted, transformed and loaded into data warehouse

Responsibilities:

Developed Master detail, drill through and rank reports by using report studio.
Created Daily backups by using Cognos Connection
Reviewed the reports developed by other team members.
Created HTML Items , packages , templates and reusable components
Developed Complex reports by using Conditional formatting and Conditional blocking
Interact with client on a daily basis and Detailed Requirements Study

Project #2:

Title : 7Eleven Sales analysis (May 2006 to July 2007)

Client : 7Eleven, Malaysia

Environment : Cognos impromptu, power play

Role : Report Developer

Description:

7Eleven is one of the largest retail companies operating in Malaysia. It manufactures and distributes a wide variety of retail products. This is designed for the purpose of sales analysis that basically helps the decision makers to analyze the sales. This system helps to keep track the impact of advertising and other promotion on sales. It is also used to test the effects of pricing changes and varying media weights on local markets. It can compare today’s sales results to those of previous year, as well as compare results among chains, geographic regions, and products down to the brand level.

Role& Responsibilities:

List Reports, Cross-tab Reports and Drill-through Reports.
Created reports using cascading prompts.
Created various types of reports Developed for various user levels.
Queried from different database tables as per the requirement.
Scheduling the reports.
Created and enhanced existing Power Cube as per user requirements.
Imported IQD files created in impromptu into transformer to construct a power cube Involved in optimizing Power Cubes.

Project #3

Title : Extra Mile Sales analysis (Sep 2005 to Apr 2006)

Client : Extra Mile, USA

Environment : Cognos impromptu and Oracle 9i

Role : Report Developer

Description:

Extra Mile, a global scale, it supplies collection of products to consumers like sports products, outdoor products, home appliances and fruits. Extra Mile sales does business in participating suppliers provides the largest selection of high quality merchandise available anywhere. Marketing strategies are based on built purchasing of slow selling, first quality merchandise and reselling these goods at discount prices. Suppliers store products until they are ordered. Reporting requirements are many and diverse and include standard accounting, sales, financial, marketing and inventory.

Role & Responsibilities:

Have done modifications to the catalogs
Created Catalog prompts, Conditions and Calculations.
Created cross tab report, mailing labels reports by using cognos impromptu.
Created Snapshot, Hot file, Thumbnail reports.
Worked on giving privileges to the User profiles like Governor settings, Table access, Folder access
Scheduled various reports

Educational Qualifications:

· BS.C(COMPUTERS)FROM S.K.UNIVERSITY.ATP

Cognos Developer -- 20080819-0001

2008-08-19T15:04:00.000-07:00

Email us today if you're interested in this resource.

OBJECTIVE

I am looking for a challenging position in the IT industry, which shall provide me with opportunities to explore my potential.

educational qualifications

EXAMINATION	BOARD	INSTITUTION	AGGREGATE
BE, Computer Science And Engineering	Visveswaraih Technological University	Kalpataru Instituteof Technology,Tiptur	65.10%
II PUC	Pre university Board, Karnataka	VVNL PU college Jogfalls Shivamogga(dist)	62.16%
SSLC	State Board, Karnataka	Government High School Kargal Shivamogga(dist)	82.32%

Completed Bachelor of Engineering in Computer science and Engineering in the year 2007

SKILL PROFILE

Primary Skills :	C, Java, SQL, Data modeling, Data warehousing and BI concepts..
Platform:	Windows 98, Windows XP, Linux
ETL Tool:	Microsoft SSIS
OLAP Tool:	COGNOS 8: Query Studio, Report Studio. Framework Manager

Experience SUMMARY

1.8 years of experience as a DWH and BI developer at Aviana nrit,Bengaluru.
Expertise, knowledge and hands on experience with MS SSIS 2005
Extensive experience in Extraction, Transformation, Loading (ETL) data from various Sources into Data Warehouses and Data Marts.
Exposure to COGNOS 8(Query Studio, Report Studio, Framework Manager)
Zeal and ability to learn new concepts, new tools.
Sincere and hard working.

PROJECTS:

1.Project Details

	Insurance BI System
Client	ING Vysya
Role	DWH and BI Developer
Organization	Aviana Nrit limited, Bangalore
Environment	Windows 2000, Cognos 8 BI, SSIS, MS SQL Server 2005,
Duration	Feb 2007 – Jun 2007

Description

The project involve in BI solution (the “Insurance BI System”) for a “standard” insurance company, which gives support to e-Reporting system that can serve as web based analytical reporting process using Cognos suite of BI products. The IBI System will depend on underlying data marts.The IBI System will support the reporting structure followed in the insurance banking industry, and be designed to be customizable according the needs of specific customers. Customizable dimensional model is core of the IBI Data Mart solution. This model serves as a base for rapid implementation of insurance banking business intelligence applications.

Responsibilities:

Understanding the Business Requirement and Design as per it.
Developed a solution to the need by gathering and analyzing client data.
Generated I.Q.D files from Impromptu as a source for power play cubes
Performed calculations and conditions in Impromptu reports
Knowledge in making the model plans in Power Play Transformer to Generate Power Cubes
Standard Reports like Simple to Cross-tab to Group Cross-tab are generated using Impromptu.
Multi Dimensional Drill Up / Drill Down Analysis Reports are developed using Power Play
Created Levels with in Dimensions for better Analysis using Power play Transformer.

COGNOS Power Play has been used to analyze and present the Cube data in the form of multi-dimensional Reports & Charts.

Team Size: 5

2. Project Details

	General Sales Data Mart
Client	BAJAJ AUTOMOBILE
Role	DWH and BI Developer
Organization	Aviana Nrit limited, Bangalore
Environment	Windows 2000, Cognos 8 BI, SSIS, MS SQL Server 2005,
Duration	JUL 2007 – DEC 2007

Description:

The project is involved in Analyze, design and development of Bajaj Motorcycles sales and service maintenance system. The purpose of this project is to build a Data Warehouse database to the Sale Division of the company, which will give a support in generate the multi-dimensional summarized, reports to track the performance on services provided to their customers. This project is overall about claim data analysis. Bajaj Automobile wants to analyze the claims data generated by the system so that they can identify various factors influencing it, look at the trends, optimize through put and reduce losses by way of claims for faulty spares.

Responsibilities:

Understanding the Requirement Specifications & Business Logic.
Developed solutions to meet business needs by gathering and analyzing client resource.
Developed various Mappings, Transformations for migration of data using SSIS 2005.
Used various transformations in SSIS 2005.
Done data aggregation while transformation.
Extraction of data from the enterprise data warehouse for analytical and multi-dimensional reporting system for specific Corporate Business Unit
Developed simple as well as complex reports using Reporting studio.
Developed List, Cross tab, Drill through, Master-detail and chart which involved Multiple Prompts, Filters, and Multi-page.

Team Size: 5

Project details:

	General Sales Data Mart
Client	Prism Cements
Role	DWH and BI Developer
Organization	Aviana Nrit limited, Bangalore
Environment	Windows 2000, Cognos 8 BI, SSIS, MS SQL Server 2005,
Duration	JAN 2008 – till date.

Description:

The project involves in both execution & building a data warehouse Database for the sales department where the data was from different sources of oracle and flat files. The company serves the mass merchandisers, department and independent chain stores .The Company’s mission statement is "Strengthening Both Supplier and Retailer". This is accomplished through providing quality servicing at store level.

Responsibilities:

Understanding the Requirement Specifications & Business Logic.
Developed solutions to meet business needs by gathering and analyzing client resource.
Developed various Mappings, Transformations for migration of data using MS SSIS 2005.
Used various transformations in SSIS 2005.
Done data cleansing and aggregation while transformation.
Extraction of data from the enterprise data warehouse for analytical and multi-dimensional reporting system for specific Corporate Business Unit
Developed simple as well as complex reports using Reporting studio.
Developed List, Cross tab, Drill through, Master-detail and chart which involved Multiple Prompts, Filters, and Multi-page.

Team Size: 5

PERSONAL PROFILE

Name:	Naganayan D S
Father’s Name:	Dr D K S Aradhya
Date Of Birth:	03/10/1983
Current ctc	1.44 lakhs/annum
Expected ctc	2.70 lakhs/annum
Languages:	English, Kannada, Hindi.
Hobbies:	Reading novels, Playing Cricket, watching tech shows
Notice Period:	2 week

New Cognos job!

2008-08-01T15:32:00.001-07:00

http://c8jobs.blogspot.com/2008/08/finance-systems-analyst-and-programmer.html

Cognos ETL Specialist 20080619-0001

2008-06-19T18:37:00.000-07:00

Email us today if you're interested in contacting this resource

Current Location : In Singapore, On Social Visit Pass

EDUCATIONAL QUALIFICATION

Bachelor’s Degree in Mechanical Engineering 2005

SK University, Kurnool, India

TECHNICAL SKILLS

ETL Tools : Cognos8, Business Objects, DataStage 7.5.2 Enterprise Edition, DataStage 7.5 Server Edition

Reporting Tools : Cognos, Business Objects

Languages : C, C++, SQL, PL/SQL

Operating Systems : Win 95/98/NT/2000/XP, Unix

Databases : Oracle 8.i/9.i

Other Tools : TOAD

CERTIFICATIONS

Quality Management Systems(QMS) Satyam Computer Services Pte Ltd, India
SQL – OCA Oracle, India

TRAININGS

Oracle, Unix Training at Satyam Computer Services.
DataStage Training at IBM in April ‘07.
Cognos and Business Objects Training at Satyam Computer Services in Feb’08

CAREER SUMMARY

More than 2 yrs. of experience in Data Stage - ETL Developer and Cognos.
Involved in Functional and Technical Systems Analysis & Design, Systems, Star Schema, Snowflake, changing dimension and Documentation.
Developed server and parallel jobs using different types of stages such as Transformer stage, Lookup Stage, Join stage and created the Reports in Cognos according to the requirement.
Implementation of ETL (Extraction, Transformation and Loading) methodology using DataStage.
Integration of various Data Sources like Oracle and Flat files into the Staging Area.
Good knowledge in Database Concepts.
Strong knowledge in Data warehousing concepts and hands on experience in Data Stage and Cognos.
Have Good Programming knowledge in SQL, PL/SQL.
Strong Understanding of Software Lifecycle Methodology.
Experience in functional analysis, establishing business rules and process flows.
Excellent User interaction skills.
Having Good Communication Skills, Can learn new Technologies and Tools quickly.

EXPERIENCE

Mar 06 – Till Date Satyam Computer Services, Hyderabad, India

Software Engineer

Oct 07 – Apr 08

Project 3 GNE (Gulf & Near East) – Secondary Sales Reporting System

Client GSK (Glaxo Smithkline), UK

Team Size 6

Environment Cognos 8, DataStage 7.5.1, Oracle 10g, TOAD, UNIX

Project Description

GNE – Secondary Sales Reporting system is to develop reporting solution for GSK Gulf and Near East (GNE) which would provide easy access and drilled-down capability to retailer level. This is expected to improve the decision making by providing data with multidimensional analysis. The Secondary Sales reporting system is to replace existing excel based reports and provide additional functionality to enhance analysis and reporting capabilities.

Responsibilities

Designed and Created Reports in Cognos.
Authored Report Specifications.
Documented Package Configuration and System test case.
Involved in Unit Testing and System Testing

Jun 06 – Sep 07

Project 2 DRSF (Data Reporting System Foundation)

Client GSK (Glaxo Smithkline), Ware, UK

Team Size 30

Environment DataStage 7.5 Enterprise Edition (Px), Oracle 10g, TOAD, UNIX

Project Description

GlaxoSmithKline (GSK) is a world leading research-based pharmaceutical company. The Data Reporting System Foundation (DRSF) will provide a system for automatically gathering information from a range of sources by automatic and manual means. This information will be stored, processed and presented to the users of the system in a form that they can readily analyze.

Responsibilities

Analysis of the specifications provided by the client.
Developed parallel jobs for extracting, Transforming and loading the required data into Foundation Layer.
Used Datastage designer to create mappings (jobs) using different types of Stages such as Transformer stage, Lookup stage, Sequential file Stage, Sort stage, Join Stage etc.
Developed jobs in the Local containers.
Designed and developed job sequences for parallel jobs according to the requirement.
Used DataStage director to validate, to test and to monitor the resulting executable jobs.
Interaction with the onsite team.
Involved in unit testing by authoring and executing the unit test cases
Adhered to Quality procedures related to the project.

Jul 06 – Oct 06

Project 1 PMAR (Profit Management Analysis & Reporting)

Client GSK (Glaxo Smithkline), UK

Team Size 16

Environment DataStage 7.5.1, Cognos, Oracle 9i, TOAD, UNIX

Project Description

PMAR (Profit Management Analysis & Reporting) is used for analysis of profit & associated financial details of GSK. The Analysis is done for two establishments of GSK, namely GSKE (Glaxo & SmithKline Exports) and GSKTS (Glaxo & SmithKline Trading Services).

Responsibilities

Preparing Unit Test Case Documents for Data Stage jobs.
Preparing System Test Case Documents for Data Stage jobs.
Reviewing SQL Queries using TOAD.
Unit Testing for Data stage jobs.
System Testing for Data Stage jobs.
Created Simple jobs in Ascential Data Stage.
Prepared documents for the UAT.
Checked the Data Integrity in both JDE and Data Stage.
Created Deployment Document for production support.

COMPENSATION DETAILS

Currently on 4 Lakhs Indian Rupees per annum, plus Medical for self and parents, plus annual Leave Travel Allowance, and 15 – 25% annual Appraisal.

NOTICE PERIOD

Available Immediately

New C8 SDK Utility --- Cognos 8 Modification Check

2008-05-12T17:19:00.000-07:00

http://bicentresdkguide.blogspot.com/2008/05/new-c8-sdk-utility-cognos-8.html

Cognos Developer in New York

2008-05-10T07:42:00.000-07:00

http://c8jobs.blogspot.com/2008/05/cognos-developer-in-new-york.html

Cognos Data Warehouse 20080322-0001

2008-03-22T08:43:00.000-07:00

Email us today if you're interested in contacting this resource

Objective

To work in a challenging and progressive environment where, I can contribute for achievement of goals of the organization and my growth.

Summary

1 year of total experience in IT industry, with 1 years of experience in Data Warehousing using PL/SQL, tools like Cognos 7,Cognos 8,SAP BW.

Work Experience

o Working as Software Engineer in HCL Technologies Ltd, Chennai from Jan 2007 to till date

Qualification
o Master of Computer Applications from Anna University with 78% in 2007.
o Bachlore of Computer Application From Bharathiyar University with 68% in 2004.
o Higher secondary from Immaculate with 61.5% in 2001
o 10th from Immaculate with 66% in 1999.

Assets

o Good communication skills.
o Excellent analyzing skills, good grasping capabilities and ability to learn new things.
o Self directed, self motivated and committed individual.

Skillset

Reports : Cognos 8,Cognos 7 & SQL server 2005(SSRS)

Databases : Oracle9i/10g, SQL server 2005

Languages : C,C++, SQL, PL/SQL, UNIX Shell Script

DB Related : TOAD 7.3, SQL Loader

Operating Systems : Windows NT/2000, UNIX & Linux.

Project Profile

Project # 1

Title : CODMAN SALES REPORTING.

Client : JOHNSON & JOHNSON, US

Duration : Jan 2008 – Till date

Team Size : 6

Environment : Cognos 8.2,ORACLE 10g,Unix.

Project Description:

JOHNSON & JOHNSON (J & J) was one of the leading pharmaceutical company. Codman is a group of this J &J company. This project was initially kicked off as a migration of reports from Cognos 7 series to Cognos 8. But the client needed few alterations in the reports. So the project then started as a development project. Reports were generated on varios categories like Sales vs Objective (SVO), Monthly and Daily basis, Business Reporting.

Specifications were given to the developers which had the report layout and query that generated the reports. These requirements were gathered by my onsite lead.

Responsibilities carried out:

o Was involved in the model creation in Framework Manager.
o Created relationships, cardinalities and calculations at the FWM level to satisfy the given query.
o Developed complex reports which involved creation of many queries and joining them at the Report Studio level.

Project # 2

Title : DB- FSR Rollout.

Client : Deutsche Bank, Singapore

Duration : Jun 2007 – Jan 2008

Team Size : 20

Environment : Cognos 8.2/8.3, SAP BW.

Project Description:

Deutsche Bank is one of the world's leading financial service providers. Rollout of FSR happened for Honk Kong, Korea, Indonesia and Singapore. It is an Onsite-Offshore model of development project we have developed around 550 reports using cognos Report studio and few query studio reports. Reports has been developed in the Dev environment and after the quality process reports has been moved to the QA and PROD successfully.

The functional design documents provided by the client, Deutsche Bank, were presented in Excel format. The same was then replicated in Report Studio. A concept called Cell Based reporting was followed in which a data item is assigned only one value at which it is placed. This is called RFP (Report Form Position). The value against the RFP is stored in the source database i.e. SAP BW. Cognos picks up the values against the RFP from BW and populates the values for that particular position. A share point was maintained from where the defects raised by the users were taken and then fixed based on the priority. Versioning of the reports were to be maintained to make sure that the last updated report was worked upon the defects. This last updated report was then used for migration to the corresponding environment.

Responsibilities carried out:

o A total of 190 Indonesian reports were handled.
o Tested, validated and migrated the reports to different environments during the implementation phase at onsite (Singapore).
o Fixing the defects as per the priority and updating the same in the share point.
o Change Request for all the regions were handled effectively.

Project # 3

Title : PnC DashBoard

Client : HCL Technologies

Duration : Apr’2007 – May’2007

Team Size : 6

Environment : Cognos 8.2,TOAD 7.3, Oracle 8.1.7

Project Description:

* Created Metadata models from the DWH ORACLE database schema.
* Developed models using star schema grouping.
* Created short-cuts to resolve some join issues.
* Created folder structure and namespace to maintain Database view and presentation view.
* Developed Report design specification for few reports.
* Created list and cross-tab reports as per report design spec.
* Created two dashboards based on the given reports as per requirements using ReportStudio.

Project # 4

Title : Hospital Management System

Client : HCL Tecnologies.

Duration : Jan 2007 – Apr 2007

Team Size : 2

Environment : SQL Server 2005(SSAS,SSRS), TOAD 7.3,Oracle 8.1.7

Project Description:

* We have moved the source data to staging area database using SQLSERVER scripts.
* From staging area to DWH SQLSERVER database we used sort, merge, and join, aggregate transformations using SSIS.
* We have designed the Metadata model using star schema using SSAS.
* We rectified some join issues in the model.
* Created four cubes using SSAS.
* Created reports like list, cross-tab, charts using SSRS.
* Used some of the features like Drill-through, KPI, drill-down and conditional-formatting using SSRS.
* Created reports are scheduled as per the given frequency period.

New Job Posted!

2008-01-24T16:45:00.000-08:00

http://c8jobs.blogspot.com/2008/01/reporting-developer-analyst-20080124.html

Cognos 8 Migration Specialist 20080124-0001

2008-01-24T05:23:00.000-08:00

Email us today if you're interested in contacting this resource.

Primary Skills: Series 7 to Cognos 8 Migration Specialist

Location: Waltham, Mass USA

Years Experience: 12 years

Introduction: I have been using the Cognos BI suite of products since 1998 and I have recently gained significant project experience using Cognos 8.2.

Recent Projects:

Project 1.
Worked as a primary consultant for a leading insurance specialist. My main task was to upgrade their 300 Impromptu reports and user interface into a Cognos 8.2 infrastructure. This involved establishing a migration plan, series of user acceptance unit testing, generating documenation, and providing general training on the usage of Cognos Connection, Report Studio, and Query Studio.

Project 2.
Employed as a primary consultant the United States Department of Defense. I was directly involved with reviewing their Cognos Impromptu catalogue and 220 Impromptu reports before planning a migration strategy to Cognos 8. This involved interaction with their Business Analysts to review their current and near future reporting requirements.

BI Consultant / Oracle DBA 20080116-0001

2008-01-16T16:01:00.000-08:00

Email us today if you're interested in contacting this resource.

Primary Skills: Oracle DBA/Datawarehouse, Cognos 8.1 MR1, Informatica ETL

Location: San Francisco, California USA

Years Experience: 8 years

Introduction: My 8 years experience involves mainly working as an Oracle DBA that was responsible for working with a Fortune 500 Data Warehouse. I was involved with supporting the Warehouse design, generating Cognos reports and testing Cube development. I am looking for a position as a Senior Cognos Developer in the California area.

Recent Projects:

Project 1.
Responsible for Oracle 9i upgrade to 10g sizing around 300GB running on Solaris server for a Fortune 500 company.
• Database upgrade, and performance tuning
• Data Mart creation, data repository/metadata creation/management
• Database Backup/Recovery strategy/Planning
• Cognos 8 BI Server, Framework Manager installation and data modelling
• Reports design/development using Cognos Query Studio and Report Studio, add/manage/schedule tasks using Event Studio

Project 2.
Responsible for administering multiple Oracle 9i production databases, which were around 5TB running on Compaq Alpha servers using Compaq TRU64 Unix. Managed 7 Oracle development instance on Compaq Tru64 Alpha servers and 2 Oracle 9i instances on Sun Solaris servers.
• Database Performance Tuning
• Datawarehouse management (i.e. data profiling, data quality metrics, cleansing, transformation, mapping and loading into multiple targets)
• ER Data Modelling using Erwin 4.x
• Cognos 8 Framework Manager, report development using Query Studio and Report Studio
• Cognos Event Studio
• Implemented Peoplsoft HRMS data mart to Warehouse
• Informatica Infrastructure, installations, patch application
• Team Lead support services for a project of 34 resources
• Applied database upgrades and patches on yearly maintenance cycle
• Installation of Dev, QA, and PROD database instances
• Database Backup/Recovery strategy/Planning

Cognos Consulting will post your CV for free

2008-01-14T16:37:00.001-08:00

Welcome to our blog where we match Cognos consultants with potential employers. If you're an IT recruiter, corporate head hunter, or just a HR rep looking to fill a Cognos position within your organization then you have come to the right place to find your Cognos talent.

We will post Cognos CVs free of charge so that you can find the skill set that you need to help make your project a success.