Close
Overlay

Carla Marie Ramos - Philippines

Carla Marie Ramos
Send Message
Connect

Carla Marie's Trophies

Attractive Profile SaleSpider Trophy Image
Premium Member Not Completed SaleSpider Trophy Image

About Carla marie Ramos

Carla+Marie+Ramos
Carla Marie Ramos is currently living in Philippines, working as an Analyst Programmer and is interested in Fashion, Internet / IT, Media.
Not the person you're looking for?
Find more results for Carla Marie Ramos

Job Title

Analyst Programmer

Location

Philippines

Categories of Interest

Fashion, Internet / IT, Media

Company Size

21-50

Resume

CARLA MARIE J. RAMOS
Polo Ground Florida, Maseru, Lesotho
EMAIL : cmr72001@yahoo.com
CONTACT NO.: +26663320557

Years in IT: More than 3 Years
Total Years of Work Experience: More than 3 Years


Work Experience

August 2006 April 2009 Rizal Commercial Banking Corporation
Ayala ave., Metro Manila

Based at the HR and Controllership Department as Analyst Programmer
(August 2006)

Project Title: RCBC Business Inteligence (RBI)

Description: Strengthen / building up the DataWarehouse infrastructure through creation of Operational Data Storage (ODS) for all application systems (e.g. CASA, Treasury, Loans, Telemoney)

Role: Analyst Programmer

Duties and Responsibilities:

Develop SSIS Packages for ETL process and for updating/building-up of fact and multidimensional cube data.
Define the table structures based on the users requirements.
Modify/Enhance the BI scheduler that runs the SSIS packages
Develop OLAP cube report using Analysis Services specifically for Telemoney System and deploy to MS Excel 2007.

Environment: SQL Server 2005 SSIS, Visual Studio .NET 2005 Integrated Services


Project Title: Customer Information System (CIS)

Role: Analyst Programmer

Part of the Research And Development Team. Develop CIS Number generator for Customer Information System that implements Luhn Algorithm logic for validating and assigning Check Digit.

Environment: SQL Server 2000, ASP.NET 2.0


Project Title: Financial Reporting Package for Loans

Description: Generates Loans report as one of the requirements for BSP (Bangko Sentral ng Pilipinas) Regulatory Reports.

Role: Data warehouse Support/ Analyst Programmer

Duties and Responsibilities:

Responsible for creating jobs in datastage (loading of loans data from Informix to SQL)
Creating report formula and mappings
Consolidating/importing all the required data to SQL tables (Report Columns, Report Details, Report formulas)


Environment: MS Windows 2000 Server, Informix 9, SQL Server 2000, ASP.NET 2.0, Ascential Datastage 6


Project Title: Acquisition/ Disposition Reports

Description: Acquisition/Disposition Reports (AcquiDispo) System is a web-based application primarily designed to eliminate the manual processing of the Acquisition/Disposition (AcquiDispo) Reports, which are submitted to BSP as one of their regulatory reports.


Role: Data warehouse Support/ Analyst Programmer
Main Function: Maintenance and Support/ Development of several modules

Duties and Responsibilities:

Responsible for creating jobs in datastage (loading of handoff files from sources)
Designing/creating table structures and stored procedures
Creating maintenance module for reference tables, validation of reports, adjustment module, audit trail, dbf consolidation module in web application.
Creating table relationship diagram, users manual, and source system requirements documents

Environment: MS Windows 2000 Server, Informix 9, SQL Server 2000, ASP.NET 2.0, Ascential Datastage 6


Project Title: Asset Liability Management Reports (ALM)

Description: Measures the liquidity of the balance sheet in the short run by projecting the potential cash inflows and outflows over time. The report shows the principal amounts of assets and liabilities in each time bracket.

Role: Data warehouse Support
Main Function: Maintenance and Support

Duties and Responsibilities:

Responsible for migrating ALM jobs, reference files, and other manually process data from DEV to PROD server
Maintaining/updating of GL mappings
Investigating/fixing discrepancies
Generating month-end reports
Updating report format and reference files/tables
Production support in staging jobs (datastage)
Maintains/Enhance loading jobs in datastage

Environment: MS Windows 2000 Server, Informix 9, Ascential Datastage 6




November 2004 August 2006 Infrasoft Incorporated
San Juan, Metro Manila

Based at the Solutions Development Department as Systems Developer
(November 2004 August 2006)


Project Title: Fast Food 1 (FF1) Stock Count Monitoring System Project
Ministop Philippines (Robinsons Convenience Stores Inc.)

Description: The FF1 Stock Count Monitoring System consists of two (2) applications namely Store Stock Count Monitoring Application and the Head Office Upload Application. The store application enables store personnel to enter FF1 stock count and to verify, generate the final FF1 report. The application also generates a text file containing stock count data to be sent to the head office for uploading. On the other hand, the Head Office Upload Application reads the text file sent by the stores and uploads the data to the database at the head office.

Duration: March 2006 Present
Role: Systems Developer
Main Function: Development of several modules, Unit Testing, Creation of Database and Stored Procedures, Deployment
Environment: MS Windows NT 4.0, MS Windows XP, MS SQL Server 6.5 /7.0, Visual Basic 6.0

Project Title: Delivery Inventory and Invoicing System (DIIS) Project
Virtuality Inc.

