Post Job Free

Resume

Sign in

Sql Server Developer

Location:
Tustin, CA
Salary:
95000
Posted:
January 20, 2017

Contact this candidate

Resume:

PROFESSIONAL INDUSTRY EXPERTISE

Healthcare

Electronic Eligibility and Claim Processing, EHR Certification, Erp systems, Treatment file standards, Grievance, Hipaa privacy and security rules

Accounting

Basic accounting system, payroll, and inventory.

TECHNICAL SKILLS

SQL/Relational Databases

Microsoft SQL Server 2008 2008 R2 and 2012. SQL Server Management Studio and SSIS (SQL Server Integration Services). Report generation thru SSRS. Excel result from SSAS (OLAP), SQL Profiler for debugging/performance tuning. Extensive experience in database design, writing and tuning T-SQL triggers, stored procedures, functions, views and user defined functions.

Magic eDeveloper/uniPaaS

Magic eDeveloper versions 7 through 9 as well as UniPaaS. Add something else relevant for Magic/uniPaaS

Methodologies and Programming Languages

Agile/Scrum and Waterfall methodology as it pertains to software development lifecycle. Microsoft SQL Server (2008-2012), Magic eDeveloper (versions 7-9) and UniPaaS. XML, HTML, ASP.NET, C# and Microsoft Silverlight with Component one.

PROFESSIONAL EXPERIENCE

Glidewell Dental 2/2016 to present

Irvine,m CA

BI Developer

Secured some sensitive data information like customer name, addresses,ssn and credit cards by using a third party software called IDERA. IDERA software is recognized as a HIPPA compliance software.

Maintain SQL server databases backup, index, clean up and monitor SQL server health

Daily monitoring of SQL jobs, replication, available disk space and Attunity sync.

Goal to removed or replace sa login, remove user with sysadmin and consolidate multiple SQL servers into 1 server.

Optimized the batch process that involved big data. Re-wrote the sql script to process by batch with delay to avoid high used of memory and avoid using all the resources.

Sync data from SQL server into the Cloud using Attunity. Modified or create Views using Redshift and,RazorSQL which will later be posted to the Cloud for Tableau Reporting.

Used PostresSQL and worked on JSON data with millions of messages being imported and then deleted. Involved manual vacuum of table or group of tables.

Maintain the daily SQL jobs that run vacuum analyzer on the cloud.

Comppartners

Irvine, CA

DBA/SQL Developer 8/2014 – 2/2016

Addressed outstanding ticket/log by fixing the SQL script logic and, fixing Data.

Monitor and Maintained SQL server database performance using Spotlight and Foglight tools.

Asp.net, C# and Microsoft Silverlight component one developer.

Maintained web services like validate Patient address location, stored and retrieved private and important document thru Amazon.

Maintained billing report accuracy thru OLAP and MSWord templates.

Often used SQL Profiler to trace block or lock process, analyzed CPU usage ratio and read data ratio per SQL statement execution.

Maintained DTS SSIS package which came from different sources like Dbase, excel, csv and fixed width text file. This was scheduled to run every night and it's data are so important to calculate billing and invoice.

Modified or create SQL scripts like stored procedure, function and trigger for bug fixing or enhancement.

Western Dental Services, Inc; Orange, CA 9/2009 – 7/2014

Senior SQL Developer

Added features that every changes on the claim, procedure or treatment must be approved or signed by Prescribed Dentist. This feature were added for the HIPPA compliance.

Played a major role in the SQL table schema designed, defined the relationship of the Western Dental Member subscriber, dentist, group, firm, offices and claim procedures. Was also involved in the migration of the pervasive database into SQL database.

Involved on data modelling design which include linking the existing data model from other resources and come out with better data structure with no redundancy and as much as possible avoid using de-normalization. Used Visio and Case software application tools for the design.

Wrote T-SQL scripts with some web service connections to bring up the nearest Dental offices based on Subscriber's address and radius. Wrote SQL Triggers to create an audit trail of some transaction table. This will help end-user to monitor or keep track of who made some changes to a record and when.

