Manager Sql Server
Resume:
Farida Orapunt
*** **** ******, ******* ** *****
*******@*******.***; ********@*******.**; ******.*******@***.***
Employment situation: Green Card holder
OBJECTIVE: To obtain a position where I can apply my computer and electronic systems engineering education and work
experience to analyze, develop and deliver information technology.
INFORMATION TECHNOLOGY EXPERIENCE SUMMARY:
Seven years experience in Microsoft SQL Server database administration, architecture and development in client-server and
in-tier Internet environments. Six months as Assistant IS Manager.
Client Operating Systems:
Microsoft Windows 9x, NT 4.0 Workstation, 2000 Professional, and XP.
Programming Languages:
SQL, Visual Basic, Pascal, Assembly, Fortran, Cobol, RPG.
Software Applications:
MS SQL Server (6.5/7/2000/2005), ORACLE 10g, Informatica, Ghost, MatLab, MS Access, MS Word, MS Excel, MS
PowerPoint, Corel Draw, Adobe Photoshop.
Professional Summary:
- Knowledge of Replication, Data Availability, Log Shipping, Data Transformation Services, Data Import/Export,
Integration Services and ETL, Administrative and Task Automation.
- Hands-on experience with SQL Server versions (6.5, 7, 2000, 2005) in the following editions (Enterprise, Standard,
Developer, Express).
- Expert level knowledge of Database Backups and Restoration, Recovery procedures, and Maintenance tasks.
- Experienced in resolving problems related SQL Jobs and Alerts and take actions accordingly.
- Extensive use of creating SQL Queries, Stored Procedures, Indexes, Triggers and Tables.
- Strong understanding of SQL Server Architecture and Database Design.
- Hands-on experience in Performance Tuning, Logical and Physical Database Optimization, Hardware Sizing and
Testing.
- Expertise in Database Programming and Data Conversion over 5 years experiences of algorithm designing and
debugging.
- Strong knowledge of VBA and MS Access (97, 2000, 2003).
- Knowledge of Peer-Peer, TCP/IP Based and Client/Server Networking and experience in n-Tier and Object-Oriented
design methodologies, development, implementation and support.
- Delivery program Assistance to small-companies for all Windows operating systems and Microsoft Office family
applications including Access, Outlook, Word, and Excel (95, 97, 2000, 2003, 2007).
- Experience in installing and configuring Windows operating systems (98, ME, XP, 2000 Professional and Vista) with a variety
of memory, PCI cards and USB devices, DVD and multimedia software and hardware.
- Experience in creating Ghost images of various installations.
- Experience in workstation management, updated software configuration, computer and peripheral integration, problem
analysis, and resolution.
- Technical writing includes more than 3 years of writing documentation for software implementations.
- Strong client services skills and experienced working with clients on-site, off-site and on-call, analyzing software
requirements and developing solutions and procedures.
- Offers proven abilities as team player; possess strong communication, verbal and written skills, Self-motivated with analytical
and problem solving skills developed through variety of projects
PROFESSIONAL EXPERIENCE:
CGI Information Systems and Management Consultants Inc., Saskatchewan, Canada
Database Analyst (Client: Russell Investment in USA) 01/07 to Present
Team member of database administrators responsible for all SQL Server database architecture, development and
administration for one of the large investment companies in USA.
- Managed multiple SQL 2000 database servers in development and production environments with databases as large as 500
GB. The environment is high volume 24X7 online transaction process (OLTP) for US dollar account management.
- Developed application requirements and designs in support of quickly changing business needs.
1
- Designed and created tables, views, triggers, and stored procedures in T-SQL for both SQL 2000 and 2005 in support of
several dynamic, high change-activity applications.
- Monitored SQL Server performance for excessive blocking, locking and inefficient stored procedures and queries.
- Rewrote procedures and modify database schemas as necessary to resolve application bottlenecks.
- Reduced run time of SQL Server resource requirements for some processes by more than 80%.
- Implemented replication strategies for multiple high availability SQL Server2000 environments.
- Responded for planning, implementing and maintaining SQL 2000 virtual server over Windows 2000 Advanced Server
clusters.
- Responded for backup and restored databases from the disk and tape backup.
- Responded for handling client requests.
- Created documentation of new and existing processes.
- Researched solutions to various SQL issues or upgrades.
- Provided services off hours and on-call, weekends and holidays and other duties as requested.
- Assisted with network administration including setup and maintenance of new user account and network backup.
IQmetrix Intelligent Business Solutions, Regina, Saskatchewan Canada
Support Team Specialist (Level 1) 09/06 to 12/06
The front-line/first point of contact for technical support.
- Answered incoming support calls using a list of frequently encountered issues and attempt to resolve the client concern.
- Escalated the issue to Level 2 support when unable to deal with the problem.
Thai Ruamtoon Warehouse Co., Ltd. (T.R.R. Group), Bangkok, Thailand.
Project Leader/Assistant IS Manager 01/04 to 08/04
A supervisor and team leader directed and controlled computer programmers and the work of subordinates to
supports the IS Manager in the day to day running of a Information System department.
- Reported directly to the director and IS Manager, and was the single point of contact for 6 sugar factories in T.R.R. Group
concerning technology infrastructure related to wired and wireless Networks, routers, corporate backoffice application, PCs,
servers, point of buy hardware and related systems.
- Analyzed LAN to determine what were the major problems and improvements needed to be made to the network
infrastructure.
- Evolved the LAN infrastructure with a dial-up internet connection to a lease line or fiber optics backbone connecting 5 sugar
factories and WAN connecting satellite to another sugar factory.
- Designed, implemented and maintained Novell and Windows NT-based networks utilizing various LAN and WAN
technologies including Ethernet, Token Ring, T-1, Frame Relay, TCP/IP and IPX/SPX.
- Performed MS SQL Server 7.0 and 2000 DBA functions. This was comprised of SQL installation, configuration and
performing tuning.
- Created of views, triggers, and stored procedures utilizing both static and dynamic T-SQL along with troubleshooting and
correcting of blocking and deadlocking issues were also included.
- Provided project management for both new implementation and post implementation support engagements.
- Led and mentored computer programmers.
- Utilized MS Transact SQL, and VB Script to modify standard package or create custom functional modules.
- Designed, developed and maintained database (including user interface) by using MS Access and VB Script for application
and report generation.
- Did presentation of the database to the users, responded for report generation, scheduled and wrote database
documentation.
- Made presentations of the department projects to the clients (6 factories in group of companies) and Board of Supervisors
using MS Word, MS Excel and PowerPoint.
- Prepared exhibits and technical reports for manuals, brochures, presentations and publications.
- Analyzed work requests for completeness including customer follow-up and updating documents. Contact with public,
engineering companies, service provides (power companies, water companies, fire agencies, school districts, telephone
companies, and emergency) via telephone, e-mail and in person. Compose various county business letters.
- Provided services off hours and on-call, weekends and holidays and other duties as requested.
Computer Programmer 09/98 to 03/01
Responsible for Inventory and Cane Account programs of T.R.R. Group
- Analyzed user requirements and developed system specifications.
- Developed and tested the code for cane accounting tasks within the corporation, including cost estimating, salary
computation and purchased supplies, and monitoring 6 factories of the company group.
- Implement application software and trained user community.
- Worked on SQL server (6.5/7/2000) support in Microsoft Access and Microsoft applications.
- Installed and upgraded of desktop hardware, software system and peripherals.
- Supported and assisted for hundreds of users with varying levels of computer experience.
- Assisted with network administration including setup and maintenance of new user account and network backup.
- Evaluated and installed of new hardware and software as well as efficient use of existing tools to support operations.
2
- Design, programming and long-term support of Microsoft Access database programs to meet information storage and
reporting needs at individual and corporate levels.
- Assisted with design and assembly of a documentation system for facility procedures and work instructions.
University of Regina, Saskatchewan, Canada
Teaching Assistant 2002 to 2003
- Assisted with academic aspects in undergrad class, ENEL 280 - Electrical Circuits and ENEL 282 - Semiconductor Devices,
with the Department of Electronic Systems Engineering.
- Facilitated recitation as assigned
- Completed the assigned homework problem/cases individually
- Collected, collated and distributed sets of handouts and examinations
- Assisted in distribution of instructor/course evaluations
Student Research Assistant 2002
- Assisted with technical aspects in research work with the Department of Electronic Systems Engineering. Analyzed and
simulated the data to understand the optical properties of amorphous semiconductor devices in Matlab.
- Facilitated recitation as assigned.
Formula Industries Co. Ltd., Bangkok, Thailand
Assistant OEM Manager 03/98 to 08/98
- Looked after OEM Manager for the production line.
- Responded for sale / collection / business/ development / sale planning and forecasting.
EDUCATION:
Doctor of Philosophy, University of Regina (UofR), Canada to be completed in 09
Electronic Systems Engineering (GPA 93.66%).
Master of Engineering, King Mongkut’s University of Technology Thonburi (KMUTT), Thailand 02/04
Computer Engineering (GPA 3.33).
Master of Applied Science, University of Regina (UofR), Canada 12/03
Electronic Systems Engineering (GPA 91.33%).
Bachelor of Science, King Mongkut’s Institute of Technology Thonburi (KMITT), Thailand 02/97
Mathematics Science.
Related Courses:
Advanced Electronic Devices, Advanced Software Design, Artificial Intelligence, Computer and Information Security, Computer
Architecture, Computer Networks, Data Communication Systems, Data Management, Data Structures, Database Systems,
Digital Hardware System Design, Digital Image Processing, Digital Telephony, Digital Signal Processing, Electrotechnology,
Operations Research, Operating Systems, Optoelectronic, Sampling Techniques, Software Engineering, Statistical Inference,
Stochastic Process, System Analysis and Design and Visual Information Retrieval.
PROJECTS:
Ph.D.’s Project
The dependence of optical absorption in Hydrogenated Amorphous Silicon.
Master’s Thesis
The optical absorption in Hydrogenated Amorphous Silicon.
Term Project in Advance Software Design
As a project team for a flight plan scheduling project, I was responsible for the project coordination, integration and
documentation throughout a semester.
Term Project in Virtual Information Retrieval
Wrote a complete program by MatLab to retrieve synchronized sounds and interpret the signal to notes.
Term Project in Digital Image Processing
Wrote a complete program by Matlab to retrieve the image of 1000 samples by converting color space and create index of
each picture.
AWARDS AND SCHOLARSHIPS:
3
2003. University of Regina, Saskatchewan, Canada.
Spring/Summer – Faculty of Graduate Studies and Research Graduate Scholarship.
Fall – Faculty of Graduate Studies and Research Graduate Scholarship.
2005. University of Regina, Saskatchewan, Canada.
Spring/Summer – Faculty of Graduate Studies and Research Graduate Scholarship.
Fall – Faculty of Graduate Studies and Research Graduate Scholarship.
2006. University of Regina, Saskatchewan, Canada.
Winter – Faculty of Graduate Studies and Research Graduate Scholarship.
Spring/Summer – Faculty of Graduate Studies and Research Award.
Fall – Faculty of Graduate Studies and Research Graduate Scholarship.
CONFERENCRES AND PUBLICATIONS:
1. D.J. Lockwood, J.-M. Baribeau, M. Noël, J.C. Zwinkels, B.J. Fogal, F. Orapunt, S.K. O'Leary, Amorphous Silicon
Films and Superlattices Grown by Molecular Beam Epitaxy: An Optical Analysis, Amorphous and Heterogeneous
Silicon-Based Films-2002 (J.R. Abelson, J.B. Boyce, J.D. Cohen, H. Matsumura, J. Robertson, Eds.) Mater. Res.
Soc. Vol. 715, A19.1.1-A19.1.6. (2002).
2. F. Orapunt and S.K. O’Leary, The Urbach focus and hydrogenated amorphous silicon, Applied Physics Letters,
Vol. 84, p. 523-525 (2004).
3. J.H.D. da Silva, R.R. Campomanes RR, D.M.G. Leite, F. Orapunt, S.K. O’Leary, Relationship between the optical
gap and the optical-absorption tail breadth in amorphous GaAs, Journal of Applied Physics, Vol. 96 (12): 7052-
7059 (2004).
4. D.J. Lockwood, J.-M. Baribeau, M. Noël, J.C. Zwinkels, B.J. Fogal, F. Orapunt, and S.K. O'leary, 2005, Amorphous
Silicon Films and Superlattices Grown by Molecular Beam Epitaxy: An Optical Analysis, MRS Spring Meeting,
Program/Symposium A19.1 (2005).
5. L.-L Tay, D. J. Lockwood, J.-M. Baribeau, M. Noel, J.C. Zwinkels, F. Orapunt and S.K. O'Leary, The Optical
Response of Silicon Films Prepared Through Molecular Beam Deposition, MRS Spring Meeting,
Program/Symposium A10.2 (2006).
Business Reference
Darlene Buttazoni
Senior Consultant (B.Comm, PMP)
CGI Information Systems and Management Consultants
1900 Albert Street, Regina, SK S4P 4K8
Tel. 306-***-****
Email: *******.*********@***.***
Hussam Barieh
Senior Consultant - DBA Technical Lead
CGI Information Systems and Management Consultants
1900 Albert Street, Regina, SK S4P 4K8
Tel. 306-***-****
Email: ******.******@***.***
John Chu
IS Manager
Thai Ruamtoon Warehouse, Co., Ltd.
Bangkok, Thailand
Phone: (662-***-***** ext. 287 (Office)
E-mail: ****@********.***
Academic Reference
Stephen K. O’Leary, PhD
Professor of Electronic Systems Engineering
Faculty of Engineering
University of Windsor
Tel. (519) 253- 3000 Ext. 2567
Personal Reference
Gary Peck
Sales Manager,
The Pet team
302 Vine Circle
4
Rocklin, CA 95765
Phone: 916-***-****
E-mail: ****@*********.***
Bob Lim
Sales Associate,
Costco
Midas Avenue, Rocklin, CA
Tel. 916-***-****
Lana Aksenova
Software Engineer,
Intel Corporation
5519 Cabrillo Way, Rocklin, CA 95765
Tel. 916-***-****
Ron Benning
Real Estate Broker
RE/MAX Gold West Roseville
983 Reserve Drive
Roseville, CA 95678
Tel. 916-***-****
5
Contact this candidate