We provide IT Staff Augmentation Services!

Lead Etl Developer/etl Architect Resume

4.00/5 (Submit Your Rating)

New York City, NY

SUMMARY:

  • During 28 years in the Information Technology Industry I have accumulated extensive knowledge of a variety of data processing platforms (see "Skills Summary" section). My work history demonstrates the ability to work independently or lead groups to provide effective solutions. In addition to effective communication skills I can offer these core technical competencies.
  • Database Architecture - experience designing new database or maintaining existing databases. Experience Data Modeling using Erwin and Visio tools. Experience with large and small databases hosted on DB2, Oracle, IBM U2 and MS SQL. Extensive experience with Autosys and IBM Tivoli Workload Scheduler tools.
  • Datastage Development (ETL) - have worked with Datastage since its release in 1998. Over the years developed methodologies which enable jobs to be generated quickly with Best Practices. Having worked on many large scale processes and have methodologies to manage large data sets in Server and Parallel jobs.
  • Server Administration - Experience managing UNIX and Windows servers including O/S maintenance, process automation and security. Have extensive experience with AIX Volume manager, Disk Management, Sysback backups and hardware maintenance on the IBM pSeries servers. My experience with performance tuning has been proven with significant improvements (reduction) in I/O bandwidth and database TPS utilization.

TECHNICAL SKILLS:

  • Datastage Developer
  • Erwin Data Modeling
  • UNIX shell scripting
  • Awk Scripting
  • DataBASIC
  • UniBASIC
  • PICK Basic
  • SQL
  • HTML/XML
  • PERL
  • Databases
  • Skill Level
  • DB2
  • Oracle
  • Teradata
  • MS SQL Server
  • DB2/400
  • MS Access
  • PICK/Multivalue
  • Operating Systems
  • Skill Level
  • UNIX
  • AIX
  • Linux
  • Windows
  • HP-UX
  • AS400
  • VMS/Ultrix
  • Datastage Development and Database Architecture

EXPERIENCE:

Confidential, New York City, NY

Lead ETL Developer/ETL Architect

Responsibilities:

  • Versions used: IBM Websphere Datastage version 9.1.2 on Linux, Oracle 11.g, and MySQL 5.5
  • Design CMS (Center for Medicaid/Medicare Services) EDGE Server feeds with sequential files and XML. Feeds included response processing with updates to user tables for monitoring status and results of feed processing by CMS.
  • Managed Linux RHEL6 Operating System and MySQL Database to ensure reliable operations. Automated submissions and reporting processes with Unix scripts and SQL. Created file directory structure to manage the EDGE server data. Created ODBC connection to the MySQL database to extract data for submissions reconciliation and audits.
  • Impact analysis of ICD 10 Diagnosis code set conversion to the existing systems and remediate issues to ensure ongoing processing.
  • Prepared and managed releases for Datastage, Database and Unix deployments to production
  • Managed defects and coordinated work teams to resolve defects in timely fashion. When necessary resolved specifications issues and created Change Request if necessary to correct system specifications.
  • Planning and execution of Datastage 8.5 on HPUX Datastage 9.1 on Linux code migration and Re-hosting. Provided critical guidance to identify the issues impacting the Datastage and Unix processes involved in the migration.

Confidential, Parsippany, NJ

Project Manager/ETL Architect

Responsibilities:

  • IBM Websphere Datastage version 8.1 on zLinux and DB2.
  • Create project plan to manage workload, scope and deliverables.
  • Impact analysis of XML schema and mapping changes to estimate work effort and impact on delivery schedule.
  • Managed team of 14 offshore and 2 onsite developers in the specification, design and coding of the Source to ODS and ODS to Data mart ETL jobs for 10 subject areas. Managed project tasks to ensure timely completion of development. Designed common template jobs which ensured consistent code throughout the project simplifying maintenance. Managed the deployment of jobs and external components required for each release.
  • Managed defects and coordinated work teams to resolve defects in timely fashion. When necessary resolved specifications issues and created Change Request if necessary to correct system specifications.

Confidential, Fort Washington, PA

Senior ETL Architect & Developer

Responsibilities:

  • Versions used: IBM Websphere Datastage version 7.5, 8.5 & 8.7 on HP UX (UNIX), Oracle 10g.
  • Design ETL process to integrate data from 8 sources into an Enterprise ODS. Write specifications for ETL jobs to extract data from the source, create transaction set with common schema & load into the ODS (Operational Data Store). Source data was a mix of Oracle database, MS SQL database and flat files.
  • Coded and tested 5 of the source to ODS processes in 2 months with team of 5 developers under my management. This was accomplished by creating reusable design components and effectively managing the development tasks.
  • Impact analysis of schema and mapping changes and estimate work effort and delivery schedule.
  • Managed team of 2 offshore and 3 onsite developers in the specification, design and coding of the Source to ODS ETL jobs for 5 sources. Managed project tasks to ensure timely completion of the coding. Designed common template jobs which ensured consistent code throughout the project simplifying maintenance. Managed the releases tracking all jobs and external components required for each release.
  • Mentored the Developer staff on performance improvement and developing reusable code

Confidential, Berkley Heights, NJ

Consulting Senior ETL Architect & Developer

Responsibilities:

  • Versions used: IBM Websphere Datastage version 8.1 & 8.5 on Sun OS (UNIX), Oracle 10g & Autosys.
  • Design and oversee development of conversion process for entire claims system composed of 10 separate sub-systems. Source systems were AS400 and Oracle, target system was primarily Oracle. Utilized industry standard “ACORD XML Business Message Specification for P&C Insurance and Surety” for data interfaces were applicable.
  • Design Data model for Auto Policy ODS used for external feeds and Data Mart updates.
  • Design, code and implement Controls to manage Datastage jobs and runtime configurations.
  • Implement revision control policies and procedures for Datastage to ensure reliable maintenance and releases
  • Train new Datastage developer on designer,director and XML pack. Trained the new developer on XML syntax and parsing or building XML with Datastage. Built 3 vendor interfaces with XML in and sequential files out, and 1 database extract which output an XML SOAP transaction.

Confidential, Bloomfield, Connecticut

Consulting ETL Architect & Developer

Responsibilities:

  • Versions used: IBM Websphere Datastage version 8.1 UNIX
  • Redesigned entire payment system consolidating and streamlining 21 jobs in to 6 jobs. This resulted in significant improvement in runtimes and significant reduction in maintenance cost. Used high level data analysis to determine the redundancy in the system and reduced the number of jobs and stages necessary to perform the same work faster and more reliably. Also redesigned Sequences to reduce maintenance effort and improve reliability.
  • Implemented Datastage Revision control system for ETL Developer team to ensure accurate and timely releases.
  • Designed and coded source system loads for MDM (Master Data Management) system.
  • Implement, manage and support the IBM Tivoli Workload Scheduler for the development environment. Trained ETL and QA team on the use of the Workload Scheduler used to test the systems.
  • Managed team of 3 developers coordinating scope and delivery dates with the Project manager. Coordinate development effort to ensure all features are delivered on time.
  • Managed releases tracking all Datastage and external components (scripts, SQL,…) required for each release.
  • Mentored the Developer staff on performance improvement and complex job troubleshooting.

Confidential, Lake Buena Vista, Florida

Consulting ETL Designer & Developer

Responsibilities:

  • Versions used: Ascential/IBM Datastage version 7.5 UNIX, Teradata V2R6
  • Working for the Global Business Technology Strategy department I redesigned Datastage jobs to improve quality and improved performance by 600-900%. Design new Datastage jobs to transform source data and load into Datamart tables. Code jobs to design specification, perform unit testing and prepare UAT testing environment. Code routines and Sequence jobs to improve process flow and reliability. Identify locking contention issues, resolve with job design and database index modifications.
  • Upgraded 8 Oracle 9i databases to 10.2g - create project plan in MS Project, manage resources and coordinate User Acceptance Testing. Perform DBA tasks such as cleaning up Invalid Objects, code PL/SQL scripts to capture table stats in a separate table for later comparison after the upgrade.
  • Train developers on Datastage internals, hash file sizing, job processes & job record locks.
  • Provide DBA support to users, optimize queries, rebuild tables, monitor temp and free space. Monitor and analyze locking issues and resolve user process errors. Identify I/O bottlenecks and resolve with application and tablespace modifications.

Confidential, Hopewell, New Jersey

Consulting ETL Designer & Developer

Responsibilities:

  • Datastage versions used: Ascential/IBM Websphere Datastage version 7.5.x, Windows and version 8.1refresh
  • Create Data models for data marts and data warehouses from Business requirements. Complete ETL Design, coding & implementation working with offshore teams and in some cases alone. ETL development included server, sequence and parallel jobs with various sources & targets including: sequential, complex flat files, DB2 UDB, MS SQL Server, & Oracle. Worked on job rewrite using Datastage 8.1refresh running on Linux Server Cluster.
  • Worked on team to create Database validation data mart. This data mart compared and analyzed data from 4 separate databases containing 50 million plus records in each of 10 separate entities. Key data fields were analyzed in the ETL process providing attribute/column level error detail. Performed data profiling and quality analysis on the key and data fields. Define code cross-reference tables to encode/decode coded fields. Coded parallel job streams using MJC scripting language to execute entire database analysis in shortest possible runtimes.
  • Managed the development and testing effort of the 2 offshore team members.
  • Designed data model and ETL process for Website Utilization data warehouse. Fully automated ETL for weekly website utilization reporting. Lowest level of granularity is User-Date with data aggregated to 2 summary levels to allow for fast report response.
  • Designed, coded & implemented database migration involving 197 tables in 3 weeks. Created job generator to create job .DSX files. Then coded an ftp job generator which created Datastage jobs and .BAT scripts to ftp files to the target server. For the entire project more than 600 ready to run, jobs and scripts were created in 3 weeks.
  • Designed data model and ETL process for Risk Analytics Data warehouse. Designed data model for target tables to provide rapid response and flexibility. Application included 6 data feeds with approximately 120 million records. Coded jobs to process source data and produce report table load files aggregated and pre-filtered for rapid report response.