Used SSIS to read and import employee information in excel file. Wrote a stored procedure that will call the SSIS Command line to capture the data from Employee excel file and saved it to temporary table and then do a necessary update on the master table. Added this stored procedure to the SQL Server agent and schedule to run every night.

Wrote a SQL stored procedure and function that will dynamically build a SQL script command that will copy the data from one temporary table (Snapshot) into the actual SQL Table or vice versa.

Wrote complex T-SQL scripts that will call 2 or more stored procedure and SQL function. Used multiple BEGIN TRY & BEGIN CATCH specially when dealing with record update, insert record or deletion within the stored procedure. Developed a stored procedure to record any error that may occur and send email to developer.

Involved in a production database backup. Refresh the test database for developer, and staging database for QA tester.

Wrote a T-SQL that will import member eligibility CSV file, validate data accuracy and then do an update on the master member table. The member eligibility csv file came from approx. 26 different sources called Group Carrier and they may have the same or different CSV format layout. So, I have written a T-SQL Importation for each group carrier and a standard SQL stored procedure that will do the validation and update.

Data warehousing experienced. Wrote a T-SQL and SSIS to capture the monthly or daily subscriber eligibility information that came from 25 different Group of Companies. The eligibility file have 2 different format (EDI or 834) and they are being fed to the main database so Benefits management team can able to produce a report of how many member eligible for a certain group for certain Office branch, or for all Western Dental.

Used SSAS to optimized huge utilization transaction claims data to get a quick result on reporting the claim done by particular Doctor, by State, or by office.

For HIPAA project, wrote a SQL Script to access website service online from 3rd party company database to retrieved list of Health Issue, Vital, Allergy and medical history.

Wrote a SQL script to access website service online to get the nearest Western Dental office location based on Subscriber address and radius.

Wrote a SQL script to access the map quest web service online based on Subscriber Address.

Wrote SSAS cube to easily get a quick information on Count number of member by facility, Group Benefits, or per State. Count Procedure per facility / Group Benefits or per State and vice versa. Output was generated in Excel.

Developed a SQL view so end-user can access it using MS Excel, and created a SSRS report using MS Visual Studio. I have often used SQL statement as a source script for SSRS Report.

Below aresome SSRS Report that I have developed;

1. Subscriber Eligibility Listing that can be range by either As of Date, eligibility Status, Group of Company, and office branch.

2. Dependent reaching 18 years of age Listing. This report can be range by As of Date, Group of Company and Plan.

3. Facility Roaster - Calculated premium, copayment and agent commission report.

Vadim Software, Kelowna, BC/Canada 4/1998 – 5/2009

SQL Developer

Played a major role in development and support of the following local municipality accounting module using MS-SQL database and Magic as front-end interface. Below are list of module;

1. Cash Receipting 4. General Ledger

2. Property Tax 5. Accounts Payable

3. Business License 6. Account Receivable

Responsible for the upgrade of MS SQL from 6.5 to SQL 2000.

Wrote complex T-SQL stored procedures for posting a payment. Every time teller from Cash Receipting accepted a payment from customer that payment information will go to the SQL job queue in the SQL Server Agent. The T-SQL script that i have developed is to fetch the un posted SQL job (based on FIFO ) and then apply the payment from oldest balance first up to the current balance, calculate interest or penalty if applicable, update the customer ledger and populate the batch balancing information.

Wrote complex T-SQL stored procedures that based on the Tax land jurisdictions number, it will capture all property tax owner information and then calculate tax levy based on its assessment, add land tax improvement and then print tax notice. (Tax Notice printing was done using Magic software tool).

Developed a weekend cleanup of database. Drop and re-create table indexes, dropped unused temporary table, update transaction table statistic and cleaned up SQL job queue.

EDUCATION

Bachelor of Science, Computer Science

Central Colleges of the Philippines

1993

Sample SSRS Report Generation

https://www.youtube.com/watch?v=v2igaaJ-SAM

OTHER

Fluent in English and Tagalog



Contact this candidate