Cognos Enterprise Planning

Harry Kartha

Mobile: 336-***-****

*** ********* ******* **. ***** Charles, MO 63303

Email: ***********@*****.***

Resident Status: US CITIZEN

Cognos Enterprise Planning Consultant with extensive experience in Performance Management, Business Intelligence , Data Warehousing Architecture, Development and Project Management, Excellent In-depth knowledge and understanding of Cognos architecture, implementation, and maintenance of enterprise-wide systems. Experienced in analyzing and translating business requirements, business processes into requirements and implement overall Enterprise Planning and BI strategy. Capable of offshore resources and offshore product development. Proven ability to develop and implement Enterprise Planning and Business Intelligence solutions that support wide variety of business functions.

Technical Skills

Cognos BI Certifications IBM Cognos 8 Planning Application Consultant - COG – 400

IBM Cognos 8 BI Administrator – COG – 122

IBM Cognos 8 BI Author - COG-112

BI / OLAP Tools Cognos Planning Analyst 8.4, Cognos Contributor Administration Console 8.4, Cognos 8.4 Framework manager , Report studio, Metric Studio, Analysis studio, Datastage and Informatica

Databases Oracle, IBM-DB2, Teradata, MS SQLServer, MS Access.

Training taken Two weeks intensive training on TM1 9.5 from Decision Systems, Chicago

Operating Systems Windows XP, Windows2003, Windows NT, Unix, MS-DOS

Languages Java, XML, Perl Scripting, UNIX Shell Scripting, Web Sphere Studio Developer, VB.NET

Others TOAD, Query Analyzer, Enterprise Manager, Erwin, SQL Developer Data Modeler

Quality SQA Suite, Mercury Test Direct, Load Runner

Educational Background Undergoing MBA program from Fontbonne University, Saint Louis MO.

BS in Accounting and Business Management from University of Kerala, Cochin, India 1989.

Diploma in Computing and Programming from Apple Computers, Bombay, India 1990.

PROFESSIONAL EXPERIENCE SUMMARY

Cognos Consultant

Constar Inc. Philadelphia – PA Mar 2011 – Current

Cognos 8 BI tools (Enterprise Planning Analyst and Contributor, Framework Manager, Report Studio, Analysis Studio), MS SQL Server, AS400, Windows XP.

• Implementing and deploying Cognos 8 Planner for budgeting, forecasting and production planning solutions.

• Administration of Contributor applications. Move/migrate the model, access tables, macros, GTPs, Load and publish.

• Developed Analyst and Contributor Model

• Worked with various Objects D-Lists, D-Cubes, D-Links, File Maps, Macros, and Administration Links.

• Used Erwin to model the data flow

• Worked with the ETL Team on Informatica issues

Cognos Consultant

Merial, Atlanta – GA Jan 2010 – Feb 2011

Cognos 8 BI tools (Enterprise Planning Analyst and Contributor, Framework Manager, Report Studio) MS SQL Server, Oracle 11i, Windows XP.

• Design, develop, and maintain Cognos 8 Planning and Reporting for planning and forecasting systems in accordance with both Company and industry best practices and standards.

• Design, develop, and support effective and efficient operational linkages between the corporate planning system and the regional and business function models.

• Participate in Cognos Planning - using Planning components (Contributor and Analyst).

• Implementing and deploying Cognos Planner for budgeting and planning solutions. Translate the business requirements into skeleton model (D-Lists and Cubes ).

• Design and develop the Cognos framework manager model handling various aspects such as Regular dimensions and Measure dimensions, building Star schema groupings and Develop Packages, setup-object level security and Row level security.

Cognos Consultant

GE Aviation, Cincinnati – OH Jul 2009 – Jan 2010

Cognos 8 BI tools (Enterprise Planning Analyst and Contributor, Framework Manager, Report Studio) Teradata Oracle 11i, Windows XP.

• The Military Data Warehouse is designed primarily to track part usage and maintenance events for the US Military.

• Maintained and upgraded complex Report studio reports prompts, conditional formatting and customized queries.

• Involved in development of Metric studio scorecards, dashboards for upper management, data flows, Metric types, Metrics and strategic maps.

• Ensured development and incorporation of business architecture with other layers.

• Oracle 11i and Teradata was used as the Data warehouse Database

• Informatica was the ETL tool used for the project.

Cognos Consultant

Gateway Corporation, Saint Louis – MO Feb 2006 – Jun 2009

Cognos 8 BI tools (Enterprise Planning Analyst and Contributor, Framework Manager, Report Studio, Analysis Studio), MS SQL Server, Oracle 11i, Windows XP.

• Implementing and deploying Cognos 8 Planner for budgeting, forecasting and planning solutions.

• Administration of Contributor applications. Move/migrate the model, access tables, macros, GTPs, Load and publish.

• Developed and worked with various Objects D-Lists, D-Cubes, D-Links, File Maps, Macros, Selections and Libraries.

• Creation of D-Links with a D-cube as target and source. Also created Analyst and Contributor Links to transfer data.

• Setting up the Contributor application, Developing plan in Analyst, Designing the E-List, Setting up the users, assigning the rights.

Cognos Consultant

AT&T Telecommunications, Greensboro - NC Jan 2005 – Feb 2006

• Design enhancement and Development of IBS Application using PFC.

