SUMMARY:

• Over 22 Years of experience in Project Management in Financial Budgeting HRMS Systems
• Oracle EPM Cloud solutions for Planning modules (EPBC)Concept Design PCMCS CDM
• Azure Cloud Compute and Azure Storage Explorer connected to Oracle Cloud
• Worked on Azure Portal to monitor and manage Azure Objects
• Implementation of Resource Group to Maintain Cost Center Metering for resource usage
• Oracle EPM Cloud Administration including Pods/User/Dimension Creation / Management .
• Run Master Setup, Fact and Dimension for Warehouse and GL Profitability AP AR Datamart
• Ability to design and maintain databases using Peoplesoft Logical model, implementing the DDL, tuning Peoplecode, SQR’s, Stored Procedures, Rule based cost based optimizer hints
• PCMCS Allocation Rule, Rule Balance using Smartview
• PSQuery, nVision, Crystal Reports, VBA excel for nVision for income statement, Bal Sheet
• Hands on experience in setting HDFS distributed nodes, installing HBase columnar DB
• Design, Development and Implementation of Peoplesoft 9, Including Hardware Selection and Database and Peoplesoft Internet Architecture. (PIA)

SKILLS:

Oracle Azure AWS: Oracle EPM Cloud EBPCS / MS Azure Compute and Storage /AWS E2

ERP Architecture: PeopleSoft 9.1,9.0,8.8 Financials & SCM,HRMS, Peoplecode, SQR

BI: Hyperion Planning, Essbase, Ascential Datastage, Business Object Universe OBIEE, Analytics, Interactive Dashboard,Erwin Data Modeling tool

Communication: Provide Program status to Steering committee, C Level executive, Execute program from thought to tactical implementationAligning strategy to organizational goals

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Peoplesoft Financials, Oracle EPM

Finance Data Architect

Responsibilities:

• Review of Peoplesoft Financial system integration to Oracle in the cloud
• Liaison between Financial Planning / Corporate Finance and Onsite/Offshore IT
• Analyzed Business Rules and Allocation Logic related to spreading the allocation pool by cost center and different client company.
• Allocation Rule and generation of Fully Allocated Client Company P&L
• Establish Cloud environment for Oracle EPM modules EPBCS/PCMCS/EPRCS modules
• Performing Data Load into EPBCS and PCMCS using CDM tools
• Configured Smartview installation for all Planning activities
• Maintained and Created forms and workflow for the Planning Cubes
• Initialized EPM application for Finance / Workforce Planning / Insurance /Project Costing / Asset
• Designed and developed Dimension Management techniques between Peoplesoft and Oracle
• Performed Ledger Dataload between Peoplesoft and EPM PLN Cube
• Reviewed End to End Business Process of HSB Peoplesoft Accounts Payable
• Created Pivot Grid / Fluid Pages / Workcenter an Dashboards in Peoplesoft
• Created Azure VM s, Storage Service to integrate with Oracle EPM
• Advanced proficiency in Angular 8 and Single Page UI design.
• Advanced proficiency in Bootstrap and Typescript Libraries used in Angular
• Advanced proficiency in HTML and CSS.
• Professional experience with Git / Java /Hibernate ORM
• Peoplesoft PUM image and Upgrade experience
• Converted Oracle to Postgres SQL server using Ora2pg tool
• Enterprise Performance Management

Environment: Peoplesoft Financials, Hyperion EPM,ODI, DRM, DRG

Finance Data Architect

Confidential

Responsibilities:

• Evaluation of the As - Is Architecture of the Hyperion Planning and Peoplesoft Financial system
• Liaison between Confidential Customers / Implementers / and Fund Allocation Team
• Analyzed Business Rules and Allocation Logic related to spreading the allocation pool by cost center and different funds.
• 5.3 Trillion dollars asset under management and 50 billion dollars of annual expense allocation
• Use Erwin All fusion to define system requirements and communicate with team members
• Use Erwin All Fusion to maintain referential integrity and key structures
• Export DDL and Platform specific SQL code from Erwin
• Model Relational and Dimensional models using Erwin and keep the dimension data aligned to fact table
• Manage on-site and off-shore teams using Agile, Scrum structure for solution delivery
• Prepare Vanguard Management SLA /SLO / Program dashboards for monthly/quarterly /yearly reports
• Provide Cost Center Allocation for Fund Expense ratio using Oracle Cloud/PCMCS and Hyperion

Confidential, Ohio

Environment: Accenture ABMS, HP MITS, Teradata, HP HAVEN

Solution Architect

Responsibilities:

• Solution Lead for Replication of Eligibility (Accenture IE) and Claim system (HP MITS)
• Liaison between Confidential Customers / Implementers / and Tech Vendors / 88 Counties
• Investigate and Design important IE transaction and Map them to Functional Specification
• Created Managed care capitation reports for $18 Billion annual spend
• Various Data cleanse logic for inter agency feeds Department of Health, Aging, Insurance
• Facilitate Replication of 7 TB of Data from Orlando Data Center and Confidential Data Center
• Detailed review and Debugging of Oracle Active Dataguard software, Cognos, Informatica, SAS
• In Depth process and data analysis of Claims and Eligibility Transaction
• Setup Reporting Strategy for Member Month Data Mart
• Design New Data Marts for Budget Financials for 24 Billion Dollar Ohio Department of Medicaid
• Provide weekly update to Agency and Statewide C - Level executives, including

Confidential

Environment: PeopleSoft Financial, HRMS 9.1 on Oracle 9i & 10g

Project Architect

Responsibilities:

• Functional Lead for Peoplesoft Reporting for HCM and Finance Statewide all agencies
• Liaison between 140 State Agency HCM and Finance Administrators and OAKS
• Setup OWS (Staging),OWE(Enriched),MDW( multi - Dimensional) for Peoplesoft FSCM/HCM source
• Maintain Project Plan, Resource Plan and Communication for significant workstream
• Facilitate Organization Change Management State wide for Confidential
• Setup OBIEE KPI and Dashboard using Cognos Framework Manager and Report Studio
• Detailed review of migration process from Legacy to BI for disparate agencies
• In Depth process and data analysis of GAAP and Commitment Control Accounting Ledgers
• Setup Reporting Strategy for Peoplesoft Workforce Planning and Compensation Data Warehouse
• Design New Data Marts for Peoplesoft ePerformance and Peopleosoft ELM
• Provide weekly update to Agency and Statewide C-Level executives,

Confidential

Environment: PeopleSoft Financial, HRMS 9.1 on Oracle 9i & 10g

Project Implementer Peoplesoft 9.1 Financial Transformation

Responsibilities:

• Functional Lead for Peoplesoft Financial Asset Management. Process Lead for Financial conversion strategy for COA Ledger and Journal balances, AP, AM Consolidation and Equitization.
• Process flow definition using Confidential proprietary Industry Print Tool.
• Design and Implementation of Multiple Mapping Rules and Source Target data set.
• Review Ledger Set, Vendor Processing, AM GAAP and Tax books, Multi Currency
• Validate test script and review with stakeholders in international setting, HCC Europe and US
• Perform issue mitigation in Unit testing, Integration testing and User Acceptance / test cycles.
• Document for turnkey knowledge transfer of Peoplesoft 9.1
• Developed strategies for multi currency conversion .
• Consolidation Tree’s, Elimination BU’s

Confidential, Burlington, MA

Environment: PeopleSoft Financial, SCM & HRMS 9.0 & 8.8 on Oracle 9i & 10g

Project Implementer

Responsibilities:

