Eric Chio
Fairfax
Summary
Experienced data and analytics professional with a proven track record of managing and executing large-scale data analytics programs. Skilled in developing and implementing data strategies, overseeing diverse portfolios across various industries. Adept at leading and collaborating with development teams to design, engineer, and launch efficient and scalable data solutions that drive impactful results within large organizations.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Senior Program Manager
Amazon | Financial Operations Global Data & Analytics Team
03.2021 - Current
- Own program management of entire FinOps Global Data Analytics BI portfolio which includes data architecture, data engineering, data visualization and data science projects to develop analytic solutions with data engineers, BI engineers and data scientists globally for business users within Finance Operations leveraging AWS technologies and tools
- Own prioritization and planning sessions with business teams and to create product roadmap to deliver analytics solutions to drive business impact for both Accounts Payable and Accounts Receivable within Finance Operations
- Developed dashboards using AWS Redshift in Tableau and Amazon Quicksight to provide insights and monitor important business metrics for channel and senior leadership
- Drive data governance and standards to improve data discovery, data quality, data lineage and metric definitions using industry leading practices to provide visibility and transparency to customers and business stakeholders
- Performed migration of over 200 datasets from legacy Redshift environment to the new Redshift Spectrum data warehouse environment for data optimization, hygiene and consolidation to improve user experience
- Created a unified customer request intake and prioritization framework for team to receive requests and delivered automated rules engine to enable auto-routing, auto assignment and labeling to enable smooth sprint prioritization process
- Own the prioritization and ranking of our data engineering team’s backlog for infrastructure enhancements, data pipeline changes to onboard new datasets or enhance existing tier-1 and tier-2 datasets used for reporting
- Eliminate redundant efforts across all channel teams and identify gaps to improve team’s efficiency and throughput
- Produce monthly and quarterly document for business reviews on program health to directors and vice president within finance operations
- Established standards and governance process on the development lifecycle of semantic datasets and dashboards to maintain high bar for customer experience
- Reviewed entire reporting portfolio (~200 Tableau dashboards) and identified opportunities for dashboard consolidation and deprecation to improve user experience and better serve our customers’ business needs
- Serving as member of the leadership team to mentor and provide training to junior-level developers
Senior Manager
EY US Government & Public Sector, Americas | Technology Consulting | Data & Analytics
12.2016 - 03.2021
- Led a team of 26 data architects, data analysts and data scientists across 3 Full Financial Statement Audit readiness contracts with a DoD agency to provide data analytics support and implement innovative big-data solutions using both on-premise and cloud-based platforms and services/technologies focused around financial audit, financial management, subledger and ledger datasets
- Led data ingestion/integration team and perform data ingestion processes and provide technical guidance for loading approximately 10 billion financial/accounting transactions per month into the organization’s enterprise data warehouse (Oracle 12c) sourcing from 47 ERP and feeder systems
- Led enterprise data and system architecture, design and development of the technical solutions to help address the client’s most challenging and evolving business needs and technical issues
- Performed advance audit analytics on accounts payable, accounts receivable, unmatched transactions, undelivered orders, unfilled customer orders, de-obligated funds and open obligations by analyzing the populations and creating interactive dashboards to highlight insights and patterns in the data and recommend actions
- Engaged and collaborated with stakeholders on performing an assessment of the current state and identifying new platform and tool requirements to address the gaps to deliver enterprise analytics capabilities for the organization
- Led the team of testers in devising testing strategy and roll-out schedule of the new enterprise big data platform (Hadoop, Hive and Impala) hosted on Amazon EMR (AWS) by identifying and resolving system functionality, performance, data quality and data integration issues
- Provided demonstrations of the new technical solutions to client’s leadership and lead the deployment of the solutions to the end users
- Performed highly technical tasks of programming in SQL and PL/SQL, creating workflows in Informatica and developing interactive data visualizations in Tableau desktop/server, Power BI, Qlik and other available business intelligence tools
- Led and facilitate discussion with the data center as well as other stakeholders to provide feedback on improving the current infrastructure and existing integrated development environment for better performance, scalability and to drive cost savings
- Responsible for building and maintaining long-lasting and client relationships with the Agency’s senior executive leadership
- Led an internal engagement of building out audit readiness capabilities using Microsoft Azure PaaS and its analytics and cognitive services to build out Power BI dashboards to deliver insights for potential customers and internal stakeholders to filter, drill-down/through into transactional level data to make business decisions
- Provided technical coaching, thought leadership and mentorship to team members on the engagement
- Responsible for leading business development opportunities as a senior manager of the firm
- Participated and serve as a member of the Data and Analytics Leadership Team responsible for making hiring, staffing, training and promotion decisions
- Participated and serve as a senior member of the company’s internal Data Analytics Community of Practice (CoP) for designing training sessions and sharing technical knowledge and expertise with data practitioners across the Government and Public Sector Practice
- Responsible for reporting weekly status updates to Agency’s senior leadership and other stakeholders
- Responsible for making staffing decisions and providing onboarding assistance, coaching and mentorship to new and existing team members
- Designed and created interactive data visualizations with drill-down capabilities using Tableau desktop and server to present insights/findings to users
- Automate data reconciliations using custom SQL scripts and Tableau dashboards to replace manual reconciliations to respond to PBC requests
- Taught data visualization leading practices courses at EY GPS and present engagement spotlight at internal EY GPS all-hands and engagement all-hands meetings
- Assist EY’s recruiting efforts by conducting weekly interviews with multiple candidates for the data & analytics sub-competency area
- Regularly conduct demonstration of innovative analytics solutions to Agency’s senior leadership
- Technologies: Oracle 12c, Hive, Cloudera Impala, Databricks on AWS, Tableau Desktop 10.5 Tableau Server 10.5, Toad, Sqlplus, Informatica PowerCenter, Informatica Developer, Alteryx, R, Microsoft Office, Textpad, Putty, Unix
Business Intelligence Specialty Lead
Excella Consulting
11.2007 - 11.2016
- Led a team of data professionals in the analysis, design and implementation of data analytics solutions using Scrum for a multitude of clients across the Federal, private, non-profits and education sectors
- Accountable for increasing Excella’s Business Intelligence (BI) capabilities and capacity to deliver BI solutions to our clients and growing the BI expertise within Excella’s Data & Analytics service area Project Lead – Led a team of technical data analysts to deliver solutions to a global hospitality firm
- Responsible for account management, team performance, relationship management, business development and client satisfaction
- Engagement 1: Data Team Lead – Marriott International
- Led a team of 4 data analysts and data scientists in providing support for digital marketing, advanced analytics and data visualization within the customer experience department
- Provided complex ad-hoc analyses of rewards and reservations data pertaining to 50 million rewards members of a global hospitality chain through SQL queries to stakeholders in the organization
- Created and presented highly visible, in-depth analyses of the health of the company’s brands compared to its competitors’ brands through Tableau and relevant statistical methods to the Brand and Content Advisors
- Created and demonstrated new ways to visualize STR global hotel census data using Tableau to enable senior leadership to make data backed and informed business decisions
- Improved existing SAS programs to streamline processes for targeting most engaged, high-value customers with hotel offers using predictive models
- Redesigned and implemented an automated end-to-end solution for an optimized email campaign in order to improve efficiency, maintainability, and accuracy
- Developed additional processes to pull data for targeted marketing campaigns Technologies: IBM Netezza, Tableau 9.2, SAS, WinSQL, Aginity Workbench for Hadoop, IBM BigInsights Account Owner/Project Lead - Led a team of developers to expand an IT system using an Agile methodology to a public auditing company in Northern Virginia
- Responsible for the growth and the performance of the account, team performance and client satisfaction
- Created new data models and modified existing ETL code to collect additional information required for processing and reporting purposes
- Conducted requirements gathering sessions with stakeholders as a ScrumMaster using Agile methodology
- Created UI mockups based on collected requirements to pilot proposed enhancements to existing pages
- Implemented validations in SQL Server and Microsoft InfoPath to ensure data quality and facilitated error reporting in system
- Created and tested the necessary database scripts to enable system to collect and provide additional information to the users
- Conducted detailed analyses on several components of the system to provide the project team with a better understanding of the system’s performance benchmarks and limitations
- Created test cases for all development-oriented stories and conducted extensive testing on all new features with documentation
- Conducted demonstrations to product owner and other stakeholders on newly developed features Technologies: SQL Server 2008 R2, Microsoft InfoPath, HP ALM – Quality Center 11.00, ERwin Data
- Engagement 2: BI Architect/ScrumMaster – The George Washington University, GWU
- Served as ScrumMaster leading all Scrum related meetings (planning, backlog grooming, sprint demo, sprint review and retrospective) for the entire duration of the Principal Investigators Dashboard project
- Served as the lead data analyst leading the implementation, verification and monitoring of the products produced during the sprints
- Facilitated workshops and collaborated with key stakeholders leveraging innovation games to identify requirements/features of the web-based, interactive dashboard for the GW research community
- Conducted data analyses and created designs for ETLs to build the entire infrastructure supporting all features delivered in the first release
- Conducted system and performance testing against ETL workflows and Cognos packages as well as created scripts for user acceptance testing
- Conducted testing on data accuracy and quality by comparing results to GW’s finance and HR systems of record (Oracle Financials and BANNER)
- Created data dictionary and report catalog for all standard reports and visualizations approved by stakeholders to provide users with data definitions and source information
- Created secure and interactive visualizations in Tableau against the various data sources
- Acted as ScrumMaster and led all Scrum related meetings (planning, backlog grooming, sprint demo, sprint review and retrospective) for the entire duration of the project
- Provided Agile coaching and training to GW’s Business Intelligence Services team within the Division of IT Technologies: Informatica 9, Oracle 11g, Toad, Cognos 10, Tableau 8.1, Erwin Data Modeler, Drupal Business Intelligence Architect
- Collaborated with key stakeholders to identify and document requirements for the database for the new HR system
- Conducted business analyses on requirements and created requirements mapping spreadsheet to document the findings
- Designed and created a data model using Erwin for the newly constructed database
- Created and configured SSIS package to extract, transform and load Ultipro data into the database for downstream reporting
- Collaborated with reporting personnel to implement database changes to improve performance and enhance report functionality
- Created test scripts, conducted extensive data validation testing and incorporated changes based on product owner and users’ feedback
- Attended stakeholder meetings with product owner to discuss system updates and communicate concerns and necessary changes to the format of the data extract Technologies: CA Erwin Data Modeler, SQL Server 2008 R2 BusinessObjects Technical Architect – Office of Personnel Management (OPM)
- Interviewed stakeholders and key subject matter experts from Merit System Audit & Compliance (MSAC) to identify requirements and implemented a reporting solution leveraging Business Objects XI R3.1 to replace a mainframe system
- Created efficient and user-friendly web-intelligence reports that complete in seconds (instead of hours) and demonstrated reports to over 60 evaluators working at various OPM field offices
- Worked with other program offices within OPM on modernizing legacy reports by creating Web- intelligence reports leveraging Business Objects XI R3.1 to eliminate the need for data calls
- Administered all of EHRI’s Business Objects universes and maintained universe security using universe restrictions in Business Objects and LDAP
- Designed and facilitated Business Objects training to all OPM and external Business Intelligent (BI) users
- Created workforce analyses and forecasting models using EHRI’s analytical tools (WASS and CIVFORS)
- Implemented EHRI’s Data Quality Reporting System (DQRS) using Business Objects XI R2.0 and APOS bursting manager responsible for generating and distributing data quality reports (2,200 reports bi-weekly) to agencies and data providers across the federal government
- Developed standard and Ad-hoc custom reports to help agency and provider users to identify, fix and improve the quality of data in the data warehouse
- Led the Business Objects Assessment project and improved all EHRI standard common reports to completing under 3 minutes Technologies: Business Objects XI R2/3.1, Oracle 11g, Toad, WASS/CIVFORS/CER, Cognos 6, APOS
- Engagement 3: Data Team Lead: Office of Personnel Management
- Led a team of data analysts and ETL developers using Scrum to create a data warehouse and implement data solutions for the EHRI department analyzing HR, Payroll and training information within the government’s executive branch
- Designed, implemented and supported BusinessObjects Enterprise Data Warehouse Solutions
- Performed installation of BusinessObjects Enterprise Suite and ETL applications
- Conducted system administration, configuration, customization and maintenance in BusinessObjects
- Developed complex queries and conducted data analysis with performance tuning
- Designed and implemented various data warehouse modules
- Completed data exports, imports, maintenance and configuration management to 10 on-site database environments
- Prepared documentation and established nightly cycle procedures for automated processes within Data Warehouse Technologies: Business Objects XI R2, Oracle 11g, Toad Technical Support Lead - Provided on-site technical support, post implementation project planning and technology vision
- Managed team of 4 technical members
- Responsible for resolving incidents and supporting 700 users of an ERP software solution that manages 1.5B of annual budget
- Developed and implemented new business processes and proposed recommendation on third party solutions to increase efficiency of clients daily business operations
- Conducted risk analysis on third party solutions to better help client on decision-making
- Performed system migration and integration followed by thorough application testing to improve system performance to minimize year-end operations by 50%
- Information Technology Consultant, 08/2004 to 10/2007 CGI
- Provided functional knowledge and performed functional tasks during implementation
- Facilitated extensive application testing and developed workaround strategies
- Provided training materials to team members and client on new business processes
- Performed financial data conversion and reconciliation in general ledger accounts
- Designed and implemented nightly automated job cycles for payroll, automated disbursement to help improve efficiency and reduce daily business operations by 30% Technologies: Oracle 9i Application Server, BusinessObjects Enterprise XI, Oracle 9i, Momentum ERP Software, BrioOne SQR Report Developer
Education
Bachelor of Science - Computer Science, Mathematics
Pennsylvania State University
University Park, PA01.2004
Skills
- Data Analytics
- Data Strategy
- Data Engineering
- Data Visualization
- Data Governance
- Data Architecture/modeling
- Change Management
- Agile Development
- Program Management
- Program Strategy & Execution
- Strategic planning
- Project leadership
- Complex Problem-solving
- Strong analytical skills
Certification
- Project Management Professional (PMP)
- AWS Certified Cloud Practitioner
Timeline
Senior Program Manager
Amazon | Financial Operations Global Data & Analytics Team
03.2021 - Current
Senior Manager
EY US Government & Public Sector, Americas | Technology Consulting | Data & Analytics
12.2016 - 03.2021
Business Intelligence Specialty Lead
Excella Consulting
11.2007 - 11.2016
Bachelor of Science - Computer Science, Mathematics
Pennsylvania State University
Similar Profiles
Stephen PowersStephen Powers
Director of Project Management – Director of Operations & Data Analytics at Director of Project Management – Director of Operations & Data AnalyticsDirector of Project Management – Director of Operations & Data Analytics at Director of Project Management – Director of Operations & Data Analytics
Ryan AndrewsRyan Andrews
Regional Sales Executive at Black Knight Financial Services Data & AnalyticsRegional Sales Executive at Black Knight Financial Services Data & Analytics
Jaden FlroesJaden Flroes
Data Center Installation Technician at Amazon Data Center OperationsData Center Installation Technician at Amazon Data Center Operations