We provide IT Staff Augmentation Services!

Business Systems Consultant Resume Profile

3.00/5 (Submit Your Rating)

NJ

Summary

Twenty years experience in management, programming, business requirements analysis, business process re-engineering, software design and development in a variety of industries including insurance, banking and financial institutionsAssociation Memberships Institute of Electrical Electronic Engineers IEEE

Technical Summary

  • Languages
  • PowerBuilder 19 years with PFC class library versions 2.0 through 11
  • Unix Shell scripting using Korn, Bash and Bourne
  • MS Visual C , Visual Basic, Access, Realbasic, Xbase varieties Clipper, Dbase, FoxBase, FoxPro , Paradox,
  • Databases
  • Oracle 7 through 10g including PL/SQL
  • MS SQL Server versions 6.X through 2005
  • Sybase through Adaptive Server Enterprise and Adaptive Server Anywhere
  • MySql, PostgreSQL, Firebird.
  • Platforms Microsoft platforms including Windows 95, 98, XP, 2000, 2000 Server. Other platforms include Linux, Unisys mainframe, HPUX.
  • Tools PVCS and Visual Sourcesafe for version control. Xpediter, Toad, dbVisualizer for stored procedures. ERwin and PowerDesigner for database designs. Visio for flow charting, MS Project for project management. Balsamiq Mockup and Flairbuilder Mockup for prototyping.
  • Experienced integrating and interfacing client server systems to legacy systems through gateway products and writing middleware layers between legacy systems and client/server.
  • 15 years experience developing and implementing solutions across numerous technical and functional environments.
  • 15 years of experience writing comprehensive project specifications and user manuals.
  • 4 years of experience with developing WEB sites using HTML. PHP, MySql, NetObjects and maintaining WEB servers

Recent Experience

Confidential

Business Systems Consultant

Project management, analysis, business analysis, design and application design using 4th GL languages and database management systems. Proficient in the following languages, database systems and tools PowerBuilder with PFC through version 11, PowerDesigner, C , HTML, PHP, MySql, MS SQL Server, Sybase, DataEase, DataFlex, Apogee, OHanlon ODBS, Clipper, Xbase languages, C, Microsoft Project through version 2003.Extensive database experience using Oracle and PL/SQL, MS SQL Server and Transact SQL, Sybase, and others.Clients include corporations in New Jersey, Pennsylvania, and Delaware. Major account examples include:

Confidential

Law Firm Collections Department

Application architect and designer for a collections application for a law firm. The application was designed using Powerbuilder and the PFC class library. Extensive use was made of the security aspects of PFC to control user access permissions to various portions of the application. The design included complete database definition and implementation. . The current database may be either Firebird or Sybase ASE based on user requirements. Allowances were also made for the use of Oracle if desired. The design methodology incorporated wireframe prototyping using both Balsamiq Mockup and Flairbuilder Mockup tools.

Confidential

Delaware Investments/Macquarie

Business analysis and reverse engineering on servers, applications, databases and email systems. Performed comprehensive interviews of employees and client and produced combined documents which included Requirements Documents, Functional Design Documents and Technical Design documents. I assisted in restructuring software and hardware systems based on those documents. Objective was the migration of more than 200 servers with all associated applications and database systems.

Confidential

Cendant Mortgage PHH

Developed modifications for mortgage and lending applications which interfaced to an external Cendant client. Primary language was Powerbuilder with an Oracle 8i database where Oracle procedures and functions were also developed. I also developed interfaces to middleware layers which were written in C and Java.

Confidential

American Business Financial Services

Responsible for project management and business analysis on Unix mainframe based banking system which performs accounting on CD and money market instruments. Interfaced to several databases including Oracle 8i, MS SQL Server, and Oracle Financials through data exports. Facilitated business process design and reengineering sessions. Conducted requirements and technical design sessions. Evaluated alternatives for an external database and managed the process of moving the proprietary Unisys database to a MS SQL Server image for reporting through Cognos tools. Negotiated contracts with Cognos and Fiserv. Also maintained additional support systems written in Powerbuilder, FoxPro, VB and Access. Other tools include Microsoft Project, Toad, Powerpoint.

Confidential

Technical Team Leader

Responsibilities included evaluating technology products, recommending solutions, and implementing recommendations. Facilitated business process design and re-engineering sessions. Conducted requirements and technical design sessions as required for each project. Performed data requirements analysis and database design.Assigned to the Capital Markets Division at First Union where I was the Technical Team Lead and manager of the Philadelphia development group. Responsible for all aspects of managing the department including project management, application architecture, customer interface, and development. Tools used include PowerBuilder 6.5 with PFC, PowerDesigner, Xpediter, Erwin, Microsoft Project. Primary database was Sybase 11.X with additional databases in Oracle. Project manager for procurement of new desktop systems during the integration of CoreStates into First Union.

Confidential

Senior System Designer

Senior software development engineer working on new insurance and underwriting applications. Primary development tools include PowerBuilder 2.0 thru 5.0 , Microsoft SQL Server, PowerClass Library, EDA MDI Gateways. Applications included wide area network connection to multiple databases, host connectivity thru EDA to DB2 and VSAM, DDE to Lotus and EMAIL.

We'd love your feedback!