An accomplished professional with a diverse background and expertise in SAS and SQL development, financial services, data analysis, electronic database report writing and oral and written communication, as well as a background in social services administration in a technical and non-technical environment.
SAS Developer/Business Analyst
Performs SAS development, testing and report implementation regarding several lines of business in support of Default Mortgage Operations Reporting, uses advanced macros, ODS output delivery and other technical reporting methods, prepares external reports for Hope Outreach, Fannie Mae and Freddie Mac, serves as line of business expert for Loss Mitigation unit, completed several banking, mortgage operations and credit risk compliance training courses, demonstrates critical thinking and knowledge of company databases to extract and analyze data, performs calculations and credit risk data analysis using excel functions to support reporting needs of internal and external customers.
Performed computer programming and data analysis, utilized knowledge of prescription terminology, medical coding and billing through use of Base and Advanced SAS, MS Excel and MS Access in preparing detailed utilization and prescription coding reports to support the Medicaid Fraud Investigations unit. Utilized knowledge of CPT and NPI Physician data, Fee for Service and Encounter data elements, also served as an ad-hoc member of SAS User group.
Business Process Analyst
Provided timely reporting and data analysis to project managers in the areas of time entry and labor hours analysis, project forecasting, risks and issues analysis, milestone and credit and related financial metrics analysis using weighted charts, graphs and resource analysis using MS Access and VBA MS Excel including macros.
Information Services Coordinator
Supervised the conversion of 200 electronic database reports from x-Base to Crystal reports to support University database. Designed, programmed, tested and implemented database reporting using SAS, SQL server 2005 and crystal enterprise 2008, supported several university foundations through financial analysis, auditing and monthly reporting, responded to customer service issues regarding adhoc reporting through assessment of information needs and provided expert customer interface, analysis, completion and distribution of data reports with emphasis on correctness and data accuracy.
Business Data Analyst
Developed, tested, and implemented database to support bridge engineers, represented the department at weekly integrated meetings to track progress of all projects regarding the official VDOT six-year plan, prepared special reports and updates to state and federal highway commission officials, bridge operations, utilized Oracle Discover 3.0 and Microsoft Access to facilitate data extraction, charts, diagrams and adhoc reporting.
Supported 53 end users which included troubleshooting network, hardware, software and administrative issues with computer peripherals, served as network administrator through assignment and maintenance of user accounts using Netware, maintained user logs and tracked all expiring passwords to ensure network security, managed replacement of all peripherals, tested all new equipment and tested several older pc's for Y2k compliance, assisted in updating all cat-3 lines to cat-5 to support the LAN system.
Utilized administrative and court ordered remedies to enforce child support, interfaced with court officials, handled customer service for both custodial and non-custodial parents, utilized wage garnishment and other remedies. Initiated and started satellite child support office in branch center area and managed administrative operations, analysis of support orders, determine eligibility for child support in terms of amount and terms of support.
Initiated collection from uninsured motorists and claimant's insurance company to recover loss payments made on behalf of insured. Developed and managed intercompany arbitration library to assist fellow claims personnel in maximization of arbitration cases. Responded to telephone inquiries regarding insurance subrogation claims
Initiated administrative and legal collection of past due installment loan and credit card accounts on behalf of private and commercial customers. Interfaced with customers to maximize collection results and minimize credit risk to the bank through payment negotiation, preparing accounts for judgment, loan recovery and charge-off in the event of serious delinquency.
Assisted in management of all phases of insurance replacement care rental business, handled scheduling of pick up and returns, handled maintenance of existing fleet and retirement of older fleet.
Recruited to learn all phases of United Way operations including campaign, marketing and communications, allocations and budgeting and information referral, served as lead on several human service and planning committees, served as lead on compensation survey project involving 30 member agencies. Served as broker/liaison between potential donors and United Way personnel to facilitate fundraising goals. Managed several campaigns through interface with company officials during campaign. Made oral and written presentation to potential donors to educate potential donors on importance of United Way services.