Nov 1998 - Current

GDW Solutions, Inc.

Mar 1997 – Dec 1998

MCI Systemhouse, Inc.

Technical Architect

Jun 1994 – Mar 1997

Butler Technology Solutions, Inc.

Data Mart Architect/Oracle DBA

Nov 1993 – May 1994

Analysts International Corporation

Application Developer

Jul 1992 – Mar 1993

IBM Corporation

Lead Application Developer

Jun 1991 – Aug 1991

Orange County Information Services

Programmer/Analyst

Jun 1989 – Aug 1989

Orange County Information Services

Programmer/Analyst

Hardware:

IBM 4381, 3090, AS/400, SUN, IBM Compatible

Operating Systems:

UNIX(Solaris 2.7), Windows 95/NT/2000/XP, OS/2 2.11, VMS, IDS/MVS, OS/400,

Languages:

Perl, SQL, PL/SQL, Visual Basic 6,C/C++, Pro*C, JavaScript, HTML, VBScript, ActiveX Script, COBOL II, APPC, JCL, CICS/VS

Databases/Tools:

Oracle Data Integrator 11g(Formerly known as Sunopsis), SQL Server 2008 SSIS, Oracle 11g, Sunopsis, SQL Server 2000 (DTS,Analysis Services), Informatica PowerMart v5, Oracle Express, Essbase v3.2 and v6.0, DB2/400, DB2/2, MS Access 97, PowerDesigner 6.1, ERWIN 3, Oracle Enterprise Manager, Transformation Server for the AS/400, Transformation Server for MS Windows NT

Applications/Tools:

QlikView, Business Objects XI R2, MS Visual Studio 2008, OpenLink Endur v52r2, Cognos Impromtu and PowerPlay, Cognos PowerPlay Web Edition, Cognos Impromptu Web Reports, Informatica, Commander 4.2, DMLan 4, TSO/ISPF, MS Internet Information Server 4.0, MS Site Server 3.0 Commerce Edition, MS Transaction Server 2.0, MS Index Server, MS Developer Studio97,

As a member of the Shared Application Services team,managed a team of QlikView platform engineers responsible for supporting over 4,700 users globally, 264 QlikView applications, and 124 Windows 2008 servers across multiple locations within the Shared Application Services at Deutsch Bank. Oversaw the shared platform, day to day requests, book of work, and roadmap strategy. Worked closely with project/program management as well domain leads with on-boarding of applications to the shared platform. Managed risks, issues, and escalations in the day to day operation of the shared platform. Reviewed and signed off of new applications and ensured applications on-boarded adhere to QlikView best practices and industry standards. Reviewed and approved weekly production changes in order to prevent risk of failure and guarantee system stability. Planned and/or conducted major hardware, network, software, and operating system upgrades and migrations. Ensured all audit & compliance issues were closed on time and no outstanding risks or gaps on scorecards. Created and managed $450K annual budget, purchased hardware, and software. Ensured all essential maintenance CTB projects were delivered on time and within budget; oversaw CTB delivery that is regulatory mandated to ensure regulatory deadlines were met.

Served as the ETL Architect/Senior ODI Developer in the development of a custom built Enterprise Data Warehouse (EDW)/Cognos initiative that support the company’s Exchange Traded Fund (ETF) and investment services at Brown Brother Harriman Corporation; the newly built ETF EDW eliminated extensive use of Excel macros and improved efficiency, productivity and most of all reduced risk. Thus, enhancing the current workflow/process and increasing the number of funds, baskets, and clients. Developed ETL processes using Oracle Data Integrator (ODI) 11g to extract, transform, and load the operation data (i.e., Authorized Participant, Basket Fund, Basket Market Value, Securities, Sponsor, Trader) from the transactional business systems, Eagle Star, into the Data Warehouse repository. Set up and configured the Oracle Data Integrator (ODI) 11g with multiple Master Repositories in a three-tier environment and performed periodic upgrades when required. Performed detail data analysis of both data elements requested by the business and data sources; documented data source definition, source-to-target mapping, and logical structures to support the ETL batch process. Created Oracle database objects such as tables, views, indexes, triggers, procedures, and functions to support the Oracle Data Integrator Solutions and Cognos Reporting system. Provided additional support, guidance, and training in the deployment of the Oracle Data Integrator solution in various environments such as integration, QA, and production which included automation of production release of ODI Scenarios and database objects. Helped estimating ETL project tasks and defining project scope

