PROFESSIONAL SUMMARY:

• Over the past 16 years, I have demonstrated success as an IT Professional in areas such as; Software Programming, Database Administration & Development, Windows Server Administration, Systems Design and Maintenance.
• Object - Oriented Programming (OOP) and Design Patterns. Developed Software and Web Applications/Web Services using; C#, Visual Basic, VB .NET, JavaScript, jQuery, Ajax, ASP, ASP .NET, CSS, HTML, T-SQL (Functions, CLR, Dynamic SQL, Queries, Encryption, Stored Procedures, Triggers, Views…), and/or My SQL.
• Database design and administration of Microsoft SQL Server 2000 to 201 2. Extensively used T-SQL and My SQL database query languages to develop database applications and solutions. Configured SQL Server Reporting Services, along with designing SSRS reports and SSIS packages. Converted Crystal Reports to SSRS Reports.
• Active Directory, DNS, DHCP, Group Policy, IIS and WINS configuration and administration.
• Installed and configured Windows AIK and Windows Deployment Services to deploy Windows OS images on PXE bootable systems. Updated servers and desktops with Windows Server Updates Services (WSUS).
• Disaster Recovery planning and implementation. Used NetBackup, Backup Exec and other solutions for systems and data backup and/or recovery.
• Experienced in computer system maintenance and construction. Designed and supported computer networks and multimedia encoding systems.
• Lead numerous networking projects such as wiring, installation and configuration of routers, switches, servers, printers, multiple terabyte NAS, SAN and Fiber Channel Storage Solutions.
• Effectuated video streaming as an alternative for video surveillance for businesses since 2000. This included LAN and WAN solutions.
• Experienced with Akamai and Brightcove Content Delivery Networks; Installing & configuring Render Farms, designed and setup for Maya and After Effects rendering; Video Encoding & Compression with various codec for a variety of applications.

TECHNICAL SKILLS:

Languages: C#, C++, JavaScript, Transact - SQL (T-SQL) and Visual Basic .NET

Frameworks: .NET, ASP (Classic), ASP.NET (MVC, Web API & Web Forms), Bootstrap, jQuery and WCF

Technologies: Ajax, CSS, HTML, JSON, LINQ, OData, Razor, SOAP, SSIS, SSRS and XML

Software: Visual Studio 2005 to 201 3, SQL Server Management Studio, CA Workload AutomationServers: Windows Server 2000 to 201 2, MS SQL Server 2000 to 201 2, Visual Studio 2005/2012 Team Foundation Server, MS Exchange Server 5.5/2003/2007 and MS System Center 2012 R2 (VMM)

Hardware: IBM, HP, Dell, Isilon NAS, Fiber Channel Arrays, Sun StorageTek SL8500 Library System, VoIP Phones, Hitachi PBX Systems, Cisco Switches, Nortel Switches, Printers and Scanners

OS: DOS, Windows 3.X to 10, GNU/Linux and Mac OS X

PROFESSIONAL EXPERIENCE:

Confidential, Simi Valley, CA

Application Developer

• Designed a Loan Label/Document Printer software with C# and T-SQL. It dynamically renders labels and other documents based on a document template configuration.
• Designed a Rule Engine logic evaluator class library. It is capable of evaluating logic statements/expressions in C# similar syntax. Along with accepting literal and Data Row column values to include in the logic statements/expressions, it also can perform arithmetic operation within the evaluated statements.
• Develop and modify applications in C#, Visual Basic (VB), ASP.Net and MVC.
• Create T-SQL stored procedures, functions and DML/DDL queries. Convert Access database applications to Microsoft SQL Server.
• Design databases, including creating the following: schema documentation, tables, stored procedures, functions, indexes (indices), and other database objects.

Assistant Vice President / Programmer Analyst III

• Created CLR/T-SQL stored procedures & functions, DML/DDL queries and Dynamic SQL queries.
• Designed SSRS 2012 reports and SSIS 2008/2012 packages, along with creating the relevant stored procedures.
• Created and/or modified .Net Applications in C# and Visual Basic (VB) .Net.
• Developed a database tool to simplify the import process of delimited flat files from within SQL queries—without the use of external tools like SSIS.
• Created an algorithm to decode data from NFS Files (Banking) to a column format data structure.
• Developed T-SQL scripts to implement Quarterly/Semi-Annual SEI Database schema changes.
• Created business reports from Investortools via the UI and/or from batch (*.BAT) files at the command prompt.
• Created and edited CA Workload Automation jobs to schedule SSIS packages, EXE modules, stored procedures and batch processes. Monitored and trouble shoot issues with CA Workload Automation jobs.

