Data Analyst Management

Project *– Delta Airlines -Atlanta, GA

Lead Tableau Developer 08/2022 – 02/2023

Provide data visualization, data analytics, and data management for the Financial business unit Gathering business requirements and work closely with Stakeholders, provide an analysis regarding to reports mean. Weekly meeting for changes as needed. Worked closely with the data Modeling team to Validate numbers and differences. As a Tableau Subject Matter Expert advising on technics and development. Tableau Administrator Creating Site / Roles / Groups and Granting Users to Reports as Tickets were created in Jira. Background

Select Experiences

Expertise

Education:

● Canadian Institute of Business (1994)

● Universidade Braz Cubas (1992)

● Harvard Connect Manager (2020)

Member & Associations:

• Professional Association for SQL Server (PASS)

• Bay Area Tableau User Group

Cell 1-415-***-****

********@*****.*** • Tableau

• MS-SQL

• Financial Services

• Pharmaceutical

• Wine Industry sector

• Social Media

Functional

Industry

Victor Mansour

Business & Systems Integration Consultant

I have over 25 years of IT experience, 12 years of Tableau new versions. Data Modeling, Statistical Analysis, KPI Definitions, Business Interaction, Story Telling and Visualization techniques. Worked with Twitter, E-bay, Nike, T-Mobile, Coca-Cola, SC Johnson, Macy's, Pfizer, BOX,TIAA and many more. Using Desktop Developer

.Reader, Public, Cloud version, Mobile and Server. I have been in different roles development experience. I am part of the Tableau Beta testers for there & administrative Creating Dashboards, Installing Tableau server, Deploying Tableau to iPad users in the field, Creating different sites, Security, adding users, Automating Restores, backups, Server Migrations &scheduling report to be email in a .pdf format. Fluent in Portuguese. Innovation for global enterprises. Deep expertise – in both technology and business objectives - enables clients to rapidly transform their data management, data visualization, and analytics programs. Insights delivered via efficient, accurate, and tailored Tableau visual analytics enable faster and more effective business decisions. Experience in Cloud data architecture, BI system conversions / migrations / expansions, compelling Self-service visual analytics, implementation/integration

Round Rock, TX 78665

• Manufacturing

• Communication

• Entertainment

• Consumer Goods

Project 1– USAFA-Colorado Springs CO

Tableau Developer / Tableau admin and Trainer 01/2024 – Present Self-service enablement solutions to meet the new needs. Provide training the USAFA team to Define & Plan – define and implement business, security, and deployment requirements. Prepare Data – catalog, connect, query, wrangle, validate, and curate data for use. Develop & Test – design, test, iterate, and document visualizations and analytics. Deploy & Enable – publish workbooks and data; manage permissions, subscriptions and alerts. Trained USAFA users on how to convert CAMIS queries to Tableau, update the converted queries, and create new queries, and export queries. Format query results and publish them as workbooks or as view-only documents. Additionally, teaching to subscribe to published queries and workbooks. Documenting the customized training. Permissions management, Support to Tableau End users and developers. Site and workbook stats analysis (traffic to views, extract times, workbook sizes). Managing users and groups: Proof of Concept Migrating Tableau Reports to Power Bi (Total of 15 reports). Create, add, and manage users and groups, and assign permissions to access content. Create projects to organize content on the site. Using Python for data preparation in some cases. Monitor site metrics such as content usage, user activity, and success of extract refresh tasks. Troubleshoot user issues with a site. Managing content: Move content from one project to another, change ownership of a content resource, and promote and certify content. Managing schedules: Applying and Installing hot fixes, data connectors working close with the Network Team. Creating and managing administrators: Create and manage other server and site administrators. UI/UX design Collaborating with product managers and engineers to gather user requirements, Conducting user research, such as interviews, surveys, and usability testing Creating wire frames, prototypes, and mockups to illustrate design concepts Designing intuitive user interfaces that align with brand guidelines Iterating on designs based on feedback Working with developers to ensure design solutions are feasible and implemented Staying up to date with the latest trends, tools, Project 2– Bayer Pharmaceutical, Whippany, NJ

Lead Tableau Developer 04/2023 – 11/2023

Lead the application and development of multiple key dashboard, ds, managing teams overseas to meet aggressive timelines. Supported existing reports that consistently required changes, fixed, issues with the data, enhancements, these reports were consumed by the national and international team and were critical that all changes were performed in a timely matter. All the changes need to be documented in ADO. Using Python for predictive analytics. New reports were also a big driver as new data sources were being added a lot of SQL was required to link to existing data sources. New Insights page was created in a verbiage style report for upper management and to be sent out as a subscription form every Monday Morning. Comparing Market share, Current year vs Last Year, best performing brands and best performing clients.

• Power BI

• SSIS

https://www.linkedin.com/in/victor-mansour-8a6363257/ Project 6 – Twitter - San Francisco, CA

Tableau Developer /Subject Matter Expert 7/2019–12/2019 Identify and validate data sources for the dashboards and reports documented in the Deliverable section (“Dashboard / Report”). Finalize the report structures for the dashboard / report (mockups). Create MDR road-map for the remaining phases. Plan and finalize MDR data Design MDR logical data model. Design physical data model for MDR related to the dashboard / report. Design ingestion data pipelines and ETL with the use of Alteryx jobs for the dashboard / report. Design Tableau reports structures. Delivering multiple reports connecting to different data sources Salesforce data / Splunk / Oracle for projections, progress and users. (UI) Focuses on the look and feel of a product's interface, including the layout, visual aesthetics, and interactive properties. Creating the visual language that users interact with, and work to make it easy to use and aesthetically pleasing. Project 9 – BP - Dallas, TX / Remote

Tableau Developer Lead 09/2018 – 12/2018

● Team of 7, led three resources on how to design, create, implement functionality, publish, and monitor performance using Tabjolt.

● Total of 6 dashboards.• Creating data validation scripts with row count, Field count, size and size offile.Summary: measured supply and demand in a specific time and region of the country, displayed in a Tree map, where the nearest distributors was to relocated, One dynamic map accordingly with region.

Project 10 – Nike– Portland OR

Tableau Lead Administrator and Developer 08/2018 - 09/2018

● Designed and developed the prototype dashboard which included predictive analysis by inputting values to see the outcome. Dashboard data was based on Units/Dollars. Which gave the user the flexibility of changing from to other.

● Documentation on how to have the prototype be used in production.

● Managed offshore Tableau team.

● Developed 5 different dashboards.

● Worked closely with the Business analysts.

● Creating Road-map for the analytics team.

Project 7– TIAA- New York City, NY

Tableau Lead 04/2019 – 08/2019

Team of 15, led 4 off shore resources. Creating Data sets using views to obtain best performance experience with 4 dashboards, gathered business requirements, Drove technical meeting with the client in New York and Charlotte. Work sessions with the client on how they want to see the Dashboards and additional enhancements.

Created data mapping, data dictionary and bug tracker Some techniques used was to, one the data was refreshed reopen the report to cache the report using a script and scheduler. Creating multiple exaggerated data sets for specific roll up (Yearly, Monthly, Weekly). Summary: This was more to automate many of the manual process using API calls, gathering data from different areas of the business. In total there were 4 different dashboards were developed. Project 8 –AmeriHealth Caritas - Philadelphia, PA

Sr. Tableau Lead 01/2019 – 03/2019

●Provide guidance on platform architecture Contribute expertise in Tableau architecture and visualization best practices Identify gaps in needed architecture to support use cases Lead activities around data ingestion, modeling and implementation of visualization updates to meet business requirements• Driving all meeting and training sessions.

●Deliverable documented 16-pages that describes when to use specific visuals, for comparison of values. Summary: Mobilization Project, Best Practices, For Developers creating reports and Tableau server configuration. Tableau Clinics (One on One)issues with EU questions and challenges sessions were twice a week, along with submission of emailing questions. Created a 16-page document that describes when to use specific visuals, for comparison of values. Visualization Design Principles, understanding your audience and designing for them Visualization Design Best Practices. Project 4– Warner Brothers –Burbank, CA

