ETL Specialist Resume

SUMMARY:

IT professional with 22 years of combined experience in the government, media and banking industries. Dedicated to excellence with an excellent record of meeting and exceeding expectations in the analysis, design and implementation of business technology solutions. Served 20 years in the Army Reserves by running the Unit Level Logistics System (ULLS) program for my unit.

PROFESSIONAL EXPERIENCE:

Confidential

ETL Specialist

Successfully implemented several high - profile projects in support of the Defense Commissary Agency (DeCA) initiatives that saved the agency several man-hours.
Design and create complex SQL in Teradata environment, UNIX/LINUX scripts and Informatica mappings in order to load information into the Enterprise Data Warehouse (EDW) and send email to appropriate parties in the event of errors during operation.
Submit and resolve Remedy tickets (issue tracking) related to correction of defaults and/or enhancement to the EDW environment and providing reporting information.
Provide 24/7 production support on a on-call basis to ensure all sales data is loaded into EDW in a timely manner.

Confidential

ETL Specialist

Developed and maintained PeopleSoft customizations in versions 6.0 and 8.0 developed and maintained complex Informatica maps and workflows using Informatica Powercenter 7.1.1 for the purpose of moving data from a legacy system into PeopleSoft environment.
Developed and maintained PeopleSoft customizations in versions 6.0 and 8.0.
Developed and maintained SQR programs/reports
Interacted with functional users to determine requirements for new changes/projects. created PL/SQL scripts, UNIX scripts, Maestro scripts and mainframe JCL in order to automate PeopleSoft processes.
Provided documentation for users whenever new applications were implemented.
Successfully implemented PeopleSoft project which allowed clients to correct data that had been imported from legacy system, which significantly reduced the clients’ error correction time.
Successfully set up the framework to allow SQR reports to be run through the PeopleSoft process scheduler, which drastically reduced the need for programming new reports and also put more control into clients’ hands by allowing the set up new run controls.
Successfully led effort for my application to ensure smooth process integration after being acquired by a larger company.
Built excellent rapport with internal clients, ensuring a great working relationship.

Confidential

Senior Programmer Analyst

Developed new PeopleSoft pages, records and PeopleCode for PeopleSoft 7.0. applied patches and fixes for PeopleSoft Accounts Payable application.
Interacted with functional users to determine requirements for new changes/projects.

Confidential

Programmer Analyst

Developed PeopleCode, pages and records for PeopleSoft Accounts Payable application.
Responsible for migrating changes from development database to production database.
Kept abreast of the latest patches and fixes for PeopleSoft Accounts Payable system and applied them as needed.
Single-handedly performed successful PeopleTools upgrade over a weekend. Upgrade included implementing changes on several UNIX servers and over 15 Novell servers. assisted in implementing a plan for migrating data to production database.
Established great rapport with Accounts Payables clients.

Confidential

Junior Programmer

Responsible for troubleshooting and installation of COTS software for the Defense Commissary Agency.
Deployed McAfee Anti-virus software to DeCA PCs and remote servers.
Assisted with setup of networking capabilities for new PCs
Developed, tested and implemented new ADASage code for the military Unit Level Logistics System (ULLS) program.

TECHNICAL SKILLS:

Hardware: IBM PC, Sun Workstation

Operating Systems: HP/Sun UNIX, Windows NT/2000/XP/7/8/10, Linux

Telecommunications/Networking: Novell, Microsoft

Databases: Oracle (latest version - 11g), Teradata (latest version - 15), SQL Server (latest version - 7.0), Informix

Programming Languages: UNIX/LINUX scripting, ADA, SQR, Crystal Reports, C# (training), Perl

Software Packages/Tools: Informatica (latest version - 9.5.1), PeopleSoft (latest version - 8.1), MS Office, Visio, Altova Suite (XML)

Methodologies: Waterfall, Agile, Object-Oriented Programming (limited)