Aaron Lorentz Email & Phone Number

Wilmington, DE, US

Mount Pleasant, SC, US

• Plan and implement strategic direction for MarketingProfs technology and services, as well as manages the software and database architecture, development, and operations across all of the MarketingProfs properties..
• Hands-on full stack development of new and innovative business solutions such as interactive marketing tools, marketing automation, conversion optimization tools, content management systems, ecommerce platforms.
• Designed and developed SaaS products, utilized by Global 2000 clients such as Microsoft, Shell, Johnson and Johnson, Google, Comcast, Adobe and others
• OpenAI integration focused on original content to generate tailored guidance for internal and external marketing initiatives
• CRM and Marketing Automation Platform integration, such as Silverpop, IBM, Acoustic, Mailchimp, Sendgrid, Twilio SMS, and Salesforce
• SQL Server database management and development, SSIS, SSMS, SSRS, stored procedures and triggers, and overall database administration and optimization

• Internet business websites and unique marketing campaigns
• Shopping cart and e-Commerce website design and programming
• Web presentations, Internet seminars and client proposal development
• Manage contractors and project timelines and deployment.
• Development of client project plan matrix, assessment of deliverables and budgets
• Specializing in graphic design, web design, and internet programming

Los Angeles, CA, US

• Full website development and administration on.Net platform.
• Created complex reporting and analysis of large volumes of user data to support ongoing consumer behavior research.
• SQL Server database development and design, T-SQL, triggers and stored procedure development, and overall database management.
• Consultation on data management, data processing, and optimization of reporting.
• Developed student/alumni data management tools, user interfaces, and reporting tools.
• Business process automation via remote scripting and scheduling.

• Website development and administration, Classic ASP and.Net.
• Credit card processing and transaction module development.
• SQL Server database development and design, T-SQL, triggers and stored procedure development, and overall database management.
• Online form development and member tracking (e.g. Conference Registration, Election Ballots, etc.)
• Online community software development and administration.
• Business process automation via remote scripting and scheduling.

Charlotte, NC, US

• Developed Capital Planning application to support capital and strategic initiatives, including forecasting and depreciation modules, and capital approval system.
• Developed automated VOP (Views of Profitability) application consisting of ETL/DTS processes, FTP, mainframe data feeds, reporting modules, and supporting database design and development.
• Developed Project Management application to track and maintain project budgets, resource allocation, project phase details, project expenditures and variances, and automated billing.
• Highly detailed software documentation following explicit corporate software development methodology.
• Developed UAT test approach, Unit Test Plan, Implementation Plan, Conversion Plan, and data integrity validation scripts.
• Business process and data analysis to assure integrity of reporting and financial decisions, and advised on software and business logic efficiencies.

Boulogne-Billancourt, Ile-de-France, FR

• SDLC application development, using VB, Classic ASP, SQL, and JavaScript, for multiple automated production systems, forecasting, inventory tracking and maintenance, product flow control, shipping and receiving.
• Project manager, responsible for creating project teams, gathering requirements, software design and development, quality assurance testing, and full implementation of software packages in administrative environment
• Application design and programming for 500+ users, including Accounting, Q/A, R&D, Production, Finance and SalesLogix
• Supervise junior programmers to assure effective development and timeline compliance
• Complete software integration and end user application training using live demos, PowerPoint presentations, visual aides, and one-on-one tutorials
• CRM software design and development for national sales teams, including deployment, technical phone and online support, virtual software updates, and QA