Senior Solutions Architect Software Consultant Resume

SUMMARY

TECHNICAL SKILLS

Languages: PLSQL, DDL, Unix Korn Shell, ESL(Formaly EASEL), PowerBuilder, COBOL, JCL,CICS

Tools: Oracle Streams, DataStage(training only), SQLDeveloper, RapidSQL, Eclipse, Lotus NotesOutlook, PVCS, Control - M, TFS, GIT, MS Office

Database: Oracle, DB2, Sybase, JDBC

PROFESSIONAL EXPERIENCE

Confidential

Senior Solutions Architect Software Consultant

Responsibilities:

Developed and maintained PLSQL packages that are called by IIP Web application for a large Enterprise Data Warehouse(EDW). Also did development and support for a PLSQL package called by the Fund Accounting application.
EDW is the Confidential's future for all core data, ear marked to be called by many applications.
EDW is stored in a Oracle Exadata platform due to the size of the tables.
The response time is still very good due to Exadata platform.
The data is fed from a large Hadoop datatabase.
Used GIT as repository.

Confidential

Senior Architect Software Consultant

Responsibilities:

Developed and supported PLSQL packages that were created to be the Transformation and Load for a data warehouse ETL.
The ETL extracted from multiple data sources.
The Extract was done using Oracle Streams.
The load was to an Oracle DB which was considered to be a data mart.
The data mart was then queried by a Web application.
Required to become familiar with Oracle Streams for ongoing support and development of the Transformation PLSQL. Also worked on PLSQL that interfaced with Anti - Money Laundering(AML) application. Used PVCS as repository.

Confidential

Senior Solutions Architect Software Consultant

Responsibilities:

Performed design, development, and support on single client specific DB which was another developed ETL that extracted data from the client using Java batch code that contained SQL using JDBC, FTP, and Oracle Triggers.
Created DDL on all of the Oracle. As application got more mature the team size decreased in 2008 so I was the only developer working on the DB as a result I did all of the data modeling using SDLC methodology and I also supported the Java batch which contained embedded SQL.
I also did all the DDL and tuning for over DB with over 80 tables in Chicago and the matching schema in Singapore. In late 2015 new software was being introduced so I was involved in evaluating Jira as a replacement for our Lotus Notes DB we used for workflow.
I worked on other teams as well that are listed above. Was due to work on DataStage application so learned the software and did a little development before the project was cancelled due to lack of funding. Used PVCS and TFS as source repository.

Confidential

Senior Software Consultant

Responsibilities:

Design, development and support of ESL applications throughout the Confidential . They all took data from IMS or CICS applications on the mainframe.
Designed and developed large ESL application for over 1,000 users worldwide that decreased users from 30 days of training in the use of IMS to 1 day to learn the GUI front - end which converted over 100 IMS tranIDs to intuitive graphical menus and windows.
Was the the team lead for five developers. Also developer on PowerBuilder applications using COBOL stored procedures and DB2.

Confidential

Application Consultant

Responsibilities:

Began working on OS/2 and learned ESL GUI software. Worked as developer on large ESL application with six other developers.

Confidential

Programmer/Analyst

Responsibilities:

Started as batch COBOL programmer for two years and then progressed to programming on large email system written in COBOL with CICS that was used by entire corporation of 18.000 employees worldwide.