Sql Server Project Manager

Resume of Mo Ghadban

Mr. Ghadban is a Senior Systems Analyst and Database Specialist with over twenty years of experience in information technology and business systems. Mr. Ghadban roles usually involve data analysis, data transformation, data architecture and relational database design. He is a Microsoft Certified Systems Engineer (MCSE) as well as a Microsoft Certified Solution Developer (MCSD).

His areas of expertise include design, development and database administration using Sybase, SQL Server, MS Access, Visio, ER-Win and Visual Studio products. He has extensive experience in project leadership, client and web server systems development and implementation as well as computer support and training.

Mr. Ghadban’s specific skills include proven leadership abilities, data modeling, business analysis, and function analysis, the application of technology to business needs, assessment of user requirements and the ability to provide value-based solutions. He has excellent communication skills, both written and oral. Mr. Ghadban has proven his ability to work in a team environment as well as working on his own.

Project 1

Citizenship and Immigration

DBA

February 2007 – [Present] (66 months)

Reference:

Stephen March, Database Administrator

Email: *******.*****@***.**.**

Mr. Ghadban joined the team in time to provide MS SQL Server 2005 DBMS expertise to the DBA group. His strong skills with Management Studio as well as Integration Service(SSIS) and Reporting Services (SSRS) have proven to be very beneficial. Responsible for SQL Server security, creating and monitoring jobs, assisting with SQL and T-SQL constructs and migrating releases to the various testing platforms. Performing data analysis after migration. Responsible for relational database design using SQL RDBMS, DTS and SSIS package for data architecture and data migration. Performed troubleshooting of code and defects, analyzing queries, code and processes for MS SQL and MySQL databases and database management systems as well as managing and maintaining these DBMSs. Performed optimization reviews of SQL Server and identified missing indices and recommended required improvements. Responsible for implementation and ongoing enhancements to database maintenance jobs to provide required disaster recovery contingencies and to ensure optimal storage of data with accurate statistics and required database integrity. Involved in the data migration process to ensure timely and optimal execution of the migration process as well as perform volume testing as required to identify impact of data migration runs on OLTP application. Designed, developed and implemented scripts and SSIS packages to automate data migration and transformation procedures within MS SQL and MySQL database management systems. Exported/migrated the data as flat files and XML formats. This process involved the design, development and creation of databases on both platforms. During the pre-release phase, Mr. Ghadban provided DBA support to releases / migrations to the various pre-production environments. Day to day activities included monitoring the performance of the database servers in order to identify and correct bottle necks on the database servers, providing design, development and maintenance support to the application components. He reviewed existing indices to identify any indices that were not used by the optimizer. Assisted with the design and development of the database server architecture and configuration and implementation of the server hardware required for the database servers and associated documentation. Created the setup template and the installation and configuration scripts required for the installation and setup of new database servers as well as the documentation. Installed, configured and upgraded MS SQL Server and database management system versions 2000, 2005 as well as 2008. This upgrade included installing, configuring and maintaining SSRS, as well as creating monitoring reports. Created DOS batch files to ease the deployment of the MS SSIS packages. Carried out data analysis, data transformation, data architecture and relational database design during the creation of these packages and well as Data Warehouse cubes. Created weekly status reports and providing monthly updates to the team leader. Created several technical guides and build books that are currently being utilized by the development team.Conducted the assessment/analysis, setup and design of the CIC wiki databases using MySQL database management system. Managed and maintained the MySQL databases and database management systems which included their installation, configuration and upgrade. Designed, developed and implemented the automated data migrations between MySql and MS SQL Server. Installation and configuration of Sharepoint Server (2010) and Biztalk Server (2006, 2010)

Environment: RDBMS - SQL Server 2000/2005/2008, Veritas and Microsoft Clustering, Windows Server 2000,2003,2008, Visual Studio .NET, Clearcase, Reporting Services (SSRS) and Integration Services (DTS and SSIS), MySql, XML, Biztalk Server(2006,2010), Sharepoint Server (2010), Data Warehouse

