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 reporting.

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 and the BU was siloed in a way that created chaos in the environment. A colleague decided to leave which created an opportunity to create a new RDBMS environment that would allow the team to function at a higher capacity. I created the FRD and SOW that was quickly approved, thus allowing me to create a POC which lead to complete funding of a new server.Responsibilities• 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 maintenance/performance evaluation, and replication/backup strategy. • 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 tools (OBIEE), SAP Business objects, MSSQL(Stored procedures, views, advanced SQL writing), Sales Force and excel.• 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 maintained between two different servers. • 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. • Overcame numerous issues by providing good, better, best solutions to leadership team to make the best decisions that included impacts, risks, benefits, and estimated total efforts. • Became a certified administrator within 6 months for Xactly.

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 get their digital analytics to reveal loan funding conversion. Included development in parallel data warehouse, power pivot, SQL Server 2014, RedGate, Team Foundation, SDLC, Analytics Reporting v3 API, SFDC, Cisco Phone System and Agile Methodology.Responsibilities • 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 campaign was tagged with specific ad words to generate specific usage needed to track. • 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, Activity tracking, Tobacco Free or Breaking Free From Tobacco, Participation Activity Reports (PAR) by Location, Participation Activity Reports (PAR) by Employer, Data input Files loads from FTP Server by Employer to reduce turnaround time for each Employer on Annual, Semi-Annual, Quarterly, Monthly, Bi-Weekly basis. Scheduling Reports subscriptions, ETL packages, Email Notifications based on success or Failure on Production and Support those operations as per their schedules. I was heavily involved in requirements gathering, documenting those requirements and keep track of those requirements on daily basis.Responsibilities● 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 source, Oledb destination, Excel source, Oledb Command● 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 manipulation to maintain data consistency ● 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 packages in Development, Test, Production environments.

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 transform physiographical information to add a persona to each of the 3600 stores for modular recommendations. By utilizing shipment data and Retail Link data and data from Lowes, I was able to produce weekly reporting specific to demand planning and forecasting for potential opportunities of optimizing factory output in China. Responsibilities• 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 decisions and was delivered monthly. Responsibilities• 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.