Project Developer (C# & T-SQL)

• Developed ASP.NET (MVC/Web API) applications using; C#, jQuery (JavaScript), Ajax, CSS and Bootstrap.
• Wrote Data Access Layer (DAL), Object-Relational Mapping (ORM) and Data Helper class libraries in C#.
• Created stored procedures, functions, views, DML/DDL queries, data types and Dynamic SQL with T-SQL.
• Designed SSRS 2012 reports and SSIS 2012 packages, along with creating the relevant stored procedures.
• Updated software applications and SSRS reports to support ICD-10 code sets, while enabling backward compatibility for ICD-9 code sets where needed.
• Designed/configured SQL Replication for data warehousing and SSRS environments.
• Created linked servers with MSDTC configured to allow SQL transactions across multiple database servers.
• Installed/configured SQL Server 2012 (SSRS/SSIS). Configure and deploy applications in IIS 7.5.

CEO / Software & T-SQL Developer

• Developed software, web applications, server controls, user controls and modules.
• Created databases, stored procedures, functions, triggers, views, tables, indexes and CLR objects (UDF and SP).
• Configured transactional replication on Microsoft SQL Server 2008 R2 for database redundancy and availability.
• Implemented and configured Transparent Data Encryption (TDE) and column-level encryption. Included creating encryption keys (Service/Master) and certificates.
• Designed and maintained standard and data-driven SSRS reports to present business data and analysis. In addition, created SSIS packages to facilitate the transfer and transformation of data between multiple systems and data formats. Installed/configured SSRS and SQL Server instances.
• Developed and implemented applications and processes to automate online ordering processes. This included XML and/or Flat file integration with distributors, such as: D&H, Synnex, Tech Data and Ingram Micro. As well as synchronizing inventory availability with distribution.
• These applications also automated the logistics and shipping processes for best delivery times, with ground shipping options within the lower 48 states; based on distribution shipping options and warehouse locations.
• Performed ecommerce payment integration with PayPal and Authorize.Net APIs.
• Built and managed Windows 2003/2008 servers for database, web server applications, networking and VPN.
• Used Microsoft Azure cloud service to build and manage virtual Windows 2008 server instances in the cloud. Along with managing other Azure supported configuration settings.
• Established business partnerships with Microsoft, APC, Cisco, IBM, Lenovo, HP, Symantec and more.
• Configuration Google AdWords, Product Feed and Analytics to manage advertising campaigns.
• Managed business processes and operations.

Programmer Analyst III

• Designed the School of Pharmacy’s Supplemental Web Application System.
• Designed web applications, desktop applications and modules using ASP .Net, VB .Net, T-SQL, HTML, JavaScript and/or XML.
• Created and modified databases, stored procedures, SQL queries, triggers and functions.
• Formatted and transferred data between multiple systems using SSIS, custom .Net code, flat files and XML.
• Designed and schedule reports with data-driven subscriptions to run on SQL Server Reporting Services (SSRS).
• Engage managers and department heads regarding their software development needs, design and implementation.
• Managed the development and maintenance of the School of Pharmacy’s software development projects.
• Administered, configured and maintained the database and web servers for the School of Pharmacy.

Reporting Engineer

• Designed and scheduled reports to run on SSRS.
• Created and modified stored procedures, SQL queries and functions to populate reports in SSRS.
• Used Data Transformation Services (DTS) and/or SQL Server Integration Services (SSIS) to transfer data.
• Built and modified applications with VB .NET, T-SQL, ASP .NET and HTML.
• Performed troubleshooting and analysis to assess the root causes of reporting and data warehouse issues.
• Designed and documented database metrics that are used to calculate business reporting data.

IT Manager (Software Developer & Systems Administrator)

• Developed and updated business applications with VB .NET, C#, T-SQL, ASP .NET and HTML.
• Built and scheduled business reports to run on SQL Server Reporting Services (SSRS).
• Designed reports within ASP .Net pages to allow flexibility in generating reports with various variables.
• Scheduled SQL reports to run at specific times and deliver to executives and company employees via email.
• Designed and modified databases. Create and alter SQL queries, functions, store procedures and triggers.
• Manage all IT operations in the factory, from planning and implementing IT changes to supporting users’ needs.
• Supported all servers (2003/2008), desktops and VoIP phones in the factory, including, but not limited to: built/deployed Windows images, create Group Polices, install Windows Updates with WSUS, diagnosed/ repaired systems, backup servers & shares with Backup Exec 12.5, administer Active Directory & Exchange Server 2007, configured Shortel VoIP Phones and enforced software licensing compliance.
• Designed and built a 20TB system with RAID-5 and RAID-6 RAID sets, running Win 2008 Server with Hyper-V, with virtual servers.
• Established partnerships with major technology manufactures to yield huge savings on technology purchases.
• Verified the need for all technology purchases.

Systems Administrator / IT Consultant

• Implement updated standards for video encoding/compression for online video broadcasting.
• Build, configure and maintain MS SQL 2000/2005 Servers and Windows 2000/2003 Servers.
• Maintain web and software applications with ASP .NET, VB .NET, T-SQL and XML languages.
• Monitor asset archiving and restoration with Flashnet and Sun StorageTek SL8500 Library System.
• Active Directory, Domain Controller, Database and Server Administration.
• Software and hardware installation and support. Administer user permissions and file access restrictions. Also ensure consistent network and internet connectivity.

Server/Database Administrator & Software Developer

• Developed and maintained a software application to automate the document import process (including updating document security) for millions of documents going into Hummingbird DM (Document Management) System using: Visual Basic .Net, XML and T-SQL.
• Hummingbird eDOCS, Hummingbird DM/RM (Document and Record Management Systems) and Open Text Collaboration administration, maintenance and troubleshooting.
• Installed server patches/upgrades, monitor health, security, resources and performance; Repaired systems as needed.
• Created, edited and monitored backup jobs in Net Backup and Backup Exec; Recovered servers and/or data as needed; Schedule daily tape pickup/drop-off for offsite storage.
• Administered groups, users, computers and service accounts in Active Directory. Managed and configured IIS.
• Administered file shares’ rights and permissions.
• Built and deployed system images with Ghost over LAN or with CD/DVD media.
• Solved escalated computer problems from the Help Desk team.
• Managed SQL 2000 & 2005 Databases: backups, importing/exporting data, writing/editing scripts & store procedures, etc...

Software Developer

• Developed software projects for shipping and logistic applications to satisfy NGL’s world-wide customers, employees and partners needs; using: Visual Basic .Net, C#, JavaScript, CSS, HTML and T-SQL (MS SQL).
• Software development projects includes: IVR, Web Sites, Web Services and Windows Applications.
• Implemented (Installed and configured) Visual Studio 2005 Team Foundation Server for source control.

.Net Developer / Video Encoder

• Develop Google/YouTube Video Reporting Solutions with VB .NET.
• Encode Videos for flash streaming.
• Develop / Configure Multimedia streaming solutions.

IT Project Manager / .Net Developer

• Setup and configured Projectmates (Company Project Management System). Including importing and exporting data to and from company MySQL databases.
• Developed the company current Email Database Query System using VB .NET, MySQL, Regular Expression and XML. This system handles field agents’ company queries in the Western US regions for over 500 employees daily.
• Managed company employees’ migration to Projectmates.

.Net Developer / Systems Administrator

• Designed Action Script, ASP .NET, VB .NET, AJAX and MS SQL Database Applications for business needs. Some applications included: Web and GUI Administration Systems, Web Back-End Database Solutions, Internal Database Applications and Flash Database Applications.
• Implemented and setup video encoding/compression infrastructure and techniques for NGTV online video broadcasting.
• Configured and maintained collocated servers using Remote Desktop and Plesk.
• Designed and setup render farm solutions for Maya and After Effects rendering.
• Designed and setup multiple terabyte solutions for Full Uncompressed HD video editing/playback and Local/Network rendering.
• Software/Hardware installation and support. Administer user permissions and file access restrictions. Ensure consistent network and internet connectivity.
• Network and Storage Systems maintenance and repairs. Some systems included: IBM Blade Center, Isilon NAS Systems and Ciprico Fiber Channel Arrays.

AV (Audio Visual) & Systems Technician

Responsibilities:

• Responsible for satisfying the audio visual, computer, telephone, and networking needs for business guests.
• Ran CAT-5 and CAT-3 cables to the hotel conference rooms as needed.
• Added additional network and telephone connections as needed (over 700 dedicated lines to consistently maintain).
• Addressed network and telephone problems, as well as setting up required LANs.
• Assisted guest with network settings.
• Changed telephone settings, voicemail configurations, and calling restrictions.
• Cisco switches, Nortel switches.