Summary
Overview
Work History
Education
Skills
Awards Certificates
Accomplishments
Technical Experience
Summary Of Strengths
Timeline
Generic

Charles Schmidt

Flemington,NJ

Summary

Dynamic Senior Database Developer with extensive experience at Lincoln Financial Group, excelling in software architecture and database implementation. Proven track record in release management and system performance improvement, leveraging Informix 4GL, stored procedures, triggers and database design expertise. Strong communicator and team leader, driving successful project outcomes and fostering collaboration across departments.

Overview

26
26
years of professional experience

Work History

Senior Database Developer/Analyst

Golub Corp (Price Chopper)
Schenectady, NY
12.2017 - 09.2018
  • Company Overview: Golub Corporation is the parent company of the medium sized grocery stores Price Chopper and Market 32. Price Chopper operates 137 stores in Upstate New York, Connecticut, Pennsylvania, Vermont, Massachusetts, and New Hampshire.
  • Analysis, design and development of main warehouse system called Exceed (aka EXE) in Informix Genero database system
  • Development of new and maintenance of existing database programs in Golub’s merchandising system, using Informix 4gl

Lead Application Architect, Lead Developer, Release Manager

Lincoln Financial Group/Osaic
Philadelphia, Pa
06.2012 - 10.2017
  • Company offers comprehensive financial solutions across different sectors.
  • Lead database analyst/developer for Advice Next team
  • Current Kanban lead for direct account (Firelight) project
  • Application development in Hyland Software platform (content and process management)
  • Provided training in release management, database development, shell scripting and job scheduling to resources in house and offshore
  • Built relationships with senior executives both in Business and IT that facilitated the buy-in for implementation of new processes and resolution of roadblocks
  • Lead for source code control system migration
  • Member of large team which facilitated migration effort to move current system from HP Unix servers to new AIX Unix servers
  • Modified shell scripts written on HP servers to process correctly on AIX servers
  • Created numerous Autosys .jil files to move scheduled processes off of Unix cron
  • Release Manager using subversion as source code control system to propagate developer’s code from the development server to multiple Quality Assurance (QA) servers
  • Worked with the production deployment team to move QA tested changes to the Pre-Production environment for User Acceptance Testing (performed by business users who requested new changes)
  • Worked with the production deployment team to move Pre-Production accepted changes to Production environment
  • All release management deploys done on scheduled basis
  • Created/modified code using Informix 4gl and Unix shell scripts for business user change requests and production fixes for Broker-Dealer system called Caesar
  • Created/Modified Informix Stored Procedures for new project which optimizes the delivery of the firm's practice resources, tools and technology to advisors
  • Lincoln Financial Group is a Fortune 500 company offering a diverse range of financial services and solutions
  • The department I work in (Wealth Management Department) deals with Broker – Dealer customers and representatives

Lead Software Engineer/Release Manager

Distribution By Air Inc. (d/b/a DBA)
Somerset, NJ
05.2008 - 10.2011
  • .Company Overview: Distribution by Air is a transportation company that delivers products to any point in the world. DBA has a total of 26 company sites located near major airport terminals. The DBA MIS group, located in Somerset NJ handles all of the system needs for all 26 locations
  • Senior member of IT team in charge of design, development and testing server side components for logistics and transportation company
  • Components include pickup tracking, billing, rating and manifesting, ACH function, report design, accounting recap system
  • Set up triggers on core tables (for above processes) to store instances of inserts, deletes and updates for audit tracking – Informix SQL
  • Direct support of 26 terminals stations around the country for their various needs (reports, screen enhancements, processes)
  • Installation and set up of RCS for Unix based source code files
  • Created Accounting Recap system to allow accounting group to pay franchised terminals based on Net Revenue Amounts
  • Created batching system for account to enable the department to pay vendors for services DBA obtained and used
  • Created MIS request system used by all stations
  • Created file transfer process for DBA customers
  • Created manifest alert notification which retrieves current status of deliveries
  • Implemented and oversaw release of software from development to test and test to production
  • Worked with internal groups (accounting, operations, fulfillment and sales) to ensure delivery of new or updated software changes in a timely fashion
  • Managed release of code, which includes tracking versions of the entire product as well as its components
  • Facilitate code release to test and then to production
  • Installed and configured current source code control system
  • Managed new and change requests, including defects and ensured implementation to the proper project release
  • Distribution by Air is a transportation company that delivers products to any point in the world
  • DBA has a total of 26 company sites located near major airport terminals
  • The DBA MIS group, located in Somerset NJ handles all of the system needs for all 26 locations

