Developer Data

Ivan Lung

********@*******.***

cell: 647-***-****

Summary:

Data Warehouse, BI and IT experience as Linux, UNIX, ETL DataStage, IBM Information Server administrator and developer, Information Analyzer and production support, Mainframe developer,.

12 years on DataStage development, administration and architecture design.

5 years on Information Server installation and administration ( IBM IS 11.7.1.1, 11.5, 9.1, 8.7, 8.5, 7.5 )

2 years on Infosphere Meta Data and Infosphere Governance Catalog (IGC) administration.

5 years on Information Analyzer and Profile Stage administration.

Analytical and adaptable to new systems and environments to suit business needs.

Worked in various industries such as Insurance, Banking, Supply chain wholesale, retail, Social Security Payment System.

Work independently to design and build IS 11.7.1 clustered WAS and engine structures.

Collaborate with various teams to solve issues such as Micro Services tier installation, performance and scalability ..etc.

Installed, maintained and configured Infosphere Governance Catalog (IGC) and FastTrack codes on DataStage 11.5 servers.

Set up IBM Infosphere, MetaData Interchange server. Created and maintained MetaData Work Bench and Business Glossary from scratch.

Installed DataStage 9.1 servers and IBM MetaData Management servers from scratch on Red Hat Linux servers. Setup all connections to DB2, UDB, SAS, MicroStrategy, and Power Designer. Set up IBM MetaData Interchange server. Created and maintained MetaData Work Bench and Business Glossary from scratch.

MetaData Work Bench, Business Glossary and MetaData Interchange server were renamed as IGC in newer DataStage versions.

Performed DataStage/MetaData administrations to create and maintain DataStage 9.1 projects, user access and password protections.

Performed DataStage, WAS and DB2 Servers maintenance.

Data modeling and programs tuning on DB Access.

Installed DataStage patches and upgrade on Information Servers. Involved in DR installation and testings.

Created proof of concept (POC) to walk through with Solution Architects. Designed and developed generic common routine for data masking on sensitive data from various sources.

Designed and developed common global routines (in DataStage and shell scripts) to be shared and called by all Data Warehouse projects.

Worked as Quality Assurance for Data warehouse and mainframe applications.

Worked in DB migration such as DB2, UDB, SQL server, Oracle and Paraccel.

Education and Certification:

Security Clearance Certificate 96279728 expiry date 06 October 2030

Bachelor of Science (Computer Science): University of Regina, SASK. Canada

Bachelor of Art (Math): University of Regina, SASK. Canada

Certificate in Basic Datastage Training from Ascential: 2004

Certificate in Advance Datastage Training from IBM: 2007

Certificate in Web Content Development from Centennial College: 2000

Certificate in C++ Development from Centennial College: 2002

Working on Java SE/EE Programming Certification at Centennial College(evening)

Technical Skills:

Operation System: UNIX, Linux, AIX, IBM MVS/TSO, CICS. IMS, MS WINDOWS, AS400

Language: DataStage, C++, KSH, HTML, XML, PL/SQL, JCL, PL/1, BTEQ, SAS, SAS/Graph, SAS /Macro, Java, SQL, CICS Cobol

Database: ORACLE, DB2, UDB, TeraData, SQL Server, IMS, Sybase, AS400, CA-IDEAL, Paraccel.

System Software: JIRA, DevOps, IBM IS 11.7.1, 11.5, 9.1, 8.7, 8.0, 7.5.2, Information Analyzer, IGC, CICS, BMS, MQ, VSAM, Autosys /ESP /CA7/CTL-M/ZEKE/CVS/PVCS/Endevor/StoneBranch, Confluence, Kubernetes, Tableau.

Professional Experience:

Client: Royal Bank of Canada Feb 2019 - Present

Location: Toronto, ON

Role: Information Server 11.7 Datastage Developer / Admin

Description: Developed, designed and administrated Information servers and projects. Designed and created IS 11.7.1.1 cluster with self motivation and minimal supervision.

Responsibilities:

Worked in Information Analyzer team to create and maintain Information Analyzer projects.

Primary responsible for the architecture design and development of the new IS 11.7.1.1 Micro Services Tier, WAS cluster and Engine cluster. First team in the company to design and install I.S. cluster on multiple tiers.

