Project Maintenance
Resume:
Daniel F. Lerch
Atlanta, GA 404-***-**** ***************@*****.***
Information Technology Analyst
Systems Configuration…Systems Development Methodology…Systems Documentation…Integration
Systems Engineering…Systems Implementation…Systems Analysis…Maintenance and Troubleshooting
Data Conversion…Coding…Risk Analysis…Solution Design…Testing …Seamless Technology…Disaster Planning
Database Administration…Data Recovery…System Functionality…System Stability…Data Migration
Performance Measurement…Strategic Planning…Cost Analysis…Compliance…Project Management...Business Process
Versatile information technology professional with 24 years of experience working at MST on financial programs that supported activities in the following areas: general ledger, financial reporting, purchasing, budgeting/tracking, sales auditing, internal auditing, real estate taxes, legal document storage/retrieval. Proven track record of enhancing company processes that saved the company money by ensuring that programs are accurate and efficient. Reliably managing and synchronizing programs with current or new systems to work seamlessly without disrupting existing business operations, while ensuring checks and balances. Skilled communicator and technical writer, who has exceptional attention to detail while maintaining superior customer service to internal and external constituents.
Technical Competencies
Platforms:
1.Mainframe: Fifteen plus years of experience using COBOL, CICS, IBM Utilities, TSO, Endevor, JCL, and Control-M.
2.Unix: Five years expereince using SH Shell Scripting, Unix commands.
3.Windows Server and desk/laptop: Seven years experience installing applications on this platform and performimng server administration tasks.
Languages:
1.COBOL: Fifteen plus years of maintenance and development experience.
2.CICS: Fiftteen plus years of maintenance and development experience.
3.C Sharp: Three years of mantenance expereince.
4.TIBCO: Two years of maintenance and developement experience.
5.UNIX Shell Scripting seven years of maintenance and development experience.
6.VB .Net: Five years of maintenance experience.
7.PLSQL: One year maintenance and development expereince
8.SQR: Five years of maintenance and development experince
9.Easytrieve: Fiftteen plus years of maintenance and development experience.
Databases:
1.DataCom: Fifteen plus years of maintenance and development experience (batch COBOL and CICS).
2.DB2: Fifteen plus years of maintenance and development experience (batch COBOL and CICS)
3.Oracle, SQL: Fifteen plus years of maintenance and development experinece (batch COBOL, CICS, PLSQL, TIBCO, VB.Net).
4.TSQL: Five years of maintenance experience.
Applications:
1.Payroll: Three years of maintenance and development of COBOL based payroll application (1987 to 1991).
2.Sales Audit: Three years of maintenance of a COBOL in house supplied retail sales audit application (1991 to 1994).
3.Budgeting/Tracking/Reporting: Seventeen years of development and maintance on a in house supplied expense budget, tracking, and reporting application (1995 to 2012).
4.General Ledger: Fifteen years of maintenance of a COBOL based GL appllication supplied by CA Masterpiece (2000 to 2015).
5.Financial Reporting: Seven years of maintaince and development on a financail reporting/database application supplied by Actuate (2006 to 2012).
6.Purchasing: Seven years of development and maintenance for the following vendor supplied applications: Cybiz, Timberline (Sage), ProcureIT (Verian) (2006 to 2012)
7.Legal Information Management: Four years of development and maintenance on a information management application supplied by Interwoven (Automony iManage) (2009 to 2012)
8.Auditing: Seven years of development and maintenance for an internal auditing application supplied by TeamMate (Wolters Kluwer) (2006 to 2012)
9.Taxes: Three years of developement and maintenance on a local and state property tax application supplied by PTMS (2010 to 2012)
Microsoft: Word, Excel, PowerPoint, Access, Visio.
Project Methodology:
1.Well trained in steps of project life cycle and change methodologies
2.Familiar with the roles of the Business Analyst, Project Manager, Product Manager, Testing Advocate, Operations Advocate, and Lead Developer
3.Well versed in the use and the creation of the following documentation: functional specs, technical specs, test plans, project plans, sign offs.
4.Well trained in change control procedures: filling out the request and supplying supporting documentation (management approval, testing, code reviews, and customer approval).
Career Highlights
Macy’s Systems Technology – Atlanta, GA
Senior Analyst/Lead Developer – Payroll & Finance Department (1991-2015)
Consistently and effectively managed constant changes in the retail environment to support Macy's Department Stores. Completing this task required the stabilization and transitioning of older and outdated systems and installing newer products. This task was accomplished with tremendous accuracy and timeliness that contributed Macy's steady growth of sales revenue from $1.8 billion in 1991 to $28 billion for 2014
April 1991 to December 1991- Common Department Class Project- I participated in a company wide effort to convert the process of the merchandise department and class numbers from seven department stores to one common department and class number. My role in this project was to update the business rules (for department and class) in the COBOL sales audit programs for all seven department stores divisions to use one common set of business rules. I also participated in the coding and testing of the COBOL programs that converted the department and class fields in the database tables (for the seven department store divisions) to one common department and class number. This project was successfully completed on time with no major incidents. The successful completion of this project enabled Macy's to report store sales data in one set of reports instead of seven separate divisional reports. Also, this was the first step that Macy's took to consolidate all of there divisional store activities. This project required the use of my COBOL, Mainframe, and Datacom DB, and skills.
December 1991 to March 1992- Roll-out of the RPS Sales Audit Application- I participated in a department wide effort to provide a new sales auditing application. This new application offered a common set of business rules that replaced the business rules for the seven department store divisions. My role in this project was that of a Lead Developer for my area. My team was responsible for stabilizing the existing seven divisional sales audit applications, providing parallel testing with the new RPS Sales Audit application, synchronizing the processing schedules by shutting down the existing divisional applications as the new divisional applications went on line. This project was successfully completed on time and without any major incidents. The successful completing of this project cut down on production interruptions for sales auditing, increased the throughput, improved accuracy, enabled on time posting to GL, and provided Macy's with accurate sales reports for the entire enterprise on or before the required delivery time. This project required the use of my leadership, multi-tasking, planning, communication, COBOL, Mainframe, and Datacom DB skills.
April 1994 to March 1998 – BTR (Budget Tracking Reporting) Project-
I participated in an effort by the Macy's finance department to develop a Macy's customized expense planning and tracking application. My role in this project was that of a Lead Developer. My team was responsible for extracting seven years of expense data from each of the Macy's divisional financial databases. From that point we executed the following tasks: translation, conversion, file transfer to a UNIX platform, and data loading into an Oracle database. My team also developed and installed the interfaces for the daily feeds between the existing mainframe base GL application and the new UNIX base budgeting application. The new application was successfully rolled out to each of the seven store divisions on time and with out any major incidents. The success of this project enable Macy to accurately plan and view payroll and non-payroll expenses (past, current, future) for 180K retail associates. Macy was able to eliminate many costly (time and money) manual planning activities and at the same complete planning activities on or before the required deadlines. This project required the use of my leadership, multi-tasking, planning, communication, COBOL, Mainframe, Datacom DB, Oracle DB, SQR, FTP, UNIX shell scripting, and Control-M skills. My team received a recognition for this effort.
August 1998 to December 1999 – Y2K, New Release and Re-platform BTR Project-
I participated in an effort to update any BTR non compliant Y2K code and to re-platform the BTR application from the UNIX platform to a Windows NT platform. My role in this project was that of a Lead Developer. My team was responsible locating the non compliant Y2K code, changing it, and testing it. We also had to had to apply a new release from the vendor (for the application software) to accommodate the move from UNIX to Windows NT. In August of 1999 the application was successfully moved from the UNIX server to the Windows NT server. In late December of 1999 and Mid January of 2000 the application did not encounter any major Y2K incidents. The Success of this project did not expose Macy's to any Y2K issues and produced a cost savings by moving the application from UNIX to Windows NT. This project required the use of my leadership, multitasking, planning, communication, Windows NT, Oracle, and testing skills.
January 2000 to August 2000 – Convert BTR to VB, DB2, and Re-platform to the Mainframe Project-
I participated in an effort to; convert the BTR application into a VB application, converted the database from Oracle to DB2, and to re-platform the application from Windows NT to the Mainframe. My role in this project was that of a Lead Developer. My team was responsible for converting the interfaces from SQR and UNIX shells to COBOL, CICS, and JCL/PROCS. The platform for this project was mostly mainframe. The successful completion of this project provided the Macy's a much improved application with many new features. The move to mainframe allowed for more efficient integration with the existing mainframe GL application.
January 2003 to March 2004 – Application System Monitoring (ASM)-
I was the project lead for a home grown application systems monitoring application. There was a need in our department to provide 24.7 monitoring for ten of the financial applications that were hosted on the mainframe, Windows, and UNIX platforms. This application was a web based application that used DB2, MQSeires, .Net, and mainframe technologies. I assisted in the design, planning, and deployment of the application. I was also the point of contact with the Macy's infrastructure team that providing my team the MQSeries and mainframe technologies. Platforms on this project were mainframe, Unix, Windows Servers, and Windows desktop (hosted development tools). This project was successfully deployed and enabled my department to provide 24/7 monitoring for our financial applications. Also, this project won the annual Macy's Innovation of the year award in 2004.
January 2006 to March 2012 – Windows Based Financial Applications-
I was one of three lead developers that owned the task of keeping the Macy's Windows based financial application up to date and running 24/7. I was responsible for installing vendor releases and patches, resolving processing issues, and answering questions from the owners of the financial applications. Each release was treated as a project and required coordination with the application owners, my management, the vendors, and my infrastructure department. Platforms on this project were Windows servers and Windows desktops. This project required the use of my leadership, multitasking, planning, communication, Windows Server Admin, Windows Desktop, Database (DB2 and SQL), .Net, and testing skills.
This effort enabled the application owners to have 24/7 access, obtain upgrades/patches in a timely manner, and to do their job. During this time frame my teammates and I routinely received recognition awards.
January 2009 to September 2009 – BTR Enhancement-
In the Fall of 2009 Macy's was restructured into Regions, Districts, and Location hierarchy format. This change required a major enhancement to the BTR application to enable data to be viewed by region, district, and location. I was one of the two lead developers that owned the task of delivering this enhancement. I participated in the sizing, writing of the technical requirements, writing of test plans, time and action planning, risk analysis, deployment planning, and deployment activities. Platforms on this project were mainframe and Windows desktop (hosted development VB tool). The enhancement was delivered on time with no major incidents and the application owners recognized our efforts. This project required the use of my leadership, multitasking, planning, and communication skills.
December 2011 to July 2014 – Oracle EB Project-
In the Fall of 201 Macy's started a $15million project to replace the existing mainframe based general ledger application with Oracle EBS. My role in the project was a lead developer for developing and maintaining the interfaces to keep both the new and the existing general ledger applications in synch with each other. I participated in the writing of the technical specs, creation of test plans, and the coding and testing of these interfaces. Platforms on this project were mainframe, Unix, and Windows desktop (hosted development TIBCO tool). The project was successfully delivered on time with out any major incidents. This success enabled Macy's to comply with the new national and international accounting requirements, avoid costly licensing agreements with other software vendors, implement new cost effective and efficient business processes, and reduce the duplication of efforts that were occurring in other departments. More importantly the move to Oracle EBS enables Macy's to continue it move into the new technologies to maintain its competitive edge in the retail industry.
Education
Bachelor of Science – University of North Florida – Jacksonville, FL
Major: Computer Information Systems. Minor: Business.
Contact this candidate