North York, Ontario, Canada, (416) 356-6205
moustafa@moustafarefaat.com, www.moustafarefaat.com
Over 20 years of experience developing software solutions, leading the Architecture, Design, Coding ,and Refactoring of many large projects .At CanITGigs.Info designed the web UI experience with Silver Light, at TCPL acted as the technical lead for the BizTalk Refresh project. At TDL designed and built the Enterprise Service Bus based on BizTalk and SQL, at Livingstone Intl provided Architecture Guidance and BizTalk Knowledge transfer to guide the upgrade of the client integration applications to BizTalk 2006. At Deloitte DMGF, salvaged the ADP project, provided technical guidance to establish self reliant BizTalk group. At Newfoundland and Labrador Prescription drug plan, delivered superior solution to integrating feeds from pharmacies, government, drug price providers and adjunction software. At FCT led the architecture for several project in parallel. Published two books and acted as a referee for the IEEE Software magazine. With International and US experience in Financial, Insurance, Health, Banking, Retail, Oil and Gas, Marketing and Telecommunications services automation.
SUMMARY
· BizTalk (6+); MOSS/WSS (5+); C# (8+); .Net(8+); Architecture (15+); ASP.Net (8+); WCF&WF(2+);WPF(0.25), Silver Light(0.25) Ajax(0.5); C++ (20+) years in CA, USA, UAE, Egypt
· Experienced in IT (10+); Banking/Financial (7+); Telecom (6+); Insurance (1.5+); Health(1.5+); Government(0.5+) years
· Authored two books on BizTalk
· Successfully managed/lead 25+ projects (7+ projects simultaneously) with values ranging up to CAD$20 million
· Directly managed teams of 15+ staff; Internal Partners and External Vendors management
TECHNOLOGY
Database Management Systems (DBMS) – Oracle, MS SQL Server, Informix, MS Access, DB2
Languages – C++, C#, Java, JavaScript, T-SQL, XML, CSIO XML Business Messages Specification 3.4.1, HTML, Visual Basic, UML, MDX, C, DSML, WSDL
Platforms – Windows, Linux, Unix, ASP.Net, Apache, Office Add-ins, Web Services, ActiveX Controls, Web Applications, Windows Security, BizTalk 2002-2009, WSS and MOSS 2003-2007, Web Sphere, MCMS, K2.Net, Exchange Sever 2003- 2007, Great Plains, DotNetNuke, MS Dynamics, Ecommerce 2002,-2007, SAP, Lotus Notes, MS Dynamics CRM, MS Dynamics GP, Amazon AS 3, Azure,WCF, WF, Silver Light, WPF
Tools – VSS, SCMS, Bounds Checker, Purify, Quantify, Ms Office, Rational Rose, Visual Studio, Host Integration Server
Software Engineering & Methodologies – Refactoring, RAD, RUP, Securing systems, Cryptography, S/W Testing, Testing Automation, Enterprise Applications Architecture, Test Driven Development, Personal Software Process, Zachman Framework, PMBOK, Sarbanes-Oxley, Six Sigma, CMM, CMMII, SDLC, HDLC, ISO, ITIL, OOA, OOSA, OOSD, HOOD, SSADM, Design Patterns
PROFESSIONAL EXPERIENCE
Client: Toronto Star May 2009 - Present
Role: BizTalk Developer (Training 40%, Design 20%,Coding 30%, Support 5%,Testing 5%)
· Project Management – Created list of activities and allocated resources into the project plan.
· Design – Worked with BA to gather and verify requirements; Reviewed requirements with stakeholders; Designed the solutions for various interfaces (EMMA, NewsGate, RIPS) and designed a robust and reliable BizTalk and SQL Sever Clustered environments: Production, Testing, QA and Development, design the strategy for integrating BizTalk with Ms Dynamics
· Implementation – Developed the interfaces and code for (EMMA, NEwsGate, RIPS), coded the schemas, orchestrations, pipelines, pipeline components, Custom Adapters, and custom functiods, Deployed the interfaces to QA, Staging and Production, and followed up with the stakeholders (building, installation, setup, etc.) Implemented and built the BizTalk infrastructure for staging, production and QA. Provided support to QA, developers and administrators
· Testing – performed unit testing and integration testing
· Training- Provided technical support and BizTalk Subject matter excerpt for the group. Trained the developers on how to develop BizTalk Custom adapters, Trained the Administrators on how to administer BizTalk Environment
· Handover – Trained Toronto Star permanent employees on the solution and how to test the environment
Key Technologies: C#, XML, web Services, Design Patterns, XSLT, SQL Server, BizTalk 2006 R2, WCF, Infrastructure Design, UNIX, SSH, SSH Scripting, SharePoint, MS Dynamics
Client: AS3 SharePoint Archiver Jan 2009 - Apr 2009
Role: Developer (Design 40%,Coding 40%, Testing 20%)
· Project Management – Created list of activities and allocated resources into the project plan. Reviewed Project Plan with Client
· Design – Gathered Requirements; Reviewed Requirements with Client; Designed the solution for a robust and reliable environments: Production, and Testing
· Implementation – Led the implementation phase, Developed and coded several application pages, timer jobs and web parts the functionality
Key Technologies: MOSS 2007, WSS 3.0, Amazon Storage Services 3.0
Client: Burntsand, Toronto, ON January 2009 – February 2009
Role: MOSS Instructor (Training 100%) Team(8)
· Training and Knowledge Transfer – Instructed 8 Burntsand permanent employees on MOSS 2007 using Microsoft Official courses 3370, 3374, and 5061
Key Technologies: MOSS 2007
Client: TransCanada Pipelines (TCPL), Calgary, AB July 2008 – October 2008
Role: Technical Lead and BizTalk Designer (BizTalk Refresh Project) (Design 100%) (Team 15+)
· Leadership- Technical team lead for the project.
· Project Management – Created list of activities and allocated resources into the project plan.
· Design – Gathered Requirements; Reviewed Requirements with Client; Designed the solution for a robust and reliable BizTalk and SQL Sever Clustered environments: Production, Testing, QA and Development; Reviewed the Design with Microsoft and get it Approved
· Implementation – Led the implementation phase, followed up with the stakeholders (building, installation, setup, etc.)
· Testing – Managed performance testing of the BizTalk ESB infrastructure for TCPL
· Handover – Trained 8 TCPL permanent employees on the solution and how to test the environment
Key Technologies: C#, UML, XML, web Services, Design Patterns, XSLT, SQL Server, BizTalk 2006 R2, WCF, Infrastructure Design, Oracle, MS Dynamics CRM and Great Plains
Client: Tim Horton’s Group, Toronto, ON April 2008 – October 2008
Role: Senior BizTalk Consultant (SAP-Lotus Notes Integration Project) (Design 60%, Coding 40%) Team (4+)
· Analysis – Analyzed the existing BizTalk environment and designed the Infrastructure for a new BizTalk environment
· Design – Designed BizTalk based integration interfaces: ClearView Interface; Expesite Interface and Frameworks Interface; Designed SAP to Lotus Notes BizTalk Proof of Concept; Designed new infrastructure (including Windows Cluster, SQL Cluster, BizTalk Cluster and IIS Cluster)
· Implementation – Developed BizTalk based integration interfaces: ClearView Interface, Expesite Interface, Frameworks Interface; Developed SAP to Lotus Notes BizTalk Proof of Concept; Developed new infrastructure (including Windows Cluster, SQL Cluster, BizTalk Cluster and IIS Cluster)
· Testing – Managed performance testing of the BizTalk infrastructure for TDHL
· Knowledge Transfer – Trained full-time staff on BizTalk, how to integrate SAP and Lotus Notes and the implemented interfaces
Key Technologies: Net, C#, 2005, UML, XML, Web Services, Design Patterns, EAI, XML Schemas, XSLT, SQL Server, WCF, BizTalk 2006 R2, SAP, SAP DOTNET Connector, SQL 2005,SQl 2005 Reporting, Lotus Notes, COM, DCOM, Oracle, SAP Payroll Module
Client: CanITGigs.Info CanadainGigs.Net, Toronto, ON Dec 07 – Present
Role: CTO , Technical Lead (Design 50%,Coding 60%) (Team 5+)
· Project Management – Created list of activities and allocated resources into the project plan. Reviewed Project Plan with Client
· Design – Gathered Requirements; Reviewed Requirements with Client; Designed the solution for a robust and reliable environments: Production, and Testing
· Implementation – Led the implementation phase, followed up with the stakeholders (building, installation, setup, etc.), Build Solution Concept. Developed the core functionality
· On Going Support and Modifications
Key Technologies: ASP.Net, WCF 3.5, WF 3.5, AJAX, Silver Light, SQL 2008
Client: Livingston International, Toronto, ON November 2007 – February 2008
Key Technologies: .Net, VB Visual Studio 2005, UML, XML, Web Services, Design Patterns, EAI, XML Schemas, XSLT, SQL Server, BizTalk 2002, BizTalk 2006, Ecommerce
Role: Senior BizTalk Consultant (BizTalk 2002 to 2006 Migration Project)
· Analysis – Analyzed and evaluated the current Partner integration systems built on BTS 2002
· Design – Created a strategy to migrate the systems from BTS 2002 to BTS 2006, provided guidance and strategy to enhance and fix the issues with the current implemented systems
· Training – Mentored/educated the current staff on BTS 2006 and best practices and industry standards for building systems with BTS 2006
Client: Deloitte, DMGF Toronto, Toronto, ON February 2007 – October 2007
Role: Senior BizTalk Consultant (Active Directory Provisioning (ADP) Solution Project) (Design 60%, Coding 40%) Team(3+)
· Analysis – Documented and evaluated the Active Directory Provisioning Solution, Design – developed a strategy to enhance and fix the issues with the existing ADP implementation, designed a solution to replace RUS for Exchange 2007, Designed a solution to integrate with Exchange 2007 based on the Power Shell extensions
· Implementation – Maintained and improved the existing implementation, implemented integration with Russia, an Belgium
· Testing – Managed performance testing of the BizTalk infrastructure
· Knowledge Transfer – Interviewed 2 BizTalk candidates, Mentored and educated 3 full time (Region 10 India) about the solution and the recommended enhancements
Technologies: .Net, C#, Visual Studio 2005, UML, XML, Web Services, Design Patterns, EAI, XML Schemas, XSLT, SQL Server, BizTalk 2004, ASP.Net 2.0 , Power Shell, DSML, Exchange 2007, WCF, MS Project 2003
Client: Newfoundland and Labrador Government, St. Johns, NFLD October 2006 – February 2007
Role: BizTalk Architect (NFLD Prescription Drug Program) (Design 50%, Coding 50%) Team(5+)
· Project Management – Created list of activities and allocated resources in project plan
· Analysis – Worked with the team to define an implementation plan, clarified and validated the requirements
· Design – Designed an integration solution and the infrastructure between Pharmacies Systems, Government Systems, Drug Price providers systems, Fax Server and the Adjudication software Design of interfaces using CSIO XML Business Messages Specification 3.4.1
· Implementation – developed, implemented the solution and built the infrastructure environment, Development of interfaces using CSIO XML Business Messages Specification 3.4.1
· Training – Trained the Operations team on how to install, and support the solution implemented, Coached Maintenance team on: BizTalk 2006, the solution design and implementation and how to modify parts of the solution
· Testing – Managed performance testing of the BizTalk infrastructure for NLPDP project, preformed unit testing, and integration testing
· Knowledge Transfer – Created the solution Technical guides (Implementation, Build, Design); provided technical support to the operation and maintenance teams
Technologies: .Net, C#, Visual Studio 2005, UML, XML, CSIO XML Business Messages Specification 3.4.1 Web Services, Design Patterns, EAI, Microsoft Project, XML Schemas, XSLT, SQL Server 2005, Oracle, Microsoft Enterprise Library, BizTalk 2006, Win Fax CPHA V3 ,
Client: Canadian Tire Corporation (CTR), Toronto, ON February 2006 – July 2006
Role: SharePoint Senior Consultant (Design 40%, Coding 20%, Mentoring 40%) Team (9+)
· Projects - Store Communication Portal Project, Lotus Notes Migration to SharePoint Project
· Analysis – Reviewed and Inspected Design and code of 3rd party provider solution
· Design – Defined the procedures and standards for the SharePoint, MCMS and .Net development, Provided guidance in transitioning CTR form Lotus Notes and Java to SharePoint, C#, and the .Net platform
· Implementation – Coded proof of concept for migrating existing lotus applications to SharePoint
· Training – Mentored CTR internal Team on SharePoint, MCMS, .Net, K2.Net, C#
Technologies: .Net 1.1, C#, Visual Studio 2003, UML, XML, Web Services, Design Patterns, EAI, Microsoft Project, XML Schemas, XSLT, ASP.Net, SQL Server 2000, Microsoft Enterprise Library, SharePoint 2003, Microsoft Content Management (MCMS) 2002, K2.Net, .Net 2.0, Visual Studio 2005, Crystal Reports
Client: Canada Cartage, Toronto, ON November 2005 – January 2006
Role: Senior Consultant Integration Project
· Analysis – Worked jointly with the team to resolve technical issues and code reviews
· Design – Designed the solution for interfacing between the Great Plain and Freight Logic and Ordering System
· Implementation – Delivered the solution for interfacing between the Great Plain and Freight Logic and Ordering System
· Knowledge Transfer – Documented options and rationale all decisions made and Provided technical support for the Canada Cartage full time team
Technologies: .Net , C#, UML, XML Web Services, BizTalk , Great Plains, Design Patterns, EAI, Microsoft Project, XML, XML Schemas, XSLT,, SQL Server
Client: Hudson’s Bay Inc., Toronto, ON August 2005 – November 2005
Role: Senior Consultant (HBC Olympics Web Site Project, AOL Promotions Services Integration Project) Team(7+)
· Analysis – Worked jointly with the team to resolve technical issues and code reviews
· Design – Designed the solution for interfacing between the HBC back office and IBM Web Sphere hosting services – and several web services
· Implementation – Delivered the solution for interfacing between the HBC back office and IBM Web Sphere hosting services – and several web services
· Training – Documented options and rationale all decisions made and Provided technical support for the HBC full time team
Technologies: .Net , C#, VB.Net, UML, XML Web Services, Design Patterns, EAI, Microsoft Project, XML, XML Schemas, XSLT, ASP.Net, SQL Server, COM+, ADO.Net, Microsoft Enterprise Library, Visual Source Safe, IBM Web Sphere, Crystal Reports
Client: First Canadian Title Insurance Company, Oakville, ON February 2005 – August 2005
Role: Enterprise Architect (Design 100%) Team(10+)
· Projects – PPSA/Chattel 3rd Party Integration Project; Commercial to TIME Migration Project; Lawyer ID Project; Motion Releases 7/8/9 Projects; Identity Management Project
· Analysis – worked with the stakeholders on defining a solution concept for the Projects simultaneously ; Worked jointly with IT and business team mates, subject matter experts (SME) and stakeholders to gather track and maintain record of decisions and ownership made with respect to or impacting on projects architecture, development, Performed Code Review; Reviewed QA Test Plan; Reviewed Detailed Design Documents Performed Requirements Analysis and Solution Options; Created and Delivered the Interface Design Specifications Document, preformed gap analysis for CSIO XML Business Messages Interfaces, Analysis of the requirements for CSIO XML Business Messages new interfaces.
· Design – Defined the solution architecture documentation, Performed Requirements Analysis and Solution Options; Created and Delivered the Interface Design Specifications Document, Design of interfaces using CSIO XML Business Messages Specification 3.4.1 and upgrading existing ones from 3.3.0
· Knowledge Transfer – Defined the solution architecture documentation , Documented and maintained options and rationale (i.e. pros and cons) for all Architectural decisions
· Vendor Management – Reviewed Detailed Design Documents; Interface with different software vendors; Provided Technical support for developers
Technologies: Solution Architecture ,SOQ, Power Point, Rational Rose XDE, CSIO XML Business Messages Specification 3.4.1 & 3.3.0 .Net , C#, BizTalk (2004,2002), MSMQ, UML, XML Web Services, Design Patterns, EAI, Microsoft Project, XML, XML Schemas., ASP.Net, SQL Server, ADO, COM+, ASP, VB 6, VB.Net, ADO.Net, Microsoft Enterprise Library, Visual Source Safe, IBM MQ-Series, Share Point Portal 2003
Client: Bell Simpatico MSN Streams Modernization, Toronto, ON November 2004 – February 2005
Role: Principal BizTalk Consultant (News Streams Modernization Project) (Design 40%, Coding 60%) Team(5+)
· Design – Designed Schemas for the different messages from the different streams, Designed the Maps to transform the different provider messages to Bell NewsML /SportsML private schemas Designed the database and the stored Procedures Designed different Orchestrations to implement the business logic
· Implementation – Created Schemas for the different messages from the different streams Developed the Maps to transform the different provider messages to Bell NewsML /SportsML private schemas Developed different Orchestrations to implement the business logic
· Testing – Performed Unit Testing on the core parts of the code; Reviewed team member’s code/design
· Training – Mentored the team members on BizTalk, XML Schemas and the project design, Provided technical support for the developers; supported the development team and the QA team
Technologies: Rational Rose XDE, .Net , C#, BizTalk 2004, UML, XML Web Services, Design Patterns, EAI, Microsoft Project, NewsML, SportsML, XML, XML Schemas., Microsoft Content Management System, ASP.Net. SQL Server, ADO.Net, Microsoft Application Blocks, Source of Site
Client: Great West Health Insurance, Toronto, ON July 2004 – October 2004
Role: Senior Software Designer (Web Modernization Project) (Design 40%, Coding 60%) Team(15+)
· Analysis – Worked with the stakeholders on analyzing and revising use cases, requirements
· Design – Designed the Business Logic Layer, worked with team on designing the UI layer and mainframe integration layer
· Implementation: develop web parts for SharePoint; and orchestration in BizTalk
· Testing – Performed Unit Testing on the code ; code reviewed other team member’s code
Technologies: Rational Rose XDE, ASP.Net, .Net , C#, SharePoint Portal 2003, BizTalk 2004, Webparts, UML, Web Services, Design Patterns, EAI, Microsoft Project
Client: Bank of Montreal, Toronto, ON March 2004 – July 2004
Role: Software Consultant (BMO Connect R2 Project) (Design 60%, Coding 40%) Team(5+)
· Project Management – Created list of activities and allocated resources in project plan
· Analysis – Worked with stakeholder on analyzing user requirements for the BMO Connect R2
· Design – Designed the BMO Connect R2; Prototype; Refactored the Rich Client Framework (RCF) Architecture
· Implementation – Worked with team on delivering the BMO Connect R2; Prototype
· Knowledge Transfer – Created the development processes for BMO Connect R2, Defined a strategy to integrate the current systems
· Training – Mentored BMO full time developers on C# and development methodologies
Technologies: UML, .Net, Patterns, C#, Web Services, Visio, MS Project, Architecture, Framework, UI, Windows Forms, ASP. Net, NUnit, Jscript, BMO RCF
Siemens Company, Trango Software Canada, Toronto, ON Permanent Employee: January 2001 – December 2003
Trango is the eCRM excellence center for Siemens
Position: Senior Programmer/Analyst (Design 60%, Coding 40%) Team (2-7+)
· Projects – HiPath Pro Center 4.5/5.1/6.0 Projects, Switch 3000/5000 Projects
· Leadership – Provided feedback to management regarding performance of team members Provided technical support for 60 developers on the HiPath ProCenter 5.1 Project
· Project management – Designed Documents for all projects , Estimated, planned, and scheduled work for team members
· Planning and Analysis – Requirements document Researched alternative solutions and made recommendations to management
· Design – Re-factored the Telephony Server; Designed the Consolidated Servers User Interface (CSUI) Designed of in Memory Database engine and queries framework and the real time and newscaster servers
· Implementation - Delivered the Telephony Server. Developed the Consolidated Servers User Interface (CSUI) ,Memory Database engine and queries framework and the real time and newscaster servers
· Testing – Preformed unit and integration testing on all projects and reviewed code/design of all projects
· Training – Mentored team members on C++ and software engineering principles
Cedara (Formerly ISG Tech.), Mississauga, ON Permanent Employee: August 1999 – December 2000
Cedera SNS is an independent provider of medical imaging software technology and services.
Position: Software Developer (Surgical Navigation System 3.0 Project) (Design 20%, Coding 80%) (Team 7+)
· Project Management – Provided estimates as input to project plan, worked on various project documents
· Analysis – Worked with stakeholders on defining requirements analysis, Analyzed defects
· Design – Designed the Surgeon’s Panel Module, and the Microscope Validation Utility in (SNN 3.0),
· Implementation – Developed the Surgeon’s Panel Module and the Microscope Validation Utility in (SNN 3.0)
· Testing – preformed unit and integration testing and code/design reviews
Client: Lucent Technologies (CAS), Naperville, Illinois, USA January 1998 – July 1999
Communications Assistance Services Development Department is responsible for developing solutions for managing and administering Telecommunications switches.
Role: Senior Consultant (GLOW Global Operator Workstation 6.0 Project) (Design 20%, Coding 80%) Team(8)
· Project Management – Coordinated a team of 11 developers team, supported the ORGS and OAT/OAP teams; prepared design and requirement documents
· Analysis – Worked on team on clarifying the requirements
· Design – Designed features, COM interfaces
· Implementation – Developed features, COM interfaces
Business Information Technology (BIT), Cairo, Egypt Permanent Employee: December 1988 – December 1997
BIT is an IBM Solution Partner providing business automation, accounting software development and customized solutions
Positions: Windows Development Team Lead/Architect (Design 60%, Coding 30%, Testing 10%) Team (5-11)
· Projects – MASS, DOE Dubai, BITFYI, PetroGas, Integrated Accounting, Advertising, Radix Hand Held FW 40 and FP Printers Arabization Projects
EDUCATION
Honors Bachelor of Electrical and Computer Engineering – Cairo University, Egypt (1983-1985)
CERTIFICATIONS AND PROFESSIONAL DESIGNATIONS
· Microsoft Certified Solution Developer 2001 and .Net, 2004
· Certified Software Development Professional (CSDP), 2003
· Oracle Certified Application Developer, Oracle Certified Internet Application Developer, 2001
PROFESSIONAL AFFILIATION
IEEE, IEEE Computer Society and IEEE Communications Society Member – 1994-present
PUBLISHED BOOKS
· Mastering the BizTalk Technical Interview, 200 BizTalk Questions with Answers ISBN: 978-1-4357-1468-7 March 2008
· BizTalk: The Practical Course, Covers BizTalk 2006 R2 and 2009 Releases ISBN: 978-0-557-04990-5 February 2009
PUBLISHED ARTICLES
· An Extensible Light Xml Rules Engine Component – June 2004
· BTS: Sending Email in HTML or Text Format from BizTalk 2004 – Nov 2004
· Various Blogs at www.MoustafaRefaat.com
AWARDS
Wells Fargo Financial – Award of outstanding participation, WFFCC PPSA Program Project, 2005
Lucent Technologies – Award for outstanding support and great teamwork, OAT/OAP Saudi Arabia Project, 1998
Lucent Technologies – Department Recognition Award for demonstrating great teamwork and dedication by putting in extra hours to meet a very short schedule, 1998
PROFESSIONAL TRAININGS AND WORKSHOPS
1988 - 2009 – XML Web Services with .Net Framework; MS BizTalk; MS SharePoint 2003; Introduction to Customer Relation Management Systems; Introduction to Management; ISO9001; Introduction to Medical Imaging; DICOM Expert Training; Software Engineering Methodology; Analyzing and Designing Object-Oriented Systems; Introduction to UNIX; Communication and Leadership Management, Software Engineering Methodology, ISO 9001 Training, MS SharePoint 2007, MS Dynamics CRM 4.0,ITIL V3.0, Windows workflow, The Fundamentals of Requirements Elicitation