Robert Webb

Sr. Technical Lead DataStage/QualityStage

***** ******** ***** **. ********, Texas 77406

Cell: 832-***-****

Email: ad31c3@r.postjobfree.com

Computer Program Proficiency

SOFTWARE:

Integration ETL Architect / Developer using Quality Stage Essentials v7.0, DataStage Enterprise Edition, DataStage Server v8.5, ETL, SQL, UNIDATA, UNIVERSE, REALITY PICK, PRIME INFO BASIC D3 UNIQUERY, Pick Systems, Microsoft Word, PowerPoint, Excel and Access

Certified on: AS400, RS6000, AIX, UNIX, SCO UNIX, LINUX, Windows NT, Windows 2000, Windows XP, Windows Vista

Knowledge of the following software packages/tools

Windows Word, Excel and Access

SSIS, SSAS, SSRS

SQL Server Management Studio

Mongod DB

PostgreSQL Database Engine on Windows and Mac OS

Using Oracle SQL Developer toot to connect to the different databases.

Toad for Oracle 13.1.1.5 (SQL software)

WinSCP

Putty

Super putty

Kanban board (Application used to track scrum projects)

My Technology

Agile Board

ARM (software)

application lifecycle management

Teradata 14.0/13.0

MySQL

Microsoft SQL Server Management Studio

VirtualBox and VMware on Windows and Linux Servers

Infosphere DataStage/Quality Stage version 11.7

Hadoop file system platform working with DataStage 11.7

Windows PowerShell Scripting

Windows, AIX, Linux, ubuntu, FreeBSD Unix Operating Systems

INTERPERSONAL SKILLS:

Install, configure, diagnose, and resolve technical Windows PC problems

Working knowledge of information systems industry terms and concepts

Flexible innovative, multi-talented and willing to learn

Excellent written, verbal/Non-Verbal communications skills

Team player with global vision

Excellent Listening and negotiation skills

Powerful customer relations skills

Great Problem-Solving and Decision-making skills

Self-motivated, with strong ambitions for the future

Leader and manager with strong human resource skills

Strong managerial skills; planning, prioritizing, and organizing.

Strong analytical skills; quantitative and financial

Experience

TCS – New York Life DataStage 11.7 Production Support Analyst – 03/01/23 – Current

Working remotely as a DataStage 11.7 production application suppor.with New York Life. Analyzing issues for failed DataStage jobs.

CA WA Workstation process scheduler – Monitoring execution and scheduling of production jobs as required by applications.

Unix OS – Using different UNIX commands to copy, move, gzip or gunzip Unix data files.

Service Management – Using to monitor incidents of process failures or changes to DataStage production processes.

TCS – Bank of America DataStage 11.7 Production Support Analyst – 08/01/22 – 12/22/22

Working remotely as an DataStage 11.7 production application Job monitoring analyst with Bank of America. Resolving issues for failed DataStage jobs.

Monitor and support over 500 workflows and 2500+ jobs (Autosys, DataStage) in Non-Production environments for testing.

Autosys – Monitoring executing and scheduling Autosys jobs as required by applications Created AutoSys job reports using different criteria.

Unix OS – Using different UNIX commands to copy, move, gzip or gunzip unix data files

Bank of America Dashboard – to monitor important daily processes

Bank of America WebSphere – used for monitoring Kafka servers and Kafka services.

B2Bi – BA Clear system service – used to monitoring/checking successful/unsuccessful transmission of critical data files/data records.

Jira – Used Jira for updating stories/tasks regularly as the team followed strict agile methodologies.

Monitoring production jobs using Autosys 11.3 job scheduler, DataStage 11.7, Director, and DataStage monitoring tools.

DataInc – Bank of America DataStage Production Support Analyst – 11/1/2021 –04/28/22.

Working remotely as an DataStage 11.7 production application Job monitoring analyst with Bank of America

Monitoring production jobs using Autosys 11.3 job scheduler, DataStage Director, and DataStage monitoring tools.

Using Toad for Oracle 13.1 SQL to verify current loading of production data within SQL server tables

Using application lifecycle management tools for assignment of projects.

Hindustan Computers Limited (HCL) – DataStage Production Support Analyst – 11/23/2020 – 10/22/21

Working remotely as an DataStage production control and Job monitoring analyst

Monitoring production jobs using Autosys job scheduler, DataStage Director, and DataStage monitoring tools.

Diagnosing and fixing all DataStage job abort and job crashing issues.

Using Microsoft SQL Server Management Studio to verify current loading of production data within SQL server tables.

Modifying/Writing scripts using Microsoft PowerShell.

