Project Manager Sql Server

Milan Del Rosario Telephone: +1-347-***-****

Email: *********@*****.*** E 3rd St, New York,

NY 10003, United States

Technical Skills

.Net Technologies (VB.net, Java

C#.net, MSSQL Server/T-SQL / SSIS

ASP.net and WPF) OLAP

VB for Applications (Excel) Apache-Tomcat

Excel Macro Oracle - PL/SQL

SharePoint Sybase SQL

HTML Eclipse/Hibernate

VB 5 and VB 6 XML/XSLT

Javascript and VBScript Unix Scripting

Business Intelligence Macromedia FLASH

Qlikview Photoshop

Business Objects\Crystal Reports

Professional experience

Havi Logistics (Singapore)

Duration May 2013 - Current

Business Intelligence Consultant - Havi Logistics

. Design and create ETL

. Design and create Data Model for Qlikview

. Design and develop KPI and Financial Qlikview Dashboards

. Directly liaise with the users for report requirements

. Provide user training for Finance users and stakeholders.

. Design and develop web application in C#.net for Finance Team

application

. Training: Advanced Topics in Design and Development Version 11

Company Name: Barclays Capital (Singapore)

Duration: December 2008- March 2013

Analyst

Project: Global Marketing Management System

. Developed reports using Qlikview technology.

. Create data models and data loading for Qlikview

. Involved in enhancements development in GMMS (using Java, Apache-

tomcat, javascript html, eclipse, hibernate and Oracle)

. Stored procedure development using Oracle

. Provides second line application issue investigation

. Liaise with DBAs\Windows\Web team for the SIT and UAT environment setup

. Coordinate with the project managers in London

Project: Barclays Natural Resource\Barclays Private Equity

. Responsible on making the vendor application run in Barclays

Infrastructure

. Coordinate with the project managers in London

. Liaise with the vendor for the application technical requirements.

. Provide updates to the Project manager on a weekly basis

. Manage SharePoint

. Liaise with the DBAs\Windows Team\Web team in setting up the application

environment

. Application Enhancement using C#.net WPF\WCF.

. Setup the ETL\Autosys for for Analytx PEO

. Setup the SSIS reporting for BNRI.

. Create SSRS reports

. Setup the SIT environment for GTC's test cycles

. Prepare and setup UAT environment for user testing and on boarding

. Prepare release plan for Production setup

. Provided KT to support team for first line application support

. Provided second line application support

Project: Phonebook 2

. Liaise with DBAs\Windows\Web team for the technical environment setup

