SUMMARY

• Over 6 years of IT experience in Business Intelligence Reporting, Design, Development, Testing and Implementation of Cognos Applications and maintenance of data warehouses, data bases, data marts and providing solutions for Financial, Logistics, Public Utility Sector, Security, and Banking Industries.
• Expertise in installing, upgrading and configuring TM1 Servers.
• Experienced in building TM1 Applications, Cubes, Dimensions, Turbo Integrator Processes,TM1 Rules, and Executive Viewer Reporting.
• Expertise in TM1 backups and process automation by creating Turbo Integrator process and Chores.
• Experienced in various Cognos tools such as Cognos 8 BI Suite (Framework Manager, Report Studio, Cognos Connection, Metric studio, Query Studio, and Event Studio), Report Net, Impromptu, Power Play Transformer, and Access Manager.
• Expertise in developing reporting applications using Cognos 10 BI components (Framework Manager, Business Insight, Business insight advanced, Report Studio, Query Studio, Analysis Studio, and Cognos Connection).
• Experienced in creating Framework Manager Models using various data sources such as Oracle, SQL Server, DB2, SAP BW Info Cube, and Sybase, publishing packages to Cognos Connection.
• Expertise in a data migration process between different versions of Cognos.
• Involved in installation, configuration and administration of Cognos BI 10, 8, and Cognos TM1.
• Designed and developed Cognos Power Play OLAP cubes using Transformer.
• Proficient in OLTP/OLAP - ROLAP/Data warehousing /Data Marts architecture.
• Excellent SQL and PL/SQL coding skills in a Data Warehousing/ Reporting environment.
• Expert level skills in developing Strategies for Extraction, Transformation and Loading (ETL) using Informatica Power Center and SSIS.
• Experienced in planning and forecasting reports by using Cognos planning.
• Data Modeling experience using Kimball’s Dimensional Data modeling (DMR), Star Schema, Snowflake modeling, Physical and logical data modeling using ERWIN and Toad data Modeler
• Strong experience in client interactions, understanding business application and data flow.
• Excellent communication and interpersonal skills. Versatile team player wif proven problem solving skills, user interface (UI) work and motivated to learn more.

TECHNICAL SKILLS

• TM 1 10.2 10.1 9.5.2 9.5 9.4.1
• TM1 Architect
• TM1 Excel
• TM1 Web
• Executive Viewer
• Cognos 8.1/8.2/8.3/8.4/10.1/10.2 (Report Studio
• Query Studio
• Metric Studio
• Event Studio
• Analysis Studio
• Business Insight
• Active Forms)
• Cognos Reportnet
• Cognos Connection
• Cognos Framework Manager
• Transformer
• SDK
• Cognos 8 Go Office
• Cognos Enterprise Planning (Analyst
• Consolidation and Contributor)
• Teradata
• Oracle10G/9i/8.x
• Sql Server 2000/2005/2007
• Sybase
• DB2
• Informatica Power Center
• Data Stage
• SSIS
• SSRS
• IBM Information Server
• B.O’s
• MS Excel
• SAP BW
• Crystal reports
• Toad 8.1.2
• SQL Navigator 4.0
• SQL Analyzer
• ER Win 4.1.3
• Rational Clear Quest
• Load Runner
• SQL Data Modeler
• PL/SQL
• C
• Java Script
• ASP.Net
• HTML
• XML
• Visual basic
• Windows OS
• Unix-HP and MS-Dos.

PROFESSIONAL EXPERIENCE

Confidential, Tampa, Florida

Cognos Developer / Cognos TM1 / Administrator

Responsibilities:

• Involved in creating Standard Reports, List Reports, Cross-tab Reports, Charts, Repeater and Drill through reports using Cognos 10.2 Report Studio.
• Performed Bursting of reports according to user requirements in Cognos Connection.
• Loaded and Maintained data in Cube using TM1 Turbo Integrator, added business Rules to TM1 Cubes.
• Optimized teh Rule performance by adding SKIPCHECK and FEEDERS to teh TM1 cube.
• Created and scheduled teh CHORES to automate teh process in TM1 cube.
• Performed TM1 backups and automated teh process by creating Turbo Integrator process and Chores.
• Created TM1 Application by adding TM1 objects and External files to an application, deploying teh application to Web
• Integrated Cognos TM1 wif Cognos 8 BI
• Involved in design, deploy and running managed planning applications based on TM1 data using TM1 Contributor.
• Involved in creating Sandboxes to work wif data in different versions using TM1 Contributor.
• Installed Cognos TM1 Executive Viewer and Setup Executive Viewer Client
• Involved in adding and removing users, portal tabs in Cognos Connection
• Worked on portal automation design, backup and recovery documentation.
• Involved in migrating data from Development to QA server, and QA to Production Server
• Created user groups, roles in Cognos Connection and applied data and group level security

