Support Analyst Desktop Applications Resume

SUMMARY:

25+ years in the Information Technology field
7 years experience in DataStage Parallel Extender programming working with DB2/UDB and Microsoft SQL Server 2000 and 2005.
17 years of mainframe experience coding COBOL, CICS and EZTreive programs.
10 years experience working on data integration from various banking systems from both mainframe and mid - range sources into an Enterprise Data Warehouse.
Have worked with all stages of the software development life cycle.
Strong debugging and problem solving skills.
A committed team player with strong communication and leadership skills.

TECHNICAL SKILLS:

Languages: Oracle SQL, PL/SQL, UNIX Shell Script, COBOL;

Hardware: IBM AIX Unix, Windows Platforms;

Operating Systems: Unix, Windows XP, Windows NT 4.0, Windows 2000, MS-DOS;

Ancillary Skills: DataStage 7.5 & 8.0 (server/EE), IBM DB2 UDB, Visio, FTP, MS Office Suite, Autosys, SQL Plus, UNIX Shell, ClearCase, SharePoint 2003/2007, InfoPath 2003

Networking: TCP/IP, Windows NT, Windows for Workgroups;

Applications: Corporate Enterprise Data Warehouse, Mortgage Systems (Loan Origination);

Mainframe: COBOL, CICS, EZTrieve, CA7, CA11, FileAid, IBM ISPF, IBM TSO

Databases: DB2, Microsoft SQL Server 2000/2005 and Oracle

EXPERIENCE:

Confidential

Support Analyst Desktop Applications

Responsibilities:

Support and analyze the automated logic flows for the trouble call agents for all three lines of business - Video, Internet and Telephone.
Code SQL macros for various ad hoc reports based on the flows used for customer trouble shooting.
Support the desktop Knowledge Management System which is the main source of all agent process documents, customer information and reporting for supporting any customer need.
Create and maintain several on-line input forms using InfoPath 2003.
Developer for Kana Enterprise which will replace the present Knowledge Management System.

Confidential

Applications Consultant / Enterprise Data Warehouse/ETL Team

Responsibilities:

Involved in requirements gathering and source data analysis and identified business rules for data migration and for developing data warehouse.
Involved in identifying the data inputs from various source systems depending upon the business requirement.
Created source to target mapping documents from staging area to Data Warehouse.
Contribute to the overall planning of projects and issue resolution by recommending approaches, identifying resources, and developing timelines.
Documented procedures for configuring, maintaining, upgrading, testing, and coding the application/custom interface routines.
Code mainframe COBOL programs on an IBM mainframe environment using VSAM, DB2, Oracle and flat file structures.
Coded small EZTreive reports as needed by the Business Analysts.
Used Changeman as the version control for all programs.
Used File-Aid and Abend-Aid as debug tools.
Used CA-7 and CA-11 as scheduling tools.
Used IBM TSO.
Use DataStage Designer to design and develop both Server and EE jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
Develop various jobs using DataStage Teradata, ODBC, Hashed File, Pivot, XML, Change Capture, LookUp, Join, Modify, Funnel, and Transformer stages.
Modify existing DataStage jobs based on new business requirements.
Design, perform and document unit testing for the project.
Use DataStage Manager for importing metadata into repository and also for importing and exporting jobs into different projects.
Use job sequence for error strategy and exception handling.
Use Autosys Job Scheduler to create jobs, job streams. Schedule the job streams based on the dependency.
Use ClearCase Version Control.
Work multiple projects at the same time under tight time constraints.
Initiate, run, and monitor the batch process.

Confidential

Programmer/Analyst

Responsibilities:

Code mainframe COBOL programs on an IBM mainframe environment using VSAM and flat file structures for the Retirement Reporting and CD/IRA systems.
Maintain the existing CICS system for entering retirement reporting information.
Coded small EZTreive reports as needed by the Business Analysts.
Used Changeman as the version control for all programs.
Used File-Aid and Abend-Aid as debug tools.
Used CA-7 and CA-11 as scheduling tools.
Used IBM TSO/ISPF.

Confidential

Programmer Analyst

Responsibilities:

Code mainframe COBOL programs on an IBM mainframe environment using VSAM and flat file structures for the Third-Party Billing system.
Coded small QuickJob reports as needed by the Business Analysts.
Used Pan Valet as the version control for all programs.
Used File-Aid and Abend-Aid as debug tools.
Used CA-7 and CA-11 as scheduling tools.
Used IBM TSO/ISPF.

Confidential

Programmer Analyst

Responsibilities:

Code mainframe COBOL programs on a Sperry/Univac mainframe environment using flat file structures and Univac tables for the Third-Party Billing, Patient Information, General Ledger, Building Maintenance and Patient Billing systems.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship