Lead Technical Analyst - Reporting Service
National Bank of Abu Dhabi
مجموع سنوات الخبرة :17 years, 5 أشهر
-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
Teach SQL fundamentals I and II, PL/SQL and Forms & Reports tracks
as oracle developer under Forms &Report 6i
Teach and help students in all the Microsoft Office track to prepare them for the certification
certification ICDL and SQL (oracle 10g)