SUMMARY:

• 14 years - Complex PL/SQL including DML and DDL creation and maintenance -Oracle 12c and SQL Server 2014.
• 13 years - PeopleSoft Confidential 8.4-9.1 AM, AP, GL, KK and PC Business Analyst including technical experience PeopleTools 8.55 functionality.
• 5 years - ETL processing using CRC32 Staging, Oracle Change Data Capture processing for incremental data extraction and load to create dimension and fact table design to support star schema and snow flake reporting structures.
• 4 years - DataStage Ascential 8.5 ETL design, maintenance, and automation using DataStage Ascential 8.5 to pull data from PeopleSoft Confidential (Financials), Confidential (Human Capital Management) and Confidential (Campus Solutions) databases.
• 4 years - PS EPM including Business Unit Wizard and BU setup, Tree Flattening processing and Hierarchy Set up from PeopleSoft Confidential, HRMS and Confidential in DataStage.
• 10 years - PeopleSoft TreeManager (PS Confidential, Confidential, and Confidential ) from implementation, documentation and the creation and setup of institutional procedures for non- technical personnel use.
• 18 years - Data Analysis including data extraction from large database platforms and deriving: Medical Cost Utilizations; Actuarial Employee Benefits measures from valuations, and experience studies; IRS Qualified plan contributions; all General Ledger and budgeting measures.
• 18 years Demonstrated process oriented mindset in creating new automated or regularly scheduled processes and adapting existing processes to greater efficiency.
• 18 years - MS Office Suite including Excel, Word, Access, Visio and PowerPoint
• Satisfied Society of Actuaries Statistical Requirement in University level course work and SOA exams.

TECHNICAL SKILLS:

DataStage Ascential 7.5/8.5 (including Director and Manager) Informatica: Oracle 12c; SQLServer2014, DB2;

Unix Shell Scripting: PeopleSoft (PS) HRMS 9.0, PS Confidential 9.1, PS EPM 9.1, PeopleTools 8.55

TRUX Waste Management Operations: Oracle 12c; SQLServer2014, DB2;

COGNOS 8, Query Studio, ReportNet and PowerPlay: UC4 8.0 - batch processing scheduler

PROFESSIONAL EXPERIENCE:

Confidential, Nocatee, Florida

Business Analyst

Responsibilities:

• Confidential is the nation s 5th Largest Publicly traded Confidential
• Exclusive responsibility for Payment Processing tool including fixes, integration with a third party application and design. Processing 4.6 million rows annually for $1.2 billion in revenue. Increased processing from 5,000 rows per hour to 10,000 by changing the start time and allow the process to finish before 8 AM for the business
• Lead Business Analyst maintaining PS Confidential 9.1 Asset Management and Project Costing modules reducing break fixes from 1 to 2 a month to no fixes for 2017

Contractor, SQL ETL Developer

Responsibilities:

• ETL development, maintenance, and automation of BKFS proprietary Data Warehouse.

Confidential, Gainesville, Florida

IT Expert

Responsibilities:

• ETL design, maintenance, and automation using DataStage Ascential 7.5 and 8.5 pulling data from PeopleSoft Confidential (Financials), Confidential (Human Capital Management) and Confidential (Campus Solutions) databases. This included a 20% reduction in processing time of the Confidential initial load from 60 hours to 47 hours
• Module Lead for maintaining PeopleSoft Finance 8.4-9.1 Asset Management and Projects Costing Modules including development and implementation of mods, upgrades and fixes for a 250,000 asset book. Also worked extensively with PS modules AP, GL and KK
• PeopleSoft Tree Manger (PT 8.51) including implementation, documentation and maintenance of all Trees for Confidential, Confidential and Confidential . Implemented the University s ChartField and Tree systems including developing and documenting the University-wide policies and procedures for defining, maintaining, adding, and modifying of ChartFields and Trees.
• Developed, implemented and managed a validation process for Phase I and II Report Initiative Reporting Package. The Initiative was the University s first successful delivery of a set of reports that provided for Month End Reconciliation of an individual department s financial activity.
• Extensive experience in all phases of the Software Development Life Cycle, including planning, requirements gathering, development, quality assurance and testing.
• Quality Assurance for Bridges Business Intelligence group, from data validation to final product design. Primary source for all data validation and reconciliation of the Cognos Data Warehouse and BI products to the PeopleSoft Financial System Finance
• Bridges Liaison for the Division of Housing. Developed and implemented Housing specific processes to transition the legacy systems to using PeopleSoft systems and are used as part of Housing s monthly business processes. This includes training, on-site customer service and extensive customer contact.

Corporate Underwriter

Responsibilities:

• Underwriting of new and renewal business of Fully Insured and Self Funded Large Group (51+ lives) and Small Group (1 - 50 lives) Health Plans, which included determining degree of risk from such factors as group s financial standing, demographics, industry, claims experience, medical underwriting, and other variables that could potentially affect risk
• Developed the critical tables and calculations on which ratings were based including Confidential s Claims Completion/Reserve tables for Confidential claims; Confidential s first competitor analysis database; Confidential s first variable administration charges based on group size; Confidential s first Confidential (Self-funded product) Administration charges; assuming various enrollment and risk scenarios; Confidential s continuance tables for pooling levels and charges used in the experienced-based rate development. Developed Confidential s first Pharmacy and Outpatient Cost and Utilization calculations.
• Responsible for administering and maintaining the Underwriting Financial Database using Business Objects, a relational database manager. The database contained monthly, quarterly, and annual data for Confidential s entire commercial block of business, as well as all enrollment data, revenue, medical claims, pharmacy claims, and medical operations data for four year periods. The database was used for all underwriting analysis, ratemaking, and rate development. Responsible for all refreshes and data accuracy of the entire database

Confidential, Gainesville, Florida

Actuarial Analyst

Responsibilities:

• Administered and consulted IRC 501(c)(3) tax exempt hospitals regarding their Florida Retirement System-mirror plans and IRC 403(b) Tax-Sheltered Annuity Retirement plans including the automation of an annual contribution calculator for a 3,000 member plan.
• Exclusive coordinator and lead of employee workshops. Responsible for presenting and explaining retirement plans ranging in scope from IRC 401(k)s to IRC 403(b)s to defined benefit plans for various clients
• Compiled and filed IRS forms, including IRC Forms 5500-Annual Report and 5300-IRS Determination filings for IRC 501 (c)(3) tax exempt hospitals
• Administered retirement plans for five Florida municipalities Collected, prepared, and compiled data to create annual valuations, special studies, and individual benefit calculations