Resume of SQL DEVELOPER

Title
SQL DEVELOPER

Primary Skills
SQL SERVER DEVELOPER

Location
US-NJ- (will consider relocating)

Posted
Jan-29-08

SQL Server Developer / DBA.

PROFILE
• Over 11 years compound experience in IT, Banking and Finance environments; 6+ years SQL Server database development experience with DBA duties.
• Worked closely with other DBAs in the design and implementation process for deploying, upgrading, managing, archiving and extracting data for reporting
• Hands on experience with scripting in T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity, optimized indexes and statistics in relation to reporting data model
• Used partition function to create partitioned tables and partitioned Index
• Hands on Experience in ETL (Extracting, Transforming and Loading) development using DTS and SSIS; Experience in data mining and analysis, design and construction of data marts, data views; Extensive experience in design techniques, ETL processes, relational database theory
• Hands-on experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000 and SQL Server 2005
• Up to par with performance, scalability, high availability, security and compliance best practice guidelines in database design, performance tuning, implementation, and maintenance in a SQL Server 2005 environment
• Implemented a well-planned backup and restore strategy protects databases against data loss due to damage caused by a variety of failures.
• Managed client software in a Microsoft SQL Server 2005 environment
• VLDB and high transaction volume experience, storage arrays, and fast growth databases.
• Extensive experience with legacy system data conversions
• Implementation and maintenance of security integrity controls (logins/roles) of applications and security groups
• Good documentation skills, Excellent communication, presentation and interpersonal skills , Strong troubleshooting and organizational skill

TECHNICAL SKILLS
Category Technology
Databases
Operating Systems SQL Server 2000/2005 Enterprise/SQL Server 6.5/7.0
SQL, T-SQL, Office 97/2000/2003/2007
Installation, Configuration, and Upgrade
SSIS, DTS, ODBC, OLE DB, OLTP
Windows 98, Windows 2000 Professional
Windows XP 2003/2005 Professional, Windows NT 4.0, Erwin 7,
Log Parser 2.2,
Light Speed 2005, Visual Studio.Net,
SQL Enterprise Manager, SQL Management Studio

Applications Visual Studio 6.0/ Visual Studio.NET
SQL Server Business Intelligent Development Studio



EMPLOYMENT HISTORY

Sisters of Mercy Health System Saint Louis, Missouri
Technical Developer / DBA Jan 2007 -- to date

Scope
The Sisters of Mercy Health System is one of the nation's “Most Wired” health systems, according to the results of the 2007 Most Wired Survey and Benchmarking Study. This is Mercy's sixth year on the list. The scope of the job was to provide information system services which include application standardization, networking, and consulting support for all functions within Mercy and between Mercy and external partners. As a part of team, my responsibilities included writing store procedures, designing DTS and SSIS packages, migrating databases to Production environment, modifying database structures, providing support and guidance to operational models by checking for data quality and its consistency, developing database backup/recovery procedures, providing technical support.

Responsibilities:
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the data; Scheduled the jobs to do these tasks periodically;
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting;
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports;
• Made sure that standards and best practices in database development were followed and maintained;
• Scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index defragmentation;
• Set up database backup and recovery strategies;
• Maintained all records of project status and followed changes as per control procedures;
• Provided technical support to internal developers and external clients;
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, PDAs and window messengers;
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment
SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003, .NET, Microsoft Visual Studio 2003/2005, T-SQL, SSIS Packages, ETL, ETL, Schema Design / ERWin DM r7.2, UDM, User Notification Services

Paladin Consulting Inc Plano, Texas
Database Developer / Designer Jan 2006 -- Dec 2006

Scope
The Database Administrator/Developer must have the ability to interact with individuals at any level, both inside and outside the company, concerning technical and non-technical issues by providing data expertise related to all core finance systems and processes including understanding the flow of data, the core data elements and the implication of changes to any data transformation routines within the Finance Department.

Responsibilities

• Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations; scheduled the same SSIS packages by creating the corresponding job tasks;
• Designed database/tables and the requisite relationships, designed partition tables and partition views;
• Created/developed/maintained the stored procedures, triggers to interpret complex business rules, history data and audit analysis;
• Administered the day-to-day operations of the financial system, making sure all processes run effectively; trained users and responded to user questions and issues;
• Worked with financial systems team members to document systems and process environments;
• Coordinated all appropriate interaction and support needed by both IS and Accounting and Finance application users; coordinated all system test plans; participated in the system testing; performed system upgrades, patches and point releases as necessary.

Environment
SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003, .NET, Microsoft Visual Studio 2003/2005, T-SQL, SSIS/ DTS, ETL, Schema Design / ERWin DM r7.2

Verizon Data Center Irving, Texas
SQL Developer / DBA Jul 2004 -- Dec 2005

Scope
Verizon Communications, Inc. is an American broadband and telecommunications company. The company offers a better alternative to high-priced cable broadband at a reasonable cost, from digital music and streaming video to photo sharing and online gaming, to video conferencing and working from home. We worked on a sales tracking system which used Microsoft SQL Server 2000 and Microsoft 2000 advanced datacenter servers. It was set in a collaborative, team-oriented environment within Verizon Data Center and external partners to set and meet department goals and deadlines pertaining to application standardization, and consulting support for all related applications and functions.

