Project Developer
Resume:
Title:Michael Rosal
*********@*****.***
Document
Source below
Name: Michael Rosal
Address:
City: Newberg
State: or
Zip/Postal Code: 97132
Country:
E-mail: *********@*****.***
Primary Phone:
Background
Most Recent Job Title: EPMo Sr. Process Analyst
Most Recent Employer: Regence
Career Level: Senior (Non-Manager)
Availability or Timeframe: Immediately
Authorized to work in the US: Yes
Security Clearance:
Do you have transportation: Yes
Over 18: Yes
Education: Bachelors
Languages Spoken: English
Job Preferences
Desired Salary: Open
Willing to Relocate:
Desired Job Titles:
Desired Job Types:
Work Status:
Desired Shifts:
Desired Travel:
Category: Information Technology or Systems
Company Size:
Company Type:
Industry:
View Emails To Candidate close
Email Status close
close
Forward Candidate(s) Status close
View Notes close
Saving close
Save To:
Note:
Resume Reserve and LeadLink data may only be used for contact directly related to
employment. Use of these free online services is subject to the Terms of Use. Resume
Reserve and LeadLink Terms of Use prohibit automated extraction of data, marketing, or
fees of any kind. Resume Reserve data is private and may only be used by authorized
individuals. Access codes for resume viewing and job lead posting are issued and owned by
LHH and will be revoked if misused.
Send questions to: *******@***.***
To review the Terms of Use, click here.
Copyright c 1997- Lee Hecht Harrison, Inc.
MICHAEL EUGENE O. ROSAL
3721 Oak Grove St
Newberg OR, 97132
*********@*******.***
DATABASE DEVELOPER / ANALYST
Mike has been in the IT industry for more than 13 years and has worked in positions
ranging from software developer and systems analyst to consultant. He had extensive
experience in customization and implementation of CRM and Pricing Management Solutions,
Visual Basic Development and MS office Applications development. Currently, Mike is
specializing in the design, development and deployment of effective database solutions
using MS SQL Server, Oracle and MS Access.
Summary of Accomplishments and Qualifications
Extensive experience in creating analytical, reporting and ETL tools using MS Access, MS
Excel and VBA.
Designed and developed ETL applications and process for a technology manufacturing to
enable integration between their ERP and CRM system and a health insurance company to
enable a more efficient and effective project reports analysis and development between
their heterogeneous project and portfolio management tools.
Fully participated in the configuration, development and implementation of Vendavo
Pricing and Margin Management to one of the division of a Fortune 500 company. The
completed project helped them increase their margin profitability, determine price
leakages on their pricing policies and analyze price trends all across their vast product
array.
Successful development and implementation of CRM solutions to the top companies in the
Philippines that includes real-time integration with SAP, Database conversion and Mobile
implementation that helped the companies become more effective and efficient in responding
to customer calls and sales requests online and offline.
Several years of experience as a developer working in a client/server and web
environments based on VB, ASP, SQL, MS Office, Oracle, VBScript, Jscript and XML
Several years of experience database development relational databases such as MS SQL
Server, Oracle, MS Access and MySQL, creating and developing stored procedures, packages,
triggers and complex queries.
Several years of experience in database administration roles in MS SQL Server and Oracle
that includes database design and implementation.
Experience in integration of several non legacy and legacy systems and data coversion.
Developed custom applications to integrate ERP systems and Vantive/Peoplesoft Customer
Support systems using Visual Basic.
Professional Expertise
Core Competencies Achievement Orientation, Impact and Influence, Drive and Initiative,
Learning Agility, Teamwork and Cooperation, Organizational Awareness
Industry Concepts Customer Relationship Management, Customer Support, Employee Help Desk,
Sales and Marketing, Field Service, Price Management, Profit and Margin Management,
Business Consolidation, Software Integration, Data Migration, Data Conversion, Project and
Portfolio Reporting
Technical Concepts Systems Integration, Data Migration, Data Conversion, Database
Administration, Package Applications Customization and Configuration
Project Management Gap Analysis, Functional Requirements, Technical Requirements, QA,
Team Mentoring, Status reports, User Acceptance Testing, Test Scripts
Languages/Software
(High Level Experience)
Visual Basic, VBA, VBScript, ASP, JavaScript, HTML, T/SQL, XML, PL/SQL, SQL Server 6.5,
7.0, 2000, Oracle 10g, Access, MS Office 2003, MS Project, Vantive, Crystal Reports,
Business Objects Enterprise, MS Office 2007
(Intermediate/Some Experience)
VB.Net, C#, JavaScript, Epiphany, SAP BW/BI, SAP CRM, PHP, MySQL, Actuate Reporting
Server, Bea WebLogic
Education
Bachelor of Science
in Computer Science, Pamantasan ng Lungsod ng Maynila, 1996
Professional Experience
Regence, Portland, OR July 2008December 2009EPMO Sr. Process Analyst
Designed and developed the EPMO Project Repository database to store various data from
the Project and Portfolio Information and Time Tracking data for Reporting.
Developed the Data Extraction and Transformation process and automation for Regence EPMO
Project and Portfolio Management Systems, Project Scheduling System, Resource Time
tracking and Project Accounting system.
Developed an ETL tool to extract Microsoft Project Plan Schedule Data into the EPR
Database
Developed an ETL process to extract Clarity Data and load it to the EPR database
Programmed the data processing and transformation services using PL/SQL Scripts, Oracle
Stored Procedures and MS Access.
Performed Reports and Data Analysis for the EPMO Department
Designed and developed delta reports between MS Project and Clarity System.
Designed and developed operational Resource reports between MS Project and Clarity
Designed and developed Clarity and Time Tracking Delta reports.
Performed daily maintenance and support of the Report generation and posting.
Databases are created using Oracle and MS Access; PL/SQL Script and MS Access VBA are
used for scripting; Oracle tools and Windows task Scheduler are utilized for other ETL
activities.
Reports Development using Business Objects, Crystal Reports and Excel.
Merix Inc, Forest Grove, OR Feb 2008June 2008Reports Analyst/Oracle Developer
Developed the Data Extraction and Transformation process and automation for Merix Oracle
EBS and SalesForce.Com integration
Developed Oracle Views and Packages for Data Extraction Process
Developed an extensive and flexible Extraction Interface in MS Access Database to perform
the actual data extraction, transformation and conversion to text files needed by the
SalesForce.Com load process.
Created new and enhanced existing Sales and Finance Reports in MS Excel and MS Access on
Merix Global Data Warehouse.
Performed data analysis and data cleanup of Merix Finance and Sales Application Database
Contributed logic analysis and validation of the Merix Finance Data Warehouse Views.
Modified and enhanced existing automated MS Access and Excel reports for new business
requirements.
Enhanced and optimized the performance of Merix Defects Tracking Access Database
application.
Utilized Oracle PL/SQL, Toad, VBA and MS Access to complete day-to-day activities.
BearingPoint Inc, VA Aug 2006 - Jan 2008Consultant
Trained as
SAP BW and CRM Consultant
Implemented a prototype for data migration tool for SAP BCS Systems and Hyperion Systems
utilizing VBA and MS Access.
Participated in the development of BearingPoint SAP BW/BI Demo Systems
Developed queries and reports on a School Grants SAP BW Demo.
Participated in the development of BearingPoint SAP CRM Demo Systems
Developed CRM presentation documents for client demo on Life Sciences and Hi-Tech
Performed user presentations on SAP Price and Margin Management (Vendavo) for knowledge
sharing purposes
Developed a project tracking system using MS Access.
Developed project points reporting system using MS Access.
Developed queries and scripts to produce required reports
Participated and performed migration of BearingPoint PM Online system to the new Upgraded
PM Tools Online System. Utilized Excel to perform checklists and reports on list of
documents to be migrated.
Intel
(Contractor) Hillsboro, OR May - July 2006Technical Support Level II
Provide technical support to Intel Customer Service Rep
Process flagged orders by Intel CSR(s)
Monitor and process email support system
Monitor and process jobs and tasks scheduled for the support system
Used Remedy ARS to log issues raised by CSR on Intel s (ICIM) PeopleSoft CRM System.
Monitored and fixed invalid customer orders and issues logged on the ICIM
Emerson US
Aug 2004Apr 2006Senior Technical Developer / Consultant
Implemented and developed the Policy Management and Pricing Logic
Designed and created additional schemas
Design Policy and Price Book User Interfaces.
Implemented and developed the User Interfaces of the Quotation Entry Screen and Policy
Management Screen.
Implemented and developed the Workflow for the Quotes Approval Process.
Designed the schema for the quotes and policies system
Developed and enhanced the Pricing Logic using Vendavo VSL and Java
Extended Java objects and created additional objects to implement the business rules not
currently support by the OTB package.
Developed and implemented the data integration between AS400 and Vendavo using Java, XML,
PL/SQL Stored Procedures, Windows Shell Scripting and VBScript.
Developed stored procedures, packages and complex queries to further implement the
business rules required by the client
Developed technical documentations and Test scripts
Participated in the System go live
Performed post-development technical support of the system.
Development done using Vendavo Java Objects, Java, XML, XSL, Vendavo VSL, Bea WebLogic
PL/SQL and Oracle database
Oracle Database Administration for Development and QA environment.
Exit33 Inc
Boston, MA April June 2004PHP Programmer
Programmed and developed scripts to be used for Explana CourseWare Web Program.
Developed the code of Exporting and Importing Course Ware Materials to a repository
database.
Assigned in development of Media Asset Manager used in storing and managing media file to
be used for Course Ware materials.
Created a personal calendar application for Courseware students.
Used PHP, Smarty, Sumatra and XML, MySQL and Apache
MISNet Inc
Makati, Philippines Apr 1996Jun 2002Senior Technical Consultant / Sr. Developer
Roles and Responsibilities
CRM Developer (Vantive/Epiphany/Peoplesoft CRM)
CRM Administrator (Vantive/Epiphany/Peoplesoft CRM)
MS SQL Server Administrator on CRM Implementations
Oracle Server Administrator on CRM Implmentations
Database Developer (Oracle, MS SQL Server, MS Access)
Visual Basic 6 Development
Reports Developer (Crystal Reports and Actuate Reports)
Web Development using ASP (ASP)
User Interface Designer (CRM Applications)
Systems Integrator between CRM Applications and Backend systems such as Mail, ERP and
Telephony
Pre-Sales technical Support and Prototype Developer
Completed implementation of CRM projects on several high profile companies in
Philippines, Singapore and Malaysia such as
Shell Malaysia (Malaysia)
Shell Philippines
Caltex
Procter and Gamble Philippines
Aetna Philippines
Ricoh Asia Pte. Ltd. (Singapore)
Starhub (Singapore)
Fort Bonifacio Devt Co.
Software Tools and Applications used
SQL Server/Oracle Server
Visual Basic/VBA
ASP/XML/HTML/VbScript/Jscript
Queries, T-SQL, PL/SQL
Actuate Reports/Crystal Reports
MS Access / MS Excel / MS Office
Vantive / Peoplesoft CRM / Epiphany
Lotus Notes / Microsoft Exchange
SAP
Windows
VBA
Visual Basic 6
*Character references are available upon request
Contact this candidate