James F. Greco

*** ***** *****

Bedford, TX *****

412-***-****

My Story: I have worked in a variety of environments over the past 37 years of my professional career. I started in Academia developing custom applications for Educational, and Social Research and Survey Analysis. Then worked in the Health field supporting Health Research and developing custom applications for data entry and analysis at a Hospital. I then took a position consulting in an Electric Company where I started as a developer and ended up supporting the company’s ERP. I developed custom applications with paradox, Power Builder, and Access. I also developed interfaces for their Human Resources Benefits and Pay Roll system. I developed an interface for their timekeeping and ADP pay roll system using Excel VBA. I then assisted in the conversion and installation of Lawson, developed custom screens and reports, and then supported Lawson Human Resources Benefits and Pay Roll system by developing interfaces to the Benefit Vendors, and their Pension Administrator. I then converted their pension system to their Vendor Vanguard, and wrote all of the interfaces to the vendor, and supported the data transfer process to the vendor. I was then laid off by the consultant, and worked supporting Lawson in Academia. The Electric company then hired me as an employee, and I worked for another 6 years when the company laid me off again due to restructuring. I then relocated to the Dallas Fort Worth area to be with family. I gained employment with Children’s Medical Center of Dallas where I have been supporting Lawson Human Resources Benefits, Talent Management and Pay Roll. I would look forward to supporting a system other than Lawson, or moving to a different environment completely. I would love to get back into development where the majority of my career has been.

Skills:

Solution Provider and problem solver

Crystal Reports

Relational Database experience (ORACLE, DB2, SQL Server, INGRES, ACCESS, Paradox, 1022, 1032, KMAN, Rbase, DBase, Foxpro, Datatrieve, and FOCUS)

SQL scripting experience

Custom Application Development with Lawson 4GL PRO COBOL, Infor IPA Process Flow Designer, Power Builder, Excel VBA and Access VBA, Paradox, embedded SQL in C program, and INGRESS 4GL

Lawson/Infor experience versions 7 through 10. Landmark/LTM experience versions 10 and 11. ASYNC and Configuration Console experience

UNIX and DOS Scripting experience

Pension System implementation experience with, AON Hewitt DB Calc Pension System, Mercer BW5 Pension System, and ProFund Pension System

Interface Development for Vendors like: Vanguard, Fidelity, ADP, Cigna, Blue Cross, Aetna, Davis Vision, Superior Vision, Hartford, etc. from various versions of Lawson ORACLE, DB2, and SQL server DBMS system.

Report development using Crystal Reports, SQL, Power Builder, Excel, and ACCESS.

Knowledge of Java, C++, Visual Basic, and .NET, FrontPage, BASIC, FORTRAN, Pascal, and LISP

Experience with Windows, PC DOS & MAC OS

Experience with UNIX, AIX and HPUX

Full Project Life Cycle Experience, RAD, and Waterfall.

Designed and Developed user test plans

Designed and Developed User training and User Documentation

User Help file Development with RoboHelp

Data Visualization and Information Architecture experience

Database Design experience, understanding of database design and field, schema, and table relationships

Data auditing, verifying, and cleaning experience

Data and system Conversion experience from Oracle to DB2, ORACLE to Access, and Access to Oracle, ORACLE to SQL Server.

Data analysis experience using SQL, EXCEL, ACCESS, SPSS

Professional Experience

Children’s Medical Center Dallas November 2016 through Present

Applications Analyst HR

Information Services Business Application Services

Achievements and Responsibilities:

Daily monitoring and troubleshooting of interfaces and IPA processes flows, LTM ASYNC errors.

Trouble shoot, Designed and Developed IPF process flows as needed.

Support of interfaces for Human Resources, Talent Management, Human Capital Management, Benefits and Payroll Suite

SQL Server Designer, development of core SQL statements for Stored procedures, and IPA process nodes

Infor Landmark LTM Configuration Manager

Design of SQL Server Tables and Views

Excel Lawson Spreadsheet Designer

Excel Lawson Add-ins

Assisted with Lawson Infor upgrade from V9 to V10 in the cloud.

Assisted with Lawson Infor Landmark upgrade from V10 to V11 in the cloud.

Assisted with upgrade of Lawson on premise to Lawson Infor Cloud.

Upgraded Fidelity interfaces from Unix ORACLE SQL to SQL Server.

Lawson LBI Smart Notes

Assisted with Open Enrollment Intellias design, and Intellias Payroll configuration.

Assisted with In House Benefits move to Outsource Benefit Provider Empyrean.

Duquesne Light Company November 1995 to April 2009