Tableau Developer /Subject Matter Expert /Data Analytic Consultant 08/2021 -06/2022

Lead the application and development of quantitative frameworks to understand client’s vast portfolio of content, media, and digital product via Big Data. Provide executives with key business insights by synthesizing data sets and managing enterprise marketing & reporting technologies. Conduct data analyses to derive key findings and insights

(user behavior & engagement and email & marketing engagement) on content, media, and product performance. Comparison and effets to Migrate reports from Tableau to MS Power BI. Reduce hours to build/implement by automating reports and prioritizing highest impact engagements Data Management and Maintenance for Aggregated Data Pipeline in Snowflake. Build aggregate datasets using ETL principles that underlay insights and visualizations; have a strong point of view on what data to prioritize. Reduce ETL data discrepancy by providing production maintenance/support for all aggregated layer data sources. Implement data management dashboard and Tableau alert system to ensure data integrity and data quality of incoming data. Accelerate reporting runtime by creating new aggregated tables for new analytic requests. Project 5– Spectrum -St. Louis MO

Business Intelligence Developer/Administrator 01/2020 – 07/2021 Tableau Developer for many of business areas, Driving all client meetings with stake holders, gathering requirements. subject matter expert for Tableau needs. Support efforts to simplify and enhance the customer experience. Perform analysis and reporting to assess on the business, identify opportunities, and evaluate key business performance indicators and business initiatives. Creating data flows with Alteryx. Work closely with managers in the collection and processing of competitive data. Working collaboratively with colleagues in corporate marketing and peers in other regions. Identify trends and fact-based, actionable insights. Create detailed road map for reporting. Extracting reports from PostgreSQL user traffic and performance from the Tableau Server Project 13 – BOX– Redwood City CA

Tableau Administrator and Developer 01/2017 - 02/2017

● Troubleshoot existing Tableau reports, Performance recommendations, Report enhancements,, Benchmarking frontend and backend using Tabjolt and Powertools.

● Created a report that lists the top 10 reports that take more than 28 sec to render

● Recommendations to use a trigger method when the ETL process has finished to refresh the TDE's.

● Best Practice document for end uses and Data governance for the Tableau Administrator.

● Method to control the Tableau Desktop licenses when End users leave and licenses are reused.

Project 16 – NVIDIA– Santa Clara, CA

Tableau Architecture, Installing Tableau Server

●Three Different Environments: Development, Test, Production

●Authentication: Access Security: using AD Grouping Benchmarking

●Backup: Scheduling, Data Load Delivery Performance

●Optimization Caching.

●Creating layouts and templates for specific Departments for Power users Data source connections. Alternative Dashboard layouts (iPad Friendly Navigation purpose).

●Performance issues troubleshooting existing Tableau Reports created by some of there power users. Proof of concept – POC. Replicating some of there existing reports from Business Objects and OBIEE. Creating Scripts in TABCMD to Export reports in PDF format. Scheduling Backups and Restores as needed.

Project 17 – Coca-Cola - Atlanta, GA

Tableau Architecture, Installing Tableau Server

●Tableau Implementation -- Backup/Restore process and Configured Email Alerts.

● Created Batch Files for Logs and Scripts - Imported Users profiles (Full Name, Password, Role, Email) Total of 3794 Users

●Cleanup files (rolling 10 days backup)

●Group List and implementation, Scripting and Defining Security Roles for Folders and Sites. Project 14– Seattle Police Department- Seattle, WA Tableau Administrator and Developer 05/2016 - 12/2016

●Created multiple POC's, Coordinated Meetings to get Business requirements, User needs, finding different ways reporting.

●Documentation and processes as needed. Worked closely to configure and Upgrade the Tableau Server version. Knowledge Transfer sessions and one and one training.

●Created data triggers in refreshing the multiple datasets that were used. Using Windows Scheduler and Tabcmd's

●Tableau Server administrator created custom scripts for TDE extracts, PDF reports and HTML wrappers. Created the security groups, Sites, added all the users.

●Tableau Desktop version 10.0.2 Designed, Writing queries in creating views for the specific POC's. fine tuning, benchmarking and monitoring performance.

