1. Meet with internal/external clients and stakeholders to determine needed functionality and/or enhancements
2. Identify business use cases, exceptions, and requirements
3. Develop wireframes, prototypes, and other project documentation
4. Create and present proposals and implementation timelines

1. Within Salesforce, Adobe Advertising Cloud/Experience Manager, Sugar, or similar customer/ marketing/content management tools, configure page layouts, relevant data fields and appropriate labels to support business needs
2. Modify backend database connections to support page configurations
3. Set data input validation rules, automated workflows, and hide unnecessary functionality within the CRM system
4. Create and manage account types, user access credentials, and plugins/extensions for end users
5. Develop and customize reports and data dashboards

1. For more advanced functionality, write automation scripts to aid in workflows
2. Develop plugins, extensions, or other new functionality in the relevant language supported by the CRM tool (e.g., Apex, Java, JavaScript, Python)
3. Code and style customized frontend forms and pages using HTML and CSS
4. Modify database/system backend services using servlets or customized software components

1. Verify data integrity and accuracy
2. Conduct or supervise user testing, behavioral testing, unit testing, or automated testing tools
3. Identify, resolve, and document bugs in customized code or CRM/CMS configurations
4. Conduct periodic reviews and updates to ensure features are working and any associated software updates remain compatible
5. Test pre-release components for compatibility before general release
6. Write user guides or develop tutorial resources for using custom-developed features

1. Conduct to a competent level all other necessary (employer specific) duties associated with the occupation

Successful completion and passing grades in Related Instruction

Completion of an Adobe Experience (AEM) Practitioner certification, Salesforce Certified Administrator credential, or comparable training as agreed to by employer

Completion of an AEM Developer certification, Salesforce Certified Platform Developer 1 credential, or comparable training as agreed to by employer

HTML, CSS, JavaScript, connecting to SQL databases, quick intro to JS frameworks. The purpose of this introductory course is to establish comfort and familiarity working in a code editor, writing and validating instructions in a markup language, and manipulating screen objects by changing properties and tags. Students are not expected to master or achieve skill as web developers, but should be comfortable and familiar with modifying web interfaces in the CRM/CMS platform or styling email templates. Topics include: 1. HTML structure 2. Text, hyperlinks 3. Images, tables, and embedded content 4. Tables 5. HTML5 features 6. Forms 7. Process 8. Design 9. CSS: color, text styling, boxes and layout, inheritance of properties

The purpose of this introductory course is to provide core skills in classical relational databases to help build skill and capacity around table structures and querying data. Topics include: 1. Core Database Concepts a. Explain core database concepts and fundamentals b. Analyze flat type, hierarchical, and relational databases c. Summarize data manipulation language and data definition language 2. Creating Database Objects a. Define data types b. Explain extracting numeric data and how to use built in data types c. Given a scenario, create tables, views, and stored procedures d. Explain SQL injections 3. Manipulating Data a. Explain how to update data and databases b. Explain how to insert and delete data c. Given a scenario, use queries to select and insert data 4. Understanding Data Storage a. Summarize how to use queries to select data b. Explain key concepts in normalizing a database c. Analyze primary, foreign, and composite keys d. Summarize clustered and non-clustered indexes e. Given a scenario, create a non-clustered table 5. Administering a Database a. Analyze sever and database level security b. Given a scenario, grant access and manage roles in a database c. Explain key concepts in database backups and backup devices d. Summarize recovery models and given a scenario, backup and recover a database

The purpose of this course is to extend the basic principles of web markup languages into a specialized language required by the CRM/CMS platform (Java in this case). Note: this section may be substituted for an equivalent course in C#, Python, or another available primary language as desired by employers participating in the cohort. Topics include: 1. Computers and components (accessing clocks, caches, registers, types of memory) 2. Numbering systems and computer math 3. Object-oriented programming principles 4. Java fundamentals (types, variables, branching, loops) for command-line scripting 5. Comments and documentation practices 6. Data Structures (ArrayLists, linked lists, stacks, queues, HashMaps) 7. Classes and Objects 8. Testing fundamentals (unit and integration testing) and test-driven development with Junit 9. Persistent data, external libraries, and advanced data connections in Java 10. Application development in JSP/Spring 11. Backend development with Spring Boot and REST service APIs 12. Authentication, authorization, and data security basics 13. Interfaces and interface design tools (brief crash course in UI/UX) 14. Using cloud services and application deployment in the cloud (if available at local training provider) 15. Version control and software development collaboration practices 16. Introduction to Agile development (Scrum and Kanban, comparison to Waterfall methods), with projects expected to model Agile practices 17. Basic introduction to design patterns and software lifecycle management

The purpose of this course is to learn the platform-specific tools, APIs, and methods for configuring, customizing, and extending the functionality of the selected tool. Most cloud-based CRM/CMS platforms provide reference courses and some sample materials hosted on their website, and this section may include more self-study than is typical of other Apprenti cohorts. Note: AEM and Salesforce are common requests in this role, but may also be substituted for other CRM/CMS platforms as required by employers. Topics include: 1. Developing forms and extended data models a. build structured documents b. create a data model c. become familiar with the navigation hierarchy d. create and design survey and form tools e. advanced data model configuration, packages, target mapping, and APIs 2. Developing web applications a. create web applications from existing templates b. create new applications from scratch in Adobe Campaign Classic c. manage web applications d. troubleshoot web applications 3. Managing data and workflows a. manage targeting workflows b. write efficient queries c. manage external data d. send a scripted email delivery e. load files from Campaign servers f. understand the basics of technical workflows 4. Building reports a. build produce, and customize reports b. reporting options and business use cases 5. Configure and manage Adobe Campaign a. configure secure, and standardize the platform b. standards, templates, and GDPR implementation c. administer user and folder access rights d. create Adobe Campaign templates and standards, e. deploy packages 6. Designing marketing campaigns a. implement marketing activities b. send cross-channel campaigns c. analyze and design recurring and retargeting campaigns d. design email content using the Adobe Experience Manager (AEM) content editor/templates.