Analytics and data engineering consulting for small businesses.

• Provide query optimization and support for engineering group using Impala.• Work with vendors and internal users to support analytics applications.• Develop python script for moving data from performance management application to analytics platform.• Support POSIT platform and R development.• Ensure high data availability and quality.

• Provide strategic support for performance management data and tools (Impala, Hadoop).• Work with vendor and internal users related to performance management data loading.• Provide technical/process guidance on improving network data ingestion data quality improvement initiatives.

• Managed a team of 2 business analysts and 4 software developers.• Acted as technical product owner for network automation utilizing Agile methodologies and software development best practices.• Worked with various business units to gather requirements for modeling telecom network into MetaSolv.• Worked with business units and technical team to gather requirements for the design of system integrations related to the automation of network provisioning.• Acted as a SME for pulling data out of various applications related to network design (MetaSolv, Salesforce, and PostgreSQL database that housed network configuration).• Improved network automation success rate 3-fold.

• Led a proactive network maintenance program to identify and prioritize issues in a telecommunications access network for resolution, with the goal of resolving external plant issues before they become customer impacting––resulting in $200K+ in annual savings for field service teams • Wrote algorithms and data pipelines to gather data from Elasticsearch data store using python • Generated output reports that were visualized in Tableau––reported on benefits realized to executive leadership

• Architected a star schema data model to support network engineering analytics.• Created ETL process to pull data from ODS that housed data from disparate data sources and populate the data model.• Created and maintained data dictionary of analytical data model.• Designed and implemented process and algorithm to assist in designing network for network engineering using python and Oracle SQL. Utilized simulations to project ports based on estimated take rates and network configurations.• Created a predictive model for network capacity management using linear regression in python and output model to excel workbooks for capacity management engineers.• Implemented data engineering automations for Chief Data Scientist to test new telemetry systems using python.• Created customer segmentation prototypes and spatial analysis using Alteryx and python.• The collective of work reduced engineering design time 50%, automated a forecasting process that took 20 hours a week, and curated data sets ended up being utilized by all analytics groups in the company.• Served as SME for implementation of analytical systems and tools; gathered design requirements for various network planning initiatives

• Managed a team of 8 direct reports and another manager who had 15 direct reports that supported reporting and application support for a 600-associate organization.• Spearheaded an initiative to move analytics from Business Objects and Crystal reports into python and web applications were applicable.• Responsible for business processes in major OSS and network implementation.• Subject matter expert for querying data out of MetaSolv and other sources systems.• Led a multi-million dollar project to modernize a field dispatching application.• Architected data model for field dispatch application.

• Served as technical lead for system integrations from MetaSolv to network provisioning.• Technical lead and mentor for 10 developers on a major project to convert from one technical stack to another.• Technical resource for implementing data migrations from legacy systems to new systems.• Assisted in the design and architecture of relational data models and APIs.• Gathered and contributed to business requirements for system integrations.• Developed XML web services and system integrations in Weblogic/Java.• Implemented gateway events to trigger automations in MetaSolv.• Wrote operational SQL queries to support reporting and automations.