Paul Chu Email & Phone Number

To provide technical support for clinical data managed and analyzed. Responsible for gathering, analyzing, and maintaining all data requirements related to the business and Clinical EDI Data Management in order to provide technical support for clinical CMS claim department. •Assist with report creation, ETL & SQL scripting, and the maintenance of all reporting databases And reporting environments• Worked on complete life cycle from ETL of data using T-SQL Statement and SSIS.• Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from DM, flat file and excel file.• Created ETL Stored Procedure using several transformations to perform Data profiling and Data Transformation (X12 , EDI 837I , 837P & 834).• Analyzed the clinical information table data to verify the CMS result process and track the input Encounter files to present the result in SSRS report.• Good experience in supporting integrity and security of data in corporate databases.• Experience in importing a Big Data with over millions provider record in warehouse system.• Responsible for creating the stored procedure and function affecting data and report process.• Created power-shell scripts to manage SQL server administration. • Served as GE Centricity administrator to solve system management issue.• Developed the ETL package using Repository Explorer.• Maintained EMRLink system (Labcorp &quest diagnostics test process)

Programmed and created SQL stored procedure, function and object view using MS SQL and Crystal reports for Clinical reporting. Managed metrics reporting, including gathering requirements, flow chart creation, design, coding, interface implementation, estimates, testing in Clarity Database (EPIC system).•Worked with functional team to determine reporting needs for the report consumers.•Maintained and Designed SQL procedure, function and view object to provide reporting solution for various reporting (operations and clinical reports)or extract need.•Developed the SSIS package for data integration or migration purposes; Created mappings/workflows to extract data from SQL Server.

Foster City, Ca 94404

Business Analyst / Programmer Managed a large-scale SQL database server to support over 200 Healthcare industry clients. Responsible for all project lifecycle phases, form specifications and coding through testing deployment, debugging, documentation, planning, implementation, configuration, maintenance and administration of relational database management systems (DBMS).Key projects include: Clear Quest Integration, Crystal Report Manager, Reporting Service and PHILIPS Healthcare application System and Database administrator• Enhanced database performance; developed and wrote Standard SQL designs; created database model and reporting services (SSRS); created SQL objects e.g. procedures, views, indexes, triggers, defined data types and functions.• Designed SSIS integration packages using business intelligence development studio BIDS. Completed Clear Quest SSIS Integration project results in a reduction of customers need for multiple network access to reduce online or 30 % of extra work required to track the Clear Quest ticket status.• Administered 300,000 customer records (Heat ticket application system) and designed UI application; created deployment plan; supported staff to quickly respond to customer requests.• Developed disaster-recovery plan for large manufacturing production database, which delivered solutions that, guaranteed recovery performance and high availability (mirroring & transaction log).• Worked with QA manager to identify gaps and data mapping issues in existing reports and designed matrix reports from disparate databases, enabling manager to quickly identify ticket requests. • Served as DBA administrator in completion of large-scale database integration process including data migration project.

Newark Ca

Software Engineer Developed programming for WinForm and Web based application. Key projects include: Next Generation insurance web application, ALM database management application, Team Foundation Team Server project, Continuous Integration build project• Developed software for project planning, data analysis, user interface design, coding and test plan.• Created (ETL) database package.• Tuned the database storage procedures; troubleshot assistance with application service.• Created client server web-based application using Visual Studio.NET; designed dynamic UI design; built auto deployment process and simple to complex T-SQL queries including the data access object pattern to provide access for a particular data resource.• Developed Winform application using Visual C#; designed backup for large customer database using stored procedure and blowfish technology as well as multithread method to speed up the large scale database (60 gigabytes), encryption & decryption process. • Planned, designed and implemented the TFS build project. Provided a reliable build process for developers to integrate instantaneous builds and involves unit tests and code analysis. Notifies build master who checked in broken/invalid code for reducing integration problems. Debugged build issue, web deployment and IIS configuration.