Himani Ahuja

215-***-****

acftrm@r.postjobfree.com

ORACLE APPS TECHNO FUNCTIONAL CONSULTANT

SUMMARY:

Oracle certified Associate with 6+ years of IT experience including analysis, design,

documentation and implementation and testing of business application systems in ERP

Oracle HCM and PL/SQL development.

Experience in designing databases and client-server architecture and expertise in PL/SQL

and SQL*Plus.

Skilled professional with expertise in development, customization, upgrades, data

conversions and interfaces.

Extensive experience in using SQL, PL/SQL, Developer 2000/6i/9i, SQL Loader, Discoverer

4i/10g, Workflow2.6, Oracle 10g/9i/8i/8/7.x, UNIX, Linux, and Shell Scripts and Oracle

Applications (HCM, base benefits, benefits administration,absence management, customer

relation management, Taleo, Recruitment and Time and labor ).

Successfully completed life cycle implementations using oracle applications (R12 & 11i

suite).

Extensively worked on PL/SQL Stored procedures, Functions, Packages, Triggers, Exception

Handling, Dynamic SQL, PL/SQL Collections, Materialized views, Indexes, Oracle Forms and

Reports.

Strong knowledge of software testing methodologies.

Experience in set -up, configuration, personalization and functionality checks.

Worked on Oracle AIM methodology and prepared documents BR100, MD50, MD70 and

TE50.

Experience in developing interface programs for importing data into feeder systems to

oracle using SQL*Loader and PL/SQL.

Good knowledge of DBMS and Oracle Relational Database Management System (RDBMS)

concepts.

Skilled in Performance tuning - analyzing query plans and query tuning using the tools such

as EXPLAIN PLAN and use hints.

Strong knowledge in Oracle cursor management and exception handling.

Experience in Oracle Web Application Programming using PL/SQL.

Testing expertise in performing Functional, System, Regression, Performance, Integration,

End to End and User Acceptance Testing. Extensive experience in Black Box and White Box

testing.

Technical Knowledge of People Code, Application Engine, AOL (Application Object Library),

Approval management engines (AME), workflow, Application Messaging and XML

Publisher.

Proficient with BI Publisher reports and using various templates to publish the reports.

Strong holds in Root cause analysis, Quality Assurance, Requirement Gathering and

Technical Documentation, Conference Room Pilots (CRP), Training Design and Delivery,

Change Management and Knowledge Management.

Excellent communication and interpersonal skills, ability to learn quickly, good analytical

reasoning and high compliance to new technologies and tools .

TECHINCAL SKILLS:

Languages SQL, PL/SQL, Unix Shell Scripting, C, C++, Java, Oracle Forms, Oracle

Reports

Databases Oracle 10g/9i/8i,, SQL Server 2005/2008,Teradata 13.10

TOAD, SQL*PLUS, PL/SQL, SQL*LOADER

Database Tools

Oracle Forms10g, PL/SQL Forms and Reports, Oracle Reports developer,

Oracle Tools

Workflow builder 2.6, Discoverer 4i/10g, Developer 2000/6i/9i,

Oracle8i/9i, JDeveloper.

Scripting Languages UNIX shell scripting, Cron jobs.

Operating Systems Windows NT/95/98/2000/XP/2003/2007, Unix, Solaris.

General Tools Microsoft Project, Oracle Metalink and SR Process, Data Loader.

PROFESSIONAL EXPERIENCE:

Capgemini - Client Heathrow, UK OCT’13-DEC’13

Role: Oracle apps Techno functional consultant

This project aim was to implement oracle applications R12, was responsible in developing

technical components, personalization, customization, requirement gathering, design and

testing of the application.

Responsibilities:

Acted as a liaison between business and technical team to define requirements.

Designed and Developed Staging tables, Created inbound processes for loading legacy data

from existing database to Oracle database using APIs (Application Programming Interfaces).

Worked on analyzing and data extraction from Special Information Types based on

qualifications, skills and information required to setup training and skills management.

Involved in the configuration and development of Manager Self Service & Internet

Applications for Oracle Application Environment. Implemented HR Manager & HR

Representative for Multi-Orgs and created function node in workflow to find HR Approver.

Used Dynamic Approvals Feature for Self Service HCM Approvals.

Created custom templates with Data Definitions for XML Publisher and Developed reports

using reports 6i and registered as XML reports in applications.

Created custom PL/SQL packages that were initiated from workflow. Scripting for Functions,

Menus, Responsibilities, Profile Option and Messages Setup.

Involved in Fit/gap and requirements analysis for new modules, customization

rationalization, report and customization specifications, conversion validation, prototype,

troubleshoot, system configuration.

Wrote database triggers and stored procedures for controlling data validation.

Developed Custom forms and added the zoom functionality in the e-business form. Also

developed PL/SQL scripts. Registered concurrent programs, request groups for reports.

Performed functional configuration setups

Configured the Competency Key Flex field to effectively capture the competency information

and designed a ‘Competency Profile’ based on Job Title, Job Family, Job Function and

Domain.