Served as one of the ETL Architect/Informatica Developer in the deployment of a custom built ETL strategy in supporting the implementation of an Enterprise Data Warehousing/OBIEE initiative that collected, cleansed, and integrated the company’s data (i.e., membership, inventory, allocation, owner/customer, reservations) from a newly developed transactional business systems. Worked closely with other team members and business users in understanding the business requirements and the source operational systems. Performed detail data analysis of both data elements requested by the business and transactional source systems. Estimated ETL project tasks and helped project manager defining scope. Documented data source definition and ETL specification (a.k.a., logical source-to-target mapping) for each environment (i.e., staging, central repository, data mart). Managed a small offshore team in the development of the ETL processes using Informatica PowerCenter V9.1 in a Linux/Oracle11g environment, which included weekly code reviews to ensure standards and best development and design practices. Created, executed, and maintained QA test plans for each environment (i.e., staging, central repository, data mart).

Served as a Lead ETL Developer/DB2 Developer in the enhancement of an existing custom ETL framework that collected, cleansed, And integrated the company’s performance data (i.e., cash-flows, liquidity positions) from various operational source systems. The enhancements were part of an overall initiative in improving an internal custom built Liquidity Risk Management System (LRSMS) that supported and provided Bank of America Corporate Treasury executives, senior managers, and business analyst with analytical reporting capability on the company’s liquidity position, sources and uses of cash, forecasting of cash flows and stress test modeling, funding counterparties, and developing funding plan as needed. Major contributions and/or accomplishments included: designing and developing an ETL component that dynamically constructed in real time the SQL to load over 100 source feeds into the Liquidity Position fact table using a Meta Data strategy; designing and developing an ETL process that mapped custom products and/or services hierarchical relationship with the company’s general ledger products for reporting purposes; developing DB2 objects such as tables, views, indexes, triggers, procedures, and functions to support the ETL Meta Data Rule component; providing support, guidance, and training in the deployment of the solution in various environments such as integration, QA, and production; and creating database objects to support the development of Spotfire reports to allow users access to source reference data; The following tools and/or technologies were used in the development and deployment of the solution: DB2 V9.7, DB2 V9.7 SQL Procedure, Windows, Linux, LRM Studio, Toad For DB2 V4.7, and Spotfire Client and Server.

Served as a Lead ETL Developer/Data Architect in the deployment of the agency Auction Securities Data Warehouse in order to make easier access of auction securities data, provide analytics, trending and comparisons, reporting and exporting capabilities that support the business needs, but most of all increase data utilization, and improve customer services and productivity. Primary responsibilities included but not limited to performing source-to-target mapping, installing and creating Oracle11g database objects (i.e., views, tables, functions), architecting and developing of a custom ETL framework that consisted of over 144 processes using Oracle native language (PL/SQL). The following tools and/or technologies were used in the development and deployment of the solution: Oracle11g, Oracle PL/SQL, and Business Objects 3.1 (i.e., Universe, Webi).

Served as a Senior Oracle Data Integrator (ODI) Developer in the development of the company's budget, forecast, and capital planning reporting system in order to improve the cycle time of the current planning process, reduce the dependency on Excel and other proprietary tools for data entry and reporting, and provide property and department level budgeting/forecasting so as to produce a consolidated budget and forecast. Primary responsibility include but not limited to installing and configuring the Oracle Data Integrator software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL processes using the Oracle Data Integrator 10g (formerly called Sunopsis) to update the Hyperion Planning and several Hyperion Essbase 11g applications including updates to meta data for various dimensions and loading of raw data; Other tasks include creating scripts such as load rules, calc, and Maxl to clear the Hyperion Essbase applications in order to facilitate the ETL processes, creating MS SQL Server 2008 SQL scripts and database objects in order to establish various environments such as development, test, and production, and creating Smart Views in order to test and validate the loading of raw data into the Hyperion Essbase application.

