** **** *** *****

Holland PA *****

Phone *** - *04 - 4795

E-mail acss2s@r.postjobfree.com

ALEXANDER KLEBANOV

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.

Worked on projects for clients such as PECO Energy, Blue Cross and Blue Shield of Pennsylvania (Healthcare Insurance), The Franklin Mint(Retail –Marketing), CHARMING SHOPPES(Retail), Inc., CIGNA Corporations (Group Insurance), The Hartford Insurance, American Reinsurance (Property & Casualty Insurance), Munich Reinsurance America(Property & Casualty Insurance), AETNA(Healthcare Insurance), TRALS (Import –Finance).

Objective Application/Solution/System Architect or Project Leader Position.

Education

Belarusian State Polytechnic Academy, Minsk, Belarus. BS in Mechanical Engineering minor in Mathematics.

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.

Visa Details

US Citizen

Contact Details

Home Phone No: 215-***-**** Mobile Phone No: 267-***-**** E-Mail: acss2s@r.postjobfree.com

Relevant Project Experience

Organization: TRALS 22113, Logoisky Tract 15/4 Minsk, Belarus

Title System Architect/Project Manager.

Client TRALS 22113, Logoisky Tract 15/4 Minsk, Belarus

Operating System UNIX, Windows 7

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

Team Size 10

Role Application/Solution Architect, Data Architect

Period Apr 2013 – current

Project Description: Financial Reporting System

Role and 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.

Organization: Cognizant Technology Solutions

Title Sr. Application Architect, Application Architect./Project Manager

Client AETNA, Blue Bell, PA

Operating System UNIX, zOS, Windows XP, Windows 7

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

Team Size 12

Role Application/Solution Architect

Period November 2010 – Dec. 2012

Project Description Multiple projects for Datawarehouse and Business Intelligence Domain

Role and 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.

Title Data Warehouse Specialist.

Client Munich Reinsurance America, Princeton, NJ

Operating System UNIX, zOS, Windows ‘Vista’

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

Team Size 8-10

Role Project Lead

Period March 2006 – November 2010

Project Description Multiple projects for Corporate Data Warehouse and Business Intelligence Area including different domains of Property and Casualty business.

Role and 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, 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.

Title Consultant.

Client American Reinsurance, Princeton, NJ

Operating System UNIX, zOS, Windows 2000

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

Team Size 4 - 10

Role Project Lead

Period September 2001 - March 2006

Project Description Multiple projects for Corporate Data Warehouse and Business Intelligence Area including different domains of Property and Casualty business.

Role and 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.

Title Consultant.

Client The Hartford Insurance, Fort Washington, PA

Operating System UNIX, zOS, Windows 2000

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

Team Size 6-8

Role System Analyst, Sr. Developer

Period March 2001 - September 2001

Project Description Multiple projects utilizing MQ processing.

Role and 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.

Title Consultant.

Client CIGNA Corporations, Philadelphia, PA

Operating System zOS, Windows 2000

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

Team Size 4

Role System Analyst, Sr. Developer

Period May 2000 - March 2001

Project Description Multiple projects utilizing Oracle/DB2/CICS processing for Group Insurance using DB2 stored procedures.

Role and Responsibilities

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

oAssisted IBM in troubleshooting of DB2 (V6)/OS390 new features.

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

Title Consultant.

Client CHARMING SHOPPES, Inc., Bensalem, PA

Operating System UNIX, zOS, Windows 2000

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

Team Size 3 - 5

Role System Analyst, Sr. Developer

Period October 1997 - March 2000

Project Description: Multiple projects utilizing DB2, Oracle and Teradata processing.

Role and 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.

Title Programmer/Analyst II

Client THE FRANKLIN MINT, Lima, PA

Operating System zOS, Windows 2000

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

Team Size 8

Role System Analyst, Developer

Period September 1996 - October 1997

Project Description Multiple projects utilizing DB2 processing.

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

Title Consultant.

Client ARMS Inc./IMI SYSTEMS Inc., Haddonfield, NJ

Operating System zOS – IBM Mainframe

Tools DB2, COBOL, CICS, VSAM, Database Utilities

Team Size 3-5

Role System Analyst, Sr. Developer

Period September 1995 - September 1996

Project Description Multiple projects utilizing IBM Mainframe environment.

Role and Responsibilities

As a Computer Consultant for a major medical insurance company (Independent Blue Cross/ Blue Shield of Pennsylvania):

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.

As a Computer Consultant at a major utilities company (PECO Energy):

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

Title Programmer.

Client William J. Labb Sons Inc., Philadelphia, PA

Operating System Windows

Tools Basic, Micro Focus COBOL, VSAM, C, Visual Basic, MS Access, MS Excel

Team Size 6-8

Role Programmer/Analyst

Period March 1992 - August 1995

Project Description Multiple projects utilizing CNC machines.

Role and Responsibilities

Designed, coded, tested, maintained, modified, converted, and adapted programs for various type CNC systems and machines developed converting and translating applications.

Trained personnel to use CNC machines software and utilities.

Developed applications to create reports and business forms according to user’s requirements (Micro Focus COBOL, VSAM, C, Visual Basic, MS Access, MS Excel).

Title Lead Programmer / Analyst.

Client Electronic Component Manufacturing Company, Minsk, Belarus

Operating System IBM Mainframe

Tools COBOL, VSAM, C, FORTRAN

Team Size 60-80

Role Lead Programmer / Analyst

Period August 1988 - August 1991

Project Description Multiple projects for toolmaking department.

Role and Responsibilities

Performed design thorough implementation of new on-line Information System for the Engineering Research Department, supported and maintained existing processes, developed applications to produce various statistical and special reports, created converting translating and adapting applications for various CNC machines using different command operational systems.

Served as a liaison between IT and Toolmaking Department to define business requirements, provided appropriate software solutions and users training.

Trained personnel to use CNC machines software and utilities.

Developed applications to create reports and business forms according to user’s requirements (COBOL, VSAM, C and FORTRAN).

Contact this candidate