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 in SQL (2000/5/8/12/14 ), 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, 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

• Data driven web projects
• N-Tier software Design
• Development
• Security and Integration
• Database Design
• Construction
• Conversion and Tuning
• Report Development and Integration
• MS SSRS
• SSIS
• ASP/ASP.NET
• ADO
• ADO.NET
• RDO
• DAO
• ODBC
• SOAP
• XML
• Ajax
• Oracle
• MSQL
• PL/SQL
• T-SQL
• VSTO
• SharePoint
• OLTP
• OLAP
• Web services
• JSON

PROFESSIONAL EXPERIENCE

Confidential, Anaheim, CA

SQL Developer

Responsibilities:

• Designed ETL processes using SSIS for data warehouse workflow.
• Designed ETL processes using SSIS for use in data collection and distribution.
• Designed ETL processes using SSIS to manage application data and processes.
• Designed and developed SQL data structures to service frontend web application.
• Supported Development of a .NET Website to service Solar Customers.
• Designed an infrastructure and process stack 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 and security for SQL Server 2008 and 2012 databases.

Environment: Windows 7/8, MSSQL 2012; MSSQL 2014; Microsoft Visual Studio 2014; SSIS 2013/2012/2008/2005

Confidential

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 data from a HL7 formatted flat file.
• Import and export data from SFTP sites using SSIS.
• Import files into SQL DB using SSIS.
• Import 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 2013/2012/2008/2005

Confidential, Anaheim, CA

SQL Developer

Responsibilities:

• Created SSIS packages to Manage Financial data and Transmit data to Vendors.
• Designed and developed SQL data structures to service frontend web application.
• Supported Development of a .NET Website to service Solar Customers.

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

Confidential, San Diego, CA

SQL Developer

Responsibilities:

• Planned, designed, optimized and developed Integration processes using Dell Boomi.
• Created processes to create Expense report entries in Concur using Concur Web service SQL data and Dell Boomi.
• Imported data 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

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 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 data.
• Performance tuned views and stored procedures and tables based on the data model of the data warehouse.
• Used Citrix virtual machine to execute and manage SSIS packages and data.
• Worked with large files greater than 25 GB 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 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 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

Confidential, San Bernardino, CA

Software Developer

Responsibilities:

• Planned, design and developed ASP.NET site to manage, archive and distribute data and reports.
• Reviewed business intelligence tools to determine the technology that best fit their reporting needs.
• Designed data model based on function and utilization of data warehouse.
• Performance tuned views and stored procedures based on the data model of the data warehouse.
• Implemented Infragistics third-party controls in Visual Studio 2005, 2008 and 2010 for ASP.NET.
• Managed documentation for code changes and code version releases using MS Team Foundation.
• Managed Report Subscriptions in SSRS and SharePoint.
• Created User Defined Functions to handle common tasks within stored procedures.
• Created dashboards to display monthly and weekly metrics using SharePoint widgets and key indicators.
• Worked with business to develop data warehouse methodologies, processes and rules.
• Used MS SSIS to import and transform data for data warehouse.

Environment: Windows 7, Windows XP,Windows 2003/2008 Server, Active Directory; MSSQL 2005/2008; Microsoft Visual Studio .NET 2008-2010, ASP 3.5/4, HTML, VBScript, JavaScript, Ajax, Infragistics, XML, Microsoft Team Foundation 2010, Microsoft Reporting Services (SSRS), MS SharePoint, VSTO 2010

Confidential

Software Developer

Responsibilities:

• Worked with business to design web based lot history record app enhancements.
• Worked with business to identify, test and correct web based lot history record app bugs.
• Implemented code changes for bug and web based lot history record app enhancements in accordance with FDA regulations.
• Managed documentation for code changes and code version releases in accordance with FDA regulations
• Provided high-level support for manufacturing personnel using eLHR web application.
• Provided 24/7 emergency support for production eLHR web application.

Environment: Windows XP, Windows 2003 Server, Active Directory; Oracle 10g; Microsoft Visual Studio .NET 2005, ASP 2.0/3.5, HTML, VBScript, JavaScript, Ajax, Camstar Insite, XML, Visual Source Safe, Remedy, OLAP/OLTP

Confidential, Foothill Ranch, CA.

Software Developer

Responsibilities:

• Migrated Access Database to SQL 2005.
• Created and maintained T-SQL scripts and procedures.
• Used SSIS to transform, schedule and maintain reports and data migration.
• Created ASP.NET application to replace Access forms.
• Created Reporting Services Reports to replace Access reports.
• Implemented, tuned and debugged enterprise apps on IIS
• Installed and configured Microsoft Reporting Services (SSRS).
• Created ASP.NET application to display training information based on Active Directory security groups.

Environment: Windows XP - Windows 2003 Server - Active Directory; MS SQL 2005; Microsoft Visual Studio .NET 2005/2008, ASP 2.0/3.5, HTML, VBScript, JavaScript, Ajax, Citrix, Access, OLAP/OLTP