Project 2

CRTC

Database Administrator

June 2011 – Present (13 months)

As the Data Database administrator, Mr. Ghadbans role was to assess the current SQL Servers and recommend improvements. These recommendations were implemented resulting in significant improvement in response time and client satisfaction. Mr. Ghadban helped coordinate and implement the migration from SQL Server 2005 to SQL Server 2008 R2. This included creation of several scripts to ensure a painless migration. Mr. Ghadban also played a key role in the tuning and configuration of the Business Objects implementation. This included researching and changing configuration setting, assisting in troubleshooting of reports and configuring the mail system.

Environment: Windows Server 2003/2008, SQL Server 2005/2008 RDBMS, SQL and T-SQL, Reporting Services (SSRS), Integration Services (SSIS)

Project 3

Public Service Labour Relations Board (PSLRB)

Data Migration Specialist/Database Architect

November 2008 – Sept 2010 (22 months)

As the Data Migration specialist, Mr. Ghadban was required to, using the list of data repositories, confirm the details of the information to be migrated and identify and convert the fields of information to be migrated. Determined that the best method of migration was a series of t-sql scripts and SSI packages As part of these migration scripts, Mr. Ghadban was responsible for the creation and maintenance of the database schema. Data Warehouse design and SSIS for Extract, Transform and Load (ETL)Mr. Ghadban provided reports based on the existing repositories to the Project Manager as well providing performance metrics on the conversion process. Responsible for data analysis, data transformation, data architecture and relational database design. Mr. Ghadban created the migration documents and install scripts used on this project. Mr. Ghadban was responsible for installing, configuring and upgrading MS SQL Server versions 2000, 2005 as well as 2008. Mr. Ghadban performed the data transformations using XML as the intermediate step.

Environment: Windows Server 2003, SQL Server 2005/2005/2008 RDBMS, SQL and T-SQL, SourceSafe, Reporting Services (SSRS), Visio, XML, SSIS

Project 4

Service Canada

FAIR System

DBA / Systems Analyst

November 2006 – March 2007 (5 months)

Mr. Ghadban’s role was to architect/design an RDBMS solution for the Service Canada FAIR team to allow for data entry, retrieval and reporting. SQL and VB script was utilized for data entry validation and checking. The system required data architecting and data transformation to load legacy data into the new database model. The system was designed with the various roles and responsibilities in mind. Mr. Ghadban created the users’ guide and systems manual.

Mr. Ghadban created all of the systems documentation for the FAIR application and headed several JAD sessions.

Environment: RDBMS MS-Access, MS-Excel, Windows Server 2000 and 2003

Project 5

Department of Foreign Affairs and International Trade (DFAIT)

DBA / Systems Analyst

October 2006 – November 2006 (2 months)

Reference:

Brad Ducker, Analyst

Phone: 613-***-****

Mr. Ghadban's role was to architect a reporting solution for DFAIT to meets its Treasury Board mandated vulnerability/risk assessment requirements (MITS) while performing data analysis, data transformation, data architecture and relational database design. Created a requirements and architecture document that was the basis of the proposed solution. Gathered requirements, interviewed business experts, conducted joint requirements sessions and implemented the proposed architecture. Installed, configured and upgraded MS SQL Server version 2000 and designed/developed and implemented the databases, users and roles, which included automated data migration and transformation procedures with the SQL database management system. Created the maintenance tasks to perform database backups.

Environment: Windows Server 2003, Visual Studio .NET, VB.net, ASP.net, RDBMS - SQL Server 2000, SourceSafe, Reporting Services, Visio, IIS, XML

Project 6

Immigration and Refugee Board

DBA / Systems Analyst

March 2006 – August 2006 (6 months)

Reference:

Sharon Moore, DBA

Phone: 613-***-****

