We provide IT Staff Augmentation Services!

Sr Bi Data Analyst/quality Assurance (consultant) Resume

Salem, OR


  • 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


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


Confidential, Salem, OR

Sr BI Data Analyst/Quality Assurance (consultant)


  • 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


  • 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


  • 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


  • 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


  • 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


  • 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


  • 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


  • 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


  • 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


  • 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

Hire Now