Fred M.

FRED MIKAN 5242 Auckland Ave #4 North Hollywood, CA 91601 E-mail: Cell Phone: [login to view URL] CAREER OBJECTIVE: Senior C#.[login to view URL].SQL Programmer.Architect SUMMARY: 1. Senior programmer with 15 years of front-end and back-end programming experience with various Microsoft tools, 5 years of project management and project lead experience. 2. Experienced with applications and web programming, SOA, 2 yrs [login to view URL], 2 yrs Silverlight, 10 yrs of vb.c#.net.sql programming, 10 yrs of OOP architecture and application design, 5 yrs classic ASP, 15 yrs Web-client interfaces.jQuery.JS.XML.CSS, 10 yrs Visual Basic6.MSAccess. 3. Experienced database programmer, 15yrs exp in database architecture, database implementation, relational database programming (Transact-SQL), developed stored procedures, and triggers, 15 yr SQL Server, 1 yr SQLAzure, 4 yr mysql, 2 yr Oracle. 4. Moderate experience in LAMP and 2yr PHP5.mySQL5.LINUX. 3. Experienced creating technical specifications and developing solutions to meet them. 4. Proven creative and analytical abilities (pending US patent). 5. Demonstrated organizational and planning skills. Able to work independently. EDUCATION & CERTIFICATES: Microsoft Azure Bootcamp: Cloud computing and Azure 06/2012 Microsoft: Developing ASP.NET Web Applications with VB.NET certified 2004 Microsoft: MCDBA - Microsoft Certified Database Administrator (passed Microsoft certification exams Database Development Sql Server 2000) 2004 Microsoft: MCSD - Microsoft Certified Solution Developer (passed Microsoft certification exams Visual Basic, Access Development, Excel Development) 1998 CSU Northridge: MBA - Master of Business Administration 2000 University of Zagreb, Croatia: BS Computer Mathematics (US recognized) 1991 WORK EXPERIENCE: VCSS, Los Angeles: jQuery.C#.Net.SQL programmer 02/13-06/13 VCSS provides community health services on 15 locations in California. -Created webpages to collect patient data with jQuery and submit for processing to aspx webpages service. -Created reports about patient services with sql and Crystal Reports. LuxDot, Westlake: VB.C#.[login to view URL].SQL programmer 06/12-12/12 LuxDot real estate services, buys and resells houses on foreclosures. -Designed cloud based architecture for real estate services based on Microsoft Azure technologies. -Designed backend database and maintained on SqlAzure hosting. -Developed new website to manage process of buying houses on foreclosures. System would import data about foreclosure opportunities from other websites and text files, and then establish workflow needed, notify via email/sms/online agents and underwriters about tasks needed to be done. VB.Net. c#.Net.SQL.MVC4.jQuery framework. RenderRocket, ShermanOaks: VB.C#.[login to view URL].SQL programmer 05/12-06/12 RenderRocket [login to view URL] provides graphics rendering service to studios and artists on distributed Amazon AWS cloud based platform, and digital assets management. -Redesigned and upgraded an existing .net1.1 software system to .net4 architecture based on object-oriented design, classes and design patterns, jQuery. -Upgraded backend sql database as needed to support .net4 and EntityFramework, added keys indexes, sql scripts to cleanup data. -Upgraded Visual Studio solution c# programming to support .net4 and EntityFramework, object classes. CSMCI, Santa Clarita: VB.C#.Net.WCF.SQL programmer 12/10-05/12 Charter School Management Corp [login to view URL] provides office, accounting and technology support for charter schools. -Developed new webpages for [login to view URL] website, for example to manage tasks needed to be completed by new schools, to view charter school financial reports. VB.Net. C#.Net.SQL.net4 framework. -Developed webservice as add-on to Chartervison website so customer can from ipad application connect and can view data. SOA.WCF.C#.JSON.jQuery.net4 framework. -Created 30 financial and accounting reports with SSRS Microsoft Reporting Services with complicated drilldowns, parameter selection from custom variable dropdowns. Integrated reports into Chartervison website them so they can be viewed by website user; wrote Transact-SQL (T-SQL) based stored procedures, triggers, user functions. -Created website for student enrollment that allowed parent to fill-in application online for a child, printed to PDF and emailed PDF application both to school and parent. Implemented with .net4.VB.sql.Linq.EntityFramework.CSLA. Designed and deployed SQL 2008 database. Avatar Partners, Los Angeles: .Net.Silverlight.SQL programmer 03/10-12/10 Avatar Partners Is provider of custom EDI document management solution. -Developed solution for paperless invoicing. Service would Import invoice data from file, create invoice document PDF and send out invoices PDF electronically by myfax or email. C#.sql.CSLA. -Maintaned application in for mapping fields used in data import, made with Silverlight.c#.net4.0, MVVM. Andrews Electronics, Santa Clarita: VB.C#.Net .SQL programmer 01/09-02/10 Andrews Electronics [login to view URL] is distributor for electronics parts used by many brand name stores as parts supply. -Developed webservice to search inventory database for parts pricing and place orders, implemented with .net C# Visual Studio, SOA, XML, WCF, CSLA. -Developed new webpages for website to search for parts pricing and place orders, with .net and Visual Studio. IBM, Los Angeles: C#.SQL programmer 12/07-01/09 IBM Global Operations [login to view URL] is global technology services organization which manages production environments for large companies. -Wrote program for sql server monitoring using C#.SMO.VStudio2005. -Created web-application to manage Inventory of servers. Used .net 3.0 technology, LINQ, VS2008sp1, architected with CLSA. -Wrote scripts to collect data for server inventorying, VBScript, T-Sql, DTS. Deluxe Digital Studios, Burbank: C#.ASP.NET.SQL programmer 12/06-12/07 Deluxe Digital Studios [login to view URL] is provider of video and DVD post-production services to media companies. -Created internal web site to enter new trailers to be streamed to networked HD-DVD player devices, edit data about digital media for example enter disc and title media, upload latest trailer files, edit social networking features like Polls and Trivia that can be answered trough HD-DVD player screen, etc. DVD Authoring group could upload all files to be streamed to HDDVD player devices. -Used asp.Net 2.0, OOP, VS2005, SOA, nHibernate ORM and LINQ, wrote nUnit tests. -Wrote c# procedures used as assemblies from sql stored procedures to send XML message with changed user email and profile to message queue. -Worked in agile, iterative development group, scrum, SVN, TortoiseSVN. -Wrote automated build scripts for [login to view URL], nAnt, unit tests for nUnit, nDoc, AltruIT, Northridge: C#.ASP.NET. SQL Programmer 3/06-11/06 AltruIT [login to view URL] is non-profit organization which develops and hosts software for children foster care agencies. -Created and maintained C#.ASP.net web pages according to specs, with CSLA, OOP, Enterprise Application Blocks, UIP, VS2003, VS2005 -Worked with nHibernate ORM. -Worked on upgrade of solution from .net1.1 to .net2.0 and VS2003 to VS2005. -Added into user interface features with AJAX and CSS. -Wrote automated build scripts for [login to view URL], nAnt, unit tests for nUnit, nDoc, -Worked with C#, VS2003, VS2005, ASP.Net 2.0, SQL Server 2005. -Worked in agile, iterative development group, scrum. Lenders First Choice, Simi Valley: C#.VB.NET Programmer/Sr. SQL DBA 2/04-2/06 Lenders First Choice Inc [login to view URL] is title and escrow company with 700 employees. -Created intranet VB.C#.ASP.net web pages for database maintenance. -Created web-services for calculating title fees in C# and for encryption in VB.net. -Made data transfer processes in C#, export to Excel, download and import to Sql Server. -Made program for tracking of production trough dashboard SharePoint 2003, C#, WebParts -Maintained Sql Server 2000 databases, made Sql queries as needed. -Created financial reports with T-SQL, Reporting Services, DTS/SSIS, Powerbuilder. -Designed SOA middleware services for data exchange with Fiorano and Biztalk 2004. City Of Pasadena, Pasadena: VB.ASP.SQL Programmer.SQL DBA 10/01-6/03 City of Pasadena Information Technology Department is responsible for all application development and computer operations in the Pasadena City Hall. -Created ASP.SQL web application for City Manager Office for grants tracking. Implemented with classic ASP, SQL Server 2000, T-Sql stored procedures. -Designed logical and physical model for databases with Erwin 3.5. -Created Visual Basic program for managing Council meetings agenda with VB6, SQL Server, Crystal Reports 8.5., interactive digital paper and paperless office. -Administered Sql 2000 databases. Monitored performance, worked on query optimizations. -Developed Sharepoint Team portal for use by IT group. -Wrote sql queries to Oracle database for geographic info system. [login to view URL], Toluca Lake, Lead ASP.SQL Programmer 01/00-9/01 Lending Universe [login to view URL] is a financial portal that accepts loan applications and transmits them to matching lenders. -Served as a technical lead for website for loans with responsibility that software is made well and that it meets the requirements. -Interviewed users and gathered technical requirements. -Developed solutions and defined the application architecture to be used by the team. -Designed database logical and physical model with Erwin 3.5. -Installed Sql Server 7.0, 2000. Administered databases and servers. -Prepared development guidelines and procedures. Directed group of 4 ASP programmers. -Monitored performance, performed performance tuning and query optimizations. -Wrote stored procedures for server maintenance and for web applications. -Designed VB6 program for loading web traffic data into data warehouse and creating web statistics reports. Designed data warehouse structure. -Used MS Sql Server, ASP, JavaScript, Java, MathCAD, SPSS. -Worked on conversion of ASP web pages to ASP.NET, made converter in C#. -Pending U.S. patent "Server-based lending system". [login to view URL], Marina Del Rey, SQL Server Programmer 03/99-01/00 Wedding411 was a company that developed websites for planning of various events. -Created, maintained and optimized MS SQL server 6.5/7.0 databases. Created logical data models and physical database design for new databases, made diagrams with Erwin. Wrote stored procedures and triggers in Transact-SQL. Performed performance tuning and query optimization. Made data-mining suggestions. Supervised and mentored 2 junior DBA/SQL developers. Wrote reports in ColdFusion. -Designed VB6 program for testing website load. Sony Pictures Imageworks, Culver City, [login to view URL] Programmer 7/98-2/99 Sony Pictures Imageworks is a digital animation and special effects studio. -Designed digital asset tracking system. Implemented with VB6 on Oracle 8/Unix database. IngramMicro, Santa Ana: SQL.C++ Programmer 1/97-6/98 Ingram Micro is a largest computer wholesaler and distributor in USA. -Developed parts of website that collect information about web site usage and created web site usage analytics reports. Wrote SQLServer 6.5 stored procedures. Made Crystal Reports 6 reports. -Designed database architecture for TechNotes, a on-line product information system for computer systems distributor. Created detailed design documentation using mix of OO and structured methodologies. Created MS Sql server 6.5 database and data mapping. Created data transfer process with C++ 5.0 & Lotus Notes API. OTHER: US Citizen.