I am a Senior Business Intelligence Architect with 10+ years of deep expertise in data warehousing methodologies, dimensional modelling, ETL, reporting solutions, testing and delivery. I build critical data and analytics processes on projects for clients; creating governance methods and providing best practice guidance to maximize the value of solutions that deliver business insights and support data-driven decision making.
Worked on a complete BI solution that takes client’s data from Postgres databases and XML files from S3. Developed the data warehouse solution in Redshift, implemented ETL with stored procedures and CRON jobs and designed visualization with Domo and Tableau.
Built a complete BI solution using client data from a SQL Server database and XML files from the database. Developed the accompanying data warehouse solution with SQL Server, utilized stored procedures and SSIS for ETL processes and implemented visualization with Analyzer, Reporting Services, etc.
Manage SQL Server databases on the project, configured and maintained database servers and processes, monitored system health and performance, ensured high levels of performance, availability, sustainability and security, assist developers with query tuning and schema refinement, provided support for critical production systems, performed scheduled maintenance and supported release deployment activities after hours.
Senior Business Intelligence Architect / Technical Lead
2020 - Present (3 years)
Delivers data warehouse and ETL solutions as part of an agile team using advanced machine learning techniques to improve performance and processes.
Helps build and improve infrastructure, application and performance development and ensures tight security including data encryption, security groups, and environment scanning.
Ensures high-quality deliverables and implements DevOps and security best practices in fast-paced environments.