SUMMARY:

• Over 20+ years of professional experience in IT and Finance, 16+ years exclusively as Sr. IBM Cognos Enterprise Planning (TM1) Analyst, Reporting, Architect and Production Support.
• Strong in understanding and working with IBM Cognos Enterprise Planning Series & BI Reporting. Expert in modeling, Reporting & Production Support. Expertise in Implementation, Installation, Bug fixing, Automation, Configuration
• Production support, Migration to newer versions and reporting with the necessary business skills in the areas of Finance.
• Hands - on experience in building models and creating Inbound and Outbound of historical and current data. Implemented, migrated to newer versions and Production support IBM Cognos Enterprise planning (TM1) & BI Reporting at the following

TECHNICAL SKILLS:

Operating System: Windows, Windows NT, Windows 2000, Windows Server 2003, Windows Server 2008, MS DOS and Unix

Languages: C#, C, C++, PASCAL, COBOL

GUI: Visual FoxPro 3.0, VB.net, VB 6.0

RDBMS: Oracle 11G, Microsoft SQL Server 2005,DB2

ETL Tools: Informatica Power Center 7.1, 7.1.5, 8.5.1 SQL Server Analysis Services and Reporting Services

Other Tools: Adaytum 2.0/3.0, IBM Cognos Enterprise Planning Series Version 8.3 & 10, TM1 10.2.2, Visual Interdev 6.0, FrontPage 2000, .net Framework, Business Objects XI Release 2, Cognos Powerplay Transformer 7.3, Access Manager Administration 7.3, and Cognos Series 7 Server Administration, Tableau and Crystal Reports

Web Technologies: VBScript, JavaScript, XML, XSL HTML

Other Technologies: ActiveX, OLE, COM, DCOM, Component Services 2001, MTS and ASP.net

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. Cognos Planning TM1 Administrator/Architect

Responsibilities:

• Leading the Forecast, Budget and Month end close cycles related to IBM Cognos planning TM1 and reporting.
• Created Databases, CUBES, Dimensions, Rules or TI processes, Applications, User security and Reporting related Budget, Forecast, MFR and Treasury Financial models using Performance Modeler and Architect.
• users on how to use Cognos® TM1® Perspectives add-in for Microsoft Excel
• Involved in Upgrade process of Cognos Planning to Cognos TM1 Planning
• Leading Production support according to the Forecast, Budget and month end close cycles.
• Consolidating data between the models and providing it to downstream systems like FGEN and BI Reporting.
• Generating Power Play reports and Loading actuals using FGEN reports.
• Improved the e-planning environment by suggesting best practices like reducing the Application size, reduce hard coding and fine tuning the Planning Process.
• Interacted with IBM to improve the e-planning implementation and provided better solution to Confidential
• Installed and configured various components, such as the Framework Manager and Content Manager
• Developed and maintained Development, UAT and Production server.
• Developed and Implemented Best Practices (Development Standards, Modeling Standards & Security Model).
• Installation and Configuration of Cognos BI Server and Power Play Transformer on Windows Sandbox.
• Involved in gathering the functional requirements for financial budgeting, forecasting and related reporting and analytics requirements.
• Developed Multidimensional Models in Power-Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures in Cognos 8.4 & 10.1.
• Worked closely with the business users to build the models and delivered based on the sign-off.
• Modified Power Cubes by adding new Dimensions, Levels, Categories and Measures.
• Extensively worked on Validating and testing report in Query Studio and Analysis Studio.
• Created different Dashboards in report studio using combination of List, Crosstab, and Graph and Map reports.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Developed user acceptance documentation and placing Screen shots of actual Report and tested report in documentation.
• Extensively worked on SQL, created joins between huge tables to map the columns from multiple tables.
• Tracked the weekly bug or issue report updates from the developers in the form of the QA Error Log.
• Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
• Led team meetings, providing status and defining go-forward approach based on achievable results.
• Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Extensively worked on call support by coordinating and maintaining offshore team.
• Worked extensively to Achieve the Performance and Tuned SQL Queries and Stored Procedures, improved the performance of the reports.
• Provided Production support through problem analysis and resolution to correct deficiencies.
• Developed Balanced Scorecard and executive dashboards, as means for measuring activities and outcomes for effective performance management.
• Involved in review sessions and demos with business users and draft design and solution
• Responsible for various tasks including user communication, follow ups, reports and Power cubes development, testing, document preparation and moving components into different environments.
• Used Cognos Metric Designer to populate the application by transferring information from relational and dimensional data sources.
• Used Metric Studio score cards extensively to track the Finance and sales Metrics such as revenue, margin and customer growth.
• Trained power users to use Query Studio for Ad-Hoc reporting and Analysis Studio.

Environment: Cognos Planning 10.1.1, TM1 10.2.2, Cognos TM1 Performance Modeler, Cognos TM1 Architect, Cognos TM1 Perspectives Cognos Insight, Cognos 10 Framework manager, Cognos Business Intelligence Report Studio, Tableau, Windows Server 2008 and Microsoft SQL Server 2005

Confidential

Sr. Cognos Planning TM1 Administrator/Architect

Responsibilities:

• Managing the Forecast, Budget and Month end close cycles related to IBM Cognos planning and reporting.
• Creating Analyst Model Libraries, Cubes, D-Lists, D-Links, and allocation tables, File Maps, ODBC links and Macros
• Creating Contributor models, Elist, User classes, Rights, Access Tables, Saved Selections, Automating jobs, Macros, Orientation, Navigation, Publishing data, Synching models, Running GTP, Loading data, and Contributor help text
• Creating System links and Admin Links.
• Installing Analyst on client machines, solving client side issues like opening contributor data grid, Excel Import & Excel Print
• Leading Production support according to the Forecast, Budget and month end close cycles.
• Consolidating data between the models and providing it to downstream systems like EFR and BI Reporting.
• Generating Power Play reports and Loading actuals using EFR reports.
• Improved the e-planning environment by suggesting best practices like reducing the model size, reduce hard coding and fine tuning the models.
• Interacted with IBM to improve the e-planning implementation and provided better solution to Philips Health Care
• Migration of the e-planning from version 8.4 to version 10.1.1 with lead role.

Environment: Cognos Planning 10.1.1, TM1, Cognos 10 Framework manager, Cognos Business Intelligence Report Studio, Windows Server 2008 and Oracle 11g.

Confidential

Sr. Cognos Planning Administrator/Architect

Responsibilities:

• Involved in managing the Forecast, Target, Comp, Capital and Budget cycles using Cognos models
• Involved in creating Analyst Model Libraries, Cubes, D-Lists, D-Links and allocation tables, File Maps, ODBC links and Macros
• Involved in creating Contributor models, Elist, User classes, Rights, Access Tables, Saved Selections, Automated, Macros, Orientation, Navigation, Publishing data, Synching models, Running GTP, Loading data, and Contributor help text
• Involved in creating System links and Admin Links
• Installing Analyst on client machines, solving client side issues like opening contributor datagrid, Excel Import & Excel Print
• Involved in Production support according to the Forecast, Target, Budget, Comp and Capital cycles
• Involved in consolidating data between the models and providing it to downstream systems like GIF and RMATC.
• Involved in Generating Power Play reports and Loading actuals using Business Objects reports

Environment: IBM Cognos Enterprise Planning Series Version 7.3 & 8.3, Oracle 9.2, Business Objects XI Release 2, GIF, RMATC, Windows Server 2003, Component Services 2001, Cognos Powerplay Transformer 7.3, Access Manager Administration 7.3, and Cognos Series 7 Server Administration

Confidential, OH

Sr. Cognos Planning Administrator/Architect

Responsibilities:

• Involved in understanding exiting system and collecting specifications for building models.
• Involved in designing Planning and reporting models.
• Involved in creating data staging models in collecting actuals from different interfaces like JDA, SAP, PeopleSoft and EDW.
• Involved in creating Cubes, D-Lists, D-Links, allocation tables, File Maps, ODBC links and Macros
• Involved in generating reports using published data and data exported from Analyst cubes.
• Involved in Creating Data prep & Creating Macros for loading data into Contributor using Analyst 7.3
• Created manager menus for the users to contribute their plan data.
• Involved in building applications, setting applications, configuring application settings, publish settings, running GTP and Synch using Contributor Admin Console
• Created Automation Macros to run Consolidation, Publish, Data Load, Prepare Import & GTP
• Involved in production support activities such as importing user rights, user classes using Access Manager, eList, Access Tables, Saved Selections, Navigation & Orientation

Environment: Adaytum 7.3, Cognos Enterprise Planning series 7.3, Analyst, Contributor Admin Console 7.3, Excel add-ins, VB, COM+, SQL 2000, Oracle 9, DB2, ASP, VBScript, JavaScript, IIS 5.0, Windows 2000 Server

Confidential, CT

Sr. Cognos Planning Administrator/Architect

Responsibilities:

• Involved in understanding exiting system and collecting specifications for building models.
• Involved in designing Planning and reporting models.
• Involved in creating Cubes, D-Lists, D-Links, allocation tables, File Maps, ODBC links and Macros
• Involved in generating reports using published data and data exported from Analyst cubes.
• Involved in Creating Data prep & Creating Macros for loading data into Contributor using Analyst 7.3
• Involved in building applications, setting applications, configuring application settings, publish settings, running GTP and Synch using Contributor Admin Console
• Created Automation Macros to run Consolidation, Publish, Data Load, Prepare Import & GTP
• Involved in production support activities such as importing user rights, user classes using Access Manager, eList, Access Tables, Saved Selections, Navigation & Orientation

Environment: Adaytum, Cognos Enterprise Planning series 7.3, Analyst, Contributor Admin Console 7.3, Excel add-ins, VB, COM+, SQL 2000, Oracle 9,DB2, ASP, VBScript, Java Script, IIS 5.0, Windows 2000 Server

Confidential, CA

Sr. Cognos Planning Analyst

Responsibilities:

