SUMMARY:

• Proficient in T - SQL application development and supporting database analysis solutions, Extract, Transformations & Loads. Experience upgrading BI apps using the MS BI Suite (SSIS, SSAS, SSRS, Report Builder 3.0).
• Understanding of dimension modeling for RDBMS & OLAP (star & snow-flakes schema).
• Proven background working with users to understand and document business requirements as well as improving data quality. Very proactive Client/ Users Support management.
• Self-motivated, result-oriented, and excellent verbal and written communication skills.
• Local candidate, can interview and start a new project immediately.

TECHNICAL SKILLS:

Medical: HIPAA, ICD9X/10, CPT, NDC, NPI, HEDIS, UNOS, Transplant

Medical Databases: CRMS Mc Kesson, NextGEN, BioClinica CTMS, SIMS Claims Mgmt, TeleResults (TITUS)

Operating Systems: MS SQL Server 2008/R2/2012, Windows XP, Windows 7

Languages: T-SQL, XML, SAS

Business Intelligence: Microsoft BI (SSMS, SSAS, SSIS,SSRS), BIDS, Excel 2010/2013, PowerPivot, Report Builder, SharePoint

Others Softwares: MS Office 2010/2013, JIRA, Pivotal Tracker, Vault, SalesForce DESK.com, Google Analytics, Google Desktop, Web Outlook, Cisco VPN, Citrix

PROFESSIONAL EXPERIENCE:

Sr Data Analyst

Confidential

Responsibilities:

• Under supervision of Sr Titus Analyst, provided TITUS database support for the Transplant Department medical staff.
• Developed SQL ad-hoc reports (all Organs, many Transplant phases, many Medical conditions), trained new users.
• Executed specials projects: 1) Configured new Zebra labels printers used by the Post Kidney Transplant group with TITUS TrTubes module and Crystal Reports. 2) Updated mapping of the Quest Lab utilization lists interface with Titus test codes nomenclature 3) Developed SQL extracts to manage the USPS Mails and Emails addresses of Confidential listed Confidential ts. 4) Did “root cause analysis” investigation to fix missing data from dashboards.
• Monitored and updated daily Titus user’s access and Kaiser connectivity to HealthConnect

Softwares: SQL Server 2012, T-SQL, Crystal Reports XI, TeleResults TITUS/Presidio, ZEBRA Technologies.

SSRS/T-SQL Developer

Confidential

Responsibilities:

• Upgraded / Developed a dozen of SSRS reports for the MS Dynamics NAV ERP system; Included complex SQL Queries to DataWarehouse, parameters, visibility, sub-reports, drill-downs, exports to PDF and Excel.

Softwares: SQL Server 2008R2, T-SQL, SSRS, Report Builder 3.0, GoToMeeting.

Client Support Technician

Confidential

Responsibilities:

• Joined Confidential to address a 6 months old backlog of client’s tickets. Fixed and upgraded SSRS reports, SQL Store procedures; Provided fast, updated responses to user’s calls for assistance, rebuilding relationship with Clients of SIMS application. Developed skills with triggers, xml and multi-tasking.

Softwares: SQL Server 2008R2, T-SQL, SSMS, SSRS, Report Builder 3.0, Web Outlook, Vault, SalesForce DESK.com

SQL Developer

Confidential

Responsibilities:

• Participated in the REFACTORING of 100’s of Store Procedures for the Global E-Commerce development project. Participated in daily Agile/Scrum design meetings. Used JIRA to monitor progress and team-up with QA group.

Softwares: SQL Server 2012, T-SQL, SSMS, Visual Studio 2010, JIRA, Web Outlook

SSRS Developer

Confidential

Responsibilities:

• Developed SSRS Report for Accounting, using CTMS on-Point Clinical database and Account Payable as sources. Provided database Analysis for Data Sources Integration processes

Softwares: SQL Server 2008 R2, T-SQL, SSMS, SAS, Visual Studio 2008, SSRS, MS Excel 2010, PowerPoint, Web Outlook

SQL Data Analyst/IT Auditor

Confidential

Responsibilities:

• Developed T-SQL Ad-hoc Datasets Analytics for the HealthCare Provider Sunshine Act Compliance Audit.

Softwares: SQL Server 2008 R2, T-SQL, SSMS, MS Excel 2010/ Web Outlook/ EMC Documentum

