OBJECTIVE:

Seeking a position (permanent or contract) to develop and maintain in - house Web/standalone projects in lead or support role — database creation to Web page; consult on end-to-end Web-based business development; design desktop applications for internal use or sale.

TECHNICAL SKILLS:

• Primarily on Microsoft stack (19 years’ experience) with project lead experience at Carousel. The Microsoft and other tools (recently began working with Linux and Neo4j) used include:
• C#/ VB.Net | JavaScript/JQuery/Node.js/Angular.js/SPA/ ASP Classic & ASP.Net (all versions) / MVC 3, 4, 5/Web API and REST / MVVM (limited) / Silverlight / (WCF | ASMX (AJAX) | Web Services | XML/XSLT) | VB/ASP/HTML/CSS | SharePoint (limited - ODATA queries from SSIS)
• SQL (MS TSQL) / Oracle SQL development (PL/SQL) | database design, maintenance, DBA and ETL job development, SSIS/SSRS/SSAS (BI/Data Warehouse development and maintenance), JetReports, Tableau, PowerBI; testing with DAX and MDX; algorithm development, debugging and optimization; all versions of SQL Server through 2016, and 2012/2016 with Azure (cloud-based)
• Linux (RHEL 6 and 7); Neo4j graph database; Java (limited - used with Cypher query language); Spotfire (7.6 and 7.7) data visualization using R, IronPython and Javascript to customize maps

PROFESSIONAL EXPERIENCE:

FULL STACK APPLICATIONS DEVELOPER

Confidential, BAKERSFIELD, CA

• Installed and configured Windows Development Server and 3-node Linux Development Cluster in support of new project development using Neo4j graph database technology (so-called NoSQL database with transaction capability). Three phases of development included (1) processing jobs with MS SSIS projects (using VS2012 and VS2015) from Microsoft SQL Server (through 2016), Oracle and OSI PI databases to Neo4j and then supplying timely business information to dashboards (using Spotfire) and Oracle systems for data governance; (2) adapting subject matter experts’ knowledge to templatized processing in Windows/Linux/Neo4j; (3) developing self-serve BI infrastructure for use by groups within Confidential . Installing 2016 SQL Server to push R scripts back to SQL Server, which supports R natively, and to schedule SSIS processing on newer system. Adapting SSAS financial info to simple Web-based printout results and automated processes. Created Financial Web page for Monthly Reporting along with ETL of data from Finance; did study of Node.js project with Angular (was not full-blown approved project)

ASP.Net/SQL Applications Developer

Confidential, Pasadena, CA

• Maintained and developed several projects and modules for existing Problem Reporting System used by staff on all Confidential projects and NASA missions. Duties required use of Visual Studio 10, 12, 13, 15 and ASP.Net Frameworks from 2.0 through 3.0 and .Net Frameworks 1.1 through 4.6. Hardly any work was done on Classic ASP, but there was some. Microsoft technologies included SSMS 2008, with some work in SSRS and SSIS (job creation/not BI), LINQ, Web Services (.asmx and WCF), Data Entity and javascript frameworks. All primary programming was in C#.

BI/Data Warehouse and SQL Developer

Confidential, La Mirada, CA

• Developed and upgraded existing Data Warehouse nightly processing for 3rd largest furniture retailer in US—used after-market tools, JetReports, PowerBI and Tableau, in addition to SQL Server 2014. Regular production server development work was on SQL Server 2012.
• Developed BI tools and datasets from queries and presentations for staff to analyze data in Purchasing, Accounting, Sales and Operations; the Data Warehouse refresh ran off jobs that were part of overnight ETL.
• Worked on various SQL projects in organization in-between BI/DW tasks and helped with accounting migration.
• Assisted in converting tables and fields for mapping and revising Data Warehouse to match the new structures caused by upgrading accounting to Microsoft Dynamics NAV

ASP.NET/SQL Applications Developer/Programmer

Confidential, Irvine, CA

• Developed mixed ASP.Net/Classic ASP web-based application with SQL Server backend to issue auto insurance at dealerships; ASP.Net was migrated to MVC (3,4,5) and developed some RESTful services; pages were being simplified and Angular.js usage was added
• Performed all database design to implement Web-based E-commerce site, and all .Net-based work
• Some Classic ASP for site maintenance; handled all migration from SOAP-based AJAX implementations to jQuery with JSON on all browsers and migration from ASP/ASP.Net to MVC, and redid all front end pages to include Angular.js and work toward an SPA approach to the entire site
• Wrote all internal Web Services and all requests for 3rd party Web Services; database work included development of all SSIS and SSRS jobs that process information overnight and perform replication/ETL (2005/2008/2012 ); worked on SSAS cube design and Data Warehouse reporting

SQL/Web Applications Developer (SQL Server/C# Web-Based Application)

Confidential, Torrance, CA

• Wrote stored procedures for implementation of least-cost algorithm to assign cars nationally at the dealer level by American factory (did not include International distribution)
• Applied similar algorithm for storage of cars by warehousing in different geographic regions
• Participated in design, testing and implementation of swapping algorithms for pre-assigning factory output to dealers
• Observing many business rules about multi-sourced versus single-sourced factory production
• This method is a high value-added process to lower the number of trades between dealerships during distribution
• Analyzed and designed ETL solutions for sales and inventory information to shorten the cycle of business forecasting from 3 months to 1 month.
• Really enjoyed working with Indian team and offshore personnel.

SQL/Web Applications Developer/Programmer (Oracle-based database system - C#/VB Web-Based Programming)

Confidential, Commerce, CA

• Develop ASP.Net/Classic ASP Web pages; create Oracle queries, stored procedures and reports for manufacturing company; internal and external Web site development and maintenance

Web/SQL/Silverlight/VB6 Applications Developer/Programmer

Confidential, Torrance, CA

• Develop mixed Silverlight/VB6 applications for large merchandizing firm as 3rd party vendor
• Silverlight duties: Design of SQL table/triggers/relations/clean-up scripts for in-house development and customer deployment
• Part of build team for customer deployment
• Implemented class design (unique design with same object model on client and server using conditional compilation)
• WCF services and UI design based on customer spec.
• Testing and refactor during development
• Part of long-term project to convert award-winning VB6 app to SL app
• Worked in client SharePoint environment and researched SharePoint issues.
• Worked well with offshore personnel.

Web/SQL Applications Developer/Programmer

Confidential, Irvine, CA

• Developed mixed ASP.Net/Classic ASP web-based application with SQL Server backend to issue auto insurance at dealerships
• Performed all database design to implement Web-based E-commerce site, and all .Net-based work
• Some Classic ASP for site maintenance
• Handle migration from SOAP-based implementations to jQuery and AJAX implementations with JSON on all browsers and migration from ASP/ASP.Net to MVC
• Wrote all internal Web Services and all requests for 3rd party Web Services; database work included development of all SSIS and SSRS jobs that process information overnight and perform replication/ETL (2005/2008/2012 ).