Sql Server System

Cesar Garcia Phone: / 609-***-**** / **********@*****.***

SUMMARY

• Over 20 years data processing experience of large IBM oriented application systems and software development.

• Extensive experience in System Analysis/Design and Problem identification and resolution IMS/DLI, CICS, IDMS ADSO, COBOL, MICROFOCUS, COBOL, DB2, COBOL PC and Mainframe development

TECHNICAL SKILLS

Hardware/

Software 30xx, 43xx, 370/xx 360/xx

MVS/xa, Os/Vs Dos/vs Vsam Jcl, CICS DLI Analysis and design IDMS/R Concepts and Facilities, Application development with ADSO and ads/Batch Data Base navigation, Interact IDMS db-dc Operations, On-Line Mapping On-Line Query, Adsa, IDD COBOL Data Communications On-Line debug, Culprit Panvalet Change Management, Tso/Ispf, Roscoe MF-CICS Os/2 Microfocus COBOL, SQL Workbench, Paradox(Pal), Novell Sql Idms Pc Development for idms/R DB2, QMF, SPUFFI, POWERBUILDER COBOLII EASYTRIEVE, VIASOFT CLIST SMARTEST FILE AID for Vsam and IMS/DB, XPEDITER, CLIST SAS. Crystal Reports, EZTRIEVE, VSAM, SQL SERVER, OPEN VMS, DCL VAX , PLATINUM, VISIO, VB6, ROSCOE, MQ Series, ENDEVOR, Z/os, ADO.Net, SQL Server 2005. VB.Net, C#, ADO.Net

Languages COBOL, Bal, Pli, Pascal, Pal, VB.Net, C#

PROFESSIONAL EXPERIENCE

PROFESSIONAL EXPERIENCE:

PECO-EXELON –PHILADELPHIA , PA FEBRUARY 2011 - NOW

Senior System Consultant

• Consultant Responsible for the analysis, development and support of In-House Enhancements to implement international ACH billing transactions and invoicing in an EDI/DB2/VSAM Environment.

• Responsible for the enhancement of the Payment Suppliers application to Generate the new IAT NACHA batches of data and deliver those interfaces to the Banks for them to translate, validate and post international and domestic financial transactions into the company accounts using secure FTP. Also responsible for enhancing multiple DB2 modules for the Trading Partner setup and maintenance.

• Responsible for the analysis of project requirements and the development of technical specifications. Developed, tested, debugged, and implemented code for existing and proposed business applications.

• Also responsible for the preparation of the test plan and the application test, that includes the unit, regression and performance test as part of the SDLC process, pre-approved by the corresponding business and technical units.

• Developed QMF reports as part of the existing and new requirements using complex SQL queries. These reports were generated and delivered to the Electric and Gas business units, to include statistical, summary and detail reports.

• Developed modifications to different modules and wrote new programs to support the project in a full DB2 and EDI environment implementing and maintaining DB2 Store procedures.

• Assisted, Maintenance and delivering results and fixes for the Production support environment in a daily on-call basis, responsible for diagnostics and escalation levels. Roles also include emergency migrations and data recreation as well as restarts for the different Backend processes.

Environment: COBOL,COBOL II, XML, EASYTRIEVE, , MVS, JCL SPUFI ENDEVOR, MQ SERIES, SQL VSAM DB2 BMC(DB2) IMS FILE AID FOR DB2, EASYTRIEVE, XPEDITOR, ABENDAID, CA-7 FTP, QMF SPUFFI

Major Business Areas: BILLING, INVOICING, CEDI, SUPPLIERS

FANNIE MAE – RESTON, VA JANUARY 2010 - DECEMBER 2010

Senior System Consultant

• Responsible for the analysis of project requirements and the development of technical specifications. Developed, tested, debugged, and implemented code for existing and proposed business and interface applications.

• Assisted in all procedural and code documentation on assigned projects mastering all phases of application (SDLC). Also Translated functional requirements into technical requirements and design,

• Prepared functional process Charts, system flow charts, and logic diagrams and Participated in the design of new systems Codes. Revised and debugged programs.

• Wrote new programs of moderate to high complexity and scope, working with applications systems designs and specifications

