SUMMARY:

• IT professional with extensive experience in wide variety of finance and business applications and ability to quickly adapt to a variety of environments and languages and changing workloads.
• Proven experience with z/OS, TSO, CICS, DB2, QMF, SQL, FILEAID/DB2, IBM SPUFI, TWS, COBOL, REXX, Endevor, Changeman, BMC tools, ICETOOL, File Manager, SORT, HP Quality Center, XML, HTML, CA - 7, and WEBSPHERE .
• Strong analytical skills. Knowledge and experience in DB2 performance and tuning.
• Experience in installation and configuration IBM products (RDZ, Eclipse).
• Extensive record in 24/7 Production support, production issues resolutions, QA testing, and weekend and emergency implementation.

TECHNICAL SKILLS:

Systems: WINDOWS, UNIX, LINIX, OS/MVS/XA/ESA, TSO/ISPF, SALESFORCE.COM

Languages: COBOL, REXX, ASSEMBLER, C, VB, APEX, VISUALFORCE

Software: CICS, BMS, SDF, IBM UTILITIES, VSAM, PANVALET, EXPEDITER, FILE-AID, INFOMAN, CHANGEMAN, JCL, MICROFOCUS WORKBENCH

Databases: tableBASE, DB2 (SQL, SPUFI, QMF), ACCESS, EXCEL, ADABAS (NATURAL)

Interoffice communications: MS OFFICE (POWERPOINT), LOTUS NOTES, MS OUTLOOK.

PROFESSIONAL EXPERIENCE:

Confidential, Pennington, NJ

Senior System Analyst/ Developer

Responsibilities:

• Perform detail systems analysis and qualitative testing for defined systems and processes
• Review business / system requirements and create detailed test scripts / test plans using predefined processes and procedures
• Extract data from production and load to test region, setup program to run test process in test region to validate function of changes and identify critical points of process to validate data.
• Design, develop, execute process to extract data for validation and compare data, create reports and test cases for users to review.
• Execute detailed test scripts to provide regression testing with big amount of data.
• Report all system defects found during testing
• Support periodic weekend and off-hour software releases.

Confidential, New York

Senior System Analyst/ Developer

Responsibilities:

• Reviewed coding in long running programs and provided changes to improve performance using COBOL, DB2, VSAM, and CICS.
• On the business users requests, created multiple ad-hoc reports using JCL, TSO, SORT, ICETOOL, TSO, and REXX.
• Reviewed and supported production implementations
• V alidated and test communication processes between mainframe and distributed environment after production implementations .
• Reviewed and approved processes for “out-of-cycle” production installations.
• Provided support to Disaster Recovery tests including switching operations between two Data Centers.
• Reviewed supported applications schedules and usages of resources, made corrections to prevent production issues.
• Created Data validation process to prevent production abends due to the invalid input data.
• Built Error alert process to notify developers of issues in various log files.

Confidential, New York

Contractor

Responsibilities:

• Provided production and maintenance support to the company’s mainframe based applications. Revised several processes to address performance issues.
• Build and managed data export/import processes from mainframe to the distributed systems.
• Build and managed tables, tables relations, and data.
• Executed regular support requests for all SFDC instances including configuration, user administration and security matrix maintenance, data management, reports and dashboard development.
• Implemented Formula fields and Roll-up summary fields.
• Applied Validation rules to maintain data integrity.
• Created Workflow rules and Workflow Actions, created and configured Approval processes and Assignment Rules to support Business Processes.
• Created various reports and dashboards for custom and standard objects to provide detailed overview of renewals, balances, and forecasting.
• Provided maintenance support and administration services including data cleansing.
• Evaluated and installed third party applications from the Salesforce AppExchange.
• Imported and exported data using Data Loader, Import Wizard and weekly Export.
• Utilized agile methodologies in system analysis, design, and development.

Confidential, Long Island City, New York

Senior System Analist/Developer

Responsibilities:

• Designed and implemented new “check image” function.
• Build processes to support multilingual, business, and Consumer statements; to assemble data for the Private Banking Group statements.
• Revised application’s architecture to add DB2 table to split data to improve DB2 performance for the business statements with more than 6K pages.
• Demonstrated significant commitment by regularly working nights, weekends, and holidays to successfully deliver projects on schedule.
• Responsible for the statements’ part of the Retirement Product Services (RPS) redesign project.
• Performed business analysis and wrote requirements for the RPS project data sources, completed data mapping.
• Improved performance efficiency by redesigning processes for large volume of transactional data.
• Developed several procedures to support data migration to the Web based applications.
• Revised statements’ process to prepare data for the HP Extream Formatter. Wrote specifications for the new statement format.
• Prepared test cases and project’s documentation. Organized training sessions for the application users.
• Created automated email process for sending financial reports as attachments.
• Designed and developed processes to print “I-1099” statements and to request statement re-printing.
• Participated in design and development of Statements On the Web (SOW) system to produce bank statements for businesses and customers upon request.
• Created on-line and batch programs to accept orders, collect archived data, generate statements in PDF format, download them from mainframe to a server using IP address, and to notify customer via e-mail (CICS, DB2, COBOL).
• Responsible for the development and maintenance of the CitiGold statement system.
• Expanded system by adding new functions: automatic rendition process and in-house printing for XEROX printers (COBOL, ADABASE, NATURAL).
• Developed programs to gather business data from the mainframe database and load it to the Oracle Database using SQL*LOADER.

IT Consultant

Confidential

Responsibilities:

• Participated in creating COMMODITIES ON-LINE TRANSACTIONS system that provided interactive editing, audit trails, and record keeping. Designed and developed several on-line and batch programs (COBOL, CICS, DB2).
• Developed programs to support Future Trades and Treasury Bills addition and cancellation processes (COBOL, DB2).
• Wrote on-line menu driven programs with screens which allowed users to add, update and delete information and facilitated up and down loads of various financial data (COBOL, CICS).
• Strengthened operations through the software system design, coding, and testing. Provided 24/7 on call support.

Confidential

Applications Consultant

Responsibilities:

• Participated in creating COMMODITIES ON-LINE TRANSACTIONS system that provided interactive editing, audit trails, and record keeping. Designed and developed several on-line and batch programs (COBOL, CICS, DB2).
• Developed programs to support Future Trades and Treasury Bills addition and cancellation processes (COBOL, DB2).
• Wrote on-line menu driven programs with screens which allowed users to add, update and delete information and facilitated up and down loads of various financial data (COBOL, CICS).