Experience

• 

  Labcorp

  May 1999 - Jun 2000

  Senior programmer analyst

  Analyzed requirements and recommended solutions to implement Seagate Info (Crystal Enterprise) and provide access to the MVS DB2 Datamart. Administered 150 users, debugged SQL, improved report efficiency, and tuned servers for optimum performance. Managed user licensing.

• 

  Midway airlines

  Jun 2000 - Sept 2001

  Oracle dba|application administrator

  Primary support person for Oracle Datamart, and Airmax Seat Control application on Oracle. Implemented Seagate Info (Crystal Enterprise) as a business intelligence solution for both Datamart and Airmax. Provided all desktop support for Oracle client installs and Database Administration.

• 

  Computer extension professionals, inc

  Feb 2002 - Jun 2002

  Senior bi specialist

  Designed and Developed Crystal Reports for RJR. I was offered an Annual renewal with a 20 percent increase to work as a Microstrategy Admin.

• 

  Bb&t

  Jul 2002 - Jan 2017

  Conducted Informatica code reviews of mappings and workflows to audit for compliance to standards, compare to mapping documents logic, and a source to target mapping. Functioned as the primary ETL contact for the Decathlon team and SAS Developer that supported the ETL team.• Audited and made recommendations for developer code reviews.• Performed Informatica development for commercial loan decathlon extract, replacing SAS code.• Made changes to SAS MF code to allow it to connect to the new Netezza platform, preventing code failures. Offered recommendations for distributed SAS code changes that eliminated Netezza over connection failures related to SAS.• Continued support of the Datafuse application. Mostrar menos Worked as the lead Informatica ETL Developer for coding, providing mapping documentation for offshore resources. Collaborated with onshore resources on integration with production scheduling. Performed as the primary SAS resource on the marketing database team.• Provided application administration for third-party Data Quality and householding applications. Managed the Data Quality environment with dev, test, and production windows application servers, including IIS FTP processes.Key Informatica Projects • POC project for Informatica. I Coded 80 percent of Informatica mappings to replace the SAS code for the Marketing Database.• Developed weekly process for CIF (Customer Information) in Informatica to automate the movement of data to the Datafuse windows application server (quality control application) so the process could be executed on a scheduled basis • Provided inputs to weekly branch assignments to customers using Datafuse functionality (quality control application) with Informatica controlling inputs and outputs. Integration of Datafuse (quality control application) with Informatica for the annual assignment project replaced mainframe processes. • Developed tables and Informatica mappings for tracking branch changes every week. Designed aggregates to improve the performance of MicroStrategy reports using Informatica processes. • Designed a quality control program in SAS that assisted with analyzing landed data's accuracy. Later, the SAS program that determined the accuracy of landed data was converted to Informatica. Designed a SAS program that analyzed the movement of ddl from test to production databases analyzing permission differences between the test and production databases and analyzing the accuracy of Datafuse Geocoding.• Created an MDM component (Classification entities) that supported the House Holding Key Database. Mostrar menos Designed specs, coded Informatica mappings, and served as the technical lead on Informatica development issues. Created mapping documents to support specs, tips, and tricks documentation, using Frontpage, to document issues discovered during development and application documentation for the Informatica toolset. • Recognized as the lead “SAS Warehouse Administrator” developer for the Marketing database that created custom SAS programs to support quality control efforts. • Served as the Power Exchange for Mainframe developer to create security standards document for Informatica mainframe communication infrastructure. Troubleshoot and test implementation issues.• Implemented a process in Informatica that generated time savings of five man-days a month. • Created Webfocus reports opening the Informatica Profiler statistics to our business clients.• Designed Informatica code for DRL DataMart that implemented the front-end fact data to the LOB.• Primary SAS distributed resources on the SDS team. Mostrar menos

  • ETL Developer II

    Jan 2015 - Jan 2017

  • Marketing Systems FTE

    Feb 2007 - Jan 2014

  • Shared Data Services FTE

    Jul 2002 - Feb 2007
• 

  Wells fargo

  Mar 2018 - Mar 2023

  Senior software engineer

  Deliver level three support for Anti Money Laundering Application (Cornerstone). Provide recommendations for standards, documentation of ETL processes that are currently in existence, and related pieces for a production application.• Examined Autosys scheduler to determine connections between Informatica processes, Unix scripts, and Autosys jobs. Developed Informatica processes including scheduling and batch scripts to execute jobs in an automated fashion. Peer-reviewed other developers’ code. Created Schedule changes for over 89 jobs to alter dependencies and remove obsolete Jobs. Documented Agile Progress with the Group-based Jira Kanban board. Confluence was used to document group processes.• Secure Code reviews and manage secure code requirements for maintenance releases.• Acquired proficiency in Excel Power Query to match and report on various flat files and HTML files, generated from Autosys and the Informatica repository. Mostrar menos

• 

  Teksystems

  Mar 2023 - now

  Software developer etl

  Contract With PNC Bank as an ETL Developer.