We provide IT Staff Augmentation Services!

System Architect/project Manager Resume

EXPERIENCE 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, Agile, Waterfall and TOGAF methodology.

OBJECTIVE:

Application/Solution/System Architect or Project Leader Position.

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, UML.

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, Java

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.

RELEVANT PROJECT EXPERIENCE:

Confidential

System Architect/Project Manager

Operating System: UNIX, Windows 7

Tools: Oracle. MS Access DB, Unix, Pl SQL, ProCobol, Micro Focus Cobol

Responsibilities:

  • Collected and assessed business requirements.
  • Prepared architectural and design documentation.
  • Performed system analysis and development of all level project technical requirements and testing strategies.
  • Performed hardware, software and licensing requirements estimation, risk assessment, budget and affordability reviews.
  • Designed, led development, testing and implementation support for component design and development of Financial Activities Data Mart and supporting Access DB modules providing required statistic and reporting.
  • Providing implementation and post-implementation support.
  • Established standards for architecture, design, development and production support.

Sr. Application Architect, Application Architect./Project Manager

Confidential, Blue Bell, PA

Operating System: UNIX, zOS, Windows XP, Windows 7

Tools: IBM Rational Software Modeler, UML, IBM Rational ClearCase, IBM Rational ClearQuest

Responsibilities:

  • Architectural analysis and development of all level project requirements and testing strategies
  • Risk Assessment, affordability reviews,
  • Creating application architecture documentation, automated process models, use cases, non-functional requirements and technical checklists including hardware, software and licensing requirements estimation,
  • Architectural support for component design and development for Datawarehouse and various Data Marts including usage of multiple ETL and reporting tools (Data Stage, Informatica, Ab-Initio, COGNOS, Micro-Strategy)
  • Implementation and post-implementation support.

Data Warehouse Specialist.

Confidential, Princeton, NJ

Operating System: UNIX, zOS, Windows ‘Vista’

Tools: Oracle, DB2, MS SQL, DataStage, COBOL, Pro-Cobol, PLSQL, UNIX Scripting, MQ-Series, Database Utilities

Responsibilities:

  • Designed, led development, testing and implementation of various Corporate and Local Data Warehouse related large scale software systems 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, Java), 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.
  • Lead DW project of decommissioning mainframe based database (DB2/VSAM) and processes replacing them with required functionality in UNIX environment using Oracle and SQL Server.
  • 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.

Consultant.

Confidential, Princeton, NJ

Operating System: UNIX, zOS, Windows 2000

Tools: Oracle, DB2, Accentual, COBOL, Pro-Cobol, PLSQL, UNIX Scripting, MQSeries, Database Utilities

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.

Consultant.

Confidential, Fort Washington, PA

Operating System: UNIX, zOS, Windows 2000

Tools: DB2, Oracle, COBOL, CICS, VSAM, PLSQL, UNIX Scripting, MQSeries, Database Utilities

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 Confidential Options.
  • Performed maintenance and updates on DB2 tables containing metadata to utilize HUB for new applications.

Confidential, Philadelphia, PA

Operating System: zOS, Windows 2000

Tools: DB2, COBOL, CICS, VSAM, MQSeries, Database Utilities

System Analyst, Sr. Developer

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).

Confidential, Bensalem, PA

Operating System: UNIX, zOS, Windows 2000

Tools: DB2, Oracle, COBOL, Pro-COBOL, CICS, VSAM, UNIX Scripting, MQSeries, Database Utilities

System Analyst, Sr. Developer

Responsibilities:

  • Worked on implementation of Arthur Allocation package - merchandise distribution system comprising central Oracle database with users PC through ODBC link.
  • Created cross-platform interfaces and processes in order to support connections and real time data synchronization between UNIX based Allocation package (Oracle, PL/SQL), MVS (DB2, VSAM), and UNIX based DW (TERADATA, PL/SQL).
  • Created batch and on-line event triggered multiplatform applications.
  • These applications were developed using Oracle, PL/SQL, COBOLII, Pro-COBOL, DB2, VSAM, CICS, and IBM MQ-Series and allowed to access and update DB2 and Oracle tables and VSAM files simultaneously. For DB2 Data Collection modules dynamic SQL was utilized. Oracle Procedures, Functions and Triggers were widely used in these processes.
  • Participated in Arthur Performance Tracking System elimination project.
  • This system consisted of proprietary database contained large volumes of actual and plan business data plus client/server based front end.
  • It provided a number of ways to monitor business performance through on line queries and by generating variety of reports.
  • Modification was done to eliminate Arthur and make all systems rely on data extracted from NCR TERADATA based Corporate Data Warehouse along with replacing front end by WinDDI and Decision Master. Designed, developed, tested and implemented number of complex applications running in multi-platform (SUN UNIX/MF MVS/Windows NT) environment.
  • It included, along with others, extracting data from company Data Warehouse TERADATA tables, TERADATA XPORT and MULTILOAD with dynamically created SQL, and COBOL/DB2 batch processes using temporary indexes and dynamically bound plans.
  • Worked on Black Book by SKU project (COBOL, DB2, VSAM, CICS) - corporate inventory management system. Developed major applications for database population using streams of transactional, sales, shipments, markdowns, and physical inventory data. Participated in logical and physical data design. Designed and implemented partitioning on main Black Book Inventory table, developed data base maintenance process which includes table repartitioning and reorganization, tuned applications performance using EXPLAIN, STROBE and run time monitoring tools.
  • Provided 24/7 production support for all MIS data processing on weekly rotation basis.

Programmer/Analyst

Confidential, Lima, PA

Operating System: zOS, Windows 2000

Tools: DB2, COBOL, CICS, VSAM, EASYTRIEVE PLUS, Database Utilities

Responsibilities:

  • Performed development, support, maintenance and enhancements of major production SABRE system (includes Attrition, Commission, and Bad Debt systems) for Sales/Marketing Department, provided additional twenty four hours production support for all Sales and Marketing systems on rotation basis with other team members.
  • Participated in ongoing modification of Sales/Marketing system to support Customer Satisfaction System European Implementation (COBOLII, EASYTRIVE PLUS, DB2, CLIST).
  • Performed complex analysis on Sales/Marketing database and company Data Warehouse to detect and eliminate unsynchronized data, establish and restore data integrity, developed jobs for clean-up and data conversion, defined methods and implemented jobs for monitoring achieved results (COBOLII, DB2, DB2 Connect, EASYTRIVE PLUS).
  • Developed new production Mailstream process for UK market witch does address standardization, generates and prints bag and individual post labels, mail sorted files, and reports (COBOL, EASYTRIEVE PLUS, CLIST, TSO Dialog Manager).

Confidential, Haddonfield, NJ

Operating System: zOS - IBM Mainframe

Tools: DB2, COBOL, CICS, VSAM, Database Utilities

System Analyst, Sr. Developer

Responsibilities:

  • Performed enhancement, support, and maintenance of Out Of Area Claims System, problem solving analysis and programming (COBOL, DB2, VSAM, IMS, FILE-AID).
  • Designed, coded, tested, and implemented custom in-house report generating applications (COBOL, EASYTRIEVE PLUS, VSAM, and DB2).
  • Assisted users in identifying needs and key input/output requirements, participated in defining data base structure, program control methods, and informational flows.
  • Participated in on-going ITS conversion and re-design of existing OOA Claims System.
  • Analyzed, developed and tested new on-line and batch applications for a consolidated accounts payable project (COBOL, CICS, DB2, VSAM), modified them according to end-users requirements, created acceptance test criteria and plans, trained end users.
  • Developed report generating modules for HR Department (COBOL, DB2, and VSAM).

Hire Now