F

Stephen Foli

404-***-****

adtqpk@r.postjobfree.com

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

Contact this candidate