Associate Analytics and Intelligence Principal at Azentio Software (2021-12 – Present)
Leading the implementation of BI/RM/CMS solutions for banking companies, conducting performance tuning and optimization activities on BI systems, training end-users, and planning ongoing projects.
- Successfully led the implementation of BI/RM/CMS solutions for large banking companies, resulting in improved data visibility using Microsoft BI stack layers.
- Conducted performance tuning and optimization activities on BI systems, improving query response times, reducing data processing bottlenecks, and enhancing overall system performance.
- Received positive client feedback and recognition for delivering high-quality BI solutions on time, exceeding client expectations and driving successful business outcomes.
- Train end-users, enabling them to effectively analyze and interpret data, make data-driven decisions, and maximize the value of the BI solution.
- Designed and implemented a data warehouse using Microsoft SQL Server Integration Services (SSIS), enabling data integration from multiple sources and providing a centralized and reliable data repository for reporting and analysis.
- Developed and deployed interactive dashboards using Microsoft Power BI, allowing business users to easily explore and interact with data, leading to faster insights and data-driven decision-making.
- Optimized data transformation and loading processes using Microsoft SQL Server Analysis Services (SSAS), improving performance and reducing data processing time, resulting in quicker report generation and analysis.
- Collaborated with business users to gather requirements and designed and implemented tabular data models using Microsoft SQL Server Analysis Services (SSAS), enabling advanced analytics and reporting capabilities.
- Conducted training sessions workshops for end-users to promote adoption and proficiency in Microsoft BI stack solutions, empowering them to leverage the tools capabilities and make data-driven decisions.
- Plan ongoing projects: CMS/IFRS9/RM/BI
Associate Analytics and Intelligence Principal at Path Solutions (2020-08 – 2021-12)
Extensive experience working with BI tools and SQL Server technologies. Developed SSIS packages, created database objects, built data warehouses, and led product management responsibilities.
- Extensive experience working with BI (SSIS, SSAS, SSRS, PBI) and T-SQL using SQL Server 2012/2014/2016/2017/2019.
- Experience in writing, developing and creating new database objects such as tables, views, indexes Complex stored procedures, function, cursors, locking issues, Backups, Recovery and SQL Agent Server profiler.
- Experience in developing SSIS packages for data migration between different heterogeneous sources such as flat files, excel, Oracle, Sybase. Proficient in extraction Transformation and Loading (ETL) process by pulling large volumes of data from various data sources using SSIS.
- Hands on experience loading Data warehouse for both Dimension and fact tables.
- Created reports such as parameterized, Drill through/Down reports using Relational Data warehouse, OLAP cubes and tabulars. Experience in generating reports for OLAP and Tabular model databases.
- Developed SSAS tabular models.
- Experience in generating on-demand and scheduled reports for business analysis and management decisions using SSRS and Power BI.
- Lead a role in product management team to gather and analyze details related to the product Cash Monitoring System.
Senior Business Intelligence Engineer at Path Solutions (2013-06 – 2020-08)
Data collection, integration, modeling, transformation, and analysis. Created reports and visualizations using SSRS and Power BI. Gathered business requirements, optimized BI system performance, provided training and support to end-users.
- Data Collection and Integration. Collect data from various sources within the organization, such as databases, data warehouses, and external systems. Also ensure the data is integrated and consolidated for analysis.
- Data Modeling and Transformation. Design and develop data models that support business requirements.
- Data Analysis. analyze data using analytical techniques SSAS to identify trends, patterns and insights.
- Reporting. create reports and visualizations using SSRS and Power BI
- Create Power BI reports in different mode of connections (Live, Import, Direct Query).
- Business Requirements Gathering. Collaborate with business stakeholders to understand their information needs and define requirements for BI solutions
- Performance optimizer. optimize the performance of BI systems by fine tuning queries, optimizing data models. Ensure data retrieval and faster response times for reports and dashboards.
- Provide training and support to end-users on BI tools and application.
- Assist users in interpreting data, generating reports, utilizing self-service BI capabilities.
- Continuously monitor and evaluate the effectiveness of BI solutions. Identify areas for improvement, propose enhancements, and implement best practices to enhance the overall BI capabilities of the organization.