• Utilized standard procedures, enhanced system performance, and defined criteria for testing.

• Developed test cases, scenarios and scripts to ensure application quality.

• Created test transactions ran component, assembly, and system tests for conformance to standards and adherence to design specifications.

• Assisted, Maintenance and delivering results and fixes for the Production support environment in a 24 by 7 on-call basis, with 20 minutes response for initial diagnostics and two escalation levels. Roles also include emergency migrations, data recreation as well as run restarts for the different backend processes identified as fixed.

Environment: DB2, QMF, SPUFI, IDMS, ADSO, IMS, BMC, COBOL, COBOL II, CICS, Z/OS, MAPC, DMLO, OLQ, ADSALIVE, MQ Series, SQL Server, TSO/ISPF/SDSF, Rational Clear Quest.

Major Business areas: Mortgage Backend Security Interfaces, Loan Level disclosure, Collateral Management and Holding, Pools and Cusip, Acquisition, Multi and Single Mortgage Family Data.

ISC-AFLAC Columbus, GA AGOST 2008 TO DECEMBER 2009

Senior Systems Consultant

•Responsible for the analysis, technical requirements, development and support of existed In-House Enhancements to implement requirements associated with the Mainframe and Distributed applications.

•Modify existed On-line modules written in COBOL/CICS/MQ/DB2 to implement several business functions associated with rules inheriting the new Architectural Model.

•Prepare the impact analysis and estimates of the schedule and efforts, Analyze, design, code, test, and install into production approved modifications to existing applications. Assisted as directed in the review of design, code and documentation of other developers.

•I Gathered information from business units and I created the general design document that includes the mapping process; Gap and impact Analysis, technical specifications and the, interfaces design for the Import Export process for the multitier, Distributed, Mainframe Multiplatform software “Tracker’.

•Developed modifications to different modules and wrote new programs to support the project in a full DB2/CICS/MQ environment implementing and maintaining DB2 Store procedures.

•Build and set the test Data (DB2 VSAM SQL Server) for the execution of the new and existed modules including the unit application and integration test.

•Implemented and promotes the modules to a different stages in Endevor including Development, Integration System test(QA) and Packages elevations. Due to the Strategic development decision, this project is implemented in a full SDLC process including peer reviews for each stage defined in the general project plan.

Environment: COBOL,COBOLII, CICS, EASYTRIEVE, MVS, JCL SPUFI, ENDEVOR, MQ SERIES, SQL VSAM DB2 BMC(DB2 TOOL) FILE AID FOR DB2, IMS EASYTRIEVE, NDM, ABENDAID, SQL EXPEDITOR/ONLINE/BATCH, FTP, BMS/GT,TSO/ISPF/SDSF A SQL 2005, C#, Data Dimensions, Visual Studio, SS Management Studio ADO.Net

Major Business areas: Cash Disbursement, Flex Admin, Claims, Escheat process, Life Policy Holders SNG, Accounts Payable.

MIAMI DADE COUNTY- PROPERTY TAXES JAN 2008 – TO JUL 2008

Senior System Consultant

• Responsible for the Design, Analysis, coding, test and migration to the production environment of several new online/Adso and Batch Idms modules for the implementation of the Portability System.

• Rewrote main modules for the Property Taxes that include modules written in IDMS ADSO and Cobol II and Cobol III in a CV and Local modes using complex Structures in many to many relationships.

• Analyzed the business Portability rules (New State Law) and their applications with the creation of IDMS CICS and DB2 programs to complain with the final product rules and the presentation of the Front-end and Back-end processes to the user including The User interface prototype (ADSA). Designed and mapped the layouts used from the payroll information to the main system at MDITD using MQ Series.

• Performed data analysis for the data conversion of several applications to be implemented in a .NET environment SQL SERVER and Re-structure and Re-Modeling reviews. using IDMS DB2 VB forms also Supported and maintained various current IDMS release Application systems, i.e. Property Taxes and Property Appraisal.

• Analyzed ADSO dialogs Easytrieve and CICS modules and suggest adjustments as necessary.

