Summary
Overview
Work History
Education
Skills
Websites
Certification
Alteryx designer Core Certification
Quote
Additional Certifications
Timeline
Generic

DhineshKumar Thinakaran

Manager - Information Technology
Flanders,NJ

Summary

15+ years of diverse experience in Information Technology, to the Entire Software Development Life Cycle (SDLC) from Requirement, Study to Development and implementation and Change Management. That will also include infrastructure implementation, financial reporting, application administration and large-scale system integration projects. 13 year of experience in a Breadth of Hyperion products including Hyperion Financial Data Quality Management, Financial Data Quality Management-Enterprise Edition, Essbase, Hyperion Financial Management, Oracle Data Integrator, Smart view and Excel Add-In on Windows environments. In-depth understanding of the upgrade process as well as the process of migration from Dev to Test and Test to Production Environment. Main liaison between IT and Finance during HFM/FDMEE upgrade project, as well performed end-to-end process with detailed analysis. Done extensive testing and wrote queries in SQL to ensure the data loading. Perform unit testing at various levels of the ETL. Also, debugged the sessions by utilizing the logs of the sessions. Responsible for initiating Financial Data Quality Management (FDQM)/ Financial Data Quality Management-Enterprise Edition (FDMEE) through setting standards for Data Quality, Data profiling, Data augmentation and overall Data Integration. Expertise in developing and Administration of Financial Reports and Interactive Reports. Facilitate resource planning with project stakeholders at corporate level. Identify and define project risks and communicate to project team and customer representatives. Annual Database Password changes for all Hyperion schema. Automated the daily backup scripts and service restarts using batch scripts in windows. On time completion of all assigned tasks and desirable meeting the business expectations and timelines. Has extensive experience in designing and development for diverse industrial landscapes and varied level of complexities that are unique to some of large Fortune 500 clients in industries like Retail, Pharmaceutical, Technology and Insurance. Strong commitment towards quality, experience in ensuring compliance to coding standards and review process. Possess Ability and Willingness for learning new applications as needed. Active team lead and team player with excellent interpersonal skills, keen learner with self-commitment & innovation.

Overview

16
16
years of professional experience
1
1
Certification

Work History

Manager-Finance ITS (Information Technology Services)

Zoetis Inc.
01.2016 - Current
  • Build, manage, and developed an application team comprised of 5 personnel, provide coaching and mentorship, conduct performance evaluations, and establish inclusive work cultures
  • Managed 8 projects valued at $60K to $200K, oversaw dynamic project teams comprised of Stakeholders, Auditors, Business Analysts, Change Control team, ITGC team, External Vendor and ensured on-time and on-budget completion
  • Generated 3 FDM reports and 3 FR reports in 1.5 years, exceeding goal by 10%
  • Identified reporting process improvement opportunities for quarterly repetitive task on behalf of business operational team, and enhanced operational effectiveness and improve team productivity, resulting in 60% reduction in work hours
  • Managed a team of 5 finance technology professionals in developing and implementing strategic plans for financial systems and processes
  • Oversaw the implementation of new finance technology systems, resulting in a 20% increase in efficiency and accuracy
  • Developed and maintained relationships with external vendors to ensure timely and cost-effective delivery of technology services
  • Conducted regular training sessions for staff on new technology systems and processes to improve their technical skills and knowledge
  • Collaborated with cross functional teams to identify and address any issues or gaps in the finance technology systems
  • Monitored and managed the budget for finance technology services, ensuring cost effectiveness and compliance with financial regulations
  • Conducted regular audits of finance technology systems to ensure data integrity and security
  • Also perform yearly review on security, application changes or process changes to ensure all the evidences are available and deviations are documented for review meeting with Auditors
  • Implemented data analysis and reporting tools to improve decision making processes and provide insights to senior management
  • Led the integration of new finance technology systems with existing systems to streamline processes and improve overall efficiency
  • Stayed updated on industry trends and best practices in finance technology, making recommendations for improvement and innovation within the organization
  • Upgraded from 11.1.2.1 to 11.1.2.4 with all FDM scripting, re-engineering with JYTHON scripting and application development from scratch.

Senior Associate Projects

Cognizant Technology Solutions
02.2015 - 01.2016
  • Responsible for managing all Hyperion related design, build, implementation, process improvement initiatives
  • Responsible for budgeting, vendor management, and training management
  • Involved in Knowledge transfer and development transition to the other team members and to production team (onshore and offshore) Performed system upgrade and related tested from EPM 11.1.2.1 to EPM 11.1.2.3 for HFM/FDM
  • Organized and Conducted data mapping sessions and functional design reviews Responsible for maintaining all metadata changes for Financial Data Quality Management (FDQM) applications (Actual & Forecasting data) and HFM
  • Responsible for monthly activities and monitor the deadline of financial data submission on respective deadline, make the system ready for user for data submission
  • Documented all the application and user issues and the corresponding resolutions in order to facilitate easy knowledge transfer
  • Provide support to users on access related issue and to some users, installing EssBase add ins and smart view Responsible for Promotion of entities based on the specific workday, based on different account level data freeze, as decided by controllership and FP&A team
  • Worked with the business users directly on Drill through issues, Responsible for month-end tie-out and provide related support to financial controllers
  • Infrastructure Support – Server/Services Maintenance like File system Space Management, moving Backups to shared server, Exports, weekend maintenance for performance
  • Manage/Supervise PeopleSoft team that includes permanent employee and consultants
  • Coordinated efforts with the Infrastructure team to ensure all environments/servers were built to the right specifications
  • Managed efforts in installing SSL to Workspace servers
  • Leaded a team of 5 resources (1 onshore & 4 Offshore)
  • BT lead ensuring business cycles are supported and completed within due date
  • Ensure end to end delivery of new enhancement\project activities WDAC calendar activities for support team

