Manager Data
Resume:
Jason EunYong Jeong
NorthYork, ON, M2N7C6, Canada
************@*******.***
OBJECTIVE
To obtain a challenging and responsible position as a Business Intelligence Expert and to utilize 14+ years of experience to full potential.
Extensive experience in delivery of decision support reporting using Cognos 8x BI Tools (like Report Studio, Analysis Studio, Power play Studio, Query Studio, Cognos Connection, Dashboard, Administration, Transformer and Framework Manager) accessing information of various types of relational data source (like MS-SQL, Oracle, Sybase).
EDUCATION
IBM Cognos 8 BI Nov 2010
Project Management Aug 2004
SAP BW 3.0 Jul 2002
MicroSoft Certified System Engineer Apr 2000
Microstrategy 7.0 Jan 1999
Unix and Teradata Jul 1998
Bachelor’s degree in Statistics Feb 1998
INHA University in Korea
Certification
PMP Sep 2004
MCSE Dec 2000
PROFESSIONAL EXPERIENCES
Mar 2006- Current AIG General Insurance, Seoul, Korea
Environment UNIX, Windows NT, Mainframe OS/390, DataStage, UML, SPSS, Cognos BI 8 (Report studio, Query studio, Analysis studio, Framework Manager, Power Play, Transformer), Oracle, Sybase, MS SQL, OLAP Analysis, Data Mart, Data Mining, ONYX, Ms Project
Role / Accomplishments: Sr DW Manager/ Sr BI DeveloperFamiliar with design and specification for ETL processes (workflows) using DataStageDesign and develop ETL processes and data architecture: create Datamart for insurance policy and customer to analyze loss ratio by campaign, product and coverageDeveloped reports in Cognos 6.X and Cognos 8.XDesigned and developed Cognos report for DM(DirectMarketing) MarketerDesigned and developed Cognos report for TM(TeleMarketing) Call CenterModeled, designed, built and administered Cognos 8 dashboard, cubes and report using Framework Manager: Analysis Studio,Report Studio,Query Studio,Event Studio,TransformerDesigned and integrated Cognos job automationGeneral recommendations and implementation of Cognos performance improvements Designed and created Cognos PowerPlay cubes using Cognos Transformer.High level of expertise dealing with large DataWarehousing systemsImplement report automation project of TM Call Center: Managed/optimized project schedule and task planning using MS Project, identified data flow of call center report, designed and built data model and automated the report Analyzed the current logical and physical data models, collected and identified all input data that get in the summary data warehouses; Create technical and user documentation. Designed, modeled and built ETL process for CRM system supportDeveloped and deployed Portfolio Management Tool to enable data analysis Responsible for generation support of P&L reports and Dashboard for senior management reporting
Mar 1998- Feb 2006 SAMSUNG SDS, Seoul, Korea
Environment : UNIX, Windows NT, Mainframe OS/390, DataStage, Oracle, Sybase ASE, Sysbase IQ, Teradata, MS SQL, SAP R/3, SAP BW, ODS, OLAP Analysis, Data Integration, Data Marts, Microstrategy 7.0, BEx Query, dynaSight, Data mining, FTP, System Architect, Ms Project
Jan 2004 - Feb 2006 SAMSUNG Securities, Seoul, Korea.
Role / Accomplishments: Senior BI developer, DataWarehouse ManagerMaintained and monitored the DataWarehouse SystemConducted root cause analysis in DataWarehouse system by monitoring, troubleshooting and resolving system issues.Installed and administered Microstrategy 7.X Designed, modeled and built ETL process for CRM system supportCollected user requirements and prepared data architecture, test scenario and analysis reports: identified data retention period and volume of all summary data warehouses Migrated legacy systems data to DataWarehouse using DataStageExtensive use of complex stored procedure & views-using Transact-SQL and its tuning for fast retrieval of data.Made a schedule and contingency plan for data migration: Defined and created migration plan, defined activities, determined estimates, monitored activities.Completed 6 Sigma project successfully: reduce the ETL process time by developing batch scheduler that can execute lots of program in parallel.
Jul 2002 - Dec 2003 SAMSUNG Securities, Seoul, Korea.
Role / Accomplishments: BW developer
Designed and implemented the BW System for Business Planning and SAP CO.System.Collected user requirements and defined the data transformation and ETL processAnalyze current business systems/data sources to deliver EIS system (dynaSight)Supported and coworked with EIS system developer to create dashboardRealized target ODS and InfoCube model and implemented reports and OLAP cubes. Architecture design using Unified Markup Language (UML)Work closely with Business Planning team to ensure full alignment to the Decision Support Strategy and Best practices to make sure business use correct tool for their requirements
Mar 1998 - Jun 2002 SAMSUNG Life Insurance, Seoul, Korea.
Role / Accomplishments: BI developer, DataWarehouse Maintainer
Developed ETL process using COBOL(PL/I) Program Language Saved the running time about 20% through ETL Process innovation in daily batch processGenerated weekly statistical and performance reports for senior management review Collected user requirements, defined the process and developed the OLAP reportsDesigned, modeled and built data mart and ETL process for customer scoring system Made training materials for end user and teach how to use the OLAP Tool(Microstrategy).Prepared GAP analysis report for existing applications with new requirements from customers. Assist implementation and writing user manualData migration for old 3rd Party system (DB2,MS Access) to new DataWarehouse systemCreated and maintained ETL job in different data forms (Table, Ascii, Text, Excell, CSV) and schedule jobsMonitored the ad-hoc OLAP report of end user and gave direction for correct usage of Microstrategy.Played a critical role in launch of new products and/or campaigns by providing statistical data and active collaboration with product and marketing teams. Contributed to the improvement of customer retention by developing customer scoring analytics targeting 7 million existing customersInvolved in maintenance of policy and customer Data Warehouse systems and improved of data reporting efficiency by up to 30%.
TECHNICAL SKILL
ERP SAP BW 3.0 - 2yearsData Architecture System Architect - 4years
UML, ERWin – 4yearsBI Reporting BEx Query - 2years
Microstrategy 7.0 - 7years
Cognos 6.X - 2years
Cognos 8.X - 4yearsETL Tools DataStage - 4yearsDataBase Teradata - 4years
Oracle 9i, 10g - 8years
Sybase IQ – 4years
Sybase ASE – 6years
MS SQL – 3yearsO/S Unix, IBM Mainframe, Dos, Win NT 2003 2008, Win 7, Vista,XPProgramming COBOL, PL/I, ABAP, SQL, C++ Builder, UNIX Shell ProgrammingTools Microsoft Office, Citrix, VPN, Ultra-Edit, PC-anywhere, SnagIT etc
REFERENCE Available upon request
Contact this candidate