|
|
Title: |
SQL Server Developer
|
Location: |
US-Texas-Dallas
|
Work History: |
Lee M. Bagapuro
Phone: (214) 504-1565 / (469) 432-2167
QUALIFICATION SUMMARY
• 11+ years I.T. experience
• 5 years Backend Development experience using Microsoft SQL Server Transact SQL
• Solid experience on creating Stored Procedures, Triggers, Functions, Views and Constraints
• Experience with Bulk loading using BCP, ETL (Extract, Transform, Load) and DTS
• Experience on creating and modifying database objects and constraints
• Solid experience on server utility such as Backup and Recovery
• Light experience on Microsoft SQL Server database administration
• 4+ years Sybase DBA and Sybase Transact SQL Experience
• 9+ years all in all Transact SQL Experience
• Experience on Microsoft SQL Server to Sybase migration
• Exposure on providing Basic to Intermediate Sybase training courses
• Experience in database design and development
• Banking, Insurance and Health Care industry experience
COMPUTER SKILLS
Operating Systems: Windows (3.1, 95, 98, NT, 2000, XP), Linux, UNIX
Databases: MS SQL Server (6.5, 7.0 and 2000), Microsoft Access 2000, Sybase ASE (version 12.0, 12.5 and 15.0), xBase
Languages: Microsoft SQL Server Transact SQL, Sybase Transact SQL, Visual Basic 6.0, Vantive Basic for Application (VBA), Turbo Pascal, Foxpro for DOS, VAX COBOL, Application Generation System (AGS)
Software: Embarcadero DBArtisan, ProActive DBA, Sybase Jaguar / EAServer, Autosys, ERWIN, Visio, Sybase PowerDesigner, Sybase PowerTransfer, Vantive 8.0 (Peoplesoft CRM), Vantive Tools, Vantive Forms Designer, Visual SourceSafe Seagate Crystal Reports, Actuate Reports
WORK EXPERIENCE
Senior DBA
Stradcom Corporation Jul 2006 to Mar 2008
Stradcom Corporation is a leading private sector proponent for government information technology projects in the Philippines. Stradcom is currently implementing the Land Transportation Office-Information Technology (LTO-IT) Project.
- Primary DBA Support for sites with about 40 plus Sybase production servers running on Windows and Linux RHEL4
- Secondary DBA Support for the Central Office Sybase production server running on Linux RHEL4
- Major responsibilities include database administration, troubleshooting of Sybase ASE servers, performance and tuning, and database maintenance
- Minor tasks includes maintenance of Jaguar servers and InfoImage/G360 system
- Perform regular Sybase ASE server upgrades and migration on both Windows and Linux platforms. Migration involves application and database migration from Sybase 12 and 12.5 into Sybase ASE 15.0
Technology: Sybase ASE 12.0, Sybase ASE 12.5, Sybase ASE 15.0, Linux, Windows
Professional Services Consultant and DBA
Sybase Corporation Dec 2004 to Jun 2006
Sybase Solutions Corporation is the sole distributor of Sybase in the Philippines, the recognized technology leader in client/server software solutions.
- Responsible for rendering DBA and technical support work for all clients with Sybase ASE licenses
- Regular tasks include database administration, troubleshooting of Sybase ASE servers, performance and tuning, database maintenance, scoping of possible client engagements (proof of concept), and on-call technical support for major clients
- Performed installation of Sybase ASE servers and Sybase clients on Windows, Linux and UNIX
- Performed regular upgrades of Sybase servers through EBFs
- Performed successful database recovery of Sybase servers with hardware failure
- Handled installation of sybsecurity for audit and dbccdb for database consistency
- Performed regular database maintenance and monitoring
- Provided regular backup procedures
- Technical Lead on Migration Projects:
o Microsoft SQL Server to Sybase ASE migration
o Sybase ASE 12 to Sybase ASE 15 migration
- Performed regular Sybase Transact SQL development on various client needs
- Handled installation of Red Hat Enterprise Linux 4.0 on production and development servers
- Responsible for teaching all scheduled courses for Sybase ASE:
o Introduction to SQL course
o Fast Track to Sybase ASE course
o System and Database Administration: Sybase ASE
Technology: Sybase ASE 12.0, Sybase ASE 12.5, Sybase ASE 15.0, Microsoft SQL 2000, Linux, UNIX, Windows
Senior Software Engineer
Accenture Mar 2002 to Nov 2004
Accenture in Manila conducts its activities as the Manila Delivery Centre being part of Accenture’s Technology & Outsourcing group.
- Sub-team lead for Backend Development team
- Sub-team lead for Product Testing team
- Migration Coordinator
- Development of program scripts, stored procedures, functions and triggers using Transact SQL
- Development of DTS packages
- Perform unit and assembly test for modules
- Development of data transformation tools using Visual Basic and MS Access
- Perform code optimization
- Creation of test plans, test conditions, test scripts and test data
- Execution of test scripts
- Creation of General and Detailed design documents
- Review of codes, design documents, and test documents
- Creation of CRT (Capability Release Testing) and ORT (Operational Readiness Test) documents
- Archiving of objects in VSS
Technology: Microsoft SQL 6.5, Microsoft SQL 7.0, Microsoft SQL 2000, Microsoft Access 2000, Visual Basic 6.0, Visual SourceSafe
Analyst Programmer
Information Technology Solutions International, Inc. Jun 2001 to Jan 2002
ITSI Inc. is a leader IT application development company in the Philippines.
- Responsible mainly for the Attendance Register module and some external reports used for payroll
- Also a member of a team responsible for the FMS Desktop Application
- Development of forms and functionalities using VB 6.0
- Involved in code development and code revision
- Perform code spikes (feasibility) for certain functionalities
- Created and updated unit test plan document
- Performed unit testing
Technology: Visual Basic 6.0, Microsoft SQL 6.5
Software Engineer
Singapore Computer Systems Mar 2000 to Mar 2001
Singapore Computer Systems (SCS) is a leading information and communications technology service provider in Asia. As the provider of Trusted Services to its customers, SCS empowers organizations with competent IT professionals, using proven processes and living technologies in a timely and cost-effective manner.
- Installation of MS SQL v 6.5 Server
- Installation of Vantive Server and Client version 8.5.3
- Maintenance and performance tuning of MS SQL Server
- Provided support on installation of Vantive Server and Clients
- Responsible for Actuate Reports Administration
- Business analysis for the Product module
- Gather user requirements and translate to program specifications
- Development of functionalities using VBA/VBScript and ActiveX
- Development of objects and forms using Vantive Object Studio
- Creation of Transact SQL stored procedures, functions, triggers, scripts for certain business rules
- Perform Unit Testing
- Provided training on Actuate Reports Administration
- Provided technical support on Vantive system customization
- Provided technical support on Actuate reports
- Served as a technical team lead on both reports and pricing modules
- Provided Pre-Sales Support
- Provided Vantive Enterprise Demo
- Provided Vantive Programming training
Technology: MS SQL 6.5 and 7.0, Vantive 8.0, VBA/VBScript, Vantive Enterprise, Actuate Reports
Associate Product Support Specialist
Aetna Jan 1998 to Dec 1999
Aetna is one of the nation’s leading diversified health care benefits companies, serving members with information and resources to help them make better informed decisions about their health care.
- Created the database design
- Created forms and objects
- Developed the various functionalities
- Performed unit testing
- Created Transact SQL scripts for generation of test data for use in stress and performance testing
- Created Transact SQL scripts for initial customer record upload
- Created Transact SQL stored procedures for the application of proper business logic and to facilitate correct data transfer
- Involved in the maintenance and documentation
- Performed Y2K testing
- Provided technical support on customized Vantive product (Malaysia)
- Provided technical support on database design (Malaysia)
- Searched for a suitable data transformation and data transport tool
- Involved in the decision making for which product to buy
Technology: MS SQL v 6.5, IBM DataPropagator / DataJoiner, Vantive 8.0, VBA/VBScript
Developer / Analyst
Citibank, N.A. – Asia Pacific Support Center Jul 1996 to Aug 1997
Citibank N.A. – APSC is Citibank’s IT support and development center in Asia and the Pacific region.
- Analyzed and designed the teller system
- Coded the financial and non-financial banking applications
- Performed unit and product testing
- Involved in the documentation
- Provided support on maintenance of product
Technology: AGS, SUN/UNIX, Windows
EDUCATION
De La Salle University: Manila, Philippines
B.S. Computer Science – Information Technology
Continuing Education:
- Information Technology Training Program - Citibank, N.A. APSC
- Microsoft SQL Server Administration - Aetna
- Vantive Consultant Training - Aetna
- Microsoft SQL Programming - Aetna
- Administering Windows NT Training - Aetna
- Front Page Training - Aetna
- Seagate Crystal Reports Training - Aetna
- IBM Data Propagator and Data Joiner Training - IBM Global Services
- CMM Training - Accenture
- Red Hat Enterprise Linux Essentials – Sybase Solutions Corporation
- Sybase Performance and Tuning - Sybase Solutions Corporation
|
Skills: |
Sybase and MS SQL Server T-SQL
|
Education: |
BS in Computer Science - Information Technology
|
Endorsements
|
 |
Lee has received 0 endorsements.
|
Lee has endorsed 0 Members.
|
| |
Rank |
Title |
Location |
Status |
Actions |
|
Public Messages
|
|
| From |
Date |
Message |
No public messages. |
|
|
