Project Sql Server

Julio Piedrasanta

Montebello, CA *****

Home 323-***-**** • Cell 323-***-****

*****.*@*********.***

PROFESSIONAL SUMMARY

Solutions-oriented with over ten (10) years IT experience including:

• Database administration and developer

• Experienced in developing and troubleshooting data storage setups, database design, programming and

administration in direct support of business objectives

• Extensive hands on experience in T-SQL, SQL, DTS, SSIS, SSRS, Stored Procedures, Functions, Triggers,

Views, Security, Data Analysis, Query Optimization and Data Migration

• Experienced in Logical and Physical database modeling

• Maintain data standards

• Backup and Recovery procedures

• In depth knowledge of MS Access using VBA to create web like looking applications and Access

Reporting

TECHNICAL & SOFT SKILLS

• Excellent computer skills - Microsoft Office including Access, PowerPoint, Excel, and Microsoft Project,

Visio, DBArtisan, Erwin, VB, VBA and SQL Server 6.5/7/2000/2005

• Excellent oral and written communication skills; detail-oriented; well-organized; consistently able to

demonstrate success in planning effectively and meeting project deadlines

• Strong problem-solving skills utilizing creative solutions; possess the ability to learn, adapt, and become

quickly skilled in new areas of technology

• Team player with proven ability to excel in high pressure environments; accepts responsibility and enjoys

challenging projects that require creative solutions

PROFESSIONAL EXPERIENCE

Catholic Healthcare West, Pasadena, CA

Senior Business Systems Analyst 2/2007 – 5/2009

Responsible for providing support in identifying key manual work processes within the Managed Care

Applications Department for automation and applying enabling technologies to create a more efficient work

environment. Under the direction of the Senior Director of Managed Care, responsible for the effective

planning, development, and implementation of high quality information technology tools to eliminate manual or

duplicate work processes

• Develop highly sophisticated Access applications using VBA and SQL server as back-end

• Develop customized Ad-Hoc Reports

• Provide DBA support and administration of distributed SQL development/test/production database

environments

• Responsible for performing analysis of data

• Provide support of existing Production applications

• Act as liaison between Hospital Directors and Managed Care Applications department

• Responsible for analyzing existing manual process and make necessary recommendations for automation

• Build a highly sophisticated application to aid in contract negotiations with Healthcare Organizations

• Build a systems request application to track different requests tickets for the department

Julio Piedrasanta

Page Two (Continued)

Blue Shield of California, Woodland Hills, CA 8/1996 – 2/2007

Database Administrator II (2004 – 2007)

Work with all aspects of SQL Server database administration including Data Modeling and Post-

Implementation support. Work in conjunction with other developers to create web based applications and their

supporting databases.

• Provide DBA support of distributed SQL and Oracle development/test/production environments

• Provide support and assistance to different project planning by identifying project definition, design

requirements, analysis documentation, database design, development and implementation

• Responsible for data integrity, backup and restore procedures, and performance tuning

• Work on logical/physical data modeling as the primary Database Developer

• Aid in the implementation of Security policies

• Proactive database maintenance plans

• Collect and analyze real-time performance and historical information

• Day-to-day database management, monitoring and troubleshooting

• Support data loads from different sources

• Stress testing for database / Apps servers

• Advise application developers on writing optimal code

(2001 – 2003)

Programmer Analyst II

Responsible for developing, coordinating and managing new applications’ design, development and

implementation. Tasked with analyzing existing manual processes throughout different Business Units and find

ways to automate or make it more accessible to the users

• Analyze new and existing business processes to formulate recommendations for integration and/or

enhancements

• Develop and maintain applications, reports and process flows for senior management

• Provide support for software applications which includes MS Access, SQL, Oracle and AS400

• Act as a liaison between business and technical staff at all levels of the business cycle

• Provide Project Management between IT and Business Units by organizing project tasks, structure

information collection activities, and set up timelines for completion of required tasks

• Responsible for collecting, researching and performing analysis of data

• Handle full range of project components as a team player and in an independent and autonomous manner

(2000 – 2001)

Systems Analyst II

Participated in organization assessment of implementation plans for the migration of old system programs onto

new software platforms. Tasked with creating a centralized place where many of the re-occurring Business

Units’ requests where to be automated.

• Act as a liaison between business and technical staff at all levels of the business cycle

• Provide analytical support to different Business Units

• Responsible for collecting, researching and performing analysis of data

• Provide design, development, support and access to ad-hoc reporting information using MS Access,

AS/400 and New Generation Software

• Provide problem resolution to complex questions regarding Provider of Services, claims, plan codes and

membership

• Increase flexibility in reporting features

(1996 – 1999)

Systems Analyst

Liaison between IT and Business Units to address technical issues. Provided design, development, support,

problem resolution and access to ad-hoc reporting information using the AS/400 and New Generation Software.

• Improve query readability and design using NGS for AS/400

• Increase flexibility in reporting features

• Design and develop Membership Tracking System using MS Access

• Design and develop reports on imports and manipulation of large data.

• Maintain and update AS/400 queries for Membership, Claims and Provider Relations

• Analyze data for accuracy and consistency

Contact this candidate