Experienced senior business intelligence developer with over 20 years of experience in data warehousing and business intelligence focused on development and design of corporate wide reports using UI reporting tools. Led the analysis, design, development, testing and implementation of ETL components and trained all junior developers.
AREAS OF EXPERTISE:
Business Intelligence Applications: Power BI, Qlikview, Business Objects, Tableau
Database: SSIS, SSAS, SSRS, T - SQL, P/L SQ, Azure, Oracle, Terradata, Sybase, MS Access
Programming Languages: Python 3, Visual Basic .Net, VBA, Microfocus COBOL, Turbo Pascal 7.0
- Design and develop an automated reporting platform for Treasury and Capital Management department.
- Data warehouse developed using Microsoft BI stack.
- Extensive use of T-SQL including Stored Procedures, views, triggers and column store indexes.
- Develop and maintain ETL solution in SQL Server Integration Services (SSIS).
- Cube design & KPIs using SQL Server Analysis Services (SSAS).
- Automate processes using Control M and custom SQL metadata driven solution for jobs and error logging.
- Develop MI dashboards using Power BI dashboards.
- End to end business intelligence solution development for Confidential
- ETL using SSIS to SQL Server 2005 database and reports using SSRS.
- Financial reporting and automation of income statement, balance sheet and trial balance reports for Confidential