Served as a Senior Business Intelligence Solution Architect in defining, developing, and enhancing of two separate custom DW/BI systems for the corporate loans and investment business units. Primary responsibility include but not limited to coordinating, planning, and conducting interviews with various business users in identifying and capturing business requirements, defining and developing project scope/plan, creating and developing two separate multi-dimensional data models using the Ralph Kimball methodology, performing source-to-target mapping, building database schemas in an Oracle8i environment which included creating scripts and procedures for production migration, and building two separate ETL batch processes (over 120 packages) using MS SQL Server 2008 Integration Services (SSIS). Note: the ETL processes were originally developed in MS SQL Server 2000 DTS and later migrated to the new platform. Additional tasks include the creation of a custom analytical application using MS SQL Server 2000 Analysis Services for the investment services in order to track primary and secondary commission by region and salesperson, the migration of the original reporting solution to Business Objects Enterprise (BOE) XI R2, the creation of the migration procedures for installing and configuring BOE in a production environment, performing BOE software upgrade and patch installation in the development environment, creating and developing of BOE Web Intelligence reports, training business users in how to navigate through BOE Info View and creating and accessing reports.

Served as a Data Warehouse Architect/Consultant in the enhancement and development of a SAP Business Warehouse application at Pitney Bowes Corporation. Responsibilities included but not limited to conducting intereviews with executives, senior managers, SME's, business analysts, and technical staff in capturing and understanding business requirements, and defining project scope; performed detail data analysis of both data elements requested by the business and data source (IMS and SAP R/3), and documenting data source definition, source-to-target mapping, and logical structures for the data warehouse/data mart; translated business requirements into dimensional data model to support the billing/invoice data mart using Erwin; communicated and/or provided knowledge transfer to consultant (SAP BW Developers), both on and offshore, in the development and support of the project (SAP BW). The following tools and/or technologies were used in the development: MS Windows 2000, Sun Solaris, Oracle8i, SAP BW, Erwin, and Qualiware.

Served as a Data Warehouse Specialist/Consultant in the enhancement and development of an enterprise data warehouse/business intelligence application for the automotive services at Automotive Finance Corporation. Primary focus and/or development efforts were in the reengineering of the ETL processes using the Oracle Data Integrator (formerly known as Sunopsis) tool. Additional tasks included the creation of schema objects (tables, views, indexes, packages, triggers, etc.) in an Oracle8i environment, the expansion of a single dimensional data model (star schema) into multiple star schemas, source to target mapping, storage capacity planning and the support and maintenance of the Cognos EP Series 7 reporting environment. The following tools and/or technologies were used in the development: MS Windows 2000 Server, Sun Solaris, Oracle8i, Sunopsis, PL/SQL, Cognos EP Series 7, Erwin, and Oracle Enterprise Manager.

Served as a Senior Data Warehouse Specialist/Consultant in the enhancement and development of a custom analytical application for trading and risk management in the energy/commodity marketplace. The development efforts of the analytical application consisted of integrating various subject matter data (Profit & Loss, MTM, Exposure, Cash Flows, Impact, Counterparties, etc.) from the Endur application. In addition to the development role, helped build the data warehousing services of the company and trained and mentored internal staff on data warehousing. Tasks included conducting requirement analysis; the design and development of a dimensional data model (star schema); the creation of a database, in both Oracle8i and SQL Server 2000; the development of ETL processes (PL/SQL, DTS Packages); the creation of several multidimensional cubes; the development of a web reporting application; client training and documentations. The following tools and/or technologies were used in the development: MS Windows 2000 Server, Sun Solaris, Oracle8i, SQL Server 2000 (DTS and Analysis Services), PL/SQL, MS Office Web Components, Erwin, FrontPage 2000, Oracle Enterprise Manager.

Served as a Lead Data Warehouse Architect in the development of a web-based Enterprise Customer Relationship Management (eCRM) reporting application for the eCommerce department at J.Crew. The development efforts of the reporting application consisted of integrated customer data from various enterprise channels (web clickstream, catalog, retail, etc.), thus providing a consistent view of the customer. Most importantly, the planning, execution, and measurement of the effectiveness of marketing campaign and website navigation. Tasks included conducting requirement analysis, designing and developing of a data model (star schema), the creation a Oracle8i database, coding of ETL procedures (PL/SQL, Perl and Informatica), designing of Cognos Impromptu and PowerPlay reports, software installation, and the automation of production jobs. The following tools and/or technologies were used in the development: MS Windows NT, Sun Solaris, Oracle8I, PL/SQL, Perl, Unix, Essbase, Cognos, Erwin, IIS, and shell scripts.

