computer consultant
Resume:
TROY D. SAPPINGTON
***********@*****.***
Highlights:
Twenty+ years general IT experience, fifteen+ years management experience, ten years teaching college level classes.
Twenty+ years of experience in the IT industry specializing in the field of Data warehousing and BI.
Twenty years of teaching and development of MicroStrategy, 10 yrs. Tableau.
Twenty years of experience at architecture, administration and development levels in MicroStrategy products including MicroStrategy Developer, Administrator, Intelligence Server, Web, Mobile.
Twenty years of Data warehousing experience with expertise in Data Modeling, OLAP tools and SQL.
Proficient in MicroStrategy using Oracle, Informix, DB2, Teradata, SQL Server and MS Access.
Manage IT projects and systems administrator, architect and technical lead.
Technical Skills:
BI Tools: MicroStrategy, Tableau
RDBMS: Snowflake, Teradata, SQL Server, Oracle, DB2, Informix, MS-Access,
ETL: Alteryx, SQL Server DTS and SSIS packages
Utilities: Teradata Administrator, TOAD, QMF, SQL Plus, Erwin, Visio and Power Designer
OS: Windows administrator, Mac OS, Unix- Solaris, Linux administrator
Employment:
DataLynks Inc. BI Data Visualization, Admin, Architect, Developer – self-employed Apr. 1999 – present
MicroStrategy, Administrator, I-servers, Web server, Mobile, Developer, dossiers, MicroStrategy Cloud.
Admin tools (Object Mgr., Command Mgr., Integrity Manager, System Monitor and Security using MSTR Cloud (ACL, users and groups) etc….
Architect - Create schema objects, facts, attributes, hierarchies, parent-child relationships, transaction services etc.
Install, configure, deploy, and maintain MicroStrategy software updates on Windows and Linux systems.
Upgrade clients MicroStrategy, Install and configure I-servers, Narrowcast, Web and Mobile servers, architect and technical lead. Cloud base AWS.
Deployed and administrated reports on MicroStrategy Object Manager on MSTR Cloud.
Created reports - datasets, report services doc, Dossiers, dashboards, KPI, scorecards and mobile apps.
Developed Reports enabling Data Drilling across multiple Dimensions using MicroStrategy Desktop and MicroStrategy Web, reports & Dossiers.
Designed and deployed customized reports, documents and dossiers using MicroStrategy tool suite.
Experience in migrating reports from BO and SSRS to MicroStrategy.
Created simple and Complex Reports in MicroStrategy Developer and made it available to users for access through MicroStrategy Web and Mobile.
Design Interactive Dashboards in MicroStrategy Web to assess company's performance and monitor the overall goals of the business.
Provided various management levels with reports, analysis time series graphs and Bar Graphs using MicroStrategy Web and Mobile.
Understand the business users’ reporting and analytical needs; communicate effectively with the business users and help author business requirements.
Demonstrated proficiency working with data, especially analysis of potential data sources and development of source to target business rules mapping.
Work with developers, data modelers, testers, and business area subject matter experts (SMEs) to support development, system testing, and user acceptance testing (UAT).
Perform Unit Testing, and document test results.
Support System Testing, End-to-End testing, and UAT.
Work with developers for detailed design documents.
Develop business rules spreadsheets (BRS’s) to document data movement/data transformation rules.
Perform data profiling, data analysis, and setup mock data for development/unit testing.
Support all phases of the project development lifecycle using system development life cycle (SDLC) and other project methodologies.
Tableau, Lead Administrator – Data Visualization Architect, development of data visualization.
Teach Tableau server, desktop and online classes, Admin, Architect, development of data visualization.
Experience creating data visualization views, reports, and dashboards for desktops and servers.
Developed dashboards, reports and user interface based on requirements
Design and implement calculations, perspectives, hierarchy structures, score cards, and Key Performance Indicators (KPIs) with intuitive visualizations to enable data driven decision making
Identify, acquire, and analyze data from multiple sources into user-friendly dashboards used across the enterprise
Design/create innovative visualizations to identify patterns and trends
Interact with business and technical personnel to solve complex data related to business and technical problems
Translate business requirements into technical solutions by delivering value-added dashboards
Provided expertise in Tableau software, collaborating with team members to deliver clear and well-thought-out dashboards and visualizations
Updating and improving existing reports/dashboards
Ensured Tableau reports are functioning at the highest efficiency level
Ensured reports follow best practices for visualization and usability
Install, configure, deploy, and maintain Tableau software updates on Windows and AWS.
Design and implement effective data systems and models with snowflake
Alteryx, Lead developer – Data cleansing Architect, development of process and workflows for data visualization.
Teach Alteryx, in class and Online classes, Admin, Architect, development for data visualization.
Experience creating data cleansing processes, for reports, and dashboards for use in MicroStrategy and Tableau.
Install, configure, deploy, and maintain Alteryx software updates on Windows.
BI Analyst Building logical and physical data models. Design data models to desired reporting capability.
Maintained existing enterprise solutions, including migrations of legacy solutions and processes to new technologies.
Work with Vendor management to determine and implement a long-term BI strategy.
Liaison between business/technical users and the third-party BI technical support.
Clients – Sprint, T-Mobile, H&R Block, CBRE, BlueCross BlueShield, BNSF, AT&T, Nationwide, NIC, IBM…
T-Mobile - MicroStrategy Architect, Developer Oct. 2019 to present
Created data visualization using datasets from Desktop, used Data view, create visuals in Report view.
Design data models to desired reporting capability.
Maintained existing enterprise solutions, including migrations of legacy solutions and processes to new technologies.
Worked with Power BI & MicroStrategy security roles.
Power BI & MicroStrategy modelling; DAX; data storytelling; report publishing; security and knowledge of help make decisions with data.
Completed full SLC process to Design; Develop; test and maintain Power BI visualizations and reports for requested projects.
Educate business stakeholders on intelligence reporting capabilities
Actively engaged in business stakeholder requirements gathering sessions to understand; interpret and translate requirements into an effective technical solution.
Lead recommendations to upper-level management on use of tools across enterprise.
Designed architecture for technology solutions by applying industry best standards of architectural practices.
Write strategic vision and insight related to the IT Control Tower, including reviews of emerging technologies which may benefit the IT business line.
Architect - Create schema objects, facts, attributes, hierarchies, parent-child relationships.
MicroStrategy Developer, Web and Dossier to create reports, grid, graph, dashboards…
Los Alamos National Lab – MicroStrategy, Tableau Admin, Architect - contract Jan. 2019 – Sept. 2019
MicroStrategy Lead Administrator – Data Visualization Architect, development of data visualizations.
Experience creating data visualization, reports, Dossiers, Hyperintelligence and dashboards for end users.
Install, configure, deploy, and maintain MicroStrategy software updates on Windows and Linux.
Teaching end users how to create data visualizations using MicroStrategy Developer and Web.
Tableau Lead Administrator – Data Visualization Architect, development of data visualization.
Experience creating data visualization views, reports, and dashboards for desktops and servers.
Install, configure, deploy, and maintain Tableau software updates on Windows.
Teaching end users how to create data visualizations using Tableau desktop and server.
O’Reilly – MicroStrategy Admin, Architect and Developer Aug. 2017 – Jan. 2019
MicroStrategy Lead Administrator – Data Visualization Architect, development of data visualizations.
Experience creating data visualization, reports and dashboards for end users.
Install, configure, deploy, and maintain Power BI software updates.
Teaching end users how to create data visualizations using Power BI Desktop and Reader.
BlueCross BlueShield – MicroStrategy Admin, Architect and Developer Apr. 2016 – Aug. 2017
MicroStrategy Lead Administrator – Data Visualization Architect, development of data visualizations.
Experience creating data visualization, reports and dashboards for end users.
Install, configure, deploy, and maintain MicroStrategy software updates on Windows.
Teaching end users how to create data visualizations using MicroStrategy Developer and Web.
Black Box Network Services – Tableau Admin, Architect and Developer Oct. 2015 – Apr. 2016
Tableau Lead Administrator – Data Visualization Architect, development of data visualization.
Experience creating data visualization views, reports, and dashboards for desktops and servers.
Install, configure, deploy, and maintain Tableau software updates on Windows.
Teaching end users how to create data visualizations using Tableau desktop and server.
OTSI - BI Consultant July. 2010 – Mar. 2014
Create course materials for MicroStrategy and Tableau on-site training and eLearning, train all levers of users.
Experience creating complex reports and Report Services documents (dashboards), current and historical data.
Install and configure MicroStrategy I-Server, Web server and Mobile for iPads & iPhones.
Experience working with on/offshore models using MicroStrategy and Tableau.
SSRS support activities in a multi-environment, administration, upgrades, troubleshooting and development.
Tableau – Train users, experience with installations and upgrades, admin, development data visualization.
Work with Vendor management to determine and implement a long-term strategy for Tableau & MicroStrategy.
USDA Enterprise Data Warehouse Architect – contractor Aug. 2008 – Jul. 2010
Kansas City, MO
Facilitate projects and work with Business Analysts and customers to define project requirements.
Manager of ETL group for Data loaded to OPS, Reporting, and Enterprise data warehouse using SSIS. Create business reporting using SSRS. Responsible for enterprise data architecture.
Building logical and physical data models. Operational, Datamarts, and EDW.
Design efforts for technical platform, Lead technical standards. Design data models to desired reporting capability using Power-Designer.
First American Corporation Sr. MicroStrategy Administrator & Data Architect Oct. 2006 to Mar. 2008
Roanoke, TX 76262
Gather user requirements and create documentation for management sign-off.
Lead recommendations to upper-level management on the use of tools across enterprise.
Designed architecture for technology solutions by applying industry best standards of architectural practices.
Write strategic vision and insight related to the IT Data Management Group, including reviews of emerging technologies which may benefit the FARETS business line.
Administrator Unix I-servers, other Admin tools (Object Mgr, etc…), create reports, (grid, graph, dashboards)
Limited Brands, Inc. eLearning, Business Intelligence, MicroStrategy- contractor Apr. 2006 to Aug. 2006
Columbus, OH 43230
Create documentation and course materials for MicroStrategy eLearning Web 8.0.2 classes.
Set up and taught eLearning MicroStrategy classes using Breeze (webcast) application.
Architect MicroStrategy 8.0.2 projects and create all Microstrategy objects for training, development and production.
Use Teradata SQL to validate data for user acceptance.
Configure Enterprise Manager 8.0.2 projects and ETL for development, QA, and production.
Hallmark Cards, Inc. Data Warehouse Architect & MicroStrategy – consultant Oct. 2005 to Mar. 2006 Kansas City, MO. 64108
Lead recommendations to upper-level management on the use of tools across enterprise.
Mentor/Lead team members on MicroStrategy I-Server, Narrowcast Server, Desktop, and Web, version 8.0.1
Load and configure Narrowcast server 8.0.1, setup services, schedules, etc. for enterprise distribution.
Architect MicroStrategy projects and object development - reports, filters, metrics, etc. (v 8.0.1 r2).
Develop custom applications and integrate data from other applications.
IBM Global Services MicroStrategy Administrator & Developer (contractor to TxDot) Oct. 2004 to Sept. 2005
Austin, Texas 78727
MSI 7.5.3 and 8.0 report development, project architecting, report and architect troubleshooting, SQL modification and tuning system administration.
Upgrade MicroStrategy Narrowcast, web, and I servers. Configure Narrowcast and I Severs for Web portal and email.
Load and run Scan MD and MD Doctor for DB2 metadata. Create tables and set up ETL for DB2 data warehouse.
Taught MicroStrategy Desktop, Web and I-Server Admin 7.5.3 train the trainer and end user classes.
Architect MicroStrategy projects and object development - reports, filters, metrics, etc.
Interviewing qualified candidates and making hiring recommendations
Cisco Systems MicroStrategy Administrator & Developer - contractor Aug. 2004 to Oct. 2004
Austin, Texas 78729
Develop Data Models and DDL’s for MSI projects using Erwin and Visio.
MSI 7.x.x report development, Project architecting, report troubleshooting, SQL modification and tuning system administration.
Performance evaluations and clean up metadata to improve performance.
Modify reports to shorten execution times. Setup MicroStrategy Enterprise Manager and the ETL process.
Administer users and groups for MicroStrategy Audit.
Sprint Corporation - MicroStrategy Administrator & Developer- contractor Aug. 2002 to Jul. 2004
Overland Park, Kansas 66214
Manage and setup Enterprise Manager, Security filters, and administer over 14,000 users in two large MSI environments.
Develop MSI projects (Prototype and Production) using MicroStrategy 7i Desktop.
Upgrade MSI v 5 - 6, v 6 – 7.1.1, v 7.1.1 – 7.5.0, v 7.5.0 – 7.5.1 on Desktops, Intelligent and Web Servers.
MSI 7.x.x report development, Project architecting, report troubleshooting, SQL modification and tuning system administration.
Database used: Oracle, Informix, MS Access, SQL Server 2000.
Project Management, managing all aspects of BI projects
Support 40 plus MicroStrategy projects in a production environment.
Johnson County Community College Adjunct Professor, Staff Instructor Jun. 1994 to Aug. 2004
Overland Park, Kansas 66210
I taught college credit hour classes and college staff on Microsoft Office and Microsoft Windows, Computer Hardware, Network Essentials, MS Project 2002, Linux Red Hat, UNIX, Project Management.
Certifications: Certified Platform Administrator, CPA (I-Server & Narrowcast)
Certified MicroStrategy Trainer
MicroStrategy Project Developer (MPD)
Certified MicroStrategy (CMD) Report Developer and Project Designer
Microsoft Certified Professional (MCP)
Windows XP Pro & Server 2008, Network Essentials, Enterprise
Microsoft Certified Trainer (MCT)
Microsoft class (MOC) 803 Admin.
Education: MIDAMERICA NAZARENE UNIVERSITY, Olathe, Kansas 66062
BA in Computer Science
Master in educational technology
BRYAN INSTITUTE, Overland Park, Kansas
Degree, Computer Programmer (MIS)
Activities: Member: United States Golf Association, Kansas Golf Association
Contact this candidate