Developed a state machine to call lambda functions (Serverless transaction processing) to act as an ETL tool which conformed disparate (csv, json, EDI) data into a homogeneous JSON standard. The resulting homogeneous file had common keys that allowed it to be used by Amazon Athena for data mining.

2014 – Present EDW Technical LeadTechnical lead for installation of the new data warehouse system. Led the effort in installing a new Enterprise Data Warehouse. The EDW was purchased from Guidewire. Responsibilities included installation of basic EDW for Claims Center, Policy Center. Led a team of onshore and offshore developers to create new ETL for missing content and develop customizations for business. Used SAP BODS 4.2, Oracle 11g and 12c, Linux Scripting.2010 – 2014 DataStage Center of Competency Technical LeadFounding member of the DataStage Center of Competency. Established DataStage as the de facto standard for ETL development. Responsibilities include training new developers, creating best practices, working with data architects and designers to leverage DataStage, development and deployment. IBM DataStage/InfoSphere 8.1, Oracle 10-11c, IBM DB2, Linux Scripting.2007 – 2010 Data Warehouse Technical LeadLed data warehouse team in supervising the daily deliverable of data, developed and enforced the team's SDLC, managed bug tracking, gathered requirements and managed project deliverables. Used PL/SQL Oracle 9-10, Linux Scripting

Sr. ConsultantLead/Assistant Architect in customizing Siebel 7.5 for a large consumer goods company. Responsibilities include: Training team on optimizing Oracle code, and architecting data warehouse solutions. Data warehousing effort consisted of developing a methodology to quickly process 57 million records on a nightly basis, this target was achieved for an average of 20 minutes per run.

Development Manager, Oracle Contracts ServicesDeveloped a code generator with Java , JDBC, and XML to produced generic table handler API’s for database insert/update/lock/delete tasks. Contributed to department training by presenting several series of Java and XML classes. Classes covered OOP principles, Introspection, Swing, applets, servlets, RMI (network programming), JDBC, and thread processing. Managed team of three, to develop forms, reports, for Oracle Contract Services. Principal responsibilities dealt with developing and supporting code for importing data, upgrading from previous versions and key forms development and support. Other responsibilities included architecting solutions, writing HLDs, DLDs, managing responses to bug issues across several branch versions, patch deployment, and pager support. Assisted in the requirements gather, architecture and development of buy side contracts. Built team website with HTML DB. Oracle 9i (9.2.0.2.0), Java, XML, XSL, PL/SQL, Forms 6i, Designer 2000

Created data model for Content Engine. ScreamingMedia’s Content Engine received articles, classified them into categories, then distributed them to its customers to give the fresh content for web articles. The database was to contain all articles for an indefinite period. The data model leveraged Oracle 8i data warehouse capabilities, namely table partitioning, to allow massive amounts of articles to be searched and easily month-balled. Developed customizations for Oracle Applications to fit business process needs. Responsibilities included interviewing end-users, gathering requirements, supervising development team, and project management. Oracle Applications CRM 3i, ERP 11.0.3. Oracle 8i (8.1.6). Oracle 8.0.5 database. Oracle Forms 4.5.

2/2000 – 5/2000 Assisted in the development of Oracle Contracts Web screens. Created an Advanced Query Screen to retrieve contracts. Used Java Server Pages, HTML, JavaScript, and Java JDBC.10/1999 – 11/1999 Working as a liaison between Oracle Contracts and NCR (Oracle’s Strategic Design Partner with Contracts). Responsibilities include handling customer suggestions for product development.6/1999 – 9/1999 Created PL/SQL API’s for Oracle Contract Services, an Oracle Front Office application. Part of a two man team which handled all server-side table functionality via API’s, for Oracle Contracts. Forms developers would use our API’s for any table interaction. The API’s functionality included standard INSERT, UPDATE, DELETE, and LOCK functionality, but also enforced referential integrity since foreign key enforcement cannot exist on a distributed database. Used PL/SQL, Designer 2000. Oracle RDBMS 7.3 & 8i 3/1998 – 5/1998 Instructed Developer/2000 Release 2 Forms 5.0 Classes for Oracle Education 12/1997 – 2/1998 Assisted in the conversion of an Ingres database to an Oracle database. Was responsible for C scripts which performed periodic maintenance functions. 9/1997 – 12/1997 Assisted in the generation and maintenance of GUI screens for tracking appropriations. Created an installation package with Install Shield. Used Designer/2000, Developer/2000, Install Shield.

Lead DeveloperEmployed as lead software engineer. Responsibilities included screen creation, report generation, background processing and performance tuning. Created character-based inventory tracking systems for retail companies. Converted Oracle Forms from V3.0 to V4.5. Used Developer/2000. Maintained GUI front-end for said product with PowerBuilder 4.0 and 5.0. Used Oracle 7.3, Developer/2000, Forms 4.5, PowerBuilder 4.0 and 5.0, C, Pro*C, SQL*Forms 3.0, Korn/Bourne Shell programming on a RISC 6000 with an AIX platform. Worked for Retek.

1/1993 – 10/1993 Total Cost Management ConsultantResponsible for the creation of all screen and reports of an inventory tracking system for the Department of Labor. Used Oracle 6.0, SQL*Forms 3.0, and SQL*ReportWriter on a VAX/VMS. 10/1991 – 5/1992 Quality Technologies ConsultantResponsible for the coding of a menu driven laboratory information management system. Used Oracle 6.0, SQL*Forms 3.0, and SQL*ReportWriter on a UNIX server.1990 – 1991 Computer Power Group Consultant8/1991 – 10/1991 Assisted in the data modeling of a database system, which tracked different benefits packages sold by a marketing company. Used CICS, DB2 and embedded SQL in COBOL code on a VAX/VMS platform. 5/1991 – 8/1991 Participated as part of a two-man team, which created a student registration systemfor a college of law. The system encompassed student registration to the college, assigning student to the courses, faculty management, grade tracking and archiving of student records. Responsibilities included project management, end-user interviewing, development of the database and screen design, and creation of all reporting needs. Used Oracle 6.0, SQL*Forms 2.3 and RPT on a PC platform. 2/1991 – 5/1991 Participated in the design and programming of a human resources tracking system.The effort tracked employee skills, which ranged from education to work experience. Was responsible for the creation of all reports generated by the system, assisted in the development of the database and developed screens for end-users. Used Oracle 6.0, SQL*Forms 2.3 and RPT on a VAX/VMS mainframe. 9/1990 – 2/1991 Participated in the design, programming and reporting of a property management system. Was responsible for the creation of on-line and batch reports, assisted in the development of the database and screens to user specifications. Used Oracle 5.0, SQL*Forms 2.3 and RPT on a VAX/VMS mainframe.