Worked closely with business leaders in Finance, Legal, BI and Operations departments on optimizing algorithms for a
$10 billion revenue a year publicly traded energy company
• Automated regulatory process of Financial Regulatory department by creating a series of algorithms to predict
illegal trading patterns and behavior of 1000s of Orsted's commodity traders; effectively saved company millions a year by optimizing detection of illegal tradition patterns and behavior
• Worked on pricing algorithm to provide better forecasts of future wind farm energy projects
• Conducted Tableau training sessions to coworkers on best practices in data analytics and visualizations

Senior Data Scientist

Worked closely with senior management in Marketing, Business Development, Analytics and Operations departments to build automation tools and an executive dashboard providing strategic actionable insights
• Built automated executive dashboard in Tableau with over a dozen KPIs combining both economic data and company specific data to provide strategic actionable insights for both Business Development and Operations
departments
• Optimized direct mail campaigns and built automated lead generation reporting tool in Tableau pulling data
directly from Hadoop for direct mail campaigns; effectively saving company $100,000s per year in third party
consulting fees
• Created PowerPoint deck that was presented to executives at JP Morgan Chase Bank focusing on US residential
real estate market
• Built three data cubes for analytics departments that effectively doubled productivity of analysts on data requests

Worked closely with senior management team to launch and optimize new Personal Loan division that grew from $5
million in loan portfolio value to over $600 million today (currently one of the largest Personal Loan providers)

•   Automated underwriting process of Personal Loan division by creating an algorithm (similar to Rocket Mortgage)
to predict fraud and credit risk of applicants; effectively saved company millions a year by fast tracking low risk
applicants through underwriting
•   Created cash flow simulations for investors of various pricing models and risk scenarios using Python
•   Optimized both lead aggregator campaigns and cross-sell campaigns by predictive modeling and segmentation
analysis to increase both conversions and gross margin of lead populations
•   Created dozens of automated reports and dashboards in both SAS and PowerPivot for teams ranging from operations to marketing to capital markets, and for executives to fully track new Personal Loan division
•   Created fully automated commission report for all sales teams in SQL that involved over 1,000 sales agents and dozens of complex commission rules created by management
•   Worked on ad hoc optimization projects for Personal Loans division tailored around enticing borrowers to select
higher loan amounts
•   Provided training and mentoring to team members in both PowerPivot tool for automated report creation and python for cash flow simulations

Senior Reporting Analytics Analyst

Worked closely with PR department, product team (operations), and executive team to drive incremental revenue and reduce expense

•   Built predictive modeling algorithm that provides advice to investors about which properties listed on RealtyTrac
are the best deals; became a highly successful product for both RealtyTrac's B2B and B2C businesses
•   Saved the company $36 million annually in marketing costs by creating bi-weekly analytical reports centered
around housing market trends, census information, and HomeFacts information. This data was obtained by mining
RealtyTrac and HomeFacts' SQL database and is frequently reported by the media nationwide
•   Built new home sales forecasting model which is used to predict the health of the U.S. housing market; project is
projected to produce millions of dollars in additional PR value nationwide
•   Automated several reports nationwide via vlookup and pivot table onto an interactive real-time map from SQL
server (via SAAS cube) in order records team of vendor quality and price
•   Launched a new online widget that provided key metrics including market appreciation, sales trends, and the distressed market for hundreds of metro areas across the country
•   Managed execution of quarterly and annual presentations of financial statements of divisions performance and strategy for CEO and Board of Directors

Senior Database Analyst

Worked closely with CFO and Asset Management team to generate additional revenue streams and to reduce expenses

•   Led the negotiation, analysis, and valuation of City Gardens Apartment property which was purchased from Edison. Arranged the first-in-the-nation Fannie Mae Green Refinance Plus Loan for the property in the amount of
$19.4 million; worked closely with lender on due diligence and created pro-forma estimates on green energy
savings
•   Structured City Gardens deal so LINC would earn an estimated $400,000 more in revenue for 2012-2013. Also
worked closely with lender and appraisers on due diligence; performed analysis on green energy savings, and served as project manager for green construction project on property
•   Created custom pro-forma for Green Energy ESCO business that brought in a $225,000 innovation grant to the new business from Citibank
•   Built five year rolling budgets for all divisions of company with P&L, balance sheet, debt and cash forecasts.
Created reports and dashboards which were presented to the board of directors and operating committees
•   Created business plans and pro-formas for three new business initiatives: Green Energy ESCO, Property
Management, and Volunteer Consulting
•   Worked frequently on market research and comparable analysis on both a property level and dozens of vendors for partnerships

Senior Financial Analyst

Find out detailed information about Maciej Siedlecki,  in , CA

Maciej Siedlecki: in , CA

Maciej Siedlecki

Orsted

Ten-X

loanDepot

Renovo Capital

LINC Housing

University of California

University of California