• Involved in creating Cubes, D-Lists, D-Links, allocation tables, File Maps, ODBC links and Macros
• Involved in generating various types of reports using Excel add-ins.
• Involved in creating System links and Admin Links.
• Involved in generating reports using published data and data exported from Analyst cubes.
• Involved in Creating Data prep & Creating Macros for loading data into Contributor using Analyst 7.3
• Involved in building applications, setting applications, configuring application settings, publish settings, running GTP and Synch using Contributor Admin Console
• Created Automation Macros to run Consolidation, Publish, Data Load, Prepare Import & GTP
• Installing Analyst on client machines, solving client side issues like opening contributor datagrid, Excel Import & Excel Print
• Involved in production support activities such as importing user rights, user classes using Access Manager, eList, Access Tables, Saved Selections, Navigation & Orientation

Environment: Cognos Enterprise Planning Series 7.3, Analyst, Contributor Admin Console 7.3, Excel add-ins, VBCOM+, SQL 2000, Oracle 9, DB2, ASP, VBScript, Java Script, IIS 5.0, Windows 2000 Server

Confidential, NJ

Cognos Enterprise Planning (Adaytum) Adminstrator

Responsibilities:

• Involved in creating Cubes, D-Lists, D-Links, Allocation tables, File Maps, ODBC links and Macros
• Involved in generating various types of reports using Excel add-ins.
• Involved in generating reports using published data and data exported from Analyst cubes.
• Involved in Creating Data prep & Creating Macros for loading data into Contributor using Analyst 7.3
• Involved in building applications, setting applications, configuring application settings, publish settings, running GTP and Synch using Contributor Admin Console
• Created automation scripts to run Consolidation, Publish, Data Load, Prepare Import & GTP
• Installing Analyst on client machines, solving client side issues like opening contributor datagrid, Excel Import & Excel Print
• Involved in production support activities such as importing user rights, users, eList, Access Tables, Saved Selections, Navigation & Orientation

Environment: Cognos Enterprise Planning Series 7.3, Analyst, Contributor Admin Console 7.3, Excel add-ins, VBCOM+, SQL Server 2000, Oracle 9, DB2, ASP, VBScript, Java Script, IIS 5.0, Windows 2000 Server

Confidential, NJ

Cognos Enterprise Planning (Adaytum) Adminstrator

Responsibilities:

• Involved in building models, Product setup, Clustering servers & Admin, Web & Analyst Server Setup
• Involved in creating Cubes, D-Lists, D-Links, Allocation tables, File Maps, ODBC links and Macros
• Involved in generating various types of reports using Excel add-ins
• Involved in generating reports using published data and data exported from Analyst cubes.
• Involved in Creating Data prep & Creating Macros for loading data into Contributor using Analyst 7.1
• Involved in building applications, setting applications, configuring application settings, publish settings, running GTP and Synch using Contributor Admin Console
• Created automation scripts to run Publish, Data Load, Prepare Import & GTP
• Installing Analyst on client machines, solving client side issues like opening contributor datagrid, Excel Import & Excel Print
• Involved in production support activities such as importing user rights, users, eList, Access Tables, Saved Selections, Navigation & Orientation

Environment: Cognos Enterprise Planning series 7.1, Analyst, Contributor Admin Console 7.1, Excel add-ins, VB, COM+, SQL 2000, Oracle9, DB2, ASP, VBScript, Java Script, IIS 5.0, Windows 2000 Server

Confidential, NJ

Cognos Enterprise Planning (Adaytum) Adminstrator

Responsibilities:

• Involved in Product setup, Clustering servers & Admin, Web & Analyst Server Setup
• Involved in creating Cubes, D-Lists, D-Links, Allocation tables, File Maps, ODBC links and Macros
• Involved in designing Analyst models, Generating reports, Creating Data prep & Creating Macros for loading data into Contributor using Analyst 2.0/3.0/7.1
• Involved in building applications, setting applications, configuring application settings, publish settings, running GTP and Synch using Contributor Admin Console 2.0/3.0/7.1
• Created a COM+ interface using VB and automation scripts to run Publish, Data Load, Prepare Import & GTP
• Installing Analyst on client machines, solving client side issues like opening contributor datagrid, Excel Import & Excel Print
• Involved in production support activities such as importing user rights, users, eList, Access Tables, Saved Selections, Navigation & Orientation, Data Loads, Publish and Data Consolidation.

Environment: Adaytum 2.0/3.0, Cognos Management System 7.1, Analyst 2.0/3.0/7.1, Contributor Admin Console 2.0/3.1/7.1, VB, COM+, SQL 2000, Oracle 9, ASP, VBScript, Java Script, IIS 5.0, Windows 2000 Server

Confidential, NJ

Adaytum Adminstrator

Responsibilities:

• Involved in analyzing the models according to the specifications given by the client.
• Involved in creating the models using Analyst
• Involved in deploying the models using Contributor Admin console
• Involved in daily production support like loading data, model changes and user rights etc.
• Involved in developing Access Tables and saved selections
• Involved in migrating from version 2 to version 3
• Involved in setting up the servers and installing software
• Involved in setting Analyst rights, and developing analyst macros

Environment: Adaytum 2.0 & Adaytum 3.0, Visual Basic 6.0, COM, MTS, SQL Server 7.0, ASP 3.0, VBScript,