Programmer Analyst Iv resume example

2009 – 2014 - Expanding CRM Environment

Added Credit Processing to Brunswick Channel Sales Application:

Worked with project manager and end users to add credit processing approval flow, screens, and reports to track deposit schedules, payments, signed documents, and email notifications. Integrated credit processing into opportunity and contract processing workflows.

Utilized: Application Architect, System Technical Architect, SQL Server DBA and developer, Visual Basic developer, Windows AD, SMTP, T-SQL, GoldMine API coding, upgraded to new version of Crystal Reports (Business Objects XI) control for Visual Basic, created new embedded Crystal Reports, iSeries data connection from SQL Server using Linked Server, started using Visual Studio 2010 and InstallShield to package application, defined project tasks and estimates, scheduled and reviewed with team throughout development, unit testing, system testing, packaging, installation, configuration, training, and implementation.

Add Brunswick Channel Sales Application to Citrix Servers:

Eliminated complex installs on North American Sales and Product Specialist notebooks, reduce IT support costs by eliminating data synchronization issues and application installs, and reduced data security risks.

Utilized: System Technical Architect, Visual Basic developer, Windows registry, defined project tasks and estimates, worked with Citrix team throughout project, application install for Citrix, FreeFileSync, problem solving, unit testing, system testing, packaging, installation, configuration, and implementation.

Replaced GoldMine UI with New Brunswick Channel Sales Application features:

Added features to improve search capabilities, integrated ERP Customer Account info, added account history, and expanded emailing capabilities. Also, added remaining IT Administrative capabilities.

Utilized: Application Architect, System Technical Architect, Systems Integration, SQL Server DBA and developer, SQL Server developer, Visual Basic developer, DataStage developer, Windows AD, SMTP, T-SQL (including stored procedures), GoldMine API coding, unit testing, system testing, packaging, installation, configuration, and implementation.

Added Quoting and Price Book Capabilities to Brunswick Channel Sales Application:

Worked on while working on two other projects and had to coordinate releasing versions of application with changes comprised of work done for all three projects and plus support issues fixes. Used DataStage jobs for systems integration of item, component, and price lists from ERP for creating quotes, provided means of testing item releases in test quotes before promotion of item updates for use in actual quotes, and allows for sales management visibility to all quotes made to customers for improved sales forecasting. Worked with project team members while designing, coding, and testing new Visual Basic screens and DataStage jobs.

Utilized: Application Architect, System Technical Architect, SQL Server DBA and developer, Visual Basic developer, T-SQL (including recursive queries for data hierarchies), Systems Integration, DataStage developer, GoldMine API coding, designed demo application for presenting to management, defined project tasks and estimates, scheduled and reviewed with team throughout development, unit testing, system testing, packaging, installation, training, and configuration.

Replace Citrix with Remote Desktop Server for Brunswick Channel Sales Application:

Updated application for new environment, added ability to update application automatically when new version was released, and successfully tested on Remote Desktop Server.

Utilized: Visual Basic developer, defined project tasks and estimates, replaced registry settings with settings files and learned how to properly install applications for Remote Desktop Server.

2006 – 2008 - Expanding BI Environment

Automated Weekly Payroll Processing for Retail:

Designed DataStage jobs to pull data from computers at 90 retail centers across North America through high latency satellite data connections, store data gathered into SQL Server database, and then transferring data to iSeries once data had been pulled from the centers for validation.

Utilized: DataStage developer, lookup of hash file data from batch job to get center connection and data criteria and passed through to other jobs that copied data from retail centers to centralized SQL Server database, designed jobs for multiple retry attempts, maintained log records of center statuses, transferred data from SQL Server to iSeries using ODBC.

Implemented Financial Data Mart for Retail:

Assisted with technical issues, SQL Server database and security updates, DataStage job design, and implementation. iSeries was the source of data and SQL Server housed the data mart. Exclusively supported after co-worker left company.

Utilized: System Technical Architect, DataStage developer technical and architectural assistance, standards, and naming conventions, assisted with development issues and batch jobs, helped design SQL Server databases, and helped with Business Objects Universe design.

Supported TimePro for Retail Centers:

Worked with the retail applications team to upgrade and consolidate TimePro on centralized Servers using Terminal Services along with rework to DataStage jobs and setup of new SQL Server and application servers. Updated Visual Basic 6.0 application for maintaining center information (location, equipment, IP addresses, etc.) to allow for better searches, running database, VBS, and bat file scripts in bulk across multiple centers, better ping support, and remote desktop integration.

Utilized: System Technical Architect, Visual Basic developer, SQL Server DBA and developer, purchased application configuration and support, DataStage developer, iSeries using ODBC, terminal services support, and VBS and batch file scripting.

Implemented Point Of Sales and Labor Data Warehouse for Retail:

Designed to take daily cash receipts from iSeries using ODBC and labor from TimePro SQL Server database using OLEDB to populate a SQL Server based data warehouse. Exclusively supported after co-worker left company.

Utilized: System Technical Architect, DataStage developer technical and architectural assistance, standards, and naming conventions, assisted with development issues and batch jobs, and helped design SQL Server databases.

Assisted with Hyperion Implementation:

Helped setup servers and learned primary support tasks while working with consultants and trained on Hyperion installation and configuration.

Utilized: Learned how to manager user security, minor application calendar changes, how data was loaded, integrated backups with Backup Exec backup jobs, and promoting major updates from test to production.

Upgraded DataStage and Data Warehouse Server:

Worked with consultants and IT staff to test over 600 jobs used for simple file transfers, systems integration, and data warehousing. Upgraded to Version 8.0.1 (first version since IBM purchased DataStage) and SQL Server 2008.

Utilized: System Technical Architect, DataStage administrator and developer, SQL Server DBA and developer, helped locate and worked with consultants, Windows Server local and AD account management, testing, defined project tasks and estimates.

Multi-company support added to sales and orders data warehouse:

Worked with consultant to add company number to keys in SQL Server database tables and updated DataStage jobs to include data for specific company numbers and process data by including company numbers in joins and keys.

Utilized: SQL Server developer, segregate key usage for tables with slowly changing dimensions as part of a star schema and multiple levels of fact table aggregation, defined project tasks and estimates, and worked with team of co-workers and consultants to test and implement.

SQL Server Reporting Services Proof of Concept:

Installed SQL Server and SSRS on a test system along with SharePoint integration to test out capabilities with CRM application.

Utilized: System Technical Architect, SQL Server DBA, Windows Local and AD account setup, and SSRS training.

2001 – 2005 - Maturation of Client / Server Environment

Create Account Plan Add-on Application for GoldMine:

Wrote Visual Basic 6 application integrated with GoldMine API to improve productivity of account planning for capital equipment sales staff.

Utilized: Application Architect, Visual Basic developer, API, DDE communications, testing, packaging, defined project tasks and estimates, and implementation.

GoldMine Upgrade:

Reconfigured GoldMine to use with Microsoft SQL Server Express on notebooks to eliminate support issues due to corrupt dBase files and allow for direct reads of Microsoft SQL Server data from Visual Basic 6 Account Plan Application for GoldMine.

Utilized: Application Architect, Visual Basic developer, API, System Technical Architect, SQL Server developer, Windows Local and AD account setup, WinBatch scripting, defined project tasks and estimates, testing, packaging, and implementation.

GoldMine Implementation for Billiards Group:

Reconfigured GoldMine by adding a remote server location, configured application, setup security, imported data, trained, installed, and implemented.

Utilized: System Technical Architect, SQL Server DBA, Windows Local and AD account setup, WinBatch scripting, defined project tasks and estimates, testing, packaging, and implementation.

Upgraded Account Plan Add-on Application for GoldMine:

Updated application to search for accounts and create saved lists (views) of accounts to provide more ease of use.

Utilized: Application Architect, Visual Basic developer, SQL Server developer, defined project tasks and estimates, testing, packaging, training, and implementation.

Sales and Order Summaries Interface:

Added sales and order summaries to GoldMine account history using DataStage to locate updates and update the GoldMine database using T-SQL based stored procedures that use special GoldMine APIs to allow for synchronization of data.

Utilized: Systems Integration, SQL Server developer, T-SQL (including stored procedures), DataStage developer, unit testing, system testing, and implementation.

Update Account Plan Add-on Application for GoldMine into Brunswick Channel Sales Application:

Expanded into opportunity management and forecasting capabilities by replacing existing FoxPro application and adding shipment planning for Logistics and Contract Management departments. Also added corporate calendar maintained in ERP system using DataStage jobs so dates could appear in correct accounting month. Made use of Crystal Reports within Visual Basic and SQL Server views. Trained users in all departments.

Utilized: Systems Integration, Crystal Reports control for Visual Basic with dynamic data feeds, SQL Server developer, T-SQL (including stored procedures), DataStage developer, WinBatch scripting, unit testing, system testing, training, and implementation.

Extended Usage of Brunswick Channel Sales Application for Billiards Group:

Customized code to allow for tracking of tables displayed, account tracking specifics, and reset of displayed data at start of new year. Designed, coded, tested, trained, and implemented.

Utilized: Application Architect, Visual Basic developer, SQL Server developer, WinBatch scripting, defined project tasks and estimates, testing, packaging, training, and implementation.

Upgraded Expert Advisor:

Upgraded application for fixes and to stay current for support agreement while working with technical support staff to merge code versions and implement.

Utilized: System Technical Architect, SQL Server DBA and developer, WinBatch scripting, defined project tasks and estimates, testing, and implementation.

Implemented Expert Advisor for IT:

IT needed a quick and easy solution for a help desk system so we used existing licensing to use application for help desk as well. Implemented with help of other IT staff and helped train.

Utilized: System Technical Architect, SQL Server DBA and developer, WinBatch scripting, defined project tasks and estimates, testing, configured, installation, training, and implementation.

Replaced Expert Advisor for customer technical support with HEAT:

Assisted other IT staff, consultants, and customer technical support staff to configure application and implement while I was working on other projects. I designed server environment, had SQL Server administrator responsibilities, helped setup and test application integration with GoldMine, and automated and documented install process for clients.

Utilized: System Technical Architect, SQL Server DBA and developer, WinBatch scripting, defined project tasks and estimates, testing, configured, installation, configuration, and implementation.

DataStage Upgrades:

Upgraded to Version 4 and later to version 6.0.3 primarily for fixes, performance improvements, and to stay current for support agreement. Migrated and tested all jobs. Also, upgraded to new hardware, Windows Server and SQL Server versions.

Utilized: System Technical Architect, SQL Server DBA, Windows Local and AD account setup, SQL Server developer, DataStage administrator and developer, unit testing, system testing, IT training, and implementation.

Upgraded Business Objects:

Switched from client installs to web based version to significantly reduced support. Worked with technical support to get through issues and trained end users.

Utilized: System Technical Architect, SQL Server DBA, Windows Local and AD account setup, unit testing, system testing, training, and implementation.

Upgraded Lucas Bear:

Upgraded to new version of purchased software used for inventory planning and forecasting while streamlining and cleaning up batch processing to reduce processing time, complexity and support.

Utilized: System Technical Architect, DataStage developer, Windows Local and AD account setup, bat files, unit testing, system testing, training, and implementation.

1995 – 2000 - Start of Client Server Environment

Took over support of purchased sales force automation application called SNAP:

Stabilized and upgraded the SNAP application and migrated from using Gupta SQLAnywhere database to Microsoft SQL Server while working with SNAP technical support and project manager to implement this project.

Utilized: System Technical Architect, SQL Server DBA and developer, configuration, unit testing, system testing, training, and implementation.

Replaced SNAP with GoldMine for Y2K project:

Converted and cleansed data before importing into GoldMine using T-SQL, automated remote and network installs using WinBatch scripting, and implemented using Microsoft SQL Server for network users and dBase files for remote users on notebooks while working with consultant for GoldMine configuration and administration knowledge.

Utilized: System Technical Architect, SQL Server DBA and developer, hardware and software selection, Windows Server administration, WinBatch scripting, configuration, unit testing, system testing, training, and implementation.

Implementation of help desk system (Expert Advisor) for customer technical support:

Worked with customer technical support with testing and implementation of their code changes, helped with multiple system upgrades, used WinBatch to automate client upgrades, and handled all updates to complex SQL Server database.

Utilized: System Technical Architect, SQL Server DBA and developer, ErWin, WinBatch scripting, configuration, unit testing, system testing, training, and implementation.

New data warehouse environment as part of Y2K project:

Lead research and conducted product selection for ETL, database system, backup system, database middleware, and reporting tools with IT team. Selected DataStage, SQL Server, Backup Exec, ErWin, DataDirect ODBC Drivers, and Business Objects. Worked with consultant to integrate AS/400 Robot/Client job scheduler with DataStage. Performed all technical architect design work, product installation and configuration, and implementation work. Helped design and create all databases (including tables and indexes), assisted programmers with all technical issues, coded all batch jobs in DataStage, assisted DataStage job designers with issues, and implemented tape backups.

Utilized: System Technical Architect, SQL Server DBA and developer, DataStage administrator and developer, BusinessObjects administrator, Backup Exec Administrator, hardware and software selection, Windows Server administration, configuration, unit testing, system testing, training, and implementation.

1991 – 1994 - Mainframe Programming

Updated invoicing and sales order acknowledgment reports:

Hired a month before new Mainframe ERP system's implementation and was able to learn mainframe environment, update COBOL and JCL, and test prior to implementation of ERP system.

Utilized: COBOL and JCL programmer.

Additional Mainframe Experience:

Used FOCUS and SAS to create reports and summarize data, updated data entry screens written in CICS and COBOL, and updated COBOL and JCL for nightly processing.

Utilized: COBOL, FOCUS, SAS, and JCL programmer.