Citadel Federal Solutions LLC ETL DataStage/QualityStage – 03/18/2019 – 10/23/2020

Working remotely as DataStage Developer designing high level Infosphere Datastage parallel processes using version 11.5

Creating Infosphere Datastage jobs to read data files from listed multiple data resources (.CSV, .TXT, Complex flat files, Oracle, DB2 Mainframe systems)

Creating Datastage parallel processes to extract EBCDIC data from mainframe systems to convert form EBCDIC to ASCII format.

Worked with business subject matters experts to analyze various known issues, identifying new issues and recommending solutions in the discovery phase of the project.

Analyzed and consolidated all the issues and recommendations in the second phase of the project to present a summary report to the project management and executive committees.

Created DataStage/Python script process flow diagrams to document the current state and future state of business processes for financial programs.

Extracted and analyzed system requirements from stake holders for new software releases and system patches.

Maintained and managed systems requirements documents such as use cases.

Prepared and delivered presentations highlighting existing issues and proposed solutions as well as newly implemented software functionality.

Developed business process flows and data dictionary for ETL development team.

Design and Development of ETL methodology for supporting Data Migration, data transformations and processing in a corporate wide ETL solution using Teradata TD 14.0

Developing and maintaining UNIX scripts within AIX UNIX operating systems.

Using SQL Server to verify data results within DB2 database tables.

Worked with other team members, including DBA’s, ETL developers, technical architects QA, business analyst and project managers on specific tasks needing developing using python scripting language.

Hewlett Packard Enterprise BI/ETL Developer – Spring Texas 09/24/2018 – 03/08/2019

Working onsite and part time remotely, working for the Personal Systems Quality (PSQ) team developing ETL/SSIS packages.

Working with Microsoft SQL Server.

Focusing primarily on providing field event information to the PSQ organization for analysis in managing early-life and overall product quality.

Hands on experience in Azure Development, worked on Azure web application, App services, Azure storage, Azure SQL Database

Gather requirements from the business and created the solution requirements deliverable document.

Partnered with the project business team, vendor project subject matter experts and ETL teams to define and document project business goals, business processes and practices as input to project scope.

Worked closely with data governance team to ensure data quality and integrity of the oracle database.

Coordinated activities across the project among the various teams to translate business requirements into solution requirements.

Worked with project business leads to identify, document and mange the scope related change requests.

Responsible for maintaining database functions including collecting information, analyzing statistics, granting rights for database objects, transferring databases, creating and managing partitions, and managing user accounts within Teradata TD 13.0

Involvement in Designing Azure Resource Manager Template and in designing custom build steps using PowerShell.

Working independently supporting the existing ETL infrastructure, designing, extracting, transforming, and loading ETL components on a daily basis.

Responsible for developing, testing, implementing, and maintaining windows server systems from moderate to large size and complexity including audits and troubleshooting and improving system and database performance.

Developing SQL queries, using Microsoft SQL Server Management Studio.

Developing system data backup and production processing scripts using power shell script development tool.

Responsible for writing technical documentation for SSIS ETL packages currently functioning on the data warehouse.

Working with python involving the development of workflows triggered by events from other systems. Developed processing, archiving, and recovery python scripts to be used by other teams within the company.

Information Business Machines (IBM) – Boston Massachusetts (Remote) 01/2018 – 09/14/2018

Working remotely as technical project lead. Designing high level Infosphere Datastage processes on version 11.5.

Working with offshore ETL developers team located in India developing and monitoring successful ETL projects. Note: The project sessions usually start between 3:00am and 4:00am CST. Which is 1:30pm to 2:30pm in India time.

Creating Infosphere Datastage jobs to read files from multiple applications using complex flat files and sequential file stages.

Using SQL Server to verify data results within DB2 database tables.

Developing and maintaining UNIX scripts within AIX UNIX operating system.

Responsible for communicating with offshore team on needed software changes/updates

Developing ETL DataStage jobs that read/write data from and to Hadoop File System

Responsible for designing, developing, testing, and implementing ETL DataStage solutions

Responsible for extracting, transforming and loading data from different type of sources into the data warehouse.

Responsible for writing technical documentation for ETL DataStage Jobs.

United Services Automobile Association (USAA) – San Antonio TX 8/08/2016 – 12/30/2017

Technical Project Lead/Senior ETL DataStage Developer

Responsible for the technical direction of company projects. Analyze and translate company needs into high level technical solutions. Review and approve technical estimates.

Responsible for delegating different project task to competent team members and developers.

Responsible for reviewing timelines and providing input to stakeholders and upper management, regarding details and status of projects.

Responsible for informing project managers and upper management of needed resources to insure success of company projects.