Senior Software Engineer

Lehman Brothers
Jersey City, NJ
02.2007 - 04.2008
  • Company Overview: Lehman Brothers is a global finance corporation, which serves the financial needs of corporations, governments and municipalities, institutional clients, and high net worth individuals worldwide
  • Design and development of account balance transfer process between an account’s cash account and margin account and between cash account and income account – Informix 4gl
  • Engineering and deployment of daily calculation of closing price and services fees for trust accounts – Informix 4gl
  • Development of business department reports for all departments listed in employer description – Informix 4gl, Java
  • Development of file processing program for trades received from an external partners – Informix 4gl
  • Design and Development of process to hold sales proceeds being pushed to money market fund due to memos held against equity at time of sale – Informix 4gl
  • Design and Development of screens for Money market and Margin departments – Informix 4gl
  • Implementation of ftp automatic ftp transfer of report files to archive server for upload to archive system (view direct)
  • Created and deployed jil files for Autosys scheduler
  • On call support for daily processing of trade, journal and report process
  • Lehman Brothers is a global finance corporation, which serves the financial needs of corporations, governments and municipalities, institutional clients, and high net worth individuals worldwide

Senior Software Engineer

Talk America
New Hope, Pa.
06.2002 - 01.2007
  • Company Overview: Talk America is a competitive local exchange carrier, which provides local, long distance and ISP/DSL service
  • Lead Developer of 3 team commission system
  • Senior member of IT staff in charge of design, development, testing and support of components of server side billing and rating system
  • Components included commissioning, collections, customer deposit maintenance, financial report manager, referrals, credit analysis, customer rewards and customer leads management
  • Lead of project team for commission system
  • Use of StarTeam, RCS and Clearcase for code storage, versioning and escalation to test and production environments
  • Involved in source code and data migration form Informix to oracle system
  • Talk America is a competitive local exchange carrier, which provides local, long distance and ISP/DSL service

Business Systems Analyst

Lockheed Martin Global Telecommunications (LMGT)
King of Prussia, Pa.
04.2000 - 04.2002
  • Company Overview: LMGT is a subsidiary of Lockheed Martin, which specializes in systems integration of Internet systems
  • Analysis of existing customer billing and provisioning requirements
  • Requirements gathering and planning with customer at customer’s site
  • Creation of billing and provisioning requirements for IDC (Internet data center) customer
  • Aided in design of process flows with other subsystems
  • Architecture design of hardware for billing system
  • Cost model creation for hardware and software for billing system
  • Installation of Portal’s Infranet billing system in research and development lab (versions 6.0.1, 6.0.3 and 6.1) including server applications on SUN Solaris server and client applications on Windows NT PC
  • Customization of Portal OPCODEs on SUN Solaris server in C programming language
  • Installation of Seagate Crystal report server used by Infranet billing reports
  • System administration of SUN Solaris Ultra 5 workstation
  • LMGT is a subsidiary of Lockheed Martin, which specializes in systems integration of Internet systems

Business Systems Analyst