Wrote technical documents, user guide, connection guide with naming conventions, project migration documents for the IS 11.7.1 clustered environments.

Presented architecture design and features of IS 11.7.1 clustered environments to stake holders, business users and production supports in web-ex sessions.

Designed/ Installed IS 11.7.1 Micro Services Tier.

Created/ Installed standalone WebSphere Application Server (WAS) cluster and upgraded to version ND 9.0.5.1

Enabled secure login and SSL certificate on WAS cluster. Connected to cluster nodes with snoop servlet.

Managed pods on Micro Services Tier using kubectl.

Designed/ Installed clustered WAS with deployment manager, members, app servers on different Linux VMs

Designed / installed clustered IS 11.7.1. DS engines on Linux VMs.

Enabled load balancing in IS 11.7.1 cluster.

Upgraded IS 11.7.1 cluster to SP2 and the latest FP1.

Performed post installation validation after full 11.7.1 cluster installation.

Applied jar files provided from IBM to fix upgrade issue.

Solved installation issue using SOLR admin in Micro Services tier.

Created/ Installed standalone XMETA and IADB on UDB. Relocated IADB to be used on another IS server.

Created/ Installed Operation Console on UDB and SQL server. Performed a demo on Operation Console to senior director and business stakeholders.

Worked with end users to create IMAM Hive connection.

Wrote scripts to re-start servers in the complex IS 11.7.1 clustered structure.

Wrote scripts to re-start ODF Engine. Check rule run result using ODFAdmin.

Involved in bi-weekly Sprint planning using productivity tool Enterprise JIRA.

Involved in daily JIRA scrum meeting with offshore and onshore teams

Worked with scrum master in bi-weekly retrospective meeting.

Installed/upgraded Information servers from IS 11.5 to 11.7.1 on Linux VMs with multiple tiers and all-in-1 tier.

Created and Installed IS.11.7.1 for RBC Insurance team on four production Linux VMs: 1 services tier, 1 DB2 repository tier and 2 engine tiers.

Created JDBC Data sources & J2C authentication in WAS console for various IADBs in Information Analyzer projects.

Created IMAM imports and ODBC entries for various data sources. Created/Enabled DB2 Connector to connect to mainframe DB2 from IMAM and Datastage projects.

Created Data Rules and performed column analysis.

Created and maintain IA projects and DataStage analyzer projects. Performed column and table analysis.

Created data sources, data rule set definition in the new IGCUI in IS 11.7.1 SP2. Run Data Rule and browse exceptions using this new IGCUI thin client in IS 11.7.1.1.

Created virtual table using new IGCUI in IS 11.7.1 and performed cross table analysis.

Worked with different line of business users to migrate IA projects from SQL SVR to UDB. created mapping documents and document the business requirements

Wrote Datastage jobs and scripts for table migration. Assisted users to migrate IA rule sets to IS 11.7.1 IA projects.

Created UG backup/restore scripts. Performed ISALite health check and UG diagnostic ...etc.

Created IS 11.7.1 Client package on Window 10.

scheduled change releases in Production and assisted production supports to fix issues and server upgrades.

Assisted offshore development team to solve IA, UDB, Linux and IS 11.7.1 issues.

Wrote sample jobs in DataStage jobs to assist users to create IA virtual tables.

Wrote scripts and Datastage jobs for SQL server to db2 migration.

Wrote Datastage jobs and sequences to process datasets on different nodes in the engine cluster.

Worked on various production and UAT incidents/tickets. Fixed StoneBranch job to be run on two Linux VMs.

Worked with installation team to install StoneBranch Agent.

System tuning and optimization. Installed/upgraded Linux packages on various VMs. Monitored system usages.

Partially involved in DevOps/Urban Code Deploy, Jenkins development and meetings.

Created projects, users and enabled user security on various projects.

Created IA data sources, connections, analyzer projects, IA rule sets and IA rules.

Created mainframe JCLs to enable UDB maintenance on Linux servers.

Enabled DB2 connector and connected to mainframe DB2. Created IMAM connection to connect to the mainframe DB2.

