PROFESSIONAL PROFILE:

• I possess a unique mixture of education, experience, and skills.
• After obtaining three Masters Degrees, my career has encompassed experience in academic research, data analysis, program design and development, and human resource information system programming and operations management.
• I possess multi - lingual programming skills.
• I know many programming languages and I am open minded and not committed to one arena of development.
• I have experience in all phases of the Standard Development Life Cycle.
• I have experience providing data analysis through reports and graphics from off the shelf programs and custom programs.
• I have data cleansing and data transfer experience and I possess system installation and system implementation experience.
• Crystal Reports with an ORACLE database
• SQL Scripting for Lawson and Kronos data extraction
• Custom Application Development with Lawson 4GL / Micro COBOL Application and Screen Development
• UNIX Scripting experience
• AON Hewitt DB Calc Pension System
• Mercer BW5 Pension System
• ProFund Pension System
• Excel VBA and Access VBA
• PowerBuilder, experience as a class creator and client programmer
• INGRES 4GL
• Embedded C programming
• Paradox programming
• Knowledge of Java, C++, Visual Basic, and .NET, FrontPage, BASIC, Fortran, Pascal, and LISP
• Experience with Windows, PC DOS & MAC OS X
• Experience with UNIX, AIX and HPUX
• Mainframe experience
• Full Project Life Cycle Experience
• Designed and Developed user interfaces
• Designed and Developed user test plans
• Designed and Developed User training and User Documentation
• Help file Development with RoboHelp
• SQL programming and query experience
• Data Visualization and Information Architecture experience
• Database experience with ORACLE, DB2, SQL Server, INGRES, ACCESS,
• Paradox, 1022, 1032, KMAN, Rbase, DBase, Foxpro, Datatrieve, and FOCUS
• Database Design experience, understanding of database design and field and table relationships
• Data auditing, verifying, and cleaning experience
• Data Conversion Programming experience
• Data analysis experience using SQL, EXCEL, ACCESS, SPSS, BMDP
• Reportsmith, and Crystal Reports
• System Conversion experience and System Implementation experience
• Exposure to several Pension Systems, served as technical Lead on the conversion of several Pension Administration Systems

PROFESSIONAL EXPERIENCE:

HRIS Operations Supervisor

Confidential, Pittsburgh, PA

Responsibilities:

• Designed and developed monthly crystal reports processes, developed data interfaces between Lawson and vendor systems.
• Designed and developed file transfer and reconciliation processes to vendor systems.
• Designed and developed process for calculating quarterly and annual 401(k) matches, and nondiscrimination testing using Crystal reports and excel.
• Designed and developed UNIX and DOS scripts. Designed and developed annual total compensation statement with crystal reports. Enter and clean database data with SQL statements.
• Supervise the operation of the HRIS system and all its interface and reporting needs.
• Clean data in the database and test the implementation of software updates.
• Provide monthly reports and ad hoc data requests from various departments.
• Implement the process for the annual open enrollment.
• Run reports for quarterly and annual 401(K) calculations. Transmit file to vendor

Programmer Analyst/Systems Analyst

Confidential, Pittsburgh, PA

Responsibilities:

• Designed and Developed Custom Lawson applications using Lawson 4GL.
• Designed and Developed Custom program interfaces between Lawson ERP and Treasury Workstation SAS application.
• Part of a project that developed and implemented Lawson Process Flow project, for an Employee Self Service Process and Annual Enrollment of Benefits.
• Assist with reports and data evaluation, project systems analysis and project management, and application development.
• Debugged and corrected existing application code.

Consultant Analyst

Confidential, Pittsburgh, PA

Responsibilities:

• Created VBA Excel Macros / Application 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 Confidential Vendors, and IT. Custom Application and crystal report design, development, and implementation for department needs.

Senior Consultant / Associate / Programmer Analyst

Confidential, Coraopolis, PA

Responsibilities:

• Programmed Excel applications to assisted in data analysis of open enrollment data, making the process a less of a manual process.
• Custom Developed applications for grievance and discipline data tracking.
• Edited screens and reports in the Lawson Application for more efficient use.
• Developed several custom designed Applications in Power Builder and Access.
• Application maintenance and enhancements of Power Builder and Access Applications developed.
• Converted and applications from GEAC to Lawson ERP system.
• Maintain deadlines of Project Life Cycle. Analyze, clean, and report data.
• Custom developed applications.
• Maintain Pension Administration Software and custom developed applications.
• Liaison between HR Department and Confidential Vendor, and IT Department.
• Assist with software implementations.
• Provide application documentation and training.
• Troubleshoot problems and provide analytical assistance.
• Installed Pension System upgrades and performs system maintenance.

Systems Engineer

Confidential, Pittsburgh, PA

Responsibilities:

• 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. 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.