Team Lead- Analyst Programmer

Accenture Solutions
09.2014 - 01.2015
  • Managed to provide excellent support to customers in a quick turnaround time
  • Ensured meeting various SLA like ownership SLA, Resolution SLA etc
  • Created reconciliation spreadsheets to tie data between HFM applications using Excel Add In and Smartview
  • Designed, developed and supported more than 100 upstream locations, mapping tables, security, import scripts, and logic accounts as part of FDM/HFM metadata changes
  • Loading FDM data using ODI and integrating various data such as Actual, Budget and Forecast and historical data across the Hyperion Products and troubleshooting the data load issues through FDM
  • Involved in regular Client interaction/Calls to identify the issues, change requests, enhancements and provided best of technical solutions
  • Created users and user groups in the Planning applications and assigned security to web forms Resolving and documenting the defects/enhancements on data issues and other issues reported by users
  • Working closely with off-shore supporting team and coordinating the resources Updated the FDM script on Adhoc based change request from the Business users
  • Interacting with the Team on various forums to discuss the status, clarify any queries regarding the functionality etc
  • Trained, assisted and transferred knowledge to offshore/onshore resources.

Senior Analyst Programmer

Accenture Solutions
09.2011 - 09.2014
  • Responsible for coordinating Hyperion projects including mapping of data, installation of Hyperion, modifications, and reporting, account mapping and Logic (Logic includes Formulas within the Chart of Accounts and Entities) Performed data extracts and loads to Hyperion from SAP
  • Also, created and exported data from Retrieve Excel to the Enterprise Database
  • Special spreadsheets were made with Hypval functions for analysts to perform analysis
  • Assisted users in creating and saving Analyst queries
  • Coordinated monthly accounting close process managed administration of the Hyperion system (EssBase, Planning, HFM) infrastructure to ensure a stable, optimized financial planning and reporting environment
  • Created and Worked monthly financial FR reports
  • Responsible for any data reconcile issue in the reports during quarter close.

Analyst Programmer

Accenture Solutions
08.2010 - 08.2011
  • Performed project management duties as well as requirements analysis, planning, design, scheduling, status reports, development, and implementation Worked on Hyperion 9.3.1 to EPM 11.1.2.1 upgrade project and performed various iterative testing before go-live
  • Working as onshore ETL LEAD, Maintained /Altered the DIM workflows according to the business needs
  • Responsible for viewing and managing production integration jobs using ODI Operator
  • Worked on Flat file (Fixed and Delimited) as source and Oracle/EssBase Target for the DIM/ODI interface design
  • Unit and System Testing of all parts developed – Preparation of unit test cases, Integration test cases and analysis documents
  • Interacting with the Team on various forum to discuss the status, clarify any queries regarding the functionality etc
  • Trained, assisted and transferred knowledge to offshore/onshore resources
  • Altered some of the Event scripts with respect to the business need of markets/Accounts for FDM
  • Created and tuned various FDM scripts on addition with new products, UAT test scripts and Deployment related documentation
  • Implemented new architecture to reduce the down time of applications during and after monthly calculations and metadata changes.

Assistant System Engineer

Tata Consultancy Services Ltd.
06.2008 - 08.2010
  • Interact with business community/Clients and gathered requirements and incorporated identified factors into Informatica mappings Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations
  • Done Unit Testing of Mappings and used debugger for identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create mapplets that provides reusability in mappings
  • Creation of Informatica Workflows, sessions and Run that Sessions to load into Target Data Validation has been done for various sources to target mappings.

Education

Master of Engineering -

PSG College of Technology
TamilNadu, INDIA
01.2008

Bachelor of Engineering -

Maharaja Prithvi Engineering College
TamilNadu, INDIA
01.2006

Skills

  • FDQM
  • FDMEE
  • FCCS (Trained)
  • Hyperion Essbase 9x, 11x
  • Hyperion Financial Management (Certified)
  • Hyperion EPBCS (Trained)
  • ODI
  • Alteryx
  • Tableau
  • ROLAP
  • Oracle
  • SQL
  • PL/SQL
  • VB/ Macros
  • Unix
  • Windows
  • Team Leadership

Certification

  • Oracle Hyperion Financial Management 11 Certified Implementation Specialist.
  • Alteryx Designer Core Certification
  • Alteryx Foundational Micro-Credential

Alteryx designer Core Certification

Building Workflows · Data Blending · Data Cleaning · Data Preparation · Data Processing · Extract, Transform, Load (ETL) · Problem Solving · Data Analysis · Alteryx

Quote

There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins

Additional Certifications

  • FCCS Trained
  • Hyperion EPBCS Trained
  • Financial Consolidation and Close Explorer
  • Financial Accounting Foundations (LinkedIn Learning)
  • Agile Foundations (LinkedIn Learning)
  • Microsoft Power Apps Essential Training: The Basics (LinkedIn Learning)

Timeline

Manager-Finance ITS (Information Technology Services)

Zoetis Inc.
01.2016 - Current

Senior Associate Projects

Cognizant Technology Solutions
02.2015 - 01.2016

Team Lead- Analyst Programmer

Accenture Solutions
09.2014 - 01.2015

Senior Analyst Programmer

Accenture Solutions
09.2011 - 09.2014

Analyst Programmer

Accenture Solutions
08.2010 - 08.2011

Assistant System Engineer

Tata Consultancy Services Ltd.
06.2008 - 08.2010

Master of Engineering -

PSG College of Technology

Bachelor of Engineering -

Maharaja Prithvi Engineering College
DhineshKumar ThinakaranManager - Information Technology