Expert in Business Analysis
Over the past 20 years, Expert has also worked as an independent part-time consultant developing and deploying several MS Access and MS Excel applications and more recently, designing heuristic business modeling tools and making significant contributions to a wireless In-Building workforce certification training program. Expert specializes in maintaining existing MS Access and VB codebases.
Prior tenures resulted in large scale business impacts (notably during the mid-2000’s instituting a technical configuration program that supported wireless build-outs of 100+ million/month sales at its peak, and devising a physical inventory management and tracking system for a major telecommunications carrier whose sales totaled several billion annually).
Since 2013, recent assignments have been focused as a technical-business liaison developing and implementing business requirements which facilitate business operations:
• Business Advocate, interfacing between business constituents and IT, fashioning business requirements to support IT transformation as the result of corporate mergers.
• Development of integrated database applications supporting customer physical and financial inventory management, Quote-to-Cash enterprise applications, complex product configuration, and E-Business systems introductions.
• Design and deployment of an automated telecommunications repeater tuning calibration tool for 3G Location Based Services which reduced turnaround time from several days to 30 minutes.
• Development and maintenance of custom production MS Access software database applications specializing in data interchange between MSExcel and MSAccess, supporting both internal and external client requirements.
2017 - present:
• Development of a rules-based Excel application used by a holding company to predict marketing “sweet spots” for wireless infrastructure investments.
• Support of a large government laboratory contract to upgrade their commercial and public safety wireless communications systems, during which he collaborated on writing the RFP for vendor acquisitions (OEM, Systems Integrator and MMRD)
• Joint development and delivery of a wireless workforce development In-Building adjunct training certification program, delivering course modules via live webinars and face-to-face, commissioned by the Wireless Infrastructure Association (WIA), a national wireless training trade organization.
A system engineer by training, Expert began his career as Electrical Engineer in various development roles in hardware and firmware design, systems integration and performance testing. Circa 1990, Expert transitioned from (undisclosed company) to AT&T Network Systems in to a Product Management organization during the early days of wireless adoption. Several years later, he became interested in Microsoft Office development technologies (MS Access, MS Excel, MS Powerpoint and VBA application development) and began developing applications for clients in his spare time. For the next 15 years, he used his database application development skills to define new roles within the corporate enterprise as a systems analyst and continued developing new skills in client requirements analysis, business process analysis, process re-engineering, acceptance testing and documentation, which span many years of project experience. Within the past 5 years, Expert amassed sufficient project hours to qualify for a Certified Business Analyst certification along with taking the required coursework.
He possess excellent planning and organizational skills, exceptional analytical skills, effective written and verbal skills and a strong functional as well as technical understanding of client requirements.
Industry/Business Sectors: In-Building Telecommunications, Enterprise IT Transformation, Systems Analysis, Business Process Analysis, Process Re-engineering, MS Access Database, MS Excel VBA, Visual Basic for Applications development
Technical Skills: Data analysis, Client Requirements Development, Business Process Re-engineering, Microsoft Office applications (Excel, Access, PowerPoint, Word) VBA development; Visual Basic; Java; PL/SQL, SQL, data access pages, database analysis, design and implementation, SAP Sales & Distribution, Object Oriented software development and C# programming.
Expert may consult nationally and internationally, and is also local to the following cities: New York, New York - Yonkers, New York - Newark, New Jersey - Jersey City, New Jersey - Paterson, New Jersey - Elizabeth, New Jersey - Bridgeport, Connecticut - New Haven, Connecticut - Stamford, Connecticut - Philadelphia, Pennsylvania
|Year: 1987||Degree: MBA||Subject: Finance (International Certificate)||Institution: Seton Hall University|
|Year: 1979||Degree: MS||Subject: Electrical Engineering||Institution: Stanford University|
|Year: 1978||Degree: BS||Subject: Electrical Engineering (Mathematics double major)||Institution: Tufts University|
|Years: 2017 to Present||Employer: Undisclosed||Title: Principal Solutions Consultant||Department:||Responsibilities: Expert is principal solutions consultant at his eponymous firm, where he has been employed from 2017 to present.|
|Years: 2011 to 2017||Employer: Various||Title: IT Transformation Professional||Department:||Responsibilities: From 2013 to 2017, Expert undertook IT transformation supporting the integration of Alcatel-Lucent and NOKIA information systems architectures, corporate governance and quality metrics development and reporting, managed various operational topics (pre-merger) to consolidate business processes across multiple disparate groups. Before this role, from 2011 to 2012, Expert developed requirements for, developed and delivered stand-alone MSAccess telecommunications repeater tuning application incorporating complex mathematical algorithms, context-sensitive input file parsing, Google Earth kml file generation, dynamic MSExcel reporting interface functionality, and installation scripting. The application implemented a 3G positioning calibration engine accomplishing a significant turnaround time reduction from days to minutes.|
|Years: 2001 to 2012||Employer: MS Access||Title: Application Development, Integration and Deployment||Department:||Responsibilities: Expert was tasked with MS Access database application development and administration. He undertook ongngoing MS Access database development supporting enterprise requirements for physical inventory management, product structure hierarchies and custom reporting. He implemented user security within Access databases deployed in multi-user mode in a WINNT share point environment. Expert developed integrated file transfer scripts to comply with specific file format requirements, export custom report data and initiate file transfers. He also developed user interface formats to support user import/export of data files with validations and error reporting.
During this time, Expert was also responsible for MS Excel VBA Application development and implementation, in which capacity he designed and implemented data migration utilities importing data and format converting from various data sources. He wrote user interface front-end quality validation checking and error diagnostics. He specialized in data interchange between MS Excel and MS Access.
|Years: 1996 to 2012||Employer: Various||Title: Product Management Operations||Department:||Responsibilities: Expert supported recent corporate efforts to standardize configured product nomenclature targeted at compliance with Rosetta Net standards (GTINs) and identification of current operational customer gaps with the ordering of Lucent products. Engaged corporate operating units, incorporated vertical business requirements including the migration to Contract Manufacturing, interfacing from the Order-to-Cash stream to Product Data Management systems and identified current gaps with the current product nomenclature and operation. Identified a standardized information architecture supporting configured product nomenclature across the corporation.
Supported recent corporate initiatives to standardize product configuration efforts throughout the corporation. Worked as part of a Lucent-wide team to drive the analysis of relevant business and technical requirements, formulated the business process, gaps and identify solutions which provide business value-added to the current operations while concurrently supporting current business needs. Supported corporate RFP activities in evaluating alternative suppliers of vendor software supporting these initiatives.
Implemented client server database applications supporting the development and ordering of wireless applications. Application resides on a shared WINNT folder and is accessible via data access pages over the corporate intranet.
Business and technical requirements lead migrating existing client/server support processes over to an e-commerce/e-business environment.
Developed Wireless Networks Group application configurator development program supporting $1 - 5 Billion sales annually. Managed systems platforms introductions away from embedded Legacy systems; manage introductions of SAP and Trilogy while supporting current operations. Assumed development responsibilities for several complex product configurators. Established and refined the operative configurator development processes project managing the efforts of multiple organizations including product managers, sales teams, technical requirements and support personnel and CIO development and systems testing staff.
Co-authored and implemented several operations processes including simplified orderable item development, order realization and product configurator development. These operative processes supported a $5B wireless annual revenue stream.
|Years: 1990 to 1996||Employer: AT&T Network Systems||Title: Business and Product Management||Department: Network Wireless Systems Operations||Responsibilities: Within database administration, Expert was responsible for Contract Database (CDB) Pricing, Administration, Planning, Management and Quality nationally for domestic Wireless accounts. Planned and managed the development and implementation of methods and procedures for CDB compliance with the terms and conditions of customer contracts; re-engineered the contract load procedures to migrate from an interactive to a batch environment using a DOS application uploaded onto a UNIX platform; performed audit of bid & proposal configuration utilities to verify accuracy of pricing data against corporate databases.
Directed the activities of the product support group of seven product managers responsible for product planning and operations of the AUTOPLEX System 1000 cell-site, switching and optional features products; developed product life cycle strategies considering cross-elasticity and profitability issues; managed rollout; new product introduction; and deployment programs for new and current products. Supported first commercial introductions for new product offerings; established new product forecasts and pricing for cellular products.
|Years: 1979 to 1990||Employer: AT&T Bell Laboratories||Title: R&D||Department:||Responsibilities: With the research and development department, Expert held various hardware, firmware, software and systems engineering development positions working on 5ESS switching systems stratum 3 network clock synchronization and Subscriber Loop Carrier systems.|
|Licenses / Certifications|
|Registered Professional Engineer, NJ, April 1987, License
Master of Business Administration, Finance, International Certificate, May 1987, Seton Hall University, East Orange, NJ.
Master of Science in Electrical Engineering, Sept 1979, Stanford University, Stanford, CA
Bachelor of Science in Electrical Engineering, May 1978, magna cum laude, mathematics double major, Tufts University, Medford, Mass.