We provide IT Staff Augmentation Services!

Finance Data Architect Resume

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

Hire Now