We provide IT Staff Augmentation Services!

Sr. Software Engineer Resume

Boise, ID

Summary Over fourteen years of programming experience, including eight years experience in Enterprise Data warehousing, Packaged Applications, ETL architecture, ETL tools and RDBMS.

  • Experience in requirements definition, business process analysis and re-engineering, data modeling and organizational level design.
  • Experience in maintain and upgrade of Oracle EBS applications. Experience in PO, PA, FA, AP, BOM, Order Management (OM), Shipping, WMS, GL modules and SLA setups, Multi Org and Multi Set of Books
  • Worked on 4 Oracle EBS upgrades. Two R12 upgrades. At present working on R12.1.2 instance.
  • Good understanding of Oracle EBS as functional user as well as technical expert.
  • Converted business requirements into logical data models through the identification of key business concepts and artifacts
  • Familiar with Software Development Life Cycle implementation philosophy.
  • Experience in design of data solutions in alignment with Audit, Division, or SOX policies and procedures
  • Self-motivated individual having exceptional work ethics superior planning and good organizational skills.
  • Familiar with dimensional modeling, data architecture, ETL architecture, Data Profiling and Data Analysis.
  • Experience in building Forms, generating Reports and registering concurrent programs/reports/ forms in Oracle applications using AOL.
  • Hands-on experience with PL/SQL, Oracle Reports, Oracle Forms, and XML Publisher
  • Experience with OA framework, Business Events
  • Strong Team leadership skills with an ability to turn ideas into detailed executable strategic and operational plans.
  • Self-starter with potential, initiative and a positive attitude. Able to meet very stringent deadlines and always deliver the package.
  • Keen and enthusiastic with constant desire to learn and a commitment to excel.