• Developed upgrade strategy to upgrade tools release 8.48 to 8.49 and application release 8.8 to 9.0.
• Participated in design discussions to support project and baseline for merging vanilla customizations.
• Identify and migrate customizations from a Holding project within upgrade path
• Perform pre and post upgrade functional and technical review. Add tuning indexes for the PO screen
• Configure document association rules and Rules processor for the AP Matching in 9.0
• Perform issue mitigation in Unit testing, Integration testing and User Acceptance / Post production.
• Create Citizens bank interface for automating Paycycle eft process, Used Expect shell script
• Moved Custom Objects Queries/ Trees/ SQL/Setup table from Source to target using DMS scripts
• Performed Asset Management interface with AP / PO using Receiver 1,2,3 impact
• Initialized the AM to AP interface in PS9 system. Added New required field Asset Type to Profiles
• Migrated User profile from old to new user id to enable SSO using Active directory
• Set Up integration Broker for the GHX EDI Vendor.
• Investigate the features of Position and People HRMS core setup and select People.
• Worked on Paygroup, Payroll and Core Foundation Table setup.
• Implemented template based recruiting, Candidate gateway, Talent acquisition management
• Train Users on Job and Person data relationship. Salary Plan, Salary Grade Table
• Perform pre and post upgrade functional technical review, HR/Benefits/Payroll
• Analyze recruiting process in 8.8 fit gap with PS 9.0 changed manage resumes to in corporate resume mirror and monster job site. Seamless on boarding through candidate gateway
• Configure document association rules and Rules processor for the AP Matching in 9.0
• Worked in multi vendor and multiple stakeholder upgrade environment, with continuous resource turnover.
• Engaged C - Level Executives to proof of concept effort for the Peoplesoft enterprise portal
• Socialized the toolset to Lahey C-Level leadership team including CFO,CHRO and steering Commt.
• Built a prototype for Guest, Employee, Doctor, Patient view of the enterprise portal.
• Create Portlets in Eclipse using Pluto and Jetspeed
• Implement JSR 168 and WSRP compliant Portlets using Pluto Plug in, J2EE
• Publish Portlets in WSRP Producer consumer in Peoplesoft Portal
• Use Content Management Capabilities, Collaborative Workspace, Branding tools
• Peoplesoft Enterprise Performance Management 9.0:
• Setup Ascential tool set, including Director, Administrator & Designer 7.5.X PS delivered
• Import Peoplesoft Delevired DSX files through the Administrator
• Configure Master Run Utility to point to Source, OWS,OWE
• Run the Setup Sequence and Master Sequence for the EPM warehouse
• Worked with Datasets and Job streams to map processing sequence
• Develop Performance Ledger, Resources, Activities and cost Objects
• Theoretical understanding of reciprocal allocation looping.
• Create the General Ledger and Payables Mart for EPM Financials warehouse
• Create the Compensation Mart and Workforce Profile Mart for EPM HCM warehouse
• Load KPI for Workforce scorecard, CFO portal Solution
• Configure EPM Analytics and Charting tool
• Design Operation Data Store, ETL process using Ascential DataStage and MetaStage

Confidential, Simsbury, CT

Environment: PeopleSoft Financial & Distribution 7.0 & 8.4 on Oracle 7.x,8.x

Project Manager CNA Merger

Responsibilities:

• Project Implementor Peoplesoft 8 for Reinsurance LOB
• Team Lead PeopleSoft AR, BI, Project Costing, GL
• Developed backup strategy and validation - - includes document backup processes, testing backup processes and validating successful recovery from backup.
• Participated in design discussions to support project and baseline work.
• Performed regular schedule maintenance processes
• Worked with application development staff to develop database architectures
• Planned and performed the migration of all Oracle version 9.2.0.7 to version 10.1.0
• Administered Oracle 8i, 9i and 10g databases on various unix platforms (HP, SOLARIS, AIX)
• Automate and consolidate upgrade steps, while still producing technical analyze the output.
• Run upgrade steps by launching programs and processes, monitoring progress, performing necessary navigation, and checking for errors.
• Setup Paycycle, Voucher and Vendor information. Resolve paycycle runtime errors.
• The Hartford Group Benefits bought CNA Business identifying M&A as strategic initiatives
• Creation of CNA business process mapping to GBD business process
• Document Data Quality, Data Integrity and Gap Analysis with SME ( Subject Matter Expert)
• Complete SDLC Implementation Of Peoplesoft 8.4 Application
• Billing and Account Receivable modules.
• Business requirement analysis, Solution Design