SUMMARY

• Extensive IT experience in hardware and software design, and systems development, integration and support.
• Technical expertise in front - end, middleware and backend (database) development.
• Experience with consuming Web services: Salesforce; Taleo; Jive; Concur.
• Extensive experience with EDI automation, processing, workflow management and troubleshooting.
• Extensive experience in SQL (2000/5/8/12/14/16 ), SSIS, SSRS, Stored Procedures, CTE, PL/ T-SQL scripts and procedures, Crystal Reporting, Business Objects, Tableau, Dell Boomi.
• Experienced in building and deploying integrated reports using Microsoft Reporting Services (SSRS).
• Experienced in using Transaction SQL (PL/T-SQL) to create complex Queries and Stored Procedures to import, transform and normalize data from Oracle, DB2, FoxPro, Access and other relational databases.
• Well practiced at analyzing and optimizing SQL tables, queries and indexes.
• Skilled at creating Database Schemas and designing Data Cubes in a SQL OLTP/OLAP environment.
• Excellent team member with outstanding leadership skills.
• Self-starter and takes pride in completing projects on time and under budget.

TECHNICAL SKILLS

• N-Tier software Design
• Database Design
• Tableau
• SSRS
• SSIS
• ASP/ASP.NET
• ADO
• ADO.NET
• RDO
• DAO
• ODBC
• SOAP
• XML
• Ajax
• Oracle
• MSQL
• PL/SQL
• T-SQL
• Powershell scripting
• VSTO
• SharePoint
• OLTP
• OLAP
• Web services
• JSON
• Jitterbit Studio
• CommVault
• Idera

PROFESSIONAL EXPERIENCE

Confidential, CA

SQL/ETL Developer/DBA

Responsibilities:

• Created SSIS package to automate data archiving from multiple tables to corresponding archive tables based on configuration table values.
• Created reports that drilled down to other reports and exepted input to document the data environment and processes.
• Implemented process to collect, track and report on SQL job progress, success and failures.
• Created Reports to track SQL Job Failures and Resolutions based on error codes.
• Created Packing Slip reports for shipping integration.

Environment: Windows 8/10; Oracle 11g; DB2; MSSQL 2008r2; MSSQL 2012/14/16; Microsoft Visual Studio 2017; SSIS 2016, SSRS, SharePoint, Idera, Kanban, HyperV, Veam; TruckMate; Scale

Confidential

SQL/ETL Developer/DBA

Responsibilities:

• Designed and Built Datamarts to increase report availability and performance.
• Designed and created SSIS packages to pick up and process "837" formatted medical claims files.
• Automated EDI Import processing and Response.
• Automated ODAG, MTR, Part C, PDR and other Healthplan Audit reporting.
• Implemented process to collect, track and report on SQL job progress, success and failures.
• Created Reports to track SQL Job Failures and Resolutions based on error codes.
• Upgraded EzCap to version 6.5.2
• Increased performance of Authorization Letters report from 1.5hrs to less than 8mins.
• Automated Denial Letter Creation and printing.
• Automated Authorization Letter creation and printing.
• Applied patches to EzCap and Essette.

Environment: Windows 7/8/10, MSSQL 2008r2; MSSQL 2012/14/16; Microsoft Visual Studio 2014; SSIS 2016,Tableau, MS Access, Idera, SpiceWorks; HyperV, Veam; EzCap; Essette; Webgoods; Aerial.

Confidential, CA

SQL/ETL Developer/DBA

Responsibilities:

• Designed ETL processes using Jitterbit Studio for use in patient/healthcare data collection and distribution.
• Designed ETL processes using Jitterbit Studio to manage healthcare application data and processes.
• Created custom monitors to track errors and metric thresholds from data collection and distribution processes using Idera.
• Managed backup, restore, security and data governance for over 250 SQL Server and Oracle databases of various versions.
• Created scripts to gather administrative data from over 250 Healthcare database servers simultaneously.
• Created, designed and supported ETL processes using Microsoft SSIS packages to transform Healthcare data.
• Database administration of over 250 SQL and Oracle databases that managed Healthcare data.
• Created and supported custom Visual Studio .NET objects in SSIS for patient data.
• Managed PGP encryption and keys for incoming and outgoing ETL processes containing PHI and PII.
• Created, Managed and supported EDI processes for various healthcare vendors.

Environment: Windows 7/8, Oracle 10g, 11i, 11g, MSSQL 2008r2 - 2016; Microsoft Visual Studio 2014; SSIS 2005 -2016, Idera, Nagios VMware, LANDesk, CommVault, Aqua Data, Epic, HL7, Mobile Heartbeat, Kronos, Healthcare and Patient data, Business Objects, FDA, HIPPA Compliance, data governance

Confidential, CA

SQL/ETL Developer

Responsibilities:

• Designed ETL processes using SSIS for financial data warehouse workflow.
• Designed ETL processes using SSIS for use in financial data collection and distribution.
• Designed ETL processes using SSIS to manage financial application data and processes.
• Designed and developed SQL data structures to service frontend web application.
• Created and managed EDI processes for sharing credit reporting data Experian.
• Created and managed EDI processes for sharing Financial data with Confidential partners and applications.
• Supported Development of a .NET Website to service Solar Customers.
• Designed infrastructure and processes to track metrics produced by data collection and distributions processes.
• Created custom monitors to track errors and metric thresholds from data collection and distribution processes.
• Managed backup, restore, security and data governance for SQL Server 2008 and 2012 databases.

Environment: Windows 7/8/10, MSSQL 2012; MSSQL 2014; Microsoft Visual Studio 2014; SSIS 2005 - 2014, VMWare, Powershell

Confidential, CA

ETL Developer

Responsibilities:

• Created scripts to determine what Jobs are running on what servers and whether the Job is running SSIS packages or Stored Procedures.
• Create SSIS package to parse and Normalized patient data from a HL7 formatted flat file.
• Import and export healthcare data from SFTP sites using SSIS.
• Import patient and healthcare files into SQL DB using SSIS.
• Import healthcare data from remote Oracle DB to SQL Server DB.
• Performed referential Integrity checks on SQL tables using SSIS.
• Create and distribute Medical admissions and Discharge data using SSIS to an Interactive Voice Response system.
• Created tracking system to track the execution and results of SQL jobs and SSIS packages across multiple SQL Servers.

Environment: Windows 7/8, MSSQL 2008 R2; MSSQL 2014; Oracle, Business Objects, Crystal Reports, Microsoft Visual Studio 2014; SSIS 2005 - 2014, Easy Cap, Optum, HL7 Asset

Confidential, CA

SQL/ETL Developer

Responsibilities:

• Created SSIS packages to Manage Financial data and Transmit data to Vendors.
• Designed and developed SQL data structures to service frontend financial web application.
• Supported Development of a .NET Website to service Solar Customers.
• Managed backup, restore, security and data governance for SQL Server databases.

Environment: Windows 7/8, MSSQL 2008 R2; MSSQL 2014; Microsoft Visual Studio 2014; SSIS 2005 -20014

Confidential, San Diego, CA

SQL DBA/Developer

Responsibilities:

• Planned, designed, optimized and developed Integration processes using Dell Boomi.
• Created processes to create Expense report entries in Concur using Concur Webservice, SQL data and Dell Boomi.
• Managed EDI process from SalesForce and Taleo Web Services into Process Peak using Dell Boomi.
• Created process to Insert, Update and Delete user properties in Jive using Jive Web Service and Dell Boomi.
• Created processes to manage workflow integration between in-house and online platforms: MSSQL, SalesForce, Jive, Taleo, Process Peak, Concur, Onyx and Matrix using Dell Boomi.

Environment: Windows 7, MSSQL 2008 R2; Microsoft Visual Studio 2008; XML; SOAP; JSON; REST; Concur; Taleo; Jive; Salesforce; Jira; Process Peak, Dell Boomi

Confidential, Irvine, CA

Business Intelligence Developer

Responsibilities:

• Planned, design optimized and developed Visual Studio 2008/2012 SSIS packages to extract transform and load data to data warehouse tables, external clients and Tableau DataMart’s.
• Created technical design requirements and specification documentation based on business requirement documents.
• Imported client data from Excel, XML and CSV files.
• Used SSIS to create client data feeds to deliver via FTP.
• Maintained ETL for Star Schema data warehouse tables.

Environment: Windows 7, Windows 2008 Server, Active Directory; MSSQL 2005/2008/20012 ; Microsoft Visual Studio .NET 2012, Visual Source Safe, HTML, XML, Citrix, Hadoop, OLAP/OLTP, Tableau, GIT HUB, SSRS, SSIS

Confidential, Orange, CA

Business Intelligence Developer

Responsibilities:

• Planned, design and developed Visual Studio 2008 SSIS packages to extract transform and load Healthcare data to data warehouse tables.
• Created technical design requirements and specification documentation based on business requirement documents.
• Designed data model based on flat file design specifications to import fixed length healthcare financial data.
• Performance tuned views and stored procedures and tables based on the data model of the Healthcare data warehouse.
• Used Citrix virtual machine to execute and manage SSIS packages and data.
• Worked with large healthcare files greater than 25gb in size.

Environment: Windows 7, Windows 2008 Server, Active Directory; MSSQL 2005/2008; Microsoft Visual Studio .NET 2008, HTML, XML, Citrix

Confidential,Irvine, CA

Business Intelligence Developer

Responsibilities:

• Planned, design and developed Visual Studio 2005 SSIS packages to extract transform and load financial data to data warehouse tables.
• Managed projects for full life cycle team development efforts (9-12 team members).
• Created technical design requirements and specification documentation based on business requirement documents.
• Designed data model based on Business Objects financial Data warehouse Universe.
• Performance tuned views and stored procedures and tables based on the data model of the data warehouse.
• Created TSQL scripts to manage project releases, changes and migrations.
• Performed technical reviews for code design and QA.
• Provided weekly and off-hours technical support for data warehouse and reporting.

Environment: Windows 7, Windows XP, Windows 2003/2008 Server, Active Directory; MSSQL 2005/2008; Microsoft Visual Studio .NET 2005, HTML, XML, Business Objects, MS Share Point, Crystal Reports 2008