• Coded, unit tested, and debugged Batch DB2, IDMS COBOL CICS modules including unit and application test and the creation of SSI Packages for Data migration from the Mainframe to the SQL Data Bases including the Transformation of some Input Data (ETL).

Environment: DB2, SPUFI, IDMS, ADSO, COBOLII, COBOLIII, CICS, Z/OS, MAPC, DMLO, OLQ, ADSALIVE, MERCURY, FILE AID/DB2 Some VB and SQL Server, COBOL3.

Major Business areas: PROPERTY TAXES AND PROPERTY APPRASIAL.

BANK OF AMERICA / MBNA, Dallas, TX APR 2007 – DEC 2007

Senior Programmer Analyst

• Responsible for the analysis, development and support of the new In-House Enhancements to implement 250 new APR’s to the Credit Card Service Systems at Bank of America.

• Developed interfaces to ensure the File Maintenance Core System was consistently and Logically Running the regular Core production software (Modified Version) Including the Daily, Weekly and Monthly Cycle Runs for North America and Europe.

• Coordinated the execution of the different Pre Cycles runs creating multiple transactions for the different Applications.

• Developed modifications to different modules and wrote new programs to support the project in a full DB2 environment implementing and maintaining DB2 Store procedures.

• Assisted, Maintenance and delivering results and fixes for the Production support environment in a daily 24/7 on-call basis, 20 minutes response for initial diagnostics and two escalation levels. Roles also include emergency migrations and data recreation as well as run restarts for the different Backend processes identified as fixed.

• Redesigned, created, and loaded multiple objects (Tables, Store Procedures, Triggers) in SQL Server 2005 using Transaction Scripts, also the modification and creations of new form classes using Visual Studio 2005, VB. C# NET, ADO.NET for 3-tier Architecture Net framework as Application Server & Windows 2003 professional/ XP Professional

Coding of several Microfocus COBOL/DB2 to load the extracted Mainframe Data warehouse and the conversion of several Microfocus COBOL programs to be run in the mainframe using MASTER BUILDER and APS

Environment: COBOL,COBOLII, EASYTRIEVE, DYL280,SAS, MVS, JCL SPUFI, ENDEVOR, CA-7 MQ SERIES, SQL VSAM DB2 BMC(DB2 TOOL)FILE AID FOR DB2, EASYTRIEVE , ABENDAID, SQL Server, visual Studio, Visual Basic 2005 Net.

Major Business areas: CREDIT CARDS

CARE FIRST BCBSMD/CODDINGTON, DEC 2006 – APR 2007

Senior Programmer Analyst

• Responsible for supporting and developing interfaces between the Health Application Facets and the Mainframe Environment. Roles which included the creation of multiple PROCS to load the information extracted from Informatica and Unix Boxes using ETL to update the DB2 Tables in a full COBOL Easytrieve MVS/JCL environment.

• Developed, tested, debugged, and implemented code for the Mainframe-Distributed application for the International Classification of Diseases(ICD-9).

• Also responsible for Solving Production Support problems for the different applications and the creation of data from the Mainframe to be compared and tested.

• Through the use of different business rules extracted data using FTP’s to be load in the mainframe and created Easytrieve reports for the users of the system, middleware developers, and the QA staff that evaluated the multiple data results.

• Developed modifications to different modules and wrote new programs to support big enhancements on MMIS,

Medicare Recovery Audit Contractor program (RAC) and Managed Care Plans.

• Responsible for the design , modification and implementation of multiple reports for the auditing, Account and internal quality control procedures and reviews departments.

• Support the Translation of transaction process from Gentran applications (EDI - 837 and a 835). Wrapping and Unwrapping EDI transaction HIPPA Translator.

Environment: COBOL,COBOL II, EASYTRIEVE, MVS, JCL SPUFI PANVALET , IMS, FILE AID, SQL VSAM DB2 IMS, SARJCL, OPSPROG, FTP ABENDAID,EDI Gentran, ERWIN,TSO/ISPF/SDSF

Business Areas: INVOICING, FACETS, UNIX, INTERFACES, MEDICAID, MEDICARE, HIPPA, EDI

BANK OF AMERICA / MBNA, Dallas, TX FEB 2006 – NOV 2006

