Brian Skelton Email & Phone Number

San Francisco, CA, US

Sunnyvale, California, US

San Francisco, California, US

San Francisco, California, US

Responsible for all things ICM including project planning, scoping of work, prioritizing and leading a team of administrators within Xactly. Develop and maintain plan configuration inside of Incent and simultaneously support all Connect integration. In addition, responsibilities include enablement for Admins, sales organization, and support of implementing.

Austin, Texas, US

Supporting clients in their need for new Implementation as a dedicated Xactly Consultant. The support provided included creating of Functional Requirements Document (FRD), Integration Design Document (IDD), and Operation Guide. It also includes providing deliverables specific to the SDLC including a Prototype, UAT/SIT session and “Go Live”.

Charenton Le Pont Cedex, FR

• Originally hired as a contractor for a project specific to analyzing the current data solution and providing additional support in creating analysis for identifying errors in data warehouse. There were no BI developers.
• Server implementation for SQL Server 2016/2014. DBA functions include user security, data integration, database maintenance, indexing (cluster/non-clustered), Production deployments, stored procedure deployment, server.
• Responsible for performance tuning and improving job performane.
• Compensation reporting utilizing SSIS (SQL task, For Each Loop, OLEDB destination/Source, files system task, data conversion, aggregate, lookup, merge, OLE DB Command, Conditional split, derived column), Oracle BI.
• Developed data warehouse architecture specific to housing data that feeds Sales Force. This architecture includes transactional data for differential updates to occur. It also includes a replication strategy that was.
• Lead as a Liaison between the BU and IT in projects that included the creation of gathering all business requirements and technical documents for the IT department.

Dallas, Texas, US

• Acted as an embedded consultant from IT in the marketing department. My focus was to be the lead between Marketing and IT for all projects related to analytics, specifically Google Analytics. There was a big push to.
• Engineered the solution in Adeptia Suite for SQL Server 2012 that included SFDC, Google Analytics, Prime Path (Lender Management System), Cisco Phones that resulted in a dashboard specific to each campaign. Each.
• Dynamic integration was created in through the database architecture to pass specific parameters within the Google Analytics Cube. This allowed any user to create a report without constraints of additional integration.
• Engineered and supported power pivot reporting for the marketing team achieving a reduction in labor cost. This included SQL development of stored procedures, views and advanced sql script writing.
• Lead meetings with multiple departments to evaluate processing mapping, technology development, solution delivery, and integration.

Dallas, Texas, US

• Developed complete BI end to end solutions by building a data warehouse with ETL packages related to Claims, Claimants, RX Claims, Bio-metrics, Member Health Assessment (MHA), Employer Incentive Programs points.
• Developed Business requirement (BRD), Functional requirement (FRD) documents, keep track of changes in BRD, FRD documents.
• Designed complex SSIS packages with error handling as well as using various data transformations like conditional split, fuzzy look up, multi cast, data conversion, derived columns, Merge join, row counts, Oledb.
• Expertise in creating Indexes (clustered, Non-clustered Views, indexed views, complex stored procedures, User defined functions, Common Table Expressions (CTE’s) and appropriate triggers to facilitate efficient data.
• Performed Data dumps using MySQL Data dumps commands to create Development, Test, Production environments for newly initiated projects
• As a Developer I have implemented SSIS Business Intelligence Life cycle such as SSIS packages Configurations (XML Configuration, SQL Server, Environment variable, Parent Package Variable), Deployment, Scheduling.

Grand Prairie, US

• Developed complete BI end to end solutions by building a data warehouse with ETL packages related to Store of the community attributes (Wal-Mart) and Lowes Link. By utilizing ETL tools such as SSIS, I was able to.
• Developed Business requirement (BRD), Functional requirement (FRD) documents, keep track of changes in BRD, FRD documents.
• Develop Proof of concepts for collaboration in working sessions with key stakeholders.
• Designed complex SSIS packages with error handling as well as using various data transformations from Retail Link, Hyperion, and Microstrategy to SQL Server 2012
• Performed Data dumps using Retail Link, Hyperion, and Microstrategy Data dumps commands to create Development, Test, Production environments for newly initiated projects

US

• Developed complete BI end to end solutions by building a data warehouse with ETL packages that supported the solution for the Special Services department. The solution utilized multiple KPI that would drive business.
• Developed Business requirement (BRD), Functional requirement (FRD) documents, keep track of changes in BRD, FRD documents.
• Supported and maintained KPI reporting.
• Designed complex SSIS packages with error handling as well as using various data transformations from Avaya and LMS.