Confidential, Wilmington, DE

Consulting ETL Designer & Developer

Responsibilities:

  • Datastage versions used: Ascential/IBM Datastage version 7.5 UNIX
  • Design, code & implement ETL Solutions for data warehouse, data marts and application data feeds/loads using Ascential/IBM Datastage tool. Write Oracle SQL scripts to extract data from data sources and update control files. Modify & enhance existing Ascential/IBM Datastage ETL applications (jobs). Setup control-M jobs to automate Datastage jobs scheduling and error handling. Train staff on Dynamic file management sizing & maintenance methods to improve Datastage performance. Used CVS (Concurrent Versioning System) to manage the source code for Datastage jobs, supporting UNIX scripts and SQL scripts.

Confidential, Lafayette, CA

Data Warehouse Architect/Developer

Responsibilities:

  • Write ETL tool to extract the contents of the entire database of 50+ tables. The ETL tool extracted the tables based on parameters, from 3 separate databases located on separate servers. The data from all servers was combined into a single database with corporate level data. This could be classified as a Master Data Management (MDM) or an Operational Data Store (ODS) Database. Designed OLAP data structure, load processes & reports using MITS (OLAP tool) from the corporate database.

Confidential, Trenton, NJ

Consulting Ascential/IBM Datastage ETL Designer & Developer

Responsibilities:

  • Design, code & implement image & Ascential/IBM Datastage ETL jobs for the License, Titles, Violations & Registrations databases.
  • This Datastage system uses Ascential/IBM Datastage ETL tool to integrate tabular data from the OCR systems (multiple formats) with image data in Confidential format.
  • Build in house image database application & integrate with outside data sources to achieve effective process control & improve data quality.
  • Maintain existing Ascential/IBM Datastage ETL applications (jobs). Modify & enhance existing Ascential/IBM Datastage ETL applications (jobs).

Confidential, Wilmington, Delaware

Consulting Ascential/IBM Datastage ETL Developer/Analyst

Responsibilities:

  • Design code & implement Ascential/IBM Datastage ETL jobs to populate data warehouses and data marts using AS400, Sybase & MS SQL source databases with Oracle as the target database.
  • Debug & correct existing production jobs to enable full automation of the datastage jobs.
  • Created in-house training class for new developers on datastage Administrator, Manager, Director & designer. The 1 week class included several labs to develop Datastage Jobs focusing on the technologies used at Applied Card. Exam was given to ensure all students learned the required material.
  • Write & modify Perl scripts to start bulk loader on the Oracle server and return stats to the Datastage ETL server jobs to enable management of entire process from Datastage Director. Code Oracle SQL load commands to populate data warehouse.

Confidential, Claymont, DE

Consulting Project Manager/Analyst/Programmer

Responsibilities:

  • Manage project to migrate Universe database from Data General Aviion server to a Confidential server running the Linux operating system.
  • Built custom Kernel from Red Hat standard distribution.
  • Code validation reports used to ensure accuracy of the database after migration.

Confidential, Little Rock, Arkansas

IBM Datastage ETL Developer/DBA

Responsibilities:

  • Analysis, Design & code Ascential/IBM Datastage ETL jobs to populate several data warehouses & data marts. Data Modeling with Erwin for data marts & data warehouses.
  • Work with DBA designing schema & tables to enable data integration. Write & modify jobs to convert databases on MS SQL Server 7.
  • Install & Setup Ascential/IBM Datastage 4.1.1 on AIX 4.3 (UNIX) and Windows servers. Setup required ODBC connections to MS SQL Server 7, and CLI calls to DB2 version 7.1 for both Windows and UNIX servers.
  • Write data profiling and quality tests using Quality Manager Ascential/IBM Datastage XE suite.

Confidential, Denver, Colorado

Consulting Analyst/Programmer

Responsibilities:

  • Setup journalling for unidata database.
  • Consult on efficiency issues.
  • Write scripts on AIX to automate the journalling process.
  • Write custom code to bypass SB+ login to allow full security control at AIX level.

Confidential

IBM Datastage ETL Developer/Analyst

Responsibilities:

  • Working at major drug manufacturer with data warehouse programming team to code & implement about 25 data feeds for new data warehouse with Ascential/IBM Datastage ETL tool.
  • This was a short assignment to wrap up the existing project & integrate the Datastage ETL jobs into the production environment.
  • Improved the existing job design & custom routines/code to increase efficiency and accuracy. Write UNIX scripts to automate the Datastage jobs with error detection.
  • The scripts reported status and errors to the Unicenter Autosys Job Management server fully integrating Datastage with the production environment.
  • This data warehouse was built with sequential (ASCII) files that were loaded into an Oracle database. Audited & corrected SQL statements updating Oracle database.

We'd love your feedback!