SUMMARY:

• 10+ years of analytics and insights experience
• 6 years of systems optimization, integration, and quality assurance
• 4+ years of monitoring, analyzing, and integrating disparate systems and process improvements

TECHNICAL SUMMARY:

SAS, COGNOS, SAS, SQL Server, TSQL, SSIS, AWS S3, Athena, Jira, Confluence, Microstrategy, Tableau Server and Workfront for Agile.

PROFESSIONAL EXPERIENCE:

Confidential, Salem, OR

Sr BI Data Analyst/Quality Assurance (consultant)

Responsibilities:

• Successfully Identify granularity issues in SQL Server (SSMS) and work closely with Engineering to resolve adjacent problems and provide Business with viable software deliverables.
• Establish strong rapport with business partners and work closely with key stakeholders in understanding their business needs, and gather well - defined requirements necessary to transition all ad hoc reports from COGNOS to the reporting tool of record, SAS Visual Analytics.
• Test and validate distinct column count between legacy reporting system, COGNOS Impromptu and SAS VA dev.
• Design complex ERDs (Entity Relationship Diagrams) of SSMS tables and views for evaluating column granularity and referential integrity

Environment: SAS, Cognos, SQL Server, and Workfront for Agile

Confidential, Portland, OR

Senior Data Analyst

Responsibilities:

• Effectively and accurately, build 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.

Environment: SQL Server, AWS Redshift, S3, Teradata, and Splunk

Confidential, Hillsboro, OR

Senior Data Analyst/Data Engineer

Responsibilities:

• Under highly time-sensitive deadline, successfully designed, documented, and architected pipelines to Consumer PII data embedded in Confidential 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 Confidential Corporate Legal with in-depth analytics relative to compromised Confidential digital accounts and bot credential stuffing attempts.
• Continuously evaluate attack vectors and provide recommendations to enhance response/security posture.

Environment: SAP, Jira, Confluence, NGAP2, AWS S3, Athena, Elastic Map Reduce (EMR), Hive, Spark and R

Confidential, Beaverton, OR

Senior Data Analyst

Responsibilities:

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

Environment: Tableau Server, Tableau Desktop, Excel, PowerPoint and Smartsheet Collaboration

Confidential, Hillsboro, OR

Sr. Data Analyst

Responsibilities:

• 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 Confidential Cloud Workflow.
• Successfully design and manage data integration of legacy commissions and compensation systems to Confidential
• Initiate and log pay reporting errors and follow vendor break/fix remedies in an Agile/Scrum environment

Environment: Cloud, Crystal Reports, Excel and Word

Confidential, Portland, OR

Lead IT Data Analyst

Responsibilities:

• Developed and led scrum teams designed to achieve bi-weekly sprint completions, maximize burn-down rate and achieve velocity forecast
• Successfully identified manual reporting practices and automated processes with SAP BusinessObjects, ultimately allowing business users faster data and more accurate information
• Performed software application testing and implementation and provide analysis for senior management.

Environment: SAP BusinessObjects, SAP InfoView, RPM, MS Access, Excel, SharePoint, and Tableau

Confidential, Beaverton, Oregon

Senior Data Analyst/DW Engineer

Responsibilities:

• 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

Confidential, Salem, Oregon

Data Analyst/Research

Responsibilities:

• 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

Confidential, Juno Beach, Florida

Insights/Data Analyst

Responsibilities:

• 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

Confidential, Boca Raton, FL

Senior Analyst, Category and Pricing Analytics

Responsibilities:

• Define and develop Category Business Planning (CBP) strategies relative to seasonal product roll outs.
• Analyze customer segmentation utilizing third party research including IRI and Nielsen data.
• Manage product pricing and promotional activities including POG and assortment change
• Develop price optimization, and KPI goals and align Direct (Web) marketing strategies with retail and contract pricing initiative relative to margin and revenue goals and forecasts.
• Manage competitive data and analyze monthly comp shops.

Environment: s: IBM DemandTec, IRI, Nielsen, Excel, SQL ManMan, and PowerPoint