• Writing Procedures and Functions in Oracle 8.0 and Crystal Reports tool was used to generate reports.

• Participated in Design and development of Cognos Enterprise planning and reporting for planning and forecasting systems (Contributor and Analyst) in accordance with both Company and industry best practices and standards.

• Design, develop, and support effective and efficient operational linkages between the corporate planning system and the regional and business function models.

• Cognos 8.2 Metric studio - Identify and design metrics, score cards and groups views. Create Balance scorecards and Functional score cards and CIO Dashboards. Create Metrics history charts , Metric types and diagrams.

Application Consultant

Alcoa, Greenville - SC June. 2003 – Dec 2004

• Converted PFC based objects to Java enabled DW using IBM – Web Sphere Application.

• Writing Procedures and Functions in Oracle 8.0.

• Crystal Reports tool was used to generate reports.

• Writing User Manual and user development programs.

• Responsible for Application Release Management, User acceptance testing.

• Involved in Test development plan for key testing & documentation/Scripts. such as: Test Plan, Test Case, Test matrix, Test data and GUI design based application and system performance testing.

• Planned and implemented disaster recovery for test and production servers

Application Consultant

R.J Reynolds Tobacco Company, Winston-Salem - NC May 2000 - Mar 2003

DB2, Crystal Reports, Power builder, Windows NT

DMG (Direct Marketing Group) Sales Automation System modules are Shipments to Retailers, Sales Team Support, Direct sales System Enhancements and Marketing Information for Events. The module also covered under this system includes Store Profile, Promotion Planning, Store Call, Chain Profile, Coupons, Contracts, Realignments and Smokers Profile. Developed Strong Crystal reporting architecture and reports to cater various business modules. Also performed development tasks in PowerBuilder 8.0

• Assisted senior architects in developing existing systems and planned new systems architecture artifacts.

• Helped analyze legacy applications and systems to derive required business functions and rules from existing applications.

• Performed requirements definitions, system analysis and design, interface and data architectures, lifecycle cost analysis and estimation, and governance.

• Worked with seven member team and project leaders to establish standards and guidelines.

Application Consultant

Coca-Cola Company, Atlanta - GA, USA. Feb 2000 - April 2000

Oracle, PowerBuilder, Windows NT

Provided technical support for the organizational restructuring of a call center creation and the knowledge transfer for systems designed and developed earlier. This involves application implementations on new locations, user training and documenting the same. Involved in the efficient call center reporting systems. These systems are implemented worldwide. Developed Batch procedures to update data and get consolidated reports faster.

Application Consultant

HealthPartners Inc. Minneapolis - MN, USA. Feb 1999 - Jan. 2000

Oracle, PowerBuilder, Windows NT

I was involved in the design, development and implementation of a Health Care Database Management System used as a Data warehousing tool. The system is with an import and export capability of the data from and to mainframe database to Oracle database and to Excel Spreadsheet. Development of this system extensively uses Power Builder 6.5 with PFC. Completed a Crystal Reports project for the Claim Management Department. This Crystal Reports are used to publish to the Web, using Crystal Enterprise XI. Created test plans, entry/exit criteria and checklists for Y2K testing.

• Designed and Developed Application Framework using PFC libraries.

• Written many Functions and Procedures in Oracle using PL/SQL.

• Involved in Test development plan for key testing & documentation/Scripts.

• Was responsible for Application Release Management.

• Created test plans, entry/exit criteria and checklists for Y2K testing.

Programmer Analyst

Carlson Companies, Inc. Minneapolis - MN, USA. June 1998 - Jan.1999

I was involved in the design and development of Loyalty applications for American Cyanamid. This system is used for Grower, Retailer and Sales Persons to track the account each of these have. The Phone call from and about the Grower is the most common task of the system. While you are on a call from a Grower, Retailer, Sales Person or a Manufacture for their information, this system allows you to modify any of the information. Development of this system extensively uses PowerBuilder 6.0 with PFC. the database used in the system is Sybase System 10 on Windows NT is the platform.

• Designed and Developed Application Framework using PFC libraries.

• Written many Functions and Procedures in Oracle using PL/SQL.

• Developed User Manual and trained user development programs.

• Involved in Test development plan for key testing & documentation/Scripts

Systems Analyst

Brown & Williamson Tobacco Corp, Louisville - KY, USA. Sep 1997 - May 1998

Beacon System is a Field Sales Force Automation project with four business modules. They are Shipments to Retail Data; Sales Merchandiser Hand held Call Reporting, Field Reporting System Enhancements and a long-term, enterprise-wide solution for data warehousing of key sales and marketing information.

• Designed and developed application framework using PFC libraries.

• Involved in development of many Database Functions and Procedures.

• Involved in functional testing of application and system performance testing.

• Was responsible for the application testing and release management.

Systems Analyst

UPS Research and Development, Danbury, CT, USA. May 1996 - Sep. 1997

Worked on the development, testing and deployment of MSAC system. The Database used for this system is MS SQL Server 6.0. This system used many Database stored procedures and functions. Involved in development of many Functions and Procedures. Crystal Reporting tool was used to generate few custom reports. many Functions and Procedures. Crystal Reporting tool was used to generate few custom reports.

• Involved in development of many Functions and Procedures

• Involved in functional testing and system performance testing.

• Was responsible for development and Implementation.

Contact this candidate