We provide IT Staff Augmentation Services!

Senior Programmer/analyst Resume

Lake Forest, IL

SUMMARY:

IT professional with twenty years of extensive experience in full life cycle software development and technical leadership. Experienced with front end development, database design and methodology documentation. Readily adapt to new technology via and implementation experience. Worked directly with clients. Confidential strong analytical, logical and problem solving skills. Ability to perform multiple tasks and adjust priorities based on workload. Proficient to plan and execute major projects with minimal supervision, effectively resolve critical problems. Experienced in working within formal methodology for software development. Work experience includes applications for Reinsurance, Brokerage, Manufacturing, Real Estate, Health Care, Legal and Government.

AREAS OF EXPERTISE:

Operating Systems : Windows 7 Pro/Ultimate Windows 8.1 Pro Windows 10 Pro

Development Tools and Databases: IBM Rational Application Developer 9 SAP PowerBuilder 12.6 InstallShield Premier 2013, SAP Adaptive Server Enterprise 15 SAP SQL Anywhere 10 IBM DB2 Enterprise 10.5, Microsoft SQL Server Enterprise 2014 Java SE 6 Microsoft Project 2013, Microsoft Office Professional 2013 Microsoft Visio Pro 2013 Crystal Reports 12, System Center 2012 R2 Service Manager Microsoft Access 2013 IBM Rational ClearQuest, Microsoft Visual Studio Ultimate 2015 Oracle11g Database Adobe Acrobat Pro DC

EMPLOYMENT HISTORY:

Confidential, Lake Forest, IL

Senior Programmer/Analyst

Responsibilities:

  • Modified multiple legacy applications to insure 64 - bit Windows 8.1 and Active Directory compatibility
  • Participated in development of data warehouse to pipeline XML files from 3 rd party services into SQL Server database
  • Created Master Data File generation tool to streamline enrollment procedures using Visual Studio (ASP.NET) & Crystal Reports
  • Migrated multiple modules and reports from legacy data sources to SQL Server database
  • Rewritten Rating Engine for enrollment applications using PowerBuilder and Java
  • Added support for new products & riders to enrollment management applications using PowerBuilder and Visual Studio (ASP.NET)
  • Implemented security enhancements for multiple applications to comply with state requirements
  • Optimized InstallShield scripts to simplify deployment of applications to remote clients
  • Collaborated with team in the development of new version of enrollment application using Java
  • Created functional and technical design documents for multiple core components and interfaces
  • Designed multiple mainframe interfaces (including commissions, batching, etc.) using Java
  • Participated in Data Modeling for new application implementation
  • Provided support for internal users and external clients
  • Created SQL scripts and custom reports on users' requests

Confidential, Chicago, IL

Senior Programmer/Analyst, Consultant

Responsibilities:

  • Converted reporting modules from UNIX Wind/U to Windows PowerBuilder platform
  • Migrated PowerBuilder source to never version to be compliant with client standards
  • Implemented message - driven reports-on-demand service using PowerBuilder
  • Modified multiple PowerBuilder reports according to client requirements
  • Created mass-mailer for reports distribution to handle more than 500 recipients using PowerBuilder and IIS
  • Provided on-site and remote to Confidential employees
  • Continued to support applications part-time on client's request

Confidential, Downers Grove, IL

Senior Programmer/Analyst, Consultant

Responsibilities:

  • Collaborated with team in the development of Confidential project (releases 3.3, 3.5 and 3.6) in three - tier environment
  • Enhanced Customer Service Management and Price Plan Management modules using PowerBuilder
  • Created a set of PL/SQL scripts for Oracle database in UNIX environment to populate tables with data
  • Developed Address Update functionality to enhance tax calculations for Confidential products and services
  • Participated in development of Deploy Billing feature to manage billing options for Non-Reseller accounts
  • Redesigned Customer Service Agreement printing routines to in corporate new Price Plan features
  • Implemented data mirroring from web based Bill Payment application into Customer Service Management module
  • Created PowerBuilder custom classes to perform Customer Service Management related common tasks
  • Utilized TUXEDO libraries to access middle-tier functions written on C and COBOL
  • Created multi-level testing scenarios for Customer Service Management and Price Plan Management modules

Confidential, Chicago, IL

Software Engineer/Business Analyst/Documentation Writer, Consultant

