RAMSELVAN NATARAJAN
Titirangi,AUK
Summary
Experienced and enthusiastic Consultant with track record of success across wide range of industries. Possesses exceptional interpersonal, problem-solving and analytical skills to provide advice and expertise to client organizations improving business performance. Experienced in all aspects of operations, strategy and finance.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Planning Analytics (TM1) Consultant
Cubewise
04.2023 - Current
- Provided high-level consulting services to clients, optimizing financial planning and analysis (FP&A) processes by recommending and implementing solutions that streamlined operations, improved accuracy, and enhanced the efficiency of finance systems.
- Developed and delivered comprehensive training programs on financial modelling, data analysis, and best practices, while implementing advanced financial models for budgeting, forecasting, and scenario planning.
- Collaborated with client teams to gather requirements, assess current FP&A workflows, and identify opportunities for process improvements, resulting in increased efficiency and reduced operational bottlenecks.
- Designed, developed, and implemented a sophisticated workforce planning model, incorporating complex workforce structures and performance-based compensation strategies to drive better resource allocation and talent management.
Business Intelligence Cognos & TM1 Developer
The Tatua Co-operative Dairy Company Limited
05.2019 - 04.2023
- Developed a comprehensive finance planning and reporting system, replacing outdated models with modern solutions
- Collaborated closely with the Leadership team, CFO, Group Finance Controller, and Lead Financial & Management Accountants to create a new financial forecast, planning, and budgeting solution
- Created various financial models including activity-based costing, bill of materials, GL, amortization, FX, milk, inventory, production, and sales forecasting
- Developed a centralized reporting solution for finance, board, and operational reports, and built self-service analytics and reporting platform
- Initiated a shift from traditional, Excel-based planning to a centralized, process-driven methodology, moving from person-centered to process-centered operations
- Improved the speed and dynamism of month-end reporting, allowing the finance team to focus more on data analysis and easily generate reports with a single click
Senior Business Intelligence Consultant
Mindfull Limited
04.2015 - 04.2019
- Collaborated with business stakeholders to gather and document business requirements, SOW, and a roadmap for finance system development
- Managed client expectations as an owner and architect of their finance system, ensuring adherence to best practices, strategies, principles, and guidelines
- Implemented best practices in TM1 designs, optimizing cubes, dimensions, and performance, and designed a compliant security model
- Owned the Cognos & TM1 training strategy, provided end-user training, and managed teams of 3 to 5 people in a technical delivery environment
Business Intelligence Consultant - Cognos & TM1
Woolworths Limited
06.2013 - 03.2015
- Created a sales dashboard for the Centralized Reporting Team (CRT) to reconcile sales data from various sources across Woolworths
- Designed and developed a supermarket scorecard for store managers to track store performance and align with group expectations
- Built the Capital Expenditure (CAPEX) model and Property Model for business teams at Woolworths, enhancing analysis, reporting, and flexibility for business changes
Application Support Analyst
Woolworths Limited
10.2012 - 06.2013
- Support Woolworths TM1 finance and Planning solutions for an entire organization
- Provide daily sales reporting from SAP BW, Crystal Reports, and Business Objects for higher management to monitor store-level sales
- Enhance TM1 solutions for existing applications and analyze and provide solutions for any problems
- Led the support team for the high availability of finance and daily sales systems
Project Leader: Cognos & TM1 Change Team
Westpac Banking Corporation
11.2011 - 10.2012
- Successfully upgraded the high availability enterprise Cognos system from 8.x to 10.x on Production, Disaster Recovery, Test, Development and Pre-Production Environment
- Led the change team to implement the business changes and requirements in the Banker's Trust Financial Group (BTFG) PLA and REAM Allocations in the TM1 system
- Led the Application System Transition (AST) Program for Westpac Group Data warehouse for 2 main finance applications BTFG and ERR (Evolve Regulatory Reporting)
Visiting Faculty: Initial Learning Program (ILP)
Tata Consultancy Services
10.2011 - 11.2011
- Teach/Provide insight to the new graduates on Business Intelligence technology with real-time scenarios and hands-on experience using Informatica, Oracle (OBIEE), and Business Objects
- Awarded as a “Champion of ILP”
Solution Designer
Tata Consultancy Services
06.2011 - 10.2011
- As a part of Technology Excellence Group (TEG), to provide due diligence on business intelligence mobile solution to prove that Cognos and TM1 applications helps business to expand their reporting and analytics capabilities
- Design and developed 2 solutions as a proof of concepts which are “Payment and Cash Management” and “Performance Management Review”
- Participated in the IBM Workshop and awarded as a “SPARK”, which is IBM active participant certificate
Business Intelligence Reporting Team Lead
Tata Consultancy Services
07.2009 - 06.2011
- Led the offshore Cognos team to deliver timely solutions for the Citi cards business including the Global Productivity Dashboard and migration of Impromptu reports to the Cognos Application
- Designed the Framework model, data analysis, and mining based on the active reports
- Involved with the Data warehouse design team and provided the constant feedback to make sure the warehouse was fit for the purpose
Business Intelligence Developer
Tata Consultancy Services
07.2007 - 06.2009
- Involved in creating month-end reports using Microsoft SSRS which includes graphical analysis reports provide users to analyze the card data
- Developed reporting cubes using the Microsoft SSAS for the inventory reports and was involved in writing SQL queries for testing the reports developed in Microsoft SSRS
Assistant System Trainee
Tata Consultancy Service
04.2007 - 06.2007
- Initial training program on developing/designing the effective solutions on Java, Business intelligence (IBM Cognos & SAP BO) and Data warehouse tools (Microsoft BI Tools & Informatica)
- This training program includes SELC process management and effective professional communications
Education
Bachelor of Engineering - Electronics and Communication
Anna University
05.2006
Skills
- IBM Planning Analytics (TM1)
- IBM Cognos Analytics
- Python
- SQL Server
- Financial modeling
- Forecasting and reporting
- Data warehousing
- Data analytics
- Reporting writing
- Technical review
- Business presentation
- Client relationships
- Requirements gathering
- Project management
Accomplishments
- Earned the prestigious " TM1 Developer Credential " badge from Cubewise by successfully completing a comprehensive assessment, which required building a functional model evaluated for accuracy and efficiency by TM1 experts.
Certification
- Python Standard Library Essential Training, LinkedIn
- Python Data Analysis, LinkedIn
- Learning Python, LinkedIn
- Introduction to Git and GitHub, Google
- Using Python to Interact with the Operating System, Google
- Crash Course on Python, Google
- TM1 Developer Credential, Cubewise
- TM1py Fundamentals, Cubewise
- Advanced MDX, Cubewise
- Advanced Rules, Cubewise
- IBM Planning Analytics Workspace V2.0.x Modelling with Rules and Feeders, IBM
- IBM Planning Analytics Workspace V2.0.x Modelling with Dimensions and Cubes, IBM
- IBM Planning Analytics V2.0.x TurboIntegrator, IBM
- IBM Planning Analytics Workspace V2.0.x Explore Data, IBM
- Wherescape Certified - Data Warehouse Development using Wherescape RED, Wherescape
- IBM Certified Developer - Cognos TM1 10.1, IBM
- IBM Certified Developer - Cognos 10 BI Metadata Models, IBM
- IBM Certified Developer - Cognos 8 BI OLAP Models, IBM
- IBM Certified Designer - Cognos 10 BI Reports, IBM
- Oracle Certified Associate in 9i, Oracle
Awards
- Mindfull Person of the year, Mindful NZ Limited 2018
- Mindfull Team of the year, Mindful NZ Limited 2018
- Champion of Initial Learning Program, Tata Consultancy Services Limited 2011
Hobbies
Played badminton for 12 years at the highest level, competing in tournaments and representing the regional masters team.
Coached the junior cricket team for 6 years, fostering teamwork, leadership, and skill development.
Languages
English
Full Professional
Tamil
Native or Bilingual
Timeline
Planning Analytics (TM1) Consultant
Cubewise
04.2023 - Current
Business Intelligence Cognos & TM1 Developer
The Tatua Co-operative Dairy Company Limited
05.2019 - 04.2023
Senior Business Intelligence Consultant
Mindfull Limited
04.2015 - 04.2019
Business Intelligence Consultant - Cognos & TM1
Woolworths Limited
06.2013 - 03.2015
Application Support Analyst
Woolworths Limited
10.2012 - 06.2013
Project Leader: Cognos & TM1 Change Team
Westpac Banking Corporation
11.2011 - 10.2012
Visiting Faculty: Initial Learning Program (ILP)
Tata Consultancy Services
10.2011 - 11.2011
Solution Designer
Tata Consultancy Services
06.2011 - 10.2011
Business Intelligence Reporting Team Lead
Tata Consultancy Services
07.2009 - 06.2011
Business Intelligence Developer
Tata Consultancy Services
07.2007 - 06.2009
Assistant System Trainee
Tata Consultancy Service
04.2007 - 06.2007
Bachelor of Engineering - Electronics and Communication
Anna University
Similar Profiles
Jared HeelamJared Heelam
Computing, Tablet & Smart Home Buyer at The Warehouse StationeryComputing, Tablet & Smart Home Buyer at The Warehouse Stationery
Ramandeep KaurRamandeep Kaur
Stock Controller at Reliance RetailStock Controller at Reliance Retail
Renuka DobariyaRenuka Dobariya
Grocery Assistant at Expert Enterprise LimitedGrocery Assistant at Expert Enterprise Limited