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.
Work history
UpStack
Senior Business Intelligence Architect / Technical Lead
2020 - Present (3 years)
Remote
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.
Develop data architecture solutions in AWS to support the provision of scalable and efficient data; leveraging advanced expertise in mining structured, unstructured and transactional data.
Applied data analysis, data modelling and new technologies and techniques in delivering exceptional customer experience solutions for Tradeshift.
Gather and document business requirements to design and develop data warehouse data models, technical requirements, prototypes and end-state products for clients.
Managed BI and ETL projects from start to finish; assessing business trends and requirements, developing appropriate technology solutions, and leveraging existing technologies.
Designed and developed data warehouse data models; focusing on database architecture, data modelling, data analysis, software design, programming and application integration.
Studied, troubleshot and configured IBX Business Network's scheduling system, optimized ETL operations and implemented various solutions.
Business Intelligence and Reporting Solutions / Senior Developer
2008 - 2012 (4 years)
Bucharest, Romania
Designed, developed and maintained complex reporting and business intelligence solutions for customers from local and international markets.
Monitored performance and managed parameters for the provision of fast query responses to users; working with best practices for data loading and extraction.
Evaluated and recommended improvements to system software or hardware architecture; ensuring that delivery meets agreed requirements.
Analyzed and optimized the MSSQL Server production databases, advanced MSSQL development to meet client expectations and administered the ERP system for better response at users needs.
Participated in maintenance reviews, SQL optimizations, disaster recovery planning and testing, and custom software database support.
Provided best practice guidance to ensure database security, back-up and recovery procedures, replication and log shipping system.
Oversaw database administration tasks on SQL Server databases; assuring database design, implementation and integration to access relational database management systems.
Trained local users on SQL Server databases and handled the implementation, integration and maintenance of third party software solutions, report generation.
Improved calculus performances and query optimization, elaborated reports, fixed malfunctions and worked on database backup plans.