Sql Server Project
Resume:
Petru Gardea
Tel. 416-***-****
******@***********.***
Petru Gardea, M.Sc., is a seasoned professional with fifteen years professional experience in IT consulting for financial and insurance, government, software and product development, and computer manufacturing. Over twelve years of Canadian experience includes solution and application architect, technology strategist, security consultant, analyst, team leader and developer.
As a consultant for RBC Financial Group (RBC), Petru was core member of the team which sanctioned the Interactive Financial eXchange (IFX) as the messaging standard for RBC banking, in itself a foundational block in RBC s SOA vision. He was the main contributor and designer of the IFX-based Web Services development process, which provided innovative, collaborative, effective and scalable solutions for the project delivery teams, proven successful in a high paced and extremely dynamic development environment. He then effectively trained other staff members and provided reference implementations on both J2EE and .NET platforms. As a member of the IFX Centre of Excellence (IFX CoE) from its inception, he led for almost a year IFX CoE s deliverables. As an Application Architect with the Common Components Centre of Excellence (CCCoE), he introduced new technical solutions to improve forward compatibility of Web Service implementations running on top of JAXB, and drive the implementation of new processes and tools, most importantly Combinatorial Test Modeling and Strategy, Virtual Network Appliances and System-on-Chip, as foundational building blocks for a practical Test Driven Development. Other credits include: influencing and hands-on in delivering a security model for IFX Web Services using WS-Security, WS-Trust and SAML, deployed on Datapower and working in conjunction with IBM WebSphere; technical liaison with external IT service providers (IBM, TELUS); subject matter expert in determining and providing in-depth analysis of technical problems in J2EE Web Service Containers (WAS on z/OS).
As CTO of Paschi Research and Development, Inc. (Paschi), Petru established a successful product line around the QTAssistant, with major Canadian FIs as clients. It also gathered interest from European IT solution providers in the banking industry. The innovative product line-up includes new and extremely versatile development tools designed to reduce the cost of an Enterprise Application Integration project, using various messaging technologies, from Web Services, WebSphere MQ and IMS Connect on z/OS. When Paschi joined the IFX Forum in March 2007 (see ) he was an active member of the IFX Architecture Committee (see ). He was a guest speaker at Microsoft s Financial Services Architect Forum in 2007, discussing REST vs. SOAP Web Services. Paschi is a Microsoft Partner (read more on the web).
As a consultant for CIBC Mortgages, Lending and Insurance Technology (CMLIT), Petru was instrumental in establishing one of the most advanced technology for XML processing, based on DataPower s intelligent XML-Aware Network (XAN) infrastructure, as the CIBC enterprise standard. He was influential in reshaping CIBC s XML-based message brokering. He is credited with introducing new quality control strategies designed to improve the quality of Service Oriented Architecture (SOA) solutions. Other remarkable achievements include the design of the first solution to XML-enable legacy applications using Oracle s XML DB (based on 9iR2), deployment of a SOAP/Flat files messaging broker, built using IBM WebSphere MQSI, between CMLI and external business partners and designing end-to-end processes and tools to integrate Rational ClearCase, Microsoft SQL Server 2000 and bank s internal SDLC processes. Petru was fulltime member of the Solution Management Council of CMLIT (the architecture group) from its formal inception in 2003 and designated as the subject matter expert for Web Services, XML related technologies and Enterprise Application Integration (EAI) deliverables for CMLIT. As part of his ongoing assignments, Petru acquired a wealth of knowledge and experience on mortgage and creditor insurance software systems and the business processes they support.
As a consultant for Datacard Canada, Petru was actively involved in the technical research and architecture of their smart card-aware software applications. Major achievements include a first in Canada smart card personalization solution for Datacard s flagship plastic card printers (1997/99), delivery of the solution for smart card personalization used in the early phases of the E-Campus Project, a joint initiative from Bishop s University, Lennoxville campus of Champlain College, Quebec and RBC (1999/2000) and integration of fingerprint minutiae extraction and hardware-based encryption within a highly distributed, mission critical environment (1998/99)
Petru was certified by Microsoft as MCP, MCSE, MCSD, MCDBA (1999) and by Sun Microsystems as Programmer for the Java 2 Platform (1999).
References are available upon request.
Education:
Gh. ASACHI Technical University
Of Iasi, ROMANIA
Master of Science
in Computer Science, 1993
Technical summary:
Languages
C#, Java, XML, XML Schema (W3C/Schematron/Relax NG), XSLT, XQuery, HTML/XHML, C++/C, UML, AOM, T-SQL, PL/SQL, JavaScript/VBScript, PowerScript, assembler
Models
Interactive Financial eXchange(IFX), IBM Information Framework (IFW), RTDS/XMLM (TSYS VISA), exposure to IBM WCC
Combinatorial Test Modeling and Strategy, System-on-Chip Mock Testing (Virtual Network Appliances)
Servers/Other
Microsoft BizTalk/Sharepoint/Office Forms, MQSI/WBI/WMB, WLI, WebSphere, WebLogic
MS SQL Server, Oracle 10g/9i/8, Sybase SQL Server 10/11, DataPower XS40/XI50 (XAN)
Frameworks/Other
.NET, J2SE/J2EE, BRMS/BRE, TCP/IP and Internet protocols, IBM MQ, CAB/WPF/SCSF, Gemplus/Java Card/VISA/Open Platform, cryptography, COBOL copybooks, ATL/COM/DCOM, Biometrics, ODS/DB-Lib, OCR/ICR/OMR
Infragistics .NET Advantage, ComponentArt Web.UI, Northwoods Go Diagram, yFiles yWorks, mojoPortal
Web Services
SOAP, WSDL, UDDI, WS-Security/Trust/Addressing/ReliableMessaging/Policy, REST
Tools
QTAssistant, MS Visio, IBM RSA, Contivo, ERStudio, Erwin
MS Visual Studio, Eclipse, IBM WSAD/RAD, WebLogic Workshop, JBuilder, PowerBuilder (6.x/5/4), InfoPath, ProGrammar, Mathematica
ClearCase, SourceSafe, CVS, SVN, PVCS
IBM Rational Functional Tester 6.1/ClearQuest, NUnit, JUnit, Fiddler, Compuware QALoad, Numega DevPartner Studio/SoftICE, HP Protocol Analyzer
Advanced Installer, InstallShield, MS Windows Installer, WiX,
Operating systems
Microsoft Windows, IBM AIX, OS/400
Hardware
IBM PC/x86 and compatibles, Zilog/Intel CPUs and microcontrollers
Highlights:
Fifteen years experience designing and developing software, with more than eight years in leading design and application/solution architectures for major FIs in Canada.
Programming in C#(6+ years), Java (8+ years), C/C++ (7 years), SQL (8+ years), MS SQL Server (5+ years), Oracle (2+ years), PowerBuilder (5 years), Sybase (2 years)
Very good knowledge of OOD and OOP, MOF, UML, MDA, BRMS, CMS, relational database design, AOM, modeling business objects using XML Schema, networking, multithreading
Strong problem solving skills, creative, enthusiastic, efficient
Fast learner, easily adapts to new environments and tools,, experienced in team programming
Experienced programmer with a proven track of reusable and clean code
Experienced in dealing with clients and third party solution vendors.
Professional certifications:
Microsoft Certified
Systems Engineer/Solution Developer/Database Administrator
(1999)
Sun Certified Programmer
for the Java 2 Platform (1999
)
Professional Employment:
February 2006
- PresentRBC Financial Group
Application Architect
/Enterprise Architecture Services/Common Components Centre Contract
January 2000
- October 2005CIBC Mortgages, Lending and Insurance
Solution Architect/Senior Software Developer
Contract
May 1997
- December 1999Datacard Canada Co
., Mississauga
Senior Software Engineer Contract
March 1993
- March 1997PASCHI Research & Development Ltd
., Iasi, ROMANIA
Software Engineer
Major initiatives with RBC Financial Group:
Enterprise Technology Initiative: XML Messaging Strategy
Its objectives were to review Industry Standard Messaging Models and XML Schemata to assess their capabilities and applicability to RBC; review current practices; define and recommend how industry standards should be adopted and managed within RBC by specifying a roadmap, high level processes and tooling capabilities. The scope of the strategy was for the whole enterprise, not limited to a business vertical.
As a core team member, I was responsible to survey existing IFW processes, analyze and recommend new IFX and XML Schema management processes designed to alleviate the existing problems which called for the need to change. A significant amount of time was spent in completing various technical Proof of Concept (POC) designed to demonstrate viable solutions; from establishing new binding technologies to versioning, baseline management and automatic code and documentation generation, on both J2EE and .NET platforms.
Enterprise Application Services/Common Component Centre: IFX Centre of Excellence/VXML
Its objectives were to establish a CoE; deploy new tooling and train additional resources (Lead, Business and Technical System Analysts); maintain communication between the architecture and the development team; deliver reference implementations and fine tune processes while delivering projects on the new platform.
As lead from the architecture team, I was responsible with the design and execution of all phases related to IFX deployment; I ve provided guidance and hands on support in establishing a new security model for IFX-based Web Services, for both internal and external (IBM, Telus) resources, with significant deployment on Datapower; worked closely with the J2EE team in establishing a new framework for generic IFX messaging processing; assumed approving roles for Business Message Specification Requirements; worked with Java developers and participated in Java code reviews to ensure correctness of IFX implementations.
Common Component Centre: VXML
Its objectives were to migrate existing point to point IMS transactions used by the IVR system (hosted by a third party) to an IFX-based implementation/SOAP Web Services, deployed on WebSphere z/OS, and accessed through a Datapower appliance. Some of the underlying IMS transactions were wrapped or replaced with other data access methods. The project also undertook the migration of TSYS (VISA) data packets interface to the new XMLM (SOAP/XML over WMQ) data format.
I was responsible to provide reference implementations for other team members to follow; developed full technical spec for IBM consultants to provide deliverables on Datapower; architectural solutions and hands on guidance and support to the developers team; review and approve design documentation; provide technical expertise to identify and propose solutions to address issues found in TSYS XML Schema; write code to extend JAXB 1.x to allow RBC to deal correctly with the extensibility model employed by XMLM; designed and developed a testing model and strategy using QTAssistant s Combinatorial Testing Modeling and Strategy and System-on-Chip Mock Testing modules to address the need of extensive negative testing coverage for key components (e.g. Bill Payment Web Services choreography); worked with RBC internal groups and IBM to provide them with expert test cases to identify and correct issues (via product hot fixes) in the WAS Web Services (XML parsing) stack (on WAS 6.1 and 6.0.x
Common Component Centre: Bluewave
Its objectives were to align several RBC lines of business to share a common financial planning tool and support regulatory and compliance-related changes.
Common Component Centre: RTDS/XMLM Migration
Its objectives are to replace all of the TSYS VISA RTDS packet (flat/WMQ) based interfaces throughout RBC Financial Group and RBC Bank (U.S.) with a new shared services gateway based on IFX Web Services, using the new TSYS XMLM messaging format.
As subject matter expert on EAI, Web Services, J2EE Web Service containers, XML related technologies (W3C XML Schema and XSLT), COBOL copybooks and IMSConnect, I was responsible to provide architectural solutions and hands on guidance and support to the developers team; review and approve design documentation; interface with, and amend or propose new solutions from, the Solution Architecture team; provided analysis and test models to detect and expose new implementation issues stemmed from a new deployment model (concurrent WAS deployment on AIX and z/OS) around JMS (with WMQ provider) and IMSConnect connection pooling based on QTAssistant s Virtual Networking Appliance features; provided an XML Schema Test Driven Development model for XSLT 1.0 based deliverables, with stellar results in detecting business requirements and implementation issues; create project plans for my team s deliverables; assign, supervise and work with up to four resources.
Major initiatives with
CIBC:
Online Banking Loans and Lines Drill Down 2005
An initiative to provide more information for the CIBC Online Banking customer website. Using CAAP features, we ve exposed host IMS transactions as SOAP with WS-Addressing headers with virtual no coding on the host.
Environment: XML/XSLT, W3C XML Schema, WS-*, WebSphere MQ/IMS, DataPower XI50
CMLI Application Adaptor Platform (CAAP) 2004/2005
CAAP is a domain messaging broker, acting as an adaptor and bridge between CMLI internal, CIBC and external systems. Its remarkable abilities include the XML-virtualization of any message provider/consumer over HTTP(S)/MQ with a choice of zero development effort outside CAAP. CAAP has brought to CMLIT a solution stack which included new testing models and formalized the work for client stubs and mock services testing. By commoditizing CAAP as an omnipresent network device, the complexity and cost of EAI in SOA-based solutions is expected to lower while the quality of the output to jump up. I have researched, developed the Statement of Work (SOW), use cases, test cases and then hands-on conducted the trial and the vendor selection process. I have been the solution architect and lead developer from the inception of it.
Environment: XML/XSLT, W3C XML Schema, WS-*, WebSphere MQ, DataPower XI50, Contivo
CIBC Enterprise Message Broker (EMB) 2004
With CMLIT success in selecting DataPower (an IBM Company) as the XAN provider and in depth knowledge of the WS-Addressing and WS-ReliableMessaging, I have helped the EMB team through establishing XAN as the new deployment platform and in devising new enterprise messaging specifications using viable and de-facto industry standards from the WS-* suite of specifications. According to commissioned independent studies, covering a three years time span, the Total Cost of Ownership (TCO) was lowered with millions of dollars with hundred times more Transactions Per Second (TPS).
Environment: XML/XSLT, W3C XML Schema, WS-*, WebSphere MQ, DataPower XS40, Contivo
Customer Centric Insurance Platform (CCIP) 2003/2004
CCIP program established a new system of record for creditor insurance products. As the designated EAI Solution Architect, I have defined the integration solution within CMLIT, in accordance with CIBC Enterprise Message Brokering specifications and positioned it for unhindered growth; designed an extremely flexible and transparent integration layer between a third-party proprietary application (FIMMAS) and CIBC messaging infrastructure using Oracle s XML DB; proposed and demonstrated new approaches in testing SOA using client stub and mock services.
Environment: XML/XSLT, WebSphere AS 5.0, J2EE, Oracle 9iR2, RUP
Renewal Mortgage System 2003/2004
This particular project instituted automation of faxed renewal forms. Analyzed business requirements, authored the system requirements and conducted the preliminary vendor selection process for the OCR/ICR/OMR component of the RMS project. Following the vendor selection, led and worked closely with the development team and the vendor, with remarkable results in production.
Environment: XML/XSLT, J2EE/WebSphere AS 4.0, IIS, VB.NET, Microsoft SQL 2000, FileNet, Internet Explorer
Mortgage Life Insurance and Renewal Mortgage System 2003/2004
Designed a new framework to build systems uniformly and predictable for Intranet applications which benefited two distinct initiatives, going on at the same time, delivered by two distinct development teams and targeted for two different platforms (Microsoft and Java).
Environment: XML/XSLT, WebSphere AS 4.0, IIS, J2EE, VB.NET, Microsoft SQL, Oracle, FileNet, Internet Explorer
SQL 2000 migration and ClearCase integration 2003
While undertaking the migration from 6.5 to the 2000 version of the Microsoft SQL Server, I ve completely redesigned the implementation of the security component to fully integrate with Microsoft Window NT Domains, and designed a solution, provided the framework and oversee the execution of integrating SQL-based development with the internal ClearCase and SDLC processes. Using powerful SQL code analysis tools, we ve managed within a four months period, to migrate a database (over 1300 stored procedures, 220+ tables), fully integrate with the corporate NT domains, institutionalize a process that would synchronize the SQL code base efficiently and automatically create SQL install packages and completely rewrite the physical design of the database.
Environment: Microsoft Windows, SQL Server, ASP, C++, XML, XSLT, W3C XML Schema
Online Mortgage and Insurance Offer 2002/2003
Team member of the architecture team providing the solution to one of the most significant bank s initiatives, involving development outsourcing (two parties), integration between the internal Online Banking group, a third party provider, the internal mortgages system and two external business partners. I was instrumental in designing and supplementing the MQSI 2.0/2.1 and WebSphere 4.0 development. I ve designed the SOAP messaging layer, the reliable messaging model and W3C XML Schema. Acted as the lead technical liaison between all involved
Environment: AIX 4.3, IBM DB2, J2EE, MQSI 2.0/2.1, WebSphere AS 4.0, WebSphere MQ 5.x, SOAP, XML, XSLT, W3C XML Schema
Cost of Borrowing 2001
Designed and implemented system changes for compliancy with The Bank Act s Cost of Borrowing Regulations. Given the layout of the processing pipeline, COB became a significant component of the mortgage advancing platform.
Environment: MS SQL Server 6.5, ERStudio, ASP
Aurora system stabilization 2000
Team member in redesigning and implementing a key component of one of the application services that forms the infrastructure of the mortgage advancing system.
Environment: MS Visual C++ 6.0, MS Visual Basic 6.0, Rational Rose EE 98, MS SQL Server 6.5, IBM MQ Series 5.0, RogueWave, ADO, XML, JScript.
Major initiatives with Datacard Canada Co.:
Royal Bank of Canada Campus Card Mondex smart card pilot
(July - August 1999)
For an online overview of the project, please visit . Designed and implemented a web-enabled, multithreaded print server application. The application front end and database access were implemented using PowerBuilder 6.5 distributed application model. The plastic card printer interface and the smart card support were implemented into reusable ActiveX components.
Environment: MS Visual C++ 6.0, PowerBuilder 6.5, ATL, MFC Winsock, Sybase SQL Anywhere.
JNet (
April
- August 1999)
Team member designing a distributed application to replicate data between DB2 on OS/2 and Oracle8 on Windows NT using IBM MQSeries 5.1 with XML formatted messages. Designed and prototyped Datacard's application using Java (classes for IBM MQSeries and wrapper classes to existing agents - JNI) and COM/DCOM.
Environment: MS Visual Studio 6.0 (C++, J Oracle8, IBM MQ, DB2, XML.
Newfoundland Driver License
(June 1999)
This project was a joint effort of Datacard Canada and IBM Canada. I have presented IBM team with Datacard technologies relevant to the project and make recommendations regarding the solution and I was designated to provide IBM team members with technical support regarding Datacard 's IDWorks COM software components.
Environment: MS Visual C++ 6.0, MS Visual Basic 6.0.
Smart card security framework demo application (February - April 1999)
Designed and implemented an application enabler for clients in a client/server environment using smart cards for authentication and repository of the user profile. Researches to extend the solution using IIS 4.0, WebLogic 4.0.3.
Environment: MS Visual Studio 6.0, PowerBuilder 6.5, IIS 4.0, BEA's WebLogic 4.0.3, MS SQL Server 6.5.
GTAA - Card issuance system (January - March 1999)
Plastic card personalization system for Pearson Airport. Designed and implemented COM components for image processing (conversion between various formats, preview and printing) and business rules. Designed the business rules management system allowing users to manage rules by editing metadata stored in a database.
Environment: MS Visual Studio 6.0 (Visual C++, Visual Basic), ADO, Accusoft's ImageGear, MS SQL Server.
Scuba Schools International Vianet deployment
(December 1998 - June 1999)
Vianet is a suite of identity information software that includes packages for data retrieval, image capture and card issuance in an intranet/internet environment. Team member documenting and implementing the database design with Oracle8 on a multiprocessor Dell server running Windows NT, installing and configuring ArcServe6.5 backup agent for Oracle, designing and implementing the reports with Crystal Web Reports using Oracle stored procedures returning result sets, deploying the solution at the customer site in Ft. Collins, CO.
Environment: MS Visual Basic 6.0, ADO, PowerBuilder, Oracle8, IIS4.0, Crystal Web Reports 7.0.
Client Identification Benefits System (
CIBS
) (August 1997 - February 1999, November - December 1999)
CIBS is an application that allows the enrollment of individuals in a demographic and a biometrics database, issues requests for setting bank accounts and electronic funds transfer. Team member in designing and implementing the application and the database. Designed the application security, designed and implemented the interfaces to an application running on a mainframe (using TCP/IP), to the external hardware encryption token (using extended stored procedures), to the biometrics (fingerprint) capture device, to the Datacard s PIN pad and to the Datacard s embosser. Designed and implemented the card production workstation. Deployed the solution at the customer site.
Environment: PowerBuilder 6.x, MS Visual Studio 5.0/6.0, MS SQL Server, Winsock, biometrics, encryption.
Major initiatives with
Paschi Research & Development, Ltd
.:
TimeCheck (May 1996
- March 1997)
Application used to control the access in restricted areas using data captured from networked card readers. Designed and developed the user interface, the database design and some DLLs for the card readers service providers.
Efficiency Calculator (1995)
Application used to process and register various expenses and to design and generate various reports. Designed and developed the file conversion tool, designed and developed the business rules module.
XTest (
1994
)
Responsible for design, development and testing of a real-time application and an IBM PC/x86 ISA add-on-card data acquisition board used to evaluate the employees skills in the fashion manufacturing industry.
Freelance
projects
August 2005
present
I believe that defining domain-specific languages on MDA principles is a viable and important alternative to UML. Designing and implementing a collaborative application design framework intended to facilitate successful communication between a software solution provider and financial and insurance clients.
Environment: C#/ASPX, Microsoft Visual Studio 2008 Shell, XML, W3C XML Schema, SQL, .NET
January 2003 present
QTAssistant . is a robust suite of integrated tools aimed at facilitating the analysis, refactoring and management of industry standard XML Schema, and development and testing of (primarily XML-based, also provides support for COBOL copybooks) messaging solutions. Its features include sophisticated XML Schema management, analysis and refactoring, and additional metadata capturing; XML/Flat file generation from any XML Schema, spreadsheets or relational databases, using an XML-based scripting language; creation of test cases based on Combinatorial Test Models, integrated end to end to provide out of the box testing of messaging applications, as both client or mock service; Virtual Networking Appliances, for System-on-Chip Mock Testing. Designed and implemented the application; acquired extensive knowledge in developing an off the shelf application, including product development, packaging and deployment for commercial use: product modularization, third party components selection and integration, custom control developing, testing, application memory and performance profiling, obfuscation and copy protection/licensing, professional grade setup with internet enabled auto updating, etc.)
Environment: C#, XML, W3C XML Schema, SQL, WebSphere MQ, COBOL copybooks, TCP/IP, Microsoft .NET/CAB/SCSF/WPF, Windows OS.
February 2001
September 2002
Designed and implemented an application called iMiner used to analyze complex SQL code. The goal was to identify language-specific constructs to support migration between versions of SQL engine and to extract business rules for reverse engineering. The grammar was expressed using a proprietary XML language, the code generator, the IDE, etc. were written in Java 2. The graph layout and visualization was based on ATT s Grappa engine (under GraphViz).
Environment: Java, SQL.
June August 2000
Prototyped pure Java solutions for infrastructure systems providing real time chat/full duplex audio/one-way video over the Internet capable of working through firewalls/proxies for a startup company.
Environment: JBuilder 3.5, JDK 1.3, JMF 2.1, JSDT 2.0, servlets, JRun 3.0.
May June 2000
Designed and implemented the database for an Internet based online ordering/billing/inventory application.
Environment: MS SQL Server 7.0, ASP, Macromedia s Dreamweaver UltraDev 1.0
Other projects
Telus
November 2007
Implemented a small project on Datapower XI50 appliance, to return account balances for prepaid customers. The technical solution involved LDAP lookups from Datapower, XML over HTTP calls (gateway into an external payment platform) and routing logic. The solution required an in-depth understanding of the XI50 features and issues as well as the ability to deliver the correct technical solution based on high-level requirements.
Contact this candidate