Utilizing MS SQL Server 2000 RDBMS procedures, installed, configured and upgraded the MS SQL database management system and developed and implemented automated data migration and transformation procedures. Ensured that the SQL and T-SQL stored procedures followed the business rules. This included design, development, implementation, data analysis, testing and data validation of the R4 version of IRB’s ICMS. Created data architecture strategy and documentation, including DTS packages; to ensure that data transformed from previous versions adhered to the new database design.

Environment: Windows Server 2003, Visual Studio .NET, VB.net, ASP.net, RDBMS SQL Server 2000, SourceSafe, Reporting Services (SSRS), Visio, SSIS

Project 7

Canada School of the Public Service

DBA / Systems Analyst / Team Leader

September 2005 – March 2006 (6 months)

Reference:

Paul Carpentier, A/Manager, Operations

Phone: 819-***-****

Responsible for all aspects of SQL 2000 including installation, configuration and upgrades to the SQL database management system and server. Implemented the backup schedule and MS SQL Server 2000 maintenance jobs. Restored databases on an as required basis. Responsible for relational database design with MS SQL database management system. Responsible for DTS and SSIS package for data architecture and data transformation. This included managing and maintaining (troubleshooting, analyzing and optimizing) MS SQL databases and the database management system. Created, implemented and documented a naming convention for Server objects, assisting the report writers with creating and optimizing stored procedures. Designed and developed databases and workflows using Visio. Performed data migration to MS SQL Server 9 (2005) and developed and deployed automated data migration and transformation procedures. This included using T-SQL and SQL to design, develop and implement stored procedures and triggers to assist with the data migration. Monitored the database using performance monitor with specific PERFMON options. Used profiler to trace running queries and resolve deadlock issues. Assisted with the implementation of MOM for SQL Server monitoring as well. Assisted the developers with tuning stored procedures and ensured that keys were used in searches. Created triggers to assist with referential integrity. Index statistics were monitored and updated as required.Maintained database objects including create and drop of tables, views, triggers, stored procedures, users and UDF’s. Database scripting was utilized to complete this task. Created all of the reports using SSRS.

Environment: NT, MS-Access, Visual Studio .NET, VB.net, ASP.net, SQL Server 2000/2005, SSIS, SourceSafe, Reporting Services, MOM, Visio

Project 8

Foreign Affairs Canada (FAC)

Database Architect / Administrator / Systems Analyst

February 2005 – August 2005 (7 months)

Reference:

Brad Ducker, Analyst

Phone: 613-***-****

Responsible for the design, development and implementation of the databases using MS SQL. Using Visio, developed the standards documentation including naming conventions, coding convention and linked servers policies. Assisted with the installation and configuration of the SQL database management system, as well as the upgrade from SQL Server 7.0 to 2000. Participated as a systems analyst on several projects and developed the supporting stored procedures in support of the business rules.Created and maintained database maintenance tasks to ensure the smooth operation of the database server. Ran DBCC jobs to verify logs. Created and dropped database objects as required including tables, triggers, stored procedures and user defined functions (UDFs). Object scripting was used in the transition. Used profiler to trace various activities on the server including variables passed to stored procedures. Performed database monitoring, including tuning and retuning of indices. Developed and implemented automated data migration and transformation procedures and DTS packages with MS SQL database management system in order to migrate data from various sources to MS SQL and XML formats.

Environment: NT, MS-Access, Visual Studio .NET, VB.net, ASP.net, SQL Server 7.0/2000, SourceSafe, Crystal Reports, ERWin, Visio, XML, DTS

Project 9

Office of the Superintendent of Financial Institutions (OSFI)

DBA / Systems Analyst / Team Leader/Data Conversion

November 2002 – March 2005 (27 months due to overlap)

Reference:

Paul Arscott, DBA

Email: ****.*******@****-****.**.**

