We provide IT Staff Augmentation Services!

Sr Bi Data Analyst/quality Assurance (consultant) Resume

Salem, OR

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

Hire Now