Project 15 – Southern Glazer's Wine & Spirits– Dallas/Florida Tableau Administrator and Developer 01/2016 – 08/2016

●Created POC’s, Coordinated Meetings to get input from the Business users and there needs.

●Using AIP Solution Redshift as the backend.- Tableau Desktop version 9.3.3. Designed,

●Creating 8 dashboards using two different data sets one with 40 million rows of data and the other with 245 million rows of the data.

●Performance tuning and monitored user activities. Project 11 – Pfizer– Peapack, NJ

Tableau Lead 03/2018 – 08/2018.

● Created all documentation for a migration schedule.

● Defining the architecture and Hardware specifications for their environments (Dev, Test, Prod).

● Created views in MySQL to the visuals used for the tableau reports

● Incorporating JavaScript wrapper around the Tableau visuals.

● Leading a team of 3 Tableau users onshore/offshore.

● Created 18 new Dashboards for Management the team. Project 12– T-Mobile– Seattle WA

Tableau Lead Administrator and Developer 05/2017 - 03/2018

● Operational Analytics Front End Tableau Lead Developer

/Administrator

● Develop Operational and Analytical reports for the Rebellion Solution Platform (T-Mobile Prepaid and

Postpaid services) in production: Created over 26 different dashboards

● Develop the Operational Analytics Dashboards - combine data from tools like Splunk, AppD, SiteCat, Rally, QC into a Data Lake and then do Visualization using Tableau / Alteryx including ETL - using client requirements/user stories

● Lead and participate in client demos

● Recommend new KPIs/dashboards based on client

feedback and product performance

● Collaborate with on-site/offshore operational analytics teams.

● Load. Delivery Performance Optimization Caching. Creating layouts and

● templates for specific Departments for Power users Data source

● connections. Alternative Dashboard layouts (iPad Friendly Navigation

● purpose) Performance issues troubleshooting existing Tableau Reports

● created by some of their power users.Proof of concept – POC.

● Replicating some of there existing reports from Business Objects and

● OBIEE. Creating Scripts in TABCMD to Export reports in PDF format.

● Scheduling Backups and Restores as needed. Tableau Consultant for

● Pharmacyclics. Presentation Pros and Cons Spotfire, Qlikview and

● Tableau POC using there data to create reports in Tableau

● Proposing Infrastructure Architecture and solutions to problems

● encountered in there data. Environments: Development, Test,

● Production, Benchmarking, Backup: Scheduling, Data Load. Delivery Performance

● Optimization Caching

Project 19 –Sr. Business Intelligence Developer/Database Administrator Kendall Jackson Winery. Santa Rosa, California USA April 2013 – January 2014

● Scripts using SSIS, SSRS and SSAS.

● Migrating MS-SQL 2008 to MS-SQL 2012.

● Rewriting many process that Data Objects (SAP) were using to process data and data extracts using SQL Script.

● Designing ETL processes using Visual Studio. Data extract from the AS/400.

● On Call 24 hours, troubleshooting data issues in the middle of night. Using the Pragmatics and Red gate tools.

● Scripting to send out alerts that data is accurate to the specific end user. Writing scripts to fine tune indexing.

● Reverse engineering Business Objects Reports using SSAS and SSRS

● Introducing Microsoft Power Pivot and Microsoft Power View Creating SSAS cubs for specific Departments.

Project 20 - Sr. Business Intelligence Developer (Full Time) Doremus. San Francisco, California USA August 2012 – March 2013

● Purchasing, Setting up, and configuring a MS-SQL 2008 R2 server for Data warehouse purpose. Writing scripts using SSIS, SSRS and SSAS.

● Purchasing, Installing, Setting up and Configuring and administering the Tableau Server Version 7.

● Creating Dashboard, Scorecard and Reports Card concept as needed using Tableau Desktop and Tableau Server (Versions 7)

● Designing ETL processes.

● Defining Data sets such as Google Analytic, MediaMind, Facebook, Twitter, Bright Cove, Resolution Media and Radiant6

● Define and Design Dashboards, Scorecards and Reports Writing Scripts to send out alerts that data is accurate.

