Uploaded File
add photo
Anthony
anthonydoylebus@gmail.com
201-673-3111
Jacksonville, FL 32099
ETL Developer
25 years experience W2
0
Recommendations
Average rating
188
Profile views
Summary

  • Results oriented leader with a comprehensive technical background in Architecture and Development.
  • Certified Agile SAFe Practitioner with over 30 years of Information Technology experience, including data warehousing, application architecture and application development.
  • Major strength developing systems in a wide range of operating environments.
  • Solid understanding of enterprise and technical architecture.
  • Outstanding interpersonal skills with audiences from senior level management to end-users.
  • Experience with multiple industries, including financial services, health care, pharmaceutical, manufacturing and automotive.
  • Excellent leadership skills with experience managing teams up to 10 members.
  • Tools: Ab Initio, Tableau, Cognos 8

Experience
Ab Initio Developer
Healthcare
Dec 2016 - present
  • Overseeing the development of over 50 contractors onshore and off-shore from major agencies.
  • Pharmacy Systems has the responsibility to maintain the relationship between millions of customer’s pharmacies and their doctors, insurance companies as well as multiple agencies. The Department accounts for two-thirds of the revenue of Walgreens.
  • Oversee and maintain enhancements to Abinitio procedures which transfer data across a vast network which maintains Customer and physician relationships in a variety of systems from specialty, loyalty and health conditions.
  • Serving as a member of the Walgreens Architectural advisory broad as the ETL SME.
  • Leading the conversion of Abinitio from Abinitio 3.0 to 3.27.
  • Currently updating the departments Abinitio best practices document
Ab Initio ETL
Remove Skill
Ab Initio ETL Developer
Government
May 2015 - Jun 2016

Secret Clearance

Navy Standard Integrated Personnel System (NSIPS)

  • Worked extensively on metadata resolution all graphs within the entire repository.
  • Each table and file was defined. Duties were to investigate each unresolved relationship and fix them. Some elements required further definition within the EME repository. Many elements called for working with Ab initio engineers to resolved issues within the EME.
  • Using Ab initio developed many fact tables for the Navy personnel system. Many functional areas in the Navy called for maintaining forces be ready. These fact tables needed to reflect current force readiness the associated dimensions had to be maintained.
  • Extensive use of Ab initio component read tables with complex SQL statements.
  • Complex graphs compared incoming new raw data with matching existing data creating change datasets.
  • Developed Ab initio graphs populating type 2 dimension which were used my various the various fact tables. Created numerous Ab initio load graphs for each new table.
  • Coordinated Business Requirements and Technical requirements for developers in a SAFe Agile environment. Directly relayed business needs with technical staff via writing programming specifications which were derived from
  • Served on a team of ETL developers, testers, data architects, data modelers in an agile environment to create and maintain an enterprise data warehouse.
  • Executed back office and Front office updates using plan it along with extensive usage of PSETS and generic graphs.

Environment: Oracle, Ab Initio, shell scripting, MS-Office, XML, UNIX, SAFe Agile

Shell Scripts Scripting ETL Developer ETL Data Warehousing Data Modeling Data Architecture Business Requirements Agile Methodology Ab Initio SQL XML UNIX Oracle Metadata Technical Specifications
Remove Skill
ETL Developer Consultant
Information Technology
Mar 2015 - May 2015
  • Managed and executed Allstate's ETL system yearly update.
  • Received files from each state updated individually using Ab initio developed Korn shells.
  • This process required very closely monitoring the execution of the loading state.

Environment: Oracle, Ab Initio, shell scripting, MS-Office, MVS, COBOL, UNIX, Agile

Shell Scripts ETL Developer ETL Cobol Agile Methodology Ab Initio Oracle UNIX Scripting Korn Shell
Remove Skill
Lead Data Warehouse Developer Consultant
Information Technology
Oct 2013 - Jul 2014
  • Served in the capacity of technical leader on a very large project for a major Health care provider in North Carolina (BCBSNC).
  • Project overall objective to change the legacy systems of the entire Health care insurance provider.
  • Usage of state of the art Ab initio Components reading using read xml data using MQ series calls.
  • Continuous flows graphs updated various QUES the QUES were read and processes were triggered.
  • The graphs team was responsible for updated the appropriate tables.
  • These graphs were developed in an Ab initio object originated environment using various xml components.
  • Coordinated technical activities between onshore leadership and large offshore developers.

Environment: Oracle, Ab Initio, shell scripting, MS-Office, MQ-Series, XML, UNIX, Agile

Data Warehousing Agile Methodology Ab Initio Shell Scripts XML Oracle UNIX Scripting IBM Websphere MQ
Remove Skill
Data Warehouse Developer Consultant
Information Technology
Jun 2012 - Oct 2013
  • Talend open studio developer.
  • Developed process converting MS SQL tables to Oracle 9g.
  • Each table had an extracting Talend graph (process).
  • Each table had a transforming Talend graph.
  • Each table had a loading Talend graph.
  • Executed daily data warehouse updates, external loads etc.
  • Developed strategy to nightly load 138 various staging tables from 8 major banking systems.
  • Monitored daily executions and support production.

