Teradata/ab Initio Developer/lead Resume
Raleigh, NC
TECHNICAL SKILLS:
Classes: Ab Initio, Perl, PMP prep, Informatica PowerCenter (Basics, Advanced Admin & Development), and Microstrategy’s Visual Insite
CORE COMPETENCY:
- Technical Lead for Ab Initio and Informatica Development Teams
- Strong understanding of data warehousing and data extraction techniques for financial reporting.
- Ability to quickly learn new technologies to add value to business processes leveraging MBA and technological knowledge.
- Over 5 years Ab Initio development experience
- Informatica Expert
PROFESSIONAL EXPERIENCE:
Teradata/Ab Initio Developer/Lead
Confidential, Raleigh, NC
Responsibilities:
- Coordinate Teradata Bteq to Ab Initio Conversion effort
- Author of corporate process documentation for AI Dataset configuration
- Ab Initio source - to-target parameterized Graphs.
- Coordinate Tag creation for common projects in TRMC.
- Ensure all meta data lineage is mapped properly in MHUB.
- Coordinate correct dataset and lineage loads to metadata hub for all EDW DataMart groups
- Converted the first Ab Initio application for the CDAS team and helped guide the CDAS team through the remaining conversions while converting multiple applications
- Actively reduced the total tickets (failures/issues) of the applications supported
- Worked closely with technical designers and modelers to determine specification documentation for multiple new and current application
- Trained several new contractors on standard development practices and procedures
- Developed standards for conversion from Informatica’s ETL tool to Ab Initio.
Database/Teradata Developer
Confidential, Raleigh, NC
Responsibilities:
- Performed Confidential administrative tasks and assisted in Confidential upgrade from version 6.x to version 7.x
- Migrated required folders, mappings, sessions, and workflows from test into production
- Provided production support on Unix of all Confidential workflows and associated Korn Shell scripts loading to Oracle and Teradata databases which includes approximately 1200 workflows daily with 9 million files monthly throughput
- Responsible for performance tuning and cleaning up historical data on the production server
Sr. Financial Data Warehouse Developer
Confidential, Morrisville, NC
Responsibilities:
- Created complex Confidential mappings, sessions, workflows and related Korn Shell scripts
- Performed an in-depth analysis of a major banking client’s environment to improve the performance
Consultant, Lisle, IL
Database/Teradata DeveloperResponsibilities:
- Created complex Confidential mappings, sessions, workflows and related Korn Shell scripts
- Performed an in-depth analysis of a major banking client’s environment to improve the performance on Confidential mapping run times based on their SLA expectations
- Provided comprehensive documentation on clients ETL environment with recommendations on performance improvement techniques
- Created internal training database, Confidential repository and star schema model for Logan Britton
Confidential, Raleigh, NC
Informatica Administrator
Responsibilities:
- Migrated mappings from development environment into production
- Provided production support for client
- Created mappings and associated sessions sourcing from flat files into Oracle
Confidential, Naperville, IL
Data warehouse / Informatica Administrator and Production Support
Responsibilities:
- Performed administrative tasks such as setup user security, folder architecture utilizing shared folders, maintained shared folder, and migrated folders into production
- Created mappings and configured workflows using Oracle sources and targets for finance department
- Production support for Informatica scheduled daily runs for financial systems
- Audited mappings and assisted client with performance tuning
Network Administrator/Support
Confidential
Responsibilities:
- Managed support tickets for eight Midwest offices and all VIP tickets
- Awarded “Consistently Exceeds Expectations” in 2001-2003 performance appraisals
- Management frequently requested my technical assistance on assignments across the US
- Lead several teams to successfully complete large scale installations, upgrades and provided technical support to ensure successful transitions to clients
Network Engineer/Administrator
Confidential, Comark, IL
Responsibilities:
- Installed and configured (local intranet using IIS, Business Objects, Oracle, Windows servers)
- Promoted to national implementation team within five months