SUMMARY

• Solutions - oriented Software Programmer and Coordinator, Business Analyst and Financial Reporting Professional with demonstrated strength in data reporting, utilizing spreadsheets, databases, project management, IT support and extensive mathematical programming, improving projection reporting, compliance, and efficiencies.
• Proven problem-solving specialist, answering questions, resolving issues and improving workflow and productivity.
• Known for superior computer abilities, disaster planning and management, gathering data, generating reports, testing systems, improving accuracy and quality, ensuring reduced downtime.

TECHNICAL SKILLS

• Access
• Excel
• SQL
• VB
• NILS
• ATS
• BEEP
• APL

PROFESSIONAL EXPERIENCE

Confidential, Bethlehem, PA

Junior Software Development Coordinator

Responsibilities:

• Ensured thorough accuracy of monthly sales reports for management from 2015 to present using Access and Excel.
• Completed analytic testing of new system for software systems conversion of approximately 300 simulated, realistic composite units using Access, Excel, VB, and internal sales of components from 2016 to May of 2017, and reported vital findings to management on May 31st, 2017.
• Ensured timely, as well as generally thorough and accurate, completion of roughly 90% of our department’s analytic assignments given on maintaining 2g software product knowledge and 2g software return coding for composite pricing from 2014 to 2016 under prior system.
• Coordinated assignments in forms to coworkers from 2016 to present.

Confidential, Bethlehem, PA

Software Developer

Responsibilities:

• Ensured timely, as well as generally thorough and accurate, analytic completion of assignments given on improving 2g software product knowledge and 2g software return coding for composite pricing.

Confidential, Bethlehem, PA

Dental Renewal Specialist

Responsibilities:

• Improved projection accuracy by gathering data for renewal target analysis, ensuring accurate projections of renewals needed on block basis.
• Improved underwriting accuracy by preparing bi-weekly exhibits using Excel macros and pivot-tables, monitoring renewal targets vs. actual, ensuring underwriters’ rate-revising discretion based on need.
• Generated renewal projection of annual dental policies by first exporting raw claims / premium data from source, then implementing expense, claim trends, and other financial projection assumptions in Access into analysis, determining needed target renewal premiums.
• Improved whole-group underwriting accuracy by rigorously testing Guardian’s renewal system using an Excel rating model, ensuring subsidizing one line of business with another within single case, ensuring sound, just, and accurate rates.
• Improved underwriting processes by testing all table-driven targets calculated and derived on Guardian’s renewal system for approximately 150 cases, each with approximately 20 components for approximately 3K element tests, ensuring system accuracy by assisting underwriters with additional testing.
• Improved reporting by measuring how lapse rates correlate with rate increases, using line-graph regression analysis in Excel, ensuring quality and accuracy.
• Improved policyholder relations by providing and preparing necessary analysis in Excel, helping strategizing around maximizing persistency-profitability balance, identifying location of subsidizing one segment of business with another, and how much, pleasing policyholders, ensuring company needs met.
• Improved systems by assisting in testing of new renewal system with Excel model, using v-lookup to tables.

Confidential, Plymouth Meeting, PA

Regulatory Analyst

Responsibilities:

• Avoided regulatory fines 100% by successfully filing hundreds of necessary insurance documents for regulatory agencies, ensuring compliance, and accuracy.

Confidential, Parsippany, NJ

Statistician

Responsibilities:

• Improved rating procedures by providing necessary data in required format and condition to rating bureaus for rating multi-million dollar policy portfolio for excess reinsurance, ensuring accuracy, and compliance.
• Established IBNR for collateral in case policyholders became insolvent by providing actuarial loss projections twice per year to each policyholder of UMI and Genesis, creating programs, procedure documents, and utilizing data transfers and conversions of Genesis, Princeton, and Cambridge, ensuring claims would get paid in disaster event.
• Improved system transition by completing special projects, including analytic claims data conversion from Princeton to CSC and conversion of claims data to Cambridge using Excel, Access and/or SQL, ensuring continued workflow with each company retaining individual sets of data specifications.
• Reduced administrative risk and leasing overhead by quickly responding to questions from Cambridge, regarding data content, definitions, and coding needed, ensuring employees ease of performing job functions, while working from anywhere on new web-based Cambridge system.
• Improved rating bureau relationships by controlling data through Excel and SQL, including data cleaning and validation for analytic reporting to state rating bureaus, parent company General Re, Utilities Mutual Insurance Company, Princeton Insurance Company, and Cambridge Integrated Services, ensuring no penalty fines for corrupt data.
• Improved workflow by performing daily and weekly network maintenance, maintaining item checklists, reviewing, and implementing corrective action when needed, managing daily and monthly internet and intranet server back-ups, maintaining claim administration servers, file sharing, and print sharing.
• Maintained system workflow by managing all computer-related functions for small office in absence of part-time consultant for 6 years, ensuring productivity, and no downtime.

Confidential, Piscataway, NJ

Actuarial Analyst

Responsibilities:

• Minimized report creation time and maximized analysis time by creating analytic APL (A programming language) programs, producing reports, analyzing medical and dental small business premiums and claims experience for all pricing
  and renewal decisions, executing programs for periodic batch reports.
• Improved compliance and avoided fines by filing policy-rating changes in 35 states quarterly for thousands of small businesses, corresponding with state insurance departments, answering analytic questions including medical claims vs medical expense loss ratios, ensuring rate compliance.
• Improved rate compliance by performing additional annual reviews of small group ratings laws for actuarial certifications, reviewing state regulations for changes in rating restrictions or boundaries, providing feedback, implementing billing system changes, eliminating non-compliance fines.
• Improved quality by passing all actuarial exams from 100 through 150, the equivalent of 3 exams under the current structure, including calculus and probability, statistical methods, and regression methods, ensuring required skill strength in mathematical, problem solving and data processing.