Jeffrey McFelea, CPA
Accountant at GenTech Associates, Inc.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English -
Topline Score
Bio
Credentials
-
Certified Public Accountant
-
Experience
-
GenTech Associates, Inc.
-
United States
-
Business Consulting and Services
-
1 - 100 Employee
-
Accountant
-
May 2017 - Present
• Provide Government accounting services through utilizing various record keeping and software systems for the Department of Veteran’s Affairs including but not limited to reviewing and reconciling monthly reports, identifying errors, the nature of the error and the required general ledger entry to resolve variances • Assist in responding to inquiries related to payment inquiries, vendor specific information, collection and overpayment matters • Review suspense transactions resulting from payroll deductions and other entries to identify and recommend property accounting treatment • Identifies accounting problems, inaccurate records and reports, improper methods for document control, and lack of documentary evidence to support performance of reconciliations
-
-
-
-
Sr. Business Analyst, Securities
-
Aug 2016 - Nov 2016
•Participated onsite in the system conversion project for client from CSI to Broadrige. •Developed user acceptance test cases for FINRA 3110 program for email or postcard notifications in order to prevent fraud for changes in client or contact information. In addition, notifications for external wire or transfer activity to clients account. •Liaison between three business units, compliance, Broker Efficiency group and developer to coordinate the staging of test activity for UAT in the test environment.
-
-
-
-
Sr. Business Analyst, Independent Consultant
-
Nov 2013 - May 2016
• Provide technology and project management consulting services to clients through utilization of software such as: Access, SQL Server 2012, Excel, Business Objects, AS400 and Visio• • Effectively manage phases of project life cycle including cost benefit analyses, project plan development, resource allocation, key metric reporting, workflow diagrams, policy and procedure documentation and UAT • Create databases to efficiently reconcile data and generate senior management reports: variance, KPI, dashboard and metric reporting for senior management • Utilize VBA to control the quality of data outputs generated in Access and Excel reporting tools to more accurately quantify trends in portfolio performance and product sales • Assist in streamlining the invoice management processes through the use of Visio process flows, SQL queries and Access reporting tools • Act as liaison between business unit SMEs and developer to correct errors on billing statements and add additional items such as insurance and tax lines • Developed test cases to be used in user acceptance testing to ensure that the data feeds from the third party vendors where accurately being captured and processed in addition to difficult scenarios for the bucketing of the newly added functionality produced the required results
-
-
-
Residential Credit Solutions, Inc
-
United States
-
Financial Services
-
1 - 100 Employee
-
Senior Business Analyst, Information Technology
-
May 2013 - Oct 2013
• Responsible for maintaining SQL and Access databases designed to aggregate loan and pool level cash flow data required to facilitate external monthly reporting requirements • Spearhead initiative to convert existing reporting tools to newer technologies while maximizing utilization of the existing data warehouse ensuring that the newly created reporting tools are accurate and able to be delivered to the business unit for ongoing use in reporting and gathering data • Provide business unit partners with ad-hoc reports created through utilization of the data warehouse, macros and database queries resulting in increased efficiencies and data integrity • Create procedural documents, Visio process flows and swim lanes that summarize current reporting processes and identify opportunities for improvement
-
-
-
-
Senior Business Analyst, Investor Reporting
-
2012 - 2013
• Partner and cross train with financial reporting team to create reports provided to Corporate Accounting and Executive teams to monitor firm advance positions • Responsible for all facets of reporting and remitting to master servicers or investors on advanced securitizations • Assist with additional responsibilities as requested including but not limited to training new investor reporting associates, set up of new custodial accounts and reconciliation of acquisition data • Partner and cross train with financial reporting team to create reports provided to Corporate Accounting and Executive teams to monitor firm advance positions • Responsible for all facets of reporting and remitting to master servicers or investors on advanced securitizations • Assist with additional responsibilities as requested including but not limited to training new investor reporting associates, set up of new custodial accounts and reconciliation of acquisition data
-
-
-
Federal Home Loan Bank of Dallas
-
Banking
-
100 - 200 Employee
-
Securities Analyst, Derivative Accounting
-
2012 - 2012
• Responsible for the preparation, review and submission of trade information to internal and external auditors to facilitate periodic reviews • Assisted in the streamlining of reconciliation of trade files to mainframe system reports to increase efficiencies and accuracy • Recalculated swap resets and calculated cash flow analysis • Responsible for the preparation, review and submission of trade information to internal and external auditors to facilitate periodic reviews • Assisted in the streamlining of reconciliation of trade files to mainframe system reports to increase efficiencies and accuracy • Recalculated swap resets and calculated cash flow analysis
-
-
-
American Home Mortgage Servicing
-
United States
-
Financial Services
-
200 - 300 Employee
-
AVP, Data Analytics , Investor Reporting
-
2010 - 2012
• Manage Investor Reporting Data Analytics group consisting of four employees responsible for the maintaining the efficiency of the reporting system. • Serve as subject matter expert in the development of technologically superior reporting system designed internally to overcome reporting obstacles caused by increased economic distress and the need to mitigate losses incurred by investors. • Conduct audits of servicing data required to facilitate monthly investor reporting and remitting for entire servicing platform. • Create and maintain technological solutions including the automation of reports to reduce re-work and manual processes resulting in lower division overhead. • Developed Ad Hoc reporting for executive management on various lines of business including loss mitigation, bank reconciliations and servicing advances • Responsible for all portfolio stratifications and delinquency reporting for rating agencies including Fitch, Moody’s and S&P
-
-
-
-
Investor Accounting, Supervisor Master Servicing
-
2007 - 2010
• Developed and implemented controls, policies and procedures for the investor accounting department during the creation of the master servicing division. • Supervised two accountants to timely and accurately aggregate data from 14 servicers report to bond administrators for 18 securities while interfacing with internal and external business partners to ensure compliance with contractual and regulatory requirements. • Built and bucketed reporting on OTS and MBA delinquencies for rating agencies including Fitch, S&P and Moody’s • Utilized SQL for Ad-Hoc reporting out of SBO master servicing system
-
-
-
-
Investor Accounting, Assistant Vice-President
-
2006 - 2007
• Managed a group of 16 reconciliation accountants to ensure 600+ bank accounts were reconciled timely and accurately in accordance with investor guidelines and Reg. AB. • Developed an Access database to manage the workflow and distribution of accounts. • Created and performed routine between AS400 and SQL Server to resolve known data issues existing in AS400 for improved reporting accuracy • Construct routine and Ad-Hoc reporting on out of balance conditions within custodial accounts • Managed a group of 16 reconciliation accountants to ensure 600+ bank accounts were reconciled timely and accurately in accordance with investor guidelines and Reg. AB. • Developed an Access database to manage the workflow and distribution of accounts. • Created and performed routine between AS400 and SQL Server to resolve known data issues existing in AS400 for improved reporting accuracy • Construct routine and Ad-Hoc reporting on out of balance conditions within custodial accounts
-
-
-
Washington Mutual, Inc.
-
United States
-
Banking
-
Loan Accounting Operations, Senior Financial Analyst
-
2004 - 2006
• The project group consisted of four analysts. The group was responsible for working with various loan accounting groups to streamline processes via technology solutions. • Performed complex analytical projects involving complex computer modeling/forecasting to provide top management with definitive financial/trend data with minimal direction. • Responsible for the design, development and maintenance of Access database solutions to create custom reports and perform account reconciliation. • Created Ad Hoc queries and reports for upper management on various stratifications of the portfolio in addition to general ledger and custodial accounts
-
-
-
-
Investor Accounting, Business Analyst
-
2003 - 2004
• The Investor Accounting department was comprised of four groups: Investor Reporting, Treasury, Loan Reconciliation, and Cashiering. These groups were responsible for the accounting and reporting of loan level data. • Developed an Access database to reconcile incoming bank wires. Monthly volume averaged 4,000 transactions resulting in $80,000 monthly fee income. • Automated monthly reports via Access that resulted in greater accuracy and efficiency gains. • Responsible for communicating results to management.
-
-
-
-
Investor Reporting, Special Project Manager
-
2000 - 2001
• The Investor Reporting department consisted of eight associates responsible for accurately reporting the status of each loan to investors such as: RFC, Fannie Mae, and Federal Home Loan Mortgage Corporation. • Ensured timely and accurate reconciliation of 50+ custodial bank accounts. • Supported IR with AS400 query assistance and developed Access databases.• Performed the monthly portfolio walk forward on 600,000 loans for Treasury and Control. • Analyzed daily exception reports between AS400 and remote applications.
-
-
Loan Reconciliation , Team Lead
-
2000 - 2001
• The Loan Reconciliation department was responsible for the accuracy of the initial loan funding data to ensure the loan reported correctly.• Managed a group of Loan Reconciliation Accountants. • Reconciled incoming bank wires for escrow and trailing payments from loan originators/sellers resulted in the accuracy of beginning balances.
-
-
Loan Reconciliation, Accountant
-
1999 - 2000
• Performed various audits of initial loan data ensuring the accuracy of data, reducing or eliminating future potential losses.
-
-
Loss Mitigation, Specialist
-
1996 - 1999
• The Loss Mitigation department was responsible for negotiating resolution to delinquency of securitized and whole loan inventory in order to reduce losses incurred.• Managed a designated portfolio of loans in accordance with investor guidelines. Sought approval as necessary in order to facilitate closing of negotiated resolution
-
-
Education
-
1999 - 2002
University of Texas, Dallas
M.S., Accounting, Accounting -
1991 - 1995
University of Texas, Austin
B.B.A., Finance, 3.2
Community
