Hi, I’m
Ajay Kumar Ponnapalli
Irving,TX
Summary
Applications like Total 12+ years of Professional Experience Out of which 10+ years of IT Professional Experience in Business Intelligence OneStream, Oracle Financial Consolidation and Close Cloud Service (FCCS), Hyperion Financial Management (HFM), Account Reconciliation Cloud Service (ARCS), Profitability Cost Management Cloud Service (PCMCS), Data Relationship Management (DRM), Hyperion Financial Reporting (HFR) and Financial Data Quality Management, Enterprise Edition (FDMEE), Knowledge on Essbase & Planning.
Certified ARCS, FCCS, and Level 2 certification in Anaplan.
Overview
13
years of professional experience
1
Certification
Work History
Genpact India
Lead Hyperion Consultant
12.2017 - 07.2023
Job overview
- Worked with 5 leading clients at their space.
- Evaluated current processes to develop improvement plans.
- Produced detailed and relevant reports for use in making business decisions.
- Gathered, documented, and modeled data to assess business trends.
- Reviewed internal systems and organized training plans to address areas in need of improvement.
- Conducted thorough reviews of operations to devise and deploy improvement strategies.
- Restructured procedures through coordination with compliance director to create and execute projects.
- Skilled at working independently and collaboratively in a team environment.
- Proven ability to learn quickly and adapt to new situations.
- Passionate about learning and committed to continual improvement.
Deloitte
Senior Hyperion Developer
01.2017 - 11.2017
Job overview
- Created and maintained database containing information on business proposals and contacts.
- Reached out to potential customers via teams, email, and in-person inquiries.
- Pitched ideas for business development to executive team and gave in-depth presentations to clients using effective public speaking skills.
- Maintained high level of integrity by keeping sensitive client data and corporate information confidential.
- Involved in Creating and processing journals and adjust data using journals.
- Worked on MEC process.
- Created the task flows in HFM and linking between them and scheduling consolidations
- Prepared data forms and setting up validations in forms in HFM
- Responsible towards project—giving response to client immediately
- Assigned no input to cells in data forms in HFM.
- I have updated rule so that beginning and ending cash includes two restricted cash accounts
- Responsible for Kick out mails and responding to them.
- Setting up calls with clients and internal members when every necessary.
- Worked on Metadata updates, build up hierarchy in HFM.
- Worked on planning plan types, and supported in planning activities.
- Dealing with form builders in planning.
- Involved with planning budgeting application to add dimensions, assigning member properties.
- Worked on variance reporting procedures, time balancing.
- Worked on currency dimension properties.
- Overall metadata build and refreshing data.
- Preparing Duplicate Data forms in planning by taking reference of another.
- Worked on Essbase activities like data loads from data files and SQL, taking data backups clear data before loads in test environment.
- Editing load rule files in Essbase and editing scripts.
- Preparing WSR's, MSR's and update status reviews.
- Preparing PPTS on COE Connects.
- Dealing with artifacts and giving access to users.
- Ignoring inactive entities to HFM from FDM
- Update UDI fields in planning to identify easily from which source member is being loaded.
- Resolved mapping Issues in FDM.
- Supporting for the other projects in building scripts through VBA and advanced Excel.
S&P Global Market Intelligence
Hyperion Developer
05.2012 - 01.2017
Job overview
- Tested programs and databases to identify issues and make necessary modifications.
- Designed, developed, and implemented software applications for website based on analyzed requirements and understanding of industry technical standards.
- Discussed issues with team members to provide resolution and apply best practices.
- Translated customer requirements into written use cases.
- Collaborated on stages of systems development lifecycle from requirement gathering to production releases.
- Participated in software field testing to verify performance of developed projects.
- Documented technical workflows and knowledge to educate newly hired employees.
- Designed intuitive graphical user interfaces to improve user experience.
Shore Infotech
Senior Financial Analyst
06.2011 - 05.2012
Job overview
- Trained new analysts on corporate policies and procedures and implemented mentoring program, reducing onboarding time.
- Developed presentations and reports to inform and educate stakeholders and financial teams on growth possibilities.
- Provided strategic planning advice and financial oversight for corporate stakeholders.
- Tackled both annual and quarterly budget management tasks and developed financial models from benchmarking.
- Reviewed statistical information to determine financial trends for use in investment planning.
- Developed corporate investment strategies to drive growth and security.
- Conducted detailed financial analysis to identify and evaluate changes in operations, trends and potential areas of improvement.
- Collected data from other divisions to support quarterly forecasts.
- Developed forecasting tools to analyze revenue variances and capitalize on industry trends.
- Developed and implemented financial models to analyze complex information and assess health of organization.
- Reviewed financial reports and streamlined operations to increase productivity and company profits.
- Evaluated financial performance of investments, acquisitions and other business opportunities to provide strategic recommendations.
- Performed complex financial and budget analyses to determine requirements and justify requested funding.
FactSet
Junior Financial Analyst
10.2010 - 05.2011
Job overview
- Collected data and developed detailed spreadsheets to identify trends and create revenue, profitability, and expense forecasts.
- Conducted detailed financial analysis to identify and evaluate changes in operations, trends and potential areas of improvement.
- Used relevant financial technology to generate reports and recommended courses of action to upper management.
- Performed complex financial and budget analyses to determine requirements and justify requested funding.
- Reviewed financial reports and streamlined operations to increase productivity and company profits.
- Collected data from other divisions to support quarterly forecasts.
- Developed and implemented financial models to analyze complex information and assess health of organization.
- Evaluated financial performance of investments, acquisitions and other business opportunities to provide strategic recommendations.
- Collection of Financial data into voyager tool.
- Making necessary adjustment as per footers available.
- Completing targeted files per day with accurately and effectively.
- Attended training for Income statement and Balance sheet collection points.
- Worked on advanced excel for validation of data.
- Prepared VBA macro's as per requirement
- Worked on Def14A, 10K reports to fetch financial data.
- Analysis on financial statements like Balance sheet, Profit and loss accounts, and cash flow statement.
- Analysis of financial ratios and providing user cases solutions to take decisions for Management.
Education
Nagarjuna UniversityGuntur, India
MBA from Finance
08.2010
Pune UniversityNashik, India
Bachelor of Arts from Costing
06.2007
Skills
EPM Products
On-Prem
- Hyperion Financial Management
- Hyperion Essbase and Planning
- DRM, FDMEE, HFR and Smart-View
Cloud Services
- FCCS, ARCS, PCMCS
- Data Management/Data Integration
CPM Products
- Onestream
Languages
- SQL, Python, Groovy, C#
Certification
ARCS
FCCS
Anaplan Level1 and Level2
Languages
SQ
Timeline
Lead Hyperion Consultant
Genpact India
12.2017 - 07.2023
Senior Hyperion Developer
Deloitte
01.2017 - 11.2017
Hyperion Developer
S&P Global Market Intelligence
05.2012 - 01.2017
Senior Financial Analyst
Shore Infotech
06.2011 - 05.2012
Junior Financial Analyst
FactSet
10.2010 - 05.2011
Nagarjuna University
MBA from Finance
Pune University
Bachelor of Arts from Costing
Similar Profiles
SAGAR NAIRSAGAR NAIR
Management Trainee at Genpact IndiaManagement Trainee at Genpact India
Pallavi BhasinPallavi Bhasin
Master Black Belt/ Process Excellence Consultant at Genpact IndiaMaster Black Belt/ Process Excellence Consultant at Genpact India
Aashish DubeyAashish Dubey
Sr Manager (Tower Lead)– O2C – Pharma Industry at Genpact IndiaSr Manager (Tower Lead)– O2C – Pharma Industry at Genpact India
Ankit BhatiaAnkit Bhatia
<ul><li>Led architecture design and RFP solutioning for multimillion-dollar transformation programs on OCI, AWS, and Azure.</li><li>Delivered scalable, cloud-native solutions for modernization, integration, and automation across global clients.</li><li>Partnered with Sales, Product, and GTM teams to create compelling proposals and increase deal win rates.</li><li>Conducted C-suite workshops to define transformation roadmaps and align cloud strategy with business outcomes.</li><li>Designed AI/ML-enabled automation frameworks that improved process efficiency by 30%.</li><li>Supported deals in areas like mainframe migration, platform reengineering, and QA services.</li></ul> at Genpact India<ul><li>Led architecture design and RFP solutioning for multimillion-dollar transformation programs on OCI, AWS, and Azure.</li><li>Delivered scalable, cloud-native solutions for modernization, integration, and automation across global clients.</li><li>Partnered with Sales, Product, and GTM teams to create compelling proposals and increase deal win rates.</li><li>Conducted C-suite workshops to define transformation roadmaps and align cloud strategy with business outcomes.</li><li>Designed AI/ML-enabled automation frameworks that improved process efficiency by 30%.</li><li>Supported deals in areas like mainframe migration, platform reengineering, and QA services.</li></ul> at Genpact India
Kevin Ricardo Freire OrtizKevin Ricardo Freire Ortiz
Clerk – Procurement at Hotel VINClerk – Procurement at Hotel VIN