Iridium
Washington, DC
04.1998 - 12.1999
  • Company Overview: Iridium is the first telecommunications company to provide cellular communication through the use of low earth orbit satellites, which provides global coverage for their customers and their roaming partner customers who wish to use the Iridium system
  • Training of customer care personnel in use of billing/customer care system for roamer compliance testing (LHS’ BSCS)
  • Used customer care system to activate customer SIM cards for use in roamer compliance testing
  • Performed compliance testing with other cellular carriers using above mentioned SIM cards - compliance testing followed GSM protocol IREG 24
  • Performed IREG 24 testing using Wandel & Goltermann STS (8620)
  • Conducted IREG 24 “Common tests” with numerous roaming partner IREG personnel
  • Used INET protocol analyzer to perform tracking and troubleshooting of signaling events that arrived into the switch
  • Used Siemen’s K1297 to analyze and track SS7 signals during call processing
  • Verified contents of roamer exchange record files (TAP) to ensure file contains proper call records from above mentioned IREG tests
  • Familiar with Siemens D900 subscriber based manipulation
  • (Creation/deletion of subscriber activations, services global titles, etc.)
  • Iridium is the first telecommunications company to provide cellular communication through the use of low earth orbit satellites, which provides global coverage for their customers and their roaming partner customers who wish to use the Iridium system

Business Systems Analyst – Requirement analysis/design

Teligent –CLEC
Virginia
01.1998 - 03.1998
  • Company Overview: Teligent is teleservices provider, which will provide local, long distance and Internet service and compete against the incumbent local exchange carriers
  • Analysis of existing Teligent system requirements
  • (System requirements include billing, rating, products, post billing, taxation, customer care and customer structures)
  • Analysis of Saville’s system requirements
  • Cross-referencing of Teligent and Saville requirements
  • Creation of system requirements
  • Creation of test scripts for billing and rating system to execute against Saville Systems applications
  • Teligent is teleservices provider, which will provide local, long distance and Internet service and compete against the incumbent local exchange carriers

Business Systems Analyst

ICO Services Ltd. (Intermediate Cellular Orbits)
London, England
05.1997 - 10.1997
  • Company Overview: ICO is a Network Operator in the field of telecommunications
  • ICO is a satellite engaging in the use of Satellites at an intermediate orbit around the earth to provide global communications to the mobile Telecommunications marketplace
  • Requirements analysis for subsystems needed by ICO’s business operations subsystem which included wholesale billing, rating, interconnect billing, fraud, roaming, number management, SIM management, partner care, service provisioning, call data management, and decision support
  • Aided in initial creation of test and implementation project plan and process
  • Design and development of issue tracking system for system integrator
  • Access/Visual Basic
  • Analysis of projected CDR volumes processed by ICO’s network
  • Analysis of system performance, development and operational requirements
  • ICO is a Network Operator in the field of telecommunications
  • ICO is a satellite engaging in the use of Satellites at an intermediate orbit around the earth to provide global communications to the mobile Telecommunications marketplace

Cellular Consultant

Bell Atlantic NYNEX Mobile
Bedminster, NJ
11.1996 - 04.1997
  • Analysis, design and development of enhancements to cellular fraud detection system
  • Call records from Bell Atlantic switches are fed directly into the fraud detection system to search for various cellular fraud incidents which include velocity violations, overlapping calls, usage violations, dialed digit analysis, tumbling mobile id’s and ESN’s, and station class mark violations
  • Did analysis of the following: development process and environment, documentation efforts, software build process, test and implementation process and environment, customer requirement and request process
  • Also analyzed design flow of fraud validation process
  • Made numerous performance enhancements to fraud validation process as well as design and development of fraud alarms

Senior Member Technical Staff

Telesciences CO Systems / Lion Software, Inc.
Mt. Laurel, NJ
09.1992 - 10.1996
  • Member of IT team in charge of designing, coding, testing and support of components of billing and customer care software for cellular companies operating in a GSM platform
  • Components include GSM roaming, user interfaces, and reports
  • In charge of project team for roaming services module
  • Database Administrator for Informix database for cellular software package
  • Duties included database changes, backup and tuning, as well as escalation of changes to test and production environments
  • Use of Clearcase source code control platform for code storage, version control and escalation to test and production environments

Education

BS - Computer Information Systems

Bloomsburg University
Bloomsburg, PA

