Jim Arnold

Freelance Database Designer & Financial Planner

624
Location:Dallas, Texas, United States
Profile:https://www.freelanced.com/jimarnold
0
Kudos
5.0
2 Skills
$80
Rate/Hr
CONSULTANT

Expert with forty two years of experience in Finance, Financial Planning and Analysis and Business Intelligence in firm’s ranging in size from start-up to NYSE listed. I combined all of my business skills for a very powerful combination in problem solving and product delivery of actionable knowledge.

• Developed the Analytical and BI systems for the 2nd Look and Streamlined Loan Modification as required by the US government for Fannie Mae encompassing over 800,000 loans with a portfolio value over $18 billion.
• Created Metrics/KPI reporting systems for Blue Cross Blue Shield an $11 billion health insurer to track performance against Medicare Part C and D contracts showing areas of deficiency in vendor performance.
• Developed a consolidating accounting system to track 250,000 domestic and international restatement entries for WorldCom (MCI) representing five years and $75 billion that provided information for the restated financial results.
• Built and managed the department that developed planning, forecasting and KPI/Metric systems that supported revenue growth from $2 million to $1.2 billion in seven years.

PROFESSIONAL EXPERIENCE

Retired Dallas, Texas 2009 to Present

Zen Analytics Dallas, Texas 2007 to 2009

Consultant showing companies how to gain competitive advantages through actionable knowledge.

• Developed the Analytical and BI systems for the 2nd Look and Streamlined Loan Modification as required by the US government for Fannie Mae encompassing over 800,000 loans with a portfolio value over $18 billion.

Resources Global Professionals, LLC, Dallas, Texas 2001 to 2007

Consultant providing financial and operational analysis and Business Intelligence services to Fortune 500 companies.

Resources Global Professionals, LLC is an $800 million Professional Services Firm.

• Created Metrics/KPI reporting systems for Blue Cross Blue Shield an $11 billion health insurer to track performance against Medicare Part C and D contracts showing areas of deficiency in vendor performance.
• Developed a data mining system allowing Allegiance Telecom to get corrected revenue amounts from a telecom billing system and file corrected municipal tax returns requesting over $2 million in tax refunds.
• Documented and reviewed business processes, requirements and metrics for a national retailer’s Warranty Center resulting in thirty recommendations one of which reduced billing cycle time over 30%.
• Developed a consolidating accounting system to track 250,000 domestic and international restatement entries for WorldCom representing five years and $75 billion that provided information for the restated financial results.

Arnold/Carrasco & Co, Inc., Dallas, Texas 1990 to 2001

Consultant providing Business Intelligence, financial and operational analysis and performance improvement services.

• Integrated six disparate accounting systems into a consolidated financial reporting system for a national home health care company resulting in the firm not having to hire additional personnel and improving information quality.
• Created multiple decision support and reporting systems for the Retail/SMB Pilot Integration group of this deregulated unit of TXU to be able to track actual against planned results after electric deregulation in Texas.
• Developed databases, associated metrics and reporting systems for tracking trouble tickets, circuit provisioning and testing of circuits for a start up ISP.
• Conducted a major product line review of a NYSE listed firm and showing them how to increase profitability by 200%, free up $1.5 million in working capital and avoid over $3 million in capital expenditures.

US Operators, Inc., Dallas, Texas 1988 to 1990

Start-up provider of Operator Telecommunication Services

Chief Financial Officer and Board Member

• Developed planning systems that allowed for the growth of the firm from $10 to $20 million in revenues in one year.
• Developed a cash flow management system with the ability to have an $850,000 book overdraft for seven days on a monthly cash flow of $1.8 million without a bank overdraft.
• Raised $2.5 million in leases and working capital line increases and $600,000 in private debt.

Sprint Communications Dallas, TX, Kansas City, MO, White Plains, NY 1980 to 1988

The third largest long distance carrier in the United States.
Prior companies US Telephone (1980 – 1984) and US Telecom (1984 – 1987).

Director-Corporate Financial Planning and Reporting Dallas, Texas

• Analyzed acquisitions and major vendor contracts resulting in the firm not signing a $100 million vendor contract nor completing an acquisition due to being overpriced by 175% saving the firm $11 million.
• Member of the finance team at US Telephone that raised $140MM in working capital lines, lease financing, private debt and equity placements and a $16MM IPO.
• Responsible for all planning and internal and external reporting including SEC and taxes.

Anderson Clayton Foods, Financial Manager Dallas, Texas 1979 to 1980

Tramco, Inc., Chief Financial Officer and Board Member Dallas, Texas 1976 to 1979

Texas Industries, Inc., Budget Analyst/Internal Auditor Dallas, Texas 1972 to 1976
______________________________________________________________________________________________________

CURRENT APPLICATIONS AND TECHNICAL SKILLS

Applications –MS SQL Server (2012) Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS), MS Access (Expert), Excel (Pivot Tables), Word, PowerPoint, Visual Studio2010

Process and Technical Skills - Defining business requirements and the business process dimensional model, JAD sessions, designing and populating databases, ERD, ETL, data warehouse construction, data analysis, data mining, data mapping, data visualization, KPI’s, Metrics, dashboards and scorecards.

_____________________________________________________________________________________

EDUCATION AND ASSOCIATIONS

MBA in Finance, University of Dallas 1979
BBA in Economics and Accounting, Southern Methodist University 1972

Languages - English and Texan

Member - Dallas Business Club, Executives In Action
Owner of Linkedin DFW Business Intelligence and Analytics Group