Aashish Niphadkar

• Analyzed TM1 applications to optimize financial forecasting, budgeting, and reporting processes.
• Developed model testing checklist for migration to IBM PAW Cloud version 2.0.104.
• Automated nightly dimension updates and administrative tasks utilizing Python and REST APIs.
• Enhanced rules and TI processes for improved data calculation and loading efficiency.
• Facilitated global teams in designing standardized user input forms.
• Managed application design prioritization while supporting team members with daily tickets.
• Maintained current status of BA and design documents.

Established contracts with Johnson & Johnson, AbbVie, CBS Networks, and Merck & Co. To support business initiatives.

• Conducted JAD sessions with clients to evaluate plans and reporting models.
• Analyzed client feedback to identify enhancements and establish future timelines.
• Supported operational efficiency of on-premise TM1 and PA applications.
• Executed silent installations of IBM PAW, PAX, WEB, Architect, and Perspectives on Amazon Cloud.
• Implemented Kerberos security for Windows single sign-on across TM1 Web and PAW.
• Collaborated closely with IBM on Problem Management Records.
• Utilized IBM Planning Analytics from TM1 10.2 to PA 2.0.9.3.

Secured contracts with Charles Schwab and Savers to increase revenue streams.

• Analyzed TM1 applications for financial forecasting, budgeting, and reporting accuracy.
• Identified upgrade requirements for transition from TM1 10.2 to IBM Planning Analytics.
• Developed prototypes for existing inputs and reports within Planning Analytics.
• Redesigned processes to integrate new functionalities seamlessly.
• Authored user handbooks and guides for PAX and PAW access.
• Created comprehensive business requirements documents alongside technical documentation.
• Conducted user training sessions to ensure proficiency in new system capabilities.

Established strong relationships with Qualcomm to enhance collaboration and service delivery.

• Analyzed TM1 and BI applications, optimizing reporting cubes and data sources.
• Collaborated with financial and reporting teams to gather and implement change requirements.
• Executed strategies to improve processes for data loads and historical data storage.
• Conducted code reviews, ensuring adherence to best practices in development.
• Transitioned forecasting from a twelve-month to a twenty-four-month rolling period by adjusting the rules.
• Refined cubes and dimensions for seamless integration of new NXP acquisition.
• Modified Oracle FPM models using sample data to ensure alignment with existing frameworks.

• Conducted JAD sessions to capture requirements from existing and new Adaptive Planning system users.
• Streamlined monthly open and close processes through automation, enhancing operational efficiency.
• Designed and stabilized TM1 system at IMC utilizing TM1 Web interface.
• Upgraded TM1 from Version 10.1 to 10.2, implementing fix packs and backup strategies.
• Managed TM1 application maintenance in compliance with complete SDLC protocols.
• Identified project dependencies and risks while establishing effective mitigation strategies.
• Facilitated status meetings and prepared weekly progress reports for stakeholders.

Established client relationships with MGM Resorts and Amgen Biotechnology Company.

• Conducted health checks on TM1 systems, recommending targeted improvements.
• Evaluated TM1 structures, identifying areas for performance enhancement in cubes and hierarchies.
• Developed comprehensive implementation and testing plans, including prototypes for proposed changes.
• Collaborated with senior management to define implementation strategies and timelines.
• Ensured implementation team fully understood system changes to promote effective execution.
• Successfully transitioned TM1 applications between onsite and offshore teams.

Cultivated partnerships with Actelion Pharmaceutical, Taylor Made – Adidas, Fifth Third Bank, TBC Corporation, and West Palm Beach, Florida.

• Facilitated strategic discussions to align IBM TM1 applications and services with client needs. Understood the Hyperion Essbase cubes for financial reporting, management reporting, and inside bank reporting.
• I understood the Hyperion Essbase cubes for financial reporting, management reporting, and inside bank reporting.
• Interacted with different LOBs and gathered requirements for historical financial reporting cubes starting from 2003, as ten years of data were needed.
• Analyzed historical reporting requirements for hierarchical changes across clients.
• Developed data flow diagrams using Perl and Graphviz to illustrate complex processes.
• Collaborated with offshore teams to transfer knowledge of reporting cubes and template creation.
• Executed writing and debugging of TI processes to ensure optimal functionality.
• Gathered requirements for financial reporting cubes dating back to 2003.

• Analyzed multidimensional design of existing cubes for TM1 financials and reporting requirements.
• Mapped legacy Cognos Planning system to auxiliary cubes supporting primary reporting structures.
• Collaborated with Kaiser support team to ensure effective TM1 server maintenance.
• Managed user access and security protocols within TM1 environment.
• Recommended structural changes to enhance existing cubes, and refine security processes.
• Automated daily error file generation and distribution to relevant team members using email logs.
• Executed monthly Turbo Integrator processes and routine data rollup tasks.
• Streamlined FTP data transfer automation to mainframe servers housing GL system.

Clients: Silver Spring Networks, The Boeing Company.

Silver Spring Networks, Redwood City,

• Understanding the multidimensionality of the data for designing cubes in TM1 and for reporting needs.
• Mapped the old structure for different auxiliary cubes, feeding the main cubes, and reporting cubes.
• Worked with them to create the cubes and modify the dimensions in the current structures and the old cubes using business rules and the TI process.
• Worked with the team on enhancing the existing cubes by suggesting changes to the structures and modifying the processes.
• I worked on data validation with the Oracle team as part of the TM1 routine.
• Added security to the cubes and dimensions in TM1 by controlling them from time to time.
• I worked with the Oracle team to clean the data as a regular fishing routine, applying different checks from time to time.
• Worked with a third party named Data 41 for specific requirements.

Environment: Cognos TM1 (9.5), TurboIntegrator, TM1 Architect, TM1 Perspective, Oracle 10g, ASCII files.

The Boeing Company, Cypress, California

• Understanding the multidimensionality of the data for designing DMR models in Cognos 8, as well as for designing dimensions and cubes in Cognos TM1, by analyzing and identifying different data sources.
• Gathered the requirements for regular analysis and for financial performances during the JAD sessions.
• Created a prototype model for the users.
• Created DMR models in Framework Manager, and analyzed them in Query Studio.
• Published DMR models and cubes to the Cognos Portal.
• Used best practices in Cognos TM1 for creating dimensions and cubes in the TI process (ordering, indexing, loading the data in cubes, and also including naming conventions) and rule statements.
• Worked on the scenario modeling (what-if analysis) for the Boeing Telecom group and the Boeing Desktop & Computing group.
• Involved in the replication of cubes between servers and synchronized the cubes on demand.
• Strongly analyzed and created different budgeting scenarios by using combinations of different subsets and employing a data spreading technique.
• Improved the performance of the cubes and DMR models. Controlled the cubes and dimensions in TM1.
• Created ad hoc reports in Query Studio for top-level management. Managed on-site and offshore teams.

Environment: Cognos 8.4 (Framework Manager), Query Studio, Cognos TM1 (9.4), TurboIntegrator, TM1 Architect, TM1 Perspective, Oracle 10g, MetaManager, ASCII files.