Vice President - Data Warehouse and Business Intelligence Architect

• Feb 2012 - Present

A hands-on technical leader & manager with demonstrated track record of data architecture and design: Data warehouse architecture role: - Built a robust data warehouse utilizing security, company, financial, trade, and market data. - Designed and developed star schemas to aid in OTC trade and quote analysis. - Incorporate AWS S3, Athena, DynamoDB, Redshift & Spectrum services for fast cloud data solution with lower cost. Business intelligence solution architecture role: - Designed and developed Jasper Reporting solution that enabled visualization of insights and analysis from business data. - Streamline web development process by separate development of the GUI and data as a service and embedding data analytics reports & dashboards in web application. As a result, it speedup the development process and has proven to be the most successful delivery of the Execution Quality product. - Evaluating AWS SLICE and QuickSight services for a fast cloud-powered business intelligence service at a lower cost. Data engineer role: - Designed and developed ETL strategies to transfer data from multiple database platforms into data warehouse. - Designed and developed ETL strategies to transfer different data files types from different external data sources. - Designed and developed in-house ETL tasks execution services. - Incorporate AWS Kinesis, SQS, EMR(Spark & Hadoop), Kafka, EC2, DMS, GLUE, and Lambda services for data collection. Development role: - Engineered features and developed rules base algorithms for compliance and Blue-Sky securities classification. - Developed algorithms to track stock promotions. - Applied Machine Learning & Deep Learning algorithms for fraud detection. - Developed Apache Spark real-time applications in Scala. - Designed and developed market data replaying tool in C#. Management role: - Team lead responsible for 2 developers. - Provide technical specification - Oversee technical design and providing technical guidance. - Code review Show less

Vice President - Developer Tech Lead

• Apr 2003 - Feb 2012

Director - Web Development

• Mar 2001 - Aug 2002

Vice President - Web development

• Mar 1997 - Mar 2001

Vice President - Trading System Support Manager

• Sep 1996 - Mar 1997

Vice President - Trading System Support Manager

• Jun 1993 - Sep 1996