Senior PLSQL & BI Developer

American Express

1. Skills Set: Oracle BI, Power BI, Oracle SQL, PLSQL, PLSQL Functions, Procedure, Packages, Cursors, Bulk Collections, Query Performance Tuning, CTEs, Sub-queries, materialized views,
2. type of indices, dynamic partitioning, clustered tables.
3. Responsibilities/Accomplishments:
4. • Comprehensive understanding of security practices, including data-level security.
5. • In-depth knowledge of the Oracle BI ecosystem, encompassing Data Warehouse, ETL processes, data connectivity, data modeling, and reporting.
6. • Demonstrated ability in developing robust BI solutions within the OAS framework.
7. • Independently provided effective system solutions for data warehousing and BI reporting.
8. • Designed and executed data models, Dashboards, and visualizations to support actionable insights.
9. • Proficient in crafting complex SQL queries, optimizing joins, and utilizing database indexes for enhanced performance.
10. • Proven track record in optimizing reports, enhancing performance, and implementing database optimizations.

Team Lead (SQL & TSQL Developer)

Sequel System

1. Skills Set: Oracle SQL & PLSQL (Toad & PLSQL Developer), ETL Migration (ODI), Query Performance Tuning, Oracle BI reports and dashboards, Database Administration Tasks, Power BI reports and dashboards (DAX, Power Query, Power Pivot, Power Service)
2. Responsibilities/Accomplishments:
3. • Leading team of 5 members in the development of plsql packages and procedure.
4. • Held the position of Senior Database & BI Developer, focusing on Big Data technologies.
5. • Accumulated extensive experience in Oracle PL/SQL development at Sequel Systems Inc., Rawalpindi.
6. • Took a pivotal role in constructing a healthcare system with HL7 files integration, highlighting a deep understanding of healthcare intricacies

Team Lead PLSQL Developer

SITA

1. Skills Set: Oracle SQL, PLSQL, PLSQL Functions, Procedure, Packages, Cursors, Bulk Collections, Query Performance Tuning, Data migration, data modeling.
2. Responsibilities/Accomplishments:
3. • Held the role of Module Lead PLSQL Developer at SITA.
4. • Oversaw tasks associated with database administration (DBA) and focused on enhancing database performance.
5. • Proficiently contributed to the creation of comprehensive reports and interactive dashboards using Power BI.
6. • Demonstrated expertise in data modeling as a key component of the role's responsibilities.

Senior Database Consultant (TSQL)

Systems Ltd

1. Skills Set: Microsoft SQL Server, ETL Migration, Creating queries and TSQL Procedures and functions, Power BI Reports and dashboards
2. Responsibilities/Accomplishments:
3. • Functioning as a TSQL Database Support Developer with a focus on complex TSQL queries, stored procedures, and functions.
4. • Proficiently implementing Common Table Expressions (CTEs) and temporary tables as part of database development.
5. • Adeptly leveraging the ETL platform SSIS for data integration and transformation tasks.
6. • Contributing to reporting endeavors in SSRS and Power BI, utilizing advanced features such as DAX, Power Query, Power Pivot, and Power View.
7. • Skillfully engaging in cube design and MDX query development within the SSAS framework.

CECOS University

Database