F
Stephen Foli
***********@*****.***
Buford GA
SUMMARY
Experienced IT Professional offering over 8+ years of experience working with various technologies. I am a results-oriented information technologist who focuses and balances many complex initiatives without compromising quality. I have a strong business acumen with the ability to translate business issues into technical solutions. While still learning, I am experienced in almost all phases of development and analytical projects. Over my career, I have delivered proven
solutions utilizing a broad array of technology platforms. In addition, I am trustworthy, hardworking, highly dependable, and a great team player. SKILLS
TECHNICAL SKILLS / TRAINING:
CRM Analytics
Dashboard creation
Analytic Studio
CRM workflow development
Salesforce APEX and Visualforce
Reci[e/App Development
Dataset/Dataflow Development
Teradata Aster, Access, DB2, Postgres,
MySQL, Snowflake.
SDLC processes
ServiceNow
Database Tuning Wizard, Index Tuning
Wizard, SSIS, SSAS, SSRS, Microsoft
Clustering
MSDTS, SSIS, BCP, Data Migration, SQL
Loader, Import/Export Wizard, TPT,
Project Management Methodologies:
Agile
EXPERIENCE
Tableau CRM Developer
Buford/Remote, GA
First Citizen Bank/ Jan 2022 to Current
CRM Analytics Development Responsibilities:
● Understanding the needs of Stakeholders and converting them into easy insightful dashboards using the CRM Analytics tool.
● According to business requirements, create customized and standard dashboards, which helps business to take decision using data.
● Create customized recipes and dataflow to clean, and transform data before loading it into the dataset.
● Create a dataset from salesforce and external data.
● Maintain dashboard and dataset security using Apps and security predicates.
● Connect salesforce objects and build external connections in CRM Analytics. Salesforce Admin Responsibilities:
● Create user and assign various access using license, profile, permission set, and permission set licenses.
● Create new objects, prepare all fields for objects, create and assign various layouts to profiles.
● Implement security using various stages like OWD, role hierarchy and sharing rules.
● Use automation tools such as process builder, Workflow rules and Flows to automate business processes.
● Create reports according to requirements and implementation of a dashboard using various reports together.
Tableau CRM Developer
Remote, GA
T-Mobile/ Mar 2019 to Dec 2021
Applied various skills to evaluate, design, implement and optimize databases and database applications.
Planned, designed, and streamlined data structures for analysis. Developed, designed and optimized data structures for analysis. Managed all levels of internal analytics practice, including ETL, database administration, report development and integration. Analyzing and visualizing large volumes of data using CRM Analytics(Tableau CRM) Crafting and managing dataflow/recipes. Setting up Apps, Sharing and Security Predicates.
Building/maintaining dashboards and working with bindings and connecting with data sources.
Application building and deploying using continuous integration/Deployment (CI/CD) tools- Jenkins and Salesforce DX.
Planned, designed and streamlined data structures for analysis. Tableau Developer/Data Analyst
Wells Fargo Dec 2017 to Feb 2019
Developed various database objects and sourced disparate Framework data into a central repository for analysis and reporting in support of customer service initiatives Created visual representations of product categories and relationships, using Tableau dashboards to highlight desired aspects of key financial and performance indicators Personally analyzed data sets collected over time to identify relevant patterns and trends, producing visual reports for presentation to appropriate personnel Provided subject matter expertise development and Analytics Platforms to improve performance and scalability
Database design, data modeling, and deployments
Developed Various models in DBT for ETL
Creating HLSD documents (for new infrastructure and expansion) Developed ETL processes ETL load and update scripts to load data from various data sources into BigQuery, Postgress, Mysql, and other applications Participated in the advisory team to design and establish advanced analytic capabilities within Framework
POWER BI DEVELOPER/Data Analyst
Georgia Regional Hospital Jan 2016 to Nov 2017
Requirement gathering, administration, configuration Support (life cycle), and enhancement of existing and new projects
Analyze current ETL process, define and design new systems Design, develop, test, and deploy Power BI scripts and perform detailed analytics Create dashboards and interactive visual reports using Power BI Perform DAX queries and functions in Power BI
Designing and implementing technical solutions to satisfy both functional and functional project requirements ensuring quality, scalability, and meeting the SLA's Lead in Creating data models, test plans, technical designs, code review, unit testing, and documentation to support the business processes Database design and performing various administration tasks Developed various T SQL scripts and procedures to support MSCI, Bloomberg, CRD, Wilshire
Analytics, Portia, databases, ETL processes, and applications Setup AWS RDS/Azure SQL instances
EDUCATION AND TRAINING
Bachelor of Science
Winneba University Jan 2012
Ghana
CERTIFICATIONS
Salesforce Tableau CRM and Einstein Discovery Consultant Salesforce Administrator
MCSE (Data Platform)
ACCOMPLISHMENTS
· Design and apply KPIs, dashboards, and operational metrics using PerformancePoint Server — publishing them via Tableau to enable KPIs tracking in a real-time Tableau CRM Data Preparation Specialist
Tableau CRM and Einstein Discovery Insights Specialist Lightning Experience Reports & Dashboards Specialist