SUMMARY:

• Highly effective infrastructure and software engineer with distinguished career leading all facets of software development, systems implementation, migration, analysis, network administration, systems architecture and design, deployment and support.
• Software architecture, modeling, testing, object oriented analysis, business analysis, OO design, algorithms, documentation, MOF/MSF/Agile/CMM and full SDLC.
• Systems management, application deployment, desktop configuration, change control, client support, etc.
• Extensive experience in implementing IT systems supporting the legal and legislative sectors; healthcare and health insurance; property and casualty; and legislated, federal and corporate governance, judicial and legal systems. These included child welfare support and case management, child support payment processing, call center and customer services systems for child welfare and child support, judicial systems in the health insurance and health care sector, K - 12 school systems, court room IT, systems for managing law firms, financial management and so on. Work included responsibility for principles, practices, codes and procedures such as CFR 21 Part 11, HIPAA, GAAP, SOX, and FISMA; including validation via various methodologies such as V-Model and Waterfall and so on.
• Database administration and development (SQL Server 6 (ca 1996)-2016, Oracle 8i and later, Siebel SQL, Teradata SQL etc), architecture and design. Extensive Experience in all operations and programming aspects of ANSI SQL/SQL-92, T-SQL, PL/SQL, Teradata SQL etc. Expert SQL Server 2000-2016 SSRS, SSIS, .NET integration, SSAS, OLAP, Data Warehouse, DTS, DBA (including replication, high availability, performance, and infrastructure management). Reporting with SSRS, Crystal, Clarity, Power BI, Tableau, Power Pivot (and entire Power stack of technologies from MS), DQS, MDS, Cognos, Microsoft Excel, DAX, MDX, data ware house, datamart schemas and so on. As a McGraw-Hill, Wiley, and Pearson Publishers technical author I keep current on all technologies.
• End-to-end Windows 2000/2003/2008/ R2/2102/2016Windows 8/8.1/10 systems architecture, including NLB and various clustering/HA projects and Windows AZURE/Microsoft Cloud. Fully versed in all Azure offerings, including Azure Stack, IaaS, PaaS, SaaS and so on.
• Network engineering, TCP/IP, IPX, VPN, firewalls, security (including CFR 21 Part 11 security), PKI, RAS, routing, Virtual Networks, Azure to CPE connectivety, FireWalls, private fabrics, storage design and management, operational prodecures, disaster recovery, high availability and so on.
• Cloud: Adopted Microsoft Azure due to familiarity with MS infrastructure and technology. Deployed LOB virtual servers, IIS, Domain Controllers, Virtual Servers, VPN, Active Directory, SQL Server, SQL databases etc. Also worked on Azure based Visual Studio offering from MS, TFS and Team Services (cloud based), and so on.
• Communications systems migrations such as GroupWise to Exchange, network separations and so forth.
• Keen awareness of ensuring success through strategic planning, risk management, problem solving, and the application of commonsense project management practices.
• Excellent communication and interpersonal skills with exceptional detail-oriented practices. Fluent in English and author of more than 25 technology books. I am also content manager (freelance) for Pearson’s Windows Server 2016 Unleashed book that covers all updates to Windows Server 2016 and the Microsoft offerings in the entire Azure stack of Windows based technologies.
• Celebrated industry author (just completed Windows Server 2016 Unleashed) with numerous publications that have been extensively translated, including Windows Server 2008, SQL Server 2005/8/2012-2016 , The Complete Reference and SQL Server 2000, The Complete Reference (Osborne/McGraw-Hill), Visual Basic .NET, The Complete Reference (Osborne/McGraw-Hill), and Windows 2000/Server 200/2008 Bibles (Wiley) and more. Also the author of the McGraw-Hill courseware for the MCSE Network Essentials core exam, the MCSE Active Directory (70-219) core exam and Addison Wesley’s Building High Availability Windows Server 2003 Solutions. Also, Sybex Windows 8,1 Certification Guide (due 2014), Wiley’s Windows 8,1 Bible (due 2014), Windows 10 Bible (2015), Visual Studio 2013 Bootstrapped (MISIQ), due March 2014. Windows Server 2016 Unleashed (2016), Windows Azure Unleashed (2016).
• Extensive developer experience with the .NET/CAB/Application Blocks/P&P Frameworks, expert in VB.NET, C#, C++ and a variety of languages and bleeding edge technologies such as AJAX, ASP.NET, Razor, LightSwitch, MVC, Linq, ADO.NET, EF, .NET 4.5+ (WCF, WPF, WF (workflow), SOAP, REST (all versions of VS) and flavors of JS such as Angular/AngularJS, React, Node and so on. Experience with various SOA technologies in the Microsoft stack. Also worked with (installed, configured and managed) several source repository/CI systems such as Visual Source Safe, Clear Case, and (mostly), Subversion, Git, Team Foundation Server/Visual Studio Team Services (TFS/TSVS). Well versed in all Micrsoft Office tools (Word, Excel etc), Office365 and the entire Adobe suite of publishing tools (for technical documentation), such as InDesign, from the Adobe cloud.

TECHNICAL SKILLS:

O/S Platforms & Servers: All Windows operating systems; Exchange 5.5/2000/2003/2008 and onwards, SQL Server 7/2000, 2005, 2008, 2012 SMS 2.0/2003, ISA, MOM, Commerce Server, IIS, Citrix Metaframe, Terminal Server, SharePoint and so on. . .

Networking: Routers, switches, hubs RAID, SCSI, USB, DLT & DSS Backup; Telephony Systems, IVR, WINS, DNS, DHCP, PKI, Active Directory, replication, NDS, LDAP, Group Policy, SAN, NAS . . .

Tools: & Applications:: Microsoft Office (Word, Excel, Outlook, and PowerPoint), MS Project, ERWin, Visio, Rational Rose, Interdev, all brands of backup software, DR, NetIQ, FullArmor, FastLane, SQL Assistant, SQL Developer, Enterprise Admin, Management Studio etc.

Development Technologies: .NET Framework and end-to-end Microsoft technology such as WPF, WCF, EL, Patterns and Practices and so on, English Query, RDL, Crystal Reports, Delphi, JBuilder, Interdev, Visual Studio; Query Manager, UML, Architecture Frameworks (Zachmann etc), RUP, ERD, V-Model, QA/QC GMP, IEEE, Agile, CMM, Test-Driven development and so on.

Programming: C/C++, Java, JavaScript, Jscript, Visual Basic .NET, Visual Basic, VBS, C#, Object Pascal, SQL, T-SQL, PL/SQL, SQL-92, MDX, Regular Expressions, OLAP/OLTP, XML, SOAP, Team Services, Team Foundation Server, VSS, Ajax, JSON, JQuery, LINQ and so on.

PROFESSIONAL EXPERIENCE:

BI Architect, Software and Data Ware House, Reporting Systems, architect/developer

Confidential, Raleigh-Durham, North Carolina

Responsibilities:

• Contracted to help architect a new BI reporting system against DHW with SSRS.
• ETL from Oracle 12c and SQL Server systems supporting the EPIC healthcare system/revenue reporting. Entire suite of SQL Server 2016, SSRS, Power BI, Tableau et al. Work includes data warehouse design and deployment, ETL/SSIS/.NET, SQL Server, IIS, Report Services, designing, developing and troubleshooting financial reports and so on.
• Working with BI and report services team in both archicture, proof of concept and so on.
• The components of this project included revewing solutions for a complete CPE Microsoft BI solution, a hybrid BI solution with systems hosted in the Azure cloud and systems hosted in CPE, and a complete Azure system where all SSIS, SSRS, and SSAS services exclusively hosted and managed in Azure.
• I also reveived integrating develop work stations into the Azure Stack, hooking into Visual Studio Team Services and so on.

Lead BI Architect, Software and Data Ware House architect and developer

Confidential, NYC, NY

Responsibilities:

• Contracted to create an ETL system integrating high performance, multi-core, parallel processing.NET Windows Services with SQL Server 2016 to rapidly extract, transform and load data into investment company data warehouse to provide data and reports for multiple investment companies and hedgefunds.
• Full Visual Studio 2015 and entire suite of SQL Server 2014/2016. Work included data ware design and deployment, ETL/SSIS/.NET, SSRS, SSAS, MDS, ODS, DQS, SQL Server broker, Azure, IIS, Report Services, sundry report systems, R for financial reporting, designing, developing and troubleshooting financial reports and so on.
• The entire system was deployed to Azure on both IIS servers, applications servers for ETL and SQL Servers for DWH and processing.
• Contracted to update the lead content of the best selling book Windows Server 2012 Unleashed to Windows Server 2016 Unleashed and to manage and provide content for the Web site related to the book called the Windows Server 2016, Content Update Program.
• The program comprises information on all Windows Server platforms, such as SQL Server 2008 to SQL Server 2017, and all related Azure services.

ETL/SSIS/DW System and Software and Platform Architect and Senior Developer

Confidential, NYC, NY

Responsibilities:

• Contracted to migrate a data warehouse comprising decades worth of trades and transactions data to a new SQL Server data warehouse platform into the corporate worldwide cloud-premise hybrid infrastructure.
• Worked with the original data architects to develop various facilities for the data, staging, cleaning, integrity and consistency checking and so on.
• Wrote migration scripts, scrubbed data and did intensive quality assurance and quality control to ensure migration of the company trading information comprising several billion dollars in trades and world-wide investments.
• Project required .NET/C#, T-SQL, networking, and a wide range SQL Server data migtration tools, analysis tools, networking, platform support, remote data center consultation and so on. Did extensive quality assurance and proof fo concept using MS Excel, Power Pivot and Pivot tables and the like.

Lead WEB/FORMS/ETL/SSIS System and Software and Platform Architect and Senior Developer

Confidential, NYC, NY

Responsibilities:

• Contracted to document (about 4000 pages), re-architect and build proof of concept for a new version of the Account Meter Sync interface between the customer service center (CSS), intermediate systems and other data sources (such as LPDS) and the Itron meter management system (IEE).
• The IEE system provided a Web service interface to which an XML configuration file is passed. This configuration file provided the IEE with all meter additions, removals and changes to sync the IEE with the account and billing departments. All account additions and changes were made in systems hosted in DB2 databases. My system accessed the IEE SQL Server databases for adds and changes in IEE and compared this data against the account meter sync databases. Data was added and updated to the staging database against which new IEE configuration files were produced for IEE. The legacy system I documented and the new system I architected was SQL Server 2008 R2 based and I also supported, documented and reachitected the entire SQL Server system responsible for extracting CSS information, massaging it and ultimately extracting the XML configuration file to pass to the IEE.
• While working on the project I became very familiar with the IEE and Itron’s AMI and Itron’s meter management technology.
• The project was to build a new interface system to the current IEE and then to transition it to a system that would interface with AMI, and a universe of millions of meters. In order to document, design and rearchitect in this project I became familiar with all aspects of IEE, such as creating service points, meters and recorders and their types, channels, formulas, service point channels and so on.
• The account meter sync employed numerous Microsoft stack ETL/SSIS/RSS .NET (VB and C#)/ASP.NET systems that synchronized the customer service systems (customer accounts, customer premise, and service point data in DB2) with the Itron meter management systems.
• The ETL layer extracts data (utility usage data from millions of customer premise meters) from DB2, matches customer accounts (new accounts and meter additions and exchanges) with their meters and updates and inserts all data into a SQL Server repository for cleaning and massage. Data is then extracted to XML configuration files and uploaded into the Itron IEE systems.
• While on this project I was tasked with re-architecting the existing web services and ASP.NET/BizTalk tier and rearchitecting for ASP.NET, WCF and MVC (report access). All maintained code was VB.NET. I documented and updated/created views, stored procedures, triggers, functions in TSQL. I was also on call to resolved logic errors and bugs in the existing database, as well as updating tables and sprocs for both the OLTP systems as well as the data warehouse systems. The new account sync system I was tasked to architect was to be built in C#.
• Also supported the existing legacy systems so the FTE developer and administrator could take six months sick leave.

Lead System and Software and Platform Architect and Senior Developer

Confidential, WESTBURY, NY

Responsibilities:

• Contracted to create several SSIS packages that moved data (invoices, orders, delivery items etc.) from a myriad of online stores, warehouses, brick and mortar stores, cloud based SQL Servers, warehouse systems (CICS, DB2 and AS400) and so on. Created C# based code in SSIS to reconcile (match) invoices with purchase orders.
• Code updated database systems to allow accounts payable to pick up validated invoices that were matched against POs and delivery confirmations so that suppliers could be paid. SSIS also moved matched invoices to the accounting systems for payment.
• I created a new database for this project (for staging and invoice/po matching) and created a large number of tables, views, functions, sprocs, triggers.
• I was also reposibles for linking the server to other database repositories in the organization and wrote a number of cross platform queries as part of the ETL process.
• Also created a ASP.NET-MVC4 Web application to let users see all SSIS job reports and to obtain reports showing which invoices were imported by the SSIS application and the results of the PO-Invoice matching systems (such as which invoices had correct number of books ordered, which invoices could be matched against a PO, invoices rejected and so on).
• The Web app also included functionality to allow for the manual management of invoices and POs.
• I was also responsible for the porting of DTS to SSIS, and the creation, packaging and installment, scheduling and maintaining of the SSIS functionality.
• The final stage of the project involved the creation of about 12 SSRS reports, charting, rolling up data, weekly and monthly reporting, drill down reports and so on.

Lead System and Software and Platform Architect and Senior Developer

Confidential

Responsibilities:

• Project is a three-tiered automated trading service against the API of the Interactive Broker trading engine using C#, WFP, WCF, MVC 4 (ASP.NET with Razor) and Winforms, ASP.NET, SQL Server , T-SQL and Visual Studio 2012. The system was developed and deployed on Microsoft Azure Cloud Services using SQL Server 2012 R2, Visual Studio 2012/3 and the .NET Framework 4.5.
• I built the server components to run on Windows Server 2008 and 2012 using both Windows services and WCF for the full gamut of SOA benefits.
• A forms application using elements of the WPF allows for secure management of the server, while a MVC/ASP.NET application is used for client access, reports, data analysis and so on.
• Web technology also includes JQUERY, CSS, Telerik and Infragistics controls and so on. Platform source control and teamware is TFS.
• Lead on full .NET OO architecture.
• The above system was deployed to Microsoft Cloud (Azure) to meet a 99.99% uptime requirement and proof of concept.
• I architected the system on Azure cloud servers (SQL Server 2012, Windows Server 2012 R2 Datacenter, IIS, and so on).
• System was deployed to a test domain in the cloud on Active Directory (just launched) with all FSMO roles in place.
• Network was setup in the cloud as a VN/VPN (new Azure offering) allowing the cloud system to be connected to the corporate services and allowing users on VPN clients to interact with the system from corporate locations.

Lead System and Software and Platform Architect and Senior Developer

Confidential, CHATTANOOGA, TN

Responsibilities:

• Project ran the gamut of all Windows technology architecture (software and infrastructure (Windows 2012 and Windows 7, 8) and development of a secure ASP.NET-MVC4 based Web application for end-to-end report delivery (SSRS etc) and data mining service covering all insurance related information for employees, policy holders and brokers/producers, according to all standards and requirements of the Affordable Care Act (Obama Care), HIPPA and HIT. Provided all systems and software design and documentation for all tiers.
• Also architected and reengineered in-house data, business rule, security, communication, and all cross-cutting utilities and code around Microsoft P&P, the repository pattern, Enterprise Framework, Dependency Injection (DI) and so on. Front end was built with ASP.NET, MVC, Telerik, Infragistics, JavaScript, JQuery, AngularJS, CSS, T-SQL and so on.
• The middle tier was built with various libraries from the EL, a host of WCF services (in a secure, DMZ secured environment using TCP and named pipes for endpoints for access to sensitive information with external clients using a mix of REST and standard HTTP/SOAP for less critical communication using built in endpoint and connection libraries).
• The system database technology was SQL Server 2008 with services accessing data from a variety of sources such as Sybase, TeraData, Congnos, Oracle and so on.
• Both VB.NET and C# were used on this project to support existing systems and developing new systems.
• Project also involved reverse engineering legacy VB/ASP reporting apps and porting them to SSRS.

Senior Developer

Confidential, MIAMI, FL

Responsibilities:

• Projects included architecture and development of ASP.NET based Web application used to track and update data of testing scores of school children.
• Application used SSIS to bring data into standard OLTP and OLAP tables organized for analysis.
• The application then allowed teachers to load student data into columnar, pivot table like, multidimensional cube and grid structures to assess student grades by school year, grade, schools, KPIs, courses, and so on.
• While at MDCPS I was also responsible for several ETL/SSIS/SSAS/SSRS projects used to scrub and transfer data from mainframe systems into the SQL Server DWH and DB2 environment. The typical application would be to load flat files dumped onto FTP shares, transform the data using a number of functions and stored procedures, run calculations against the data and a variety of transformation code and then move it to SQL Server where it is accessed by the school and the state.
• I was also tasked with the job of converting legacy DTS packages to SSIS, which involved a lot of rewriting and converting old Visual Basic 6 applications into WPF based Visual Basic.NET applications.
• The ASP Application was developed using VB.NET and C# with extensive AJAX functionality using the both the Infragistics tools and Telerik Rad tools for ASP.NET and AJAX. I was responsible for all elements (html, aspx, web parts, CSS, Ajax, backend code (VB.NET, C# and JavaScript, JQuery), and datatier-SQL Server 2005/8 integration.
• Code behind for the front end and business layers was done in VB.NET, and data layers and data engine was built using C#. The layout, scope and flow of the site were achieved using a master-content page model for integration into the county portal with a pathway to MVC implementation.
• The entire application was integrated with the county legacy systems, report servers and so on where several older (ASMX) Windows services were upgraded to WCF processes.
• Other technologies and tasks for this project include Microsoft Application Blocks, T-SQL, ADO.NET, JavaScript, Security, Web Services and WCF, CSS, and Active Directory, SSRS integration and so on. I was also tasked to convert InfoPath forms to ASP.NET as the IT department decided to abandon a number of SharePoint applications it no longer had the staff to maintain. While at Miami-Dade I was also a member of the TFS support team where the system catered to a department of upwards of 35 developers.

Senior SHAREPOINT Developer

Confidential, ft lauderdale, FL

Responsibilities:

• Architected, developed and deployed the Employee Job Referral system for Kaplan’s HR department.
• This SharePoint app comprised InfoPath forms, multiple lists and document library integration, Web parts, ASPX pages, and extensive integration with Kaplan financial and ERP systems.
• I programmed extensively against the SharePoint OM using C#, and implemented scheduling, events, CAML functionality, and more, from inception of the production to release and deployment in the production farm.
• Other technologies and tasks for this project included WCF, WPF, WF (workflow), Application Blocks, TSQL, ADO.NET, ASP.NET, AJAX, JavaScript, Security, Solution Development (WSP), Web Services and so on.

Senior Developer

Confidential, Orlando, FL

Responsibilities:

• Architected, developed and deployed the Universal Orlando (UO) ticketing web service (a large SOA initiative) using C#, SQL Server, an ASP.NET a façade to the eGalaxy ticket processing system, and a WPF client for system management.
• This online system allows partners like Travelocity to book shows like Blue Man Group or activate tickets to the parks.
• The WCF services allowed clients to connect to the service, check for ticket availability, reserve and book seats and preferred seating arrangements, accept and process payments and interface with ticket pick up services.
• Also tasked to architect and design a biz intelligence application using WPF, C#, SQL Server and OLAP for Universal Orlando and Universal Hollywood for planning and forecasting sales, orders and revenue for the Confidential merchandizing departments.
• Projects required SSIS/ETL to load ticket data to the data warehouse.
• Worked with the BI and DSS people to implement the solution and used WPF to display charts, KPIs, tabular data and so on.

Senior Developer, september

Confidential, Orlando, FL

Responsibilities:

• Responsible for project enhancing and converting of ASP.NET components of the K-12 Web-based Virtual Student Administrator to ASP.NET 3, 3.5 using all of Microsoft Ajax toolkits.
• I employed and implemented a variety of components, such as update panel, model popup dialog box, visual control extenders, Web services and so on, to provide users with a richer and more responsive online experience.
• Development included client, middle tier and database logic.
• Code done in C#, JavaScript, HTML, Json, Xml, T-SQL and so on.

Senior Developer

Confidential, Orlando, FL

Responsibilities:

• Developed the data layer, data engine client and a number of components used to access SQL Server/OLAP(SSAS)/DW systems as part of a Windows WPF-based benchmarking application built by a team of four.
• The application is written in C# and accesses SQL Server 2000 and SQL Server 2005 (TSQL and MDX). My components included all the ADOMD/MDX code to access cubes (such as a cellset/tuple adapter in C# relying on reflection and attributes) extract data and work with various dimensions in the compilation of industry studies. Work at Confidential also included several extensive ETL/SSIS/DTS Report Services projects.
• Worked with ProClarity and created my own ProClarity-like Cube-browser in WPF for analyzing and reporting on data from MD queries involving pages, columns and rows in the same query. SSIS was used with C# functionality and PKI to transform and move data from researcher stand-alone SQL Server personal edition databases into the data warehouse.
• WPF client was deployed on researcher laptops used to collect data at Confidential clients, store the data in local versions of SQL Server personal edition and then move the data to the Confidential data warehouse when researchers returned to Confidential

Senior Developer/DBA

Confidential, Orlando, FL

Responsibilities:

• Developed an automated file “moving” server based system in C# and a number of ETL/SSIS/DTS packages supporting the SQL Server 2000 and mid-range OLAP (cubes and dashboards, troubleshooting KPIs, members, measures, dims and fact tables) systems used by the Confidential Customer Reservations Center (DRC).
• Worked with and supported AIMCall (WPF thick client), Service Center, SQL Server 2000/SQL Server 2005 (TSQL and MDX), ETL from NCR Teradata and Siebel, SQL Assistant. Tasked to covert DTS to SSIS and upgrade and enhance the ETL layers between the Teradata tier, various internal and external data marts and Confidential ’s legacy systems, which nightly dumped data onto FTP servers.
• This data needed to be picked up by my packages, transformed and cleaned and moved to the SQL Server data tier. Highlight of the project was assisting with the KPI Dashboard that tracked ticket sales for teamsters in the Confidential ticket office.