Responsible for leading technical team, insuring that approved architectural software designs, data modeling, ETL processing jobs are met.

Responsible for designing, developing, testing, supporting and implementing technical solutions for the data warehouse using SQL developer and ETL DataStage, and SSIS tools.

Experience working with PostgreSQL database engine

Responsible for extracting, transforming and loading different combinations of data using the developed DataStage jobs and SSIS ETL packages for the data warehouse.

Responsible for delivering fact and dimension tables for the Data Warehouse.

Working with QA team, ensuring software defects are resolved, and the proper creation of software testing cases.

Developing ETL DataStage jobs to read/writing data from and to Hadoop File System

Developing ETL jobs within the Netezza environment using standard design methodologies. Also using Netezza SQL to manage ETL framework used by the company.

Using set processing techniques to apply company business rules to groups of data within large tables on company databases.

Work with architect to decide how projects will be implemented and executed within current company systems.

Decide what components (new or customized) that will get used from existing infrastructure.

Responsible for communicating with offshore developer team on needed software changes/updates. Offshore time located in India…

American International Group (AIG) - Houston Texas 10/20/2014 – 03/18/2016

ETL DataStage/QualityStage and SQL Server Developer

Working with Oracle, MySQL and PostgreSQL database Engine.

Working within an agile technically challenging work environment. Using DataStage/QualityStage 9.1 to extract, transfer and load data from Oracle database tables.

Experience creating complex SSIS and Infosphere DataStage data extraction Transfer and Load jobs.

Experience creating parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.

Preforming Data Modeling procedures

Using Rapid SQL 8.0 to verify data results within Oracle database tables.

Designing high level Infosphere DataStage processes.

Developed Infosphere DataStage jobs to read files from multiple applications using complex flat files and sequential file stages.

Developed SSIS and Infosphere DataStage jobs for unit testing

Developed SSIS and Infosphere DataStage jobs for loading data into Oracle, DB2 and Terra Data tables using Oracle connector stages.

Analyzed defects within SSIS and Infosphere DataStage application jobs and applied fixes to SSIS and Infosphere DataStage jobs and Sequences

Create Oracle code, store procedures, views, triggers and functions with Oracle database environment.

Developed UNIX scripts within AIX UNIX operating system.

Supporting DBA’s in business requirement, code reviews and documentation.

Support user acceptance testing, job performance and optimization.

Support implementation of jobs and deployment to the production environment.

Setup initial testing environment.

Perform SSIS and Infosphere DataStage job fixes.

Perform peer-to-peer code reviews.

Monitor Infosphere DataStage production jobs and perform urgent changes when necessary.

Worked independently and with other team members on daily data projects

Information Business Machines (IBM) – Boston Massachusetts 05/13/2012 – 09/09/2014

ETL DataStage/QualityStage and SQL Server Developer.

Working remotely, within a fast pace technically challenging environment using SQL Server and Infosphere DataStage/QualityStage 9.1 to extracting, transfer and loading data from DB2 database tables.

Ability to create Infosphere DataStage data extraction jobs.

Ability to create Infosphere QualityStage data matching jobs.

Preforming Data Modeling procedures

Using Rapid SQL 8.0 to verify data results within DB2 database tables.

Designing high level Infosphere DataStage and Infosphere QualiytStage processes.

Developed Infosphere DataStage jobs to read files from multiple applications.

Developed Infosphere DataStage jobs for unit testing

Developed Infosphere DataStage jobs for loading data into DB2 tables using DB2 connector stages.

Analyzed defects within Infosphere DataStage application jobs and applied fixes to the Infosphere DataStage jobs and Sequences

Create DB2 code, store procedures, view, triggers and functions with DB2 database environment.

Developed UNIX scripts within AIX UNIX operating system.

Supporting DBA’s in business requirement, code reviews and documentation.

Support user acceptance testing, job performance and optimization.

Support implementation of jobs and deployment to the production environment.

Setup initial testing environment.

Perform Infosphere DataStage and Infosphere DataStage job fixes.

Perform peer-to-peer code reviews.

Monitor Infosphere DataStage/QualityStage production jobs and perform urgent changes when necessary.

Worked independently on daily and weekend data transfer and data validation projects

Assisted in installation, managing and performance tuning of Netezza databases and other records.

Performed backups and recovery functions of Netezza databases.

Provided technical assistance for efficient performance and security functions of Netezza database.

Ability to develop Android application using IBM mobile data for Black Barry and Samsung mobile devices.

Food Services of America (FSA) – Scottsdale Arizona 05/21/2011 – 04/27/2012

