Mandar Joshi

Cupertino, CA 408-***-**** acxi9k@r.postjobfree.com LinkedIn: Mandar Joshi

Senior Developer, Enterprise Performance Management

Accomplished Essbase Architect with 15+ years of demonstrated experience in the Internet, financial services, and IT services industries. Proven success in building and managing enterprise financial applications for Global Fortune 500 companies. Adept at translating business intelligence and performance management requirements into manageable data formats for complex, multi-faceted projects.

Exceptional combination of business and technical acumen tuned for interacting effectively with cross-functional teams of business analysts, developers, programmers, key stakeholders, and senior managers to identify and drive streamlined execution of all aspects of enterprise-wide process improvement initiatives. Leveraging deep knowledge of multi-dimensional databases, including Hyperion, Essbase and Oracle Express Server.

Technical Summary: Hyperion Essbase, MAXL, MDX, Smart View, SQL, UNIX Shell Scripts; Planning, HFM, Oracle Express Server, Oracle Financial Analyzer 11i, Oracle Sales Analyzer 11i, Oracle Express SPL, UC4, SAP BPC, Longview, Tableau

PROFESSIONAL EXPERIENCE

PAYPAL INC., San Jose, CA May 2008 July 2016

MTS 1 BI Developer (Oct 2011 Jul 2016)

Assistant Project Manager Cognizant Technology Solutions (May 2008 Oct 2011)

Played key role as a part of Data Technology and Finance Transformation Organization. Worked directly with cross-functional teams on various projects pertaining to planning, forecasting, and business analytics. Instrumental in implementing the Essbase for the Finance and FP&A teams and successfully completed major deliverables.

•Built Segment P&L cube to consolidate the actuals, forecast, and budget data by regions and payment flows and provided management PL for entire PayPal. Developed enhancements and maintenance for the Segment PL cube to accommodate growing business of PayPal and the business challenges of integrating the various acquisitions data into PayPal systems.

•Designed and built BU Specific Essbase cubes for high visibility business units and key PayPal acquisitions to track progress of key initiatives at a granular level while conforming to the requirements of the Global FP&A team.

•Worked with Micro Strategy team to build a cube (Weekly Executive Dashboard) that provides PayPal senior executives with weekly data about customers, merchants, and other vital financial metrics.

•Delivered daily dashboard with forecast variance and reported results to PayPal executives including the CEO and CFO; showed daily/weekly/quarterly view of key financial metrics. Report provided pulse of the business at a glance.

•Built regulatory reporting cubes to deliver a daily report to Luxembourg for its banking governance authority.

•Migrated PayPal Essbase environment to better hardware without impacting the business continuity.

•Automated backups and built scripts to maintain system backups on weekly basis.

•Metadata Management and Outline maintenance.

Environment: Hyperion Essbase Version 11.1.24, 9.3.1, Solaris, MS Office Suite, UC4, Teradata, SQL, VBA

COGNIZANT TECH SOLUTIONS, Jersey City, NJ; Columbus OH; Racine WI Jun 2002 Sep 2011

Developer, Offshore Team Lead, and Onsite Coordinator

Worked on large scale implementations for multi-site clients such as PayPal in San Jose CA, JPMorgan Chase in New Jersey and Columbus OH. CNH Capital in Racine WI. Analyzed, designed, developed, and deployed key enterprise applications for data integration.

JPMORGANCHASE, Columbus OH Jul 2006 Dec 2007

Hyperion Essbase Developer

Provided technical project support to leverage Hyperion Essbase in storing, generating, analyzing, and reporting the plan and forecast data. EP is the “official book of records” for Plan and Forecast data for JPMorgan Chase.

Continued…

Mandar Joshi 408-***-**** acxi9k@r.postjobfree.com Page 2/2

•Worked closely with business users to understand requirements, manage monthly production calendar, and coordinate testing activities.

•Enhanced, realigned, and automated procedures for transferring data to external applications such as CMR, P&F.

•Instituted the automatic partitioning between different applications and eliminated the need of manual data handling during cross LOB ORG movement. Replaced the phased out components with a new replacement process.

•Streamlined unification of code databases, eliminating the need to maintain multiple copies of the same script.

•Successfully handled standardization of Calc Scripts and Unix Wrappers.

Environment: Essbase Version 7.1, IBM AIX, MS Office Suite

JPMORGAN CHASE, Jersey City, NJ May 2006 Jul 2006

OFA Developer / PRF Security Remediation

•Designed a new solution for Heritage JPMC due to the PRF application decommissioning. Created an alternate method of storing application access security and supporting all user access to applications such as DPS, P&F, without affecting the existing user experience. Charged with analyzing the current module and understanding requirements.

•Co-ordinate with different teams involved in the project such as Network Admins, Citrix Server Engineers, DBA Users.

•Handled follow up on testing and sign-off from users

Environment: Oracle Financial Analyzer 11i, Oracle Sales Analyzer, Oracle Express Server, MS DOS Batch, Citrix, Windows

JPMORGAN CHASE, Jersey City, NJ Jun 2003 May 2006

Onsite Coordinator / Plan and Forecast

•Assigned to support JPMC in leveraging the Oracle Financial Analyzer to generate, analyze, and report the Plan and Forecast data. Provided BAU support for monthly realignment process, submissions process, and data exchanges between other applications such as SAP-CO, CMR

•Analyzed and resolved problems faced during the production cycle and ensured databases were optimized, by regularly performing maintenance routines, upgrade the software. Managed the express instances, backups.

•Ensured new enhancement requests were attended to by following all the standardized procedures and quality assurance best practices for testing, code review, and collating documentation.

•Worked with multiple clients and users to clarify requirements, and co-ordinate testing and activities related to monthly production cycle. Trained and shared knowledge with onsite/offshore resources.

Environment: Oracle Financial Analyzer 11i, Oracle Sales Analyzer, UNIX, Citrix

OFA Developer / Onsite Coordinator Profitability Reporting Facility Jun 2003 May 2006

•Provided technical support for Profitability Reporting Facility (PRF) application that is used to generate MIS results for Heritage JPMorgan. PRF was a collection of applications that catered to reporting requirements of Actuals, Plan and Forecast data.

•Supported the monthly realignment process, submissions process, and data exchanges between other applications such as SAP-CO, P&F, CMR. Ensured actuals were efficiently reported using Oracle Sales Analyzer while plan and forecast data was reported using Oracle Financial Analyzer applications.

•Worked with clients and users to understand the requirements and co-ordinate testing and activities related to monthly production cycles. Ensured databases were optimized by regularly performing maintenance routines and upgrading software. Managed the express instances, backups.

Environment: Oracle Financial Analyzer 11i, Oracle Sales Analyzer, Unix, Citrix

CNH CAPITAL, Racine, WI Jun 2002 May 2003

Project Lead / Onsite Coordinator

•The Internal Reporting System catered to their PL & BS reporting requirements. Major functionalities handled by this application were Actuals, Forecast, Budgets reporting and Analysis, Currency conversion for various entities across the globe, SGA Overloads Allocation and Inter-company Elimination

Environment: Oracle Financial Analyzer 11i, Oracle Sales Analyzer, Unix

Previous Positions Held:

ITTI PVT. LTD., India, Senior Systems Engineer Dec 1998 May 2002

Contact this candidate