Data Engineer & Business Analyst
Resume:
STEVEN J. AHLBERG
***** ****** **. *********@*******.***
Utica, MI 48317 https://www.linkedin.com/in/stevenjahlberg Cell: 586-***-**** DATA ENGINEER & BUSINESS ANALYST
Meticulous, results-driven, team-oriented Financial Analyst and Consultant with 15 years of professional experience in the accounting field. Adept at using practical knowledge of corporate finance and accounting to create clear and comprehensive financial reports to present to senior management. Able to meet tight deadlines and deliver superior performance on complex projects. Excels utilizing web scraping and predictive modeling to analyze strategies and business opportunities to optimize profit margins. Thrives being part of a dynamic team in a fast-paced setting. Excellent written and verbal communication skills. QUALIFICATION HIGHLIGHTS
PROFESSIONAL EXPERIENCE
Freelance Contractor Detroit, MI
Data Engineer & Business Analyst November 2019 – Present Google Cloud Data Engineer and Hybrid Cloud Architect to implement and maintain cloud APIs for business analytics across multiple platforms. Utilize AutoML and artificial neural networks to revolutionize business processes and solve problems for prediction, classification, and segmentation across a wide variety of business areas, including retail sales, marketing, risk assessment, accounting, financial trading, business management, and manufacturing. Design and customize automated reports and dashboards to summarize outcomes. Provide variance analysis with an impeccably keen human inspection element to ensure the data being fed into the machine learning training models is of optimal integrity and quality regardless of dataset size.
Install, configure, and manage service mesh proxies.
Deploy service mesh control-plane and proxies.
Centrally observe, discover, and monitor your microservices-based applications across clusters.
Define and manage multi-cluster services using open-source service mesh and multiple control-plane topologies.
Enable consistent policy enforcement across multi-cluster services.
Completed and passed full training course work as a CISSP. Thyssenkrupp Materials NA Southfield, MI
Sr. Financial Analyst/IT Accountant March 2019 – October 2019 Integrate SAP, QuickBase, various apps, Excel and Microsoft Office to maintain financial coordination efforts for information technology components procured for multiple international, national, and local projects. Customize financial reporting to allocate IT hardware and software being utilized between global business areas in manufacturing for aerospace, engineered plastics, industrial supply chain services, and raw materials processing. Analyze and maintain efforts to track and manage device procurement, charge allocations, software apps, licenses, and subscriptions across different f/x rates. Link and automate multiple schedules in Excel across multiple business areas, customers, and projects to reconcile Profit and Loss Statements along with actual vs budget Capital Expenditure Reports.
Maintain project expense reports and facilitate as an IT central hub for project cost tracking and reporting for 50+ projects.
Through research and analysis, recovered over $567,000 in previous unbilled expenses. Microsoft Office Cloud API Development Operations KPI Analyses ERP Systems Data Engineer Google Cloud Platform
Hybrid Cloud Architecture Business Intelligence Financial Analysis Strategic Planning Account Reconciliation Data Migration Risk Analysis Dashboard Development Python Programming Predictive Analysis Auto Machine Learning Consolidation Accounting Page 2 of 3
Freelance Contractor Detroit, MI
Consultant/Financial Analyst August 2016 – February 2019 Review company General Ledgers and reconcile accounts to consolidate and summarize their financial strength in comparison to industry trends. Analyze cash flow statements and KPI's using benchmarking to formulate next quarter projections. Compare actual vs budget operating activities and correspond to management about significant variances with explanations and/or suggestions on improvement. Also assist in bank reconciliations, A/R and A/P processes, capital asset management, and operating budgets.
Work for six different nationwide companies headquartered around Southeast Michigan reconciling general ledgers, consolidating financial statements of multiple cost centers, and providing asset management along with rolling 12-month financial forecasting.
Work independently with small, independent shops to reconcile accounts, tie out financial statements, manage inventory, review purchase orders in conjunction with the budget, and note opportunities for process improvements.
Dalto Consulting, Inc. Bingham Farms, MI
Consultant March 2016 – August 2016
Work with a variety of companies involved in a financial turnaround and profit enhancement. Design and conduct turnaround plans, cash management and control programs, insolvency analysis, creditors and parties- of-interest negotiations, due diligence, corporate financings and real estate workouts. Serve in official capacities as debtor-in-possession, trustee for debtor and receiver for companies undergoing a Chapter 11 proceeding, out- of-court workouts or liquidations.
Work with a multi-million-dollar restaurant franchise completing a Chapter 11 proceeding.
Project financials, due diligence, corporate summary, control analysis, and workout summary workbook for an international manufacturing company saving them $1.2 million.
Consult with Executives about turnaround plans, control programs, and cash management for multinational corporations.
Research and analyze competitors, demographics, and seasonal trends to strategize solid marketing plans.
Use customized Excel formulas to illustrate financial history, reconcile accounts that are out of balance, diagram trending data, and expound on cash flow analysis to formulate projections. SG Capital Group, LLC Southfield, MI
Sr. Accountant May 2015 – August 2015
Generate financial statements, budgets, and cash flow comparisons along with ad hoc reporting. Use rolling T12 income reports to graph trending financial and occupancy data in comparison with actual vs. budget variance analyses. Prepare pro forma reports to emphasize current and projected figures to be utilized in negotiations of acquisitions along with gaining investors to show returns on investment. Analyze current financial figures and trends compared to the pro forma budget and adjust accordingly.
Assess rehab costs of a property structure and 176 units following individual walkthroughs.
Detail lease audits to compile tenant and property data to be transferred over to our property management software, AMSI.
Assist Principal and CFO with preparation of collection reports along with demographic statistics for both cities and counties.
Set up control and standard operations procedures for a new corporate manual.
Orchestrate inter-company transactions to reconcile receivable, payable, reserve, and operating accounts from clerical, bank, and vendor errors.
Page 3 of 3
CSI Support & Development Services Warren, MI
Sr. Accountant September 2005 – January 2015
Prepare financial reports for senior management and assist auditors in annual reviews. Incorporate new and existing reports to formulate financial analyses for current operations and 40-year long term objectives. Generate annual operating budgets exceeding $1.8 million and prepare quarterly reports to compare actual costs to projected expenditures. Provide support in the development of presentations and ad-hoc reporting which analyze surplus cash and cash flow. Produce immaculate monthly reports and bank reconciliations to maintain the integrity of the general ledger and chart of accounts.
Improve financial comparison reports to enhance clarity of expenses and projections to increase the efficiency of financial management, prepare reserve draws, and utilize grants for eight co-ops.
Allocate complex charges, and journal entries adhering to GAAP and HUD regulations.
File tax returns and prepared governmental reports in compliance with strict accounting standards.
Scrupulously analyze and research reporting issues to improve accounting operations and reconcile accounts.
Train three new employees on accounting principles and company procedures.
Promoted five times: starting from Part-time Accounting/HR Clerk, to Accounting Clerk, to Sr. Accounting Clerk, to Jr. Accountant, to Accountant, to Sr. Accountant.
Experience with 1099’s, taxes, and insurance form procedures. CERTIFICATIONS
Google Cloud Data Engineer Professional
Architecting Hybrid Cloud Infrastructure with Anthos Specialization Algorithmic Trading and Finance Models with Python, R, and Stata Excel: Economic Analysis and Data Analytics
Meta-analysis for Data Science and Business Analytics Microsoft Power Automate: Advanced Business Automation RPA, AI, and Cognitive Tech for Leaders
Python for Applied Data Science
Python GUI Development with Tkinter
Using Power BI with Excel
Microsoft Excel: Using Solver for Decision Analysis EDUCATION
Walsh College
Bachelor of Business Administration & Accounting Processes Troy, MI
July 2005 – March 2009
Central Michigan University
Electronic Engineering
Mt. Pleasant, MI
September 2001 – December 2004
Contact this candidate