Environment: Oracle, MsSql, Talend, MS-Office, UNIX

Data Warehousing SQL Oracle Talend Studio UNIX
Remove Skill
ETL Developer Consultant
Information Technology
Apr 2011 - May 2012
  • Lead developer on system which tracked medical drug sells in the developed world.
  • Various data feeds came in through many channels and through a very complex process individual prescriptions were monitored from the manufacture to the consumer. Data matrixes were captured and tables updated allowing reporting on every stage of marketing.
  • These processes required Mainframe and UNIX systems. Mainframe systems were COBOL processing with heavy PROCs and JCL. The UNIX processes were processed utilizing Ab initio and Korn Shells.
  • Implemented changes to existing systems.
  • Prepared and delivered presentations to management regarding system architecture.

Environment: Oracle, Netezza, Ab Initio, Shell Scripting, MS-Office, MVS, COBOL, UNIX

Oracle ETL ETL Developer UNIX Shell Scripts Scripting Netezza Cobol Ab Initio System Architecture
Remove Skill
Ab initio Developer Consultant
Information Technology
Apr 2010 - Apr 2011
  • Developed and maintained advertising systems in a complex environment which utilized parallel execution systems.
  • Ab initio servers were configured to 1024 ways parallel which caused very heavy analysis.
  • Extensive use of various Ab initio components to take advantage of data spread over such a vast number of servers. Had to know how to join flows and be efficient with system resources. Know which type of lookup component to use for each situation. Used vector processing quite often to use internal memory effectively.
  • Exposed to Netezza Databases also.
  • Served as Netezza DBA each developer was required to become very proficient using Netezza databases.
  • Provided support to design teams, data architects, technical architect, business analysts, BI analysts as well as business leaders.

Environment: Oracle, Teradata, Netezza, Ab Initio, shell scripting, MS-Office, UNIX

Ab Initio Business Analysis DBA Teradata Oracle Netezza Shell Scripts Data Architecture UNIX Scripting
Remove Skill
AbInitio Architect
Healthcare
Sep 2009 - Mar 2010
  • Led the development of ETL solution sourcing an OLAP database from the Corporate Teradata OLTP database.
  • Lead developer on project to develop back office processing for an online Pharmacy.
  • Team developed graphs which accepted feeds from the Teradata database using Ab initio read components.
  • Processed using Ab initio transformation components and populating the Oracle data warehouse in place.
  • Each came from various departments via the Teradata tables and feed the appropriate downstream systems.
  • Developed Tableau reports and Dashboards assisting the Business intelligence experts with data issues.
  • Managed a team of 6 offshore developers.
  • Served as a member of the design team while working closely with the technical architect, business analysts, business and customer stakeholders to develop requirements.

Environment: Oracle, Teradata, Ab Initio, MVS, COBOL, shell scripting, MS-Office, UNIX

Ab Initio Teradata ETL Data Warehousing OLAP OLTP Oracle Scripting Shell Scripts Tableau Business Intelligence UNIX Database Design
Remove Skill
Senior Ab Initio Developer Consultant
Information Technology
Sep 2008 - Mar 2009
  • Developed customer reporting system. System objective was to track truckers' retail activity.
  • Served as Senior Ab initio developer directing other developers with software development.
  • Coordinated with Mainframe developers with system integration.
  • Evaluated and validated mapping and business processing rules prior to development.
  • Planned, scheduled and managed all development activities during the entire life cycle of the project.

Environment: DB2 UDB, Teradata, Ab Initio, MVS, COBOL, shell scripting, MS-Office, UNIX

Ab Initio Teradata DB2 DB2 LUW Shell Scripts Scripting UDB UNIX
Remove Skill
Production Support Analyst Consultant
Banking/Financial
Feb 2008 - Aug 2008
  • Managed and setup Teradata monitoring of production environment for data warehouse support group.
  • Worked closely with users to analyze existing processes to identify and implement enhancements. Types of utilities analyzed were Multiload, FastLoad and T-Pump.
  • Tracked enhancements from testing through production implementation. Projected savings of enhancements over the first year after implementation was estimated at $4.5 million dollars.

Environment: Teradata, MVS, COBOL, MS-Office

Teradata Data Warehousing Production Support
Remove Skill
Lead Ab Initio Developer Consultant
Information Technology
Jun 2006 - Jul 2007
  • Lead Ab initio Consultant developed system which tracked customer activity.
  • Created system for the development of Business Customers data warehouse.
  • Worked with the web development team to push warehouse data to interface directly with the customer base.
  • Served as the Administrative lead overseeing code development by the entire team.
  • Responsible for code and metadata promotion from development to Quality Assurance to Production.
  • Worked with the development of Ab initio Standards and Best Programming practices.
  • Reviewed detailed programming specifications prior to development.
  • Conducted code reviews with other developers and the Ab Initio administrative group.