Description: This project involves the development of a system that would keep track of the delivery inventory of all stocks from suppliers and generate delivery receipts and invoices upon delivery to the client. Reports such as the inventory report are also generated by the system.

Duration: January 2006 April 2006
Role: Systems Developer
Main Function: Development of several modules, Unit Testing, Creation of Database and Stored Procedures, Deployment
Environment: MS Windows XP, MS SQL Server 2000, Visual Basic .NET


Project Title: Inventory Management System Project
Ministop Convenience Store (Tordesillas Branch)

Description: The Inventory Management System project was designed and developed to keep track of the stores inventory. It allows store personnel to enter actual stock count, compute system inventory and generate inventory and variance reports.

Duration: October 2005 December 2005
Role: Systems Developer
Main Function: Development of several modules, Unit Testing, Creation of Database and Stored Procedures, Deployment
Environment: MS Windows XP, MySQL 5.0.11, SQL 6.5, Visual Basic .NET


Project Title: Royalty Computation and Weighted Gross Profit Reports Applications Project
Ministop Philippines (Robinsons Convenience Stores Inc.)

Description: The Royalty Computation and Weighted Gross Profit Reports project of Ministop is an application that automatically generates the Royalty and Weighted Gross Profit reports of Robinsons Convenience Stores Inc. (RCSI) based on the data needed for these reports that are stored in the database.

Duration: March 2005 November 2005
Role: Systems Developer
Main Function: Development of several modules, Unit Testing, Creation of Database and Stored Procedures, Deployment
Environment: MS Windows XP, MS Windows 98, MS SQL Server 7.0, Visual Basic 6.0


Project Title: Distribution Center / Merchandising System Interface Applications Project
Ministop Philippines (Robinsons Convenience Stores Inc.)

Description: The Interface Applications Project of Ministop consists of 2 applications namely the Extract and Upload applications developed using Visual Basic 6 and MD SQL 7.0 & 2000. The Extract application is installed in the Distribution Center and its main task is to extract order information from their database to a text file. On the other hand, the Upload application, which is installed in the Head Office, reads the text file generated by the Extract application, checks the order information against the purchase order data and then uploads the data in the database

Duration: March 2005 November 2005
Role: Systems Developer
Main Function: Development of several modules, Unit Testing, Creation of Database and Stored Procedures, Deployment


Environment: MS Windows XP, MS Windows 98, MS SQL Server 7.0 / 2000, Visual Basic 6.0


Areas of Specialization

By Industry or Business Process
Banking

By Discipline
Software Development
Data warehouse Support
Systems Analyst

By Software Platform

Operating System
Windows XP, 2000, NT, 98

Database/Connectivity and Reporting Tools
MS SQL Server 6.5/7.0 / 2000/ 2005, MySQL 4.0 / 5.0.1, Informix 9, Crystal Reports 11.0,10.0/9.0/8.0/8.5,
ETL Solution- SSIS Package; Ascential DataStage 6.0.1, OLAP-MS SQL Server 2005 Analysis Services

Programming Languages
Visual Basic 6, Visual Basic.NET, ASP.NET, Java Script, HTML, XML,


Trainings and Seminars Attended


ASP.NET New Horizons Learning Center, Phil. 2005
Visual Basic .NET New Horizons Learning Center, Phil. 2005
Advanced Web Applications Technologies w/ Microsoft Visual Studio 2005 MIS NET 2007
Advanced Data Access with Microsoft Visual Studio 2005 MIS NET 2007
Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services MIS NET 2008
Implementing and Maintaining SQL Server 2005 Analysis Services dB Wizards 2008


Certifications

Microsoft Certified Professional Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET 2008

Education


2001 2004 Mapua Institute of Technology
Bachelor of Science in Computer Science

1997 -2001 Gregorio Araneta University Foundation
High School Diploma

Personal Background
Born on Sept. 16, 1984. A very responsible person, especially when it comes to work and helping my family. Willing to be trained and eager to learn other programming languages.

Quick Profile Summary

Carla Marie Ramos
Name: Carla Marie Ramos
Link: http://www.salespider.com/p-7647761/carla-marie-ramos
Location: Philippines
Job Title: Analyst Programmer

Explore using SaleSpider

Businesses You May Be Interested In

 Business Picture
 Business Picture
 Business Picture
 Business Picture

Other Analyst Programmers from

 Business Picture
 Business Picture
 Business Picture
 Business Picture

Carla marie Ramos’s Business Connections

Find more information on the Company

Share This Profile

Member Spotlight

case lawrence Icon
Case Lawrence
Case Christopher

Business Spotlight

New Braunfels Tree Service Pros Icon
New Braunfels Tree Service Pros
Http://www.newbraunfelstreeservicepros.com
»
»
Carla Marie Ramos
Who Viewed This Page
458376 views
Last Seen
Thursday August 11, 2016
Top Cities
Delhi 1.7%
Toronto 1.17%
Bangalore 1.1%
Top Browser
Chrome Chrome51.56%
Iphone16.42%
Firefox Firefox14.07%
OS Expand
Windows
42.06%
Android
27.51%
Iphone
16.91%
Device Expand
Desktop
50.37%
Mobile
43.63%
Tablet
5.99%
Language Expand
En-US
64.76%
En-us
17.89%
En-GB
2.84%
spacer pixel