Project 17 – Position: Senior Consultant (L4)

Tableau Lead for Brocade Networks

Defining architecture and Hardware specifications in a VM. environment and on-site server. Worked with the Brocade network team defining the Single Sign-On. DHCP routing to the Tableau Server..Hierarchy on the Tableau Server by Site (Department), Groups,

Dashboards, Workbooks and users.Scripted by adding multiple new users using the TABCMD commands.Scheduling Exports of existing Reports into a PDF and sending them to the End user by Email using TABCMD on a daily basis Creating and implementing HTML wrapper using the internal portal to connect to the Tableau Reports for upper management. Fine-tuning, Queries Monitoring trouble shooting using Interworks, alteryx and Tableau’s Performance Recoding Feature. Development of 19 Dashboards in 8.1 and 8.2 re-engineering existing reports from Business Objects an OBIEE. Brocade introducing new data sources in this case was Hadoop and Sales Force. There were Limitation s using the Tableau connector which is a third party (Hadoop - Horton Works), it only allows 1000 rows of data daily. I suggested having the data warehouse create a data pull on a daily basis and have it available to aggregate,Calculate and Cross reference with other data sources.

Project 18 - Tableau Lead for Onyx/Amgen Pharmaceuticals Amgen pharmaceuticals acquired Onyx and requested to have all servers and application be running on the Amgen domains. How the Tableau Server was on the Onyx Server it required an Installing and Migration. Two principal elements were Active Directory and all the Tableau Server Users. Proof of Concept (POC) - Using the Tableau Cloud version and Connecting to EC2 or Microsoft Azure. This was to determine of these technologies could be used. Conclusion The cloud version is still new and has a lot of missing components from what is available in the On-site version.Creating a task list defining architecture and Hardware specifications in a VM environment SQL Server Configuration, Creating SSAS cubes. Migration of Users. Workbooks, Security and Server Licenses. Upgrading there Tableau Server version. 8.1 to 8.2. Benchmarking Old and New Environment. Creating ETL process to clean raw data Creating a SSIS packages. Coordinated with the Tableau Sales team for additional License Discounts. Amgen was interested in the usage of the application. Implementation and roll out Tableau for iPad users using Juno Pulse as a VPN tunnel to connect to the Tableau Server many of the existing reports needed to be revisited because of performance issues

(Aggregating, reducing Filtering and Calculation done on the Tableau Side) One week of Training for the Amgen Team this included Documentation hands on the usage of Tableau Desktop.Creating 12 new Dashboards for the Amgen Management team.Support for End Users with tableau issues.Tableau Consultant for Nvidia Corporation Tableau Architecture. Installing Tableau Server Three Different Environments: Development, Test, Production, Authentication: Access Security: using AD Grouping. Benchmarking. Backup: Scheduling, Data Using PL-SQL, Crystal Reports, IBI, Webfocus and VB (Visual Studio). Support role using JIRA and Sharepoint., Data mining and creating new Reports on Request.Automating data loads. Supporting legacy systems that were programmed in FoxPro, Visual Basic, VBA, Source Safe and Clipper 2003 - 2004

PC and SAS backend support for affiliated distributors.PC support High level user satisfaction, supporting over 90%remotely for all PC and server support.Support Calls resolved in a timely matter.Windows XP rollout for the Affiliated Distributors,Documenting and creating computer images for specific needs for the affiliated distributor;s network.Using Ghost and having customized images for individual sites. Deployment, Testing and Configuring of iPAQ’s. Support and scripting for Symbol RF Handheld units. Server migration.

2002 - 2003

Setting up demos for Albertsons (AIMS) and Food Lion (ROAR). Coordinating with the purchase, Installation and licenses for the dedicated Server (PHXAPP001), installing the appropriate software. Completion of the front end for the AIMS. All the reports that were generated on the server was designed and executed.Documenting all procedures. Using Java, HTML and JavaScript report writer for the AIMS application Placing procedures to extract and place weekly data. Receiving flat files from Albertson;s via FTP procedure. Learning and using the Auto Pilot utility used by JDA to create auto script for shelf sets.Putting together demos for the specific chains with requirements that the user has requested. Having direct communications with the users.Recognizing all the needs for the user by incorporating all addictions for the application. Listening and relaying the problem to the correct Group

