Yyyyyy x. yyyyyy       7222 Redwood Valley Court - Lewis Center, OH

xxx-xxx-xxxx                                                                                    abc@xyz.com

 

Career Objective                                                                                            

Solutions-focused, quality-oriented Functional/Technical Lead in Oracle Applications eager to contribute technical expertise and sharp management skills toward actively supporting company operations

 

Profile                                                                                                              

Ø  Offer over 13 years progressive IT experience in planning, leading and implementing critical projects focused on Oracle Application functional/technical design, development and implementation, specializing in various Finance, Supply chain and manufacturing modules.

Ø  Effectively define, develop and implement targeted action plans to maximize operational productivity, efficiency and profitability.

Ø  Proven value and dedication as both a leader and team member as demonstrated by longevity and progression throughout career; successfully develop, mentor and lead top-performing teams.

Ø  Dynamic communication, presentation, relationship building and problem-solving abilities.

Ø  Excel at interacting with broad populations including senior management, staff, clients and vendors.

Ø  Expertise in creation/execution of data warehousing, database administration and J2EE applications.

Ø  Comprehensive background in Oracle11i E-business suite, Oracle 7.x/8.x/9i/10g, Informatica 5.x/6.x/7.x and Epiphany E.4/E.5/E.6(OLAP). Proficient in Shell Scripts, Unix, Windows NT/2000/XP.

 

Professional Experience                                                                               

Worthington Industries Inc. - Ohio                                                                                   2004-Present

Team Lead for Oracle Financials and Supply Chain Management Modules - AP Automation Project, Project One A2FR, P2P and HR ETL widget development

  Contribute solid industry expertise toward designing, developing and implementing the full life cycle of Financials and Purchasing modules; actively support requirements gathering and key discussions.

  Effectively handle preliminary data analysis of all business processes for AP and PO modules in relation to procurement requirements.

  Innovatively modify and support extension Forms and Reports, created to support the functionality not supported by Standard Oracle Apps.

  Work with offshore/onsite development teams to develop CEMLI programs to support extensions; liaise with Oracle OHS and NAIO to resolve instance issues and manage maintenance releases.

  Steer the installation and configuration of Informatica power center for Interchanges, Exchanges and Conversions of data from Mainframe and other sources to Oracle.

  Apply technical abilities toward participating in data model design reviews for HR attendance/payroll.

 

The McGraw-Hill Companies - Columbus, OH                                                                  2003-2004
Team Lead for Oracle Applications, Finance & Supply Chain Management

  Conducted comprehensive review and analysis in order to effectively manage the implementation and customization of AR, AP, GL, FA, PO and INV Modules.

  Periodically coordinated checkpoint meetings with the developers to ensure the code is developed in strict compliance with coding standards.

  Maintained full accountability for Configuration of Key Flex Fields, Descriptive Flex Fields, Profiles, Value Sets, Lookups, and Transaction Types.

  Proficiently developed multiple custom Packages and Reports to support and provide the business functionality, while continuously interacting directly with business users to resolve functional and technical issues during user acceptance and production support.

  Actively involved in requirement gathering, mapping the data from legacy system to Oracle 11i tables.

  Successfully resolved iTAR logged for various issues in the system, working with Oracle support.

 

JP Morgan Chase - Columbus, OH                                                                                 2003-2004

Data Warehousing Consultant - NEV (Net Economic Value) Application

  Strategically defined, developed and executed PL/SQL procedures to use them in the informatica mappings instrumental to boosting productivity, efficiency and quality of operations.

  Led the creation, implementation and modification of new Informatica mappings and sessions to complete SOR request from business user, fix production problems and improve load performance.

  Successfully developed new extraction methods in E.piphany to generate incremental aggregates.

  Timely completed all SOR requests in the production with proper user acceptance testing in DEV and UAT environments, exhibiting strong technical and analytical abilities.

 

Page 1 of 2

Yyyyyy x. yyyyyy                                                                                               page 2 of 2

 

 

Abilizer Solutions Inc. - San Francisco, CA                                                                     1999-2002

Oracle DBA/Sr. Data Warehousing Developer - Corporate Employee Portals

  Spearheaded results-driven database modeling (Logical and Physical), data configuration and reorganization of the databases, with full accountability for creating users and roles and granting/revoking appropriate roles, system privileges and object privileges to users.

  Resourcefully developed packages, procedures, functions and triggers for manufacturing system, identified and addressed existing and potential issues and created proactive upgrades and enhancements for optimal results.

  Created and developed forms, reports and tools to generate DML scripts for the tables.

  Oversaw performance tuning and optimization of Oracle Databases by configuring SGA parameters.

 

PerksAtWork.com                                                                                                         1999

Sr. Data Warehousing Developer - Employee Portals (HRA), Abilizer Information Presentation Suite

  Actively involved in all aspects of data modeling, ranging from gathering the user/ business requirements to designing the data mart, Star and snowflake schemas with 6 team members and collaborating with the Data Architect expert.

  Applied exceptional presentation and interpersonal relation talents toward creating and facilitating demonstrations for Business Intelligence tools (E.piphany) and ETL tool (Informatica).

  Proficiently executed ETL, OLAP and Business Intelligence strategies supporting operations.

  Designed, developed and created Informatica mappings, with strong focus on optimizing productivity, efficiency and performance.

  Efficiently planned and coordinated workflow and assigned projects to optimize utilization of human capital and operational resources.

 

Acs Technologies Ltd.                                                                                                   1997-1999

Sr. Oracle Developer - Material Requirement Planning 

  Actively involved in the design and development of the system, with full responsibility for developing and customizing existing forms.

  Contributed technical skills in creating database triggers to protect database tables from unauthorized updates and deletes, as well as developing complex reports for business users analysis.

 

Education & Professional Training                                                            

B.E, Electrical & Electronics Engineering - Bangalore University, India

Oracle Purchasing Training - Oracle University

E.piphany CRM Administration - E.piphany Education

 

Technical Skills                                                                                              

  Hardware: Sun Spark Ultra, IBM RS 6000,Pentium Servers                

  Operating Systems: UNIX (Sun Solaris 5.8, HP UX 10.10,  Red Hat Linux ) & MS Windows NT/XP

  ERP: Oracle Applications (11i  & 10.7)

  Databases: Oracle RDBMS (7i, 8i, 9i & 10g), MS SQL Server 7.0, MySQL

  Application Servers: Web Logic 5.1, Jboss 3.0.1, Tomcat, Apache

  Modules: Oracle Financials (AP, AR, GL & CE), Purchasing (PO, iProcurement), Oracle Manufacturing (INV), HR and Payroll

  Languages: PL/SQL, SQL, Java, JDBC, Shell Scripting, Perl

  IDE: Eclipse, Jdeveloper and Visual Caf

  DBA Tools: Oracle Enterprise manager (OEM) 2.2, Toad, RMAN, Erwin

  ETL: Informatica Power Mart/Power Center 5.1/6.1/7.x, Epiphany E.4/E.5/E.6

  GUI s: Developer 200 (Forms 4.5/6.x & Reports 2.5/6i)

  Version Controls: CVS, PVCS, Serena Version Manager, ITG

  Other Tools: SQL*PLUS, SQL*Loader, Install Shield