SUMMARY:

• An expert in TM1modelling, application architecture, technical lead, application development, active forms & administration
• Business focused I.T. professional with more than 20 years of broad ranging experience in Accounting, Logistics, FMCG marketing, Manufacturing, Distribution, Business Intelligence, Data Warehousing, Financial Performance Management
• Implemented Performance Management solutions using Cognos 10 BI & Cognos TM1 tools
• Implemented Cognos BI (versions 7, 8 & 10 ) solutions in CRM, manufacturing tracking, non - conformance, finance, sales, help desk, human resources, labor booking, supplier performance and tracking applications
• Focused on providing enterprise-wide cost effective Business Performance Management solutions

TECHNICAL SKILLS:

Business Domain Expertise: Manufacturing, Fast Moving Consumer Goods, Supply Chain, Logistics, Banking

Enterprise Perf. Mngt: TM1 10.2.2, Cognos BI 10.1 suite, Cognos Insight, Cognos Workspace, Performance Modeler

ERP: SAP, Manfact, Pronto, HMS

Database/ Data Sources: DB2/UDB, MS SQL Server, Oracle, Teradata, MySQL, PeopleSoft, MS Excel, MS Access, flat files

Operating System: Windows, OS X, Linux

Programming: TM1 TurboIntegrator, PL/SQL, T-SQL, Basic, Pascal, Fortran & C

Other: Rational Team Concert, SDLC Process, QubeDocs, MS Office, MS Visio, MS Project, Confluence, Jira

PROFESSIONAL EXPERIENCE:

TM1 Senoir Developer

Confidential, Lombard, IL

Responsibilities:

• Developer TM1 Web and TM1 Application applications on forecast and budgeting for multiple Confidential clients. Develop dashboards, reports using Active Forms and Cognos Insight. Implement element-level and/or cell-level security as required. Train and support users. Document applications developed.
• Budget/Forecast: Develop applications, cubes, dimensions, TI processes, rules/feeders and reports as required for each of the assigned client account
• Cognos TM1 and Project activities
• Develop cubes, dimensions, TI processes, rules/feeders for Forecast/Budget application
• Develop applications for multiple currencies & reporting calendar
• Develop applications to also include multi-country payroll budget/forecast
• Develop active forms for data capture and reporting
• Implement element-level/ cell-level security as required
• Help in user
• User support after implementation

TM1 Consultant

Confidential

Responsibilities:

• Develop TM1 rules/feeders as required. Write TI processes for required utilities, dimensions/subsets maintenance. Modify existing cubes / dimensions as required. Develop websheets as required in IBM’s internal Sales application.
• Sales: Develop TI processes, rules/feeders and websheets as required for an application designed for 1,000 concurrent users. Modify existing cubes, TI processes, rules/feeders as required.
• Cognos TM1 and Project activities
• Develop TI processes to load and maintain dimensions and static subsets
• Develop TM1 rules/feeders for various cubes
• Support the development of websheets with Action buttons
• Fix assigned defects
• Use Architect/ Perspectives / Performance Modeler where appropriate
• Use Rational Team Concert for source code control and defect resolution

TM1 Consultant

Confidential, Los Angeles, CA

Responsibilities:

• Design, develop and implement an enrolment and reporting tool on Projects and incentives
• Projects: Design, model and implement TM1 cubes and websheets to capture qualified Projects for the incentive program launched by the management
• Incentives: Design, model and implement TM1 objects to implement the business rules on calculating and reporting incentives
• Cognos TM1 and BI Suite activities
• Implement solution that includes the TM1 tools, EDW and Cognos BI
• Create additional dimensions and use existing applicable dimensions to build TM1 cubes
• Write TI processes to populate/update the new dimensions
• Write TM1 rules/feeders
• Author Report Studio reports for reporting
• Create and publish websheets to capture Projects enrolment data

BI Consultant

Confidential, Orlando, FL

Responsibilities:

• Enhance existing Framework Manager Models
• Enhance existing Report Studio Reports as required
• Collaborate with the data warehouse personnel to ensure accurate data extraction
• Collaborate with SMEs to ensure that user requirements are met

TM1 Consultant

Confidential, Michigan

Responsibilities:

