Benjamin Ng Email and Phone Number

Working with partners to develop enhanced connectors with Alation's Open Connector Framework

Working with tech partners to establish and enhance integrations with Alation- Databricks, Tableau, dbt, Fivetran, Matillion- Data Quality Partners

- Designed solutions for:--- Agent dashboard and scorecard reporting--- Executive revenue dashboard--- Call forecasting data mart--- Content delivery auditing tool and data mart--- Near Real Time customer profiling for call routing--- Executive customer experience dashboard- Led teams of ETL, report developers and business analysis across parallel work streams- Gathered requirements for a design of each project- Worked with client to refine data warehouse testing and production release process- Coordinated development, testing and deployment of solution

- Reviewed requirements and existing code for a data warehouse migration initiative- Established development standards across parallel work streams- Coordinated design reviews with SMEs to account for require changes during migration- Provided development guidance to teams of ETL developers- Performed data analysis and debugging of new source system

- Gathered requirements for a redesign of a new external facing state agency website- Coordinated the technical design by working together with Sense Corp partners- Assisted in interview with internal agency personnel, vendors and external agencies. Conducted over 20 interviews- Reviewed current systems integrated to the website and determined future systems of integration- Developed technical integration roadmap for future website and multi-phase implementation plan- Gathered requirements for agency’s procurement process through multiple interviews and review of 90+ page procurement manual- Identified gaps and areas for efficiency improvement. Provided multi-year roadmap of recommended projects to enhance procurement process- Researched potential procurement solutions. 80+ solutions were filtered down to four based on requirements and highly scoring matrix- Co-developed the detail scoring matrix to evaluate the final 4 vendors. Final evaluations done based on 4+ hour demos by vendors to ensure all details were covered

- Gathered highly requirements from client, customer and lenders on the solution desired by the client- Developed detailed business requirements for a settlement facilitation hub- Led team in designing settlement facilitation hub. Design included 25+ table data model and 20+ transformations.- Presented business requirements and technical design to key stakeholders

- Gathered requirements for multiple user defined applications (UDAs)- Coordinate technical and business test plans for risk assessment of each UDA. Test plans include 20+ test cases- Led team in conducting testing of UDAs- Develop and presented test findings to key stakeholders

- Manage company’s software and video conference deployments and installations. - Led design and implementation of the Court Video Kiosk pilot at a major municipality utilizing company’s software and Cisco infrastructure. - Proto-typed of new products for the company- Provided sales engineer support

- Designed and developed analytics software for reporting on various Cisco Telepresence infrastructure. - Managed product deployments at Fortune 500 firms and other enterprises utilizing video conferencing.

- Led design and implementation of clearing and settlement system for processing transactions- Gathered requirements from multiple business areas- Coordinate technical and business developments- Resulting system provided client an industry leading management and accounting system

- Managed team of consultant in the design and implementation of data mart and reports- Worked with IT personnel to establish data warehouse standards- Worked with business to gather report and data requirements- Designed and documented ETL and report specifications- Assisted with ETL development in Business Objects Data Integrator- Assisted with Report development in Business Objects XI R2- Provided support for team members working on migration impact assessment

- Lead Consultant for implementation of custom dashboard using Business Objects Web Intelligence- Worked with business and IT personnel to gather requirements- Provided training to client on design and implementation of dashboard- Assisted client personnel with ETL development in Business Objects Data Integrator- Provided support for team members working on migration impact assessment

- Executed assessment of the business needs through-out the insurance company- Assisted in interviews with business personnel in each company department- Identified and validated strategic business goals and provided findings in the assessment delivery- Led design, implementation and delivery for two phases of Oracle data warehouse initiative- Implement reports in both Crystal Reports and Business Objects Desktop Intelligence

- Executed assessment of the decommission of an existing data warehouse- Led interviews with business stake holders- Worked with team to create and deliver assessment findings

- Implemented Impromptu reports against Oracle data warehouse- Assisted in design of reporting backend- Trained client personnel on technical aspects of reports

- Led design and implementation of Tactical Decision Aid for submarines sonar systems- Managed offsite integration of software- Scoped future enhancements specifications through interview with various naval officers- Trained naval officers on software functionality and capabilities

- Lead Consultant – Marketing/Sales Data Warehouse (KANA, Broadbase, Oracle)- Installed and configured KANA Analytics and Broadbase Databases- Assisted in creation of conceptual, logical and physical data models- Gathered business requirements based on end-user interviews and sample reports- Designed and developed corporate end-user reports- Executed unit, system, user acceptance and performance tests on ETL data flows- Trained key users on data and ETL toolset

- Lead Consultant – Web Analytic Data Warehouse (KANA, Broadbase, Oracle)- Installed and configured KANA Analytics and Broadbase Databases- Assisted in creation of conceptual, logical and physical data models- Customized end-user web analytic reports

- ETL Consultant – ETI*EXTRACT (Oracle)- Gathered business requirements based on end-user - Created PL/SQL programs to populate report data marts- Implemented data acquisition using ETI*EXTRACT- Developed documentation of data model and mappings related to collection tables of the data warehouse

- ETL Consultant – ETI*EXTRACT (Oracle)- Gathered business requirements based on end-user - Created PL/SQL programs to populate report data marts- Implemented data acquisition using ETI*EXTRACT- Developed documentation of data model and mappings related to collection tables of the data warehouse

- ETL Consultant – ETI*Extract (SQL Server)- Defined requirements for data acquisition process through business user reports- Managed team of four data acquisition engineers, including task definition, allocation and management- Deployed customized ETI*Extract including C/SQL Server and C/FS DSLs on Windows NT- Developed test infrastructure for deployed DSLs