Data Stage Developer
Resume:
Thomas McNicol
******.**********@*****.***
Elgin, IL 60123
SUMMARY
DataStage Developer with over 20 years hands on experience in complex software design, coding, testing, and analysis. Expertise includes implementation of Relational Database and Data Warehousing Systems using ETL tools such as IBM WebSphere DataStage 7.5/8.5/8.7/9.1,11.3 and PL/SQL. Well-versed in all areas of SDLC, having partnered closely with Project Managers and Analysts to understand the business requirements and develop the most efficient project solution. Mr. McNicol has worked with extensively with Enterprise Edition and has 3 years of experience with Debugging UNIX Scripting and Teradata. I have been involved with several integration efforts mainly upgrading platforms and changing code base from older languages to newer.
TECHNICAL SKILLS
• Autosys/Tidal scheduling tools.
• COBOL
• Cognos
• DataStage 11.3/9.1/8.7/8.5/8.1/7.5.2
• Eztrieve plus
• Informix
• JAVA
• MS tools including MS Access
• Adabas/Natural
• Oracle 12,11,10g, 9i/ 8i
• PL/SQL
• SDLC
• SQL Navigator/Toad/Data Studio/AQT/AginityNeteeza Workbench
• SQL Server 2005/ 2000
• Oracle 12.g Cloud solution.
• SQL*plus
• Teradata
• Netezza
• DB2
• Informix
• Siebel
• Sqlserver
• UNIX/LINUX
• Windows NT 4.0/ XP/ 2000/ 2003 Server
• Agile project methodology
• InfoSphere versions ServerEdition 3.5, Parallel 7.5 thru 11.3
Education
Chicago city college associate’s degree, 1973
PROFESSIONAL EXPERIENCE
TCS/Bank of America Charlotte, NC Aug 2015 to May 2019
Client Bank of America- Merril Lynch
Hands on development role using Infosphere tools, Datastage and Fast track in all phases of Agile development
• Convert and integrate SqlServer reporting system into Oracle and upgrade from monthly snap shot into historical processing using Datastage designs and sequencers using Teradata as a source and reference platform.
• Expand referral souces to capture Digital, Direct Route and Teller commercial vehicle, retirement services types and pass to fulfillment engine
• Convert FTP to SFTP using UNIX scripts to comply with Bank requirements.
• Integrate various small business verticals into referral reporting system.
Perficient inc July 2011 to July 2015
Client: In house project to quickly deploy and implement health care package. Jan 01 2015 to July 2015.
• Package asset healthcare code accelerator for deployment in HCPDM data warehouse. Test and package all subject areas for quick standup.
• Develop Charge master assets for healthcare payments in healthcare data warehouse as an accelerator project for faster and easier deployment
• Upgrade package from Datastage 9.1 to 11.3 by listing production modules, export into a .dsx package and import into 11.3 project. These were compiled and tested as a regression testing story.
• Designing and Developing Data Ingestion with Datastage 11.3 for integrating data from multiple source systems
• Created several PL/SQL scripts for data ingestion
Client: Baylor Scott and White hospital group, Dallas Texax – May 01 2015 to July 30 2015
• Develop Charge master assets for healthcare payments in healthcare data warehouse and deploy due to customer requirements..
Client: Texas Health Resources- Dallas Texas – July 2014 – December 2014
• Convert and integrate DB2 programs for healthcare model into NETEZZA and upgrade from Datastage 8.5 to 9.1 version. This required working with UAT team to develop test scripts.
• Responsible for conversion of sqls and scripts to NETEZZA and unit test. From staging to EDW to Data mart and including UAT scripts to assist testing team.
• Worked on performance tuning of data workflows to optimize the data ingestion speeds
•
Client: Baylor Healthcare dallas, TX - June 2014 – July 2014
• Used DataStage 9.1 and IBM’s Rapid Job Update Tool to integrate/change programs from Netezza to Oracle for a proof of concept project on the HCPDM. (Health Care Provider Data Model) using conversion tool.
Client: Perficient Asset Development (Internal Project) - Nov 2012 – May 2014
• Used DataStage 8.7/9.1/11.3 to create load programs and sequencers for rapid development and deployment of healthcare model for internal assets
Client: Premier Healthcare Alliance – Charlotte, NC - July 2011-October 2012
• Used DataStage 8.7 to create load programs and sequencers for rapid development and deployment of healthcare model. This also included importing reference data for drugs, procedures and diagnosis data.
• Used DataStage 8.5 and MQ series to build all reference data loads for hospital, organisms and lab tests, including hierarchies and relationship tables.
• Designed and deployed reference data model and processes for clinical and patient data.
• Developed/tested/integrated real time programs for ADT patient tracking for hospital data.
• Import reference data from outside data providers and loading to dimensional data warehouse in UNIX/DB2 environment for Cognos framework and UI screens.
Navistar International (Contracted through Jayceeco)Lisle Illinois January 2011-July 2011
DataStage Developer
• Converted system from Siebel to DataStage for reporting in UNIX/Teradata/Oracle/Informix environment.
• Participated in conversion from server platform to parallel 8.1 and Oracle 11 to Teradata databases.
Boeing Financial Systems (Contracted through HCL America) Raleigh, NC April 2010-December 2010
ETL Analyst
• Provided First level support on DataStage 7.5.3 to comply with government requirement of audit rules.
• Monitored production run of financial data warehouse build, load and Cognos Cube builds to ensure timely deployment for financial analysts for the consolidated warehouse.
• Documented Autosys (scheduling application) jobs and began the process of building better documentation.
• Participated in setup and running of pre-production programs due to be implemented in the next breakpoint.
Kelloggs (Contracted through Capgemini) - Oakbrook IL September 2008-November 2008
DataStage Analyst
• Reviewed DataStage components and usage for analysis.
• Documented user process flow diagrams, for all ERP and financial reporting systems.
• Created spreadsheets, Visio and Access database for future use.
• Gathered and resolve all current running systems for global systems to determine impact of IT spending freeze
Limited Brands (Contracted through Capgemini) Columbus Ohio January 2007-August 2008
DataStage Developer/Analyst
• Involved in ETL requirements gathering, design and development of ETL procedures, setting up repeatable job processes, validate table structures and sequences.
• Using the stages such as Aggregator, ODBC, sort, lookup, merge and created datasets and access them in IBM DataStage 7.52. to create large formatted files for import into SAP IDOC load process.
• Converted functional requirements into technical specifications and then programs.
• Worked on DataStage Administrator, DataStage Manager, DataStage Director and DataStage Designer.
• Using DataStage designed the procedures for getting the data from all systems to load Site, Sales Org, Article and Variant structures in SAP.
• Used DataStage Director and the runtime engine to schedule, run, monitor schedule and validate its components.
• Used DataStage Administrator to assign privileges to users or user group’s move, rename or delete projects.
• Developed processes for extracting, cleansing, transforming, integrating and loading data into Data Mart’s using DataStage Designer.
• Analyzed and extracted data from user files and legacy mainframe data.
• Used various stages like transformer, funnel, lookup, join, merge, remove duplicates, change capture, filter, aggregator etc.
• Create various DataStage datasets & LUTs (Look up tables)
• Worked with DataStage components for data cleansing and conversion and loaded data into target database.
• Created sequences which were using in custom Oracle insert/update stage.
• Responsible for supporting and managing database activity during the development process.
• Performance tuning of DataStage jobs.
• Extensively worked on improving performance of the jobs by avoiding as many transforms as we could.
• Used shared containers for multiple jobs.
• Used FTP tool for UNIX file handling
• Created shell scripts which will invoke the DataStage jobs passing all the variables for the job to execute like the Source and Target databases connection information.
Boeing Integrated Defense Systems (Independent Consultant) Philadelphia, PA August 2006-December 2006
DataStage Developer
• Worked with the Business analysts and the offsite team for requirements gathering, business analysis, testing, and project coordination
• Involved in Logical and Physical Database design for custom parts database needed for integration with third party system that scheduled maintenance and parts procurement tasks
• Gathered client requirements and documented into project plan.
• Worked on developing data mapping documents and mapping rules to illustrate data flow from source system to target tables
• Worked extensively with Server jobs, UNIX scripting and Job Sequencers.
• Worked with stages like Data Set, File Set, FTP Stage, Look Up and XML stages for performing lookup functions on the source and lookup datasets, determine changed, new or deleted records format in XML and deploy in UNIX server for Daemon processing.
Environment: IBM DataStage 8.0.1, Oracle 10g/9i, TOAD, Windows 2000.
GMAC, MO (through Tek-Systems) St. Louis, MO January 2006-August 2006
Cobol/Adabas Developer
• Follow specifications for new COBOL programs to pass data through a content switch (XML) format to load Oracle tables and present in Java/HTML.
• Test and follow up through user testing with WebX and test planning software
• Create test scenarios and follow through to project leader.
• Create Natural audit programs and de-construct programs for documentation.
Environment: OS/360 MVS, Adabas 7.0/Natural 3, COBOL
PepsiAmericas, Meadows IL March 1999-August 2005
DataStage Developer/ Analyst
• Used DataStage Designer to extract data from many back end systems in Oracle database and formatting data into binarized format for loading into handheld delivery application.
• Created both logical and physical data models.
• Designed and populated feed into custom load format for insertion into BI format for analysis
• Using DataStage to maintain consistent data and values by shielding the legacy structures..
• Developed job sequencers and implemented them.
• Optimized process from 3 hours to 45 minutes using various means.
• Increased correct invoice pricing and discounts by 25% due to better procedures and structure changes
• Extensively worked on DataStage Director, DataStage Manager and DataStage Administrator.
• Used Hashed files for reference lookups and complex logic.
• Used hashed files for conditional lookups and to handle multivalues.
• Fully responsible for 24/7 support for critical Sales and Delivery process.
• Using DataStage director to monitor jobs and setup for SYSADMRL scheduler.
• Shell scripts were written to invoke PL/SQL functions and SQL loader tool
• Wrote custom routines for cleaning data before loading data into target database.
• Created custom tax application data structure for 'by the ounce' calculation versus 'by the case' process in less than a month to keep pace with implementation schedule.
• Responsible for all scheduling and support for delivery application data that ran as a real time system for database update and output.
• Lead developer to JAVA based pricing system that replaced mainframe data with ORACLE web based application to resolve discount pricing into handheld devices.
• Team member for Streamware vending solution to convert from mainframe based application to web based application. Experienced in all phases of SDLC and have acted in every capacity.
• Created Database objects like tables indexes.
• Generated triggers for data integrity, created views to resolve complex queries and also create computational modules in Pro*C.
• Used SQL*Loader to load data into Oracle database.
• Performed extensive SQL tuning and optimization on views and queries generated by reporting, front- end packages and developers.
• Wrote technical documentation and data process documentation for back end systems.
• Consolidate separate mainframe jobs that were run 22 times into one set of jobs that formatted all data for HHC legacy system prior to upgrade. Saved many dollars in incorrect invoice creation because of missing discount information.
• Extensive Natural programming and analysis for shutting down the mainframe project.
Environment: Ascential DataStage 7.5, Oracle 9i, Toad 8.6, SQL, PL/SQL, Windows 2000, DOV/VSE OS, JAVA
Elkay MFG, Oak Brrok IL June 1998 to March 1999
Adabas Natural Developer (Contract)
• Extensively involved in project’s systems analysis & design, information gathering, process & data modeling, data cleansing and user requirements.
• Optimize current programs using newer processes.
• Extraction data into Access database for easier analysis.
Environment: DOS/VSE, Adabas/Natural, Windows 2000, Lotus Notes
William Wrigley Jr. Co, Downtown town L Sep 1986 to March 1995
Adabas Natural Developer (Full Time)
• Conversion of mainframe platform VSAM to Adabas using Natural
• Support for billing and order entry
• Use of EZTRIEVE tool for analysis
Environment: DOS/VSE, Adabas/Natural/VSAM
Contact this candidate