Oracle Sql
Resume:
Himani Ahuja
************@*****.***
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