SUMMARY:

• A Software Engineer with vast expertise in database and application design, development and all stages and aspects of SDLC.
• Ability and experience in design, development and implementation of highly efficient software solutions in complex business environment to meet demanding SLA, performance and availability requirements.
• Skilled in IBM Mainframe technologies and a wide spectrum of software products, development and monitoring tools, languages and utilities. Extremely skilled and proficient in DB2 for z/OS at Development and Database Administration Level. Well versed in SQL and the most recent and efficient features and components. Well acquainted with the latest releases and new functionality, and performance enhancements they provide.

TECHNICAL SKILLS:

Operating Systems: z/OS, OS/390, MVS, VM/ESA, VM/SP, UNISYS MCP/AS.

Languages: Enterprise COBOL, Enterprise PL/1, SQL, SQL/PL, C, REXX, CLIST, JCLDLALGOL, WFL

Data Base Management: DB2 9, DB2 10, IMS DB/TM, Advantage CA - Datacom DB

Transaction Management: CICS, IMS/TM

Tools: and Utilities: BMC DB2 Catalog Manager, BMC Utilities, BMC MainView, BMC Apptune, BMC Log MasterIBM Development Center, IBM Data Studio, ASG TMON, CA DataQueryCA DataReporter, CA File-Aid/DB2, CA Fileaid/IMS, CA Fileaid, z/OS System UtilitiesDB2 Utilities, Syncsort, DFSORT, Access Method Services (IDCAMS), ICKDSF, SPUFI, QMF

Change Management: TSO/ISPF, ISPF Development(Dialog Manager), VSAM, ASAP Scheduling Facility, OPC schedulerCA-7, CA AllFusion ERwin, Serena Magic Quadrant(ALM), Clarity, NDM (Connect Direct), FTPco: Z SFTP, CA AllFusion Intertest, STROBE, Rumba, Astra, Reflection, IBM HOD.

PROFESSIONAL EXPERIENCE:

Confidential - Bethesda MD

Senior Systems Analyst

Responsibilities:

• Revenue Management is multi-tier application with data store DB2 for z/OS.
• I’ve been working primarily on Database and Application design, development of DB2 Stored Procedures - COBOL and Native, Triggers, Performance Monitoring and Tuning.
• I worked on 3 large and successful projects and a variety of smaller projects as technical team lead and team member.
• Time Zone Region Processing for Group Data
• The major focus of the project was to allow 24x7 availability and improve critical data accuracy for International Properties via performing database updates at Time Zone level.
• The project entails Single Group Data Store (SGDS) database partitioning and associated code changes to utilize the new database structure, establishing batch processing schedules at Time Zone level for all inbound applications. The second large segment of the project were the downstream applications, which utilize SGDS database in batch and online. The major complexity was the scope - a large number of components subject to analysis and change. We also acheaved exceptional performance improvement - in some instances over 80% elapsed time and 60% CPU savings.
• Group Pricing Optimizer (GPO 2.0) - SOA with multiple consumers, the most critical of which Marriott.com. Mutitier environment environment incorporating IBM mainframe, Websphere Application Server, Unix, etc.
• The objective of the project was to improve performance and reduce response time and cost. My through analysis revealed that the main reason for performance drawback was the excessive small DRDA calls - dynamic SQL and single statement stored procedures. The application was restructured and rewritten, where necessary. By means of consolidation and utilization of efficient DB2 features and techniques we achieved substantial reduction of the number of messages and database calls which provided considerable performance improvement. It also improved the maintainability of the application.
• Function Space Availability - Mutitier environment incorporating IBM mainframe, Websphere Application Server, Unix, etc. The service provides group reservations for function rooms through Marriott.com. I worked on POC, database and application design, and development of DB2 Stored Procedures, volume testing, performance monitoring.
• Conversion of Opera properties to CI, medium size project, which migrates and converts property data from one sales and catering system(OPERA) to another(CI).

Environment: IBM Mainframe, z/OS, Enterprise COBOL, REXX, DB2 9/DB2 10, SQL, SPUFI, BMC Catalog Manager, BMC Utilities, BMC MainView, BMC Apptune, BMC Log Master, IBM Development Center, IBM Data Studio, TSO/ISPF, Panvalet, PanApt, CA-7, JCL, IBM System Utilities, Syncsort, IBM DB2 Utilities.

BCBS - CareFirst - Owings Mills MD

Senior Software Engineer

Responsibilities:

• I worked primarily on two large, high profile projects as technical lead and team member:
• Inter-Plan Teleprocessing System (ITS), which is a Confidential Association standard for data exchange between BCBS plans for out of state services.
• I was in charge of the conversion of the application from VSAM to DB2. Worked primarily on DB2 and CICS environment configuration, data conversion, performance tuning, analysis and design of interfaces to in-house claim applications.
• Worked on prior and subsequent releases of the application, which introduce business and functional enhancements to satisfy HIPAA or BCBS Association standards. I also provided production support on rotational basis. Under my quidance, the team managed to reduce application failures to negligible minimum.
• Unified System Services (USS) - A multi-tier application, which provides unified, web-based interface to medical claims data, benefits, subscriber details for Maryland and DC. Available in all Customer Service Offices.
• I worked on Design and Development of DB2 Stored Procedures in DB2 for z/OS, which provide claims and benefits information. My responsibilities were Analysis, Design, Development, Performance Analysis and Tuning, all aspects of testing, implementation.
• I also worked on:
• Ad-hoc reports, requested by Business Analysts for in-dept data analysis, identification of potential inaccuracies or discrepancies, or for auditing purposes.
• CareFirst specific DB2 environment set up for efficient testing and validation.
• Ongoing formal and informal and technical guidance to team members in DB2 and SQL, analysis and coding techniques.

