Over 10 years of experience (6 in New York) as a Programmer/
Muhammad Qasim Ikram
Executives Suites, Email: mqikram@gmail.com
Supreme Block Apt # 010 Telephone: +92-51-210-2759
F-11/1, Islamabad. Pakistan. Mobile: +92-333-511-8853
Summary
Over 10 years of experience (6 in New York) as a Programmer/Analyst with proficiency in analysis, design, development, migration, integration, testing, and implementation of multi-tier and client/server applications using PowerBuilder and J2EE with Oracle, Sybase and Microsoft SQL Server. Expertise in development and deployment of Distributed Components. Solid presentation, communication and collaboration skills. Well versed with all aspects of software life cycle from gathering functional and non-functional requirements to providing post-production support.
Education
Bachelor of Computer Science
Brooklyn College City University of New York (CUNY), USA
[PAKISTAN EXPERIENCE]
Society for International Help, Islamabad (07/2006 03/2007)
IT Consultant
I consulted for Society for International Help (New York) sister organization Tameer-e-Millat Foundation It is a non-for-profit organization that has been established since 1987 and running over 350 formal and non-formal schools in Pakistan. Development was done for both New York and Islamabad offices.
Worked as a lead programmer in the design and development of Donation Management System. DMS was developed using PowerBuilder 10.5. Database schema was created using PowerDesigner. Oracle 9i was used as a backend database.
Created several Oracle stored procedures for reports and data feeds.
Created Servlets and Java Server Pages (JSP) for various applications running in New York offices.
Created XML documents (by extracting data from DMS database) and their schemas for various data feeds. Also convert XML documents into HTML using XSLT.
Diallog CDMA, Islamabad (11/2005 6/2006)
IT Consultant
Diallog CDMA in collaboration with Great Bears International launched a WLL (Wireless Local Loop) service in Islamabad. I was responsible for development and integration of new and legacy applications at Diallog CDMA and its sister company Diallog Broadband.
Enhanced Franchise Registration System (FRS) by adding new reports and modules. FRS was developed in PowerBuilder 9.0 with Oracle 10g as a back-end database. Integrated FRS with Global Inventory Application by developing modules that retrieved inventory data into FRS by calling Enterprise JavaBeans of Global Inventory Application.
Developed PL/SQL packages consisted of stored procedures and functions used for various reports hosted by Franchise, Inventory and Customer Management Systems.
Developed various Enterprise JavaBeans (Stateless Session Beans and BMP Entity Beans) for Customer Management Application.
Extended Billing System by developing several servlets that retrieved billing data from database and passed it onto several other systems in the XML representation.
Documented several business processes that encompass Making of a Franchise. Analyzed,
re-engineered and implemented new processes by getting consent from all relevant departments.
Asian Development Bank, Islamabad (10/2004 10/2005)
IT Consultant
I worked as an Asian Development Bank consultant to Government of Pakistan at Ministry of Economic Affairs and Statistics (EAD). DMFAS (Debt Management and Financial Analysis System) was used by EAD to manage all external debt of Pakistan (over 35 billion US Dollars). DMFAS was developed by UNCTAD (United Nations Conference on Trade and Development) and used Oracle 8i database that housed over 500 tables.
Developed a Payment Authority Program (PAP) that enabled payment sections of Debt Management wing to generate payment authorities for loan repayments. PAP was developed using PowerBuilder 8.0 and was tightly integrated with DMFAS and relied on its database for all loan related information.
Developed Light Grant Management System (L-GMS). L-GMS provided browser based interface to Grant Recording Modules of DMFAS using J2EE architecture. Client tier was developed using Java Server Pages. Enterprise JavaBeans (Stateless Session Beans and BMP Entity Beans) were used to encapsulate all grant processing functions. A master servlet was developed as an intermediary component between JSP and EJB. L-GMS used Oracle 9i Application Server and Database.
Developed several stored procedures and functions that were used to segregate non-concessional and concessional debt in terms of interest and maturity. Also calculated Total Debt Quantum by preparing Debt Stock tables of public and publicly guaranteed debt.
Developed a Debt Management Manual that comprehensively documented functioning of all business processes employed by Debt Management Wing of EAD. Each process was documented, first by generating a detailed Process Map (UML Activity Diagram) and then by using
Business Process Restructuring Templates enlisting attributes like actors, cycle time, effort time, supporting system, etc.
Worked with debt expert and financial analyst and developed a presentation for the Prime Minister of Pakistan. Presentation included quantitative and sectored profile of foreign loans, sectored performance analysis, impediments to sectored productivity and recommendations for sectored allocation of future assistance. SPSS and Excel were used for NPV, regression and other analysis.
Conducted several presentations regarding automation and integration of various systems at EAD. Also imparted trainings in the usage of IT systems to the officers of EAD.
National Textile University, Faisalabad, Pakistan (05/2002 07/2004)
IT Consultant
National Textile University has been established since 1956 and has been producing graduates in all major areas of fabric sciences.
Worked as a lead programmer in the design and development of University Management System. UMS was developed using PowerBuilder 8.0. Database schema was created using Erwin 3.5. Oracle was used as a backend database.
UMS consists of Applicant, Student, Registration, Results, Accommodation, Advisor, Fines, Fees, Employee, Employee Compensation, Employee Vacation and a very extensive Reporting Module. Four modules for Testing Services Department were added later on.
Data was extracted from various legacy applications and pumped into Oracle using PowerBuilder pipeline and several PL/SQL stored procedures.
A very fast, intelligent and user-friendly search engine was developed to facilitate searcher through out the application. Search Engine supports Boolean searches and ascending and descending sorting of result set.
A very extensive reporting module was developed that included more than thirty reports. Reporting module provides pre-retrieval and post-retrieval filters for all columns of the reports. Sorting options in the module included ascending and descending sorts for one or all columns
[USA EXPERIENCE]
Ace Financial Services Group, New York (04/2001 01/2002)
Senior PowerBuilder Developer
Using insurance, reinsurance, credit derivative and proprietary investment products, ACE Capital Re provides risk capital in a wide variety of fields, including mortgage, structured credit, financial guaranty, commercial real estate residual value and title. I worked in the Product Development and System Maintenance Teams.
Worked as a lead programmer (four programmer team) in the design and development of Deal Tracking System. DTS was developed using PowerBuilder 7.0 and PFC. Database schema was created using Erwin. Oracle was used as a backend database.
Deal tracking system allowed underwriters and surveillance officers to keep track of reinsurance deals coming from various lines of businesses. DTS had deal tracking, client database, layers, cessions, reports, and surveillance schedule modules.
A very extensive reporting module was developed as part of a Deal Tracking System that includes more than forty reports covering both Assumed and Ceded Transactions.
Developed various stored procedures for deal processing and surveillance schedule modules. Several triggers were also created to replicate data to audit tables.
Created XML documents and their schemas for various data feeds.
Hong Kong Shanghai Banking Corp. (HSBC), New York (08/2000 - 03/2001)
PowerBuilder Consultant
HSBC is one of the largest banking and financial services organizations in the world. I worked on a back office Precious Metal Trading System (PMTS). Sybases Enterprise Application Studio 3.0 was used to develop and deploy the whole Application. Sybase Adaptive server hosted all the databases.
Precious Metal Trading System (PMTS) was a three-tier application. I developed and deployed several Jaguar components using PowerBuilder 7.0. Data retrieval for all drop down datawindows and reports were fashioned using components.
Enhanced and maintained Trade Processing Module (TPM). TPM enables the traders to enter, update, and control the establishment and settlement of precious metals trades.
Created several stored procedures for trade processing and inventory management modules.
Developed a Credit Limit System (CLS). Database schema and E-R diagrams were created using Erwin. CLS was a browser-based application. User interface was developed using HTML and CSS. Servlets were used for users authentication and data retrieval.
Enhance Financial Services Group, New York (07/1999 - 07/2000)
PowerBuilder Consultant
Enhance Financial Services Group is a leading provider of credit-based insurance and financial services. I worked in Application development group of Enhance Reinsurance. Primary development tool was PowerBuilder 6.5. CornerStone was also used on some projects. Oracle was used as a backend database.
Worked in the development team of LYNX. A GUI application developed in PowerBuilder that provided users with ability to input and analyze Time Series Reinsurance data. Lynx connected to an Oracle database and Oracle data warehouse. Application had extensive searching capabilities.
Developed various stored procedures and triggers to load data into Data Warehouse.
Created a Business Rules Application that employed browser base front end. User interface was designed using SilverStream Page Designer. Servlets were used to insert, update and delete business rules. SilverStream Application Server hosted all the servlets and web pages.
Developed INFOMOVE. A data loading application created using PowerBuilder pipelines. Input to Infomove consisted of various flat files and Microsoft Access databases.
Developed a reporting application using BRIO for screening equities data.
Created PERL scripts to preprocess flat files before they were loaded into data warehouse.
Created XML documents and their schemas for various data feeds.
CompInfo Inc., New York (06/1997 - 06/1999)
PowerBuilder Developer
CompInfo is a market leader in Case Management Systems with two flag ship products: Corporate LawPack and LawPack. I worked in the Product Development and System Maintenance teams. Responsibilities included were product enhancements, system maintenance and development of
customized reports and enhancements for various clients.
Developed a version control system to keep track of bugs. System was designed in PowerBuilder and connected to three databases (MS-SQL, Sybase and Oracle) simultaneously.
Developed applications to facilitate database migration for Sybase based clients. Data was extracted from clients' legacy applications and entered into LawPack according to business rules.
Migrated Corporate LawPack source code from PowerBuilder 3.0 to PowerBuilder 5.0. Removed all obsolete functions and modified major modules so that they were in compliance with new PowerBuilder standards.
Performed overall system testing with QA department. Identified potential user interface and business logic flaws. Conducted response time and stress testing.
Headed a team of developers and diagnosed potential Y2K bug in software. After source code scans, problem areas were identified and front and backend source code was modified.
Performed thorough system testing for Y2K. Gave a presentation describing Y2K issues and its ramifications.
BPA International, New York (06/1996 - 05/1997)
PowerBuilder Developer and Interactive Auditor
Interactive Arm of BPA International reports web sites traffic. Web server log files were analyzed using different tools and various Statistics like site usage, advertisements, and broken links are reported in monthly and quarterly reports.
Developed an application in PowerBuilder that analyzed web sites' traffic. Web server log files were processed and stored into a Microsoft SQL Server database. Reporting module has over 10 analytical reports.
Developed PERL Scripts for pre-processing and quick-analysis of web server log files.
Administered Microsoft SQL Server. Performed database creation, tuning, backups and restore.
Maintained a small network of Windows NT base clients and managed an FTP server.
Analyzed web sites traffic and structure using Interse, SiteAnalyzer, Webtrends, and various other reporting tools.
Computer Proficiencies
Modeling and Design Tools
Erwin, PowerDesigner, Borland Together.
Application Servers
Oracle Application Server, Sun Application Server, Tomcat, SilverStream, JRUN, IIS.
DBMS
Oracle, Sybase, MySQL, Microsoft SQL Server.
Reporting Tools
Brio, Crystal Reports, Infomaker.
Development Tools
PowerBuilder, Jbuilder, NetBeans, Stylus Studio Enterprise Suite, SQLNavigator, Toad, SilverStream, Xpediter, DreamWeaver, FrontPage, PVCS, MS Visual SourceSafe, Interse, SiteAnalyzer, Access, Paradox, Dbase III+, etc.
Languages
JAVA, SQL (PL/SQL and T-SQL), XML, C, PERL, PASCAL, HTML.
Scripting Languages
JSP, JavaScript, Korn Shell (Ksh).
Operating Systems
UNIX (System V and BSD). Linux (Red Hat), Windows 2000/NT/XP/9x