Faisal Bashir Email & Phone Number

Pakistan

Islāmābād, Pakistan

Islamabad

Developed templates and reports in Oracle BI Publisher in rtf format for the bank.Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.Attended weekly meetings with stakeholders for reports development requirement gathering.Implemented security by creating roles and groups.Debugged complex SQL queries.SQL query writing to fetch data for the entire bank and all the reports.Integrated BI Publisher with OBIEE. Created templates such as account ledgers, Income and expenditure, statement of account, statement of affairs and other reports for the entire bank.Worked with database administrators to optimize report performance through database tuning.Reports scheduling according to various departments requirement and placing on FTP.Automation of end of day reports generation through batch files and VB scripting.

Islamabad

A brief summary of the duties performed are:IBM DB2 Databases administration, maintenance, Replication, Consolidation, and performance tuning.Backup and Restoration of databases using control center and batch files.Database Replication using the DB2 Replication tool.Configure database manager and database parameter for different operations (Backup/Restore, Replication, etc).Catalog and un-catalog instance and database at local and remote clients.Import and Export data between different tables.Troubleshoot the database related problem using db2 problem determination.Performance tuning of databases.Creation of Stored Procedures using db2 development center.Developed various utility programs for the bank using J2SE and IBM DB2 version 8.2.Developed various complex GUI's, including dynamic menus using J2SE. Implementation, Training & Support of e-rapid banking application.E-rapid implementation and training in several branches of the First Micro-Finance Bank Ltd. Bea Weblogic installation, administration, deployments.Development and maintenance of banks official web site (www.fmfb.com.pk).LAN Troubleshooting.Working on the FMFB Report module using JSP and Tomcat, Crystal Enterprise.Implemented a reporting module using JRC.Report design and generation using Crystal Reports.

Developed various websites using technologies:ASP 3.0, IIS 5.0, CDO NTS, SQL Server 2000, MS-Access, JavaScript, .NET Framework version 1.1, C#, ASP.NET, Visual Studio .NET 2002, ADO.NET

Projects worked on: Hiring Website of Overseas Employment ServicesOES is an online hiring Web Application which provides facility to jobseekers and employers for registration, search/post jobs online by jobseekers and employers respectively, submission of resumes by jobseekers against the advertised jobs, and their search/selection by the employers, workspace provision for jobseekers/employers and also administration of job seekers and employers by the administrator.URL: http://www.faujioes.com.pk