Gnanavel Chakkarapani

• Resolved technical issues promptly, minimizing downtime and maintaining high levels of customer satisfaction.
• Responsible for loading data for Operational, Balance Sheet, P&L, Actuals and forecasting cubes using Planning Analytics.
• Developed Turbo Integrator (TI) processes to update cubes based upon the new report or input Templates.
• Developed TI wrapper process to handle hierarchy changes of dimensions, deleting consolidated elements and adding them back from data source.
• Support Operational, Non -Operational, Cash Flow and Overhead Applications Reports and Templates issues.
• Support Sales, Operational and Overhead Budget process to prepare Budget for every year.
• Created ad-hoc fix for adding new services, location etc. to cubes and reports. Developed web sheets for user to automate monthly forecasting cycles.
• Responsible for adding TM1 users, roles, and maintaining security.
• Scheduled Chores and Monitored Data Loads on timely manner.
• Used Replication to copy the Cubes from one server to other server.
• Led a team of developers through successful implementation of complex projects while adhering to tight deadlines and budgets.
• Written TI scripts, Business Rules to create Dimensions, Subsets, Attributes, Cubes, and Views and Variance Calculations.
• Optimized the rules using SKIPCHECK and FEEDERS and Created Input forms and Reports using TM1 Perspectives.

.

• Contributed to the development of best practices documentation to streamline future developments and improve team productivity.
• Mentored junior developers in best practices for Cognos development, fostering a supportive team environment.
• Implemented robust security measures to protect sensitive data within the Cognos environment.
• Resolved technical issues promptly, minimising downtime and maintaining business continuity.
• Improved overall system performance by optimising Cognos Framework Manager models and packages.
• Enhanced report generation efficiency by developing and implementing advanced Cognos BI solutions.
• Requirement gathering from business users, analysis and prepare mapping document.
• Installation and configuration of Cognos servers in new environment.Migration of all reports from Cognos 10.2 to Cognos Analytics 11.0.5
• Configure the file system setup and implement finance reports to daily transfer in five difference location.Develop Framework model and packages for ad-hoc retail reports.
  

• Gathering requirement from business users and prepare requirement document and mapping document.
• Developed all reports from Cognos BI 7 to Cognos BI 10.2.2 and Migration of all reports from Cognos 10.2.2 to Cognos Analytics 11.0.10.
• Migration and Implemented the 5 Enterprise Applications Wide Reporting system using Cognos 11.0.10
• Created List Reports, Cross-tab reports, Drill- through reports, Master detail reports using cascading prompts, conditional formatting in Cognos Report Studio.
• Compatibility check of migrated report and fixed the Prompt page and reports using HTML layout from Cognos BI 10 to 11.
• Fix the compatibility report issues using JavaScript and CSS migrated from 10 to 11.
• Working on enhancement and code changes in reports and created deployment archive file to move non-prod to prod environment
• Provided comprehensive training to end-users on Cognos functionalities, resulting in increased adoption rates.

• Advanced organizational efficiency by leading cross-team initiatives to develop new features or resolve complex issues within Cognos suite.
• Improved decision-making capabilities for management with creation of customized, interactive Cognos dashboards.
• Safeguarded sensitive information through the establishment of robust security protocols within the Cognos environment.
• Boosted analytical capabilities for users by integrating external data sources into existing Cognos models.
• Increased user adoption rates by providing comprehensive training sessions on Cognos tools and functionalities.
• Reduced data discrepancies by conducting thorough quality assurance testing on all developed reports and dashboards.
• Enhanced data accuracy by designing and implementing Cognos reports for various business functions.
• Decreased operational overhead expenses by automating routine tasks using IBM Cognos Scheduler.
• Optimized system performance through regular monitoring, tuning, and troubleshooting of Cognos applications.

• Have been involved for designing, creating and analysis of report in Cognos TM1.
• Extensive design and implementation in cubes and dimension.
• Design and create Reports and Input Sheets using TM1 perspective for MS-Excel Interface and integration using Cognos TM1.
• Integrating IBM AS400 to fetch database and load data into TM1 cubes using Turbo-Integrator process and Creating TI processes for developing Cubes and Dimensions.
• Writing complex rules for cubes using Skipcheck and Feeders and Involved in creating securities for TM1 server components in Architect.
• Creating schedule environment for TI processes using chores in TM1 Server and Using TM1 perspective to create active form, spread sheet, slice and snapshot report.
• Defining Views, Approval Hierarchy and managing rights for users in TM1 Performance Modular and Creating dashboards using Cognos Insight.

• Designed and developed forward-thinking systems that meet user needs and improve productivity.
• Created proofs of concept for innovative new solutions.
• Involved in requirement analysis, functional specification & technical design documentation.
• Developed financial report like Balance sheet, Trail balance and P&L in report studio and reviewed Cognos reports and also involved in Cognos portal development.
• Involved in creation of list reports with many number of queries, used techniques like drill through.
• Created value prompts, and text prompts to filter data using cognos report studio and Created Drill- through reports, Master detail reports.
• Extensively implemented conditional blocks to display/hide report contents based on user selection on prompt.