. Involved in SDLC (using C#.net, ASP.net, JQuery, javascript and html)

. Stored procedure development using SQL server 2008

. Setup the environment SIT environment for GTC testing.

AMSC-ServiceManagementToolset

. Production Support Level2 (Application in Win Server, Java Apache-Tomcat,

SQL server, Autosys, Unix)

. Develop reports in Business Objects for Oracle database.

. Unix Scripting for HP Service Center

. Setup ETL\Autosys jobs for SMR reports

. Handles Incident and Problem Management

. Liaise with the GSDC and RTB lead regarding major issues

. Participate in Change and Configuration Management

. Create Business Objects reports for Chan

. Coordinate Minor releases with GSDC team and GSC

. Proactively updates the team's knowledge bank

. Worked on database backend for issue investigation (SQL server, Oracle

and Sybase)

Company Name: Levi ' Strauss Singapore

Duration: September 2006 - December 2008

Business Application Analyst

Divisional Booking System (Team Leader)

. This project is using ASP.Net, WPF\WCF (C#) and SQL Server 2005 as

Backend DB

. Application design including UML and adopt the Microsoft Best practices

in the system development

. Two people are under my supervision for this project

. Reports and provides updates to the Project Manager on the task status of

the team

. Plans timelines, assigns needed resources and monitors if schedules and

deadlines are strictly met.

. Database design

. Use Case documentation

. System Design Documentation

. UI Design for Web Based, Window Based and VBA modules of the system

. Create Technical Documentation for Web Based, Window Based and VBA

application

. Involved in Business object coding for Web Service and Business Objects

(C#), XML/XSLT and VBA (Excel Macro).

. Setup and design ETL jobs in SSIS

. Create Reports using Business Intelligence and SSRS

. Create document for User Testing and Training

. User Training and UAT on the client location (China and Hong Kong)

. Bug Fixes

. Production support (2st Level - Rectify issues raised in Remedy)

Supply Chain Front Office

. This project is using VS.Net 2005 (C# Winforms), VBA, VB6 and (PL/SQL)

Oracle 8i as Backend DB

. User requirement gathering for application enhancements

. Design Application enhancements

. Create Technical Documentation for Winforms and VBA application

. Create document for User Testing

. User Training

. Bug Fixes

. Production support (1st Level - Rectify issues raised in Remedy)

Data Warehouse Team

. Project Technology: SQL Server 2000 and SQL Server 2005.

. Create DTS packages to load data from external sources.

. Migrate existing DTS packages to SSIS.

. Design. Develop and Maintain stored procedures.

. Design and create OLAP Cubes

. Monitor Scheduled batch jobs during office and after office hour support

(Shifting)

. Provides 24/7 1st Level Support for Production Issues. (1st Level -

Rectify issues raised in Remedy for Severity 1). Issues must be rectified

before Asia-Pac office hours to avoid disruption in Users operation.

. Escalates issue to the involved department (Asia- Pac). Communicate thru

phone, sms or email.

Company Name: Accenture Singapore

Duration: July 2005 - August 2006

Project Name: IRAS

Senior Software Developer

. Project Technology: VS.Net 2003 (C#) and DB2 as Backend DB

. Three people are under my supervision for this project

. Reports and provides updates to the Project Manager on the task status of

the team

. Plans timelines, assigns needed resources and monitors if schedules and

deadlines are strictly met.

. Application coding in C#, SQL stored procedure in DB2.

. Application testing using NUnit and directly liaise with the users for

testing cycles and bug fixes.

Company Name: American International Underwriters.

Duration: May 5, 2003 - June 10, 2005

Systems Analyst /Programmer

. Project Technology: VB.Net 2003 (C#) and Sybase as Backend DB

. Application design including UML and adopt the Microsoft Best practices

in the system development

. Reports and provides updates to the Project Manager on the status of the

projects that are handled by the developers that are assigned under my

supervision.

. Plans timelines, assigns needed resources and monitors if schedules and

deadlines are strictly met.

. UI and Database design

. Application coding in VB.Net, VB and SQL stored procedure in Sybase.

. Create Reports using Crystal reports 8

. Create document for User Testing and Training

. Production support (2st Level) for APAC users (Thailand, Korea,

Singapore, Malaysia, Taiwan and Philippines).

Company Name: Accenture Philippines

Duration: August 2002 - April 2003

Software Engineer

. Create Use case for Global shares project

. Application coding in SQL stored procedure

. Create test cases and plan test cycles

. Implement Test cycles

. Developed reconciliation tool application using VBA (Excel)

Company Name: Extraordinary Realty

Duration: October 2001 -July 2002

Project Name: Property Manager

Software Engineer

. Project Technology: Visual Basic 6.0 and SQL server 2000

. UI and Database design for property retail application

. Create reports using Crystal reports

. Create document for Application, User Testing and Training

Company Name: Philamcare Insurance

Duration: January 2001 - August 2001

Software Engineer

. Project Technology: Visual Basic 6.0 and SQL server 2000

. UI and Database design for property retail application

. Application coding in Visual Basic, VBA (Excel) and SQL stored procedures

. Create reports using Crystal reports

. Create document for Application, User Testing and Training

. Liaise with the users for enhancements

Nov. 1999 - Jan. 2001 Geodata Technologies Inc.

Analyst /Programmer

. Project Technology: Visual Basic 6.0 and SQL server 2000

. Application coding in Visual Basic, and SQL stored procedures

. Create test cases and plan test cycles

. Implement Test cycles

Education

1995 - 1999 AMA Computer College Quezon City

Trainings Attended

Microsoft SQL 2005 Migration

Avantus Singapore

11th-19th December 2006

Contact this candidate