Jatin.webxl15@gmail.com Resume

Desired Industry: Information Technology	SpiderID: 21308
Desired Job Location: Morristown, New Jersey	Date Posted: 6/16/2008
Type of Position: Full-Time Temporary	Availability Date:
Desired Wage:
	U.S. Work Authorization:
Job Level: Experienced with over 2 years experience	Willing to Travel:
Highest Degree Attained:	Willing to Relocate:

Objective:
Summary:
• 7+ years of IT consulting experience in enterprise-level solution, focusing on Data Warehouse, CRM and Business Systems in financial, retail and telecom industries
• M.S. degrees in IT and MBA, developed a combination of technical skills and business knowledge
• Proficient skills in Teradata/Oracle Database, Unix, Java and web development tools

Education:
• Carnegie Mellon University, Pittsburgh, PA
M.S in Information Technology, School of Computer Science (GPA:3.95/4.00)
• Ewha Womans University, Seoul, Korea
Master of Business Administration (GPA:4.18/4.30)
• Sungkyunkwan University, Seoul, Korea
B.S in Information Engineering

Experience:
Projects:
July 2006 – Current Capital One Services, Inc. Richmond, VA
Data Stewardship, US Card
Data Analyst
Responsibilities:
• Managed Teradata warehouse access of end user/roles and assigned data objects to roles, responsible for maintaining the group master file
• Created Teradata SQL scripts for Audit/Clean up
• Created Teradata SQL scripts to validate Data Quality within US Card subject areas
• Assisted in the creation, documentation, and publishing of business metadata for newly created US Card Data Environments (Oracle/Teradata)
• Reviewed of project artifacts such as business requirements, design documents, etc.
• Monitored and responded to end user data/technical questions
Environment: Teradata, SQL, MS OFFICE,

Dec 2005 – June 2006 Capital One Services, Inc. Richmond, VA
Capstone Models Team,
Data Analyst
Responsibilities:
• Extracted and analyzed data from existing data stores and performing ad hoc queries
• Assisted in the design, coding, and implementation of new production and DB systems
• Developed and implemented tests on model results
• Used Oracle RDBMS, PL/SQL, Unix, Capstone Application
Environment: Oracle RDBMS, PL/SQL, Unix, Capstone Application

Education:
Dec 2003 – Aug 2004 CircleOne, Seoul, South Korea
Senior IT Consultant – NGM Project , SK Telecom Co., Ltd.
Responsibilities:
• Responsibilities included system analysis and business requirements elicitation, designing system architecture, database model and User Interface for customer membership part
• Supervised 5 programmers through leadership and technical and industry expertise, scheduled project plans, created a work breakdown structure (WBS), managed scope/quality to integrate and perform the activities of a project in accordance with its project plan.
• Used MS Project, Visio, Erwin, Oracle RDBMS, PL/SQL, Unix, Oracle Forms, Java
Environment: MS Project, Visio, Erwin, Oracle RDBMS, PL/SQL, Unix, Oracle Forms, Java

Jul 2000 – May 2002 NCR Korea, Seoul, South Korea
IT Consultant(Professional Service)
Analytical CRM Project - Kookmin Bank and Shinhan Bank
Responsibilities:
• Served as CRM consultant to clients, providing professional services in campaign management solution, Effectively supported business development of campaigns and assisted to analyze target customer group
• Designed application architecture by communicating with marketing department, branches and call centre channels
• Installed, Configured and Implemented Teradata Campagin Management System running on Unix/Teradata environment by integrating with the other enterprise systems
• Mentored clients to maintain campaign management application

Customer Data Warehouse Project - Samsung Electronics Co., Ltd.
• Designed customer database model and transformed Logical Data Models into Physical Data Models, Created an automated daily ETL (Extract, Transform& Load) process using Teradata Utilities such as FastLoad, MultiLoad and Queryman
• Supported OLAP(Online Analytical Processing) by data analysis and SQL execution

Jan 1997 – Jan 2000 LG Telecom Co., Ltd., Seoul, South Korea
IT Researcher
• Designed, Implemented, Tested and Maintained CSBS (Customer Service and Billing System) by customizing Amdocs’ System- Experienced software development life cycle
• Used Power Builder, Tuxedo, Oracle, HP Unix, Shell Script
• Designed, Implemented, Tested and Maintained PPS (Pre-Paid System) by supervising off-shore development team using Visual Basic, Oracle, C Programming, and Unix
• Took a charge of an IT representative of Pre-Paid Service Launching TFT and successfully supported TFT by solving the business problems, Acquired the biggest number of PPS subscribers in Korean market. Got a great achievement award in 1999 at the opening ceremony for 2000
• Did troubleshooting, diagnosed, installed, upgraded, configured application environment
• Trained call centre & retailers in making system/user manuals and making presentations
• Discovered Business Requirements of Data Warehouse/CRM System

Academic Project
Carnegie Mellon University, Pittsburgh, PA
Virtual Gift Card Project - American Eagle Outfitters (AE)
• Analyzed best practices in business process, functionalities, security and usability
• Designed Use Cases(UML), Sequence Diagram, Sitemap, Work Flow/Information Flow and Screens for virtual gift card on ae.com based on users’ requirements, Also, Implemented Prototype and provided security and extension solutions
• Suggested ready-to-implement level deliverables, which is expected to reduce cost by 33% of physical gift card and increase sales in total gift card by 60% at the end of 2005

Skills:
Skills:
Languages: C++, Java, UML, SQL, PL/SQL, Perl, VB, PB, Oracle Forms
Operating System: UNIX, LINUX, Windows 95/98/NT/2000/XP
Web Development: J2EE, J2ME, JSP, Servlets, Java Beans, PHP, HTML
Database: Teradata, Oracle, Microsoft Access, MySQL, Postgress
Applications: Teradata Utilities, MS Office, MS Project, Rational Rose, ER-win, Minitab

Certifications:
• Certification of Introduction to Oracle : SQL AND PL/SQL in 2006
• Certification of CMMI(Introduction Capability Maturity Model Integration) in 2005
• Teradata Basics V2R5 in 2001

Candidate Contact Information:

Name: Hye Young Kim
Street: -	Phone: 973-841-2212
City: Morristown	Fax: -
State: New Jersey
Zip:
Web Site: