Shannen H. Le

626-***-****

Email: ad1gur@r.postjobfree.com

OBJECTIVE To build a successful career as ETL Developer/Database Warehouse Developer/SQL Developer/BI Developer/Data Engineer.

PROFILE Self-starter. Learns and adapts quickly. Ample self-confidence, work well under pressure.

High standards of performance.

EDUCATION

California State Polytechnic University, Pomona

Bachelor of Science Degree in Computer Information System, March 2004.

Mountain San Antonio College, Walnut

AS Degree in Accounting, Summer 1995

Secova Employee of the month on September 2004

SCAN HP Recognition best service delivery on April 2010

Relevant Courses:

Object Based Programming-Power Builder. Executive Support System.

Data Modeling System Analysis and Design.

Object Oriented Programming-SmallTalk. Management Information System.

Client/Server Application Development. Business Telecommunication.

Rapid Application Development Workgroup Support Systems

Structured System Analysis

TECHNICAL SKILLS

●Operating Systems: Windows 95/98/2000/XP/Win7/NT Server 4.0, FTP, and DOS

●Applications: SQL Server 2000/2005/2008/2010/2012/2017/2018/2019, MS Visual Studio 2005/2008/2010/2012/2017, Team Foundation Server 2012, Visual SourceSafe, Microsoft BI tools (SSIS, SSRS and SSAS), Power Builder, Visual Basic, Crystal Reports, Brio Enterprise, Sagent, RedBrick Data Warehouse, VISIO, ERWIN, MS-Project 98/2003/2013, Netscape Composer, FrontPage 98/2003, Power Mart/Informatica, Office 97/2003/2007/2010 (Excel, Access, Word, Power Point), CData

●Hardware: PC hardware, Printer, Networking

PROFESSIONAL

EXPERIENCE

Sr. Data Engineer, United HealthGroup/Optum Health, El Segundo, CA

06/2022 - current

●Using Microsoft BI suite, develop and test database scripts, store procedures, SSIS package to support system integration Enterprise Data Warehouse

●Data Integration extract inbound/outbound data load for (PeopleSoft/Pharmacy/Data Warehouse Daily Refresh/Capitation/etc) using SSIS in various file format text, csv, html, and excel.

●Research and analytics on data issue

●Using SNOW application (request and change ticket) and Rally for project assignment

●Using TFS for code versioning development

●Production On Call Support Data Warehouse SQL job

Sr. BI Developer, Carrington Mortgage Holding, Aliso Viejo, CA

05/2018-06/2022

●Using Microsoft BI suite, develop and test database scripts, store procedures, SSIS package to support system integration Enterprise Data Warehouse.

●Design, develop and deploy back-end systems to support reporting and database using SSIS source data from various format such table, excel, csv, access database, text, etc.for ETL process loading tables/view as Loan/LoanApplication/JIRA/ServiceDesk/GL.

●Create new reports and modified existing reporting using SSRS

●Using SSAS for create GL/JIRA/LoanOriginationPortfolio cube

●Migrate existing store procedure in SQL

●Support on service desk such as trouble shoot business user access and report issue and perform other duties as assigned

Data Analyst-HEDIS & Stars, Scan Health Plan, Long Beach, CA

02/2018-05/2018

●Designs and produces timely and meaningful analysis and data interpretation regarding large health care related datasets, related to 5-Star ratings, HEDIS,, state specific programs (such as QIP/PIP), programs issued by state agencies (such as DHCS or HSAG) and other associated company initiatives.

●Using SAS to extract Provider data to CMS auditor review.

●SQL, Excel and/other business intelligence tools to extract needed data. Writes original code and modifies existing code, as needed, to execute projects to specifications, and assists in the development of these specifications.

●Assists with development, implementation, and documentation of quality assurance (QA)

●Processes to ensure that reported data is accurate and reliable.

Sr. Data Warehousing Specialist, Scan Health Plan, Long Beach, CA

02/2008-01/2018

●Designing, developing and deploying both dimensional and relational models in a managed health care environment Data Warehousing and Data mart ETL processes using SSIS. Source data from various format such table, excel, access database, text, etc.

●Created Finance(Enrollment/MedicareRevenue/PremiumRevenue/DHCSPremium)/Claim/PDE/Pharmacy/Enrollment(membership info) cube using SSAS.

●Experience with Calinx/HL7 lab data source convert to load in Data Warehousing using SSIS.

●Experience working with Healthcare data (Lab, Claims, Auth, Encounter, Membership Eligibility, Provider Network Management, Pharmacy, PDE, Finance, and CMS (TRR/MMR/MOR/etc))

●Created report model for non-user sql writer building report using report builder.

●Experience with SQL view, SQL store procedure, update database tables, Query Analyzer, DTS, Enterprise Manager, SQL Server Agent, Team Foundation Server, Microsoft BI tools (SSIS, SSRS and SSAS), MS Visual Studio and Visual Source Safe

●Experience with data quality, standardization of data management processes, efficiency, expert in problem solving, working across departments and developing solutions that meet or exceed the needs of the organization.

●On call support job monitoring and troubleshoot production data load issue.

ETL Developer, Ultralink, Health Plan, Costa Mesa, CA

10/2003-02/2008

●Design, develop and validate reports using Crystal Reports version 8.5.

●Experience with Informatica ETL (data mapping, maplet, source and target), workflow manager, workflow monitor, data validation, data extraction for HRIS, payroll and carrier file.

●Informatica HIPPA format.

●Experience with SQL view, update database tables, Query Analyzer, DTS, Enterprise Manager and SQL Server Agent.

●Create and develop SQL DTS package to import/export source data as text file, excel, .cvs in/out database.

●Implement and design Data Warehousing and Data Mart ETL process using Informatica and also SQL Server Integration Services (SSIS).

●Standardize census data dictionary into one format.

Database Specialist, Korean Air, ITDC, Los Angeles, CA 09/2000-09/2003

●Design, development and maintenance database using SQL Server such as relational views, mapping data model, trigger, store procedure, DTS packages, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Server Agent, index table, data updates and constraint.

●Document and maintenance data dictionary contents.

●Experience with Sagent ETL and Sagent reporting tool.

●Mapping source data, target data and also maintenance database in Power Mart.

●Managing SQL Database Access and setup user account, monitoring, truncate SQL log for better perform on data retrieval and backup/restore database.

●Analyze data and creating the reports using Sagent Design Studio, Brio Enterprise and SQL Server.

●Software installation such SQL Desktop version, Sagent Design Studio Client, Brio Enterprise, Power Mart, etc.

●Procedure and documentation guideline the end user manuals on application.

●Conduct online Brio Enterprise and Sagent training on production application.

●On-call support for database problems and end user.

●Using VISIO to draw data flow and data diagram.

●Assist with data not import in the database.

●Create data integrity file to be reloading in the database.

MIS, Maxim Lighting International, City of Industry, CA

02/1998-08/2000

●Maintenance Fourth Shift Manufacturing database, design report.

● Network maintain: software upgrade, setup users, troubleshooting and supporting users on a daily basis (printer, Office applications), training employees on new software, daily tape backup.

●Special I. S. related projects such as create the report for management level.

●Using Crystal Reports for query and create reports.

●Create report and design database using MS-Access.

●Help end user enhance the accounting receivable/accounting payable, operation and also payroll issue.

●Create data flow and data diagram using VISIO.

●Experienced with 10 keys.

Research Technician, Avery Research Center, Pasadena, CA

9/1996-01/1998

●Perform basic online literature searching; Work with computer spreadsheets, data entry.

●Use Internet to download chemical & material information and monitor research sites.

●Contacted with other library system to get the sources.

●Using 10 keys for calculation.

●Help end user with computer problems such as MS-Office.

Technical Support, Dynamik System Services, Westminster, CA 06/1993-06/1996

●Install software, configuration PC, setup NT workstation.

●Help end user with computer problems such as report, MS-Office, printer, etc.

REFERENCE Available upon request

Contact this candidate