Environment: Oracle, Ab Initio, shell scripting, MS-Office, UNIX

Ab Initio Oracle Shell Scripts Metadata Scripting UNIX Data Warehousing
Remove Skill
Lead Ab Initio Developer Consultant
Information Technology
Oct 2005 - Jun 2006
  • Team leader on the reinstatement project.
  • Repaired and rewrote Loan initialization process. Process created the ground floor processed for the loan origination process.
  • Acted as liaison between Ab initio standards group, project management, senior management, and data governance and user community. Tasks included reviewing programming specifications, conducting code reviews and mentoring members of the group.
  • Implemented enhancements and resolved defects in existing graphs to reduce run time.
  • Utilized Ab initio parallel processing and efficient memory usage to increase job efficiency and minimize run time of graphs.

Environment: Oracle, Ab Initio, shell scripting, autosys, MS-Office, UNIX

Ab Initio Oracle Shell Scripts Scripting Data Governance UNIX Project Management
Remove Skill
ETL - Ab Initio Developer
Insurance
Mar 2000 - Sep 2005
  • Designed and developed the architecture for data warehousing components: data quality, staging and aggregation, ETL, tool integration, and information and analytics delivery.
  • Provided technical expertise on data modeling, data warehousing and data integration.
  • Assisted Ab Initio development staff in development and beta testing of the Data Profiler.
  • Developed graph to populate common lookup files and deployed as a common component accessible to all developers.
  • Assisted architects and DBA’s with fine-tuning the warehouse by providing common key elements, which aided in partitioning and parallel processing.
  • Collaborated on warehouse model design with data architects using CA Erwin.

Environment: DB2 UDB, Control-M, IMS, Ab Initio, MVS, COBOL, PERL, shell scripting, MS-Office, UNIX

Ab Initio Data Modeling Data Warehousing DB2 Perl Erwin Data Modler ETL DB2 LUW Shell Scripts BMC Control-M Data Architecture Scripting Data Integration UNIX
Remove Skill
Project Manager/Programmer-Analyst Consultant
Information Technology
May 1997 - Jan 2000
  • Project leader for the Y2K conversion effort. Led a team of eight (8) programmer/analysts.
  • Team lead for maintenance of legacy mainframe COBOL programs for a revenue recovery system.
  • Identified problems presented by user community. Met with end-users to propose changes.
  • Coordinated movement of code changes to production cycle. Successfully converted $86M in assets of newly acquired bank to Bank of Americas portfolio using COBOL, VSAM, and OS/MVS.
  • Coordinated effort to identify potential problem code, formulate a conversion routine and move changes from development to testing to production.
  • Developed ETL routines for a consumer data warehouse designed with Bill InMon methods using Prism as the ETL tool. Coded COBOL routines to extract data from legacy files translating and applying business rules to clean the extracted data.
  • Coordinated loading of extracted files into an Oracle database.
  • Worked with Prism consultants to ensure proper design.

Environment: COBOL, MVS/TSO/JCL, VSAM, CICS, Oracle, Prism, shell scripting, MS-Office

Project Management Shell Scripts VSAM Scripting JCL ETL Data Warehousing Cobol CICS
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Computer Science
California State University at Long Beach 1973
U.S. Government Secret Clearance
Certifications
Certified Agile SAFe Practitioner with over 30 years of Information Technology experience
SAFe Practitioner Certificate
Skills
Scripting
2016
15
Shell Scripts
2016
15
UNIX
2016
14
Ab Initio
2021
13
Data Warehousing
2016
13
ETL
2021
11
Data Architecture
2016
7
Oracle
2016
7
Data Modeling
2016
6
DB2
2009
6
DB2 LUW
2009
6
BMC Control-M
2005
5
Data Integration
2005
5
Erwin Data Modler
2005
5
Perl
2005
5
Cobol
2015
3
Project Management
2006
3
Agile Methodology
2016
2
CICS
2000
2
ETL Developer
2016
2
JCL
2000
2
Metadata
2016
2
Netezza
2012
2
SQL
2016
2
Teradata
2011
2
VSAM
2000
2
Business Analysis
2011
1
Business Requirements
2016
1
Database Design
2010
1
DBA
2011
1
System Architecture
2012
1
Talend Studio
2013
1
Technical Specifications
2016
1
XML
2016
1
Application Development
0
1
Applications Architecture
0
1
Business Intelligence
2010
1
Cognos
0
1
Data Governance
2006
1
IBM Websphere MQ
2014
1
Korn Shell
2015
1
OLAP
2010
1
OLTP
2010
1
Production Support
2008
1
SQL Server
2012
1
Tableau
2010
1
UDB
2009
1