Experience

Purdue Federal Credit Union

• United States
• Banking
• 100 - 200 Employee

• Senior Database Administrator

  • Jul 2015 - Present

  1). Support the organization's database environments. a). Manage and monitor database for performance, optimization and stability. b). Implement data architecture standards across all databases. c). Develop SQL scripts, functions, stored procedures, and views. 2). Develop BI solution to support organization's decision-making. a). Design conceptual, logical, and physical data models. b). Create data warehouse using SSAS. c). Develop reporting using SSRS and PowerPivot. d). Develop ETL using SSIS Packages.



IMG (International Medical Group)

• United States
• Insurance
• 300 - 400 Employee

• Database Administrator, Database Software Engineer

  • Sep 2007 - Jul 2015

  1). Provide SQL Server database administration functions that support IMG’s products and business. a). Responsible for database administration, performance tuning, backup, restore and troubleshooting activities. b). Proficient in performance monitor, SQL profiler, Dynamic Management Views and third party tools etc. to monitor server and database. 2). Provide database design direction, development support and be a key player in sharing the techniques used to design databases. a). Ensure database architecture, design, and technological decisions are driven by a clear focus on the business needs and the future roadmap. b). Develop, improve and enforce database development standards. c). Write SQL code and .NET CLR for database access, modifications, and constructions including queries, triggers, stored procedures, user-defined functions, and views. d). Develop tools with C#, VB.NET to facilitate data loading, database management, and other applications. 3. Perform data acquisition functions. a). Develop and improve the guideline and strategies for ETL process in IMG. b). Document the SSIS development standards. c). Develop and maintain SSIS and DTS packages to perform ETL. 4. Perform data analysis and data modeling functions. a). Develop and maintain Enterprise Data Warehouse (EDW) with SSAS. b). Design and develop business intelligence reports with SSRS.