PROFILE SUMMARY

• Qualified, experienced and trained information technology professional. 10 years of full life-cycle development/implementation and Database Administration experience building complex OLTP solutions with Oracle technologies.
• Holding qualification of MBA-Management Information System and Certification in Oracle DBA.
• Involved in all phases of full Development life-cycle. Requirements Definition, GAP Analysis, Process Modeling, Data Modeling, Report Mapping, Application Configuration, System Testing, Procedure Development, User Training. Possess a solid track in design, analysis, development, implementing, and support as well as leading and motivating technical professional in order to achieve high levels of performance.
• Involved in Full life-cycle implementation of Oracle E-business Suite R12 - HRMS and Payroll Module Core HR, Self Service SSHR , OLM Including I-Learning , Oracle I-recruitment, Oracle Time and Labor OTL , and Payroll including Fast Formulas , Support for Complete payroll cycle with Pay Processing, Retro Pay, Costing and Transfer to GL
• Have good understanding of system development/implementation methodology including Oracle AIM methodology and documentation. Prepare BBD, BR100, TPD, Test Scripts, MD50 and MD70, User Manual etc. Conduct CRP, SIT, UAT and user training sessions supplemented with AIM documentation.
• Installing, Configuration and Administration of Oracle Database, Up-gradation and Migration of Oracle Databases. Perform backup and Recovery using User-Managed backup scripting, using RMAN and using Export/Import and Data Pump.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

• Involved in complete setup of HR Payroll which includes setup of Key Flex Fields, Descriptive Flex Fields, setting up business group, Special Information Types, Location, Organization, Job, Position, Grade, Grade Rate, People Group, Address, Payroll, Payment Method, Element, Element Link, Global Values, Formula Results, User Define Functions, Table Structure, Table Values, Oracle Menus, Security Setup. Expertise in design and development of interface, custom process, concurrent program, payroll calculation functions, fast formulas, Alerts, AME, Workflow.
• Proficient in SQL and writing PL/SQL stored procedures and functions, Procedures, packages, database triggers and SQL Loader scripts and using Oracle standard APi's.
• Developed various custom functions which are used in the payroll calculation, Creating linking various earnings deductions elements writing calculation rules using Oracle Fast Formula.
• Customizing the standard PTO accruals to meet business requirements such as Leave Encashment, Promotions, and Carryover process.
• Support for Complete payroll cycle with Pay Processing, Advance Pay, Proration, Retro Pay, Developed custom Costing process including Project Costing and Transfer to GL.
• Prepare and Migrate Master Data and Transactional Data from legacy systems into Oracle HRMS and Payroll using Data Load API's and Data Loader.
• Developed different functional requirement and embedded them in API's USERHOOK, also using Oracle Alerts, Dynamic Triggers and Task Flows etc. Customized the standard Oracle Workflow process and as well as creating new Workflows.
• Oracle Time and Labor OTL module implementation including configuration, training and support.
• Oracle learning Management and I-Recruitment module implementation including setup, training and support.
• Close interaction with Oracle Support to ensure system is running smoothly. Test, Setup and Implements suggestions/recommendations by Oracle in Test and in Production environment.
• Coordinate with Oracle DBA's System administrators for resolving internal technical issues.
• Design and develop the code for RICE components Reports, Interfaces/ Implementation, Customization and Enhancements as per the functional requirement.
• Review functional design, create the technical specifications, develop code, unit and integration testing and user acceptance testing. Train applications users to ensure the correct and proper use of business systems by conducting CRP, SIT, UAT and prepare the documentation and user guides for the implemented solution. For e.g. BR100, MD050, MD070, User Manual etc

• It's an IT Company of Emirates Group, developing and Supporting different Software's for Airline and other Businesses, primarily for Emirates Airline. Working as a contract Employee of Bitech International LLC. CRIS, Customer Relationship Information System is an application designed to support the skywards Frequent Flyer Programmed and Business Rewards. CRIS Application is currently implemented in Emirates Airline, Srilankan Airline, Philippine Airlines, Jet Airways, Kazakhstan Airline Air Astana Etisalat Non Airline .
• Involved in Gap Analyzing, Designing and managing the team for Development and Implementation of Customer Loyalty Programme for SME Small medium Enterprises , also integrate it with CRIS, technology used is Oracle 9i database and Dot Net Framework.
• Creating System Requirement Specifications SRS , Technical Design Document TDD , Statement of Work SOW , User Test plans UTP and Integration Testing documents, involved in estimation and planning, supervise UAT sign-offs, involved in Implementations including Configuration management, preparing Release Notes etc
• Involved in converting the CRIS Customer Relationship Information System Front-End from Developer6i to PL/SQL API's for Dot Net Framework by gathering the requirements, getting the business knowledge and understanding the current application. Where necessary, responsible for the development and unit testing of application programs interfaces conversions, reports, or workflows .
• Additionally, working as a Configuration Analyst using All Fusion Harvest.
• Supporting Systems in Oracle Developer6i as a Front End and Oracle 9i Database and Oracle Discoverer as a Reporting Tool and PL/SQL Developer Tool