Sql Server Project Manager

YONG CHOI

***** ****** *******, **********, ******** 20874

C) 301-***-**** ************@*****.***

Abstract

• Results-oriented database architect with extensive experience in data warehousing, database marketing and data integration

• Independently developed an advanced Customer Data Integration (CDI) system

• Fluent in all aspects of system development, data warehouse design, data modeling, and project management

• Implemented data warehouses for companies in a variety of industries such as insurance, banking, finance, and education

• Excellent ability to work as a leader as well as an individual contributor

• Savvy and passionate about numbers, market indicators, and metrics to translate hard data into insight and action

• Enthusiastic, self-motivated, dedicated employee with a strong work ethic

Experience

DataLab USA Germantown, Maryland

Database Architect / Project Manager 2007 – Present

• Independently developed an advanced Customer Data Integration (CDI) solution

Assigns unique and persistent identifiers to disparate data

Creates a complete, accurate, single view of the customer data

Enables companies to readily identify, collect and update customer and prospect information

Allows a customer to be identified regardless of address changes, name variations or name changes over time

Utilizes a matching technique called Data Explosion to minimize false negatives / false positive matches

Reduces inefficiencies and costs associated with customer data collection and management

Allows for improved database marketing and customer relationship management

• Designed and implemented multiple enterprise level Marketing Data Warehouses and Prospect Data Warehouse

• Automated ETL processes and mapping using SQL Server Integration Services (SSIS)

• Developed custom reports using SQL Server Reporting Services (SSRS)

• Created workflow, procedural and documentation standards designed to increase efficiency and productivity

• Designed Quality Management Systems (QMS) to capture procedures and provide quality guidelines

• Automated ETL processes and mapping using SQL Server Integration Services (SSIS)

• Developed custom reports using SQL Server Reporting Services (SSRS) and Crystal Reports

• Defined an architecture of a Decision Support System using SQL Server Analysis Services (SSAS)

• Created workflow, procedural and documentation standards designed to increase efficiency and productivity

APS Healthcare Silver Spring, Maryland

Data Analyst 2007 – 2007

• Provided data warehousing and application development solutions for health plan administration

• Improved and streamlined processes regarding data flow & data quality to improve data accuracy, viability, and value

• Performed complex analysis and reporting of health care data including health care provider and consumers

• Provides thorough, accurate clinical data research, analysis and interpretation of patient and provider data

• Provides research tools, strategies and data analytics

DataLab USA Germantown, Maryland

Technical Lead / Data Analyst 2005 – 2007

• Developed and managed multiple direct marketing programs for companies in a variety of industries

• Evaluated comprehensive business processes and requirements

• Performed in-depth data analyses and forecasted various marketing trends

• Managed complete life-cycle of database marketing projects from design to implementation

• Defined project priorities, scope, approach, and resource requirements as a team lead

USinternetworking Annapolis, Maryland

Database Application Specialist 2004 – 2005

• Provided Tier 2 - 3 level support to Siebel and PeopleSoft clients

• Monitored and evaluated program effectiveness and made changes required for improvement

• Wrote Product Documentation (end-user manual) for enterprise product

• Increased IT productivity by creating remote solutions to most problems

Otsuka America Pharmaceuticals, Inc Rockville, Maryland

IT Technician 2002 – 2003

• Handled system installation, maintenance, and upgrades

• Provided advice to staff, ensuring productive use of the company's IT software and hardware

• Administered and maintained end user accounts, permissions, and access rights

• Designed and implemented the server roles for domain controllers, anti-virus, backup, printers, database and files storing

Myong-In C&C Seoul, Korea

Data Analyst 1998 – 1999

• Responsible for translating and documenting business needs into technical requirements

• Analyzed financial data and conducted exploratory statistical analysis

• Lead development of logical and physical data models

• Created and managed databases used for target marketing and customer behavior analysis

• Performed geographic data analysis, mapping, and market penetration analysis

• Created detailed test plans based on analysis of vendor requirements

• Planed and coordinated release of database upgrades

Education

University of Maryland, Baltimore County Baltimore, Maryland

Master of Science, Information Systems GPA: 4.00 2003 – 2004

University of Maryland, Baltimore County Baltimore, Maryland

Bachelor of Science, Information Systems GPA: 4.00 2000 – 2003

Industry Experience

• Banking • Insurance

• Finance • Education

• Health Care • Marketing

Skills

• Microsoft SQL Server 2000, 2005 & 2008, Oracle, MySQL, MS Access, MS Visual Foxpro

• DTS Packages, SQL Server Integration Services (SSIS)

• SQL Server Reporting Services (SSRS), Crystal Reports, SQL Server Analysis Services (SSAS)

• Visual Basic .NET, VBA, C++, HTML, Altiris, Erwin, Subversion, MS SourceSafe, MS SharePoint, MS Project, MS Visio

• Data Warehousing, Project Management, Data Modeling, Data Mining

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate