TIMOTHY S. MCADAMS
503-***-**** Salem, OR
ad1l8h@r.postjobfree.com
Summary
Exceptionally talented senior data analyst with deep understanding of IT and business applications including data management, software deployment, systems integration, and cloud computing. Well versed in Agile methodologies including burn down rates, backlogs, grooming sessions, and lean business processes.
TECHNICAL SUMMARY
SAS, SAP, COGNOS, SQL Server, TSQL, PowerBI, AWS S3, Athena, RedShift, Jira, Confluence, Microstrategy, Tableau and Workfront for Agile.
Consulting/Contracting 2012 to 2021
WestRock
Sr. BI Data Developer Remote 04/21 to Present
Collaborate with cross functional teams in identifying and accessing appropriate and necessary data sources to support analyses relative to procurement and supply chain decisions.
Build complex and insightful visualization reports in PowerBI and publish findings for key stakeholders and functional partners.
Identify and correct gaps in global monthly reporting domain and provide analysis for better data access.
ENVIRONMENTS: Rally, PowerBI, Alteryx, SQL Server, SharePoint, Power Automate, DAX, M and MS Planner.
NIKE (on behalf of Centizen App) Beaverton, OR 11/20 to 04/2021
Sr. Data and Business Systems Analyst (contract) - NIKE Global Technology
Design and build complex JSON CDC (change data capture) contracts allowing seamless downstream consumption by ED&A consumers.
Define test scenarios based on business processes and participate in integration testing and deployment.
Enable the Product Dimensional Data engineering teams to clearly understand data and system requirements assuring development work is done correctly and efficiently.
ENVIRONMENTS: JSON, Snowflake, Data Lake (HIVE, Presto), LucidCharts, Jira, Confluence, and SQL
SAIF Corp (on behalf of Vanderhowen) Salem, OR 02/19 to 03/20
Sr Data Analyst/Quality Assurance (consultant) – Information Systems, SSBI
Successfully developed highly critical engineering requirements for SAS LASR configurations, and assured key stakeholders and Functional Partners’ seamless transition from unsupported legacy systems to an Enterprise platform of record, SAS VA.
Effectively Identified granularity issues in SAS attributes and worked closely with Engineering to resolve adjacent problems, providing Business with viable software deliverables in SAS VA.
Developed, executed, and validated acceptance criteria, performing data quality tests and performance testing relative to distinct column counts between legacy reporting systems, and SAS VA dev.
Designed complex ERDs (Entity Relationship Diagrams) of SSMS tables and views for evaluating column granularity and referential integrity
ENVIRONMENTS: SAS VA, SAS EG, COGNOS, SQL Server, SharePoint and Workfront for Agile
Project completed
PGE – (via IGWN) Portland, OR 06/18 to 12/18
Senior Data Analyst (contactor) – Customer Analytics
Effectively and accurately, built complex SQL queries and provide corporate marketing with clean lists for direct communication efforts.
Test and identify gaps in table attributes and advise developers of defects or missing data.
Create and manage consensus relative to the adoption and implementation of an Agile/Scrum delivery team.
ENVIRONMENTS: SQL Server, SAS EG, SharePoint and VersionOne
Contract completed
NIKE – (via Optiv Consulting) Hillsboro, OR 02/18 – 05/18
Senior Data Analyst/Data Engineer (contractor) - Corporate Information Security
Under highly time-sensitive deadline, successfully designed, documented, and architected pipelines to Consumer PII data embedded in NIKE Consumer Engineering team’s “Walled Garden”.
Successfully managed various cloud and big data applications including AWS S3, Athena EMR and Hadoop, as a means of providing Global Cyber Incident Response and NIKE Corporate Legal with in-depth analytics relative to compromised Nike digital accounts and bot credential stuffing attempts.
Continuously evaluate attack vectors and provide recommendations to enhance response/security posture.
ENVIRONMENTS: SAP, Jira, Confluence, NGAP2, AWS S3, Athena, Elastic Map Reduce (EMR), Hive, Spark and R
Accepted offer with PGE
NIKE (via Aditi Consulting)
Senior Data Analyst (contractor) Beaverton, OR 11/17 to 2/18
Led the charge to establish critical data visualization tools (Tableau) and build comprehensive reports designed to illustrate IWS’s Resource to Plan initiative for FY19.
Working closely with Finance, successfully compiled all Global IWS financial data, relative to budget and headcount and provide COE directors with viable financial information for better decision making.
ENVIRONMENTS: Tableau Server, Tableau Desktop, AWS, PowerPoint and Smartsheet Collaboration
Project completed
INTEL (via US Tech Solutions) Hillsboro, OR 04/17 – 08/17
Sr. Data Analyst IV (contractor)
Successfully reduced burn-down rates and return velocity to green in a highly critical Phase I software rollout.
Effectively work with product owners and stakeholders in defining and executing critical user-stores and report enhancements to SAP Callidus Cloud Workflow.
Successfully design and manage data integration of legacy commissions and compensation systems to Callidus
ENVIRONMENTS: Callidus Cloud, Crystal Reports, Excel and Word
Kaiser Permanente (via Mastech and Akrays) Portland, OR 02/16 to 02/17
Lead IT Data Analyst (contractor)
Successfully identified manual reporting practices and automated processes with SAP BusinessObjects, and SAS, ultimately allowing business users faster data and more accurate information
Developed and led scrum teams designed to achieve bi-weekly sprint completions, maximize burn-down rate and achieve velocity forecast
Performed software application testing and implementation and provide analysis for senior management.
ENVIRONMENT: SAS, SAP BusinessObjects, SAP InfoView, RPM, MS Access, Excel, SharePoint, and Tableau
NIKE (via NW Software) Beaverton, Oregon 01/15 to 02/16
Senior Data Analyst/DW Engineer (contractor)
Effectively designed and architected data mapping relative to star schema methodology in data warehouse build.
Successfully design and build a SQL Server data warehouse with SSIS packages designed to ETL flat files from outside vendors and banking suppliers as a means of illustrating critical Fraud to Revenue measure and chargeback analysis.
Engineered DPL virtual server, including data warehouse build, table column development, stored procedures, and systems administration.
Environment: Oracle SQL Developer, SQL Server, SSIS, Accertify
Oregon Department of Transportation Salem, Oregon 06/14 to 11/14
Data Analyst/Research (Limited Duration)
Gathered, compiled, and reported various attributes relative to transit activities and identified gaps in statewide federal transit funding.
Collaborated with Information Systems staff in designing and implementing new information platforms.
Environment: MS SQL Server 2008, Excel, Word and PowerPoint
Cambia Health Solutions Portland, Oregon 12/13 to 02/14
Data Analyst/Data Modeler III Contract (Contract completed)
Analyzed business requirements and documentations, and prepared reports for claim inventories relative to internal audits, user acceptance testing and health insurance exchange programs (HIX).
Identified and successfully automated aging reports for daily audits and CPI requirements
Environment: Python, SQL Server, Visual Studio, SSIS, SSRS, R, Facets, and Rally CA
Project completed
Florida Power and Light Juno Beach, Florida 05/12 to 02/13
Insights/Data Analyst (contractor)
Managed, documented, and quality checked frequently used Customer Data Warehouse (CDW) attributes and provided various requested reports.
Provided technical assistance relative to sensitive utility and energy-related matters including case rates
Environment: Oracle SQL Developer, TOAD, SPSS, SharePoint, Lotus Notes, Excel, PowerPoint, and Access
Moved to Oregon
EDUCATION
MBA, Marylhurst University, Portland OR
B.A. in Communication Studies, California State University, San Bernardino, CA