SUMMARY:

• Objective - c, iOS 6-11, Swift and Objective-C design patterns (4 years)
• React Native, Ionic & Angular.js & Xamarin (4 years)
• Expert knowledge of Swift 2, Objective-C, REST, XML, and JSON (4 years)
• Intimately familiar with iOS design patterns and coding conventions as well as Apple's Human Interface Guidelines and App Store Review Guidelines
• Expert understanding of networking, local data caching and multitasking on iOS
• 4 published applications in the iTunes Store
• Javascript & Java (6 years) native iOS Apps in Objective-C (4 years)
• Expert in Core Services, Media and Cocoa Touch frameworks, developer tools (Xcode), and workflows (both manual memory management and ARC, debugging, profiling, unit testing, continuous integration, provisioning, distributing and submission to the App Store)
• SQL Server, SSRS, SSIS, T-SQL, automated jobs (12 years)

PROFESSIONAL EXPERIENCE:

Mobile iOS/Apple Application Developer/SQL Server development DBA

Confidential, McKinney, TX

Responsibilities:

• Mobile native iOS App in Objective-C, React Native & Xamarin to provide portal for customer access to reports of test results.
• SQL Server 2k-2014 production/development dba, query/stored procedure/view/trigger development with complex T-SQL, SSIS, SSRS, ETL, BI, datamart (datawarehouse).

Mobile iOS/Apple & Android Application Developer/SQL Server development DBA

Confidential, Las Colinas, TX

Responsibilities:

• Mobile native iOS App in Objective-C/Android mobile app delivering access to Confidential customer service.
• SQL Server 2k-2014 production/development dba, query/stored procedure/view/trigger development with complex T-SQL, SSIS, SSRS, ETL, BI, datamart (datawarehouse).
• Developed C#.NET (asp.net) custom reporting application with SSRS against the SQL Server 2005 database and SQL Server 2005 OLAP datamart developed to support report denormalization and supporting ETL with
• SSIS, stored procedures and SQL Server Agent Jobs.
• Developed 30 custom reports with SSRS.

Contract Mobile iOS/Apple & Android Application Developer

Confidential, Frisco, TX

Responsibilities:

• Developed and implemented new Mobile iOS/Apple & Android Application reporting portal to present customer information to user community via internet with mobile-portal application.
• SQL Server 2k/2005 T-SQL (Transact SQL) stored procedure/query/udf development to support commercial scheduling application enhancements and support program development.
• Develop production query processes to update production databases and optimize stored procedures to solve performance problems.
• Corrected problems with Service Broker implementation. Develop SSIS packages/SQL Server ETL jobs to sync systems nightly.
• Used email2db program to gather customer information from various websites and process/save it to database.
• Developed new SQL Server 2005 database/stored procedures/queries/udf to support new application development integrated with existing commercial scheduling systems.

C#/SQL Server Developer

Confidential, Richardson, TX

Responsibilities:

• C#.NET 3.5/4.0, ASP.NET customer support portal programming with advanced javascript, to enhance client-facing customer portal with new drug/healthcare functionality.
• SQL Server 2008 R2 T-SQL (Transact SQL) stored procedure/query/udf development to support customer portal.
• Tortoise SVN used to manage source code.

Business Intelligence Developer

Confidential, Allen, TX

Responsibilities:

• VB.NET 3.5/4.0, ASP.NET reporting portal programming with SSRS 3.0 (SQL Server Reporting Services), javascript & DHTML, to develop client-facing report portals with security administration.
• SQL Server 2k, 2005 & 2008 R2 production/development dba for database design and T-SQL (Transact SQL) stored procedure/query/udf development to support reporting portals. SSIS 10.0 and database design/development to support ETL processes that populated reporting database from Oracle/IBM DB2 AS400 source via linked servers.
• Migrated SQL Server 2000 DTS to SQL Server 2005 SSIS both by full conversion and “wrapping”.

Programmer

Confidential, Denton, TX

Responsibilities:

• VB.NET 3.5/4.0, ASP.NET programming with Telerik web controls, datagrid, Jquery (javascript) and Telerik Ajax to develop mission critical “TeamTracker” application.
• SQL Server 2k, 2005 & 2008 R2 database design and T-SQL (Transact SQL) stored procedure/query/udf development to support GUI application and Microsoft Reporting Services (SSRS) 2008 R2 report web-portal development with SSIS 2008 R2 package development to support ETL (extract, transform, load) of reporting tables.
• Seventy five percent (75%) remote development of Reporting Services report webportal with TeamViewer 7.0 and VPN.

Programmer

Confidential, Frisco, TX

Responsibilities:

• Health care insurance benefits enrollment application development and client enrolment file processing with VB.NET/C#.NET 3.5 programming to create xls, edi 834 4010 and 5010 data files. SQL Server 2005 & 2008 R2 T - SQL (Transact SQL), SQL Server Agent, stored procedure/query development to support file creation and data manipulation, data integration processing, database maintenance, bulk inserts, SSIS packages, etc.
• SQL Server 2005 SSIS package and scheduled job creation and maintenance to support scheduled ftp/https and other file transfer processes to support 834 edi, and data integration processing and database maintenance.
• SQL Server Reporting Services (SSRS 2008) report portal development (ASP.NET and C#.NET) and deployment with associated stored procedures and supporting SSIS 2008 packages to support custom developed SSRS reports for Lawson Accounts Receivable application (Cloverleaf/MediAR). Developed custom SSRS reports with SQL Server 2008 R2 queries, stored procedures, views and user-defined functions against the Cloverleaf database schema for custom, detailed day-to-day reporting needs.
• Maintenance and enhancements to support client community with core Classic ASP benefits entry front-end application.
• VSS (TFS) - Visual sourcesafe used in a team (Team Foundation Server) environment.
• Remote support and application development over VPN and GoToMyPC.

Programmer

Confidential, Allen, TX

Responsibilities:

• VB.NET 3.5 Linq Xdocument (xml literals) to PDF fields population and Outlook extensions application development.
• LinqPad linq query development for objects. SQL Server 2008 R2 production/development dba, T-SQL (Transact SQL) and SSIS 2008 data transfer/translation between databases.
• Peter Blum Data Entry Suite development: validation/data entry.
• Remote application development with MS remote desktop through a TS (Terminal Services) Gateway server.

SQL Server 2005 Production/Development DBA

Confidential, Dallas, TX

Responsibilities:

• Develop Crystal Reports XI reports using MS SQL Server 2008 production/development dba, designed database and stored procedures (T-SQL), and Crystal Reports server for iPhone and managed offshore development of iPhone 3.0 webapp to display Crystal Reports on the iPhone.
• Developed ASP.NET 3.5 (html & css) (C#.NET 3.5 server application/VB.NET 3.5 administration application) Crystal Reports server for iPhone 3.0 webapp to support viewing Crystal Reports on the iPhone. Managed installation of SQL Server 2008 database, security implementation, created database schemas, index tuning.
• Used SSIS 2008 for index rebuilding monthly, and nightly database backup.
• Gather requirements, design and develop integration process (SSIS 2008), SQL Server 2008 database architecture to receive imported CSV files into Softrax Accounting system from CollabNet eCommerce website through Salesforce.com with and automated SQL Server scheduled job, BCP and stored procedures (T-SQL).
• User acceptance testing and unit testing done with Webex to communicate with personnel on local database and customer site in San Francisco, CA.
• Parallel development of this functionality with SSIS package into MS SQL Server Analysis Server cube for reporting purposes.
• MS Reporting Services reports developed to present cube data.