Joung Min Oh
- Data warehouse, ETL, Business Intelligence (Tableau) Lead and .Net C# Developer
- New York City, NY
- Member Since Mar 15, 2023
Candidates About
Joung Min Oh
(TONY OH)
Summary
- .Net C# Webform, MVC, Microsoft SQL Server, Oracle database, T-SQL, PL/SQL, Stored Procedure, JavaScript, Json, xml, jQuery, OOP (Object Oriented Programming) for the implementation (application/software) and maintenance of internet or intranet-based business-oriented applications.
- Big data implementation, management in Data warehouse with Business Intelligence tool. (Sophisticated database object design and its performance enhancement in conjunction with summary, Datamart, Fact tables for further reporting or for Business Intelligence tool)
- Data handling against various databases on ERP, MES, B2B, B2C, multi-tier transaction based on system & application and sales & marketing purpose of applications and its daily operations.
- Project management from small to large size of projects by collaborating with resources in various locations and countries.
- Positive attitude toward projects, challenges of getting new trends and working with other teams and members. (IT teams and business teams)
Education
Mar. 2006 ~ Aug. 2008
Master of Business Administration in International Business (Foreign Direct Investment, Trading, Logistics)
SoGang University, Seoul, South Korea
Sep. 1997 ~ Mar. 1999
Bachelor of Science in Computer and Information Science
The University of Oregon, Eugene, OR, USA
Mar. 1989 ~ Feb. 1994
Bachelor of Science in Mathematics
Korea University, Seoul, South Korea
Experience
Daikin North America (Good Manufacturing Inc)
Data warehouse, ETL, Business Intelligence (Tableau) Lead and .Net C# Developer
Houston, TX
May. 2017 ~ Apr. 2018
Industry: Manufacturing (HVAC)
+ Tableau configuration in Tableau server and web.
- Tableau server installation, configuration and version upgrade based on Active Directory authentication with company’s Single-Sign-On credential.
- Tableau web configuration (Manage user, license, sand/production projects management)
- Pre-defining report purpose of data in Data warehouse to make it ready to be used in Tableau designer version.
- Explorer best practice by the combination of data warehouse access and Tableau desktop dashboard designer and release it to the end-users so that they can easily design dashboard and publish into Tableau web.
- Configure the server to enable Tableau trusted authentication for embedded dashboard in external web sites.
+ Data warehouse implementation
- Try to combine all split data in different databases on different systems into company-wide consolidated data warehouse.
- Handle manufacturing related data (MES, ERP on mainframe), CRM data (account, contact, lead, opportunity, quote, won/lost, order in pipeline), finance data (GL, BS), products’ real-time analytic data (energy consumption, efficiency, temperature), SCM data (order, invoice, ship, inventory), consolidated sales data (rep. sales, district sale, regional sales, goal, revenue, cost, margin)
- Gather & analyze business report & dashboard requirements and then ETL from various sources. (AS400 Mapics, Microsoft Dynamics CRM, External vendors via FTP in XML, Text format)
- Design databases, tables, views, stored procedures and data dictionaries to pull data. (Merge or CRUD operations)
- Provide summary data using views or tables for internal users or Tableau users.
- Implement data pulling and manage data flow and then monitor the data integrity daily.
- Open Query, SSIS, T-SQL on Microsoft SQL Server 2012 Enterprise Edition. (User authentication was based on company-wide Active Directory)
- Direct access to company’s mainframe’s DB2’s physical or logical files to get updated data by writing SQL script.
- Manufacturing domain with a big data. (Mainly, shipment, invoice, finance general ledger, trial balance, order, inventory with more than 1 billion records)
+ .Net C# implementation
- Deliver data from data warehouse to other internal/external consumers by WCF, Web API (REST) with XML or Json data format for them to consume. (MVC pattern without View)
- Implement wrapper Web Api for Tableau Trusted Authentication process to get Ticket from Tableau and allow accessing to Tableau dashboard in external web site. (The purpose of this process is to bypass Tableau login process)
- ETL from other data providers by using their Web API delivering XML or Json format.
- ETL into database tables from FTP in different format (XML, Json, Text) in SSIS with Script Task.
- SSIS with 1-5 minutes real time interval automatic process was used to get XML from FTP where vendor drops XML in 1-5 minutes interval. (Data was delivered from 3rd party vendor who keep monitoring HVAC machines at different houses by different states. Total 7 sensors per each machine and it includes temperature, electivity consumption and several fact data for marketing strategy purposes. End user of this data is product development team & marketing team)
- Implement of single web site rendering json in html/css to show statistics with chart components from Google Chart. (Get/parse Json and compute summary/aggregation for the chart and then do binding to chart.)
E & Company
Senior .Net C# Developer
South Korea / Mexico / Europe
July. 2015 ~ Jan. 2017
Industry: IT, System and Application Integration and consulting
+ LG Electrics (Seoul, South Korea)
- Project: E-Commerce Platform Enhancement.
- Oct. 2016 ~ Jan. 2017
- Develop and optimize commercial middleware with Web API aimed to perform sophisticated business transactions to communicate with vendors. Business cycle is mainly order, acknowledge, invoice, shipment, logistics, history tracking and linkage with SNS (Social Networking System)
- Achieve by Web API as front-end exposures and back-end business logic by using business layer of classes and data access layer of classes with stored procedures to do handling data against database.
- Provide Json format of data to consumer according to mapping definition which was gathered in the phase of user-requirements and analysis phase of project. (Change request was used to change/update existing prototype or mapping definition)
- Provide Web Api’s URI to consumer to select/update/insert transactions which are defined in controller that communicates with database via set of classes in model.
- .Net C# Webform, Web API, SQL Server 2012, Json, XML, Partially MVC Pattern
+ SamSung Construction (Seoul and Ulsan, South Korea)
- Project: KHNP (Korea Hydro & Nuclear Power), Nuclear Power Plant Construction
- Aug. 2016 ~ Oct. 2016
- Intranet based on new nuclear power plant construction management system implementation.
- Customization based on specialized package for specific business needs.
- .Net C# Webform, Ajax, SQL Server 2014, Infragistics as GUI component
+ Lucis Korea (Seoul, South Korea)
- Project: Contact Center Solution Migration
- May. 2016 ~ July. 2016
- Responsible to convert legacy application migration to latest .Net C# webform.
- Old ASP and .Net framework 1.0 to .Net framework 3.5 with Visual Studio 2015
- Convert COM+ DLL to .Net dll successfully to remove multi-tier architecture and consolidate into single application tier for entire application.
- .Net C# Webform, SQL Server 2012
+ Hyundai & KIA Car (Seoul, South Korea, Frankfurt, Germany)
- Project: KIA Marketing Solution Deployment
- Jan. 2016 ~ Apr. 2016
- Served as Project Manager on the implementation of 1,500+ automotive dealers’ websites spanning over 20 countries. (All of Europe countries and their dealers)
- Keeping track of project schedule, milestone, resource, 3rd party sub-contractors, budget.
- Adobe Experience Manager (AEM) as a standalone solution package with additional ad-hoc development according to user’s needs.
- Had really close relationship with KIA as customer and negotiated/communicated for successful project launching.
- Used agile project development methodology instead of strict waterfall.
+ Hyundai & KIA Car (Monterrey, Mexico)
- Project: KIA Mexico Manufacturing and Assembly Plant MES
- July, 2015 ~ Dec. 2015
- In charge for web-based on MES (Manufacturing Execution System) application development which sorely focused on SCM (Supply Chain Management) system and handled sophisticated logistics processes and procedures by doing interfacing with SAP module.
- Overall responsibility of this role was the understanding of SCM and the implementation of the application. Main implementation was importing/exporting/container delivering with tracking, container loading/unloading, container yard allocation, unpacking box and putting into stock allowing stock/inventory management in the warehouse.
- Entire data management was based on SAP as MES host system, SCM local database and 3rd party data interactions. (South Korea/US custom, logistics service provider who provided GPS based on tracking)
- Implemented multi-thread console application to get status data from MES devices and feed into database. (Interface module was provided by vendor who installed the one and their device used RFID at the final stage before stocking into warehouse)
- Carry out Oracle database initial setup and data migration for the project. (11g R2)
- .Net C# Webform, Windows Service, Console monitoring application, Oracle 11g R2, Telerik as GUI component
Edenred
IT Director, Senior Developer
Seoul, South Korea
July. 2013 ~ July. 2015
Industry: Marketing Solution Agency (FGMC, Fast-Moving-Consumer-Goods, Finance, IT, Car) with BTL strategy, eVoucher/Reward Service
+ Key Role
- Responsible for all IT system & application development and operation activities in South Korea market (about 30 customers) in conjunction with collaboration with business development team, finance team and oversea resources in Singapore, India, Taiwan, Japan, China, Hong Kong.
+ Solution Development
- Drive, manage development using .Net C# (Framework 2.0 ~ 4.5) Webform (including Mobile Web) and Winform, jQuery, JavaScript, SSIS, SQL Server (T-SQL, Stored Procedure)
- Merchant POS interface with barcode (More than 1,000 Merchants in South Korea)
- One of merchants is Burger King that has around 2,000 offline shops in South Korea and the system was connected to all of their offline shop’s POS system to allow customers to do redemption of e-Voucher. (Secured socket communication was used between the system and their system to be secured.)
- Order, distribution, settlement, invoice cycle management application development
- SSRS report development (SQL Server 2012 Reporting Service, SSDT for report development and deploy)
- Digital Marketing Promotion (BTL) web development. (Mostly, single page or a few pages of highly performance based on web application using client-side technology instead of server-side technology which handles huge in-coming traffics for a digital promotion during specific period of date and time.)
- JIRA collaboration tool configuration for change request and agile or scrum project management. (Deployed for all Asia affiliates)
- Management and development activity (50% and 50%): Management was for leading & managing whole South Korea IT team as well as reporting to region office and communication with colleagues in global office. Development was for designing new sub system into existing system in DB modeling, application architecture in .Net C#, making development template in multi-tier environment and unit testing and deployment and maintenance management by change request.
+ IT Management
- Employ technical expertise to oversee infrastructure on system and application; enhancing processes and launching aggressive initiatives to support business needs and to optimize performance.
- Propose IT portion for the solution as part of master contract and then maintain sub-projects as part of SOW (Statement of Work) continuously to provide the latest needs for customers.
- Overall management of all IT aspects in South Korea for resource, budget, profit and loss, projects/tasks, annual budgeting, forecasting and tracking the operation performance.
IQVIA
Formerly, named as IMS Health after Cegedim Relationship Management
Operations Director
Seoul, South Korea
Feb. 2010 ~ Feb. 2013
Industry: Healthcare (Pharmaceutical CRM & Sales Force Effectiveness solution provider)
+ Key Role & Achievement
- Responsible for all operation activities in South Korea market for not only new projects for new customer but also existing customers by SOW (Scope of Work) and SLA (Service Level Agreement)
- Provide IT part of proposal according to customers’ needs. (Server, network, pricing model, licensing depending on the size of users.)
- Lead and manage IT team to develop and implement CRM and BI solutions for pharmaceutical companies. (SaaS, On-premise, Billing, License)
- Responsibility also includes activities such as resource management, profit & loss control, budgeting, assets control.
- Collaboration with resources in other Asia counties, Singapore, Japan, China, India.
- MI (Mobile Intelligence) solution configuration specialist (MI is a sole solution for only Healthcare industry as SFA/CRM solution.)
- Lead and manage team to gather, validate and update ETC & OTC information daily. (Hospital & clinic information, doctor information; specialty, experience, influence and patient treating data, number of expected calls; OTC details.)
- Validate daily for ETC & OTC as one of products under the product name as OneKey and integrate it to company’s main product called MI (Mobile Intelligence) for auto-assigning territory & sales rep. for pharmaceutical company’s sales organization.
- Cliktech BI (Business Intelligence) solution development and customization
- Operation and daily solution maintenance for clients ensuring all facets of Service Level Agreements (SAL) were met.
- Managed max. 20 IT specialists and max. 20 business consulting specialists for South Korea market.
- Liaison with global development center colleagues in Bangalore, India for specific customization requirements. (Gather business requirements and write down technical specification and send it to India to have additional ad-hoc development)
- Support more than 20 pharmaceutical companies in South Korea market which are most of multi-national pharmaceutical companies and a few of local pharmaceutical companies.
- Operations include all activities (Except Sales/Finance) happening daily in South Korea market.
- Did not have major issues in my team to support business to raise revenue volume for almost 3 years.
Generac Power Systems
Senior Web Developer
Seoul, South Korea / Waukesha, WI
May. 2002 ~ Jan. 2010
Industry: Manufacturing (Generator)
+ Key Role & Achievement
- CRM, B to B, B to C web development for company web site, dealer portal containing activities of business-oriented processes. (Order, invoice, shipment, invoice, delivery and its all reports and dashboard)
- Intranet portal web development for internal employees allowing them to manage information. (Active Directory as consolidated user profile for centralized authentication)
- Web application was strongly in the 3-tier application architecture (Presentation in web server, COM+ business logic in application server, Database in SQL Server with mainly stored procedure & view)
- Interface development for AS 400 Mapics, daily ETL, order, invoice real-time interface.
- BI (Business Intelligence, Reporting) development – Dashboard, Reporting (SSAS)
- ASP (Active Server Page), JavaScript, Visual Basic, .Net VB/C#, SQL Server, SSIS, SSAS
- One of Windows service application was based on multi-thread application to monitor devices, servers and jobs continuously and to alert status to users.
- Launched company’s first web based on e-commerce web site successfully allowing dealers making order in front web which reduced a lot of efforts on the phone.
- .Net C# & VB Webform, SQL Server, Windows Service, Console Application, DB2
Standard Chartered Bank
Junior System Engineer
Seoul, South Korea
Feb. 2001 ~ May. 2002
Industry: Finance (Banking)
+ Key Role in Data warehouse and CRM (Customer Relationship Management) system
- Project management to build Data warehouse.
- RFP (Request for Proposal), vendor selection, vendor management
- Worked with Bain & Company as business process innovation partner.
- Worked with IBM, Samsung, LG, Teradata as IT partner.
- All data in Data warehouse is from mainframe in core banking system. (IBM OS 390)
- Data warehouse: Unix operating system, Teradata as database
+ Key Role in call center and Loan center system
- Project management to build call center and load center to centralize all loan processing into consolidated center
- RFP (Request for Proposal), vendor selection, vendor management
- Worked with Bain & Company as business process innovation partner.
- Worked with IBM, LG, Teradata as IT partner.
- Interact with core backing mainframe for transactions in front-end. (IBM OS 390)
+ Nominated as best employee for the month.
Tong Yang Networks
Researcher & Developer
Seoul, South Korea
Apr. 1999 ~ Jan. 2001
Industry: IT, System and Application Integration and consulting
+ Key Role & Achievement
- Research and development of solution or component that can be used in company’s on-going projects.
- Implemented CBD (Component Based Development) and applied the solution to most of projects in the company.
- CBD was based on 3 tier application architecture and deployed to both Java platform and Microsoft platform. (Class, collection, business access layer, data access layer)
- Support sales team by providing detailed system and application architecture in