SUMMARY

• Confidential Planning and Budgeting Cloud Services Specialist.(PBCS/EPBCS).
• Engage in process improvements and implementation of special projects, including evaluation of new tools or systems, related to the Financial Management function and within Confidential Enterprise management.
• EPM Practice Lead with in Confidential, responsible for 600K deliverables. Pre sales presentations and marketing. Scoping and planning client’s engagements. Provide technical / functional content.
• Design and development of financial budgeting and workforce planning applications. Setup Dimensions, web forms, smart list and writing calc scripts. Designing hierarchies, planning dimensions and custom dimensions as per user requirements.
• Excellent skill in Metadata management and designing Data Warehouse schemas specifically in Oracle Database 11g., Skills in Oracle 12c Database. Multitenant container and pluggable databases (CDB and PDB) data extraction.
• Confidential Planning cloud (PBCS) - Successfully implemented Planning application on Confidential cloud environment. Oracle Planning and Budgeting Cloud Services Specialist.(PBCS).
• Experience in relational databases. Experience in data mapping and transformations.BW warehouse experience. EXALOGIC administration.
• Essbase cubes Performance tuning and support FP&A group for on going reports.
• Data modeling skills (conceptual, logical, and physical) with transactional and dimensional modeling experience
• DRM - Design, development and implementation. Experience in ETL tools ( Informatica, Data stage).involved in configuration of Data Relationship Governance (DRG).
• FDMEE - Data integration with Essbase, planning and HFM applications. Custom scripts and data mart design for Confidential applications. OFSAA data model extract for Confidential applications.
• FDMEE validation rules and scripting development experience.
• Oracle EBS Data integration / Extraction, COA mapping for Master data management. UNIX shell, python and java scripting design and development for automation for job scheduling
• Oracle Exalytics In memory Hardware management. Expertise in writing UNIX shell scripts and Very strong SQL skills.
• Design and developed Data interfaces for FX trading and SESAC a Music industry platforms applications.
• Ability to learn very quickly and apply new skills to existing problems.

CURRENT EXPERIENCE:

Confidential

Managing Consultant

Responsibilities:

• Collaborate with the project team to ensure functional requirements appropriately incorporated.
• Lead the Technology to assist design workshops and implementation process. Drive the completion of project deliverables.
• Data relationship management - Metadata management for Essbase, Confidential planning and HFM
• Designed and developed data governance model in DRM for the users.Configuration and automating DRM process for Confidential applications.
• Migrating and upgrading Confidential HFM, Essbase and planning applications from 11.1.2.1 to 11.1.2.4
• PBCS/EPBCS - Confidential planning and budgeting cloud system applications design and implementation.
• Server as a technology lead person on the project, actively participate in requirements gathering and design sessions, representing company strategy.
• Define the business solutions and structures needed to realize new opportunities.
• Experience in performance tuning Essbase cubes and design and devlopemdnt of Calc scripts for Essbase Cubes.
• Design and implementation of EPM systems on UNIX and also on windows environment. Automation scripts design
• Data integration using FDMEE, open interface table design, account mapping and data validation rules for different locations configured and setup in FDMEE application.
• In FDMEE Using Python script import and export process developed and implemented.
• Data loading to HFM, planning and Essbase applications inbound and outbound interfaces implemented in FDMEE application. Custom script developed for import and export process.
• Design and developed star schema for Data stage ETL processing. Converted OLAP dimensions into relation model for COGNOS reporting needs.
• Experience in Oracle Exalytics Hardware management. Expertise in writing UNIX shell scripts and Very strong SQL skills
• Confidential HFM, Essbase and planning applications support and administration.

Confidential

Project manager

Responsibilities:

