Sql Server Data
Resume:
Jin Lemen
********@*******.***
Dublin, CA 94568
SUMMARY OF QUALIFICATIONS
Over 10 years in the Information Technology Industry. Experienced in
Front-end Applications involving WEB development, Client/Server.
Experienced in data modeling and data architecture.
Specializing in data warehouse, data quality, data integration, and data
conversion in Oracle database and SQL Server.
Full software life cycle experience involving requirement specification,
interacting with business, Onsite/Offshore coordination, system
implementation.
Experienced in systems design, data modeling, coding, testing, debugging,
Test Data creation and migration, implementation and post-installation
support in following PMLC/SDLC Methodology including SOX compliance.
TECHNICAL EXPERTISE
Languages: Java, HTML, Java Script, ASP, COBOL II, CICS, C,
C++, PL/SQL, UML, VB6, VBScript, Perl Script, Unix
Script, FoxPro, XML
Databases: ORACLE 9i/10G RAC, SQL Server 2000/2005, SAS, MS
Data Model tool: ACCESS
ERwin
Application/ Web IIS server
Servers: Informatica 7.3 & 8, SQL Loader, PL/SQL scripts,
ETL tools: SQL Server DTS Packages
IDE: Visual Interdev 6.0,VB.net, Visual C++, ECLIPSE
2.1
Technologies: JDK1.4.1, SERVLETS, JSP, ADO, DOM, JDOM, TCP/IP,
FTP
Testing Tools: issue log, PVCS, SOFTEC
Productivity Tools: Visio 2000, Lotus Notes, Microsoft Project
Reporting tools: Crystal Report, Business Object XI
Deployment Tools/ PVCS
Version Control:
Operating Systems: Windows 2000/NT, Sun Solaris 5.8, OS/39, Windows
XP, MS DOS
PROFESSIONAL EXPERIENCE
JP Morgan Chase (formerly Providian/Washington Mutual Finance), Pleasanton,
CA 1999-2009
Database Developer/Analyst
Experienced various cross-functional projects in doing technical
requirement analysis for data management impact, Data ETL design, and
developing logical data structure working with on-shore/off shore IT
teams( Accenture and Cognizant). Promoted existing Data Management ETL
processes for reducing development cost and development duration.
. Involved developing data mart (used star schema) for acquisition data
warehouse. Wrote informatica ETL process to populate data mart fact
and dimension tables as a team member. The data source was Acquisition
OLTP database.
. Identified legacy co-brand system processes developed in informatica
ETL processes and unix scripts and wrote technical system documents
including process flow diagram. The document was used for simplifying
the informatica ETL process at new co-brand launches.
. Developed informatica ETL design and logical data architecture for
storing co-brand acquisition data working with on-shore/off-shore data
management IT team including DBA.
. Worked on a File Creating Utility System developed in informatica.
Provided technical solution as database analyst. With completion of
this project, we reduced the development cost 60K to under 20K for a
new development.
. Managed various data analysis for Customer geographic data, Privacy,
and Do Not Solicitation writing in PL/SQL scripts upon business
requests.
. Conducted data integrating and cleansing projects with the large
volume of legacy customer geographic information in order to provide
the accurate customer information at acquisition process.
. Provided data management technical specifications including ETL
design, Logical data model, and data mapping for various cross-
functional projects.
. Worked with SQL Server DTS Packages for data migration from various
sources such as flat files, MS Access, Oracle tables to SQL Server and
stored procedures for data analysis, data mining, and deleting
temporary tables and views as database analyst.
. Involved SOX Requirements monthly and Quarterly for customer credit
information data integration from TSYS to Data Warehouse validating
all health checks and maintaining health check tables in Oracle
Database.
IT Project Lead
Targeted to be the Subject Matter Expert/IT Analysts for enterprise wide
projects, conducted various projects including data management projects
for detail level technical specifications working with business owner and
outsourcing IT team. The specifications were used for LOE and for actual
development.
. Partnered with business team and system owner; conducted JAD
sessions and collected implemented business requirements and
corresponded system logics requirements which ensured technology
business requirements were accurate.
. Created the detail level technical assessment for database
development and data ETL process and reviewed with business team,
system owner, and outsourcing development team for the estimation.
. Reviewed timeline, technical design document, code review, QA plan,
UAT plan, and all test results and reviewed documents with business
for approval and initiated the project in following PMLC/SDLC
requirements.
. Planned the project timeline and worked with outsourcing technical
development team including DBA and Data Modeler.
. Validated project plan, design documents, development in reviewing
codes, testing validating test results, implementation, execution
in validating real data, and closing.
. Conducted post-production validation with no issues being identified.
Software Engineer/MIS Analyst, 1999 - 2005
Development various business operation applications and MIS reports for
various business groups. The MIS intermediate data or final data were
processed using DTS Packages and Store Procedures mostly in SQL server
2000.
. Worked on Test Call Center Application development as a team member.
The application was written in Visual Basic for GUI and SQL Server for
back-end data storage. Participated creating SQL Server stored
procedures to populate MIS tables in Star Schema and developing VB GUI
for user data entry.
. Developed Quality Control System for measuring customer experience in
Visual Basic front-end and SQL Server back-end for storing customer
experience data including automated reporting using MS Excel. The DTS
Packages /Stored Procedures were created to integrate Quality Control
System reporting data.
. Conducted QA/UAT Tests fixing defects and application errors in
mocking up test data.
. Developed PL/SQL Scripts executed in SQL Loader or UNIX environment
for MIS data integration to Oracle database from various data sources.
. Analyzed the existing tangible and manual reporting processes written
in SAS program for Membership Product Business Group in order to
enhance the prolonged SAS process. SAS program was converted to VB
Application for creating/automated MIS reports in EXCEL and SQL
server DTS Packages/stored procedures for data integration to SQL
Server tables and views. The whole process time was reduced almost 80%
as the end results.
. Automated Dashboard reports in Web basis applications using VB Script,
ASP, and JavaScript for various business senior managements.
. Researched data on the various platforms such as Oracle, SQL Server,
SAS, MS Access, and flat files and developed production and ad-hoc
report writing program SQLLDR and Unix Shell Scripts.
EDUCATION AND CERTIFICATIONS
Associate of Arts, Computer Learning Center, San Francisco, CA
Soongsil University, Korea
University of Maryland University Asia - Korea
Introduction to Software Engineering Certificate
Kimball Group Data warehouse Dimensional Modeling Certificate
Informatica PowerCenter 8 Product Training Certificate
Business Objects Web Intelligence XI Report Design Certificate
JAVA Programming, University of California Berkeley Extension
Microsoft Interdev(HTML, ASP, VB Script), San Francisco State University
Visual Basic Database Programming Certificate, University of California
Berkeley Extension
JAVA and JAVA Script, University of California Berkeley Extension
Client/Server Certificate Program, San Francisco State University
Contact this candidate