Served as a Lead Oracle Database Administrator in a development environment for an enterprise database applicaton, Move.com. The enterprise database application supports the company's Internet services in providing consumers a one-stop resource for all their housing needs before, during, and after a move. Tasks include designing and building of logical and physical database structures, administrating several Oracle database applications and security, analyzing and translating end users requirements into database objects (tables,views,indexes,procedures,functions,etc.) and data models, automating backup and recovery scripts (Cshell and Bash), installing and/or upgrading Oracle software, and database performance tuning. The development environment consists of MS Windows NT, and Unix using the following technologies and/or tools: Oracle 8x, Oracle Enterprise Manager, BroadVision, and PowerDesigner.

Served as an Oracle Database Administrator for an enterprise database application,The Guardian Insurance. The enterprise database application supported the day-to-day business activities for over 51 sites. Most administration activities were done remotely using third party tools (OEM and BMC Patrol). Tasks included monitoring daily activities, troubleshooting problems, software and application upgrades on various platforms (MS Windows NT, Sun, and AIX), performance tuning, automation of backup and recovery scripts, and maintenance of system security and database objects.

Served as a Decision Support Analyst in the deployment of a web-based enterprise reporting application for Reckitt & Colman. Tasks included the installation and configuration of the Cognos and MS IIS (version 4.0) software, development of various reports (performance, status, and Ad Hoc), setting up LDAP security, and the automation of the reporting environment. The development was done under MS Windows NT platform using the following front-end tools to retrieve and manipulate data from an Oracle database application: Cognos Impromptu and Impromptu Web Reports.

Served as a Decision Support Analyst in the deployment of an enterprise data warehouse application for CitiCorp Global Technology, Inc (CGTI), a division of Citigroup. The enterprise data warehouse application is to support the business processes (Order Management, End User Billing Detail, Carrier Services, and Products) of CGTI. Task include analyzing and documenting business data reporting needs, designing and developing of Impromptu reports, designing and developing of multi-dimension models in PowerPlay, and assisting in the development of user training materials. Additional responsibilities include the creation of Oracle database objects (Index, Tables, Views, etc.), database performance tuning and SQL statements, data extraction scripts, installation and configuration of Cognos software in a MS Windows NT environment, and the automation of the reporting environment.

Assisted in the support and maintenance of an Electronic Order Entry (EOE) Web-based application for the Avon Corporation. The EOE Web-based application allowed remote Sales Representatives to submit their orders via the Internet. Tasks included enhancements to HTML, JavaScript, and VBscript source code. The following Web and/or technologies were used in the developing and deploying the application in a Windows NT Server 4.0 environment: MS Internet Information Server 4.0 (IIS), MS Site Server 3.0, Commerce Edition, MS Transaction Server 2.0, MS Index Server, SQL Server 6.5, and MS Developer Studio97.

Served as an Oracle Database Administrator (DBA) in the deployment of an enterprise data warehouse database in Oracle for the Chase Manhattan Bank. The data warehouse database was deployed to support the Profitability Reporting Facility (PRF) application for the financial analysis community. Tasks include the design, development, and the administration of several Oracle database applications exceeding 50 Gbytes in data, Oracle performance tuning, translation of business requirements into database application design and data models, and migration of various database schemas between databases. Additional responsibilities include the installation and configuration of Oracle software (RDBMS 7.3 and Oracle Enterprise Manager 1.5) in a UNIX and Windows NT environment.

Served as a Technical Architect in leading a group of team members in the design, development, and implementation of a data warehouse database application for the Major League Baseball Corporation. Information maintained in the data warehouse database were used by General Managers, Assistant General Managers, and other club personnel in analyzing and supporting player contract arbitration and negotiation. Tasks included the design and development of a Conceptual System Blueprint, the presentation of the propose system to the client, the evaluation and selection of hardware and software vendors, the logical and physical design and implementation of the database application, and the design and development of the data distribution program between databases. Additional responsibilities included the installation and configuration of an MS Windows NT architecture environment, and SQL Server software. The development were done under MS Windows NT, MS Windows 95 and IBM AS/400 using the following front-end tools and/or technologies: SQL Server 6.5, DB2/400, MS Access 97, Business Objects 4.0, Transformation Server for AS/400 and MS Windows NT, Visual Basic 5.0, and Wise Installation 5.0.

