John Aplin Email & Phone Number

Roswell, Ga, Us

Dallas, Tx, Us

Team Leader: 10 yearsManaged technical teams supporting the design, development, deployment and maintenance of business intelligence solutions supporting sales operations, customer service, marketing, finance and employee compensation.Supervise all aspects of the assigned team including day-to-day activities, task/project assignment, coaching and development, as well as performance evaluation.Work interactively with stakeholders to assess business needs, define project scope, deliverables, and timelines.SQL Server Developer: 20 yearsManagement Studio (SSMS) / Integration Services (SSIS) / Reporting Services (SSRS) / Visual Studio / Azure / Power BIWorked on numerous teams as SQL Server developer automating business processes, interfacing with source data systems, building complex data models, data hubs, reporting environments and desktop interfaces. Extract, scrub, transform, load and collate data from a variety of sources into comprehensive scalable database solutions driving flexible tools for the dissemination of analytics reports and strategic recommendations for stakeholders/executives.Conduct cross-system data audits for accuracy, completeness, identification of data discrepancies/process gaps, root cause analysis, and resolution of inconsistencies. Power BI development for data modeling, solution prototyping, dashboards, and KPI analytics.Azure administration (IAAS) for virtual Windows servers. Experience with configuration, optimization, private link services, dns zones, etc.VBA programming experience automating desktop data activities and manual reporting (Excel/Access) for work effort reduction, organizational efficiency and modernization.Internal Auditor: 4 yearsConducted operational, financial and information system audit activities including determination of audit scope, preparation of audit program, collection and collaboration of data, and oral and written presentation of report findings to senior leadership.