SUMMARY

• Extensive (over 20 years) experience in information systems architecture, systems and data analysis, application design, development, testing, implementation and support for commercial applications.
• Ability to provide technical architecture vision and recommend strategy/solution, collaborate with Project Manager, Architects, Business Analysts, Data analysts, Developers, and QA/Testers to size and estimate project efforts, develop work plans, define task dependencies, and deliver solutions.
• Expertise in all phases of project life cycle in mainframe and client/server environments.
• Strong professional communication and leadership skills with the ability to perform effectively both independently and as part of a team.
• Experience in APLC/SDLC an Agile methodology.

TECHNICAL SKILLS

Hardware / Platforms: IBM Mainframe, UNIX, Windows 98/XP/2000/7.

Technology: IBM DataStage, Ab - Initio, Informatica, COGNOS, uni-SPF, SyncSort, PipeSort, MaxSort, IBM Utilities, PLATINUM Utilities for DB2, BMC Utilities for DB2 and Oracle, CANDLE DB2 Tool Kit, Move for DB2, BTEQ/MLOAD/XPORT for TERADATA, WinDDI, Oracle Server Utilities, TOAD, ErWin, FTP, FTF, XCOM, NDM, CONNECT:Direct, CEDF, INTERTEST, XPEDITER, COBTEST, FILE-AID, COMPAREX, STROBE, SYSVIEW, MS Office Tools.

Programming Languages: COBOL, JCL, EASYTRIEVE PLUS, CICS, IBM MQ-Series, VSAM, FORTRAN, C, TSO, CLIST, ISPF Dialog Manager and Macros; Pro-Cobol, Micro Focus COBOL/CICS; Visual Basic, VBA

Databases: DB2 ESE with DPF, DB2 UDB for zOS, DB2 UDB for UNIX and Windows, Oracle, PL/SQL, SQL*Plus, TERADATA, MS SQL Server, MS Access.

Scripting Languages: UNIX Shell Scripting, REXX

Version Control Systems: LIBRARIAN, PANVALET, ENDEVOR, IBM Rational ClearCase.

PROFESSIONAL EXPERIENCE

Data Warehouse Specialist

Confidential

Responsibilities:

• Designed, led development, testing and implementation of various Corporate and Local Data Warehouse related large scale software systems (Client, Treaties, Certificates, Finance, Claims, Cash, AAIC Direct Insurance, ICO ETL database, special Data-Marts) including applications feeding corporate Data Warehouse from legacy (mainframe and AS400) source systems (DB2, COBOL, CICS, VSAM, MQ-Series, JCL, ZEKE), using ETL methodology, data transferring processes, data manipulation, data extract/transformation/load and balancing applications in Unix/Oracle environment (FTP, Unix, Oracle, DB2, Micro Focus COBOL, Pro-Cobol, PL/SQL, DataStage), database loading (SQL*Loader).
• Collected and analyzed user’s requirements, performed impact analysis, created functional and detail specifications, project plans and production schedules, reviewed proposals for new projects as to remain consistent with industry strategies, managed the project schedule to meet the business objectives, ensure that SLC processes are applied in accordance with company policy throughout all phases of the project lifecycle.
• Served as lead and mentor for teams of developers involved in multiple Corporate and Local Data Warehouse projects.
• Performed the assessment for current state of data warehouse and determined the gaps and provided the target state ETL architecture, developed and reviewed the high level ETL architecture.
• Participated in database design, data analysis and data modeling.
• Performed problem solving analysis and programming to preserve data integrity between Data Warehouse and legacy source systems.
• Performed Audit Trail analysis for all production Oracle Data Bases, created and supported Access DB providing required usage statistic and reporting.
• Performed day-to-day support and maintenance for all major Data Warehouse systems.

Confidential

Responsibilities:

• Designed, led development, testing and implementation of various Corporate and Local Data Warehouse related large scale software systems (Client, Treaties, Certificates, Finance, Claims, Cash, AAIC Direct Insurance, ICO ETL database, special Data-Marts) including applications feeding corporate Data Warehouse from legacy (mainframe and AS400) source systems (DB2, COBOL, CICS, VSAM, MQSeries, JCL), data transferring processes, data manipulation, data extract/transformation/load and data balancing applications in Unix/Oracle environment (Unix, Oracle, DB2, Micro Focus COBOL, Pro-Cobol, PL/SQL, DataStage), database loading (SQL*Loader).
• Collected and analyzed user’s requirements, performed impact analysis, created functional and detail specifications, project plans and production schedules, reviewed proposals for new projects as to remain consistent with industry strategies, managed the project schedule to meet the business objectives, ensure that SLC processes are applied in accordance with company policy throughout all phases of the project lifecycle.
• Served as lead and mentor for teams of developers involved in multiple Corporate and Local Data Warehouse projects.
• Performed the assessment for current state of data warehouse and determined the gaps and provided the target state ETL architecture, developed and reviewed the high level ETL architecture.
• Participated in database design, data analysis and data modeling.
• Performed problem solving analysis and programming to preserve data integrity between Data Warehouse and legacy source systems.
• Performed day-to-day support and maintenance for all major Data Warehouse systems.

Confidential, Fort Washington, PA

Responsibilities:

• Designed, developed, tested and implemented multiple applications utilizing MQ processing (IBM MQSeries, COBOL, CICS, VSAM, DB2 and Unix scripting) including online application for browsing messages in queue and moving messages from one queue to another, recycling messages from Dead Letter Queue based on information from Dead Letter Queue Header, online application maintaining parameters for process of pooling and tracing data from different messaging queues (regulates writing into log/JES files, starts/stops pooling process or change process parameters like queue manager wait duration, empty queue wait duration, abend wait duration, abend attempt counter, batch window start/end time, and others), online application to setup dynamically MQSeries options and queue names (source, target, and others) for MQ Driver, applications for storing in DB2 and then reprocessing MQ data that for any reason have not been written in queue successfully. Reprocessing application can be started from terminal or by using CICS PLT (Program List Table) and reschedules itself after certain period of time or after processing certain number of messages. Weekly purge job also was implemented.
• Performed enhancements and maintenance to existing MQ related applications.
• Developed multiple additions and maintenance changes to HUB - a set of software modules that provides a common interface to access and update data that supports the AARP Health Care Options. Performed maintenance and updates on DB2 tables containing metadata to utilize HUB for new applications.

Confidential, Philadelphia, PA

Responsibilities:

• Participated in Gateway Extract Service project - multi tier metadata driven application providing optimized data interchange between relational DB2 (V6) based Enterprise Database (EDB) containing personal/client demographic, eligibility, and enrollment data. Developed and implemented major elements of the project including process set up tier and dispatcher, application programming interface (API) accessible from different platforms, business layer, and application log. All programs utilize COBOL/DB2 and LE370. Nested DB2 stored procedures and Global Temporary Tables where employed. Created and implemented common debugging technology for stored procedure development and testing.
• Assisted IBM in troubleshooting of DB2 (V6)/OS390 new features.
• Worked on Client Setup Dual Write project. While being added or changed through Desktop VB based system, information is written into EDB database and should be transformed and replicated into new Customer Service (CSFODS) database. Responsibilities include data analysis and data mapping, analysis of databases intercommunication rules, design, coding, production implementation and modification existing and new modules and stored procedures (PL/SQL, Oracle, COBOL, CICS, DB2).