Vice President - Data Warehouse And Business Intelligence Architect
CurrentA 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