Experience

ProCom Consulting LLC

• United States

• Data Migration Consultant

  • Feb 2014 - Present

  Solution Architect on project to migrate OSS data from TIRKS,GRANITE and CANOPI to Metasolve / Oracle M6. - Developed approach to extract TIRKS data from IMS source - Created TIRKS ERD - Defined ETL to extract and transform TIRKS, GRANITE and CANOPI data into format used to populate M6 Solution Architect on project to migrate OSS data from TIRKS,GRANITE and CANOPI to Metasolve / Oracle M6. - Developed approach to extract TIRKS data from IMS source - Created TIRKS ERD - Defined ETL to extract and transform TIRKS, GRANITE and CANOPI data into format used to populate M6



Verizon

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Lead Solutions - System Architect

  • Dec 2010 - Feb 2013

  System Architect / Business Analyst / Telecommunications Domain Expert Senior member and Network Systems Subject Matter expert of Data Warehouse BI / analytics development team tasked with providing BI and analytics support to Network Services organization. Responsible for process and data analysis, process and data modeling and system architecture and design. Led initiative to identify and model data needed to support BI, Analytics & Data Broker functionality Analyzed customer order and network inventory processes including TIRKS OSS (19 unique systems and 189 databases across 5 independent regions). The result was the first comprehensive document showing operational flows and the systems, databases and data elements that supported them. The document supplied information that was critical to developing the Network Services data warehouse and support BI / Analytics and data broker requirements. Originated development of BI and Analytics support for service order processes Designed change data capture and ETL processes, static reports and user interfaces. Support included performance metrics and predictive - prescriptive analytics. System provided clients from multiple organizations and at different operational levels, the tools needed to better understand service order flow and provided the insight required to make informed decisions. Show less



VERIZON BUSINESS NETWORK SYSTEMS

• Solutions-System Architect - Software Development

  • May 2005 - Dec 2010

  Partnered with clients and IT organizations to define and develop functionality supporting service availability, address and geographic, reference and regulatory, pricing, access optimization, switch homing and automated end to end path design. Responsibilities included eliciting and / or creating business requirements, designing technical approach and creating system specifications that described inputs and outputs, data transformations and models, business logic, system and user interfaces and audit requirements. Served as project lead for all phases of development life cycle. Projects included operational, process integration and BI / Analytical initiatives. Highlights include: - Identified data integrity and data consistency issues impacting over $22M in revenue - Designed BI / Analytics system to manage, plan and control network inventory data - Initiated program to automate international pricing, path design and switch selection - Designed approach for automating high bandwidth service order process - Responsible for data migration component of system integration initiative - Recommended development of international address validation and geocoding services - Key member of team responsible for designing single end to end service order process Show less



Verizon Business - MCI Provisioning Systems

• System Architect / Lead Developer

  • 2001 - 2005

  System Architect / Lead Developer Development team lead performed data analysis, data extracts, data mapping and transformation, data modeling, data loads, database design, database administration and reporting for entire organization. Member of team that created access cost control system. Ability to controls access cost was primary factor in recovering from Chapter 11. Highlights include: -Co-Authored system to provide comprehensive view of network Inventory and control operational expense by automatically designing the end-to-end path between the customer and Verizon -Instituted reporting system to provide BI / analytical visibility into MCI Network inventory -Co-Authored MCI provisioning Circuit Order Data Warehouse Show less



Verizon Business - MCI Sales & Marketing Systems

• Lead Software Developer

  • May 1998 - May 2001

  Developed and maintained systems and data infrastructure to support sales and marketing, engineering and construction and order entry. The major responsibilities were to find, combine, summarize and disseminate information to many different organizations and support both operation and BI / Analytical business needs. Highlights include: -Created data warehouse containing business demographic detail and MCI local network geography -Co-Authored first web based user interface that at MCI to provide direct access to demographics -Defined approach for business customer naming standards -Developed process to automatically standardize existing business customer profiles -Designed geospatial methodology to identify regulatory Telecom geography from a postal address Show less



COMSYS AND FUNCTIONONE

• Consultant

  • 1995 - 1998

  Independent consultant operating as FunctionOne Software and as an employee of the Comsys Corporation Performed data and statistical analysis using SAS for projects in the legal, pharmaceutical, insurance and telecommunications industries. Independent consultant operating as FunctionOne Software and as an employee of the Comsys Corporation Performed data and statistical analysis using SAS for projects in the legal, pharmaceutical, insurance and telecommunications industries.



CNA INSURANCE

• United States
• Insurance
• 700 & Above Employee

• Data Analyst & SAS Programmer

  • 1995 - 1995

  Analysis and Ad-Hoc SAS programming for health insurance. Co-Authored Actuarial data warehouse and client portal. Analysis and Ad-Hoc SAS programming for health insurance. Co-Authored Actuarial data warehouse and client portal.



NationsBank - Bank of America

• Sr MVS systems programmer

  • May 1985 - Oct 1994

  Responsible for installation, design and management of operating systems, storage management sub-system, third party software and capacity planning. Capacity planning duties included creation of data warehouse containing system performance history and analytical reporting to track performance and predict future requirements -Responsible for moving data in Data Center consolidation projects -Developed program to generate scripts that automated and controlled data movement processes -Designed System Managed Storage architecture Show less



EDS Advanced Solutions

• IT Services and IT Consulting

• Systems Programmer

  • Jan 1982 - May 1984

  MVS systems programmer, responsible for capacity planning, system performance and DASD managment MVS systems programmer, responsible for capacity planning, system performance and DASD managment