We provide IT Staff Augmentation Services!

Lead Consultant Resume

SUMMARY

  • Solutions - oriented core TM1/Planning Analytics professional with 8+ years of solid Corporate Performance Management with focus on TM1/Planning Analytics specifically analyzing, architecting/designing, developing, testing, integrating, enhancing, performance improvement, implementing and/or deploying high quality TM1 systems/applications, IBM Cognos TM1 and Planning Analytics
  • Overall 14+ years of combined experience in Information Systems and Finance, unique combination of skills gained from experiences from USA, Canada, India and Australia
  • Experience in TM1 solutions for financial, non-financial- budgeting, forecasting, planning and reporting models including developing/scripting/enhancing/maintaining simple to complex Turbo Integrator processes (ETL), Rules, creating/maintaining Active forms, Cube designing, Dimensions, Views, Subsets, Security, Active Forms and User Interface design/development and data loads and reconciliation
  • Experienced in TM1/Planning Analytics Architect, PAX,PAW, TM1 Perspectives, TM1 Web
  • Experienced to design optimal solutions through joint application design where diverse solutions are possible in Agile and SDLC environments
  • Migrated TM1 objects between environments such as DEV, SIT/QA, Production and setup environments
  • Effectively automated systems and processes and provided improvements on existing processes
  • Currently learning ‘Data Science with Python’
  • Prepare technical and architecture documentation in SharePoint, Video recordings, etc.
  • Experienced in analyzing issues, understand data flow between systems, understand code/scripts/configuration, batch jobs, TM1 objects, data analysis, identifying the root cause, change/update code, discuss/design better way of performing tasks, developing, testing different scenarios and implementing fixes and enhancements
  • Followed best practices in industry for OLAP and provided effective solutions
  • Working experience: IBM Cognos TM1, Teradata, Microsoft Excel, Word, Visio, Power Point, Industry Print (BPM), SAP Xcelsius,, SQL, multi-dimensional database structures - OLAP and best practices

PROFESSIONAL EXPERIENCE

Confidential

Lead Consultant

Responsibilities:

  • Effectively designed/developed enhancements, tested and deployed TM1 application solutions based on local market requirements by learning and understanding the existing applications
  • Implemented solutions utilizing IBM planning analytics Architect, PAX, Workspace
  • Written TI processes for loading data and data transformations ( such as loaded data with conditional loads for populating volumes in Variable Opex based on source split in COGs with source as Revenue (Top line) area, populated loaded key for previous 3 months, etc.) for actual and planning scenarios
  • Created cubes for local requirement, dimensions, attributes, alternate hierarchy and maintained metadata/dimensions and rules in development/test environment
  • Analyzed feeder issues in rules and modified rules as per local requirement
  • Collaborated effectively with functional consultants and team
  • Created Exploration, Custom and Dynamic reports using PAX, published the reports in Application, published reports in workspace sheets, in case of migration from one server to another updated/changed server name in reports by updating package name and created/maintained action buttons
  • Created new sheets in workspace, published cube views in these sheets, synchronized between views/sheets, used sets to select elements and maintained in test server the existing workbook/sheets
  • Administered Planning Analytics using Workspace (Administration) for server memory, stopping/starting server, long running processes(locks), permissions
  • Created MDX and used MDX in subsets and TI process import/source view creation
  • Migrated objects between servers
  • Analyzed logs for unexpected server down, cube dependency, dimension update failures, data load failures, etc.

Confidential

Architect / Senior Consultant

Responsibilities:

  • TM1 Specialist on project creating banking cube (includes multiple data sources, data transformations and adjustments) to provide Business and Consumer Banking as a single place to produce monthly reports
  • Designing, developing, unit testing, release testing, closely assist performance testing, create/migrate objects between TM1 environments, monitor logs/process history/changes through pulse for bank’s scenario modeling enterprise wide new application in Agile environment
  • Key working areas are gathering information, discuss solution options, follow or recommend best practices, designing and creating turbo integrator scripts such to load data from source database, files or cubes, creating views and subsets (static and dynamic subsets using MDX) for source and target and automation of data sources, cloning of dimensions from one dimension into another, creating and populating attributes, reengineering existing TIs for enhancements
  • Create processes to load cubes from source to target, create/update dimensions and participate in date reconciliations between source to multiple intermediate cubes and understand the dimensionality and dimensions of cubes
  • Developed Balance Sheet movement in source and multiple downstream cubes, enhanced Capital Methodology workflow (webform/security/update TI/enhance rules/enhance workflow tasks in gaining Ownership/Submit/Reject/Approve), reconciling data between source/business requirement to target cube data, addressing performance issues (capturing run time, records processed, addressing locking issues, capture errors, cube dependency, etc).
  • Developed element exclusions (multiple elements combination) while loading data from source cube to target cube
  • Delivering highest quality work by thorough analysis, modelling, building, reviewing and strict adherence to timelines and budget and work on multiple Sprint development tasks simultaneously by prioritizing the tasks as per client’s need through open interaction
  • Developed and enhanced end-to-end TM1 models and prototypes as per requirements
  • Effectively performed regression testing of application
  • Working with the Technical Leads, Specialists and ensured deliverables meet architectural, technical scripting, security and data standards
  • Performed security updates, executed workflow tasks for accuracy and completeness - created cell security, updated cubes/dimension security, created active form and workflow scripts
  • Developed Turbo Integrator processes to load data from source to single version of truth and load to downstream cubes via mapping/lookup cubes
  • Strongly support and resolve issues from System Integration Testing (SIT/QA) team, Performance Testing team and Release Testing
  • Capture implementation plan while doing release testing, create back-out plan/tasks to hand over to Production team implementing the developed sprint tasks in production environment
  • Responsible for benchmarking (performance evaluation), testing, documentation and implementation
  • Worked on looping/thrashing issue where processes executed from concurrent users gets into lock resolved by creating unique view/subset names and serialization of objects (Synchronization)
  • Migrate objects between environments using Pulse, monitor logs, share details and solutions with client such as cube logging (on/off), errors if any from logs as Attribute is not Unique while cloning dimensions and data load resolving errors
  • Participate in daily sprint meetings, updat JIRA tasks and spring planning sessions
  • Provide detailed process documentation, create and setup multiple new test users (}ClientGroups) by analyzing groups the test user to be given access
  • Work with testing team for end to end testing, contribute thoroughly to implementation plan
  • Migrate objects between environments using Pulse, monitor logs, processes, share details and solutions with client such as cube logging (on/off), errors if any from logs as Attribute is not Unique while cloning dimensions and data load resolving errors
  • Create schedules in interface cube and calendar cube - these hold list of TIs with their detailed schedule of execution along with source cube, target cube, type of load (cube to cube or cube to txt, etc), parameters to be used, source target mappings, etc. and create back out plans and associated scripts

Confidential

Architect / Senior Consultant

Responsibilities:

  • Captured and reviewed TM1 architecture on Production and Development servers by working with IT Infrastructure team
  • Consulted with business and set up smarter consolidated views they could drill-down to track business performance quickly with relevant and timely information
  • Reviewed Client’s TM1 application model and performed re-ordering of dimensions based on calculations using dimension elements and populated cube cells
  • Reviewed Server Configuration file and/or environment, TM1s.cfg and increased maximum view size
  • Monitored and reviewed performance control cubes, }StatsByCube, }StatsbyClient }Stats For Server
  • Reviewed TM1s.cfg and increased maximum view size, set up smarter consolidated views that users could navigate quickly and created dynamic subsets
  • Improved performance by approx. 40% to 60% on views that were taking longer time to open
  • Reviewed rules and recommended areas where performance can be improved by looking into Feeders, best practices approach of avoiding text functions in Rules (such as SUBST and SCAN)
  • Looked for enhancement in TM1 rules such as recommended to practice using TM1 attributes instead of text functions (SUBST, SCAN), these functions in TM1 are usually slower than using attributes
  • Provided recommendation to use lookup cubes
  • Provided recommendation to restart server on a regular schedule as to clear memory in garbage

Confidential

Architect / Senior Consultant

Responsibilities:

  • Developed a prototype by designing, developing and testing TM1 cubes, dimensions (elements/attributes), TI processes, views, subsets and rules for a General Merchandise product planning project’s POC
  • Analyzed requirements and created technical designs
  • Developed a workflow process for POC that captures through a planning cycle, the financial parameters and metrics of the General Merchandise’s Global product portfolio across all product lines
  • Created TM1 client instance, automated work flows

Confidential

Senior Associate

Responsibilities:

  • Responsible for technically developing enhancements through design and build, testing and deploying TM1 solutions for client’s global enterprise wide Inventory planning and forecasting using IBM Cognos TM1, in an Agile development environment
  • Developed and enhanced the ETL in Turbo Integrator (TI) complex processes for both new and existing functionalities such as loading data into Cubes from different data sources, automation of data sources and moving data between cubes
  • Enhanced Rules either by altering the existing Rules or adding new Rules or removing Rules based on requirements, maintaining optimized performance through Feeders
  • Maximum Automation of processes in TM1 - reduced manual updates
  • Enhanced TM1 web forms - using Active forms, applying conditional formatting, action buttons and deploying into web
  • Migration of TM1 applications between development, QA and Production environments
  • Designed and enhanced dimensions and developed Turbo Integrator processes such as to create elements and attributes, automated population of various attributes and automated population of complex control/look up cubes for setting configurations
  • Technically integrated a model with existing global model in TM1 by learning and understanding the application
  • Worked with engineers, functional and other technical teams to solve problems in IBM Cognos TM1 system/Application and its related areas
  • Analyzed requirements and created technical documents
  • Participate in daily sprint meetings, updated JIRA tasks, support analyst in user stories
  • Worked on TM1 Application security model
  • Understand the architecture to know the source and destination (up steam and downstream), data flow, assess impacts, propose batch timings/updates, etc.
  • Conducted testing to ensure that the systems work as expected and to ensure proper functioning of the application and data integrity
  • Completed sprint tasks by gathering information, designing/developing TM1 Turbo Integrator (TI) process scripts, Rules, Feeders, Views and Subsets
  • Performed Unit / Integration Testing and monitored TM1 logs in Test, identified errors and took corrective measures
  • Helped Production Support team in performed root cause analysis of technical issues, fixed the issues and ensured timely delivery

Confidential

Developer

Responsibilities:

  • As a TM1 systems engineer engaged in Financial Planning project
  • Created and maintained cubes such as headcounts, headcount output and recruitment calculation and dimensions such as organizational hierarchy, currency
  • Monitored various processes and troubleshoot issues by examining turbo integrator, rules, data, configuration (such as cube view), metadata/dimension elements, logs, source system data setup, understanding the business logic working with clients/users
  • Built understanding of functional and technical logic/calculations, processes and user interface
  • Created reports and dashboards to support financial and operational reporting such as maintaining expense reports, KPI and sales dashboards
  • Created reports using slices from cube views, used worksheet functions such as DBRW/DBRA in worksheet
  • Demonstrated experience in writing rules using Feeders, Skip check, DB function, inter cube references and performed complex calculations
  • Provided data extracts through direct client interaction and functional analysis
  • Troubleshoot issues and followed through to resolution, fixed bugs and maintained applications
  • Responsible for Cognos TM1 10.1 administration of dimensions, cubes, Turbo Integrator, Rules and Security
  • Created users/clients in TM1 and assigned security based on the requirement
  • Understood existing model, gathered information and evaluated output requirements and formats
  • Managed financial data uploads; making a copy of data from one element from a dimension to another element, set up rules and calculations and altering dimension structure as per the requirements of the business
  • Monitored user helpdesk tickets
  • Raised PMR and follow up through to resolution of the issues
  • Functionally learnt the systems to understand TM1 application

Hire Now