Data Analytics Leader with SQLSSIS/Power BI Expertise
Resume:
Paul Samson
*******@*******.***
EDUCATION
B.S. UCSD Physics
M.S. SDSU Physics
SKILLS
Advanced relational database SQL development with very large, heterogeneous, complex data sets
Very experienced with Microsoft’s Enterprise SQL Server Business Intelligence Stack: Power BI, Reporting Services (SSRS), Integration Services (SSIS), Analytical Services (SSAS), Excel
Intermediate experience with R, Python knowledge
Excellent Customer service record, many awards earned from nominations by customers
Great rapport with colleagues. I prioritize building strong relationships within and between teams
Outstanding performance reviews in my last role for 5 consecutive years
Passion for continuous improvement/research in technology, statistics, and probability
Highly-refined time management techniques to work on multiple efforts simultaneously
Effective Project Management, typically to track and schedule my team’s activities
Strong Written and Verbal Communication skills, effective to technical and non-technical audiences
Recent work history
2/25-present: Data Analyst Consultant
• Installed SSRS and toolsets, leading/mentoring staff in report creation, migrating enterprise operational reports from a legacy AS400 system to SQL Server.
• Designed a data model with visualizations in a Power BI proof of concept to demonstrate the capabilities of the toolset to my customer
• Continuous focus on mastering Power BI Desktop and Service best practices
• Snowflake training, 6 badges earned. Google Machine Learning training, 5 badges earned
• Dimensional modeling, star-schema development, revisiting prior models to reactor using the modern and popular DBT technology
6/18-2/25: Senior Database Administrator, Tucson Electric Power
• Designed Power BI data analysis models, presentation panels and dashboards, mentoring Contractor-provided development teams on the company’s standards and best practices
• Developed visualizations in Power BI/SSRS utilizing statistical analysis to guide Engineers in optimal meter configuration. Extended the analysis to R to identify potential correlations between the main features in our data set
• Technical lead for Compliance/Auditing team members to develop enterprise-level reports against hundreds of Oracle and SQL Server database instances providing regulatory information for State and Federal agencies
4/17-6/18: Database Architect, University of Arizona
• Developed ETL processes to migrate large, complex data sets from various sources into SQL Server and MySQL
• Designed data pipelines to internal University and external partners, cleansing and validating data for analysis
• Contributed to the design of the College of Medicine’s curriculum dimensional model and data warehouse
• Worked with customers in the Departments of Education and Admissions to perform statistical analysis, mainly focused on demographic distributions and outcomes for both general undergraduate and College of Medicine students.
7/16-4/17: Database Analyst Consultant, Arizona Community Physicians
• Redesigned database processes to effectively utilize a limited maintenance window for multi-terabyte database systems (Allscripts Electronic Health Record) in a high-availability configuration supporting over one hundred Physician offices
• Worked with key stakeholders in both the billing and operations departments to update their IBM Cognos dimensional models and create SSRS reports providing insurance-payment status and electronic patient record data.
3/12-6/16: Data Development/Administration Team Lead and Supervisor, Pima County
• Technical Lead of the Data Development team, responsible for designing dimensional models for Departments
• Used those models to build targeted Data Marts for Departments, cubes and tabular data sets, and SSRS reports. These provided valuable decision support to the County’s leadership teams for financial analysis and forecasting, operational metrics, and Freedom of Information Act requests
• Designed and configured the County’s multi-server, enterprise reporting environment in SSRS
• Developed complex financial system SQL and data sets for a self-service enterprise reporting environment in SSRS
8/08-3/12: Database Administrator/Analyst, City of Tucson
• Full database administration for dozens of enterprise-wide database systems on Windows, AIX and Linux platforms.
• Developed ETL processes in SSIS and linux scripts to transform the City’s HR data from a mainframe DB2 source into our Oracle Data Warehouse
• Working with end users and analysts, generated requirements and developed reports deployed to our enterprise Crystal Reports system for various departments, including Finance, HR, Prosecutors, Police and Fire.
Contact this candidate