Oskar Diaz de Leon
23424 Fern Pl
Murrieta, CA 92562
[Send email using form at bottom]
Phone 760.535.6798
EXPERIENCE

Welk Group Inc -  Systems Analyst - October 2004 – Current
• Lead team with Conversion of Crystal Reports to SSRS 2008 within Visual Studio
2008
• Development of Crystal Reports from corporate CRM system
• Integration of SQL Server 2008 Reporting Services with SharePoint in
Integration Mode
• Development and Design of Reporting Services Reports, with an connections of
embedment to other reports
• Deployment of Crystal Reports platform and Reporting Services platform
• Create and manage database maintenance plans and design and implement backup
and disaster recovery plans
• Deployment and setup of corporate SharePoint farm rolled out spanning 6
corporate locations
• Upgradeded SQL Server platforms to new Editions (SQL Server 2005- SQL Server
2008)
• Development/Administration on SQL Server 2000/2005/2008 focusing on Database
Normalization, Indexing, Stored procedures, views, Data mining,  and Reporting,
(Crystal & SSRS)
• Design/Development of Custom SharePoint applications using ASP.NET, SharePoint
API’s, and Web Services
• Development of multi-tiered SharePoint Workflows complete with alerts and
external dataset interaction.
• Development of Dashboards (KPI) using ASP.NET and SQL Server Reporting
Servicves(SSRS).
• Implementation of SQL Server Reporting Services added SharePoint Integration
Mode (64 bit platform)
• Development of Touch Screen applications with Windows Forms and Flash overlay.
Kiosks used in at partner locations ( IKEA San Diego, Honda Center, Del Mar Fair,
Miramar Air Show, and San Diego Chargers) 
• Managed Database Maintenance plans for corporate Disaster Recovery models(SQL
2000/2005/2008)
• Logging and Monitoring of SQL Server Databases on over 16 databases on over 5
SQL Server in a mixed SQL server environment (2000/2005/2008)
• Developed complex views, stored procedures, and functions within SQL Server
• Implemented SQL Server Replication (Transactional Mode) between 4 properties,
this feature increased our efficiency by separating our reporting environments
with our live ones.  
• Created SQL server security roles to handle security efficiently within our
organization.
• Developed portions on front end Web Site (www.welkownerslounge.com) and
www.welkvacations.com, created Web API’s for website interaction w/ Property
Management System (ASP.NET C# 3.5 and Classic ASP)


Mahaska Health Partnership    Jr Developer  June 2003 – April
2004
• Developed Intranet with ASP.NET 1.1.  Original deployment consisted of
employee directory, staff information, calendar events, and message board. 
Developed with SQL 2000 with managed code and stored procedures.
• Established shared drives with Active Directory security based on security
groups.
• Troubleshoot hardware problems with network cards, video cards, sound cards,
motherboards, modems. 
• Development of Crystal Reports (Nested, sub-reports and dashboards)
• Developed an Intranet with ASP.NET containing calendars, contacts and
searchable indexed datasets. 


Summer 2002 Intern Web Developer, Computer Geeks Oceanside, CA
• Developed ASP pages to monitor inventory and shipping requests.
• Created user guides and trained internal staff on released functions
• Performed QA and testing of development scripts, while creating SDLC
documents
• Assisted with development of in-house inventory management system.  Created
stored procedures and front end with ASP and SQL 2000

EDUCATION
Bachelor’s Degree from William Penn University  May 2004
•	Major : Computer Science
•	Minor : Data Management
TECHNICAL SKILLS

SQL Server 2000/ 2005/2008, Crystal Reports (Business Objects), SQL Server
Reporting Services, XML, XLST Visual Studio 2008, Stored Procedures,  Data
Migration, SQL Server Analysis, Triggers, T-SQL, DTS, Photoshop, ASP.NET, C#,
VB.NET, SQL,  AJAX, JavaScript, Visual Studio 2005, Active Directory, Network
Administration, VERITAS Backup, Microsoft SharePoint, MS-Office