Senior Programmer Analyst

• Responsible for acting as developer and support between the testing Services, Maintenance Groups and the development teams for the In-House new release installation of the MBNA and Bank Of America Credit Card Services.

• Enhanced Major Product Application for VISA, MASTER CARD, AMEX and UBS.

• Developed interfaces to ensure the File Maintenance Core System was correctly transmitting the changes made in the application.

• Coordinated the execution of the different Pre Cycles runs creating multiple transactions for different Applications and the executions of NDM ‘s from the production to the test Box (Mainframe)

• Participated in the maintenance and development of PROMOTIONS, PARAMETERS, PROSPECTS CARDHOLDERS, MONETARY and NON-MONETARY TRANSACTIONS PROFILE and DEMOGRAPHICS.

Environment: COBOL,COBOLII, EASYTRIEVE, DYL280,SAS, MVS, JCL SPUFI ENDEVOR FILE AID, MQ SERIES, SQL VSAM DB2 BMC(DB2 TOOL) FILE AID FOR DB2, ABENDAID

Major Business areas: CREDIT CARDS

AMERICAN GREETING, OH AUG 2005 – JAN 2006

Programmer / Business Analyst

• Responsible for the analysis of project requirements

• Translated functional requirements into technical requirements and design.

• Prepared system flow charts and Participates in the re-design of existing systems.

• Wrote new programs working with applications systems designs specifications utilizing standard procedures, also Enhances system performance Defines criteria for testing Develops test cases, scenarios and scripts to ensure application quality Creates test transactions, runs component to assembly the system tests for conformance to standards and adherence to design and specifications.

• Worked on major business areas: Tiering, reservation accounts, purchase orders, and billing for major stores.

Environment: DB2, SPUFI, IDMS, ADSO, COBOL, COBOLII, CICS, Z/OS MAPC, DMLO, OLQ, ADSALIVE, ENDEVOR MQ Series, SPUFI ADSALIVE and Some JAVA.

Major Business areas: TIERING and RESERVATION ACCOUNTS, PURCHASE ORDER, and BILLING FOR MAJOR STORES

DOWJONES - WALL STREET JOURNAL JUL 2004 – JUL 2005

Senior System Consultant

• Responsible for the analysis of project requirements and the development of technical specifications.

• Developed, tested, debugged, and implemented code for existing and proposed business applications.

• Assisted in all procedural and code documentation on assigned projects mastering all phases of application (SDLC). Also Translated functional requirements into technical requirements and design,

• Prepared functional process Charts, system flow charts, and logic diagrams and Participated in the design of new systems Codes

• Revised and debugged programs.

• Wrote new programs of moderate to high complexity and scope, working with applications systems designs and specifications

• Utilized standard procedures, enhanced system performance, and defined criteria for testing.

• Developed test cases, scenarios and scripts to ensure application quality.

• Created test transactions and ran component, assembly, and system tests for conformance to standards and adherence to design specifications

• Worked on major business areas: Billing and Retention, Multicall Contacts, and OLF Week Process.

Environment: DB2, PLATINUM, SPUFI, IDMS, ADSO, COBOL, COBOLII, CICS, Z/OS, MAPC, DMLO, OLQ, ADSALIVE, MERCURY Test Director Some VB6 and SQL Server.

MIAMI DADE COUNTY- TRANSIT DEPARTMENT JUN 2003 – MAY 2004

Senior System Consultant

• Responsible for the Analysis, coding, test and migration to the production environment of several Transit Applications.

• Rewrote main modules for the schedule and Mini Scheduled for the three major transit Systems.

• Analyzed the business union rules and their application with the creation of DB2 programs to replace the current payroll editing programs.

• Designed and mapped the layouts used to transfer payroll information to the main system at MDITD using MQ Series.

• Wrote of TOS and POS (Major COBOL CICS data transfer payroll systems).

• Performed data analysis for the data conversion of several applications to be implemented to the Oracle data Bases using SQL SERVER , IDMS CRYSTAL REPORTS, and some Existed Visual Basic Programs.

• Supported and maintained various current release systems, i.e. Bus and Rail Applications.

• Analyzed ADSO dialogs Easytrieve and CICS specifications and suggest adjustments as necessary.

