Developed RNTV (Real-time Network Traffic Viewer) to support international trunk group traffic usage. Provides dynamic filtering, report style, and time aggregations. Data collection via NEMOS protocol: internal (AT&T) communication protocol with telnet connectivity and a distinct command / response messaging.Developed LMSng application to support the “Virtual Network Function” (VNF) evolution of the Location Based Services. Windows Server utilizing C# in ASP.NET MVC Core 3.1, SQL… Show more Developed RNTV (Real-time Network Traffic Viewer) to support international trunk group traffic usage. Provides dynamic filtering, report style, and time aggregations. Data collection via NEMOS protocol: internal (AT&T) communication protocol with telnet connectivity and a distinct command / response messaging.Developed LMSng application to support the “Virtual Network Function” (VNF) evolution of the Location Based Services. Windows Server utilizing C# in ASP.NET MVC Core 3.1, SQL Server Enterprise, and 60+ Terabytes of database storage.* Role Based Access Control (RBAC) authentication with Active Directory, ASP.NET Identity, claims based authorization.* .NET based publish subscribe system using.NET “Task Parallel Library (TPL) Data Flow”. * REST service to support file movement service “DataRTR”.* Custom ETL process using ADO.NET datasets, configured by XSD files, for file structure definition, destination definition, column mapping. * SQL Server Service Broker (SSB) base publish/subscribe event system, and a “Directed Acyclic Graph” (DAG) workflow. * Star or snowflake schema to support dimensional modeling and OLAP reporting.* COLUMNSTORE index tables for “big data” requirement.* Table partitioning and “sliding window” approach for efficient ETL.New data processing server utilizing SAFE Feature Management Engine (FME), installed on an Azure VM running Ubuntu operating system.Consolidate multiple reporting systems into MetriX. This involved replacing Java processes into FME workspaces. Developed Python libraries, used internally to a FME workspace. Developed a SOAP interface between the FME workspace and a SOAP endpoint.Integrated “Mobility Voicemail on Azure” (MVMoA) network of SBC elements into MetriX. This involved ETL of multiple file types into a Snowflake cloud data warehouse. Required transforming hundreds of header names to original SNMP MIBS names use Feature Management Engine (FME) from Safe. Show less

Co-developer of MetriX reporting system, a meta-data driven system to collect, organize, and report data in support of “core” elements of the AT&T network. MetriX has 2 functional areas to address growth and complexity. * Data Capture Appliance (DCA). Multiple DCA’s could be added to a MetriX system: addresses data volume and multiple sources. Separates out complexities in handling many different types of data. * Engineering Data Warehouse (EDW). The EDW is itself a DCA that… Show more Co-developer of MetriX reporting system, a meta-data driven system to collect, organize, and report data in support of “core” elements of the AT&T network. MetriX has 2 functional areas to address growth and complexity. * Data Capture Appliance (DCA). Multiple DCA’s could be added to a MetriX system: addresses data volume and multiple sources. Separates out complexities in handling many different types of data. * Engineering Data Warehouse (EDW). The EDW is itself a DCA that collects data from the other DCA’s. Additionally performs the role of defining the “engineering rules” requirement: data filter, summarized, group network elements together, and reporting.MetriX was meta-data driven with input via web server. Meta-data used to create ETL code (DCA), filtering and aggregations (EDW), reporting (EDW), and data warehouse maintenance. SQL Server Service Broker (SSB) used to execute workflow of jobs. SSB queue Activation Procedure convert message into “job” to execute via meta-data conversion into dynamic SQL. Created multiple SQL Server data warehouses/marts using “dimensional data modeling” for VoIP services and Location Based services. These data marts were used as source data by SQL Server Analysis Services (SSAS) to produce OLAP cubes. SQL Server Service Broker (SSB) for event based work dispatch and execution. OLAP cubes were used for performance and capacity management of the different networks:* CVoIP – Customer VoIP network with Oracle data source.* NTN – National Tandem Network, which consisted of SONUS GSX Media Gateway, SGX Signaling Gateway, and PSX Call Routing Server.* LBS – Location Based Services Show less

