Yyyyyy x. yyyyyy 7222 Redwood Valley Court - Lewis Center, OH
Solutions-focused, quality-oriented Functional/Technical Lead in Oracle Applications eager to contribute technical expertise and sharp management skills toward actively supporting company operations
Ø 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.
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.
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.
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
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
Remember: Hire Us To Write YOUR New Resume
And We GUARANTEE That If You’re Not Working In 60 Days Or Less,
We’ll Revise Your Resume, Refund Your Money,
AND Give You $50 EXTRA!