We provide IT Staff Augmentation Services!

Sr. Systems Programmer Dc (usa)

2.00/5 (Submit Your Rating)

PROFILE: Extensive experience in the analysis, design, development, testing and maintenance of Database applications with ORACLE, had written specification documents and involved in the building of RICE components (Reports, Interfaces, Customizations and Extensions or Enhancements). Had been extensively involved in the implementation of ORACLE applications release 10.6/10.7/11.0.3/11i in modules like Oracle General Ledger, Oracle Accounts Payables, Oracle Accounts Receivables, Oracle Purchasing, Oracle Project Accounting, Oracle Order Entry, Oracle Inventory, Application Object Library, Oracle Federal Financials, Oracle Federal HR, Oracle HRMS and Oracle Advance Benefits. Experience entails extensive interface with the user community.

SKILLS:

Hardware: SUN SPARC O/S MS DOS 6.2, SCO OPEN SERVER 5.0, WINDOWS 3.11,WINDOWS 95, WINDOWS NT 4.0, WINDOWS 2000 Professional, WINDOWS XP Professional, SCO UNIX, SUN OS 5.5.1,AIX. Intel Pentium 486, IBM Pentium PCA s
Languages &:
Tools Oracle BI Discoverer Plus, Developer 2000, SQL*FORMS 3.0/4.5, SQL*REPORTS 1.1/2.0/2.5, Forms 6i, Reports 6i, PL/SQL, SQL*PLUS, TOAD 8.5.3.2, SQL*NAVIGATOR, SQL*LOADER, PVCS, Subversion;
Database: ORACLE 11g/10g/9i/8.1.7/ 8.0.4/ 7.X/ 6.X 
Oracle Apps: 11i, 11.0.3, 10.6/7

EDUCATION:

Bachelor\'s Degree in Electronics Engineering, Confidential,University

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC (USA) April’10 - Present 
Sr. Systems Programmer on their Oracle KITT Project

  • The client was Implementing KITT and I was responsible for providing technical support on all supported financial applications such as DELPHI (Oracle Federal Financials) and PRISM.
  • Run the DELPHI Interfaces on a daily basis.
  • Update the Oracle KITT Database Tables.
  • Run the Interfaces and refresh the Financial Module Data on a daily basis.
  • Send daily KITT Update to the users via email.
  • Develop and maintain any CR documents related to Financial Module.
  • Perform the unit and system integration tests on all the software changes performed within Financial Module.

Worked as an Independent Consultant from July\'02-February\'09 on Oracle Federal Financials, Oracle Federal HR, Oracle Financials and Oracle HRMS for the following Clients:

Confidential, Raleigh, NC (USA)
IT Analyst for Oracle Financials 11i Support (Release 11.5.10.2) Project

  • The client had done an upgrade to Oracle Financials release 11.5.10.2 and I was responsible for providing Account Maintenance support to the GL, AR, AP and PA modules.
  • Responded to user issues regarding GL, AR, AP and PA modules.
  • Was responsible for making modifications to the Invoice Import program in AP.
  • Opened and Coordinated technical assistance service requests with Oracle Support.

Confidential,Laurel, MD (USA) 
FIS Support Application Developer for Oracle 11i E-Business Suite (Release 11.5.9) Project

  • Provided Oracle applications functional support and developed and maintained custom programs, reports and forms that interface with Oracle HRMS, Payroll and GL financial applications, utilizing Oracle Release 11i E-Business Suite, in order to provide an integrated information system solution to meet the business needs of the agency\'s Finance Office.
  • Developed a report that has all individuals that received disciplinary under reason 39 by org name, job title, disciplinary level, name, race, pay grade and gender.
  • Developed a report to extract workforce data for Human Resources Management annual report.
  • Developed a report to allow for percent increase in salary values for purpose of processing annual COLA.
  • Worked with Oracle support services to resolve customer open issues.

Confidential,Washington, DC (USA) 
Techno Functional Consultant at GPO on their Oracle Federal HR Project
Oracle 11i Federal HR (Release 11.5.9)

  • Was Responsible for all aspects of the implementation of the Oracle Federal HR system to support the Government client.
  • Was Responsible for maintaining all basic HR data elements and automating the Request for Personnel Action (RPA) process.
  • Finalized module setups within Oracle HR.
  • Actively involved in Testing the Oracle HR module.
  • Actively involved in Testing the Oracle HR and NFC integration.
  • Actively involved in Communicating with Oracle Development related to testing of the Oracle to NFC integration.
  • Was Responsible for Tracking issues and communicating with the client HR user community.
  • Was Responsible for Preparing user guides and training material.
  • Trained HR users on the Oracle System.
  • Have deep knowledge of OPM regulations and Federal HR business processes (i.e., RPA, SF-52).
  • Have detail knowledge of the NFC FESI interface.

Confidential,NJ (USA) 
Oracle Consultant

  • Analyzed, Designed, Implemented and Supported the Oracle FDW Project.
  • Produced Standard reports utilizing Oracle Discoverer as the reporting tool and provided reporting capabilities allowing users to drill through to Account and Customer level balance data for domestic deposits and reporting against GL accounts.
  • Provided ability to produce standard reports automatically via scheduled calendar and on demand.
  • Created a set of standard report queries and made available to users for supporting Regulatory Reporting Infrastructure requirements for validation and reconciliation.
  • Provided Production support and Troubleshooting.
  • Participated in meetings with Off-Shore team members in Mumbai on a daily basis via conference calls.


Confidential,DC (USA) 
Functional Consultant at Do Ed on their Oracle Federal Financials Project
Oracle 11i Implementation Environment (Release 11.5.9)

  • Oracle Federal Financials: Actively involved in attending, evaluating and reporting on Functional Sub-Team (FST) meetings and provided immediate feedback to the Department on project approach, plans, schedule, architecture, processes and data. Interfaced with the client on a day to day basis and supported the completion of specific tasks within estimated timeframes and budget constraints. Also reviewed task area work products of the Vendor like design documents and artifacts for completeness and adherence to customer requirements and delivered comments on project product deliverables to the Department. Validated to-be business process flows and configuration set-ups. Also, validated the functional and technical requirements. Participated in Conference Room Pilot (CRP) as per the project plan and evaluated them. Also assisted in SIT and UAT activities and deployment.


Confidential,Washington, DC (USA) 
Technical Consultant at The District of Columbia building their Oracle Federal HR application.
Implementation of Oracle Federal HR Release 11.5.8:

  • Oracle Federal HR: Actively involved in Rapid Process Design (RPD) Sessions on Federal HR module with the Client. 48 Functional scenarios process flow were created during RPD. Developed data mapping document for Employee conversion from Legacy system to Oracle. Also developed Functional and Technical design documents for Employee conversion. Used API’s to load the data from staging table into the core tables. Have extensive working knowledge on Office of Personnel Management (OPM) regulations and Federal HR Business Process like SF-52, RPA and also with NFC Payroll.

Confidential, from September\'98-June\'02 on Oracle Financials and Oracle HRMS for the following Client\'s:

        • Confidential, MD (USA)
        • Technical Consultant at KCI Technologies building their Oracle Advance Benefits and HRMS applications. Customized, tested and implemented the Oracle Application Release 11.5.4:
  • Oracle Human Resources: Developed a program in PL/SQL for the conversion of employees from the Legacy system into the Oracle HR tables using API’s. Used the API\'s to load the data from staging table into the core tables.
  • Oracle Payroll: Customized the Standard Paycheck Report as per the client’s requirement. Also involved in the Loading of Balances into Oracle Payroll. Customized reports for employer compensation like 401k. Implemented and Customized Oracle Advance Benefits as per client needs.
  • Confidential, VA (USA)

Technical Consultant at XO Communications building their Oracle financial applications. 
Customized, tested and implemented Financial Applications Rel. 11.0.3:

  • Accounts Payable: Developed an Interface Program in PL/SQL for P card to AP. Also developed an Interface program to acknowledge Bank of America Transmission.
  • Created a custom check print Report for UK Implementation.
  • Human Resources: Created the ADP – HRMS Interface to include sick, Vacation accruals. Also developed custom Reports including XO Transfer Details Report by Cost Center, New report to list sick, vacation accruals for managers, Exclude Global Employees from headcount detail report by cost centers.
        • Confidential,(USA)

Technical Consultant for Oracle Applications Project. Converted, tested and implemented Oracle Federal Financial Application Release 11.5.2.

  • Oracle Receivables: Developed Interface programs in PL/SQL for Importing Invoice Information into
  • Oracle Receivables Applications Using Auto Invoice.
  • Oracle Inventory: Developed Interface programs in PL/SQL for Importing Item Master into Oracle
  • Inventory Application Using Item Interface.
  • Oracle Cash Management: Developed Interface programs in PL/SQL for Importing Bank Statement
  • Information into Cash Management Using Bank Statement Import Program.

Confidential,MA (USA) 
Technical Consultant for Oracle Applications Project. Customized, tested and Implemented Oracle Applications Release 10.7

  • Oracle Receivables: Developed Interface programs in PL/SQL to integrate Customer Information Using Oracle Receivables Applications Customer Interface. Also, developed Interface programs in PL/SQL for Importing Invoice information into Oracle Receivables Applications Using Auto Invoice. I was involved in the Design, Development of Custom Forms and Reports like Developing a Form for Rental Transactions and HHPP Transactions to get the Service Address, Billing Address, Bill frequency, Cycle Number, HHPP Transaction Number. Also Developed Custom Reports like Daily Detail Report of Charges, Monthly Detail Report of Charges. I was actively involved in constant interaction with the end user at various stages of Development and Testing.
        • Confidential,NC (USA)

Technical Consultant for Oracle Applications Project. Customized, tested and Implemented Oracle Application Release 11.0.3

  • Oracle HRMS: Involved in the Design, Development of a number of Custom Forms and Reports like Developing a form for Payroll to get the Continuous Service Date of various employees. Also I was Involved in the Development of Custom Reports like Life Insurance Report, Salary Review Report, Direct Deposit Advice Report, Check Writer Process & Report.
  • Oracle Purchasing: Involved in the customization of Reports like Purchase Order, Receipt Traveler, Purchase Warehouse Report. I was actively involved in constant interaction with the end user at various stages of Development and Testing.
        • Confidential,MD (USA)

Technical Consultant for Oracle Application Project. Customized, tested and Implemented Oracle HRMS, Oracle General Ledger.

  • Involved in the Design, Development of a number of custom Reports like Employees at Top of Grade, Quarterly Merit Review Summary Report, Classification Book, Personnel Classification Report. Actively involved in constant discussions with the end user in the design and development of the above reports.
  • Responsible for setting up the concurrent programs and attaching the program to a Request Group to view, modify and integrate them with Oracle Applications.
  • Responsible for creating a procedure for generating the Quarterly Wage Listing of employees for the state of Maryland and was also involved in creation of Views for Employee Information, Assignment Information, Salary History and Earnings. Created an extract to get the Employee number, Full Name and Payment Method for all the Employees.
  • Created an extract to get the Employee Number, Last Name, First Name, Middle Name, Job Title, Work Telephone and Organization Id for all the Employees.
  • Oracle General Ledger: Created Budget Extract for CIP Project.
  • Created FSG Reports for Activity Based Costing.

We'd love your feedback!