Candidates About

Sheen Martin

Professional Summary:

Seasoned Application Developer with expertise in coding, application design, testing and QA. Business and technical analysis. Systems and user documentation. Successful project team player, and comfortable in the board room as well.

Skills

·         JD Edwards E1 software development, design and testing         ●     Unix, Windows, DB2, Pick

·         Support, maintenance, and guidance                                              ●     System Interfaces

·         Over two decades of SQL experience                                              ●     Excellent communication skills

·         Extensive hands on experience on EnterpriseOne Toolset OMW, TDA, BSVW, FDA, Enterprise Report Writing, Menu Design, Data Structure (DSTR), Processing Option Design Aid (PODA), Named Event Rules (NER), User Defined Codes (UDC), Data dictionary, Integrations and Troubleshooting using JD Edwards Debugging Tool

Work History

Various consulting roles                                                                     March 2016 – March 2017

Kate Spade & Company, North Bergen, NJ                                     August 2013 – October 2015

Senior Applications Designer Developer

·                     Software development, design, testing, QA, and implementation – primarily Finance (G/L, A/P and A/R) JD Edwards EnterpriseOne (OneWorld) to enhance efficiency and accuracy

·                     Support primary and other modules, Fixed Assets, Purchase Orders, Receipts, Inventory, Distribution, Manufacturing, Sales, etc. to support Finance operations

·                     Technical support for incidents, problems and projects with JDE daily operations

·                     Maintain and support interfaces with external systems (VendorNet, Ceridian, MGIS, direct vendor invoice interfaces) both incoming and outgoing EDI

·                     Support interfaces with internal systems, SEWN and RAMS Systems, Balance, Locate (Retail systems), WorkflowAR, Tequila (Lease)

·                     PL SQL packages, procedures and scripts created and maintained for interfaces as well as JDE code.  Unix scripts     also utilized and maintained.

·                     Create custom Interactive grid input screens for data from Microsoft Excel, to automate manual A/R invoice entry,

which included a custom UBE to load the custom table data to the Z files for posting to A/R and G/L

·                     Increase associate productivity with performance improvement project (included data purge)

·                     Lucky brand sold off, TSA project: data extracts, JDE code changes, transition support

·                     Publicly-traded SOX compliant environment.  ServiceNow product used for incident, problem and project   requests and resolution workflow (SDLC). Documentation for requirements, user acceptance approvals.                Prepare promotion and installation instructions.

·                     Work with third party Visionet staff for support and development

·                     Work with Business Analysts and Finance staff for requirements gathering, documentation and implementations of                 projects

·                     Database maintenance, ad-hoc queries, view creations performed with TOAD tool (Oracle db, BI, JDE)

Home Properties,  Rochester, NY                                                      January 2011 – January 2013

Enterprise Applications Developer

·                     Custom software development, design, testing, QA, and implementation – Finance (G/L, A/P, and Fixed Assets)  JD Edwards EnterpriseOne (OneWorld)

·                     Technical support for incidents, problems and guidance with JDE daily operations

·                     Develop and support interfaces with external systems (OPS Technology, AON Risk Management, AMEX, Registry Monitoring Insurance Services, M&T Bank - positive pay and bank reconciliation)

·                     Support interfaces with internal systems, MRI Property Management System, Microsoft products Excel, Access

·                     Develop SQL Server Reporting Services (SSRS) reports, SQL 2008 R2, using MS Visual Studio 2008, to replace Business Intelligence reports, Data Mart reports, Crystal reports and JDE reports

·                     Lead JDE service pack upgrade from SP22 to SP24, went live December 2011, to utilize SQL 2008 R2 performance on a new VM platform

·                     Perform work in a publicly-traded SOX compliant, SoD environment.  ITIL Foundation certified in 2012, extensive documentation work for business requirements, technical design, and test plans.  ASSYST product utilized for proper request approvals, work flow, QA, user acceptance testing, and production implementation (System Development Life Cycle)

·                     Support JD Edwards software by interfacing with Oracle Global support for SAR creation and resolutions

·                     Work with third party (CDS) software personnel on in house requests for change assigned to them

·                     Work with third party (CDS) to provide and verify JDE CNC package builds and ESU installations

·                     Use SQL Sentry to monitor database activity (blocking, deadlocks, tuning)

Lane Construction Corporation, Cheshire, CT                                January 2004 – June 2009

Computer System Analyst

·                     Custom software development, design, test and implementation – Payroll, HR, and Finance (G/L, A/R, A/P) JD Edwards EnterpriseOne (OneWorld)

·                     Provide technical support for resolving day-to-day production problems and questions

·                     Develop and maintain interfaces between external systems and JD Edwards applications

·                     Provide ad-hoc SQL extracted data, via Excel for payroll, legal, HR, and audit requests

·                     Integrate third party software to EnterpriseOne

·                     Coordinate and assist with implementation of JD Edwards EnterpriseOne updates (ESUs) and maintenance

