Principal Architect
Deutsche Boerse AG/Frankfurt Stock Exchange, STOXX
Total years of experience :23 years, 6 Months
Responsibilities:
- Designed and developed calculation engines for rule-based Selection and Weighting of constituents in stock exchange indices.
Tech stack: Oracle, SQL and PL/SQL
- Designed and implemented Reference Data loading processes.
Tech stack: Oracle, SQL and PL/SQL
- Engineered rule-based index composition processes for DAX/MDAX, STOXX, and bonds indices.
Tech stack: Oracle, SQL and PL/SQL
- Developed calculation processes for Index close value, Market Capitalization, and Adjusted prices based on Corporate Actions (split, merge, dividend) for various index families.
Tech stack: Oracle, SQL and PL/SQL
- Designed and developed an engine for forecasting future index composition based on predicted Corporate actions.
Tech stack: Oracle, SQL and PL/SQL
- Created a set of introspection tools to streamline troubleshooting of the index composition process.
Tech stack: Oracle, SQL and PL/SQL
- Established a Google Cloud Platform Python service application for index composition processes.
Tech stack: Google Cloud Platform, Python, sqlite, flask, google.cloud, functions_framework, pyparsing
- Established a Google Cloud Platform Python service application for corporate actions processing.
Tech stack: Google Cloud Platform, Python, Cloud SQL, fastapi, docker, cloud_run, htmx
Key Achievements:
- Pioneered universal rule-based Selection and Weighting engines, enabling highly scalable domain-agnostic item selection and weighting from customer-provided data. Implementation of the engines led to up 30 times faster performance and easier maintenance of processes.
- Led the redesign of composition rules for the DAX 40 index, resulting in improved performance and reduced calculation times from hours to minutes.
- Successfully revamped the STOXX Indices composition process, resolving performance issues and reducing calculation time for more than 15 thousand indices to less than a minute.
- Initiated the Corporate Actions 90-day Forecast project, optimizing calculation efficiency for STOXX indices composition forecasts. The process is fully automated and provides three quarters forecast for 15 thousand indices in matter of minutes.
- Developed introspection tools to empower non-technical teams to monitor index constituent selection decisions, alleviating the need for extensive technical analysis.
Responsibilities:
- Gathered and analysed requirements.
- Compiled an initial backlog of requirements.
- Led release and sprint planning.
- Ranked, estimated, and prioritized detailed requirements.
Responsibilities:
- Developed ETL processes and supported database procedures.
Project: Product and Valuation Control toolkit Development
Customer: SAP Headquarters, Walldorf, Germany
Role: Software Developer
Responsibilities:
− Developed components for SAP Smart Accounting for Insurance.
Data Architect at a Standard Bank project
Responsibilities:
- Designed a Data Warehouse (DW) for generating reports, dashboards, and cubes for bank subsidiaries in Africa, the central office, and external systems.
- Gathered DW and report requirements.
- Managed and controlled the DW implementation, documentation, and rollout.
Key achievements:
- Established a DW for producing reports in Africa and the central office, offering accurate, reliable, and highly available data.
- Improved DW performance, reducing loading times from 3-4 hours to 1-2 minutes.
- Reduced storage usage by approximately 5 times without sacrificing accuracy.
- Enabled parallel loading of DW structures.
- Ensured scalability to accommodate data from various countries and days without
performance degradation.
- Simplified DW data structures for ease of use by developers with basic SQL skills.
- Implemented data quality control with pre-conditions and post-conditions.
- Designed an adaptable architecture to accommodate new requirements and data sources seamlessly.
- Established thorough auditing of the DW data loading process.
- Documented DW structures and reports for efficient management and testing.
Lead Software Engineer at a Standard Bank project
Responsibilities:
- Designed, developed, and rolled out calculation engines for Impairments, Cost Centre Segmentation, Effective Interest Rate, and Average Balances.
- Generated posting files for SAP with calculation results.
- Sourced data for QlikView and Business Planning and Consolidation.
- Gathered calculation requirements and collaborated with data providers.
- Provided support for the calculators.
Key Achievements:
- Engineered calculators capable of running massively in parallel.
- Created a set of reports for end users to verify calculation accuracy independently.
- Designed calculators for flexibility in making calculation changes without major design modifications.
- Implemented data quality control with pre-conditions and post-conditions.
- Ensured a thorough audit of the calculation process.
Performance Achievements:
- Impairments calculator: Achieved calculations in under 1 minute, meeting the bank's expectations.
- Cost Centre Segmentation calculator: Reduced calculation time from 3 hours to 2 minutes.
- Effective Interest Rate calculator: Reduced calculation time from 2 hours to 10 seconds.
- Average Balances calculator: Reduced calculation time from 2 hours to 10 seconds.
Responsibilities:
- Led a 10-member design, development, and support team for BI solutions using an agile-like methodology.
- Acted as the liaison with clients to gather BI solution requirements and communicated these requirements to the development team.
- Implemented and supported BI solutions.
- Trained and integrated new team members.
- Designed and developed databases for BI solutions.
- Created ETL procedures.
- Troubleshooted performance issues in the database segment of BI solutions.
Key achievements:
- Developed and supported software for cost calculations of a large energy company with approximately 300 users.
- Designed, developed, implemented, and supported a BI solution with a web interface for data analysis for another large energy company with around 500 users.
- Designed, developed, implemented, and supported a BI solution with a web interface for data collection and analysis for a large steel company with 100 users.
- Contributed to the design and development of databases used in the projects, encompassing
auditing, master data management, data warehousing, OLAP engines, ETL procedures,
calculations, security, and document flow systems.