Power Bi Sql Developer
Resume:
Fred Simon
*******@*******.***
Overview
Over 36 years in IT with the last 29 doing Oracle as a developer, data modeler and DBA over a variety of industries such as government, banking, insurance, manufacturing and telephony. Skills include PL/SQL, data modeling, relational databases, data warehouse, etl, dba, jira, powershell, linux, system analysis, forms, reports.
Professional Experienc
Naval Information Warfare Center (NIWC) – Atlantic
Oct 2023 – Present
Database Architect
Within Defense Health Readiness Engineering Support (DHRES), which maintains electronic medical records for deployed service members worldwide, undertook
Data modeling
- reverse-engineering Oracle tables into an entity-relationship diagram, including both local and
remote tables
- created as-is and to-be diagram of reports and its data source. Also included prod and
development databases, servers, power bi software, and dataflow
- configured Oracle SQL Developer to connect to databases
Oracle development
- questioned use of materialized views
- understood hierarchical queries
- prepared for partitioned tables
- found alternative to switching between synonyms
- proposed to-be Oracle Cloud Infrastructure and networks
- added constraints to Oracle tables - primary keys, foreign keys, unique indexes
- corrected deficiencies in existing PL/SQL package such as package spec
- considered use of SQL Access Advisor
Learning
- Power BI, including install and configuration of Power BI Gateway.
- naval training courses
Systems analysis
- wrote document on how to access the remote database going thru virtual desktop service
(VDS) and remote database protocol (RDP)
- upgraded CyberArk’s Endpoint Privilege Manager to Delinea Privilege Manager.
- completed and submitted documents such as SAAR's to access computer resources
- requested National Vulnerability Database (NVD) access
Oracle 19.20: Oracle SQL Developer, Oracle Cloud Interface
Windows 11: Excel, Jira.
Lockheed Martin – Aircraft Manufacturer, FL
June 2022 – March 2023
Software Engineer
As part of a sustainment program for a fighter jet
enhanced Powershell script by validating whether an account to be re-enabled was still in Active Directory.
installed Git Bash.
corrected PL/SQL cursor to find logs about parts needing replacement which have a next higher assembly level.
analyzed workarounds used to temporarily replace faulty baseline code.
refreshed an Oracle database with extracts unzipped from zip files provided by the sites.
Oracle 12c: PL/SQL.
Windows 10: Powershell 5.1.19041, Excel, Jira, Git Hub 2.33.1Windows.1.
US Navy – Dept of Defense, CA
June 2021 – March 2022
Software Engineer V
For navy fleet technical and summary information housed in a CLOB
created queries with regular expressions
scripted daily/weekly/monthly/etc ship casualty metrics such as average and median durations and counts.
improved PL/SQL by removing unnecessary code, optimizing queries, streamlining logic and combining programs with dynamic SQL.
added parameter to PL/SQL program to exclude a date range.
corrected database errors.
created tables, PL/SQL specs and body, sequences, identities.
Oracle 12c: Windows 11, PL/SQL, Excel, SQL Developer, You-track.
US Navy - Dept of Defense, CA
November 2019 – May 2021
Architectural Analyst
For an airplane maintenance data warehouse
created DDL for fact and dimension tables, including junk and conformed dimensions, using Kimball methodology for load into universe to create Business Objects reports.
created natural and surrogate primary keys.
wrote PL/SQL to partially build DDL by copying and transforming stage table ddl.
created entity relationship and shell diagrams.
requested creation of the stage tables and views with data sourced from a Maximo application and general ledger.
found stage tables without primary keys, mismatched record counts, missing tables and etl bugs.
aided conversion of PL/SQL to Informatica.
created update trigger to find incorrect etl values.
clarified requirements.
wrote monthly report.
worked on virtual machine.
Oracle 12c: Windows 10, Office 365, PL/SQL, Excel, Toad, Erwin, SharePoint, Jira, Confluence, Agile.
US Air Force – Dept of Defense, AL
November 2018 – November 2019
Oracle DBA
On a university student management system
installed SQL Developer, Oracle Enterprise Manager and Management Agents on Azure virtual hosts.
determined what the Advanced Queueing process was doing
diagrammed system data flow
copied tables from on-premise production environment to Azure cloud virtual machines.
analyzed versions of Oracle Database and OEM to decide which to install.
created entity relationship diagram of a major subsystem.
prepared Oracle 12C database STIGs.
wrote PL/SQL program to obfuscate sensitive database data.
Multi-tenant Oracle 12C: Windows 10, Oracle Enterprise Manager 13.3, Oracle Advanced Queueing, Azure,
Data Pump, DBCA Jira, Confluence, Agile.
US Army – Dept of Defence, AL
May 2018 – November 2018
Systems Analyst
On an infrastructure system, used PL/SQL to
Copy files from local network to virtual machine.
Process an excel file after it was transferred to an Oracle table.
Add logging procedures and exception handlers to procedures.
Change loop processing
Change dynamic SQL where SQL injection attacks were possible.
Oracle12c: Windows 7, PL/SQL packages and procedures, Excel, WINSCP, Jira, Sharepoint, Linux, Agile
US Army – Dept of Defence, KY
Mar -2017 – May 2018
Systems Analyst
On a human resources system created ETL and data maps
with exception handling
explaining ETL flow, de-confliction and type 1 and 2 slowly changing dimensions
Mapping flat file data extract back to source tables by reverse engineering stored procedures and packages.
Adding functionality to stored procedures.
Zipping files in a Unix script]
SQL Server 2008: Windows 7, T-SQL, SQL Server Management Studio, SQL Server Integration Services, Remedy, Jira, Sharepoint, Unix
Attained Comptia Security+ Certificate
Oct 2016 – Dec/2016
Bank of America – Bank, NC
Oct 2015 – Aug 2016
Oracle developer
Developed database which records and measures risk in complying to bank regulations and policies. In so doing
created and reviewed tables, procedures, etl package and database mappings
modeled data
Agile development
Oracle11g: Windows 7, PL/SQL, Informatica, Toad, SVN, Jira
Defense Manpower Data Center - Dept of Defence, CA
Jan 2015 – May 2015
Software Engineer
For each military component, wrote ETL and created fact table for counts of reserves and their sub-populations supporting a J2EE web front end. Employed
pl/sql packages using ref-cursor
bulk collect
remote Kimball dimensional data warehouse
Oracle Scheduler
Agile development
Oracle11g: Windows 7, PL/SQL, Toad, SVN, Jira, Oracle Scheduler
US Navy – Dept of Defense, LA
Aug 2013 – Jan 2015
ETL Developer
In a Kimball military human resources data warehouse
wrote ETL in the E-leave and qualifications subsystem in collaboration with web based Business Objects reports
created pl/sql packages for type 1 and 2 slowly changing dimensions
did etl, both incremental and bulk
analyzed Kimball dimensional and relational data warehouses.
optimized PL/SQL
Oracle11g: Windows 7, PL/SQL, Toad, Dimensions
Humana – Health Insurance, KY
Jun 2012 – Jul 2013
Oracle architect/developer
To support physician ETG composite scoring based on groupers
ran and wrote ETL
revised Inmon star data store and relational model for use in Oracle database and Qlikview.
modified scoring code sql with analytic functions.
explained confidence and reliability levels and peer cost comparisons.
understood use of gamma distribution for physician scoring
prepared use of external tables and bitmap indexes.
created sql to populate geographies and specialties.
ran quality tests of provider compliance ratios
Mohs sub-specs
introduced procedures in place of conditions for critical variable
replaced ccg codes with etg
changed criteria to 10% and 10 in number
created table for episode counts
consider only current period and not last 2
Ophthalmology sub-specs
remove episode count and percentage criteria at the tid/hrr level
patient_id is also part of primary key with along with episode_id for episodes
verified mixed use of condition code and procedure code for the different sub-specialities
Other
corrected use of inconsistent geography data
evaluated Oracle ntile, rollup and cube functions for peer totals
developed normalized and star schema data models of scoring and selections procedure
new PHP database and scripts with UNION
created and populated tables for upstream reports
determined some primary keys
Oracle11g: Windows 7, SQL, Erwin Data Modeler, PL/SQL Developer, QlikView, Excel macros.
Trover Solutions – Insurance, KY
Jan 2012 – May 2012
Oracle Developer
Within property and casualty and medical insurance screens
updated ref-cursor packages for forms queries.
added fields
rejected events and cases
gave report capability to query
redesigned tables.
Oracle10g: Windows XP, PL/SQL, Forms10g, PL/SQL Developer, Putty, Winscp, QVCS, Data modeling.
US Postal Service – US Government, MN
Feb 2011 – Dec 2011
Oracle Developer
In a payment system for rural postal carriers
transferred leave from clock ring system to leave system.
solved production issues
developed forms, database procedures and triggers
did Data modeling
Oracle10g: Windows XP, PL/SQL, Forms 10g, Toad, SQL Developer, Putty, Reflection, Reports 10g
Global Logistics LLC – Gas station, SC
Oct 2008 –Jan 2011
Owner/Business Analyst, POS Support
In a retail store
developed daily sales report for each cash register.
constructed worksheet to store money counts, overages, underages in each cash register.
devised guide showing how to open and close store, including how to reset registers for next day.
operated Digimaster DVR to catch store theft.
submitted police and bad check reports.
built worksheet to replenish change and set gas price.
reported taxes.
interviewed employee candidates and aided in the hire/fire decisions.
passed Oracle certification exam Oracle 10g New Features for Administrators
Dept of Justice – US Government, DC
Oracle developer/Data Modeler/DBA
Jan 2008 – Sep 2008
In a training and infrastructure database
installed and configured Windows XP, Windows Server 2003, Developer Suite twice, SQL Developer, Oracle Application Server twice-Infrastructure and Business Intelligence/Forms, Oracle Database twice, Designer repository twice, WinSSHD.
created entity-relationship diagram, 10 pl/sql jobs using utl_file package, requirements, project plan, 10 staging tables, 20 production tables.
installed public keys for RSA and DSA encryption.
created Secure External Password Store.
defragmented disks.
configured automatic shared memory management.
used dbverify for file corruptions
Oracle10g: Windows XP, Windows Server 2003, WinSSHD, pl/sql utl_file, Designer 10g, Forms 10g, Reports
10g, Scheduler, data modeling, Application Server, utl_tcp, jinitiator.
US Postal Service – US Government, VA
Jul 2007 – Dec 2007
Oracle developer
While suspending and discontinuing post offices
created 20 pl/sql packages consisting of html forms using htp pl/sql package and cascading style sheets.
built ddl and test scripts.
modified 1 html/pl/sql/css report.
optimized SQL
Oracle10g: Windows XP, pl/sql html, javascript, css
Dept of Logistics Info Service – US Gov, VA
Apr 2007- Jul 2007
Data Modeler/Oracle developer
In a hazardous materials system
expanded ERD for later use as multi-dimensional data model, facilitating OLAP
created abbreviated relational model
loaded Erwin and Oracle 10g onto laptop.
wrote SQL as a basis for the ETL process that merged source database into Kimball data warehouse that held information useful for business intelligence.
analyzed change data capture packages in datawarehouse
did service oriented architecture - constructing sqlx queries to create xml and debugging a consumer pl/sql package
Oracle10g: Windows XP, SQL, SQLX, PL/SQL, Erwin, XML
The Boeing Co - Airplane manufacturer, WA
Jul 2006 - Mar 2007
Oracle developer
In an airplane configuration system
modified reports
converted Pro*C/awk/sed program to pl/sql using database link to db2
loaded service bulletins into Oracle using pl/sql from staging tables loaded by push from sql server across database link
SQL-LOADed data on Excel spreadsheet to Oracle table
migrated forms, reports, menus and unix startup scripts from one version and server to another
ORACLE9i: Sun/Unix,Windows95,Forms10G,Reports10G,Pro*C, Awk, sed, RCS, SQLLOADER
Dept of Motor Vehicles - CA government, CA
Apr 2006-Jun 2006
Oracle applications developer
In a timekeeping system
created custom timekeeper tab screen.
planned configuration of OTL by assigning responsibilities and determining context sensitive descriptive flexfields, value sets and profile values
ORACLE9i: WindowsXP,Oracle Applications Time and Labor 11i (OTL), Oracle Applications HR 11i, PL/SQL,
Forms6i, data modeling
Nevada Dept of Taxation - State tax dept, NV
Dec 2005 - Mar 2006
PL/SQL ETL developer
In a state tax system
moved DB2 data to Oracle
created flat file data extract consisting of business intelligence information for subsequent etl into multi-dimensional
Kimball data warehouse
tested,
reconciled and documented
ORACLE9i: WindowsXP,PL/SQL, Toad
Randolph Air Force Base - Air Force, TX
Jan 2005- Nov 2005
Oracle applications developer
In an air force HR system
changed quick codes
corrected exception handlers.
wrote design documents
ORACLE8i: WindowsXP,Reports4.5, Oracle Applications HR 10.7, Designer2000, PVCS, Test Director, Kintana, PL/SQL Developer, Forms4.5
The Boeing Co - Airplane manufacturer, WA
Sep 2000-Dec 2002
Oracle developer
For airplane configurations
converted Developer2 to Developer6
created reports - 3 matrix with totals, 7 master/detail
created 3 screens
tuned SQL using Explain plan, Tkprof,hints
upgraded 11 screens, 20 reports,8 procedures,10 tables
specs
wrote Unix and Perl scripts
fixed printer bugs
installed Designer9i and captured database
ORACLE8i: Sun/Unix, Windows95, Forms 6i, Reports 6i, Pro*C, Designer9i, RCS,Makefile,Perl
Naval Air Weapons Station - Naval base, CA
Dec 1999 – May 2000
PL/SQL ETL developer In a Kimball financial data warehouse
used PL/SQL etl to extract Oracle data to flat file for FTP to data warehouse on naval intranet and load file from CLOB into tables
wrote specs
revised ERD
loaded, exported, imported test data
ORACLE8i: Sun/Unix,Windows NT,Designer6, PLSQL8,Import/Export, Sql*loader, PVCS
Westinghouse -Dept of Energy nuclear site, SC
Jun 1998 – May 1999
Oracle developer/Data Modeler
In an asset management system
converted Forms4.5 to Forms5 and Forms3 to Forms4.5
created 2 Forms5 screens which load scanned barcode data into tables, 2 Reports3 reports, 1 Forms5 screen.
installed Designer 2.1, Developer 2.1 and patches
tuned SQL in screens and reports
reverse-engineered database and screens
created ERDs
adding constraints.
created and tuned database links to DB2 & Oracle
created LOV screen to DB2
web-enabled existing forms for use on intranet
created HTML page on a non-PL/SQL cartridge implementation
configured CGI
ORACLE7: Sun/Unix,Windows 95,Designer 2.1, Reports5,Forms5,HTML,Forms3, SQL*LOADER,Import/Export,
Exceed X-Window emulator
South Texas Project - Nuclear plant, TX
Nov 1997 – May 1998
Data Modeler, Oracle developer
Added improved tech specs to surveillance tests and their work orders.
In a maintenance schedule
did specs
revised ERD
modified 10 screens,6 reports,5 procedures,4 tables, workflow
ORACLE7: Sequent/AIX, Windows 3.1, Designer 2000, Forms5,Reports5,PL/SQL
First Union - Trust dept of bank, NC
Feb 1996 – Oct 1997
Data Modeler/developer/DBA
Created a stock market system that traded repos and money markets by sweeping cash between checking and trust accounts
modeled Oracle/Edify processing
created 25 screens, 15 reports, menu, procedures,30 tables
installed Designer 2k
reverse engineered database
administrated repository
queried Kimball datawarehouse
wrote user documentation
ORACLE7: Alpha 8440/OpenVMS 6.2/Windows 3.1, Windows 95/Designer 2000, Forms5,Reports5,
SQL*LOADER, Gateway Products, DCL
Other: Flowcharting 4, Network Data Mover, IBM MVS/JCL
PA Power & Light - Nuclear plant, PA
Feb 1995 – Feb 1996
Data Modeler, Designer2000 developer
In an issue tracking system
modeled data
created 10 screens, 10 tables, menu
To notify emergency personnel
revised ERD
created 10 screens, 10 tables, 3 reports, procedures, menu
Supporting the placement and modification of equipment
revised ERD
created 20 screens, 30 tables, 3 reports, procedures
ORACLE7: Sun/Unix,Windows 3.11/Case 5.1, Designer 2000, IDEF
Meldisco - Shoe distributor, NJ
Nov 1994 – Feb 1995
Data Modeler
For a retail store replenishment system revised ERD to include
sales forecasts & history
warehouse orders
ship schedules
optimal inventory
Windows3.1,Erwin-Erx for Powerbuilder V1.5c/IBM PC
Sprint - Telephone company, MO
May 1994 – Oct 1994
Oracle forms developer
In the placement, transfer and retirement of equipment/cable over tax districts
created 45 screens, menu, procedures
ORACLE7: HP9000/Unix,Forms4, PLSQL1, ER Diagrams, Process Diagrams.
NY State Government –Services to Disabled, NY
Jan 1994 – May 1994
Oracle developer
For capital expenditures
created 5 screens, menu, procedures.
installed SQLPLUS
For equipment inventory
revised 15 screens, 8 reports
ORACLE7: Vax/VMS,Windows3.1/Forms4/PLSQL1.
ORACLE6: Vax/VMS/DCL,Forms2.3, QMX, All-In-One, Pro-Cobol, Sql*loader
Xerox - Photocopier manufacturer, NY
Aug 1993 – Jan 1994
Oracle developer, Data Modeler
For the Pay-On-Production system, including bill of material, purchase order, forecasted demand, costs, shipping and receiving
created 4 screens, menu, procedures
revised ERD
ORACLE6: Vax/VMS/DCL,Global View,Forms3, PLSQL1, ERD/Process Diagrams
Alpha & Omega - Warehousing software, PA
May 1993 – Jul 1993
Oracle dba, developer
For employee time and client data
created 10 tables, ERD, instance
installed SQLNET
configured printers
generated kernel
segmented disc
ORACLE6: Vax/VMS/DCL,HP9000/Unix,vi, Korn Shell programs,Makefiles,Forms3,Plsql1, Pro-c, Menu5, CVS,
Deft case tool, Erds, Sqlnet, Sqldba
Howmet - Jet engine parts manufacturer, MI
Nov 1992 – Apr 1993
Oracle developer
In the MRP system
revised 10 screens. Created procedures
ORACLE6: Vax/VMS/DCL, Forms3, PLSQL1, Pro-C, Pro-Cobol
NASA & US Army – US government, Northern VA
Nov 1991 – Nov 1992
Oracle developer
In the deployment and repair of computers system
created 10 screens, 10 tables, 3 reports.
loaded data
ORACLE6: Vax/VMS/Dcl,Sco-Unix,X-Windows, Forms2.3, Sql*Loader,Sql*Plus reports
General Electric - Electrical products, NY
Aug 1991 – Oct 1991
Oracle developer
Parts and products supplied to government
converted/revised 15 screens,5 reports from version 5 to version 6
ORACLE6: IBM MVS,JCL,Clists, LATEX, SQL*PLUS reports, RPT, Forms2.3
Warner Lambert - Pharmaceuticals, MI
Sep 1990 – Jul 1991
Oracle developer
In support of Clinical Studies Funding System did the following
In as-Is system
flowcharted current system from data entry to report generation
obtained report output, data entry procedures, data input forms, metadata on every field on forms,
suggestions for improvement.
observed data entry procedures and job submissions.
Flowcharted non-computer procedures
Received explanation of jargon
Developed new system
converted 10 reports from IBM/PL1 to IBM/ORACLE.
created screens for add funding, payments, query and update, closeouts, changes to authorized
amount and approval date, archive to history
created tables for funding, payments, expense adjustments, in this way - created CLIST to copy contents of
Dialog Mgr tables to flat file. SQL-Loaded to tables.
Printed report to verify results.
Started writing SQL programs for report variables such as various expenses - ytd, cumulative, remaining to
yearend, next year, the year after, cancelled.
Discovered project codes are inconsistent. Ran report on all errors. Constructed screen to enter corrections
and instructions on its use
Cleaned monthly expense data by creating report.
Verified new system by comparison with existing system
ORACLE6: IBM MVS,JCL,Clists, Sql*Plus reports, Rpt, Sql*Loader, Dialog Mgr/Keymaster, Forms2.3
American Way Life - Credit life insurance, MI
May 1989 Sep 1990
Oracle programmer/analyst
Billing system
created 2 reports and 5 tables for annual renewable term, whole life and term insurance with its riders
revised profit/loss reports
Credit life and A&H valuation system
created 1 report, 10 tables
For whole life (interest-sensitive and traditional), term and credit insurance
created 15 screens, 10 tables
Cash value, death benefit and reserve systems for level premium whole life insurance
Agent commission system
Modified program to allow for both gross and net payoff coverages
ORACLE5: Vax/VMS/DCL, Pro-Cobol, SQL*PLUS reports, Forms2.1
IBM PC: Lotus 1-2-3/Flowcharting.
General American Life - Reinsurance, MO
Mar 1987 – May 1989
Actuarial programmer
Enhanced GAAP and Statutory valuation system
redesigned input module to enable rates to be picked up at every integral age.
extrapolated rates into the future
created reserve factors on a per treaty basis
separated GAAP static and dynamic jobs which created factors
developed static GAAP factors from assumptions
revamped static and dynamic calculations
created flowcharts and explained the system including lapses, interest, cash values, factor files.
introduced defaults
added new formulas for year-end reserves, investment income, monthly premiums, term plans,
GAAP reserves and assumptions. Modularized program.
corrected a policy year calculation
re-designed valuation records
created tape backup and restore system. Introduced Generation Data Groups, department
LIB's
re-programmed Bordereau system
combined GAAP jobs to access policy tape once
as an interim measure, valuations continued on the IBM with reserve records created by extracting
policy data from DEC, copying it by tape to IBM and inputting it to the valuation programs.
amalgamated IBM files on DEC.
In support of the reinsurance pricing program
programmed coinsurance allowances for variety of companies and plans
wrote manual and trained.
programmed formulas for yearend reserves, investment income, monthly premiums, term plans
determined GAAP reserves from POLYSYSTEMS and added it to the pricing program
Designed new bulk reinsurance system
established DATA-XPERT input screen
wrote data integrity and comparison PL/1 programs. Reported duplicate cession numbers.
From tapes coming from outside companies, verified smoker codes and converted to
valuation-style records. Wrote sample gross-up program
changed valuation program
trained staff to run programs
In new DEC/ORACLE database
designed and created tables.
loaded over 2 million records from old IBM system to Oracle tables with Oracle Data Loader.
developed and modified menus
stopped double data entry
converted programs from IBM to ORACLE
created 5 reports, 3 screens, 10 tables. Some forms for data entry had comprehensive triggers
Improved valuation
Canadian reserves
- created and uploaded to Canadian Reserve Factor file and changed reserve program to access it
- VSAM'ed
- changed lookup dtno's
- ran it
enhanced ANB/ALB
extended allowances beyond 10 yrs and now at integer issue ages.
excluded female setbacks on female policies.
rectified duration calculation
created valuation extract file from and 3 separate DEC systems and transferred it to IBM
valuation systems. Placed entire procedure into menu.
revised programs, including ability to delete a row, change sites, making fields required, change
format, cursor movement and commit process
Set re-entry annual decrement = 0. Created Forms screen for re-entries.
Set rate = 1 when policy yr = 0
wrote sql to update annual decrease in Policy table.
clarified and corrected valuation error messages. eg: printed policy and treaty numbers on abends
introduced net present value profit measure
ORACLE5: Vax/VMS/DCL, Forms2.1, SQL*PLUS reports, Pro-PL1, SQL*LOADER.
IBM MVS: IBM 3090/TSO/ISPF,VSAM,OSJCL, Dataxpert, PL1, IBM PC, Generation Data Groups
Crown Life - Life insurance, Canada
Jan 1985 – Feb 1987
Actuarial programmer
Prepared financial statements
summaries of active and disabled life reserves on the BS3/NAIC basis including provisions for IBNA and IBNR
verified and adjusted IBNA
computerized exhibit 4 of Ottawa Statement. Reported exhibit 15
individual health section of "Report of the Valuation Actuary"
provided details for "Statement of Actuarial Opinion on the Annual Statement"
US business statement - exhibit 9 - aggregate reserves
movement statistics for government agencies
computer costs transferred to reinsurance
unit value system valuations - individual health, insurance, tab
unaccrued claims, outstanding health insurance claims, UPR and midterminals
inforce and settled gross premiums
US and American Crown issues and inforce
Researched reserves
American Crown deferred premium acquisition premium cost
basic minimum single premium calculated on universal life policies
adjusted Premise female non-smoker reserves
National Reinsurance ratios of reserves to gross premium
cost of insurance for US term/life/endowment plans
percentages by state/province
developed Crown America single premium variable life reserves, Converted VLN records. Checked net amount at risk. Calculated preliminary reserves.
Found sensitivity of attained age reserves.
ramifications of new DTS valuation table
relationship between new BS3 and NAIC disabled life reserves
Company policies
details of reinsurance agreement provided to New Jersey Dept. of Insurance
Puerto Rico and UK mortgage study
corrected coding procedures for American Crown ceded policies
age/duration on basic/active par Canadian business
mortality study with ANOVA and linear regressions
reviewed business systems and and accounting procedures
decide whether to list on NASDAQ. DPAC, GAAP reserves. Purchase vs historic accounting
Technical
cost of computer time for yearend valuations
corrected program which created microfiche
clarified automatic archival, space compression and actions to be taken in response to
flags/warnings on data set management report
programmed product discontinuances and early release
flowcharted valuation jobs
re-designed reports on claims and profit center financials
moved group health conversions onto system
updated patch files
put Ramis file definitions on PPS Stats file
considered inforce universal life
Created 10 actuarial reports. Did studies. Topics were
deferred acquisition costs, reinsurance ratios, universal life premiums, costs of insurance, single premium variable
life reserves, OTS tables, UK and Puerto Rico mortgages, ceded coding procedures, mortality, NASDAQ findings,
computer costs, system flowcharts, group health conversions, in-force runs, age/duration studies.
Did yearend financial statements. Valuation analysis.
IBM MVS: IBM 3090/TSO/ISPF, OS JCL,PL1, Ramis, SAS, IMS DB/DC,Telon,CDCS4
IBM PC: Lotus 1-2-3, Flowcharting.
Zurich Life - Life insurance, Canada
Mar 1983 - Dec 1984
Actuarial programmer
Prepared financial statements
claims intimated revenue reports, VPPR, extra mortality, excess interest, expected CA 5864 deaths,
quarterly mortality
movement statistics
Dept of Insurance requests for reserve summaries and audits
double indemnity claims for group and individual life insurance and AUL reinsurance received
dividend liability
Ran/revised programs.
In an annuity and insurance reserves system, did the following
revised 3 reports
created 1 report
anticipated monthly annuity payments
for immediate and deferred annuities, did valuation, updates, statuses, payment audits, file searches
handled insurance policies rejected by system
tax reserves
Other
statistics, asset-liability matching
VM 370, CMS, MCM 1024, APL
Technical Skills
Software (Yrs)
ORACLE (29):
12c multi-tenant (1): Oracle Enterprise Manager 13.3, PL/SQL, Data pump, Database Configuration Assistant,
Oracle Universal Installer, Oracle Advanced Queueing, Azure, Data Pump
12c (2): SQL, PL/SQL Developer
11g (2): SQL, PL/SQL Developer 10g (2.6): PL/SQL, SQLX, Erwin
9i (2.1): PL/SQL (1.5)
8i (1.1): Designer9i (.1), PLSQL8 (.3), Developer6i (.7)
7 (6.6): Developer6 (1.6), Designer 2.1(.7), Designer 2000 (2.4), Forms5 (.3), Reports (.2),
CASE5.1 (.1), Forms4.5/PLSQL (.5), Forms4/PLSQL (.6), Reports2.5 (.1), Perl, UNIX C-shell
6 (3.2): Forms3/PLSQL (.7), Forms2.3 (1.2), RPT (.3), DEFT Casetool (.1), Pro-Cobol
5 (3.5): Forms2.1 (.2), Sql*Plus reports (1.5), Pro-Cobol (.6), Dcl (.6), Pro-Pl1, Menu5 (.1)
mixed: SQL*LOADER (.1), JCL & CLISTS (.1), UNIX/KORN Shell (.1), Pro-C, SQLDBA, SQLNET, Import/Export
OTHER (7.4):
Powershell (.3), Jira (3), Digimaster DVR(3), PL1 (1.6), JCL (1.1), APL (.9), Ramis (.4),
Erwin Erx for Powerbuilder V1.5c (.3), VSAM (.2), IMS-DB/DC (.1), Flowcharting (.1), Lotus 1-2-3,
Latex, Globalview, C, SAS, Telon, CICS,DB2,Dialogue Manager, Keymaster, Network Data Mover
Operating Systems (Yrs)
LINUX (2)
WINDOWS (4.5): XP (4.5)
SUN (5.1): SunSparc/Unix/Windows 2000(1.2), Windows NT (.4), Windows 95(2.2), Windows 3.11 (1.1)
HP (.6): 9000 Series 800/HP-UX (.6)
DEC (6.7): Alpha 8440/Open VMS 6.2 & Windows 3.1 (1.7), Vax/Vms (5)
IBM (5.8):
Contact this candidate