Software Skills/Credentials/Training
  • ETL Tools: DataStage (Enterprise Edition), Informatica PowerCenter (7.1.2, 6.2)
  • Profiler and Analysis Tools: Ascential Profile Stage.
  • CASE Tools: Designer/2000, ErWin, PowerDesigner
  • DBMS Oracle 7.x/8.x/9.x, Oracle 10g, Microsoft Access, SQL SERVER 2000
  • Formal training of the following Products: Datastage Enterprise Edition, Oracle Financials (Manufacturing, Inventory, Order Management, Work in Process, Oracle database 10g, Informatica PowerCenter, Oracle Payables, Subledger Accounting.
  • Packaged Applications: Oracle Applications 10.4,10.7, 11i,EBS R12, IFS Applications.
  • Programming Skills: SQL, 4GL, PL/SQL, Shell Scripting
  • Attended classes on CPIM certification by local APICS chapter.
EXPERIENCE

Sr. Software Engineer Confidential, Boise, ID
January 2008 - Present

Worked on coversion of Legacy Fixed Assets into Oracle Fixed Assets system.

Stepped in as functional expert when needed. Explained Oracle EBS functionality to user group to make decisions.

Worked on integrating Promac Project Management system with Oracle Project Management Module.

Worked as functional expert when needed.

Worked on upgrading Oracle 11i applications to Oracle EBS R12.1.2

Worked on Oracle Payables and Sabrix Tax system integration.

Worked on modification of Subledger Accounting rules, Account generation workflows modification, custom work flows design, Custom development of reports and forms.

Supported Oracle R12 modules (PA, FA, AP, PJM, Inventory), period end activities.

Worked with Oracle support on bug fixes, patch application.

Supported Oracle payables, Fixed Assets, Project Accounting, Project Management, Purchasing , Inventory modules and all integrations with Oracle.

Involved in development of configuration documents (BR-100), design documents (MD070) and requirement documents (MD050).

Developed extracts for Data Warehouse (EDW) applications.

Sr. Software Engineer Confidential, Boise, ID
August 2006 - January 2008

Worked in ETL architect team for stardizing templates for Persistant stage and Presentation layer jobs.

Participate in use case development, JAD and other user requirements meetings to develop test cases.

Production support and co-ordinate all enhancement activities

Participated in Data architect team for standardizing table structure, usage of conformed dimensions, Master data Management in various projects.

Participated as a developer on OMNI replicator (a change data capture tool from Lakeview Technology Inc. This CDC tool is based on Oracle Log Miner.)

Worked on various phases of data mart development (like gathering requirements, Fact Qualifier Matrix creation, data modeling, Data architecture, ETL architecture, ETL development and Testing).

Coordinated development tasks with offshore team on developing the ETL jobs, testing and release.

Worked on data analysis. (Profile stage (part of IBM Web Sphere suite) is used for data analysis).

The following tools are used in support.

HP-Unix, Korn Shell scripts, Perl scripts, Oracle 10G, Oracle 9i, PL/SQL, DataStage (Enterprise Edition), Ascential ProfileStage, SQL Navigator.

Sr. Programmer/Analyst Managed Business Solutions, Fort Collins, CO

(Client: Hewlett-Packard, BOISE) June '04 - Aug 06

Worked as a team lead, managing a team of five developers.

Worked on ETL modifications, Shell scripting, Data warehousing Applications.

Participated in RTP (Release to Production), Post release process. Suggested various changes that helped in supportability of application.

Worked as transition coordinator between development team and support team. Worked on run books development, process flow diagrams.

Worked on gap analysis during release of applications.

The following tools are used in support.

HP-Unix, Korn Shell scripts, Oracle 8i, Oracle 9i, SQL 8.1.7, PL/SQL, Oracle Web Forms (Forms 6i), Informatica 5.1, Informatica 6.2 (ETL Tools), Brio 6, and Business Objects.

Sr. Programmer/Analyst Confidential, Boise, ID

Sep '02 - June 2004

Supported Manufacturing, Product Generation, Supply Chain, Marketing Chevron Applications.
Participated in RTP (Release to Production), Post release process. Suggested various changes that helped in supportability of application.

Used ETL tool and developed scripts to extract, transform, clean and move data from source systems to the enterprise data warehouse.

Worked as transition coordinator between development team and support team.

Guided report developers about data source and worked with business users about the user testing and release.

The following tools are used in support.

HP-Unix, Korn Shell scripts, Oracle 8i, SQL 8.1.7, PL/SQL, Oracle Web Forms (Forms 6i), Informatica 5.1, Informatica 6.2 (ETL Tools), Brio 6, and Business Objects.

Sr. Programmer/Analyst Confidential, Nampa, ID

Mar \'98 - Sep '02

Worked on Upgrade of Oracle EBS suite (10.7 to 11i, 10.7 character to 10.7 GUI).

Worked on BOM, WMS, INV, OM, WIP, Shipping modules.

Guided data warehouse ETL developers with the data source information from ERP applications.

Lead the team to develop the interfaces for Supply chain project.
Worked on developing the interfaces for I2 (FP module). These interface scripts extract data from Oracle OE and Manufacturing Applications and give in form of flat files to I2 Rhythm Link.

Lead a team in developing the interfaces, system test plans, integration test plans and error handling.

Made customized changes to reports, forms in Oracle Manufacturing (10.7 and 11, 11i versions) Applications.

Application is developed for EDI 850/860 PO outbound process. Developed procedures for PO information and setup the EDI process with vendors.
Data is extracted from Oracle ERP and sent to vendor using Harbinger EDI tool.

The following transactions of the Production Applications in following transactions. Inventory transactions, Manufacturing transactions, Line changes, Configuration Validation checker Program, BOM configuration, BOM checker Program, Work Order Release, Shop Floor Data Tracking.

Software: Oracle Manufacturing Applications 10.4 ,10.7, 11, 11i versions, Oracle 7.3, Oracle 8i, PL/SQL 2.3, Developer/2000 1.5 W, SQL*Loader, UNIX system V, Programming in K Shell
Hardware: Sun Solaris, Windows NT

Programmer/Analyst Confidential, Memphis, TN. Dec \'96 - Mar \'98

CARDS: Supported Cummins Avalon Relational Database application. Supported in data management, database objects modification, SQL* Forms 3.0 modification.

ALPS (After Market Logistics and Planning System): ALPS integrate the existing legacy systems with added functionality. Worked on the conversions, interfaces with other systems. Worked on the gap analysis. Worked on web forms.

DSRP (Demand Solutions Resource Planning): Applications. Designed the data structure, schema, objects and conversion and interface scripts. DSRP is a data mart used in forecasting.

Software: Avalon Distribution and Order Entry Applications, Oracle 7.3, Developer/2000 1.5 W, DESIGNER/2000, SQL * Operator, PL/SQL 2.3, UNIX system V. Hardware: DEC/ALPHA 2000, Windows NT

Programmer /Analyst Confidential, Columbus, IN Jun \'96 -Nov \'96

Designed database for Wholesale Compensation System. Generated Forms, Reports, and scripts for objects using the Designer/2000.

Reviewed the design of the ASAP (After market Sales and Analysis Project) and developed forms and reports.

Software: Oracle 7.3, Developer/2000, PL/SQL 2.2,DESIGNER/2000, SQL * Operator, PL/SQL 2.3, UNIX system V. Hardware: Unix, Windows NT

Programmer Confidential, Tucson, AZ Jan \'96 - May \'96

Extensive use of ORACLE Developer 2000 (Forms 4.5) and the back end,
In terms Of stored procedures, Functions and database triggers involved in the development and implementation Fleetguard (SOMS).
The product includes Order Entry, MRP, Purchasing, GL, Accounts payable and Accounts Receivable modules
Software: Oracle 7.1, Forms 4.5, Reports 2.5, Hardware: Unix

EDUCATION

Masters in Engineering

REFERENCES Furnished upon request.

Hire Now