• Led at least 8 full-cycle Confidential Planning implementations at Fortune 500 and Bio pharmaceutical companies. Designed and architected Confidential Planning with a primary focus on revenue planning, SG&A, capital expenditure, Project accounting and workforce planning.
• Served as a PM and designed and developed many planning, budgeting and forecasting solutions leveraging Confidential Planning. Main project deliverables include Income Statements, Balance Sheets, Capital Management and Workforce Analytics.
• Multiple PBCS cloud implantations on AWS platform for Pharmaceutical industries.
• Extracted data from ERP systems. Metadata design for Confidential Planning in DRM.
• Created properties and property categories that match the naming conventions of target systems. Created hierarchies in DRM.
• Confidential administration, backup and recovery and user security implementations.
• Automated the data in and out of DRM through windows scripting. Oracle PBCS on AWS cloud platform
• Design and developed Forecast and budget Confidential planning application in PBCS Confidential planning cloud V 11.1.2.3. Environment.
• FDMEE setup in PBCS cloud. Implemented drill through setup. OBIEE and Essbase integration, design of OLAP reports in OBIEE environment
• EBS Data integration, extraction and mapping to Confidential planning finance and project cubes. Design Actual load interfaces. COA mappings for master data management.

Confidential

Data Integration lead

Responsibilities:

• Design and developed Forecast and budget Confidential planning application V 11.1.2.1. Written custom load scripts, business rules and data entry forms in forecast planning application.
• Gathered the requirements for integration of DRM with each downstream system. Created properties that support the feed in to DRM and in to target application.
• Implemented DRG. Involved in configuration of Data Relationship Governance (DRG). Trained users across Data Relationship governance (DRG) and its uses.
• FDMEE integration with HFM and planning applications. Account mappings and other data validation rules developed. Import and export using FDMEE application. Automation process designed and implemented using Unix/Dos shell scripts.
• Responsible for solution designs and Data integration using ODI/FDM applications. FDM Adopter configuration for Essbase / planning application. Drill back setup for planning application. Custom load scripts written for data loads. Auto restarts Shell scripts for EPMA applications.
• Configured FDM adopters for Essbase application. Implemented drill through setup. Designed custom scripts in FDM application.

Data Integration Lead

Confidential

Responsibilities:

• FDMEE/FDM application experience, HFM and planning application configured and import and export process developed. Adopter and open interface table design in FDM/FDMEE
• Experience includes the design and implementation of applications for workforce planning, budgeting and financial analysis where Oracle Confidential System 9 / 111.1.2.1/11.1.2.2 BI+ Essbase Analytics skills were used extensively to build multidimensional cubes. Smart View and Excel Add-on experience includes building financial reports to assist in required financial reporting.
• Responsible for solution designs and has managed and implemented custom client Oracle Confidential System 9 / 11 Planning application solutions in various industries’. Extensive experience with the design and implementation of Oracle Confidential System 9 / 11 Planning solutions specific to Retail, Financial and Higher Education Contractors.
• Workforce planning / Confidential Public Sector Planning V 11.1.2.1 design, development and implementation. Confidential application migration from Test, QA and production servers using Confidential LCM tool.
• Experience also includes the Data Integration Design and implementation using Oracle data integrator application (ODI) and financial data Quality Management (FDM) v 11.1.2.1.

Confidential

Responsibilities:

• Gathering of functional specification for Workforce planning application and formulation of a solution for the clients requirements.
• Manage and coordinate with the Finance Team to enhance the knowledge and usage of current financial systems as part of continuous effort to gain efficiency and effectiveness in financial analysis and especially Budgeting and forecast models.
• Designed proposal development and demos for Workforce planning applications. (Version 11.1.1.3/11.1.2. )
• Design and developed Workforce planning application. Implemented budget and forecast models as per user requirements
• Managed the Region and department Employee transfers, share employee between the departments and designed offshore / smart shore workforce budgeting model using business rules and data forms.
• Business process redevelopment revolving around the new automated data load process and implementing security filters on all planning dimensions and also in Essbase applications.
• Trouble shooting and performance tuning Essbase cubes and planning applications, Writing Calc, load rules, Reports and business Rules.
• Designed various forms for budgeting and forecasting models.
• Supported current P&L Essbase cubes and Reporting ASO Cube. Modified MDX formulas as per user needs

Confidential

Senior Consultant

Responsibilities:

