John Y.

Background

About John Y.

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 reports Toolset/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 plan Industries:> Federal Program, Non-profit, Healthcare, Financial, Higher Ed, Computer, Telecom, Animal Care, Semiconductor, Chemicals Email: jcyates1@hotmail.com StrengthsFinders 2.0 - Top 5 (Feb 2013):> Analytical, Connectedness, Strategic, Learner, Responsibility