PROFESSIONAL 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 50 members.

TECHNICAL SUMMARY:

Corporate infrastructure: Technical Architecture Definition; Architecture & Standards Definition; IT Governance

Distributed systems: Distributed Applications Design & Development; Application & Systems Integration

Business continuity: Disaster Recovery Planning

Hardware: Sun, HP, IBM, DELL, COMPAQ, IBM 390/370/360, ZOS, CRAY, CDC6400

Operating systems: UNIX, Solaris, Linux, Windows Vista/XP, MVS/IMS, IBM/AIX, IBM/MVS

Languages: Ab Initio, Talend, SQL, Perl, JAVA, VB, COBOL, CICS, JCL/TSO/VTAM, Shell, Korn Shell, Tableau, PL/SQL

Databases: MS SQL Server, Oracle 11g, Teradata, Netezza, DB2 UDB, MYSQL, IMS/DB, Access

Application software: Control-M, MS Office/Project/Visio, CA Erwin

Data warehouse tools: Ab Initio, Talend, SSIS, Prism, EME, Co Operating System 2.15, 3.1

SDLC methodologies: SAFe Agile, Agile RTC, Waterfall

BI tools: Tableau, COGNOS 8

Document management: Microsoft SharePoint

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Developing jobs using Talend.
• Jobs which support a wide variety data feeding the Datawarehouse.
• Created over 100 jobs which extract data from incoming data feeds into staging tables
• MsSql database sources
• Oracle database sources
• Created jobs which transforming for the presentation layer and presenting for the user community.

Confidential

Developer

Responsibilities:

• 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 documents.

Confidential

Abinitio ETL Developer

Responsibilities:

• 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 Business Requirements.
• 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

Confidential, Northbrook, IL

Abinitio ETL Developer

Responsibilities:

• 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

Confidential, Durham, NC

Abinitio ETL Developer

Responsibilities:

• 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

Confidential, Jacksonville, FL

Data Warehouse Developer Consultant

Responsibilities:

• 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

Confidential, Collegeville, PA

Abinitio ETL Developer

Responsibilities:

• 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

Confidential, Sterling, VA

Abinitio ETL Developer Consultant

Responsibilities:

• 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

Confidential, Franklin Lakes, NJ

Abinitio ETL Developer

Responsibilities:

• 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

Confidential, Omaha, NE

Abinitio ETL Developer

Responsibilities:

• 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

Confidential, Jacksonville, FL

Production Support Analyst Consultant

Responsibilities:

• 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

Confidential, Dallas, TX

Abinitio ETL Developer

Responsibilities:

• 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

Confidential, Herndon, VA

Abinitio ETL Developer

Responsibilities:

• 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

Confidential, Jacksonville, FL

Abinitio ETL Developer

Responsibilities:

• 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.
• Developed and maintained system programs; developed codes repository maintenance series of programs.

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

Confidential, Jacksonville, FL

Project Manager/Programmer-Analyst Consultant

Responsibilities:

• 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