Created process and toolset to mass update a large number of profiles to fix system security. The system contained hundreds of profiles the with overpromised access to hundreds of objects. Led a team of developers and worked with stake holders to clean to minimize access to each group without impacting their ability to do their job. The toolset allow automated system updates using Apex reading from excel sheets.

Build Out Community Portal SiteIntegration With Drupal SiteExpand FFlib framework to support non-trigger contextCreated a custom screen flow component using aura CMP to allow E-Captcha to be supported inside a flow hosted on external sites.Create a custom support invokable method (class) to allow public groups to be emailed when a record is added to a queue.

Build PDF Report GeneratorClean UP pre-existing production issuesGet SFDC Org back On track

Federal Client - VALERI projectProject Goal: Develop a Loan application and management system using lightning Salesforce platform.Developed/established 3 Standard methodologies for developing Lightning Components based on complexity and need.Designed and Developed class to dynamically check filed level security for the current user prior to launching a lighting component replace the standard and time-consuming methodology used and recommended by Salesforce.Designed and Developed an aura enabled rules engine to support validations for a complex process system where each process has different validation requirements and behaviors making validations for this functionality more maintainable, readable and easier to add and remove new validations.Developed several lightning components implementing a lightweight strategy making them easy to maintain.

Internal project: Build Salesforce team skill set and prepare team for deployment for consulting workRole Purpose: *Work with management to build a new Salesforce team to support new practice at Accenture.*Developed training program for new non-Salesforce experienced developers to prepare them for consulting and development work. *Performed duties of a trainer and technical lead for the team of 8 junior developers.*Provided ongoing support and advance training sessions while getting the new team up to speed.*Provided development support where trainees having issues on current projects.*Theses are on going responibilites as the team grows, and or changes

Internal Project: AFS SmartPurpose: To expand and migrate documentation storage, tracking, sales tracking, deal process and status from existing share point solution. Salesforce will severely reduce the dependency on Sharepoint improving tracking, organization, and reporting of critical corporate data.*Reviewed existing prior work on new application*Reviewed findings with PM to design a system to better maintain sales documentation in terms of access, security, improved search results, and organization.* Current system causing inefficacies due to disorganization and lack of security of documents.*Created structure updates to improve the flexibility of the system and extend security model support for new upcoming requirements.*Reviewed existing security model, found that is was broken and need to be overhauled.*worked with client and Project manager to address the issues* Implementation of Security is partially finished but blocked due to preexisting security system issues.*Created Automation processes to track and update related records based on opportunity and plan updates. Making it easier for sales staff to perform their job and give better access to Sales managers to key data and matrixes.*Created a user interface to maintain question sets on forms( i.e forms can now be updated without touch the visual force code).*Created a user interface to control Apex security model allowing admin to audit existing security permission by user or by record. Tool also allows edit of access level including revoking access.

Federal Client: SFR project Purpose: To migrate existing systems from an obsolete existing model into cloud-based solution using Salesforce. Primary focus: Employee training system and content delivery systems using Salesforce Knowledge.*Reviewed with Client tracking of employee training system (in the old system) to understand how it was working what was not working and what improvements they were seeking.*Purposed, designed and implemented Salesforce solution to replace the old system and improve automation processes to reduce future maintenance requirements.*Client struggling with article system used by employees inside of Salesforce, participated in several conversations on how it could be improved in terms of delivering relevant search results and homepage results to the individual employee based on role, interest and business needs.*Purposed combination of algorithms and querying designs to make major strides in improving search results. *Created user stories to support new design and successfully carried out implementation.*Created advanced search algorithms to manage Knowledge output to users based on article relevancy and User preferences using Visualforce and controller and support classes.*Designed advance multi-stage approval system for sales/opportunities; leveraging approval processes, task, workflows, validation rules, and triggers.*Created several complex automation systems to automate tasking, tracking, and reporting of the training system for federal employees of this client.*Created architecture to support training application and tracking*Created automation processes relating to triggers, junction tables, and system user records and profiles to filter and assigning of the training courses as course and users are added to the system.

Federal Client: Global projectRole Purpose: To provide development support correcting existing issues causing system execution failures. Create and lead the process for a major data migration into Salesforce system.*Developed Several Triggers and automation processes*Key trouble shooter solving system-wide issues with governor limits *Client system would occasionally fail exactions when working on customer account updates. Reviewed the system for the client to determine the cause of the faults. Determined that triggers were firing off in cascading and repeating sequence causing the system to hit governor limits. *Purposed and impeded a run once solution where each trigger (or trigger section) could only fire off once per execution. This implementation exposed several areas in the code where developers were depending on this behavior to successfully carried out operation (this a major violation of Salesforce best practices)* Worked with testers to further identify lost functionality due to trigger fix and created defect reports with a detailed explanation of the expected fixes for the related issues.* Defects were corrected and the system no longer faults during execution.* Worked with client to plan out major data migration* Reviewed existing data (dirty data) to formulate how a migration would be possible.* Resolved key consolidation issues where customers had several account records in the system causing fracturing of detailed records linked to several different accounts belonging to the same client.*Mapped migration process using Data Loader, Excell, Salesforce reports, heavily relying on v-lookups to properly map out key relationships.*Created data validation process to verify data integrity after migration*Created procedure and documentation to support migration process*Performed the actual migration to production org•Performed forced updates and data integration clean up processes to synch with all other system records.

Federal Client: SOW 9 / SOW 11 sep 15 mar 16Purpose: To review a failing statement of work prior to going to reaching the go-live date. The project has been running for several months functionality is intact. The application is hitting several govern limits when handling bulk data and is failing data and meta- data migration from DEV to CAT org.*On review Determined that the critical issue was in the code where it was not bulikfied causing the majority of the issues.*Created Epics and stories to correct the issue and deployed the workload to myself and others key developers*Secondary issues with Visualforce pages (user interface) unfriendly to audience (clients customer base)*Work with Client management team to understand the needs of the client and how they were to use the system. In addition learned that client privacy was somewhat lacking in certain areas and need to be addressed.*Created new requirements and goals to improve future client experience and to close gaps in the system security model.*Advised and assisted with client data migration from an external SQL-Server system into Salesforce. Worked with IT staff to identify which data (fields) was relevant to the new system and drafted plans to migrate client data from old SQL Server database into Salesforce.*Consulted on a customer issue where clients were replacing files in the system causing loss of data in the previous version of the file (done by other customers). Advised to create a file locking system which I was able to design and implement solving the issue.*Optimize existing code, fixing several governor issues limits and other code optimizations.*Create several Visualforce pages and controllers for P-Cori SF community.*Updated Security model for org.*Designed file locking system forcing users to check out and check in files. Preventing users from overwriting each other’s work or duplication of work.* Designed all test classes for Sow 9 and updated test classes from previous efforts.

Developed custom apps on SalesForce system to track client and agent activate. Setup several custom matrix's to track performance of agents and performance of financial products owned by clients. In addition set up custom algorithms and searches to determine and generate client data for purpose of future marketing and increasing company revenue via up selling and or policy replacement.

Preformed security audits for SalesForceDesigned Custom Apps for SalesForceAdmin for SalesForce systemsDeveloped prototype knowledge based system for hospital staff of North Bay Medical Center. Designed complex Data base to allow access to a library of short training videos and how to fill out any forms used in day to day operations.