Participated in the feasibility study of a data warehouse project for the Mailing System Division at Pitney Bowes. Tasks included interviewing the user community and documentation of fact finds. Additional responsibilities included the assessment of an Oracle on-line transaction processing database in an MS Windows NT 4.0 architecture environment.

Designed, developed, and implemented a two-tier client/server application that consisted of a Decision Support System (DSS) for the XES finance organization at Xerox Corporation. Tasks included the design, development, and the administration of a Oracle data mart, the distribution of global data from the Data Warehouse, installation and configuration of the Oracle software in both production and test environment, performance tuning, implementation of a backup and recovery strategy, conducting requirements analysis, data modeling, automation of production jobs and support. The development were done under Windows for Workgroups and Unix using the following front-end tools and/or technologies to retrieve and manipulate data from various database systems (Oracle, Essbase, Access, and DB2): Essbase Application Manager, Visual Basic, Access, Embedded SQL, ODBC, Pro*C, Cshell, and SQL*Plus. In addition to the implementation of the DSS, provided support for integrating various components of the development of an C++ application, evaluation and acquiring of new installation software for productivity enhancements, and functional and/or technical support of an MS inter-application (Visual Basic, Excel, and Access).

Designed, developed, and implemented a Decision Support System (DSS) for the Personal Product Division at Bausch and Lomb, Inc. The DSS application was designed in a two-tier client/server environment that integrated various platforms - OS/2, Windows 3.1, NT, IBM 3090, and AS/400. Tasks included the design and development of a Graphical User Interface (GUI) using Commander Builder (EIS), the design and development a multi-dimensional database (MDDB) application using Essbase that stored and maintained company's financial, marketing, and sales data, and the loading and manipulation of the data into the database using ADL and Essbase SQL Interface. Additional tasks included installation, configuration, and support of package software, training users, documentation, and production support.

Developed, tested, and implemented a batch application in C that calculated the required reserve for all policies at Mutual Life Insurance Company of New York. Designed OWL application interface in C++ that allowed the output results to be viewed by end users. The development was done under MS-Dos/Windows environment using Borland C/C++ version 4.0. Additional tasks included designing and testing of reports using EasyTrieve Plus and Cobol II, and retrieval of customer data from an IMS/VS database. Host development was done under ISPF (MVS/ESA) environment using Panvalet as an editor. XPEDITOR was used as a debugging tool for all Cobol II applications.

Designed, tested, and implemented several distributed processing programs using Advanced Program-to-Program Communications (APPC) for the Information Technology Division at Rochester Gas & Electric Corporation. The distributed processing programs allowed customer service orders to be sent and received from a Mobil Telecommunication application, thus allowing Field Personnel to view customer service order on their PC Radio (laptops). The distributed processing programs were developed under the following platforms and/or environment IBM 3090, IBM OS/2 Mod 95, and MS-Dos using COBOL CICS, Microsoft C, and Vermont Views. Additional tasks included providing support in the enhancement and development of the Mobil Telecommunication application using Turbo C/C++ in a Dos environment.

Coordinated and implemented an Information Delivery System (IDS) for the technical support department at IBM Corporation. Tasks included the design, development, and the administration of a DB2 database application, the design and development of a distribution program that allowed personnel remote access to data from a portable terminal, conducting requirement analysis, and the automation of production jobs and support. The development of the IDS was done under OS/2 2.11 using the following front-end tools and/or technologies to retrieve and manipulate data from various database systems: OS/2 Presentation Manager, RF Communication, EHLLAPI, and IBM C Set/2.

Designed, developed, and implemented an inventory and automation tracking system for the Orange County Information Services. The development was done on a Wang 100 system. Tasks included logical and physical layout of the database, coding of programs to load the database, interviewing the user community, documentation of reference manual, and training end users on the Wang 100 system.

Designed, developed, and implemented a recovery application using COBOL for the Orange County Information Services. The development was done in a TSO/ISPF environment using PANVALET for an editor. The recovery application ran on an IBM 4381 (MVS/XA).