Responsible for the installation, configuration and upgrade of SQL database management system, as well as migration of applications, data and T-SQL stored procedures from SQL 7.0 to SQL 2000 RDBMS. This process included performing data analysis, and then design, development and implementation of DTS packages to automate and migrate the data from various environments (development, user acceptance testing and production). As part of this migration, assisted with the implementation of Kerberos authentication for web-based applications. These DTS packages were then converted to SSIS packages on SLQ Server 2005. Responsible for troubleshooting, analyzing and optimizing the SQL databases and the database management system. This included using query analyzer, SQL profiler and execution plans as part of the analysis. Determined the best method for receiving and processing Bank and Insurance Company returns. The decision to use XML code and associated schemas for data validation and migration into SQL Server database was well received and Mr. Ghadban developed and implemented automated data migration and transformation procedures to migrate the data nightly. Assessed client requirements, and guided as well as supported the client in determining their functional specifications and requirements, assessing and managing client expectations. To satisfy these requirements, provided Project Plans, data architecture document, database design, created/modified SQL and T-SQL stored procedures, provided MS-Access data transformations and Crystal reports, depending on requirements, which enhanced the delivery of the intended design specification. These multi-tiered applications were implemented using visual Interdev, client-server code and Visual Studio .Net.Provided design methodology guidelines to the development team, including implementation of several processes. Utilized the SQL server tools including Enterprise Manager, Query Analyzer and Query Profiler almost on a daily basis for tuning and debugging multi-tiered applications.

Environment: NT, MS-Access, Visual Studio .NET, VB.net, ASP.net, SQL Server 6.5/ 7/ 2000, SourceSafe, Crystal Reports, Visual InterDev, ERWin, Visio, XML

Project 10

Department of Justice (DOJ) - Concurrent Projects

DBA / Systems Analyst / Lead Developer

May 2001 – November 2002 (18 months)

Reference:

Kim Mathews, Senior Analyst

Phone: 613-***-****

Project 10.1

Responsible for assessing client requirements, and guiding as well as supporting the client in determining their functional specifications and requirements and assessing and managing client expectations on The Case Management System (CMS) (SQL Server v7). Responsible for the installation, configuration and upgrade of MS-SQL Server and RDBMS as well as troubleshooting, analyzing code and defects, and optimizing the database and the database management system. Designed, developed and implemented the database with MS SQL and developed and implemented the process for the automated data migration to MS-SQL for the various data sources as well as transformation procedures to assist in the data migration. Utilized the MS SQL server tools including Enterprise Manager, Query Analyzer and Query Profiler on a daily basis for tuning and debugging of multi-tiered applications. DTS was used to migrate data to SQL server.

Environment: NT, MS-Access, Visual Basic, RDBMS SQL Server 6.5/ 7/ 2000, SourceSafe, Crystal Reports, ERWin, Visio, DTS for data migration/conversion

Project 10.2

Mr. Ghadban was responsible for the site planning and analysis, functional and design specifications and implementation of a database driven web site application for the Anti-Terrorism bill at DOJ. Designed, developed and implemented the data architecture model, the physical database and the SQL/T-SQL stored procedures. The database backup and restore guidelines were created and tested. Using Data Transformation Services, designed, developed and implemented the automated data migration required by the Verity search engine. This multi-tiered system stored the data in an MS SQL Server 7.0 RDBMS, data access and report generation was provided through MS-Access RDBMS and an ASP driven web site. CSS and includes were used to conform to Treasury Board GOL guidelines for common look and feel. Troubleshot the database and application, analyzed code and defects and provided optimization for database and database management system. Provided ongoing support during implementation phases of the site. Database objects were scripted and applied as part of the migration from development to production. Developed all technical documentation such as functional and design specifications, code documentation including providing input to the initial application project plan and technical framework, version control is by way of file-folders and change request/enhancements use e-mail public folders. Created detailed test plans for all phases of applications built under this project performed under manual test procedures. Developed extensive documentation to address configuration management issues within the knowledge management process of site content.

