• Responding to a change in the client's IT direction, promptly prepared for construction of the planning and forecasting tool, developed a global enterprise-wide application using Cognos TM1.• Design, develop, and implement Cognos TM1 10.2 Applications for Financial Planningand Budgeting models with complex rules.• Development of TurboIntegrator(TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.• Maintenance of TM1 users, roles, and security.• Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.• Created complex Active Forms and enhanced the performance of existing Active forms.• Scheduled Chores and Monitored Data Loads on timely manner.• Created TI Processess to transfer currency data to currency cube.• Created rules to transfer data between cubes.• Used TM1 rules editor to create and edit rule to create various calculations.• Used Replication to copy the Cubes from one server to other server.• Development of ETL processes based upon complex SQL queries retrieving data from various sources for creating dimensions and cubes, and loading data using TurboIntegrator.• Import the data from ODBC and Text files using TM1 Turbo integrator.• Provided the What If Analysis facility to users to get desired output by changing parameters.• Reviewed Business Requirement Document (BRD) for Completeness, Gather and analyze financial planning, budgeting and reporting requirements.• Performed Unit Testing and User Acceptance Testing• Used HP Quality Center for Bug Tracking, Reporting and Analysis.

Role: Sr TM1 DeveloperResponsibilities• Building Dimensions and Cubes.• Creating Turbo Integrator Processes as DB2 systems Backend Data source.• Writing Dynamic Turbo Integrator Automation Scripts in TI Processes.• Data Reconciliation and validation of data with the TM1 Cube level and Reports level data. • Applying Business Rules to Cubes for advanced modeling.• Tuning the cubes for better performance.• Defining Drill through paths to an ODBC source, views in another cubes.• Create Rules for currency conversion.• Creating Excel based reporting suites.Projects:Annual Operating Plan Projects (2014, 2015)The objective of project was to give a system which is extremely simple to maintain and very easy to configure multiple iterations of budgeting at same time, thereby reducing the manual configurations of adjustments happening every quarters. Design the model in such a way that to effectively use TM1 parallel interaction feature to improve the performance and to avoid the locking for a huge user base. This Project was to deliver a single platform for entire bank which would cater the vision of centrally maintained diversified Budgeting Solution. Roles & Responsibilities: Been a part in architecture design. Understand the business requirements and design modules which cater the need. Co-Lead the team in achieving the time lines and mitigating the challenges. Developed TM1 planning application and provide user training. Developed optimal TM1 solution which was able to handle large volume of end users. Created the Excel templates combined with VBA which will reduce the load in TM1 wherever possible. Built reconciliation applications in excel and provided support for the business throughout the submission period and reporting Changing the configuration and templates to support the new requirements. Performed Unit, Integration, and Regression and UAT Test phases

• Manage TM1 data through Excel and Spreadsheets.• Handling Change requests, related to creation of new user profile.• Validation of data for accuracy and similarity.• Maintaining and assigning the securities in TM1 application environment.• Used TM1 rules editor to create and edit rule to create various calculations.• Using turbo integrator to identify and map dimensions and data from an external data source to or existing source.