SUMMARY:

• Lead effort to convert a 2 terabyte data warehouse from Sybase/Oracle to Teradata
• Lead effort to upgrade Informatica from version 5 to version 7
• Lead effort to improve performance of Informatica code, reduced daily cycle by 50%
• Lead effort to transition daily cycle monitoring and support from development team to an operations team

TECHNICAL SKILLS:

• Informatica
• MicroStrategy
• Erwin
• ModelMart
• SQL
• Dimensional Modeling
• Yantra
• MQSeries
• XML
• RapidSQL
• BTEQ
• Sybase
• Oracle
• Teradata
• MS SQL Server
• SQL Anywhere
• PowerBuilder
• SAS
• MS Visio
• Cobol
• Windows
• HP - UX
• Solaris
• AIX

PROFESSIONAL EXPERIENCE:

ETL Developer

Confidential, Cumming, GA

Responsibilities:

Lead developer. Mentored other developers. Enforced standards and best practices. Constructed ETL code to parse the weblogs. Completed data analysis to ensure dimensions were complete and consistent. Executed daily data load. Tracked and reported defect status on a daily basis.

Worked with third party vendors to receive their data. Designed/constructed code to load third party data into stage. Completed data analysis to ensure integration of third party data with ATC data. Designed/constructed code to integrate third party data with ATC’s car data.

Worked with third party vendor on what data ATC needed to be to apply specials to dealer inventories. Designed/constructed code to receive and load the third party data into stage. Created code to capture deltas from today’s data. Constructed code to match specials with dealers. Constructed code to integrate dealer special data into consumer site for display on web site. Incoming data from third party vendor was XML files.

Spotlights - Worked with dealer site team to design/construct an automated process that duplicated their manual process so that dealers did not have to manually apply/swap inventory on spotlights ads. The process uses configuration data to drive the process and allows dealers to create rules for applying/swapping spotlights. Dealer inventory change messages were generated, wrapped in SOAP and loaded on the data bus to be delivered to the corporate email system for distribution.

Have supplied data to many internal and external applications. Some feeds required encryption before delivery. Delivery methods included FTP, SFTP, and shared mount points.

Constructed code that loaded data from PeopleSoft and Hyperion into Oracle Identity Manager staging area. Received encrypted data and decrypted before processing.

Collected business requirements. Wrote corresponding technical requirements. Co-created data flow and data model designs. Designed and constructed code to send HR personnel data to external performance review vendor. Data was required to be encrypted and delivered by SFTP.

Performed data analysis on 5 Business Units and a third party vendor’s data to ensure data integrity and completeness. Created data flow and data model designs. Design/constructed ETL to process Business Unit files. Created delta files to be delivered to third party vendor. Designed/constructed ETL code to receive data appends for delta files from Polk to determine car dealer matches across Business Units and load type 2 tables of supporting data.

20% production support allocation. Perform data analysis to identify issues. Perform code analysis to identify the correct code stream on which to perform root cause analysis. Design/construct ETL code fixes to correct the issue. Perform QA on other support member’s code changes. Scheduled emergency releases for dealer impacting issues. Worked with internal application support and development teams to identify issues within their code.

ETL Architect

Confidential - Atlanta, GA

Responsibilities:

Developed ETL code to load data from Oracle source to Oracle staging area. Created ETL code to load the data from Oracle to Teradata. Informatica was used to create flat files and then Mload/Tpump scripts were created to load the data from the flat files to Teradata. Coding was done to reduce the cycle time so more cycles could be completed daily. On average 2 cycles could be completed before the change and about 38 cycles could run daily after the change. Analyzed the Informatica Repository found lots of unused objects that should be removed from the repository. Analyzed data issues to determine if they were source system issues or ETL load issues. Mentored junior ETL developers in the use of Informatica and BTEQ.

Application Architect

Confidential - Atlanta, GA

Responsibilities:

Designed and developed ETL code for a sync engine that sends data from the legacy billing and customer service system to the new billing and customer service system. Analyzed data issues and recommend methods to get the data into the new systems. Lead weekly calls with the business to discuss records that were falling out of either the sync engine or the target system load. Managed and cleared fallout on a daily basis. Technical oversight of on-shore and off-shore development. Resource planning for major releases.

