SUMMARY:

• Over 11 years of total experience in Oracle E-Business Suite with real –life knowledge of Oracle applications. Responsible for functional and technical design, development and implementation and upgrade of numerous projects. Experience in process improvement and re-engineering as well as being recognized as an expert in Oracle applications such as HR, Payroll, OTL, ESS, MSS and LD.
• Work experience includes working in public sector environment, in dealing with clients and understanding their requirements. A direct, clear communicator and efficient team leader with genuine interest in productivity, self-motivated and a dedicated fast learner.
• Highly proactive, organized, detail-minded, problem solver with excellent oral and written communication skills.
• Self-motivated with a positive attitude to meet/exceed goals unsupervised and in a team environment.
• Dependable, reliable and responsible; thrive in challenging situations requiring the ability to learn new skills and has excellent time-management skills and the ability to handle multiple time-sensitive tasks simultaneously.

SKILLS SET:

Internet
SSHR,Time Entry, XML, HTML, OA Framework, JSP, Perl, Cold Fusion

Tools
TOAD, Reports 6i, Forms 6i, Developer 2000

PL/SQL, SQL Plus 8.0 and 10.2.0.x, SQL Loader, Java, C, C++, Unix shell programming

Databases
11g, 10.2.0.x, 8.0

OS
Unix, Win 2000/2003, WinNT

Hardware
Sun Solaris

EDUCATION:

• Masters in Computer Science from Confidential University
• Bachelors in Computer Science from Confidential University .

PROFESSIONAL EXPERIENCE:

Oct 2011 – Jul 2012
Oracle Consultant
Confidential, Philadelphia
Oracle Applications R12

• Oracle Modules experience : HR, ESS, MSS, OTL & OAB
• Functional production support and maintenance of HR, SSHR and OTL modules. Interact with users to diagnose problems, and to propose, test and implement solutions.
• Consult with and translate user defined requirements into functional design documents. Prepare business procedures, gap analysis and other documentation following AIM methodology. Prepare test scenarios, test scripts, data sets for the 12.1.3 and database upgrades
• Create end user training documents with detail instructions based on the business processes and provide training.
• Troubleshoot production issues and working with Metalink on need basis
• Developed interfaces to third party benefit vendors
• Involved in the production support of open enrollment process
• Developed Eis reports for HR and benefits related data
• Developed complex position data reports for Health Department and proposed solutions to improve the business processes that contribute to more efficient operations and reporting.

Sep 2001 – Sep 2011
Sr. Business Systems Analyst
Confidential, North Las Vegas, NV
Oracle Applications 11i

• Oracle Modules experience: HR, Payroll, OTL, OLM, ESS, MSS, LD, iRec
• Functional and Technical team lead during the Oracle 11i upgrade for HRMS applications and involved in upgrade and implementations.
• Technical and functional Production support and maintenance of HRMS applications.
• Create end user training documents with detail instructions based on the business processes and provide training
• To use Oracle’s APIs for conversion of employee data, assignments, GSP, employee training history, jobs, positions, SIT’s and labor schedules.
• Implemented PTO accruals and customized fast formulas for 6 leave types here with the city.
• Implemented the custom timecard layouts having PTAEO, per city requirements.
• Created several time entry rules for different bargaining units including Police and Fire.
• Was involved both functionally and technically in the set up of new grade structure and grade ladders.
• Created custom direct deposits and checks using XML.
• Implemented all custom payroll fast formulas per requirements.
• Automated holiday payoff, sick sell back, Group Term Life (GTL) for benefits and Public Employee Retirement Services (PERS) processes.
• Was involved in the set up of HR DBI and conversion of job data for HR DBI purposes.
• Performed personalizations on Self service time entry and SSHR.
• Involved in providing customized views for PSB module.
• Involved in the initial design of the custom interfacing programs for distribution of payroll cost to different PTAEO’s based on the business requirements.
• Implemented several customized menus, functions and responsibilities.
• Involved in the set up and implementation of performance and review dates.
• Developed custom EEO4 XML report per federal requirements.
• Involved in generating W2’s, employment verification and Quarterly reports to SSA.
• Developed several custom reports per business requirements.
• Worked with Oracle support on 24 X 7 bases to resolve critical severity 1 bugs on HRMS modules.
• Worked on the creation of OAB fast formulas and mock open enrollment process. The OAB module implementation was later cancelled due to lack of funds.
• Worked on the custom interface to GL for Maximus application used by Municipal Court, Offendertrack used by Detention.
• Involved in the set up and interfacing of NV Power billing.
• Involved in the set up of dunning letters for AR.

Nov 2000 – Aug 2001
Software Engineer
Confidential, Las Vegas, NV

• Responsibilities included were developing projects in Cold Fusion and HTML.
• Developed news content for the Paris Hotel and Casino web site. The content included many categories such as headline news, sports, travel, Finance, etc.
• Developed a database for displaying ad banners for Paris Hotel and Casino. The banners were displayed according to the category selected on a page. The banner display size and timing was customized.
• Reports were developed to display the system status and heartbeat of the Kiosks.

Jun 2000 – Oct 2000
Web Applications Developer (contract position)
Confidential, Las Vegas, NV

• Responsibilities included programming in Perl/CGI and HTML using MySQL
• Developed several scripts were written to provide detailed information of a domain account for the technical support group, such as whois, nslookup, ipaddress, server, ftp and web status, sub accounts, email config, etc.,
• Several other scripts were written for the billing department for building the invoice, customer account services and price details.

Jan 2000 – May 2000
Applications Developer
Confidential, Las Vegas, NV

• Responsibilities include programming in C++, Perl/CGI and HTML using Sybase and MySQL.
• Search term project was developed for the marketing department to analyze the incoming traffic to the site and identify keywords often used. HTML pages in conjunction with Perl were developed to report the site activity.
• Perl scripts was written for the Express Signup page to enroll in the business services being, S-clicks, Web Connect, and banners. The input data along with the keywords chosen by customer are saved. A filer program is written to check the validity of the IP address, email and URL before the transaction is complete.

Jan 1999 – December 1999
Graduate Teaching Assistant
Confidential Las Vegas, NV

• Responsibilities include training and assisting undergraduate and graduste students in C++ and C programming under a UNIX environment on Sun Solaris.
• Assisted students in developing several complex network protocols and various course related projects.
• Speech Recognition: Speech input is given to the program which will be able to recognize human speech. Some time domain features such as auto correlation and linear prediction are used. Pattern matching technique is used to check the percentage of accuracy ti make the recognition as accurate as possible.
• Written several programs using C++, open GL and SGI for Fern leaf animation, creation of solid and transparent objects, designed fractal mountains, Mandelbrot and Julia sets.

May 1995 – June 1996
Software Engineer
Confidential

• Student Information System: Design, analysis and development of the student information system. This maintains student admission information, into which department, the year of undergraduate study, fulltime or part-time, courses taken, fee payment details, dormitory details and grades offered to the respective courses.
• Banking system: Design, analysis and development of the banking system. This system handles customer account information, updated transaction details made by the customer, calculation of interest added to the principal amount and payment amounts towards any loans taken by the customer.
• Marketing System: System syudy, design and development of the processing of the customer and purchase orders. The transaction involves processing of orders received and inspection of goods. Then invoicing model deals with the preparation of bills once the goods have been supplied for a given order by the organization.

TRAINING & CERTIFICATIONS:

• Oracle certification on Fundamentals of OA Framework, OAB, Advanced PL/SQL, Fast Formulas and Flexfields set up.
• Jan 98 – May 98 : SAP R/3 3.1G, ABAP/4 and MM module, NNE International Inc, Los Angeles
• Jun 95 – Aug 95 : Post graduate diploma in RDBMS in Oracle v 7.1, Hyderabad, India.