·                     Coordinate weekly and as required package builds for the full clients and JAS server builds, for new and enhanced software, tables, versions, etc. with CNC administrator

·                     Support CNC activities as required (example: project promotion failures due to checked out objects in project)

·                     Lead Prevailing Wage Timecard Automation project (Payroll – Davis-Bacon act) from payroll manager’s idea, through design, development, testing and implementation

·                     Assist conversion for REA Contracting (acquired company in NC) from J.D. Edwards World (AS/400) to J. D. Edwards OneWorld ERP 8.0 System), go live January 2, 2009

                    - specifically modify existing system for new companies data, setups, program versions, logos

·                     Develop and implement in house MICR check printing with logos (payroll and AP)

·                     AP and Payroll direct deposits and advices emailed with logos (payroll pdf password encrypted with third party Digital Designs Inc software)

·                     Electronic filing of certified payrolls (TxDOT, TRS/Labor Compliance Management. VA, DC, MD)

·                     Electronic filing of wage garnishments to individual States

·                     Quarterly SUI electronic filing – customize per state as needed

·                     Year end customization and support (w-2, 1099s, state wage reporting)

·                     HR electronic file interfaces: 401k to Fidelity, Benefits to BSWIFT, Pension to Hooker and Holcomb

·                     Manufacturing plant inventory and pricing support.  Sales orders support.

·                     Conversion from PICK in-house Legacy System (PICK database on AIX o/s) to J. D. Edwards OneWorld ERP 8.0 System, go live June 1, 2004 with all modules

                   - Primarily Employees, Payroll and Human Resources history, assist with Financials (G/L, A/R, A/P, Tax), Assets, Equipment, Job Cost

·                     Post conversion validation with custom JDE reports and SQL

·                     Ongoing support of Legacy PICK system for some minor systems not converted (Stockholder checks, pension) as well as occasional historical data requests (prior to June 2004 conversion)

Ivanhoe Cambridge Inc., Toronto, ON                                                         April 1994 – December 2003

Programmer Analyst                                                                                                        January 2001 – December 2003

·                     Conversion from IS3 - in-house Legacy Tenant Management System (UniVerse database running Blacksmith Application Development Tools on an IBM RS6000 AIX o/s) to J. D. Edwards Property Management System, go live date was October 31, 2003

·                     Create custom ODBC data transfer using MS 2000 SQL

·                     Create, test and enhance JDE table conversion programs

·                     Post conversion data validation using SQL and on going support, including software maintenance, enhancements, bug resolution, user guidance and system administration duties for IS3

·                     On going support, including maintenance, enhancements, bug resolution, user guidance and system administration duties for in-house Legacy Tenant  Management System (Prime Information and BP99 running on a Prime computer) and the IS3 Legacy system (UniVerse on  unix o/s)

·                     Assist in support of data flow from in-house TIPS (Powerbuilder/Sybase) Leasing and Tenant Administration system through the Prime to IS3.  This included tenant information as well as custom tenant billing programs.

·                     Design, create and implement custom General Ledger interface between IS3 (UniVerse) and JDE

·                     Supply client driven requests such as custom downloads of G/L data for CCRA audits, partner data downloads (often using MS Access and other tools), property cost centre  combines, property sales to other parties

·                     General Ledger/Accounts Receivable warehouse project.  To be able to access legacy G/L and A/R data after IS3 is obsolete. Design, create and implement an SQL database to hold the five years of G/L and A/R before JDE G/L implemented in Jan. 2001.

·                     Currently at level 107 in French language instruction offered by Alliance Français

                                                                                                                                                April 1994 - January 2001

·                     As part of a team, migration of legacy systems from the Prime (Information) to IS3 (UniVerse).  Design, create, and implement custom software.  User participation and sign off in all cases.

·                     Year 2000 project.  Test programs and operating systems for Y2K compliance on IS3 and the Prime.  Enhance programs and apply operating system upgrades on test machines.  Apply same to production systems before January 1, 2000

·                     Markborough, Laing acquisitions, import of A/R data after team imported tenant data to TIPS.

·                     Assist team in GL and AP system migrations/rewrites - 1996

·                     Part of team for Revenue Budget system, tenant and location based (from TI) 1994-9

·                     Part of team for Operating Budget system, 1994-9.

·                     Tenant Information system support, primarily until TIPS system went live in 1996

Education

Bachelor of Mathematics : Computer Science, University of Waterloo, Waterloo, ON (Canada)

Honours Secondary School Diploma, Lakeway Collegiate and Vocational School, Sault Ste. Marie, ON

Certificates and Courses

ITIL Foundations Certificate, 2012, Exam proctored at New Horizons, Rochester, NY

J. D. Edwards courses: Property Management, Address Book, One World Foundation, Table

                           Conversion, Development Tools I and II, Basic and Advanced Report Writing

Blacksmith Developer 1 & 2, Stauffer Information Systems, Oxnard, California

Info/Basic programmer course, Prime Information User and Report Generation, Prime Canada