Environment: NT, IIS, MS-Access, Visual Basic, Visual InterDev, FrontPage, ASP, SQL Server 7.0, and SourceSafe, ERWin, Visio

Project 10.3

Mr. Ghadban was responsible for completing the RALLI system and transforming it from a series of static web pages to a multi-tiered, RDBMS driven web site with dynamic content accessed from an MS SQL server 7.0 database. Provided input to the project plan as functional design specifications evolved. Conducted extensive data analysis of the existing site, including the facilitation of several JAD sessions. Rewrote the administrative front-end, made changes to the existing DB structure (created the data model) and added new stored procedures to support these business requirements. Wrote the system and user manuals. Provided management with proof-of-concept during the redesign and was responsible for reviewing detailed test plans for all phases of the application. He was also responsible for application implementation, testing, training and support.Developed documentation to include functional specifications, configuration / change management and code documentation which facilitated support to clients and effectively manage configuration settings for the database.

Environment: NT, IIS, Visual Basic, Visual InterDev, FrontPage, ASP, SQL Server 7.0 RDBMS, and ER-Win

Project 10.4

Mr. Ghadban converted an earlier version of an MS-Access RDBMS for the Litigation Services at DOJ. The Digest system allowed lawyers the ability to enter condensed versions of cases and then publish these to the intranet.

Responsible for conducting the testing for all phases of this application as well as data migration and transformation.Developed extensive documentation surrounding site functional and design specifications as presented with the project plan.

Environment: NT, IIS, HTML, MS-Access and Visual Basic

Project 11

Canada Post Corporation (CPC)

DBA / Project Lead

February 2001 – May 2001 (4 months)

CPC requirement was for a database that would allow them to schedule and track the deployment of new desktop and laptop computers. Worked with the Canada Post management team to provide proof-of-concept and prototypes to ensure client buy in. Performed database design, data architecture and data analysis and documented the RDBMS system to reflect developed functional specifications. The reports section utilized a number of complex queries that Mr. Ghadban created using SQL. Responsible for the creation and documentation of a detailed work plan and assigning tasks to the junior DBA during the application project-planning phase and through the project life cycle.Provided training and support to clients during and after application deployment. Responsible for data analysis, data transformation, data architecture and relational database design.

Environment: Windows NT/2000, MS Office 2000, MS Project 98

Project 12

Citizenship and Immigration Canada (CIC)

Project Leader

February 2000 – January 2001 (11 months)

Reference:

Sue Bigras, Director

Phone: 613-***-****

Mr. Ghadban’s knowledge of database applications, scope definition and work estimates greatly assisted the Data Warehouse Support (DWS) team in achieving their goals. This included data modeling using ER-Win and database normalization as well as the creation of ETL scripts for the dimensional model. Responsible for data analysis, data transformation, data architecture and relational database design. Created T-SQL stored procedure within Sybase RDBMS to perform the extraction and data transformation, by implementing automated data migration and transformation procedures. Extensive data analysis was required to ensure that the transformed data was of the highest quality. Provided the team with a detailed code documentation tool that allowed them to easily extract documentation from the T-SQL stored procedures. Provided the methodology training and assistance to junior team members to enable them to be successful. Provided work estimates and assigned and distributed tasks to the junior team members by the use of a structured work breakdown structure in creating the project plan. While on loan to the WISER Case Management team, provided the knowledge bridge between WISER and DWS. Mr. Ghadban provided the team with a detailed code documentation tool that allowed them to easily extract documentation from the stored procedures. Conducted detailed Unit testing of the application. Developed documentation to be referenced by project staff in providing ongoing support to applications and to also facilitate the training of junior team members. Updated functional and design specifications as required throughout the project life cycle. Provided troubleshooting, analysis and optimization of SQL database management systems, as well as ongoing support during implementation phases of the application.

Environment: Visual Basic, NT, Win 9x, RDBMS Sybase, SQL, MS-Access, OLAP, UNIX, ERWin, SourceSafe

