Bayt.com
Islam Sedawy Ali, Lead Technical Analyst - Reporting Service

Islam Sedawy Ali

Lead Technical Analyst - Reporting Service

National Bank of Abu Dhabi

Location
Egypt
Education
Bachelor's degree, Computer and Information System
Experience
17 years, 5 Months

Share My Profile

Block User


Work Experience

Total years of experience :17 years, 5 Months

Lead Technical Analyst - Reporting Service at National Bank of Abu Dhabi
  • Egypt
  • My current job since August 2008

-Good experience in PL/SQL and query optimization.
-Extensive experience in writing stored procedures, functions and views.
-Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures,
functions, and triggers.
-Over 5 years of experience in SQL Server 2005/2008.
-Over 5 years experience developing and supporting Crystal Reports XI 8 and Crystal Reports 8.
-Developed complex reports -- multi-functioned, leveled and grouped, summary functionality in main
reports providing detailed drilldown through On Demand Sub-reports
-Developed complex SQL queries including Sub queries, correlated queries, and Nested queries,
Unions, Intersect and Aliases.
-Take over all Database Development requests and maintenance for the IPCC system and
In-house Applications
-Responsible for any implementation, modifications and maintenance required by the
Central Bank of Egypt in reference to data retrieved from Databases
-Responsible for any implementation, modifications and maintenance required by I-Score
company and resolve any dispute requested from customers
-Responsible for maintaining NBAD Staff requirements in reference to reporting, databases
and file generation
- Strong analytical skills and resolving technical issues.
-Expertise in SQL reporting development.
-Expertise preparing report specifications and database designs to support reporting
requirements
-Successfully developed applications and systems in provided timeline.
-Worked on performance tuning of the SQL queries to improve data conversion process.
-Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing
SQL Queries.
-Tuned SQL queries and performed code debugging using TOAD.
-Related Projects :Migrate data from bank master system to intellect system, HR system,
Cheques for Collections Application, End Of Month Applications, Customized In-house
Reports and other related applications and systems

Oracle Instructor at Compusoft
  • Egypt - Cairo
  • January 2008 to September 2008

Teach SQL fundamentals I and II, PL/SQL and Forms & Reports tracks

Oracle Developer at Telemisr NEC
  • Egypt
  • January 2008 to August 2008

as oracle developer under Forms &Report 6i

ICDL instructor at Synergy
  • Egypt - Cairo
  • December 2006 to December 2007

Teach and help students in all the Microsoft Office track to prepare them for the certification

Education

Bachelor's degree, Computer and Information System
  • at sadat academy for management sciences
  • July 2006

certification ICDL and SQL (oracle 10g)

Specialties & Skills

SQL Server 2000 2008
+Endorse 0
Oracle SQL
+Endorse 0
Reporting Skills
+Endorse 0
C#
+Endorse 0
Web Development
+Endorse 0
Database developer
+Endorse 0

Languages

English
Expert

Training and Certifications

Developing Microsoft SharePoint Server 2013 Core Solutions (Training)
Training Institute:
Global Knowledge
Date Attended:
May 2014
Duration:
40 hours
2779B - Implement a Microsoft SQL server 2005 Database (Training)
Training Institute:
Synergy Professional Services
Date Attended:
January 2009
Oracle Database 10g : Forms & report (Training)
Training Institute:
Synergy Professional Services
Date Attended:
July 2007
Secure Coding Training (Training)
Training Institute:
SecureMisr
Date Attended:
August 2012
10266-Programming in C# with Microsoft® Visual Studio® 2010 (Training)
Training Institute:
Synergy Professional Services
Date Attended:
December 2010
10265-Developing Data Access Solutions with Microsoft® Visual Studio® (Training)
Training Institute:
Synergy Professional Services
Date Attended:
December 2010
10267-Introduction to Web Development with Microsoft® Visual Studio® 2010 (Training)
Training Institute:
Synergy Professional Services
Date Attended:
December 2010
2793 - Implementing & Maintaining Microsoft SQL server 2005 Reporting services (Training)
Training Institute:
Synergy Professional Services
Date Attended:
January 2009
Oracle Database 10g : programming with PL/SQL (Training)
Training Institute:
Synergy Professional Services
Date Attended:
July 2007
Oracle Database 10g : SQL Fundamentals I & II (Training)
Training Institute:
Synergy Professional Services
Date Attended:
July 2007