Responsibilities:

• Supported business functions through use of internally-developed and third-party software solutions.
• Developed complex SQL queries, stored procedures, and DTS packages
• Defined and developed a data migration strategy between different products and platforms
• Worked on optimization and tuning of SQL queries and indexes
• Assisted in the application development, debugging, configuration, and optimization from database perspective
• Performed database design by analyzing business requirements
• Reviewed applications and database design for compliance with best practices standards
• Assisted in troubleshooting and resolution of database issues

Environment:
SQL Server 2000 Enterprise, Windows Enterprise Server 2003, .NET, Erwin, Microsoft Visio, DTS, SQL Profiler, Query Analyzer, ETL, SQL Lite

Provident Bankshares Corp. Baltimore, MD
Database Developer Jan 2003 -- Jun 2004

Scope
Provident Bankshares Corp. is the holding company for Provident Bank, the second-largest banking institution headquartered in Maryland. With $6.36 billion in assets, it has 152 branches in southern Pennsylvania, Virginia, Baltimore and the greater Washington suburbs. The job was set in a collaborative, team-oriented environment within Provident Bankshares Corp. in order to set and meet department goals and deadlines pertaining to application standardization, and consulting support for all related functions. In both of development and production environments, the job focused on administrating, maintaining, and optimizing the existing databases; designing and implementing new databases for various projects according to the requirements from Provident Bankshares Corp.

Responsibilities
• Performed periodic maintenance and upgrades on both database hardware and software
• Implemented a well-planned backup and restore strategy that protects databases against data loss
• Managed all database servers in production, staging, and development and test environments
• Responsible for the design, development and implementation of mappings/transformations based on source-to-target specifications, defining ETL (extract, transform, load) and ETS development standards and conventions
• Daily, weekly, and monthly production data processing, monitoring, and trouble-shooting in an environment of mission-critical operational systems, benchmark establishment, and capacity planning.
• Planned and implemented long-term capacity planning and infrastructure changes to maximize performance for all database components.
• Responsible for deployment and rollback execution to support software/solution releases
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
• Provided production support for data servers on a 24/7 basis

Environment
SQL Server 2000, Erwin, DTS, Enterprise, Query Analyzer, Erwin, Microsoft Visio, T-SQL, LiteSpeed

Blue Cross Blue Shield of Michigan Detroit, Michigan
Production Database Developer Jul 2001 -- Dec 2002

Scope
Blue Cross and Blue Shield of Michigan has the largest network of health care providers in Michigan and over six million subscribers, and they offer a broad range of health plans for both individuals and individuals with families. The job was to develop, implement and maintain all databases including stored procedures, triggers, and complex queries, which include the administration of various bank databases in both development and production environments.


Responsibilities
• Daily, weekly, and monthly production data processing, monitoring, and trouble-shooting in an environment of b operational systems
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing
• Installed and maintained database applications to improve processing performance including applying upgrades, patches, and bug fixes in all database instances
• Created scripts and SQL jobs to facilitate database backup and recovery, server and data processing monitoring and alerting
• Worked with developers to setup databases and coordinate the schemas and procedures deployment on staging and production.
• Performed reorganizations and implement changes on production databases.
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases
• Served as technical support for any database related performance or access issues

Environment
SQL Server 2000, Windows Server, Windows NT, .NET, Erwin

Coca-Cola Bottlers Philippines, Inc. Manila, Philippines
Systems Specialist 1995 -- 2001

Responsibilities:
• Analyzed, designed, and developed interface programs using SQL, Cobol, RPG, and CLP procedures on DB2 UDB (Query Manager) for iSeries to consolidate forty-two (42) databases/libraries (one for each of the plants) of the Sales and Marketing System into one database; and to monitor receivables from customers for nationwide consolidation to help top management in the analysis of sales and marketing figures;
• Ensured Y2K compliance of the Sales and Marketing System(BASIS) and non-BASIS through remediation of locally developed programs (RPG and COBOL);
• Conducted application training and provided technical support to all users and implementors ;
• Documented the above systems in terms of its screen and report layouts, database design, function description and interfaces with existing systems.

Environment
IBM AS/400, IBM S34/36/38, IBM PCs and compatibles, COBOL/400, COBOL/ILE, CL, RPG IV, DB2/SQL for AS/400, SDA, SEU, DFU, Query, PDM, DeBug, SQL, MS Access, Word, Excel, Powerpoint, Project, OS/400, MSDOS, Windows 95/98/2000, Client-Access/400 including Client Access Express and Operation Navigator

EDUCATION
Microsoft Certified Professional
(SQL Server) US
AS/400 Business Application Diploma Certification Seneca College , Toronto, Canada
B.S. Chemical Engineering University of the Philippines,
Quezon City, Philippines

REFERENCES AVAILABLE UPON REQUEST

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-NJ »

View other SQL DEVELOPER resumes, Programmer / Developer resumes