SUMMARY:

• 1 7 yrs designing and implementing relational databases and database applications.
• 8 yrs object - oriented multi-tier development: UI, business logic layer, data access layer, and data layers.
• Excels in analytical, critical, and creative thinking, enjoys problem solving.
• Excellent oral and written communication skills.

LANGUAGES AND SKILLS:

Languages: SQL/T-SQL, C#, J avascript, JSON, XML

Back: end SQL Server, Entity Framework, IIS, Windows Services, MySql

Front: end ASP.NET, MVC, WebAPI, REST, WCF, Javascript, AngularJS, JQuery, AJAX, HTML, CSS

Technologies: OOP, Visual Studio /TFS, IOC/DI containers, GIT, A WS, Bootstrap, Agile, Jira

Other: Security Clearance

EXPERIENCE:

Confidential, Torrance, CA

Senior Software Engineer

Responsibilities:

• 3 months Angular development for new forms - javascript, html, css, WebApi endpoints, C#.NET business layer, and MySql stored procedures.
• 9 months Webforms development, both new forms and maintenance, including new features and bugfixes.
• Worked with off-shore dev team & in-house development team via Agile w/ daily scrum.
• Used Github for source control, Jira for Agile.
• Main site/business is payment processing for group/organization membership. Did all development for the largest new client, United States Air Force (USAF) for their club memberships.

Confidential, Marina Del Rey, CA

.NET Developer

Responsibilities:

• New development and maintenance on applications supporting the digital supply chain for ordering (automated and manual), processing, and delivery of digital media content and metadata for platforms such as iTunes.
• SQL tasks include backup and restore of multiple 100GB production and staging databases, stored procedure development and tuning, indexing, SQL jobs, views, functions, SQL CLR assemblies, security management, disk space management, Linked Servers, Post-restore and release scripts, and a large Archiving project.
• Development and maintenance in apps including MVC web app (C#) with WebApi endpoints providing REST services, Windows Services for database queue polling, WCF endpoints. UI consisted on MVC views w/ HTML, CSS, Javascript, & JQuery. New development included AngularJS with JSON
• Various projects include providing functionality for importing Excel and parsing to XML of client title data for further processing, SNS text messaging thru Amazon Web Services (AWS) on particular events/status, SQL CLR assemblies, and batch files to stop/start services for release activities.
• All apps and services developed adhere to well-thought Object-Oriented design with appropriate functional layers for loose coupling and ease of testing and maintenance.

Confidential, Hermosa Beach, CA

Senior Developer

Responsibilities:

• Wrote plugins for open-source ASP.NET MVC e-commerce platform ( Confidential ) for saving customer preferences, referral program, and custom homepage imagery.
• Plugin design implements Entity Framework 5.0 against SQL Server 2008R via Code First (reverse engineering), and mapping with Fluent API. Implements Repository pattern and Service layer to separate CRUD functionality and business logic from controller layer.
• Utilizes Autofac for IOC (inversion of controller) and dependency injection container. Configuration views use Kendo controls (grid) and implement JQuery and AJAX for updates without postback.

Confidential, Los Angeles, CA

Senior Developer

Responsibilities:

• Development, maintenance, and support for business applications and intranet websites using ASP.NET, C#.NET, VB.NET, SQL Server, Oracle, and MS Access. Confidential is a $300M+ annual revenue plastics manufacturing company with 8 plants in the North America.
• Developed multi-tiered production work order application for product manufacturing configurations spanning several product lines. Application utilizes ASP.NET webforms for linking to customer production configurations from SalesLogix CRM, Access 2010 front-end for scheduler data input from various plant sites, a SQL Server database back-end, and two synchronized image stores.
• Maintenance & new features in Bill-of-Lading app (site separate) for shipping and shipping-related accounting information. The BOL app utilized an Oracle 11 back-end to import customer and part data (read-only) and MS Access for local back-end data storage and front-end data entry & reporting. ASP.NET webforms site is used to publish Shipping schedules.
• Maintained several (C# & VB.NET) ASP.NET webforms intranet sites for unique customer product branding, Warranty, and for intracompany communications, utilizing Oracle and SQL Server back-ends and ASP.NET front-ends for image and .pdf upload and storage.
• Developed an Oracle data access assembly (.dll) utilizing Entity Framework and LINQ by leveraging the new ORA.NET provider to provide common/high-use Oracle data via public static methods.
• Developed a Windows Service to watch files in disparate directories for updates and post update to a central (web) data source location. Technologies included XML & C#.NET.

Confidential, Santa Monica, CA

Systems Engineer 4 / SQL Developer

Responsibilities:

• SQL Developer contractor supporting data backend for new development of pilot ($30M - $500M) capital finance loan management application, including, scalar and table-valued functions, complex stored procedures, tables, views.

Confidential, Encino, CA

Senior Developer

Responsibilities:

• Senior Developer for Omni Mgmt, a data services company that provides consulting and data services, primarily to law firms representing corporations re-organizing through Ch. 11 bankruptcy. Omni mgmt provides custom database solutions including, but not limited to processing for filed claims and objections, balloting, disbursements, and reporting for all stages. Latest Omni projects include our online Virtual File Room (VFR) for document management: upload/storage and retrieval, universal document search, ad-hoc querying and custom reports.
• Develop multi-tiered application architecture, from database back-end, middle-tier object design (OOP business objects, data access layer, web services in C#), to front-end (Winforms/ASP.NET).
• Utilize or create functional requirements, use cases, UML diagrams, and other software development lifecycle products.
• Develop reusable library of assembl ies (.dll), web services, and functional modules in C# to support and extend existing applications.
• Maintain source code in Visual Sourcesafe (also SVN).
• Design and implement new SQL Server databases: Create table schema, indexes and constraints (incl referential integrity), stored procedures, custom T-SQL scripts, user-defined functions, triggers, audit tables, DTS/SSIS packages, etc.
• Maintain (40+) client databases, application front-ends, and supporting/connecting layers - business objects, data access.
• Perform data imports/exports, data migration/transformation (ETL) b/w flat file or non-normalized data sources, write T-SQL script generators, implement jobs - scheduled backups & maintenance plans, secure the database through roles and user permissions.
• Solve Problems - Analyze technological challenges and provide sound, creative solutions. Assist team with design and coding experience.
• Learn - constantly improve tech knowledge, stay current with Microsoft’s latest best practices and products, seek and provide mentorship.
• Major projects:
• Owens Corning claims database - Omni’s largest client/case utilized several complex databases with +1 million rows. (SQL)
• Audit trail code generator - implement audit-trail for SQL Server tables with rollback functionality. (SQL)
• SQL Table Compare tool - SQL table schema & data comparison/synchronization tool. (C#/Winforms)
• Claims Workbook - fully automated Excel multi-sheet workbook that utilized automation to import, process and format SQL Server data. (SQL, VBA)
• Virtual File Room - online document management application. Features include bates stamping, user-definable folder hierarchy, document hiding/sharing capability, - (ASP.NET/C#/SQL Server).
• FileStore assembly - universal black-box file storage for consuming applications. Allows for unlimited User/Application configurations targeting multiple file storage databases utilizing 3 unique storage options: file directory, SQL Filestream, or SQL In-Row storage - (C#/SQL Server).
• Saved Rpts manager - save and share custom search criteria and column sets for ad-hoc and static reports. Report criteria stored as XML metadata. (C#/ASP.NET)
• OmniHR web app - Intranet timesheet application. SQL Server 2008 back-end, ASP.NET front-end, hosted on Hyper-V virtual machine. (C#/ASP.NET)
• OmniSearch - vm-hosted MS Search Server installation & .dll for online document keyword search. Allows plug & play document keyword search for any application. (C#/SharePoint)
• Network Traffic Generator - traffic generator for simulating network load on IIS server. ( Confidential )