Programmer / Analyst Resume
Summary
Understanding of software industry and knowledgeable with SDLC and application development. Proficiency in using various application development tools, and knowledge of SQL, PL/SQL scripts in Oracle database. Good communication skills and sound understanding of business applications.
Experience and qualifications
- Comprehensive understanding in PL/SQL, Oracle SQL, Perl, Unix/Linux
- Proficiency in SQL, Windows, Unix, and Linux environments
- Working knowledge of JDE EnterpriseOne (E9.0), HR and payroll, and some technical knowledge
- Intermediate knowledge of accounting, finance, payroll, and human resources systems
- Various projects completed related with finance, trade equity, and human resources
BS in Computer Science & Business Management
Software/Hardware Environments
SQL, SQL Developer, Oracle Application Server, AS400
JD Edwards EnterpriseOne (E9.0), Oracle HRIS, Payroll, Ceridian
Microsoft Office products (Word, Excel, PowerPoint, Outlook)
Confidential, 07/2010 – Present
Programmer / Analyst (Intermediate)
- Hands-on in a Windows and Unix/Linux environment
- Created several tables, views, indexes, and table joins, using Oracle SQL and PL/SQL, for order management of trade equity applications
- Ability to create Views, Materialized views triggers, and procedures
- Updated tables of order processing in Equity Trading system using SQL
- Performed database performance tuning under supervision and instructions of senior DB-Staff
- Understanding of PL/SQL concepts: Data Modeling, ETL, Data Warehouse, External Table, etc…
- Wrote Perl scripts for utility and database search programs
- Basic experience in creation of HTML page using Perl CGI script
- Filtered and extracted data from application tables as per user requirements, formatted retrieved data in excel spreadsheet, imported and exported data into various formats
- Understanding of various Unix commands and Unix Cron Tab/Job
Environments: Unix/Linux, Oracle 10g, Windows, Trade Equity Management system, Perl (6.0), HTML, PL/SQL Developer 9.0, etc.
Confidential,NJ 07/2007 – 07/2010
HRIS Associate
- ADP payroll administration (bi-weekly) and manage overtime reports.
- Employee joining, induction and maintenance of employee database, personnel files and record keeping
- Benefits management - Health insurance, COBRA, 401K, Attendance management and maintaining compensation.
Enter and maintain computer records, including recruitment files and tests, general files and other information on sick leave, punch corrections, vacation pay, attendance reports, and hourly time records in HRIS system. - Ensure Tax Credit is in compliance for all hires as well as adhering to all state and federal regulatory employment requirements inclusive of I-9 compliance, work permits and payroll practices, and Target minor regulations.
- Reviewing and maintaining Job Application System (JAS) and distributing application packets to applicants and assisting with routine recruitment related questions.
Environments: HR Zone (HR – including confidential data) – Payroll MAX-FSTL (Timesheet), CONVAR – JAS / TAS (Job / Talent Application System), AS400, Forrester Wave HRMS (Q4, Q3), PeopleSoft, JD Edwards