KIZITO ICHEOKOLO
Lynchburg,VA
Summary
IT and medical professional with over 10 years of diversified proficiency as project manager, Data Analyst, Scrum Master, architect, consultant, and admin offering 10+ years of success leading all phases of diverse technology projects; with around 10+ years’ knowledge in Tableau, SQL, Python, Excel, SFDC, SOQL, SOSL, SOAP and REST API, Salesforce lightning design, Sales Cloud, Salesforce Pardot, Salesforce.com CRM, Force.com. Platform as an Administrator and consultant in Salesforce.com with experience in, Salesforce Health Cloud, Salesforce Education Cloud with experience in implementation on Salesforce.
Overview
12
12
years of professional experience
Work History
Salesforce Business Analyst
ATBOD
08.2019 - Current
- Designed and oversee multiple Force.com development in the areas of Salesforce Lightning Components, Lightning Web Components, Lightning Process Builder, Lightning UI/UX, creating Lightning pages by using component app builder and use Data Loader for Data Migration
- Expertise in Lightning app builder and new application based on Lightning to have compatibility of the app in mobile, Tab and Desktop versions
- Developed Lightning Component Framework Knowledge of Salesforce Lightning Process Builder, Lightning UI/UX, app builder and creating Visual Workflows, salesforce support communities and Chatter groups
- Built reusable UI/UX components with lightning component framework and maintained Salesforce.com solution
- Worked with various SFDC Health Cloud objects like Accounts, Contacts, Leads, Dashboards and develop Lighting Components
- Developed test strategy documents and test plan templates
- Perform detailed analysis of business and technical requirements and designed the solution by customizing various standard objects of SFDC and other Platform based technologies like visual Force, Force.com API, Web Services and Lighting Components
- Interacted with the sales and marketing, accounts department, service department, customers in all their locations to gather high level requirements
- Performed data migration and manipulation using Salesforce.com tools and integration using salesforce.com APIs and gathered inputs from management to develop functional requirement
- Managing scrum master and making sure that product owner explains items in backlog clearly and created different business and technical documentation including Test Cases, Test Scripts, and Project Scope, Training manuals, BRD, FRD, TDD, RTM, Gap Analysis
- Customized and personalized Salesforce.com to fit environment's specific needs
- Setup apps, Objects, page layouts, related lists, tabs, roles, and profiles Set up validation rules, workflow rules, sharing rules and approval processes
- Created new user accounts and configure Salesforce.com to fit security needs at the user and organization levels Set up outbound/inbound messages, lead conversion process, email-to-case, web-to-lead implementations, business specific reports & dashboards, portals setup & app exchange package deployment and Chatter customization Oversaw the execution of test cases, review test results and report defects
- Created detailed test status reports in a variety of formats
- Advised on best practice for successful QA Led the service calls to the Salesforce.com technical support team for issue resolutions Directs and communicates business user team, vendor of cloud technology and on-premises infrastructure integration for Salesforce.com
- Oversee multiple platforms of lightning authentication and security, Canvas, Mobile SDK, and expertise in customizing standard objects Accounts, Contacts, opportunities, Products, Price books, Cases, Leads, Campaigns, Reports and Dashboards, Testing and maintenance.
- Reduced operational costs through thorough data analysis and implementing cost-effective solutions.
- Improved business processes by analyzing current practices and recommending optimization strategies.
- Enhanced company-wide decision-making by developing comprehensive reports on key performance indicators.
- Enhanced Salesforce efficiency by identifying and implementing process improvements.
Data/Business Analyst
Bausch and Lomb, VA
07.2017 - 08.2019
- Configured various Reports and Dashboards using Tableau and SQL
- Reduced operational costs through thorough data analysis and implementing cost-effective solutions using calculated field and joins in SQL and Tableau
- Streamlined project management with effective communication and collaboration across cross-functional teams.
- Evaluated potential investments by performing financial analyses to assess profitability and viability within the company''s long-term strategy.
- Conducted interviews with key business users to collect information on business processes and user requirements.
- Updated and developed scripts and queries to extract and analyze data from multiple sources using SQL and PYTHON
- Assisted with creating data cubes and OLAP models to improve data analysis.
- Designed and developed data pipelines to acquire, clean and process data.
Library Technical Assistant
Lynchburg University
05.2014 - 05.2017
- Enhanced library user experience by providing efficient technical assistance and support in various library operations.
- Promoted digital literacy among patrons through conducting workshops and one-on-one technology training sessions.
- Collaborated with librarians to implement collection management strategies, improving organization and accessibility of materials.
- Troubleshot technical issues related to computer workstations, printers, scanners, and other equipment used within the library setting.
- Conducted regular inventory audits, identifying missing or damaged items for replacement or repair.
- Maintained a clean and inviting library environment by performing routine shelving tasks and organizing materials according to established procedures.
- Supported interlibrary loan processes by coordinating requests between different institutions for resource sharing purposes.
Business Analyst
J. Crew Distribution Center, VA
07.2012 - 03.2014
- Built Excel reports that displayed incorrect posted claim payments and remittances for returning clients
- Performed complex data transformation tasks using Excel formulas to cleanse and transform customer claims data
- Built Excel solution to reconcile claim payment data for compliance auditing purposes
- Built Excel based reports that performed automated root cause analysis of unpaid claims; These reports increased employee productivity by 65%
- Built Excel reports that provide performed complex calculations and displayed claim payments / negotiations via Pivot tables and charts; These reports decreased claims processing time by 60%
- Wrote complex T SQL queries for data validation and to create reconciliation reports to resolve data discrepancies in claim payment data
- Performed medium to complex data transformations and cleansing in excel using formulas like VLOOKUP, INDEX/MATCH, IFS, MID and array formulas
- Manage interdepartmental implementation changes for daily and full conversion data extract files
- Worked with insurance companies to evaluate unresolved claims
- Created custom objects needed to automate existing processes within the organization's sales force
- This allowed the system to act as the central repository of data not only for all field personnel but for the entire organization
- Implemented and customized SFDC Service Cloud with specific record types/page layouts to translate
- Gathered and translated requirements from nontechnical end users and executive team through weekly meetings and department/end-user interviews.
Education
Bachelor of Science - Economics
University of Lynchburg, Virginia
Lynchburg, VA05.2017
Bachelor of Arts - International Relations
University of Lynchburg, Virginia
Lynchburg, VA05.2017
Skills
- SQL, Tableau, Power BI, Excel, Python, Jira, Azure Dev Ops, Informatica, Sharepoint, Agile, Scrum, Project Management
- Data Governance, Data Exploration, Data Profiling, Data Cleansing, Data Transformation, Data Mapping, Data Visualization, Reporting
- Salesforce Technologies Salesforcecom SFA, Apex Triggers, Apex Classes, Salesforce CRM, Classes/Controllers, SOQL, SOSL, VisualForce Pages/Components, Workflow rules, Forcecom Eclipse IDE Plug-in, Forcecom Sandbox, Forcecom Data Loader, S-Controls, Apex Web Services, Eclipse, Forcecom Platform (Sandbox, and Production) CPQ and Steelbrick Integration using REST and SOAP API, Batch Apex Triggers, Batch Classes, Schedule Classes, Wrapper Classes SOQL And SOSL, Visualforce Page, Controllers, Field Dependencies, Import Wizard, VLOOKUP, Validation Rules, Workflow Rules
References
Available upon request
Timeline
Salesforce Business Analyst
ATBOD
08.2019 - Current
Data/Business Analyst
Bausch and Lomb, VA
07.2017 - 08.2019
Library Technical Assistant
Lynchburg University
05.2014 - 05.2017
Business Analyst
J. Crew Distribution Center, VA
07.2012 - 03.2014
Bachelor of Science - Economics
University of Lynchburg, Virginia
Bachelor of Arts - International Relations
University of Lynchburg, Virginia
Similar Profiles
Elohor PalamaElohor Palama
SALESFORCE ADMIN/BUSINESS ANALYST at ATBODSALESFORCE ADMIN/BUSINESS ANALYST at ATBOD
Sharayah ContrerasSharayah Contreras
Freelance Web Designer at Endura WellnessFreelance Web Designer at Endura Wellness
Aviana BrownAviana Brown
Assistant Manager at ALDIAssistant Manager at ALDI
Jose CortezJose Cortez
Project Manager at M2L IncProject Manager at M2L Inc
Sarah ThorneSarah Thorne
Assistant Director of Admissions at Liberty UniversityAssistant Director of Admissions at Liberty University