Environment: Oracle Applications R12 (12.1.3), Oracle 10g, PL/SQL, SQL*Loader, SQL*Plus, TOAD,

HR, SSHR, CWB, Oracle 10g, SumTotal, (Benefits, Payroll), MS Project, PL/SQL, Oracle Forms 10g and

AME workflow.

Wipro – Client SAB MILLER, South Africa JUN’12-SEP’13

Role: Oracle apps Technical consultant

The Project involved Upgrade of Oracle Applications from Oracle 11.5.10.2 to R12.0.5 and to

customize business process with Oracle Applications R12 new functionalities.

Responsibilities:

Outlined the upgrade strategy from the current version to R12.0.5

Created data migration scripts to facilitate the localization specific requirements.

Defined and built responsibility matrix in accordance with existing security framework for

the new Business Group.

Developed concurrent processes using PL/SQL, assessing performance degradations on

custom code and fixed accordingly, fixed code variations and gaps as per user requirements.

Involved in customization of several standard reports to serve important business processes

very specific to the client. Such reports include Absence related detail, timecards

submission, legal entity, assignment related information, candidate offer, HCM assessment

salary, previous employment history and bonus history.

Developed security matrix for user population across HCM suite of applications.

Developed Reports using Discoverer4i, Performed setups for EUL, Created business areas,

Created joins, Create calculated items, Created conditions, Created new folders based on

user requirements.

Identified product gaps, coordinated with Development Team by creating TAR and obtained

one-off fixes. Managed and monitored TARs for several P1 Issues. Provided on site solutions

and resolved showstopper issues.

Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports.

Developed and executed test cases. Involved in Functional, Performance and Regression

testing.

Defined and built responsibility matrix in accordance with existing security framework for

the new Business Group.

Developed and executed extensive test cases for HCM, Payroll, and Self Service HR and fixes

the known issues before the install.

Environment: Oracle Applications 11.5.10.2 to R12.0.5, Oracle 9i, Workflow 2.6, PL/SQL,

SQL*Loader, SQL*Plus, TOAD and Discoverer 9i.

Wipro – Client Genpact, US FEB’10-MAY’12

Role: Oracle Technical Consultant

Responsibilities:

Designed/developed/Modified tables, views, materialized view, stored procedures,

packages and functions.

Involved in Unit Testing Stored Procedures and Functions.

Created Materialized Views and partitioning tables for performance reasons.

Worked on various backend Procedures and Functions using PL/SQL.

Troubleshoot performance issues and bugs within packages, forms, and reports using

dbms_output, Forms debugger, explain plan.

Developed UNIX shell scripts to perform a nightly refresh of the test system from Production

databases.

Coordinate with the front end design team to provide them with the necessary stored

package and procedures and necessary insight into the data.

Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy

the requirements.

Created SQL*Loader scripts to load data into the temporary staging tables.

Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application

development team

Used TOAD, PL/SQL developer tools for faster application design and developments

Developed procedures using Dynamic SQL.

Developed database objects including tables, Indexes, views, sequences, packages, triggers

and procedures to troubleshoot any database problems

Tuned complex Stored Procedures for faster execution and Developed database structures,

according to the requirements

Resolving the issues on priority basis.

Responsible for Analyzing and Implementing the Change Requests.

Involved in handling the changes in compiling scripts according to the database changes.

Performed Administrative tasks like adding security, granting privileges, and scheduling and

sharing of reports.

Converted standard report to Discoverer reports for more user-friendly access to the data.

Edited existing reports to add additional functionality (Parameters, sorting, calculations, and

conditions).

Environment: Oracle 10g, SQL Server Reports 10g, SQL, PL/SQL, Toad, Oracle RDBMS, SQL

Developer.

Wipro - Client Genpact, INDIA OCT’08 –JAN’10

Role: Oracle PL/SQL Developer

Project involved offshore design, development, testing and implementation. Mapped all data from

multiple legacy databases (Access, paper based, Flat file) to Oracle tables.

Responsibilities:

Worked with stakeholders and subject matter experts gathering business and technical

requirements from customers to define product content and help formulate and manage

the project scope.

Recommended architectural design solutions and integration solutions.

Coordinated with systems partners to finalize designs and confirm requirements.

Developed the SQL database tables, stored procedures, SSIS packages to load the tables.

Developed SQL scripts to query the table data and translate it to logical business information

to generate business reports using SSRS.

Utilized the Aggregate, Join, Router, Lookup and Update transformations to model various

standardized business processes

Performed Unit Testing on the Mappings.

Developed XML parser in C++ based on DTD & Schema.

Developed PL/SQL packages and database triggers.

Responsible for the technical and user documentation of the customizations.

Developed concurrent processes using PL/SQL, assessing performance degradations on

custom code and fixed accordingly, analyzed user needs, fixed code variations and gaps as

per user requirements.

Environment: SQL server 2005, Oracle 9i, Windows XP, C, C++, UNIX (Solaris, HPUX, AIX & Linux),

Win32, XML, SQL developer and DTD.

EDUCATIONAL QUALIFICATION:

MS (Software Engineering), India

Bachelor of science (IT), India

Contact this candidate