Designed/ Installed IS 11.7.1 Enterprise Search.

Installed Docker on Micro Services Tier.

Performed re-index on Micro Services and Service Tiers using REST API.

Worked with offshore team and production support to fix production issues and conducted knowledge transfer. Provided guidance and coordinate the scheduling of reviews with offshore team.

Created data mapping documents for different line of businesses. Wrote data conversion Datastage codes and Linux scripts.

Updated Enterprise Confluence with project design, architecture and implementation details.

Installed Ansible 2.9, worked with Ansible play book. Created yaml files.

Installed Python 3.6 on Linux server. Modified Python codes for IS 11.7.1 Micro Service Tier installation.

Installed Java 1.8. Wrote stand alone java codes to connect to UDB from Linux and Window laptop.

Assisted US Data Office to setup connection to UDB from Tableau. Monitored dashboard response times on Tableau server.

Implemented changes and fixes into production using Service Now.

Assisted DBA and DB security team for the installation of XMETA and IADBs for issues like remote DB connection, DB2 connector and db encrytion.

Worked with DBA to create DDLs and DMLs for IADB, XMETA and Operation Console.

Environment: Information Server 11.7.1, 11.5, Information Analyzer, Linux, IADB, JIRA, DevOps, Urban Code Deploy, UDB, Operation Console, SQL SVR, Linux, MS Window, DataStage, StoneBranch, REST API, Tableau, Kafka, Hive, Zeke, JCL, MVS, Endevor, Apache, Confluence, Zookeeper, Ansible, Python, DbVisualizer, Java, Kubernetes, Docker, Snoop Servlet, Agile methodology.

Client: Scotia Bank of Canada April 2016 – Sep 2016

Location: Toronto, ON

Role: Datastage / IGC Admin

Description: Developed and maintained MetaData repository for the reverse engineering project.

Responsibilities:

Installed, Maintained and Configured Infosphere Governance Catalog (IGC) and FastTrack codes on DataStage 11.5 servers.

Collected business requirements from BA and team lead.

Provided documentation and job flow.

Performed MetaData mapping and Data Lineage on the reverse engineering project.

Wrote system scripts and DataStage jobs to backup/restore IGC MetaData Repository and FastTrack mapping.

Wrote DataStage 11.5 jobs using Hadoop.

Fixed immediate production issue.

Environment: Linux, DataStage 11.5, Hadoop, MS Window, FastTrack, IGC, Toad.

Client: Workplace Safety Insurance Board (WSIB) February 2015 – April 2016

Location: Toronto, ON

Role: ETL Data Warehouse Admin / Developer

Description: Created and implemented Common Generic Routines to mask production sensitive data

Responsibilities:

Proposed to use generic common routine with business owners for data masking. Created quick proof of concept to walk through with Solution Architects.

Created quick proof of concept for the Common Generic Routines and wrote mini codes to walk through with Solution Architects.

Was assigned for the design, development, implementation and support of Common Generic Routines to mask production sensitive data from Oracle 11g, SQL servers, DB2, UDB, VSAM, SAM, Mainframe CFF flat files with header and trailer records, and AIX files.

The common generic masking routine was written mainly in DataStage 8.5. also wrote a few C++ generic routines to be called by DataStage jobs.

Installed DataStage 9.1 servers and IBM MetaData Management servers from scratch on Red Hat Linux servers. Setup all connections to DB2, UDB, SAS, MicroStrategy, and Power Designer.

Set up IBM Infosphere, MetaData Interchange server. Created and maintained MetaData Work Bench and Business Glossary from scratch.

Generated data feeds for SSIS.

Set up FTP connections to MVS from DataStage server and other servers.

Create and maintain XML files using Datastage PX.

Create packages in SSIS.

Assisted developers with advices to solve day to day issues.

Environment: SQL servers, DB2, UDB, MVS, VSAM, SAM, Mainframe CFF flat files, Oracle, AIX, SSIS, SSRS.

Client: Aeroplan, AIMIA (Montreal) October 2013 – Jan 2015

Location: Montreal, QC

Role: BI Developer & Information Server Administrator

Description: Developed and administrated Data Warehouse projects

Responsibilities:

Designed Data Warehouse jobs in DataStage 9.1 on Linux servers. Wrote shell scripts.

Worked in DB migration from UDB to Paraccel.

Created and maintained DataStage projects for development, UAT and production environments. Defined node partitions, resource and scratch disks. Bind DB2 instance 1 in metadata repository. Wrote cleanup jobs.

Installed DataStage 9.1 servers and IBM MetaData Management servers from scratch on Red Hat Linux servers. Setup all connections to DB2, UDB, SAS, MicroStrategy, and Power Designer. Set up IBM MetaData Interchange server. Created and maintained MetaData Work Bench and Business Glossary from scratch.

MetaData Work Bench, Business Glossary and MetaData Interchange server were renamed as IGC in newer DataStage versions.

Performed DataStage/MetaData administrations to create and maintain DataStage 9.1 projects, user access and password protections.

Designed and created common global routines (in DataStage and shell scripts) to be shared and called by all DW projects. Wrote and presented technical specification for the generic routine.

Performed DataStage, WAS and DB2 Servers maintenance.

Data modeling and programs tuning on DB Access.

Assisted developers, production supports, architects and technical advisors on connections, programming, architecture, resource planning and DataStage issues.

Installed DataStage patches and upgrade DataStage 9.0 to 9.1 versions on existing Linux server. Involved in DR installation and testings.

Assisted production supports to handle difficult issues.

Wrote sample templates and coordinate with outsource team in India. Wrote quick website for knowledge transfer to include coding standards and template, end users training, drivers download, instructions for DataStage Clients installation and upgrades, tips and tricks and request forms.

Environment: Oracle, UDB, Linux, MS Window, DataStage, MetaData Work Bench, Business Glossary, IGC, Toad.

Client: Sears Canada Sep 2012 - Mar 2013

Location: Toronto, ON

Role: DataStage Developer

Description: Datastage Administrator & Developer

Responsibilities:

Worked on JDA E3 Project for Store and Warehouse Replenishment

Developed DataStage 8.7 codes for the JDA project.

Performed some Datastage admin tasks to maintain projects.

Installed DataStage servers and IBM MetaData Management servers from scratch on Red Hat Linux servers. Setup all connections to DB2, UDB, SAS, MicroStrategy, and Power Designer. Set up IBM MetaData Interchange server. Created and maintained MetaData Work Bench and Business Glossary from scratch.

Job tunings and system resources monitoring.

Wrote Aix wrapper, archive scripts, system configuration files and define ODBC settings to AS400 server and FTP script to connect mainframe to AIX server.

Wrote DataStage jobs to generate test data before live test.

Support, fix and tune production jobs.

Environment: AS400, MVS, AIX, MS Window, DataStage, FTP, JCL.

Client: Royal Bank of Canada August 2010 - September 2012

Location: Toronto, ON Responsibilities:

Worked for EIM team on Data Warehouse Environment (DWE) Systems

Production support to various BI Data Warehouse systems using TeraData, Sybase, DataStage and MVS.

Acquired fire call id to fix production tables in TeraData (A,B) for urgent issues.

Wrote IS Datastage programs and server jobs.

Created programs to parse DataStage codes, exported output in XML format. Wrote DataStage programs to generate HTML error reports. Created simple SharePoint site using html and Java scripts.

Wrote a few SAS programs to generate run-time files to fix production issue.

Also worked on older DataStage 7.5 projects on Window 2003 servers.

Environment: Sybase, Window server, DataStage, TeraData, BTEQ, SAS, HTML, Linux, Java scripts, MVS, Zeke, JCL, OMS, On-Demand, Hummingbird BI.

Role: Data Warehouse Developer

Description: Developer and production support

Client: Canadian Tire Corporation Ltd July 1999 - August 2010

Location: Toronto, ON

Role: Datastage Administrator, Datastage Developer, C Developer, SAS Developer, PL/1 Developer

Description:

Datastage Developer November 2004 - August 2010

Datastage Administrator October 2006 - February 2008

Profilestage Administrator April 2007 - June 2009

C/C++ Developer February 2002 - October 2004

PL/1 Developer July 1999 - January 2002

Responsibilities:

Designed and developed Service Level Agreement (SLA) system. Wrote recursive JCL jobs using SAS to generate SLA report in HTML format. Participated monthly SLA meeting with SLA manager.

Wrote data cleansing and archive jobs.

Created and presented DataStage best practice document.

Was involved maintaining SAS jobs for in-house HR employee system.

7/24 pager support and end users support for DataStage ETL and Cognos projects. Wrote archive script for the Cognos team to maintain detail and summary cubes. Attended Cognos and Information Server training courses from IBM.

Responsible for writing and maintaining DataStage programs, jobs, shell scripts for the BI applications.

Developed ETL intranet website to educate new DataStage developers as well as knowledge transfer.

Translated Mainframe JCL and PL/1 programs into DataStage projects.

Wrote SAS programs to generate reports and dynamic JCLs during runtime for JES reader queue.

Involved in QA teams to test the BI ETL applications using Quality Centre / Test Director.

Created, maintained Data Warehouse projects on various AIX servers.

AIX disk monitoring, wrote archive scripts and maintained system integrity.

BI database upgrade to DB2 Ver. 9

DataStage upgrade from 7.5.0 to 7.5.2

DataStage upgrade from 7.5.2 to Information Server 8.1

Responsible for creating and maintaining ProfileStage projects for the Data Quality Analyst team.

Data extraction from DB2 and Oracle 11g for data profiling.

Wrote DataStage programs to extract XML files, MQ datagrams and requests for loading to ProfileStage server.

Generated HTML reports from DataStage and upload to the intranet. Wrote FTP/SFTP scripts.

Involved in the development and support of Canadian Tire Exchange Point website using multithreading C++ to retrieve Mainframe DB2 data, generate and post the web base html reports to the Canadian Tire internet site using MQ.

Responsible for develop and support the Canadian Tire Exchange Point internet website:

ohttps://www.ctcpartner.com

Worked in warehouse for 2 years for the shipping project using C, C++, Oracle PL/SQL, sqlplus on Unix tru64.

Developed and maintained PL/1, JCL, IMS DB/DC programs on MVS.

Environment: XML, MQ, PL/1, PL/SQL, IMS, DB2, Oracle, SQLplus, DataStage, ProfileStage, SAS, HTML, Java scripts, MVS, JCL, XPEDITER, Window server.

Version Control: CVS / PCVS, CA7, ESP, Autosys

Client: ESSO - Imperial Oil Nov 1997 - May 1999

Location: Sarnia, ON

Role: SAS Developer

Description: SAS and Mainframe COBOL development

Responsibilities:

To create and maintain Convenience Retail Information and Point of Sale systems using SAS, DB2, COBOL and JCL.

Involved in the HOURGLASS, Y2K compliance and certification training. Responsible for Y2K compliance testing.

Primary responsible for analysing, designing and developing the DEBIT CARD RECONCILIATION system.

Using SAS and SAS/GRAPH to generate statistic reports in color. The reports are in office97 CGM format used for PowerPoint presentations.

Environment: IBM MVS TSO, Development softwares are SAS, DB2, COBOL, JCL, HOURGLASS. SAS /GRAPH, SAS/STAT, SAS/ACCESS, MVS.

Client: Zurich Canada June 1997 - Aug 1997

Location: Calgary, AB

Role: SAS Developer

Description:

Was involved in the Data Warehouse Ratemaking project. Developed about 40 SAS programs and 2 COBOL programs.

Hardware includes IBM mainframe under MVS/TSO, and development softwares are SAS, COBOL, VSAM, JCL and QMF.

Environment: SAS, SAS Macro, DB2, COBOL, JCL, MVS.

Client: Oshawa Foods Sept 1996 - June 1997

Location: Ottawa, QC

Role: Developer

Description:

Oshawa Foods is the headquarter for IGA, Price Chopper, Pharma Plus, Food City and Food Townl in Canada

Responsibilities:

Was involved in the food promotion project POMO. Developed about 20 online CICS COBOL programs and 35 batch Cobol programs.

Maintained and supported existing systems.

Environment: CICS COBOL, JCL, MVS, VSAM, BMS, CA-DATACOM/SQL and CA-IDEAL

Contact this candidate