Responsibilities:

  • Participated in the Order Management Documentation project
  • Reverse engineered and created Data Model for Order Management Oracle Database using ER/Studio
  • Researched Business Processes work flow for Order Management Suite
  • Documented Order Management source code written on PowerBuilder, Java, COBOL and PRO C
  • Researched and documented UNIX scripts and Oracle PL/SQL code for Order Management, EDI and Logistics modules
  • Developed utility to convert UNIX script loader lists into Excel spreadsheet using PowerBuilder
  • Created batch procedures for source code scanning using PowerBuilder and 3 rd party software
  • Participated in creation of Business Logic flowcharts using Visio
  • Worked directly with users in multiple Confidential locations to gather necessary information

Confidential, Downers Grove, IL

Senior Programmer/Analyst, Consultant

Responsibilities:

  • Collaborated with team in the development of Confidential 2.9 project in three - tier environment
  • Enhanced a variety of modules (Customer Service Management, Point-of-Sale, etc.) using PowerBuilder
  • Created a set of PL/SQL scripts for Oracle database in UNIX environment to create/modify tables and populate with data
  • Developed Selective Bill Inserts (SBI) module for targeted marketing of Confidential products and services
  • Implemented Status and History modules for Promotional Freedom project using PowerBuilder
  • Created PowerBuilder objects for browsing / editing of multiple application and tables
  • Utilized TUXEDO libraries to access middle-tier functions written on C and COBOL
  • Participated in testing of modules created by other team members (Campaign History, DNC, etc.)

Confidential, Indianapolis, IN

Lead Software Engineer / Business Analyst, Consultant

Responsibilities:

  • Led the migration of entire SSACI environment to the most current XP/2003 compliant version of PowerBuilder
  • Outlined schedule of tasks leading to SSACI goals, provided project completion estimates to the client
  • Migrated PFC and Non - PFC SSACI PowerBuilder applications from to latest version
  • Modified SSACI applications to comply with new Windows XP style design standards
  • Transferred customized PFE extension layer of client PFC applications into the new libraries
  • Rewrote / removed obsolete PowerBuilder code and PFC objects / functions
  • Adapted PFC Security application to client specifications using PowerBuilder
  • Worked with the client to resolve migration issues according to client s requests within project scope

Confidential, Rosemont, IL

Database Developer / QA Tester, Consultant

Responsibilities:

  • Led the team of consultants working on database conversions and front end enhancements
  • Designed business plan to accomplish project goals within client s challenging schedule
  • Created a set of Microsoft SQL Server tables, stored procedures and scripts to automate complex testing tasks
  • Was responsible for maintaining data integrity of Microsoft SQL Server databases modified in conversions
  • Worked on optimization of routines designed for creation of XML files
  • Performed QA testing for modules designed by team members using Microsoft Visual Studio

Confidential, Chicago, IL

Senior Programmer/Analyst

Responsibilities:

  • Collaborated with team in the enhancement and maintenance of a variety of accounting modules for reinsurance brokerage
  • Designed user interface using PowerBuilder and server side business logic implementation using Sybase Adaptive Server
  • Created server components that allowed clients to view up - to-date accounting reports from the Internet using EA Server
  • Created a set of stored procedures and triggers for Sybase Adaptive Server to move accounting business logic to back end
  • Created a utility to maintain users' access levels for specific applications and business tasks
  • Implemented currency-independent accounting logic for worldwide reinsurance brokerage applications distribution
  • Expanded PFC library with business related user objects and services
  • Created a set of objects to communicate with Jaguar server from applications and Internet Explorer plug-ins
  • Utilized PowerBuilder internal version control features to insure source code integrity while developing in team environment
  • Migrated outdated source code into PowerBuilder applications and optimized their performance

Confidential, Itasca, IL

Programmer/Analyst, Consultant

Responsibilities:

  • Led the design, coding, testing and deployment of Brokers Revenue Accounting software using PowerBuilder and SQL Server
  • Worked with large mutual funds companies to determine their data warehouse standards
  • Created stand - alone data import module to pipeline data provided by mutual fund companies to the Confidential data server

Confidential, Minnetonka, MN

Software Engineer

Responsibilities:

  • Participated in the development and implementation of Managed Care applications in mixed two and three - tier environment
  • Redesigned and implemented Broker Tracking System software
  • Interfaced with clients to determine their specific needs and enhanced multiple programs on their requests
  • Provided technical support for existing applications

Confidential, Chicago, IL

Programmer/Analyst/Tech Support

Responsibilities:

  • Collaborated in the development of PowerLaw Legal Case Management software using Clipper and PowerBuilder
  • Developed a utility to transfer user data between Xbase, Microsoft Access and Sybase databases
  • Provided customer service and technical support for customers and resellers

Hire Now