CAROL J. MAROTTI

SUMMARY

●Excellent skills in project management, design, development, test and implementation of business solutions

●Strong ability to communicate and collaborate with all levels of stakeholders to achieve business results

●Highly diverse and hands-on technical experience, in Salesforce, SAS, MS BI Stack, Informatica Cloud, Linux/Unix, and Oracle/SQL Server

●Experienced implementing BI, LOS, CRM and ERP solutions

●Strong background working in top tier companies learning best-in-class architecture in business domains including Sales & Marketing, Accounting, Finance, Operations, Supply Chain, and IT

●Exceptionally skilled at managing difficult and complex projects with successful outcomes

●Highly self-motivated with strong analytic and problem-solving skills

●Recognized as an effective communicator and team player

SOFTWARE/HARDWARE SKILLS

Reporting

SAS VA, Power BI, SSRS, SSAS, Cognos10, Tableau, Business Objects, Oracle BI, Crystal Reports

Analytic Solutions

SAS DDS, SAS CI, SAS DQ, SAS CSB, Varicent, SAP BW, jhaKnow

Programming:

PL/SQL, SSIS, T-SQL, SAS DI, Informatica Cloud, Python, C, UNIX/Linux, HTML/XML, EDI, VB

Operating Systems:

Windows, HP-UX, RedHat Linux

Databases:

Oracle 12c, SQL Server 2017, AS400

Core Systems

Salesforce, Jack Henry/Silverlake, Credit Quest, Digital Insights, Oracle OMS, JDA, SAP R/3, Mercury ITG

Other Software

MS Project, MS TFS, Visual Studio, Toad, SharePoint

Certifications

ITIL v3, Salesforce Admin, Salesforce App Builder

EXPERIENCE

Milan Laser, NE

9/2022-Present

VP, Applications & Architecture

Milan Laser is the largest laser hair removal company in the nation and the only one that offers the Unlimited Package: unlimited treatments for life at no additional cost. The Salesforce environment has 2400+ users across 300+ clinics with $45MM+ in monthly sales. I am responsible for managing the Salesforce platform and team providing direction on design, scalability and best practices.

●Design and provide technical oversight on Service Cloud projects, including the implementation of Omni-Channel, Email-to-Case and Amazon Connect.

●Manage several large projects, enhancements, tier 2 support for the mission-critical Salesforce environment.

nCino, IL

2/2019-9/2022

Solution Architect

nCino is a Fintech software company developing and implementing end-to-end Salesforce to enable financial institutions to digitize their Commercial/Consumer/Retail banking processes. I am responsible for the configuration and implementation of the nCino Bank Operation System for enterprise banks over $20B in assets.

●Configure and trouble-shoot Customer/Partner Portal, Commercial/Consumer Lending, Security & Access on the nCino/Salesforce platform.

●Work onsite with client to translate requirements into configuration changes and solution design.

●Develop/configure/troubleshoot changes on the nCino/Salesforce platform.

●Won award for North American Solution Architect of the Year 2021

Midland States Bank, IL

10/2011-2/2019

Director of Emerging Solutions/Enterprise Architect

Responsible for the digital and analytics platform strategy and implementation; including CRM, BI, and Data Management.

●Executed strategic analytics program delivering best-in-class CRM and analytic solutions achieving 90% adoption and 95% customer satisfaction ratings.

oSales and Marketing platform (Salesforce / SAS CI)

oReporting and Analytics platform (Salesforce / SAS BI / MS BI)

oIntegration platform (SAS DI / SSIS / Informatica Cloud / Python)

●Lead solution architect and developer, specializing in Salesforce, SAS, Informatica Cloud and MS BI

●Lead business architect and analyst, domains in Sales, Marketing, Finance, and Risk

●Managed program/project plans and financials for a $5M+ capital budget

●Managed 18-person team of internal employees and consultants on/off-shore on large-scale project

●Established service and support using SDLC and ITIL best practices

Smith & Nephew, TN

11/2006-10/2011

BI Manager/Lead BI Architect

Responsible for the design, development, and support of the Sales, Finance and Inventory Data Warehouses. Managed Global BI team across 5 countries.

●Managed $2M+ BI project to develop a global SAP data warehouse

●Designed and developed Oracle and SAP/BW analytic applications (Sales, Finance, Inventory, Supply Chain)

●Lead developer and architect, specializing in SAP/BW, MS BI, Varicent.

●Managed production support for the mission-critical Data Warehouse with over 3,000 users and over 10,000 custom reports.

ALSAC/St Jude Children’s Hospital, TN

11/2005-11/2006

Lead Business Analyst

●Responsible for managing projects and support activities for a team of IT developers.

●Designed and developed cell center interfaces and campaign management tools.

●Collaborated with marketing to develop campaign analytics for A/B testing.

●Managed data warehouse and mailings generating over $230 million in revenue per year.

ResultsPositive, AZ

2/2005-10/2005

Consultant

Responsible for the design, development, and implementation of IT Governance software (Mercury ITG / PL/SQL) for clients including Southwestern Bell, KBR, and Chevron.

Best Western International, AZ

11/2000-2/2005

Senior Programmer Analyst/DBA

Project Manager/Lead architect and developer for customer loyalty website application, mobile quality tracking, automated IVR system (PL/SQL, T/SQL, and Java).

Independent Consultant, AZ

8/1999-11/2000

Consultant

Designed and developed various PL/SQL applications (EDI interfaces, reporting, and supply chain management) for clients including Shamrock Foods and Dial corp.

JDA Software, AZ

3/1997-4/1999

Senior Business Analyst

Project Manager/Consultant for several large merchandising system implementations, including William-Sonoma, American Tire, Whole Foods, Wild Oats, and Deutsche Shell.

●Lead business and technical analyst for several large ERP implementations companies (William-Sonoma, American Tire, Whole Foods, Wild Oats, and Deutsche Shell)

●Conducted business process re-engineering sessions and client training.

●Designed and Developed PL/SQL interfaces to Financial, Purchasing, and Inventory Systems.

●Implemented finance and marketing analytic cubes

TOSCO/Circle K Corporation, AZ

12/1995-3/1997

Business Analyst

Project Manager and technical lead in the implementation of the corporate price book.

●Implemented corporate price book and performed advanced product category analytics for Marketing Intelligence (RedBrick, JDA, VB and PL/SQL).

Honeywell Inc., AZ

6/1992-12/1995

Software Engineer

Designed, developed, and implemented client/server tools and workflow applications used to decrease cycle-time, increase quality, and reduce cost in the factory.

●Developed analytic application to predict hardware failure in manufacturing process

●Designed and developed analytic applications in VB and PL/SQL

EDUCATION

University of Nevada - BS in Computer Science/Electrical Engineering, Statistics Minor

University of Phoenix – MBA (Marketing)

TRAINING AND AFFILIATIONS

SSIS and SSAS Training (PragmaticWorks)

ITIL Version 3 Certification

Delta Mu Delta

TDWI Chapter Member

SAP BW Training

SAS CI/DQ/VA Training

Salesforce Administrator

Salesforce App Builder

Salesforce Experience Consultant

Salesforce Sharing and Visibility Architect

Contact this candidate