Environment: IBM Mainframe, z/OS, Enterprise COBOL, REXX, DB2 V8, SQL, DB2 Utilities, SPUFIBMC DB2 Tools and Utilities, IBM Development center, CICS, CA File-Aid, CA File-Aid/DB2, ASG TMON, STROBE, TSO/ISPF, Changeman, Serena Magic Quadrant(ALM), Clarity, Panvalet, CA-7, JCL, IBM System Utilities, Syncsort.

Confidential, Boston MA

Senior Software Engineer

Responsibilities:

• Detailed design, development, unit and integration testing, and implementation on project Global Income Control (GIC).
• GIC processes Domestic and Foreign Corporative Actions and Dividends. It is a mainframe application, operating on IBM zSeries. The data is stored in DB2 and CA-Datacom DB databases, accessed online via CICS transactions. Considering that State Street offices and sub-custodians are geographically dispersed, the centralized online systems operate 24x7x365, and there is no dedicated batch processing window. The batch runs in parallel with the online application, which makes software design and coding demanding and challenging.
• I worked on several projects - batch an online, in DB2, or DB2/Datacom mixture environment in close cooperation with SSC DBA personnel to synchronize performance and availability requirements.
• I worked on technical specification, development, documentation, test plans, unit, volume and stress testing and implementation.

Environment: IBM Mainframe, z/OS, Enterprise PL/I, Enterprise COBOL, DB2 V8, SQL, DB2 Utilities, SPUFI, CICS, CA File-Aid for DB2, ASG TMON, Advantage CA-Datacom DB, CA-DataReporter, CA DataQuery, MQ Series, TSO/ISPF, ChangeMan, OPC Scheduler, JCL, Syncsort.

Confidential, Boston, MA

Senior Systems Analyst

Responsibilities:

• The application handles complex listings, which service representatives create for the customers. It is a 3-Tier application with web based front-end, middle tier Netscape Application/Enterprise Servers and IBM Mainframe - CICS, DB2 for OS/390.
• I worked on requirements clarification, DB2 database and application design, detailed design, coding, code walk-through and testing
• Billing Order and Support System (BOSS).
• BOSS is a mission critical application, used by CSR and providing access to billing data and gateway to a wide range of other online applications with different business functionalities. Approximately 900,000 lines of source code - 70% PL/I and 30% COBOL, DBDs, PCBs, etc.
• I was involved in development and implementation of new subsystems, interfacing BOSS in batch and online, implementing new functionalities. I also performed analysis of production failures, implementation of patches, to promote the stability and reduce the ABEND rate of the application. I was involved in 24X7 on call production support on rotational basis, problem diagnosis and solving.

Environment: IBM Mainframe,OS/390, PL/I, COBOL II, REXX, DB2, SQL, MQ Series, DB2 Utilities, SPUFI, Erwin, CICS, CA File-Aid for DB2, ASG TMON, Endevor, Librarian, ASAP, MQ Series, TSO/ISPF, ISPF Development(Dialog Manager), JCL, IBM Utilities, IMS DB, IMS TM, Syncsort

Confidential

System Administrator, System Programmer

Responsibilities:

• I worked as a system administrator and system programmer on Unisys A Series - A11-E22 and A11-422. The two systems work in parallel with RDB (Remote Database Backup) in ABW (Audit Block Write) mode. The primary system is a production system, the secondary operates as a DR installation as well as development environment.
• I was in charge of system software installation and configuration, performance monitoring and tuning, capacity planning and operational support. Developed service DCALGOL programs and WFL procedures essential for specific operational requirements; worked on Multi Lingual System configuration and support.
• Responsible for System Operations and first point of contact for technical support.

Environment: Unisys A Series, MCP/AS, COMS, MARC, CANDE, BNA, ALGOL, DCALGOL, WFL, System Utilities, SMFII, TeamQuest, Attachmate InfoConnect.

Confidential

DB2 Server Data Base Administrator and VM/ESA System Administrator

Responsibilities:

• I was in charge of the design of National Pensions Database in DB2 (SQL/DS) at logical and physical level.
• Designed and developed the migration software package, to unload/restructure/edit the data from VSAM and load to the new DB2 (SQL/DS) database. Performed data migration from VSAM to DB2 Server (SQL/DS). Designed and developed the software package for database daily update during redevelopment in DB2 Server (SQL/DS) environment to facilitate performance tuning and regression testing environment.
• Established VM/ESA environment for development teams. Performed ongoing technical assistance and to application development teams in SQL, PL/I and ISPF development, REXX.

Environment: IBM mainframe, VM/ESA, VM/SP, DB2 Server, VSAM, AMSERV, PL/I, REXX, EXEC2, ISPF Development(Dialog Manager), SQL, ISQL, VM and DB2 Utilities, SyncSort.

Confidential

DB2 Application DBA, Team Leader and Programmer Analyst

Responsibilities:

• Information Services is leading IT Company in Bulgaria oriented in application software design and development. It develops and supports a wide range of application systems, running on company’s computer systems or at clients’ sites.
• I worked as DB2 Application Administrator, Programmer Analyst and Team Leader on 3 projects, gathering and defining requirements, database design, application design, programming, implementation and maintenance of th e application systems - Corporation Planning, Commodity Exchange, Financial and Staff Information, operating in 75 data centers countrywide.

Environment: IBM Mainframe, VM/SP, OS/VS1, DB2 Server, ISPF Development(Dialog Manager), PL/I, SQL, ISQL, QMF, COBOL, C, REXX, EXEC2, JCL, VSAM, CICS, DB2 and System Utilities, Syncsort for CMS and OS/VS1, Tubes