Translates clients requirements to functional documentation; participates in technical designs and test planning  Designs, prototypes, configures, and tests new or enhanced applications  Performs customer support processes and activities for the implementation of new or existing applications  Monitors the efficiency and effectiveness of application operations and troubleshoots problems, as necessary  Participates in the testing of applications at various stages of development  Performs ad hoc testing on recently developed applications or application components  Prepares and analyzes defect-tracking reports on existing applications  Works with several business process modeling tools on a regular basis  Gathers details on the input, output, goals and event triggers associated with business processes  Interacts with business process owners to validate documented business process models  Modifies and updates existing models as business processes continue to change  Maintains the Care Centers Scorecard and performs any modifications that are requested by the business  Helped redesign and test SQL code for the Call Centers scorecard to convert the platform from CMS to UCR

 Promoted the full cycle approach including request analysis, creating/pulling data-sets, report creation and implementation and provided final analysis to the requestor. Developed advanced SQL to process data extracts from a variety of support systems and data warehouse tables Assured the integrity of project data and process, including data extraction, manipulation, processing, query optimization, analysis and reporting Implemented and maintained daily, monthly, and quarterly LOB and executive level reporting that enabled data driven business decisions Analyzed data, interpreted results and conveyed findings in a concise professional manner Managed the HAMP Underwriting and Servicing sampling process to be statistically compliant with MHAC regulations at a 95% confidence and 2% precision level  Designed and modified statistical calculations to determine sample sizes for 45 different HAMP audits using the Optimal Neyman approach and other statistical random sampling Maintained and modified Access databases that were used to create text files that were then converted in to HTML files that could be uploaded in to the ACES production and UAT testing environments Setup audits within ACES so that assigned analysts could perform their testing on the calculated sample provided Prepared as needed data-sets, reporting, and presentations for senior management

Ensure information is passing correctly from several administration systems to financial systems Assist Project Managers by completing project work for Nationwide Retail Services and Nationwide Financial Services Maintain financial systems by providing updates and system improvements where necessary implementations Formulate and define business transformation scope and objectives through research and fact-finding combined with an understanding of applicable business processes, systems, and industry requirements Design and modify moderately complex business processes and the corresponding information technology solutions. Analyze business and user needs, document requirements, and revise existing business processes as necessary. Guide and advise less experienced staff As the Disaster Recovery Coordinator, coordinate and assist in activities assigned by the Office of Business Continuity Management. Maintain and update the Disaster Recovery Plan for the NF Office of Finance and communicate changes to all managers within the department.

Maintain current knowledge of standard languages, coding methods and operations requirementsAnalyze existing program logic to determine the best method of accomplishing required changes or cause of program malfunctionPerform maintenance and modification of programs currently in production to keep them responsive to user needs and to assure efficient operation in the production environmentAssist in the design of automated portions of systemsDesign program logic to meet specifications and to adhere to prescribed standardsCode programs in an authorized languagePrepare test data and thoroughly test coded programs to validate accuracyAnalyze production programs to isolate problems or to determine more efficient methodsDocument and maintain program specifications according to OPERS standardsFulfill administrative reporting requirements

Completed the balance sheet and income statements for different lines of business each monthHelped convert Crossroads Pipeline Company from PeopleSoft 7.5 to 8.8Prepared FERC Form 2 reports for management as needed Completed audit schedules on a quarterly basis as neededParticipated on non-recurring finance related projects as neededPrepared and distributed accurate accounting entries, financial plans and regulatory reportsPrepared actual and projected data, as necessary, for regulatory filingsMaintained various computer programs and tables required to produce financial reports

Perform voucher processing, approval and check issuancePerform daily cash management transactions and reportingPrepare bank reconciliations for company accounts and supporting schedules for balance sheet accountsPrepare and post monthly general ledger entries and month end key indicating reportsManage, file and organize accounts payable documentationAnalyze and report financial statements to the CFO Prepare and submit monthly claim files and backup to the underwriting company