• Coded, unit tested, and debugged Batch DB2, IDMS COBOL modules including unit and application test.

MIAMI DADE COUNTY – MDITD OCT 2002 – APR 2003

Senior System Consultant

• Analyst Responsible for the elaboration of Business Specification Through the use of the State Methodology and responsible to translate these rules into Technical Specifications for a Proposed Real Time Architecture using Mq Series, Idms, Adso, Mapc, Olq, Dmlo, Cics, DB2, Store Procedures CoboII.

• As part of the Team I was also responsible for the creation of Some of the Programs for the new Core Application( Real time interface for the interchange of transactions between two different State agencies).

• Prepares User Test Scripts for the users of FACTS and FLKIDS Including the new Online Cics, Db2, redesign. Also interacted with the QA staff to evaluate the multiple data results. Developed and wrote brand new programs to support The project Using COBOL, COBOLII, MVS, JCL CICS, SPUFI PANVALET FILE AID, SQL, DB2 and MQ Series.

Business areas: FACTS: The Judiciary State System and FLKIDS: Family State Court System.

MIAMI DADE COUNTY - TRANSIT DEPARTMENT AUG 2000 – JUN 2002

Senior System Consultant

• Consultant for a Government Agency, responsible for the coding test and migration to the production environment Using IDMS/ADSO, COBOL SAS Culprit CLIST in the areas of Bus and Train Maintenance Systems.

• Responsible for the Analysis of Major enhancement and their solution. Also, responsible for the coding of brand new DB2 IDMS CICS COBOL MQ Series Adso and SAS modules in the areas of Inventory.

TYCO INTERNATIONAL JUL 1999 – MAY 2000

Senior System Consultant

• Responsible for the Analysis, coding, and enhancements of the Commissions, Sales Production Contract processing, contract works, National Accounts and other related applications. Duties included 7/24 on-call Maintenance.

• Developed system in IMS/DB-DC-DLI in an MVS Environment. Also, responsible for multiple User Requirements developed in IMS/CICS COBOL/OS 390, DB2 and Easytrieve.

OFFICE DEPOT FEB 1998 – JUN 1999

Senior System Consultant

• Responsible for the Maintenance and developing of the Warehouse system applications in a multi CICS – Regions environment for 23 states Using IDMS, COBOL, DB2, VSAM and MQ.

• Provided production support for other applications and the development of the Y2K remediation.

NCCI APR 1995 – JAN 1998

Senior System Consultant

• Responsible for the Analysis coding and Enhancements of the DCI System, Workers Compensation, employee injury data, Rating and Statistics.

• Developed the system in IDMS release 12.0 in an MVS environment. Also, Responsible for multiple user requirements using IDMS, Adso, CICS, DB2 and Easytrieve.

• Responsible for the coding of interfaces to the Experience Rating system using COBOL CICS and DB2, QMF, SPUFFI to integrate the Date Directory information system in a unique source of information for the On-line Environment.

• Responsible for the conversion of The CIF application (On-Line Version) to the Y2K standards using

CICS, DB2 ,IDMS, COBOL, Viasoft and Smartest.

COMPUTER HORIZONS - CITICORP MAY 1992 – MAR 1995

Senior System Consultant – Project Leader

• Responsible for the maintenance of existing applications including conversions Analysis design and coding in an MVS environment Using CICS, COBOL VSAM.

• Responsible for the management of the Global Finance System for the Citicorp Company for Brazil, Argentina and Mexico (Cosmos 53 Applications).

• Responsible for the Analysis Coding and Enhancements of the DCI System This role also include the coding of interfaces to the DB2 databases coded in COBOL, CICS and SQL. Beside the technical role also responsible for the management of projects including resources

(12 Programmer Analysts), Hardware Needs and Third Party Software.

• Day-to-day business application support and management for production systems – handling system issues, answering user queries and monitoring applications to ensure maximum system

uptime. This involves close interacting with the business users and IT groups across the region and

globally to ensure issues are resolved in a timely manner as per the Application Management stand

BUDGET SERVICES/MIAMI DADE COUNTY FEB 1991 – APR 1992

