John Y. Email & Phone Number

Business-engaged, technology-aware analyst offers business intelligence, reporting, data analysis and business analysis skills for executive insight, operational knowledge, and custom analytical support. Cross-functional collaboration, strategic vision, detailed execution, humble attitude, and professional curiosity offer levers for results in a data-driven world. Exposure to an array of industries, business functions, technologies, and relationships provides flexibility in dealing with complex challenges.Examples are: • Insight - business partner, metric selection, data prep, dashboard design, visual analytics • Trust - responsible for data quality, data mining, master data, and dimensional & data profiling • Ownership - product manager responsible for requirements, design, testing, training, controls • Reliability - managed company budget process; created flexible processes used for years • Effectiveness - migrated worksheets to database to improve speed/quality of global financial reportsToolset/Concepts Exposure: > BI/Analytics/Data - Microsoft Power BI, SQL Server, Integration Services (SSIS), Reporting Services (SSRS); Hyperion Enterprise, Essbase, Brio; Business Objects; Cognos; Alteryx Designer > Databases - SQL Server, Oracle, Access > Query Tools - SQL Developer, SQL Navigator, Toad, Discoverer, Oracle Data Integrator > Oracle Financials - GL module, Oracle Financial Analyzer, Financial Statement Generator > CRM - Salesforce > Office Tools - Microsoft Office; Google Sheets > Project/Team - Outlook, Slack, Microsoft Teams, Jira, Microsoft Team Foundation Server (TFS) > Remote Tools - Zoom, Microsoft Teams, Google Meet > Methodology - SDLC/Waterfall, Agile > Math/Logic - Statistics - descriptive, hypothesis test, confidence limits, correlation, regression (linear and non-linear) > Governance/Compliance - Healthcare (HIPAA); Higher Education (FERPA); Finance (SOX); Business continuity planIndustries: > Federal Program, Non-profit, Healthcare, Financial, Higher Ed, Computer, Telecom, Animal Care, Semiconductor, ChemicalsEmail: jcyates1@hotmail.comStrengthsFinders 2.0 - Top 5 (Feb 2013): > Analytical, Connectedness, Strategic, Learner, Responsibility

Listed skills include Data Warehousing, Requirements Analysis, Business Analysis, Software Documentation, and 16 others.