Project 13

Ottawa-Carleton Regional Police Service (OCRPS)

DBA-SQL Server Specialist

July 1999 – January 2000 (7 months)

Reference:

Mila Goldfarb, DBA

Phone: 613-***-****

OCRPS has a variety of environments. Mr. Ghadban was contracted to provide on-demand support for any number of issues. Responsible for installation, configuration and upgrade of SQL 6.5 to SQL 7.0 database management system as well as for the development of policies for backup and restore strategies. Assisted in planning (capacity planning) and then migrating SQL server from 7.0 to 2000. Assessed and fine-tuned existing SQL Server objects (including triggers, stored procedures and table indexes). Query analyzer and Profiler were used to apply and then track the changes. Also provided troubleshooting, analyzing and optimizing the MS-SQL database management system. Audited database statistics and tuned indexes. Database objects were scripted, modified and then reapplied as required. After proper data analysis, Mr. Ghadban designed, developed and implemented the relational database design. Designed, developed and implemented the automated data migration and transformation procedures with SQL used to capture data nightly.

Environment: Visual Basic, Windows NT/ 2000, Win 9x, RDBMS SQL Server 7.0/2000

Project 14

Canadian Council on Health Services Accreditation (CCHSA)

Technical Project Manager

July 1998 – October 1999 (16 months)

CCHSA was incorporated in 1958 to set standards for Canadian Health Services organizations and assess their compliance against these standards. CCHSA is a non-profit organization and a registered charity. Mr. Ghadban was responsible for the project panning, scheduling and costing.

Mr. Ghadban assessed the impact of variations to the project and provided written and oral reports on his findings and recommendations. Mr. Ghadban provided guidance and direction to the developers with regards to managing client expectation, software design best practices, anomaly / problem tracking and management. Mr. Ghadban provided assistance with the RDBMS database normalization and structure. This three-tiered, object oriented application utilized VB 6.0. The team comprised Mr. Ghadban, three developers, up to nine testers and various support staff. MS project was utilized to enforce task allocation and to track progress of developers throughout the SDLC.

Mr. Ghadban was responsible for developing and reviewing detailed project test plans for all phases of applications built under this project. Mr. Ghadban provided to the client troubleshooting and ongoing support during implementation phases of the application. Mr. Ghadban was responsible for data analysis, data transformation, data architecture and relational database design.

Mr. Ghadban developed and documented Standard Operational Procedures (SOP) to facilitate the functional design specifications, development and support of applications and database systems.

Environment: Visual Basic 6.0, MS-Access RDBMS, MS-Project, and Win 95

Project 15

Department of Justice (DOJ) FOAEA

Senior Developer / Database Administrator

February 1998 – February 2000 (24 months)

Reference:

Mark Visneski, Senior Analyst

Phone: 613-***-****

Redesigned the database model; developed/enhanced stored procedures and created an MS-Access reporting system. Capacity planning was an important step to this process. As part of growing the system, the indexes were regularly audited and optimized. Database objects were scripted, modified and then reapplied as required. Responsible for data analysis, data transformation, data architecture and relational database design. His input contributed to the modification of the application project plan as well as the functional and design specifications of the system. This re-assessment included analysis of tools such as Data Transformation Services (DTS), replication, backup and recovery procedures. Provided SQL and T-SQL and programming expertise within SQL Server RDBMS in the development and testing of release 2.0 of the Case Management system. Architected the redesign of the database model using MS SQL database management system, this included installation, configuration and upgrade of the database management system; developed/enhanced T-SQL stored procedures and created an MS-Access reporting system. Responsible for developing and performing extensive Unit and System testing for all phases of the application. MS project was utilized to enforce task allocation and to track progress of developers throughout the SDLC.Developed and documented Standard Operating Procedures (SOP), which effectively allowed for the project team to provide ongoing support of the nationally deployed application as well as allow for the tracking and management support issues within knowledge management guidelines.Troubleshot, analyzed and optimized (provided ongoing support) the SQL database and database management system during re-deployment phases of this system. Assisted with the migration of Oracle data to SQL Server and developed and implemented the automated data migration and transformation procedures with MS SQL database management system.

