Jim Barnes Email & Phone Number

Portland, Or, Us

Plano, Texas, Us

Dublin 2, Ie

Senior Power BI Consultant responsible for establishing Power BI reporting infrastructure for a global service line for Accenture. Deliverables included templatized Power BI model extensible to entire service line client database portfolio, C# scripting to update the model via Power BI TOM API, PowerShell scripting to deploy and manage Power BI workspaces and deployment process via Power BI REST API. Technologies and tools include Power BI desktop, Power BI service, Power Query, M, DAX Studio, DAX, XMLA, TMSL, Azure SQL Database, SQL, Powershell, Visual Studio, C#. Full life cycle, greenfield project.

Baltimore, Maryland, Us

Automating various BI processes using both on-prem and cloud based technologies.

Aalborg, North Denmark Region, Dk

Implemented Targit proprietary BI platform at client sites. Supported existing client implementations including SSIS, SSAS, T-SQL, SQL Server based solutions as well as Targit proprietary BI stack tools. Built some API integrations for existing clients to expand the data available to enrich on-prem data.

Tampa, Fl, Us

Production support and troubleshooting for numerous client SQL Server databases, SSAS OLAP cubes, and SSIS ETL jobs. Developed numerous custom solutions for clients on top of BST Enterprise ERP system using internal BST development tools and Powershell. Upgraded numerous client BI artifacts to current release version including SSAS tabular models and PowerBI reports.

Clearwater, Florida, Us

● Production support for Florida State Reporting database application. Implemented fixes and enhancements per customer requests, Automated SSIS processes to enable customer self service.● Turned around and managed contentious client relationship.● Contract was renewed. Developed second generation FSR application.● SQL Server, Advanced T-SQL, SSIS, XML SPY, Red Gate tools

● Built DWH and ETL to load data from cloud based ASP. SOAP. xquery, TSQL, SQL Server 2016, XML Spy.● Built DevOps CI/CD POC process and environment with Redgate and APEX tools, GIT, Jenkins, Octopus, BitBucket and Bamboo.● Built SSIS packages and SQL Agent jobs to automate business processes and data acquisition.● Introduced SSRS to the company.

Walnut Creek, Ca, Us

Developed overall BI roadmap. Established BI Governance processes.Managed a team of BI developers in delivering key projects to the organization. Collaborated with key stakeholders across the organization in achieving coordinated BI strategy.

San Francisco, California, Us

Managed 2 programs of work concurrentlyWeb Analytics program – created processes and tools to support operationalizing web analytics framework across Wholesale Internet channel application portfolio.Project Portfolio Management program – managed shakeout of PPM tool and subsequent vendor selection process for new PPM tool

San Francisco, Ca, Us

Designed and developed BI solutions related to bank risk analysis and network security monitoring.Served as Microsoft BI and database SME for SharePoint development team.

San Francisco, California, Us

Supported IT audit activities related to off balance sheet derivative liabilities in response to Federal Reserve audit findings

San Francisco, Ca, Us

Managed the BI organization for Esurance, consisting of 23 full time and 10 offshore contract resources. Designed reporting platform strategy and execution plan for consolidating/retiring 5 legacy end of life reporting applications onto SSRS platform. Developed innovative approach for calculating Unearned Premium based on audit findings. Lead migration of legacy VSS database to TFS and updated database deployment process.

San Francisco, California, Us

Business Intelligence Capability Development ManagerBuilt the business intelligence function for the call center sales channel for Wells Fargo Advisors Lead/developed a SQL Server based sales and marketing data mart from scratch, integrating 18 upstream systems (including Oracle, DB2, Teradata and other sources) to paint a complete end to end picture of the call center sales operation from lead generation through account opening,funding, bank cross sell, and customer satisfaction.Developed customer segmentation experiment and related analytics to determine effect of Customer Profiling Model script on call center operations. Model was adopted based on experiment results and script was deployed across the entire organization, fundamentally changing howcall center reps interact with customers on initial contact.Developed operational and executive reporting packages delivered through self-service, ad hoc, scheduled subscription, and concierge modes, tailored to consumer requirements Implemented all layers of the Microsoft BI stack (SSIS, SQLServer, SSAS, SSRS) on SQL 2008 R2 as well as Power Pivot cubes, Tableaudashboards, and SharePoint distribution • Implemented automated data qualitytool for testing data integrity and validity • Built relationships with key ITstakeholders, marketing partners, and executive managementBI Application ManagerLead BI application development team supporting cross sell BI reporting application in Wells Fargo Wholesale Technology GroupSenior Project Manager- Wells FargoDeveloped cross sell activity valuation model. Presented the model to seniormanagement to gain organizational support for International Cross SellStrategies strategic projects, including “Gold Rush to Cross Sell” Incentivecompensation plan.

San Francisco, California, Us

Fraud Prevention Group – Online Bill Pay Assessed current state of the market for fraud detection and prevention software. Implemented code hardening and testing tool, enhancing security practices of bill pay development team. Managed vendor selection process for Bill Pay business intelligence platform Program Management Office – Online Customer Service Group Facilitated weekly project enhancement/integration sizing meetings. Coached technical managers on building project business cases/NPV analysis. Developed master project list for annual funding approval process.

San Ramon, Ca, Us

Built IT resource allocation process and supporting tool for IT PMO organization.

Walnut Creek, Ca, Us

PMO Consultant- CSAADeveloped a current state SWOT analysis for enterprise PMO organization and subsequent reorganization plan. Presented the plan to the executive committee (C level). Plan was adopted and reorganization subsequently completed.Created the project portfolio master schedule and process.Created a scoring model for assessing project alignment with corporate objectives.Developed project budgeting, cost tracking and reporting tools, and standardizedperformance reporting package for all portfolio programs and projects.

Worldwide, Oo

Provided project management and technical leadership to joint client consultantteams in delivering business value through large technical project implementations. Leadership responsibilities included client relationship management, business development, staff development, and recruiting. • Established a PMO for a large network security program ($24MM) for a national health insurer. Developed security risk mitigation scoring model to measure program progress • Managed a team of 18 Deloitte consultants in delivering a large B2B systems integration program.

Us

Delivered numerous greenfield application development projects for various Bay Area clients.

Mba, Finance, Strategy

Ba, Business Economics

Engineering

Ms Coursework, Software Engineering

Certificate, Systems Analysis, Design, And Management