• Installation and integration of EPM 11.1.1.3 applications.
• Responsible for implementing a process containing assessment, environment hardware sizing, Capacity planning, installation and rollout. Setting up high availability Failover server configuration.
• Gathering requirements from business customers and translating into IT solutions.
• Configure Essbase, HFM and planning applications, integration and migration of 9.3.1 applications into EPM 11.1.1.3 version.
• Responsible for setting SSL on all Confidential System 11.1.1. 3 environments. Installation and integration of Oracle Data Integration module (ODI) V 10.1.3.5 reverse engineered Essbase metadata into planning application. Using ODI created data load interfaces.
• Integration and configuration of Data relation management (DRM) module in EPM 11.1.1.3 environment.
• Gathering requirements from business customers and translating into IT solutions and leading a group in the development of these solutions, Solid troubleshooting ability
• Developed a maintenance strategy including daily and weekly backup, disaster recovery, log rotation, system health monitoring, and helpdesk integration.

Confidential

Senior Technical Consultant

Responsibilities:

• Confidential performance suite 9.3.1 production support and on going development On Enterprise Applications.
• Developed backup and Defrag scripts, trouble shooting Essbase log files and performance settings tuning in Essbase CFG file parameters.
• Import and Export of planning application across Prod, QA and development. Creating new planning application loading scripts to load data from HFM/FDM/MDM and maintaining custom scripts to load GL Actual data from legacy systems.
• Assist with business process redevelopment revolving around the new automated data load process and implemented security filters on all planning dimensions and also in Essbase application.
• Supported day to day activities for Allocations, Income statement and balance sheet applications in ESSBASE 9.3.1
• Experience with Essbase automated dimension builds, creating batch scripts and processing scripts, Experience with ESSCMD and MAXL command language for batch processing. Design and developed Smart view reports for users.
• Migrated Essbase and planning applications from production to QA to Development for testing complicated processes to debug / trouble shooting real time problems in a day to day activity.
• Skilled at gathering requirements from business customers and translating into IT solutions and leading a group in the development of these solutions, Solid troubleshooting ability

Confidential

Senior Technical Consultant

Responsibilities:

• Created a project timeline to redesign a Confidential Enterprise Application
• Redesign a corporate Confidential Enterprise application utilizing an automated data load process from Lawson ERP database.
• Assist with business process redevelopment revolving around the new automated data load process
• Developed multiple organizational structures in Confidential Enterprise to meet the management and legal reporting requirements
• Created new chart of accounts and corresponding formulas to allow for account subtotals and balance sheet roll-forward information
• Maintained Workforce and CapEx planning applications, and also managed forms and financial reports for workforce planning application. Implemented Head count functionality in workforce planning application
• Design and development of Web Analysis, Financial Reports for planning and Essbase applications.
• Design and maintenance of ASO cube outline and member formulas. Assisting with development of divisional KPI reporting cubes .Providing support to end-users for Reporting Template design. Maintaining system and end-user documentation

Senior Technical Consultant

Confidential

Responsibilities:

• Designed and developed Five year Plan Budget database in SQL Server. Created Analytical database in SQL server as a Cube model. Using Data warehouse techniques.(Star schema model)
• As a SQL Server DBA maintained date for the hospital device management, migrated data from Maximo database into Five year plan database. Designed custom interface using SQR language. Also deigned a web based Plan application using Microsoft .NET software
• Design and development of Confidential Brio reports on SQP BW database. Involved in migrating brio version 6 to 8.5
• Migration of BI reports to Business objects from Confidential system.
• Identify suitable dimensions and facts for star schema. Written complex stored procedures and triggers to improve the performance. Involved in performance and tuning for ETL Packages. Extensively worked on the stored procedures, Functions. Written Shell scripts for event automation. Maintained and supported GL, AP, Profit & Loss and Budgets operating reports

Confidential

Technical Manager

Responsibilities:

• 14 Years of experience in C3I systems endogenously designed, developed and integrated with static and mobile radars for air defense.
• Designed and developed Tracking filter (Alfa, beta tracking) algorithms for RDP (Radar data processing).
• Experience in developing custom interfaces for embedded systems.
• Experience in mission critical applications support, mission systems integration, information assurance / information operations, and intelligence systems