Consultant

• Responsible for the coding, test, and migration to the production environmental of IDMS/Adso, COBOL Culprit CICS Programs in the areas of: Building and Zoning, Tax Delinquent System, Personal and payroll System.

• Responsible for the Analysis of the existing enhancement and their solution. Responsible for the coding of brand new COBOL Adso and CICS modules in the areas of building and Zoning.

• Responsible for coding IDMS/Adso Programs for the new Personnel and payroll system via Global Specification. As a member of the development team responsible for the generation of coding and testing of brand new Microfocus COBOL Programs using Relational Database(IDMSR) And SQL in a workbench environment.

ESSEX COMPUTER SERVICES MAY 1990 – JAN 1991

Consultant

• Responsible for the migration from development to a test environment of the following CAS applications: INV Inventory Control, BOM Bill Of Material, MRP Material Replacement Planning.

• Was responsible for the identification of COBOL/Dml ADS/O, CULPRIT and JCL’s to apply the in-house changes.

• Responsible for the implementation of the Ptf’s to the batch descriptions throughout the use of the infotsis in a telecommunication environment from a data base located in Boston.

• Responsible for the modifications of the batch and On-line programs an run it in a test environment to be approved by the user (parallel).

METRO INFORMATION SERVICES FEB 1989 – MAR 1990

Senior Consultant

• Responsible for the analysis, programming test and user training for a major telephone Company of the following activities using IDMS/O ADSA, IDD COBOL-DML, CULPRIT AND CICS:

o Customer information directory (Costumer services for the billing inquires)

o Financial application used as an interface to the CAS System

o On-line application for the data gathering of the personnel System.

o On-line application for the update of the transaction for the payroll System.

• Responsible for the creation of the conversion module that allows the load of the data files from MSA files to the CAS data bases.

• Was responsible for coding an On-line application to the Update of the CAS, as an interface to submit Inventory ledger entries, indirect material, salvage value plant displaced physical inventory purchases and supply expenses to the Cullinet General Ledger.

A.G.S. INFORMATION SERVICES MAR 1988 – JAN 1989

Consultant

• Developed programming specifications for the On-Line provider contract system at a major insurance company.

• Was responsible for the development of the On-line Prototype that served as a model for dialogs flow and control.

• As a part of the development team, programmed, tested and Successfully implemented the on-line components of the provider System using IDMS COBOL And ADSO.

• Responsible for the implementataion of the records lock for the provider system.

• Worked on the interface between the On-line and proposed Batch Systems, this Involves the analysis of all I/O modules Sub schemas and Schemes Components and their entities in the IDMS environment.

CULLINET SOFTWARE FEB 1984 – FEB 1988

Software Engineer

• Supported Banking Software Packages, and maintained multiple systems for the government and industrial clients.

• Designed and implemented the On-line BWCS version of the Banking Software package for international clients using IDMS and CICS.

• Supported and maintained various current release systems i.e. Saving and Certificate of deposit for Major Accounts.

• Analyzed ADSO dialogs specifications and suggest adjustments as necessary.

• Coded, tested, and debugged Adso dialogs COBOL CICS and ADS/B dialogs.

• Redesigned a third party application using complex IDMS database Structures.

• Wrote specifications, coded ADS/O dialogs and COBOL modules including unit and application test, design of the required paths to be applied in the Logical record facility and Subschermas.

SOCIAL SECURITY ADMINISTRATION MAR 1978 – JAN 1984

Project Leader

• Assigned to a lead project for the elaboration of a national project identification and collection Systems.

• Responsible for the design of the physical and logical databases in an MVS/IMS environment. Also, responsible for the creation of routines in DLI that allows the use of standards for the COBOL-DLI Programming, DLI calls PCB’s Masks and SSA (Qualified and Unqualified).

• Responsible for the support and maintenance of various current release systems in CICS COBOL DOS/VSE.

ST. AGUSTINE COLLEGE- CHICAGO ILLINOIS JAN 1988 – DEC 1989

Instructor

• Basic, COBOL System Analysis

EDUCATION

BSE Systems Engineer

University Federico Villareal, Lima Peru

**********@*****.***

Contact this candidate