| Jobs in CRM Today | This is a free service of CRM Today. Take some time and meet
qualified candidates or explore interesting job
opportunities.
We invite candidates to submit their CVs and companies to post their CRM releated job offers. Enter into the Job Center of CRM Today and you may find what you are looking for! |
|
|  |  |
| IT Consultant | | | Ref. Number: | CRM11382 | | |
|
| Personal Information |
| Personal Profile: | Total 5 years IT Experience
Almost 2 years in Siebel Analytics/OBIEE, Informatica | |
|
| Education: | Bachelor Degree |
|
| Date of Availability: | 2 months notice |
|
|
|
| Current Position |
| Current Job Title: | IT Consultant |
|
| Current Location: | Philippines |
|
|
| Preferred Position |
| Preferred Job: | IT Consultant |
|
| Preferred Location: | USA, UK, Australia, Singapore |
|
|
|
|
| |
|
|
| Education | Bachelor of Science in Computer Science
University of the Philippines | |
| Working Experience | Christian Paul B. Cosinas
IT CONSULTANT
Location: Manila, Philippines
cpcosinas@gmail.com
+63 915 664 3228
RELEVANT EXPERIENCE
Total of 5 years experience in the IT industry having both business and technical related roles. This Includes Business Intelligence/Data Warehousing, Call Centre, Data Encoding/Data Entry, Medical Transcription, Financial, Security Services.
Excellent skills in the Development of Informatica ETL Routines, SQL Scripts, Data Analysis/Validation, and Reports Analysis.
Configuration in Siebel DAC, Siebel Analytics/Oracle Business Intelligence Data Warehouse and basic development skills in Siebel Analytics/Oracle BI Dashboards/Answers
Administration of Informatica PowerCenter Environment.
Went through Siebel 7.7 Essentials Training and Siebel 7.7 Implementation Case Study.
Analyzed, designed, and developed both web based and Windows based systems with backend database. Well experienced in using Visual Basic 6.0, PHP, XML, SQL Server and PostgreSQL.
Highly involved in creating complex database design, stored procedures, and triggers.
Previous experience as a Lead Developer/Analyst had developed his skills in systems analysis, testing, troubleshooting, debugging, and customer handling.
Was exposed to different operating systems, various machines, application and web servers, and scripting languages.
Experienced in technical matters, but also involved in analysing requirements and developing reports and statistics that customer needs.
EMPLOYER:
HEADSTRONG INC.
(A GLOBAL CONSULTING COMPANY)
PROJECT 1:
CLIENT: BANK OF NEW YORK
PROJECT: SIEBEL ANALYTICS/ORACLE BUSINESS INTELLIGENCE Informatica ETL Developer, Siebel Analytics Configurator, Siebel DAC Configurator
Responsibilities:
Configure Siebel DAC to manage ETL Process, Execution Plan, Subject Areas, Table Groups, Tables, Indices, and Tasks. Configure connection to Informatica Server, OLTP, OLAP. Create Vanilla Data warehouse tables and Vanilla Informatica Mapping and Workflows.
Analyze Oracle BI Data warehouse vanilla mappings and check its dependencies. Create custom mapping that will be based on the requirement of the report. It includes complete ETL process like Sources, Transformations, and Target Loading.
Create database stored procedures.
Perform Unit/UAT Testing and Data Validation.
Create UAT Testing Documents which will be needed by Testers as reference.
Technologies Used:
Windows 2000/XP, Unix/Solaris, Siebel Analytics 7.8, Oracle Business Intelligence, DB2, Siebel DAC, Informatica PowerCenter 7.1.2
PROJECT 2:
CLIENT: ADT SECURITY SYSTEMS
PROJECT: REPORT DELIVERY CENTER Analyst, Informatica ETL Developer
Responsibilities:
Create custom ETL routines to populate Database in Data Warehouse. Analyze needed data transformations, which will be retrieved by the Reports Developer.
Works with Reports Developer to better understand requirements.
Design efficient ETL for best optimization.
Analyze and Update existing Informatica ETL.
Data Validation and Creation of complex SQL Scripts.
Map Sources to Data Warehouse Model.
Technologies Used:
Unix, Oracle 8i, Oracle 10g, TOAD, Informatica PowerCenter
PROJECT 3:
CLIENT: ADT SECURITY SYSTEMS
PROJECT: SIEBEL ANALYTICS PROTOTYPE AND SIEBEL DATA WAREHOUSE Analyst, Informatica ETL Developer and Administrator, Siebel Analytics and Siebel DAC Configurator
Responsibilities:
Install and Configure Siebel Analytics and DAC. Configure DAC to manage ETL Process like Excution Plan, Subject Areas, Table Groups, Tables, Indices, and Tasks. Configure connection to Informatica Server, OLTP, OLAP. Create Vanilla Datawarehouse tables and Vanilla Informatica Mapping and Workflows.
Create Siebel Analytics Reports and Perform Data Validation.
Analyze OLTP to OLAP vanilla mappings. Look for target table that would best fit mapping from OLTP to OLAP. Create Custom tables in OLAP. Create Business Model for Data Warehousing Solution.
Setup Informatica Envrionment, which includes Repository, Repository Server, and Informatica Server.
Analyze vanilla mappings and check its dependencies. Create custom mapping that will be based on the requirement of the report, which includes complete ETL process like Sources, Transformations, and Target Loading
Technologies Used:
Windows 2000/XP, Windows 2003 Server, Siebel Analytics 7.8, Oracle 10g, Siebel DAC, Informatica PowerCenter 7.1.2, TOAD
SIEBEL 7.7 CORE CONSULTANT TRAINING
OCTOBER 2006 Training Participant
Responsibilities:
Actively participated in a comprehensive three-week Siebel 7.7 Core Consultant Course. It is covered by a two-part course such as Siebel Essentials and Siebel Implementation Case Study. The whole course covers the following topics of Siebel eBusiness Applications: Installation, Access Control/Data Organization, Data Model, Server Administration, Application Configuration, Business Process Automation and support for Mobile Clients. It also includes architectural concepts and mechanisms that control access to data.
Siebel skills is enhanced by doing extensive laboratory exercises to create custom Siebel application that meets a defined set of business requirements and perform initial data loading for customized application. He received praises and good feedbacks from her trainer during the course.
EMPLOYER:
GLOBALINK HOLDINGS CORP. (DSR DATASEARCH MANAGEMENT CORP.)
(A BPO GROUP OF COMPANIES)
PROJECT 1:
ELECTRONIC DATA DISCOVERY (EDD) Developer-Analyst / Team Leader
This project was developed to create a Client-Server System that extracts metadata (important information and properties from electronic files) and store it in a database. The system is capable of filtering important information and uses it in creating reports based on clients specification. It also converts electronic files to image format files. It has a web based module that customer may access for retrieval of significant information from the database.
Responsibilities:
Involved in gathering and analysis of Clients Requirements for the EDD Project
Comprehensive Research for the Windows compatible objects (such as Microsoft Office Objects, Adobe Acrobat, Web Browser, Microsoft Outlook, etc.). that will be automated and use in extraction of metadata
Leads Team in Module distribution and Systems Analysis
Created Database Design, Stored Procedures and Triggers that will be used by all the modules in the system and for faster retrieval of information and distribution of jobs in multiple workstations
Created an Application running in a Server for passing of information to multiple workstations
Created modules for Generic Generation of Report based on customer parameters
Created Service Programs that the Client wants for additional features
Tested the system
Instructs a large group of people on how to use the system
Created a Users manual and documentation of the system.
Technologies Used:
Windows 2000/XP, Linux, PostgreSQL, Visual Basic 6.0, Visual Basic .Net, Microsoft Office Objects, Microsoft Outlook, Other Electronic Files Object, Windows API.
PROJECT 2:
EDD IMAGING AND REPORTING
Developer-Analyst
This system uses the output of the EDD Project. This will be used by a large group of people who will review the Image files. This system also generates complex reports and statistics which will be very significant to clients.
Responsibilities:
Involve in gathering and analysis of Clients Requirements for the EDD Imaging Project
Mr. Cosinas developed this whole system
Created Database Design and Stored Procedures for retrieving significant data that the users Input in the system
Created Database Procedures for faster assignment of files by an administrator and retrieval of metadata of each file
Created module that QA will need in viewing the Image files. It also has the basic features of an Image viewer
Tested the system
Instructed a large group of people on how to use the system.
Technologies Used:
Windows 98/2000/XP, Linux, PostgreSQL, Visual Basic 6.0, Kodak Imaging, Microsoft Office Object, Windows API.
PROJECT 3:
CALL CENTER SYSTEM
Developer-Analyst / Team Leader
This project is created to be used by different groups in company. It is created in such a way that it is configurable based on the requirements of the client of each group. It has a reporting and statistics modules that will be very significant to client or customers.
Responsibilities:
Involved in gathering and analysis of Clients Requirements for the Call Center Project
Researched for the Technology that will be used in developing the System
Researched for the SDK and Documentation of TAPI Programming, and Documentation of CISCO Call Manager 3.3
Created module such as Interactive Voice Response (IVR), Voice Mail. Telephony Application Programming Interface (TAPI) of Microsoft is used in order to Transfer Voice and handle call events
Created Database Design, Stored Procedures and Triggers which will be the core of Logic in handling and queuing of calls
Created module which will be used by CSRs for retrieving of customer information
Created Web Based Monitoring of Calls, CSR Activities, Call Reporting and Statistics, Assignment of Skill Set to CSR, Adding and Updating of CSR Information
Created Web Based retrieval of Voice Recordings from Storage Server
Tested the System
Lead in Instructing CSRs on how to use the System.
Technologies Used:
Windows 2000/XP, Linux, PostgreSQL, Visual Basic 6.0, PHP, JavaScript, TAPI, CISCO Call Manager.
PROJECT 4:
IP WEB CAMERA
Developer-Analyst
This project is for company security. It uses the Objects of the IP Camera for automation. The information of every camera installed in the company will be stored in the database
Responsibilities:
Researched for Software Development Kit or Object of the IP camera used which is a D-LINK IP Camera
Interfaced OCX of IP Camera in PHP and used JavaScript for Controlling the OCX
Created Database Design and Stored Procedures for retrieval all Camera Information and Location
Created an encryption tool for password protection
Created Statistics of users who logged on the system
Created Users manual and documentation.
Technologies Used:
PHP, Linux Server, PostgreSQL, Macromedia Dreamweaver, Javascript, VBScript.
PROJECT 5:
TRACKING AND BILLING SYSTEM
Developer-Analyst
A web based system that generates sales statistics and consumption of Internet Card. It extracts information from the database and layout in a form which will be understandable and significant to customer.
Responsibilities:
Involved in Gathering of User Requirements and Parameters for the System
Created database functions and procedures for better performance and easy maintenance
Created Stored Procedures that will generate report based on complex formula parameters
Created various dynamic reports and statistics layout that will be significant to users
Used 64bit encryption for password encryption of Users.
Technologies Used:
PHP, Linux Server, PostgreSQL, Macromedia Dreamweaver, JavaScript.
WORK HISTORY
October 2006 Present Headstrong Philippines Inc. IT Consultant
August 2002 July 2006 Globalink Holdings Corp. Lead Developer-Analyst
EDUCATION
1998 2002 University of the Philippines Los Banos
Bachelor of Science in Computer Science
SKILLS Software/Applications:
Informatica PowerCenter, Siebel DAC, Siebel Answers
Visual Basic 6, Visual Basic .Net, PHP, JavaScript, VBScript, PL/SQL
SQL Server 2000, PostgreSQL, MySQL, MS Access
Dreamewaver, Microsoft Office, FrontPage
Operating Systems:
Windows 2000 Professional Server, Windows XP, Windows 2003 Server, Windows NT Server, Linux/Unix, Solaris
TRAININGS AND SEMINARS ATTENDED AND CONDUCTED
Siebel 7.7 Core Consultant Course (October 2006, Oracle Philippines)
(Siebel Essentials and Siebel Implementation Case Study)
Communication Skills (October 2006, Headstrong Philippines and TeleDevelopment)
Siebel Analytics 7.7/7.8 (November 2006, Headstrong Philippines)
Informatica PowerCenter (November 2006, Headstrong Philippines)
PegaRULES Process Commander Overview (December 2006, Headstrong Philippines)
Decision Analysis and Resolution (September 2007, Headstrong Philippines)
| |
|
 Contact with Candidate |
|
|
|
|
|
| |
by Document Type
