Independently support Resume

SUMMARY

Strong understanding in enterprise data warehouse (EDW) analysis.
Expert in ETL IBM IIS (Datastage) SDLC, from design, implementation, testing, production deployment, and software administration; also familiar with Informatica design and process.
Expertise in relation database in DB2, Oracle, SQL server and strong SQL.
Strong experience with Java development using Eclipse, Python, R.
Strong experience in Linux and shell scripting.
Familiar with version control tool such as GITHUB.
Knowledge of Big Data, Hadoop, Mongo DB.
Strong business analysis skill and fast learner for debugging, research and investigation. Self - motivation and ability to work equally well independently and within a team environment.

TECHNICAL SKILLS

Platforms: UNIX, Linux, Mainframe (OS/390), Windows (Server 2012/XP/7/10)

Databases: DB2, Teradata, Oracle, Microsoft SQL server, SQLite

Languages: SQL, UNIX Shell Script, R, Python, Java

Software: IBM InfoSphere Information Server (v7.5, 8.1, 8.5, 9.1, 11.3,11.5), Informatica, DB2 relational database, Microsoft Office 365, Teradata Utilities (BTEQ, FASTLOAD, FASTEXPORT, SQL Assistant), Citrix, Dbvisualizer, Datameer, File Transfer (FTP-Putty & WINSCP), Autosys

PROFESSIONAL EXPERIENCE

Confidential

Independently support

Responsibilities:

Installed and supported IBM InfoSphere Information Server (IIS, v11.5) on Windows server 2012 with regular maintenance.
Installed and supported IBM DB2 database (v11) on Windows server 2012.
Independently designed and supported ETL development jobs for daily RFS reports to import data from Microsoft MySQL.
Experience importing data from more TEMPthan 40 Remedy Oracle tables to support daily IBM BAS reports.
Experience with data warehousing with utilizing star schema data stores for ETL targets.

Independently support

Confidential

Responsibilities:

Independently designed and supported ETL for 70+ daily reports with 200+ tables and 300G+ data, worked from development, testing, UAT to Production deployment.
Independently installed IBM IIS software (version 9.1) in both customer Dev and Prod Linux servers; regularly maintained and supported the server; set up IIS high availability configuration for Disaster recovery.
Implementing business requirements into ETL process to deliver reports.
Familiar with data warehouse, closely working with database administrators in table indexes and foreign key configurations to improve ETL process.
Creating scripts to run Autosys to schedule ETL loading process.

Confidential

technical lead

Responsibilities:

Leading USA region ETL team to perform data processing, and application/Software development to deliver reports for multiple clients.
Supporting ETL QA testing before deploying codes in different environments from Development to UAT, and then to Production.
Primarily worked on ETL develop to provide report data for diverse customers, such as State of New York, State of Ohio, Glodman Sachs, ULA...
Mentoring and training new developers to understand Datastage and data model.
Worked on project migration from Datastage v8.7 to v9.1, then to v11.3.

Confidential

ETL Developer

Responsibilities:

Built measure and metrics for service level agreement management and analysis for global clients, such as AmerisourceBergen, Panasonic, Hartford et al.
Primarily built Automatic Call Distribution processing for report and integrated it to ADW project for multiple customers.
Worked on project migration from Datastage v8.1 to v8.7.
Strong analytical skill, good at ETL process debugging and trouble-shooting.

Confidential

ETL developer

Responsibilities:

Working on a project for a major financial institution
Worked on project migration from Datastage V7.5 to V8.1
Designed, developed unit test for each individual DataStage jobs.
Developed efficient reconciliation scripts to query and validate the migration results.
Utilized Mainframe to handle database and text editing.
Worked on a retail ETL project
Involved in a project using Teradata to manage the Enterprise Data Warehouse of star schema with slowly changing dimensions methods for Retail Company.
Programmed highly efficient SQL to manage over 800 Gig of sales data using Teradata BTEQ.
Designed and developed processes for extracting sales and pricing data from legacy systems and production databases.
Developed and tested processes for loading initial and cyclical sales and pricing data into a data warehouse.

Confidential

Postdoctoral researcher

Responsibilities:

Responsible for executing Brain Korea21 research project to study the root hair morphogenesis in plant via development progress tracking system and delivering final report on schedule and within budget
Managed and reported on project requirements, progress, and deliverables
Involved in mentoring graduate students
Responsible for executing National Science Foundation (USA) research projects to investigate the mechanism of insect resistance in agriculture and leave development in plant
Delivered final report on schedule and within budget
Wrote manuscript for journal publication

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship