SUMMARY: 

14+ years of total experience with 13+ years of extensive experience in Oracle Applications 11i and R12+ - HR, Payroll, OTL, OAB, AR, AP, GL modules and Workday HR and Payroll modules. Experience includes full lifecycle Oracle HR, Payroll, OTL, OAB, Labor Distribution implementations, Receivables, Payables, MDM which include requirement gathering from business, studying the existing processes, documentation of requirements, understanding the functional design specification and creating detail design specifications, estimating and scheduling projects, coding, testing and migration followed by production support. Complimented with strong analytical, troubleshooting and problem solving skills along with interpersonal, written and verbal communication skills.

ERP Expertise:

• Expertise in implementing and customizing Oracle OM, HR, Payroll, OTL, Labor Distribution and Oracle Advanced Benefits, AR, AP, GL modules.
• Worked on the Workday implementation project and integration Workday HR and payroll with Oracle.
• Managed all implementations with a high degree of client satisfaction. Projects were completed on schedule and met all utilization and profitability targets.
• System Analysis (“as-is” and “to-be”), Requirement Study, Specification generation, Test Plan Preparation, Technical design and Coding, UAT, Production Migration and documentation in Oracle and Oracle Applications
• Oracle PL-SQL expert with vast experience on application performance tuning and shell scripting.
• Expertise on Oracle Applications data migration/conversion (technofunctional)
• Expert on usage of third party tools and softwares and their integration with Oracle application system.
• Expertise in interfacing with external systems like ADP, benefit providers, 401k, ESPP, Bank of America, Courion, Taleo, Talx, Aflac, ETrade, HRB, Benefits Focus, Siebel on demand, Merrill Lynch, IATA, Concur, Cor360, Monster.
• Worked on multiple HR, Payroll, Receivables and Payables conversions starting from business requirements phase through the post-production support phases.
• Vast experience in documentation, post implementation support and process management.
• Strong knowledge of Application Object Library (AOL), TCA, Web ADI, OA Framework, BI Publisher and System Administration.
• Vast experience in custom reporting to cater to business needs.
• Trained on Six Sigma, Quality Assurance, Defect prevention and AIM methodologies.

TECHNICAL SKILLS:

Domain expertise:

• AP/AR Invoicing
• Insurance
• Banking
• Fuel management and pricing
• Payroll taxation
• US Government
• Pharmaceuticals
• Educational (universities)
• Aviation
• Marine
• Corporate 
• Service contracting

Functional Expertise:

• Human Capital Management
• Time and Labor
• Advanced Benefits
• Payroll
• Labor Distribution
• General Ledger
• Treasury
• Receivables
• Payables
• Order Management

Technical Expertise:

• Oracle SQL, PL/SQL
• Oracle Developer 2000 - Forms and Reports 6i, 9i,10g.
• Forms personalization, customization.
• UNIX - Shell scripting
• OA Framework
• Workflow
• DOS - Batch programming
• JAVA, XML.
• ODI.

PROFESSIONAL EXPERIENCE:

Confidential

Miami, FL.

Oracle Lead Consultant

Responsibilities:

• Workday implementation and Workday to Oracle Integration (Workday/Oracle HR/Oracle GL)
• Involved in gathering business requirements for Workday implementation and gathered requirements for Workday to Oracle integration, designed the following integrations.
• Designed, coded using PLSQL, tested and also performed UAT with business.
• Created master interfaces from Workday to Oracle using Oracle HRMS APIs for loading HR Locations, Organizations, Jobs from Workday.
• Designed and coded processes to load following data groups from Workday to Oracle.
• Created processes using Oracle HRMS APIs for loading Employees, Contingent workers, Addresses, Phones, Contacts, Extra information types, Special information types, Assignments, Assignment criteria, Costing and Salaries, Requisitions and Vacancies, Employee transfers from one business group to another business groups.
• Designed and coded Workday payroll to Oracle GL interfacing.
• Designed and coded Oracle to Bank of America Merrill Lynch interfacing for stock vesting and participation.
• Modified processes for Oracle interfacing to TM1 budgeting tool, Oracle Interfacing to Active Directory/Email Server and Oracle to Success Factor interfacing program.
• Created reports for validating data from Workday through SOA interfaces.
• Worked on production support enhancements for this project.
• Coordinated with offshore teams, DBA teams, Release management, banks, business users and vendors.
• WFS WorldStore Online Project (Oracle HR)
• Gathered requirements, designed the architecture and programmed interfacing between Oracle HR and WFS Online Store.
• Development of the processes and interfaces using PLSQL, SOA.
• Performed Unit testing, integration testing and involved in UAT and production support.
• IATA XML 3.1 Aviation invoicing upgrade project (Oracle AR)
• Gathered requirements and designed new processes for generating receivables consolidated invoices in IATA XML 3.1 formats.
• Developed/updated complex invoicing processing using PL/SQL.
• Worked on performance tuning of processes.
• Performed Unit testing, integration testing, involved in UAT and production support.
• Worked on enhancements or these processes.
• Receivables invoicing for a new acquisition - Colt (Oracle AR/OM)
• Involved in requirement gathering for generating AR invoices in required CSV10 and CSV20 air formats.
• Created programs using PLSQL, performed Unit testing, integration testing.
• Involved in the CRP, UAT of this project.
•  Oracle Treasury and FXALL project (Oracle Treasury)
• Worked on updating custom Oracle forms for exposure entry, aggregations and authorization.
• Created new inbound and outbound interfaces between FXALL and Oracle using PLSQL and Unix shell scripting.
• Modified existing inbound interface from FXALL to Oracle Treasury and performed unit and integration testing.
• Stanley Security interfacing (Oracle HR)
• Worked on the project enhancements to Stanley Security interfacing from Oracle (PL/SQL).
• MDM supplier hub conversions and integrations (Oracle MDM/Supplier hub/Customer hub)
• Designed and developed Suppliers conversion programs using PLSQL. Worked on 4 MDM R12 supplier conversions in different implementation phases, consolidation, reporting requirements and generation.
• Guided IT vendor teams with the requirements, development, testing, UAT and post production support.
• Took over post production support, carried out requirement reviews, design reviews, code reviews, functional testing for various releases and enhancements.
• Used EDQ tool for customer profiling, deduplication and for identifying matched and non-match records that needs to be reviewed with the business.
• Gathered requirements for various integrations, provided estimation and design analysis. Lead the development efforts on different technologies like ADF, BPM, Filenet, Sharepoint, MDM.
• Worked on the testing of integration of supplier hub and custom hub with SRM (Oracle Sales Cloud), testing of Sharepoint integration of customer credit request checks and Filenet integration with Oracle CRM and customer hub for storing documentation required for the new supplier and customer requests.
• Involved in CRPs, identified gaps and bugs in the system and reported the same to the management. Worked with vendor to prioritize gaps and fixes and monitored the development.
• COR360 enhancement (Oracle AP)
• Working on the requirements and design for the process enhancement of COR360 invoicing.
• Development, testing of changes required for this enhancement.

Tools used: Application Dev Tools - Developer 2000 - Forms and Reports 6i, 9i, 10g. EIS payroll processing and reporting. TOAD, PLSQL Developer, SQL Navigator, Hummingbird, Workflow builder, Appworx, JDeveloper. CM and ticket tracking Tools - VSS, MKS, Clearcase, Heat, Kintana, Vizio. Sharepoint, IBM Filenet Operating Systems - UNIX, Solaris, Windows XP/2000/98/NT

Confidential

Miami, FL.

Oracle HRMS Tech Lead.

Responsibilities:

• Requirements gathering, design for new projects and change controls, technical flow design creation.
• Assisted developers with requirements, design, coding, unit and integration testing, tuning.
• Created reports and assisted users with labor reporting, AAP reporting, EEO reporting, ADP reporting, benefits reporting.
• Designed and developed custom labor costing solution for various companies of MasTec.
• OTL and projects time reconciliation, Payroll to GL reconciliation.
• Supported OTL time entry for different companies, payroll runs, costing, transfer to GL, GL/Payroll reconciliation, payment transfers to banks, check printing, miscellaneous transactions.
• Pre and post patch testing, Coordinated with DBAs for rollup patches, RUP patches, year end testing, coordinated UATs.
• 11i to R12 migration of different companies of MasTec, identified HR, Payroll and OTL RICE components, migration planning, organization, job, position, elements, payroll mapping.
• OTL time entry rule modifications, OTL timecard layout modifications.
• Modified fast formulae for payroll (401k limiting, skip rules)
• PTO accrual rule modifications for various companies based on their requirements.
• EIS reporting and payroll processing updates. Also, worked with EIS support to upgrade the tool and debug any issues.
• Coordinated with Oracle support for production issues, patches, high severity tickets.
• Worked on custom reporting for higher management including the biggest cost component - labor cost.
• Responsible for benefits open enrollments load, MasTec Census population and coordination with benefits vendor.
• Designed, coded and modified inbound and outbound interfaces to/from Oracle and external systems like Merryl Lynch, Prudential, ETrade, Benefit Focus.
• Designed and coded custom payroll pre-process for handling prevailing wage requirements for various companies of MasTec.
• Supported MTE module which is a custom time entry system for one of the companies of MasTec.
• Worked extensively to correct payroll balances.
• Modified Oracle forms for timekeeper entry.
• Coordinated with GL, AP, AR, inventory teams for integration testing and UAT.
• Modified OTL custom workflows for custom time approval hierarchy.
• Worked as an EIS administrator, migrated reports to production, user security and provisioning.
• Setup security profiles for restricting data access in HRMS.
• Design organization and supervisor based custom reporting for employees’ paystubs.
• Worked with SOA team to create interfaces from Siebel to OTL and from payroll to Siebel.
• Made form personalizations to restrict view of certain tabs, fields and to alter item properties based on the business requirements.
• Updated custom checkwriter process for the formatting to be compatible with check printing process.
• Created processes using public HRMS APIs to mass update person, assignment, salary, element entries for employees.
• Created HRMS conversion processes for MasTec companies.
• Created Census file programs for benefits vendors and benefits deduction load program in Oracle.
• Created a custom module for employee chargeback and reverse chargeback processing for one of the companies of MasTec operating in different states.
• Worked with Courion for automated password reset project in Oracle applications and windows
• Created a program for mass termination of employees (in 11i) after moving them to a new prod instance (R12).
• Involved in the interfacing of TALEO and Oracle.
• Analysis and troubleshooting of time entry issues, testing of different timecard layouts, integration of OTL to Projects, wrote timestore APIs.
• Worked with ADP to update periodic and quarterly interfaces.
• Modified Talx (work number) interface for unemployment claims reporting.
• Documentation of existing processes using AIM methodology.

Technology/Softwares: Oracle 11g, PL/SQL, Sqlloader, Unix, Developer 2000 forms and reports 6i through 10g, Oracle Applications, EIS reporting and payroll processing tool, BI(XML) Publisher, OA Framework, Workflow, DOS.

Platform: Linux, 11g/10g database, Oracle Apps 11.5.10.2 and R12 - 12.1.0.3, Siebel CRM

Confidential

Rockville, MD

Sr. Oracle Applications Developer (Consultant)

Responsibilities:

• Analysis of components of inbound and outbound interfacing which needed to be modified as a part of migration.
• Lead a team for converting RDF reports into XML reports.
• Identified components for migration of Oracle Applications from Windows to Linux. (Forms, Reports, Libraries, Interfaces, Setup)
• Modified reports for migration so that they run on the new Linux environment.
• Verified application functionality after application of database and family pack patchsets.
• Ran pre-upgrade and post-upgrade reports and compared the results.
• Identified timelines for migration.
• Worked closely with client users to resolve UAT issues.
• Opened service requests and worked with Oracle support on several severity 1 issues to resolve system level seeded issues.
• Provided production support for the system after go-live.

Technology/Softwares: Oracle 11g, PL/SQL, Sqlloader, Unix, Developer 2000 forms and Reports 6i, Oracle Applications, BI(XML) Publisher, Workflow, DOS.

Platform: Red Hat Linux (5.5), Sun Solaris (32-bit), 11g/10g database, Oracle Apps 11.5.10.2

Confidential

Pasadena, California

Oracle HRMS Payroll Sr Technofunctional Developer.

Responsibilities:

• Developed a strategy and supporting programs to reduce the time for migration of objects like forms and reports from 11i instance to the new R12 instance.
• Enhanced and migrated the custom Benefit Billing functionality. This was a major project.
• Verified HRMS and payroll processes and the checkwriter process in R12 instance.
• Validation of Labor Distribution module custom functionalities and reports.
• Guiding client developers on R12 upgrade steps.
• Enhanced a PTAEO validation report and interfaces to AR, GL and OGM from HR and Payroll modules.
• Validation of reports, forms and dependent objects in R12 test instances.
• Suggested best practices for migration and configuration management.

Area of work: R12 Upgrade/Implementation HRMS/Payroll, OTL, LD, SSHR, GL, GMS, AR, AP, GL.

Technology/Softwares: Oracle 11g, PL/SQL, Sqlloader, Unix, Developer 2000 forms and reports 10g, Oracle Applications, BI(XML) Publisher, OA Framework, Workflow, DOS.

Platform: Sun Solaris (32-bit), 11g/10g database, Oracle Apps 11.5.10.2 and R12

Confidential

North Las Vegas, NV.

Sr Business Systems Analyst (Technofunctional)

Responsibilities:

• Worked as a lead analyst during 11i upgrade to move existing HR, Payroll and Time entry and finance reports, programs and database items to a new 11i system.
• Used Oracle’s APIs for conversion of employee data, assignments.
• Created new grade ladders and updated existing grade steps to a new step system.
• Worked on fast formulas to help customize payroll calculations, PTO and accruals.
• Created new custom reports for citywide departments on Oracle HR, Payroll, Labor Distribution and GMS and to help users for testing the same.
• Technical team lead on the implementation of Labor Distribution module from scratch.
• Created new custom interfacing programs for distribution of payroll cost to different PTAEOs based on the business requirements of various departments like Finance, Police and Utilities etc.
• Designed and worked on the development of world’s first customized Enhanced Distribution Adjustment (EDA) system within Labor Distribution module for the use of City’s Finance department.
• Created PATEO costing reports to identify burdened costs based on different awards.
• Provided production support on 11o/11i system which included maintaining/modifying interfaces to AP, GL system. Eg: For City’s electricity billing to-from Nevada Power, interface from Municipal Court to General Ledger.
• Worked on interface programs to process and feed Nevada Power billing information to City’s Oracle Accounts Payable system.
• Worked on an interface to feed information to Oracle General Ledger from Maximus system for Municipal Court transactions.
• Designed and created citywide detailed labor costing report with dollar amounts, hours worked, date earned and PTAOE and GL segment information.
• Worked on the organization synchronization on OTL, Payroll, LD, GMS and GL modules while testing Labor Distribution custom interfaces.
• Identified and reported bugs in the Orapps system and worked with Oracle support for quick resolution. (Suggested changes to Oracle Development team in the seeded LD codes for improvement.)
• Worked with Oracle support on 24 X 7 bases to resolve critical severity 1 bugs on HRMS, Public Sector Budgeting, Time entry and LD modules.
• Worked on the technical implementation of OAB module, created OAB outbound interface for City’s vision insurance and also created custom OLM reports.
• Worked on personalization in OA Framework Pages, extending OAF business components.
• Designed OTL interface for Fire department to Oracle Time Entry system (Telestaff interface).
• Helped City’s budget group to identify issues in the PSB extract from HRMS and fixed them.

Area of work: Upgrade/Implementation and post implementation production support and requirements analysis, design and development.

Modules: AR, AP, GL, HR, OTL, Payroll, Oracle Projects.

Platform: Sun Solaris (32-bit), 11g/10g database, Oracle Applications 11.5.10.2

Confidential

Merrimack, NH

Mercury ITG Governance (Kintana)

SQL Developer (Oracle SQL)

Responsibilities:

• Worked on gathering business requirements, designing, coding and unit testing.
• Resolved bugs and fixes and provided production support.
• Coordinated with offshore team members for design, coding and integration testing once the requirements are finalized.
• Worked on employees’ W2C forms custom processing, created programs for identifying corrections and $ amount in each box (multi-state).
• Worked on the creation of programs for Data masking for ensuring the customer sensitive data privacy.
• Created custom reports for HR management of Bank of America.
• Customized Termination and Severance process (Bank of America).
• Worked on fast formulas for customization based on business requirements.
• Created programs for PTO and accrual processing.

Area of work: Implementation, post implementation production support and development.

Platform: Sun Solaris, 9i database, Oracle Applications 11.5.10.2

Oracle HRMS Lead Developer

Modules: Oracle Applications 11i HRMS / PAYROLL.

Technology/Software: Oracle Applications 11i, Oracle 9i, PL/SQL

Tools: Clear Case (version control)