Skills

  • Software Architecture Development
  • Database Implementation in relational databases
  • Release management
  • Proficient in Unix/Linux shell scripting and operating system navigation
  • System Performance Improvement
  • Informix 4GL, stored procedures, triggers, ESQL/C
  • Hyland tools including Hyland Studio, management console, client and config
  • Agile project management
  • Agile tools Jira and Version 1
  • Team leadership
  • Source code control, including Subversion and Git
  • Proficient in Autosys and Stone Branch
  • In-depth Understanding of SDLC Processes

Awards Certificates

Eagle Scout

Accomplishments

  • Development Team lead of technical staff
  • Database professional with 30+ years of experience in industries including telecommunications, finance and logistics
  • Lead analyst on large projects including $1M billing system for major Portuguese telecom company
  • Key contributor to database and infrastructure projects including 9 month migration of Unix commissions system including process scheduling and script changes for major fortune 250 financial firm
  • Detail oriented manager including software release management of 4 Unix servers
  • Lead developer of multiple projects including commissions processing team (headcount = 4)
  • Excellent oral and written communication skills. Provided training to system end users in 3 countries.

Technical Experience

  • Informix (ESQL/C, SQL, 4GL, Stored Procedures, triggers)
  • Oracle (PL/SQL, Stored Procedures)
  • C, UNIX (HP-UX, Solaris, make)
  • Unix Shell Script and Unix OS
  • Visual Basic, Java, Java Swing, J2EE, JavaScript, JSP, JDBC, Orion web server
  • Billing systems (Portal Software’s Infranet, Saville CBP, LHS’ BSCS)
  • FraudTec
  • Scheduling platforms: Autosys, Stonebranch
  • Source code control and archive systems (GIT, Subversion, PVCS, Star Team, SCCS, RCS, Clearcase)
  • Hyland Software, including Unity Client, OnBase Studio, Configuration and Client platforms and Unity Management Console
  • Development kits: IntelliJ (Java), Eclipse (Java), Server Studio (Informix), Toad (Oracle)
  • MS Project, Framemaker, Microsoft Office (Word, Project, Excel, Powerpoint, Access, OneNote), Vermont Views, Visio, Paint Shop
  • Full life SDLC (System Development Life Cycle) strong knowledge of customer requirements gathering, requirements analysis, design, development and testing.
  • Experience in Agile/Scrum environments including Jira and Version 1
  • Release and IT management.

Summary Of Strengths

Accomplished IT Professional with over 30 years of experience including 15 years of telecom experience, with extensive experience in the full software development life cycle including implementation of source code control concepts and release management. Expert in database design and development with supporting server-side applications. Analytical decision maker with strong communication, interpersonal, learning and organizational skills.

Timeline

Senior Database Developer/Analyst

Golub Corp (Price Chopper)
12.2017 - 09.2018

Lead Application Architect, Lead Developer, Release Manager

Lincoln Financial Group/Osaic
06.2012 - 10.2017

Lead Software Engineer/Release Manager

Distribution By Air Inc. (d/b/a DBA)
05.2008 - 10.2011

Senior Software Engineer

Lehman Brothers
02.2007 - 04.2008

Senior Software Engineer

Talk America
06.2002 - 01.2007

Business Systems Analyst

Lockheed Martin Global Telecommunications (LMGT)
04.2000 - 04.2002

Business Systems Analyst

Iridium
04.1998 - 12.1999

Business Systems Analyst – Requirement analysis/design

Teligent –CLEC
01.1998 - 03.1998

Business Systems Analyst

ICO Services Ltd. (Intermediate Cellular Orbits)
05.1997 - 10.1997

Cellular Consultant

Bell Atlantic NYNEX Mobile
11.1996 - 04.1997

Senior Member Technical Staff

Telesciences CO Systems / Lion Software, Inc.
09.1992 - 10.1996

BS - Computer Information Systems

Bloomsburg University

Similar Profiles

CREATE PROFILE
Charles Schmidt