SQL Developer/ QA Analyst

Confidential

Responsibilities:

• Developed a SQL module made of several Store Procedures, to PIVOT data coming from SalesForce Surveys file; Use Cursors, DYNAMIC SQL, System Store Procedures and Functions;
• Process successfully the CALNOC (Collaborative Alliance for Nursing Outcomes) submission for AUG, OCT & DEC 2012 in collaboration with the 2 Nursing Analysts from the Confidential Nursing Process Improvement Team.

Softwares: SQL Server 2008 R2, T-SQL, SSMS, Visual Studio 2008, SSIS, MS Office 2010/Excel/Outlook/PowerPoint

SQL Developer/ QA Engineer

Confidential, San Francisco, CA

Responsibilities:

• Joined a team of 6 QA Engineers to Audit & Debug hundreds of 2011 HEDIS measures for the Florida BSBC Insurer. Developed SQL scripts extract and aggregate records from Claims files to QC results generated by IMS Health proprietary software (HealhSmart Designer & HealthSmart Manager)
• Used PIVOTAL tracker to monitor progress/results with team members. Participated in bi-weekly AGILE/ SCRUM meetings under product manager leadership.
• The team was ed the NCQA 2012 HEDIS on March, 10th 2012.

Softwares: SQL Server 2008 R2, SSMS, T-SQL, SAS, PIVOTAL Tracker, Plastics, MS Office / Excel/Outlook 2010

Sr Database Engineer

Confidential, Berkeley, CA

Responsibilities:

• Tested / Upgraded 21 new SSRS reports for the BackOffice application before deployment. Provided assistance to Vietnamese development team to optimize SQL queries execution.
• Developed a new DataMapping MetaData repository for the BackOffice ETL processes ( loading of ODS Stagging tables from Client’s AS400 sources databases)

Softwares: SQL Server 2008 R2, SSMS, SSRS, T-SQL, TortoiseSVN, Excel/Outlook 2010, OneNotes 2010, Skype

HealthCare Data Analyst/SSRS Developer

Confidential, San Francisco

Responsibilities:

• Reconfigured SSRS ReportServer databases to separate reports using the PRODuction, TEST or TRAIN databases by updating Datasource & Datasets links as well as NEXTGEN connection strings (60 reports, 28 datasets)
• Updated, Executed & Designed T-SQL queries doing QC on the Confidential EMR migrations SQLServer .
• Developed new SSRS reports for the Healthcare Data Manager

Softwares: SQL Server 2008 R2, SSMS, SSRS, T-SQL, Excel/Outlook 2010, NextGEN

DATA/QC Analyst

Confidential, San Francisco

Responsibilities:

• Joined the DI to ACI Banking applications migration QC team to identify data discrepancies
• Loaded DI and ACI Mock files ( Corporate Banking and Business Banking) onto SQL Server DIMigration database
• Developed Ad-Hoc SQL queries to match Consumer, User, Accounts( ACH, Wired, Loan…), Officers, Branches from the Source and target application, and list outliers using OUTER JOINS
• Created QC reports using Excel and SSRS
• Provided technical support to Project Lead for Excel 2007 ( Formula and Macros)

Softwares: SQL Server 2008, SSMS, BIDS, SSRS, Excel/Outlook 2007

Sr Data Analyst

Confidential, San Rafael, CA

Responsibilities:

• Analyzed Class Action Claim Documents and Processed Securities Litigations Transactions E Claims files to calculate Shareholders Losses using T-SQL, EXCEL, and in-house packages.
• Eliminated a 6 months old backlog in 4 months, by implementing QA/QC actions and process automation.
• Lead a BI Dashboards comparative study with InetSoft, IDashBoard & Business Object Xcelsius for Confidential ’s Executives.

Softwares: SQL Server 2000, T-SQL, TOAD, DataJunction, MS Visual Studio, MS Office 2007

Information Data Management Analyst

Confidential

Responsibilities:

• ETL ANALYST and SQL developer on a project to build a data mart of Capitation Records from the 7 Insurances contracting with PAMF.
• Analyzed NCQA Pay for Performance Measures specifications to design Extract-Transform-Load logic for each quarterly file/member’s population.
• Programmed ETL process using Microsoft DTS, SSIS packages and T-SQL.