Venkateswara K.

About Me

Venkateswara is a Certfied Anaplan Model Builder/Architect and Data Engineer with close to 4 years of experience in EPM technologies, providing solutions on the go through design approach and optimization. He builds Anaplan models, with end-to-end project execution from design, implementation, and optimization to ongoing maintenance and working closely with clients. Venkateswara works on data integration to ensure smooth data flow for financial analysis and reporting and develops TM1 models to support financial planning and consolidation processes.

Backend

Database

SQL Microsoft SQL Server SQL Server Integration Services (SSIS) SQL Server Analysis Services (SSAS)

DevOps

Other

Anaplan Model Builder Data Modeling Cognos IBM Planning Analytics Data Analysis ETL Data Architecture Object-oriented Programming (OOP) Business Analysis Core Java Data Warehousing Microsoft Power BI Enterprise Performance Management (EPM) Dashboards DAX Data Reporting Proof of Concept (POC) Cognos TM1 IBM Cognos Metrics

Work history

LTIMindtree
LTIMindtree
Anaplan Model Builder
2022 - Present (3 years)
Remote
  • Analyzing client’s business requirements and processes through user stories analysis.

  • Building a model in Anaplan, end-to-end project execution from design, implementation, and optimization to ongoing maintenance and working closely with clients.

  • Collaborating with internal and external colleagues to analyze existing processes.

  • Identifying key business drives, new processes for improving model, and new actions, resulting in decreased cost and improved performance, while maintaining Anaplan best practices.

  • Designing solution architecture based on Anaplan best practices, ensuring scalability and flexibility of the models.

  • Handling defects raised by users, such as loading Anaplan data and creating structures, and working on enhancements based on business requirements.

  • Helping end users get familiar with Anaplan tool and with the back-end processes to maintain the model more effectively.

  • Creating versatile and dynamic dashboards for clients and developing dashboard reporting templates based on changing requirements.

Anaplan Model Builder Data AnalysisData ModelingIFRS Financial Reporting Financial Modeling Financial Planning & Analysis (FP&A) Business Requirements User StoriesSolution Architecture Solution Design Dashboards User Onboarding
LTIMindtree
LTIMindtree
Cognos TM1 Developer
2021 - 2022 (1 year)
Remote
  • Worked on a financial consolidation and reporting project for a UK-based company using IBM Cognos Controller as a primary consolidation tool.

  • Integrated data between Cognos Controller and TM1, ensuring smooth data flow for financial analysis and reporting to improve decision-making by providing timely and accurate financial insights.

  • Designed and developed TM1 models to support the company’s financial planning and consolidation processes using data from Controller for management reporting.

  • Extensively used TI for loading data into dimensions, cubes, and new dimensions and cubes to existing environment and created rules to transfer data between cubes.

  • Scheduled chores and monitored data loads in a timely manner, maintaining TM1 users, roles, and security.

  • Gathered and documented all outstanding and new business requirements and worked on user access review.

  • Provided production support, troubleshooting incidents and working with IBM vendor in case of tool-related issues.

  • Analyzed and translated business requirements to business logic on TM1 platform.

Cognos TM1 IBM Planning Analytics SQLData ModelingData AnalysisIBM Cognos Financial Reporting Financial Analysis Financial Modeling Financial Planning & Analysis (FP&A) Management Reporting Business Requirements Production Support
Contract
Contract
Power BI Developer
2021 - 2021
Remote
  • Imported data from various sources and worked on various transformations available in Power BI to create reports.

  • Integrated custom visuals based on business requirements using Power BI Desktop.

  • Generated computed columns and computed tables in Power BI using DAX.

  • Developed upselling and cross-selling reports using DAX functions.

  • Created reports using time intelligence calculations, tables, and aggerate functions in reports.

  • Improved data accessibility by establishing table relationships and hierarchies and implemented best practices for data.

Microsoft Power BI Proof of Concept (POC) Data Transformation Data Reporting Business Requirements Power BI Desktop DAX DataTablesBI Reports Dashboards & ReportsData Aggregation SQL Functions

Education

IBM Planning Analytics Workspace V2.0.x Modeling with Dimensions and Cubes
IBM Planning Analytics Workspace V2.0.x Modeling with Dimensions and Cubes
IBM
2024 - 2024
Anaplan Model Builder (Expires Dec 2025)
Anaplan Model Builder (Expires Dec 2025)
Anaplan
2023 - 2023
Microsoft Certified: Azure AI Fundamentals & Azure Data Fundamentals
Microsoft Certified: Azure AI Fundamentals & Azure Data Fundamentals
Microsoft
2022 - 2022
B.Tech Electronics and Communications Engineering
B.Tech Electronics and Communications Engineering
Mother Theresa Institute of Engineering & Technology (MTIET), Palamaner - India
2016 - 2020 (4 years)