Principal Consultant
Wipro Arabia
Total years of experience :18 years, 11 months
ROLES & RESPONSIBILITIES
• Project planning and Execution along with Scope elaboration and effort estimation
• Resource mobilization, staffing & deployment with training & Performance review
• Implementation & Development of Planning & Budgeting Systems
• Requirement Gathering & Designing solutions and Documentation
• Ensure Project plans and Goals are documented & achieved as per timelines within the
stipulated scope and budget
• Ensure Technical feasibility and Architectural & Design compliance with the requirements
• Define and document project scope & objectives and develop a detailed plan to monitor
and track the progress of the project
• Daily status meetings with the team & clients on ticket status and SLA adherence
• Manage stakeholder expectations, Coordinate both internally and externally for the
flawless execution of project
• Work on creating PreSales proposals, RFPs & Presentations and liase with the PreSales &
Sales teams
Noteworthy Credits:
•Handled teams on production support and CRs & enhancements during budget & forecast cycles
•Rolled out Hyperion Planning to EMEA OpCos in a SPOC role to the satisfaction of the client
Noteworthy Credits:
•Automated the defragmentation process to avoid manual errors and simplified the process
•Efficiently handled the Budget cycle to the satisfaction of the finance users
Implement automation of data extraction and load process and facilitate defragmentation process
•Enhancement of Hyperion planning and Essbase applications for more system availability
•Perform metadata and data cleanup and resolve user issues
•
Administration & Enhancement of Hyperion planning and Essbase for budgeting and reporting
•Handle business meetings with the Finance leads and Corporate
•Resolve user issues in a timely manner and prioritize the issue register
•
Noteworthy Credits:
•Successfully managed the Hyperion planning and Essbase applications for forecasting, budgeting and reporting
•Efficiently developed reports in Hyperion Financial Reporting resulting in reducing 20 man days of work per quarter to a single click
•Coordinated with the Technical team for performing enhancements in Assurenet applications and providing the Accounts Payable extract
•Succeeded in reducing the number of tickets by 50% by avoiding proper documentation of repetitive issues & reducing the downtime by 25% by recommending / implementing process improvements
Key Deliverables:
•Accountable for administration of Hyperion planning and Essbase applications for forecasting, budgeting and reporting
•Chair all business meetings with the forecast & budget leads and other onsite functional teams
•Set up Exchange rates for all applications on a monthly basis as per Treasury file
•Create forecast & budget business rules & Webforms on an ad hoc basis
•Maintain Assurenet application to reconcile between Oracle Financial applications GL & SL balances
•Deploy and support multi-site highly scalable solution implementation for high availability and capacity
•Provide security access to APAC users and clear technical issues; handle user requests through Siebel analytics on security accesses, data issues, budget & forecast analysis and submission of data for APAC region |
•Support Assurenet users in security set up and reconciliation process of balancing between GL and AR, AP, FA & SL and co-ordinate with the Technical / Development team in creating and testing the procedures
Hexaware (For client - IMS Health care, USA):
#1: PBF Support & Administration
Noteworthy Credits:
•Successfully developed and delivered the new Hyperion Planning classic & EPMA applications for forecasting & budgeting for 4 consecutive years
•Successfully automated and improved the process resulting in reduced scope of manual errors and data loss
•Successfully created and designed the new Essbase cubes using Analytic Integration services
Involved in implementation & administration of Hyperion planning classic & EPMA applications in forecasting & budgeting applications; performed Masterdata & data refreshes and forecast & budget submissions
•Created, maintained and approved PBF & FIQ calendars based on corporate schedules
•Performed budget transfers and BLP (Business Line Profitability) processes during the budget cycle
•Prepared and maintained MS Project plan to track progress of projects and update clients on status of the same
•Involved in Budget & Forecast analysis and submission of data for around 54 countries; created EPM applications for forecast & budget and business rules & Webforms in every cycle
•Responsible for administration of Hyperion planning in forecasting & budgeting applications; performed Masterdata & data refreshes and forecast & budget submissions
•Tracked user requests through QMS and resolved tickets ensuring highest level of user satisfaction
Key Deliverables:
•Designed the cube in Essbase services, created the cube using Rule Files for Member Load and Data Load; refreshed the cube on a monthly basis for latest EMEA data
•Developed reports using Hyperion Financial Reporting
Same as in key deliverables of HP Global Soft
•Dealt with WITS issues and resolved them on a daily basis
•Generated reports in sync with the Production parameters
#2: 445 (Jan’06 - Jul’07)
Key Deliverables:
•Created, modified and published Brio queries in Custom SQL of reports & cubes; analyzed all cubes and reports to see effect of 445 calendar
•Handled WITS issues and resolved them on a daily basis
•Provided access to users to view various reports and Scheduled Jobs
Noteworthy Credits:
•Involved in analyzing and optimizing cubes’ performance post account hierarchy changes and interactive reports to monitor effect of new organizational changes
•Developed reports using Hyperion Financial Reporting and optimize reports for better performance & user friendliness; granted access to users on various reports and schedules jobs
Key Deliverables:
•Analyzed performance of cubes post account hierarchy changes and all dimensions & members in Essbase outline
•Studied the financial statements and data validation; resolved tickets raised by users
•Prepared Load rules and data load files and performed data refreshes
•Generated reports using Excel Spreadsheets
General Management programme for IT Executives
MBA Finance
MA Economics
BCom Computer Applications