Environment: IBM Cognos TM1 10.2/ 10.1, TM1 Executive Viewer, TM1 Contributor, Cognos 10.2/10.1 BI Suite, Frame Work Manager, Informatica 8.6, Oracle, SSIS, SAP R/3, Erwin, UDB, Sql Server 2008, IIS, Windows 7/XP

Confidential, Brentwood, Tennessee

TM1/ Cognos Developer/ Administrator

Responsibilities:

• Involved in creating Tm1 Cube, Used TI process to create dimensions and load teh data
• Integrated Cognos TM1 wif Cognos 8 BI, provided Security to TM1 objects by creating Users and Groups
• Involved in installing and configuring TM1 Servers, building TM1 Dimensions, cubes, and applications.
• Exported teh Data to Excel files and relational databases using Turbo Integrator process.
• Created TM1 Workbook and uploaded to TM1 Server.
• Created TM1 Workflow process and assigned teh task to TM1 Users
• Involved in Integrating Executive Viewer wif PowerPoint to make presentations
• Created teh Data source and Database connections for TM1 Cubes in Executive Viewer Explorer.
• Created user groups and roles in Cognos Connection and applied data and group level security.
• Created derived metrics, metric types, Scorecard, performance graphics in Metric Studio
• Involved in creating Dashboards for immediate visibility into key performance indicators KPI’s

Environment: IBM Cognos TM1 9.5.1/9.5, TM1 Executive Viewer, TM1 Contributor, Cognos 8.4.1/10 BI (Report Studio, Query Studio, Analysis Studio, Metric studio, Frame Work Manager), Informatica 8.1, Oracle 9i/ 10g, SAP, Erwin, Sql Server 2005, IIS 6, Windows XP

Confidential, Phoenix, AZ

Cognos Developer/ Administrator

Responsibilities:

• Involved in Preparing teh design requirements, system configuration and Performance tuning.
• Administered installation, configuration, and software upgrades of Cognos applications.
• Created Construction Variance Report, Variance Explanation Report, Capital Budget Variance Summary Report, Variance Summary Departmental Report, Overtime Hours Report, Construction Overhead Report for Finance
• Created a Summary Report, UG cable report, Forecast vs. Actual Report
• Created a Dashboard Navigation for T&D Reliability using Report Studio, Dashboard for displaying all teh metric details in T&D reliability
• Created a Framework Manager Model for Reliability indices, and a DMR model
• Created and maintained Database, Users, Tables, Views, PL/SQL Stored Procedures and Macros
• Created Cubes based on teh business requirements and created teh related drill through reports
• Involved in Creating query prompts, cascading prompts, developed prompt pages and conditional variables

Environment: Cognos 8.4.1 BI (Report Studio, Query Studio, Analysis Studio, Metric studio), Informatica 8.1, IIS, UDB, Teradata, and Windows XP

Confidential, SFO, California

Cognos Developer/Data Modeler

Responsibilities:

• Created complex reports using Report Studio including conditional blocks, conditional formatting, and stored procedures.
• Used Cognos Framework Manager to build models, packages and publish a package, used Analysis Studio to analyze and compare large volumes of dimensional data.
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts, and Drill through Reports
• Involved in creating folders, setting permissions and scheduling jobs in teh Cognos Connection
• Performed Bursting of reports according to user requirements in Cognos connection
• Scheduled and distributed Reports through Schedule Management in Cognos Connection
• Performed detailed documentation of design, development, testing and deployment activities
• Created Design Documents for teh Development of Cognos Reports
• Daily execution of teh project, issue escalation, work allocation, review of deliverables and QA

Environment: Cognos 8.4/8.4.1 BI (Report Studio, Query Studio, Analysis Studio, Metric studio), SSIS, SQL Server 2005, Tomcat, and Windows XP

Confidential

Cognos Developer

Responsibilities:

• Participated in discussions wif clients for better understanding of teh business requirements
• Referred existing cubes and reports and analyzed requirements
• Customized data by adding calculations, summaries, prompts, and filters according to teh user’s requirements
• Involved in creating various reports including List, Cross tab, Charts and Mailing Label reports.
• Developed Drill through reports, Master Detail Reports, Bursting Reports
• Used Cognos Framework Manager to build models, packages and publish packages
• Resolved production issues and extensively worked wif production support team
• Involved in teh documentation preparation for User Training

Environment: Cognos 8/8.3 BI (Report Studio, Query Studio), SQL, Access Manager, Oracle 8x, and Windows 2000 server