Performed System Capacity Monitoring and Engineering (SCME) analysis of the Lucent Autoplex-1000 (APX-1000) Cellular Switching System. Extract, Transform, and Load (ETL) trunk group usage and T1 data. Created reports to isolate impaired cell sites and T1 circuits. Aid in determining financial waste in T1 circuit assignments to trunk groups. Utilized SQL Server databases to consolidate data into a consistent reporting environment. Used multiple Solaris servers to perform… Show more Performed System Capacity Monitoring and Engineering (SCME) analysis of the Lucent Autoplex-1000 (APX-1000) Cellular Switching System. Extract, Transform, and Load (ETL) trunk group usage and T1 data. Created reports to isolate impaired cell sites and T1 circuits. Aid in determining financial waste in T1 circuit assignments to trunk groups. Utilized SQL Server databases to consolidate data into a consistent reporting environment. Used multiple Solaris servers to perform ETL scripting using KSH (Korn shell) scripts and various UNIX utilities. Converted this into collecting similar PM and traffic data from the 2G (GSM) and 3G (UMTS) Radio Access Network (RAN) with different data files types (CSV/TSV, Excel workbooks, XML, and JSON files). Created processes to collect from different RDBMS vendor databases including Oracle and Sybase. Wrote SQL queries in multiple SQL dialects (PL/SQL, T-SQL) for ETL of data, loading it locally into a SQL Server database.Designing data marts and data warehouses utilizing “dimensional data modeling” using “star” and “snowflake” schemas in SQL Server databases. * The data marts were used by “SQL Server Analysis Services” (SSAS) to provide OLAP cubes.* OLAP cubes were designed specifically to address the unique engineering requirements for analyzing the performance of the RAN network. They were viewed by end users via PivotTables inside of Excel workbooks. * This provided users the ability to design any number of reports, or analyze data in any number of ways to address their needs. Show less

Provided hardware and software support of the Lucent Autoplex-1000 (APX-1000) Cellular Switching System, the first generation cellular service. Supported the Executive Cellular Processors (ECP) and the 5ESS-2000 digital switch and provided primary support for the Centigram voicemail system. Performed configuration additions or changes, hardware replacement, T1/DS1 and T3/DS3 installation, routing, and cross connect; supported data link connectivity between the ECP and the… Show more Provided hardware and software support of the Lucent Autoplex-1000 (APX-1000) Cellular Switching System, the first generation cellular service. Supported the Executive Cellular Processors (ECP) and the 5ESS-2000 digital switch and provided primary support for the Centigram voicemail system. Performed configuration additions or changes, hardware replacement, T1/DS1 and T3/DS3 installation, routing, and cross connect; supported data link connectivity between the ECP and the Autoplex Series II cell sites.Addressed data collection and “data extraction” requirements that occurred, developing scripts to “scrape” data from text files. This involved automating and scheduling report production, data capture, parsing and storing results to be used by various internal customers. Worked on the Lucent OMP’s, which are Sun based Solaris servers used to support the Autoplex system and did similar data work for the Centigram voicemail system. Show less

Worked on a variety of equipment connecting to telephony switching systems before transitioning to voicemail systems support.Provided installation, repair, and remote (telephone) support for customers. Examined memory address values to analyze configuration settings, memory dumps, or similar “binary” work. Wrote a technical manual on one of the systems.Supported later generation voicemail systems that utilized “Sun” operating system (SunOS). Used various CLI… Show more Worked on a variety of equipment connecting to telephony switching systems before transitioning to voicemail systems support.Provided installation, repair, and remote (telephone) support for customers. Examined memory address values to analyze configuration settings, memory dumps, or similar “binary” work. Wrote a technical manual on one of the systems.Supported later generation voicemail systems that utilized “Sun” operating system (SunOS). Used various CLI (AWK, grep, sed) to configure the systems or analyze error logging.Took on the role of a trainer for the voicemail systems and created two different (one week) classes for customers to take. * The first was a “user / support” class that provided beginner content on the voicemail system. * The second was the “advanced support” class, which provided hardware troubleshooting and software configuration and troubleshooting. Show less