SUMMARY:

Experienced ETL Developer with Informatica and Power Center and Power Exchange with strong Cobol skills to used in integrating Mainframes and Networks with a background in the financial industry. I am a forward thinking professional that works well independently or in a team environment.

TECHNICAL SKILLS:

SOFTWARE: Microsoft Office, Informatica/PowerCenter 8.1.1, PowerExchange, UDO/CDE Confidential, COBOL, COBOL II, TSO/ISPF, DB2, VSAM, UNIX, CDB2/SQL, JCL, FOXBASE+, MicroFocus COBOL, TCP/IP, JAVAPearl Scripting, UDO/CDE by Informatica, Oracle 10g, SQL Server, Panvalet, Expeditor, Endeavor, Abend - Aid, SPUFI, QMF, Omegammon, Confidential, Oracle Forms, Oracle Reports Intertest, IDCAMS, Realia Cobol, File-Aid, DB2 File-Aid, ClistPowerbuilder, Visual Basic, HTML

DATABASES: DB2/SQL, FOXBASE+, DB-Vista, Clipper, Progress, VSAM, Oracle 10g

HARDWARE: IBM 3090, MVS/ESA, AT&T Starlan, Novell, Motorola 68000Mini’s, Micro’s, Arcnet, Ethernet, IBM 370

EXPERIENCE:

Confidential, San Antonio, Texas

Data Warehouse Programmer

Responsibilities:

• Developed and Supported complex SQL Queries, Stored Procedures, and job scripting
• Developed some Oracle Reports and Oracle Forms to show results better for management
• Excellent ability to analyze business requirement document and then design, develop and implement ETL process to accomplish the requirements
• Excellent understanding of Data Warehousing concepts and best practices
• Working knowledge and experience with Enterprise class RDBMS environments (such as Teradata, Oracle, DB2, MS SQL Server)
• Updated JAVA procedures
• Strong technical and analytical skills

Environment: Windows 7, Informatica Power Center 8.6, Teradata v13, Power Exchange, Lotus Notes, Citrix, Cobol, DB2, Perl Scripting, Teradata BTQ Scripting, MS Office

Confidential, Addison, Texas

ETL Data Analyst

Responsibilities:

• I was on a team that consisted of onshore and offshore teams from India. The Data Refresh Integration Project was tied to a billing project
• Responsible for developing a database structure that fits into the overall architecture of the system under development and has to make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls.
• I had to write and maintain load scripts and load systems and analyzing load systems and supporting complex sql queries.
• I also participated as a ETL Developer creating workflows and job streams and worked closely with the Data Architect to optimize sql queries wherever.
• We used Windows XP and Unix with Oracle 10g . I also worked with Oracle Reports and Oracle Forms and Confidential, unix’s version control system.
• This project also interfaced with the mainframe to download (FTP) files and also for testing or comparing DB2 tables.

Environment: Windows NT, Microsoft Project Manager, IBM Terminal Emulator, IBM 3090, MVS/OS, MQ Series, Synsort, COBOL II, DB2, TSO/ISPF, ABEND-AID, Expeditor (Batch debugger), Endeavor (Library manager), Oracle 10g, Informatica PowerCenter/Power Exchange, Unix

Confidential, Plano, Texas

ETL Developer

Responsibilities:

• Held different roles: Team Lead, ETL Developer & Facilitator for meetings with the EDS client in Australia
• Using Unix Pearl Scripting for maintance tasks
• Making changes utilizing INFORMATICA PowerCenter, Creating workflows and Job streams
• Validated databases using SQL, Improve client integration and efficiency
• Created new procedures for running the ETL workflows/work streams
• Modifying PROCS to reference new/changed files
• Creating new JCL/PROCS/GDG’S for new workflows development
• Documenting Program, JCL, Unit Test changes for peer review
• Few batch jobs were schedule using CA7 on the mainframe
• Worked with Oracle Forms & Oracle Reports for showing results in a more visual format
• NDM on the mainframe side for FTP of modules over to the client for review
• Creating DOCLIBS for job scheduling
• Familiar with Webservices, MySQL
• Other tools used - ENDEVOR, SUPERC and EXPEDITOR, CDE/UDO,SPFPC, VISIO, PowerPoint Presentation
• Recorder / Facilitator for meetings with the client (Common Wealth Bank of Australia)

Environment: Windows NT, Microsoft Project Manager, IBM Terminal Emulator, IBM 3090, MVS/OS, MQ Series, Synsort, COBOL II, DB2, TSO/ISPF, ABEND-AID, Expeditor (Batch debugger), Endeavor (Library manager), Oracle 10g, Informatica PowerCenter/Power Exchange, IP Switch Pro, Unix

Confidential, Dallas, TX

Programmer Analyst

Responsibilities:

• Responsible for development/maintenance in Credit Card system
• Reformatting VSAM files using File-Aid batch and IDCAMS
• Making programming changes using COBOL/DB2
• Revising or adding new copybooks
• Modifying PROCS to reference new/changed files
• Creating new JCL/PROCS/GDG’S for new program development
• Documenting Program, JCL, Unit Test changes for peer review
• Creating DOCLIBS for job scheduling
• Other tools used - Endevor, Superc, and Expeditor

Confidential, Houston, TX

Programmer Analyst

Responsibilities:

• Responsibilities included the enhancing of 15 screens and 15 Confidential and 10 batch modules of the Online Collection System of Oil Credit Card processing system. The system was also well documented in manuals as well as Property Insurance Applications
• Used Microfocus Cobol as a pilot tool for new programs or systems
• Enhanced their Intranet site with reports detailing what activities were done for that day.
• Enhanced the Risk system to be more efficient and flexible. Handle multiple of clients all over the United States. Our Houston division processes oil cards with clients with multiple special handling and special billing purposes. (Shared on-call support 24/7) The handling of the oil cards is very similar to the way credit cards are handled and process.

Environment: Novell Network, Windows NT, IBM 3090, MVS/OS, MQ Series, Unix, Microfocus Cobol, Confidential, COBOL II, TSO/ISPF, ABEND-AID, Intertest, Expeditor (Batch debugger), Endeavor (Library manager), Syncsort, CA7, Confidential /DB2