We provide IT Staff Augmentation Services!

Technical Consultant Resume Profile

2.00/5 (Submit Your Rating)

LA

SUMMARY

IT professional with extensive experience with all phases of SDLC in both PeopleSoft HRMS and mainframe Application Support. Demonstrated strengths in all aspects of report generation including various mainframe report writers, Cobol and SQR modules, SQL in Oracle, and some familiarity with PeopleSoft Query. Mentors application developers, interfaces with users, and creates specifications and documentation. Excellent verbal, written, and interpersonal skills as well as a proven track record of delivering high quality results on time and under budget. A Passion for problem solving system customer needs.

EXPERIENCE

Confidential

  • Benefits Division of world-class payroll provider, providing benefits support for client companies.
  • Environment: SQR, SQL, Oracle, Unix, Windows 2003, Toad, Benefits

Business Analyst

  • Provided Business Analysis support for clients on Enterprise benefits package, using Oracle in Unix environment.
  • Maintained accurate benefits data for clients, correcting data issues, and performing mid-plan year mass data adjustments.
  • Provided ad hoc reporting using SQL as requested.
  • Met client needs by tracking and maintaining benefits files, such as Cobra, FSA, and Payroll deductions.
  • Ensured successful nightly benefits' batch jobs by tracking and maintaining jobs, while on call.
  • Documented Business Analysis processes, thus ensuring complete transition of the tasks for future BAs.
  • Provided detailed accurate requirements/specifications for program changes.
  • Produced validated regression test bed by performing complete testing of program changes.

Confidential

  • Consulting firm providing services and outsourcing.
  • Environment: SQR, SQL, Oracle, Unix, Windows 2003, Toad, Benefits

Technical Consultant

  • Provided Business Analysis support for clients on Enterprise benefits package, using Oracle in Unix environment.
  • Trained in Benefits system Support.
  • Added and validated new Annual Enrollment rates for various clients.
  • Performed Annual Enrollment testing.
  • Produced occasional 'ad hoc' report.
  • These activities facilitated a smooth Annual Enrollment for the clients with which I was involved.

Confidential

  • Energy provider resulting from merger of Commonwealth Edison ComEd and Philadelphia Electric PECO , with over 5.5 million electric customers.
  • Environment: PeopleSoft HRMS HR, Payroll, T L, GL , SQR, SQL, Oracle, Visual Basic, Unix, ManageNow, LDRPS, COBOL, JCL, Online FileAid Batch DB2 , QMF, Windows 2000, Librarian, Endevor, Visual Source Safe

Senior Programmer/Analyst

  • Provided application support of PeopleSoft HRMS using Oracle in Unix environment.
  • Maintained enhanced Payroll reports and occasional HR report so users could better able ascertain success of Payrolls and impacts of Payroll on HR.
  • Developed full 'life-cycle' Payroll reports and interface system so that the users could track the data from Payroll to the various interfaces.
  • Worked on Oracle SQL extensively, including in several App Designer views, from inception through implementation. These views allowed the programming staff to oversee the data flows as they were sent from HRMS to the Payroll checks.
  • Supported nightly payroll close and nightly reporting SQRs using Oracle SQL Plus, PeopleSoft SQRs, and People Tools to allow nightly processes to complete in a timely manner.
  • The following were steps involved in the successful implementation of PeopleSoft HRMS:
  • Participated in implementation of additional reporting SQRs after merger, including some experience with T L.
  • Participated in Upgrade of various reporting SQRs, including the SQRs behind panels.
  • Participated in regular tax upgrades of PeopleSoft HRMS.
  • Maintained Level-2 Help Desk using ManageNow.
  • Supported legacy Telon-based mainframe Leave Accrual system written in COBOL with IMS DB / DC and an Expense system written in COBOL with DB2.
  • In preparation for the upgrade in the PeopleSoft product:
  • Took training in PeopleSoft 8.4 People Tools and Application Engine and in the use of LDRPS for Disaster Recovery Plan.

Confidential

Midwestern consulting firm providing services and outsourcing for over 30 years.

Technical Consultant

Confidential

  • Environment: SQL, Oracle, PeopleSoft, COBOL, Assembler, JCL, Windows 95
  • Supported HR, Payroll and Billing applications.
  • Supported implementation of PeopleSoft HRMS Payroll System, using Oracle SQL Plus, PeopleSoft SQRs, and People Tools.
  • Maintained mainframe assembler batch billing system producing 120,000 bills daily. System required 24-hour monitoring and monthly enhancements.
  • Wrote support interfaces for the mainframe Genesys HR and Payroll package written in COBOL.

Confidential

  • Environment: Windows 95, COBOL, Assembler, JCL
  • Reengineered Assembler Data Access system and Documented COBOL Data Validation system on the mainframe.
  • Determined program flow, charted I/O, and rewrote modules to smoothly and logically perform the same tasks without changing results of Data Access process.
  • Identified and documented all data paths in Data Validation process.

We'd love your feedback!