| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address Briarwood Dr Apt A-3Horsham, PA Street Address
Home/Cell: PHONE NUMBER AVAILABLE Email: EMAIL AVAILABLE Web: www.gregac vitylog.blog SUMMARYStudent (2023), Data Analyst and Steward (2018-2023), Solu ons-oriented So ware Programmer and Coordinator (2014-2017), Business/Data (2000-2013) and Actuarial Analyst (1996-2000), and Financial Data Repor ng Professional (1996-Present) with demonstrated strength in data repor ng and stewardship, regulatory ling, u lizing spreadsheets, databases, project management, IT support and extensive mathema cal programming and processing, improving projec on repor ng analy cs, compliance, and eciencies. Proven problem-solving specialist, answering ques ons, resolving issues, and improving workow and produc vity. Known for disaster planning and management, gathering data, genera ng reports, tes ng systems, improving accuracy and quality, ensuring reduced down me. Exper se in: MS Excel VBA / MS Access / MS SQL / Java / JavaScript System Maintenance / Tes ng / Valida on / Coding Troubleshoo ng / Issue Resolu on Financial Modeling Analysis and Decision Making Insurance Renewal / Door Unit Sales Repor ng / Promo Products Supplier and Distributor Data Repor ng and Data CleaningPROFESSIONAL AND PERSONAL EXPERIENCESTUDENT ACTIVELY SEEKING EMPLOYMENT, Horsham, PA August 2023 Present StudentLooking for employment in reviewing at least 40 new posi ons per week when able and best, maintaining and enhancing my expense and annuity projec on daily that includes MS Excel VBA, MS Access, MS Power BI, Java, and JavaScript completed automa ng new methods of projec on for select payees in August 2023 to improve accuracy and smooth projec ons by 200 to 300 payees each with separate projec ons aec ng overall surplus/decit calcula on to align expenses through spending decisions, learning Dieren al Equa ons and Java by reading two books, interpre ng ongoing truncated frequency and me analy cs of my personal to-do using Java and MS Excel, answering ques ons for my websiteSTUDENT ACTIVELY SEEKING EMPLOYMENT, Horsham, PA May 2023 August 2023 StudentLooking for work, maintaining scripts, studying JavaScript, documen ng my JavaScript code, and star ng June 2023 and con nuing into July 2023, incorpora ng MS Access, MS Power BI and JavaScript in expense and annuity projec on, applying and studying Java con nuing a second me, opening and upda ng my website, star ng June 2023 and into July 2023, applying Java to my to-do list con nuing a second meSTUDENT ACTIVELY SEEKING EMPLOYMENT, Horsham, PA February 2023 May 2023 StudentLooking for work, maintaining personal nancial scripts, interpre ng ongoing to-do analy cs, reviewing vector analysis, and documen ng my Java code, maintaining automated system in calcula on of monthly expense and annuity projec on including DOS scripts with planned enhancement in exis ng Java, maintaining truncated frequency and me analy cs of my personal to-do using Java, reviewing answers to problems in vector analysis, documen ng my Java code for OOP ADVERTISING SPECIALTY INSTITUTE, Horsham, PA June 2019 February 2023 Assistant Data StewardPerformed large-scale data reconcilia ons for thousands of emails per month combined across 8 to 12 data sweeps using MS Access, MS Excel, MS SQL, and Business Objects, improving deliverability and syncing with Pardot and SalesForce to contact lead companies to acquire them as members, completed online classes for BASI Training and general educa on. Created and maintained 8 to 12 documented processes for data sweeps for reconcilia ons toward corrected data regarding emails and mailing addresses using MS SQL, MS Excel VBA, and MS Access Created an MS Excel VBA report run monthly for a large client Enhanced and maintained email reconcilia on system to propose decisions on roughly 40 dierent scenarios based largely on documenta on Performed reconcilia ons and on Business Objects reports, Personify, and Sales Force, regularly xed email-related informa on Achieved BASI cer ca onADVERTISING SPECIALTY INSTITUTE, Horsham, PA August 2018 June 2019 Data Repor ng AnalystCreated required reports using MS Access, MS Excel, and MS SQL. Suppressed for duplica on of contact. Created required reports for call lists and mailing lists for ASI Shows including appropriate suppression on phone numbers and email addresses, spot-checked suppression scenarios with every list, performed a weekly sweep of phone numbers for duplicates self-ini ated Created an email reconcilia on system that provides all informa on needed in a few MS Excel lines to make each decision on thousands of emails Submited tags daily to SalesForce and performed rou ne data updates Completed extra hours as needed to meet goalsSTUDENT ACTIVELY SEEKING EMPLOYMENT, Horsham, PA June 2017 August 2018 StudentCompleted studying two books on MS SQL years earlier for version 2012, and then recently for version 2016, tested, maintained, and enhanced and updated early and updated daily data analy c sta s cal quan ta ve forecas ng repor ng projec on since 2015 of my personal nances/expenses with both an MS Access VBA macro, and MS SQL for valida on, for an automated system in calcula on of monthly expense projec on. Studied actuarial material for exam FME of deriva ve markets and investment and took exam, studied actuarial material for exam C of actuarial models. REEB MILLWORK CORPORATION, Bethlehem, PA June 2014 June 2017 Junior So ware Development CoordinatorEnsured mely, as well as generally thorough and accurate, comple on of roughly 90% of our departments data analy c assignments and problems for customers in manufacturing given on maintaining 2g so ware product knowledge and 2g so ware return coding for composite pricing including SKU components using Notepad++, MS Excel macros, Tortoise SVN, and Winmerge, ensured accuracy of monthly analy c sales reports using MS Access to create extract for pivot tables, completed tes ng for system conversion using MS Excel for approximately 300 simulated realis c modeled composite items each composed of about 10 factors each for thousands of components with hundreds of pricing issues found and reported, ensured mely, as well as generally thorough and accurate, comple on under prior system of assignments on maintaining so ware, and coordinated assignments in language to coworkers Ensured mely, as well as generally thorough and accurate, comple on and management of roughly 90% of our departments data analy c assignments and longer-term complex problems, frequently based on inventory, given on maintaining and interpre ng 2g so ware product knowledge and 2g so ware return coding for composite pricing from Jun of 2014 to Feb of 2017 under prior system using C++ language interpreter in Notepad++ for return coding and crea ve MS Excel VBA macros for decision tree database addi ons on extracts, thereby managing projects and priori es. Enhanced extensive automa on of large projects through scripts and MS Excel VBA macros for so ware development. Executed VB scripts for copying and renaming for necessary format of hundreds of png images for import to 2g so ware. Ensured thorough accuracy of month-end sales reports for management from 2015 to 2017 using MS Access queries coding and MS Excel pivot tables, as well as through a mee ng with IT department. Analyzed sales data from crystal reports to best present those pivot table reports and dashboards to management, as well as any necessary data cleaning. Based on that sales data, as well as two other dierent nancial sources, performed personal business analysis and decisions. Completed reading a book of MS SQL by Itzik Ben-Gan to extend and maintain my analy c database handling knowledge.ROBERT HALF TECHNOLOGY, Bethlehem, PA February 2014 May 2014 So ware DeveloperEnsured mely, as well as generally thorough and accurate, data analy c comple on of assignments given on improving 2g so ware product knowledge and 2g so ware return coding for composite pricing. ACTIVELY SEEKING EMPLOYMENT, Bethlehem, PA December 2013 January 2014 Posi on Non-ApplicableLooking for workGUARDIAN LIFE INSURANCE COMPANY OF AMERICA, Bethlehem, PA March 2007 November 2013 Dental Renewal SpecialistManaged eciency and accuracy of all monthly, quarterly, and annually generated data reports for overall dental renewal ra ng targets vs actual, including any further ad-hoc repor ng using MS Access coding and MS Excel, with 3K data elements tests detailed below on rst point, and documented process for repor ng. Enhanced underwri ng processes, and so risk management, by tes ng all table-driven targets calculated and derived on Guardians web applica on renewal nancial system for systems data conversion for approximately 150 cases using MS Excel model including v-lookup to tables, each with approximately 20 components for approximately 3K element tests with hundreds of issues on factors found and xed, ensuring system accuracy by assis ng underwriters with addi onal tes ng. Improved sta s cal projec on accuracy by gathering data from disparate data sets for renewal nancial target analysis, ensuring accurate P&L projec ons of dental renewals needed on block basis using MS Access coding for analysis, then improved underwri ng accuracy, thereby assisted in managing risk, by preparing bi-weekly exhibits using MS Excel macros and pivot-tables, monitoring renewal targets vs. actual, ensuring underwriters rate-revising discre on based on need. Enhanced repor ng analyses by measuring how lapse rates correlate with rate increases for maximizing persistency-protability balance, using line-graph regression visualiza on analysis in MS Excel, ensuring quality and accuracy. Improved calcula on for renewal targets by instruc ng our VB programmer in a detailed fashion. Followed test protocols using MS Excel spreadsheet formulas for a renewal system. EDUCATION September 1992 - May 1996BS, Computer Science and Math dual major, Bucknell University, Lewisburg, PA, Cum Laude, 3.6 out of 4.0 GPA, high concentra on of Engineering and Computer Engineering classes including So ware Engineering for UNIX with C++ and OOPPROFESSIONAL AND PERSONAL COMPUTER LANGUAGES AND APPLICATIONS USED MS Access, MS Excel, MS Word, MS SQL, SAS, C++ emulated, VB, VBA, Java, JavaScript, NILS InSource Regulatory Informa on System, Beep, PC Encore, Citrix, APL, UNIX, DOS |
