About Me
Solution-oriented Senior BI Developer/Data Engineer with over 7 years of expertise in Database Design Development, ETL Implementation, and support of OLAP/OLTP/Data warehouse systems, Reporting, and Presentation. Highly …
Solution-oriented Senior BI Developer/Data Engineer with over 7 years of expertise in Database Design Development, ETL Implementation, and support of OLAP/OLTP/Data warehouse systems, Reporting, and Presentation. Highly motivated, well-organized team member with excellent analytical skills, capable of adapting quickly to roles and delivering results.
Experience
Bi Developer
● Ensured the timely and smooth functioning of SSIS packages.
● Maintained, developed procedures and scripts for seamless data migration.
● Maintained and debugged SSIS packages and jobs.
● Dealt with debugging any regular and occasional job failures and incidents.
● Collaborated with the reporting team to create insightful Power BI dashboards and paginated reports, facilitating data-driven decision-making.
● Liaised with external suppliers to resolve application-related issues.
● Worked on any other pertinent tasks related to stored procedures, views, and reporting.
● Provided training and mentorship to new interns, fostering a culture of continuous learning and development within the team.
BI Developer
<p>Ensured the timely and smooth functioning of SSIS packages.<br>
Maintained and developed procedures and scripts for seamless data migration.<br>
Maintained and debugged SSIS packages and jobs.<br>
Dealt with debugging regular and occasional job failures and incidents.<br>
Collaborated with the reporting team to create Power BI dashboards and paginated reports.<br>
Liaised with external suppliers to resolve application-related issues.<br>
Worked on stored procedures, views, and reporting tasks.<br>
Provided training and mentorship to new interns.</p>
BI Developer
<p>Designed and maintained reports and dashboards using Power BI and SSRS.<br>
Leveraged DAX measures to meet business requirements.<br>
Played a key role in the creation and evolution of the BI architecture.<br>
Ensured scalability and efficiency in data solutions.<br>
Led the implementation of row-level security in Power BI reports.<br>
Supported internal users in utilizing BI tools effectively.<br>
Provided technical assistance and troubleshooting expertise.<br>
Developed and implemented unit, functional, and integrated test scenarios.<br>
Worked with fellow specialists to establish governance rules and standards for business intelligence practices.<br>
Provided support to internal users.</p>
Sr. BI (SQL) Developer
<p>Developed complex analytic queries and T-SQL stored procedures.<br>
Optimized performance through query tuning and index optimization.<br>
Collaborated closely with FA and QA teams to streamline the development process.<br>
Enhanced product quality.<br>
Implemented logic and indexed tables, views, and stored procedures based on business requirements.<br>
Conducted unit tests and assisted in test preparations.<br>
Maintained data integrity and program quality.<br>
Debugged stored procedures and views following QA testing results.</p>
Data Engineer
<p>Led development efforts using SQL, SSIS, Power BI, and Azure Data Factory.<br>
Designed, developed, and maintained ETL processes for existing data warehouses.<br>
Built workflows in Azure Data Factory to automate data flow.<br>
Migrated on-premise SQL Server schemas to Azure cloud environments.<br>
Developed and automated reports and dashboards.<br>
Created scalable reporting solutions and data visualizations using Power BI.<br>
Implemented row-level security measures in Power BI reports.</p>
BI/ETL Developer
<p>Analyzed and optimized ETL processes.<br>
Developed strategies for cleaning and integrating complex healthcare datasets.<br>
Exported data from various sources to Azure Blob storage using Azure Data Factory.<br>
Configured SSIS packages for diverse environments and configurations.<br>
Collaborated with clients and internal teams to support complex data management projects.<br>
Designed and implemented SQL scripts and stored procedures for data manipulation.<br>
Implemented incremental loading processes and data synchronization strategies.<br>
Automated manual tasks to streamline operations and improve efficiency.</p>