(Data Security, Network Engineering Dept.) On top of problems keeping management in the loop of current problems and their current status. Listening and investigating options to resolve problems. Problem solving finding the correct channels to get the work done in an accurate and timely matter. Having a communication dialog with the end user for upgrades and modifications. 1998 - 2002

Programming utilities for SMIS and DOE in Clipper environment, First line support for all the Distributor SMIS Communications. Setup SMIS/DOE image for the computer rollout which was rolled out to over 500 distributor;s nationwide.System administrator for the Remote Connect Manager/Sterling Commerce/FMM communication supported close to 1200 users. System administrator for DOE communications (Client Access/ASYNC).Maintained all updates for the FMM computers which consisted of writing scripts in Visual Basic, VBA and pushing updates, Virus Definition, Service Packs, Hot fixes to clients in the field. Responsible for the processing SMIS numbers that were received from distributors that are part of the Gallo Network for FMM reports. It consisted of using Telnet, UNIX, Oracle tables and Visual Basic GUI interface Responsible for creating and distributing FMM reports for new product reports generating close to 12000 reports on a weekly basis and distributed to the FMM users Nationwide.

Conferences:

Campus Technology: Location: Seaport World Trade Center. Boston, MA July 19-22 2010. Tableau Customer Conference: Location: Sheraton Hotel. Seattle, WA Aug 30-Sep 2 2010. Digital Analytics Association (Symposium) San Francisco 30-Aug-2012 Training, Membership & Associations:

●ACM- Association for Computer Machinery

●Microsoft TechNet

●DAA – Data Analyst Association

●Member of SQL Pass

●Bay Area Tableau users

●Tableau Beta Testing Group

●Thoughtspot

Project 21 – Sr. Database Administrator and Developer (Full Time) Touro University. Vallejo, CA Nov 2009 – July 2012 Defining architecture and Hardware specifications in a VM. environment and on-site server. Worked with the Brocade network team

● Purchasing, Setting up, and configuring a MS-SQL 2008 R2 server for Data warehouse purpose.

● Consolidate multiple data silos that exist on campus to one location.

● Scheduled data extracts on a daily basis,

● Sophisticated stored procedures and triggers to provide complete technical solutions.

● Using Advanced DTS Packages and well as scripting Language for data scrubbing and data mining, build internal/external

● interfaces, and support currently developed for the Server.

● Use expert knowledge of MS-SQL Concepts, Using development tools such as SQL-Developer Suite 10g toolset and

● programming languages such as PL/SQL, and MS-SQL, PL/SQL

● BI Reporting tools Tableau and Cognos,

● Diagnose/resolve technical problems independently, articulate and discuss solution with peers in a confident manner with

● a view to getting input to provide the best solution.

● Multi task in the fast-paced, production environment to juggle priorities as needed to provide resolution to high profile

● technical issues.

● Diagnose performance issues using SQL trace technology as well as database explain statements and ability to analyze

● output of these traces.

● Creating reports as needed using Tableau Desktop, Tableau Public and Server versions, the reports are shown in a

● Dashboard,

Project 22 - Sr. Program Analyst (Full Time)

E & J Gallo Winery Modesto, California USA 1998 – 2009. Experience Summary:

● PL-SQL scripts (Using SQL Navigator) to automate data loads of winery sales sent by the distributors, the scripts were created to filter data that was sent to the winery, the code included exceptions to extract bad data.

● Created Triggers, Store Procedures and Packages.

● I was responsible to test, optimize, and debug the PL-SQL Code. Always looking new ways to improve the process.

● Team player that deployed the ordering products for the winery the application was written in Java I used tools such as

● Eclipse/Websphere the usage of Ajax and struts my role was to develop the front and backend of the allocation of a specific brand to a specific region of the country. In the last 2 years I was supporting and writing new functionality to the application. Many reports were generated using IB (Webfocus) I. Many of the reports were created on demand by end users.

Contact this candidate