Environment: SQL Server, VB, HAHTSITE, IIS, MS-Access, MS-Project, Win 95, Win NT, Erwin, Oracle, Visio

Project 16

Regional Municipality of Ottawa-Carleton (RMOC)

Data Conversion Specialist/DBA

September 1998 – February 2000

As part of the Year 2000 strategy, the Regional Municipality of Ottawa-Carleton (RMOC) had various requirements for migrating legacy data storage systems (Oracle, flat text and documents) to MS-Access and SQL Server 7.0 RDBMS. Responsible for data cleanup and conversion, the development of forms and reports for accessing the data as well as installation, configuration and upgrade of the complete SQL Server RDBMS. Created the data model based on user requirements. Created backup and restore strategies in support of the database applications. Used various tools to prepare the data for import to MS-Access and then to SQL Server. Change management processes were deployed to ensure that appropriate testing occurred. Provided client training and support. Created data architecture and designed/developed database using MS SQL.

Environment: MS-Access, Win 95, Oracle, SQL Server 7.0 RDBMS

Project 17

Public Works and Government Services Canada (PWGSC)

Project Manager / Business Analyst

November 1997 – February 1998 (4 months)

The Automated Petroleum Procurement System at PWGSC was to be migrated to new department standards. Mr. Ghadban's role was to analyze system functionality, conduct business analysis, create a data model, provide proof of concept and create a project plan. Problem analysis and resolution strategies were inclusive of this study which included reviewing the existing Oracle RDBMS database, interviewing end users, analysis of the data dictionary and interviewing users and system managers of related systems.

This provided a migration strategy to the new platform. The new platform was to be a three-tiered web based system using Visual Basic and ASP, with stored procedures and triggers handling the data. MS project was utilized to enforce task allocation and to track critical path items. Mr. Ghadban was responsible for data analysis, data transformation, data architecture and relational database design.

Mr. Ghadban provided his client with template screen designs for the re-development project, and utilized UML notations and guidelines for creating system process diagrams, a workflow diagram and the entity relationship diagram as well as the proposed work breakdown plan. Mr. Ghadban developed the normalized database model for the new system and created sample VB forms and ASP designs.

Environment: MS-Project, ERWin, Visio, SQL Server, VB, ASP, UML, COBOL, Oracle RDBMS

Project 18

Canadian Heritage

Programmer Analyst

October 1997 (1 month)

Mr. Ghadban developed, tested and implemented a browser independent database driven web application that allowed users to build business cases. The system prompted the user for various parts of the business case while providing examples of the current section being worked on. Upon completion, the system presented the user with a text version of their business case that they could then import into a word processor for final formatting.

Mr. Ghadban was responsible for conducting initial analysis of the existing application, reviewing detailed test plans for all phases of applications built under this project, which were performed under manual testing procedures. He contributed further to the project plan by designing and presenting revised functional specifications. Mr. Ghadban was responsible for data analysis, data transformation, data architecture and relational database design.

Environment: FrontPage, VB Script, ASP, MS-Access

Project 19

EXOCOM Application Solutions Corp.

Project Manager

December 1996 - October 1997 (11 months)

As Project Manager with EXOCOM, Mr. Ghadban performed managerial duties such as employee tracking, employee career planning and conducted prospective employee interviews. As well, Mr. Ghadban participated in Open Houses and Career Fairs. Mr. Ghadban led the Client/Server group and provided direction and mentoring to junior and intermediate consultants.

Mr. Ghadban was also responsible for cost estimations of projects that included the breakdown of work into tasks. These tasks then became the basis for the project plan. Mr. Ghadban was responsible for data analysis, data transformation, data architecture and relational database design for various projects.

Contact this candidate