Lead ETL Infosphere DataStage Developer /SQL Server Developer

Work remotely using Infosphere DataStage 8.5 and SQL Server 8.0

Created Infosphere DataStage jobs to extract date from legacy system files.

Developed Infosphere DataStage jobs to read files from multiple applications using flat and sequential files

Developed SQL queries to reconciliation of matching data record counts.

Analyzed defects within Infosphere DataStage application jobs and applied fixes within job Infosphere DataStage jobs and Sequences.

Created SQL data staging tables and loaded extracted data into SQL Server 2008 data warehouse.

Responsible for monitoring Infosphere DataStage production jobs and restarting production jobs.

Monitor data warehouse production processes and restarting any aborted processes due to lost network communications with the production server.

GC Services – Houston Texas 02/15/2010 – 04/01/2011.

DataStage Administrator/Lead DataStage Developer

Using DataStage Server 7.5.3 to extract data from the universe multi value files and load into Microsoft SQL Server data warehouse.

Developing database tables with PostgreSQL database Engine

Design advanced SQL queries, stored procedures, triggers, scripts maintain, modify, and optimize the SQL store procedures for SQL server databases. Responsibilities include - mentoring other data processing staff on the use and functionality of DataStage. Creating source to target data mapping for all Pick/universe data files. Developing DataStage jobs to handle the loading of critical data within the SQL database tables. Scheduling DataStage production ETL production jobs. Monitoring all DataStage production job processes and making critical adjustments where need.

Responsible for supporting Pick Universe legacy systems, within a AIX Unix environment Making Modifications, test, debug and document programs on large, complex projects using the Pick database and programming using Pick Universe to current system software.

Tyler Technologies – Plano Texas 03/2007 – 2/10/2010

Programmer Analyst / SQL Developer

Responsible for supporting Pick Universe legacy systems, within a AIX Unix environment Making Modifications, test, debug and document programs on large, complex projects using the Pick database and programming using Pick Universe to current system software.

Revise and update programs and documentation, developing specifications, developing new system modules.

Developing Data conversion modules for data transfer of legacy system data files.

Exporting data from the Pick Universe data files, determining data requirements needed to be loaded into SQL data base tables.

Design advanced SQL queries, stored procedures, triggers, scripts maintain, modify, and optimize the SQL store procedures for SQL server databases.

Using QuailityStage as a data quality tool to qualify and cleans the universe data

Using DataStage to extract data from the universe multi value files and load into DB2 and SQL data warehouse.

Collaborate with applications developers on data modeling and system diagrams.

Manage database performance, capacity, replication, backup and security.

Work with external entities of the company to transfer data. Assist business analysts and end-users with reporting needs

Involved in requirements gathering and source data analysis and identified

business rules for data migration and for developing data warehouse data marts. Involved in identifying the data inputs from various source systems depending upon the business requirement. Created source to target mapping documents from staging area to Data Warehouse and from Data Warehouse to various Data Marts. Involved in low-level design and developed various jobs and performed data loads and transformations using different stages of DataStage and pre-built routines, functions and macros.

Based on business requirements, design, develop and maintenance of applications using Visual C#. and ASP.Net with Visual Studio 2005, SSIS, and SQL Reporting Services.

Ascential Software/IBM – Westborough, MA 07/2003 – 03/2007

Software Consultant / ETL Developer

Responsible for executing and completing development of DataStage Server 7.5 and QualityStage 7.0 jobs. Including gathering requirements, analyzing, designing, testing, implementing ETL and Data Quality processes.

Worked as part of the development team responsible for making enhancements and supporting ETL jobs within the Data Warehouse environment

Skillfully utilized metadata and data quality processes and procedures

Interact with Management to better understand business, and system challenges to develop, diagnose, and modify ETL jobs related to Data Warehouse integration issues.

Managed ETL DataStage and QualityStage integration projects as assigned to be on time and within allocated budget.

Provided guidance and transfer knowledge on job requirements to other ETL DataStage and QualityStage developers

Provided Administrative support on AIX Unix system for DataStage and QualityStage production jobs. Provided installation and upgrade support of AIX Unix systems. This would include administrative procedures of creating new directories, new mount drives, copying, uncompressing, untar of system and application files. Performance tuning of unix system and newly installed applications. Provided documentation of all upgrades, installations, performance tuning, and production jobs executed on AIX system.

Developed ETL application at RBC in Toronto Canada, using XML product tools to migrate informatica data to DataStage jobs.

Education

BS degree: Bowling green State University - Huron, OH

Major: Management Information Systems (MIS)

IBM Certification in ETL DataStage Data Integration Development.

Contact this candidate