Provide actionable intelligence to RA, RDM, Biz IL, and other teams by creating Salesforce and Power BI reports including paginated connected to Azure Databricks, Snowflake, Teradata, Oracle, and SQL Server.

Provide actionable intelligence to Fin Ops, Cloud Cost, Cloud Governance, Engineering Product, Finance, and Accounting teams; and Engineers, and Technical Program Managers; and Cyber Risk Oversight Committee• Power BIo Create and publish reports and datasets connected to SQL instance via Enterprise Gateway such as Top N Subscriptions, Tooling Cost, Accounting Journal Entry, OPEX Cost, and Gross Margin o Create and publish reports connected to Azure EA Portal, SSAS Cubes, Excel in OneDrive, Private Trello boards using SSO via API, and Salesforceo Grant access to workspaces, datasets, and reportso Schedule refreshes• Utilize CloudAware built on Salesforce’s platform to:o Import data using Data Loader and Data Import Wizardo Modify Objectso Run Dataflows, look at Datasets to see which Recipe is being used, and inspect Recipes to determine data sources and transformations in Data Managero Modify and delete Recipes and Datasetso Create Einstein Analytics dashboards containing Account, Breeze, Qualys, Ingress, and MDE metrics; and identify subscriptions purchased via Azure and AWS Marketplaceso Create lenses and dashboards using multiple datasets and custom SAQL querieso Train others how to modify SAQL and export datao Create CMDB Reportso Utilize Lightning and Classico Performed an assessment of who has access to create datasets which affects Citrix’s cost and can lead to dataset refreshes failing when Citrix’s row limit is exceeded• Write queries and export data from Google BigQuery datasets• Connect Excel to Azure Blob Storage• Download Usage Detail, Marketplace Charges, and Price Sheets by Enrollment from Azure EA Portal• Review Accounts and Subscriptions in Azure Portal• Perform SOX compliance audit of data transfer for completeness and accuracy• Write T-SQL queries in SSMS• Test SQL objects and provide approval to implement them in production• Interview candidates and make hiring recommendations

Provide actionable intelligence to Customer Care, Pricing, Inventory, and Finance teams.• Partner with team members to plan, analyze, design, implement, and support systems that provide actionable intelligence• Create Master Data Services (MDS) entities, attributes, domain-based attributes, business rules, and views• Create and/or modify SQL tables, views, functions, and stored procedures with CTE’s and merge statements• Stop and start SQL jobs when changing objects used by them• Collaborate with DBA team to implement changes to SQL objects in production environment• Create and/or modify SSRS reports• Collaborate with Web App team to implement changes to SSRS reports in production environment• Work with data from CDK’s Dealer Management System (DMS)• Modify SQL functions and stored procedures that comprise inbound feeds of data from vendors

• Manage Business Intelligence Program• Provide actionable intelligence to Program Managers, Director, CSIO, and ELT• Managed projects to select Security Awareness Training vendor and transition Secure Coding Training Program to our team while search for Program Manager was conducted• Interview candidates• Partner with Security Operations team; and Secure Coding, Security Awareness, Global Security Framework (GSF), and Sales Enablement Program Managers to plan, analyze, design, implement, and support systems that provide actionable intelligence which includes:o Creating SQL tables and views; and SSIS packages to load data into SQL databaseo Facilitating the automation of running PowerShell and Python code to extract data from Active Directory (AD), transform it, and load it into MyAbsorb’s site via REST API; and extract data from the site via REST API, transform and load it into SQL databaseo Led project to have a custom object like Cases created in Salesforce to process customer’s security questionso Co-led project to select tool to process RFIs (Loopio) which reduced time to process caseso Collaborating with ServiceNow team to: Implement catalog items Utilize variable sets and custom scripts to ensure actionable intelligence could be obtained Creating ServiceNow reportso Collaborating with coworker to modify a PowerShell script to extract data from AD to be uploaded to SANS siteo Designing and implementing an Excel workbook to store data used in Tableau dashboard containing policy grade and review metricso Creating, and distributing Qualtrics surveys to obtain net promoter score (NPS)o Creating Tableau dashboards connected to: SQL database, MySQL database, and Splunk which analyzes the effectiveness of FireEye, Fortinet Firewalls, Glasswall, IronPort, and McAfee in reducing risk Google Analytics that measure intranet usage• First person in company to connect Tableau to ServiceNow• Experimented with Python and extracted data from REST API

• Create SQL Server tables, views, and stored procedures• Create SSIS packages• Create Tableau dashboards such as the Services Partner, Call Center, and TRM dashboardso Consolidate data from multiple systems such as SalesForce and SAPo Consolidate data from multiple connections to SQL Server database(s), SSAS Cube(s), and Excel file(s)o Create calculated members using MDX and calculated fields• Use ODC to create PivotTables connected to SSAS Cube(s) in Excel workbooks• Work with IT to ensure the integrity of data in SQL Server database and SSAS Cube built for reporting during UAT• Work with IT to ensure the integrity of Services data in SalesForce• Perform ad-hoc data pulls from SQL Server databases• Provide technical guidance to others with a focus on SQL Server and Tableau• Provide business guidance to others

