Loren Smith Email & Phone Number

San Francisco Bay Area

Louisville, Kentucky Area

• Managed database installations, backups, restorations, scheduled DTS jobs and resolution of failures• Generated database, schema, table, procedure, table, view, trigger, and function create statements• Designed ETL processes to incorporate disparate data from newly acquired assisted living facilities• Developed business intelligence reports and database administration dashboards using SSRS & SSIS• Generated ER diagrams and relational data models for new data structure• Configured linked servers and ODBC connections• Pinpointed performance bottlenecks using DMVs, profiler traces & query time & IO statistics information• Reviewed all SQL for adherence to established standards and structured to enable optimal efficiency• Generated SQL scripts required to process all corporate data extract requests• Refactored and tuned existing SQL stored procedures to ensure optimal query plan utilization• Created new and modified existing indexes to optimize application performance • Assessed the risk footprint of proposed changes to current data architecture• Automated DBA tasks using SQL stored procedures, SQL Agent, PowerShell scripts, & SSIS packages• Lead concurrent web application development projects from initiation through post go-live support• Worked with project stakeholders to define business requirements and set project scope• Translated business goals into functional requirements, technical specifications & use cases• Designed, implemented, tested, and deployed new web applications to test % production environments• Managed project, application, and user documentation including work breakdown schedules, traceability matrices, change control, data models, data & process flow diagrams, sitemaps, & job aides• Created and maintained project timelines, while monitoring resource time allocated versus budgeted• Published status reports to stakeholders detailing activity completed, in progress, & current action items

Louisville, Kentucky Area

• Organized business plans submitted to Board of Directors for proposed redevelopment assets• Prepared market feasibility studies assessing investment opportunities with $266M committed• Created financial models detailing asset’s historical, in-progress, and forecasted performance• Acted as a liaison between I.S. and all departments to develop competitor analysis application• Identified improved data validation techniques improving CRM’s information response quality & quantity• Developed applications utilizing web services and developer APIs to maximize data mining effectiveness, increase data collection efficiency, and improve dataset comprehensiveness & accuracy• Improved operational & analytical efficiency through the automation of data compilation & presentation• Compiled analytics presented during Wall Street Investor Road Show hosted by Ventas, Inc.• Managed the development and delivery of ad hoc and recurring reports and maps for Executive Team• Designed, developed, and maintained databases fulfilling strategic information needs not addressed or otherwise available through internal enterprise system applications

Louisville, Kentucky Area

• Designed and developed competitor database containing detailed information on over 12,000 senior housing properties, enabling the speedy calculation of any market’s level of saturation• Managed analytics required to assess the operational and financial impact of converting care pricing models for newly acquired assisted living facilities• Designed and developed database to track and analyze resident survey results submitted through the course of a three month trial concierge service partnership with an external vendor• Oversaw the logistics involving residents having to be relocated (both internally and externally) due to scheduled redevelopment project construction• Responsible for tracking resident apartments upgraded before, during, and after redevelopment project construction reached ‘substantial completion’

Louisville, Kentucky Area

“Top Producing Loan Advisor” Award, August 2007• Managed personal mortgage banking unit• Facilitated entire loan process from initial application through closing and follow-up• Analyzed customer’s income, assets, and liabilities to determine optimal mortgage solution• Aggregated loan application package and worked directly with Underwriters to meet the Underwriting Guidelines required to obtain loan approval and funding• Reviewed HUD Statement and entire closing package for accuracy• Communicated daily status updates with customers and supervising manager

Greater San Diego Area

Managed Accounts Receivable and Accounts Payable departments• Performed EOM reconciliations and journal entries to the general ledger• Implemented a new invoicing system improving efficiency & lowering overhead costs by 66%• Ensured timely invoicing of over $30 million in gasoline sales per month• Oversaw the integration of satellite office’s accounting operations• Worked with Sales Dept. & customers to resolve accounting issues affecting their account• Initiated processes to ensure more accurate billing and correction invoicing

Greater San Diego Area

Greater San Diego Area

Greater San Diego Area

Local Music, Apparel & Art Retail Store located in San Diego’s Gaslamp Quarter • Online Store • Event Productions* Featured in 944 Magazine, August 2005• Managed online and brick and mortar retail operation’s fiscal responsibilities• Maintained accounting records and generated financial statements• Prepared income tax documents, filed sales tax and forms required by regulatory agencies• Managed day-to-day operations as well as the purchasing of goods• Analyzed sales trends & implemented new strategies increasing revenue 113% YoY• Reviewed and assessed customer needs to ensure optimal inventory purchasing• Negotiated lower product costs increasing gross profit margin

Master Of Science In Information Systems

Specialized in: • Software Project Management and Development • Database and Internet Technologies

Bachelor Of Science In Business Administration, Finance And Accounting

Activities and Societies: Sigma Chi Fraternity, Varsity Soccer• Dean’s List: Fall 2000, Spring 2001

Education record