• Design, develop and implement an analytical and performance management solution on CRM, Employee performance and User access audit
• CRM: Design, model and implement TM1 model to facilitate the analysis of Customer acquisition costs and balances using Cognos BI tools, Performance Modeler and TM1 Architect
• Employee performance: Design, model and implement TM1 objects to facilitate the analysis of Employee performance against customer acquisition goals using Cognos Insight, Performance Modeler & TM1 Architect
• User access audit: Design, model and implement TM1 objects to facilitate the analysis and audit of user access. Enable the appropriate manager to grant/remove access of his/her subordinates.
• Cognos TM1 and BI Suite activities
• Implement solution that includes the TM1 tools, EDW and Cognos BI
• Create 3 staging cubes and a CRM reporting cube
• Create an audit cube to for managers to confirm user access to the CRM using Cognos Insight
• Build Turbo Integrator (TI) processes for dimension maintenance, cube updates and needed utilities
• Create TM1 rules for TM1 cubes
• Help build a dashboard using Cognos Workspace, Cognos Workspace Advanced and Report Studio with both multi-dimensional and relational data sources
• TM1 cube performance and tuning to meet user requirements

BI Developer / TM1 Modeller

Confidential, Portland OR

Responsibilities:

• Participate in the design, development and implementation of analytical and performance management solutions for two projects that help DTNA analyze the various components impacting the cost conversion and sales margins. These two projects are on Manufacturing and Sales
• Sales: Design and model TM1 objects to facilitate the analysis of sales costs using Cognos BI tools & TM1 Perspectives
• Manufacturing Costs and Forecasting: Develop the solution to analyze conversion costs and performance against forecasts. Implemented tools included PowerPlay and TM1 cubes, Cognos for MS Office and think-cell add-on to update the presentation slides automatically
• Cognos TM1 and BI Suite activities
• Implement solution that includes the ERP, EDW, Cognos BI and TM1 tools.
• Built TM1 cubes that are rules driven as well as TurboIntegrator driven.
• Built numerous Turbo Integrator (TI) processes.
• Used TM1 Perspectives to develop utilities based on the Slice for Power User reporting.
• Used IBM Cognos 10 BI Report Studio, Query Studio & PowerPlay cubes for end user reports.
• Built dashboards using Business Insight and Business Insight Advanced.
• Extensive performance and tuning work to make the entire model to meet users requirements.
• Developed TurboIntegrator processes to run Item level cost calculations to compare of month, quarter and year timeframed transactions
• Wrote the rules to reflect Business Rules and improve TM1 performance
• Developed several Cognos Active Reports
• Generate documentation framework using QubeDocs
• Migrated Cognos ReportNet reports to Cognos 8.4.1
• Act as a backup Cognos BI Admin

Senior Business Systems Analyst

Confidential, Beaverton, OR

Responsibilities:

• Business requirements gathering and analysis
• Coordination with Corporate Data Governance Committee & Enterprise Business Intelligence team
• Identify solution options and risks
• Adopt Agile methodology in solution delivery

BI Applications Analyst

Confidential

Responsibilities:

• Architected, designed and implemented Cognos 8 BI solutions
• Architected, designed and implemented DW/ data marts sourced from PeopleSoft, Manfact, HMS and Cognos Planning
• Deliver BI solutions on various areas of the business including labor booking, cost tracking, supplier performance, quality control, tracking and help desk performance
• Support the Cognos Planning 8.4 implementation

Business Intelligence Team Leader

Confidential

Responsibilities:

• Architected, designed and implemented Cognos 7 BI solutions
• Architected, designed and implemented DW/ data marts sourced from Oracle, Pronto and SQL Server
• Deliver BI solutions on various areas of the business including payroll, sales, inventory and cost tracking
• Lead a team of BI developers to support the business
• Train senior management teams on BI solutions being implemented

Information Manager

Confidential

Responsibilities:

• Architected, designed and implemented Cognos 6.5 BI solutions for sales and promotion tracking, stock tracking
• Architected, designed and implemented DW/ data marts sourced from in-house-enhanced ERP running in AS/400
• Train and support senior management teams

Information Manager

Confidential

Responsibilities:

• Architected, designed and implemented Cognos 5 BI solutions for sales and promotion tracking, stock tracking
• Developed multi-user applications promotion tracking and sales tracking using Visual FoxPro 5
• Helped in the acquisition of a Y2K compliant ERP