• Administered SharePoint siteso Created and modified sub-sites including Business Intelligence Centerso Created and modified security groupso Worked with IT to enable Excel Services on a siteo Created trusted data connections libraryo Created, published, and approved Office Data Connection (ODC)o Used ODC to create PivotTables connected to SSAS Cube in Excel• PerformancePoint Serviceso Created and/or modified key performance indicators (KPI’s), scorecards, filters, indicators, analytic charts, analytic grids and dashboards using Dashboard Designero Added Excel workbooks using ODC’s to dashboardso Deployed dashboards to SharePoint sites• Extracted, transformed, and/or loaded data from SAP and SalesForce into SQL databases using tools such as DBAmp and SQL• Created, modified, tested, and/or troubleshot SSIS packages• Created, modified, tested, and troubleshot SSRS reportso Sub reports; matrix, table, and tablix; filter data with parameters; and conditional formattingo Created, modified, scheduled, deleted, and/or troubleshot report subscriptions• Created Tableau reports• Analyzed stored procedures with Database Engine Tuning Advisor and implemented suggestions like creating indexes• Created, modified, tested, deleted, scheduled, and/or troubleshot SQL tables, views, stored procedures, functions, and jobs• Utilized Microsoft Project to manage projects• Utilized BizTalk / BRC / BRE• Quarterly Territory Realignmento Deleted and inserted Sales District Code to Vantive Territory Position mappings in SAPo Worked with others to create SalesForce Report of Territories that changed Vantive Territory Positiono Created SQL query to retrieve data from the SalesForce TRACS system to be used to review and process Territory and Sales Rep changeso Created SQL queries used to identify issues with the SalesForce TRACS system and created issues on the SharePoint siteo Connected to Cubes via Excel and identified issues with measures falling into N/A• UAT

• Key member of the SAP Material Master Data Team for the SALSA project• SALSA is critical to making SAP scalable enough to be used by CITRIX to grow beyond a billion dollars in revenue• Extract, transform, and/or load data (ETL) with Access, Excel, SAP, SSIS, and SQL• Install SQL Server 2008; and stop and start services• Migrate Microsoft Access database into SQL Server• Create, modify, delete, and/or troubleshoot SQL Server Stored Procedures and Tables• Create SAP QuickViewers including table joins to extract data such as MVKE, MARA, KOTD100, KOTD950• Execute SAP QuickViewers including in the background• Cleanse and transform SAP material data and create files such as characteristics to be loaded into SAP• Compare input files to output files to validate that the data was loaded into SAP• Utilize Citrix Access Gateway, GoToMeeting, and XenApp

• Extracted, transformed, and / or loaded data (ETL)• Create, modify, test, and troubleshoot SQL Server Reporting Services (SSRS) reports o Create, troubleshoot, and modify stored procedures used as data sets o Sub reports; matrix, table, and tablix; filter data with parameters; and conditional formatting o Deploy reports in Reporting Services and SharePoint o Create, modify, schedule, delete, and / or troubleshoot data driven and / or standard subscriptions• Analyze stored procedures with Database Engine Tuning Advisor and implement suggestions such as creating indexes• Create, modify, schedule, test, delete, and / or troubleshoot SQL Server Integration Services (SSIS) packages, stored procedures, jobs, tables, and views• Utilize SQL Profiler to troubleshoot issues with SSRS and other reports• Setup transactional replication by creating publication and push subscription using a remote distributor• Add articles to existing publications• Utilizing SQL Server 2008 in an active / passive clustered environment since 04/09• Getting familiar with Idera’s SQL Diagnostic Manager

• Extracted, transformed, and / or loaded data (ETL)• Administered 43 SQL Server 2000 and 2 2005 instances• Installed SQL Server and service packs; registered SQL Server instances; and configured, stopped, and started services• Created, modified, scheduled, and troubleshot SQL Server Database Maintenance Plans including Database Backups, Integrity Check, Optimizations, and Transaction Log Backup Jobs• Created, modified, and deleted SQL logins and users using SQL or Windows authentication including groups and assigning Server or Database roles• Setup SQL Mail and SQL Agent Mail• Created, modified, scheduled, deleted, and / or troubleshot SQL Server Operators, Alerts, Data Transformation Services (DTS), Stored Procedures, Jobs, Triggers, and Tables• Migrated databases• Restored SQL Server objects, databases, and instances including one to a new server when the old server died• Setup, monitored, and modified replication of data from SQL Server 2005 to SQL Server 2000• Worked with System Administrators and Network Engineers to ensure there was enough disk space• Worked with System Administrators, Developers, users, and vendors to create, modify, troubleshoot, and repair SQL Server databases including determining the minimum SQL permissions needed for applications to function• Worked with Computer Technicians and users to setup and troubleshoot Access front ends connected to SQL Server back ends via ODBC; documented it; and provided it to others• Worked with co-workers to plan, analyze, design, implement, and support a Change Management system with a SharePoint front end and SQL back end for the IS Department which included a calendar and e-mail notifications• Alerted System Administrators a server was down and worked with them to notify users, troubleshoot, and resolve issue• Delivered IS New Hire Training• Guided co-workers in creating, modifying, and troubleshooting Crystal reports