SUMMARY:

• Systems Architect/Manager/Lead Software Engineer with twenty years of progressively responsible software engineering, data/systems architecture and related information technology experience; expertise in database coding, BSS/OSS architecture, and systems support
• Skilled at fostering cooperative working relationships with management, vendors, and clients; ability to effectively lead, motivate, and coordinate cohesive, high - performance teams
• Strong interpersonal, verbal, and written communication skills with both technical and non-technical audiences; ensures strong communication and consistent status reporting
• Highly motivated; able to work independently and within aggressive time constraints
• Outstanding analytical, creative, and quantitative skills; detail-oriented

TECHNICAL SKILLS:

Technology: Oracle (7.x - 11g; Forms 4.5, 5, 6, Reports, PL/SQL, Designer, Developer 2000), SQL Server 2000, MySQL, SQL* Plus, Remedy ARS, Business Objects (5.x-XIR2), Crystal, Erwin, MS Project, GraphDB/Neo4j, TOAD, BEA Weblogics,, Agile, Jira, SDLC

Solutions: BSS/OSS SOA, TOGAF, Zachman, UML, SDLC (Agile, SCRUM), BPM, Architectures and Solution Artifacts, Data Warehouse, Data Governance, DDL, ETL, Web Services

BSS/OSS: Oracle Metasolv (4.2.x, 5.x, 6.x). Granite Xng/Xpercom, SingleView (ADC), DSET, CBP/400 (Saville), Netcracker, Remedy, Vitria, ASAP, OSM, IPSA, Kenan FX

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect/Lead Developer

Responsibilities:

• Work with ELNK business units to establish data process and transform rules
• Build ETL scripts to migrate inventory related data into separate MSS instance
• Add to existing delegation functionality to exchange data with 3 additional source legacy databases across a shared inventory database supporting the order entry, provisioning and service delivery functions
• Work with the business to user test 5,000+ test cases and remedy bug fixes as needed
• Handle go live production support to script additional data cleansing and cleanup.
• Oversee the design and implementation of the work delegation portion of the NextGenMSS project
• Work as part of architect team to define the approach of synchronizing work management functions (order creation, provisioning plan assignment, task creation, task processing) across three MSS instances to keep a PSR in sync through the lifecycle of a PSR.
• Assist in translating design into physical NoMagic design documents
• Develop code and lead other developers in implementing the customization code necessary for work delegation as part of NextGenMSS
• Successfully rolled out the production go live for NextGenMSS
• Handled post go live bug fixes and new development as it related to work delegation

Confidential

ETL Developer/Migration Specialist

Responsibilities:

• Augment the Oracle CGBU staff as part of a Metasolv data migration and consolidation project.
• Work with Frontier to consolidate all network/customer inventory from TIRKS and DS into Metasolv
• Perform source data mapping, translation, and loading for network and customer circuit records
• Specialized in circuit migration and cleanup.
• Leverage the Oracle MMT to perform by weekly migration cycles
• Assist post launch with cleaning up outstanding defects
• Build PL/SQL scripts to cleanup post migration fallout for network/equipment/circuit reconciliation and location maintenance.
• Utilize the Oracle migration tool suite, where needed, to run mass reconcile cycles for circuit loads.

Confidential

OSS Architect

Responsibilities:

• Design lead for company wide transformation project impacting all critical business systems
• Vendor management between Oracle Communications and Tech Mahindra including resource allocation, contract management, SOW review, and work deliverables throughout the project
• System consolidation of redundant functional systems and databases. Including Metasolv to Metasolv, Netcracker to Metasolv migration work
• End state design to implement Oracle RSDOD framework with OSM/ASAP/IPSA/MSS
• Future state design to include a transformation of 3 billing, 4 inventory, 3 quoting/sales, and 4 order capture platforms.
• Oversee a technical team of roughly 30+ consultants both off shore and in the US
• Develop and present to the business an ongoing roadmap for transformation roll out over a 2 year span of the project
• Involved with integration of new product roll outs from the marketing teams to ensure functional integration into the system design for delivery
• Provide data architecture management across the OSS stack
• Function as a Metasolv SME for on going development and database maintenance

Confidential

Lead Software Engineer

Responsibilities:

• Metasolv administrator responsible for successfully implementing upgrade of version M6: Metasolv is an end-to-end customer care, trouble ticketing, provisioning, and work-flow system used to manage a current customer base of approximately 5,000.
• Granite administrator handling day-to-day user support, data gathering and report creation and all system integration tasks with Xpercom and internal IT systems.
• Data warehouse specialist responsible for maintenance and report creation of enterprise warehouse.
• Data migration specialist handling data imports into Oracle/Unix-based Metasolv as a part of ongoing market acquisitions. Migrations include bidirectional data flow with Metasolv and Granite/Xpercom.
• Data migration specialist handling extraction of required provisioning and network data from Metasolv, electronic order capture and data warehouse to complete sale and transition of key markets (Covad, ICG, FDN, LDMI, McLeod, Xpedius)
• Manage vendor relations (including Granite, Metasolv, and Remedy, as well as third-party professional service vendors) for recurring maintenance and contract renegotiations on various software suites.
• Day- to-day technical project lead requiring customer interaction as well as issue management and technical team leadership.
• Troubleshoot day-to-day user issues within the Metasolv application requiring a thorough understanding of the application components (service requests, network, provisioning plans, etc.) as well as a complete understanding of the back-end data model.
• Oversee small teams of users to derive end-user testing and validation
• Data warehouse developer designing and deploying Oracle and SQL Server based data warehouse across entire business entity. This particular warehouse is a conglomerate of data from 2 different provisioning systems, a billing system, an inventory management system, and trouble ticketing system; the overall architecture covers three different instances and provides enterprise-wide reporting and data accountability.
• Developed, tested, and implemented numerous Metasolv custom extracts and data validation procedures and triggers to provide a more efficient end-user experience.
• Remedy Administrator responsible for maintaining ARS Help Desk, NOC trouble ticketing, Field Services Dispatch and Electronic Order capture systems, which encompasses all customer-based trouble support for both internal and external customers.
• Developed Electronic Order Capture system within Remedy to allow sales representatives to electronically submit customer orders from the field to allow for flow-through provisioning on orders per day.
• Integrated TBS inventory with Vibrant network costing system to allow the company the ability to begin reconciling close to $5M of disputed charges.
• BusinessObjects Administrator/Developer responsible for maintaining and designing close to 20 universes and over 200 Business Intelligence reports.

Confidential, Pittsford, New York

Manager, OSS Application Development

Responsibilities:

• Led team of OSS developers responsible for all external interface development and third party integration against TBS application, including APIs, DSET electronic bonding implementation, E911, voicemail, and calling card interfaces.
• Handled all aspects of project management from tracking and ensuring appropriate resources, investigating and resolving issues, fostering positive customer relations, and scheduling.
• Metasolv SME overseeing new OSS rollout of TBS application in conjunction with SingleView and various support systems targeting new billing, provisioning and ordering infrastructure.
• Promoted after three months for demonstrating needed leadership and extensive knowledge of key OSS system. This position was eliminated when Mpower filed for Chapter 11.

Confidential, Pittsford, New York

Lead Software Engineer

Responsibilities:

• TBS Technical SME and Lead Developer for various Java, VB, and PL/SQL interfaces.
• Developed necessary database level procedures to assist in API interaction.
• Technical Lead for rollout/testing of DSET e-bonding solution.

Confidential, Rochester, New York

Software Engineer/OSS Support Specialist

Responsibilities:

• Provided 3rd level system support on Telecom Business Solutions (TBS) OSS system, resolving user issues and data integrity violations, and maintaining system schema.
• Managed/maintained TBS API gateways for electronic bonding order processing and automated billing integration.
• Developed Oracle-based applications for in-house utilization, comprised of Oracle Developer tools and SQL PL/SQL.
• Designed and implemented collocation tracking system within Oracle Forms.

Confidential, Rochester, New York

Senior Software Engineer

Responsibilities:

• Developed Oracle-based GUI applications utilizing Forms for in-house data manipulation and maintenance.
• Developed Oracle application GUI for CCDB system based on tax court case ruling.
• Assistant DBA, maintained various tables, user accounts, and packages utilizing Enterprise Manager, including designing ERD used in project conception.
• Developed Visual C++ application utilizing TCP/IP connectivity to retrieve tax based data from external company to in-house user application.
• Developed text-processing programs utilizing Omnimark.

Confidential, Syracuse, New York

IS Technician/Assistant LAN Administrator

Responsibilities:

• Troubleshot and maintained operations/connectivity of four LANs (Novell/OS/2 based), an AS400 system, and over 200 PC’s.
• Systems Administrator of Novell LAN controlling three OS/2 client/server-based LAN connections.
• Technician on District Support Center providing immediate solutions to all extended centers.

Confidential, Ogdensburg, New York

Database Programmer/Consultant

Responsibilities:

• Design and develop data tracking application to provide better access to Confidential t record sourcing.