We provide IT Staff Augmentation Services!

Sr. Programmer Analyst Resume

TECHNICAL SKILLS

Platforms: IBM AS400 & 36, Windows, DOS

Languages: RPG to LE, COBOL, SEQUEL, JDE (&DWV, SVR),VB

Software: JDE One - World, GUS-OS, Aplus -INFOR, Lansa, Gentran/Extol, MS(SQL serverManagement Studio, Visual Studio, Report Builder, SQL Server Integration Designer), SDS Sales Discovery System (data creator and SDS Viewer), Lotus Notes, Outlook, Remedy, Silvon, MS Office Suit, DRV Spool Flex - AS400Reports Now, Infinium, Kronos, EAM, Cognos

Tools: MS Office Suit (Word, Access, Excel), TAATOOLS, SQL

PROFESSIONAL EXPERIENCE

Confidential

Sr. Programmer Analyst

Responsibilities:

  • Creates, maintains, develops and enhances the current software packages for Titan
  • Infinium and Kronos on the AS400 (from RPGLE to RPG Free)
  • EAM (Data Stream) and Cognos on hosted web server
  • Working with Robot job scheduler, report sets - Opal code, devices, etc.

Confidential

Applications Programmer / Business Analyst

Responsibilities:

  • Creates, maintains, develops and enhances the current software packages for our manufacturing company (JDE One World,& BOSS)
  • In-house / on-the-job training and web classes has given me the ability to branch into other areas within the corporation, such as Lansa, JDE, SEQUEL - scripting, batch processing, reporting, EDI / Gentran
  • Member of a rotating on-call schedule
  • Strong ability to produce, test, and document code with minimal supervision
  • Valuable resource during the integration and merger phase from Confidential to Confidential systems and data transfers

Confidential

Applications Manager

Responsibilities:

  • Managed a team of 4 programmers
  • Train end users on new programs implemented
  • Helped our applications team support the current ERP system on GUS (German Software) on a tomcat server
  • Wrote complex SQL code that extracts data from our new ERP and feeds SDS (Sales Discovery System) - saving the company contracting services for this project
  • Wrote the batched files and processing for automation and efficiencies
  • Analyze systems requirements, prepare specifications and work with end-users to define project’s needs (project management).
  • On call 24/7

Sr. Systems Analyst/Programmer

Confidential

Responsibilities:

  • Microsoft SQL Server Management Studio - Prepared Complex SQL statements to extract data from our new ERP & Financial software (GUS-OS-tomcat server)
  • Create, maintain, develop and enhance the current software packages for manufacturing company (APLUS-Infor / Daly & Wolcott ).
  • AS400 - RPG to ILE, CLP, QUERY, SQL, SDA, DFU, RLU SQL, batch processing, job schedule, emails, OCL, interfaces into / from Extol; access databases and excel.
  • In-house / on-the-job training and local classes has given me the ability to branch into other areas within the corporation, such as Access database development, Excel, PC batch jobs, automatic emails, macro automation and more.
  • Develop, analyze and design the data created for the SDS package used by the company to review the corporate budget, forecast, sales, inventory, route management, P.O., Allowances, Rebates, FAH data. (AFS / IRM Sales Discovery System Viewer & Data Creator)
  • Researched, developed, analyzed, designed and coded the new prudential 401K data and the new ING & Prudential data transfer files.
  • Member of a rotating on-call schedule
  • Automated several in-house processes for Accounting, HR, Customer Service / Marketing and Inventory departments saving valuable resources and time
  • Researched, developed, analyzed, designed and coded the new automatic emailing of the broker reports, short ship reports and other automatic reports - ran off the as400.
  • Researched, developed, analyzed, designed and coded a new Production Planning system for our manufacture facility which ties into the Sourcing department purchases in a timelier manner.
  • Analyze systems requirements, prepare specifications and work with end-users to define projects needs (project management).
  • Strong ability to produce, test, and document code with minimal supervision.
  • Possess the ability to adapt easily to changing business needs and project priorities.
  • Project manager on several projects: I have guided several project plans, schedules, monitoring and communications.
  • Strong communication skills with in-house and external persons to direct project tasks
  • Became Database Administrator in August 2006.
  • Create, maintain, develop and enhance the applications on the PC level which includes Microsoft Access databases (basic development to programming)

Confidential

Programmer Analyst

Responsibilities:

  • Developed programs for the solution of a variety of well-defined business problems while adhering to all standards and maintaining a high level of quality and productivity.
  • AS400 - RPG to ILE / free, CLP, QUERY, SQL, SDA, DFU, RLU SQL, batch processing, job schedule, emails, interfaces into Lawson; web page and warehouse management systems.
  • Member of rotating on-call schedule
  • Developed, analyzed and designed the automated inventory reconciliation system and the trigger program(s) that interfaced the web team data to the as400 software packages.
  • Researched, developed, analyzed, designed and coded the new 820 EDI format for payments to vendors (and employees).
  • Member of rotating on-call schedule
  • Automated several in-house processes for Finance, HR, Benefits and Inventory Control.
  • Designed and developed the TAX files, CSVs and reporting to outside agencies for each of the states, the US Tax department and the outsourcing agency.
  • Assist subordinates and interns with debugging and coding.

Hire Now