Develop methodology and provide guidance to transition Social Security Administration from legacy z/OS analytics system to cloud-based self-service BI platform. Identify production artifacts, both de jure and de facto, for migration. Develop standards for coding, visualizations, performance monitoring, and data integrations. Identify repeated code to design reusable modules to streamline code.Write monthly tips and techniques newsletter to evangelize new BI platform and provide alternatives to deprecated or discontinued legacy platform components.

Demonstrate to prospects the value proposition of API-led architecture and Bits in Glass professional services. Provide technological guidance to East Coast and Midwest sales representatives. Analyze clients’ needs and existing technologies and develop proposals for solutions and implementations. Liaise with MuleSoft architects and project managers to provide blueprints, project plans, and SoWs.

Led solutions architecture in North American market. Concentrated on financial and insurance industries. Developed and promoted processes to ensure successful PoC’s and post-sales implementation of SQream’s GPU based database engine on-prem or in the cloud.Collaborated with executive directors and senior vice presidents to translate business needs into effective system strategies. Determined skill sets and staff required. Liaised with offshore product managers and with training and development teams to implement system design. Developed solutions for real-time data-intensive computations. Designed systems leveraging GPU powered analytic engine built to analyze petabyte level data. Designed data models using Apache Parquet in Hadoop ecosystem and proprietary file store on Red Hat Linux.Simplified system architecture by eliminating risk analytics OLAP cube and optimizing code, so queries run nearly as fast using trade level data directly. Managed project to refactor and optimize Oracle SQL queries and DDLs by leveraging SQream DB.

Developed interface for client portfolio management system to ingest MBS/ABS financial data. Collaborated with data scientists and system engineers to develop optimal data model.Gathered requirements for marketing prototype and coordinated with overseas developers to produce working version for Paris industry conference. Prototype helped the 1010data win major contract with client.Trained and mentored development managers on optimal approaches to refactoring row-based big data models into a column-based distributed node model.

Led conversion of enterprise reporting system encompassing 1,000 financial, regulatory and risk reports. Designed architecture and led team as both lead and hands-on contributor.Created roadmap for modernization effort. Achieved complete transition to new system while maintaining existing system. Presented project plan to the CEO of major BI/DW vendor who recommended it as best practice.Developed metadata for Trizetto Facets™ insurance data model, as part of master data management initiative to unify reporting models.

Built and led a team responsible for enterprise data warehouse, business intelligence, ETL, data cleansing, KPI reporting and predictive analytics. Led design, development and maintenance of enterprise risk management system.

Designed applications for trading offices in London, Tokyo and Sydney. Developed reports for Equities, Commodity Futures, and Credit departments. Wrote user guides and trained users.