Senior Software Resume
Profile Summary
Applicant is a senior software engineer from Accenture – Confidential for over four years already. He is under the expertise of Information Management System and Datawarehousing technologies. He has three years of experience in legacy data conversions to SAP R/3 particularly SAP HR and S&D - Customer Master using the latest IBM DataStage ETL application. Other skills include data integrity checking using Oracle SQL scripting, PLSQL and MS-Access/Excel Applications. Exceptional oral and written communication skills.
Job Experience
Project: Confidential
Project Duration: Nov.2008 -Nov.2009
The mission of the program is to standardize and streamline processes across the tri-service and ensure consistency of approach in all areas of the organization.
Role Description
Responsible for handling over 100 info types of SAP E-HR data conversion delivery of the Ministry of Defense which involved activities relating to analysis, design, development, unit test & deployment of data using DataStage ETL / PLSQL - Oracle Database components.
Project: Confidential
Project Duration: Aug.2006 -Oct.2008
Role Description
The Olympic Program is a global business initiative to maximize the value of systematic harmonization, standardization, and consolidation of Global Downstream\'s business systems of a leading energy company.
Olympic seeks to deliver common business platforms that will streamline operations, improve our processes, and enable a comprehensive view across the breadth and depth of each global Business Unit and Service Organization.
[Roles & Responsibilities]
For Global HR System Conversion (June 2006 to May 2007) :
Technical Role in HR Data Conversion
- follow the requirements and specification of the various legacy systems of the company.
- prepare the HR SAP-ETL data structures.
- execute efficiently the extract, transform, load and validation of HR data.
- Work with the HR ESS coordinators and ETL specialists in resolving technical and non technical issues.
Functional Role In HR Data Conversion
- analyze and prepare functional specification documents and other related requirements.
- Contribute in the discussion of the requirements, processes, security, and reporting of the data.
For Customer Master Data Conversion (May 2007 - October 200)::
Establish a Unique Customer Master Data utilizing an ETL tool for Asia Production system
- Performs Cross Reference of all Customer\'s IDs from all Sources by creating a Customer Master Mapping Table
- Maintains necessary Customer Attributes, or other dependent control value mapping tables in Oracle Staging DB.
- Defined account groups, to control field selection, partner functions and partner determination procedure for customer master.
Cleanse, Match, and Merge Customers for Asia Production system
- Captures and maintains Business Rules on Standardization, Cleansing, Matching and Merging of Customer data
- Defines Precedence Rules and applies it in the transformation stage of data conversion.
- Customized the structure of ETL tool to include defining assigning the Sales Organization, Distribution Channel, Division, sales office, sales group, and shipping point.
Integrates with other Applications
- Log conversion defects using Mercury Quality Center.
- Validate and update customer data and mapping changes using MS Access and Ms Excel.
- Maintains multiple views of the customer over time using Oracle DB and Text files
- Transferred the required legacy data to SAP system through LSMW.
Post deployment activities
- Prepared documentations which includes areas of course design and evaluation for transition purposes.
Project: Confidential
Project Duration: June2006 -Aug.2006
Role Description
- receive supervised, structured training with related technical instructions in using Mercury quality testing software.
- assist in creating and validating test scripts and enterprise data integration tasks.
- comply with the project\'s confidentiality policies and other related requirements.
Project: Confidential (CMS) Manila
Project Duration: Feb.2006 -June2006
Role Description
- responsible for the preparation, validation, production, maintenance and publication of more that 100,000 web contents of a large well-known health benefits company using an content management application called Stellent.
Education
Bachelor of Arts in Psychology
Training/Continuing Education
Course
ATS Application Programming: MS .NET
MLA CMMi Overview
Datastage Essentials for Enterprise Edition on Windows
Mercury Interactive\'s Using and Administering Test Director
SAP AC010 - Business Process in Financial Accounting
SCM600 - Business Processes in Sales Order Management
Skills
- Content Management
- Customer Master Data Maintenance
- Data Stage Developer 8.01 - Enterprise
- Mercury Quality Testing
- Microsoft Office
- Microsoft-SQL Server-Database
- Oracle 9x – TOAD / Oracle 10g SQL Developer
- SAP-Data Conversion
- SAP-HR Master data
- UNIX - Scripting
- ADO.NET
- ASP.NET
- Automated Functional Testing Execution
- VB.NET