Senior ETL Developer

Confidential - Atlanta, GA

Responsibilities:

Designed and developed the ETL code for the Federal Vaccine Data Warehouse. Updated the Development Standards. Updated the Process Control scripts that the team had in place so that they were reusable by every project without having to copy the scripts for each project. Help gather the requirements and recommend what data each source system should send the Warehouse and in what format.

Technical Team Lead - ETL

Confidential - Atlanta, GA

Responsibilities:

Lead a team of employee, contractor and off-shore resources that perform ETL design and development task. Responsible for all ETL work. Complete resource assignments. Approve weekly Clarity Timesheets. Track and Manage production issues until resolved. Review all ETL designs. Perform Code review on all ETL code. Reduced the cycle run time by 4 hours. Manage the Informatica Upgrade project. Create and enforce Informatica Development Standards. Create and enforce ETL Development Standards. Enforce Scripting Development Standards. Enforce PL/SQL Development Standards. Create and maintain the ETL trouble ticket process. Member of the Production Support rotation team. Create and maintain time-off schedule for ETL team. Responsible for reviewing and recommending new tools. Work with the Internal Audit Team to verify that the ETL team is compliant.

Data Warehouse Technical Architect Team Lead

Confidential, Atlanta, GA

Responsibilities:

Responsible for entire data warehouse estimation process. Responsible for demand forecasts. Responsible for employee timesheets. Responsible for contract extensions and negotiations. Responsible for all designs, data models, and data dictionaries that are produced by the architecture team. Responsible for accepting requirements from the analyst group -- are they complete and provide enough information to create a quality design. Responsible for code review for each project. Responsible for standards, procedures and processes for the entire development life cycle of a project. Responsible for review of new software and software versions. Also responsible for incorporating the new features into our standards and processes. Responsible for running hardware and software upgrades. Responsible for making sure that the existing hardware and software supports future needs. With the majority of our development team being offshore I have gone to India to perform knowledge transfer and perform an assessment on each team member to determine if they were capable of performing the job. One of my roles is also defect management, I make sure that what was labeled a defect was really a defect and scheduled the defect into future releases.

Data Warehouse Lead Architect

Confidential, Atlanta, GA

Responsibilities:

Responsible for estimating ETL portion of all projects. Establish standards and procedures for data model, Informatica, MicroStrategy and stored procedure development. Perform impact analysis of source system changes. Plan and execute hardware, database platform, Informatica and MicroStrategy upgrades. Maintain peer review schedule, to ensure all peer reviews occur. Coordinate offshore projects with an India development center. On-call for production support 24X7X365. Ensure that projects are on time. Determine firewall hole needs and submit firewall hole requests. Handle escalations. C-Level executive contact point for Production Outage resolution. Created a Production Support Stabilization team to manage over 1300 processes. Reduced cycle time by 65%, decreased job failures by 46% and created processes to predict job completion time. Performed the “go-to” developer role each time a project was in jeopardy.

Data Warehouse Application Architect

Confidential, Atlanta, GA

Responsibilities:

Enforce standards and procedures for data model, Informatica, and stored procedure development. Perform peer reviews for design and code. On-call for production support 24X7X365. Perform Developer role to ensure projects meet deadlines. Test firewall holes once opened. Perform end user support.

Data Warehouse Developer

Confidential, Atlanta, GA

Responsibilities:

Develop architecture for Enterprise Data Warehouse and Data Marts using Erwin/Model Mart. Develop Informatica mappings to move data from Source systems and populate the Enterprise Data Warehouse. Develop Informatica mappings to move data from Enterprise Data Warehouse to Data Marts. Create data feeds from Enterprise Data Warehouse and Data Marts. Informatica mappings include Sources and Targets of following types: Sybase, Oracle, XML, and flat files. Write documentation to support the mappings and the data feeds. Write Korne Shell scripts to move flat files to loading/pickup area via ftp, secure FTP, and Secure Copy. Architect and create reports using MicroStrategy. Create Templates for Data Warehouse Documentation. Train new developers in Informatica, ERWIN, and Star Methodology. Create project estimates based upon the Confidential Estimate Model. Provide production support on an as needed basis. Provide support and backup for other team members. Train power users and managers so they understand the data they are reporting.