and April 2010 to April 2016

Started as an IT Consultant Analyst then was hired fulltime

Robert J. DePaul & Associates, Inc. & CynaTek, Inc

Only client was the Duquesne Light Company

HRIS Operations Supervisor/Coordinator

Human Resource Department

Achievements and Responsibilities:

Supervise the operation of the HRIS systems and all its interface and reporting needs.

Clean data in the ORACLE database and test the implementation of software updates and file interface changes.

Implement the processes for the annual open enrollment of Benefits, End of the year tasks, and bi-yearly Compensation Statement.

Run reports for quarterly and annual 401(K) calculations.

Run reports/interfaces for employee benefits like Medical plan coverage, Dental plans, Life Ins., Retirement enrollments, and Wellness incentive, 401(k), Vision Care plan, and 1095C.

Design and develop reports for time off and absence management.

Design and develop all interface file transfer processes and perform monthly file transfers to vendors.

Designed and developed custom applications for client.

Applications were for project accounting and message management, storage of environmental and energy savings data for customers.

Installed Lawson ERP system to replace an existing GEAC system, maintained and assisted in system upgrades.

Designed, developed, implemented custom input screens, reports, and interfaces for various needs throughout the company, like pay roll pay processing, GL, and time management.

Interfaced systems like Pension systems and Lawson ERP HRIS systems written in Lawson 4GL.

Created Excel Macros to calculate future compensation amounts to validate Pension data, Created VBA Excel Macros and Applications to Audit HR Benefits Invoice Billing, and to track File Archiving and File Storage in offsite mine.

Designed and developed and implemented Access Application for disability data tracking. Analyze, clean, and report data as needed.

Maintain Pension Administration Software and custom developed applications. Liaison between HR Department and Pension Software Vendors, and IT.

Custom Application and crystal report design, development, and implementation for department needs.

Education Management Corporation April 2009 through April 2010

Programmer Analyst/Systems Analyst

Achievements and Responsibilities:

Designed and Developed Custom Lawson applications using Lawson 4GL.

Designed and Developed Custom program interfaces between Lawson ERP and Treasury Workstation SAS application.

Developed and implemented a Lawson Process Flow, for an Employee Self Service Process and the Annual Enrollment of Benefits.

Design and development of reports and interfaces needed for data evaluation, systems analysis and project management, and application development.

Debugged and corrected existing application code.

University of Pittsburgh Medical Center November 1990 through October 1995

Systems Engineer II.

Achievements and Responsibilities:

Provided the Trauma Department with an efficient, dependable, and less cumbersome and expensive data registry.

Designed and developed the registry to store and report data for head injury patients.

Designed and developed applications that made the daily data storage and retrieval easier for users.

Planned and designed Trauma Departments IT needs.

After leaving in 1995, maintained a consulting arrangement for another 2 years providing assistance for a system written in the paradox programming language as a part time consultant.

Application / system design, development, implementation, documentation, training, and maintenance for systems written in Ingres 4GL with embedded C and embedded SQL, Paradox, Dbase, Access, and Power Builder.

University of Pittsburgh May 1983 through October 1990

University Center for Social and Urban Research and

University of Pittsburgh Learning Research and Development Center

Research Analyst/Senior Programmer Analyst

Achievements and Responsibilities:

Installed a computerized survey collection and analysis system.

Cleaned and checked survey data to find and correct errors before data analysis.

Configured statistical programs to analyze collected data.

Designed and developed databases for storage of the collected data.

Assisted in planning and design of departmental IT needs.

Served as departmental technical resource.

Provided survey data analysis and reports for projects. Provide supervision of data entry and analysis.

Liaison between center and vendor of survey collection and analysis system.

Implement and maintain survey collection and analysis system.

On the project for Educational Evaluation

University of Pittsburgh Learning Research and Development Center

Designed and developed database to store education research data.

Designed and developed pilot system for automating daily attendance tracking and reporting.

Designed and developed system to interface and store student achievement scores.

Lead programmer and departmental technical resource, departmental database resource, department data analyst, department developer and application / system implementer.

Prepare and load collected data into database for analysis with statistical software.

Wrote code for statistical software (SPSS, BMDP), and analyzed data.

Education:

Masters in Information Science

University of Pittsburgh - Graduate School of Library and Information Sciences

Masters of Public Administration

University of Pittsburgh - Graduate School of Public and International Affairs

Masters of Urban and Regional Planning

University of Pittsburgh - Graduate School of Public and International Affairs

Bachelor of Arts and Science

University of Pittsburgh - College of Arts and Sciences

Contact this candidate